Re: consumption memory

From: John Jolet (john.jolet_at_FXFN.COM)
Date: 02/26/04

  • Next message: Aaron W Morris: "Re: Script-Permission"
    Date:         Thu, 26 Feb 2004 09:48:32 -0600
    To: aix-l@Princeton.EDU
    
    

    bear in mind that setting the sga to be pinned doesn't really do anything
    unless you set the flag in the os that allows processes to pin sga. i forget
    which one that is. otherwise, oracle will grab the sga, then if necessary,
    the os will swap chunks of it :)

    On Thursday 26 February 2004 09:23 am, you wrote:
    > You may ask your DBA's what they have the Oracle SGA set at. I'm not a DBA
    > expert but my understanding is that the SGA setting is how much memory
    > Oracle claims when it starts up. For example, due to the high SGA setting
    > we have on our Oracle Databases our available memory almost always is 0 or
    > close to it.
    >
    > Jason de la Fuente
    >
    > >>> gilberto.hitoshi@BULL.COM.BR 02/25/04 05:18PM >>>
    >
    > I have machine with 12 cpus and 16 Gbytes of memory. The machine is using
    > vantive apllication and oracle 8i. Aix 4.3.3.81 .
    > I'm having problem with memory. Any moment , the memory is 0 . In this
    > moment , i trying killed all processes , but the machine not release the
    > memory, and i need reboot the server. I changed the vmtune to
    > /usr/samples/kernel/vmtune -f 1440 -F 1456
    > /usr/samples/kernel /vmtune -p 5 -P 30 -t 30, but the problem still
    > continue.
    > Anyone has any idea about this problem?
    >
    > Hitoshi


  • Next message: Aaron W Morris: "Re: Script-Permission"

    Relevant Pages

    • Re: I/O performance troubleshooting
      ... You are running out of memory a lot, but not paging as a result. ... The comments on the SGA look dead on to me. ... I should alocate more of it to Oracle. ... It seems pretty obvious to me my performance problem is with the disks I have. ...
      (AIX-L)
    • Re: SGA size.
      ... I have Oracle 8.1.7 installed on my IBM ... > (I'm thinking that is not enough memory). ... > about the size of the SGA. ... On this one server I have a test database ...
      (comp.databases.oracle.server)
    • Re: ORACLE 9i - memory usage
      ... Oracle allocates 13GB (which is the total size of your SGA) at startup ... within physical memory. ... Can I guess it is actually allocating 13Gb of memory? ...
      (comp.databases.oracle.server)
    • Re: ORACLE 9i - memory usage
      ... Oracle allocates 13GB (which is the total size of your SGA) at startup ... within physical memory. ... Can I guess it is actually allocating 13Gb of memory? ...
      (comp.databases.oracle.server)
    • Re: ORA-04031 with Collections and SGA Settings
      ... I am working with a data warehouse using an Oracle 10g R1 database. ... SGA MAX SIZE: 5904 MB ... The database server is also configured as a shared server. ... Do the settings for the SGA raise any questions/comments/concerns? ...
      (comp.databases.oracle.server)