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 get actual data change values from previous transactions in oracle?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What authentication modes does sql server support? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the steps you will take to improve performance of a poor performing query?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
Query processing is slow(eg select query)how will u solve that
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
How do you trace the traffic hitting a sql server? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?