BC Checklist
prstat -a , top SELECT to_char(startup_time,'DD-MON-YYYY HH24:MI:SS') "DB Startup Time" FROM sys.v_$instance; select name,open_mode from v$database; Session Details:- ===================== select username,count(*),status,TYPE from v$session where username not in ('SYS','SYSTEM','DBSNMP') group by username,status,type; col OSUSER for a15 col USERNAME for a10 col MACHINE for a30 set lines 999 pages 999999 col sid for 99999 col username for a20 col osuser for a15 col login_time for a20 col machine for a18 col program for a40 select sid ,serial#,username,status,osuser,machine,program,to_char(logon_time, 'hh24:mi dd/mm/yy') login_time,last_call_et from v$session where username is not null order by login_time / set pages 50000 lines 32767 col USERNAME for a10 col MACHINE for a15 col PROGRAM for a40 SELECT USERNAME,machine,inst_id,sid,serial#,PROGRAM, to_char(logon_time,'dd-mm-yy hh:mi:ss AM')"Logon Time",