oracle

Oracle latch internals

June 6, 2012 Internals, oracle 4 comments

Oracle latch internals

Server latch implementation called KSL, e.g. every table with name starting with x$ksl… is latch
related and every[……]

Read more

坏块处理一例 (1)

May 31, 2012 maintain, oracle 2 comments

测试AIX从linux导入数据时 Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS阶段停留了很久:

ORA-39082: Object type ALTER_PROCEDURE:”USER_DA[……]

Read more

新到两台x2-2

May 29, 2012 Exadata, oracle 3 comments

oracle服务还是很到位的 2台机器弄了这么一辆卡车来运 :)[……]

Read more

11g 密码延迟登陆导致 library cache lock

May 24, 2012 11g, oracle No comments

前阵子刚写过11g密码延迟登陆的新特性,11g oracle在登陆密码输入错误时候不会立刻中断这个连接而会递增等待时间,这有可能在失败登陆N次以后达到一个很长的阀值(10s),从而导致session 大量积压导致问题的严重化,今天就碰到了问题,PMS team在转换密钥的时候出现了问题,应用一直狂连[……]

Read more

Scripts: report the index fragmentation status

May 14, 2012 maintain, oracle No comments

/* ************************************************************* */
/* Index Fragmentation Status (idsfrag.sql): */
/*[……]

Read more

11G New feature: Failed Logon Delays

April 27, 2012 11g, oracle 4 comments

在pub上看到一个不错的帖子 oracle 11g password delay

对这个特性 做如下说明

Failed Logon Delays

A hacker may attempt a brute force hack to break into your Oracle D[……]

Read more

11gR2 rac ora.asm error (ASM)

April 26, 2012 maintain, oracle, RAC No comments ,

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[……]

Read more

ASM Preferred mirror Read

April 25, 2012 oracle, RAC 2 comments

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[……]

Read more

“hcheck.sql” script to check for known problems in Oracle8i, Oracle9i, Oracle10g and Oracle 11g

April 20, 2012 Internals, oracle No comments

Execution Environment:

Access Privileges:
Requires to be run connected as SYS schema

Usage:
$ sqlplus
SQL*Plus: Release 9.2.0.2.[……]

Read more

diff-hidden parameter between 10g and 11g

April 16, 2012 11g, oracle No comments

看到刘兄的一篇文章转载下

Reference:http://www.oracledatabase12g.com/arch[……]

Read more