摘要：
先判断flash_recovery_area的利用率，如果超过10%则自动调度rman对日志进行归档AIX Version 6.1,Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bi#!/bin/shecho "---------------begin date-------------"dateexport ORACLE_HOME=/oracle/product/10.2export ORACLE_SID=orclexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBK 阅读全文
摘要：
做imp导入的时候报这个错误提示SQL> SQL> show parameter sga NAME TYPE VALUE------------------------------------ ----------- ------------------------------lock_sga boolean FALSEpre_page_sga boolean FALSEsga_max_size ... 阅读全文
摘要：
新建jobdbms_job.submit(JOB OUT BINARY_INTEGER,WHAT IN VARCHAR2, NEXT_DATE IN DATE DEFAULT SYSDATE, INTERVAL IN VARCHAR2 DEFAULT 'NULL',NO_PARSE IN BOOLEAN DEFAULT FALSE,INSTANCE IN BINARY_INTEGER DEFAULT 0,FORCE IN BOOLEAN DEFAULT FALSE);例如：declare... 阅读全文