Which dictionary tables and/or views would you look at to
diagnose a locking issue?
Answer Posted / sushma s
V$LOCKED_OBJECT
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what are the differences of where and if in SAS?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
what is the role of dip user in our database?
what is a user-defined lock?
Where do you find the default index fill factor and how to change it? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Can you redefine a table online?
What is a system database and what is a user database? : sql server DBA
What are the recovery models for a database? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
how does an oracle clusterware manage crs resources?