Re: Why is 9i pausing?

If there is any swapping, it would be the inactive, right? Doesn't that entirely explain why there would be a pause after a period of inactivity?

What does top have to say about it? Do you see it in sqlplus when telnetted directly to the server?

Are you using a journalled filesystem?

select name, value from v$parameter where name like '%mt%' or name like '%pga%' or name like '%sort%'
/

Try cutting the SGA's by 2/3. Try running only one instance.

Do you see activity on your undo tablespace?

Does the problem change if you open two sessions and do the same thing at the same time on both of them?

Does lnsrctl status show registrations?

How do you know the rows are getting created quickly? Are you using order by or ctas statements? Are you using indices? Are you creating indices? Are you joining? What sql statement are you using?

So many questions!

jg

--
@home.com is bogus.
http://news.yahoo.com/s/nm/20050805/wl_nm/media_wikipedia_dc