» 11.1 Chensq's BLOG

kill oracle thread on windows

2011 年 2 月 15 日 — chensq

PLAIN TEXT
SQL:

SQL> SELECT b.STATUS, object_id, session_id
2 &nbs[......]

Posted in 11.1, 11.2, Oracle Database, Windows. Tags: kill, locked_object, orakill, session, Windows. 没有评论 »

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. 没有评论 »

Oracle 11g tracing events

2010 年 9 月 2 日 — chensq

www.ads1st.com l
1 declare
2 err_msg VARCHAR2(120);
3 BEGIN
4 dbms_output.enable[......]

Posted in 11.1, 11.2, Aix, Hp-ux, Internal, Linux, Performance Tuning, Solarise, Truble shooting, Windows. Tags: events, oradebug, tracing. 没有评论 »

crs css parameter diagwait

2010 年 8 月 23 日 — chensq

Oracle Clusterware evicts the node from the cluster when

Node is not pinging via the ne[......]

Posted in 11.1, 11.2, CRS, Grid, OS. Tags: css, diagwait, evict, get, set. 没有评论 »