I like the way you found the root cause. If I may paraphrase, you asked the database how it was spending its time, and the answer guided the remainder of your performance improvement project. I contrast this method with the traditional approach, which is to try to guess at a root cause from the domain of literally thousands of possible root causes.
Cary Millsap -----Original Message-----
i might add my 2c, even though the problem has been resolved. :-) once upon a time, we had a 2g database that was taking a looooooong time to import. anyone ever heard of remedy? did everything that has already been mentioned. tracing revealed log file sync waits ... and lots of em' ... (and a few other log type waits ...) we had long datatypes ... we were frustrated ... it's only 2 bloody gig after all ... got rid
of the 2nd member of each log group --> byebye log file parallel write waits
... this was done in test a number of times before we did it on production. but we did put the logs on /tmp in prod. after the import we very quickly moved them off. :-) the real issue was a poor io subsystem, but oracle's handling of longs during import did not help. never followed up on the internals of it. a document on metalink purporting to shed light on issues w/importing longs was ... "not available to me" (or something like that). the moral here is, in _certain_ situations, odd little tricks like that can save the day. it ain't for everyone, but in our particular case, logs in memory allowed us to complete a nasty little rebuild (can you say 150000 extents ...) for a very poorly configured db w/in the allocated time window. cheers, casey ... -----Original
Message-----
Oracle 8.1.7 on Solaris 8 I am
testing and upgrade from 7.3.4 to 8.1.7. Because the test server is
I have
tried: In
looking at how long it takes, the table imports in a second or less, but
Does
anyone have any ideas how I can speed this up? 10 hours to import a
TIA. Terry Terry
Ball, DBA -- Fat City
Network Services -- (858) 538-5051 FAX: (858) 538-5051
|
Title: RE: IMPORT sloooowwww
- Re: IMPORT sloooowwww Ron Rogers
- RE: IMPORT sloooowwww Khedr, Waleed
- RE: IMPORT sloooowwww Khedr, Waleed
- RE: IMPORT sloooowwww Magaliff, Bill
- RE: IMPORT sloooowwww Bernard, Gilbert
- RE: IMPORT sloooowwww Johnson, Michael
- RE: IMPORT sloooowwww Connor McDonald
- RE: IMPORT sloooowwww Ball, Terry
- Re: IMPORT sloooowwww Nuno Souto
- RE: IMPORT sloooowwww Casey Dyke
- Re: IMPORT sloooowwww Cary Millsap
- Re: IMPORT sloooowwww Nuno Souto