TOCPREVNEXTINDEX

Lund Performance Solutions


SOS Oracle Detail Memory and Network

The Oracle Detail Memory and Network Screen

The Oracle Detail Memory and Network screen provides statistics about memory allocation and network transfers.
To access the Oracle Detail Memory and Network screen from any SOS display screen:
  • Type s from the SOS Enter command: prompt to view the Screen Selection Menu.
  • From the Screen Selection Menu, enter N (upper case). An example of the screen is shown in Figure 37.1.




  • Figure 37.1 SOS Oracle Detail Memory and Network screen

    Oracle Detail Memory and Network Display Items

    SGA

    The SGA section of the screen presents statistics related to the SGA.
    Table 37.1 SOS Oracle Detail Memory and Network data items: SGA
    Data Item
    Description
    Free Memory
    The amount of memory available.
    If a large amount of free memory is available for long periods of time, consider increasing the sizes of other memory areas.
    DB Block Buffers
    The size of the buffer cache.
    Log Buffers
    The size of the redo log buffer area.
    Dictionary Cache
    The size of the data dictionary cache.
    SQL Area
    The shared SQL area size.
    Lib Cache
    The size of the library cache.

    Session

    The Session section of the screen contains memory statistics that show the amount of memory allocated to all users both inside and outside the global area.
    Table 37.2 SOS Oracle Detail Memory and Network data items: Session
    Data Item
    Description
    UGA Memory
    The size of the User Global Area.
    UGA Memory Max
    The maximum size of the UGA.
    PGA Memory
    The size of the Program Global Area.
    PGA Memory Max
    The maximum size of the PGA.

    Network

    The Network section of the screen presents statistics for the network (SQL* Net).
    Table 37.3 SOS Oracle Detail Memory and Network data items: Network
    Data Item
    Description
    Bytes Received from Client
    These two statistics show the traffic between SQL*NET clients and the server, in bytes.
    Bytes Sent to Client
    Round-trips (client)
    The number of times a message was sent and an acknowledgement was received.
    Bytes Received from dblink
    These two statistics show the SQL* Net traffic for database links, in bytes.
    Bytes Sent to dblink
    Round-trips (dblink)
    The number of times a message was sent and an acknowledgement was received for database links.

    Lund Performance Solutions
    www.lund.com
    Voice: (541) 812-7600
    Fax: (541) 81207611
    info@lund.com
    TOCPREVNEXTINDEX