oracle系统状态trace文件分析器当系统hang住时，或者进程间有阻塞时，你可以产生下面两种跟踪文件，一种是进程状态跟踪文件，一种是系统状态跟踪文件： process state dumps ==> 一个进程的所有对象状态,如果确认哪个进程有问题,就用该方法 system state dumps ==> 整个系统的所有进程中的所有对象状态进程状态转储可以用以下几种方式：process state dumps:1.ALTER SESSION SET EVENTS 'IMME
Usage: ora [-u user] [-i instance#] [] General -u user/pass use USER/PASS to log in -i instance# append # to ORACLE_SID -sid set ORACLE_SID to sid -top # limit some large queries to on # rows - repeat Repeat an coomand time. Sleep between two
数据库DBA必备手册 Jonathan Lewis 大神力作 Chapter 1: Getting Started . . . ................................................................................. 1 Oracle in Processes .................................................................................
