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;

Explain materialized views and how they are used.

0 Answers  

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  

---

What is the dataguard background process??

1 Answers   iGate,

---

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

---

What type of index should you use on a fact table?

1 Answers  

---

---

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

---

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

---

If CPU is very slow What can u do to speed up?

1 Answers  

---

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

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

0 Answers   Patni,

---