Better Logic for Better Solutions
Feed aggregator
12.2 Introduction to Real-Time Materialized Views (The View)
Although I usually focus on index related topics, I’ve always kinda considered Materialized Views (MVs) as an index like structure, which Oracle can automatically update and from which Oracle can efficiently retrieve data. The cost of maintaining a Materialized View Log is not unlike the cost of maintaining an index structure, the benefits of which […]
12.2 Index Deferred Invalidation (Atomica)
One of the useful little features quietly introduced with Oracle Database 12c Release 2 is the ability to now defer the invalidation of dependent SQL cursors when an index is created or modified. This can be useful when you say create a new index which you know will have no impact on any existing SQL […]
12.2 Some Cool Partitioning New Features (Big Wheels)
I previously discussed just how easy it is to convert online a non-partitioned table to be partitioned with Oracle Database 12.2. Thought I might run through a number of really cool new partitioning features and capabilities that were also introduced in 12.2. To start, I’m just going to create a basic range-partitioning table and populate […]
Big Announcement – New Job, New Country (A New Career In A New Town)
APRIL FOOLS After 5 1/2 years at Oracle Corporation, I’ve decided to leave and take on a very exciting new challenge !! President Trump’s office have accepted my nomination to head their IT department in Washington DC, where I’ll be responsible for ensuring all USA government data is stored in a extremely efficient and secure manner. So […]
Take a few minutes to patch Oracle APEX 5.1
Yesterday a first patch set of Oracle Application Express (APEX) 5.1 has been made available to download.
one-of patches
If you encounter issues, you can ask for support and most likely a bit later a patch is made available through support.oracle.com. The APEX team is doing a great job with this.
For example some people using APEX Office Print had an issue which was caused by a bug in APEX_JSON (which we heavily use behind the scenes). The next day the APEX Dev Team already made a patch available (PSE 25650850).
patch set
Instead of applying those one-off patches, you can wait for a patch set which includes those one-off patches and more. If you didn't move to Oracle APEX 5.1 yet, you can just download the latest version which includes 5.1.1 immediately.
There're many fixes for the Interactive Grid features, but next to that, many others as well, like for example login issues.
applying the patch set
If you're on Oracle APEX 5.1, search for patch 25341386. Unzip the file, stop the webserver, run @apxpatch, copy the images folder and start the webserver again.About 2 minutes later you're on the latest version.
Happy patching...
one-of patches
If you encounter issues, you can ask for support and most likely a bit later a patch is made available through support.oracle.com. The APEX team is doing a great job with this.
For example some people using APEX Office Print had an issue which was caused by a bug in APEX_JSON (which we heavily use behind the scenes). The next day the APEX Dev Team already made a patch available (PSE 25650850).
patch set
Instead of applying those one-off patches, you can wait for a patch set which includes those one-off patches and more. If you didn't move to Oracle APEX 5.1 yet, you can just download the latest version which includes 5.1.1 immediately.
There're many fixes for the Interactive Grid features, but next to that, many others as well, like for example login issues.
applying the patch set
If you're on Oracle APEX 5.1, search for patch 25341386. Unzip the file, stop the webserver, run @apxpatch, copy the images folder and start the webserver again.About 2 minutes later you're on the latest version.
Happy patching...
