RE: Slow Export

Sorry, I see that. I was responding to the comment that the problem didn't exist till mid-December.  

Have you tried looking at V$SESSION_WAIT? truss -c?  

My point remains that you need to identify the bottleneck before you can solve the problem.  

Hope that helps,  

-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: Smith, Ron [mailto:rlsmith_at_kmg.com] 
Sent: Tuesday, January 31, 2006 3:44 PM
To: Bobak, Mark; tanel.poder.003_at_mail.ee; ORACLE-L
Subject: RE: Slow Export


His question was "Are you exporting lots of small objects or few large objects?".  I was answering the question.

	-----Original Message-----
	From: Bobak, Mark [mailto:Mark.Bobak_at_il.proquest.com] 
	Sent: Tuesday, January 31, 2006 2:39 PM
	To: Smith, Ron; tanel.poder.003_at_mail.ee; ORACLE-L
	Subject: RE: Slow Export
	
	
	Understood Ron.  The point that Tanel and I are trying to make is, if the process is slow, there is a bottleneck somewhere.  You can use Oracle features and O/S tools to determine where it is.  Once you've done that, you're one step closer to solving the problem.  Until you understand the behavior, you're nowhere.
	 

	-- 
	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:36 PM
	To: tanel.poder.003_at_mail.ee; ORACLE-L
	Subject: RE: Slow Export
	
	
	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

		-----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:26 PM
		To: ORACLE-L
		Subject: Re: Slow Export
		
		
		And when you should see from v$session_event and v$session_wait that database itself is not the bottleneck, you could run truss -c on the exp process for a while and see the breakdown whether any system calls (like write()) take lots of time.
		 
		Are you exporting lots of small objects or few large objects?
		 
		Tanel.
		 

			----- Original Message ----- 
			From: Bobak, Mark <mailto:Mark.Bobak_at_il.proquest.com>  
			To: rlsmith_at_kmg.com ; oracle-l_at_freelists.org ; oracle-db-l_at_Groups.ITtoolbox.com ; oracle-rdbms_at_yahoogroups.com 
			Sent: Tuesday, January 31, 2006 2:07 PM
			Subject: RE: Slow Export

			What does V$SESSION_WAIT tell you about the session executing the export?
			 

			-- 
			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." 

			 



	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. 


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