Blogs about: Execution Plan
Featured Blog
generate dumps – overview
Some nice – important dump options and still under constuction find sga ID in Unix environments with mutiple instances running within the same os-use (e.g. oracle) you cannot see which memory se… more →
mygraeff.com
What's the most efficient way to filter on specific dates?
wrote 2 weeks ago: One of the most satisfying parts of being a SQL Consultant is being able to work with a customer to … more →
Understanding SQL Server Logical Query Processing
wrote 2 weeks ago: When troubleshooting or performance tuning your T-SQL query it’s always wise to remember the o … more →
Hotsos Symposium 2013 continued
wrote 1 month ago: During my presentation at Hotsos 2013, an attendee questioned my statement that each filter/selectio … more →
How I forced a hard parse for a select statement .
wrote 1 month ago: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 I have created a table TEST1 for the follo … more →
Hotsos Symposium 2013
— 1 comment
wrote 2 months ago: It was a great pleasure presenting at Hotsos. Thank you for attending my presentation – your c … more →
How to view xml plan as graphical execution plan
wrote 3 months ago: Do you want to look XML execution plan as graphical execution plan? It is simple save the xml plan w … more →
Do not filter for dedicated access in (oracle) sparql
— 1 comment
wrote 3 months ago: It took me a resort to good old autotrace lately when attempting to optimize a sparql query in oracl … more →
sql_sql_id.sql 1.7
wrote 4 months ago: Here is thing with SQL tuning: at a certain point you encounter an inefficient SQL statement. You lo … more →
Get Parameter value from running stored procedure or Query
wrote 4 months ago: Most of the time early dba get confused when an application team asks by what parameter values the s … more →
Retrieve Execution Plan
wrote 4 months ago: From AWR: select plan_table_output from table (dbms_xplan.display_awr('&sqlid')); … more →
Query Execution Plan (Basic)
wrote 5 months ago: What is an execution plan? Every day, out in the various discussion boards devoted to Microsoft SQL … more →
Daily automation: Execution plan for UI Automation?
wrote 6 months ago: Have you tried to debug GUI or UI Automation scripts? It’s possible, of course, however this a … more →
How to set Execution plan for my sql
— 1 comment
wrote 6 months ago: Most of us face with similar issue on our sql which are running on our databases. Sometimes some sql … more →
Client / Server Processes and Query Processing - The Mechanics
wrote 9 months ago: SQL Server is a true client / server database. This means that application logic is processed both … more →
Optimising SQL Server for ad hoc workloads
— 1 comment
wrote 9 months ago: In this post I will be demonstrating with hands-on examples how to optimise your SQL Server for … more →
Looking into the contents of Plan Cache in SQL Server
— 3 comments
wrote 9 months ago: In this post I will be demonstrating with hands-on examples how to look into the contents of Plan Ca … more →
Stored procedure compilation and caching
— 1 comment
wrote 10 months ago: In this post I will explain when the actual caching (the stored procedure is placed in the procedure … more →
New Penn State BIM Execution Planning Docs Out
wrote 10 months ago: http://bim.psu.edu/ … more →
Is HCC always benifit for you? Exadata Hybird Column Compression
wrote 10 months ago: Exadata implement the Hybird column compression on the cell storage server level. It stores the data … more →
