It’s a busy summer at Pythian, with our continuing wave of speaking sessions at upcoming community and regional industry events.
Coming to a city near you, watch for Pythian presenting hot Oracle and Microsoft SQL Server database topics:
Oracle Technology Days – Montreal
August 9, 2011 – 8:30am – 1pm, Hilton Montreal Bonaventure
Oracle Technology Days – Toronto
August 25, 2011
Blogs are not just yet another piece of writing. They are the manifestation of passion, perfection and purity of love towards the community. Bloggers take immense pride in sharing what they know or want to know in their blog posts, and that enables the community to respond by learning or by teaching. Log Buffer is a way to appreciate this passion, and Log Buffer #229 is yet another example of that.
Kyle Hailey discusses yet another Rule of Thumb about the log file syncs time.
Many questions Jonathan[Read more...]
Sun is shining and the warm wind is blowing and bringing in new and novel ideas for the technology blogs and database are no exception. From the SQL Server to MySQL and up to Oracle, blogs are bubbling with warm and cool blog posts and we present you the pick of the week in this Log Buffer #228 edition of Log Buffer.
There is an Exadata Virtual Conference, which has been organized by Tanel Poder on August 3rd and 4th. Kerry Osborne has more details.
The new release of DB Optimizer , version 3.o, from Embarcadero has awesome new feature : explain plan overlay onto VST[Read more...]
An ideal summer day is when the sun is shining, the warm sunshine refreshes your body, the light breeze becomes naught with your hair, the birds sitting on intoxicated leaves smile at you, and you to top all of that you get the latest hot issue of the Log Buffer. Yes to put cherry on your cake, Log Buffer #227 is here.
David Kurts tells us about applying Hints to Objects inside Database Views.
Jonathan Lewis answers another burning question on on multi-column bitmap indexes and the inability of[Read more...]
In your hands, the new edition of Log Buffer is smiling and it wants your undivided attention, because it is full of selected simmering yet cool blog posts from around the blogistan of database arena. Enjoy the Log Buffer #226.
Kyle Hailey is exploring I/O histogram values in Automatic Workload Repository.
Charles Hopper tells us what is wrong with the quote – Addressing TM Enqueue Contention[Read more...]
March of bloggers goes on and so is the unstoppable production of the blog posts. It’s getting more exciting week after week watching the new and old bloggers adding spice to the database blogosphere. This edition of Log Buffer brings some of the simmering and scintillating posts from around the globe in Log Buffer #225.
Kevin Closson hasn’t quit blogging, as he declares in his blog post while giving a glimpse of the future and a cute photo.[Read more...]
It’s the scorching summer season in this part of the world, Pakistan. There are many summer woes as the temperature reaches to 45 centigrade and beyond, but that also brings in the most savored fruit of the world, the king of fruits, Mango. Pakistan is one of the largest producer and exporter of this fruit from paradise. There are many variates of mangoes and its hard to pick from them as they all are so sweet and eye catching. Same is the case with the database related blogs, when it comes to selection for the edition of Log Buffer. So once again here you are, about to savor the sweet blogs in Log Buffer #224.
Automatic Diagnostic Repository (ADR) has changed[Read more...]
Social media is buzzing with the news and views of bloggers. From the database side of this glorious media, we have picked out some of the gems for you in this edition of Log Buffer, which is the Log Buffer #223.
Jonathan Lewis was presenting the keynote at the Turkish Oracle User Group conference and he blogs about a discussion over there.
A new Myth arrives Index Rebuilds and Nial litchfield has an interesting take on it.
Why is my SYSAUX Tablespace so Big?[Read more...]
As the birds have started their yearly migration back to their homes from the warmer areas to the relative less cooler areas in summer, bloggers are also touching base with the technologies which they cherish most and coming back with some master strokes. This new cool edition of Log Buffer, the coolest blog carnival covering hottest topics encompass that home coming. Now Chill with Log Buffer #222!!!
Charles Hooper blogs about an Overly Complicated Use Case Example regarding Row Values to Comma[Read more...]
Another medley of database blogs under the famous banner of Log Buffer is in your virtual hands. This edition of Log Buffer, the Log Buffer #221 puts spotlight on the fresh and cool blogs from Oracle, MySQL and SQL Server arena.
Martin is playing around with the Grid Infrastructure 188.8.131.52 PSU 2 and found an interesting note on My Oracle Support regarding the Patch Set Update.
Jonathan Lewis has found another gem as an answer to a question posted on OTN forums[Read more...]
When big news is released, the world of modern information shakes – and nowhere is this more visible than with the blogs. Log Buffer is the ideal joint for the shakers and movers of the blogosphere. This edition Log Buffer #220 sheds a spotlight on those hot spots.
Gary Myers blogs about the encouraging women in information technology and mentioned Pythian’s own Gwen Shapira.
Dom Brooks is getting a bit tired of the number of bugs in 11gR2 listed as “Fixed in 12.1″.
Tim Hall is[Read more...]
There are plethora of thrilling business software trends on the horizon as the summer of 2011 starts. Many of these will significantly impact IT organizations seeking to align IT operations with business objectives. Awareness of such trends can help you to keep ahead of the competition. What better way to get abreast of these trends in a nutshell than the Log Buffer? Log Buffer #219 is in your hands to enjoy.
When Arup writes it, it stays written. In a very refreshing post, he is sure to convince anybody why he or she needs Tanel Poder’s class.[Read more...]
GreenSQL invites you to participate in our May Webinars
MAY 18- Securing Databases in Minutes with GreenSQL Express
MAY 24 – Unified Database Security, the Next Generation of Database Security
Press here to sign
Oracle’s assault on the global market goes on with full might and as it adds new products in it’s array, SQL Server also strives hard to get the attention of people through various public appearances, and MySQL is also not behind as its growing array of bloggers marches on. This week’s Log Buffer casts a shadow on some selective blogs from these three technology in its latest edition Log Buffer #218.
ASHMON is one of the popular tool for monitoring and Kyle Hailey has just mentioned that his this tool ASHMON not only graphs ASH data but graphs v$sysstat as well.[Read more...]
Clouds are dispersing and the sun has started shining through. On the IT horizon, the cloud of Amazon has also dispersed and that is the biggest news of the previous week. Well clouds are elastic and they congregate and become solid after dispersion, and so Amazon will be fine too. And our blogosphere is fine too and here is the latest report about them in this week’s edition Log Buffer #217.
Arup Nanda asks. You want to find out the tables with the highest number of rows in a database. Pretty simple, right?
Jonathan Lewis blogs about as how to ensure that you never give the wrong[Read more...]
Log Buffer has become the mainstream carnival of the Oracle blogosphere. Technological advances in Oracle, MySQL, SQL Server and other database systems, more and more conferences, and increasing numbers of bloggers are making log buffering more and more interesting, and this week’s edition Log Buffer #216 is a clear manifestation of that.
To err is human and to manage err is management. Alex Gorbachev fascinates us by adding his thoughts to a forum thread.
Christian Antognini and Oracle Internals are the perfect match. This time[Read more...]
Interesting question on human mistakes was posted on the DBA Managers Forum discussions today.
As human beings, we are sometimes make mistakes. How do you make sure that your employees won’t make mistakes and cause downtime/data loss/etc on your critical production systems?
I don’t think we can avoid this technically, probably working procedures is the solution.
I’d like to hear your thoughts.
I typed my thoughts and as I was finishing, I thought that it makes sense to post it on the blog too so here we go…
The keys to prevent mistakes are low stress levels, clear communications and established processes. Not a complete list but I think these are the top things to reduce the number of mistakes we make managing data infrastructure or for[Read more...]
Spring is making its way into everything, and the databases are blooming as the DBAs who manage them are savoring the fragrance of the changing weather and fresh new ideas in the world of blogging. In order to appreciate the springing blogging innovations, this week’s Log Buffer, Log Buffer #215 picks some of the flowers just for you.
Hemant, the Oracle ACE from Singapore writes superbly about OuterJoin with Filter Predicate as usual with a reproducible case.
I would like to personally invite you to a GreenSQL Express Webinar,
I’ll be demonstrating GreenSQL Express, the free and simple way to keep your information private and safe.
On Wednesday, March 16th (just 2 weeks from now),
It’s called “How to Protect Sensitive Information in Minutes: Setting up GreenSQL Express with Basic Security Rules”
If you’re serious about protecting your data, you need to hear and see how it’s done. I’ll talk about:
1. Why you need a Database firewall / security solution
2. Where and How to install GreenSQL Express in your infrastructure
3. How to use GreenSQL Express to protect you database
4. How to create the security polices you need in minutes
5. How to protect your database from SQL injection attacks
6. How to
Chet Justice, the Oracle Nerd breathes a sigh of relief as he gets to release some much needed space from his hard drive.
Jonathan Lewis reminds about a subtle difference between a predicate and the constraint.[Read more...]
One of the leading performance gurus, Kellyn Pederson is letting us know how she is finding the initial months at Pythian and she rightly praises her fabulous team mates Mark Brinsmead, Paul Logan, and Andy Klock.
The famous Oracle Database Junkie – Arup Nanda, blogs more about Interested Transaction Lists.
Universal Connection Pool, Oracle’s next[Read more...]
While Oracle provides no official information they are planning on improving MySQL and using as a product to compete with Microsoft SQL Server, it is rather obvious from what little information you can glean from public announcements this is a clear business goal.
Microsoft however are publicly seeking a Senior Product Manager, MySQL Compete in the Marketing department. Your goal is nothing technical, it’s all PR to dispel MySQL as a viable product. I quote “you will equip field and partners to win in competitive engagements against MySQL, and you will influence market perception in favor of Microsoft technologies.” Here is the Full job description for those that want an amusing read.
This information came from an Oracle colleague of mine based in Asia.