> 文章列表 / Page 322

手动递增SCN号的几种方法 除去下面几种，还有一种方法直接修改 实例的Global Lamport SCN，在SGA中由kcsgscn变量存储，对于一个实例来说这是唯一的源SCN，所有其他的SCN均由这个source scn所驱动。 这种递增方式是直接用oradebug 修改该Global Lamport SCN kcsgscn ...

REM Locate the top PGA user set lines 75 set pages 999 set serveroutput on spool topuser.out select * from gv$version; declare a1 number; a2 number; a3 varchar2(30); a4 varchar2(30); a5 number; a6 num...

以下为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 while trying to add a row cache enqueue to a transact...

Question: How many LMS processes for Oracle 9i Rac? Can you check if you have increased the CPU in the machine during the upgrade. Also please let me know if you have changed any underscore parameter....

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_r...

Question: What is between between "unique index vs non-unique index". Which one is faster. The customer using non-unique and sql is getting delay If we change tp non-unique. Is it work ? Answer: Index...

OPROCD introduced in 10.2.0.4 Linux and other Unix platform. Fencing Cluster handling of nodes that should not have access to shared resources STONITH – Power cycle the node PCW – nodes fence themselv...

Active Session History (ASH) performed an emergency flush. This may mean that ASH is undersized. If emergency flushes are a recurring issue, you may consider increasing ASH size by setting the value o...

Single resource deadlock: blocking enqueue which blocks itself, f 0 Single resource deadlock: blocking enqueue which blocks itself, f 0 Granted global enqueue 0xd8578490 ----------enqueue 0xd8578490--...

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