ORA-25330 is encountered when running DBMS_PREDICTIVE_ANALYTICS.PREDICT

I recently discovered that under certain circumstances, for now it looks to be environment setting depended, that an ORA-25330 is encountered when running dbms_predictive_analytics.predict procedure. I found out of this problem while preparing a demo and certainly the error was comming up in TOAD (I am not a TOAD fan, but it is handy searching through the very big amount of factor columns in a GAPP analysis). When the same command below was executed directly on the server via sqlplus, the error was not encountered.

To investigate I tried to create a errorstack on the error, but without luck. So I started to do a sqltrace and found out that the ORA-25330 is actually on the server translated as ORA-40206. After I found that I created the following small test in TOAD: Continue reading

GAPP presentation at HOTSOS 2009

Yesterday I had the opportunity to present the presentation “Gapp in practice”, here at the HOTSOS event 2009. To get the presentation ready I worked the whole weekend in the plane and in the hotel. My biggest challenge was to get the demo for the presentation working. The demo would show how easy GAPP can be used in practice. My goal was very well in my opinion, and I was ready to present it in time…
Than at the moment of truth, my laptop was not willing to display via the beamer and I had to present on another laptop… I apologized towards the audience and almost ten minutes late I started my presentation, with some applause from the audience. Anyway my audience was good and after some minutes of strugle (a little mixed up due to the laptop chalenge), my presentation started to run…
To get people in for my presentation I used some words on my badge…

GAPP Performance Method at HOTSOS 2009

For some months ago (october 2008) I wrote an abstract for a paper to present at the HOTSOS 2009 symposium. Although I hoped I was selected to give the presentation, I was not selected by Hotsos. This was a pitty but looking at the people and the presentations who made it to the agenda of the HOTSOS 2009 symposium, it would have been very special to be there also. Due to the high quality of the sysmposium and the fact that it is the place to be for every performance geek out there, I planned together with my collegae Marco Gralike a trip to the symposium this year only as an attendee.

Last week I received unexpectedly an email from Cary Millsap with a very special opportunity within. Cary asked me if I was still interested in presenting at the comming symposium and although very little time I said of course YES. So although late I was added to the HOTSOS 2009 symposium agenda to give a presentation called “Practical Use of Method Gapp to Find Performance Bottlenecks for Business Processes in Complex Architectures”

I hope personal that I will give a presentation wich will be equally or even more interresting than the one I gave at the HOTSOS Symposium 2008. As a last word I really like to thank Cary Millsap for this opportunity.

Regards, Gerwin