RE: export hang

Hi

A simple way is to enable 10046 trace, level 8 for the session in question.

Then you can see in the trace file what the session is doing/waiting for.

/karsten

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Seema Singh Sent: Wednesday, November 24, 2004 7:44 PM To: oracle-l_at_freelists.org
Subject: export hang

Hi,
Export is hanging.When I'm running export either in background/foreground
mode it's hanging at
. exporting foreign function library names
. exporting object type definitions

When I was running one sql on dba_indexes dictionary view.The query from

this views are hanging?
No eveidence of any error on alert logs. any thought???
System is having less memory free(50mb). thanks

--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l