潛水珽的異想世界

最近在調整我們家的Oracle系統的效能,在metalink上找到了一篇有關系統調校的文章,在這邊轉錄出來給大家參考,有興趣鑽下去研究的可以循著上面的DOC NO.去找出更詳細的文件來看...

引言

Row Cache is another name of Dictionary Cache which is the part of the Shared Pool that contains Data Dictionary objects definitions available in memory to speed up Dicionary operations. Before Oracle7, every Dictionary object had a seperate init.ora parameter that controls it, these parameters were known as the "DC" parameters,but starting from Oracle7 all Dictionary cache objects are automatically controlled within the shared pool by the one parameter Shared_Pool_Size.

在oracle中,dual table是一個很特別的table,在tom ask中tom對dual的解釋是這麼說的:
1.What is the dual table, what is its purpose.

在ask tom中看到一篇解決系統狀況跟我們家系統很相似的文章,
這個公司的statspack  report 跑出來的狀況,有下面的幾個特點:

如何快捷的顯示當前鎖定和被鎖定表的用戶，sql等資訊,如果是dba用戶那麼可以使用

出處:http://209.85.175.104/search?q=cache:leWHxmLtIxAJ:www.read8.org/20070129/34343/+EXP-00056&hl=zh-TW&ct=clnk&cd=4&gl=tw&client=firefox-a

[oracle@oem 6512039]$ ../opatch apply
Invoking OPatch 10.2.0.3.0

在設定OEM 10g GC update patches功能時,發生如下的錯誤:

OEM的語系要怎麼由中文改成英文(或其他)顯示呢?