oracle读书笔记

查看错误代码

oerr ora ?

日志文件

archive log list;

日志的group里member是互为镜像的.

alter system swith logfile; 强制系统日志切换

相关视图: v$logfile v$log

更换/删除日志文件:

1.shutdown (为更快shutdown,可先startup force;)

2.将日志文件剪贴至指定目录

3.alter database rename file ‘D:/ORACLE/log1c.RDO’ to ‘C:/ORACLE/log1c.RDO’

  alter database drop logfile member ‘C:/ORACLE/log1c.RDO’

如日志处于运行状态,可执行一次日志切换.

创建表结构

带记录创建表

create table auditing.tb_balance_bak as select * from auditing.tb_balance

不带记录创建表

create table auditing.tb_balance_bak as select * from auditing.tb_balance where 1=2

查看进程及杀死进程

select * from v$session where program like '%JDBC%'

alter system kill session '12,29260'

分析表

analyze table init.tb_balance compute statistics

但有可能原来能用索引的语句经分析后不再使用索引

alter session set OPTIMIZER_DYNAMIC_SAMPLING =50

alter session set optimizer_index_cost_id =50