Drill-down view toolbar located just above the view allows to refresh the contents of the view manually (Refresh button on the left) or set the interval to automatically update the view.

The rotating flower icon on the left shows that the view is being updated. Once the update is complete the last update time is shown on the toolbar.

Some views also have other controls on the toolbar specific to the view, for example, Kill Session button on the Sessions view.

Tables are often used to display list-like (processes list) or tree-like (explain plan) information in drill-down views.

		The user can sort by a single column, move, resize and change the order of columns, show or hide a colum and copy or export the contents of the table. To copy a row or rows in a table select the row or multiple rows using Ctrl or Shift buttons, right-click on the table and select Copy as HTML or Copy as text. The copied rows are placed on the clipboard.
To hide or show a column in a table right-click on any column caption and check or uncheck the columns you need to show or hide. To sort by a column simply click on its caption. To sort in descending order click again. To change the order of columns click on a column caption and drag it to the desired location. To resize a column position the mouse between the column captions click and drag the caption end to the desired width.

Drill-down charts are used to visualize performance statistics over time. Drill-down charts can be configured to display a single or multiple statistics at the same time and move or narrow/stretch the time period to see statistics for.

Drill-down charts settings can be adjusted using drill-down chart configuration dialog. Press the Configure chart button at the top of the drill-down chart. In the configuration dialog you can add or remove statistics from the chart, change the line thickness, color and read the description of the statistics. Drill-down chart has three major components: the chart area, the overview band/time period chooser and the legend. The chart area is where the charts are displayed. The overview band and time period chooser become visible when the mouse is positioned over the overview line. The overview band shows all available statistics values. The time chooser allows to move and change the width of the selected time period. The legend shows the selected statistics and their chart color.

Choosing time period.  You can change the selected time period by moving it back and forth in time and by narrowing or stretching the time period.

Moving time period.  The easiest way to move the selected time period is by dragging the chart area. Position your mouse over the chart area, press its left button and drag the mouse to the right or to the left to move the time period. The same can be achieved by positioning the mouse over the time chooser handle and dragging it in the desired direction.

Stretching time period.  To narrow or widen the selected time period position your mouse over the overview line. The overview band and the time period chooser will show up. Position your mouse over the left or the right handle of the time period chooser and drag it to narrow or widen the time period. There are also shortcuts for the most common time periods in the upper part of the chart area.

Flat charts are most often to display 24 hours by 7 days summary of some performance statistics. The values are shown with the intensity of the color. The legend below the chart helps understand the distribution of statistics and the actual value can be seen by hovering the mouse over the corresponding square.

Bar charts display values as vertical bars. To see more detailed information about each value position your mouse over the bar. The value for the selected bar as well as some additional information will be shown in a tooltip.

Oracle Sessions view shows a list of Oracle sessions currently connected to the database and the details for the selected session. You can set the view to automatically refresh every N seconds or refresh it manually. The Oracle Sessions view can be filtered, sorted and searched, the columns can be moved and resized with a mouse. To hide or show columns in Sessions view right-click on a column and check or uncheck a column in the list. To search - click in the column and start typing a search expression. Use up-down arrows on the toolbar to move to the next occurrence. To open Sessions view double-click on an Oracle database and choose Sessions tab.

Current session.  The current (own) session is always highlighted for easy identification

Activity column.  One column in the All Sessions list is a special column in that its value is not directly retrieved from Oracle but rather calculated based on the sessions statistics. The value is displayed as a speed gauge and the more active the session is i.e. the more resources it is using on the server the faster the speed gauge moves. The rotation of the speed gauge helps easily and quickly pinpoint the sessions that are the most resource-intensive right now. This column is shown for active sessions only.

Long op column.  The long op column is based on the Oracle long op (long operations) statistics. If a session is reported by Oracle as performing a long operation this column shows the estimated percentage of work done as a progress bar.

Parallel server sessions.  You can easily see which sessions spawned parallel servers and how many. Parallel server sessions are displayed under their query coordinator as shown on the picture:

Advanced session filter.  Session filters can help find only the sessions the users interested in or speed up session information retrieval. All session filters are applied before the sessions are retrieved from the database and they can be especially helpful if there are too many concurrently connected sessions. Session view offers some preconfigured session filters like active sessions, long SQLs or waiting sessions. In addition to the preconfigured filter the user can add his own custom filters using all available columns, grouping if necessary using brackets, AND, OR and all operators and functions available in Oracle SQL. To get the list of available columns right-click inside the filter condition field.

Killing or disconnecting a user session.  To kill or disconnect a user session select the session in the list and press Kill Session toolbar button. You can choose whether to allow the current transaction to finish to kill immediately. In some cases it is preferrable to kill the shadow process first. It is not recommended by Oracle but sometimes it is the only way to ensure that killed session does not hang in the database until reboot. Use this option only if you cannot get rid of killed sessions otherwise.

Starting/stopping trace for a session.  To start/stop trace for a selected session or sessions select the session(s) and press Start trace or Stop trace buttons.

Top sessions view can be used to find sessions that consume most of the system resources. Select the statistics to sort the sessions by in the list on the toolbar and the number of top sessions to display.

All statistics or selected only.  Top sessions view has an option to display all statistics for all top sessions or only the statistics by which the sessions are sorted.

If Show All option was chosen the top sessions will be displayed as 3D charts where each chart shows all statistics for the session. The legend at the bottom of the view explains what statistics are displayed. The actual values are shown right below the chart. If Selected only was chosen a single 3D chart shows the selected statistic value for all top sessions. The session attributes (SID, serial# and username or background process) are displayed next to the session's bar.

Oracle Locks view shows a list of Oracle sessions currently holding or requesting a lock and the details for the selected session. You can set the view to automatically refresh every N seconds or refresh it manually. The Oracle Locks view can be filtered and sorted, the columns can be moved and resized with a mouse. To hide or show columns in Locks view right-click on a column and check or uncheck a column in the list. To open Locks view double-click on an Oracle database and choose Sessions/Locks tab.

Holders and waiters.  You can easily see which sessions are waiting for other sessions to release a lock. The waiters are shown under the holders in the order in which they requested a lock and the object they are waiting for is displayed next to the waiting session. For example in a situation as shown on the picture:

Killing or disconnecting a user session.  To kill or disconnect a user session select the session in the list and press Kill Session toolbar button. You can choose whether to allow the current transaction to finish to kill immediately. In some cases it is preferrable to kill the shadow process first. It is not recommended by Oracle but sometimes it is the only way to ensure that killed session does not hang in the database until reboot. Use this option only if you cannot get rid of killed sessions otherwise.

Starting/stopping trace for a session.  To start/stop trace for a selected session or sessions select the session(s) and press Start trace or Stop trace buttons.

Oracle Processes view shows a list of Oracle processes as returned by V$PROCESS system view. You can set the view to automatically refresh every N seconds or refresh it manually. The Oracle Processes view can be filtered and sorted, the columns can be moved and resized with a mouse. To hide or show columns in the view right-click on a column and check or uncheck a column in the list. To open Oracle processes view double-click on an Oracle database and choose Sessions/Processes tab.

Oracle session statistics view is a history view that can be configured to show statistic history for the past hour, day or month. It collects and displays session-related Oracle statistics:

Oracle Top SQL view allows to analyze and find the most expensive SQLs in terms of logical or physical I/O, CPU or other criteria. You can select the number of top N SQLs to display and the statistic to sort by: buffer gets, disk reads, executions etc.

You can set the view to automatically refresh every N seconds or refresh it manually. The Oracle SQL view can be sorted by clicking on a column but it is important to know that sorting affects only the top N SQLs that were retrieved according to the criteria (buffer gets, disk reads etc.), The columns can be moved and resized with a mouse. To hide or show columns in SQL view right-click on a column and check or uncheck a column in the list. To open SQL view double-click on an Oracle database and choose SQL/Top SQL tab.

To see the details for a SQL select it in the list. The full text, explain plan and SQL statistics are displayed in the panels below.

Top sessions view can be used to find sessions that consume most of the system resources. Select the statistics to sort the sessions by in the list on the toolbar and the number of top sessions to display.

All statistics or selected only.  Top sessions view has an option to display all statistics for all top sessions or only the statistics by which the sessions are sorted.

If Show All option was chosen the top sessions will be displayed as 3D charts where each chart shows all statistics for the session. The legend at the bottom of the view explains what statistics are displayed. The actual values are shown right below the chart. If Selected only was chosen a single 3D chart shows the selected statistic value for all top sessions. The session attributes (SID, serial# and username or background process) are displayed next to the session's bar.

To find out what tables/indexes are most heavily stressed or cause contention choose Segments I/O view. For example, to pinpoint the table, index or materialized view that accounts for most physical I/O select physical reads or writes in the list on the toolbar and sort the segments list by value in descending order by clicking on Value column caption.

	Warning
	Segments I/O view is available on Oracle 9i Release 2 and higher only.

Full statistics for the selected segment are shown in the Stats tab below the segments list.

Oracle buffer pools view shows the list of buffer pools, configured for the system, including default buffer pools for all data block sizes, keep and recycle pools.

You can set the view to automatically refresh every N seconds or refresh it manually. The Oracle buffer pools view can be sorted by clicking on a column caption, the columns can be moved and resized with a mouse. To hide or show columns in the view right-click on a column and check or uncheck a column in the list. To open Buffer pools view double-click on an Oracle database and choose Memory/Buffer Pool tab.

The statistics for a buffer pool are shown in the buffer pool statistics tab when a buffer pool is selected in the list.

Oracle buffer pool contents view shows all objects currently held in a buffer cache and the size they occupy.

You can set the view to automatically refresh every N seconds or refresh it manually. The Oracle buffer pool contents view can be sorted by clicking on a column caption, the columns can be moved and resized with a mouse. To hide or show columns in the view right-click on a column and check or uncheck a column in the list. To open Buffer pool contents view double-click on an Oracle database and choose Memory/Buffer Pool Content tab.

The statistics for a buffer pool are shown in the buffer pool statistics tab when a buffer pool is selected in the list.

The type of buffer that causes the most waits can be found using the Wait statistics view. This view shows the waits per buffer type for buffer busy waits

Oracle shared pool statistics view is a history view that can be configured to show statistic history for the past hour, day or month. It collects and displays shared pool-related Oracle statistics:

PGA statistics view is a history view that can be configured to show statistic history for the past hour, day or month. It collects and displays PGA-related Oracle statistics:

Oracle Waits view shows Oracle wait events and their related statistics. The user can choose to display or hide idle wait events

You can set the view to automatically refresh every N seconds or refresh it manually. The Oracle Waits view can be sorted by clicking on a column caption, the columns can be moved and resized with a mouse. To hide or show columns in Waits view right-click on a column and check or uncheck a column in the list. To open Waits view double-click on an Oracle database and choose Waits tab.

To see the history for a wait event or a group of wait events select the wait events in the list. The wait history chart shows wait event statistics for a week. If several wait events have been selected their statistics are added up.

Oracle Locks view shows a list of Oracle sessions currently holding or requesting a lock and the details for the selected session. You can set the view to automatically refresh every N seconds or refresh it manually. The Oracle Locks view can be filtered and sorted, the columns can be moved and resized with a mouse. To hide or show columns in Locks view right-click on a column and check or uncheck a column in the list. To open Locks view double-click on an Oracle database and choose Sessions/Locks tab.

Holders and waiters.  You can easily see which sessions are waiting for other sessions to release a lock. The waiters are shown under the holders in the order in which they requested a lock and the object they are waiting for is displayed next to the waiting session. For example in a situation as shown on the picture:

Killing or disconnecting a user session.  To kill or disconnect a user session select the session in the list and press Kill Session toolbar button. You can choose whether to allow the current transaction to finish to kill immediately. In some cases it is preferrable to kill the shadow process first. It is not recommended by Oracle but sometimes it is the only way to ensure that killed session does not hang in the database until reboot. Use this option only if you cannot get rid of killed sessions otherwise.

Starting/stopping trace for a session.  To start/stop trace for a selected session or sessions select the session(s) and press Start trace or Stop trace buttons.

The type of buffer that causes the most waits can be found using the Wait statistics view. This view shows the waits per buffer type for buffer busy waits

Oracle latches view shows the list of latches, parent and child latches and current latch holders.

You can set the view to automatically refresh every N seconds or refresh it manually. The Oracle latches view can be sorted by clicking on a column caption, the columns can be moved and resized with a mouse. To hide or show columns in the view right-click on a column and check or uncheck a column in the list. To open Latches view double-click on an Oracle database and choose Lathces tab.

Files I/O view shows the breakdown of I/O activity by Oracle files. By sorting this view you can find out what files and tablespaces account for most I/O activity

To find out what tables/indexes are most heavily stressed or cause contention choose Segments I/O view. For example, to pinpoint the table, index or materialized view that accounts for most physical I/O select physical reads or writes in the list on the toolbar and sort the segments list by value in descending order by clicking on Value column caption.

	Warning
	Segments I/O view is available on Oracle 9i Release 2 and higher only.

Full statistics for the selected segment are shown in the Stats tab below the segments list.

Logical I/O view is a history view that can be configured to show statistic history for the past hour, day or month. It collects and displays logical I/O-related Oracle statistics:

Physical I/O view is a history view that can be configured to show statistic history for the past hour, day or month. It collects and displays physical I/O-related Oracle statistics:

Table scans view is a history view that can be configured to show statistic history for the past hour, day or month. It collects and displays table scans-related Oracle statistics:

Undo tablespaces view shows the list of undo tablespaces configured for the database. The tabs below the list show the details about the selected undo tablespace, such as files that comprise the tablespace, rollback segments and their statistics and current transactions using the tablespace.

To find out what was the longest query on the database or when most undo was generated or what was the highest number of concurrently running transaction use Undo statistics view. Undo statistics view is based on V$UNDOSTAT system view and shows undo statistics for the past week grouped by hour in a 24x7 flat chart.

Undo retention view can be used to calculate undo space requirements for a given undo_retention parameter setting.

Redo groups view shows the list of redo log groups configured for the database. When a group is selected its members are shown in the redo members table. The current group is highlighted.

Log switch history view helps find out how often and when most of redo log switches occured and shows the redo log switch statistics for the past 2 weeks grouped by hour in a 24x14 flat chart.

Redo statistics view is a history view that can be configured to show statistic history for the past hour, day or month. It collects and displays redo-related Oracle statistics:

Archive destination and archived logs view shows the list of all archive destinations. When an archive destination is selected the list of archived logs for this destination is shown in the archived logs table.

Temp I/O view shows the breakdown of I/O activity by Oracle temp files. By sorting this view you can find out what temp files and tablespaces account for most I/O activity

Archive destination and archived logs view shows the list of all archive destinations. When an archive destination is selected the list of archived logs for this destination is shown in the archived logs table.