Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reducing Redo Log
John Vernes wrote:
>
<snip>
> Questions:
> * Does the size of the PCTFREE parameter effect the redo size?
No, pctfree afects only the size of your tables and indexes.
> * I mean to remember that in Oracle 8 it must be possible to reduce the
> redo log when using the statement ALTER TABLE ...... NOLOG;
> This should work for parallel insert, but also for serial inserts as I
> recall.
> Has anyone played with this feature and if so do you have some results
> for me?
> * Are there other ways to reduce the redo log size?
>
Don't know O8, but have a llok at your backup/restore concept beor you
use such features.
If you do this thing each day and several times and would like to have a
restore to point
of failure it's a great trick ;-)
Because each time you do it your backup doesn'r reflect this changes and
also there's no
hint in the redo/arch files of your changes and the backup is out of
sync.
IMHO don't use it except your backup/recovery strategie is able to
handle with it.
rgds
eugen
Received on Mon Jun 08 1998 - 12:29:25 CDT