OBJECTS
=======
@?/rdbms/admin/utlrp
col owner for a20
col object_name for a50
select owner, object_name, object_type
from dba_objects where status = 'INVALID' order by 1, 2, 3;

_____________________________________________________________________________________

AWR
===
@?/rdbms/admin/awrrpt.sql

_____________________________________________________________________________________


V$SESSION_LONGOPS
=================
select distinct to_char(start_time,'YYYY-MM-DD_HH24:MI:SS'), sql_id from v$session_longops order by 1;
select sql_text from v$sql where sql_id = 'xxxxxxxxxxxxx';

_____________________________________________________________________________________


TABLESPACE SIZE OVERVIEW
========================
col "Tablespace"   for a22
col "Used MB"      for 99,999,999
col "Free MB"      for 99,999,999
col "Total MB"     for 99,999,999

select df.TABLESPACE_NAME "Tablespace",
TOTALUSEDSPACE "Used MB",
(df.TOTALSPACE - tu.TOTALUSEDSPACE) "Free MB",
df.TOTALSPACE "Total MB",
round(100 * ( (df.TOTALSPACE - tu.TOTALUSEDSPACE)/ df.TOTALSPACE))
"Pct. Free"
from
(select TABLESPACE_NAME,
round(sum(BYTES) / 1048576) TOTALSPACE
from DBA_DATA_FILES
group by TABLESPACE_NAME) df,
(select round(sum(BYTES)/(1024*1024)) TOTALUSEDSPACE, TABLESPACE_NAME
from dba_segments
group by TABLESPACE_NAME) tu
where df.TABLESPACE_NAME = tu.TABLESPACE_NAME order by 1;

_____________________________________________________________________________________


SESSIONS
========
column USERNAME format a20
column OSUSER   format a15
column PROGRAM  format a30
  
select username, to_char(logon_time,'YYYY-MM-DD_HH24:MI:SS'), osuser, program, sid, serial#
from v$session
where username <> ' ';

_____________________________________________________________________________________