Friday, June 25, 2010

Find the Size of Schema in Database

Below query will help you out in finding the size of the schema in database


Select sum(bytes)/1024/1024/1024 GB, tablespace_name from dba_segments where owner='XXXXX' group by tablespace_name
NEED TO REPLACE XXXXX WITH THE SCHEMA NAME THAT NEEDS TO BE EXPORTED

Wednesday, June 9, 2010

What is Internode Sync in RAC environment?

Internode sync is critical in RAC environment because it maintain proper co-ordination between processes on different nodes, preventing them from changing the same resource at the same time.

Internode sync guarantees that each instance see the most recent version of a block in its buffer cache.

This is the reason of having a necessity of Global Resources in RAC Environment

For more details read: Global Resources Topic in Oracle RAC.

Tuesday, June 8, 2010

Message - FIFA 2010 Begins this week...

Hello Friends,


Very much happy to see that FIFA 2010 begins this week on 11th June 2010.


It is one of my favourite game that I use to play during my school days. Below is the schedule of the same.


http://www.fifa.com/worldcup/matches/index.html