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 can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  

---

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

---

what is the use of home directory???

1 Answers   HP,

---

Oracle 11g new features?

2 Answers  

---

Explain about your sql server dba experience? : sql server DBA

0 Answers  

---

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

---

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---

How do you add a data file to a tablespace?

3 Answers  

---

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

1 Answers  

---

Compare and contrast TRUNCATE and DELETE for a table.

7 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  

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  

---