What are the components of SGA?
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 Database Buffers ?
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
What is use of Rollback Segments In Database ?
What is hit ratio ?
What is the function of ARCH?
What is PGA?
How to find the SGA Size
What is meant by free extent ?
What is dictionary cache ?
What is the role of PCTFREE parameter is Storage clause ?
What do Redo Log Buffers contain?
How does Space allocation table place within a block ?