Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers   TCS,

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

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?

0 Answers  

---

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  

---

what is asm?

0 Answers   Oracle,

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---