Tag: Oracle

Oracle is not removing InnoDB!

was asked “What’s the deal with Oracle removing InnoDB?”  I had not heard this, so I did some research.  It took less than 5 minutes to figure out what happened, and it was easy to see where the confusion is….

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 >

11G R2: Oracle Cluster SCAN Listeners: Use easy connect naming method

Just recently I came across another unclear error message while troubleshooting an Oracle Instance registration with SCAN Listener. This post is one of the posts which may save quite a bit of time for people who will hit the same issue.

Read More >

OOW10 Bloggers Meetup… and the winners are…

I’m happy to announce the winners of this year’s t-shirt and creative blogger’s contest at the Oracle OpenWorld 2010 Annual Bloggers Meetup. Asif Momen, of the Momen Blog was the big winner of the HP X310 DataVault. Although there wasn’t as much participation as I had hoped for the creative blog post contest we have not one, but two AppleTV winners to announce; Sunil S. Ranka for his post: Mapping the Maze, Online Bloggers to Real World Faces: Pythian Blogger Meetup at OOW10 and Mr. Chet Justice, Oraclenerd for his entertaining, 5 part series from the meetup. Definitely an “A” for effort – could you tell he really wanted the AppleTV?

Read More >

Oracle Net trace in 11G … or build in ITIL

If you ever had tried to switch Oracle net trace than you know that it is quite straight forward to switch it on. You would say that I need to set the following parameters in the sqlnet.ora file…

Read More >

Pythian Official OPN Specializations: Our badges of honour

After over a hundred hours of hard work, Pythian has achieved multiple specializations under our Platinum membership level of the Oracle PartnerNetwork’s OPN Specialized program. We’re proud to be recognized by Oracle as a value-added services partner.

Read More >
Page 61 of 141« First Page...10...5960616263...70...Last Page »