1 / 31

Orange 기본화면

Orange 기본화면. 메뉴. 메인 툴바. 윈도우 리스트. 보조 툴바. 세션 정보. 툴 윈도우. 스키마 브라우저. 메인 상태 줄. 툴 상태 줄. 세션 관리. 8-Database Information. 9-Network Configuration Tool. 7-Description Tool. 10-File Editor. 6-Schema Tool. 11-SQL Monitor. 5-Table Editor. 12-Session Monitor. 4-Trace Tool.

chen
Download Presentation

Orange 기본화면

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Orange 기본화면 메뉴 메인 툴바 윈도우 리스트 보조 툴바 세션 정보 툴 윈도우 스키마 브라우저 메인 상태 줄 툴 상태 줄

  2. 세션 관리 8-Database Information 9-Network Configuration Tool 7-Description Tool 10-File Editor 6-Schema Tool 11-SQL Monitor 5-Table Editor 12-Session Monitor 4-Trace Tool 13-Transaction Monitor 3-Plan Tool 14-Lock/Latch Monitor 2-PL/SQL Tool 15-Instance Monitor 1-SQL Tool 16-Oracle ERP Monitor 17,18-Export, Import Connect or Disconnect 19-Loader 20-Space Manager Connected Session List or Change Session 21-Security Manager 22-Analyze Manager 23-Graph & Report Current Session 24-Health Check 25-Schema Browser Sub 기능 : Edit, Action, Option, Right Mouse로 Tool

  3. Network Configuration Tool 1-Network Configuration Tool icon 9-Save Net Configuration 2-Register New Name Client “tnsnames.ora” File 3-TNS Name : “MYTNS” 4-SID : “ORANGE” 8-Database Connection Test 7-TNS Ping Test 6-Ping Test Protocol : “TCP” 5-HOST : “192.168.6.106” PORT : “1521” Ping Test 결과 TNS Ping Test 결과 Database Connection Test 결과

  4. Database Information Database Information icon Change Session

  5. SQL 실행(SQL Tool) sample.SQD open 실행결과 STDxx로 login 실행방법 Schema Browser

  6. Description Tool

  7. SQL 편집(SQL Tool-<Alt+C>)

  8. SQL 편집(SQL Tool-Query Builder) Return Validate

  9. SQL 편집 및 실행(SQL Tool-기타) Template Window Query Builder.SQD HINT

  10. File Editor SQL Tool의 Copy to Clipboard -> Copy as Java Code의 SQL 문을 Paste한 상태

  11. PL/SQL Tool 2, 5. Check Out 4. Compile/Run 8, 10~12. Step별 실행 Template Window 7. Debug Mode Compile 3. Modify 1. Debugging 선택 6. Insert Breakpoint 9. Watch & Back Trace 등록

  12. SQL Monitor

  13. SQL Monitor (Criteria 설정기준) 1. 자원소모가 많고 수행빈도가 높은 SQL 추출 2. Full Table Scan을 수행하는 SQL 추출 3. LiteralSQL 추출

  14. SQL Monitor (튜닝대상 SQL 찾기)

  15. Plan Tool (튜닝 전)

  16. Analyze Manager

  17. Plan Tool (튜닝 후)

  18. Session Monitor (Trace)

  19. Trace Tool

  20. Session Monitor (Kill)

  21. Lock/Latch Monitor

  22. Transaction Monitor

  23. Export / Import

  24. Unload / Loader

  25. ERP Monitor

  26. Graph & Report

  27. Health Check

  28. Instance Monitor

  29. Space Manager

  30. Security Manager

  31. Table Editor

More Related