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 to the [...]

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 start the ASM instance and begin the [...]

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 a set of [...]

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 [...]