메뉴 건너뛰기

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 Announcing SQL Server on Linux [5] 명품관 2016.03.09 2882 1
» eDB360 - Carlos Sierra's Tools(SQLTXPLAIN 개발자) 명품관 2016.04.25 1665 1
185 오라클 릴리즈 로드맵 [2] file 명품관 2019.05.15 7145 1
184 VirtualBox 5.0.10 released! November 10th, 2015 ecrossoug 2015.11.13 949 0
183 Oracle Announces Beta Availability of Oracle Database 12c Release 2 명품관 2015.12.07 919 0
182 2023년 5월 오라클 Help Center Learn의 튜토리얼과 labs 명품관 2023.06.13 230 0
181 The Modern Command Line (SQL, PL/SQL) 명품관 2015.11.24 619 0
180 How to Test OCFS2 in a Virtual Environment 명품관 2015.11.24 1893 0
179 How to Configure x86 Memory Performance for Large Databases Using Linux HugePages 명품관 2015.11.24 1431 0
178 How to Set Up DTrace to Detect PHP Scripting Problems on Oracle Linux 명품관 2015.11.24 1641 0
177 Advanced Usage of the AWR Warehouse 명품관 2015.11.24 989 0
176 Multitenant Database Management 명품관 2015.11.24 560 0
175 Oracle VirtualBox 5.0.14 released! 명품관 2016.01.21 408 0
174 Announcing the general availability of Oracle Linux 7.2 명품관 2015.11.30 186730 0
173 Watch featured OTN Virtual Technology Summit Replay Sessions - Nov 30, 2015 명품관 2015.12.01 28167 0
172 Free webinar - Advanced Oracle Database Administration in Action with Uwe Hesse 명품관 2016.01.06 435 0
171 Oracle PL/SQL to Excel xlsx API ORA_EXCEL 명품관 2016.01.07 1426 0
170 Time-out and Thanks by Tom Kyte (Tom Kyte 의 휴식) 명품관 2016.01.08 20396 0
169 Oracle Database certification on Microsoft Windows 10 명품관 2016.01.08 3071 0
168 Announcing the general availability of Unbreakable Enterprise Kernel Release 4 명품관 2016.01.11 666 0
위로