Tag: Oracle

Physical Disk, Cell Disk, Grid Disk, and ASM Disk in Exadata

This blog post mentions some of very important components of Exadata Storage Server, which are physical disks, cell disks, grid disks and ASM disks and their correspondence.

Read More >

Potential Data Loss Issue on Exadata

I just got an Exadata Customer Advisory e-mail from Oracle, identifying “an important issue that needs your immediate attention” and pointing to MOS note 1265396.1. The only fix is to upgrade to the newly-released version 11.2.2.1.1 of the storage server software.

Read More >

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

Welcome to Log Buffer, the weekly news blog about blogs in the datasphere.

Read More >

Oracle Exadata V1 Documentation is Published

I was searching oracle.com for some Exadata-related wait events, and noticed some hits popping up from formerly closely-held Exadata documentation. Upon closer look, I found the full Exadata V1 user’s guide. I hope the V2 documentation will be posted soon.

Read More >

Exadata Implementation Results: Recordings Available

For those of you who weren’t able to attend my webinar last week “Implementing Exadata: the results are in, recordings are now available here online.

Read More >

Exadata Smart Scans and The Flash Cache

One of the key features of Exadata V2 is the flash cache. Although commonly thought of as an OLTP-specific feature, it has also been marketed as a data warehouse accelerator. According to this frequently-used presentation slide, a full Exadata rack provides 21 GB/sec of disk throughput and 50GB/sec of flash throughput. was testing throughput using a simple query, making use of both smart scans and parallel execution. Here’s what the objects look like. They’re running on a quarter rack system with a stated capacity of 4.5GB/sec disk and 11GB/sec flash.

Read More >

Installer 11.2.0.2 Download Updates Option

The new functionality to download latest patches or either apply saved ones came with installer of Oracle 11.2.0.2 (Software Updates Option) It can be used not only through OUI but with silent installation too. There are several options and variables…

Read More >

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

Welcome to Log Buffer, the weekly roundup of happenings in the database world. Lots to cover this week, so let’s get on with Log Buffer #204. Enjoy!

Read More >

MySQL Troubleshooting for the Obsessive Oracle DBA

One of my favorite customers had a problem. They had to load around 20G of data into a table on MySQL database. The data loaded fine, but when he tried to build few indexes on the database, he got a mysterious error: ERROR 1114 (HY000): The table ‘really_big_table’ is full. The error was mysterious because we had around 1.5T of free space on the disk. Also, if the customer created the indexes before loading the data there was no error. This gave them a work around, but one that slow and annoying. Later, I found out that we are not the first to run into this mystery.

Read More >

Implementing Exadata: The results are in

Following up on my earlier webinar Implementing Oracle Exadata – Strategies for Success, I’ll be giving another webinar to present the results of the Exadata implementation at LinKShare. I’ll be talking about actual performance results, our zero-downtime go-live, compression experiences, and performance tuning in an Exadata environment.

Read More >
Page 67 of 143« First Page...10...6566676869...80...Last Page »