Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Performance Questions
<DMina_at_laiki.com> wrote in message
news:1140710855.360626.228910_at_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
>
> 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.
>
HTH
Matthias Hoys
Received on Thu Feb 23 2006 - 12:43:35 CST