Feed aggregator

12.2 Index Deferred Invalidation (Atomica)

Richard Foote's Blog - Tue, 05/30/2017 - 01:14
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)

Richard Foote's Blog - Wed, 04/05/2017 - 08:21
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)

Richard Foote's Blog - Fri, 03/31/2017 - 13:45
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

Dimitri Gielis Blog - Wed, 03/29/2017 - 13:00
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...

12.2 Online Conversion of a Non-Partitioned Table to a Partitioned Table (A Small Plot Of Land)

Richard Foote's Blog - Sun, 03/26/2017 - 23:46
In my previous post, I discussed how you can now move heap tables online with Oracle Database 12.2 and how this can be very beneficial in helping to address issues with the Clustering Factor of key indexes. A problem with this technique is that is requires the entire table to be effectively reorganised when most of […]

Let’s Talk Database: New Dates Released (You Can’t Talk)

Richard Foote's Blog - Thu, 03/16/2017 - 05:53
Good news for all you Oracle Database folk in ANZ. I’ll be running a new series of “Let’s Talk Database” sessions at a venue near you in the coming months. I’ll be discussing two interesting topics, “Introduction to the Oracle Cloud for DBAs” and “Introduction to Oracle Database 12c Release 2“. The dates for this series and registration […]

12.2 Moving Tables Online (Real Cool World)

Richard Foote's Blog - Wed, 03/15/2017 - 06:41
One of the really cool new features introduced in Oracle Database 12c Release 2 is the capability to MOVE tables ONLINE, while maintaining all the associated index structures. This was possible for table partitions in Oracle Database 12c Release 1 but only for Indexed Organized Tables before then. Rather than show a demo that just moves a table, […]

12.2 Index Advanced Compression “High” Part IV (The Width of a Circle)

Richard Foote's Blog - Fri, 03/10/2017 - 05:18
A quick post (for me) with a long weekend beckoning… In Part I, Part II and Part III of looking at the new Index Advanced Compression level of “High”, we discussed how it can significantly decrease the size of your indexes in a manner not previously possible. This can result in significant reductions of index storage and […]
Subscribe to Better Logic LLC aggregator