General Oracle DB Check And Recommendation

 General DB Check And Recommendation

------------------------------------------------

Database Configuration Analysis

------------------------------

1 Optimize Redo Logs

2 Table Partitioning for Big table

Database Performance Analysis.

--------------------------------

3 Check Stale Statistics for Tables

4 Check Fragmented Tables/ Index

5 Check Statistics for SYS tables

6 Check User objects in SYSTEM tablespace 

7 Check Un-indexed foreign keys  

select * from (

select ct.table_name, co.column_name, co.position column_position

from user_constraints ct, user_cons_columns co

where ct.constraint_name = co.constraint_name

and ct.constraint_type = 'R'

minus

select ui.table_name, uic.column_name, uic.column_position

from user_indexes ui, user_ind_columns uic

where ui.index_name = uic.index_name

)

Best Practices

-----------------

8 use Switchover Verify during switch over  

9 Check Temp file mismatch on nodes  

10 OS Watcher need to be installed on each node  

11 Backup Table Deletion from Database

12 Block Corruption Check  

13 Purge Recyclebin regularly

14      check Hardparsing for SQL

Other Recommendation

---------------------

15 check Compatibility parameter

16 Check Sequence Cache

17 DOP Removal from object

18 Check Invalid Object 

19 Check AWR Rentention

20 Check Datafiles count in each Tablespace 

21 Table space usages

22 Undo TS Mismatch on each node  

23 Puging for large table  

24 ASM Space usages  

25 Unusable Indexes

26 Invisible indexes

27 Check Default Degree for table

28      Check ORA-ERRORS in alert log

30 Check Auto extensible for datafiles

31 Check Redo Transport Destination

32 set hidden _use_single_log_writer value to  true if it is not set

33 check archive_lag_target parameter