It’s been a while since I put anything on this blog, most likely down to a combination of being overly busy in my previous life at UKOUG and not having anything to say that couldn’t be said in 140 characters.
Anyway, I’ll be at the UKOUG Tech13 Conference in Manchester (more...)
Oracle OpenWorld is a monster event – 10Ks of attendees, thousands of sessions and 100Ks of private conversations that all help convey and define the message about Oracle’s strategy and the roadmap for its close to 4000 thousand products. Concurrently with OOW is the JavaOne conference that – al a (more...)
“The devil can cite Scripture for his purpose. An evil soul producing holy witness Is like a villain with a smiling cheek, A goodly apple rotten at the heart: O, what a goodly outside falsehood hath!” —from The Merchant of Venice by William Shakespeare Dr. Codd’s support for non-relational (more...)
In this post I will put 5 other new 12c features in the spotlight (in addition to the features of a previous post), that really makes the 12c an improvement against the previous versions of the Oracle database.
To get this result I listed up all the major new (more...)
Here is the poll data from the Confio-sponsored webinar “NoSQL and Big Data for the Oracle DBA” and my answers to the questions asked in the chat. The recording of the webinar is now available at http://www.confio.com/webinars/nosql-big-data/. The slide deck is at http://iggyfernandez.files.wordpress.com/2013/10/nosql-and-big-data-for-oracle-dbas-oct-2013.pdf. Are (more...)
In my webinar for Confio on October 10, I will explain that the deficiencies of relational technology are actually a result of deliberate choices made by the relational movement in its early years. The relational camp needs to revisit these choices if it wants to compete with NoSQL and Big (more...)
Reblogged from So Many Oracle Manuals, So Little Time: See also : No! to SQL and No! to NoSQL The inventor of the relational model, Dr. Edgar “Ted” Codd believed that the suppression of physical database design details was the chief advantage of the relational model. He made the case (more...)
EA1 dropped in July. Now here we are a little more than a week before Oracle Open World and we are making Early Adopter 2 of Oracle SQL Developer version 4 available for you to download and provide feedback.
There’s two big things you need to know about:
- About 500 (more...)
See also : No! to SQL and No! to NoSQL The NoSQL camp claims to have the lead in performance, scalability, and availability. Should you use SQL or NoSQL for your next project? A well-known database theoretician suggested that you weigh three factors, one of which is performance. He conceded (more...)
See also : No! to SQL and No! to NoSQL The inventor of the relational model, Dr. Edgar “Ted” Codd believed that the suppression of physical database design details was the chief advantage of the relational model. He made the case in the very first sentence of the very first (more...)
I've always considered myself a developer and a LOWER(DBA)
. I may have recovered perhaps one database and that was just a sandbox
, nothing production worthy. I've built out instances for development and testing and I've installed the software a few hundred times, at least. I've done DBA-like duties, but (more...)
Just a quick wrap up on EM12cR3 upgrade. I have to say that I was pleasantly surprised that everything went so smooth. I didn’t expected anything else, but with so how many products and components we have there I got few things in mind. The version I got was already (more...)
Security should be on everybody’s mind after the recent revelations that Google Chrome Handles a Security Hole in the Worst Way and that cloud computing companies stand to lose $35 billion dollars because of the intelligence-gathering activities of our government. According to Slavik Markovich, the CTO of database security at (more...)
You may remember this children’s song from kindergarten or you can listen to this YouTube video: “Ten green bottles hanging on the wall Ten green bottles hanging on the wall And if one green bottle should accidentally fall There’ll be nine green bottles hanging on the wall.” In this Oracle (more...)
This is the last post in this series and I’ll not introduce anything new here, but rather just summarise the changes explained and talk a bit about the value the solution delivers to the organisation.
Let’s first review the situation we faced before implementing the changes.
The cost of writing (more...)
Reducing storage requirements
In the last post in this series I talked about how we sped up the move of data from operational to historical tables from around 16 hours down to just seconds. You find that post here.
The last area of concern was the amount of storage this (more...)
Moving to history tables
In the last post I talked about how we made the speed of actually writing all those log-records much faster. It has to date been so fast that no a single report of a problem has been filed. you find that post here.
Once the data (more...)
Writing log records
The last post in this series introduced the problem briefly. You find that post here.
In this post I’ll talk about the changes made to make that writing of log records fast enough. There were 50 million records that was written. Each of them pretty much in its (more...)
In my work among other things I tune and tweak solutions for EXADATA. Today I’ll write about a big improvement we achieved with a process that moves data from the operational tables to the ones where the history is stored.
This will not be a technical post. While I (more...)