The prior blog post [make a link] reviewed PeopleSoft CPU patching. Worthy of its own post is the October 2014 CPU. A show of hands back in April at our PeopleSoft database security presentation at Collaborate 2016 [link?] further confirmed Integrigy’s research that a surprising number of PeopleSoft installations have not applied this patch.
The PeopleTools October 2014 CPU (8.52.24, 8.53.17, 8.54.04) fixes a critical issue with the (more...)
I have written about the importance of automation in previous posts, and this one is following the same line. This time I wanted to test and document my experience with “golden database templates”. Wy? Because most DBAs will appreciate that there are more interesting things to do than to run “create database” scripts all day, so why not automate the process? For quite some time DBCA, or the Database Creation Assistant offers you the option (more...)
In a previous post I wrote about one misconception about views that is revealed when I talk about Editioning Views in my EBR (Edition-Based Redefinition) presentations.
This post is about another misconception.
In the part of the presentation in which I “preach” to cover every table with an Editioning View and to replace every reference to tables in the code with reference to the corresponding Editioning Views, I usually get the following question from the (more...)
At CERN we run multiple Hadoop clusters to satisfy demanding requirements from our experiments and accelerator communities. The usage and criticality of the clusters are increasing dramatically as more users are looking at Hadoop to process and archive the vast amounts of data coming out of LHC.
I started this blog in 2008, so it has taken me all of 8 years to produce one hundred posts. Not exactly a huge output when compared to many other bloggers, but at least the pace has been reasonably consistent over the years, and hopefully most (more...)
This is the 19th installment of my blog series around Stream Processing and Analytics.
Last week all the presentation from the Spark Summit have been made available on YouTube. I have included the Stream Processing related talk in the links section below.
As usual, find below the new blog articles, presentations, videos and software releases from last week:
News and Blog Posts
Continuing my love hate relationship with streams - today presented another interesting challenge when this email alert from cloud control appeared in my inbox
So ORA-4080- pretty unusual error (well not the normal kinds of failures anyway) - what is that?
oerr ora 4080
04080, 00000, "trigger '%s' does not exist"
// *Cause: The TRIGGER name is invalid.
// *Action: Check the trigger name.
I have reviewed the latest edition of Oracle PL/SQL Programming. This is not a book, at least for me, that I would read front to back. I use it mostly as a reference, but the great thing about this book is that you can also use this book to learn programming PL/SQL from scratch.
The book is nicely ordered into different parts, like Program structure and how to use SQL in PL/SQL (which by the (more...)
This week my plans were thrown into chaos when our house flooded. Before I go any further I should state that everyone is fine, no structural damage was done and we were about as lightly flooded as you can be whilst still being, well, in the situation of having dirty, contaminated water in your home. Let’s just say our garden pond partially relocated into our house but (more...)
VirtualBox 5.0.22 has been released.
Judging by the progress of 5.1, now in beta 3, it won’t be long before we’ve got something new to play with. 🙂
VirtualBox 5.0.22 Released was first posted on June 17, 2016 at 2:02 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If (more...)
In the absence of a virtual column or function-based index, the optimizer uses a basic selectivity guess of 1% for a predicate of the form: “function(column) = constant”; but there is (at least) one special case where it gets clever; simple type conversion:
create table t1 nologging as select cast( case when mod(rownum,1000) = 0 then 0 when mod(rownum,100) = 0 then 1 else 9 end as varchar2(1) ) v1 from all_objects where rownum (more...)
We had an interesting question on AskTom this week. The poster had been told by their DBA that the reason their large INSERT-AS_SELECT statement was consuming lots of temporary segment space, was because the database had been recently altered to enable FORCE LOGGING, presumably to ensure easier consistency in a physical standby node.
So … here’s a simple test case to demonstrate that this assertion is wrong.
First we build up table, and then (more...)