Download
orange n.
Skip this Video
Loading SlideShow in 5 Seconds..
Orange 기본화면 PowerPoint Presentation
Download Presentation
Orange 기본화면

Orange 기본화면

182 Vues Download Presentation
Télécharger la présentation

Orange 기본화면

- - - - - - - - - - - - - - - - - - - - - - - - - - - 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