Oracle Text – 5 million rows, ADDM insight.
February 19, 2007 1 Comment
Now that the indices are built, Oracle Text query performance is fine with typically sub-second -> second response time observed.
As mentioned previously, at some point, I’m going to have to rebuild these and investigate this crippling index creation but not just yet.
This is a vanilla development 10gR2 install which has given me a short but sweet introduction to ADDM via OEM, as mentioned previously.
OEM homepage > Advisor Central > ADDM
The default on install has given me a week’s worth of AWR snapshots gathered at hourly intervals. Whether this will be enough for most problem resolution depends on the problem and the system. General best practice is to gather statspack snaps at a certain level every 15 minutes. What we’re looking for is for a short enough time period that the problem is significant and identifiable without imposing too large an overhead in terms of storage and performance of doing the snap itself. Jonathan Lewis advocates, in general, a level 0 snap every 15 minutes with a level 5 or greater every hour but with some caveats.
Below are the reports from one particular one-hour period during the six day journey: