Posts Categorized: Technical Blog

Temporary Tablespaces: to BIGFILE or Not to BIGFILE

The environment was an Exadata environment undergoing pre-production stress testing. We used Real Application Testing to take a highly-concurrent OLTP workload, and replayed the workload with the synchronization parameter set to FALSE, effectively increasing concurrency beyond the original test system. AWR showed a large volume of buffer busy activity.

Character Set Conversion 10g and 11g – Part 1

This post is the first in a series of discussions … perhaps you have never had the pleasure of needing to change a character set. If you have not and soon do, purchase a good sleeping bag as you may be at the office late for a few days to get the task accomplished.

MySQL Oracle Connect 2012: Day Two

Another interesting day today, I was attending the keynotes and I have found them quite interesting. Specially the way Tweeter use MySQL to build-up a nosql solution, jokes a side I take few notes on things I must analyze and dig in. Interesting one was also the introduction of the Paypal models, which brings me to attend the presentation later on. Presentation was well constructed and with some good theoretical work, but I was quite disappointed, I found the presentation incomplete, and missing real numbers for the MySQL Cluster NDB setup.

Exadata X3H2M2: A Few Thoughts

Tonight at Oracle OpenWorld, Oracle CEO Larry Ellison announced the latest Exadata release: X3. It sports a hardware refresh including a big expansion in RAM and flash storage capacity: 4TB and 22TB respectively on a full rack. Read my thoughts on this here.

MySQL Oracle Connect 2012: Day One

I attend five sessions today and I think some of them were very interesting. Like the one on the Optimizer insight, quite informative and accurate.
The other one done by the MySQL Cluster (NDB) group on the installer and new Javascript API interface, left me a little bit … foggy. Why? Because in my mind one of the most important thing to accomplish in NDB is the correct dimensioning of the memory, buffers, possible operation, attributes and so on, all things that should come from the review of the schema definition review and from the application analysis.

Page 14 of 57« First...1213141516...203040...Last »