Oracle latch internals
Server latch implementation called KSL, e.g. every table with name starting with x$ksl… is latch
related and every[……]
Category: oracle
坏块处理一例 (1)
测试AIX从linux导入数据时 Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS阶段停留了很久：
ORA-39082: Object type ALTER_PROCEDURE:”USER_DA[……]
新到两台x2-2
11g 密码延迟登陆导致 library cache lock
Scripts: report the index fragmentation status
/* ************************************************************* */
/* Index Fragmentation Status (idsfrag.sql): */
/*[……]
11G New feature: Failed Logon Delays
在pub上看到一个不错的帖子 oracle 11g password delay
对这个特性 做如下说明
Failed Logon Delays
A hacker may attempt a brute force hack to break into your Oracle D[……]
11gR2 rac ora.asm error (ASM)
ASM – ora.asm error
11.2.0.3 RAC CRS 无法启动
[ohasd(25286)]CRS-2112:The OLR service started on node db-41.
2012-04-25 14:46:13.120
[ohas[……]
ASM Preferred mirror Read
ASM Preferred mirror Read
Introduction
The concept of the Preferred Read is not a new idea, but is now implemented in Oracle’s ASM volume[……]
“hcheck.sql” script to check for known problems in Oracle8i, Oracle9i, Oracle10g and Oracle 11g
Execution Environment:
Access Privileges:
Requires to be run connected as SYS schema
Usage:
$ sqlplus
SQL*Plus: Release 9.2.0.2.[……]
diff-hidden parameter between 10g and 11g
看到刘兄的一篇文章转载下