Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: To patch 'n pray or to keep looking for the root cause: tha t is the question
Hi Tom, long long ago, I tried and gave up on direct exports (can't
remember any more exactly why, but there were odd problems with it).
These servers of mine are smallish/crappish boxes with two ATA or SATA drives, therefore network traffic plays no role. Differences in time taken between "fast" and "not-so-fast" exports go to up to six times, and although I am in no hurry (nights here are long enough, especially during the winter), looking at oddity I can't explain kinda nags me.
Got off-list suggestion to try 9.2.0.4 patch or higher, so I believe I'll go for it on one trial system. Will also have a peak at v$session_event as Allan kindly suggested.
Branimir
-----Original Message-----
From: Mercadante, Thomas F (LABOR)
Branimir,
Have you tried direct exports and logged any differences? Obviously this problem is either server based or Oracle based.
Direct exports would skip the SGA - thus eliminating any busy buffer problems.
And also look for other events happening on the server. Are your disk mounted locally, or on a SAN? This could be another cause for delay - network problems interfering with SAN writes.
Tom
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 02 2005 - 13:59:41 CDT
![]() |
![]() |