Oracle Database Administration

set lines 134 set pages 250 spool /home/oracle/scripts/logs/list_catalog_backup.log; select DB NAME,dbid,NVL(TO_CHAR(max(backuptype_db),'DD/MM/YYYY HH24:MI'),'01/01/0001:00:00') DBBKP, NVL(TO_CHAR(max(backuptype_arch),'DD/MM/YYYY HH24:MI'),'01/01/0001:00:00') ARCBKP from (select a.name DB,dbid, decode(b.bck_type,'D',max(b.completion_time),'I', max(b.completion_time)) BACKUPTYPE_db, decode(b.bck_type,'L',max(b.completion_time)) BACKUPTYPE_arch from rc_database a,bs b where a.db_key=b.db_key and b.bck_type is not null and b.bs_key not in(Select bs_key from rc_backup_controlfile where AUTOBACKUP_DATE is not null or AUTOBACKUP_SEQUENCE is not null) and b.bs_key not in(select bs_key from rc_backup_spfile) group by a.name,dbid,b.bck_type ) group by db,dbid order by least(to_date(DBBKP,'DD/MM/YYYY HH24:MI'),to_date(ARCBKP,'DD/MM/YYYY HH24:MI')); SELECT db_name, input_type, status, to_char((start_time),...

Database size  col "Database Size" format a20  col "Free space" format a20  col "Used space" format a20  select round(sum(used.bytes) / 1024 / 1024 / 1024 ) || ' GB' "Database Size"   , round(sum(used.bytes) / 1024 / 1024 / 1024 ) -   round(free.p / 1024 / 1024 / 1024) || ' GB' "Used space"   , round(free.p / 1024 / 1024 / 1024) || ' GB' "Free space"   from (select bytes   from v$datafile   union all   select bytes   from v$tempfile   union all   select bytes   from v$log) used   , (select sum(bytes) as p   from dba_free_space) free   group by free.p   / This script will display a list of Oracle invalid objects: break on c1 skip 2 set pages 999 col c1 heading 'owner' format a15 col c2 heading 'name' format a40 col c3 heading 'type' format a10 ttitle 'Invalid|Objects' select     owner       c1,     object_type c3,...