ITPub博客

Dba做日常Oracle的维护SQL相当多，我的近百个，如下的几个是经常用的，不断的会在本文档添加。[@more@]1、文件IO统计select TS.Name, DF.Name File_Name, FS.Phyblkrd Blocks_Read, FS.Phyblkwrt Blocks_Written, FS.Phyblkrd+FS.Phyblkwrt Total_IOs from V$FILESTAT FS, V$DATAFILE DF,v$tablespace TSwhere DF.File#=FS.File# AND DF.ts#=TS.TS#order by FS.Phyblkrd+FS.Phyblkwrt desc;2、表空间统计SELECT upper(f.tablespace_name) "表空间名", d.Tot_grootte_Mb "表空间大小(M)",

本文给出了hp-unix下为Oracle配置异步IO(AIO)的具体的流程。[@more@]源自Metalink Note:139272.1PURPOSE ------- The purpose of this document is to discuss the implementation of asynchronous i/o (aio) on HP-UX, specifically to enable aio for the Oracle RDBMS Server. SCOPE & APPLICATION ------------------- This note is intended for DBAs and Support Personnel. 1.0 Introduction ================ On HP-UX, when the Oracle datafiles reside on a filesystem, then the DBWR process(es) make synchronous write

Logminer是每个Dba都应熟悉的工具，当一天由于用户的误操作你需要做不完全的恢复时，由于你无法确定这个操作是哪个时间做的，所以这对你的恢复就带来的很大的难度，丢失的数据也不能完全恢复回来。而LogMiner就可以帮你确定这个误操作的准确时间。或是某段时间日志疯长，你想知道成因，那也求助LogMiner吧。[@more@]我的测试环境是Aix4.3.3的操作系统，Oracle9.2.0.3的测试库。一、LogMiner的几点说明1、LogMiner可以帮你确定在某段时间所发的各种DML，DDL操作的具体时间和SCN号，它所依据的是归档日志文件及联机日志文件。2、它只能在Ora

Oracle 诊断事件编码及内容。[@more@]10000 control file debug event, name 'control_file'10001 control file crash event110002 control file crash event210003 control file crash event310004 control file crash event410005 trace latch operations for debugging10006 testing - block recovery forced10007 log switch debug crash after new log select, thread %s10008 log switch debug crash after new log header write, thread %s10009 log switch debug crash after old log header write, thread %s10010 Begin Transac