How to turn off oracle monitoring log

Method: 1. Use "show log_status" to view the monitoring log. If the "log_status" parameter is ON, it means the log is on; 2. Use "set log_status off" to change the parameter to off, and use "save_config" to save the configuration modification. ; 3. Restart the listening program.

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to turn off oracle monitoring log

The monitoring log is controlled by the log_status parameter, ON means open, which is also the default value, and OFF means closed. You can view the status of parameters through the show command of the LSNRCTL tool.

Close the listener log:

# su - oracle
$ lsnrctl
LSNRCTL> set log_status off
LSNRCTL> save_config
LSNRCTL> show log_status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter "log_status" set to OFF

The above modifications will take effect immediately and there is no need to restart the listener.

Manually delete the listener log in the alert directory. (It is recommended to make necessary backup before deletion)

Method:

Lsnrctl>show log_status
Lsnrctl>set log_status off //不产生监听日志，但监听程序还是要的
Lsnrctl>save_config //保存配置
Lsnrctl>stop //关闭监听程序并重启监听
Lsnrctl>start //重启监听

The example is as follows:

Recommended Tutorial: "Oracle Video Tutorial"

The above is the detailed content of How to turn off oracle monitoring log. For more information, please follow other related articles on the PHP Chinese website!