Answer Posted / sudarsan
check point is a background process(chk process name),when
ever any transaction takes place oracle create an check
point for that particular transaction and that is saved
into the controlfile header as well as datafile header.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
What is the difference between dropping a database and taking a database offline? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How can you control the amount of free space in your index pages? : sql server DBA
what is asm?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What would you do with an "in-doubt" distributed transaction?
Which autogrowth database setting is good? : sql server DBA
which background process invoke at the time of upgradation tell me???
What is the default port no on which sql server listens? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
how to restore files with rman?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Where would you look for errors from the database engine?
