F43199 Full Table Scans

[RAMMEDJR]

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

 

[DSauve]

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
*************************************************************

 

[wsellers]

If you don't want the history files to be updated by a description or item
number change in P4101 you can selectively turn this off in UDC 40/IC.
Delete the "y" in the "Description 02" field of the history file F43199.



Walter Daniel Sellers

 

[RAMMEDJR]

Excellent that was it, actually the zjde0001 version of P4101 is set for
global update processing. Amazing that in less than an hour I can get a
solution for something JDE has been working on for over a week.

Thanks again Don and to everyone else that participates in the list group
for your suggestions and solutions.

Dave Rammer
Sheboygan County IS

 

[epost]

You can activate database AUDITING and audit the statements ran against the
F43199 which will tell you all sorts of information. If it is a server
process then you know it is most likely a job executing the SQL causing the
full table scan. If it has a user id then either the user issued the
statement via an inquiry from a screen or the user ran the job from thier
local workstation. You can always consider adding an index to the table
once you trap the statement if it is really effecting performance, of course
as the table grows this will be a bigger factor.

-Ethan Post - Oracle DBA - www.freeocp.com

 

[adri_valentim]

Also check that the F42199, and F4111 also is removed from UDC 40/IC. You
will got a big performance improvement.



Valmatrix Consulting Inc.