Re: [External] : Re: Question on gathering System Statistics

From: Neil Chandler <neil_chandler_at_hotmail.com>
Date: Wed, 10 Feb 2021 09:46:17 +0000
Message-ID: <DB7PR10MB20906653A5A793A8213476CB858D9_at_DB7PR10MB2090.EURPRD10.PROD.OUTLOOK.COM>

your order is correct. I managed to mix myself up between setting db_file_multiblock_read_count and setting MBRC explicitly.

Gathering ‘exadata’ copies the db_file_multiblock_read_count into system stats, which you’re then overriding. You will be getting a pretty ratio high number of multi blocks for every single block read.

Regs

Neil.
sent from my phone

On 10 Feb 2021, at 02:20, Jack van Zanen <jack_at_vanzanen.com> wrote:

Hi Neil,

I am fairly certain (while ago now) we did the order as I mentioned them as this is the order we documented it. checking the value for MBRC it is 256.

Regards

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 10 2021 - 10:46:17 CET

This message: [ Message body ]
Next message: Jonathan Lewis: "Re: high Block change tracking waits"
Previous message: Jonathan Lewis: "Re: Rows processed by a sql but not retrieved"
Maybe in reply to: Redacted sender : "Re: [External] : Re: Question on gathering System Statistics"
Next in thread: Mladen Gogala: "Re: use_large_pages parameter"

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

Original text of this message