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
what is the diffrence between core dba and apps dba?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
how can you initialize log miner?
what are the performance views in an oracle rac environment?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
how can you communicate with operating system files from oracle?
What are the commands you'd issue to show the explain plan for "select * from dual"?
how can a session indicate its interest in receiving alerts?
Where would you look for errors from the database engine?
how can you find out if a table can be redefined?
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
What types of replication are supported in sql server? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What is a system database and what is a user database? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.