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

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 Health-Check, SQLHC

16 Responses

Subscribe to comments with RSS.

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

1455583.1

coskan

May 4, 2012 at 3:30 pm

Reply
- Thanks Coskan. I just made the correction. The link should work well now.
  
  Carlos Sierra
  
  May 5, 2012 at 9:31 am
  
  Reply
It worked except I ran into ora-600 [rwoirw: check ret val] with count distinct and order by. I am on 11.2.0.3.
Workaround: set “_optimizer_distinct_agg_transform”= FALSE;

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

DBA

May 8, 2012 at 10:31 am

Reply
- 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
  
  Reply
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?

DBA

May 9, 2012 at 11:19 am

Reply
- Enter “Y” in that case. SQLHC does not access STA data.
  
  Carlos Sierra
  
  May 9, 2012 at 11:34 am
  
  Reply
[…] SQL Health-Check (SQLHC) 3-minutes video: “…a small tool for big problems!” #Oracle […]

11 Interesting Things You May Have Missed This Week » Eddie Awad's Blog

May 20, 2012 at 10:03 am

Reply
- 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
  
  Reply
  - 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.
    Regards,
    Nicolas
    
    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.
    Regards,
    Nicolas
    
    Nicolas Jardot
    
    September 5, 2012 at 3:57 am
  - Thanks
    
    Carlos Sierra
    
    September 5, 2012 at 9:30 am
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

Paolo

PaoloF

February 20, 2014 at 6:15 am

Reply
- SQLHC works on 10.2 and higher
  
  Carlos Sierra
  
  February 20, 2014 at 8:13 am
  
  Reply