메뉴 건너뛰기

Korea Oracle User Group

새소식

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

명품관 2016.04.25 11:46 조회 수 : 1665 추천: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.

번호 제목 글쓴이 날짜 조회 수 추천 수
187 MariaDB 10.4.2 Beta Release 명품관 2019.02.01 352580 0
186 Announcing the general availability of Oracle Linux 7.2 명품관 2015.11.30 186725 0
185 MOS Note:136697.1 - New HCHECK.SQL for Oracle Database 12c 명품관 2016.06.01 119020 0
184 MOATS: The Mother of All Tuning Scripts! (by TANEL PODER) 명품관 2016.04.28 83334 0
183 오라클 18c Express Edition(XE) 윈도우 버전 사용 가능 명품관 2019.02.22 64239 0
182 Oracle Database 19c 다운로드 가능 명품관 2019.04.30 59526 0
181 Oracle Magazine Junary/February 2019 명품관 2019.03.12 39904 0
180 Watch featured OTN Virtual Technology Summit Replay Sessions - Nov 30, 2015 명품관 2015.12.01 28154 0
179 Time-out and Thanks by Tom Kyte (Tom Kyte 의 휴식) 명품관 2016.01.08 20396 0
178 MySQL Database Service (in Oracle Cloud Infrastructure) file 명품관 2021.02.04 16541 0
177 오라클 릴리즈 로드맵 [2] file 명품관 2019.05.15 7145 1
176 New! Announcing MySQL Enterprise Transparent Data Encryption 명품관 2016.04.23 6005 0
175 Oracle Cloud Infrastructure and Red Hat Enterprise Linux 명품관 2023.02.01 5603 0
174 오라클 19c에서 desupport 되는 기능들 명품관 2019.02.19 5112 0
173 Oracle Database 19c 매뉴얼 문서 오픈 명품관 2019.02.15 4386 0
172 오라클 클라우드 피닉스, 서울 리전이 마이크로소프트 Azure와 연결 리전으로 추가 명품관 2022.01.28 4342 0
171 오라클 데이터베이스 19c 버전이 리눅스 8.x Update 1+에서 인증 명품관 2020.05.14 4282 0
170 Oracle Database Migration Assistant for Unicode(DMU) 명품관 2016.05.31 4002 0
169 Oracle Database 19c requires OL7, RHEL7 or SLES12 or newer 명품관 2019.02.15 3737 0
168 Oracle Database certification on Microsoft Windows 10 명품관 2016.01.08 3071 0
위로