Interested to Buy Any Domain ? << Click Here >> for more details...
What are the components of SGA?
- 5 Answers
- 6542 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 |
Diference between Oracle 9i and 10G.
What is the maximum number of Lock Processes used?
What is meant by redo log buffer ?
What is an Integrity Constrains in Oracle?
What is the maximum size of a row in oracle 9i?
4 Answers Baidu, HCL, Yashu Systems,
What is an Oracle Data Segment?
What is the function of Lock (LCKn) Process?
What are the components of SGA?
Teradata: How can we know the indexed column in a table?
What is Shared Pool?
When will be a segment released?
What are the functions of SMON?
Oracle General 
