SQL Tuning Health-check Script (SQLHC)

1. Pure hand-crafted

Tools: Programmer's hands

Features: Handwritten client and server-side validation code

2. Semi-manual semi-automatic

Tools: Jquery.validate (client) + dataannotations & dataannotationsextensions (server side)

Features: Client handwritten partial validation code, server side only need to declare validation rules

3. Fully Automatic

Tools: Jquery.validate & jquery.validate.unobtrusive (client) + dataannotations & dataannotationsextensions (server side)

Features: Only server-side claims validation rules, client validation code is automatically generated. Reference article: Unobtrusive JavaScript in ASP. NET MVC 3

• SQL execution is slow, how fast and accurate optimization.
  • SQLHC is one of the best tools.
  • By getting all the SQL execution plans, list the actual performance bottlenecks, listing the number of rows on the table where SQL resides, the data and distribution of each column, the existing index, the actual execution of SQL-time, IO, and the number of rows returned.

• Specific use of reference Document 1366133.1 SQL Tuning health-check Script (SQLHC)

• Simple steps:
  • Free Download from Oracle
  • Get Sqlid from AWR
  • Then run SQLHC and follow the prompts to enter Sqlid

Category: Database-oracle

SQL Tuning Health-check Script (SQLHC)