Re: SQL> select class,count from v$waitstat; show data block contention

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Tue, 13 Mar 2001 10:19:12 GMT
Message-ID: <3aadf11c.3873715@news-server>

On Tue, 13 Mar 2001 09:47:43 GMT, Anjo Kolk <k.kolk_at_chello.nl> wrote:

>
>
>From my experience, waits on data blocks means either that you are missing
>freelists (many processes are inserting in to the same object) or the
>buffer cache is too small too keep your current working set in and you have
>to read them from disk all the time.
>

Thanks for the info, Anjo. Would having blocks in buffer pool RECYCLE cause a similar problem (or make it more likely to happen)?

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Tue Mar 13 2001 - 04:19:12 CST

This message: [ Message body ]
Next message: Anjo Kolk: "Re: SQL> select class,count from v$waitstat; show data block contention"
Previous message: Anjo Kolk: "Re: SQL> select class,count from v$waitstat; show data block contention"
In reply to: Anjo Kolk: "Re: SQL> select class,count from v$waitstat; show data block contention"
Next in thread: Anjo Kolk: "Re: SQL> select class,count from v$waitstat; show data block contention"
Reply: Anjo Kolk: "Re: SQL> select class,count from v$waitstat; show data block contention"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US