RE: export hang
- From: "Karsten Weikop" <oraclel@xxxxxxxxxx>
- To: <oracledbam@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Nov 2004 20:05:21 +0100
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Seema Singh
Sent: Wednesday, November 24, 2004 7:44 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
