| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to tune "redo log space request"?
I've tried to increase log buffer but nothing changed. I've tried to increase redo log files number but nothing changed. I've tried to increase redo log files size and I've got less frequent"redo log space requests" but the total "redo log space wait time" was quite the same.
> You're always going to get some space waits during a log switch -
You mean that it's not a performance problem having "redo log space
requests"?
> speeding up your log switches may be a better option...
How can I do that?
Thanks!
Luca Minudel software designer
Italy Conegliano (TV)
e-mail luca.minudel_at_nline.it
Connor McDonald <connor mcdonald_at_yahoo.com> scritto nell'articolo
<39F10997.7263_at_yahoo.com>...
> Michael Bialik wrote:
> >
> > Hi.
> > Try increasing log buffer to 1048576 ( 1Mb ).
> >
> > HTH. Michael.
> >
> > In article <01c03ae1$35d9e960$239e15c2_at_w95luca>,
> > "Luca Minudel" <luca.minudel_at_nline.it> wrote:
> > > I've got a problem with an Oracle instance.
> > > The instance has a "redo log space request" (and a consequent
"redo log
> > > space wait time") every time there is a redo log file switch.
> > > The redo log files are huge (32MB) and are many (12 redo log
groups of 1
> > > file each). They are on 2 different fast
disks/controllers/channels.
> > > The log buffer is set to 262144.
> > >
> > > As I know there should not be "redo log space requests". Isn't it?
> > > How can I avoid them?
> > > How can I find theyr cause?
> > >
> > >
>
> Whilst this lower the redo space statistics, it will probably increase
> log file sync times as well as making the performance of the LGWR much
> more sporadic...
>
> You're always going to get some space waits during a log switch -
> speeding up your log switches may be a better option...
>
Received on Sat Oct 21 2000 - 08:35:32 CDT
 |
 |