What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
- 1 Answers
- 4378 Views
- TCS, I also Faced
- E-Mail Answers
Answer / sawant
The System Global Area in a Oracle database is the
area in memory to facilitates the transfer of information
between users. It holds the most recently requested
structural information between users. It holds the most
recently requested structural information about the database.
The structure is Database buffers, Dictionary cache, Redo
Log Buffer and Shared SQL pool (ver 7.0 only) area.
| Is This Answer Correct ? | 2 Yes | 0 No |
Explain what are clusters?
Do View contain Data ?
How to get last row id?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How to calculate date and time differences in oracle?
Why cursor variables are easier to use than cursors?
Why is oracle database so popular?
why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?
What is a partition in oracle?
25. Display the client number and the value of the highest value order placed by that client.
How to restrict the duplicate records in table valuesets
What is DTS and purpose of DTS ?
Oracle General 
