I just completed my second presentation here at Oracle Open World. It discusses Application Development inside and with the Database, introducing and discussing quite a few trends, concepts, best practices and new or rediscovered database features. It was nice presentation to prepare and to present: fun stuff, useful too and a very receptive audience. I promised the audience to make the presentation and the demo scripts available on the weblog within the hour, so here it is. I would like to thank everyone who attended the presentation – I really appreciated the interest shown and the feedback given afterwards.
Download the presentation:Modern10g11gDatabaseDevelopment_OOW2008.pdf.pdf
Download the demoscripts: oow2008_demoscripts.zip.
Hi Tim, you are welcome. What I should have said is (from the 11g docu): “Module and action names for a registered application can be retrieved by querying V$SQLAREA or by calling the READ_MODULE procedure [on dbms_application_info]. Client information can be retrieved by querying the V$SESSION view” .
Lucas, thank you for sharing presentation.
There’s a note on p.18 about client_identifier in v$sqlarea. Are you sure it is really there?