注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

lazydba

hello

 
 
 

日志

 
 

[Oracle] Kernel Layers and X$ tables  

2008-04-07 08:24:06|  分类: all about databa |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

Kernel Layers: http://www.oreilly.com/catalog/orinternals/chapter/ch01.html
x$ tables naming conventions: http://www.eygle.com/archives/2004/11/oracle_x_table.html
Oracle internels: www.ixora.com.au
Book: http://www.amazon.com/Oracle-Database-Performance-Tuning-Techniques/dp/0072263059

Two interesting layers:

The services layer (KS)

The services layer provides low-level services that are used by all the higher layers, such as error handling, debugging, and tracing facilities, as well as parameter control and memory services. In particular, the service layer is responsible for generic concurrency control facilities such as latches, event waits, enqueue locks, and instance locks. This layer is also responsible for the management of the data structures for background and user processes and sessions, as well as state objects, inter-process messages, and system statistics.
?
Some x$ tables in ks:
Parameter:
x$ksppi - parameter info
x$ksppcv - Current session values
x$ksppsv - System values

Memory management
x$ksmsp - SGA heap
x$ksmlru
Event waits
x$ksled - Event Descriptors
x$kslei -
x$ksles - Session Statistics
Latchs
x$kslld
x$ksllt
x$ksllw
x$lslpo
x$kslwsc
Enqueue:
x$ksqdn
x$ksqeq
x$ksqrs
x$ksqst
?
The generic layer (KG)
The generic layer provides management for the generic data structures that are used by the higher layers, such as linked lists. Of particular interest are the library cache and the memory allocation heaps used for the shared pool and session memory.

Some x$ tables in kg:
Library cache:
x$kglob - All objects
x$kglbody
x$kgltrigger
x$kglindex
x$kglcluster
x$kglcursor
x$kglna - Object Names
x$kglpn - Object Pins
x$kgllk

Heap
x$kghlu

?


  评论这张
 
阅读(130)| 评论(0)
推荐 转载

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017