Oracle has released an Enterprise Manager Plug-In for AWS. This Plug-In enables you to monitor and troubleshoot your cloud-based databases alongside with your on-premise databases with one single tool. Especially in cloud-based environments it can be tricky and time consuming to identify issues with your database. However, by deploying this Plug-In within your OEM Cloud Control environment, you gain following management features:
- Monitor EBS, EC2 and RDS instances on Amazon Web Services
- Gather performance metrics and configuration details for AWS instances
- Raise alerts and violations based on thresholds set on monitoring
- Generate reports based on the gathered data
Filed under: (more...)
Oracle has ported DTrace for Oracle Linux. DTrace is a very powerful performance analysis and troubleshooting tool that allows you to instrument all software. It’s name is short for Dynamic Tracing. I’m not a DTrace expert but some say it is that powerful that it allows you to reverse engineer any software…
Filed under: Oracle
The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.
Here’s an excerpt:
4,329 films were submitted to the 2012 Cannes Film Festival. This blog had 46,000 views in 2012. If each view were a film, this blog would power 11 Film Festivals
Click here to see the complete report.
Filed under: Misc
In the last post of my “Loading data fast” series I showed how DML error logging can be used to prevent batch loads from failing when one or multiple rows can’t be inserted. Now the question is how much performance impact errors have on the mechanism. What I try to prove is that a developer should not just blindly use DML error logging instead of thinking whether the data he intents to insert is primary valid. So let’s have a look:
First I create the same simple table with a primary key on it that I used before:
CREATE TABLE (more...)
In the last post of my series “Loading data fast” I showed how batch inserts can actually make a huge difference in insert performance. Now one question remains: What happens when an error occurs like a unique key violation? The answer is: The insert statement will fail with an error and stop. Now, if you didn’t catch the exception, it will be raised and the commit will never be issued which will lead to a loss of all previous inserted data as well. However, if you catch the exception and make sure that you issue a commit afterwards, you will (more...)
It’s been a long time since my last post on this blog and there were very good reasons for this. Since the last 6 and a half months I did not only move from the US to the UK but also switched from my previous company to Oracle. Of course it took a while to get into the new job but also to get approval for continuing this blog. You will notice a disclaimer at the right hand side saying that this blog is my private blog and has nothing to do with Oracle. So obviously nothing that I post (more...)
In my last post I talked about how persisting data can become the bottleneck on large high scale systems nowadays. I also talked about that more and more people tend to think that databases are simply slow, seeing them as just big I/O systems. And I talked about how lots of applications are still inserting data as they used to do years ago rather to use bulk inserts.
In this post I will show you how bulk inserts can actually boost your inserts and therefore you systems. I will use a simple example showing the difference between:
Today more and more applications have the requirement to load data fast. While this requirement isn’t new in IT, nowadays it mainly means to persist data fast into the database. In times of cheap memory and lots of processing power, system have developed from slim single-threaded applications to huge multi-threaded clusters using lots of memory which provides them with low latency. As a result of that, working with data inside the application became cheap, in some cases even bringing data into the system, e.g. over some in-memory queuing systems. However, the persisting stage still needs to do I/O at (more...)
Today I was part of a NYOUG seminar about “Indexing Strategies” held by Mr. Jonathan Lewis himself. If somebody doesn’t know Jon Lewis, he is one of the top Oracle gurus on the entire planet with more than 25 years of Oracle experience. He probably used Oracle before I was even born (1985)! The very interesting fact however is that he actually never ever worked for Oracle but still has all the deep inside knowledge. Usually those gurus came out from Oracle or are still working for them. I guess the great amount of years dealing with Oracle helped him (more...)