|
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 | 
转播
