Flushing the shared pool has an impact on systems forcing at least the re parsing of sql statements and new ( perhaps even changed ) execution plans. Use with caution on any production environment and test/test before deploying anything like this.
The usual approach for a system suffering from shared pool fragmentation and/or 4031 is to identify sql not using bind variables and consider implementing ( after logon session based database trigger best ) (more...)
Well the obvious answers are "it depends" and "how far away is the actual presentation"? For Hotsos 2014 I had the vast majority of the work done in early December 2013 ... not bad for a presentation not delivered until March 3 2014.
That was after a couple of series of revisions and after all this was based on a presentation originally done at Oracle Open World 2011.
It makes even an experienced and grumpy (more...)
Well I don't really mind endorsements for skills that are in my current toolset. It is a nice compliment to get endorsements from people that you know well or have work with or are working with.
On the other hand endorsements for things that you have never worked on in your life seem a little strange. I now have several endorsements for Oracle HR ... never ever in my life touched that not even (more...)
These days at least for me seeing an ORA 600 is a relative rare ( thank god ) occurrence. They always raise your blood pressure sometimes to unhealthy levels. Looking at one that at first glance hints at possible block corruption ... not good.
This bug 8895202 was fixed already in current environment but not "enabled" ( so thanks so much ... what use is a bug that is fixed but not enabled to be (more...)
We have two topics being presented and as usual great free food beginning at noon. This should be a good mix of topics Java related for developers/dbas and Oracle database internals stuff for dbas/developers.
First up on the agenda is Scott Seighman a Principal Sales Consultant from Oracle Corporation. Scott will be talking about Java 8 which is just around the corner from being released.
Specifically his presentation is: Java.Next: An Overview (more...)