Re: Rapid Log Switching
Date: Wed, 20 Feb 2008 22:18:48 -0000
Message-ID: <026e01c8740e$90a4e930$0300a8c0@Primary>
Rich,
Thanks - Brain didn't catch up with last post there.
John,
I recall Tanel Poder making some comments about "private threads" having space reserved in the log file - do you have a very large value for the 'transactions' parameter: which would require a lot of private threads, which possibly might pre-empt a lot of space in the logs then not use it. (10.2, 64Bit - private threads can take 128Kb each, and threads = ceil(transactions / 10)
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
- Original Message ----- From: "Rich Jesse" <rjoralist_at_society.servebeer.com> To: <jonathan_at_jlcomp.demon.co.uk> Sent: Wednesday, February 20, 2008 10:00 PM Subject: Re: Rapid Log Switching
> Hey Jonathon,
>
> I think he's saying the logs switch when they grow to only 2-to-6 Megabytes
> -- not every 2-to-6 minutes. In other words, "why aren't the logs filling
> before switching?"
>
> Rich
>
>> >> >> 20M in 2 to 6 minutes isn't really very much - I assume the >> puzzle is why have things changed. >>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 20 2008 - 16:18:48 CST