Oracle Performance Questions

From: <DMina_at_laiki.com>
Date: 23 Feb 2006 08:07:35 -0800
Message-ID: <1140710855.360626.228910@z34g2000cwc.googlegroups.com>

Hello people,

I have several querstions if somebody can help me. We have ORacle 9i Rel 2 installed on AIX 5.2

I have read that JFS and Large File Enabled filesystem is not advisable! Do you have any comments on this? My filesystems (all datafiles) are Large File Enabled.
If you are using bufferred I/O does it make any sense to have multiple buffer caches? (db_16K_cache_size etc) My db_block_size is 8K
If i make use of Direct I/O what changes do i have to change on OS? (except of course mounting the filesystem using dio)
Do you use LOCK_SGA=TRUE and if yes what do i have to have in mind in terms of OS configuration parameters?

Thank you. Received on Thu Feb 23 2006 - 10:07:35 CST