(Dbaharrison) Today i was doing a small proof of a concept with a materialized view – i don’t use these that often as use cases don’t come up too much. In this particular case i was doing a test of what is/isn’t possible when having a fast refresh-able mview on a table join.

(Scott Wesley) One of the simplest tuning techniques to encapsulate PL/SQL used in APEX within packages, minimising the size of anonymous blocks. This applies to any PL/SQL within the page, including computations, processes, plugins, dynamic actions, validations, shortcuts and dynamic PL/SQL regions

(connormcdonald) Subtle variances in the way you work with statistics can have a significant impact on how your optimizer plans work out…so you need to take care.

(Kellyn Pot’Vin-Gorman) How much do you know about the big push to BI Publisher reports from Information Publisher reporting in Enterprise Manager 13c? Be honest now, Pete Sharman is watching…. 🙂

(Martien van den Akker) JMS is perfect for setting transaction boundaries and in OSB it is pretty clear on how JMS transactions are handled. However, in SOASuite using the JMS adapter the SOA Infrastructure is handling your JMS transactions by default; and messages are removed from the queue rightaw

(Dominic Brooks) For most of our database set-ups we use a different TEMP space for application users than for end-user/support/developer/reporting usage.

(connormcdonald) For “normal” indexes, USER_IND_COLUMNS will contain the column name(s) for an index, but things (appear to) go astray when looking at function-based indexes.

(Andrejus Baranovskis) To execute Groovy expression in ADF 12c (to call Java method from Groovy), you must specify trusted mode. Read more about it in my previous post – ADF BC 12c New Feature – Entity-Level Triggers. Setting mode to trusted, works in most of the cases.

(connormcdonald) Most people are aware of this standard referential integrity control, namely you can’t delete the parent if children exist

(Andrew Reid) A developer reported a problem with a %TYPE declaration which was returning PLS-00302 in an Oracle 10 database. The cause turned out to be a variation on a problem which I have already reported.