How would you determine what sessions are connected and what
resources they are waiting for?
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 would you go about verifying the network name that the local_listener is currently using?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
how can you communicate with operating system files from oracle?
what are the benefits of flashback feature?
what functionality does oracle provide to secure sensitive information?
What is the default port no on which sql server listens? : sql server DBA
What is dcl? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
What the different components in replication and what is their use? : sql server DBA
Explain materialized views and how they are used.
what is a user-defined lock?
what are the performance views in an oracle rac environment?
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