Re: Rapid Log Switching


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@xxxxxxxxxxxxxxxxxxxxx> 
To: <jonathan@xxxxxxxxxxxxxxxxxx>
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-l

Other related posts: