Re: Index creation - performance problem

Where is the temporary tablespace of that user? data tablespace? same disk?

Hth,

Sybrand Bakker, Oracle DBA

Adam Roze <arz_at_royalpbk.com> wrote in message news:38C6758D.339F0603_at_royalpbk.com...
> Hi,
>
> I am trying to create unique index on a big table.
> Table is placed on separated datafile/tablespace/disk . Monitoring disk
> activity shows that oracle reads and writes about the same
> amount of data ~2.5 MB/s.
>
> I understand that oracle has to read the table to create index but why
> does it write to it ??? Is it possible to avoid ??
>
> As the table is big ~6GB it takes an hour to create the index and I
> hope that elimination of writes would make it faster.
>
> Oracle is 7.3.4.5 on Digital Unix 4.0E
>
> Any help would be greatly appreciated.
>
> Adam
>
Received on Wed Mar 08 2000 - 00:00:00 CST