Tuesday, March 27, 2012

To check the instance details in real application clusters

 To check the instance details in real application clusters

select INST_NAME,INST_NUMBER from gv$active_instances;


-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to Trouble shoot Logfile_sync wait event

   First  Identify and break down LGWR wait events. Query wait events for LGWR. In this instance LGWR sid is 3 (and usually it is). select s...