TOCPREVNEXTINDEX

Lund Performance Solutions


SOS Oracle Main

The Oracle Main Screen

The Oracle Main screen provides lists all Oracle instances you have added and some important metrics for each instance, as well as some aggregate statistics (summed over all instances).
To access the Oracle Main 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 O (upper case). An example of the screen is shown in Figure 34.1.




  • Figure 34.1 SOS Oracle Main screen

    Adding an Oracle Instance

    To add an Oracle instance to the data collection:
  • Type R from any SOS screen.
  • SOS will prompt for the instance connect string. Enter a net service name or a full connect string in the form host:port:SID (Oracle’s listener port is usually 1521). If no instance name is entered, the default database instance on the local machine will be used.
  • Next, SOS will prompt for the user name. This user should have select rights on v$ performance views, ts$, and file$. The user must also have rights to create, select, delete, and insert tables (for SOS temporary data).
  • Finally, SOS will ask for the user’s password.
  • If more than one instance is configured, SOS will prompt you to select an instance each time you go to an Oracle detail screen.

    Deleting an Oracle Instance

    Instances may be deleted with the "T" command.

    Oracle Main Display Items

    The Oracle Main screen data items are described in the next two tables.


    Table 34.1 SOS Oracle Main data items: aggregate statistics
    Data Item
    Description
    Sessions
    The number of active sessions.
    Connections
    The number of connections to Oracle.
    Opened cursors
    The number of cursors opened.
    Locks
    The number of locks currently held.
    Commits
    The number of commits.
    Rollbacks
    The number of rollbacks.


    Table 34.2 SOS Oracle Main display items: instance lines
    Data Item
    Description
    Instance
    The instance connect string.
    LibHit
    The library hit ratio percentage.
    DtaHit
    The data dictionary hit percentage.
    BfRHit
    The row buffer hit percentage.
    Sess
    The number of active sessions.
    Conn
    The number of connections to this instance.

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