On Thu, Dec 10, 2009 at 6:46 PM, D'Hooge Freek <Freek.DHooge@xxxxxxxxx>wrote: > Jared, > > Thank you for sharing the queries. > But I'm looking for a more general method that is not looking to the > advisory tables. > Reason for this is that I think that the figures in the advisory are pushed > higher because of a query that is executed every 10, 15 minutes and that is > performing a full table scan on a 2 GB (and growing) table. > > Well, that makes sense. The advisors seem to work well enough otherwise. > > ps) The vendor is writing a patch to deal with this problem query. > > Lucky you. I found a similar problem some time back in a product (since acquired by Oracle) that continually ran 3 different queries in the background, all FTS. The solution was to wait for the next version. That reminds me, I should check to see if they actually fixed it. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com