以下是statspack中的语句,不知道是哪里产生的,应用程序中查找了没有这样的sql语句啊SQL ordered by Gets for DB: WWWDB Instance: wwwdb1 Snaps: 1790 -1791
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL includes the resources used by
all SQL statements called within the PL/SQL code. As individual SQL
statements are also reported, it is possible and valid for the summed
total % to exceed 100 CPU Elapsd
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
343,271,419 3,518 97,575.7 58.4 1277.22 1273.13 2065199525
select * from (select null TABLE_CATALOG, ac.owner TABLE_SCHEMA,
ac.table_name TABLE_NAME, acc.column_name COLUMN_NAME, null COL
UMN_GUID, null COLUMN_PROPID, acc.position ORDINAL from all_cons
traints ac, all_cons_columns acc where ac.owner = acc.owner and
ac.table_name = acc.table_name and ac.constraint_type = :"SYS_B_
0" and ac.constraint_name = acc.constraint_name) DBSCHEMA_PRIMAR
Y_KEYS WHERE TABLE_NAME = :"SYS_B_1" order by :"SYS_B_2", :"SYS
_B_3" 189,330,661 3,517 53,833.0 32.2 939.43 941.58 91741357
select * from (select null TABLE_CATALOG, idx.table_owner TABLE_
SCHEMA, idx.table_name TABLE_NAME, null INDEX_CATALOG, idx.owner
INDEX_SCHEMA, idx.index_name INDEX_NAME, null PRIMARY_KEY, deco
de(idx.uniqueness, :"SYS_B_00", -:"SYS_B_01", :"SYS_B_02") UNIQU
E_,null CLUSTERED,null TYPE, null FILL_FACTOR, idx.initial_exten
t INITIAL_SIZE, null NULLS, null SORT_BOOKMARKS, -:"SYS_B_03" AU
TO_UPDATE, :"SYS_B_04" NULL_COLLATION, col.column_position ORDIN
AL_POSITION, col.column_name COLUMN_NAME, null COLUMN_GUID, null
COLUMN_PROPID, :"SYS_B_05" COLLATION, null CARDINALITY, null PA
GES, null FILTER_CONDITION, null INTEGRATED from all_indexes idx
, all_ind_columns col where idx.owner = col.index_owner and idx.
index_name = col.index_name and idx.table_owner = col.table_own
er and idx.table_name = col.table_name ) DBSCHEMA_INDEXES WHER
E TABLE_NAME = :"SYS_B_06" order by :"SYS_B_07", :"SYS_B_08", :"
SYS_B_09", :"SYS_B_10", :"SYS_B_11" 22,976,094 32,870 699.0 3.9 95.62 94.51 1231109843
select to_char(null), ac.owner, ac.table_name, acc.column_name,
acc.position, ac.constraint_name from all_constraints ac, all_co
ns_columns acc where ac.owner=acc.owner and ac.constraint_type=
:"SYS_B_0" and ac.constraint_name=acc.constraint_name and ac.ow
ner like :"SYS_B_1" escape :"SYS_B_2" and ac.table_name like :"
SYS_B_3" escape :"SYS_B_4"
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL includes the resources used by
all SQL statements called within the PL/SQL code. As individual SQL
statements are also reported, it is possible and valid for the summed
total % to exceed 100 CPU Elapsd
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
343,271,419 3,518 97,575.7 58.4 1277.22 1273.13 2065199525
select * from (select null TABLE_CATALOG, ac.owner TABLE_SCHEMA,
ac.table_name TABLE_NAME, acc.column_name COLUMN_NAME, null COL
UMN_GUID, null COLUMN_PROPID, acc.position ORDINAL from all_cons
traints ac, all_cons_columns acc where ac.owner = acc.owner and
ac.table_name = acc.table_name and ac.constraint_type = :"SYS_B_
0" and ac.constraint_name = acc.constraint_name) DBSCHEMA_PRIMAR
Y_KEYS WHERE TABLE_NAME = :"SYS_B_1" order by :"SYS_B_2", :"SYS
_B_3" 189,330,661 3,517 53,833.0 32.2 939.43 941.58 91741357
select * from (select null TABLE_CATALOG, idx.table_owner TABLE_
SCHEMA, idx.table_name TABLE_NAME, null INDEX_CATALOG, idx.owner
INDEX_SCHEMA, idx.index_name INDEX_NAME, null PRIMARY_KEY, deco
de(idx.uniqueness, :"SYS_B_00", -:"SYS_B_01", :"SYS_B_02") UNIQU
E_,null CLUSTERED,null TYPE, null FILL_FACTOR, idx.initial_exten
t INITIAL_SIZE, null NULLS, null SORT_BOOKMARKS, -:"SYS_B_03" AU
TO_UPDATE, :"SYS_B_04" NULL_COLLATION, col.column_position ORDIN
AL_POSITION, col.column_name COLUMN_NAME, null COLUMN_GUID, null
COLUMN_PROPID, :"SYS_B_05" COLLATION, null CARDINALITY, null PA
GES, null FILTER_CONDITION, null INTEGRATED from all_indexes idx
, all_ind_columns col where idx.owner = col.index_owner and idx.
index_name = col.index_name and idx.table_owner = col.table_own
er and idx.table_name = col.table_name ) DBSCHEMA_INDEXES WHER
E TABLE_NAME = :"SYS_B_06" order by :"SYS_B_07", :"SYS_B_08", :"
SYS_B_09", :"SYS_B_10", :"SYS_B_11" 22,976,094 32,870 699.0 3.9 95.62 94.51 1231109843
select to_char(null), ac.owner, ac.table_name, acc.column_name,
acc.position, ac.constraint_name from all_constraints ac, all_co
ns_columns acc where ac.owner=acc.owner and ac.constraint_type=
:"SYS_B_0" and ac.constraint_name=acc.constraint_name and ac.ow
ner like :"SYS_B_1" escape :"SYS_B_2" and ac.table_name like :"
SYS_B_3" escape :"SYS_B_4"
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货