Re: Reading resource busy error system trace

Systemstate doesn't give you the full "Call Stack Trace", you need errorstack:

alter system set events '54 trace name errorstack level 1';

Regards
Jonathan Lewis

On Mon, 4 Jul 2022 at 17:06, Pap <oracle.developer35_at_gmail.com> wrote:

> I searched with string 'Call Stack Trace' but didnt find any such in all
> the captured trace files generated with that ospid.
>
> I double checked with the team and found the level 266 trace was not
> getting generated somehow, so they did set it as level 258 as below.
> However wondering if this detail expanded 'call stack trace' is not
> captured just because it's been generated with level 258 as opposed to
> level 266.
>
> ALTER SYSTEM SET EVENTS '54 trace name systemstate level 258';
>
>
>
>
> On Mon, 4 Jul 2022, 7:52 pm Jonathan Lewis, <jlewisoracle_at_gmail.com>
> wrote:
>
>>
>> You didn't miss anything.
>>
>> I read your comments about *systemstate level 266*, but my fingers typed *errorstack
>> level 1* when I wasn't watching because that's a good first choice to
>> try when you see a session raising an error.
>>
>> This is an extract from my test dump (with a lot of lines near the start
>> of the call stack deleted):
>>
>>

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