1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
<html lang="en">
<head>
<title>explainplan - TOra</title>
<meta http-equiv="Content-Type" content="text/html">
<meta name="description" content="TOra">
<meta name="generator" content="makeinfo 4.13">
<link title="Top" rel="start" href="index.html#Top">
<link rel="up" href="common.html#common" title="common">
<link rel="prev" href="sgastatement.html#sgastatement" title="sgastatement">
<link rel="next" href="gettingbindparameters.html#gettingbindparameters" title="gettingbindparameters">
<link href="http://www.gnu.org/software/texinfo/" rel="generator-home" title="Texinfo Homepage">
<!--
This manual is for TOra, version 2.1.2+.-->
<meta http-equiv="Content-Style-Type" content="text/css">
<style type="text/css"><!--
pre.display { font-family:inherit }
pre.format { font-family:inherit }
pre.smalldisplay { font-family:inherit; font-size:smaller }
pre.smallformat { font-family:inherit; font-size:smaller }
pre.smallexample { font-size:smaller }
pre.smalllisp { font-size:smaller }
span.sc { font-variant:small-caps }
span.roman { font-family:serif; font-weight:normal; }
span.sansserif { font-family:sans-serif; font-weight:normal; }
--></style>
</head>
<body>
<div class="node">
<a name="explainplan"></a>
<p>
Next: <a rel="next" accesskey="n" href="gettingbindparameters.html#gettingbindparameters">gettingbindparameters</a>,
Previous: <a rel="previous" accesskey="p" href="sgastatement.html#sgastatement">sgastatement</a>,
Up: <a rel="up" accesskey="u" href="common.html#common">common</a>
<hr>
</div>
<h4 class="subsection">3.9.2 Explain plan</h4>
<p>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.
<p>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.
<ul>
<li>It is run as a different user which doesn't access the same database objects as the user you are logged in as now.
<li>The session running the query can have changed some optimizer parameters compared to your session.
</ul>
<p>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.
<p>Explain plan requires a table to store the result in. The name of this table can be configured in the options(see <a href="preferences.html#preferences">Options</a>). 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.
</body></html>
|
