Answer / Sachin Kumar Singh

Performance views in an Oracle RAC (Real Application Clusters) environment provide information about resource usage, wait events, and other important metrics. Some commonly used performance views include:
1. V$ACTIVE_SESSION_HISTORY: Tracks recent activity of active sessions.
2. V$SYSSTAT: Shows system statistics related to CPU, I/O, network, and other resources.
3. V$RESOURCE_LIMITS: Displays resource limits for each session.

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

2 Answers  

---

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1 Answers  

---

What is the difference between LMT & DLT?

1 Answers   CTS,

---

. 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?

1 Answers  

---

How to make a replica of existing oracle server to another server?

3 Answers  

---

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  

---

how can you create a user-defined lock?

1 Answers   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?

1 Answers  

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

1 Answers  

---

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

---

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

---