> This statement appears to be killing our performance. > > What's going on and is there anything we can do about it? > > select > type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(li > sts,65535),NVL( > groups,65535),cachehint,hwmincr, NVL(spare1,0) > from seg$ > where ts#=:1 > and file#=:2 > and block#=:3 Who is the parent of this statement? And what are the most frequent bind values fr ts# and file#? I mean that 'select type#,...' is usual SYS statement and it's probably better to try to tune parent statement. -- Egor http://www.oracledba.ru/orasrp/ Free Oracle Session Resource Profiler -- //www.freelists.org/webpage/oracle-l