但是awr是反映系统情况的,是不是系统后台进程反而是最需要调整的呢?
大家的系统是否也是这样!
应外有些系统明明是系统的SQL, sql module里确显示为用户的应用。
如下例示:
select null, i.owner, i.table_name, decode (i.uniqueness, 'UNIQUE', 0, 1), null, i.index_name, 3, c.column_position, c.column_name, 'A', i.distinct_keys, i.leaf_blocks, null from all_indexes i, all_ind_columns c where i.owner = c.index_owner and i.index_name = c.index_name and i.table_owner = c.table_owner and i.table_name = c.table_name and i.owner like 'SP\_RELEASE1' escape '\' and i.table_name like 'GTC\_DATA' escape '\' union select null, owner, table_name, to_number(null), null, null, 0, to_number(null), null, null, num_rows, blocks, null from all_tables where owner like 'SP\_RELEASE1' escape '\' and table_name like 'GTC\_DATA' escape '\'
|