(Marco Gilbert) The following query will allow you to see the CPU attribution of the first level plan and the CPU attribution of the subplans used by this plan. (The query assumes that your first level plan is named “PLAN…” and your subplan is named “SPLAN…”.)

(Alex Osuna, Eva Ho, Eric Barrett, Bikash R. Choudhury, Bruce Clarke, Ed Hsu, Blaine McFadden and Tushar Patel) This IBM Redbooks publication describes best practice guidelines for running Oracle databases on IBM System Storage N series products with system platforms such as Solaris, HP/UX, AIX, L

(Tarry Singh) Network cards are getting faster, internet connections are increasingly becoming faster. There are even talks of 1Gbps internet and faster coming available. Oracle RAC can benefit from such developments, but did you know that you could stretch your RAC geographically (well almost) if y

(Wilfred van der Deijl) Oracle Forms has been web enabled since 1999. It is perfectly possible to run Oracle Forms in a web browser and in its Statement of Direction, Oracle has indicated to support Form to, at least, 2013. On the other hand there is a rapid growth and adoption of Java/J2EE technolo

Oracle has released the latest ATG rollup RUP5 (official name is 11i.ATG_PF.H.delta.5). From a security perspective, RUP5 is important in three regards – –The ATG rollups contain a number of security enhancements –RUP5 incorporates ATG CPU patches from January 2005 to January 2007 –Starti

(Tim Dexter) The majority of reports I see are laid out as what is termed ‘group above’, the break groups appear above the detail data thus.

(Patrick Wolf) Oracle APEX 3.0 contains a nice new feature you should be aware of. There is a new substitution variable APEX_DML_LOCK_WAIT_TIME which you can use to define how the behavior of the “Automatic Row Processing (DML)” and ApplyMRU/D processes should be in case if the processed row is lock

(Lawrence Linnemeyer and Bradley Brown) In this conclusion to a three-part series covering the addition of validations, computations, and processes to an HTML DB application, you will learn about data manipulation, manually creating a web services process, and more.

(Eddie Awad) I almost forgot that the Oracle Joins series is not complete yet. So here is the last episode, a quick and easy anti-join and semi-join refresher.

(Marc Billette) I chose to talk about a technique I used at a client’s site to report the topmost space-wasting objects in an Oracle database. I was looking for a way to detect these objects without having to run some expensive analyze statements or dbms_stats jobs. I found out that I can use the db