Answer / kittu

in two ways we can check
1) archive log list
2) select log_mode from v$database;

Answer / krishna

archive log list
select log_mode from v$database;

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

0 Answers  

---

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---

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,

---

How to make a replica of existing oracle server to another server?

3 Answers  

---

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

---

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

---

How would you force a log switch?

4 Answers  

---

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

What is a system database and what is a user database? : sql server DBA

0 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  

---