orange n.
Skip this Video
Download Presentation
Orange 기본화면

Loading in 2 Seconds...

play fullscreen
1 / 31

Orange 기본화면 - PowerPoint PPT Presentation

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

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

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

Download Now 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 기본화면


메인 툴바

윈도우 리스트

보조 툴바

세션 정보

툴 윈도우



메인 상태 줄

툴 상태 줄

세션 관리

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



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”


8-Database Connection Test

7-TNS Ping Test

6-Ping Test

Protocol : “TCP”

5-HOST : “”

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 tool1
SQL 편집 및 실행(SQL Tool-기타)

Template Window

Query Builder.SQD


file editor
File Editor

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

SQL 문을 Paste한 상태

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