Database Performnace monitoring
set pagesize 1000 SET LINESIZE 110 col COMP_ID format A9 col COMP_NAME format A40 col STATUS format A15 col VERSION format A12 col owner format a30 col object_name format a30 col object_type format a30 SPOOL DB_DD_CHECK.TXT /* Database identification */ select NAME, PLATFORM_ID, DATABASE_ROLE from v$database; select * from V$version where banner like 'Oracle Database%'; select INSTANCE_NAME, to_char(STARTUP_TIME,'DD/MM/YYYY HH24:MI:SS') "STARTUP_TIME" from v$instance; /* Database Component Registry status */ select comp_id, comp_name, status, version from dba_registry; /* Level of patch in the database */ select * from dba_registry_history; /* INVALID objects count, by type & in detail */ select count(*) "INVALID Objects Count" from dba_objects where status !='VALID'; select owner, object_type, count(*) from dba_objects where status !='VALID' group by owner, object_type order by owner, object_type; select owner, object_type, obje...