Re: Why is 9i pausing?

Sybrand,

Fine - I'm sure that someone else will be prepared to at least give me some pointers. I'm not planning paying any consultants to look at the problem, so folks needn't feel guilty about helping me out...

For anyone who *is* willing to offer advice: according to Enterprise Mgr Console, the total SGA size is 130MB in each DB, so perhaps the swapping isn't that big an issue. There is some swapping, sure, but the Sun box isn't permanently on it's knees - the problem is intermittent and SAR reports that the box is pretty much idle. Sometimes data is written & read at a perfectly acceptable speed, other times there's the pause I referred to before Oracle does anything, and this pause often comes when I execute a statement after a period of inactivity.

TIA
Tarby Received on Fri Aug 05 2005 - 09:44:07 CDT