-
dbms_server_alert.get_threshold returns threshold not found
What am I doing wrong?
Ramolix[oracle] /usr/local/oracle > sqlplus "sys/password@staging as sysdba"
SQL*Plus: Release 10.1.0.4.0 - Production on Fri Dec 1 11:07:37 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Release 10.1.0.4.0 - 64bit Production
SQL>
set serveroutput on
DECLARE
vWarnOp NUMBER(10);
vWarnVal VARCHAR2(100);
vCritOp NUMBER(10);
vCritVal VARCHAR2(100);
vObsvPer NUMBER(5);
vConOcur NUMBER(5);
BEGIN
dbms_server_alert.get_threshold(dbms_server_alert.tablespace_pct_full, vWarnOp, vWarnVal, vCritOp, vCritVal, vObsvPer, vConOcur, NULL, dbms_server_alert.object_type_tablespace, 'JOHAN');
dbms_output.put_line('WarnOp: ' || TO_CHAR(vWarnOp));
dbms_output.put_line('WarnVal: ' || vWarnVal);
dbms_output.put_line('CritOp: ' || TO_CHAR(vCritOp));
dbms_output.put_line('CritVal: ' || vCritVal);
END;
/
returns:
ORA-13799: threshold not found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_SERVER_ALERT", line 140
ORA-06512: at line 9
tablespace JOHAN exists!
Please help.
Thx,
Johan
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|