oracle Indexes ...

From: Sebastien Durbec <seb_at_zh.steria.ch>
Date: Thu, 21 Oct 1999 11:52:23 +0200
Message-ID: <380EE257.8EB551A8@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 - 04:52:23 CDT