What is pga_aggregate_target?
No Answer is Posted For this Question
Be the First to Post Answer
What is the relation between database and instance?
When should you increase copy latches?
Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
System tablespace cant be exported from one database and imported into another why?
How can you tell if an index on particular table is used or not used in 9i?
List five most important parameter in 9i affecting performance?
What does a dba stand for?
What are the main benefits of using spfile over pfile?
You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?
Which rman command is used to create an exact replica of a database innew host?
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?