应用开发解决方案
2
目 录
1. 方案简介 ..................................................................................................................................4
2. TOAD™ FOR ORACLE........................................................................................................5
2.1. S
CHEMA BROSWER............................................................................................................6
2.2. SQL
EDITOR ......................................................................................................................6
2.3. P
ROCEDURE EDITOR..........................................................................................................7
2.4. SQL
MODELER ..................................................................................................................8
2.5. F
ASTREPORT......................................................................................................................9
2.6. S
CRIPT MANAGER ............................................................................................................10
2.7. M
ASTER/DETAIL BROWSER.............................................................................................10
2.8. C
ONNECTION COLOR-CODING.........................................................................................11
3. TOAD™ FOR ORACLE PROFESSIONAL......................................................................11
3.1. PL/SQL
DEBUGGER.........................................................................................................12
3.2. C
ODE PROFILING .............................................................................................................12
3.3. K
NOWLEDGE XPERT™ FOR PL/SQL...............................................................................13
3.4. T
EAM CODING .................................................................................................................14
3.5. C
ODE XPERT....................................................................................................................14
4. TOAD™ FOR ORACLE XPERT .......................................................................................15
4.1. SQL
SCANNER.................................................................................................................15
4.2. SQL
INSPECTOR...............................................................................................................15
4.3. SQL
OPTIMIZER...............................................................................................................16
4.4. I
NDEX EXPERT.................................................................................................................19
4.5. C
ROSS INDEX ANALYSIS..................................................................................................19
4.6. O
UTLINE MANAGER ........................................................................................................20
4.7. P
LAN CHANGE ANALYZER...............................................................................................20
4.8. B
EST PRACTICES..............................................................................................................22
5. TOAD™ FOR ORACLE SUITE.........................................................................................22
5.1. DBA
MODULE .................................................................................................................22
5.1.1. Database Monitor ...................................................................................................22
5.1.2. Database Probe.......................................................................................................23
5.1.3. Health Check...........................................................................................................24
5.1.4. Instance Manager....................................................................................................24
5.1.5. Top Session Finder..................................................................................................25
5.1.6. Oracle Parameters..................................................................................................26
5.1.7. Session Browser ......................................................................................................26
5.2. K
NOWLEDGE XPERT™ FOR ORACLE ADMINISTRATION ..................................................27
5.3. D
ATA FACTORY™ DEVELOPER EDITION ..........................................................................27
5.4. B
ENCHMARK FACTORY™ FOR DATA BA SE S .....................................................................27