Re: What is this doing for me?

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 17 Aug 2005 10:12:55 -0700
Message-ID: <bf4638050817101272cd042b@mail.gmail.com>

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_at_acxiom.com> 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

> 

> 

>


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

Received on Wed Aug 17 2005 - 12:14:58 CDT