Category Archives: Uncategorized

Most recent version here(updated). Added these two: display_results(test_name,compared_to_test_name) – output results of testings in the two scenarios.  List results from all queries that ran more than 3 times as long with one test or the other.  Also summarize results with … Continue reading →

Quick update to package from previous post. Here is the zip of the download: zip(updated) I added these procs to collect select statements on a source production database and to copy them back (as clobs) to the test database: collect_select_statements(max_number_selects, … Continue reading →

I’ve uploaded this package(updated) that I’m using to test some large select statements.  See the file packagedescriptionv1.txt for a description of the package.  Also, test.sql and test.log is an example of using the package. This is an updated version of … Continue reading →

This weekend we had the most convincing evidence that our change from dedicated to shared servers on a database that supports a farm of web servers was the right move.  We have had some outages on the weekend caused by … Continue reading →

I’m trying to test some select statements that have some lines longer than 4000 characters and I couldn’t get them to run in sqlplus so I built this proc to run a select statement that is stored in a CLOB … Continue reading →

One of our senior developers found a way to greatly improve the performance of a query by adding a dynamic sampling hint for a table that had multiple correlated conditions in its where clause.  This led me to try to … Continue reading →

So, this isn’t really Oracle related except that I got a new Windows 7 laptop to support Oracle and I’m getting an annoying popup message every time I try to run putty to access a database server. I looked up … Continue reading →

So, I had to get a new work laptop to install Oracle 12c.  I was on Windows XP and even though I knew my company would have paid for me to get a new one a long time ago I … Continue reading →

We are running the Oracle delivered automatic optimizer stats job on some of our 11.2 Oracle databases and the job is not completing for some of our tables.  But, the list of these tables is buried in a trace file … Continue reading →

In two previous posts I’ve discussed the possibility of switching from the default dedicated server configuration to shared servers to support a large web farm. The original post I decribed how Tom Kyte recommended a Youtube video that champions reducing … Continue reading →