What are the components of SGA?
- 5 Answers
- 5000 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / cspriyadba
SGA constists of
1)Shared Pool => Components
a)Library Cache
(Shared SQL Area/ & Shared PL SQL Area)
b)Dictionary cache
2)Database Buffer Cache
3)Redo Log Buffer
4)Large Pool
5)Java Pool
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / ravi dutta
shared pool (data dictionary and library cache), buffer
cache, redo log buffer
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / avdhesh yadav
SGA constists of
1)Shared Pool Components :=
a)Library Cache
(Shared SQL Area/ & Shared PL SQL Area)
b)Dictionary cache
2)Database Buffer Cache
3)Redo Log Buffer
4)Large Pool
5)Java Pool
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ashok
in 10g
shared pool
buffer cache
log buffer
java pool
large pool
streams pool
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / syed
sga componets are
1)Buffer cache
a)pin buffered
b)dirty buffer
c)free buffer
2)log buffer
3)shared pool
a)library cache
2) dicatonary cache
4)large pool
5)java pool
6)streams pool
7) fixed sga
| Is This Answer Correct ? | 0 Yes | 0 No |
What is meant by recursive hints ?
Can a Tablespace hold objects from different Schemes in Oracle?
How will you estimate the space required by a non-clustered tables?
How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
what is the role of archiever
What are the two types of Server Configurations?
What is the significance of having storage clause ?
How to find the SGA Size
Diference between Oracle 9i and 10G.
How will you swap objects into a different table space for an existing database?
How to find the current session sid
What is a Rollback segment entry ?
Oracle General 
