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
how can you implement fine-grained auditing?
Explain about your sql server dba experience? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
what are the differences of where and if in SAS?
What would you do with an "in-doubt" distributed transaction?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How would you go about verifying the network name that the local_listener is currently using?
Query processing is slow(eg select query)how will u solve that
Which autogrowth database setting is good? : sql server DBA
what are the types of connection load-balancing?
What the different components in replication and what is their use? : sql server DBA