Oracle-L: RE: Oracle Performance Tuning steps

From: <Long.Nguyen_at_csiro.au>
Date: Mon, 01 Jul 2002 01:33:20 -0800
Message-ID: <F001.0048C897.20020701013320@fatcity.com>

Gavin,

You need to monitor who is locking the object. v$locked_object could be queried for this info.

Long

-----Original Message-----
Sent: Monday, 1 July 2002 6:03 PM
To: Multiple recipients of list ORACLE-L

Hi,

        I'm working on a pidley sized db ( about 100mb) but sometimes when I try compiling a decent sized package i get a time out error saying the object is locked, while at other times the package compiles on the fly. 
        I'm trying to figure out why i get this error randomly. Some suggestions maybe that the compiler is going into a loop in my code which i seriously doubt. Is there any way I can find out what is causing the compile to hang up ....

yes i know it says the object is locked but when no one is using the db ( that's when I update) why should the object (i.e. my package) lock ? any help would be really appreciated,

thank you,

Gavin

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Long.Nguyen_at_csiro.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jul 01 2002 - 04:33:20 CDT