Re: gc current request p3 value

  • From: Laurentiu Oprea <laurentiu.oprea06@xxxxxxxxx>
  • To: moustafa_dba@xxxxxxxxxxx
  • Date: Wed, 17 Mar 2021 07:50:46 +0200

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@xxxxxxxxxxx> 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?

Other related posts: