Oracle Wait Event Explained: Direct Path Read Temp

post date Jun 11, 2009
post author Support in Oracle, Performance Tuning, Response Time Analysis
post date Tweet This
post comments No Comments

This discussion of an Oracle Wait Event comes from James Koopmann of Pinehorse, Inc., an Oracle expert consultant and friend of Confio.
Understanding Oracle Wait Events is important in diagnosing and resolving database performance.  Confio has an extensive … Continue reading →

Invisible Indexes in Oracle 11g

post date May 15, 2009
post author Support in Oracle
post date Tweet This
post comments No Comments

(This guest blog entry contributed by James Koopmann of Pinehorse, Inc., a well known database performance consultant, trainer and speaker, and a friend of Confio.)
Have you ever wished you could create an index that was visible to … Continue reading →

Finding Usable Oracle Database Indexes

post date Apr 29, 2009
post author Support in Database Performance, Oracle, Performance Tuning
post date Tweet This
post comments No Comments

(This guest blog entry contributed by James Koopmann of Pinehorse, Inc., a well known database performance consultant, trainer and speaker, and a friend of Confio.)
The rules of slap-happy data modeling would dictate that we place database indexes … Continue reading →

Extended Optimizer Statistics in 11g

post date Apr 14, 2009
post author Support in Oracle, Performance Tuning
post date Tweet This
post comments No Comments

(This guest blog entry contributed by James Koopmann of Pinehorse, Inc., a well known database performance consultant, trainer and speaker, and a friend of Confio.)
Better execution plans for faster running SQL is a common goal. Unfortunately … Continue reading →

Comparing and Merging Divergent Data; Just Darn Fun!

post date Mar 13, 2009
post author Support in Oracle
post date Tweet This
post comments No Comments

(This guest blog entry contributed by James Koopmann of Pinehorse, Inc., a well known database performance consultant, trainer and speaker, and a friend of Confio.)
Extracting and loading data from one database to another can often leave us … Continue reading →

Looking at Linux Utilization with sar and Oracle’s V$OSSTAT

post date Feb 26, 2009
post author Support in Oracle
post date Tweet This
post comments No Comments

(This guest blog entry contributed by James Koopmann of Pinehorse, Inc., a well known database performance consultant, trainer and speaker, and a friend of Confio.)
With the advent of the new V$OSSTAT view in Oracle, DBAs now have one … Continue reading →

Top Objects finds PK Index

post date Oct 30, 2008
post author Support in Oracle
post date Tweet This
post comments No Comments

(This guest blog entry contributed by Dallas D., a long time Ignite user and expert DBA)
I actually had occasion to use the “top objects” view today, and it was very handy!  I had a insert that was experiencing massive … Continue reading →