Hi ,

Could u anybody please confirm if , there will ever be more than 1 record in v$instance table . i have seen different scripts for date , time of last instance startup in the following path : http://www.dbasupport.com/oracle/scr...tration/Audit/ why do we need a where clause here .

Thanks .