2010-02-01から1ヶ月間の記事一覧
Code Description 10000 Controlfile debug event, name ‘control_file’. 10001 Controlfile crash event1. 10002 Controlfile crash event2. 10003 Controlfile crash event3. 10004 Controlfile crash event4. 10005 Trace latch operations for debugging…
1,Create a RMAN script named rman.bkp to do the task. [oracle@CentOS53 Oracle_Scripts]$ more rman.bkp CONFIGURE CONTROLFILE AUTOBACKUP ON; configure channel device type disk format='/u01/oracle/app/admin/o11g2/backups/full_db_%U'; configur…
1.Don't believe in myths - reason for yourself! ・"伝説"を信じないこと、自分で考えよう。 2.Don't follow "conventional wisdom" - often the things everybody knows are simply wrong! ・知られたことを信じないこと、みんなが知っていることは通常間…
2. Statspack Configuration --------------------------- 2. Statspack設定2.1. Database Space Requirements 2.1. データベース必要な領域 The amount of database space required by the package will vary considerably based on the frequency of snaps…
Statspackとは? 公式定義: A set of SQL, PL/SQL, and SQL*Plus scripts that allow the collection, automation, storage, and viewing of performance data. This feature has been replaced by the Automatic Workload Repository. パフォーマンスデー…
(1)カレントトレースファイル(TraceFile)ファイル名を取得する SELECT d.VALUE || '/' || LOWER (RTRIM (i.INSTANCE, CHR (0))) || '_ora_' || p.spid || '.trc' trace_file_name FROM (SELECT p.spid FROM v$mystat m, v$session s, v$process p WHERE…