What is Ora VKTM process?
Answer: The Oracle docs note that the “VKTM process (virtual keeper of time) is responsible for providing a wall-clock time (updated every second) and reference-time counter (updated every 20 ms and available only when running at elevated priority).” Oracle Training from Don Burleson.
What is Ckpt process in Oracle?
The CKPT process, which always exists in Oracle8 but is optional in Oracle7, is responsible for updating the headers of all Oracle datafiles at the time of a checkpoint. In Oracle7, this task may be performed by the LGWR process, but if there are many datafiles in the database then LGWR performance may be reduced.
What is m00 process in Oracle?
Symptoms. M000 background process generates a trace file at database startup, related to PGA sizing. The trace file contains information related to process memory, similar to the following: Note the allocation of 384MB for qesmmCheckPgaL in the above.
What is the purpose of Ckpt process?
CKPT (Oracle Checkpoint Process) is an Oracle background process that timestamps all datafiles and control files to indicate that a checkpoint has occurred. The “DBWR checkpoints” statistic (v$sysstat) indicates the number of checkpoint requests completed.
What is new in Oracle 11g?
Support for data compression is nothing new in Oracle Database, but 11g takes the concept to a new level with Advanced and Hybrid Columnar Compression. Explore SQL Result Cache, PL/SQL Function Cache, and Database Resident Connection Pooling.
What happens when Pmon is killed?
If you kill PMON, NOTHING will happen to your database at all.
What is use of Pmon and Smon in Oracle?
PMON is the Process Monitor which is responsible for recovering processes when the user process fails. PMON does the process cleanup. SMON is the System Monitor which is responsible for recovering the system after a failure.
What is SGA and PGA in Oracle 11g?
The SGA is shared by all server and background processes. Examples of data stored in the SGA include cached data blocks and shared SQL areas. Program global area (PGA) A PGA is a nonshared memory region that contains data and control information exclusively for use by an Oracle process.
What is Smon process?
The system monitor process (SMON) performs recovery, if necessary, at instance startup. SMON is also responsible for cleaning up temporary segments that are no longer in use and for coalescing contiguous free extents within dictionary managed tablespaces.