The SGA statement have three tabs. The first tab called SQL simply display all of the SQL of the statement.
The second tab called Execution plan displays the execution plan of the statement. This is described in more
detail later. The last tab called Information simply display the information available about the statement
in the SGA.
A few notes here is that the execution plan displayed here is not necessarily the same as when run depending
on one of these reasons.
What you see in this window is the execution you would get if you ran the statement like the one you are logged in
as now and in your session. One example of this problem is if a user executes SQL which accesses his own objects which
doesn't have public synonyms, then another person can simply not execute the SQL without modifying it to add owner specifier to
the tables which TOra will not do automatically.
Explain plan requires a table to store the result in. The name of this table can be configured in the options.
If the table doesn't exist TOra will ask you if it should try to create it. Without this table you can not display execution plans
in TOra.SGA Statement
This element is used to describe an element in the SGA.Explain plan
This element can be either part of an SGA statement or by itself in some cases (See above for a screenshot).
For more information about execution paths check the Oracle manual Designing and Tuning for Performance,
chapter 5 in the 8i release.
select * from essprc where prcid > :prcid and begrdt > :begrdt; |
As you can see the field name as specified after the : character is presented as a title. If the same field name is used at several parts of the query you only get to specify it once. You specify the value in the editor line just to the right of the field name label. If you want to specify a NULL value check the NULL checkbox to the right of the editor. You can also edit the value in a memo editor pressing the Edit button to the right on the value.
The parameter editor will cache it's value so it will remember the last parameters you fed to it when you run the query again.
This is a list that describes the columns of a table or view. There is nothing much special
about this view except that you can check the collected analyze statistics for the column by
placing the cursor over it and reading the tooltip that will be displayed. If no tooltip
is displayed there is no analyzed statistics available. Also notable is that this list is
read completely from the object cache if it available. This will mean that if you are modifying
the object you are modifying you need to reread the object cache before you can see the
changes.Object description