idl_ub1$表是用来存储PL/SQL的代码单元的,包括DIANA等,IDL在这里代表Interface Definition Language. 这个对象的含义可以从Ixora找到一点提示: It is an intermediate language in which the structure of database tables and the logic of PL/SQL program units can be consistently represented as attributed trees. ...
truncate table IDL_UB1$ Hello, I would ask you, does it safe to truncate table IDL_UB1$ ? I use Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit I use following query to check segment size for tablespace "SYSTEM" select owner,segment_name,segment_type ,bytes/(1024*1024...
ind$ i where i.bo#=:1 and i.obj#=c.obj# and c.intcol#=:2select 1 from subpartcol$ c,ind$ i where i.bo#=:1 and i.obj#=c.obj# and c.intcol#=:2delete from idl_ub1$ where
但是IDL_UB1$和对应的index I_IDL_UB11 obj#,dataobj#均已经改变,而且相关对象的segment header也变化为新dataobj#(truncate之后的),也就是说truncate在数据库中的主要更改操作已经完成.现在在缺少记录的情况下,数据库执行如下sql无法获取记录,从而无法open...
select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece from idl_ub1$ where cvn54b7yz0s8u 6455976 220128 6427409 select s.synonym_name object_name, o.object_type from sys.all_synonyms s, s fqmpmkfr6pqyk 11814078 6958760 3189450 ...
idl_ub2$ idl_sb4$ idl_ub1$ settings$ warning_settings$ procedureinfo$ access$ obj$ 注意以上这些数据字典基表都存放在SYSTEM表空间上,丢失SYSTEM表空间也就意味着你可能找不回这些程序了(如果你没有其他备份的话),即使使用DUL工具也无法挽回。 我来简单介绍一下这些数据字典基表( 11g以前可以在sql.bsq文件...
IDL_UB1$ TABLE 248 SOURCE$ TABLE 64 IDL_UB2$ TABLE 30 C_TOID_VERSION# CLUSTER 23 C_OBJ#_INTCOL# CLUSTER 15 I_SOURCE1 INDEX 12 C_OBJ# CLUSTER 11 JAVA$MC$ TABLE 11 ARGUMENT$ TABLE 11 IDL_CHAR$ TABLE 10 OBJ$ TABLE 8 SEGMENT_NAME PARTITION_NAME SEGMENT_TYPE BYTES/1024/1024 --- ...
功,报了ORA-1653: unable to extend table SYS.IDL_UB1$ by 1024 in tablespace SYSTEM这个错误。去看了看alert文件发现如下提示 提示说我的System表空间的容量不够大,所以我查了一下我的system表空间 的利用情况,发现如下问题: 通过上图发现原来我的System表空间容量不足了,只剩下3.81M。
/*+ index(idl_ub1$ i_id... 0.52 91 0.01 8.28 2.12 98.76 39m4sx9k63ba2 select /*+ index(idl_ub2$ i_id... 0.51 1 0.51 8.22 3.11 97.01 cd1q0zw912c1p insert into wrh$_service_stat ... 0.44 1 0.44 7.05 1.13 98.49 daa1t30srjkgy insert into wrh$_waitstat (dbi...
BYTES SEGMENT_NAME SEGMENT_TYPE OWNER 8053063680 AUD$ TABLE SYS 285212672 C_OBJ#_INTCOL# CLUSTER SYS 285212672 IDL_UB1$ TABLE SYS 75497472 SOURCE$ TABLE SYS 49283072 I_H_OBJ#_COL# INDEX SYS 47185920 HIST_HEAD$ TABLE SYS 33554432 IDL_UB2$ TABLE SYS 27262976 I_HH_OBJ#_COL# INDEX SYS 26214...