⌘KCtrl+K 快速搜索

> 文章列表 / Page 318

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 Granted global enqueue 0xd8578490 ----------enqueue 0xd8578490--...
#POST 89 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$v...
#POST 3 MIN READ
2009-06-19

Know more about redo log buffer and latches

1. The Total size of the log buffer is determined by LOG_BUFFER parameter. 2. Only Server process may pin a data block in exclusive mode. 3. LGWR writes to the redo log files when: The redo log buffer...
#POST 7 MIN READ
2009-06-17

如何设计分区索引

通过下图定义的规则,可确定分区索引类型: Hash Global分区索引介绍 HASH-Partitioned Global索引是Oracle 10g开始提供的新特性。而在以前的版本中 ,Oracle只支持Range-Partitioned Global索引。HASH-Partitioned Global索引的好处如下: 比Range-Partitioned Global索引易于实施。HASH-P...
#POST 2 MIN READ
2009-06-16

Script:List Buffer Cache Details

以下脚本用于列出Oracle Buffer Cache的详细信息: REM List Buffer Cache Details SET LINESIZE 200 PAGESIZE 1400 SELECT /*+ ORDERED USE_HASH(o u) MERGE */ DECODE(obj#, NULL, to_char(bh.obj), u.name || '.' || o.name) na...
#POST 9 MIN READ
2009-06-16

Script:List NLS Parameters and Timezone

以下脚本用以列出Database-instance-session的NLS参数和所在时区: REM List NLS Parameters set linesize 90 pagesize 1400 col Parameter for a40 col Value for a40 SELECT Parameter, Value FROM NLS_DATABASE_PARAMETERS / SELEC...
#POST 1 MIN READ
2009-06-16

Script:List SORT ACTIVITY监控临时空间的使用

以下脚本可以用于列出数据库内的排序活跃性能信息并监控临时空间的使用: REM SORT ACTIVITY set linesize 150 pagesize 1400; SELECT d.tablespace_name "Name", TO_CHAR(NVL(a.bytes / 1024 / 1024, 0),'99,999,990.900') "Size (M)", TO_CHAR(NVL(t....
#POST 30 MIN READ
2009-06-16

Script:List OBJECT DEPENDENT

以下脚本用以列出数据库中对象的依赖性: REM OBJECT DEPENDENT select D_OBJ#, do.object_name, do.object_type dtyp, do.status dsta, D_TIMESTAMP, ORDER#, P_OBJ#, po.object_name, po.object_type ptyp, po.status psta, P_TIMESTA...
#POST 15 MIN READ
2009-06-16

Oracle SQL Function Detail

Below lists Oracle SQL Function , and which version introduce this: SQL> SELECT NAME,VERSION,DATATYPE,DESCR FROM v$sqlfn_metadata order by 2; NAME VERSION DATATYPE DESCR ------------------------------...
#POST 127 MIN READ