Re: What is this doing for me?
- From: Egor Starostin <egorst@xxxxxxxxx>
- To: lawrence.wolfson@xxxxxxxxxx
- Date: Thu, 18 Aug 2005 11:24:44 +0700
> 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
- References:
- What is this doing for me?
- From: Wolfson Larry - lwolfs
Other related posts:
- What is this doing for me?
- From: Wolfson Larry - lwolfs