Re: gc current request p3 value
Date: Wed, 17 Mar 2021 07:50:46 +0200
Message-ID: <CA+riqSUWNiiV+fQneOffaUYejxLsf6xWUOszLVy1b+iXJNN7Vw_at_mail.gmail.com>
Hello,
I see someone blogged Tanel`s answer on this: https://dioncho.wordpress.com/2009/02/23/parameter3-of-gc-buffer-busygc-current-request-wait-event/
You can use conversion api script provided by Tim: https://oracle-base.com/dba/script?category=miscellaneous&file=conversion_api.sql
Out of experience a lot of gc current request hangs/long waits were caused by bugs, I suggest you to also cross check the list of bugs for your DB version.
În mar., 16 mar. 2021 la 21:21, Moustafa Ahmed <moustafa_dba_at_hotmail.com> a scris:
> Hello listers
>
> With event *gc current request*
> P1 and P2 are quite straight forward
> File#
> Block#
>
> But for P3 what does id# mean and refer to?
> Also looks like hex/dec conversion needed
> How do we do that?
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 17 2021 - 06:50:46 CET