Interested to Buy Any Domain ? << Click Here >> for more details...
What are the components of SGA?
- 5 Answers
- 6555 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 the function of Redo Log in Oracle?
What is the maximum number of Lock Processes used?
Can a Tablespace hold objects from different Schemes in Oracle?
What is an Oracle Rollback Segment?
What is function of RECO?
What is the function of Dispatcher (Dnnn)?
How will you force database to use particular rollback segment?
When does LGWR write to the database?
Which parameter in Storage clause will reduce no. of rows per block?
What are the uses of Oracle Rollback Segment?
What does LGWR do?
what is ORACLE MEMORY STRUCTURES
Oracle General 
