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 to update salary of employees department wise?
what are the different type of normalization? : Sql dba
What is procedure explain with example?
What is a natural join sql?
How do I write a sql query in pgadmin 4?
What is the difference between RDBMS and DBMS?
20 Answers Practical Viva Questions, Sapient, Stag Computers,
What is trigger in pl sql?
Is it possible to pass parameters to triggers?
how to connect oracle in unix prompt?
How does sql developer connect to oracle database?
What are the popular database management systems in the it industry?
How can you create an empty table from an existing table?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)