In case if we want to identify duplicates rows of a table and want to remove them from a table. ...
Scripts
SAR is used to collect, report or save system activity. SAR stands for System Activity Report. SAR is used to...
Automate RMAN Backup using Shell Script In a real environment, you will not manually trigger all the Oracle database backups....
Backup of the Oracle home can be taken using any preferred method. You can use any tool such as zip,...
A profile is a collection of attributes that apply to a user.The profile is used to enable a single point...
Many people ask these Questions, Q. How to identify which column is candidate for Index creation? Q. How to determine...
This content is password protected. To view it please enter your password below: Password:
RMAN> show all; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; RMAN> CONFIGURE RETENTION POLICY TO NONE; The REDUNDANCY...
Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performance, manageable backup and recovery, for all Oracle data formats....
Check the status of the cluster $ crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready...
1) Information of database (Primary & Standby). SQL> SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; 2) To...
Oratop is a text based user interface tool similar to top command for monitoring basic database operations in real time...
Adding partitions 11g/12c -- SYNTAX : ALTER TABLE <SCHEMA_NAME>.<TABLE_NAME> ADD PARTITION <PARTITION_NAME> VALUES LESS THAN < HIGH_VALUE> TABLESPACE <TABLESPACE_NAME >...
Useful views to get index details: dba_indexes dba_segments dba_ind_columns dba_ind_partitions user_indexes user_segments user_ind_columns user_ind_partitions Query to check Index on a...