6.56 DBA_HIST_SGASTAT 6.57 DBA_HIST_SHARED_POOL_ADVICE 6.58 DBA_HIST_SHARED_SERVER_SUMMARY 6.59 DBA_HIST_SNAP_ERROR 6.60 DBA_HIST_SNAPSHOT 6.61 DBA_HIST_SQL_BIND_METADATA 6.62 DBA_HIST_SQL_PLAN 6.63 DBA_HIST_SQL_SUMMARY 6.64 DBA_HIST_SQL_WORKAREA_HSTGRM 6.65 DBA_HIST_SQLBIND 6.66 DBA_...
FROM dba_hist_sql_plan WHERE sql_id = 'fahv8x6ngrb50' ORDER BY plan_hash_value, id; 重点关注filter_predicates列。 --这一列能帮助推断不走索引的原因。 这一列的查询结果若是为null,那就是正常的。若是不为null,那就须要额外关注不为空的原因。例如以下图所看到的:...
col filter_predicates format a15 SELECT plan_hash_value, id, LPAD (' ', DEPTH) || operation operation, options, object_owner, object_name, optimizer, cost, access_predicates, filter_predicates FROM dba_hist_sql_plan WHERE sql_id = ' fahv8x6ngrb50' ORDER BY plan_hash_value, id; 重点...
6.54 DBA_HIST_SGASTAT 6.55 DBA_HIST_SHARED_POOL_ADVICE 6.56 DBA_HIST_SHARED_SERVER_SUMMARY 6.57 DBA_HIST_SNAP_ERROR 6.58 DBA_HIST_SNAPSHOT 6.59 DBA_HIST_SQL_BIND_METADATA 6.60 DBA_HIST_SQL_PLAN 6.61 DBA_HIST_SQL_SUMMARY 6.62 DBA_HIST_SQL_WORKAREA_HSTGRM 6.63 DBA_HIST_SQLBIND 6.64 DBA_...
6.56 DBA_HIST_SGASTAT 6.57 DBA_HIST_SHARED_POOL_ADVICE 6.58 DBA_HIST_SHARED_SERVER_SUMMARY 6.59 DBA_HIST_SNAP_ERROR 6.60 DBA_HIST_SNAPSHOT 6.61 DBA_HIST_SQL_BIND_METADATA 6.62 DBA_HIST_SQL_PLAN 6.63 DBA_HIST_SQL_SUMMARY 6.64 DBA_HIST_SQL_WORKAREA_HSTGRM 6.65 DBA_HIST_SQLBIND 6.66 DBA_...
5.54 DBA_HIST_SGASTAT 5.55 DBA_HIST_SHARED_POOL_ADVICE 5.56 DBA_HIST_SHARED_SERVER_SUMMARY 5.57 DBA_HIST_SNAP_ERROR 5.58 DBA_HIST_SNAPSHOT 5.59 DBA_HIST_SQL_BIND_METADATA 5.60 DBA_HIST_SQL_PLAN 5.61 DBA_HIST_SQL_SUMMARY 5.62 DBA_HIST_SQL_WORKAREA_HSTGRM 5.63 DBA_HIST_SQLBIND 5.64 DBA_...
5.54 DBA_HIST_SGASTAT 5.55 DBA_HIST_SHARED_POOL_ADVICE 5.56 DBA_HIST_SHARED_SERVER_SUMMARY 5.57 DBA_HIST_SNAP_ERROR 5.58 DBA_HIST_SNAPSHOT 5.59 DBA_HIST_SQL_BIND_METADATA 5.60 DBA_HIST_SQL_PLAN 5.61 DBA_HIST_SQL_SUMMARY 5.62 DBA_HIST_SQL_WORKAREA_HSTGRM 5.63 DBA_HIST_SQLBIND 5.64 DBA_...
5.53 DBA_HIST_SGASTAT 5.54 DBA_HIST_SHARED_POOL_ADVICE 5.55 DBA_HIST_SHARED_SERVER_SUMMARY 5.56 DBA_HIST_SNAP_ERROR 5.57 DBA_HIST_SNAPSHOT 5.58 DBA_HIST_SQL_BIND_METADATA 5.59 DBA_HIST_SQL_PLAN 5.60 DBA_HIST_SQL_SUMMARY 5.61 DBA_HIST_SQL_WORKAREA_HSTGRM 5.62 DBA_HIST_SQLBIND 5.63 DBA_...