Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key


Play button


Play button




Click to flip

11 Cards in this Set

  • Front
  • Back
What is SGA?
An Oracle Server Instance is made up of Oracle's main memory structure, called the System Global Area.
The Server Processes communicates with SGA when the user accesses the data in the database.
What are the components of SGA?
1-Shared Pool
2-Database Buffer Cache
3-Redo Log Buffer
4-Java Pool
5-Large Pool
6-Streams Pool
Describe Shared Pool?
Shared Pool caches the most recent SQL issued by the user.
It uses LRU (Least Recently Used algorithm)to manage the contents
Describe Database Buffer Cache?
Caches the data that has been most recently accessed by the users.
It uses LRU (Least Recently Used algorithm)to manage the contents
Describe Redo Log Buffer?
It stores information for the recovery process.
Describe Large Pool?
Caches Data for large operations such as Recovery Manager backup and restore activities and Shared Server Component.
Describe Streams Pool?
Caches the Data stored with Queued message request when Oracle Advance Queuing option is used.
What is the unit of SGA memory space?
Granules can be 4MB, 8MB or 16MB Sizes.
How many types of Parameter files are their?
2 Types
1- PFILES Parameter Files
2- SPFILES Server Parameter Files.
Both of these files can be used to configure instance and database options including the size of SGA and its components if manual SGA management is being used.
What are the differences between PFILE and SPFILE?
1- Its a text file
2- Instance need to be shutdown and restarted in order to get the changes.
3- Naming Convention initinstance name.ora
4- It can be created from SPFILE using create PFILE command.

1- its a binary file.
2- Most changes can be made dynamically when the instance is up and running.
3- The naming conventions are spfileinstance name.ora
4-Can be created from PFILE by using create SPFILE command.
What dynamic performance view can be used to examine SGA?
SQL>select * from V$SGA;
For looking into the SGA Components.
SQL>select components, current_size from v$sga_dynamic_components;