| EXPORT taking more time [message #434894] |
Fri, 11 December 2009 10:09  |
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 #434907 is a reply to message #434896] |
Fri, 11 December 2009 10:54  |
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 #434912 is a reply to message #434909] |
Fri, 11 December 2009 11:08 |
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
