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
Explain materialized views and how they are used.
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how can you communicate with operating system files from oracle?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
how can you record information about current session?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
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
What are the different ways you can create databases in sql server? : sql server DBA
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
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is the use of ocr?
what is ora 24313?what is the procedure to exclude that error?