To change Thresholds
BEGIN
DBMS_SERVER_ALERT.SET_THRESHOLD(
METRICS_ID => dbms_server_alert.tablespace_pct_full,
WARNING_OPERATOR => dbms_server_alert.operator_ge,
WARNING_VALUE => '55',
CRITICAL_OPERATOR => dbms_server_alert.operator_ge,
CRITICAL_VALUE => '80',
OBSERVATION_PERIOD => 1,
CONSECUTIVE_OCCURRENCES => 1,
INSTANCE_NAME => NULL,
OBJECT_TYPE => dbms_server_alert.object_type_tablespace,
OBJECT_NAME => 'USERS');
END;
/
To turn of alerts for USERS tablespace
BEGIN
DBMS_SERVER_ALERT.SET_THRESHOLD(
METRICS_ID => dbms_server_alert.tablespace_pct_full,
WARNING_OPERATOR => dbms_server_alert.operator_do_not_check,
WARNING_VALUE => '0',
CRITICAL_OPERATOR => dbms_server_alert.operator_do_not_check,
CRITICAL_VALUE => '0',
OBSERVATION_PERIOD => 1,
CONSECUTIVE_OCCURRENCES => 1,
INSTANCE_NAME => NULL,
OBJECT_TYPE => dbms_server_alert.object_type_tablespace,
OBJECT_NAME => 'USERS');
END;
/
select * from RECYCLEBIN;
PURGE RECYCLEBIN;
DROP TABLE emp PURGE;
Search OPDG in metalink for perf tuning guide
Oracle Patch: http://www.oracle.com/technology/support/patches.htm
Oracle Alert: http://www.oracle.com/technology/deploy/security/alerts.htm
Back to fixed size SGA (on the fly):
alter system set sga_max_size=2G scope=spfile;
alter system set sga_target=0M scope=both;
alter system set shared_pool_size=384M scope=both;
alter system set db_cache_size=416M scope=both;
alter system set java_pool_size=16M scope=both;
alter system set large_pool_size=16M scope=both;
show parameter sga_max_size;
show parameter sga_target;
show parameter shared_pool_size;
show parameter db_cache_size;
show parameter java_pool_size;
show parameter large_pool;
Clean delete of database on Linux (so next install uses the original ports and files)
Remove entires from:
/u01/oracle/product/10.2.0/install/portlist.ini
rm $ORACLE_HOME/plumtree.com_NIDB
rm $ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_plumtree.com_NIDB
