Alert log - Oracle FAQ
来源:互联网 发布:centos rm 文件夹 编辑:程序博客网 时间:2024/05/09 18:47
Alert log
From Oracle FAQ
(Redirected from Alert.log)
Jump to: navigation, search
The alert log file (also referred to as the ALERT.LOG) is a chronological log of messages and errors written out by an Oracle Database. Typical messages found in this file is: database startup, shutdown, log switches, space errors, etc. This file should constantly be monitored to detect unexpected messages and corruptions.
Oracle will automatically create a new alert log file whenever the old one is deleted.
[edit]Location of the ALERT.LOG file
Oracle will write the alert.log file to the directory as specified by the BACKGROUND_DUMP_DEST parameter.
SQL> show parameter BACKGROUND_DUMP_DEST
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest string /app/oracle/diag/rdbms/o11gr1/
o11gr1/trace
[edit]Writing to the ALERT.LOG file
Users can write messages to the alter.log file. Example:
-- Write message to alert.log
exec dbms_system.ksdwrt(2, ??Look Ma, I can write to the alert.log file!??);
PL/SQL procedure successfully completed.
-- Flush the buffer
exec dbms_system.ksdfls;
PL/SQL procedure successfully completed.
本文转自
http://www.orafaq.com/wiki/Alert.log
- Alert log - Oracle FAQ
- Oracle's alert.log
- Oracle's alert.log
- oracle alert.log位置
- Oracle-Alert log解读
- Python 监控Oracle alert log
- Oracle alert log 的监控并发邮件 (Alert Log Monitoring)
- Oracle alert log 按天 存放 脚本
- oracle 11g alert.log path
- Oracle alert log 按天 存放 脚本
- Oracle alert log 按天 存放 脚本
- Oracle alert log 按天 存放 脚本
- oracle 11g 删除alert log文件
- Oracle alert.log这个文件放在哪里?
- Oracle 11g Alert log 文件位置的问题
- Oracle 11g Alert log 文件位置的问题
- Query the Oracle Alert Log using SQL commands
- Oracle 11g Alert log 文件位置的问题
- v$parameter2 与v$system_parameter2、v$spparameter
- 图片上传时,本地显示预览功能
- 谢谢你曾经爱过我
- javascript 55个技巧
- SNS将成为网站的标准配置
- Alert log - Oracle FAQ
- 记录集,换成数组/rs.getRows()/redim Preserve 保留原有数据
- 自省
- Python解决打靶问题
- JTree用法及JTree使用经验总结(转)
- 数据库查询优化原则
- excel实用技巧
- Oracle数据库SQL语句性能调整的基本原则
- XCache安装配置