Oracle 参数 LOG_ARCHIVE_TRACE 官方解释，作用，如何配置最优化建议
本站中文解释
：
LOG_ARCHIVE_TRACE指定日志档案进程追踪(archive trace)的等级。使用这个参数可以生成日志档案进程的诊断信息，它的取值范围为0至16，比如：
LOG_ARCHIVE_TRACE=16
参数值越大，系统生成的诊断信息就越多，但同时也会消耗更多的资源，如果用户不熟悉这个参数，是不建议直接更改该参数，系统默认值是0，应该只在数据库管理人员要求下，去更改它的值。
官方英文解释
LOG_ARCHIVE_TRACE enables and controls the generation of comprehensive trace information for log archiving and redo transport activity.
| Property | Description |
|---|---|
|
Parameter type |
Integer |
|
Default value |
|
|
Modifiable |
|
|
Modifiable in a PDB |
No |
|
Range of values |
0, 1, 2, 4, 8, 16, 32, 64, 128, 256, 512, 1024, 2048, 4096, 8192, 16384, 32768 |
|
Basic |
No |
|
Oracle RAC |
Multiple instances can have different values. |
The additional tracing that is output when setting LOG_ARCHIVE_TRACE to a non-zero value can appear in trace files for an archive process, RFS process, LGWR process, SYNC process, ASYNC process, foreground process, MRP process, recovery process, log apply process, startup process, shutdown process, and other processes that use redo transport services.
Table 2-4 describes the valid LOG_ARCHIVE_TRACE values.
Table 2-4 LOG_ARCHIVE_TRACE Values
| Value | Description | More Information |
|---|---|---|
|
0 |
Disables archivelog tracing (this is the default) |
|
|
1 |
High-level tracing |
High-level tracing provides a small amount of tracing from most redo transport processes. When a value is specified that is not high-level (not 1), the high-level tracing for that value will be output to the trace file even if the high-level tracing has not been specifically requested. For example, if you set |
|
2 |
Tracks Data Guard interfaces |
This tracing level is for the various Data Guard configuration parameters, the various Data Guard related SQL commands, the various Data Guard table accesses, and some Data Guard internal interfaces. |
|
4 |
Tracks common redo transport services |
This tracing level is for a number of common services provided by redo transport to various internal users (such as the RFS process, the LGWR process, and the ASYNC process). These include locking primitives, use of common VOS (Virtual Operating System) interfaces, task scheduling, process monitoring, control file access, and other miscellaneous common services. |
|
8 |
Tracks database protection mode |
|
|
16 |
Tracks disk and network I/O requests |
|
|
32 |
Tracks redo transport destinations |
|
|
64 |
Tracks redo transport archive engine |
|
|
128 |
Tracks redo transport FAL (fetch archive log) engine |
|
|
256 |
Tracks Physical, Logical, and Availability Machine clients of RFS process |
|
|
512 |
Tracks redo transport of LGWR, SYNC, and ASYNC processes |
|
|
1024 |
Tracks redo transport RFS process |
|
|
2048 |
Tracks redo transport gap resolution |
|
|
4096 |
Tracks real-time apply |
|
|
8192 |
Tracks recovery process |
|
|
16384 |
Tracks redo transport buffer management |
|
|
32768 |
Tracks LogMiner dictionary |
You can combine tracing levels by adding together the values of the desired tracing levels. For example, a setting of 3 will generate level 1 and level 2 trace output. You can set different values for the primary and standby database.
When this parameter is set to the default value of 0, Oracle will still generate appropriate alert and trace entries in response to error conditions. If you change the value of this parameter dynamically in an ALTER SYSTEM statement, the change takes effect immediately.
Many of the trace messages from redo transport processes include a routine name at the beginning of the trace message. The first part of the routine name specifies the module for that routine. Table 2-5 shows the tracing value used for each redo transport module. Note that the tracing value for transport modules can change from release to release.
Table 2-5 Tracing Values Used for Redo Transport Modules
| Module Name | Purpose | Tracing Value |
|---|---|---|
|
krsa |
Locking primitives |
4 |
|
krsb |
Buffer management |
16384 |
|
krsc |
Crash recovery |
64 |
|
krsd |
Destination |
32 |
|
krse |
Archive engine |
64 |
|
krsf |
FAL engine |
128 |
|
krsg |
Gap resolution |
2048 |
|
krsh |
Helper |
4 |
|
krsi |
Input/output |
16 |
|
krsj |
Protection mode |
8 |
|
krsk |
Control file access |
4 |
|
krsl |
Log writer |
512 |
|
krsm |
MRP process |
8192 |
|
krsn |
Configuration |
2 |
|
krso |
Process monitor |
4 |
|
krsp |
Physical standby and Availability Machine RFS client |
256 |
|
krsq |
SQL commands |
2 |
|
krsr |
RFS process |
1024 |
|
krst |
Tables |
2 |
|
krsu |
Network I/O |
16 |
|
krsv |
VOS front end |
4 |
|
krsw |
ASYNC process |
512 |
|
krsx |
Internal interfaces |
2 |
See Also:
Oracle Database
Administrator’s Guide
