show open tables where in_use0;
select version,bundle_series,comments from dba_registry_historyt;
select open_mode,protection_mode,database_role,switchover_status from v$database;
select s.serial#,p.spid,l.oracle_username from v$locked_object l,dba_objects d,v$session s,v$process p where d.object_id= l.object_id and l.session_id = s.sid and s.paddr = p.addr;