Answer / raj

it locks the header #SCN number of the datafiles and
datafiles will be updated continuously.
If the db is coming out from begin backup mode it updates
the header #SCN number.

Answer / kittu_chintu2005

It freezes the entire database and it won’t take any transaction to datafile then excessive redologs generates.

How would you go about generating an EXPLAIN plan?

2 Answers  

---

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

---

what is the difference between db2start command and start database manager command?

1 Answers  

---

How would you determine the time zone under which a database was operating?

2 Answers  

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers  

---

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

1 Answers  

---

How would you force a log switch?

4 Answers  

---

How can we know the exact updation date of a particular database?

2 Answers   Satyam,

---

what is the role of dip user in our database?

0 Answers  

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  

---

What is blocking and how would you troubleshoot it?

1 Answers  

---

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

---