Home » RDBMS Server » Server Utilities » EXPORT taking more time (10g R1,RHEL3)
EXPORT taking more time [message #434894] Fri, 11 December 2009 10:09 Go to next message
anwar786
Messages: 25
Registered: May 2009
Location: bangalore
Junior Member
Hi guyz

In our client place the export of one of the database is taking
30hrs to make 1.6gb dump.

there are 210 schemas having 800 tables each of the same structure for serving 210 cities. Most of the tables in these schemas have 0 rows. Exporting 0 row table even takes 5-7 sec each, and with tables with rows take even more time. Hence consuming 30hrs aporox. The total DB size is 27gb. and used space is 15.6gb.
I am giving buffer of 1.3gb still no improvements. its a real trouble for our daily activity.

Also what all background process, memory in SGA does exp utility consumes when it is started. ples let me know.

please anyone tell a solution.
Re: EXPORT taking more time [message #434895 is a reply to message #434894] Fri, 11 December 2009 10:18 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.orafaq.com/wiki/Import_Export_FAQ#How_can_one_improve_Import.2F_Export_performance.3F
Re: EXPORT taking more time [message #434896 is a reply to message #434894] Fri, 11 December 2009 10:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I am giving buffer of 1.3gb

Have you enough free RAM to not generate swap with this size?

Regards
Michel
Re: EXPORT taking more time [message #434907 is a reply to message #434896] Fri, 11 December 2009 10:54 Go to previous messageGo to next message
anwar786
Messages: 25
Registered: May 2009
Location: bangalore
Junior Member
actually we scheduled it on sunday morning 5 a.m to run this export. In sunday there are no activity going on and the ram is 10gb. But my other question is does exp take any SGA MEMORY FOR running such as shared_pool or large pool etc and any background process as well.
Re: EXPORT taking more time [message #434909 is a reply to message #434896] Fri, 11 December 2009 11:00 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Have you tried Mr Mahesh link?

>>But my other question is does exp take any SGA MEMORY FOR running such as shared_pool or large pool etc and any background process as well

What is your SGA_MAX_SIZE & SGA_TARGET Size?

Is there any other process running long? Is there any other CPU High Utilization?

- Babu

Re: EXPORT taking more time [message #434912 is a reply to message #434909] Fri, 11 December 2009 11:08 Go to previous message
anwar786
Messages: 25
Registered: May 2009
Location: bangalore
Junior Member
SGA_target=1.07 gb
sga_max_size=1.07gb

pga_aggregate=366m

REGARDING OTHER BACKGROUND PROCESS AM NOT SURE BUT USERS DO NOT CONNECT ON SUNDAY AND WE HAVE ONLY SCHEDULED THIS DATABASE EXP REST OTHER DATABSSES EXP ARE SCHEDULED ON OTHER DAYS KEEPING THIS PROBLEM IN MIND ONLY WE SCHEDULED LIKE THIS BUT STILL ITS NOT HELPING.

WILL INCREASE IN SGA_TARGET HELP?

Previous Topic: How to handle Dynamic Filename with a single control file
Next Topic: How commit happens in SQL Loader
Goto Forum:
  


Current Time: Wed Dec 07 06:56:36 CST 2016

Total time taken to generate the page: 0.11668 seconds