> doesn't work. And before resorting to that, a direct attach sga program,
> dumping v$session_wait should be done before
There might be a catch here. Such program will not work without some
values (like address of fixed table). These values may change after db
startup and are obtained using ordinary SQL (via sqlplus, for
example). So if we want to use program that directly read data from
SGA of hanged database, we need to preliminary read some values
sometimes before database hangs (for example, immediately after
startup).
--
Egor
http://www.oracledba.ru
--
http://www.freelists.org/webpage/oracle-l
Received on Sat May 06 2006 - 07:08:16 CDT
