Menubar

Performance Analysis for Oracle

Action Menu

The following table lists the commands on the Action menu and their uses. (The commands displayed are determined by context and cursor focus.)

Command

Use

Open in New Window

Open the New Window creation dialog wizard.

Refresh View List

Refreshes the Business views node for both this client and for system-wide changes.

New Shortcut

Create the mechanism to analyze the performance and resource consumption of specific dimensions of interest (over differing domains and filters across different time periods and granularity), both episodic and non-episodic.

New User Defined Collection

Create the mechanism by which Oracle resource consumption can be analyzed over selected domains and filters across different time periods.

Execute/Edit

Display the Summary window of the in-focus report.

Report

Open the Report Wizard dialog specification series.

Schedule

Opens the report scheduling properties dialog.

Remove Schedule

Deletes the specific report schedule currently active.

Preview

Generate window display of report.

Print

Print the in-focus saved report.

Rename

Rename an existing customized template or history view.

Delete

Delete an existing customized template or history view.

Compare

An analytic baseline feature that facilitates graphical resource comparison by dimensions between two historical time frames on a relative or absolute basis. Each item activity is broken down into its components and compared with the second time frame. See Compare.

Save Shortcut

Record the specified customized history view to be archived and retrievable.

Roll Up

When the History instance view is at a dimension node depth level of four or greater, this function shifts the focus to the top level of this dimension.

Show Top 25 Only

Limit the display to the 25 most resource-demanding domains (occurrences) of a specific dimension.

View SQL

Display the statement syntax in [Quest] SQL View.

Tune SQL

Open the SQL statement for SQL tuning (if installed).

Explain Plan History

Compare any two forms of execution plan used historically by Oracle for executing a given SQL statement.

Index Analysis

Opens all the SQL statements in the node in SQL Tuning to be subjected to the SQL Tuning Lab index advisory process (if installed).

Scalability Test

Send groups of SQL statement directly to Benchmark Factory (if installed) to create and execute scalability tests  for an automated load testing solution.

Copy SQL to Clipboard

Make the SQL text available for pasting into a Windows application.

Multi-line SQL Text

Expands the SQL display to a multi-line presentation so that the entire SQL is visible.

Summarize SQL Text

Shortens the SQL statements by replacing long SELECT  and FROM clauses with '...'

Kill Session

Launches TOAD to terminate the Oracle session.

Filter

Limits the dimension pane listing display to only those entries which meet a set of user-specified wait type numeric thresholds and SQL statement text conditions.  

Drill Down

Performs a one-level drill down to the focused node member.

Enabled

Restart collection of a paused history view.

Disabled

Pause collection of a history view.