Dave,
We had this exact same problem several months ago, but we also had
excessive scans of the F42199 table. We finally found that we had one user
that was running a version of Item Master (P4101) (from a row exit off of
Item Branch) which had the "Global Update" processing option set to a '2'.
By setting this to a '2', every time an item is changed, the program will
go out an do a global update on all tables that are specified in the UDC
table 40/IC.
I'd suggest you either secure down P4101 so that your users can't prompt
for versions/values, and/or change all your P4101 versions so that the
"Global Update" processing option is set to some other value -- ours is
'1'.
Hope this helps!
Don Sauve
Wagstaff, Inc.
e-mail:
[email protected]
OW B733.1 SP11.3 (XE in the works), HP-UX v11.0, Oracle 8.1.6
RAMMEDJR
<
[email protected] To:
[email protected]
gan.wi.us> cc:
Sent by: Subject: F43199 Full Table Scans ~~0:4870
owner-jdelistml@jde
list.com
01/31/2001 11:28 AM
Please respond to
jdelist
During the past two weeks monitoring the Oracle database I have noticed
that
some application is doing periodic full table scans of the F43199. Is
there
someway I can tell which app is causing this.
Thanks.
Dave Rammer
Sheboygan County IS
OW B7331 SP11.2 / HP-UX11.0 / Oracle 8.0.6
--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=4870
*************************************************************
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at
http://www.JDELIST.com
*************************************************************