Re: Database Buffer Cache Hit Ratio

"pcambraf" <pedro.cambra_at_gmail.com> wrote:
> I didnt like your off topic answers... if you dont want to help me just
> dont say nothing, i wasnt answering for been replyed like that...

The replies you received were most helpful, because they pointed out that you are not asking the right question in the first place. The *least* helpful reply would be to simply answer your misguided question.

> Im a DBA jr, in the applications side, cause the real DBAS wont fix
> anything, i just dont have access to sys or system or whatever could be
> called superuser, so i begin with handicap.
> Anyway, im on a OLTP enviroment, with dictionary managment tablespaces,
> its a small system, about 3 o 4 gigs on disk and there are user
> complains, so much. The application is not well written, but fix this
> is not possible, they dont want to (another handicap),

What is the point of knowing what the problem is if no one is willing and able to act on that knowledge?

> ive seen this db
> cache hit ratio so low, and i thought its a problem, and my question
> was: Could a contention in DBWR process (theres only one as ive said
> above) produce a low hit ratio in the instance?

What do you think the DBWR is contending with? If you only have one DBWR, I can see how it could be bored, or be overhelmed, but how could it be contentious?

Anyway, I don't think DBWR could affect the hit ratio except under very bizarre situations in which its affect on the hit ratio is the least of your problems. Even then, I'm not sure it could.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB