ALL POSTS

Rounding Errors in MYSQL with DECIMAL Type

It seems to be assumed that fixed-point values, DECIMAL and NUMERIC, in MySQL are not susceptible to rounding errors because they are exact numeric data types. It must be kept it mind, that there are limits in precision, and the maximum number of digits for DECIMAL is 65. What I am discussing here is rounding error.

On Your Marks, Get Set …..

This is my first Oracle OpenWorld in a few years. I have not changed (I don’t think), but the show must have grown significantly. With the huge number of acquisitions over the past few years, I am sure I will not recognize some of the solutions mentioned in many presentation billboards as I pass through all the conference venues. For any first time attendees who stumble into this post, my advice as an OOW veteran:

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

Integrated and Turnkey solutions are the name of game these days. Solutions based on software, hardware, storage, and networking tightly knitted in one box with the option of customization are shaping the future. Oracle, once again leading the pack has come up with a groundbreaking appliance and blogs are buzzing with it and so is this Log Buffer Edition. ODA and various sizzling news from SQL Server and MySQL are adorning this Log Buffer #239.

Needles and Pins

Sometimes clients ask us to implement scripts that change objects in their schemes. In order to prevent the situation when these scripts hung just because some, or several, objects are pinned. Here are two simple procedures that can help to check what we will get during our maintenance.

Pythian & Oracle Database Appliance in the News

Today was a busy day in the news for Pythian, as Oracle released Oracle Database Appliance. Pythian is now offering fixed-price services to migrate to ODA and support it on an ongoing basis. Small and midsized business can leverage Pythian’s Oracle expertise and take full advantage of the cost and performance advantages of ODA.

Database Appliance for the Masses

I’m an experienced Oracle DBA, I have lots of Linux experience and scores of RAC installations under my belt. I also work for one of the best and more experienced RAC teams in the world. So when a customer asked how long it will take to install 2-node RAC, we answered “2 hours”. It took over 30 hours…

Comparing Oracle Database Appliance and Exadata

Oracle Database Appliance (ODA) is in many ways similar to an Exadata quarter rack: they both use two similar compute servers in an engineered system configuration, with shared storage and flash storage. But in other ways, especially networking and storage, they differ significantly.

Page 80 of 248« First...102030...7879808182...90100110...Last »