Re: What is this doing for me?

Wolfson Larry - lwolfs wrote:

>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
>
>
> Thanks
>
>

Analyzing data dictionary might help, if the oracle version allows it. How do you know that this is the
statement that is killing your performance? May be increasing shared pool would help? What kind
of waits are you encountering?

-- 
Mladen Gogala
Oracle DBA
Ext. 121


--
http://www.freelists.org/webpage/oracle-l