Home » RDBMS Server » Server Utilities » How to Monitor Export
How to Monitor Export [message #209631] Sat, 16 December 2006 01:01 Go to next message
neerjblr
Messages: 3
Registered: March 2006
Location: India
Junior Member

Guys

We do export-import regularly and sometime when we get too many rows in a table(eg: 297965538) export hangs for some time. Internaly it is running since i can see that the export dump size is increasing but would appreaciate if any one can provide some script to know "how many rows" so far has been "exported" and from which table.

Thanks
Neeraj
Re: How to Monitor Export [message #209642 is a reply to message #209631] Sat, 16 December 2006 04:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please search before posting. Most the questins asked are already answered in one form or other.
Please see whether this helps.
http://www.orafaq.com/forum/m/126015/42800/?srch=monitor+import#msg_125898
Re: How to Monitor Export [message #209699 is a reply to message #209631] Sun, 17 December 2006 03:13 Go to previous messageGo to next message
neerjblr
Messages: 3
Registered: March 2006
Location: India
Junior Member

Hi,

Thanks for the link.
But the question asked there was not answered.

Questions is , is there any query which displays us that this is the table and this many rows are currently being exported by export utility as import does.

Reason to monitor is very simple.
I start export in vnc session and if the table being exported is having 2000000 rows than in the session it will be hang until that table is being exported and export logfile will never get updated, at the same time size of the export dump is increasing but this is not the technical answer(size of the dump file).

If there is no query to watch the things going when export is running than will i get some workaround other than the Tom has given.

Thanks
Neeraj
Re: How to Monitor Export [message #209702 is a reply to message #209699] Sun, 17 December 2006 04:08 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>But the question asked there was not answered.
Did you read the FULL posting?
>> Questions is , is there any query which displays us that this is the table and this many rows are currently being exported by export utility as import does.
Feedback = N does that.
If you want to issue a 'query' against the database to check the same, there is NO SUCH FACILITY.
You are exporting (logically extracting) records out of oracle. Why do you expect Oracle to record that information?
Previous Topic: export
Next Topic: ORA - 12203 TNS Unable To Connect Destination
Goto Forum:
  


Current Time: Thu Dec 08 08:33:02 CST 2016

Total time taken to generate the page: 0.27153 seconds