Answer / shwetha

During normal running of database, dirty buffers are added
to checkpoint queue.Also when a block is first modified it
is entered in the checkpoint queue.The RBA of redo record
is also added.Every 3 sec CKPT records the RBA from
checkpoint queue.In case of instance failure RBA gives the
location from where recovery has to start( Checkpoint
position). During log switch CKPT updates contrl file and
data file headers.

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers   IBM,

---

How can you enable a trace for a session?

1 Answers  

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---

What does coalescing a tablespace do?

1 Answers  

---

i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,

---

how can you schedule a job in database?

0 Answers   Oracle,

---

what is a user-defined lock?

0 Answers   Oracle,

---

any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,

---

Where would you look for errors from the database engine?

0 Answers   IBM,

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---