One of my readers today send me an error they got while restoring a database via RMAN RMAN> startup mount;…
Tag 11gR2
A production database of showed 4 cores of CPU burning constantly by 2 process E000 and E001. On further investigation…
ORA-00245: control file backup failed; target is likely on a local file system RMAN-08132: WARNING: cannot update recovery area reclaimable…
prompt ************************************ prompt **** ASH OVERALL WAIT PROFILE prompt ************************************ set lines 999 SELECT MIN(sample_time) min_ash_available,sysdate-MIN(sample_time) available duration FROM v$active_session_history;…
SQL> ALTER TABLE MOVE PARTITION COMPRESS FOR QUERY LOW PARALLEL 8; SQL> ALTER TABLE MOVE PARTITION COMPRESS FOR QUERY HIGH…
http://gavinsoorma.com/2012/11/ash-and-awr-performance-tuning-scripts/
Install and Configure Oracle Application Express Apex 5.0, 4.2.6, 4.2.x with Embedded PL/SQL Gateway
1. Download Software as Zip file from OTN http://www.oracle.com/technetwork/developer- tools/apex/downloads/index.html 2.Unzip apex_5.0_en.zip Software to ORACLE_HOME directory, it will create a…
Since it was announced in Early 2010 that Oracle GoldenGate will be the RoadMap for Replication for Oracle Database, The…
— Get DDL from impdp — The below command will not import the dump, but will just create a .sql…
For running a single SQL Command via sqlplus on multiple servers, we have to first do a few pre-requisites 1.…
We had an interesting scenario where we did a full rman refresh of a standby database becuase the archivelogs went…
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor TNS-12541: TNS:no listener TNS-00511: No listener ERROR: ORA-12560:…
This error comes when running ggsci on a linux or unix platform. Generally it is due to wrong setting of…
CREATE TABLE REPLICATION USING MATERIALIZED VIEWS ————————————————- SOURCE TABLE : LOG_RECORD TARGET TABLE : LOG_RECORD_UPD We have a large table…
Query to find out size of the 10 Largest Tables sitting inside an Oracle database which is greater than 1GB…
Suppose you have a query result and want to concatenate a string to that output for better readibility, it can…
Sometimes it is required to find the largest tables residing in your database. It helps to identify candidates for table…
SQL Query to check size of Table — Check Size in GB SELECT bytes/1024/1024/1024 FROM USER_SEGMENTS WHERE SEGMENT_NAME in (‘TABLE1′,’TABLE2’);…
######### ERROR ##### DGM-17016: failed to retrieve status for database ORA-16664: unable to receive the result from a database DGMGRL>…
We will create 2 standby databases from a single RAC primary database. 11gR2 allows upto 30 standby databases. The most…
1. Install Latest OPatch clients from support.oracle.com – As Grid User — unzip p6880880_112000_SOLARIS64.zip -d $ORACLE_HOME ##Replace All – As…
Primary is a 2 node-rac cluster with instances swx1 and swx2 running on ASM. A service called swxscan is created…
Many a times to save cost in building a DR solution for a certain application; you have to create a…
We had a new Oracle installation on an AIX 6.1 Power7 server. Our organization doesn’t have an AIX admin. So…