Now available! https://docs.oracle.com/en/database/oracle/oracle-database/20/books.html Going through the New Features guide, there is a shed load of wonderful enhancements. Then you look at the Licensing guide, and most of them require Exadata or Oracle Cloud or both.
Many times I’ve seen the question on forums “How can I move a table from one schema to another?” and the answer is always that you can’t. You have to copy it. Or export/import it. Well, here’s a way. It …
A very nice licensing change in 19c: you can now have up to three PDBs in a Standard Edition Multitenant database. Apart from the obvious advantage of being able to do some database consolidation, it gives SE2 users the ability …
Humans are visual creatures and it is often helpful to communicate information through color. Use this tutorial to change your APEX interactive report heading colors. First lets understand how we can identify the headers of an Interactive Report. APEX needs …
What is Privilege Analysis (included in Oracle Database 19c Enterprise Edition) Database 19c is nothing more than the re-badging of release 12.2.0.3: the terminal 12c release that will have extended support until March That having been said, there are a …
Do you know about multiple domain certificates? If not you may have to learn quickly, because Oracle has changed the way they are handled in release 12.2. This is going to break a lot of applications. A multiple domain certificate …
Will upgrade from 12.1 to 12.2 break your applications? It may if your developers are using JSON. In both release 12.1 and 12.2, there are these keywords: orclx> select * from v$reserved_words where keyword like ‘JSON%’ order by 1; KEYWORD …
Comparing database 12cR1 release 12.1.0.2 to 12cR2 release 12.2.0.0.3, I see these new parameters: adg_imc_enabled TRUE Enable IMC support on ADG allow_global_dblinks FALSE LDAP lookup for DBLINKS allow_group_access_to_sga FALSE Allow read access for SGA to users of Oracle owner group …
I am fascinated by what I call “equal SQL”: statements that are equivalent, in that they deliver the same result but may have hugely different performance characteristics. Here’s a little case study. Consider this example, working in the OE demonstration …
HCC is available only on Oracle supplied storage, such as a ZFS storage appliance or (as in this case) an Exadata engineered system. Furthermore, it occurs only for direct loads: in my examples, using CTAS. This is the script I’m …