Transcript orange 실습교육

Orange 기본화면
메뉴
윈도우 리스트
메인 툴바
보조 툴바
세션 정보
툴 윈도우
스키마
브라우저
메인 상태 줄
툴 상태 줄
세션 관리
8-Database Information
7-Description Tool
6-Schema Tool
5-Table Editor
4-Trace Tool
3-Plan Tool
2-PL/SQL Tool
1-SQL Tool
9-Network Configuration Tool
10-File Editor
11-SQL Monitor
12-Session Monitor
13-Transaction Monitor
14-Lock/Latch Monitor
15-Instance Monitor
16-Oracle ERP Monitor
17,18-Export, Import
19-Loader
20-Space Manager
21-Security Manager
22-Analyze Manager
23-Graph & Report
Current Session
24-Health Check
25-Schema Browser
Sub 기능 : Edit, Action, Option, Right Mouse로 Tool
Connect or
Disconnect
Connected Session List
or Change Session
Network Configuration Tool
1-Network Configuration Tool icon
9-Save Net Configuration
2-Register New Name
Client “tnsnames.ora” File
3-TNS Name : “MYTNS”
8-Database Connection Test
4-SID : “ORANGE”
7-TNS Ping Test
6-Ping Test
Ping Test 결과
Protocol : “TCP”
5-HOST : “192.168.6.106”
PORT : “1521”
TNS Ping Test 결과
Database Connection Test 결과
Database Information
Change Session
Database Information icon
SQL 실행(SQL Tool)
STDxx로 login
sample.SQD open
실행방법
Schema Browser
실행결과
Description Tool
SQL 편집(SQL Tool-<Alt+C>)
SQL 편집(SQL Tool-Query Builder)
Return
Validate
SQL 편집 및 실행(SQL Tool-기타)
Query Builder.SQD
Template Window
HINT
File Editor
SQL Tool의 Copy to Clipboard -> Copy as Java Code의
SQL 문을 Paste한 상태
PL/SQL Tool
4. Compile/Run
2, 5. Check Out
8, 10~12. Step별 실행
Template Window
7. Debug Mode Compile
3. Modify
1. Debugging 선택
6. Insert Breakpoint
9. Watch & Back Trace 등록
SQL Monitor
SQL Monitor (Criteria 설정기준)
1. 자원소모가 많고 수행빈도가 높은 SQL 추출
2. Full Table Scan을 수행하는 SQL 추출
3. Literal SQL 추출
SQL Monitor (튜닝대상 SQL 찾기)
Plan Tool (튜닝 전)
Analyze Manager
Plan Tool (튜닝 후)
Session Monitor (Trace)
Trace Tool
Session Monitor (Kill)
Lock/Latch Monitor
Transaction Monitor
Export / Import
Unload / Loader
ERP Monitor
Graph & Report
Health Check
Instance Monitor
Space Manager
Security Manager
Table Editor