Pages

▼
Wednesday, September 4, 2013

Partitioning an existing table using datapump - a sample demo

›
First create a sample  table for testing purpose,  SQL>CREATE TABLE big_table (   id            NUMBER(10),   created_date  DATE,   ...
Tuesday, September 3, 2013

Oracle Cluster tables - an efficient way to reduce the I/O

›
If you two are more tables are joined together on a single column and most of the time you issue join queries on them, then consider creati...
Friday, August 23, 2013

Installing Oracle 10g RAC on Oracle VM in windows 2008 using openfiler as shared storage

›
Dear friends those who interested in knowing more about RAC architecture , they need to prepare one RAC system for their study purpose.Here...
2 comments:
Wednesday, August 14, 2013

Different types of Failover mechanism in Oracle

›
FAILOVER:  In the context of Oracle Net, failover refers to the mechanism of switching over to an alternate resource when connection to th...
Tuesday, August 13, 2013

How load balancing works in oracle ?

›
Load Balancing Oracle RAC systems provide two types of load balancing for automatic workload management: * Server load balancing distrib...
Tuesday, May 14, 2013

Data Guard Protection Modes and redo transport modes in oracle

›
Log Transport Services enables and controls the automated transfer of redo data within a Data Guard configuration from the primary site to ...
1 comment:
Tuesday, April 30, 2013

Detailed information on different methods of generating explain plan

›
Whenever an SQL statement is executed, Oracle (that is the RBO or CBO) designs an execution plan for it.  This execution plan is basically ...