What are the components of SGA?
- 5 Answers
- 5040 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 are disadvanteges of having raw devices ?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
How many Dispatcher Processes are created?
How the space utilisation takes place within rollback segments?
What is the functionality of SYSTEM table space ?
What is Database Buffers ?
What is PGA?
List the Optional Flexible Architecture (OFA) of Oracle database ?
What is Dedicated Server Configuration?
What is the maximum size of a row in oracle 9i?
4 Answers Baidu, HCL, Yashu Systems,
When will be a segment released?
What is the OPTIMAL parameter ?
Oracle General 
