Shift handover report, it contains pending request.
1) Oracle Database instance is running or not
2) Database Listener is running or not.
3) Check any session blocking the other session
4) Check the alert log for an error
5) Check is there any dbms jobs running & check the status of the same
6) Check the Top session using more Physical I/O
7) Check the number of log switch per hour
8) How_much_redo_generated_per_hour
9) Run the statpack report
10) Detect lock objects
11) Check the SQL query consuming lot of resources.
12) Check the usage of SGA
13) Display database sessions using rollback segments
14) State of all the DB Block Buffer
15) Check for the invalid objects and recompile.
16) Verify the success of archive log backups, based on the backup interval.
17) Monitoring space Availability
18) Check tablespaces should not be used more that 75%.
19) Viewing the Alert log file to analyze the ORA errors if any.
20) Check all last night backups were successful.
21) Most Important - Check your oracle license and do not run/execute/create anything beyond the oracle license policy.
To Find out the total size of the DB and Database growth weekly/monthly for future
necessary space arrangements
select( select sum(bytes)/1024/1024/1024 data_size from dba_data_files ) +( select nvl(sum(bytes),0)/1024/1024/1024 temp_size from dba_temp_files ) +( select sum(bytes)/1024/1024/1024 redo_size from sys.v_$log ) +( select sum(BLOCK_SIZE*FILE_SIZE_BLKS)/1024/1024/1024 controlfile_size from v$controlfile) "Size in GB" from dual;
Query to find the 10 Largest Objects in DB:
============================================
select * from (select SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024/1024 GB,TABLESPACE_NAME from dba_segments order by 3 desc ) where rownum<= 10;
1) Oracle Database instance is running or not
2) Database Listener is running or not.
3) Check any session blocking the other session
4) Check the alert log for an error
5) Check is there any dbms jobs running & check the status of the same
6) Check the Top session using more Physical I/O
7) Check the number of log switch per hour
8) How_much_redo_generated_per_hour
9) Run the statpack report
10) Detect lock objects
11) Check the SQL query consuming lot of resources.
12) Check the usage of SGA
13) Display database sessions using rollback segments
14) State of all the DB Block Buffer
15) Check for the invalid objects and recompile.
16) Verify the success of archive log backups, based on the backup interval.
17) Monitoring space Availability
18) Check tablespaces should not be used more that 75%.
19) Viewing the Alert log file to analyze the ORA errors if any.
20) Check all last night backups were successful.
21) Most Important - Check your oracle license and do not run/execute/create anything beyond the oracle license policy.
To Find out the total size of the DB and Database growth weekly/monthly for future
necessary space arrangements
select( select sum(bytes)/1024/1024/1024 data_size from dba_data_files ) +( select nvl(sum(bytes),0)/1024/1024/1024 temp_size from dba_temp_files ) +( select sum(bytes)/1024/1024/1024 redo_size from sys.v_$log ) +( select sum(BLOCK_SIZE*FILE_SIZE_BLKS)/1024/1024/1024 controlfile_size from v$controlfile) "Size in GB" from dual;
Query to find the 10 Largest Objects in DB:
============================================
select * from (select SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024/1024 GB,TABLESPACE_NAME from dba_segments order by 3 desc ) where rownum<= 10;
