ENABLE_DDL_LOGGING In Oracle 12c This ENABLE_DDL_LOGGING parameter has been introduced in oracle 12c. Enable the parameter: SQL> show parameter enable_ddl_logging NAME TYPE VALUE ———————————— ———– —————————— enable_ddl_logging boolean FALSE…
Read MoreHow To Drop SQL Baselines In Oracle 1.Get the sql_handle and sql_baseline name of the sql_id: SELECT sql_handle, plan_name FROM dba_sql_plan_baselines WHERE signature IN ( SELECT exact_matching_signature FROM gv$sql WHERE…
Read MoreOrapwd Tool For Password File In Oracle orapwd tool is used to create and manage password files. DEFAULT LOCATION FOR PWD FILE – $ORACLE_HOME/dbs Usage: orapwd file= entries= force=<y/n> asm=<y/n>…
Read MoreHow To Export And Import Statistics In Oracle For Table: PROD> exec dbms_stats.export_table_stats(ownname=>’SCOTT’, tabname=>’TEST’, stattab=>’STAT_TEST’, cascade=>true); PL/SQL procedure successfully completed. SQL> set lines 200 SQL> set pagesize 200 SQL>…
Read MoreHow To Add A Tempfile In Primary Database In Dataguard Adding tempfiles to TEMP tablespaces in primary database, will not automatically create on standby database. Because no redo is generated,…
Read MoreFlashback Primary Database In Dataguard Environment 1. Make sure both primary and standby databases have flashback enabled. – PRIMARY DB SQL> select name,database_role,flashback_on from v$database; NAME DATABASE_ROLE FLASHBACK_ON ——— —————-…
Read MoreIssue: On : 12.2.4 version, ISSUES WITH FUNCTIONALITY OF AD UTILITIES When attempting to run fs_clone after a successful clone the following error occurs. FSCloneApplyAppsTier_08081620.log shows +++++++++++++++++++++++++ configProperty id =…
Read MoreIssue: [STATEMENT] This request finished with an error and produced the following completion message: ORACLE error 6550 in FDPSTP Cause: FDPSTP failed due to ORA-06550: line 1, column 18: PLS-00802:…
Read MoreIssue: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool <POOL_NAME> to allocate to applications, please increase the size of the pool and retry.. Cause: This issue is due to leaked…
Read MoreIssue: Integration of IDCS with Weblogic (WLS) with 1 managed server <MANAGED_SERVERX> works fine. Created another managed server-2 with similar configurations and this is where the issue occurs and they…
Read More