Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: large access to one big table, help!!
If the table is placed in a separate tablespace you should be able to mark
the tablespace as READONLY. The you get some overhead. Switch it to
READWRITE before making changes to the table.
Ronny Ivarsen
ivarsen_at_online.no
David Novo <dnovo_at_ipmultimedia.es> wrote in message
news:7htvu7$2sa$1_at_talia.mad.ttd.net...
> I have a lot of reads to a big table (about 800.000 records). I have only
> reads no writes.
> The CPU increased to 30%.
>
>
> What can I do, to optimize the performance, to decrease the CPU time ??
>
> Thanks!!
>
>
Received on Fri May 28 1999 - 19:32:13 CDT