Define the SGA and:

How you would configure SGA for a mid-sized OLTP environment?

What is involved in tuning the SGA?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB Administration Interview Questions

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  


what do you understand by flashback feature of oracle?

0 Answers   Oracle,


What are the recovery models for a database? : sql server DBA

0 Answers  


Give two methods you could use to determine what DDL changes have been made.

2 Answers  


internal architecture

0 Answers   CSC,






Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers   Tech Mahindra,


As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,


Name three advisory statistics you can collect.

1 Answers  


Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers  


Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  


what is the use of recording information about current session?

0 Answers   Oracle,


What authentication modes does sql server support? : sql server DBA

0 Answers  


Categories