10g features related general notes

More notes: http://www.globusz.com/ebooks/Oracle/00000010.htm

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