One simple health check for oracle with sql(二)
STEM';
select count(*) invalid_num from dba_objects where status='INVALID';
col owner for a16
col object_name for a30
col object_type for a16
set line 100
set pagesize 10000
select owner,object_name,object_type from dba_objects where status='INVALID';
col table_name for a30
col tablespace_name for a20
set line 100
select owner, table_name, tablespace_name, chain_cnt from dba_tables where chain_cnt >
0;
select OWNER||'.'||index_name as "OWNER.INDEX_NAME", blevel from dba_indexes where blevel>=4 order by 2 desc;
col username for a16
select * from v$pwfile_users;
col GRANTEE for a20
col GRANTED_ROLE for a20
Select * from dba_role_privs where granted_role='DBA';
select event,count(*) from v$session_wait group by event;