Wat is SGA ?
Answers were Sorted based on User's Feedback
Answer / swapneswar
system global area(SGA) is a shared memory regionallocated
by ORACLE that contains data and control information for
one ORACLE instance
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / mohit lalwani
SGA known as System Global Area and is a part of the Oracle instance.
SGA consist of different memory structures which are
-Shared pool (mandatory)
-Database Buffer Cache (mandatory)
-Redo Log Buffer (mandatory)
-Large Pool (optional)
-Java Pool (optional)
-SGA is sized by sga_max_size
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / narayan mishra
->SGA stands for System Global Area.
->it store the data and control information for oracle srever.
->it can be shared by database processes.
Is This Answer Correct ? | 2 Yes | 0 No |
How do I run sql profiler?
Is left join same as inner join?
Do view contain data?
What is count * in sql?
Can we use out parameter in function?
select 1,col1,col2 from table1. output?
Is sql a microsoft product?
How to connect a sql*plus session to an oracle server?
How to run sql functions in pl/sql?
What is nvl function?
what are rollup and cube in t-sql? : Transact sql
what is a constraint? : Sql dba