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 trigger and what are its types?
Explain oracle’s system global area (sga).
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
What is raw datatype in oracle?
How many types of tables are there in oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
How to delete multiple rows from a table in oracle?
How to assign data of the deleted row to variables?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How to delete an existing row from a table in oracle?
What is system tablespace?