A new version of SQLT has been published. Version 12.1.12. (see 215187.1 )The new thing included are several matrices to display the three reasons of SQL Plan...
A new version of SQLT has been published. Version 12.1.12. (see 215187.1 )The new thing included are several matrices to display the three reasons of SQL Plan Directives :Table Cardinality Misestimate DirectivesGroup By Cardinality Misestimate DirectivesJoin Cardinality Misestimate DirectivesAnd segregates them by the two statesUsableSuperseded The "Single Table" ones are displayed in the "Columns" Section, and the "Group by" and "Join" Directives are displayed on their own...
A new version of SQLT has been published. Version 12.1.12. (see 215187.1 )The new thing included are several matrices to display the three reasons of SQL Plan Directives :Table Cardinality Misestimate...
Recently I have seen a raising trend of issues about chained rows so this post is to show a not so obvious side effect. I see no reason to explain what a...
Recently I have seen a raising trend of issues about chained rows so this post is to show a not so obvious side effect. I see no reason to explain what a chained row is and examples of them as in the internet there are very good postings that talk about them like http://www.akadia.com/services/ora_chained_rows.html Migrated Rows is just a special case of chained rows. I am going to use a similar testcase as the article to show my point. Similar table, just bigger columns as...
Recently I have seen a raising trend of issues about chained rows so this post is to show a not so obvious side effect. I see no reason to explain what a chained row is and examples of them as in the...
I presented at the 2013 Great Lakes Oracle Conference (GLOC). "The Sins of SQL Programming that Send the DB to Post-Upgrade Performance Purgatory" On tuesday 14...
I presented at the 2013 Great Lakes Oracle Conference (GLOC). "The Sins of SQL Programming that Send the DB to Post-Upgrade Performance Purgatory" On tuesday 14 Starting at 3pm In Room MC 201 It is a fun presentation with a halloween theme.
I presented at the 2013 Great Lakes Oracle Conference (GLOC). "The Sins of SQL Programming that Send the DB to Post-Upgrade Performance Purgatory" On tuesday 14 Starting at 3pm In Room MC 201 It is a...
There are multiple blogs posts, presentations and documentation about "think time" and "service time" and some tools that would translate that for you but if...
There are multiple blogs posts, presentations and documentation about "think time" and "service time" and some tools that would translate that for you but if you do not have those tools available or you need to understand a pattern of behavior from the client app, how can you identify "think time" in a SQL trace ? This case is of a customer which reported a performance problem from its JDBC connections running reports that are constantly timing out and needed to identify...
There are multiple blogs posts, presentations and documentation about "think time" and "service time" and some tools that would translate that for you but if you do not have those tools available or...