Oracle Database/Performance Monitoring

From Wikibooks, open books for an open world
Jump to: navigation, search

On the oracle database Web administration tool, there is a usage monitor shown on the right-hand side of the screen. This displays both the Storage used by Oracle and the current Memory in use. It also lists the total sessions and users.

For a more detailed view of server settings, Enter the Administration section, and open the Monitor.

  • Sessions displays a list of users currently connected to the database.
  • System Statistics displays the current resources used by the database. It can also be set to display changes within the statistics from a given reference point.
  • Top SQL displays a list of previous SQL statements that are the most resource intensive.
  • Long Operations displays the status of operations that are taking more than 6 seconds.

Troubleshooting invalid and unusable objects[edit]

Gathering optimizer statistics[edit]

Viewing performance metrics[edit]

Reacting to performance issues[edit]