115
We’d like to hear your suggestions for improving our indexes. Send email to
Index
A
active sessions, changing, 29
Alter dialog, changing objects
with, 90
Alter Resource Plan button, 104
ALTER SESSION privilege and
Current Schema
toolbar, 15
Alter this object type button, 55
Alter User function, 102
ambulance icon, 45
Associations options page
(Project Manager), 111
Audit Objects screen, 101, 106
Audit SQL/SYS Privs
screen, 101, 105
audit trail, viewing, 106, 107
AutoCommit after each
statement, 8
AutoTrace feature, 46
B
Benchmark Factory for Oracle
tool, 114
Best Practices/Advice tool, 50
bind variables, using in SQL
Editor, 26
Breakpoints tab (Debugger), 74
Browser Style function, 58
C
Call Stack tab (Debugger), 75
cancelling running
statements, 26
“Change Active Session for this
Window” button, 29
Change Session function, 15
Clear All Data Grid Filters
function, 58
closing blocks, finding, 69
closing Toad, confirming
before, 8
code completion templates in
Toad, 32, 67
code formatting in Toad, 33
Code Profiling tool, 78
Code Snippets menu item, 28
Code-Editing panel (Procedure
Editor), 62
CodeXpert utility, 78–82, 113
toolbar buttons for, 81
columns
anchoring on left side of data
grids, 37
116
|
Index
columns (continued)
displaying for schemas, 28
displaying for tables/views, 32
rearranging, in data grids, 34
comments, adding to/removing
from code, 33
COMMIT, prompting for, 8
committing automatically or
manually, 8
Compare Data wizard, 42
Compare Databases function, 98
Compare Schemas function, 97
comparing user accounts, 102
Compile button (Procedure
Editor), 69
Configure button (Standard
Toad toolbar), 7
Configure Grantees
function, 104
configuring
data grid options, 35
Procedure Editor, 61
Schema Browser, 51–54
Toad, 6
Connections.ini file, 9
Create menu, 10
added functionality from DBA
Module, 83
objects, creating, 90
Create object type button, 55
Create Public Synonym button
(Objects Panel), 55
Create Script button (Objects
Panel), 56
Create User function, 102
“croak” .wav file, 7
CRUD Matrix tab
(CodeXpert), 80
Current Schema toolbar (SQL
Editor), 15
customizing
Project Manager, 110
shortcut keys, 18
Toad templates, 67
D
.dat files, 112
data grids in Toad, 33–44
accessing Single Record
View, 39
editing data from, 37–39
navigating, 36
Popup Editor, 38
saving/sending data in various
formats, 39
Data options
for data grids, 35
for Schema Browser, 52–54
Data Pump sessions,
managing, 94
database administration, 82–100
Database Browser, 85
Database Health Check, 85
Database menu, 11
Database Monitor, 85
databases, comparing, 98
DataFactory tool, 114
datatypes, editing, 38
DB Object project nodes, 109
DB Schema project nodes, 109
DBA menu, 11
added functionality from DBA
Module, 83
tablespace statistics,
displaying, 92
DBA Module, 83–85, 114
modifying Oracle
parameters, 87
DBMS Output tab
(Debugger), 75
DBMS_OUTPUT package
in Debugger, 75
in Procedure Editor, 68
DBMS_PROFILER package, 78
DBMS_RESOURCE_
MANAGER package, 104
DDL options page (Project
Manager), 111
Index
|
117
DDL statements, 23
Quest ScriptRunner and, 25
Debug menu, 11, 71
Debugger, 70–82
cleaning up symbol table, 78
menus and toolbar for, 71
options for, 70
Output panel, 73–75
running stored programs
from, 77
setting parameters, 76
Debugger toolbar (Procedure
Editor), 63
default settings for windows,
tuning, 7
Describe facility (Toad), 31
Details panel (Schema
Browser), 51, 57–58
documentation resources for
Toad, 4
Drop selected object type
button, 55
E
EDIT command (Toad), 30
Edit menu
SQL Editor, 16
Toad Menu toolbar, 10
Edit toolbar (SQL Editor), 14
editing data from data
grid, 37–39
Editing panel (SQL Editor), 13
Errors panel (Procedure
Editor), 62, 69
Execute Without Debugging
function, 77
executing statements in
Toad, 23–26
EXPLAIN PLAN
command, 44–46
Export Data function, 96
Export File Browser, 95
Export Table Scripts
function, 96
Export/Import Utility
Wizards, 94
exporting data from data
grids, 39
extents, checking, 94
external tools, configuring, 7
F
Favorites tab in Schema
Browser, 57
File menu, 10
Filecompare.ini file, 9
files, working with in SQL
Editor, 22
Filter object type button, 55
Find Closing Block function, 69
flat files, creating, 97
“Flush the SGA” button, 48, 99
folders, grouping objects
into, 57
Formatter toolbar (Procedure
Editor), 63
formatting code, 33
Formatting toolbar (SQL
Editor), 14
fragmentation information by
tablespace, displaying, 93
free space for tablespaces,
displaying, 92
FTP File project nodes, 109
full-screen display of SQL Editor,
toggling, 13
functionality of Toad,
expanding, 6
G
grantees, configuring, 104
Grants function, 96
Grid menu, 10
118
|
Index
H
help files and other resources, 4
Help menu, 12
Hilker, Steve, 3
HTML Schema Doc Generator
tool, 100
HTML, supporting, 21
Huddleston, Bryan, 3
I
Icon Legend function, 58
Import Table Data wizard, 43
import/export tools, 94
IN and IN/OUT parameters,
setting, 76
Index Expert tool, 50
INIT.ora parameters, 86
installing Toad, 6
internal fragmentation, 93
Item History function, 58
J
Java, supporting, 21
Just-in-Time Debugging, 76
K
keys, shortcut (see shortcut keys)
Kill Sessions function, 49
Kill/Trace screen, replaced by
Session Browser, 89
Knowledge Xpert for Oracle
Administration, 84
M
Main toolbar (SQL Editor), 14
“Make a Non-SQL Code
Statement” button, 30
Master Detail Browser
window, 42
Menu Shortcuts option, 12
Menu toolbar (Toad), 10–12
menus for SQL Editor, 13–18
Metrics Report tab
(CodeXpert), 81
Multi Select option, 40
N
navigating
data grids in Toad, 36
Procedure Editor, using
keyboard, 62
Navigation panel (Procedure
Editor), 61
NOPARALLEL hint in data
grids, 54
O
Object Palette menu item, 28
Objects panel (Schema
Browser), 51, 54–57
objects, creating and altering, 90
“OCI Array Buffer size number
box” option, 36
“Open a new DBMS Output
window” button, 68
opening files in SQL Editor, 22
optimizing SQL, 44–50
Options button (Project
Manager), 110
ORA-00942, Table does not
exist, 15
Oracle Parameters, 86
Oracle Probe Profiler API, 78
Output panel (Procedure
Editor), 62, 73–75
output statements, creating, 67
P
parameters
modifying for Oracle, 86
setting, 76
Index
|
119
parsing
SELECT statements, 25
text from HTML/Java, 21
PLSQL.dci file, 32
policies/policy groups,
managing, 105
populating the Procedure
Editor, 64
Popup Editor in data grid, 38
“Post edit” button, 38
Print Grid feature, 41
Procedure Edit toolbar, 63
Procedure Editor, 59–69
configuring, 61
customizing Toad
templates, 67
debugging with, 70–82
navigating, using keyboard, 62
populating, 64
shortcut keys for, 66
Profiler Analysis window, 78
PROFLOAD.sql script, 78
project files
creating, 109–110
saving/sharing, 111
Project Manager (PM), 107–112
project nodes, types of, 109
properties files for Toad, 9
Q
QDesigner Physical Architect
tool, 114
query statements, 23
Quest ScriptRunner (QSR)
utility, 25
Quest SQL Optimizer for
Oracle, 50
R
RAC (Real Application Clusters)
instances, 86
Oracle Parameters screen, 87
Session Browser and, 49, 89
SGA Trace Optimization
and, 99
Top Session Finder and, 88
recalling saved statements, 27
Record Count function, 41
REF CURSOR Results tab
(Debugger), 75
Refresh ALL Lists function, 58
Refresh Details Panel
function, 58
Refresh Objects Panel
function, 58
“Refresh the List of Statements”
button, 48
resource groups/resource plans,
managing, 104
resources for learning Toad, 4
result sets
scrolling down through, 36
scrolling left to right
through, 37
Results panel (SQL Editor), 13
Results Tree tab
(CodeXpert), 79
Right Mouse menu
data grids
configuring options for, 35
displaying record
counts, 41
Procedure Editor, 64
compiling programs, 69
creating output
statements, 67
finding closing blocks, 69
projects, creating/
using, 110–112
Schema Browser, 56
SQL Editor, 18
disabling/enabling
AutoTrace, 46
formatting code, 33
roles in Oracle, managing, 104
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.