Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

eDB360: 360-degree comprehensive report on an Oracle database

with 18 comments


Overview:
eDB360 is a free tool that provides a 360-degree view of an Oracle database on the Cloud or on-premises. Its output can be used as a foundation for a database health-check, a performance evaluation, or to collect resources utilization needed for a sizing and provisioning plan. Of course it can also be used to simply get a glance of an entire Oracle database.

With eDB360, a user with limited access can acquire a good understanding of an Oracle database without having to log into the server directly. This capability is of great value to developers, system administrators, 3rd party consultants, or any remote user with limited access to an Oracle database.

eDB360 tool is database centric. Notice that in case of RAC database(s), it only needs to be executed on one node and it gets information about all of them. eDB360 works on Oracle 10g to 12c databases. eDB360 works on Linus and UNIX systems. For Windows systems you may want to install first UNIX Utilities (UnxUtils) and a zip program, else a few OS commands may not properly work.

Each execution of eDB360 may take up to 24 hours, thus it is recommended executing it overnight or over a weekend. Test eDB360 on a lower environment before executing on Production. Since eDB360 execution time is a frequent concern, a blog post explains how to diagnose cases where eDB360 takes long to execute.

For other FAQ or more information about eDB360, check links below or simply Google: eDB360.

Note: To execute this eDB360 tool, the database should be licensed to use at least the Oracle Diagnostics pack (else the output is very small and of little use). If the database is licensed for both the Tuning and the Diagnostics pack, then respond with a “T” to the first execution parameter. This tool has an optional second parameter, which allows to specify a custom configuration filename. This second parameter is seldom needed, so when asked to enter such filename, simply hit the “enter” or “return” key, unless of course you want to customize an aspect of eDB360 (advanced mode).

Links:

  1. Download latest version v1713 (May 3, 2017)
  2. Sample Output
  3. Readme included in tool
  4. Blog post: eDB360 takes long to execute
  5. Frequently asked questions (FAQ)

Instructions steps:

  1. Download edb360-master.zip from link above.
  2. Copy edb360-master.zip to server where eDB360 will be executed, and unzip there.
  3. Navigate to edb360-master directory and connect into SQL*Plus (use an account that can read from the data dictionary).
  4. Execute SQL script sql/awr_ash_pre_check.sql and review output, specially last page. Then decide if continuing with eDB360 or remediate first findings reported.
  5. Execute SQL script edb360.sql. Pass value “T” as the first parameter if the database has the Tuning pack license, or “D” if it has the Diagnostics pack license (if having both licenses then pass “T”). For most cases, simply hit “enter” to skip the 2nd parameter, which is optional and it is designed to configure eDB360.
  6. Provide to requestor the compressed output file: edb360_<NNNNNN>_<NNNNNN>_YYYYMMDD_HH24MI.zip.

Written by Carlos Sierra

July 3, 2015 at 2:16 pm

18 Responses

Subscribe to comments with RSS.

  1. What is the difference between edb360 ans SQLd360?

    jimmybrock

    December 18, 2015 at 1:30 pm

  2. […] diagnose the system in your absence. If you are very fortunate, you may even get them to execute eDB360 for […]

  3. Hi Carlos,

    I think that I found something to fix in the 1e.69. Database Size on Disk report (edb360 v1616).

    Lines like:

    WHEN s.bytes > POWER(10,15) THEN ROUND(s.bytes/POWER(10,15),3)||’ P’

    But, I think that the right expression is ../POWER(2,50).

    I mean, change all the POWER expression to base 2.

    And it could be a little better.

    Greetings,

    Daniel Calderon

    September 15, 2016 at 11:33 am

    • Actually it used to be power of 2 on edb360, but for space on disk the proper measure is poser of 10…

      Carlos Sierra

      September 15, 2016 at 1:24 pm

  4. Does edb360 support to run in parallel using multiple connection to database to reduce the runtime ?

    kal

    October 9, 2016 at 8:20 am

    • Nope, and that is intentional. Most clients are concerned that eDB360 would eat up lots of resources, and it does not because it executes serial by design. Under which circumstances would you need to rush it?

      Carlos Sierra

      October 11, 2016 at 9:19 am

  5. […] Hesse explains well some important statistics on Exadata. For some time now, eDB360 includes a report on Smart Scan efficiency, which is nothing but a Google Chart on top of […]

  6. do you know if edb360 can run on oracle solaris supercluster

    benoit mandeville

    December 28, 2016 at 4:02 pm

  7. Carlos,
    I have been using sqlt and I came across this recently.. It’s amazing set of scripts!!!
    Dharmesh

    Dharmesh

    February 13, 2017 at 2:23 pm

  8. […] eDB360 has always worked under the premise “no installation required”, and still is the case today – it is part of its fundamental essence: give me a 360-degree view of my Oracle database with no installation whatsoever. With that in mind, this free tool helps sites that have gone to the cloud, as well as those with “on-premises” databases; and in both cases not installing anything certainly expedites diagnostics collections. With eDB360, you simply connect to SQL*Plus with an account that can select from the catalog, execute then a set of scripts behind eDB360 and bingo!, you get to understand what is going on with your database just by navigating the html output. With such functionality, we can remotely diagnose a database, and even elaborate on the full health-check of it. After all, that is how we successfully use it every day!, saving us hundreds of hours of metadata gathering and cross-reference analysis. […]

  9. […] a point, eAdam is similar to eDB360; both access the Data Dictionary in order to produce some reports. The key difference is that […]

  10. […] many of you know, eDB360 is a free tool that provides a 360-degree view of an Oracle database without any installation. A […]

  11. […] many of you know, eDB360 is a free tool that provides a 360-degree view of an Oracle database without any installation. A […]

  12. There is a comprehensive SQLTXPLAIN book from Apress , when do we get one on eDB360?

    ricky jon

    April 24, 2017 at 6:42 am


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: