Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: 12c
Sharing a tablespace between 2 databases
I was reading an interesting discussion today about multiple databases each containing large amounts of read-only data. If that read-only data is common, then it would make sense to have a single copy of that data and have both databases share it. Well, as…
12c Release 2, set feedback enhancement in SQL PLus
There’s a nice little touch to the “set feedback” command in SQL PLus in 12.2. There is a new “only” clause in the SET FEEDBACK command, so you can run queries but the resulting rows are not shown in the display. They are still…
12c Release 2 – Transparent Data Encryption online !
It doesn’t take a rocket scientist to know that even if you have incredibly stringent controls on user authentication, user authorisation etc, that wont save you if your data on disk is not encrypted. All you need is an errant tape, a missing disk,…
TimTams, Twelve Two, and tete-a-tete !
What do you do when you’re an Australian, you’re at Oracle Headquarters, 13,000 kms from home you bump into someone whilst grabbing a coffee Well…naturally, you lure them over with a packet of our famous Australian chocolate biscuits, grab a camera and have a…
Oracle Database 12c Release 2 is here !
Since OpenWorld 2016 when we first saw some of the cool features in Oracle Database 12c Release 2, many IT professionals out there have been exploring the release via our various cloud offerings, but if your organization has not yet embraced the cloud, then…
Extending Flashback Data Archive in 12c
Flashback Data Archive (previously called Total Recall) has been around for a long time now. For those unfamiliar with it, (and by the way, if you are on Enterprise Edition, you should be familiar with it, because its a free feature), here is a…
A 12.2 treat for the festive season
We’re being asked to store more and more data, yet keep backup windows, query performance and the like unchanged, no matter how much we store. As a result, more and more database shops are needing to partition their data. The problem is – partitioning…
