Query to find out size of the 10 Largest Tables sitting inside an Oracle database which is greater than 1GB…
Tag 11g
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…
One of the best books I have read on Oracle database security.It skips all the basics like what is a…
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…
Problem —— Error on starting ASM from SQLPLUS or ASMCMD SQL> startup; ORA-01078: failure in processing system parameters ORA-29701: unable…
bash-3.2$ impdp system/***** directory=import_dir nologfile=y dumpfile=exp_swx_20092012.dmp full=y ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31640: unable to open…
The various security mandates these days required a lot of auditing on the database. Though there are a host of…
Occasionally you need to create a quick one node RAC setup for testing and one of the requirements is a…
SQL> conn / as sysdba Connected to an idle instance. SQL> startup mount ORACLE instance started. SQL> drop database; drop…
While trying to troubleshoot an application connectivity issue today along with a developer I faced an interesting situation. We had…
Working on creating a muti-master replication for a production system. Each database needs to be active and replicate changes back…
Oracle GoldenGate will now be more closely coupled with Oracle database. And it is by far the best heterogenous replication…
GoldenGate is touted by Oracle as its future for data replication. It will slowly phase out Oracle Streams and will…
// *Cause: The archiver process received an error while trying to archive // a redo log. If the problem is…
When a large number of records neds to be deleted from a table. If you do a normal delete it…
Recovery interrupted! Recovered data files to a consistent state at change 13507372 Fri May 11 20:11:09 2012 Errors in file…
Guaranteed Restore Points are a life-saver when it comes to Application changes.It can ensure that you can rewind the database…
I had a block corruption of my primary database, though we had a standby build we wanted to recover the…