Category Archives: APEX SIG

Increasing Scalability with Oracle Application Express

Yesterday, at the UKOUG APEX SIG (which I’ll post a follow-up about shortly), I did a quick 1 hour presentation on Increasing Scalability with Oracle Application Express, I touched on (and demonstrated) quite a few different techniques in which you can make you APEX applications more scalable (and/or just as importantly, reducing the overhead of your APEX applications).

Today, I received an email from someone who attended that presentation. I have asked their permission to post their message –

“I just thought I would let you know of the performance improvements I have got since your presentation yesterday”

and what were those improvements?

“The updateable grid has always been slow to run and was taking 1min 2seconds ( I couldn’t think how to improve it without completely redesigning it), with the changes this has been reduced to 6 seconds.”

and the difference in the production system –

[table id=2 /]

That’s quite an improvement from the users perspective, something which used to take over 30 seconds is now well under a second.

From my perspective, it’s great to know that some people were inspired to use what they learned to make some significant changes which will ultimately make their end users happier (and we’re all end users of one system or another right?).

At the UKOUG conference in a few weeks time, I’m actually going to be presenting a 2 hour Masterclass on the same topic (which allows me to go into more depth, more demos and more aspects than an hour allows).


Just a quick note to mention that on Wednesday I’ll be at the (2nd!) APEX SIG meeting at the Oracle City Office in London, it looks like it’s going to be a packed day (already sold out sorry!) full of APEX sessions. I’m very happy that something ‘official’ is now being held in the UK for APEX and that so many people are involved and supporting it.

Secondly, time flies…UKOUG is right around the corner now (30th November – 2nd December). There are lots of great APEX sessions planned –

[table id=1 /]

If you didn’t spot it, I’m doing 2 sessions, Dispelling Myths about Application Express and also a 2 hour masterclass on Building Scalable Applications with Oracle Application Express (which I believe should be interesting to *anyone* developing with APEX, not just those people who are developing large scale applications).

We are also going to hold an APEX round-table on Tuesday (1st December) at 12:55-13:55, where you can come along and ask any (APEX related!) questions you have.

It’s interesting to see that Oracle are taking this event seriously too, with David Peake, Anthony Rayner and Hilary Farrell from the APEX Development team all attending (and presenting).

Now, I just need to book my hotel!

UK Application Express SIG – Followup

On friday (12th February), the first UK Application Express Special Interest Group meeting was held. I previously blogged about the planned content, theme etc here.

I’m very pleased to say that the event exceeded many peoples expectations in terms of attendance, with around 55 or so people (and I believe around 20 people on the ‘waiting list’, it’s a shame we couldn’t have got a bigger room!). It was also a very nice surprise to see that Jonathan Lewis was sitting in on the event.

There were some interesting presentations on the day, David Peake gave us some sneak insights into APEX 4.0 and the roadmap ahead.


Dimitri then gave us a presentation on Advanced Charting in APEX.

Matt Nolan & Vincent Migue then told us how they were using APEX internally inside their company (with some nice AJAX and Web 2.0 functionality).


Then finally it was my turn to Dispel Myths about APEX (sorry no pictures of myself this time).

Finally we had a panel session where the floor was open for any question (I must apologise to my fellow presenters if I took too much share of answering the questions, but there’s always that split second timing where you try to gauge if anyone else is going to answer and if not you just dive in).

My gut feeling is that the day was a good success, there were lots of interesting questions outside of the presentations (during breaks/lunch etc) and I find that this is usually one of the highlights of events like this since many people are not comfortable asking questions in a big group but in a 1-2-1 situation you get the chance to ask anythign you like

After the event many of us went to nearby bar (my wife even joined us later) and whiled away the hours discussing all things APEX and non-APEX.

I do want to stress one thing though, if you attended the SIG meeting, please *please* make sure you give your feedback to the UKOUG, since without this feedback they will be unable to gauge the response to the event and determine any future plans for it.

I really do hope another event is arranged soon, as I see APEX growing in popularity and usage every day, so there is definitely a need for events like this. Special thanks to Justin Hudd for finally pulling this all together!

UK APEX SIG – Coming VERY soon


The “need” for a UKOUG Application Express SIG (Special Interest Group) has been discussed a lot, Jonathan Lewis blogged about it a year ago and received a lot of interest. Sara Blair also floated (or resurfaced at least) the idea again last year, again receiving a lot of positive feedback. I have also been very interested in the idea and have said as much to most UK “APEX people” that I’ve spoken to.

However up till now it’s just never happened, fortunately Justin Hudd has progressed it past the idea stage and actually co-ordinated pulling everything together to actually make it happen!

So on the 13th February in the Oracle office in London will be the first UKOUG APEX SIG meeting!

The agenda is available on the UKOUG site here, however to give you an outline, we have –

  • David Peake (Oracle) – Latest & Greatest from Development
  • Anthony Rayner (Oracle) – Learn How Oracle Utilises Application Express
  • Dimitri Gielis (AE) – What happens on an APEX Page?
  • Matt Nolan & Vincent Migue (e-DBA) – Using APEX to Expose your Business to the Web
  • John Scott (me!) – Dispelling Myths about Application Express
  • APEX Forum – A chance to ask the Experts
  • A.O.B. and Close

The event is planned to run from 9am to 5pm, however given how enthusiastic most of us are about Application Express I’m sure we’ll be around a bit later too to ask any questions etc.

A note on the pricing:

  • If you are already a member of UKOUG then it’s free to attend.
  • If you are not a member then there is a £160 plus VAT charge.