1 min read
In case if we want to identify duplicates rows of a table and want to remove them from a table. ...
Scripts
1 min read
4 min read
SAR is used to collect, report or save system activity. SAR stands for System Activity Report. SAR is used to...
1 min read
Automate RMAN Backup using Shell Script In a real environment, you will not manually trigger all the Oracle database backups....
2 min read
Backup of the Oracle home can be taken using any preferred method. You can use any tool such as zip,...
5 min read
A profile is a collection of attributes that apply to a user.The profile is used to enable a single point...
6 min read
Many people ask these Questions, Q. How to identify which column is candidate for Index creation? Q. How to determine...
2 min read
This content is password protected. To view it please enter your password below: Password:
1 min read
RMAN> show all; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; RMAN> CONFIGURE RETENTION POLICY TO NONE; The REDUNDANCY...
8 min read
Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performance, manageable backup and recovery, for all Oracle data formats....
9 min read
Check the status of the cluster $ crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready...
4 min read
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...
2 min read
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 >...
2 min read
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...
