Oracle X$ Structures
Version 11.2.0.3
 
General Information
Note: This page is a work in progress. As I find demos and descriptions of X$ structures this page will continue to be enhanced. If you have any information that might further expand these contents please forward them to me. Thank you. Morgan
List X$ Arrays and related information desc v$fixed_table

desc v$fixed_view_definition

desc v$indexed_fixed_column

SELECT kqftanam
FROM x$kqfta
ORDER BY 1;

SELECT t.kqftanam "Table Name"
FROM x$kqfta t, x$kqfco c
WHERE t.indx = c.kqfcotab
AND c.kqfconam like '%SID%'
INTERSECT
SELECT DISTINCT t.kqftanam "Table Name"
FROM x$kqfta t, x$kqfco c
WHERE t.indx = c.kqfcotab
AND c.kqfconam like '%NAM%';
Morgan's brute-force code for collecting the names of X$ objects. It ain't pretty but it gets the job done.

Adding additional loops allows for brute force construction of arbitrarily sized X$ objects.		 CREATE TABLE xdollar (
file_name VARCHAR2(30),
numrows   NUMBER);

CREATE OR REPLACE PROCEDURE xdollarproc IS
 rindex  BINARY_INTEGER;
 slno    BINARY_INTEGER;
 sofar   NUMBER(6,2);
 twork   NUMBER;

 pfix CONSTANT VARCHAR2(23) := 'SELECT COUNT(*) FROM X$';
 str1 VARCHAR2(128);
 str2 VARCHAR2(128);
 str3 VARCHAR2(128);
 str4 VARCHAR2(128);
 str5 VARCHAR2(128);
 xstr VARCHAR2(128);
 n xdollar.numrows%TYPE;
BEGIN
  rindex := dbms_application_info.set_session_longops_nohint;
/*
  -- one
  twork := ((95-65)+1)**1;
  FOR a IN 65 .. 95 LOOP
    sofar := (a-65);
    dbms_application_info.set_session_longops(rindex,slno,'1',0,0,sofar,twork,'');

    str1 := pfix || CHR(a);
    BEGIN
      xstr := str1;
      EXECUTE IMMEDIATE xstr INTO n;
      INSERT INTO xdollar (file_name,numrows) VALUES ('X$' || CHR(a),n);
    EXCEPTION
      WHEN others THEN
    NULL;
    END;
  END LOOP;
  COMMIT;

  -- two
  twork := ((95-65)+1)**2;
  FOR a IN 65 .. 95 LOOP
    str1 := pfix || CHR(a);
    FOR b IN 65 .. 95 LOOP
      sofar := (a-65)*(b-65);
      dbms_application_info.set_session_longops(rindex,slno,'2',0,0,sofar,twork,'');

      str2 := str1 || CHR(b);
      BEGIN
        xstr := str2;
        EXECUTE IMMEDIATE xstr INTO n;
        INSERT INTO xdollar (file_name, numrows) VALUES ('X$' || CHR(a) || CHR(b),n);
      EXCEPTION
        WHEN others THEN
          NULL;
      END;
    END LOOP;
  END LOOP;
  COMMIT;

  -- three
  twork := ((95-65)+1)**3
  FOR a IN 65 .. 95 LOOP
    str1 := pfix || CHR(a);
    FOR b IN 65 .. 95 LOOP
      str2 := str1 || CHR(b);
      FOR c IN 65 .. 95 LOOP
        sofar := (a-65)*(b-65)*(c-65);
        dbms_application_info.set_session_longops(rindex,slno,'3',0,0,sofar,twork,'');

        str3 := str2 || CHR(c);
        BEGIN
          xstr := str3;
          EXECUTE IMMEDIATE xstr INTO n;
          INSERT INTO xdollar (file_name,numrows) VALUES ('X$'||CHR(a)||CHR(b)||CHR(c),n);
        EXCEPTION
          WHEN others THEN
            NULL;
        END;
      END LOOP;
    END LOOP;
  END LOOP;
  COMMIT;

  -- four
  totwork := ((95-65)+1)**4
  FOR a IN 65 .. 95 LOOP
    str1 := pfix || CHR(a);
    FOR b IN 65 .. 95 LOOP
      str2 := str1 || CHR(b);
      FOR c IN 65 .. 95 LOOP
        str3 := str2 || CHR(c);
        FOR d IN 65 .. 95 LOOP
          sofar := (a-65)*(b-65)*(c-65)*(d-65);
         dbms_application_info.set_session_longops(rindex,slno,'4',0,0,sofar,twork,'');

          str4 := str3 || CHR(d);
          BEGIN
            xstr := str4;
            EXECUTE IMMEDIATE xstr INTO n;
            INSERT INTO xdollar (file_name,numrows) VALUES ('X$' || CHR(a) || CHR(b) || CHR(c) || CHR(d),n);
          EXCEPTION
            WHEN others THEN
              NULL;
          END;
        END LOOP;
      END LOOP;
    END LOOP;
  END LOOP;
  COMMIT;
*/
  -- five
  FOR a IN 65 .. 95 LOOP
    str1 := pfix || CHR(a);
    FOR b IN 65 .. 95 LOOP
      str2 := str1 || CHR(b);
      FOR c IN 65 .. 95 LOOP
        str3 := str2 || CHR(c);
        FOR d IN 65 .. 95 LOOP
          str4 := str3 || CHR(d);
          FOR e IN 65 .. 95 LOOP
            str5 := str4 || CHR(e);
            BEGIN
              xstr := str5;
              EXECUTE IMMEDIATE xstr INTO n;
              INSERT INTO xdollar (file_name,numrows) VALUES ('X$' || CHR(a) || CHR(b) || CHR(c) || CHR(d) || CHR(e),n);
            EXCEPTION
              WHEN others THEN
                NULL;
            END;
          END LOOP;
        END LOOP;
      END LOOP;
    END LOOP;
  END LOOP;
  COMMIT;
END xdollarproc;
/
X$ Naming Notes ALO = allocate
RLs = release
 
X$ Objects By Category
Active Session History
Object Name Notes
X$ASH Maps to V$ACTIVE_SESSION_HISTORY
Advanced Queuing
Object Name Notes
X$BUFFERED_QUEUES -
X$BUFFERED_SUBSCRIBERS -
X$PERSISTENT_PUBLISHERS -
X$PERSISTENT_QUEUES SQL> select queue_schema, queue_name
   2 from x$persistent_queues;

QUEUE_SCHEMA                   QUEUE_NAME
------------------------------ -------------
SYSMAN                         MGMT_TASK_Q

SELECT owner, name
FROM dba_queues
ORDER BY 1,2;
X$PERSISTENT_SUBSCRIBERS  
Archived Redo Logs
Object Name Notes
X$KCCAL SQL> SELECT alnam
2 FROM x$kccal
3 WHERE alnam IS NOT NULL;

ALNAM
-----------------------------------------------------------
C:\ORACLE\FAST_RECOVERY_AREA\ORABASE\ARCHIVELOG\2011_10_09\ O1_MF_1_198_79451QF5_.ARC
Automatic Diagnostic Repository (ADR)
Object Name Notes
X$DBKRUN Health management runs
X$DIAG_ADR_CONTROL ADR homes, paths, purge times, and similar administrative data
X$DIAG_ADR_INVALIDATION no rows when checked
X$DIAG_ALERT_EXT Text portions of the XML version of the Alert Log
X$DIAG_AMS_XACTION -
X$DIAG_DDE_USER_ACTION contains incident_id
X$DIAG_DDE_USER_ACTION_DEF -
X$DIAG_DDE_USR_ACT_PARAM -
X$DIAG_DDE_USR_ACT_PARAM_DEF -
X$DIAG_DDE_USR_INC_ACT_MAP -
X$DIAG_DDE_USR_INC_TYPE -
X$DIAG_DFW_CONFIG_CAPTURE -
X$DIAG_DFW_CONFIG_ITEM -
X$DIAG_DIAGV_INCIDENT -
X$DIAG_DIR_EXT -
X$DIAG_EM_DIAG_JOB -
X$DIAG_EM_TARGET_INFO -
X$DIAG_EM_USER_ACTIVITY -
X$DIAG_HM_FDG_SET -
X$DIAG_HM_FINDING -
X$DIAG_HM_INFO -
X$DIAG_HM_MESSAGE -
X$DIAG_HM_RECOMMENDATION -
X$DIAG_HM_RUN -
X$DIAG_INCCKEY -
X$DIAG_INCIDENT -
X$DIAG_INCIDENT_FILE Lists incident files
X$DIAG_INC_METER_CONFIG -
X$DIAG_INC_METER_IMPT_DEF -
X$DIAG_INC_METER_INFO -
X$DIAG_INC_METER_PK_IMPTS -
X$DIAG_INC_METER_SUMMARY -
X$DIAG_INFO ADR equivalent to the database instance's V$PARAMETER
X$DIAG_IPS_CONFIGURATION -
X$DIAG_IPS_FILE_COPY_LOG -
X$DIAG_IPS_FILE_METADATA -
X$DIAG_IPS_PACKAGE -
X$DIAG_IPS_PACKAGE_FILE -
X$DIAG_IPS_PACKAGE_HISTORY -
X$DIAG_IPS_PACKAGE_INCIDENT -
X$DIAG_IPS_PKG_UNPACK_HIST -
X$DIAG_IPS_PROGRESS_LOG -
X$DIAG_IPS_REMOTE_PACKAGE -
X$DIAG_PICKLEERR -
X$DIAG_PROBLEM -
X$DIAG_RELMD_EXT -
X$DIAG_SWEEPERR -
X$DIAG_VEM_USER_ACTLOG -
X$DIAG_VEM_USER_ACTLOG1 -
X$DIAG_VHM_RUN -
X$DIAG_VIEW -
X$DIAG_VIEWCOL -
X$DIAG_VINCIDENT -
X$DIAG_VINCIDENT_FILE -
X$DIAG_VINC_METER_INFO -
X$DIAG_VIPS_FILE_COPY_LOG -
X$DIAG_VIPS_FILE_METADATA -
X$DIAG_VIPS_PACKAGE_FILE -
X$DIAG_VIPS_PACKAGE_HISTORY -
X$DIAG_VIPS_PACKAGE_MAIN_INT -
X$DIAG_VIPS_PACKAGE_SIZE -
X$DIAG_VIPS_PKG_FILE -
X$DIAG_VIPS_PKG_INC_CAND -
X$DIAG_VIPS_PKG_INC_DTL -
X$DIAG_VIPS_PKG_INC_DTL1 -
X$DIAG_VIPS_PKG_MAIN_PROBLEM -
X$DIAG_VNOT_EXIST_INCIDENT -
X$DIAG_VPROBLEM -
X$DIAG_VPROBLEM1 -
X$DIAG_VPROBLEM2 -
X$DIAG_VPROBLEM_BUCKET -
X$DIAG_VPROBLEM_BUCKET1 -
X$DIAG_VPROBLEM_BUCKET_COUNT -
X$DIAG_VPROBLEM_INT -
X$DIAG_VPROBLEM_LASTINC -
X$DIAG_VSHOWCATVIEW -
X$DIAG_VSHOWINCB -
X$DIAG_VSHOWINCB_I -
X$DIAG_VTEST_EXISTS -
X$DIAG_V_ACTINC -
X$DIAG_V_ACTPROB -
X$DIAG_V_INCCOUNT -
X$DIAG_V_INCFCOUNT -
X$DIAG_V_INC_METER_INFO_PROB -
X$DIAG_V_IPSPRBCNT -
X$DIAG_V_IPSPRBCNT1 -
X$DIAG_V_NFCINC -
X$DIAG_V_SWPERRCOUNT -
Alert Log
Object Name Notes
X$DBGALERTEXT In memory copy of the alert log
Backup & Recovery
Object Name Notes
X$ESTIMATED_MTTR Estimated Mean Time To Recovery
X$KCCBI SQL> SELECT bitsm, bimdt, bidun
   2 FROM x$kccbi;

SQL> SELECT start_time
   2 FROM v$rman_backup_job_details
   3 ORDER BY 1;
X$KCVFHONL From a private communication with Riyaj Shamsudeen:

v$backup is based upon x$kcvfhonl. KCV tables are mapping from file headers.Read from v$backup will show lots of db file sequential reads with block_id=1 and blocks=1, i.e. reading file headers.

