Hi Jason

My guess (remember - only a guess) is that it is a referential table for
x$kcbwait - (kernel cache [hence kc], buffer wait) and x$kcbfwait (kernel
cache, block file wait) - the KCBWHDES is description:

SQL> desc x$kcbwait
Name Null? Type
------------- -------- --------------
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
COUNT NUMBER
TIME NUMBER

SQL> desc x$kcbfwait
Name Null? Type
------------- -------- --------------
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
COUNT NUMBER
TIME NUMBER

SQL> desc X$kcbwh
Name Null? Type
------------- -------- --------------
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
KCBWHDES VARCHAR2(64)

SQL> select * from x$kcbwait where rownum < 3;

ADDR INDX INST_ID COUNT TIME
-------- ---------- ---------- ---------- ----------
3432BC0C 0 1 0 0
3432BC14 1 1 20297 5285

SQL> select * from x$kcbfwait where rownum < 3;

ADDR INDX INST_ID COUNT TIME
-------- ---------- ---------- ---------- ----------
3432BC84 0 1 18120 3642
3432BC8C 1 1 5729 1094

SQL> select * from x$kcbwh where INDX in (0,1);

ADDR INDX INST_ID KCBWHDES
-------- ---------- ---------- ---------------------
20023AB8 0 1 unknown
20023ABC 1 1 kcbzwh0: kcbzfp

SQL>

Although address is different so I might be wrong as well. Steve Adams, Tom
Kyte or Enjo Kolk are people to ask.

Kind regards

Kresimir Fabijanic

-----Original Message-----
From: Jason Ru [mailto:[Email Address Removed]
Sent: Friday, 17 October 2003 9:56 AM
To: LazyDBA.com Discussion
Subject: X$kcbwh


Hi Oracle Guru,

Have you seen the table X$kcbwh? Please tell me
that it is and desc it?

Thanks


Jason Ru


__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] This e-mail and any attachments are confidential
and may be subject to legal or some other professional
privilege. They are intended solely for the attention and
use of the named addressee(s). They must not be disclosed
to any person without authorisation.

This e-mail and any attachments are also subject to
copyright. They may only be copied or distributed with
the consent of the copyright owner. If you are not
named addressee you must not use, disclose, retain or
reproduce all or any part of the information contained
in this e-mail or any attachments.
MS Sql Server LazyDBA home page