Skip to main content

UKOUG 2009 recap


Last week I had the pleasure of visiting the UKOUG Technology & EBS Conference. The 3 days of presentations and social networking started already on Sunday evening with the ACE dinner - very well organized by Mark and Debra. Thai food combined with good company is proven to be an excellent combination!
Amongst all the tracks I picked the ones on APEX 4.0, Forms-to-APEX conversions and some DBA / CBO / SQL presentations.

APEX 4.0
One of the greatest (of many) interesting features of APEX 4.0 is - without any doubt - the Plug-In functionality. Anyone can define snippets of code that can be used in a declarative way in your application. By defining a Dynamic Action based on a Plug-In, you can probably do anything - only limited by your imagination! Plug-Ins are defined per application, but can be published and subscribed, like you can do with Templates. Oracle is planning to have a Plug-In repository at apex.oracle.com (or samplecode.oracle.com) containing the Plug-In code itself or a reference to it.
Other enhancements aiming at easier Ajax development are Page Level On-Demand Processes and simplified (and documented!) Ajax Javascript functions.
Some native Dynamic Actions will be native, like a GetData Plug-In: Think about a POST-QUERY trigger in Oracle Forms to retrieve and present data dependent on something you entered, like a location of a company.
More native item types will be added as well: Text with Autocomplete, Resizeable Text Areas, a new Rich Text Editor and the jQuery Datepicker.

The $60,000 question is of course: when will APEX 4.0 be available???
The APEX Development team aims at an hosted Early Adopter Release around New Years Eve. So that will be just after or even before....(all disclaimers apply). Of course the actual official release date is not revealed (they may not even know it themselves), but my bet is somewhere at the end of the first quarter of 2010.

Forms to APEX conversions
Apart from my own presentation (about Integration of Forms and APEX), there were a couple more handling this subject. Some of them handled the choice of the "best" development environment, while others brought up their experience with conversions of Forms to APEX. The most interesting was the one by the guys from Northgate who already converted 1,500 Forms to APEX and are in the middle of converting another 3,500 (!) Forms. They prove that APEX can really be an Enterprise Development Tool.

DBA / CBO / SQL presentations
As mentioned I also attended some non-APEX sessions, mostly lightweight DBA stuff. For the DBA diehards there were enough interesting ones to choose from - presented by the some of the most famous DBA gurus - , but I admit that a lot of them were probably way over my head.
The ones I attended (Tom Kyte, Jonathan Lewis, Piet de Visser) had all one thing in common: don't be afraid to overload your indexes with more than the minimal set of columns that you need to enforce data integrity and prevent unnecessary locking. You can achieve performance gain on query when you (sensible) add columns that you're using in where-clauses and order-by's. Of course maintaining these indexes (on insert and update) will increase overhead, but as long as you retrieve your data more often than you insert/update it, it might lead to an overall performance gain. You can even extend this idea to the limit, by creating an index containing all columns of your table (then you'll get an IOT - Index Organized Table). If the optimizer uses that index, your table won't even be touched as all data will be retrieved from the index.
But as always: test, test, test....

All in all it was another great conference. Thanks to all who put in the effort to come up with a presentation and all the others that made such great company!
Already looking forward to next year!

Comments

Popular posts from this blog

Refresh selected row(s) in an Interactive Grid

In my previous post I blogged about pushing changed rows from the dabatase into an Interactive Grid. The use case I'll cover right here is probably more common - and therefore more useful!

Until we had the IG, we showed the data in a report (Interactive or Classic). Changes to the data where made by popping up a form page, making changes, saving and refreshing the report upon closing the dialog. Or by clicking an icon / button / link in your report that makes some changes to the data (like changing a status) and ... refresh the report.  That all works fine, but the downsides are: The whole dataset is returned from the server to the client - again and again. And if your pagination size is large, that does lead to more and more network traffic, more interpretation by the browser and more waiting time for the end user.The "current record" might be out of focus after the refresh, especially by larger pagination sizes, as the first rows will be shown. Or (even worse) while you…

apex_application.g_f0x array processing in Oracle 12

If you created your own "updatable reports" or your custom version of tabular forms in Oracle Application Express, you'll end up with a query that looks similar to this one:
then you disable the "Escape special characters" property and the result is an updatable multirecord form.
That was easy, right? But now we need to process the changes in the Ename column when the form is submitted, but only if the checkbox is checked. All the columns are submitted as separated arrays, named apex_application.g_f0x - where the "x" is the value of the "p_idx" parameter you specified in the apex_item calls. So we have apex_application.g_f01, g_f02 and g_f03. But then you discover APEX has the oddity that the "checkbox" array only contains values for the checked rows. Thus if you just check "Jones", the length of g_f02 is 1 and it contains only the empno of Jones - while the other two arrays will contain all (14) rows. So for processing y…

Dockerize your APEX development environment

Nowadays Docker is everywhere. It is one of the main components of Continuous Integration / Continuous Development environments. That alone indicates Docker has to be seen more as a Software Delivery Platform than as a replacement of a virtual machine.

However ...

If you are running an Oracle database using Docker on your local machine to develop some APEX application, you will probably not move that container is a whole to test and production environments. Because in that case you would not only deliver a new APEX application to the production environment - which is a good thing - but also overwrite the data in production with the data from your development environment. And that won't make your users very excited.
So in this set up you will be using Docker as a replacement of a Virtual Machine and not as a Delivery Platform.
And that's exactly the way Martin is using it as he described in this recent blog post. It is an ideal way to get up and running with an Oracle database …