CSDN博客

img midzhou

oracle读书笔记

发表于2004/7/1 15:58:00  757人阅读

查看错误代码

oerr ora ?

日志文件

archive log list;

日志的groupmember是互为镜像的.

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

0 0

相关博文

我的热门文章

img
取 消
img