Page History
This section includes the following topics:• About
- About the SQL tab
...
- How the SQL tab is structured
...
- How the SQL tab can help you identify performance problems
About the SQL tab
The SQL tab enables you to evaluate SQL statements and manage a database warehouse of your application's SQL statements together with their respective Explain Plans. The process of explaining statements is a prerequisite for tuning. The Explain process is designed to clarify the access path chosen for a statement and translate it into a visual medium.
...
SQL Statement entered manually by the user through a New action.
NOTE If the SQL tab is opened with no statement in context, an error message is displayed requesting you open a statement.
See About the Current tab on page 40. See About the Activity tab on page 49. See About the Objects tab on page 67.
How the SQL tab is structured
...
Two sets of tabs control the information displayed in the SQL tab:• View
- View tabs
...
- Actions tab
About the View tabs
The SQL tab displays different information regarding the selected statement or batch, in different views. A statement is selected when you drill down to it in another tab (from Current or Activity tabs) or when you open a new or existing statement in the SQL tab. Click a View tab to display additional information regarding the statement or batch. Each view has a different layout.
The following View tabs are available in the SQL tab:• Plan
- Plan
...
- History
...
- Statements
About viewing the execution plan of a statement
...