WAIT #1: nam='db file sequential read' ela= 942 file#=2 block#=1 blocks=1 obj#=-1 tim=497122949693
WAIT #1: nam='unspecified wait event' ela= 34380 p1=0 p2=0 p3=0 obj#=-1 tim=497122949979
WAIT #1: nam='db file sequential read' ela= 1188 file#=3 block#=1 blocks=1 obj#=-1 tim=497123009270
WAIT #1: nam='unspecified wait event' ela= 58053 p1=0 p2=0 p3=0 obj#=-1 tim=497123009523
WAIT #1: nam='db file sequential read' ela= 736 file#=4 block#=1 blocks=1 obj#=-1 tim=497123052425
WAIT #1: nam='unspecified wait event' ela= 42143 p1=0 p2=0 p3=0 obj#=-1 tim=497123052678
WAIT #1: nam='db file sequential read' ela= 2022 file#=5 block#=1 blocks=1 obj#=-1 tim=497123093842
WAIT #1: nam='unspecified wait event' ela= 39161 p1=0 p2=0 p3=0 obj#=-1 tim=497123094115

Here is the file header update, I was talking about. you can see that backup checkpointed at SCN from thread 6. This is not a problem per se, but other sessions in the remote nodes are not reading the file headers.

Backup Checkpointed at scn:  0x0b26.2cc0c5c8 04/12/2011 18:25:34
 thread:6 rba:(0x69fb.8fa5.10)
 enabled  threads:  00000111 11100000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
Buffer Headers
Object Name Notes
X$BH Commonly used to locate file# and block# when diagnosing cache buffers chains latch contention.

SELECT bh.obj, bh.dbarfil, bh.dbablk
FROM x$bh bh, v$latch_children lc
WHERE bh.hladdr = lc.addr;

for the said latch (whose sleeps you think are too high).

To determine if a specific buffer has too many clones:

SELECT dbarfil, dbablk, COUNT(*)
FROM x$bh
GROUP BY dbarfil, dbablk
HAVING COUNT(*) > 9;

obj column matches dba_objects.data_object_id
The tch column, touch count, records how many times a particular buffer has been accessed
Tim is time the buffer touch happened
Lru_flag relates to a buffer's hot/cold feature and is often used to find hot blocks
Buffer Pools
Object Name Notes
X$KCBWBPD -
Buffer Working Data Sets
Object Name Notes
X$KCBWDS  
Checkpoint Process
Object Name Notes
X$ACTIVECKPT -
X$CKPTBUF -
Child Cursors
Object Name Notes
X$KGLCURSOR_CHILD SELECT kglfnobj, DECODE(kglobt32, 0,
                       'NONE', 1,
                       'ALL_ROWS', 2,
                       'FIRST_ROWS', 3,
                       'RULE', 4,
                       'CHOOSE', 'UNKNOWN')
FROM x$kglcursor_child
WHERE rownum < 6;
Control Files
Object Name Notes
X$KCCCF SELECT cfnam
FROM x$kcccf;

CFNAM
--------------------------------------------------
C:\ORACLE\ORADATA\ORABASE\CONTROL01.CTL
C:\ORACLE\FAST_RECOVERY_AREA\ORABASE\CONTROL02.CTL
Database Version
Object Name Notes
X$DRC Data Guard Broker
Data Files
Object Name Notes
X$KCVDF

Datafile header information		 SELECT df_fhfno, df_fhtnm
FROM x$kcvdf;

DF_FHFNO   DF_FHTNM
---------- ------------------------------
         1 SYSTEM
         2 SYSAUX
         3 UNDOTBS1
         4 USERS
         5 EXAMPLE
         6 UWDATA
X$KCVFH K = kernel, C = cache layer, V = recoVery Component, FH = File Header
The following query will tell you if recovery is complete:

SELECT hxfil FILENUMBER, fhsta STATUS, fhscn SCN, fhrba_seq SEQUENCE
FROM x$kcvfh;

Status = 0: The datafile is consistent
Status = 1: The datafile needs more recovery
Status = 4: The datafile is in a fuzzy state-poss bad backup
Status = 8192: ?
Status = 8196: ?
Data Guard
Object Name Notes
X$VERSION -
DUAL
Object Name Notes
X$DUAL SELECT * FROM x$dual;

ADDR           INDX    INST_ID DUMMY
-------- ---------- ---------- -----
069D450C          0          1 X

SQL> select * from dual;

DUMMY
-----
X
Exadata Cells
Object Name Notes
X$CELL_NAME -
X$KCFISOSS Cellname
X$KCFISOSSN Cellname / wait
X$KCFISOSST Cellname
Heterogeneous Services
Object Name Notes
X$HS_SESSION Heterogeneous services data base link users, hosts, and SIDs
Incident Repair
Object Name Notes
X$IR_MANUAL_OPTION -
X$IR_REPAIR_OPTION -
X$IR_REPAIR_STEP -
X$IR_RS_PARAM -
X$IR_WF_PARAM -
X$IR_WORKING_FAILURE_SET -
X$IR_WORKING_REPAIR_SET -
X$IR_WR_PARAM -
Kernel Cache
Object Name Notes
X$KCBBES -
X$KCBBF According to Jonathan Lewis the number of available buffer handles set at instance start-up, and likely dependent on the number of processes, apparently 5 * processes, although that value five may be related to the fact that the default value for _db_handles_cached is five. These handles appear as the structure x$kcbbf.

SQL> show parameter processes

SELECT COUNT(*)
FROM x$kcbbf;
X$KCBBHS -
X$KCBDBK -
X$KCBFWAIT Kernel Cache Buffer File Wait used to break down the contents of v$waitstat into per-datafile statistics

