Interested to Buy Any Domain ? << Click Here >> for more details...
What are the components of SGA?
- 5 Answers
- 6376 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 |
How will you monitor the space allocation ?
What is an Oracle SYSTEM tablespace and when is it Created?
What Does DBWR do?
What is the role of PCTFREE parameter is Storage clause ?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
What are the components of SGA?
What is dictionary cache ?
What is the maximum number of Lock Processes used?
How will you swap objects into a different table space for an existing database?
What are the functions of SMON?
Diference between Oracle 9i and 10G.
What is meant by redo log buffer ?
Oracle General 
