This is the "really really" final version because it was updated and some additional references added even after the presentation was delivered.
Hoping to do it at Open World 2014 so ... I guess this is the early version of that presentation eh?
You can find it here: Three approaches to shared pool monitoring Hotsos 2014
I polled my session attendee's at Hotsos 2014 ( Three approaches to shared pool monitoring ) and asked them who was using automatic stuff versus who was doing it all manually?
My guess is that there were about 100 people in the room and it looked like automatic "won" but not by much. Maybe 55 percent automatic and 45 manual ... so there are still a whole bunch of people nervous about using that functionality. (more...)
It was a little dicey sunday morning with weather in Ohio but I caught very early flight and made it down to Dallas well before noon. Lots of turbulence in the airplane ride and bounced around some but all in all not bad. Lots of people traveling ran into hitches one way or another but by the end of the day Monday most everyone seems to be here now.
Even better I had (more...)
Our official notifications should be out by mid week ( next Wednesday ) and we appreciate all of the people submitting abstracts. Thank everyone of you very much from all of us involved in the conference.
Wow this is going to be another outstanding conference. Darn going to have to not accept a large number of quality presentations also. We do not have the time or room to run all the sessions (more...)
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...)
Last year I arrived in Dallas on sunday and it was warm. Running on monday it was in the hot range like 80+ degrees. I was out there in shorts and tank top and there are these local runners with full set of equipment jackets and everything. Wow I guess I was dying in the heat and these people still think it is cold?
Getting pretty excited about presenting again but time (more...)
Jeff Smith aka @thatJeffSmith presented two topics at our January 24th 2014 meeting. A well attended and smooth delivery even in the face of some not so nice weather. Cleveland in January and February well it's always somewhat unpredictable.
Here is the meeting setup information:
Jeff Smith is a Senior Principal Product Manager in the Database Tools group at Oracle. He works on the team that brings you SQL Developer, SQL Developer Data (more...)
As usual Tanel Poder has done an excellent job of writing up this approach.
Caveats I have tested this in 184.108.40.206.x and 220.127.116.11.x might have some issues earlier not quite sure but hey Tanel probably has this documented also.
This came in really handy recently looking at some SQL chewing up large amounts of LIO.
Here is Tanels writeup: bind variable sql monitor
leading over to here
Just saw this posted ... hmm road trip time from Cleveland on Saturday Feb 15? Only possibly dicey thing is driving/traveling on Saturday in mid February in the Midwest you can never predict what that is going to be like. But hey 4 wheel drive in the Honda CRV so ... time to check schedule and see who else might want to attend.
See this link for the Ann Arbor event World Information Architecture Day 2014 (more...)
Most people have seen this already but just in case oracle jan 2014 patch notification
From what I have seen there are huge differences company by company site by site how patching and testing of patching occurs. That's a whole different blog entry though right?
Jeff Smith aka @thatJeffSmith
Jeff Smith is a Senior Principal Product Manager in the Database Tools group at Oracle. He works on the team that brings you SQL Developer, SQL Developer Data Modeler, APEX Listener, the Public Cloud database offering, and 11gR2 XE. Jeff has presented online and in-person at many of the top user groups around the world for the past decade including ODTUG, IOUG, RMOUG, NEOUG, Suncoast Oracle User Group, and more.Two (more...)
The Great Lakes Oracle Conference is May 12-14 2014 in Cleveland at CSU. Beautiful campus environment and state of the art student center main ballroom. Plus well of course the chance to speak at the city where the river caught on fire right ( long story ask me over a beer ).
We have 1/2 day workshops on Monday
( Alex Gorbachev / ( Carlos Sierra and Mauro Pagano ) / Scott Spendolini (more...)
This year at the Great Lakes Oracle Conference ( May 12-14 2014 at CSU ) we are doing 1/2 day workshops monday afternoon. Then the conference kicks into full speed with keynotes tuesday morning and session tracks after that.
We have an incredible set of people doing workshops for our attendees. We are working on finalizing a fourth workshop in the Essbase area but not quite ready to announce that on.
We are (more...)
Believe it or not many DBAs/Developers are unaware of ( well or have forgotten ) how to "switch into" a different schema.
PLSQL has had the option for a long time
alter session set current_schema = SOME_SCHEMA_NAME;
This does not give you full schema owner capabilities ( well depends on what your login session capabilities have ) but can be very useful. For instance in some kind of script to validate that all the expected (more...)
Here is an interesting post from Thomas Saviors blog aka ( My Oracle Life ). It shows some complicated things going on flushing the database buffer cache from various CON_IDs within a CDB.12c buffer cache flushing
Obviously only the people doing design work at Oracle for 12c ( 12. (more...)
So I guess my amazing number of 77 twitter followers of @grumpyOldDba ( thanks to all you geeks by the way ) may not be quite as earth shattering as I was thinking.
Received some kind of strange tweet / offer to sell me followers?
Wow ... I could go from (more...)