Re: What is this doing for me?
- From: Jared Still <jkstill@xxxxxxxxx>
- To: lawrence.wolfson@xxxxxxxxxx
- Date: Wed, 17 Aug 2005 10:12:55 -0700
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
>
>
>
Other related posts:
