Query to get the baseline for an sql id
Please use below query. col sql_text for a60 wrap set verify off set pagesize 999 set lines 155 col username format a13 col prog format a22 col sid ...
Database
Insights and Experiences from Doyensys’ Database Administrators.
How to remove the Oracle OLAP Option from a 12c Database during 19c Upgrade
Check the OLAP option is enabled in database. select parameter, value from v$option where parameter = ‘OLAP’; PARAMETER VALUE OLAP FALSE ...
RMAN Active Duplicate Fails with ORA-19837 ORA-19849 ORA-19850
RMAN active duplicate fails with error: RMAN-03002: failure of Duplicate Db command at 09/25/2018 08:24:05 RMAN-05501: aborting duplication of target ...
Useful CRSCTL Commands
STOP & START CRS: ( run from root user) $GRID_HOME/bin/crsctl stop crs $GRID_HOME/bin/crsctl start crs Enable/Disable auto restart of CRS. ...
Schedule Statspack Report Generation.
Declaration : In this scripts using for schedule statspack report generation for hourly, frequently and purge weekly snapshots. Statspack is instead of AWR ...
Query to get the baseline for an sql id
Please use below query. col sql_text for a60 wrap set verify off set pagesize 999 set lines 155 col username format a13 col prog format a22 col sid format 999 col child_number format 99999 ...
How to remove the Oracle OLAP Option from a 12c Database during 19c Upgrade
Check the OLAP option is enabled in database. select parameter, value from v$option where parameter = ‘OLAP’; PARAMETER VALUE OLAP FALSE select comp_id, comp_name, version, status, ...
RMAN Active Duplicate Fails with ORA-19837 ORA-19849 ORA-19850
RMAN active duplicate fails with error: RMAN-03002: failure of Duplicate Db command at 09/25/2018 08:24:05 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored ...
Useful CRSCTL Commands
STOP & START CRS: ( run from root user) $GRID_HOME/bin/crsctl stop crs $GRID_HOME/bin/crsctl start crs Enable/Disable auto restart of CRS. $GRID_HOME/bin/crsctl disable crs ...
Schedule Statspack Report Generation.
Declaration : In this scripts using for schedule statspack report generation for hourly, frequently and purge weekly snapshots. Statspack is instead of AWR because AWR report is licensed. ...
Create a New PL/SQL Library
The steps in this section will show you how to create a new PL/SQL library, then create a function that will live in this library. To create the library: Launch Reports Builder (or, if already ...
ORA 02049: Distributed Transaction Timeout waiting for lock
ORA 02049: Distributed Transaction Timeout waiting for lock This error occurs when a session is trying to modify a table’s row in a remote database through a database link that is already locked ...
ORACLE GOLDEN GATE ERROR OGG-00868
In this tutorial, we are going to learn about, “How to resolve this ERROR OGG-00868″ I got the below type of error while re-start the replicat in golden gate. I have a workaround and ...
ASM Instance cloning using RMAN in same host
Description: In this article step by step Cloning the asm instance in same host.Earlier we use to clone database using rman backup. After adding the database service entry and restore the ...
How to fix INVALID status for RAC component in dba_registry
Before upgrade or after upgrade, database may show INVALID status for component Real Application Clusters in dba_registry as below . SQL> select comp_name,version,status from ...