How would you determine what sessions are connected and what
resources they are waiting for?
Answers were Sorted based on User's Feedback
Answer / 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 |
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what are the benefits of flashback feature?
what are the types of connection load-balancing?
I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........
Which dictionary tables and/or views would you look at to diagnose a locking issue?
what is the difference between off-line back up and on-line back up in ibm db2 udb?
A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What questions might be they ask in managerial round in capgemini.
what is ora 24313?what is the procedure to exclude that error?
What's the benefit of "dbms_stats" over "analyze"?