RE: Performance issues with Z-File
Tim,
2.5 hours is way too long if you are talking about using the Oracle import
utility to import data. I can tell you that contention is occuring
somewhere regardless of the method being used. There are quite a few things
one would have to look at to determine where the contention is taking place
(CPU, DISK, Log Writer, SGA too big, DBWR, the lists goes on and on). The
best place to start to look is in the V$SYSTEM_EVENT table. It will report
a top level view of the wait events occuring in the database. You can also
use statpack to take some performance before and after the job. I suggest
15 minute intervals. If you are using a JDE application to perform the
import it is possible there is contention at the object level. Ultimatley
this is why there are DBA's, because it is a specialized set of skills and
it is even occasionaly a full time job. Most JDE installs make the CNC or
one of the application folks the defacto DBA and ultimatley they run into
problems. If you want to learn more about tuning via the Oracle wait
interface I suggest Gaja Vaidyanatha's book Oracle Tuning 101, very
comphrehensive and not too expensive.
http://www.bookpool.com/.x/rakpzym6o4/ss/1?qs=oracle+tuning+101&Go.x=17&Go.y
=10
Regarding OORPG's comment that you upgrade to a real database...I have over
1200 messages in my inbox from this list, I searched for comments by OORPG
and his only response was "Use a real database rather than Oracle.". I
think based on this you can rest assured you have a "real" database and
those comments can be disregarded.
Thanks,
Ethan Post