| From: | Steve Adams |
| Date: | 07-Mar-2001 23:47 |
| Subject: | What is a fib? |
|
|
I think that fib probably means "file information block". The P1 value for file open waits is a pointer into the "KGFF heap" which is a subheap of the shared pool. Each fib has its own extent in the KGFF heap. The subheap extent number seems to correspond to the file number, but I cannot guarantee that that will always be true. You can map a decimal address (such as P1 in this case) to the containing shared pool chunk using containing_chunk.sql. That script is dependent on the rawtonum function which is declared in rawtonum.sql. In this case you'll need to hack containing_chunk.sql to return the KSMCHPAR column (the address of the heap descriptor for the KGFF heap) and join that to X$KSMHP with an explicit USE_NL hint to find the extent number for the chunk.
|
![]() |
The P1 field in V$SESSION_WAIT for the event file open is fib. I'd like to associate this with a filename. Any ideas on how to do this? It's not V$DATAFILE.FILE#, I know that much.
|