Posts Categorized: Technical Blog
Automatic degree of parallelism, or Auto DOP, is a new feature in 11gR2 that promises to help manage systems where large subset of the workload runs with parallel processing. In this post I’ll introduce the feature and give very useful tips I got from Oracle’s Real World Performance expert Greg Rahn on how to use it. So this is worth reading even if you are familiar with the feature.
This is a short blog post to give you my Apps DBA takeaway from Oracle OpenWorld 2011 in the context of Oracle Fusion Applications (new Oracle ERP/CRM/…+ product).
The MySQL errorlog is an important point of reference when administering a MySQL Server. We can grasp much about the state of our MySQL instance by the informational and error messages written out to it by our MySQL daemon. I was asked to investigate some replication outage alerts a colleague had received overnight. One of the primary directions I took was the error log file. This is where I would expect find any evidence of replication being stopped or crashes etc. When I ran the command to tail the log I was shocked to see the log was totally empty.
A bit more than a week passed since most of us who been part of the OpenWorld are back from San Francisco. It is about time to start sharing stories on how it went for each of us. I must admit that it happened to be a very stressful OpenWorld for me personally. I am recovering from it slowly. On the positive side I met so many great people, discovered how supportive people are and how great is to be a part of the Pythian Team! Let’s talk about how my 2 presentations went at Oracle OpenWorld 2011.
This post was thought of as an attempt to make some performance test with new multi-threaded replication in 5.6, at least that was my initial intention. Based on Luis Soarez – Replication Team Leader in Oracle – post. I wanted to play with new set of variables and features in order to understand how new multi-threaded replication works and make some performance tests.
Pod::Weaver, which does to POD what Dist::Zilla does to distribution files, is all that, only moreso. But it feels so powerful, holds so much promises to make my life easier once I manage to master it, that I won’t let the steep learning curve deter me. I’ll climb down my brain bicycle, and push it up that hill. And I’ll provide a running (well, walking slowly) commentary as I go along, in the hope that it’ll help other peeps who might want to venture is those exciting yet dark waters. Okay. Enough preamble. Let’s get cracking.
‘m going to be presenting two of my OOW11 sessions at the Toronto Oracle User Group’s DD Day. I’m going to be presenting two sessions, Is Oracle Exadata for You? Starring Roles for the Best Technology, and Under the Hood of Oracle ASM: Failability Analysis.
Pythian’s presence at OOW each year permits this fine company, of which I have been a part for a total of close to 8 years, to get higher on Oracle’s and the industry in general’s radar. There are so many differentiators that separate Pythian from other companies. Take homes from OOW?
The website for Oracle Database Cloud Services is now online. It’s a hosted database service running Oracle 11gR2. The database can be accessed using a hosted Oracle application server, via JDBC across the Internet, or their own RESTful API a la Amazon. Notably lacking is Oracle’s own TNS network protocol. A lot of the feature set seems to be oriented toward data warehousing applications, including the aforementioned partitioning, bitmap indexes, query rewrite, and star transformations. A few other interesting features
Better late than never – we absolutely have prizes this year for the Blogger’s Meetup. Alex has been way too busy of late to get this organized (joking, not ALL his fault…). Seriously, we do have prizes. We will have beer and there will be food at Jillian’s in a very short time.