Oracle SQL Tuning Tools and Tips

SQL Tuning, eAdam, eDB360, SQLT, SQLHC

Enkitec’s free AWR data mining tool (eAdam) is now available!

with 2 comments

As of today, you can download this free tool out of our Enkitec‘s web page. Just select “eAdam” under the Products Tab.

The next version of eAdam will  incorporate the GV$views, equivalent to the currently extracted  DBA_HIST set.  The reason of this enhancement is to handle read-only databases (DataGuard – DG). So views like GV$ACTIVE_SESSION_HISTORY will be available for data mining within the eAdam staging repository.

Any ways, I hope you enjoy this new  tool. Feel free to provide constructive feedback on this blog, or by sending  an email to carlos.sierra@enkitec.com.

Written by Carlos Sierra

March 6, 2014 at 3:40 pm

Posted in eAdam

2 Responses

Subscribe to comments with RSS.

  1. Hi Carlos,

    I just downloaded eAdam and am looking forward to using it. I noticed that that you specify using SYS to run the extract script eadam_01_xtr.sql . How essentail is it to use SYS? Is there a subset of privileges that would work adequately?

    Thanks,

    Richard Brieck

    rbrieck

    March 6, 2014 at 4:43 pm

    • Richard,
      You can use SYS or DBA or any other user that can read from the Data Dictionary

      Carlos Sierra

      March 6, 2014 at 5:32 pm


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

Follow

Get every new post delivered to your Inbox.

Join 1,423 other followers

%d bloggers like this: