Re: What is this doing for me?

> 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
--
http://www.freelists.org/webpage/oracle-l