Database Reference
In-Depth Information
Fri Dec 17 18:01:27 2010
Unix process pid: 20780, image: oracle@prddb1 (Q000) flash frozen [ command #1 ]
Fri Dec 17 18:01:27 2010
Unix process pid: 20782, image: oracle@prddb1 (Q001) flash frozen [ command #1 ]
While the database instance is in freeze mode, DBAs can collect relevant statistics, such as system state dumps
and so forth, which could be used for offline analysis:
SQL> alter session set events 'immediate trace name systemstate level 10';
Session altered.
*** 2010-12-17 18:01:27.423
Oradebug command 'ffbegin' console output: <none>
*** 2010-12-17 18:02:59.651
===================================================
SYSTEM STATE (level=10)
------------
System global information:
processes: base 0x67c3f5cf0, size 150, cleanup 0x6843d4078
allocation: free sessions 0x68c3dedd0, free calls (nil)
control alloc errors: 0 (process), 0 (session), 0 (call)
PMON latch cleanup depth: 0
seconds since PMON's last scan for dead processes: 141
system statistics:
0 OS CPU Qt wait time
275 logons cumulative
42 logons current
25367 opened cursors cumulative
Once the trace is complete, the instance can be put back to normal operation using the flash freeze resume
instance command ( FFRESUMEINST ):
SQL> oradebug ffresumeinst
Statement processed.
FFRESUMEINST (flash freeze resume instance) will unfreeze the database instance allowing normal
operations.
Fri Dec 17 18:07:32 2010
Issuing ORADEBUG FFRESUMEINST to: Unix process pid: 20344, image: oracle@prddb1 (PMON)
Issuing ORADEBUG FFRESUMEINST to: Unix process pid: 20346, image: oracle@prddb1 (PSP0)
Issuing ORADEBUG FFRESUMEINST to: Unix process pid: 20348, image: oracle@prddb1 (VKTM)
Error (ORA-00072) failed to issue ORADEBUG FFRESUMEINST to: Unix process pid: 20348, image: oracle@
prddb1 (VKTM)
in a raC environment, this should be a quick operation; if the instance where the freeze was issued does not
come back to normal operation in approximately 60 seconds, the clusterware will attempt to evict the nonresponding
instance from the cluster. this is illustrated in the output from the alert log file.
Note
 
Search WWH ::




Custom Search