Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Slow Export

RE: Slow Export

From: Luis Fernando Cerri <lcerri_at_santanderbanespa.com.br>
Date: Wed, 1 Feb 2006 14:02:34 -0300
Message-ID: <A70750EC2FDE6A4C98FCA68CC6AC283302DB3381@bsbrsp42.bs.br.bsch> 





Just a doubt that came to my mind: why was the export to /dev/null taking
hours to finish?



Smith, are the datafiles of the exported database on the same disks where
the SQL*Net trace files being written?



Regards,


Luis - no, it's not Friday :-(
 




-----Original Message-----



From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Smith, Ron


Sent: quarta-feira, 1 de fevereiro de 2006 11:44
To: Mark.Bobak_at_il.proquest.com; M Rafiq; tanel.poder.003_at_mail.ee;
oracle-l_at_freelists.org


Subject: RE: Slow Export




It was the trace in the SQLNET.ORA.  The trace file had gotten to be over
2G.


I remove the commands.  Turned off the trace.  The exports ran in 40 minutes
instead of 9 hours!



Thanks for your help!



Ron



-----Original Message-----



From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Bobak, Mark


Sent: Tuesday, January 31, 2006 3:59 PM


To: Smith, Ron; M Rafiq; tanel.poder.003_at_mail.ee; oracle-l_at_freelists.org
Subject: RE: Slow Export




Interesting.  SQL*Net trace level 16 dumps a LOT of stuff to disk.



It's possible that the combination of the SQL*Net trace writes and the exp
writes are killing your I/O.  When the export runs remotely, the SQL*Net
trace writes still happen, but the export writes are on another host.....



It's worth commenting that stuff out of youe sqlnet.ora.  Also, if this is
at all a busy database, you may want to clean out
/oracle_rdbms/app/oracle/product/8.1.7/network/trace which probably has lots
of useless *.trc files in it.



I'd comment those lines from sqlnet.ora and try re-running the exp.



-Mark





--



Mark J. Bobak


Senior Oracle Architect


ProQuest Information & Learning



"There are 10 types of people in the world:  Those who understand binary,
and those who don't."



-----Original Message-----



From: Smith, Ron [mailto:rlsmith_at_kmg.com] 
Sent: Tuesday, January 31, 2006 4:55 PM


To: M Rafiq; Bobak, Mark; tanel.poder.003_at_mail.ee; oracle-l_at_freelists.org
Subject: RE: Slow Export



Found this in the SQLNET.ORA file.  Added to try to diagnose another
problem. About the time the exports started running slow.


TRACE_LEVEL_CLIENT=16
TRACE_DIRECTORY_CLIENT=/oracle_rdbms/app/oracle/product/8.1.7/network/trace
TRACE_TIMESTAMP_CLIENT = ON 





TNSPING works well.



Ron






-----Original Message-----



From: M Rafiq [mailto:rafiq9857_at_hotmail.com]
Sent: Tuesday, January 31, 2006 3:43 PM


To: Smith, Ron; Mark.Bobak_at_il.proquest.com; tanel.poder.003_at_mail.ee;
oracle-l_at_freelists.org


Subject: RE: Slow Export




Ron,


Is there any recent change to your local  tnsnames.ora file. May be any 
bracket is missing or format error. How about your tnsping to that database 
work from local server?



Regards


Rafiq






From: "Smith, Ron" <rlsmith_at_kmg.com>


Reply-To: rlsmith_at_kmg.com


To: "Bobak, Mark" <Mark.Bobak_at_il.proquest.com>,<tanel.poder.003_at_mail.ee>, 
"ORACLE-L" <oracle-l_at_freelists.org>


Subject: RE: Slow Export


Date: Tue, 31 Jan 2006 15:26:19 -0600



No, I found I can run truss.  Just don't know how since we usually can't run



those type utilities.


The only waits are SQL*NET waits, to and from the client.  About 350 but no 
time associated with the wait.


The export is local.  If done remotely the export runs much faster, back to 
normal times.



Thanks!


Ron


	-----Original Message-----
	From: Bobak, Mark [mailto:Mark.Bobak_at_il.proquest.com]
	Sent: Tuesday, January 31, 2006 3:15 PM
	To: Smith, Ron; tanel.poder.003_at_mail.ee; ORACLE-L
	Subject: RE: Slow Export


	Hmm....so, they explicitly deperm access to the truss binary?  On


most Sun 


servers, it's in /usr/bin, and you should not need root permission to truss 
an oracle owned process.  If you can login as the user who started the 
database (presumably oracle), that should be good enough to do the trace.  
Unless they really do explicitly deperm the binary.  If that's true, I'd 
argue that's a battle you need to fight, in order to do you job well, you 
need access to O/S level tools like truss.  (I know, I know, easier said 
than done....;-))



        As for the V$SESSION_WAIT output, what do you mean by "looks low"?
Are you 


seeing waits?  What are they?



        Also, regarding Tanel's last question, are you exporting locally, or
over 


the network?



        -Mark



	--
	Mark J. Bobak
	Senior Oracle Architect
	ProQuest Information & Learning

	"There are 10 types of people in the world:  Those who understand


binary, 


and those who don't."








        From: oracle-l-bounce_at_freelists.org


[mailto:oracle-l-bounce_at_freelists.org] 


On Behalf Of Smith, Ron

	Sent: Tuesday, January 31, 2006 3:55 PM
	To: tanel.poder.003_at_mail.ee; ORACLE-L
	Subject: RE: Slow Export


	I had to restart the export.  Ran 8.5 hours this time.
	V$Session_Wait looks low right now.
	I have never used the Truss command.  Unix admins don't give us


access.


		-----Original Message-----
		From: oracle-l-bounce_at_freelists.org




[mailto:oracle-l-bounce_at_freelists.org] 


On Behalf Of Tanel Põder

		Sent: Tuesday, January 31, 2006 2:45 PM
		To: ORACLE-L
		Subject: Re: Slow Export


		Are you exporting over network or locally in the server?

		V$SESSION_EVENT, V$SESSION_WAIT and truss -c should


sufficient to reveal 


the cause..



                Tanel.







                        There are several exports in different databases,
exporting various size 


objects.  The thing is, this started about the middle of December.


                        Before that, everything was fine.



                        Ron



	Important Notice!
	If you are not the intended recipient of this e-mail message, any


use, 


distribution or copying of the message is prohibited.


        Please let me know immediately by return e-mail if you have received
this 


message by mistake,

	then delete the e-mail message.
	Thank you.





--



http://www.freelists.org/webpage/oracle-l





--



http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 01 2006 - 11:02:34 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US