Oracle
Installing Oracle RAC 11gR2 on Linux 64bit
Yet another way of installing Oracle RAC 11gR2 This tutorial shows how to install Oracle RAC 11gR2 on Linux 64bit with NAS…
Moving SPFILE from file system to ASM (ORACLE RAC11g)
There are two nodes in oracle RAC database [rac1] and [rac2] Below tasks has to be executed from the first node…
How to multiply control files in Oracle DB RAC 11g
This examle shows how to multiply control files in Oracle Database RAC 11g. An example cluster database racdb1 is up and…
Oracle DBA Interview Questions Answered: Technical
View Also: Oracle DBA Interview Questions Answered: UNIX 60 Oracle Database Administration (DBA) Interview Questions (Technical) 1. What is an Oracle…
Copy SQL Profiles to another Oracle database
Copying SQL Profiles from one database to another involves the following steps: Creating a staging table to store the SQL Profiles…
Physical Logical Oracle Database Limits
Physical Oracle Database Limits Item Type of Limit Limit Value Database Block Size Minimum 2048 bytes; must be a multiple of operating…
DBMS_STATS in an Oracle Database
DBMS_STATS in an Oracle Database Using DBMS_STATS package to gather Oracle dictionary statistics. 1. To gather table statistics with DBMS_STATS SQL>…
A very cool dollar view V$SESSION_LONGOPS
V$SESSION_LONGOPS view This view displays the status of various operations that run for longer than 6 seconds (in absolute time). These…
Types of SQL Statements
A Data Manipulation Language (DML) is a family of computer languages used by computer programs and/or database users to…
Delete large numbers of instances in Oracle SOA Suite 11g
Purging composites instances in Oracle SOA SUITE 11g There are several ways to purge large amounts of instances in SOA Suite…