RE: export hang
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <oracledbam@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Nov 2004 13:51:14 -0500
First:
Oracle version?
O/S?
O/S version?
Second:
While export is running, connect via SQL*Plus.
Identify the session that's running export.
Look at V$SESSION_WAIT for that session.
What does it tell you?
Hope that helps,
-Mark
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Seema Singh
> Sent: Wednesday, November 24, 2004 1:44 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: export hang
>=20
>=20
> Hi,
> Export is hanging.When I'm running export either in=20
> background/foreground=20
> mode it's hanging at
> . exporting foreign function library names
> . exporting object type definitions
>=20
> When I was running one sql on dba_indexes dictionary view.The=20
> query from=20
> this views are hanging?
> No eveidence of any error on alert logs.
> any thought???
> System is having less memory free(50mb).
> thanks
>=20
>=20
> --
> //www.freelists.org/webpage/oracle-l
>=20
--
//www.freelists.org/webpage/oracle-l
Other related posts:
