Orange Part I Ware Valley 1 Orange Development
- Slides: 141
Orange Part I Ware. Valley 1
Orange 기능 Development Tool Schema Browser Query Builder SQL Tool PL/SQL Tool Description Tool Table Editor Loader File Editor Tuning Tool Plan Tool Trace Tool Other Tool Database Information Data Dictionary Tool Describe DB Objects Network Configuration Export Tool Import Tool Monitoring Tool SQL Monitor Session Monitor Lock/Latch Monitor ERP Monitor Transaction Monitor DBA Tool Space Manager Security Manager Instance Monitor Graph & Report Health Check Analyze Manager Log Miner Reorg Manager 2
Tool 사이의 연동성 SQL Tool PL/SQL Tool Schema Browser Description Tool Table Editor 6
Tool 사이의 연동성 Session List Cursors Tab 7
Tool 사이의 연동성 § Session/Transaction/Lock/Latch Monitor 문제세션 검출 문제 Transaction 검출 Lock/Latch 분석 Cursors Tab 문제분석 성능개선 튜닝 8
Install 10
Install 1. Prepare 2. Wellcom 3. 사용권 계약서 4. 설치 위치 설정 11
Install 9. 온라인 업그레이드 설정 10. Configuration Admin 실행 13
Install 14
Orange Configuration Admin 15
Orange Configuration Admin 실행 16
Orange Configuration Admin 1. 초기화면 3. DBMS 정보 2. Connect to DBMS 4. 기본 테이블스페이스 선택 17
Orange Configuration Admin 5. 임시 테이블스페이스 선택 6. 설치 18
Orange Configuration Admin History 관리 19
Orange Configuration Admin : Orange 사용자 20
Online Upgrade 21
Online Upgrade - 자동 실행 - 강제 실행 Tray Icon 22
Orange 제거 23
Orange 제거 Orange 계정 제거 Drop User Orange Cascade 25
Orange 실행 26
Registration Key 입력 오렌지 실행 Registry Key 입력 27
Orange 초기화면 28
Network Configuration Tool 29
Network Configuration Tool 실행 TNS 서비명 등록 30
새로운 TNS 서비스 명 등록 1 서비스 명 변경 2 3 SID 등록 Protocol Host IP Listener Port 등록 32
테스트 Connect Test TNS Ping Test 사용자 변경 Ping Test 결과창 33
Tns. Names. ora 파일 저장 34
Global Option 설정 35
Global Options General Tab 36
Global Options Startup Tab Database Tab 37
Global Options Documentation Language Tab Health Check와 Graph & Report Tool Guide Line 언어 선택 SQL*Net Tab Orange 재 실행 시에 적용 됨 38
Global Options Upgrade Policy Tab 39
Logon/Logout 40
Logon 41
Logout 42
공용 세션/전용 세션 공용 세션 - 여러 툴들이 공용으로 사용하는 세션 - 지원 툴 : SQL Tool, PL/SQL Tool, PLAN Tool, Trace Tool, Table Editor, Schema Tool, Description Tool, Database Information, Data Dictionary Tool, Log Miner Tool 전용 세션 - 해당 툴에서만 배타적으로 사용하는 세션 - 지원 툴 : SQL Monitor, Session Monitor, Transaction Monitor, Lock/Latch Monitor, Instance Monitor, Oracle ERP Monitor, Export Tool, Import Tool, Loader, Space Manager, Security Manager, Analyze Manager, Graph & Report, Health Check 세션을 사용하지 않는 툴 - 지원 툴 : Network Configuration Tool, File Editor 44
Schema Brower 실행 46
테이블 정보 보기 – Column 정보 Table Tab Column Tab 47
Describe Tool 연동 Describe 53
Column List 연동 [ALT+C] Column List 54
SQL Tool 연동 View Data 55
Table Editor 연동 Edit Table Data 56
Analyze Table Analyze… 57
Compile Invalid Objects 58
Query Builder 59
Query Builder 실행 SQL Tool, Plan Tool PL/SQL Tool에서 실행 가능 60
완성된 문장의 Return Validate Paste SQL Cancel 63
SQL Tool 64
결과 출력 형식 Grid Output Text Output File Output 68
Column Definition(ALT+C) 동시에 여러 개 화면 오픈 가능 69
Full Description(F 4) Description Tool 70
Cached SQL(F 8) [Action] [Recall Cached SQL List…] Double Click : Insert SQL Tool Option : Database 탭 해당 SQL문 으로 대치 Cached SQL Max Count 71
Recall Named Script (CTRL+R) - Rename - 위치 재 설정 : Drag & Drop 73
SQL Formatter SQL Formatting된 모습 74
SQL Template 사용하기 Double Click Drag & Drop Toolbar 75
Bind Variable 윈도우 이용하기 지원 데이터 타입 - String - Number - Date - Char(Fixed Length) 76
SQL을 프로그래밍 언어로 변환 - Visual Basic C/C++ Power. Builder Delphi Java Perl 78
질의 결과 수정(Edit Mode) 작업 Commit Rollback Cancel Current Record Auto Accept Current Record Accept All Modified Records 80
Fixed Column 83
결과 저장 Excel Text Comma Separated File Html File XML 84
LOB 데이터 삽입 2. Commit 3. 다시 Query 실행 89
SQL Tool Options : Database 탭 Incremental Fetch 여러 SQL 실행 시에 오류 대처 공백을 새로운 SQL 문장 시 작으로 인식 94
SQL Tool Options : Editor 탭 Tab 유지 방법 - Space - Tab 95
SQL Tool Options : Server Output 탭 DBMS_OUTPUT 패키지 2000 ~ 1, 000 97
SQL Tool Options : File Save 탭 100
PL/SQL Tool 102
PL/SQL Tool 창 열기 작성 및 디버깅 - Procedure - Function - Package - Trigger 103
프로시저 생성하기 Compile/Run (F 5) Source CREATE OR REPLACE PROCEDURE scott. dbms_sql_test is cursor_name integer; ret integer; string varchar 2(100) : = 'select * from emp where empno = 1234'; begin cursor_name : = DBMS_SQL. open_cursor; dbms_sql. parse(cursor_name, string, dbms_sql. native); ret : = dbms_sql. execute(cursor_name); dbms_sql. close_cursor(cursor_name); end; 104
PL/SQL Debugger Debug Mode Compile Start Debugger 107
PL/SQL Debugging Step Over Step Into Stop Debugger Step Out Insert Break. Point Remove All Break. Points 108
PL/SQL Debugging Watch & Back Trace 109
Description Tool 110
Description Tool 실행(F 4) 111
Description Tool Find Object Type Filter 동일 이름을 갖는 객체가 여러 개 존재 할 일 경우 112
Database Information 113
Database Information 실행 114
Data Dictionary Tool 117
Data Dictionary Tool 실행 Comment 데이터 추출 Description 정보 Data Dictionary 분류 데이타 118
Data Dictionary 분류 V$ View List DBA List All Views & Search 119
Plan Tool 121
Plan Tool 실행 124
Object 상세 정보 보기 DEPT 테이블 정보 Double Click 126
SQL 실행 (CTRL+Enter) 131
Optimizer Mode 설정 - Session Level에서 설정 : Alter Session Optimizer_Mode = 모드 132
Trace Tool 134
Trace Tool 실행 135
Local Trace 파일 보기 136
Remote Trace 파일 보기 137
- Pro ware
- Odessy ware
- Ware significato informatico
- Gcu antelope scholarship
- Layout dispense bar diagram
- Open unix 8
- Verbote
- Ware java
- Kevin ware injury
- Roger ware
- Rena ware prices
- Ware fc
- Control group
- 오렌지 edit mode
- 3 ware
- Lower rio grande valley development council
- Asia silicon valley development agency
- Part whole model subtraction
- Unit ratio definition
- Part part whole
- Technical description meaning
- The part of a shadow surrounding the darkest part
- Two way anova minitab 17
- Define community development.
- Development that ended much development crossword
- Sheet metal pattern development
- Yarra valley council
- Aaec paradise valley
- Types of winds
- Ohio valley educational cooperative
- Boyer valley schools
- Waipio valley history
- Ohio valley territory
- High valley hatchery
- Tove valley broadband
- Deep valley on the ocean floor
- Growing up in the indus valley
- Indus river valley climate
- Appalachian ridge and valley new jersey
- Five regions of georgia
- Importance of valley forge
- Cancer scn
- Extensionometer
- West valley flight club
- Valley ridge academy
- Real restaurants
- Irvine valley memories
- "meltwater" -glacier -jobs -resume
- Roof valley construction
- Is sludoy a chordophone
- Patuxent valley middle school
- Cascade valley hospital
- Queen anne's war
- Ohio river valley 1763
- Fvsu student account suite
- Moreno valley water
- Moraine valley community college transcripts
- Arti nama zeanne
- Medway valley heritage forest
- Indus valley civilization medicine
- Education in indus valley civilization
- Las gallinas valley sanitary district
- Nubian desert location
- Is a u shaped valley constructive or destructive
- Lagan valley regional park
- Janapriya nile valley madinaguda
- Map of river valley civilizations
- Delaware valley honda dealers
- Growing up in the indus valley
- Indus river valley hinduism
- The aryan caste system
- Indus river valley art
- Indus civilization economy
- Indian valley high school lewistown pa
- Indus valley road
- Silicon valley dubai apartments
- Honeywell aerospace deer valley
- Indus valley civilization trade and economy
- Genesee valley boces lpn
- Hayes valley south
- Grace valley indian school al ain
- U shaped valley in canada
- V shaped valley
- Fox valley lab
- Vshaped valley
- Although i walk through the valley
- What type of erosion forms a v shaped valley
- Aaec paradise valley
- Packoutz treasure valley
- 4 river valley civilizations
- The uncanny valley
- Dearne valley activity centre
- Sac valley medshare
- Lithium valley commission meeting
- Great rift valley definition
- Wood's beekeeping supply & academy
- Aa meetings in leon valley
- Leon valley zoning map
- Concord green valley fault
- Castle valley mill
- Catawba valley ymca
- Bajada death valley
- Valley of lemuel
- 4 river valley civilizations
- Harappa
- Electronic manufacturing services
- Great african rift valley
- Great rift valley facts
- A deep valley with high steep sides
- 4 river valley civilizations
- River valley civilizations definition
- Valley free routing
- Evergreen valley college summer classes
- Crescenta valley high school summer school
- Weathering erosion
- Waipio valley camping
- Valley metro ride choice
- V shaped valley formed by
- The new deal
- Piedmont region pa
- The indus valley civilization flourished around
- Character analysis tom buchanan
- Valley of ashes great gatsby
- Tennessee valley authority
- William howard russell charge of the light brigade
- Landforms of africa
- Hidden valley middle school bell schedule
- Paano umiiral ang kabihasnan at sibilisasyon?
- Siletz valley school
- Seneca valley grading scale
- Scvhhs
- San joaquin county electric vehicle rebate
- Seasonal winds that dominate india's climate
- Mountain valley
- Hotels near paradise valley community college
- Evoluzione a cespuglio scuola primaria
- New deal political cartoon
- Rcc in moreno valley
- Trailsend com
- Metea valley 8 to 18
- 3 minor terrain features
- Indus era