-
Please keep your foreign keys
I came across an interesting blog post the other day about whether databases should be (declaratively) enforcing the foreign key relationships between tables. The blog post discussed the issue of foreign keys being temporarily disabled to perform data loading, and then encountering the problem of what to do when those foreign keys cannot be re-enabled Read more
-
Upgrade with no effort
We all know what upgrades mean. Installation…Configuration…Patching…Testing…Deployment…Change approvals…Meetings…Long hours…Perhaps pulling an “overnighter” but hopefully never having to enact the dreaded “Backout Plan”. Or…. that stuff can “just happen” without you worrying about it at all! I logged on to my Exadata Cloud Express database on the weekend, and lo and behold, it is not Oracle Read more
-
Behold the full stack developer
Well…sort of. Well…not really This blog post is really about how with just a little bit of knowledge and patience you can bring several cool technologies and tools together to achieve what you want. I’m off to OpenWorld at the start of October which will be an awesome event as usual, and in the last Read more
-
12c Statistics on load–special cases
One of the cool features in 12c is the automatic collection of optimizer statistics when a table is either created or loaded via direct path from empty. This makes a lot of sense because it saves us from what used to be the mandatory second step of gathering statistics whenever we loaded an empty table Read more
-
Choosing a password scheme for the database
In the Security Guide there is a section to assist you with the decisions about what rules you might want to have in place when users choose passwords, namely attributes like the minimum length of a password, the types of characters it must (and must not) contain, re-use of old passwords etc etc. The documentation Read more
-
AskTOM–more experts to help you!
I’m thrilled to announce the “formal” addition of globalization and characterset guru Sergiusz Wolicki to the AskTOM team. I say “formal” addition because the team was already getting guidance from Sergiusz whenever we had tough question on charactersets, but just like his enthusiasm to help customers on the forums, Sergiusz was keen to help our Read more
-
Oracle Code … Not for database people ?
Jump over to the Oracle Code home page and you will see the “mission statement” of the Oracle Code conference series: “Learn from technical experts in sessions for developing software in Java, Node.js, and other languages and frameworks.” You might hence be thinking that “old school” stuff like (relational) database technology has no place at Read more
-
Interval partitioning just got better
Interval partitioning was a great feature when it arrived in version 11, because we no longer had to worry so much about ensuring partitions were available for new data when it arrived. Partitions would just be created on the fly as required. I’m not going to talk about interval partition in detail because there’s plenty Read more
-
Quick tip–database link passwords
If you are relying on database links in your application, think carefully about how you want to manage the accounts that you connect with, in particular, when it comes to password expiry. With a standard connect request to the database, if your password is going to expire soon, you will get some feedback on this: Read more
-
AskTOM TV episode 8
On AskTOM episode 8, I’ve taken a look at locating the SQL Plan Directives used for a particular query. Here is the script output from the video if you want to use this for your own exploration SQL> SQL> create table t as 2 select * 3 from dba_objects 4 where owner = ‘SYS’ and Read more
-
Top Ten Travel hints and Tips
Well, let me be honest right at the top here. These are not travel hints These will not help you in any way. This is me having a whine and a rant about a minority of people that I occasionally encounter when travelling. Yes, this can probably be best described as me and my Read more
-
DIY parallel task execution
We had a question on AskTOM recently, where a poster wanted to rebuild all of the indexes in his schema that had a status of UNUSABLE. Running the rebuild’s in serial fashion (one after the other) seemed an inefficient use of the server horsepower, and rebuilding each index with a PARALLEL clause also was not Read more
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Learning is not a spectator sport 