[Home] [Help]
PACKAGE: SYS.DBMS_SERVER_ALERT
Source
1 PACKAGE dbms_server_alert AS
2
3 -- PUBLIC CONSTANTS
4
5 -- operator types
6 OPERATOR_GT CONSTANT BINARY_INTEGER := 0;
7 OPERATOR_EQ CONSTANT BINARY_INTEGER := 1;
8 OPERATOR_LT CONSTANT BINARY_INTEGER := 2;
9 OPERATOR_LE CONSTANT BINARY_INTEGER := 3;
10 OPERATOR_GE CONSTANT BINARY_INTEGER := 4;
11 OPERATOR_CONTAINS CONSTANT BINARY_INTEGER := 5;
12 OPERATOR_NE CONSTANT BINARY_INTEGER := 6;
13 OPERATOR_DO_NOT_CHECK CONSTANT BINARY_INTEGER := 7;
14
15 -- object types
16 OBJECT_TYPE_SYSTEM CONSTANT BINARY_INTEGER := 1;
17 OBJECT_TYPE_FILE CONSTANT BINARY_INTEGER := 2;
18 OBJECT_TYPE_SERVICE CONSTANT BINARY_INTEGER := 3;
19 OBJECT_TYPE_EVENT_CLASS CONSTANT BINARY_INTEGER := 4;
20 OBJECT_TYPE_TABLESPACE CONSTANT BINARY_INTEGER := 5;
21 OBJECT_TYPE_SESSION CONSTANT BINARY_INTEGER := 9;
22 OBJECT_TYPE_WRCLIENT CONSTANT BINARY_INTEGER := 16;
23
24 -- message levels
25 SUBTYPE SEVERITY_LEVEL_T IS PLS_INTEGER;
26 LEVEL_CRITICAL CONSTANT PLS_INTEGER := 1;
27 LEVEL_WARNING CONSTANT PLS_INTEGER := 5;
28 LEVEL_CLEAR CONSTANT PLS_INTEGER := 32;
29
30 -- metrics names
31 AVG_USERS_WAITING CONSTANT BINARY_INTEGER := 1000;
32 DB_TIME_WAITING CONSTANT BINARY_INTEGER := 1001;
33 BUFFER_CACHE_HIT CONSTANT BINARY_INTEGER := 2000;
34 MEMORY_SORTS_PCT CONSTANT BINARY_INTEGER := 2001;
35 REDO_ALLOCATION_HIT CONSTANT BINARY_INTEGER := 2002;
36 USER_TRANSACTIONS_SEC CONSTANT BINARY_INTEGER := 2003;
37 PHYSICAL_READS_SEC CONSTANT BINARY_INTEGER := 2004;
38 PHYSICAL_READS_TXN CONSTANT BINARY_INTEGER := 2005;
39 PHYSICAL_WRITES_SEC CONSTANT BINARY_INTEGER := 2006;
40 PHYSICAL_WRITES_TXN CONSTANT BINARY_INTEGER := 2007;
41 PHYSICAL_READS_DIR_SEC CONSTANT BINARY_INTEGER := 2008;
42 PHYSICAL_READS_DIR_TXN CONSTANT BINARY_INTEGER := 2009;
43 PHYSICAL_WRITES_DIR_SEC CONSTANT BINARY_INTEGER := 2010;
44 PHYSICAL_WRITES_DIR_TXN CONSTANT BINARY_INTEGER := 2011;
45 PHYSICAL_READS_LOB_SEC CONSTANT BINARY_INTEGER := 2012;
46 PHYSICAL_READS_LOB_TXN CONSTANT BINARY_INTEGER := 2013;
47 PHYSICAL_WRITES_LOB_SEC CONSTANT BINARY_INTEGER := 2014;
48 PHYSICAL_WRITES_LOB_TXN CONSTANT BINARY_INTEGER := 2015;
49 REDO_GENERATED_SEC CONSTANT BINARY_INTEGER := 2016;
50 REDO_GENERATED_TXN CONSTANT BINARY_INTEGER := 2017;
51 LOGONS_SEC CONSTANT BINARY_INTEGER := 2018;
52 LOGONS_TXN CONSTANT BINARY_INTEGER := 2019;
53 OPEN_CURSORS_SEC CONSTANT BINARY_INTEGER := 2020;
54 OPEN_CURSORS_TXN CONSTANT BINARY_INTEGER := 2021;
55 USER_COMMITS_SEC CONSTANT BINARY_INTEGER := 2022;
56 USER_COMMITS_TXN CONSTANT BINARY_INTEGER := 2023;
57 USER_ROLLBACKS_SEC CONSTANT BINARY_INTEGER := 2024;
58 USER_ROLLBACKS_TXN CONSTANT BINARY_INTEGER := 2025;
59 USER_CALLS_SEC CONSTANT BINARY_INTEGER := 2026;
60 USER_CALLS_TXN CONSTANT BINARY_INTEGER := 2027;
61 RECURSIVE_CALLS_SEC CONSTANT BINARY_INTEGER := 2028;
62 RECURSIVE_CALLS_TXN CONSTANT BINARY_INTEGER := 2029;
63 SESS_LOGICAL_READS_SEC CONSTANT BINARY_INTEGER := 2030;
64 SESS_LOGICAL_READS_TXN CONSTANT BINARY_INTEGER := 2031;
65 DBWR_CKPT_SEC CONSTANT BINARY_INTEGER := 2032;
66 BACKGROUND_CKPT_SEC CONSTANT BINARY_INTEGER := 2033;
67 REDO_WRITES_SEC CONSTANT BINARY_INTEGER := 2034;
68 REDO_WRITES_TXN CONSTANT BINARY_INTEGER := 2035;
69 LONG_TABLE_SCANS_SEC CONSTANT BINARY_INTEGER := 2036;
70 LONG_TABLE_SCANS_TXN CONSTANT BINARY_INTEGER := 2037;
71 TOTAL_TABLE_SCANS_SEC CONSTANT BINARY_INTEGER := 2038;
72 TOTAL_TABLE_SCANS_TXN CONSTANT BINARY_INTEGER := 2039;
73 FULL_INDEX_SCANS_SEC CONSTANT BINARY_INTEGER := 2040;
74 FULL_INDEX_SCANS_TXN CONSTANT BINARY_INTEGER := 2041;
75 TOTAL_INDEX_SCANS_SEC CONSTANT BINARY_INTEGER := 2042;
76 TOTAL_INDEX_SCANS_TXN CONSTANT BINARY_INTEGER := 2043;
77 TOTAL_PARSES_SEC CONSTANT BINARY_INTEGER := 2044;
78 TOTAL_PARSES_TXN CONSTANT BINARY_INTEGER := 2045;
79 HARD_PARSES_SEC CONSTANT BINARY_INTEGER := 2046;
80 HARD_PARSES_TXN CONSTANT BINARY_INTEGER := 2047;
81 PARSE_FAILURES_SEC CONSTANT BINARY_INTEGER := 2048;
82 PARSE_FAILURES_TXN CONSTANT BINARY_INTEGER := 2049;
83 CURSOR_CACHE_HIT CONSTANT BINARY_INTEGER := 2050;
84 DISK_SORT_SEC CONSTANT BINARY_INTEGER := 2051;
85 DISK_SORT_TXN CONSTANT BINARY_INTEGER := 2052;
86 ROWS_PER_SORT CONSTANT BINARY_INTEGER := 2053;
87 EXECUTE_WITHOUT_PARSE CONSTANT BINARY_INTEGER := 2054;
88 SOFT_PARSE_PCT CONSTANT BINARY_INTEGER := 2055;
89 USER_CALLS_PCT CONSTANT BINARY_INTEGER := 2056;
90 NETWORK_BYTES_SEC CONSTANT BINARY_INTEGER := 2058;
91 ENQUEUE_TIMEOUTS_SEC CONSTANT BINARY_INTEGER := 2059;
92 ENQUEUE_TIMEOUTS_TXN CONSTANT BINARY_INTEGER := 2060;
93 ENQUEUE_WAITS_SEC CONSTANT BINARY_INTEGER := 2061;
94 ENQUEUE_WAITS_TXN CONSTANT BINARY_INTEGER := 2062;
95 ENQUEUE_DEADLOCKS_SEC CONSTANT BINARY_INTEGER := 2063;
96 ENQUEUE_DEADLOCKS_TXN CONSTANT BINARY_INTEGER := 2064;
97 ENQUEUE_REQUESTS_SEC CONSTANT BINARY_INTEGER := 2065;
98 ENQUEUE_REQUESTS_TXN CONSTANT BINARY_INTEGER := 2066;
99 DB_BLKGETS_SEC CONSTANT BINARY_INTEGER := 2067;
100 DB_BLKGETS_TXN CONSTANT BINARY_INTEGER := 2068;
101 CONSISTENT_GETS_SEC CONSTANT BINARY_INTEGER := 2069;
102 CONSISTENT_GETS_TXN CONSTANT BINARY_INTEGER := 2070;
103 DB_BLKCHANGES_SEC CONSTANT BINARY_INTEGER := 2071;
104 DB_BLKCHANGES_TXN CONSTANT BINARY_INTEGER := 2072;
105 CONSISTENT_CHANGES_SEC CONSTANT BINARY_INTEGER := 2073;
106 CONSISTENT_CHANGES_TXN CONSTANT BINARY_INTEGER := 2074;
107 SESSION_CPU_SEC CONSTANT BINARY_INTEGER := 2075;
108 SESSION_CPU_TXN CONSTANT BINARY_INTEGER := 2076;
109 CR_BLOCKS_CREATED_SEC CONSTANT BINARY_INTEGER := 2077;
110 CR_BLOCKS_CREATED_TXN CONSTANT BINARY_INTEGER := 2078;
111 CR_RECORDS_APPLIED_SEC CONSTANT BINARY_INTEGER := 2079;
112 CR_RECORDS_APPLIED_TXN CONSTANT BINARY_INTEGER := 2080;
113 RB_RECORDS_APPLIED_SEC CONSTANT BINARY_INTEGER := 2081;
114 RB_RECORDS_APPLIED_TXN CONSTANT BINARY_INTEGER := 2082;
115 LEAF_NODE_SPLITS_SEC CONSTANT BINARY_INTEGER := 2083;
116 LEAF_NODE_SPLITS_TXN CONSTANT BINARY_INTEGER := 2084;
117 BRANCH_NODE_SPLITS_SEC CONSTANT BINARY_INTEGER := 2085;
118 BRANCH_NODE_SPLITS_TXN CONSTANT BINARY_INTEGER := 2086;
119 PX_DOWNGRADED_25_SEC CONSTANT BINARY_INTEGER := 2087;
120 PX_DOWNGRADED_50_SEC CONSTANT BINARY_INTEGER := 2088;
121 PX_DOWNGRADED_75_SEC CONSTANT BINARY_INTEGER := 2089;
122 PX_DOWNGRADED_SEC CONSTANT BINARY_INTEGER := 2090;
123 PX_DOWNGRADED_SER_SEC CONSTANT BINARY_INTEGER := 2091;
124 GC_AVG_CR_GET_TIME CONSTANT BINARY_INTEGER := 2098;
125 GC_AVG_CUR_GET_TIME CONSTANT BINARY_INTEGER := 2099;
126 GC_BLOCKS_CORRUPT CONSTANT BINARY_INTEGER := 2101;
127 GC_BLOCKS_LOST CONSTANT BINARY_INTEGER := 2102;
128 LOGONS_CURRENT CONSTANT BINARY_INTEGER := 2103;
129 OPEN_CURSORS_CURRENT CONSTANT BINARY_INTEGER := 2104;
130 USER_LIMIT_PCT CONSTANT BINARY_INTEGER := 2105;
131 SQL_SRV_RESPONSE_TIME CONSTANT BINARY_INTEGER := 2106;
132 DATABASE_WAIT_TIME CONSTANT BINARY_INTEGER := 2107;
133 DATABASE_CPU_TIME CONSTANT BINARY_INTEGER := 2108;
134 RESPONSE_TXN CONSTANT BINARY_INTEGER := 2109;
135 ROW_CACHE_HIT CONSTANT BINARY_INTEGER := 2110;
136 ROW_CACHE_MISS CONSTANT BINARY_INTEGER := 2111;
137 LIBARY_CACHE_HIT CONSTANT BINARY_INTEGER := 2112;
138 LIBARY_CACHE_MISS CONSTANT BINARY_INTEGER := 2113;
139 SHARED_POOL_FREE_PCT CONSTANT BINARY_INTEGER := 2114;
140 PGA_CACHE_HIT CONSTANT BINARY_INTEGER := 2115;
141 PROCESS_LIMIT_PCT CONSTANT BINARY_INTEGER := 2118;
142 SESSION_LIMIT_PCT CONSTANT BINARY_INTEGER := 2119;
143 EXECUTIONS_PER_SEC CONSTANT BINARY_INTEGER := 2121;
144 DB_TIME_PER_SEC CONSTANT BINARY_INTEGER := 2123;
145 STREAMS_POOL_USED_PCT CONSTANT BINARY_INTEGER := 2136;
146 BLOCKED_USERS CONSTANT BINARY_INTEGER := 4000;
147 ELAPSED_TIME_PER_CALL CONSTANT BINARY_INTEGER := 6000;
148 CPU_TIME_PER_CALL CONSTANT BINARY_INTEGER := 6001;
149 AVG_FILE_READ_TIME CONSTANT BINARY_INTEGER := 7000;
150 AVG_FILE_WRITE_TIME CONSTANT BINARY_INTEGER := 7001;
151 TABLESPACE_PCT_FULL CONSTANT BINARY_INTEGER := 9000;
152 TABLESPACE_BYT_FREE CONSTANT BINARY_INTEGER := 9001;
153 WCR_AVG_IO_LAT CONSTANT BINARY_INTEGER := 13000;
154 WCR_PCPU CONSTANT BINARY_INTEGER := 13001;
155 WCR_PIO CONSTANT BINARY_INTEGER := 13002;
156
157 -- alert reasons -- copied from kelt.h
158 SUBTYPE REASON_ID_T IS PLS_INTEGER;
159 RSN_SLTE CONSTANT REASON_ID_T:= 0; -- stateless test alert
160 RSN_SFTE CONSTANT REASON_ID_T:= 1; -- stateful test alert
161 RSN_SYS_BFCHP CONSTANT REASON_ID_T:= 2; -- buffer cache hit ratio
162 RSN_FIL_AFRT CONSTANT REASON_ID_T:= 3; -- avg file read time
163 RSN_SVC_ELAPC CONSTANT REASON_ID_T:= 4; -- service elapsed time
164 RSN_EVC_AUWC CONSTANT REASON_ID_T:= 5; -- wait session count
165 RSN_SES_BLUSC CONSTANT REASON_ID_T:= 6; -- blocked users
166 RSN_SYS_GBKCR CONSTANT REASON_ID_T:= 7; -- global cache blocks corrupt
167 RSN_SYS_GBKLS CONSTANT REASON_ID_T:= 8; -- global cache blocks lost
168 RSN_SFTS CONSTANT REASON_ID_T:= 9; -- tablespace alert
169 RSN_LQWT CONSTANT REASON_ID_T:=10; -- long query warning on undo tbs
170 RSN_LQWR CONSTANT REASON_ID_T:=11; -- long query warn on rollback seg
171 RSN_OSAT CONSTANT REASON_ID_T:=12; -- operation suspended on tablespace
172 RSN_OSAR CONSTANT REASON_ID_T:=13; -- oper suspended on rollback seg
173 RSN_OSAD CONSTANT REASON_ID_T:=14; -- operation suspended on data
174 RSN_OSAQ CONSTANT REASON_ID_T:=15; -- operation suspended on quota
175 RSN_SYS_MSRTP CONSTANT REASON_ID_T:=16; -- memory sorts ratio
176 RSN_SYS_RDAHP CONSTANT REASON_ID_T:=17; -- redo allocation hit ratio
177 RSN_SYS_UTXNR CONSTANT REASON_ID_T:=18; -- user transaction per sec
178 RSN_SYS_PHRDR CONSTANT REASON_ID_T:=19; -- physical reads per sec
179 RSN_SYS_PHRDX CONSTANT REASON_ID_T:=20; -- physical reads per txn
180 RSN_SYS_PHWRR CONSTANT REASON_ID_T:=21; -- physical writes per sec
181 RSN_SYS_PHWRX CONSTANT REASON_ID_T:=22; -- physical write per txn
182 RSN_SYS_PRDDR CONSTANT REASON_ID_T:=23; -- physical reads direct per sec
183 RSN_SYS_PRDDX CONSTANT REASON_ID_T:=24; -- physical reads direct per txn
184 RSN_SYS_PWRDR CONSTANT REASON_ID_T:=25; -- physical writes direct per sec
185 RSN_SYS_PWRDX CONSTANT REASON_ID_T:=26; -- physcial writes direct per txn
186 RSN_SYS_PRDLR CONSTANT REASON_ID_T:=27; -- phys reads direct lobs per sec
187 RSN_SYS_PRDLX CONSTANT REASON_ID_T:=28; -- phys reads direct lobs per txn
188 RSN_SYS_PWDLR CONSTANT REASON_ID_T:=29; -- phys writes direct lobs per sec
189 RSN_SYS_PWDLX CONSTANT REASON_ID_T:=30; -- phys writes direct lobs per txn
190 RSN_SYS_RDGNR CONSTANT REASON_ID_T:=31; -- redo generated per sec
191 RSN_SYS_LGNTR CONSTANT REASON_ID_T:=32; -- logons per sec
192 RSN_SYS_LGNTX CONSTANT REASON_ID_T:=33; -- logons per txn
193 RSN_SYS_OCSTR CONSTANT REASON_ID_T:=34; -- open cursors per sec
194 RSN_SYS_OCSTX CONSTANT REASON_ID_T:=35; -- open cursors per txn
195 RSN_SYS_UCMTR CONSTANT REASON_ID_T:=36; -- user commits per sec
196 RSN_SYS_UCMTP CONSTANT REASON_ID_T:=37; -- user commits percentage
197 RSN_SYS_URBKR CONSTANT REASON_ID_T:=38; -- user rollbacks per sec
198 RSN_SYS_URBKP CONSTANT REASON_ID_T:=39; -- user rollbacks percentage
199 RSN_SYS_UCALR CONSTANT REASON_ID_T:=40; -- user calls per sec
200 RSN_SYS_UCALX CONSTANT REASON_ID_T:=41; -- user calls per txn
201 RSN_SYS_RCALR CONSTANT REASON_ID_T:=42; -- recursive calls per sec
202 RSN_SYS_RCALX CONSTANT REASON_ID_T:=43; -- recursive calls per txn
203 RSN_SYS_SLRDR CONSTANT REASON_ID_T:=44; -- logical reads per sec
204 RSN_SYS_SLRDX CONSTANT REASON_ID_T:=45; -- logical reads per txn
205 RSN_SYS_DWCPR CONSTANT REASON_ID_T:=46; -- DBWR checkpoints per sec
206 RSN_SYS_BGCPR CONSTANT REASON_ID_T:=47; -- background checkpoints per sec
207 RSN_SYS_RDWRR CONSTANT REASON_ID_T:=48; -- redo writes per sec
208 RSN_SYS_RDWRX CONSTANT REASON_ID_T:=49; -- redo writes per txn
209 RSN_SYS_LTSCR CONSTANT REASON_ID_T:=50; -- long table scans per sec
210 RSN_SYS_LTSCX CONSTANT REASON_ID_T:=51; -- long table scans per txn
211 RSN_SYS_TTSCR CONSTANT REASON_ID_T:=52; -- total table scans per sec
212 RSN_SYS_TTSCX CONSTANT REASON_ID_T:=53; -- total table scans per txn
213 RSN_SYS_FISCR CONSTANT REASON_ID_T:=54; -- full index scans per sec
214 RSN_SYS_FISCX CONSTANT REASON_ID_T:=55; -- full index scans per txn
215 RSN_SYS_TISCR CONSTANT REASON_ID_T:=56; -- total index scans per sec
216 RSN_SYS_TISCX CONSTANT REASON_ID_T:=57; -- total index scans per txn
217 RSN_SYS_TPRSR CONSTANT REASON_ID_T:=58; -- total parse count per sec
218 RSN_SYS_TPRSX CONSTANT REASON_ID_T:=59; -- total parse count per txn
219 RSN_SYS_HPRSR CONSTANT REASON_ID_T:=60; -- hard parse count per sec
220 RSN_SYS_HPRSX CONSTANT REASON_ID_T:=61; -- hard parse count per txn
221 RSN_SYS_FPRSR CONSTANT REASON_ID_T:=62; -- parse failure count per sec
222 RSN_SYS_FPRSX CONSTANT REASON_ID_T:=63; -- parse failure count per txn
223 RSN_SYS_CCHTR CONSTANT REASON_ID_T:=64; -- cursor cache hit ratio
224 RSN_SYS_DSRTR CONSTANT REASON_ID_T:=65; -- disk sort per sec
225 RSN_SYS_DSRTX CONSTANT REASON_ID_T:=66; -- disk sort per txn
226 RSN_SYS_RWPST CONSTANT REASON_ID_T:=67; -- rows per sort
227 RSN_SYS_XNPRS CONSTANT REASON_ID_T:=68; -- execute without parse ratio
228 RSN_SYS_SFPRP CONSTANT REASON_ID_T:=69; -- soft parse ratio
229 RSN_SYS_UCALP CONSTANT REASON_ID_T:=70; -- user calls ratio
230 RSN_SYS_NTWBR CONSTANT REASON_ID_T:=71; -- network traffic volume per sec
231 RSN_SYS_EQTOR CONSTANT REASON_ID_T:=72; -- enqueue timeouts per sec
232 RSN_SYS_EQTOX CONSTANT REASON_ID_T:=73; -- enqueue timeouts per txn
233 RSN_SYS_EQWTR CONSTANT REASON_ID_T:=74; -- enqueue waits per sec
234 RSN_SYS_EQWTX CONSTANT REASON_ID_T:=75; -- enqueue waits per txn
235 RSN_SYS_EQDLR CONSTANT REASON_ID_T:=76; -- enqueue deadlocks per sec
236 RSN_SYS_EQDLX CONSTANT REASON_ID_T:=77; -- enqueue deadlocks per txn
237 RSN_SYS_EQRQR CONSTANT REASON_ID_T:=78; -- enqueue requests per sec
238 RSN_SYS_EQRQX CONSTANT REASON_ID_T:=79; -- enqueue requests per txn
239 RSN_SYS_DBBGR CONSTANT REASON_ID_T:=80; -- db block gets per sec
240 RSN_SYS_DBBGX CONSTANT REASON_ID_T:=81; -- db block gets per txn
241 RSN_SYS_CRGTR CONSTANT REASON_ID_T:=82; -- consistent read gets per sec
242 RSN_SYS_CRGTX CONSTANT REASON_ID_T:=83; -- consistent read gets per txn
243 RSN_SYS_DBBCR CONSTANT REASON_ID_T:=84; -- db block changes per sec
244 RSN_SYS_DBBCX CONSTANT REASON_ID_T:=85; -- db block changes per txn
245 RSN_SYS_CRCHR CONSTANT REASON_ID_T:=86; -- consistent read changes per sec
246 RSN_SYS_CRCHX CONSTANT REASON_ID_T:=87; -- consistent read changes per txn
247 RSN_SYS_CPUUR CONSTANT REASON_ID_T:=88; -- cpu usage per sec
248 RSN_SYS_CPUUX CONSTANT REASON_ID_T:=89; -- cpu usage per txn
249 RSN_SYS_CRBCR CONSTANT REASON_ID_T:=90; -- cr blocks created per sec
250 RSN_SYS_CRBCX CONSTANT REASON_ID_T:=91; -- cr blocks created per txn
251 RSN_SYS_CRRAX CONSTANT REASON_ID_T:=92; -- cr undo records applied per txn
255 RSN_SYS_LNSPX CONSTANT REASON_ID_T:=96; -- leaf node splits per txn
252 RSN_SYS_RBRAR CONSTANT REASON_ID_T:=93; -- user rollbk undorec appl per sec
253 RSN_SYS_RBRAX CONSTANT REASON_ID_T:=94; -- user rollbk undorec appl per txn
254 RSN_SYS_LNSPR CONSTANT REASON_ID_T:=95; -- leaf node splits per sec
256 RSN_SYS_BNSPR CONSTANT REASON_ID_T:=97; -- branch node splits per sec
257 RSN_SYS_BNSPX CONSTANT REASON_ID_T:=98; -- branch node splits per txn
258 RSN_SYS_PX25R CONSTANT REASON_ID_T:=99; -- px downgraded 25% or more per sec
259 RSN_SYS_PX50R CONSTANT REASON_ID_T:=100; -- px downgraded 50% or more per sec
260 RSN_SYS_PX75R CONSTANT REASON_ID_T:=101; -- px downgraded 75% or more per sec
261 RSN_SYS_PXDGR CONSTANT REASON_ID_T:=102; -- px downgraded per sec
262 RSN_SYS_PXSRR CONSTANT REASON_ID_T:=103; -- px downgraded to serial per sec
263 RSN_SYS_GACRT CONSTANT REASON_ID_T:=104; -- global cache average CR get time
264 RSN_SYS_GACUT CONSTANT REASON_ID_T:=105; -- global cache ave current get time
265 RSN_SYS_LGONC CONSTANT REASON_ID_T:=106; -- current logons count
266 RSN_SYS_OPCSC CONSTANT REASON_ID_T:=107; -- current open cursors count
267 RSN_SYS_USLMP CONSTANT REASON_ID_T:=108; -- user limit %
268 RSN_SYS_SQSRT CONSTANT REASON_ID_T:=109; -- sql service response time
269 RSN_SYS_DBWTT CONSTANT REASON_ID_T:=110; -- database wait time ratio
270 RSN_SYS_DBCPT CONSTANT REASON_ID_T:=111; -- database cpu time ratio
271 RSN_SYS_RSPTX CONSTANT REASON_ID_T:=112; -- response time per txn
272 RSN_SYS_RCHTR CONSTANT REASON_ID_T:=113; -- row cache hit ratio
273 RSN_SYS_LCHTR CONSTANT REASON_ID_T:=114; -- library cache hit ratio
274 RSN_SYS_LCMSR CONSTANT REASON_ID_T:=115; -- library cache miss ratio
275 RSN_SYS_SPFRP CONSTANT REASON_ID_T:=116; -- shared pool free %
276 RSN_SYS_PGCHR CONSTANT REASON_ID_T:=117; -- pga cache hit %
277 RSN_SYS_PRCLP CONSTANT REASON_ID_T:=118; -- process limit %
278 RSN_SYS_SESLP CONSTANT REASON_ID_T:=119; -- session limit %
279 RSN_FIL_AFWT CONSTANT REASON_ID_T:=120; -- avg file write time
280 RSN_EVC_DTSW CONSTANT REASON_ID_T:=121; -- total time waited
281 RSN_SYS_RCMSR CONSTANT REASON_ID_T:=122; -- row cache miss ratio
282 RSN_RADL CONSTANT REASON_ID_T:=123; -- recovery area disk limit alerts
283 RSN_SYS_RDGNX CONSTANT REASON_ID_T:=124; -- redo generated per txn
284 RSN_SYS_CRRAR CONSTANT REASON_ID_T:=125; -- cr undo records applied per sec
285 RSN_SYS_THNTF CONSTANT REASON_ID_T:=126; -- threshold notice on system type
286 RSN_FIL_THNTF CONSTANT REASON_ID_T:=127; -- threshold notice on file type
287 RSN_EVC_THNTF CONSTANT REASON_ID_T:=128; -- threshold notice on event class
288 RSN_SVC_THNTF CONSTANT REASON_ID_T:=129; -- threshold notice on service
289 RSN_TBS_THNTF CONSTANT REASON_ID_T:=130; -- threshold notice on tablespace
290 RSN_SVC_CPUPC CONSTANT REASON_ID_T:=131; -- cpu time per user call
291 RSN_SES_THNTF CONSTANT REASON_ID_T:=132; -- threshold notice on sessions
292 RSN_SFBTS CONSTANT REASON_ID_T:=133; -- tablespace bytes based thresholds
293 RSN_SYS_INQPR CONSTANT REASON_ID_T:=134; -- instance should be quiesced
294 RSN_FAN_INSTANCE_UP CONSTANT REASON_ID_T:=135; -- instance up
295 RSN_FAN_INSTANCE_DOWN CONSTANT REASON_ID_T:=136; -- instance down
296 RSN_FAN_SERVICE_UP CONSTANT REASON_ID_T:=137; -- service up
297 RSN_FAN_SERVICE_DOWN CONSTANT REASON_ID_T:=138; -- service down
298 RSN_FAN_SERVICE_MEMBER_UP CONSTANT REASON_ID_T:=139; -- svc member up
299 RSN_FAN_SERVICE_MEMBER_DOWN CONSTANT REASON_ID_T:=140; -- svc member down
300 RSN_FAN_SVC_PRECONNECT_UP CONSTANT REASON_ID_T:=141; -- preconnect up
301 RSN_FAN_SVC_PRECONNECT_DOWN CONSTANT REASON_ID_T:=142; -- preconnect down
302 RSN_FAN_NODE_DOWN CONSTANT REASON_ID_T:=143; -- node down
303 RSN_FAN_ASM_INSTANCE_UP CONSTANT REASON_ID_T:=144; -- asm instance up
304 RSN_FAN_ASM_INSTANCE_DOWN CONSTANT REASON_ID_T:=145; -- asm inst down
305 RSN_FAN_DATABASE_UP CONSTANT REASON_ID_T:=146; -- database up
306 RSN_FAN_DATABASE_DOWN CONSTANT REASON_ID_T:=147; -- database down
307 RSN_SYS_DBTMR CONSTANT REASON_ID_T:=148; -- DB Time per Sec
308 RSN_SYS_XCNTR CONSTANT REASON_ID_T:=149; -- Executions Per Sec
309 RSN_STR_CAPTURE_ABORTED CONSTANT REASON_ID_T:=150; -- capture aborted
310 RSN_STR_APPLY_ABORTED CONSTANT REASON_ID_T:=151; -- apply aborted
311 RSN_STR_PROPAGATION_ABORTED CONSTANT REASON_ID_T:=152; -- propgatn aborted
312 RSN_STR_STREAMSPOOL_FREE_PCT CONSTANT REASON_ID_T:=153; -- streamspool free
313 RSN_STR_ERROR_QUEUE CONSTANT REASON_ID_T:=154;
314 -- new entry in error queue
315 RSN_LOG_ARCHIVE_LOG_GAP CONSTANT REASON_ID_T:=155;
316 -- archived log gap for logminer
317 RSN_SYS_ACTVS CONSTANT REASON_ID_T:=156; -- average active sessions
318 RSN_SYS_SRLAT CONSTANT REASON_ID_T:=157;
319 -- Avg synchronous single-blk read latency
320 RSN_SYS_IOMBS CONSTANT REASON_ID_T:=158; -- i/o megabytes
321 RSN_SYS_IOREQ CONSTANT REASON_ID_T:=159; -- i/o requests
322 RSN_WCR_IOLAT CONSTANT REASON_ID_T:=160; --average IO latency
323 RSN_WCR_PCPU CONSTANT REASON_ID_T:=161; -- % of replay threads on CPU
324 RSN_WCR_PIO CONSTANT REASON_ID_T:=162; -- % of replay threads doing IO
325 RSN_WRC_THNTF CONSTANT REASON_ID_T:=163; -- threshold notice on WRCLIENT type
326 RSN_WRC_STATUS CONSTANT REASON_ID_T:=164; -- change of status for capt/replay
327 RSN_STR_SPLIT_MERGE CONSTANT REASON_ID_T:=166; -- auto split/merge
328 RSN_XSTR_CAPTURE_ABORTED CONSTANT REASON_ID_T:=167; -- capture aborted
329 RSN_XSTR_APPLY_ABORTED CONSTANT REASON_ID_T:=168; -- apply aborted
330 RSN_XSTR_PROPAGATION_ABORTED CONSTANT REASON_ID_T:=169; -- propgatn aborted
331 RSN_XSTR_ERROR_QUEUE CONSTANT REASON_ID_T:=170;
332 -- new entry in error queue
333 RSN_XSTR_SPLIT_MERGE CONSTANT REASON_ID_T:=171; -- auto split/merge
334 RSN_GG_CAPTURE_ABORTED CONSTANT REASON_ID_T:=172; -- capture aborted
335 RSN_GG_APPLY_ABORTED CONSTANT REASON_ID_T:=173; -- apply aborted
336 RSN_GG_PROPAGATION_ABORTED CONSTANT REASON_ID_T:=174; -- propgatn aborted
337 RSN_GG_ERROR_QUEUE CONSTANT REASON_ID_T:=175;
338 -- new entry in error queue
339 RSN_GG_SPLIT_MERGE CONSTANT REASON_ID_T:=176; -- auto split/merge
340
341 RSN_GDS_GSM_DOWN CONSTANT REASON_ID_T:=177; -- GDS GSM down
342 RSN_GDS_INSTANCE_DOWN CONSTANT REASON_ID_T:=178; --GDS instance down
343 RSN_GDS_SVC_CARD_MISSED CONSTANT REASON_ID_T:=179;
344 -- GDS svc cardinality missed
345 RSN_GDS_SVC_THRESH CONSTANT REASON_ID_T:=180; -- GDS svc threshold
346 RSN_GDS_SVC_LAG CONSTANT REASON_ID_T:=181; -- GDS svc lagging
347 RSN_GDS_CATALOG_DOWN CONSTANT REASON_ID_T:=182; --GDS catalog down
348 RSN_GDS_DATABASE_DOWN CONSTANT REASON_ID_T:=183; --GDS database down
349
350
351 -- procedure to set warning and critical thresholds
352 procedure set_threshold(
353 metrics_id IN BINARY_INTEGER,
354 warning_operator IN BINARY_INTEGER,
355 warning_value IN VARCHAR2,
356 critical_operator IN BINARY_INTEGER,
357 critical_value IN VARCHAR2,
358 observation_period IN BINARY_INTEGER,
359 consecutive_occurrences IN BINARY_INTEGER,
360 instance_name IN VARCHAR2,
361 object_type IN BINARY_INTEGER,
362 object_name IN VARCHAR2);
363
364 -- procedure to get threshold setting
365 procedure get_threshold(
366 metrics_id IN BINARY_INTEGER,
367 warning_operator OUT BINARY_INTEGER,
368 warning_value OUT VARCHAR2,
369 critical_operator OUT BINARY_INTEGER,
370 critical_value OUT VARCHAR2,
371 observation_period OUT BINARY_INTEGER,
372 consecutive_occurrences OUT BINARY_INTEGER,
373 instance_name IN VARCHAR2,
374 object_type IN BINARY_INTEGER,
375 object_name IN VARCHAR2);
376
377 -- function to expand alert messages
378 function expand_message(
379 user_language in varchar2,
380 message_id in number,
381 argument_1 in varchar2,
382 argument_2 in varchar2,
383 argument_3 in varchar2,
384 argument_4 in varchar2,
385 argument_5 in varchar2,
386 objargpos in number default -1,
387 pdb_name in varchar2 default NULL)
388 RETURN varchar2;
389
390 FUNCTION view_thresholds
391 RETURN threshold_type_set PIPELINED;
392
393 END dbms_server_alert;