dbaStreet

dbaStreet blog

Installing Ruby 1.9.2 And Rails 3.1.1 with Oracle 11.2.0.3 on Ubuntu 11.10 Oneiric

Here are the steps to install and configure Ruby on rails with oracle 11.2.0.3 on 32 bit Ubuntu 11.10 Oneiric. First install the pacakges needed by oracle ?View Code BASHsudo apt-get install x11-utils rpm ksh lsb-rpm libaio1 sudo ln -s /usr/include/i386-linux-gnu/sys /usr/include/sys Download the oracle instant client Download the following .zip files from the oracle [...]

Read more...

How to influence the execution plan without modifying the sql from the application

It is likely that all of us have encountered the following situation. Your company runs a packaged application, you get some poorly performing sql, root cause happens to be the bad execution plan. You could battle statistics and see if you can get the optimizer to pick a better plan. One of the options, is [...]

Read more...