A Checkpoint is like a snapshot of the DBMS state. By taking checkpoints, the DBMS can reduce the amount of work to be done during restart in the event of subsequent crashes.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
DBWR writes when more data needs to be read into the SGA and too few database buffers are free. The least recently used data is written to the data files first. DBWR also writes when CheckPoint occurs.
Create Date
:
Saturday, May 10, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
The Checkpoint (CKPT) process is responsible for signaling DBWR at checkpoints and updating all the data files and control files of the database.
Create Date
:
Saturday, May 10, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
I have a good knowledge on current IT trends.
Create Date
:
Sunday, April 06, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
Set the database option Truncate Log on Checkpoint , dump the transaction log, dump tha transaction log using the TRUNCATE_ONLY option, and dump the transaction log using the NO_LOG option
Create Date
:
Tuesday, April 01, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
Recruiter Needs to Understand Techonologies for IT and comming to ITES He/She need to Understand Specks what company has send across.
first of all the understand the clients requirements, for which position we have to recruit for that client,
based on the specifications of the client we have to search a suitable and qualifiable candidate from portals,
are any internal refrences .
Create Date
:
Monday, March 17, 2008
Click here
to improve the Interview Question, Answer and other fields.