piece long raw not null) /* ub1 piece */ storage (initial 10k next 100k maxextents unlimited pctincrease 0) / idl_ub1$表是用来存储PL/SQL的代码单元的,包括DIANA等,IDL在这里代表Interface Definition Language. 这个对象的含义可以从Ixora找到一点提示: It is an intermediate language in which the stru...
where tablespace_name = 'SYSTEM' and bytes/(1024*1024) > 1 order by size_m desc Result below: SYSIDL_UB1$TABLE14986 SYSI_SOURCE1INDEX9163 SYSSOURCE$TABLE6649 SYSIDL_UB2$TABLE2797 SYSI_WARNING_SETTINGSINDEX2784 SYSARGUMENT$TABLE1232 SYSI_ARGUMENT1INDEX1090 SYSWARNING_SETTINGS$TABLE882 SYSIDL_C...
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 a db78fxqxwxt7r 2737680 193937 2689611 select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece from idl_ub2$ where 39m4sx9k63ba2 2322664 108100 2307700 当然,获取最消耗时间或者等待时间最长的...
delete from idl_ub1$ where obj#=:1 delete from idl_char$ where obj#=:1 delete from idl_ub2$ where obj#=:1 delete from idl_sb4$ where obj#=:1 delete from error$ where obj#=:1 select o.owner#, o.name, o.namespace, o.obj#, d.d_timestamp, nvl(d.property,0), o.type#, ...
有类似:select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#的查询语句,由于该表被truncate之后,导致数据库启动无法绕过该sql,而hang住无法完全open成功.下午闲着没事通过模拟,可以对该故障实现正常open,并且导出...
OWNER|TABLE_NAME|allocated MB|used MB|reserved(d.pct_free) MB|waste_MB---|---|---|---|---|---SYS|IDL_UB1$|266.02|.9|26.6|238.52SYS|IDL_UB2$|30.66|.28|3.07|27.32SYS|COLLECTION$|23.27|.07|2.33|20.87SYS|TYPE$|23.27|.22|2.33|20.72SYS|ATTRIBUTE$|23.27|.73|2.33|20.21SYS|RESULT...
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 --- ...
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...
n I_ARGUMENT1 n I_SOURCE1I$ n SOURCE$ n TRIGGER If necessary, increase storage parameters to accommodate storage requirements of large numbers of replicated objects. 请参考eygle的文章( :// eygle /archives/2007/01/idl_ub1_table.html) 系统对象IDL_UB1$表的含义及作用 在ITPUB上有朋友遇到SYSTEM...
33554432 IDL_UB2$ TABLE SYS 27262976 I_HH_OBJ#_COL# INDEX SYS 26214400 I_HH_OBJ#_INTCOL# INDEX SYS 9 rows selected. 二、原因 数据库开启了审计,可以通过参数查看。 SQL> show parameter audit_trail; NAME TYPE VALUE audit_trail string DB ...