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 is a lookup table in oracle?
How to create a testing table in oracle?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
What is a OUTER JOIN?
How do we switch from init.ora file to asp file?
What is an Index ?
What is the difference between "as" and "is" in an oracle stored procedure?
What are group functions in oracle?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
Explain an exception and its types?
What is the quickest way to export a table to a flat file?