From: <mrj...@us...> - 2008-07-26 19:13:07
|
Revision: 2907 http://tora.svn.sourceforge.net/tora/?rev=2907&view=rev Author: mrjohnson0 Date: 2008-07-26 19:13:10 +0000 (Sat, 26 Jul 2008) Log Message: ----------- add html files and images Added Paths: ----------- trunk/tora/src/help/ trunk/tora/src/help/Explain-plan.html trunk/tora/src/help/Getting-bind-parameters.html trunk/tora/src/help/Index.html trunk/tora/src/help/Memo-editor.html trunk/tora/src/help/Object-description.html trunk/tora/src/help/SGA-Statement.html trunk/tora/src/help/What-privileges-do-you-need-to-run-TOra.html trunk/tora/src/help/additionalhelp.html trunk/tora/src/help/alert.html trunk/tora/src/help/analyze.html trunk/tora/src/help/api.html trunk/tora/src/help/browser.html trunk/tora/src/help/charts.html trunk/tora/src/help/common.html trunk/tora/src/help/current.html trunk/tora/src/help/database.html trunk/tora/src/help/debugger.html trunk/tora/src/help/editors.html trunk/tora/src/help/extendingtora.html trunk/tora/src/help/externalapi.html trunk/tora/src/help/fonts.html trunk/tora/src/help/globalsettings.html trunk/tora/src/help/help.html trunk/tora/src/help/history.html trunk/tora/src/help/images/ trunk/tora/src/help/images/additionalhelp.png trunk/tora/src/help/images/addwatch.png trunk/tora/src/help/images/alert.png trunk/tora/src/help/images/analyze.png trunk/tora/src/help/images/browser.png trunk/tora/src/help/images/browserfilter.png trunk/tora/src/help/images/changewatch.png trunk/tora/src/help/images/charts.png trunk/tora/src/help/images/chartsetup.png trunk/tora/src/help/images/contentfilter.png trunk/tora/src/help/images/current.png trunk/tora/src/help/images/database.png trunk/tora/src/help/images/debugger.png trunk/tora/src/help/images/describe.png trunk/tora/src/help/images/difference.png trunk/tora/src/help/images/editmenu.png trunk/tora/src/help/images/filemenu.png trunk/tora/src/help/images/fonts.png trunk/tora/src/help/images/getparam.png trunk/tora/src/help/images/help.png trunk/tora/src/help/images/helpmenu.png trunk/tora/src/help/images/invalid.png trunk/tora/src/help/images/largelogo.png trunk/tora/src/help/images/lists.png trunk/tora/src/help/images/memo.png trunk/tora/src/help/images/newconnection.png trunk/tora/src/help/images/oracle.png trunk/tora/src/help/images/output.png trunk/tora/src/help/images/pfileeditor.png trunk/tora/src/help/images/preferences.png trunk/tora/src/help/images/priviledges.png trunk/tora/src/help/images/quota.png trunk/tora/src/help/images/resize.png trunk/tora/src/help/images/rollback.png trunk/tora/src/help/images/rollbacksetup.png trunk/tora/src/help/images/script.png trunk/tora/src/help/images/searchreplace.png trunk/tora/src/help/images/security.png trunk/tora/src/help/images/session.png trunk/tora/src/help/images/sgastatement.png trunk/tora/src/help/images/sgatrace.png trunk/tora/src/help/images/sqledit.png trunk/tora/src/help/images/storage.png trunk/tora/src/help/images/template.png trunk/tora/src/help/images/templateeditor.png trunk/tora/src/help/images/templatesetup.png trunk/tora/src/help/images/toolbar.png trunk/tora/src/help/images/tools.png trunk/tora/src/help/images/toolsmenu.png trunk/tora/src/help/images/tuning.png trunk/tora/src/help/images/visualize.png trunk/tora/src/help/images/windowsmenu.png trunk/tora/src/help/images/worksheet.png trunk/tora/src/help/images/worksheetsetup.png trunk/tora/src/help/images/workspace.png trunk/tora/src/help/index.html trunk/tora/src/help/invalid.html trunk/tora/src/help/lists.html trunk/tora/src/help/newconnection.html trunk/tora/src/help/output.html trunk/tora/src/help/preferences.html trunk/tora/src/help/rollback.html trunk/tora/src/help/script.html trunk/tora/src/help/searchreplace.html trunk/tora/src/help/security.html trunk/tora/src/help/session.html trunk/tora/src/help/sqledit.html trunk/tora/src/help/storage.html trunk/tora/src/help/template.html trunk/tora/src/help/toc.html trunk/tora/src/help/tools.html trunk/tora/src/help/toolsetting.html trunk/tora/src/help/trace.html trunk/tora/src/help/tuning.html trunk/tora/src/help/unittest.html trunk/tora/src/help/window.html trunk/tora/src/help/worksheet.html trunk/tora/src/help/workspace.html Added: trunk/tora/src/help/Explain-plan.html =================================================================== --- trunk/tora/src/help/Explain-plan.html (rev 0) +++ trunk/tora/src/help/Explain-plan.html 2008-07-26 19:13:10 UTC (rev 2907) @@ -0,0 +1,53 @@ +<html lang="en"> +<head> +<title>Explain plan - TOra</title> +<meta http-equiv="Content-Type" content="text/html"> +<meta name="description" content="TOra"> +<meta name="generator" content="makeinfo 4.11"> +<link title="Top" rel="start" href="index.html#Top"> +<link rel="up" href="common.html#common" title="common"> +<link rel="prev" href="SGA-Statement.html#SGA-Statement" title="SGA Statement"> +<link rel="next" href="Getting-bind-parameters.html#Getting-bind-parameters" title="Getting bind parameters"> +<link href="http://www.gnu.org/software/texinfo/" rel="generator-home" title="Texinfo Homepage"> +<!-- +This manual is for TOra, version 1.4.0.--> +<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"> +<p> +<a name="Explain-plan"></a> +Next: <a rel="next" accesskey="n" href="Getting-bind-parameters.html#Getting-bind-parameters">Getting bind parameters</a>, +Previous: <a rel="previous" accesskey="p" href="SGA-Statement.html#SGA-Statement">SGA Statement</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> + Added: trunk/tora/src/help/Getting-bind-parameters.html =================================================================== --- trunk/tora/src/help/Getting-bind-parameters.html (rev 0) +++ trunk/tora/src/help/Getting-bind-parameters.html 2008-07-26 19:13:10 UTC (rev 2907) @@ -0,0 +1,54 @@ +<html lang="en"> +<head> +<title>Getting bind parameters - TOra</title> +<meta http-equiv="Content-Type" content="text/html"> +<meta name="description" content="TOra"> +<meta name="generator" content="makeinfo 4.11"> +<link title="Top" rel="start" href="index.html#Top"> +<link rel="up" href="common.html#common" title="common"> +<link rel="prev" href="Explain-plan.html#Explain-plan" title="Explain plan"> +<link rel="next" href="Object-description.html#Object-description" title="Object description"> +<link href="http://www.gnu.org/software/texinfo/" rel="generator-home" title="Texinfo Homepage"> +<!-- +This manual is for TOra, version 1.4.0.--> +<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"> +<p> +<a name="Getting-bind-parameters"></a> +Next: <a rel="next" accesskey="n" href="Object-description.html#Object-description">Object description</a>, +Previous: <a rel="previous" accesskey="p" href="Explain-plan.html#Explain-plan">Explain plan</a>, +Up: <a rel="up" accesskey="u" href="common.html#common">common</a> +<hr> +</div> + +<h4 class="subsection">3.9.3 Getting bind parameters</h4> + +<p>This dialog is displayed when input parameters are required to run the SQL. For instance the example dialog is the dialog displayed when running the following SQL in the worksheet. + +<pre class="example"><pre class="verbatim"> + + select * from essprc where prcid > :prcid and begrdt > :begrdt; + +</pre> +</pre> + <div class="block-image"><img src="images/getparam.png" alt="images/getparam.png"></div> + + <p>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 <strong>NULL</strong> checkbox to the right of the editor. You can also edit the value in a memo editor(see <a href="Memo-editor.html#Memo-editor">Memo editor</a>) pressing the <strong>Edit</strong> button to the right on the value. + + <p>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. + + </body></html> + Added: trunk/tora/src/help/Index.html =================================================================== --- trunk/tora/src/help/Index.html (rev 0) +++ trunk/tora/src/help/Index.html 2008-07-26 19:13:10 UTC (rev 2907) @@ -0,0 +1,74 @@ +<html lang="en"> +<head> +<title>Index - TOra</title> +<meta http-equiv="Content-Type" content="text/html"> +<meta name="description" content="TOra"> +<meta name="generator" content="makeinfo 4.11"> +<link title="Top" rel="start" href="index.html#Top"> +<link rel="prev" href="extendingtora.html#extendingtora" title="extendingtora"> +<link href="http://www.gnu.org/software/texinfo/" rel="generator-home" title="Texinfo Homepage"> +<!-- +This manual is for TOra, version 1.4.0.--> +<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"> +<p> +<a name="Index"></a> +Previous: <a rel="previous" accesskey="p" href="extendingtora.html#extendingtora">extendingtora</a>, +Up: <a rel="up" accesskey="u" href="index.html#Top">Top</a> +<hr> +</div> + +<h2 class="unnumbered">Index</h2> + +<ul class="index-cp" compact> +<li><a href="additionalhelp.html#index-Additional-Help-Settings-13">Additional Help Settings</a>: <a href="additionalhelp.html#additionalhelp">additionalhelp</a></li> +<li><a href="alert.html#index-Alert-Tool-30">Alert Tool</a>: <a href="alert.html#alert">alert</a></li> +<li><a href="tools.html#index-Available-tools-16">Available tools</a>: <a href="tools.html#tools">tools</a></li> +<li><a href="newconnection.html#index-Connecting-to-a-database-5">Connecting to a database</a>: <a href="newconnection.html#newconnection">newconnection</a></li> +<li><a href="current.html#index-Current-Session-27">Current Session</a>: <a href="current.html#current">current</a></li> +<li><a href="browser.html#index-Database-Browser-18">Database Browser</a>: <a href="browser.html#browser">browser</a></li> +<li><a href="database.html#index-Database-Settings-11">Database Settings</a>: <a href="database.html#database">database</a></li> +<li><a href="window.html#index-Elements-of-the-main-window-4">Elements of the main window</a>: <a href="window.html#window">window</a></li> +<li><a href="extendingtora.html#index-Extending-TOra-35">Extending TOra</a>: <a href="extendingtora.html#extendingtora">extendingtora</a></li> +<li><a href="fonts.html#index-Font-Settings-12">Font Settings</a>: <a href="fonts.html#fonts">fonts</a></li> +<li><a href="workspace.html#index-Getting-to-know-your-workspace-3">Getting to know your workspace</a>: <a href="workspace.html#workspace">workspace</a></li> +<li><a href="history.html#index-History-and-future-of-TOra-2">History and future of TOra</a>: <a href="history.html#history">history</a></li> +<li><a href="invalid.html#index-Invalid-Objects-31">Invalid Objects</a>: <a href="invalid.html#invalid">invalid</a></li> +<li><a href="lists.html#index-lists-7">lists</a>: <a href="lists.html#lists">lists</a></li> +<li><a href="preferences.html#index-Options-10">Options</a>: <a href="preferences.html#preferences">preferences</a></li> +<li><a href="common.html#index-Other-common-elements-15">Other common elements</a>: <a href="common.html#common">common</a></li> +<li><a href="debugger.html#index-PL_002fSQL-Debugger-19">PL/SQL Debugger</a>: <a href="debugger.html#debugger">debugger</a></li> +<li><a href="unittest.html#index-PL_002fSQL-Unit-Tester-20">PL/SQL Unit Tester</a>: <a href="unittest.html#unittest">unittest</a></li> +<li><a href="rollback.html#index-Rollback-Segments-25">Rollback Segments</a>: <a href="rollback.html#rollback">rollback</a></li> +<li><a href="script.html#index-Schema-extraction_002c-compare-and-search-28">Schema extraction, compare and search</a>: <a href="script.html#script">script</a></li> +<li><a href="searchreplace.html#index-Search-_0026-Replace-9">Search & Replace</a>: <a href="searchreplace.html#searchreplace">searchreplace</a></li> +<li><a href="security.html#index-Security-Manager-22">Security Manager</a>: <a href="security.html#security">security</a></li> +<li><a href="tuning.html#index-Server-Tuning-21">Server Tuning</a>: <a href="tuning.html#tuning">tuning</a></li> +<li><a href="session.html#index-Session-Manager-24">Session Manager</a>: <a href="session.html#session">session</a></li> +<li><a href="trace.html#index-SGA-Trace-26">SGA Trace</a>: <a href="trace.html#trace">trace</a></li> +<li><a href="sqledit.html#index-SQL-Editor-34">SQL Editor</a>: <a href="sqledit.html#sqledit">sqledit</a></li> +<li><a href="output.html#index-SQL-Output-32">SQL Output</a>: <a href="output.html#output">output</a></li> +<li><a href="worksheet.html#index-SQL-Worksheet-17">SQL Worksheet</a>: <a href="worksheet.html#worksheet">worksheet</a></li> +<li><a href="analyze.html#index-Statistics-manager-29">Statistics manager</a>: <a href="analyze.html#analyze">analyze</a></li> +<li><a href="storage.html#index-Storage-Manager-23">Storage Manager</a>: <a href="storage.html#storage">storage</a></li> +<li><a href="template.html#index-Template-Help-33">Template Help</a>: <a href="template.html#template">template</a></li> +<li><a href="toolsetting.html#index-Tool-Settings-14">Tool Settings</a>: <a href="toolsetting.html#toolsetting">toolsetting</a></li> +<li><a href="api.html#index-TOra-Tool-Tutorial-36">TOra Tool Tutorial</a>: <a href="api.html#api">api</a></li> +<li><a href="charts.html#index-Using-charts-8">Using charts</a>: <a href="charts.html#charts">charts</a></li> +<li><a href="editors.html#index-Using-editors-6">Using editors</a>: <a href="editors.html#editors">editors</a></li> +<li><a href="help.html#index-Using-the-help-browser-1">Using the help browser</a>: <a href="help.html#help">help</a></li> + </ul></body></html> + Added: trunk/tora/src/help/Memo-editor.html =================================================================== --- trunk/tora/src/help/Memo-editor.html (rev 0) +++ trunk/tora/src/help/Memo-editor.html 2008-07-26 19:13:10 UTC (rev 2907) @@ -0,0 +1,43 @@ +<html lang="en"> +<head> +<title>Memo editor - TOra</title> +<meta http-equiv="Content-Type" content="text/html"> +<meta name="description" content="TOra"> +<meta name="generator" content="makeinfo 4.11"> +<link title="Top" rel="start" href="index.html#Top"> +<link rel="up" href="common.html#common" title="common"> +<link rel="prev" href="Object-description.html#Object-description" title="Object description"> +<link href="http://www.gnu.org/software/texinfo/" rel="generator-home" title="Texinfo Homepage"> +<!-- +This manual is for TOra, version 1.4.0.--> +<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"> +<p> +<a name="Memo-editor"></a> +Previous: <a rel="previous" accesskey="p" href="Object-description.html#Object-description">Object description</a>, +Up: <a rel="up" accesskey="u" href="common.html#common">common</a> +<hr> +</div> + +<h4 class="subsection">3.9.5 Memo editor</h4> + +<div class="block-image"><img src="images/memo.png" alt="images/memo.png"></div> + + <p>This is used to display or edit larger text than is easily entered in a oneline editor or list. To the top is a toolbar with some editing buttons. Specifically you have the save changes button to the left. You can also do this using the key <strong>CTRL+Return</strong>. +You can remove the editor without saving changes using the <strong>Escape</strong> key or closing the window. + + </body></html> + Added: trunk/tora/src/help/Object-description.html =================================================================== --- trunk/tora/src/help/Object-description.html (rev 0) +++ trunk/tora/src/help/Object-description.html 2008-07-26 19:13:10 UTC (rev 2907) @@ -0,0 +1,44 @@ +<html lang="en"> +<head> +<title>Object description - TOra</title> +<meta http-equiv="Content-Type" content="text/html"> +<meta name="description" content="TOra"> +<meta name="generator" content="makeinfo 4.11"> +<link title="Top" rel="start" href="index.html#Top"> +<link rel="up" href="common.html#common" title="common"> +<link rel="prev" href="Getting-bind-parameters.html#Getting-bind-parameters" title="Getting bind parameters"> +<link rel="next" href="Memo-editor.html#Memo-editor" title="Memo editor"> +<link href="http://www.gnu.org/software/texinfo/" rel="generator-home" title="Texinfo Homepage"> +<!-- +This manual is for TOra, version 1.4.0.--> +<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"> +<p> +<a name="Object-description"></a> +Next: <a rel="next" accesskey="n" href="Memo-editor.html#Memo-editor">Memo editor</a>, +Previous: <a rel="previous" accesskey="p" href="Getting-bind-parameters.html#Getting-bind-parameters">Getting bind parameters</a>, +Up: <a rel="up" accesskey="u" href="common.html#common">common</a> +<hr> +</div> + +<h4 class="subsection">3.9.4 Object description</h4> + +<div class="block-image"><img src="images/describe.png" alt="images/describe.png"></div> + + <p>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. + + </body></html> + Added: trunk/tora/src/help/SGA-Statement.html =================================================================== --- trunk/tora/src/help/SGA-Statement.html (rev 0) +++ trunk/tora/src/help/SGA-Statement.html 2008-07-26 19:13:10 UTC (rev 2907) @@ -0,0 +1,44 @@ +<html lang="en"> +<head> +<title>SGA Statement - TOra</title> +<meta http-equiv="Content-Type" content="text/html"> +<meta name="description" content="TOra"> +<meta name="generator" content="makeinfo 4.11"> +<link title="Top" rel="start" href="index.html#Top"> +<link rel="up" href="common.html#common" title="common"> +<link rel="next" href="Explain-plan.html#Explain-plan" title="Explain plan"> +<link href="http://www.gnu.org/software/texinfo/" rel="generator-home" title="Texinfo Homepage"> +<!-- +This manual is for TOra, version 1.4.0.--> +<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"> +<p> +<a name="SGA-Statement"></a> +Next: <a rel="next" accesskey="n" href="Explain-plan.html#Explain-plan">Explain plan</a>, +Up: <a rel="up" accesskey="u" href="common.html#common">common</a> +<hr> +</div> + +<h4 class="subsection">3.9.1 SGA Statement</h4> + +<p>This element is used to describe an element in the SGA. + + <div class="block-image"><img src="images/sgastatement.png" alt="images/sgastatement.png"></div> + + <p>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. + + </body></html> + Added: trunk/tora/src/help/What-privileges-do-you-need-to-run-TOra.html =================================================================== --- trunk/tora/src/help/What-privileges-do-you-need-to-run-TOra.html (rev 0) +++ trunk/tora/src/help/What-privileges-do-you-need-to-run-TOra.html 2008-07-26 19:13:10 UTC (rev 2907) @@ -0,0 +1,44 @@ +<html lang="en"> +<head> +<title>What privileges do you need to run TOra - TOra</title> +<meta http-equiv="Content-Type" content="text/html"> +<meta name="description" content="TOra"> +<meta name="generator" content="makeinfo 4.11"> +<link title="Top" rel="start" href="index.html#Top"> +<link rel="up" href="workspace.html#workspace" title="workspace"> +<link rel="prev" href="newconnection.html#newconnection" title="newconnection"> +<link rel="next" href="editors.html#editors" title="editors"> +<link href="http://www.gnu.org/software/texinfo/" rel="generator-home" title="Texinfo Homepage"> +<!-- +This manual is for TOra, version 1.4.0.--> +<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"> +<p> +<a name="What-privileges-do-you-need-to-run-TOra"></a> +Next: <a rel="next" accesskey="n" href="editors.html#editors">editors</a>, +Previous: <a rel="previous" accesskey="p" href="newconnection.html#newconnection">newconnection</a>, +Up: <a rel="up" accesskey="u" href="workspace.html#workspace">workspace</a> +<hr> +</div> + +<h3 class="section">3.3 What privileges do you need to run TOra</h3> + +<p>TOra should be able to run as any user, although off course you can never do anything in TOra that aren't allowed from that Oracle account. You will be able to use pretty much any tool in TOra for read only purposes if you are granted the <strong>SELECT_CATALOG_ROLE</strong>, also some parts of TOra will have limited functionality if you do not have the <strong>ALTER SESSION</strong> privilege. + + <p>Also you need to be able to create the plan table if that is not done for you. The plan table (see <a href="database.html#database">Database Settings</a> for how to select plan table name) must also be available with <strong>INSERT</strong> and <strong>SELECT</strong> access. TOra will function without the plan table but off course you will not be able to display any execution plans. + + </body></html> + Added: trunk/tora/src/help/additionalhelp.html =================================================================== --- trunk/tora/src/help/additionalhelp.html (rev 0) +++ trunk/tora/src/help/additionalhelp.html 2008-07-26 19:13:10 UTC (rev 2907) @@ -0,0 +1,59 @@ +<html lang="en"> +<head> +<title>additionalhelp - TOra</title> +<meta http-equiv="Content-Type" content="text/html"> +<meta name="description" content="TOra"> +<meta name="generator" content="makeinfo 4.11"> +<link title="Top" rel="start" href="index.html#Top"> +<link rel="up" href="preferences.html#preferences" title="preferences"> +<link rel="prev" href="fonts.html#fonts" title="fonts"> +<link rel="next" href="toolsetting.html#toolsetting" title="toolsetting"> +<link href="http://www.gnu.org/software/texinfo/" rel="generator-home" title="Texinfo Homepage"> +<!-- +This manual is for TOra, version 1.4.0.--> +<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"> +<p> +<a name="additionalhelp"></a> +Next: <a rel="next" accesskey="n" href="toolsetting.html#toolsetting">toolsetting</a>, +Previous: <a rel="previous" accesskey="p" href="fonts.html#fonts">fonts</a>, +Up: <a rel="up" accesskey="u" href="preferences.html#preferences">preferences</a> +<hr> +</div> + +<h4 class="subsection">3.8.4 Additional Help Settings</h4> + +<p><a name="index-Additional-Help-Settings-13"></a> +This page is used to configure extra manuals for viewing in the TOra help viewer. Specifically the Oracle HTML based manuals which contents can be parsed and included in the left pane contents tree of the TOra help. + + <div class="block-image"><img src="images/additionalhelp.png" alt="images/additionalhelp.png"></div> + + <p>If you have compiled TOra with KDE support (Not Windows or Qt versions) you can point this to any HTTP location. You could even use the help browser to browse the Oracle manuals directly from Technet if you wanted to (Free membership required). + + <dl> +<dt>‘<samp><span class="samp">Remove path</span></samp>’<dd>This will remove the currently selected manual from the list. +‘<samp><span class="samp">Remove path</span></samp>’ + + <br><dt>‘<samp><span class="samp">Oracle Manuals</span></samp>’<dd>This is a quick way to add a collection of manuals. When you select this button a dialog will pop up and ask you for a filename. In Oracle 8 this should be the index page that contains the links to the manuals. Observe that this is not the page which links to the different book categories. In Oracle 9i you should point it to the docindex.htm file in the base directory of the documentation. If successful all the manuals available on the page is added to the list of manuals. +‘<samp><span class="samp">Oracle Manuals</span></samp>’ + + <br><dt>‘<samp><span class="samp">Add path</span></samp>’<dd>Add a manual to the list of manuals. This pop up a dialog asking for the name of the manual and the location of the manuals table of contents HTML file (toc.html). +‘<samp><span class="samp">Add path</span></samp>’ + + </dl> + + </body></html> + Added: trunk/tora/src/help/alert.html =================================================================== --- trunk/tora/src/help/alert.html (rev 0) +++ trunk/tora/src/help/alert.html 2008-07-26 19:13:10 UTC (rev 2907) @@ -0,0 +1,63 @@ +<html lang="en"> +<head> +<title>alert - TOra</title> +<meta http-equiv="Content-Type" content="text/html"> +<meta name="description" content="TOra"> +<meta name="generator" content="makeinfo 4.11"> +<link title="Top" rel="start" href="index.html#Top"> +<link rel="up" href="tools.html#tools" title="tools"> +<link rel="prev" href="analyze.html#analyze" title="analyze"> +<link rel="next" href="invalid.html#invalid" title="invalid"> +<link href="http://www.gnu.org/software/texinfo/" rel="generator-home" title="Texinfo Homepage"> +<!-- +This manual is for TOra, version 1.4.0.--> +<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"> +<p> +<a name="alert"></a> +Next: <a rel="next" accesskey="n" href="invalid.html#invalid">invalid</a>, +Previous: <a rel="previous" accesskey="p" href="analyze.html#analyze">analyze</a>, +Up: <a rel="up" accesskey="u" href="tools.html#tools">tools</a> +<hr> +</div> + +<h3 class="section">4.14 Alert Tool</h3> + +<p><a name="index-Alert-Tool-30"></a>This tool is usefull for debugging database packages that send or depend on receiving dbms alerts. + + <div class="block-image"><img src="images/alert.png" alt="images/alert.png"></div> + + <p>This tool is controled solely from it's toolbar which is followed by a list containing the alerts received so far on the watched alerts. The toolbar contains the following controls. + + <dl> +<dt>Registered<dd>This list contains the alerts that are registered for listening. To add a new alert simply write the name in this combo box and press return or the register current button immediately to the right. To remove an alert select it in the list and press the remove registered button.‘<samp><span class="samp">Registered</span></samp>’. + + <br><dt><strong>Register current</strong><dd>Register the name currently entered in the registered combo box. + + <br><dt><strong>Remove registered</strong><dd>Stop listening to the registered alert currently selected in the registered combo box. + + <br><dt><strong>Name</strong><dd>Name of the alert to send. + + <br><dt><strong>Message</strong><dd>Message to send in an alert. Pressing return in this lineedit will send the alert. + + <br><dt><strong>Edit message in memo</strong><dd>Edit the message in a memo editor, usefull for sending newlines and longer messages. + + <br><dt><strong>Send alert</strong><dd>Send the currently defined alert. You can also send an alert by pressing return in the message line editor. + + </dl> + + </body></html> + Added: trunk/tora/src/help/analyze.html =================================================================== --- trunk/tora/src/help/analyze.html (rev 0) +++ trunk/tora/src/help/analyze.html 2008-07-26 19:13:10 UTC (rev 2907) @@ -0,0 +1,74 @@ +<html lang="en"> +<head> +<title>analyze - TOra</title> +<meta http-equiv="Content-Type" content="text/html"> +<meta name="description" content="TOra"> +<meta name="generator" content="makeinfo 4.11"> +<link title="Top" rel="start" href="index.html#Top"> +<link rel="up" href="tools.html#tools" title="tools"> +<link rel="prev" href="script.html#script" title="script"> +<link rel="next" href="alert.html#alert" title="alert"> +<link href="http://www.gnu.org/software/texinfo/" rel="generator-home" title="Texinfo Homepage"> +<!-- +This manual is for TOra, version 1.4.0.--> +<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"> +<p> +<a name="analyze"></a> +Next: <a rel="next" accesskey="n" href="alert.html#alert">alert</a>, +Previous: <a rel="previous" accesskey="p" href="script.html#script">script</a>, +Up: <a rel="up" accesskey="u" href="tools.html#tools">tools</a> +<hr> +</div> + +<h3 class="section">4.13 Statistics manager</h3> + +<p><a name="index-Statistics-manager-29"></a> +This tool is usefull for collecting statistics and analyze tables in parallel. You can also use it to browse collected statistics. + + <div class="block-image"><img src="images/analyze.png" alt="images/analyze.png"></div> + + <p>You control the interface through the controls in the toolbar. The rest of the interface simply displays currently available tables in the current schema. When collecting statistics only the selected items in the tablelist are analyzed. + + <dl> +<dt>‘<samp><span class="samp">Refresh</span></samp>’<dd>Refresh the table list from the database. +‘<samp><span class="samp">Refresh</span></samp>’ + + <br><dt>‘<samp><span class="samp">Schema</span></samp>’<dd>The next control is which schema to investigate tables for. +‘<samp><span class="samp">Schema</span></samp>’ + + <br><dt>‘<samp><span class="samp">Operation</span></samp>’<dd>What operation to perform. Select one of <strong>compute statistics</strong>, <strong>estimate statistics</strong>, <strong>delete statistics</strong> and <strong>validate references</strong>. +‘<samp><span class="samp">Operation</span></samp>’ + + <br><dt>‘<samp><span class="samp">Target</span></samp>’<dd>Depending on the <strong>operation</strong> you can sometimes select what kind of statistic to collect. Choose between <strong>all</strong>, <strong>table</strong>, <strong>indexed columns</strong> and <strong>local indexes</strong>. +‘<samp><span class="samp">Target</span></samp>’ + + <br><dt>‘<samp><span class="samp">Sample</span></samp>’<dd>If the <strong>operation</strong> is <strong>estimate statistics</strong> you can choose how large sample should be used to estimate the statistic information in percent of total amount of data. +‘<samp><span class="samp">Sample</span></samp>’ + + <br><dt>‘<samp><span class="samp">Parallel</span></samp>’<dd>Indicate the number of separate connections to open to the database and run collecting statistics concurrently when collecting. +‘<samp><span class="samp">Parallel</span></samp>’ + + <br><dt>‘<samp><span class="samp">Start analyzing</span></samp>’<dd>Press this button to perform the indicated operation on the tables selected in the list below the toolbar. +‘<samp><span class="samp">Start analyzing</span></samp>’ + + <br><dt>‘<samp><span class="samp">Stop</span></samp>’<dd>Stop current run. Before the stop button you can also see information about the currently running statistics gathering run if any is running. +‘<samp><span class="samp">Stop</span></samp>’ + + </dl> + + </body></html> + Added: trunk/tora/src/help/api.html =================================================================== --- trunk/tora/src/help/api.html (rev 0) +++ trunk/tora/src/help/api.html 2008-07-26 19:13:10 UTC (rev 2907) @@ -0,0 +1,254 @@ +<html lang="en"> +<head> +<title>api - TOra</title> +<meta http-equiv="Content-Type" content="text/html"> +<meta name="description" content="TOra"> +<meta name="generator" content="makeinfo 4.11"> +<link title="Top" rel="start" href="index.html#Top"> +<link rel="up" href="extendingtora.html#extendingtora" title="extendingtora"> +<link rel="next" href="externalapi.html#externalapi" title="externalapi"> +<link href="http://www.gnu.org/software/texinfo/" rel="generator-home" title="Texinfo Homepage"> +<!-- +This manual is for TOra, version 1.4.0.--> +<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"> +<p> +<a name="api"></a> +Next: <a rel="next" accesskey="n" href="externalapi.html#externalapi">externalapi</a>, +Up: <a rel="up" accesskey="u" href="extendingtora.html#extendingtora">extendingtora</a> +<hr> +</div> + +<h3 class="section">5.1 TOra Tool Tutorial</h3> + +<p><a name="index-TOra-Tool-Tutorial-36"></a> +This tutorial will create a simple tool that can execute an SQL statement and display it's content in a list. This tutorial assumes you have knowledge of C++ and Qt programming. + + <p>First of all we create an include file which defines the tool widget. This is the window that will be displayed when the a tool window is created. How that happens comes later. + +<pre class="example"><pre class="verbatim"> + + #ifndef TOSIMPLEQUERY_H + #define TOSIMPLEQUERY_H + + #include "totool.h" + + class toResultView; + class QLineEdit; + class toConnection; + + class toSimpleQuery : public toToolWidget { + Q_OBJECT + + toResultView *Result; + QLineEdit *Statement; + private slots: + void execute(void); + public: + toSimpleQuery(QWidget *parent,toConnection &connection); + }; + + #endif + +</pre> +</pre> + <p>If this file is put in the main TOra source directory the configure script will generate the appropriate moc file which will be needed later. If you don't know what moc is, please go back to the Qt manual to read up on slots and signals. + + <p>The rest is pretty straight forward and will be much clearer after we start working our way through the implementation of this tool. + + <p>The first thing we need to do is create a tool description which is done by subclassing the toTool class. This is how we implement this class for this function. + +<pre class="example"><pre class="verbatim"> + + #include "totool.h" + #include "tosimplequery.h" + + static char * tosimplequery_xpm[] = { + "16 16 3 1", + " c None", + ".c #000000", + "+c #FFFFFF", + " ...... ", + " ..++++. ", + " .+.++++. ", + " .++.++++. ", + " .....++++. ", + " .++++++++. ", + " .++++++++. ", + " .++++++++. ", + " .++++++++. ", + " .++++++++. ", + " .++++++++. ", + " .++++++++. ", + " .++++++++. ", + " .++++++++. ", + " .++++++++. ", + " .......... "}; + + class toSimpleQueryTool : public toTool { + protected: + virtual char **pictureXPM(void) + { return tosimplequery_xpm; } + public: + toSimpleQueryTool() + : toTool(203,"Simple Query") + { } + virtual const char *menuItem() + { return "Simple Query"; } + virtual QWidget *toolWindow(QWidget *parent,toConnection &connection) + { + return new toSimpleQuery(parent,connection); + } + }; + + static toSimpleQueryTool SimpleQueryTool; + +</pre> +</pre> + <p>The first thing that happens is that we include the header file which defines the tool widget and the tool definition header files. Even if this is included in the tosimplequery.h it is good practice not to assume any extra files are included by header files. + + <p>Next comes a definition of an xpm pixmap. Normally these are placed in the icons directory and then included into the file as you can see in the TOra source. This is placed inline for clarity. + + <p>The next one is the big one. Here we define the tool class which has a few important virtual functions. + + <dl> +<dt>‘<samp><span class="samp">pictureXPM</span></samp>’<dd>This function should if defined return a pointer to a xpm definition. This will then be used for toolbar icon, menu icon and tool window icon. +‘<samp><span class="samp">pictureXPM</span></samp>’ + + <br><dt>‘<samp><span class="samp">menuItem</span></samp>’<dd>Should return a string containing the name of the menu item to add to the tools menu. This is also used for a tip for the toolbar icon by default. +‘<samp><span class="samp">menuItem</span></samp>’ + + <br><dt>‘<samp><span class="samp">toolWindow</span></samp>’<dd>This function will create a new tool widget and return a pointer to it. It doesn't need to create a widget, then it should then return NULL. Some tools there might only be one per connection for instance. +‘<samp><span class="samp">toolWindow</span></samp>’ + + </dl> + + <p>The number in the constructor is a priority indicator that denote where in the list of tools this tool should be inserted, between each 100 step a separator is inserted into the toolbar and menubar. + + <p>And last a not so obvious line where the an instance of the tool descriptor is instantiated. This is a feature that is used a lot in TOra. This will ensure that all tools are registered when the application is started. It also works when using modules, if this is compiled as a module the tool will be instantiated on loading without any hassle with functions with predefined names and such stuff. + + <p>Lastly comes the implementation of the tool widget which is not much longer. I have divided this into several parts to simplify explaining them. + +<pre class="example"><pre class="verbatim"> + + #include <list> + + #include <qtoolbar.h> + #include <qlabel.h> + #include <qtoolbutton.h> + #include <qlineedit.h> + + #include "tosimplequery.h" + #include "toresultview.h" + #include "toparamget.h" + #include "tochangeconnection.h" + + #include "tosimplequery.moc" + + static char * execute_xpm[] = { + "16 16 3 1", + " c None", + ".c #000000", + "+c #0FFE14", + " ", + " ", + " ", + " . ", + " .. ", + " .+. ", + " .++. ", + " .+++. ", + " .+++. ", + " .++. ", + " .+. ", + " .. ", + " . ", + " ", + " ", + " "}; + + toSimpleQuery::toSimpleQuery(QWidget *main,toConnection &connection) + : toToolWidget(SimpleQueryTool,"simplequery.html",main,connection) + { + QToolBar *toolbar=toAllocBar(this,"Simple Query",connection.description()); + QPixmap executePixmap((const char **)execute_xpm); + new QToolButton(executePixmap, + "Execute current statement", + "Execute current statement", + this,SLOT(execute()), + toolbar); + toolbar->setStretchableWidget(new QLabel("",toolbar)); + new toChangeConnection(toolbar); + +</pre> +</pre> + <p>In this part the parent constructor is called and the toolbar is set up. Also note the inclusion of the moc file which by convention is called tosimplequery.moc. One thing worth noticing here is the toAllocBar which is used to be able to transparently support either using KToolBar or QToolBar depending on whether this is a Qt or KDE application. This is very important since TOra also supports windows to which KDE is not available. + + <p>The second part is the setStretchableWidget call which is used to indicate that an empty label should be stretch instead of the tool button which just looks really weird. + + <p>Also worth noting is that the toToolWidget class is derived from QVBox so any widgets constructed in this widget will be lined up vertically in the order of creation. + + <p>Next up is creating our widgets and connecting them. + +<pre class="example"><pre class="verbatim"> + + Statement=new QLineEdit(this); + Result=new toResultView(this); + connect(Statement,SIGNAL(returnPressed()),this,SLOT(execute())); + } + +</pre> +</pre> + <p>This just adds two additional widgets and connect the returnPressed signal to the execute slot. One thing to realise here is that all the toResult children will use the connection of the closest parent of type toToolWidget in the widget hierarchy. And now the last thing to do is implement the execute method. + +<pre class="example"><pre class="verbatim"> + + void toSimpleQuery::execute(void) + { + try { + QString sql=Statement->text(); + toQList params=toParamGet::getParam(this,sql); + Result->query(sql,params); + } TOCATCH + } + +</pre> +</pre> + <p>The toParamGet::getParam function is used to ask for bind values in the query string. To understand what I mean try executing the query "select :hello from dual" when you try the result. The toQList is simple a list of toQValue which can hold different datatypes and converting between them transparently. + + <p>Now finally to compile this module you need to add the tosimplequery.cpp file to SOURCES define in the file Makefile. To build a plugin you also need to add the following line. + +<pre class="example"><pre class="verbatim"> + + plugins/tosimplequery.tso:objs/tosimplequery.o + +</pre> +</pre> + <p>This should go among the other plugin definitions and you also need to add the plugins/tosimplequery.tso to the dependencies of tora-plugin. + + <p>You must rerun configure for the tosimplequery.moc file to be generated the first time. Any subsequent changes should update the moc file automatically from the Makefile. + + <p>Here are the example files in their entire. + + <ul> +<li><a href="tosimplequery.h">tosimplequery.h</a> +<li><a href="tosimplequery.cpp">tosimplequery.cpp</a> +</ul> + + <p>Hopefully this is a starting point to help you read the rest of the documentation and start cranking out those plugins. + + </body></html> + Added: trunk/tora/src/help/browser.html =================================================================== --- trunk/tora/src/help/browser.html (rev 0) +++ trunk/tora/src/help/browser.html 2008-07-26 19:13:10 UTC (rev 2907) @@ -0,0 +1,276 @@ +<html lang="en"> +<head> +<title>browser - TOra</title> +<meta http-equiv="Content-Type" content="text/html"> +<meta name="description" content="TOra"> +<meta name="generator" content="makeinfo 4.11"> +<link title="Top" rel="start" href="index.html#Top"> +<link rel="up" href="tools.html#tools" title="tools"> +<link rel="prev" href="worksheet.html#worksheet" title="worksheet"> +<link rel="next" href="debugger.html#debugger" title="debugger"> +<link href="http://www.gnu.org/software/texinfo/" rel="generator-home" title="Texinfo Homepage"> +<!-- +This manual is for TOra, version 1.4.0.--> +<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"> +<p> +<a name="browser"></a> +Next: <a rel="next" accesskey="n" href="debugger.html#debugger">debugger</a>, +Previous: <a rel="previous" accesskey="p" href="worksheet.html#worksheet">worksheet</a>, +Up: <a rel="up" accesskey="u" href="tools.html#tools">tools</a> +<hr> +</div> + +<h3 class="section">4.2 Database Browser</h3> + +<p><a name="index-Database-Browser-18"></a> +This tool provides you a simple browser for exploring database schema objects. Initially it can be said that the browser also provides a browser like functionality for the template help (see <a href="template.html#template">Template Help</a>) +which is covered separately. This browser will provide you with more information and you will also in future versions of TOra be able to interact with schema objects (Dropping or create tables etc.), this is not possible in the +<!-- @uref{template.html, template help} --> +version. The template help on the other hand is tree based and some people consider it easier and faster to work with. + + <div class="block-image"><img src="images/browser.png" alt="images/browser.png"></div> + +<!-- * Using the browser:: --> +<!-- * Available information:: --> +<!-- * Content editor:: --> +<!-- * Defining a filter:: --> + </ul> + +<!-- @node Using the browser, Available information, browser, browser --> +<h4 class="subheading">Using the browser</h4> + +<p>The database browser has a very simple interface with a toolbar which contain the following functions. All of these are also available in the Browser menu item except for the schema selection and change object. + + <dl> +<dt><strong>Refresh</strong><dd>Refresh the displayed data from the database. Also available on the <strong>F5</strong> key. + + <br><dt><strong>Define filter</strong><dd>Displays the define filter dialog( +<!-- @pxref{Defining a filter} --> +). This is used to specify which objects to show in the browser. The default filter is to show everything. Also available on the <strong>CTRL+SHIFT+G</strong> key. + + <br><dt><strong>Clear filter</strong><dd>Remove the current filter and revert to the default of showing everything. Also available on the <strong>CTRL+SHIFT+H</strong> key. + + <br><dt><strong>Schema</strong><dd>The last item on the toolbar is a combo box where you can select the schema to display objects for. It defaults the schema you are currently logged in as. Only schemas that are visible to the current user is selectable in the lost (Really, TOra does not contain the secret DBA password that will always let you access everything regardless of your privileges). + + <br><dt><strong>Change connection</strong><dd>Change the connection this tool window should operate on. + + </dl> + + <p>The rest of the interface consists of two tabbed windows, one within the other. The first one you can use to select the object type you want to inspect. When you have selected a type you can see the visible objects of the specified type available in the selected schema. The second tab indicate what kind of information you want to explore about the selected object and depends on the object type ( +<!-- @pxref{Available information} --> +.). When you select an object name in the left list you can inspect information about it to the right. + + <p>You can move the keyboard focus to the schema selection using <strong>ALT+S</strong> and to the current object list using <strong>ALT+N</strong>. + +<!-- * Available information:: --> +<!-- * Content editor:: --> +<!-- * Defining a filter:: --> + </ul> + +<!-- @node Available information, Content editor, Using the browser, browser --> +<h4 class="subheading">Available information</h4> + +<p>This is the available information for the different object types. + + <p><table summary=""> +<tr align="left"><th valign="top" width="20%">Object type +</th><th valign="top" width="30%">Name +</th><th valign="top" width="50%">Description + +<p><br></th></tr><tr align="left"><td valign="top" width="20%"><strong>Tables</strong> +</td><td valign="top" width="30%"> +</td><td valign="top" width="50%"> +<br></td></tr><tr align="left"><td valign="top" width="20%"></td><td valign="top" width="30%"><strong>Columns</strong> +</td><td valign="top" width="50%">A description of the columns in the table. For more information about this information also see object description. +<br></td></tr><tr align="left"><td valign="top" width="20%"></td><td valign="top" width="30%"><strong>Indexes</strong> +</td><td valign="top" width="50%">A list with the indexes that have been created for this table. +<br></td></tr><tr align="left"><td valign="top" width="20%"></td><td valign="top" width="30%"><strong>References</strong> +</td><td valign="top" width="50%">Displays the foreign key constraints that references this table and the other objects that have dependencies on this table. +<br></td></tr><tr align="left"><td valign="top" width="20%"></td><td valign="top" width="30%"><strong>Grants</strong> +</td><td valign="top" width="50%">The grants that have been made on this table. +<br></td></tr><tr align="left"><td valign="top" width="20%"></td><td valign="top" width="30%"><strong>Triggers</strong> +</td><td valign="top" width="50%">Lists the triggers that exist for this table. +<br></td></tr><tr align="left"><td valign="top" width="20%"></td><td valign="top" width="30%"><strong>Data</strong> +</td><td valign="top" width="50%">Displays the data in the table. This is the only part of the database browser that let you modify any data. For more information about how to use the content editor +<!-- @pxref{Content editor} --> +. +<br></td></tr><tr align="left"><td valign="top" width="20%"></td><td valign="top" width="30%"><strong>Information</strong> +</td><td valign="top" width="50%">Contains information about the table available in the SGA including analyzed statistics etc. +<br></td></tr><tr align="left"><td valign="top" width="20%"></td><td valign="top" width="30%"><strong>Script</strong> +</td><td valign="top" width="50%">This tab displays an SQL script to recreate the database object. + +<p><br></td></tr><tr align="left"><td valign="top" width="20%"><strong>Views</strong> +</td><td valign="top" width="30%"> +</td><td valign="top" width="50%"> +<br></td></tr><tr align="left"><td valign="top" width="20%"></td><td valign="top" width="30%"><strong>Columns</strong> +</td><td valign="top" width="50%">A description of the columns in the view. For more information about this information also see object description. +<br></td></tr><tr align="left"><td valign="top" width="20%"></td><td valign="top" width="30%"><strong>SQL</strong> +</td><td valign="top" width="50%">The SQL that defines the view. +<br></td></tr><tr align="left"><td valign="top" width="20%"></td><td valign="top" width="30%"><strong>Data</strong> +</td><td valign="top" width="50%">Displays the data in the view. This is the only part of the database browser that let you modify any data. For more information about how to use the content editor ( +<!-- @pxref{Content editor} --> +). You can not modify some views depending on how they are defined. See the Oracle reference for more information about editing views.<br></td></tr><tr align="left"><td valign="top" width="20%"></td><td valign="top" width="30%"><strong>Grants</strong> +</td><td valign="top" width="50%">The grants that have been made on this view. +<br></td></tr><tr align="left"><td valign="top" width="20%"></td><td valign="top" width="30%"><strong>Dependencies</strong> +</td><td valign="top" width="50%">The objects that depend on this view. +<br></td></tr><tr align="left"><td valign="top" width="20%"></td><td valign="top" width="30%"><strong>Script</strong> +</td><td valign="top" width="50%">This tab displays an SQL script to recreate the database object. + +<p><br></td></tr><tr align="left"><td valign="top" width="20%"><strong>Indexes</strong> +</td><td valign="top" width="30%"> +</td><td valign="top" width="50%"> +<br></td></tr><tr align="left"><td valign="top" width="20%"></td><td valign="top" width="30%"><strong>Columns</strong> +</td><td valign="top" width="50%">The columns that the index operate on. +<br></td></tr><tr align="left"><td valign="top" width="20%"></td><td valign="top" width="30%"><strong>Info</strong> +</td><td valign="top" width="50%">Information in the SGA about an index. For instance analyzed statistics available for this index. +<br></td></tr><tr align="left"><td valign="top" width="20%"></td><td valign="top" width="30%"><strong>Script</strong> +</td><td valign="top" width="50%">This tab displays an SQL script to recreate the database object. +<br></td></tr><tr align="left"><td valign="top" width="20%"></td><td valign="top" width="30%"><strong>Script</strong> +</td><td valign="top" width="50%">This tab displays an SQL script to recreate the database object. + +<p><br></td></tr><tr align="left"><td valign="top" width="20%"><strong>Sequences</strong> +</td><td valign="top" width="30%"> +</td><td valign="top" width="50%"> +<br></td></tr><tr align="left"><td valign="top" width="20%"></td><td valign="top" width... [truncated message content] |