Answer / pvenkiroyal

select to_char(startup_time,'hh24:mi:ss dd-mom-yy') from
v$instance;

Answer / mohapatra.gouranga@gmail.com

In RAC env.

select instance_name,status,host_name,to_char
(startup_time,'DD-MON-YY HH24:MI:SS')
from gv$instance order by instance_name;

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

2 Answers  

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---

How would you force a log switch?

4 Answers  

---

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

Oracle 11g new features?

2 Answers  

---

How would you go about increasing the buffer cache hit ratio?

2 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  

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

1 Answers   TCS,

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

how will you see when the database was started using sql prompt?

2 Answers   IBM,

---