7.1 查看执行日志
select * from t_sys_run_log order by 1 desc;--点击页面用到哪些过程
7.2 查询定时job
select * from user_jobs where what like '%t_test%';--过程在此
7.4 查看数据应用的版本
select * from t_sys_info_version;
7.5外键约束错误
使外键失效
alter table tablename drop constraint fname;
使外键生效
alter table tablename enable constraint fname;
7.6 查询锁表
select * from v$locked_object;
7.9 扩展redo空间
--查询日志文件位置
select * from v$logfile ;
--查询日志文件大小
select * from v$log ;
--查询日志状态
select a.status, b.member, a.THREAD#, a.GROUP#
from v$log a, v$logfile b
where a.GROUP# = b.GROUP#;
--删除日志文件(非current状态的)
alter database drop logfile '/opt/oracle/oradata/testtestiread171/redo02.log';
--增加日志文件(与原来的一致)
alter database add logfile group 2 ('/opt/oracle/oradata/testtestiread171/redo02.log') size 512M reuse;
--删除、增加
alter database drop logfile '/opt/oracle/oradata/testtestiread171/redo01.log';
alter database add logfile group 1 ('/opt/oracle/oradata/testtestiread171/redo01.log') size 512M reuse;
--切换日志文件
alter system switch logfile;
alter system checkpoint;
--删除、新增current状态的日志文件
alter database drop logfile '/opt/oracle/oradata/testtestiread171/redo03.log';
alter database add logfile group 3 ('/opt/oracle/oradata/testtestiread171/redo03.log') size 512M
select * from t_sys_run_log order by 1 desc;--点击页面用到哪些过程
7.2 查询定时job
select * from user_jobs where what like '%t_test%';--过程在此
7.4 查看数据应用的版本
select * from t_sys_info_version;
7.5外键约束错误
使外键失效
alter table tablename drop constraint fname;
使外键生效
alter table tablename enable constraint fname;
7.6 查询锁表
select * from v$locked_object;
7.9 扩展redo空间
--查询日志文件位置
select * from v$logfile ;
--查询日志文件大小
select * from v$log ;
--查询日志状态
select a.status, b.member, a.THREAD#, a.GROUP#
from v$log a, v$logfile b
where a.GROUP# = b.GROUP#;
--删除日志文件(非current状态的)
alter database drop logfile '/opt/oracle/oradata/testtestiread171/redo02.log';
--增加日志文件(与原来的一致)
alter database add logfile group 2 ('/opt/oracle/oradata/testtestiread171/redo02.log') size 512M reuse;
--删除、增加
alter database drop logfile '/opt/oracle/oradata/testtestiread171/redo01.log';
alter database add logfile group 1 ('/opt/oracle/oradata/testtestiread171/redo01.log') size 512M reuse;
--切换日志文件
alter system switch logfile;
alter system checkpoint;
--删除、新增current状态的日志文件
alter database drop logfile '/opt/oracle/oradata/testtestiread171/redo03.log';
alter database add logfile group 3 ('/opt/oracle/oradata/testtestiread171/redo03.log') size 512M