⌘KCtrl+K 快速搜索

> 文章列表 / Page 320

2009-04-13

脚本:监控并行进程状态

脚本正文: 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 ...
#POST 15 MIN READ
2009-04-13

脚本:监控数据库中的活跃用户及其运行的SQL

脚本正文: 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...
#POST 5 MIN READ
2009-04-13

脚本:监控临时表空间使用率

针对字典管理临时表空间: 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...
#POST 2 MIN READ
2009-03-21

Oracle 8i 备份/恢复(Recovery Manager)

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

RBO基于规则的优化器access paths优先级

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...
#POST 2 MIN READ
2009-03-07

Histograms: An Overview

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...
#POST 16 MIN READ
2009-03-04

How to trigger ORA-00600,ORA-7445 by manual

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...
#POST 2 MIN READ
2009-01-12

Script to show Active Distributed Transactions

该脚本可以用于显示活跃的分布式事务(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...
#POST 5 MIN READ