> 文章列表 / Page 320

Script:Translate RDBA relative data block address -- scripts/admin/rdba/rdba_to_file_block.sql select trunc( to_number('&rdba','XXXXXXXX') / power(2,22) ) as rfile# , trunc(to_number('&...

Oracle事件10704可以帮助我们了解队列Enqueue的使用情况，使用方法如下: [oracle@rh2 bdump]$ oerr ora 10704 10704, 00000, "Print out information about what enqueues are being obtained" // *Cause: When enabled, prints out argument...

The function generates a summary report of the v$sql_shared_cursor view and additional diagnostic information depending on the reason code. Counts all the versions that have 'Y' in any of the columns ...

脚本正文: col username for a12 col "QC SID" for A6 col "SID" for A6 col "QC/Slave" for A8 col "Req. DOP" for 9999 col "Actual DOP" for 9999 col "Slaveset" for A8 col "Slave INST" for A9 col "QC INST" for ...

脚本正文: set linesize 120 pagesize 66 col c1 for a9 col c1 heading "OS User" col c2 for a9 col c2 heading "Oracle User" col b1 for a9 col b1 heading "Unix PID" col b2 for 9999 justify left col b2 heading...

针对字典管理临时表空间: select (s.tot_used_blocks/f.total_blocks)*100 as "percent used" from (select sum(used_blocks) tot_used_blocks from v$sort_segment where tablespace_name='TEMP') s, (select sum(blocks) tota...

本文永久地址：https://www.askmaclean.com/archives/oracle-8i-备份恢复（recovery-manager）.html 说明 Recovery Manager（RMAN）是从Oracle8 R8.0之后追加的管理oracle数据库备份/储存/恢复的工具。在此，我将解说oracle8i的RMAN中扩展的新功能。 RMAN基本功能的扩展 媒介管理...

RBO基于规则的优化器access paths优先级: RBO Path 1: Single Row by Rowid RBO Path 2: Single Row by Cluster Join RBO Path 3: Single Row by Hash Cluster Key with Unique or Primary Key RBO Path 4: Single Row by Uniqu...

NOTE: This article was originally created for version 7.3. Conceptually the ideas presented are the same as in later versions but implementation details may have changed or have been enhanced. Histogr...

Sometime we'd like to trigger ORA-00600/7445 internal errors for testing purpose, But it's not easy if you don't know a little trick like below: declare a exception; pragma exception_init(a,-600); beg...