Oracle DBA Checklist/Tasks

1) Proper Documentation which is very important in order to save time and act on issue immediately.2) DB health check list for Day to Day Activities. –> Check Alert log–> Tablespaces–> Archivelog cleanup script–> Check OS Watchers scripts are running or not.–> Setup cronjob for… Read More

Partition

                                                            PARTITIONING PARTITIONS :         Dividing  the large tables into small tables known as partitions Partition of single table can go in two different tablespaces Sorting can be done by partitioning thus we not require temporary tablespace Partition can be independently managed Backup and recovery… Read More

Oracle : Partitioning using online Redefinition method which requires minimal downtime

spool DEPT_NonPart_to_Part.logset timing onset time onset echo on conn SCOTT/PW –> Very Importantshow user –> Create DEPT_PART table (with partitions) EXEC DBMS_STATS.gather_table_stats(user, ‘DEPT’, cascade => TRUE);SELECT num_rows FROM user_tables WHERE table_name = ‘DEPT’; EXEC DBMS_STATS.gather_table_stats(user, ‘DEPT_PART’, cascade => TRUE);SELECT num_rows FROM user_tables WHERE table_name =… Read More