Re: A challenge...

Rather than conjecturing, why not just look at v$session_wait when the pause is happening? That will tell you why it is pausing.

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah

On Tue, 5 Jan 1999 mpir_at_compuserve.com wrote:
>
> Since the 'event' occurs every 1000 inserts or so, I suspect automatic
> rebalancing of the index b-tree(s)(depending on number of indexes). This
> would put locks on the table, etc. Duration could be function of table size
> and number of indexes.
>
> leonard_at_lf-clark.prestel.co.uk (Leonard F. Clark) wrote:
> >
> > Are the redo files big enough for the volume of transactions?
> >
> > Are you checkpointing too frequently? (Less likely)
> >
> > >Has anyone seen this type of problem before?
> > >
> > >*********
> > >About one in every 1000 insert transaction stalls (or ?) in the database -
> > >get response time peaks of 40 to 180 secs. -- WHY??
> > >*********
Received on Wed Jan 06 1999 - 09:53:18 CST