SELECT name, count, time
FROM v$datafile df, x$kcbfwait fw
WHERE fw.indx+1 = df.file#;
X$KCBKPFS Kernel Cache Buffer ckpt PreFetch Statistics. Used by the CKPT process to store its wasted prefetch block statistics history. [Link]
X$KCBKWRL -
X$KCBLDRHIST -
X$KCBLSC -
X$KCBMMAV -
X$KCBOBH Kernel Cache Buffer OBject queue Buffer Header. Contains one row for each buffers in the KCB object queue. [Link]
X$KCBOQH Kernel Cache Buffer Object Queue Header
X$KCBPRFH -
X$KCBSDS -
X$KCBUWHY -
X$KCBSW kernel cache waits
X$KCBTEK -
X$KCBVBL -
X$KCBWAIT kernel cache, block wait
X$KCBWH -
X$KCCACM -
X$KCCAGF -
X$KCCBF -
X$KCCBL -
X$KCCBLKCOR -
X$KCCBP -
X$KCCBS -
X$KCCCC -
X$KCCCP kernel cache, controlfile checkpoint progress
X$KCCDFHIST -
X$KCCDI -
X$KCCDI2 -
X$KCCDL -
X$KCCFC -
X$KCCFE -
X$KCCFLE -
X$KCCIC -
X$KCCIRT -
X$KCCLE -
X$KCCLH -
X$KCCNRS -
X$KCCOR -
X$KCCPA -
X$KCCPD -
X$KCCRDI -
X$KCCRL -
X$KCCRM -
X$KCCRS -
X$KCCRSP -
X$KCCRSR -
X$KCCRT -
X$KCCSL -
X$KCCTF -
X$KCCTIR -
X$KCFIO kernel cache, file I/O
X$KCFTIO -
X$KCFISCAP -
X$KCFISTCAP -
X$KCFISTSA -
X$KCLCURST -
X$KCLDELTAST -
X$KCLH kernel cache, lock file header
X$KCLFI kernel cache, lock file index
X$KCFIOFCHIST -
X$KCFIOHIST -
X$KCFISOSSC -
X$KCLFX -
X$KCLLS -
X$KCLQN -
X$KCLCRST -
X$KCLRCVST -
X$KCLUH kernel cache, lock undo header
X$KCLUI kernel cache, lock undo index
X$KCMSCN -
X$KCPXPL -
X$KCRFDEBUG -
X$KCRFWS -
X$KCRFX -
X$KCRMF -
X$KCRMT -
X$KCRMX -
X$KCRRARCH -
X$KCRRASTATS -
X$KCRRDSTAT -
X$KCRRLNS -
X$KCRRNHG -
X$KCTICW -
X$KCTLAX -
Kernel Generic Heap
Object Name Notes
X$KGHLU kernel generic, heap LRUs
X$KGICS -
X$KGLAU -
X$KGLDP -
X$KGLJMEM -
X$KGLJSIM -
X$KGLLK kernel generic, library cache lock
X$KGLMEM -
X$KGLNA -
X$KGLNA1 -
X$KGLOB kernel generic, library cache object. A direct dependency for DBMS_ALERT.
X$KGLOBXML -
X$KGLPN kernel generic, library cache pin
X$KGLRD -
X$KGLSIM -
X$KGLSN -
X$KGLST kernel generic, library cache status
X$KGLTR -
X$KGLXS -
X$KGSCC -
X$KGSKASP Active Session Pool
X$KGSKCFT -
X$KGSKCP -
X$KGSKDOPP -
X$KGSKNCFT -
X$KGSKPFT -
X$KGSKPP -
X$KGSKQUEP -
X$KGSKSCS -
X$KGSKTE -
X$KGSKTO -
X$KGSKVFT -
Kernel Query
Object Name Notes
X$KQDPG kernel query, fixed table columns:
X$KQFCO -
X$KQFDT kernel query, fixed tables:
X$KQFOPT  
X$KQFP kernel query, fixed procedures:
X$KQFSZ kernel query, fixed size:
X$KQFTA Kernel Query, Fixed Table: Base table of v$fixed_table, whose object_id (indx of x$kqfta) matches obj# of tab_stats$, the table dbms_stats.gather_fixed_objects_stats inserts stats into.
X$KQFTVRTTST0 -
X$KQFVI Kernel Query, Fixed View: V$ and GV$ dynamic performance views
X$KQFVT Kernel Query, Fixed View Table:
X$KQLFBC -
X$KQLFSQCE Underscore startup/initialization parameters (3308 entries per parameter in my database)
X$KQLFXPL -
X$KQLSET -
X$KQRFP -
X$KQRFS -
X$KQRPD Kernel Query, Rowcache Parent Definition: Column kqrpdosz is size of this parent rowcache object, not exposed in v$rowcache_parent although shown in rowcache dump.
X$KQRSD Kernel Query, Rowcache Subordinate Definition: Column kqrsdosz is size of this subordinate rowcache object, not exposed in v$rowcache_subordinate although shown in rowcache dump.
X$KQRST -
Kernel Security
Object Name Notes
X$KZDOS -
X$KZEKMENCWAL -
X$KZEKMFVW -
X$KZPOPR -
X$KZRTPD -
X$KZSPR -
X$KZSRO kernel security, system role
X$KZSRT -
Kernel Service
Object Name Notes
X$KSBDD -
X$KSBDP -
X$KSBFT -
X$KSBTABACT -
X$KSDAF -
X$KSDAFT -
X$KSFDFTYP -
X$KSFDSTCG -
X$KSFDSTCMP -
X$KSFDSTFILE -
X$KSFDSTHIST -
X$KSFDSTTHIST -
X$KSFMCOMPL -
X$KSFMELEM -
X$KSFMEXTELEM -
X$KSFMFILE -
X$KSFMFILEEXT -
X$KSFMIOST -
X$KSFMLIB -
X$KSFMSUBELEM -
X$KSFQDVNT -
X$KSFQP -
X$KSFVQST -
X$KSFVSL -
X$KSFVSTA -
X$KSIMAT -
X$KSIMAV -
X$KSIMSI -
X$KSIRESTYP -
X$KSIRGD -
X$KSKPLW -
X$KSLCS -
X$KSLECLASS -
X$KSLED -
X$KSLEI -
X$KSLEMAP Kernel Service, Latch Event Map: Maps events to a small number of useful classes like I/O waits"
X$KSLES -
X$KSLHOT -
X$KSLLCLASS -
X$KSLLD -
X$KSLLTR -
X$KSLLW -
X$KSLPO -
X$KSLSCS -
X$KSLSESHIST -
X$KSLWH -
X$KSLWSC -
X$KSLWT -
X$KSMDD -
X$KSMDUT1 -
X$KSMFS Kernsel Services: memory fixed SGA
X$KSMFSV Kernsel Services: memory fixed SGA vectors
X$KSMGE -
X$KSMHP -
X$KSMJCH -
X$KSMJS Kernsel Services: memory java_pool summary
X$KSMLRU Kernsel Services: memory LRU
X$KSMLS Kernsel Services: memory large_pool summary
X$KSMMEM Kernsel Services: memory
X$KSMNIM -
X$KSMNS -
X$KSMPGDP -
X$KSMPGDST -
X$KSMPGST -
X$KSMPP Kernsel Services: memory process pool
X$KSMSD Kernsel Services: memory SGA definition
X$KSMSGMEM -
X$KSMSP Kernsel Services: memory shared pool
X$KSMSPR Kernsel Services: memory shared pool reserved
X$KSMSP_DSNEW -
X$KSMSP_NWEX -
X$KSMSS Kernsel Services: memory shared_pool summary
X$KSMSST -
X$KSMSTRS -
X$KSMUP Kernsel Services: memory user pool
X$KSOLSFTS -
X$KSOLSSTAT -
X$KSPPCV -
X$KSPPCV2 -
X$KSPPI -
X$KSPPO -
X$KSPPSV -
X$KSPPSV2 -
X$KSPSPFH -
X$KSPSPFILE -
X$KSPVLD_VALUES -
X$KSQDN -
X$KSQEQ -
X$KSQEQTYP -
X$KSQRS -
X$KSQST Kernsel Services: enqueue status
X$KSRCCTX -
X$KSRCDES -
X$KSRCHDL -
X$KSRMPCTX -
X$KSRMSGDES -
X$KSRMSGO -
X$KSRPCIOS -
X$KSTEX -
X$KSUCF -
X$KSUCPUSTAT -
X$KSUINSTSTAT -
X$KSULL -
X$KSULV Kernsel Services: user locale value
X$KSUMYSTA -
X$KSUNETSTAT -
X$KSUPGP -
X$KSUPGS -
X$KSUPL -
X$KSUPR Kernsel Services: user process
X$KSUPRLAT -
X$KSURLMT -
X$KSURU -
X$KSUSD -
X$KSUSE See Demo At Page Bottom
X$KSUSECON -
X$KSUSECST -
X$KSUSESTA -
X$KSUSEX -
X$KSUSGIF -
X$KSUSGSTA -
X$KSUSIO -
X$KSUSM -
X$KSUTM -
X$KSUVMSTAT -
X$KSUXSINST -
X$KSWSAFTAB -
X$KSWSASTAB -
X$KSWSCLSTAB -
X$KSWSEVTAB -
X$KSXAFA -
X$KSXPCLIENT -
X$KSXPIA -
X$KSXPIF -
X$KSXPPING -
X$KSXPTESTTBL -
X$KSXP_STATS -
X$KSXRCH -
X$KSXRCONQ -
X$KSXRMSG -
X$KSXRREPQ -
X$KSXRSG -
X$KD Objects
Object Name Notes
X$KDLT -
X$KDLU_STAT -
X$KDNSSF -
X$KDXHS -
X$KDXST -
X$KE Objects
Object Name Notes
X$KEACMDN -
X$KEAFDGN -
X$KEAOBJT -
X$KECPDENTRY -
X$KECPRT -
X$KEHECLMAP -
X$KEHEVTMAP -
X$KEHF -
X$KEHOSMAP -
X$KEHPRMMAP -
X$KEHR lookup table
X$KEHRP -
X$KEHR_CHILD -
X$KEHSQT -
X$KEHSYSMAP -
X$KEHTIMMAP -
X$KELRSGA -
X$KELRTD -
X$KELRXMRX$KELTGSD -
X$KELTOSD -
X$KELTSD -
X$KESPLAN -
X$KESSPAMET -
X$KESWXMON -
X$KESWXMON_PLAN -
X$KETCL -
X$KETOP -
X$KETTG -
X$KEWAM -
X$KEWASH -
X$KEWECLS -
X$KEWEFXT -
X$KEWEPCS -
X$KEWESMAS -
X$KEWESMS -
X$KEWMAFMV  
X$KEWMDRMV  
X$KEWMDSM  
X$KEWMEVMV -
X$KEWMFLMV -
X$KEWMGSM -
X$KEWMIOFMV -
X$KEWMRMGMV -
X$KEWMRSM -
X$KEWMRWMV -
X$KEWMSEMV -
X$KEWMSMDV -
X$KEWMSVCMV -
X$KEWMWCRMV -
X$KEWMWPCMV -
X$KEWRATTRNEW -
X$KEWRATTRSTALE -
X$KEWRSQLCRIT -
X$KEWRSQLIDTAB -
X$KEWRTOPTENV -
X$KEWRTSEGSTAT -
X$KEWRTSQLPLAN -
X$KEWRTSQLTEXT -
X$KEWSSESV -
X$KEWSSMAP -
X$KEWSSVCV -
X$KEWSSYSV -
X$KEWXOCF -
X$KEWX_SEGMENTS -
X$KF Objects
Object Name Notes
X$KFALS -
X$KFBH -
X$KFCBH -
X$KFCCE -
X$KFCLLE -
X$KFDPARTNER -
X$KFDSK -
X$KFDSK_STAT -
X$KFRC -
X$KFDAT -
X$KFDDD -
X$KFDFS -
X$KFENV -
X$KFFIL -
X$KFFOF -
X$KFFXP -
X$KFGBRB -
X$KFGBRW -
X$KFGMG -
X$KFGRP -
X$KFGRP_STAT -
X$KFKID -
X$KFKLIB -
X$KFKLSOD -
X$KFMDGRP -
X$KFNCL -
X$KFNSDSKIOST -
X$KFTMTA -
X$KFVACFS -
X$KFVACFSENCR -
X$KFVACFSREALM -
X$KFVACFSS -
X$KFVACFSV -
X$KFVOL -
X$KFVOLSTAT -
X$KFZGDR -
X$KFZUAGR -
X$KFZUDR -
X$KJ Objects
Object Name Notes
X$KJBL -
X$KJBLFX -
X$KJBR -
X$KJBRFX -
X$KJCTFR -
X$KJCTFRI -
X$KJCTFS -
X$KJDRHV -
X$KJDRMAFNSTATS -
X$KJDRMHVSTATS -
X$KJDRMREQ -
X$KJDRPCMHV -
X$KJDRPCMPF -
X$KJICVT -
X$KJILFT -
X$KJILKFT -
X$KJIRFT -
X$KJISFT -
X$KJITRFT -
X$KJLEQFP -
X$KJMDDP -
X$KJMSDP -
X$KJPNPX -
X$KJREQFP -
X$KJXM -
X$KJZNHANGS -
X$KJZNHANGSES -
X$KJZNHNGSTATS -
X$KJZNRSLNRC -
X$KJZSIWTEVT -
X$KK Objects
Object Name Notes
X$KKCNRSTAT -
X$KKKICR -
X$KKOCS_HISTOGRAM -
X$KKOCS_SELECTIVITY -
X$KKOCS_STATISTICS -
X$KKSAI -
X$KKSBV -
X$KKSCS -
X$KKSSQLSTAT -
X$KKSSRD -
X$KM Objects
Object Name Notes
X$KMCQS -
X$KMCVC -
X$KMGSBSADV -
X$KMGSBSMEMADV -
X$KMGSCT -
X$KMGSOP -
X$KMGSTFR -
X$KMMDI -
X$KMMDP -
X$KMMHST -
X$KMMNV -
X$KMMRD -
X$KMMSAS -
X$KMMSG -
X$KMMSI -
X$KMPCMON -
X$KMPCP -
X$KMPCSO -
X$KMPSRV -
X$KN Objects
Object Name Notes
X$KNSTCAPCACHE -
X$KNSTXSTS -
X$KNGFL -
X$KNGFLE -
X$KNLAROW -
X$KNLASG -
X$KNSTACR -
X$KNSTANR -
X$KNSTASL -
X$KNSTCAP -
X$KNSTCAPS -
X$KNSTMT -
X$KNSTMVR Kernel replication, statistics materialized view refresh. Base table of v$mvrefresh. Stores MV refresh history info, such as session SID and serial#. Un-exposed columns reftype_knstmvr, groupstate_knstmvr and total_* are useful; see the query in Note:258021.1.
X$KNSTRPP -
X$KNSTRQU -
X$KNSTTXN -
X$KP Objects
Object Name Notes
X$KPONESTAT -
X$KPONJSTAT -
X$KPOQSTA -
X$KPPLCC_INFO -
X$KPPLCC_STATS -
X$KPPLCONN_INFO -
X$KPPLCP_STATS -
X$KR Objects
Object Name Notes
X$KRASGA -
X$KRBAFF -
X$KRBMCA -
X$KRBMROT -
X$KRBMRST -
X$KRBMSFT -
X$KRBZA -
X$KRCBIT Bitmap Block
X$KRCCDE -
X$KRCCDR -
X$KRCCDS -
X$KRCEXT Allocate Bitmap Extent Map
X$KRCFBH Bitmap Extent Header
X$KRCFDE Datafile Descriptor
X$KRCFH Block Change Tracking File Header
X$KRCGFE -
X$KRCSTAT -
X$KRDEVTHIST -
X$KRDRSBROV -
X$KRFBLOG -
X$KRFGSTAT -
X$KRFSTHRD -
X$KRSSMS -
X$KRSTALG -
X$KRSTAPPSTATS -
X$KRSTDEST -
X$KRSTDGC -
X$KRVSLV -
X$KRVSLVPG -
X$KRVSLVS -
X$KRVSLVST -
X$KRVSLVTHRD -
X$KRSTPVRS -
X$KRVXDKA -
X$KRVXDTA -
X$KRVXISPCHK -
X$KRVXISPLCR -
X$KRVXOP -
X$KRVXSV -
X$KRVXTHRD -
X$KRVXTX -
X$KRVXWARNV -
X$KS Objects
Object Name Notes
X$KSBSRVDT -
X$KSDHNG_CACHE_HISTORY -
X$KSDHNG_SESSION_BLOCKERS -
X$KSFDSTBLK -
X$KSXM_DFT -
X$KT Objects
Object Name Notes
X$KTADM -
X$KTATL -
X$KTATRFIL -
X$KTATRFSL -
X$KTCNCLAUSES -
X$KTCNINBAND -
X$KTCNQROW -
X$KTCNQUERY -
X$KTCNREG -
X$KTCNREGQUERY -
X$KTCSP -
X$KTCXB -
X$KTFBFE -
X$KTFBHC -
X$KTFBUE -
X$KTFTBTXNGRAPH -
X$KTFTBTXNMODS -
X$KTFTHC -
X$KTFTME -
X$KTIFB -
X$KTIFF -
X$KTIFV -
X$KTPRHIST -
X$KTPRXRS -
X$KTPRXRT -
X$KTRSO -
X$KTSKSTAT -
X$KTSLCHUNK -
X$KTSPSTAT -
X$KTSSO -
X$KTSSPU -
X$KTSTFC -
X$KTSTSSD -
X$KTSTUSC -
X$KTSTUSG -
X$KTSTUSS -
X$KTTEFINFO -
X$KTTETS -
X$KTTVS -
X$KTUCUS -
X$KTUGD -
X$KTUQQRY -
X$KTUMASCN -
X$KTURD -
X$KTURHIST -
X$KTUSMST -
X$KTUSMST2 -
X$KTUSUS -
X$KTUXE -
X$KV Objects
Object Name Notes
X$KVII Research
X$KVIS -
X$KVIT Research
X$KW Objects
Object Name Notes
X$KWDDEF -
X$KWQBPMT -
X$KWQDLSTAT -
X$KWQITCX -
X$KWQMNC -
X$KWQMNJIT -
X$KWQMNSCTX -
X$KWQMNTASK -
X$KWQMNTASKSTAT -
X$KWQPD -
X$KWQPS -
X$KWQSI -
X$KWRSNV -
X$KX Objects
Object Name Notes
X$KXFPBS -
X$KXFPCDS -
X$KXFPCMS -
X$KXFPCST -
X$KXFPDP -
X$KXFRSVCHASH -
X$KXSBD -
X$KXSCC -
X$KXFPIG -
X$KXFPINSTLOAD -
X$KXFPNS -
X$KXFPPFT -
X$KXFPPIG -
X$KXFPSDS -
X$KXFPSMS -
X$KXFPSST -
X$KXFPYS -
X$KXFQSROW -
Large Objects (LOB)
Object Name Notes
X$ABSTRACT_LOB -
X$KEWX_LOBS -
X$LOBSEGSTAT LOB Segment Stats
X$LOBSTAT LOB Stats
X$LOBSTATHIST LOB Stat History
X$TEMPORARY_LOB_REFCNT -
Locks
Object Name Notes
X$LE If a buffer is locked maps to v$lock_element
Log Buffers
Object Name Notes
X$LOGBUF_READHIST Log buffer read history
Log Miner
Object Name Notes
X$LOGMNR_ATTRCOL$ -
X$LOGMNR_ATTRIBUTE$ -
X$LOGMNR_CALLBACK -
X$LOGMNR_CDEF$ Log Miner Column Definitions
X$LOGMNR_CLU$ Log Miner Clusters
X$LOGMNR_COL$ Log Miner Columns
X$LOGMNR_COLTYPE$ Log Miner Column Types
X$LOGMNR_CONTENTS -
X$LOGMNR_DICTIONARY -
X$LOGMNR_DICTIONARY_LOAD -
X$LOGMNR_ENC$ -
X$LOGMNR_ENCRYPTED_OBJ$ Log Miner Encrypted Objects
X$LOGMNR_ENCRYPTION_PROFILE$ -
X$LOGMNR_FILE$ Log Miner Data and Temp Files
X$LOGMNR_IND$ Log Miner Indexes
X$LOGMNR_INDCOMPART$ -
X$LOGMNR_INDPART$ Log Miner Index Partitions
X$LOGMNR_INDSUBPART$ Log Miner Index Subpartitions
X$LOGMNR_KOPM$ -
X$LOGMNR_KTFBUE -
X$LOGMNR_LATCH Log Miner Latches
X$LOGMNR_LOB$ Log Miner Large Objects
X$LOGMNR_LOBFRAG$ -
X$LOGMNR_LOG -
X$LOGMNR_LOGFILE Log Miner Log Files
X$LOGMNR_LOGS -
X$LOGMNR_NTAB$ -
X$LOGMNR_OBJ$ Log Miner Objects
X$LOGMNR_OPQTYPE$ Log Miner Opaque Types
X$LOGMNR_PARAMETERS Log Miner Parameters
X$LOGMNR_PARTOBJ$ -
X$LOGMNR_PROCESS -
X$LOGMNR_PROPS$ -
X$LOGMNR_REFCON$ -
X$LOGMNR_REGION -
X$LOGMNR_ROOT$ -
X$LOGMNR_SEG$ Log Miner Segments
X$LOGMNR_SESSION Log Miner Sessions
X$LOGMNR_SUBCOLTYPE$ -
X$LOGMNR_TAB$ Logminer Tables
X$LOGMNR_TABCOMPART$ -
X$LOGMNR_TABPART$ Log Miner Table Partitions
X$LOGMNR_TABSUBPART$ Log Miner Table Subpartitions
X$LOGMNR_TS$ Log Miner Tablespaces
X$LOGMNR_TYPE$ Log Miner Data Types
X$LOGMNR_UET$ -
X$LOGMNR_UNDO$ Log Miner Undo
X$LOGMNR_USER$ Log Miner Users
Long Operations
Object Name Notes
X$KSULOP Kernsel Services: user long operation
X$XSLONGOPS Maps to v$session_longops
Mutexes
Object Name Notes
X$MUTEX_SLEEP  
X$MUTEX_SLEEP_HISTORY  
NLS Parameters
Object Name Notes
X$NLS_PARAMETERS SELECT parameter, value
FROM x$nls_parameters;

SELECT *
FROM v$nls_parameters;
NFS Mount
Object Name Notes
X$NFSCLIENTS NFS Clients
X$NFSLOCKS NFS Locks
X$NFSOPENS -
Physical Files
Object Name Notes
X$INSTANCE_CACHE_TRANSFER col fnnam format a40
col fnonm format a40

SELECT fnnam, fnonm
FROM x$kccfn;

FNNAM
----------------------------------------
C:\ORACLE\ORADATA\ORABASE\REDO03.LOG C:\ORACLE\ORADATA\ORABASE\REDO02.LOG C:\ORACLE\ORADATA\ORABASE\REDO01.LOG C:\ORACLE\ORADATA\ORABASE\USERS01.DBF C:\ORACLE\ORADATA\ORABASE\UNDOTBS01.DBF C:\ORACLE\ORADATA\ORABASE\SYSAUX01.DBF C:\ORACLE\ORADATA\ORABASE\SYSTEM01.DBF
C:\ORACLE\ORADATA\ORABASE\TEMP01.DBF
C:\ORACLE\ORADATA\ORABASE\EXAMPLE01.DBF
C:\ORACLE\ORADATA\ORABASE\UWDATA01.DBF
C:\ORACLE\ORADATA\ORABASE\CATTBS01.DBF
Processes and Process Messages
Object Name Notes
X$MESSAGES col description format a70
col dest format a10

SELECT dest, description
FROM x$messages
ORDER BY 1,2;
RDA
Object Name Notes
X$KCCDC -
Real Application Clusters
Object Name Notes
X$INSTANCE_CACHE_TRANSFER  
X$KCBSC I/O
Redo and Undo
Object Name Notes
X$KCRFSTRAND Redo pool descriptor
X$KTIFP In-Memory Undo
Rules and Rule Sets
Object Name Notes
X$RULE Rule WHERE clause & metrics
Tablespaces
Object Name Notes
X$KCCTS

Note: The highlighted tablespaces were dropped prior to this query		 SELECT tsnam
FROM x$kccts;

TSNAM
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
USERS
TEMP
EXAMPLE
UWDATA
CATTBS
PART1
PART2
PART3
PART4
Time Zone
Object Name Notes
X$TIMEZONE_FILE Timezone File In Use
X$TIMEZONE_NAMES Timezones
Wait Interface
Object Name Notes
X$KCBSH -
X$KSDHNG_CHAINS -
Miscellaneous X$K Objects
Object Name Notes
X$KAUVRSTAT -
X$KCVFHTMP -
X$KLCIE -
X$KLPT -
X$KOCST -
X$KUPVA -
X$KUPVJ -
X$KYWMCLTAB -
X$KYWMNF -
X$KYWMPCTAB -
X$KYWMWRCTAB -
X$DB Objects
Object Name Notes
X$DBGDIREXT -
X$DBGRICX -
X$DBGRIFX -
X$DBGRIKX -
X$DBGRIPX -
X$DBKECE -
X$DBKEFAFC SELECT "ACTION NAME", "ACTION ID"
FROM x$dbkefafc;
X$DBKEFDEAFC SELECT "ACTION ID", "PROBLEM KEY"
FROM x$dbkefdeafc;
X$DBKEFEFC -
X$DBKEFIEFC -
X$DBKFDG -
X$DBKFSET -
X$DBKH_CHECK -
X$DBKH_CHECK_PARAM -
X$DBKINCMETCFG -
X$DBKINCMETINFO -
X$DBKINCMETSUMMARY -
X$DBKINFO -
X$DBKRECO -
Miscellaneous Objects
Object Name Notes
X$BUFFER -
X$BUFFERED_PUBLISHERS -
X$BUFFER2 -
X$CONTEXT -
X$DGLPARAM -
X$DNFS_CHANNELS -
X$DNFS_FILES -
X$DNFS_HIST -
X$DNFS_META -
X$DNFS_SERVERS -
X$DNFS_STATS -
X$DRA_FAILURE -
X$DRA_FAILURE_CHECK -
X$DRA_FAILURE_CHECK_MAP -
X$DRA_FAILURE_PARAM -
X$DRA_FAILURE_PARENT_MAP -
X$DRA_FAILURE_REPAIR -
X$DRA_FAILURE_REPAIR_MAP  
X$DRA_REPAIR -
X$DRA_REPAIR_PARAM -
X$DRM_HISTORY -
X$DRM_HISTORY_STATS -
X$DGLXDAT -
X$GIMSA -
X$GLOBALCONTEXT -
X$HOFP -
X$JOXFC -
X$JOXFD -
X$JOXFM -
X$JOXFR -
X$JOXFS -
X$JOXFT -
X$JSKJOBQ -
X$JSKSLV -
X$K2GTE kernel 2-phase commit, global transaction entry. Find sessions coming from or going to a remote database

