数据库版本是 10.2.0.4.0 ,最近在查询的时候发现
SQL> REM -- check the one who take up lots of resources
SQL> select b.username username,a.disk_reads reads,
2 a.executions exec,a.disk_reads/decode(a.executions,0,1,a.executions) rds_ex
ec_ratio,
3 a.sql_text Statement from v$sqlarea a,dba_users b where a.parsing_user_id=
b.user_id and a.disk_reads > 100000 order by a.disk_reads desc;SYS 101281 101 1002.78218
call dbms_space.auto_space_advisor_job_proc ( )SYS 100783 792 127.251263
insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_a
lloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, N
ULL, NULL, 'FALSE', :5, 'FALSE'))
根据网上的一些资料,这是10.2.0.2以下的版本的BUG,在10.2.0.2之后的版本中被修正,
可是最近总发现这个,不知道是怎么回事,请大家指点下。
SQL> REM -- check the one who take up lots of resources
SQL> select b.username username,a.disk_reads reads,
2 a.executions exec,a.disk_reads/decode(a.executions,0,1,a.executions) rds_ex
ec_ratio,
3 a.sql_text Statement from v$sqlarea a,dba_users b where a.parsing_user_id=
b.user_id and a.disk_reads > 100000 order by a.disk_reads desc;SYS 101281 101 1002.78218
call dbms_space.auto_space_advisor_job_proc ( )SYS 100783 792 127.251263
insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_a
lloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, N
ULL, NULL, 'FALSE', :5, 'FALSE'))
根据网上的一些资料,这是10.2.0.2以下的版本的BUG,在10.2.0.2之后的版本中被修正,
可是最近总发现这个,不知道是怎么回事,请大家指点下。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货