| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> x$ tables info
Where can I get detailed info about x$ tables?
Regards,
Bhat
-----Original Message-----
From: Steve Adams [mailto:steve.adams_at_ixora.com.au]
Sent: Tuesday, August 01, 2000 4:44 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Question on x$kcbfwait
Hi Stephane,
It shows buffer busy waits on buffers containing blocks from those
datafiles.
Make sure that your script offsets the file number by one when doing the
join to V$DATAFILE.
Have a look at my buffer_busy_waits.sql script for an example.
Also, for buffer busy waits against rollback segment header blocks,
my enough_rollback_segments.sql script makes a helpful distinction
between read waits and write waits
that might help you to work out what's going on there.
You may want to post the output of both scripts back to the list?
Regards,
Steve Adams
http://www.ixora.com.au/ http://www.oreilly.com/catalog/orinternals/ http://www.christianity.net.au/
-----Original Message-----
stephane
Sent: Tuesday, 1 August 2000 4:00
To: Multiple recipients of list ORACLE-L
Hi,
I'm trying to understand x$kcbfwait.
I can't find a reference of this table in any V$
views.
I have a script that linked x$kcbfwait to v$datafile. It seems to show waits on datafiles but I do not quite understand what's going on. The datafiles having the more waits are the ones containing the rollback segments.
-- Author: =?iso-8859-1?q?paquette=20stephane?= INET: stephane_paquette_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Mon Jul 31 2000 - 22:03:02 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Author: Steve Adams INET: steve.adams_at_ixora.com.au Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
 |
 |