Mar 07, 2012
No Comments
Last week’s webinar had nearly 700 attendees! We had a lot of great questions from the audience. Below is just a sample. If you missed the event or want view it again, here is the link to the recorded webcast, … Continue reading
On January 26th, 2012, Confio presented a live webcast with Bronwyn Altizer, Lead Oracle DBA at Cardinal Health showcasing the recent Exadata deployment at Cardinal Health. Watch recorded webcast. At the end of the presentation there were a number of … Continue reading
Today I had a meeting at a large life insurance company in Denver, CO and learned that Ignite will be replacing a competitive product on both their Oracle and SQL Server platforms. The customer bought the competitive product about a … Continue reading
Server Result Cache
Result Cache is a new feature in Oracle 11g and it does exactly what its name implies, it caches the results of queries and puts it into a slice of the shared pool. If you have … Continue reading
Note: Over-allocated space is a very common problem in many applications where explosive data growth occurs and is not just an Ignite issue. This is just an example of how to do this in an Ignite environment, … Continue reading
Confio Software has an Ignite demo that runs in the cloud and is available at http://demo.confio.com:8123. We wanted to monitor both the Oracle database and the web application itself to make sure it stays up and functional. … Continue reading
I am setting up an Oracle 11g database environment on CentOS linux and ran into the following error from the runInstaller script:
java.lang.UnsatisfiedLinkError: /tmp/OraInstall2009-12-04_01-46-25PM/jdk/jre/lib/i386/xawt/libmawt.so:
Can’t load IA 32-bit.so on a IA 32-bit platform
After a little searching I found the following that … Continue reading
Problem
Some customers have experienced problems with the new Ignite Top Plans feature. The symptoms of the problems are errors in the Ignite error log similar to:
Error retrieving Plan Hashes for batch 1: ORA-12152: TNS:unable to send break … Continue reading
Introduction
Histograms are a feature of the cost-based optimizer (CBO) that allows the Oracle engine to determine how data is distributed within a column. They are most useful for a column that is included in the WHERE clause … Continue reading
Some poor performing queries we run into at customers are ones that involve “IS NULL” criteria similar to:
UPDATE table1
SET col1 = :1
WHERE col1 IS NULL;
UPDATE STATEMENT Optimizer=ALL_ROWS (Cost=144 Card=3 Bytes=195)
UPDATE OF ‘TABLE1′
TABLE ACCESS (FULL) OF ‘TABLE1′ (TABLE) (Cost=144 Card=3 Bytes=195)
Oracle … Continue reading
Twitter Feed
