Oracle表实际大小分析脚本 CREATE OR REPLACE FUNCTION REAL_SIZE(P_SEGNAME IN VARCHAR2, P_OWNER IN VARCHAR2 DEFAULT USER, P_TYPE IN VARCHAR2 DEFAULT ‘TABLE’) RETURN NUMBER AUTHID CURRENT_USER AS L_TOT […]

行迁移检测分析脚本 select snap_id, to_char(snap_time, ‘yyyy-mm-dd hh24:mi’) snap_time, v1 “table fetch continued row”, v2 “table fetch by rowid”, decode(v2, 0, 0, trunc(v1 / […]

切换到手机版