Re: Q:Good preformance

From: "Bruno Kamiche" while answering another post >> If too much space is left for update (PCTFREE), more blocks will be used, thus making the table grow unnecessarily, take in account that tables are limited to 121 blocks (depending on the OS), <<

Actually the Oracle block size controls the number of extents; 2K Oracle block = max 121; 4K =249, etc... There is no reason to build an Oracle database using 2K blocks even though it is the default size on most platforms. I have experience with Oracle on VMS alpha and Pyramid Unix and both received performance benefits from using larger blocks. With Oracle rdbms ver. 7.3 you have an 'unlimited' extent option for user objects.

Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Tue Sep 23 1997 - 00:00:00 CDT