Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sreeramch9
Check Point(CKPT) is a Background Processor, which update latest SCN to datafile header and control file by using online redolog file.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what is grd?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What is a system database and what is a user database? : sql server DBA
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.
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
how can you schedule a job in database?
What is a correlated sub-query? : sql server DBA
Explain materialized views and how they are used.
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
