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

Other related posts: