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 |
difference between bind variable and variable
What are various constraints used in SQL?
pls explain connect by prior with example and its real time use
Is oracle a programming language?
i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
what is difference between sql plus and sql*plus? (not sql and sql plus).
What is parameterized cursor in oracle?
what is the syntax of update command?
What is DTS and purpose of DTS ?
How to do clean up if create database failed?
What is recovery manager(rman) backup in Oracle?
What is BBED in Oracle?