Nothing but my learning and experience with Oracle..!

Learn about oracle Cursor with example A cursor is a pointer, which points towards a pre-allocated memory location in th SGA. The memor...

How to  Master-Slave replication in mysql  First you have to configure /etc/my.cnf in both master and slave server, 1.Master server conf...

New features in Oracle database 11g in AMM , data guard , expdp , rman etc 1.New features in Auotmatic memory management (AMM)  Oracle s...

When considering the availability of the Oracle database, Oracle RAC 11g provides a superior solution with its advanced failover mechanism...

PGA_AGGREGATE_TARGET concept In order to  understand About PGA_AGGREGATE_TARGET parameter let’s have a look at parameter *_AREA_SIZE . S...

Standard Edition RAC option free Maximum two nodes Maximum four CPUs Must use Oracle Clusterware Must use Automatic Storage Management...

Oracle 9i RAC OPS (Oracle Parallel Server) was renamed as RAC CFS (Cluster File System) was supported OCFS (Oracle Cluster Fil...