>ASKMACLEAN_

> 文章列表 / Page 324

2009-07-06

Oracle内部错误ORA-600:[1112]

以下为ORA-600[1112]内部错误的相关诊断信息: ERROR: ORA-600 [1112] [a] [b] [c] [d] [e] VERSIONS: versions 7.3 to 9.2 DESCRIPTION: ORA-600 [1112] is getting raised…
#POST 2 MIN READ
2009-07-02

Tune Very Large Hash Join

set timing on; alter session set workarea_size_policy=MANUAL; alter session set workarea_size_policy=MANUAL; alter session set db_file_multiblock_read_count=512; alter session set db_file_multiblock_read_count=512; alter…
#POST 1 MIN READ
2009-06-30

unique index vs non-unique index

Question: What is between between “unique index vs non-unique index”. Which one is faster. The customer using non-unique and sql…
#POST 2 MIN READ
2009-06-21

RAC Deadlock For Example

Single resource deadlock: blocking enqueue which blocks itself, f 0 Single resource deadlock: blocking enqueue which blocks itself, f 0…
#POST 27 MIN READ
2009-06-21

SCN may jump in a distributed transaction with dblink

在分布式事务环境中数据库的SCN可能瞬间暴增，这种行为被称作SCN jump in distributed transaction，注意这种现象是正常的。在发生分布式事务的2个数据库中，SCN较低的DB会将SCN和较高的那个数据库同步，这有时候会造成我们的一些误解认为可能是Hot backup等操作引起了SCN的猛增。 我们来具体看一下这种现象: SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release…
#POST 1 MIN READ