Re: oracle Indexes ...

My first guess would be that you
have a swap area on disc 3.

There is no 'process that plays with indices', and nothing you do outside Oracle should make Oracle processes do anything to the database.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Sebastien Durbec wrote in message <380EE257.8EB551A8_at_zh.steria.ch>...
>What does Oracle do with Indexes when it needs memory ?
>
>I've got 4 partitions on 4 seperate physical disks :
>on one are rollback segments etc...
>on another one are datas ...
>and on a third one are Indexes ...
>
>If I make a big operation, (big in terms of memory need) on the fourth
>disk, for example a stupid grep over a very big file, Oracle pannics and
>
>does something on the disk where Indexes are althought i don't play with
>
>these Indexes ??? (proctool shows it very well)
>
>Does the Oracle process that play with Indexes have a RealTime priority
>like set by priocntl ? Or is it afraid of having not enough memory if
>needed ?
>
>Seb.
>
>
>--
>-------------------------------------------------------------------
>2 Secrets to success: 1. Don't tell everyone what you know.
>-------------------------------------------------------------------
>Sébastien Durbec Email : seb_at_zh.steria.ch
> Tel : +41 (0)1 298 50 88 (direct)
>Steria Informatic SA/AG +33 (0)6 85 94 63 60 (mobile)
>Militärstrasse 105 Tel : +41 (0)1 298 50 70 (office)
>CH-8004 ZÜRICH Fax : +41 (0)1 241 88 65
>-------------------------------------------------------------------
>
>
>
Received on Thu Oct 21 1999 - 05:55:10 CDT