Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

SQL Health-Check (SQLHC) 3-minutes video: “…a small tool for big problems!”

with 16 comments

A new short video about the SQL Health-Check (SQLHC) script is now available to the entire Oracle community. My special thanks to Robert Story and Steve Dixon for making this possible. See video at MOS Doc ID 1455583.1.

Written by Carlos Sierra

May 4, 2012 at 3:04 pm

Posted in SQL Healh-Check (SQLHC)

Tagged with ,

16 Responses

Subscribe to comments with RSS.

  1. Hi Carlos.

    Thanks for making it available to public. I think the hyperlink is still visible to only Oracle employees.

    but you may want to use below for hyperlink so we can go to a live link when we click



    May 4, 2012 at 3:30 pm

  2. It worked except I ran into ora-600 [rwoirw: check ret val] with count distinct and order by. I am on
    Workaround: set “_optimizer_distinct_agg_transform”= FALSE;

    Question: Can I run sqlhc.sql in a production database?


    May 8, 2012 at 10:31 am

    • That ORA-600 is strange, and I would like to think specific to your system. If I see it again I will use your workaround in the script itself. Thanks for the feedback. A: Yes you can use sqlhc.sql in a production database.

      Carlos Sierra

      May 8, 2012 at 4:29 pm

  3. Also, the script prompts for question:

    Oracle Pack license (Tuning or Diagnostics) [Y|N] (required)

    If I have diagnostic pack license but not Tuning pack license, then should say “Y” or “N” to the above question?


    May 9, 2012 at 11:19 am

  4. […] SQL Health-Check (SQLHC) 3-minutes video: “…a small tool for big problems!” #Oracle […]

    • Hi Carlos,
      Thanks for publishing this script.
      But the video does not work anymore, I tried with Firefox and Internet Explorer and I cannot see the video.

      Nicolas Jardot

      August 22, 2012 at 3:26 am

      • Nicolas,
        Please try to get it from MOS 1455583.1
        Cheers — Carlos

        Carlos Sierra

        August 22, 2012 at 7:08 am

      • Carlos,
        I tried from the MOS note and I tried several browser without success. The Flash Player loads nothing. Maybe it’s related to the MOS migration from Flash to HTML5 and some Flash components used by the player are not here anymore.

        Nicolas Jardot

        August 22, 2012 at 12:08 pm

      • I am checking with the author of the video. I will keep you posted.

        Carlos Sierra

        August 22, 2012 at 2:15 pm

      • I checked with author of video. After updating Adobe Flash player it worked!

        Carlos Sierra

        August 22, 2012 at 3:22 pm

      • Just to inform that the video is now working. I had to force Flash Update from Adobe website and now it’s working.

        Nicolas Jardot

        September 5, 2012 at 3:57 am

      • Thanks

        Carlos Sierra

        September 5, 2012 at 9:30 am

  5. Thanks Carlos for you sharing.
    From MOS (Doc ID 1366133.1) title sqlhc seems ok also for > 10.1.2.*
    From Document 1366133.1 SQL Tuning Health-Check Script (SQLHC) seems instead that is necessary > 10.2.*.
    Can someone clear this ?
    Thanks again



    February 20, 2014 at 6:15 am

Leave a Reply

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

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

Facebook photo

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

Connecting to %s

%d bloggers like this: