Tag: internal

Oracle latch internals

Oracle latch internals

Server latch implementation called KSL, e.g. every table with name starting with x$ksl... is latch
related and every SGA has ksl... structure as well.  In order to get complete list of x$ksl table,
connect with sysdba permissions to oracle and run query:
 
SELECT kqftanam
FROM x$kqfta
WHERE  kqftanam  LIKE 'X$KSL%'

eg:

[oracle@testdb ~]$ ora si
 
SQL*Plus: Release 11.2.0.3.0 Production on Thu Jun 6 15:37:53 2013
 
Copyright (c) 1982, 2011, OracleAll rights reserved.
 
 
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
 
SQL> SELECT kqftanam
FROM x$kqfta
WHERE  kqftanam  LIKE 'X$KSL%'      2    3  ;
 
KQFTANAM
----------------------------
--
X$KSLLTR

X$KSLHOT
X$KSLLCLASS
X$KSLECLASS
X$KSLEMAP
X$KSLLD
X$KSLED
X$KSLCS
X$KSLSCS
X$KSLES
X$KSLSESHIST
 
KQFTANAM
----------------------------
--
X$KSLEI

X$KSLLW
X$KSLPO
X$KSLWSC
X$KSLWH
X$KSLWT
 
17 rows selected.

There are two structures associated with a latch in KSL – ksl[……]

Read more