SELECT /*+ ordered */
  SUBSTR(s.ksusemnm,1,10)||'-'|| SUBSTR(s.ksusepid,1,10) origin,
  SUBSTR(g.k2gtitid_ora,1,35) gtxid,
  SUBSTR(s.indx,1,4)||'.'|| SUBSTR(s.ksuseser,1,5) lsession,
  s.ksuudlna username, SUBSTR(
    DECODE(BITAND(ksuseidl,11), 1,'ACTIVE', 0,
    DECODE(BITAND(ksuseflg,4096), 0,'INACTIVE','CACHED'),
    2,'SNIPED', 3,'SNIPED', 'KILLED'),1,1)
  status, e.kslednam waiting
FROM x$k2gte g, x$ktcxb t, x$ksuse s, x$ksled e
WHERE g.k2gtdxcb=t.ktcxbxba
AND g.k2gtdses = t.ktcxbses
AND s.addr = g.k2gtdses
AND e.indx=s.ksuseopc;

x$k2gte.k2gtdses matches v$session.saddr
k2gtdxcb matches v$transaction.addr.

It's better than checking for DX locks for outgoing sessions (since a DX lock only shows up in v$lock for the current distributed transaction session). X$k2gte2 is the same as x$k2gte except on k2gtetyp which may show 2 for 'TIGHTLY COUPLED' instead of 0 for 'FREE'. One use of x$k2gte[2] is the clearly translated global transaction ID in k2gtitid_ora as opposed to the hex numbers in v$global_transaction.globalid.
X$K2GTE2 kernel 2-phase commit, global transaction entry: See above entry.
X$MODACT_LENGTH -
X$MODACT_LENGTH -
X$NSV -
X$OBJECT_POLICY_STATISTICS -
X$OCT -
X$OPARG -
X$OPDESC -
X$OPERATORS SELECT name, operands, in_type, out_type
FROM x$operators
ORDER BY 1;
X$OPTION 15 of the 64 rows tie back to DBA_FEATURE_USAGE_STATISTICS
X$OPVERSION -
X$ORAFN -
X$POLICY_HISTORY -
X$PRMSLTYX -
X$QERFXTST -
X$QESBLSTAT -
X$QESMMAHIST -
X$QESMMAPADV -
X$QESMMIWH -
X$QESMMIWT -
X$QESMMSGA -
X$QESRCDEP -
X$QESRCDR -
X$QESRCMEM -
X$QESRCMSG -
X$QESRCOBJ -
X$QESRCRD -
X$QESRCRR -
X$QESRCSTA -
X$QESRSTAT -
X$QESRSTATALL -
X$QKSBGSES -
X$QKSBGSYS -
X$QKSCESES -
X$QKSCESYS -
X$QKSFM -
X$QKSFMDEP -
X$QKSFMPRT -
X$QKSHT -
X$QKSMMWDS -
X$QUIESCE -
X$RFMP -
X$RFAFO -
X$RFAHIST -
X$RFMTE -
X$RULE_SET -
X$SKGXPIA -
X$SKGXP_CONNECTION -
X$SKGXP_MISC -
X$SKGXP_PORT -
X$TARGETRBA -
X$TRACE -
X$TRACE_EVENTS -
X$UGANCO -
X$VINST -
X$XML_AUDIT_TRAIL -
X$XSAWSO -
X$XPLTON -
X$XPLTOO -
X$XSAGGR -
X$XSAGOP -
X$XSOBJECT -
X$XSOQMEHI -
X$XSOQOJHI -
X$XSOQOPHI -
X$XSOQOPLU -
X$XSOQSEHI -
X$XSSINFO -
X$XS_SESSION_ROLES -
X$ZASAXTAB -
 
