In a proud moment for me, it appears that Mark Hurd, CEO of Oracle, has mentioned my flashdba blog during the Oracle Q4 2015 results call. At least, that’s what I’m reading into this section from the transcript published by Seeking Alpha:
We grew in storage in the quarter and this is — really we are going through a shift in storage now. We released our SAN product FS1 in the quarter which (more...)
I’ve done several Exadata deployments recently and I have to say of all the components PDUs were hardest to configure. Important to notice that unlike earlier generations of Exadata the PDUs in X5 are Ehnanced PDUs and not Standard.
Reading the public documentation (Configuring the Power Distribution Units) it says that on PDUs with three power input leads you need to connect the middle power lead to the power source. Well I’ve done (more...)
I’ve done a couple of play installations of EM12c 126.96.36.199, just to get a feel for it. You can see the result of that here.
From an installation perspective, everything was pretty similar to the previous releases. I tried the installation on both OL5 and OL6, in both cases using 12c as the database repository. (more...)
"I never knew words could be so confusing," Milo said to Tock as he bent down to scratch the dog's ear.
"Only when you use a lot to say a little," answered Tock. Milo thought this was quite the wisest thing he'd heard all day.
-- Norton Juster, The Phantom Tollbooth
Occasionally it may be necessary to ‘flip’ a table on its side, so to speak, meaning to convert rows to columns in order to (more...)
A question came up on the OTN database forum recently asking if you could have a partitioned index on a non-partitioned table.
(I’m not sure whether it would be quicker to read the manuals or try the experiment – either would probably bothere quicker than posing the question to the forum. As so often happens in these RTFM questions the OP didn’t bother to acknowledge any of the responses)
The answer to the question is (more...)
The following simple, code snippet, demonstrates how you can check if an XMLType view or…
Another interesting topic that goes over and above the CDB Resource Manager Plans I described earlier this week is the implementation of IORM Plans for Pluggable Databases. Pluggable Databases are an interesting object for studies, and I like to research things. When 12c came out there was no support for offloading initially, it is required that you are on cell software 12.1.x.x.x for full 12c support on Exadata. One aspect I was particularly (more...)
I hacked together a query today that shows the overall I/O performance that a database is experiencing.
The output looks like this:
End snapshot time number of IOs ave IO time (ms) ave IO size (bytes)
------------------- ------------- ---------------- -------------------
2015-06-15 15:00:59 359254 20 711636
2015-06-15 16:00:59 805884 16 793033
2015-06-15 17:00:13 516576 13 472478
2015-06-15 18:00:27 471098 6 123565
2015-06-15 19:00:41 201820 9 294858
2015-06-15 20:00:55 117887 5 158778
2015-06-15 21:00:09 85629 1 79129
As some of you may have read I've been investing some time in making use of cloud control as a CMDB (or something CMDB like at least) - everyone has a CMDB right.....?
Well anyway we have been arranging with our os support teams to patch SLES10 and SLES 11 up to the latest patchset across all the estate. I wanted to use cloud control to validate what actually needed to be done and i (more...)
It is not often that something like the following happens on Google while searching for…
This last few days I’ve been analysing how well received previous presentations (since 2006!) have been at the UKOUG tech conferences. It’s interesting to look at the information. I’ve learnt some interesting things about all those well-known-names :-)
Like many conferences and user group meetings, during the conference and shortly afterwards the UKOUG ask attendees to feed back on the presentations, keynotes and round tables that people go to. If you chair a session, (more...)
I got some feedback from the Oracle documentation team today, based on my recent post.
One of the concerns I raised was about how the GUIDs would be used in different releases of the documentation. Although I don’t like the look of the GUIDs, I can understand why they might be more convenient that trying to think of a neat, descriptive, human readable slug. My concern was the GUID might be unique for every (more...)
In Part II of this series, we looked at how we can create a B-Tree index on a encrypted column, providing we do not apply salt during encryption. However, this is not the only restriction with regard to indexing an encrypted column using column-based encryption. If we attempt to create an index that is not a […]
Enterprise Manager Cloud Control 12c Release 5 is avaliable to download. The new release is designed to monitor and manage both your on-premise and Oracle Cloud deployments which is called “Hybrid Cloud” by Oracle. You can deploy Management Agents onto the Oracle Cloud virtual hosts to manage Oracle Cloud targets just as you would any other targets. EM12c R5 also supports data cloning between on-premise and Oracle Cloud. Integration with Oracle Enterprise Manager Ops Center (more...)
Following on from an OTN posting about dynamic sampling difficulties I had planned to write a blog post about the difference between “not sampling when hinted” and “ignoring the sample” – but Mohamed Houri got there before me.
It’s just worth highlighing a little detail that is often overlooked, though: there are two variations on the “dynamic sampling” hint, the cursor level and the table level, and the number of blocks sampled at a (more...)
About a year ago I came across a couple of useful articles from Stefan Koehler, which is when I added his name to my blog roll. As an introduction for other readers I’ve compiled an index for a series of articles he wrote about the CBO viewed, largely, from the perspective of using Oracle to run SAP. Today I realised I hadn’t got around to publishing it, and there’s been a couple of additions since (more...)
event histogram metric, a script and some related comments on collecting and displaying wait event latency histograms for Oracle performance troubleshooting.Why:
Latency histograms (and by extension wait event histograms) provide very useful information when troubleshooting performanc
e for systems exhibiting response time with multi-mode distribution. In such cases average wait values are often not sufficient to understand the behavior of the system under study and histograms
provide a finer level of details. A (more...)
No More missing packages
I wrote several times about manually editing refhost.xml. There's not need for it, just apply Patch 18231786.
Inspired by Sue Lee’s presentation at Enkitec’s E4 conference I decided to re-run my test suite to work out how you can use Database and I/O Resource Manager in Oracle 188.8.131.52.2 to help consolidating databases in the new Multi-Tenant architecture. I should point out briefly that the use of Multi-Tenant as demonstrated in this article requires you to have a license. Tuning tools shown will also require you to be appropriately (more...)