RE: export hang

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Wed, 24 Nov 2004 13:51:14 -0500
Message-ID: <AA29A27627F842409E1D18FB19CDCF275A9C0D@AABO-EXCHANGE02.bos.il.pqe>

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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Seema Singh
> Sent: Wednesday, November 24, 2004 1:44 PM
> To: oracle-l_at_freelists.org
> 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

> --
> http://www.freelists.org/webpage/oracle-l
>=20

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

Received on Wed Nov 24 2004 - 12:48:29 CST