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
what is grd?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
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?
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
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the steps you will take to improve performance of a poor performing query?
what are the performance views in an oracle rac environment?
What is replication? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What is the default port no on which sql server listens? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What are the commands used in dcl? : sql server DBA
How do you open a cluster administrator? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?