Tag: Oracle

Do You Know If Your Database Is Slow?

The time to respond There was a question at Pythian a while ago on how to monitor Oracle database instance performance and alert if there is significant degradation. That got me thinking, while there are different approaches that different DBAs…

Read More >

Log Buffer #325, A Carnival of the Vanities for DBAs

Close your eyes and imagine an affordable holiday featuring islands, pools, simmering white sandy beaches, and clubs. Chances are that you’re thinking about a resort in Hawaii, Fiji or French Polynesia. Now picture such a trip right now. I’ll give…

Read More >

Managing Oracle on Windows: Where’s my Oratab?

If you manage Oracle on Windows, you probably have wondered why it is so difficult to work out which Oracle instances are running and which ORACLE_HOMEs they use. On Unix or Linux, this is a very simple task.  Oracle services…

Read More >

Exadata Join Offloading in Action

One of the biggest selling features of Oracle’s flagship engineered system – Exadata – is the storage offloading capabilities. Storage offloading allows data to be filtered as soon as it is read from storage, reducing the amount of data that…

Read More >

Log Buffer #324, A Carnival of the Vanities for DBAs

A blog post is a composition in an informal verse, usually characterized by the sharing of ideas, experiences, and opinionated news. This vivid explanation of valuable ramblings about the database technologies is what makes this Log Buffer Edition again.

Read More >

Oracle Database Load Testing Tools – Overview

At Pythian’s internal forum, someone just asked the following question: “The team here is evaluating DB load testing tools (Hammerdb, Orion, SLOB, and Swingbench) and was wondering about our experience in using different tools and what is our opinion?” I…

Read More >

Hard Drive: Inner or Outer?

To be precise, I wonder if OUTERmost tracks of a spinning HDD are faster than INNERmost tracks. Should we put physical IO performance secretive data to OUTERmost parts of  the disk and less critical data to INNERmost parts as several vendors suggests? Well I couldn’t find…

Read More >

A Most Simple Cloud: Is Amazon RDS for Oracle Right for You?

Amazon Web Services has offered Relational Database Service as part of their cloud offering since 2011.  These days, RDS provides easy to deploy, on-demand database-as-a-service for MySQL, Oracle, and SQL Server.  When you compare it to essentially any other method of…

Read More >

Log Buffer #323, A Carnival of the Vanities for DBAs

The onslaught of blogs is hard to ignore and underestimate. Blogging has become part of technologists everywhere, including the database professionals and evangelists. This Log Buffer Edition appreciates that and consists of blogs from Oracle, SQL Server and MySQL.

Read More >

Log Buffer #322, A Carnival of the Vanities for DBAs

Log Buffer’s collection of blogs from across the world of various databases is all about nifty features, cool tricks, pragmatic tips, real world war stories, and much more.

Read More >
Page 23 of 144« First Page...10...2122232425...30...Last Page »