Nothing but my learning and experience with Oracle..!

When we SELECT * from V$SGA (or show sga), we get the values of Fixed Size, Variable Size, Database Buffers and Redo Buffers. For e.g, ...

If you need to recover your database to a point in time by scn, sequence or time, you can use the following query to see the relation betw...

Oracle Clusterware services in a Windows RAC environment should be allowed to start automatically, ideally, with the help of the Oracle Pro...

An incomplete recovery is a type of recovery in which only a part of redo log , archive log data are applied to a restored backup in order ...

what is granules in sga ? With the dynamic SGA infrastructure, the size of the buffer cache, the shared pool, the large pool, and the pro...

Automatic Shared Memory Management in Oracle 10g Oracle instance in memory consists of two major areas SGA (system/shared global area...