What is pga_aggregate_target?
No Answer is Posted For this Question
Be the First to Post Answer
What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
You have taken a manual backup of a datafile using os. How rman will know about it?
How do you set up tablespaces during an oracle installation?
How can you find all the processes on your system?
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?
What is the advantage of using rman?
Explain the wait events in statspack report 'db sequential real'?
What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
How can you determine the space left in a file system?
What does a dba do all day?
Explain force logging feature in 9i.