CREATING MAINTENANCE PLAN FOR BACKUP
A maintenance plan is a set of measures (workflows) taken to ensure that a database is properly maintained and routine backups are scheduled and handled. Login to the server Go…
Read MoreDatabase Migration from Non-ASM to ASM
We are going to convert our oracle Database to be migrated from Non ASM to ASM storage using RMAN commands Check the ASM instance is up and running If not…
Read MoreORACLE OS WATCHER
What is oracle OS watcher? Oracle OS watcher is collects and stores as archives operating system and network metrics that you can use to diagnose performance issues. OSWbb operates as…
Read MoreTABLE REORGANIZATION
Precheck in table and index level: Step 1: Check the Table size and Index size select segment_name,TABLESPACE_NAME ,segment_type, bytes/1024/1024/1024 size_gb from dba_segments where segment_name = ‘&segment_name’ or segment_name in (select index_name…
Read More