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;

How would you force a log switch?

4 Answers  

---

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

what are the types of connection load-balancing?

0 Answers   Oracle,

---

What does coalescing a tablespace do?

1 Answers  

---

What is the dataguard background process??

1 Answers   iGate,

---

How many memory layers are in the shared pool?

3 Answers  

---

how can you implement fine-grained auditing?

0 Answers   Oracle,

---

what is ora 600?

1 Answers  

---

what is the difference between hot backup n rman backup?

1 Answers   Value Labs,

---