Re: Redo Question

On Mar 28, 9:41 am, gazzag <gar...@xxxxxxxxx> wrote:
On 28 Mar, 14:27, m...@xxxxxxxxxxx wrote:



Hi,

We are trying to see what the optimal size of our redo logs should be
and how many we should have.

We are running 10g, and we know that there is the MTTR_ parameter.
But for now, we want to the the log_checkpoint......

We have a high transaction system. Currently we have 5 redo logs,
each 50M. We are still receiving the error "Check point not
complete".

I'm not sure if creating more groups is the answer, shrinking the log
size, or making the logs bigger. We are researching it, but in the
meantime this error is happening frequently.

We are looking for some advice on what to do given the path we want to
take......

Thanks for any help.

John.

http://groups.google.co.uk/group/comp.databases.oracle.server/browse_...

HTH

-g

We are really hurting here:

NAME VALUE
------------------------------- ----------------
redo buffer allocation retries 18,887
redo log space wait time 324,520


.

Relevant Pages

  • Re: Redo Question
    ... We are still receiving the error "Check point not ... or making the logs bigger. ... We are researching it, but in the ... SQL> show parameters log_buffer ...
    (comp.databases.oracle.server)
  • Contacting Brooke Schreier GANZ
    ... I have attempted to reach Brooke Schreier Ganz, whom I found on JGFF ... researching a family I think is mine, several times in the past two years. ... would like the convenience of receiving all soc.genealogy.jewish posts in ...
    (soc.genealogy.jewish)
  • Army Chaplains & the MC
    ... A quick query for the military experts here (of which I put my hands up ... I'm researching a man who was a padre (temporary chaplain) with the ... shows him only as receiving the usual Pip, Squeak and Wilfred, but he ...
    (soc.genealogy.britain)
  • HELO command
    ... receiving some undeliverable messages and after researching I discovered that ... the HELO command is not configured correctly. ...
    (microsoft.public.exchange.admin)
  • Re: Army Chaplains & the MC
    ... I'm researching a man who was a padre (temporary chaplain) with the ... shows him only as receiving the usual Pip, Squeak and Wilfred, but he ...
    (soc.genealogy.britain)