Orange
Download
1 / 31

Orange 기본화면 - PowerPoint PPT Presentation


  • 133 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Orange 기본화면' - chen


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
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

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


Network configuration tool
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 결과


Database information
Database Information

Database Information icon

Change Session


Sql sql tool
SQL 실행(SQL Tool)

sample.SQD open

실행결과

STDxx로 login

실행방법

Schema Browser



Sql sql tool alt c
SQL 편집(SQL Tool-<Alt+C>)


Sql sql tool query builder
SQL 편집(SQL Tool-Query Builder)

Return

Validate


Sql sql tool1
SQL 편집 및 실행(SQL Tool-기타)

Template Window

Query Builder.SQD

HINT


File editor
File Editor

SQL Tool의 Copy to Clipboard -> Copy as Java Code의

SQL 문을 Paste한 상태


Pl sql tool
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 등록



Sql monitor criteria
SQL Monitor (Criteria 설정기준)

1. 자원소모가 많고 수행빈도가 높은 SQL 추출

2. Full Table Scan을 수행하는 SQL 추출

3. LiteralSQL 추출


Sql monitor sql
SQL Monitor (튜닝대상 SQL 찾기)


Plan tool
Plan Tool (튜닝 전)



Plan tool1
Plan Tool (튜닝 후)
















ad