Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
No Answer is Posted For this Question
Be the First to Post Answer
How can you find your id on a system?
You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?
Is oracle dba in demand?
How do you install statspack?
How do you generate file output from sql?
If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
How can you find out how many users are currently logged into the database? How can you find their operating system id?
What is difference between logical standby database and physical standby database?
What are functions of dba?
A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?