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
- 6404 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
how can a session indicate its interest in receiving alerts?
Which autogrowth database setting is good? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
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?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
what is the use of recording information about current session?
What is transparent data encryption? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
How do you trace the traffic hitting a sql server? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
