메뉴 건너뛰기

Korea Oracle User Group

새소식

eDB360 - Carlos Sierra's Tools(SQLTXPLAIN 개발자)

명품관 2016.04.25 11:46 조회 수 : 1667 추천:1

출처 : https://carlos-sierra.net/2014/07/27/edb360/

 

Enkitec’s Oracle Database 360-degree View

eDB360_206_135_cs

 

EDB360 is a free tool that executes on an Oracle database and produces a compressed file which includes a large set of small Reports. This set of Reports provides a 360-degree view of an Oracle Database. EDB360 is mostly used for one of the following 3 reasons, listed here in order of frequency of use: 1) Keystone of an Oracle database Health-Check. 2) Kick-off for an Oracle database Performance Evaluation. 3) High-level view of System Resources demand and utilization for an Oracle database Sizing and Provisioning project.

Usually, Developers, Sys Admins and Consultants are not given open access to a database in a Production environment. This eDB360 free tool helps approved users to become familiar with an Oracle database in a non-intrusive way. Without installing anything on the database, the eDB360 tool connects to an Oracle database and produces a large set of flat files that can be reviewed offline while using an HTML browser or a Text editor.

EDB360 can be executed by someone with very limited access to an Oracle database (i.e. a Developer, Sys Admin or Consultant with just query access to the Data Dictionary views); or if executed by an authorized DBA, there is no actual need to provide any additional access to the Oracle database to the party requesting eDB360.

EDB360 works on 10gR2, 11gR2, and on higher releases of Oracle; and it can be used on Linux or UNIX Platforms. It has not been tested on Windows. An eDB360 sample output is available at this Dropbox location; after downloading the sample output, look for the 0001_edb360_dbname_index.html file and start browsing.

 

Instructions

Download the eDB360 tool and review the readme.txt file included. Uncompress the eDB360 master ZIP file on the Database Server of interest. Navigate to the main eDB360 (master) directory and execute script edb360.sqlconnected as SYS or any other account with access to the Data Dictionary views (a DBA account is not required but it is preferred).

Execution time for eDB360 may exceed 1 hour, depending on the size of the Data Dictionary. And the size of the output may reach 1 GB, so be sure you execute this tool from a file system directory with at least 1 GB or free space. Common sizes of the output range between 10 and 100 MB.

EDB360 has only one execution parameter:

  1. Oracle Pack License: A big portion of the information presented by eDB360 comes from Oracle’s Automatic Workload Repository (AWR), and AWR is licensed by Oracle under the Diagnostics Pack. A small part of the output of eDB360 comes from the SQL Monitoring repository, which is part of the Oracle Tuning Pack. This parameter accepts one of 3 values: “T”, “D” or “N”. If you database is licensed under the Oracle Tuning Pack, enter then the value of “T”. If your database is not licensed to use the Oracle Tuning Pack but it is licensed to use the Oracle Diagnostics Pack, enter “D” then. If your site is not licensed on any of these two Oracle Packs, enter “N” then. Be aware that a value of “N” reduces substantially the content and value of the output. Thus the preferred parameter value is “T” (Oracle Tuning Pack).

Sample

1

2

3

4

# unzip edb360-master.zip

# cd edb360-master

# sqlplus / as sysdba

SQL> @edb360.sql T

 

Download

EDB360 @ GitHub is available as free software. You can see its readme.txtlicense.txt or any other piece of the tool before downloading it. Use this link edb360-master.zip to actually download eDB360 as a compressed file.

 

Feedback

Please post your feedback about this eDB360 tool at this blog, or send and email directly to the tool author: Carlos Sierra.

번호 제목 글쓴이 날짜 조회 수 추천 수
47 Oracle Database 12c Release 2 Linux x86-64 Released [2] 명품관 2017.03.02 1131 0
46 Oracle Database 12.2 Release 스케줄 정보 [1] 명품관 2017.02.01 555 0
45 MOS Note:136697.1 - New HCHECK.SQL for Oracle Database 12c 명품관 2016.06.01 119023 0
44 DMU - Tips and Tricks - Migration Assistant for Unicode 명품관 2016.05.31 2256 0
43 Oracle Database Migration Assistant for Unicode(DMU) 명품관 2016.05.31 4005 0
42 오라클 Webcast 일정입니다. 참고해서 등록하세요~ file 명품관 2016.05.20 2452 0
41 OTN Virtual Technology Summit Replay Libraries 명품관 2016.05.11 1189 0
40 MS, SQL서버2016 다음달 1일 출시 [1] 명품관 2016.05.04 1280 0
39 Windows Subsystem for Linux Overview 명품관 2016.05.04 672 0
38 MOATS: The Mother of All Tuning Scripts! (by TANEL PODER) 명품관 2016.04.28 83336 0
37 SQL Dashboard – V2 명품관 2016.04.27 834 0
» eDB360 - Carlos Sierra's Tools(SQLTXPLAIN 개발자) 명품관 2016.04.25 1667 1
35 New! Announcing MySQL Enterprise Transparent Data Encryption 명품관 2016.04.23 6006 0
34 Complete list of new features in MySQL 5.7 명품관 2016.04.22 1550 0
33 Oracle Berkeley Database (BDB) 6.2 Announced 명품관 2016.04.21 2181 0
32 RACSIG에서 구글 이벤트를 통해 Load-Balancing a RAC Database 타이틀로 webinar 진행합니다. 명품관 2016.04.20 1973 0
31 VirtualBox 5.0.18 (released 2016-04-18) 명품관 2016.04.20 1411 0
30 2016년 Oracle Open World 소식 file 명품관 2016.04.15 456 0
29 올해 차세대시스템 발주 봇물…금융IT 시장 승자는 누구? 명품관 2016.04.08 361 0
28 "파격은 없었다”…카카오뱅크, 기간계 DBMS로 오라클 결정 명품관 2016.04.07 540 0
위로