Re: Package Compile Hangs
From: Terry Dykstra <tdykstra_at_cfol.ab.ca>
Date: Thu, 22 Jul 1999 13:59:19 -0600
Message-ID: <379777e3.0_at_news.cadvision.com>
Date: Thu, 22 Jul 1999 13:59:19 -0600
Message-ID: <379777e3.0_at_news.cadvision.com>
Try flushing the SGA before you do the compile. It could be fragmented, causing the package body not to fit in one contiguous chunk.
-- Terry Dykstra Canadian Forest Oil Ltd. Walter Boggs wrote in message <7n7cfc$tqb$1_at_nnrp1.deja.com>...Received on Thu Jul 22 1999 - 21:59:19 CEST
>I'm trying to CREATE OR REPLACE a package on Oracle 7.1 via SQL*NT NT
>client. The declaration compiles fine, but when it gets to the body, the
>system hangs. There is no error, it just sits there.
>
>If I click CANCEL, SQL*PLUS stops responding and I have to kill it. This
>leaves an Oracle session sitting out there with something locked,
>preventing me from even recompiling the old package. I can't kill the
>session, I assume because it has an operation in progress. The only way
>to get out of it is to bounce Oracle.
>
>Does anyone have a clue what's going on? Thanks.
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.