Read More
Click to enlarge
Oracle November 28, 2011 1

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…

Oracle June 15, 2011 2

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…

Oracle June 10, 2011 0

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 May 16, 2011 0

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…

Oracle April 13, 2011 0

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…

Oracle March 15, 2011 0

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…

Oracle, Oracle Database December 1, 2010 1

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>…

Oracle November 29, 2010 0

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…

Oracle November 1, 2010 0

Types of SQL Statements

A Data Manipulation Language (DML) is a family of computer languages used by computer programs and/or database users to…

Oracle, Oracle SOA Suite October 18, 2010 15

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…

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.