RE: Argh.....
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <Mark.Bobak@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 15 Sep 2004 17:35:57 -0400
Mark,
Wrong answer. Correct answer:
"Yeah, well, they're undocumented and the 9.2 rdbms engine complained =
about them & would not start."
One must disarm the manager before he creates chaos.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxxxxx]
Sent: Wednesday, September 15, 2004 4:45 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Argh.....
We are suffering from a bunch of excess database calls, resulting in
lots more executions of SQL and (ovbiously) more buffer gets for any
given interval of time, and of course, cache buffers chains latch
contention is the result.
So, what's my boss's direction? Find the source of the extra calls and
extra workload? No.....
"Mark, when we moved to 9i, you removed _db_block_hash_latches and
_db_block_hash_buckets right?"
(This is my favorite part...)
"I feel that is the problem....Please look into setting these parameters
again...."
("I feel..." Grrr.....it just gets on my nerves...."I feel". How about,
"Based on this data, I think this is what's happening"?? "I feel"?? Or
"Here's the evidence which suggests this is the problem....")
Ok, I'm going to go now and pretend that setting these parameters is
going to have any significant effect on solving the problem.
--
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"On two occasions, I have been asked [by members of Parliament], "Pray,
Mr. Babbage, if you put into the machine wrong figures, will the right
answers come out?' I am not able to rightly apprehend the kind of
confusion of ideas that could provoke such a question."
-- Charles Babbage (1791-1871)
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
