Database Tuning (MOSC)

MOSC Banner

SQLT providing incorrect information on table stats

edited Sep 6, 2010 3:19AM in Database Tuning (MOSC) 1 commentAnswered

 
Hi,

We installed SQLT and used the XTRACT method passsing on the SQL_ID of the statement we were interested in fine tuning
In the main report section, it reported the following


APP.BROKER_REF
Number of rows equal to zero according to table's CBO statistics
[+] Consider gathering table statistics using DBMS_STATS.GATHER_TABLE_STATS. See Note 465787.1.

TABLE     APP.CONTAINER
Table CBO statistics are 386 days old: 2009-08-13/22:00:36
[+] Consider gathering fresh table statistics with a sample size of at least 100%.

TABLE
APP.ENTITY     Table CBO statistics are 385 days old: 2009-08-14/22:02:00
[-] Consider gathering fresh table statistics with a sample size of at least 100%.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center