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 you resize a data file?

2 Answers  

---

Which autogrowth database setting is good? : sql server DBA

0 Answers  

---

What is the difference between LMT & DLT?

1 Answers   CTS,

---

What is the difference between Datapump & export/import?

2 Answers  

---

What command would you use to create a backup control file?

2 Answers  

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

---

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

1 Answers  

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers  

---

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

3 Answers   TCS,

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 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  

---

How do you add a data file to a tablespace?

3 Answers  

---