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
- 8830 Views
- I also Faced
- E-Mail Answers
Answer Posted / santosh
You can use v$session and v$locks to view this. If you want
to see which process is taking long time you can query
v$session_longops
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What the different topologies in which replication can be configured? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What is a system database and what is a user database? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what is the diffrence between core dba and apps dba?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
what is asm?
how can you process messages in order asynchronously?
Can you redefine a table online?
How do you open a cluster administrator? : sql server DBA
Why would you call update statistics? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is the difference between clustered and non-clustered index? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
