Re: Multi-Block read count

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 9 Jan 2002 14:52:08 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA77D703D@lnewton.leeds.lfs.co.uk>

Herman,

many thanks for that info, I shall go off and try it out and see what happens here. I have Win2k and HP-UX both 10:20 and 11:00 to play with. I'll also have a look in the docs (again !) and see what I may have missed.

Regards,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

-----Original Message-----
From: h.de.boer_at_itcg.nl (Herman de Boer) [mailto:h.de.boer_at_itcg.nl] Posted At: Wednesday, January 09, 2002 2:29 PM Posted To: server
Conversation: Multi-Block read count
Subject: Re: Multi-Block read count

hello Norman,

it is platform dependent. The method I use in order to determine the maximum in a database is simple, using sqlplus:
* alter session set db_file_multiblock_read_count = 10000;

• show parameters db_file_multiblock_read_count

<SNIP> Received on Wed Jan 09 2002 - 08:52:08 CST