| |
 |
|
Oracle Tips by Burleson Consulting
|
Oracle snapshot background
process (SNPnnn)
The Oracle snapshot processes are an integral part of Oracle
advanced replication and Oracle materialized views. The SNP
processes are used to refresh replicated and pre-aggregated data.
The SNP processes will awaken when signaled by the implementation
dbms_job routine. Snapshots and materialized views are scheduled for
periodic refreshes with the dbms_job package, and the SNP process
will awaken whenever a request is made to refresh a snapshot or
materialized view.
Now that we understand the functions of the major Oracle background
processes, and how the background processes interact with UNIX,
let’s do a brief review of the tools that we can use to watch CPU
consumption for the Oracle background processes.
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
