» Windows Chensq's BLOG

view oracle alert logs in oracle databse

2011 年 2 月 16 日 — chensq

PLAIN TEXT
SQL:

www.ads1st.com SHOW parameter background_d
NAME &nb[......]

Posted in Aix, Hp-ux, Linux, Oracle Database, Performance Tuning, Solarise, Truble shooting, Windows. Tags: alert, external, logs, view. 没有评论 »

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

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

Using 32 byte PL/SQL Devoloper on 64 byte platforms

2011 年 1 月 30 日 — chensq

安装32位的Oracle客户端，如11g;
新建一个批处理文件plsqldev_64.bat，内容如下

@echo off
set path=d:\oracle\11g\bi[......]

Posted in Truble shooting, Windows. Tags: 32, 64, devoloper, plsql. 2 条评论 »