Interested to Buy Any Domain ? << Click Here >> for more details...
Which dictionary tables and/or views would you look at to
diagnose a locking issue?
- 2 Answers
- 6184 Views
- I also Faced
- E-Mail Answers
Answer Posted / braj123
sys.v$lock
v$locked_object
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
what is grd?
how can you connect from 10g user to 11g user??
What the different topologies in which replication can be configured? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How do you trace the traffic hitting a sql server? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Which autogrowth database setting is good? : 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 is the role of dip user in our database?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Query processing is slow(eg select query)how will u solve that
what is asm?
