» Hp-ux Chensq's BLOG

unrepairable block corruption

2011 年 3 月 29 日 — chensq

一个重要的测试数据库，频繁报坏块：
Corrupt block relative dba: 0×2282d416 (file 138, block 185366)
B[......]

Posted in BBED, Block, Hp-ux, Oracle Database, Truble shooting. Tags: Block, corruption, repair. 没有评论 »

Install Oracle 10g CRS & Database on Power 7 machines over 132 CPUS

2011 年 3 月 24 日 — chensq

先看一下主机配置
System Model: IBM,9117-MMB
Machine Serial Number: 067163P
Processor Type: Power[......]

Posted in Aix, CRS, Hp-ux, Install&Patch, Linux, OS, Oracle Database, Solarise, Truble shooting, Windows. Tags: 10.2.0.4.3, 10.2.0.4.4, 6718715, 7115828, 9119284, cpu_count, KGHLATCH_REG4. 没有评论 »

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

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