Interested to Buy Any Domain ? << Click Here >> for more details...
Wat is SGA ?
- 3 Answers
- 8258 Views
- ABB, I also Faced
- E-Mail Answers
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 create temparary sequence
how to fetch alternate records from a table? : Sql dba
i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject
what is the difference between delete and truncate statement in sql? : Sql dba
how is myisam table stored? : Sql dba
how is exception handling handled in mysql? : Sql dba
what is datawarehouse? : Sql dba
What is the purpose of a secondary key?
What does subquery mean in sql?
what are Dynamic SQL statements?
What is the difference between delete, truncate and drop command?
Can we use view in stored procedure?
-
Oracle (3253) - 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)
