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

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  


What are the commands used in dcl? : sql server DBA

0 Answers  


What is the difference between Datapump & export/import?

2 Answers  


What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  


which background process invoke at the time of upgradation tell me???

0 Answers   iGate,






Explain about your sql server dba experience? : sql server DBA

0 Answers  


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  


how to restore files with rman?

0 Answers  


I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  


How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  


What the different types of replication and why are they used? : sql server DBA

0 Answers  


Categories