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
- 8709 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
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 crs resource?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
What is the difference between dropping a database and taking a database offline? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What are the steps you will take to improve performance of a poor performing query?
Why would you call update statistics? : sql server DBA
What is a system database and what is a user database? : sql server DBA
What is the default fill factor value? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Why does Oracle not permit the use of PCTUSED with indexes?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
how can you process messages in order asynchronously?
What is dcl? : sql server DBA
how can you initialize log miner?
