Re: Is it possible to trace what locks my session obtains?

From: Stefan Koehler <contact_at_soocs.de>
Date: Fri, 15 Jul 2016 10:09:31 +0200 (CEST)
Message-ID: <447876055.19855.1468570171745.JavaMail.open-xchange_at_app10.ox.hosteurope.de>


Hi Michael,
for sure - you are looking for event "10704".

----------------8<----------------------
shell> oerr ora 10704
10704, 00000, "Print out information about what enqueues are being obtained"
// *Cause: When enabled, prints out arguments to calls to ksqcmi and 
//         ksqlrl and the return values.
// *Action: Level indicates details:
//
// Level: 1-4: print out basic info for ksqlrl, ksqcmi
//        5-9: also print out stuff in callbacks: ksqlac, ksqlop 
//        10+: also print out time for each line

SQL> alter session set events=10704 trace name context forever, level 3';

----------------8<----------------------

Best Regards
Stefan Koehler

Freelance Oracle performance consultant and researcher Homepage: http://www.soocs.de
Twitter: _at_OracleSK  

> Michael Cunningham <napacunningham_at_gmail.com> hat am 14. Juli 2016 um 22:43 geschrieben:
>
> I'm curious if there is a way to know what locks my session gets while running various activities such as (creating table, creating index,
> modifying table, etc.).
>
> Or, if there is some docs I can't find that show locking level for different statements and DDL that would be great too.
>
> Thanks,
>
> --
> Michael Cunningham

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jul 15 2016 - 10:09:31 CEST

Original text of this message