4

 

11 备份配置文件
create pfile='/home/oracle/db/admin/ora01/pfile/initxbb20090610.ora' from spfile;
恢复配置文件
create spfile from pfile='/home/oracle/db/admin/ora01/pfile/initxbb20090610.ora';

12 linux下oracle启动时提示ORA-00845: MEMORY_TARGET not supported on this system
主要是linux没有挂载点/dev/shm，用如下命令就可以了，大小必须大于设定的MEMORY_TARGET值
mount -t tmpfs shmfs -o size=10G /dev/shm

13 查看SQL是否使用索引
EXPLAIN PLAN
SET STATEMENT_ID = 'demo01' FOR
SELECT e.last_name, d.department_name
FROM hr.employees e, hr.departments d
WHERE e.department_id = d.department_id;
Explained.

SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY());

14 备份数据库
exp otuserdb/otuserdb owner=otuserdb rows=y compress=n buffer=65536 feedback=100000 volsize=0 full=y file=exp_otuserdb.dmp
exp ops\$frscu/frscu owner=ops\$frscu rows=y compress=n buffer=65536 feedback=100000 volsize=0 full=y file=exp_scpdb.dmp

exp ops\$frscu/frscu@scpdb rows=y indexes=y compress=n buffer=65536 feedback=100000 volsize=0 full=y file=exp_scpdb.dmp log=exp_scpdb.dmp.log

exp  ops\$frscu/frscu  buffer=65536 file=exp_scpdb.dmp full=y    rows=y   compress=n log=exp_scpdb.dmp.log
exp  cbpdb/cbpdb  buffer=65536 file=exp_cbpdb.dmp full=y    rows=y   compress=n log=exp_cbpdb.dmp.log

14 导入数据库

imp ops\$frscu/frscu full=y file=exp_scpdb.dmp log=exp_scpdb.dmp.log rows=y commit=y buffer=65536 ignore=y
imp cbpdb/cbpdb full=y file=exp_cbpdb.dmp log=exp_cbpdb.dmp.log rows=y commit=y buffer=65536 ignore=y

 

15 更新表的统计信息
analyze table customer     compute statistics;