Re: Oracle Performance Questions

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 23 Feb 2006 18:53:46 +0100
Message-ID: <mhtrv159bmfen8dlu1gh6q0c5mvtjr9q5r@4ax.com>

On 23 Feb 2006 08:07:35 -0800, DMina_at_laiki.com wrote:

>Hello people,
>
>I have several querstions if somebody can help me. We have ORacle 9i
>Rel 2 installed on AIX 5.2
>
>1. 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.
>
>2. 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
>
>3. 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)
>
>4. 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.

1 Where did you read that? It doesn't make sense at all. 2 It doesn't make sense to use buffered I/O. It only makes sense to use db_16k_cache_size if you have tablespaces with 16k block size. It does make sense to use the keep and recycle cache though. 3 None
4 If have never used it in 17 years.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Feb 23 2006 - 11:53:46 CST