查看错误代码
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