Sophisticated Performance Tuning: Need Wizard!

From: Morris Chen <root_at_corolla.tatung.com.tw>
Date: 1995/12/26
Message-ID: <4bo6m6$s6a_at_aladdin.iii.org.tw>#1/1

Hi Wizards,

        We recently have to tune the fat ORACLE 7.1 on DEC Server 2100(alpha) /OSF1 3.0 and have the following questions:

1. We currently use file system and find it's very slow to INSERT, any techniques found on ORACLE manuals are carried out but in vain, should I 'kill' the UNIX buffer cache to bypass ORACLE synchronous write or decrease the UNIX system flush rate?
2. How can I know the exact size of the System Global Area that will not be paged out? Can ORACLE use any 'resident' shared memory like Informix?
3. ORACLE 6.* use (db_block_write_batch/2) as a 'high water mark' (threshold) for db writer to write dirty database blocks to disks. Is this still true for ORACLE 7.1? BTW, if I set db_block_write_batch large will Oracle automatically use asynchonos(parallel) I/O?

ANY HINTS ARE APPRECIATED. Sorry for my poor Taiwanese English.

                                Morris Chen
                                ORACLE keeper
                                TATUNG COMPANY (over 25,000 employees)
                                root_at_corolla.tatung.com.tw
                                1995. 12. 26.
--------------------------------

The service of Oracle Taiwan Inc. is NO SERVICE. (:-<~ #_at_$%! Received on Tue Dec 26 1995 - 00:00:00 CET