我在查询 使用频率最高的10个查询 时,得到以下结果,不知道sysauth$的读取为什么会那么高,还有这下面的很多读取量也很高,刚接触这个,不知道如何下手,请各位指点下,小妹在此先说声谢谢~
SQL> select sql_text,executions from (select sql_text,executions,rank() over(ord
er by executions desc) exec_rank from v$sql) where exec_rank <=10;select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p
rivilege#>0 start with grantee#=:1 and privilege#>0
4946829SELECT DECODE(METRIC_TYPE, 6, 0, 7, 1, METRIC_TYPE), METRIC_GUID, METRIC_LABEL,
COLUMN_LABEL FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND
METRIC_COLUMN = :B1
314333SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC
_NAME = :B2 AND METRIC_COLUMN = :B1
314333
select size_for_estimate, size_factor * 100 f,
estd_physical_read_time, estd_physical_reads
from v$db_cache_advice where id = '3'
282516select shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f
, estd_lc_load_time l, 0 from v$shared_pool_advice
282515select java_pool_size_for_estimate s, java_pool_size_factor * 100 f,
estd_lc_load_time l, 0 from v$java_pool_advice
282515
SELECT DECODE(PARAMETER_VALUE, :B3 , 3, :B2 , 2, :B1 , 1, 0) FROM MGMT_PARAMETER
S WHERE PARAMETER_NAME = 'system_error_log_level'
275735select cachedblk, cachehit, logicalread from tab_stats$ where obj#=:1
194030select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (n
ext_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1
= :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, j
ob
173530
select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (n
ext_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1
= :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, j
ob
171399
10 rows selected.
SQL> select sql_text,executions from (select sql_text,executions,rank() over(ord
er by executions desc) exec_rank from v$sql) where exec_rank <=10;select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p
rivilege#>0 start with grantee#=:1 and privilege#>0
4946829SELECT DECODE(METRIC_TYPE, 6, 0, 7, 1, METRIC_TYPE), METRIC_GUID, METRIC_LABEL,
COLUMN_LABEL FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND
METRIC_COLUMN = :B1
314333SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC
_NAME = :B2 AND METRIC_COLUMN = :B1
314333
select size_for_estimate, size_factor * 100 f,
estd_physical_read_time, estd_physical_reads
from v$db_cache_advice where id = '3'
282516select shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f
, estd_lc_load_time l, 0 from v$shared_pool_advice
282515select java_pool_size_for_estimate s, java_pool_size_factor * 100 f,
estd_lc_load_time l, 0 from v$java_pool_advice
282515
SELECT DECODE(PARAMETER_VALUE, :B3 , 3, :B2 , 2, :B1 , 1, 0) FROM MGMT_PARAMETER
S WHERE PARAMETER_NAME = 'system_error_log_level'
275735select cachedblk, cachehit, logicalread from tab_stats$ where obj#=:1
194030select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (n
ext_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1
= :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, j
ob
173530
select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (n
ext_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1
= :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, j
ob
171399
10 rows selected.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货