Interested to Buy Any Domain ? << Click Here >> for more details...
How would you determine what sessions are connected and what
resources they are waiting for?
- 2 Answers
- 8829 Views
- I also Faced
- E-Mail Answers
Answer Posted / santo
Query v$sesstat or v$waitstat views.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
what do you understand by flashback feature of oracle?
What the different types of replication and why are they used? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
Where would you look for errors from the database engine?
how can you process messages in order asynchronously?
What are the commands you'd issue to show the explain plan for "select * from dual"?
How do you open a cluster administrator? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
what is grd?
What is the difference between dropping a database and taking a database offline? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
