Category Archives: Memory Management Interview Questions

What are the different kind of export backups? | Memory Management Questions

Full back – Complete database Incremental – Only affected tables from last incremental date/full backup date. Cumulative backup – Only affected table from the last cumulative date/full backup date.

Posted in Memory Management Interview Questions | Leave a comment

List the factors that can affect the accuracy of the estimations? | Memory Management Questions

The space used transaction entries and a deleted record does not become free immediately after completion due to delayed cleanout. Trailing nulls and length bytes are not stored. Inserts of, updates to and deletes of rows as well as columns … Continue reading

Posted in Memory Management Interview Questions | Leave a comment

What is mean by Program Global Area (PGA)? | Memory Management Questions

It is area in memory that is used by a Single Oracle User Process.

Posted in Memory Management Interview Questions | Leave a comment

What is a Shared SQL pool? | Memory Management Questions

The data dictionary cache is stored in an area in SGA called the Shared SQL Pool. This will allow sharing of parsed SQL statements among concurrent users.

Posted in Memory Management Interview Questions | Leave a comment

What is SGA? How it is different from Ver 6.0 and Ver 7.0? | Memory Management Questions

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 … Continue reading

Posted in Memory Management Interview Questions | Leave a comment

How to implement the multiple control files for an existing database? | Memory Management Questions

1. Edit init.ora file set control_files parameter with multiple location 2. shutdown immediate 3. copy control file to multiple locations & confirm from init.ora contol_files parameter 4. start the database. 5. run this query for changes confirmation – select name … Continue reading

Posted in Memory Management Interview Questions | Leave a comment

What is redo log file mirroring? | Memory Management Questions

Multiplexing Redo log file called Mirroing. ( Keeping multiple copies in different disks)

Posted in Memory Management Interview Questions | Leave a comment

How redo logs can be achieved? | Memory Management Questions

LGWR process wirtes all change vectors from theredo log buffer to online redo log file sequentially.

Posted in Memory Management Interview Questions | Leave a comment

What is advantage of having disk shadowing / mirroring? | Memory Management Questions

Shadow set of disks save as a backup in the event of disk failure. In most Operating System if any disk failure occurs it automatically switchover to place of failed disk. Improved performance because most OS support volume shadowing can … Continue reading

Posted in Memory Management Interview Questions | Leave a comment

What is use of rollback segments in Oracle database? | Memory Management Questions

When a user updated a particular table (for example 100 rows) the old value will be retained in the roll back segments(Oracle 8) and now it is Undo segment (oracle 9i). If the user issue a rollback command the old … Continue reading

Posted in Memory Management Interview Questions | Leave a comment