Re: Looking for Statspack documentation

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in news:3e422da2$0$247$ed9e5944_at_reading.news.pipex.net and I quote:

> at all. "if all your sql is tuned" is a hell of a caveat as well.

Hehehe! I *really* love that one. As if... :D

> of the database (db_block_size). For your object choose a prime number
> for the number of freelists as the processes are hashed by Oracle PID
> over the freelists.

That is news. Prime?

> are accessing the same rows in a block/buffer. So reducing the number of
> rows per block will help to reduce the contention on the buffer.

Might be useful to explain how. SOme folks out there don't, believe me.

-- 
Cheers
Nuno Souto
nsouto_at_optusnet.com.au.nospam