AIX

AIX

Connect with fellow AIX users and experts to gain knowledge, share insights, and solve problems.


#Power
 View Only

  • 1.  Cache a file in memory

    Posted Fri May 18, 2012 03:19 AM

    Originally posted by: sridhard1977


    Hi,
    IS there any way to cache a file in memory for aix 5.3. I have an problem in my oracle database and it is getting more time for connect. After analysing the truss output, the time taken for opening the file oraus.msb is around 40 seconds. Hence there was an delay in connection.

    Same problem occured for somebody in solaris and they have cached the file in memory to avoid disk read. Then it was working fine. Similarly any to do to the same here?

    Regards
    Sridhar
    #AIX-Forum


  • 2.  Re: Cache a file in memory

    Posted Fri May 18, 2012 08:58 AM

    Originally posted by: ColombianJoker


    AIX caches all read or writhen files stored in filesystems mounted with cache (all filesystems WITHOUT dio, cio and/or sync options) opened WITHOUT O_SYNC option. All files NOT EXCEPTED are mapped to RAM.

    If you AIX is not caching your files may be you have your cache limits too low (ioo -o maxperm -o maxclient), or your filesystem is mounted synchronous (may be dio, or cio, o sync, check with mount alone). Or your system is too low on memory.
    #AIX-Forum


  • 3.  Re: Cache a file in memory

    Posted Mon May 21, 2012 04:32 AM

    Originally posted by: KarlM


    this was a bug in Oracle 8.1.7 and there was an Oracle patch
    #AIX-Forum


  • 4.  Re: Cache a file in memory

    Posted Mon May 21, 2012 05:53 AM

    Originally posted by: sridhard1977


    Hi,
    Do you have the patch / bug number?

    Regards
    Sridhar
    #AIX-Forum


  • 5.  Re: Cache a file in memory

    Posted Fri May 25, 2012 08:42 AM

    Originally posted by: KarlM


    No but take a look at this:
    http://dbaspot.com/oracle-server/14183-oracle-8-1-7-huge-performance-problem-fixed-oraus-msb.html
    #AIX-Forum


Related Content