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 do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

---

What view would you use to determine free space in a tablespace?

3 Answers  

---

Oracle 11g new features?

2 Answers  

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  

---

How to determine the service pack currently installed on SQL Server?

1 Answers  

---

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

---

What is dcl? : sql server DBA

0 Answers  

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  

---

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

1 Answers  

---

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

---

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

---