I am sorry that I left this blog unattended for so long. So many things happened in my personal life that had to take precedence. Still I am not out of the...
I am sorry that I left this blog unattended for so long. So many things happened in my personal life that had to take precedence. Still I am not out of the woods but this year I will start to do some postings. I am sorry that I left this blog unattended for so long. So many things happened in my personal life that had to take precedence. Still I am not out of the woods but this year I will start to do some postings. I am sorry that I left this blog unattended for so long....
I am sorry that I left this blog unattended for so long. So many things happened in my personal life that had to take precedence. Still I am not out of the woods but this year I will start to do some...
More parses in 12.1 ? Some customers upgrading from 11.2.0.3 to 12.1 might get alarmed because they see a spike in total number of parse count. But not to...
More parses in 12.1 ? Some customers upgrading from 11.2.0.3 to 12.1 might get alarmed because they see a spike in total number of parse count. But not to worry, it is not a problem in 12.1. The problem is in 11.2.0.3. Lets take the following example : select a.name, b.value from v$statname a, v$mystat b where a.statistic# = b.statistic# and ( a.name like '%parse count%' or a.name like 'session cursor cache%') and value>0; begin for n in...
More parses in 12.1 ? Some customers upgrading from 11.2.0.3 to 12.1 might get alarmed because they see a spike in total number of parse count. But not to worry, it is not a problem in 12.1....
During the 2013 Great Lakes Oracle Conference (GLOC), Craig Shallahamer presented "Cursors, Child Cursors, and More Child Cursors" and motivate me to make this...
During the 2013 Great Lakes Oracle Conference (GLOC), Craig Shallahamer presented "Cursors, Child Cursors, and More Child Cursors" and motivate me to make this posting. In the past, I have participated in many situations where I had to debug the mechanisms that generate large number of child cursors and learned that ,more often than not ,a cursor is not shared for many reasons and those may change from version to version so I wrote a tool to help debug it. I see pertinent...
During the 2013 Great Lakes Oracle Conference (GLOC), Craig Shallahamer presented "Cursors, Child Cursors, and More Child Cursors" and motivate me to make this posting. In the past, I have...
Since the first release of JDBC and event longer ago with Pro* Precompilers to this day I still see the following issue : Please notice below in this abstract...
Since the first release of JDBC and event longer ago with Pro* Precompilers to this day I still see the following issue : Please notice below in this abstract of a 30 min AWR the number of Parse Calls vs Executions, the SQL Module and in the case of the first SQL, the SQL Text too. Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text 339,567 339,566 15.93 0mr7azgm9psws JDBC Thin Client SELECT COUNT(*) FROM DUAL 101,574 101,880 4.77 5uta56d6syjv3 JDBC Thin Client...
Since the first release of JDBC and event longer ago with Pro* Precompilers to this day I still see the following issue : Please notice below in this abstract of a 30 min AWR the number of Parse Calls...