You recently learned about eDB360, and now eAdam? What is this eAdam tool? Before you continue reading, please be aware that eAdam reads data from AWR, thus you must have a license for the Oracle Diagnostics Pack in order to use this new eAdam tool.
New eAdam is a free tool to perform data mining on performance related historical data recorded by AWR. The main characteristics of eAdam are:
The OTN Yathra 2014 tour is over and I’m back home now. Here are all the blog posts from the tour.
Although I come from the second biggest city in the UK, Birmingham has a very slow pace in comparison to other UK cities. Friends had told me how busy India was, so I was quite nervous about this trip and how I would cope (more...)
Application developers frequently experiment to achieve higher quality builds, they try things out, make mistakes and find fixes. Database design can be like that too, but rapidly changing the schema in traditional shared environment tends to break the application.
In this webinar, Kyle Hailey will explore how different types of cloning technology work and their benefits and limitations. The webinar will also demonstrate how you can setup and coordinate risk-free database experiments using Delphix and (more...)
Once upon a time, Oracle Support had a note called Script: Lists All Indexes that Benefit from a Rebuild (Doc ID 122008.1) which lets just say I didn’t view in a particularly positive light :) Mainly because it gave dubious advice which included that indexes should be rebuilt if: Deleted entries represent 20% or more of […]
Please click link here to read my blog at Pythian.
Super Charge Database Deployments
Delphix and Pure Storage, a combination like chocolate and peanut butter.
It’s with great pleasure that I have accepted the invitation done by the fine gentlemen at the OUGN to be a part of this year’s spring boat OUGN Conference taking us all to high seas, sharing on board the latest and greatest technology trends in the Oracle ecosystem in early April. I will be speaking […]
I’m trying to get up to speed on 12c, especially the multitentant features. So, I decided to read the sections of the manuals that related to using multitentant. Here is the name of the manual I was looking at:
Oracle® Database Administrator’s Guide 12c Release 1 (12.1)
It isn’t great reading. It is kind of slow-paced and really more of a reference but since it is a large new feature I (more...)
I want to see what useful information are returned by few RMAN commands such as report schema
or list backup
when using the default RMAN configuration and getting some backups.
When connected to the ROOT container issuing the RMAN report schema
command is quite simple identify how many pluggable databases are plugged into the container database and, above all, the relationship with their datafiles and locations.
In my case the container database, named CDB001, contains (more...)
Dang, been a while since the last posts! A lot of water under the bridge since then.
We've ditched a few people that were not really helping anything, and are now actively looking at cloud solutions, "big data" use, etcetc.
Meanwhile, there is the small detail that business as usual has to continue: it's very easy to parrot about the latest gimmick/feature/funtastic technology that will
I will describe how you configure trust stores for the WebLogic Server.
Chain of trust
When a SSL server certificate is issued by a CA it is signed by a another certificate. Normally this will be an intermediate certificated, that is again signed by the CAs root certificate. So there is a chain of trust between the (more...)
Aanstaande dinsdag 4 maart wordt er door Oracle een Oracle EMEA Virtual Developer Day georganiseerd. Je kunt je hiervoor gratis inschrijven en live, via het internet, deze volgen, mocht je in de gelegenheid zijn. Je hebt de mogelijkheid om zelf mee te doen, via twee beschikbaar gestelde VirtualBox virtuele demo machine omgevingen, of alleen de
Just a quick note that I’ve added a zip file with my presentation at Hotsos yesterday which includes the scripts that I demoed. You can find it on the Whitepapers/Presentations page. Or you can just click this link:
SQL Gone Bad – But Plan Not Changed!
It was a little dicey sunday morning with weather in Ohio but I caught very early flight and made it down to Dallas well before noon. Lots of turbulence in the airplane ride and bounced around some but all in all not bad. Lots of people traveling ran into hitches one way or another but by the end of the day Monday most everyone seems to be here now.
Even better I had (more...)
Saw this blog post about how Cary Millsap learned about Oracle performance tuning and I thought it was interesting:
It is interesting because I’ve learned so much from Cary Millsap and Jeff Holt’s book and it is cool to see how Cary got to the position he is in as a well-known Oracle performance expert. I guess I’ve always found the performance tuning part of my Oracle DBA job the (more...)
This is going to be another one of those posts, a bit like this one, that discuss the use of Oracle’s database product with Advanced Format devices. I wish there weren’t so many of these posts, but it seems that Oracle has a lot of issues with it’s implementation of 4k support.
(Before reading on, if you aren’t sure what I’m talking about here then please have a read of this page…)
This was tested on Oracle 11.2. NUMBER items and their column headings are right justified by default:
SQL> set numwidth 15
SQL> select count(*) table_count from dba_tables
If you want to see the heading in the centre of the column, you can do so with justify centre:
SQL> col table_count justify centre
SQL> select count(*) table_count from dba_tables
In the first part, I explained that Incremental Statistics are designed to allow a partitioned tables Global Statistics to be updated based on a combination of
1) Statistics gathered by analysing the contents of one or more partitions that have just been loaded or have been updated (and see this blog post for more depth on what 'updated' means!)
2) The statistics of existing partitions which are represented by synposes that are already (more...)
Sitting in an airport, waiting for a plane, I decided to read a note (pdf) about Flashback data archive written by Beat Ramseier from Trivadis. I’d got about three quarters of the way through it when I paused for thought and figured out that on the typical database implementation something nasty is going to happen after approximately 3 years and 9 months. Can you guess why ?
It’s all about smon_scn_time – which normally records one (more...)