X$ Demos
Find sessions coming from remote databases across database links

Courtesy of Mark Bobak		 Finding open database links database wide

Mark Bobak's query (originally in Metalink forum thread 524821.994, where he further attributed authorship) uses this table to find sessions coming from or going to a remote database; in short, x$k2gte.k2gtdses matches v$session.saddr, .k2gtdxcb matches v $transaction.addr. It's more robust than this query, and better than checking for DX locks for outgoing sessions (since a DX lock only shows up in v$lock for the current distributed transaction session).
SELECT /*+ ORDERED */ SUBSTR(s.ksusemnm,1,10)||'-'|| SUBSTR(s.ksusepid,1,10) ORIGIN, SUBSTR(g.K2GTITID_ORA,1,35) GTXID,
SUBSTR(s.indx,1,4)||'.'|| SUBSTR(s.ksuseser,1,5) LSESSION,
s2.username,
SUBSTR(DECODE(BITAND(s.ksuseidl,11),
       1,'ACTIVE', 0,
       DECODE(BITAND(s.ksuseflg,4096) , 0,'INACTIVE','CACHED'),
       2,'SNIPED',
       3,'SNIPED',
       'KILLED' ),1,1) S,
SUBSTR(w.event,1,10) "WAITING"
FROM x$k2gte g, x$ktcxb t, x$ksuse s, gv$session_wait w, gv$session s2
WHERE g.K2GTDXCB =t.ktcxbxba
AND g.K2GTDSES=t.ktcxbses
AND s.addr=g.k2gtdses
AND w.sid=s.indx
AND s2.sid = w.sid;
 
Related Topics
Data Dictionary
GV$ and V$ Dynamic Performance Views
 
Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: © 2012 Daniel A. Morgan