Re: Multiple Buffer Pools ! Is it worth to investigate in this ?

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Sun, 30 Dec 2001 01:23:28 GMT
Message-ID: <3c2e6c42.1646559@news>

Andreas Wizemann doodled thusly:

>i've read about Multiple Buffer Pools.
>I'm not sure if this could speed up my database (8171).

they are useful when you have wildly different access patterns for some of the database objects and you don't want those to affect the normal throughput of the system.

>Does anybody use this "feature" ?

yes, very much so.

>Is it worth to investigate in this ?
>

depends on what your apps are doing.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Sat Dec 29 2001 - 19:23:28 CST

This message: [ Message body ]
Next message: Augustine Joseph: "Re: Online Backup Doubt"
Previous message: Nuno Souto: "Re: DO or DONT Analyze SYS Objects ?"
In reply to: Andreas Wizemann: "Multiple Buffer Pools ! Is it worth to investigate in this ?"
Next in thread: Nuno Souto: "REPOST: Re: Multiple Buffer Pools ! Is it worth to investigate in this ?"

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