Hello All
I saw that piece of code a few times and still think that even if you can
bump up the BCHR it has it's place. How can you tell that you need more
space in the buffer pool? Bad BCHR is an indication that you need to check
this. It is also an indication that you do a lot of FTS or missing
How can you tell that you need more space in the buffer pool?
...You can notice when this is true by observing summarized extended SQL
trace (event 10046) data. If the LIO count for a session is small, but
the PIO count is large, then you have the problem.
So, sure... Checking a session's BCHR
So, if I coerce the developers into writing better code that
does less logical IO, and the BCHR goes down, I should
then investigate and fix the problem? ;)
Jared
On Monday 13 January 2003 08:09, Yechiel Adar wrote:
Hello All
I saw that piece of code a few times and still think that even
:)
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen
- 2003 Hotsos Symposium, Feb 9-12 Dallas
-Original Message-
Still
Sent: Monday, January 13, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L
Time to check what? If it goes down it could be because your statement(s)
were optimized to use less resources (as documented so well). If it goes
up it could be because your statements became more or less efficient. And
you'd have to check if it was because of an index, a table, a sql
To add an example of what Anjo, Morgens and everyone else is talking about,
here is a perfect illustration of why focusing on BCHR is like
concentrating intensely on how fast your tyres rotate in a Tour de France,
instead of looking of where you are going (probably a lot more useful).
Another
