> 文章列表 / Page 320

脚本正文: 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...

某用户windows 2003上的数据库由于存储故障导致系统表空间system.dbf出现IO问题，当打开数据库OPEN database时报错： ORA-01115: IO error reading block from file 15 ORA-01110: data file … ORA-27091: unable to queue I/O ORA-27070: ...

该脚本可以用于显示活跃的分布式事务(Distributed Transactions from dblink)，可以协助诊断dblink远程事务： REM distri.sql column origin format a13 column GTXID format a35 column LSESSION format a10 column s format a1 column wa...

ORA-07445: [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x5A1113A] [ADDR:0xFFFFFFFFFFFFFFFF] [UNABLE_TO_READ]一般是Windows平台上常见的内存不足问题引起，在64 bit 或 32bit 平台均可能发生，一般建议通过增加SGA_MAX_SIZE和SGA_TARGET(ASMM)来解决该问题...