OraFAQ Forum: Server Utilities » How to Monitor Export

Home » RDBMS Server » Server Utilities » How to Monitor Export

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Monitor Export [message #209631]

Sat, 16 December 2006 01:01

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

Report message to a moderator

Re: How to Monitor Export [message #209642 is a reply to message #209631]

Sat, 16 December 2006 04:51

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Re: How to Monitor Export [message #209699 is a reply to message #209631]

Sun, 17 December 2006 03:13

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

Report message to a moderator

Re: How to Monitor Export [message #209702 is a reply to message #209699]

Sun, 17 December 2006 04:08

Mahesh Rajendran
Messages: 10708
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?

Report message to a moderator

Previous Topic:	export
Next Topic:	ORA - 12203 TNS Unable To Connect Destination

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 21:41:51 CST 2024