ORACLE10g設定資料庫臨界值警告

E:\Documents and Settings\Administrator>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 10月 15 23:09:08 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn / as sysdba
已連線.
SQL> create tablespace test datafile 'test01.dbf' size 1m extent management loca
l uniform size 200k
2 ;

已建立表格空間.
(warning alert at 75% full, critical at 90% full)
SQL> exec dbms_server_alert.set_threshold(dbms_server_alert.tablespace_pct_full,
dbms_server_alert.operator_ge,'75',dbms_server_alert.operator_ge,'90',1,1,null,d
bms_server_alert.object_type_tablespace,'TEST');

已順利完成 PL/SQL 程序.

SQL> create table test_table (name varchar2(30)) tablespace test storage(minexte
nts 4);

已建立表格.

SQL> select reason from dba_outstanding_alerts
2 ;

REASON
--------------------------------------------------------------------------------

db_recovery_file_dest_size (2147483648 個位元組) 已經使用 %s%%, 還有97.64%可用的

SQL> ALTER TABLESPACE "TEST" ADD DATAFILE 'user06.dbf' SIZE 100M
2 ;

已更改表格空間.