Re: Algorithm for calculating extent size in LMT

You missed:

    IF DBWR doesn't do any checkpoint MTTR writes     or idle writes.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Now running 3-day intensive seminars
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases


Nuno Souto wrote in message <3c85757b.1473981_at_news-vip.optusnet.com.au>...



>IF you had a single user accessing the system.

>IF that user was only running one and only one program.

>IF that program did sequential accesses (which is a DIFFERENT thing

>from full scans, although it includes them!).

>IF data was loaded and written on disk in order of sequential

>retrieval.

>IF the file system you use allowed you to have consecutive areas of

>disk allocated to consecutive file system addresses.

>IF the disk sector size is matched to the file system block size.

>IF the file system block size is matched to the database block size.

>IF the database block size is matched to the LMT constant allocation.

>IF the LMT constant allocation is matched to the physical storage

>parameters of the table/tablespace/index.