» Solarise Chensq's BLOG

11.2 Dictionary

2011 年 2 月 11 日 — chensq

ALL_ALL_TABLES Description of all object and relational tables accessi[......]

Posted in 11.2, Aix, Hp-ux, Linux, OS, Oracle Database, Performance Tuning, Solarise, Truble shooting, Windows. Tags: dict, Dictionary. 没有评论 »

How to disable or enable flush of ASH data to AWR

2011 年 1 月 30 日 — chensq

MMON process will periodically flush ASH data into AWR tables.
Oracle introduced WF enqu[......]

Posted in 11.1, 11.2, Aix, Hp-ux, Linux, New Feature, OS, Oracle Database, Performance Tuning, Solarise, Truble shooting, Windows. Tags: ash, awr, awr_flush_table_off, awr_flush_table_on, MMON. 没有评论 »

change table's result_cache mode

2011 年 1 月 24 日 — chensq

Resut_cache(结果集缓存)可以大大提高查询的性能。从Oracle 11g开始，oracle支持结果集缓存。11g R1(11.1)支持server端的缓存，11g [......]

Posted in 11.1, 11.2, Aix, Hp-ux, Linux, OS, Performance Tuning, Solarise, Truble shooting, Windows. Tags: default, force, mod, result_cache. 没有评论 »

sqlplus lob usage

2011 年 1 月 12 日 — chensq

www.ads1st.com var report clob;
www.ads1st.com exec dbms_lob.createtemporary(:report,TRU[......]

Posted in Aix, Hp-ux, Linux, OS, Oracle Database, Performance Tuning, Solarise, Truble shooting, Windows. 没有评论 »

Sync time using ora.ctssd

2011 年 1 月 11 日 — chensq

Cluster Time Synchronization Service(Ctss)是Oracle 11g R2引入的集群时间同步服务。Ctss可以运行于两种模式:avtive[......]

Posted in 11.2, Aix, CRS, Hp-ux, Linux, OS, Solarise, Truble shooting, Windows. Tags: CRS, ctss, sync time. 没有评论 »