Hi Larry, Which user is running this? It looks like SYS, but I won't make that assumption. How often does it run? Does it coincide with any jobs in DBA_JOBS? -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist On 8/17/05, Wolfson Larry - lwolfs <lawrence.wolfson@xxxxxxxxxx> 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 > > >