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
Bookmarks