Let’s take the employees database, and slightly modify the employees tables: mysql> ALTER TABLE employees ADD INDEX idx_first (first_name),ENGINE=InnoDB; 1 SELECT * FROM employees ORDER BY…
Read MoreI will explain How to Add Disks to ASM Disk Group in Oracle with ALTER DISKGROUP DATA ADD DISK Command in this post. You can add disks to ASM Disk…
Read MoreI will explain How to Use TABLE_EXISTS_ACTION During IMPDP in Oracle Datapump in this post. Table_exists_action: While Import process is running if any table exists in database what will Oracle do…
Read MoreTo manage Oracle database’s storage, Oracle recommends The Automatic Storage Management (ASM) to be used regardless of database’s configuration: single-instance Oracle Database or Oracle Real Application Clusters configurations. It is…
Read MoreI will explain How to Use CONTENT ( DATA_ONLY , METADATA_ONLY ) Parameter in Oracle Datapump CONTENT: This parameter enables you to filter what is export and import during the…
Read MoreFlashback must be turned on in order to be able to use Guaranteed Restore Point. To enable Flashback, we need to use the FRA parameter like following. SQL> show parameter…
Read MoreCause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit…
Read MoreBlock Change Tracking : * Block Change Tracking Feature is used to speed up the RMAN incremental backup. *After Enabling this feature the records modified since the last…
Read MoreFlashback Data Archive feature is very much loved by Oracle DBA’s and it is come with Oracle 11g. The purpose of Flashback Data Archive is to store all DML and…
Read MoreAt the time of stuck threads we will get alerts we can see the servers are in warning state at the the time we can login to the particular warning…
Read More