Re: SQL Response Time

Brian wrote:
> I have a small database (about 4 gig total) that generates web pages
> through mod_plsql. The DB gets hit by 30 users 10 hours a day pretty
> regularly.

Good man. mod_plsql is in many ways far superior than using Java on an app tier for web reporting.

> What I don't understand is why OEM now reports 'SQL Response'
> time increasing from about 30 to 150. Is this because of the larger
> buffer cache?

The slowest most expensive operation in a database is i/o. There are three elementary ways to address this. Less i/o obviously (which is not always that obvious when looking at the SQL logic of some code). Making i/o cheaper by reducing physical i/o (PIO) to logical i/o (LIO) using a larger buffer cache. And making i/o faster (bigger pipes, better RAID, etc.)

It would therefore seem that you have reduced the POIs on your database.

--
Billy