This parameter lets you emulate the table DBCHECKORA if you want to run check database in a Java database, in which the table DBCHECKORA does not exist or when you have deliberately decided to ignore DBSTATC using -f check -i|-ignore. You can use check_cond to customize the check conditions.
Syntax
check_cond =
("<type>:<cond>:<active>:<sever>:[<chkop>]:
[<chkval>]:[<unit>]",...)
Possible values:
<type>: check condition
DBA: database administration
DBO: database operations
ORA: database messages
PROF: database profile
<cond>: name of the check condition
<active>: active flag of the proof condition
Y: yes (active)
N: no (inactive)
<sever>: severity of the check condition
E: error
W: warning
A: exception
<chkop>: check condition operator:
==: equal
<>: not equal
<: smaller
<=: smaller or equal
>: bigger
>=: bigger or equal
><: bigger or smaller
<chkval>: check value of the check condition
<unit>: unit of the check value
K: kilo
M: mega or minutes
G: giga
P: percent
S: seconds
H: hours
D: days
R: rate
Example
You can use this example as a template for your own settings.
This example corresponds to the standard settings plus the profile conditions for check conditions with Oracle 10g:
check_cond =
"DBA:ARCHIVER_STUCK:Y:W:>:90:P:",
"DBA:CONTROL_FILE_MIRROR:Y:E::::",
"DBA:CONTROL_FILE_MISSING:Y:E::::",
"DBA:CRITICAL_FILE:Y:W::::",
"DBA:CRITICAL_SEGMENT:Y:W:<=:2::",
"DBA:CRITICAL_TABLESPACE:Y:W::::",
"DBA:DATA_FILE_MISMATCH:Y:E::::",
"DBA:DATA_FILE_MISSING:Y:E::::",
"DBA:FILE_OFFLINE:Y:E::::",
"DBA:FILE_SYSTEM_FULL:Y:W:>:99:P:",
"DBA:HARMFUL_STATISTICS:Y:E::::",
"DBA:INVALID_FILE_TYPE:Y:E::::",
"DBA:IN_WRONG_TABLESPACE:Y:W::::",
"DBA:MISSING_INDEX:Y:E::::",
"DBA:MISSING_STATISTICS:Y:E::::",
"DBA:NOARCHIVELOG_MODE:Y:E::::",
"DBA:PCTINCREASE_NOT_ZERO:Y:W::::",
"DBA:REDOLOG_FILE_MIRROR:Y:E::::",
"DBA:REDOLOG_FILE_MISSING:Y:E::::",
"DBA:TABLESPACE_FULL:Y:W:>:95:P:",
"DBA:TABLESPACE_IN_BACKUP:Y:W::::",
"DBA:TABLESPACE_OFFLINE:Y:E::::",
"DBA:TOO_MANY_EXTENTS:Y:W:>:90:P:",
"DBO:ARCHIVE_TOO_OLD:Y:W:>:10:D:",
"DBO:BACKUP_TOO_OLD:Y:W:>:10:D:",
"DBO:LAST_ARCHIVE_FAILED:Y:W::::",
"DBO:LAST_BACKUP_FAILED:Y:W::::",
"DBO:LAST_OPERATION_FAILED:Y:W::::chk",
"DBO:LAST_OPERATION_FAILED:N:W::::",
"DBO:LAST_STATS_FAILED:Y:W::::",
"DBO:OPERATION_TOO_OLD:Y:W:>:10:D:chk",
"DBO:OPERATION_TOO_OLD:N:W:>:10:D:",
"DBO:STATS_TOO_OLD:Y:W:>:10:D:",
"ORA:00060:Y:W::::",
"ORA:00272:Y:E::::",
"ORA:00376:Y:E::::",
"ORA:00600:Y:E::::",
"ORA:01113:Y:E::::",
"ORA:01114:Y:E::::",
"ORA:01115:Y:E::::",
"ORA:01122:Y:E::::",
"ORA:01135:Y:E::::",
"ORA:01149:Y:E::::",
"ORA:01555:Y:W::::",
"ORA:01562:Y:W::::",
"ORA:01578:Y:E::::",
"ORA:03113:Y:E::::",
"ORA:07445:Y:E::::",
"ORA:Checkpoint not complete:Y:W::::",
"PROF:COMPATIBLE:Y:E:<>:10.2.0::",
"PROF:CONTROL_FILE_RECORD_KEEP_TIME:Y:W:<:30::",
"PROF:DB_BLOCK_SIZE:Y:E:<>:8192::",
"PROF:DB_FILES:Y:W:<:254::",
"PROF:DB_FILE_MULTIBLOCK_READ_COUNT:Y:W::::",
"PROF:FILESYSTEMIO_OPTIONS:Y:E:<>:SETALL::",
"PROF:LOG_ARCHIVE_START:Y:W::::",
"PROF:LOG_BUFFER:Y:W:><:4096,512:K:",
"PROF:LOG_CHECKPOINTS_TO_ALERT:Y:W:<>:TRUE::",
"PROF:MAX_DUMP_FILE_SIZE:Y:W:><:100000,10000::",
"PROF:OPEN_CURSORS:Y:W:><:2000,800::",
"PROF:OPTIMIZER_FEATURES_ENABLE:Y:W::::",
"PROF:OPTIMIZER_INDEX_COST_ADJ:Y:W::::",
"PROF:OPTIMIZER_MODE:Y:W::::",
"PROF:PARALLEL_EXECUTION_MESSAGE_SIZE:Y:W:><:16384,4096::",
"PROF:PARALLEL_THREADS_PER_CPU:Y:W:><:2,1::",
"PROF:QUERY_REWRITE_ENABLED:Y:E:<>:FALSE::",
"PROF:RECYCLEBIN:Y:E:<>:OFF::",
"PROF:RECYCLEBIN:Y:E:<>:OFF::",
"PROF:REMOTE_OS_AUTHENT:Y:E:<>:TRUE::",
"PROF:REPLICATION_DEPENDENCY_TRACKING:Y:E:<>:FALSE::",
"PROF:SHARED_POOL_SIZE:Y:W:<:400:M:",
"PROF:STAR_TRANSFORMATION_ENABLED:Y:W:<>:TRUE::",
"PROF:STATISTICS_LEVEL:Y:W::::",
"PROF:TIMED_STATISTICS:Y:W::::",
"PROF:TRACE_ENABLED:Y:W::::",
"PROF:UNDO_MANAGEMENT:Y:E:<>:AUTO::",
"PROF:UNDO_TABLESPACE:Y:W:<>:PSAPUNDO::")