Oracle中查找依赖的无效对象(invalid object)
找依赖的无效对象:select do.obj# d_obj,do.name d_name, do.type# d_type, po.obj# p_obj, po.name p_name,to_char(p_timestamp,'DD-MON-YYYY HH24:MI:SS') "P_Timestamp", to_char(po.stime ,'DD-MON-YYYY ...
ORA-00704、ORA-39700处理
原来的数据库11.2.0.1,现在安装的是11.2.0.3 SQL> alter database open; alter database open * 第 1 行出现错误: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option 进程 ID: 292 ...
Oracle 使用大内存出现:ORA-27102
Oracle 使用大内存出现:ORA-271025-1问题现象:发现其sga太小:SQL> show parameter sgaNAME &nbs...