Oracle database memory structures info

There are 2 different types of memory structures in Oracle database.

1. System global Area(SGA)
     
   Group of shared memory structures known as SGA, it contains data and control information for  
   one Oracle database instance.SGA is shared by all server and backgroupd processes.

   Group of  shared memory structures has below memory block:

   a) Shared Pool
   b) Buffer Cache
   c) Keep Buffer Pool
   d) Redo Log buffer
   e) Recycle Buffer Pool
   f) Large pool
   h) Java Pool
   i) Streams Pool
   j) nK buffer cache

2. Program global Area (PGA)

Memory regions that contains the data and information control of a single background process. PGA is      non shared memory created by Oracle dB when a server or background process is started, acces to the  VGA is exclusive to the process and each process has its own PGA created.

   PGA has 2 major areas called :

   a) Stack space
   b) User global Area (USA)

What do Grid Controller does?

Grind Controls let us to do below tasks:

1. Manage entire stack of software
2. Provisioning Users
3. Cloning Databases
4. Managing patches
5. Monitor Performance of application
6. View perfomance and availability of all in grid
7. Grouping hardware,databases and application servers as a whole single unit and it will be easy to manage as a group.

What does grid computing technology has or included?

1. Auto Storage management(ASM)
2. Real Application clusters(RAC)
3. Application Server Clusters(ASC)
4. Enterprise manager grid Control

What is grid computing in Oracle?

Oracle has created the grid computing infrastructure where it balances all types of workloads across servers and
lets us to manage all servers as one complete system.