In article <38C7A1BC.748D3882_at_royalpbk.com>, Adam
Roze <arz_at_royalpbk.com> wrote:
>Disklayout is:
>temp, system, rbs - disk1
>redo logs - disk2
>users - disk3
>big table - disk4
>ind - disk5
>ind2 - disk6
>ind3 - disk7
>
>Disk array monitor + v$filestat shows that oracle reads & writes to the
>datafile that contains the big table.
>All this happens during import of the user - owner of this table.
>Yesterday I divided import process into 3 steps :
> 1) import with indexfile=.... to get file with definition of the indexes
> 2) import the tables only - indexes=n in the parfile
> 3) create indexes from the file from step 1...
>Can you do such an import and check if your database writes to the table during
>index creation ?
..
If it writes to the table which it is indexing, I
would be very surprised! I would have expected
your slow-down to be caused by placing your RBS
and temporary files on the same drive.
Paul de Anguera | "You can't write a chord ugly enough to say
Reply to: | what you want to say sometimes, so you have to
deanguer@ | rely on a giraffe filled with whipped cream."
quidnunc.net | - Frank Zappa
Received on Mon Mar 13 2000 - 00:00:00 CST
