Re: HELP HELP HELP

From: Yass Khogaly <ykhogaly_at_us.oracle.com>
Date: Wed, 17 Nov 1999 13:21:30 -0800
Message-ID: <80v2kn$8s5$1@inet16.us.oracle.com>

REM overlap.sql
REM
REM Originally From bug #310481
REM Please run the following queries to see if segments are overlapping: REM
prompt Overlap on FET$

 select f1.file#, f1.block#, f1.length, f2.block# from fet$ f1, fet$ f2
  where f1.file# = f2.file# and f1.rowid != f2.rowid and
        f1.block# <= f2.block# and f2.block# < f1.block#+f1.length

 ;

prompt Overlap on UET$

 select u1.file#, u1.block#, u1.length, u2.block# from uet$ u1, uet$ u2
  where u1.file# = u2.file# and u1.rowid != u2.rowid and
        u1.block# <= u2.block# and u2.block# < u1.block#+u1.length

 ;

prompt Duplicates

 select u1.file#, u1.block#, u1.length, f2.block# from uet$ u1, fet$ f2
  where u1.file# = f2.file# and
        u1.block# <= f2.block# and f2.block# < u1.block#+u1.length

 ;

"The Views expressed here are my own and not necessarily those of Oracle Corporation"

Mark Ragan <mark.ragan_at_dial.pipex.com> wrote in message news:80ulco$m5r$1_at_lure.pipex.net...
> I am running an oracle Vsn 7 Server on Windows NT.
>
> No one is using the machine or the database, although the database is
> extremely busy servicing one background oracle process.
>
> The active process is a system Background process & I do not know what it
is
> doing, or why, but it is using up all the systems resources (Mainly Via
Disk
> accesses).
>
> Using Top session monitor I can see the offending process which appears to
> be switching between two sql commands:
>
> 1) Select ts#, file#, block#, length from uet$ where segfile#=:1 and
> segblock#=:2 and ext#=:3
> AND
> 1) delete from uet$ where segfile#=:1 and segblock#=:2 and ext#=:3
>
> I do not know what this table is used for, nor what the system is trying
to
> do.
>
> This has been going on for more than 24 hrs - Can any one help me!!
>
> TIA
>
>
>
Received on Wed Nov 17 1999 - 15:21:30 CST