Which dictionary tables and/or views would you look at to
diagnose a locking issue?
Answer Posted / braj123
sys.v$lock
v$locked_object
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the steps you will take to improve performance of a poor performing query?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
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?
who owns the operating system files created by the utl_file package?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
what are the types of connection load-balancing?
how can you process messages in order asynchronously?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
how can you enable flashback feature?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
which background process invoke at the time of upgradation tell me???
What are the different authentication modes in sql server and how can you change authentication mode? : 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.