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>
10704, 00000, "Print out information about what enqueues are being obtained"
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-lReceived on Fri Jul 15 2016 - 10:09:31 CEST