Best Practices while doing expdp and impdp activity

Best Practices while doing expdp and impdp activity in Oracle. 1) Check the size in Source database and Take the export of the schema/table. 2) If the request is to

OPatch apply failed with error code 73 in Oracle

OPatch failed with error code 73. Error code 73 Following executables are active : /home/oracle/product/11.2.0/lib/libclntsh.so.11.1 UtilSession failed: Prerequisite check “CheckActiveFilesAndExecutables” failed. Log file location: /home/oracle/product/11.2.0/cfgtoollogs/opatch/opatch2018-05-05_20-09-26PM_1.log OPatch failed with error code

Import Running longer time due to huge log switch

Import Running longer time due to huge log switch.   Issue:   For 56G schema it is taking 3 hours to import the data which is too slow. One of

To verify in the new project proposal doc.

What to verify in the new project proposal doc from DBA end? Suppose there is  database migration planned from Solaris to Linux. This is going to be a new project

Best Practices to do after joining new Company.

Best Practices to do after joining new company or taking new customer support responsibilities. We need to consider and do the below mentioned activities When you join in a new

Gather stats on Table in Oracle Database

  Gather stats on Table in Oracle Database. connect to CDB connect to PDB ALTER SESSION SET CONTAINER=PDB1; ALTER SESSION SET DB_FILE_MULTIBLOCK_READ_COUNT=2048; ALTER SESSION SET SORT_AREA_SIZE=512000000;   exec dbms_stats.gather_table_stats(ownname=>’ARP’,tabname=>’SUM_DETAIL’, estimate_percent=>100,

Oracle Database transparent gateway setup

Oracle Database transparent gateway setup Below are the steps to configure Oracle DB transparent gateway oratab entry [oracle@oralsrv admin]$ cat /etc/oratab|grep tgw tgw:/u00/app/oracle/product/12201/tghome:N [oracle@oralsrv admin]$ Template pwd=/u00/app/oracle/product/12201/tghome [oracle@oralsrv tghome]$ cat

Best practices/check list while doing DBA tasks

Best practices/check list while doing DBA tasks/changes.   Putty tool is widely used for Oracle Database administration activities. While using putty below are the best practises/check lists for implementing the