Although Oracle is smart enough it is always helpful to double check. Even in cases where you expect that Oracle aware about nulls and it will apply necessary filters itself, result can be unexpected. Below are several cases where you would get a benefit from manually added filter which could look unnecessary and redundant.

Working with APEX 5 Dialogs. APEX 5 introduces native dialogs, both modal and non-modal. How to enable dialogs in your APEX 5 application if they are not already enabled. How to open a dialog. How to close a dialog, returning values from that dialog. How to respond to the closing of a dialog. How to enable dialogs in your APEX 5 application if they are not already enabled. Enabling APEX 5 native dialogs in your application.

SQL Monitor details for later tuning. Posted by David Alejo Marcos in Exadata. Tuning has always being good fun and something like a challenge for me. From time to time we are being asked to find out why something did run slow while you are sleeping; answering this question is, in most cases, a challenge. My batch did run slow last night, can you let us know why? Or why did this query run slow? Are questions we, as DBAs, have to answer from time to time.

Doug Gault - Geek, Wino, Foodie, Traveler, Classic Car Nerd, APEX Aficionado, Author, Oracle ACE Director. A bunch of stuff about MAC, Oracle, ApEx, Wine, Food, Life, Travel, Madness, Mayhem, and whatever else I can sling in here. Monday, June 01, 2015. And I have re-launched Sumner Technologies. Hope to see you all at KSCOPE15.

Transportable Tablespace for Source and Target. Check tablespace and send email. New objects created in last week. Script to Check RMAN Backup Status in Real-Time. Check mount point status and send email. Spool Table output to CSV Excel file.

Opinions and observations about Oracle databases and the IT industry. I have recovered my site at edstevensdba. Please link over to it for latest content.

Tuesday, February 12, 2013. Click here to view this photo book larger. Tuesday, November 6, 2012. Maria Colgan will host the optional Training Day 2013. Oracle Optimizer One Day Workshop.

There is always more to learn. I have not checked if I have not taken any shortcuts through the model yet, but when that leads to improvement, I will publish them here. I have included error messages for each execution. This means rows will be duplicated when more than one error message is found for an execution. In 2010, there were 4. Where did they come from? .

Error Installing HP iLO Firmware Upgrade. Looking in Device Manager, there is a device called Base System Device. Looking at the properties of Base System Device.