What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
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 |
What to do if the binary spfile is wrong for the default instance?
Which is faster join or subquery in oracle?
Does a Before form trigger fire when the parameter form is suppressed ?
i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID
How to use like conditions in oracle?
what are the different types of cursors? explain?
What is oracle datasource?
3. Display all the client numbers in the ORDER table. Remove duplicates.
What is a Redo Log ?
Explain the use of full option in exp command.
How to delete multiple rows from a table in oracle?
What is oracle update statement with inner join ?