- 浏览: 7377820 次
- 性别:
- 来自: 上海
-
文章分类
- 全部博客 (1546)
- 企业中间件 (236)
- 企业应用面临的问题 (236)
- 小布Oracle学习笔记汇总 (36)
- Spring 开发应用 (54)
- IBatis开发应用 (16)
- Oracle基础学习 (23)
- struts2.0 (41)
- JVM&ClassLoader&GC (16)
- JQuery的开发应用 (17)
- WebService的开发应用 (21)
- Java&Socket (44)
- 开源组件的应用 (254)
- 常用Javascript的开发应用 (28)
- J2EE开发技术指南 (163)
- EJB3开发应用 (11)
- GIS&Mobile&MAP (36)
- SWT-GEF-RCP (52)
- 算法&数据结构 (6)
- Apache开源组件研究 (62)
- Hibernate 学习应用 (57)
- java并发编程 (59)
- MySQL&Mongodb&MS/SQL (15)
- Oracle数据库实验室 (55)
- 搜索引擎的开发应用 (34)
- 软件工程师笔试经典 (14)
- 其他杂项 (10)
- AndroidPn& MQTT&C2DM&推技术 (29)
- ActiveMQ学习和研究 (38)
- Google技术应用开发和API分析 (11)
- flex的学习总结 (59)
- 项目中一点总结 (20)
- java疑惑 java面向对象编程 (28)
- Android 开发学习 (133)
- linux和UNIX的总结 (37)
- Titanium学习总结 (20)
- JQueryMobile学习总结 (34)
- Phonegap学习总结 (32)
- HTML5学习总结 (41)
- JeeCMS研究和理解分析 (9)
最新评论
-
lgh1992314:
[u][i][b][flash=200,200][url][i ...
看看mybatis 源代码 -
尼古拉斯.fwp:
图片根本就不出来好吧。。。。。。
Android文件图片上传的详细讲解(一)HTTP multipart/form-data 上传报文格式实现手机端上传 -
ln94223:
第一个应该用排它网关吧 怎么是并行网关, 并行网关是所有exe ...
工作流Activiti的学习总结(八)Activiti自动执行的应用 -
ZY199266:
获取不到任何消息信息,请问这是什么原因呢?
ActiveMQ 通过JMX监控Connection,Queue,Topic的信息 -
xiaoyao霄:
DestinationSourceMonitor 报错 应该导 ...
ActiveMQ 通过JMX监控Connection,Queue,Topic的信息
ADRCI is a command-line tool that is part of the fault diagnosability infrastructure introduced in Oracle Database 11g. ADRCI enables you to:
View diagnostic data within the Automatic Diagnostic Repository (ADR).
View Health Monitor reports.
Package incident and problem information into a zip file for transmission to Oracle Support.
Diagnostic data includes incident and problem descriptions, trace files, dumps, health monitor reports, alert log entries, and more.
ADR data is secured by operating system permissions on the ADR directories, hence there is no need to log in to ADRCI.
ADRCI has a rich command set, and can be used in interactive mode or within scripts.
<WEBDB2>$adrci
ADRCI: Release 11.1.0.7.0 - Production on Mon Oct 17 17:36:25 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ADR base = "/u01/app/oracle/product/11.1.0/db_1"
adrci> help
HELP [topic]
Available Topics:
CREATE REPORT
ECHO
EXIT
HELP
HOST
IPS
PURGE
RUN
SET BASE
SET BROWSER
SET CONTROL
SET ECHO
SET EDITOR
SET HOMES | HOME | HOMEPATH
SET TERMOUT
SHOW ALERT
SHOW BASE
SHOW CONTROL
SHOW HM_RUN
SHOW HOMES | HOME | HOMEPATH
SHOW INCDIR
SHOW INCIDENT
SHOW PROBLEM
SHOW REPORT
SHOW TRACEFILE
SPOOL
There are other commands intended to be used directly by Oracle, type
"HELP EXTENDED" to see the list
adrci> show base
ADR base is "/u01/app/oracle/product/11.1.0/db_1"
adrci> show control
ADR Home = /u01/app/oracle/product/11.1.0/db_1/diag/rdbms/ticket/ticket:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME LAST_AUTOPRG_TIME LAST_MANUPRG_TIME ADRDIR_VERSION ADRSCHM_VERSION ADRSCHMV_SUMMARY ADRALERT_VERSION CREATE_TIME
-------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ----------------------------------------
3545744540 720 8760 2011-04-06 18:59:03.590638 +08:00 2011-10-11 08:07:11.574095 +08:00 1 2 65 1 2011-04-06 18:59:03.590638 +08:00
1 rows fetched
adrci> show hm_run
ADR Home = /u01/app/oracle/product/11.1.0/db_1/diag/rdbms/ticket/ticket:
*************************************************************************
**********************************************************
HM RUN RECORD 1
**********************************************************
RUN_ID 1
RUN_NAME HM_RUN_1
CHECK_NAME DB Structure Integrity Check
NAME_ID 2
MODE 2
START_TIME 2011-04-06 19:17:51.312986 +08:00
RESUME_TIME <NULL>
END_TIME 2011-04-06 19:17:51.675983 +08:00
MODIFIED_TIME 2011-04-06 19:17:51.675983 +08:00
TIMEOUT 0
FLAGS 0
STATUS 5
SRC_INCIDENT_ID 0
NUM_INCIDENTS 0
ERR_NUMBER 0
REPORT_FILE <NULL>
**********************************************************
HM RUN RECORD 2
**********************************************************
RUN_ID 41
RUN_NAME HM_RUN_41
CHECK_NAME DB Structure Integrity Check
NAME_ID 2
MODE 2
START_TIME 2011-04-06 19:39:27.010743 +08:00
RESUME_TIME <NULL>
END_TIME 2011-04-06 19:39:27.032734 +08:00
MODIFIED_TIME 2011-04-06 19:39:27.032734 +08:00
TIMEOUT 0
FLAGS 0
STATUS 5
SRC_INCIDENT_ID 0
NUM_INCIDENTS 0
ERR_NUMBER 0
REPORT_FILE <NULL>
**********************************************************
HM RUN RECORD 3
**********************************************************
RUN_ID 61
RUN_NAME HM_RUN_61
CHECK_NAME DB Structure Integrity Check
NAME_ID 2
MODE 2
START_TIME 2011-04-06 19:42:13.069254 +08:00
RESUME_TIME <NULL>
END_TIME 2011-04-06 19:42:13.091718 +08:00
MODIFIED_TIME 2011-04-06 19:42:13.091718 +08:00
TIMEOUT 0
FLAGS 0
STATUS 5
SRC_INCIDENT_ID 0
NUM_INCIDENTS 0
ERR_NUMBER 0
REPORT_FILE <NULL>
**********************************************************
HM RUN RECORD 4
**********************************************************
RUN_ID 81
RUN_NAME HM_RUN_81
CHECK_NAME DB Structure Integrity Check
NAME_ID 2
MODE 2
START_TIME 2011-04-06 19:45:41.549000 +08:00
RESUME_TIME <NULL>
END_TIME 2011-04-06 19:45:41.571990 +08:00
MODIFIED_TIME 2011-04-06 19:45:41.571990 +08:00
TIMEOUT 0
FLAGS 0
STATUS 5
SRC_INCIDENT_ID 0
NUM_INCIDENTS 0
ERR_NUMBER 0
REPORT_FILE <NULL>
**********************************************************
HM RUN RECORD 5
**********************************************************
RUN_ID 101
RUN_NAME HM_RUN_101
CHECK_NAME DB Structure Integrity Check
NAME_ID 2
MODE 2
START_TIME 2011-04-06 19:48:36.347418 +08:00
RESUME_TIME <NULL>
END_TIME 2011-04-06 19:48:36.370444 +08:00
MODIFIED_TIME 2011-04-06 19:48:36.370444 +08:00
TIMEOUT 0
FLAGS 0
STATUS 5
SRC_INCIDENT_ID 0
NUM_INCIDENTS 0
ERR_NUMBER 0
REPORT_FILE <NULL>
**********************************************************
HM RUN RECORD 6
**********************************************************
RUN_ID 201
RUN_NAME HM_RUN_201
CHECK_NAME DB Structure Integrity Check
NAME_ID 2
MODE 2
START_TIME 2011-10-05 10:00:02.241269 +08:00
RESUME_TIME <NULL>
END_TIME 2011-10-05 10:00:02.382005 +08:00
MODIFIED_TIME 2011-10-05 10:00:02.382005 +08:00
TIMEOUT 0
FLAGS 0
STATUS 5
SRC_INCIDENT_ID 0
NUM_INCIDENTS 0
ERR_NUMBER 0
REPORT_FILE <NULL>
6 rows fetched
adrci> show homepath
ADR Homes:
diag/rdbms/ticket/ticket
adrci> show homes
ADR Homes:
diag/rdbms/ticket/ticket
adrci> show incdir
ADR Home = /u01/app/oracle/product/11.1.0/db_1/diag/rdbms/ticket/ticket:
*************************************************************************
adrci> show incident
ADR Home = /u01/app/oracle/product/11.1.0/db_1/diag/rdbms/ticket/ticket:
*************************************************************************
0 rows fetched
adrci> show problem
ADR Home = /u01/app/oracle/product/11.1.0/db_1/diag/rdbms/ticket/ticket:
*************************************************************************
0 rows fetched
adrci> ips show files
adrci> ips pack
Generated package 1 in file /home/oracle/IPSPKG_20111017174127_COM_1.zip, mode complete
adrci> ips show configuration
PARAMETER INFORMATION:
PARAMETER_ID 1
NAME CUTOFF_TIME
DESCRIPTION Maximum age for an incident to be considered for inclusion
UNIT Days
VALUE 90
DEFAULT_VALUE 90
MINIMUM 1
MAXIMUM 4294967295
FLAGS 0
PARAMETER INFORMATION:
PARAMETER_ID 2
NAME NUM_EARLY_INCIDENTS
DESCRIPTION How many incidents to get in the early part of the range
UNIT Number
VALUE 3
DEFAULT_VALUE 3
MINIMUM 1
MAXIMUM 4294967295
FLAGS 0
PARAMETER INFORMATION:
PARAMETER_ID 3
NAME NUM_LATE_INCIDENTS
DESCRIPTION How many incidents to get in the late part of the range
UNIT Number
VALUE 3
DEFAULT_VALUE 3
MINIMUM 1
MAXIMUM 4294967295
FLAGS 0
PARAMETER INFORMATION:
PARAMETER_ID 4
NAME INCIDENT_TIME_WINDOW
DESCRIPTION Incidents this close to each other are considered correlated
UNIT Minutes
VALUE 5
DEFAULT_VALUE 5
MINIMUM 1
MAXIMUM 4294967295
FLAGS 0
PARAMETER INFORMATION:
PARAMETER_ID 5
NAME PACKAGE_TIME_WINDOW
DESCRIPTION Time window for content inclusion is from x hours before first included incident to x hours after last incident
UNIT Hours
VALUE 24
DEFAULT_VALUE 24
MINIMUM 1
MAXIMUM 4294967295
FLAGS 0
PARAMETER INFORMATION:
PARAMETER_ID 6
NAME DEFAULT_CORRELATION_LEVEL
DESCRIPTION Default correlation level for packages
UNIT Number
VALUE 2
DEFAULT_VALUE 2
MINIMUM 1
MAXIMUM 4
FLAGS 0
PARAMETER INFORMATION:
PARAMETER_ID 7
NAME PURGE_ENABLED
DESCRIPTION If automatic purging is allowed for the IPS schema
UNIT Number
VALUE 1
DEFAULT_VALUE 1
MINIMUM 0
MAXIMUM 1
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 8
NAME MAX_FILE_SIZE
DESCRIPTION Maximum size for included files
UNIT Bytes
VALUE 2097152000
DEFAULT_VALUE 2097152000
MINIMUM 1
MAXIMUM 2097152000
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 9
NAME MAX_ARCHIVE_SIZE
DESCRIPTION Maximum size for a physical file
UNIT Bytes
VALUE 2097152000
DEFAULT_VALUE 2097152000
MINIMUM 1
MAXIMUM 2097152000
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 10
NAME MAX_METADATA_SIZE
DESCRIPTION Maximum size for metadata in a physical file
UNIT Bytes
VALUE 209715200
DEFAULT_VALUE 209715200
MINIMUM 1
MAXIMUM 2097152000
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 11
NAME MAX_SPLIT_SEQS
DESCRIPTION Maximum number of sequences for split package
UNIT Number
VALUE 5
DEFAULT_VALUE 5
MINIMUM 1
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 12
NAME MAX_METADATA_SEQS
DESCRIPTION Maximum number of sequences for split package
UNIT Number
VALUE 1
DEFAULT_VALUE 1
MINIMUM 0
MAXIMUM 1
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 13
NAME DISABLE_COMPONENT
DESCRIPTION Disable IPS callbacks for specified components
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 14
NAME DISABLE_CALLBACKS_AMI
DESCRIPTION Disable specified callbacks for component AMI
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 15
NAME DISABLE_CALLBACKS_IPS
DESCRIPTION Disable specified callbacks for component IPS
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 16
NAME DISABLE_CALLBACKS_DDE
DESCRIPTION Disable specified callbacks for component DDE
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 17
NAME DISABLE_CALLBACKS_HM
DESCRIPTION Disable specified callbacks for component HM
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 18
NAME DISABLE_CALLBACKS_EM
DESCRIPTION Disable specified callbacks for component EM
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 19
NAME DISABLE_CALLBACKS_GC
DESCRIPTION Disable specified callbacks for component GC
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 20
NAME DISABLE_CALLBACKS_CRS
DESCRIPTION Disable specified callbacks for component CRS
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 21
NAME DISABLE_CALLBACKS_OCM
DESCRIPTION Disable specified callbacks for component OCM
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 22
NAME DISABLE_CALLBACKS_RDA
DESCRIPTION Disable specified callbacks for component RDA
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 23
NAME DISABLE_CALLBACKS_OSS
DESCRIPTION Disable specified callbacks for component OSS
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
查看alert log
adrci> show alert
View diagnostic data within the Automatic Diagnostic Repository (ADR).
View Health Monitor reports.
Package incident and problem information into a zip file for transmission to Oracle Support.
Diagnostic data includes incident and problem descriptions, trace files, dumps, health monitor reports, alert log entries, and more.
ADR data is secured by operating system permissions on the ADR directories, hence there is no need to log in to ADRCI.
ADRCI has a rich command set, and can be used in interactive mode or within scripts.
<WEBDB2>$adrci
ADRCI: Release 11.1.0.7.0 - Production on Mon Oct 17 17:36:25 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ADR base = "/u01/app/oracle/product/11.1.0/db_1"
adrci> help
HELP [topic]
Available Topics:
CREATE REPORT
ECHO
EXIT
HELP
HOST
IPS
PURGE
RUN
SET BASE
SET BROWSER
SET CONTROL
SET ECHO
SET EDITOR
SET HOMES | HOME | HOMEPATH
SET TERMOUT
SHOW ALERT
SHOW BASE
SHOW CONTROL
SHOW HM_RUN
SHOW HOMES | HOME | HOMEPATH
SHOW INCDIR
SHOW INCIDENT
SHOW PROBLEM
SHOW REPORT
SHOW TRACEFILE
SPOOL
There are other commands intended to be used directly by Oracle, type
"HELP EXTENDED" to see the list
adrci> show base
ADR base is "/u01/app/oracle/product/11.1.0/db_1"
adrci> show control
ADR Home = /u01/app/oracle/product/11.1.0/db_1/diag/rdbms/ticket/ticket:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME LAST_AUTOPRG_TIME LAST_MANUPRG_TIME ADRDIR_VERSION ADRSCHM_VERSION ADRSCHMV_SUMMARY ADRALERT_VERSION CREATE_TIME
-------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ----------------------------------------
3545744540 720 8760 2011-04-06 18:59:03.590638 +08:00 2011-10-11 08:07:11.574095 +08:00 1 2 65 1 2011-04-06 18:59:03.590638 +08:00
1 rows fetched
adrci> show hm_run
ADR Home = /u01/app/oracle/product/11.1.0/db_1/diag/rdbms/ticket/ticket:
*************************************************************************
**********************************************************
HM RUN RECORD 1
**********************************************************
RUN_ID 1
RUN_NAME HM_RUN_1
CHECK_NAME DB Structure Integrity Check
NAME_ID 2
MODE 2
START_TIME 2011-04-06 19:17:51.312986 +08:00
RESUME_TIME <NULL>
END_TIME 2011-04-06 19:17:51.675983 +08:00
MODIFIED_TIME 2011-04-06 19:17:51.675983 +08:00
TIMEOUT 0
FLAGS 0
STATUS 5
SRC_INCIDENT_ID 0
NUM_INCIDENTS 0
ERR_NUMBER 0
REPORT_FILE <NULL>
**********************************************************
HM RUN RECORD 2
**********************************************************
RUN_ID 41
RUN_NAME HM_RUN_41
CHECK_NAME DB Structure Integrity Check
NAME_ID 2
MODE 2
START_TIME 2011-04-06 19:39:27.010743 +08:00
RESUME_TIME <NULL>
END_TIME 2011-04-06 19:39:27.032734 +08:00
MODIFIED_TIME 2011-04-06 19:39:27.032734 +08:00
TIMEOUT 0
FLAGS 0
STATUS 5
SRC_INCIDENT_ID 0
NUM_INCIDENTS 0
ERR_NUMBER 0
REPORT_FILE <NULL>
**********************************************************
HM RUN RECORD 3
**********************************************************
RUN_ID 61
RUN_NAME HM_RUN_61
CHECK_NAME DB Structure Integrity Check
NAME_ID 2
MODE 2
START_TIME 2011-04-06 19:42:13.069254 +08:00
RESUME_TIME <NULL>
END_TIME 2011-04-06 19:42:13.091718 +08:00
MODIFIED_TIME 2011-04-06 19:42:13.091718 +08:00
TIMEOUT 0
FLAGS 0
STATUS 5
SRC_INCIDENT_ID 0
NUM_INCIDENTS 0
ERR_NUMBER 0
REPORT_FILE <NULL>
**********************************************************
HM RUN RECORD 4
**********************************************************
RUN_ID 81
RUN_NAME HM_RUN_81
CHECK_NAME DB Structure Integrity Check
NAME_ID 2
MODE 2
START_TIME 2011-04-06 19:45:41.549000 +08:00
RESUME_TIME <NULL>
END_TIME 2011-04-06 19:45:41.571990 +08:00
MODIFIED_TIME 2011-04-06 19:45:41.571990 +08:00
TIMEOUT 0
FLAGS 0
STATUS 5
SRC_INCIDENT_ID 0
NUM_INCIDENTS 0
ERR_NUMBER 0
REPORT_FILE <NULL>
**********************************************************
HM RUN RECORD 5
**********************************************************
RUN_ID 101
RUN_NAME HM_RUN_101
CHECK_NAME DB Structure Integrity Check
NAME_ID 2
MODE 2
START_TIME 2011-04-06 19:48:36.347418 +08:00
RESUME_TIME <NULL>
END_TIME 2011-04-06 19:48:36.370444 +08:00
MODIFIED_TIME 2011-04-06 19:48:36.370444 +08:00
TIMEOUT 0
FLAGS 0
STATUS 5
SRC_INCIDENT_ID 0
NUM_INCIDENTS 0
ERR_NUMBER 0
REPORT_FILE <NULL>
**********************************************************
HM RUN RECORD 6
**********************************************************
RUN_ID 201
RUN_NAME HM_RUN_201
CHECK_NAME DB Structure Integrity Check
NAME_ID 2
MODE 2
START_TIME 2011-10-05 10:00:02.241269 +08:00
RESUME_TIME <NULL>
END_TIME 2011-10-05 10:00:02.382005 +08:00
MODIFIED_TIME 2011-10-05 10:00:02.382005 +08:00
TIMEOUT 0
FLAGS 0
STATUS 5
SRC_INCIDENT_ID 0
NUM_INCIDENTS 0
ERR_NUMBER 0
REPORT_FILE <NULL>
6 rows fetched
adrci> show homepath
ADR Homes:
diag/rdbms/ticket/ticket
adrci> show homes
ADR Homes:
diag/rdbms/ticket/ticket
adrci> show incdir
ADR Home = /u01/app/oracle/product/11.1.0/db_1/diag/rdbms/ticket/ticket:
*************************************************************************
adrci> show incident
ADR Home = /u01/app/oracle/product/11.1.0/db_1/diag/rdbms/ticket/ticket:
*************************************************************************
0 rows fetched
adrci> show problem
ADR Home = /u01/app/oracle/product/11.1.0/db_1/diag/rdbms/ticket/ticket:
*************************************************************************
0 rows fetched
adrci> ips show files
adrci> ips pack
Generated package 1 in file /home/oracle/IPSPKG_20111017174127_COM_1.zip, mode complete
adrci> ips show configuration
PARAMETER INFORMATION:
PARAMETER_ID 1
NAME CUTOFF_TIME
DESCRIPTION Maximum age for an incident to be considered for inclusion
UNIT Days
VALUE 90
DEFAULT_VALUE 90
MINIMUM 1
MAXIMUM 4294967295
FLAGS 0
PARAMETER INFORMATION:
PARAMETER_ID 2
NAME NUM_EARLY_INCIDENTS
DESCRIPTION How many incidents to get in the early part of the range
UNIT Number
VALUE 3
DEFAULT_VALUE 3
MINIMUM 1
MAXIMUM 4294967295
FLAGS 0
PARAMETER INFORMATION:
PARAMETER_ID 3
NAME NUM_LATE_INCIDENTS
DESCRIPTION How many incidents to get in the late part of the range
UNIT Number
VALUE 3
DEFAULT_VALUE 3
MINIMUM 1
MAXIMUM 4294967295
FLAGS 0
PARAMETER INFORMATION:
PARAMETER_ID 4
NAME INCIDENT_TIME_WINDOW
DESCRIPTION Incidents this close to each other are considered correlated
UNIT Minutes
VALUE 5
DEFAULT_VALUE 5
MINIMUM 1
MAXIMUM 4294967295
FLAGS 0
PARAMETER INFORMATION:
PARAMETER_ID 5
NAME PACKAGE_TIME_WINDOW
DESCRIPTION Time window for content inclusion is from x hours before first included incident to x hours after last incident
UNIT Hours
VALUE 24
DEFAULT_VALUE 24
MINIMUM 1
MAXIMUM 4294967295
FLAGS 0
PARAMETER INFORMATION:
PARAMETER_ID 6
NAME DEFAULT_CORRELATION_LEVEL
DESCRIPTION Default correlation level for packages
UNIT Number
VALUE 2
DEFAULT_VALUE 2
MINIMUM 1
MAXIMUM 4
FLAGS 0
PARAMETER INFORMATION:
PARAMETER_ID 7
NAME PURGE_ENABLED
DESCRIPTION If automatic purging is allowed for the IPS schema
UNIT Number
VALUE 1
DEFAULT_VALUE 1
MINIMUM 0
MAXIMUM 1
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 8
NAME MAX_FILE_SIZE
DESCRIPTION Maximum size for included files
UNIT Bytes
VALUE 2097152000
DEFAULT_VALUE 2097152000
MINIMUM 1
MAXIMUM 2097152000
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 9
NAME MAX_ARCHIVE_SIZE
DESCRIPTION Maximum size for a physical file
UNIT Bytes
VALUE 2097152000
DEFAULT_VALUE 2097152000
MINIMUM 1
MAXIMUM 2097152000
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 10
NAME MAX_METADATA_SIZE
DESCRIPTION Maximum size for metadata in a physical file
UNIT Bytes
VALUE 209715200
DEFAULT_VALUE 209715200
MINIMUM 1
MAXIMUM 2097152000
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 11
NAME MAX_SPLIT_SEQS
DESCRIPTION Maximum number of sequences for split package
UNIT Number
VALUE 5
DEFAULT_VALUE 5
MINIMUM 1
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 12
NAME MAX_METADATA_SEQS
DESCRIPTION Maximum number of sequences for split package
UNIT Number
VALUE 1
DEFAULT_VALUE 1
MINIMUM 0
MAXIMUM 1
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 13
NAME DISABLE_COMPONENT
DESCRIPTION Disable IPS callbacks for specified components
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 14
NAME DISABLE_CALLBACKS_AMI
DESCRIPTION Disable specified callbacks for component AMI
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 15
NAME DISABLE_CALLBACKS_IPS
DESCRIPTION Disable specified callbacks for component IPS
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 16
NAME DISABLE_CALLBACKS_DDE
DESCRIPTION Disable specified callbacks for component DDE
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 17
NAME DISABLE_CALLBACKS_HM
DESCRIPTION Disable specified callbacks for component HM
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 18
NAME DISABLE_CALLBACKS_EM
DESCRIPTION Disable specified callbacks for component EM
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 19
NAME DISABLE_CALLBACKS_GC
DESCRIPTION Disable specified callbacks for component GC
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 20
NAME DISABLE_CALLBACKS_CRS
DESCRIPTION Disable specified callbacks for component CRS
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 21
NAME DISABLE_CALLBACKS_OCM
DESCRIPTION Disable specified callbacks for component OCM
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 22
NAME DISABLE_CALLBACKS_RDA
DESCRIPTION Disable specified callbacks for component RDA
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
PARAMETER INFORMATION:
PARAMETER_ID 23
NAME DISABLE_CALLBACKS_OSS
DESCRIPTION Disable specified callbacks for component OSS
UNIT Number
VALUE 0
DEFAULT_VALUE 0
MINIMUM 0
MAXIMUM 4294967295
FLAGS 1
查看alert log
adrci> show alert
发表评论
-
各种数据库分页Dialect的方法
2011-12-02 09:01 2047以下分页技术均来自hibernate-core-3.3.1.G ... -
Oracle控制文件管理
2011-10-18 17:00 2115每一个Oracle数据库都有一个二进制文件记录着数据库的物理结 ... -
Oracle正则表达式函数:regexp_like、regexp_substr、regexp_instr、regexp_replace
2011-10-17 17:07 8651Oracle使用正则表达式离 ... -
Oracle 10g SQL Fundamentals II(学习笔记二第7-8章)
2011-10-17 16:27 1891第七章分层检索 语法: SELECT [LE ... -
Oracle 10g SQL Fundamentals II(学习笔记二第5-6章)
2011-10-17 16:26 1473第五章不同时区管理数据 TIME_ZONE 会话参数 ... -
Oracle 10g SQL Fundamentals II(学习笔记二第3-4章)
2011-10-17 16:25 1700第三章 大数据集合 从一个表中拷贝数据 ... -
Oracle 10g SQL Fundamentals II(学习笔记二第1-2章)
2011-10-17 16:23 1939第一章用户访问 创建用户 create user us ... -
Oracle 10g SQL Fundamentals I(学习笔记二第10-11章)
2011-10-16 11:19 1624第十章创建其他对象(视图,索引,序列,同义词) 视图的优点 ... -
Oracle 10g SQL Fundamentals I(学习笔记二第7-8章)
2011-10-16 11:17 1164第七章使用各种操作Union/UNION ALL/MINUS/ ... -
ORACLE CTAS(create table as select)使用注意点
2011-10-09 11:28 6409ORACLE CTAS(create table as sel ... -
Oracle的小应用
2011-10-08 16:38 944今天同事打电话让我把数据库中的一个用户下所有表的注释导出 ... -
Oracle 10g SQL Fundamentals I(学习笔记二第4-6章)
2011-10-08 16:28 1557第四节: 分组函数: select [column, ... -
Oracle 10g SQL Fundamentals I(学习笔记第1-3章)
2011-10-08 16:25 1732第一章和第二章 distinct like 'S%' ... -
Oracle监控语句
2011-09-21 22:40 8731.监控事例的等待 select event,sum(de ... -
Oracle Rman 命令详解(List report backup configure)
2011-09-21 22:37 1561一、list常用命令总结备忘 list命令列出控制文件、 ... -
Oracle RMAN相关验证备份
2011-09-20 23:19 2235一.备份db并查看备份 list backup summ ... -
Oracle 的 Alert 日志
2011-09-20 23:18 2937从 Oracle 11g 开始,Oracle 数据库以XML与 ... -
Oracle 几个常用命令
2011-09-19 19:35 1308OEMC启动dbconsole进程1. emctl star ... -
Oracle中登录文件Login的定制
2011-09-14 10:55 1845在window系统针对Oracle登录调试设置登录 ... -
ORACLE使用dbv工具检验数据文件是否有坏块
2011-09-13 22:31 2777使用dbv工具检验数据文件是否有坏块 dbv工具可以用来验 ...
相关推荐
Oracle 11g 中的 ADRCI(Automatic Diagnostic Repository Command Interpreter)是一种命令行工具,用于查看和管理 Oracle 数据库的诊断日志和跟踪信息。ADRCI 工具可以帮助 DBA 快速了解数据库的健康状况,对问题...
通过ADR的命令行接口ADRCI (Automatic Diagnostic Repository Command Interpreter),管理员可以方便地管理这些诊断信息。例如,可以设置控制策略来决定不同类型的文件保留多久,如上面示例中的SHORTP_POLICY和LONGP...
- **2.2.3 ADR Command Interpreter(ADRCI)介绍及使用** ADRCI是一个命令行工具,用于管理和查询自动诊断存储库(Automatic Diagnostic Repository, ADR)中的日志和跟踪文件。它可以用来查看数据库的健康状况、定位...
6. **adrci.exe**: ADRCI (Automatic Diagnostic Repository Command Interpreter) 是Oracle的一个命令行工具,用于诊断和性能监控。它提供了对自动诊断存储库(ADR)的访问,可以用来查看错误报告、收集诊断信息以及...
**2.2.3 ADR Command Interpreter (ADRCI) 介绍及使用** ADRCI 是一个命令行工具,用于管理 ADR。它支持多种命令,如查看诊断信息、生成诊断报告等。 **2.3 Oracle11g 逻辑备份和恢复** **2.3.1 DataPump 导出** ...
为了查看警告日志,可以使用Oracle的ADR Command Interpreter (adrci) 工具。在命令行输入`adrci`启动工具,然后使用`show alert`命令来查看日志。根据提示选择要查看的目录(1 for `diag/rdbms/db1/db1`,2 for `...