Re: Stats not gathered on all tables with GATHER_STATS_JOB in 10g
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 16 Dec 2005 21:44:45 -0000
Sorry about the empty email - I managed to hit send
a bit too soon.
10g gives you ability to lock stats on an object by
calling a new procedure in the dbms_stats package.
Is it possible that this object's stats have been locked
while empty ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 29th Nov 2005
----- Original Message -----
From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, December 16, 2005 4:40 PM
Subject: Stats not gathered on all tables with GATHER_STATS_JOB in 10g
Hey all,
In 10.1.0.3.0, the GATHER_STATS_JOB has been running for almost a year
now. Everything seems to be running smoothly, except one table has
never has stats gathered -- SYS.SUMDELTA$. I don't see any reason why
stats have never been gathered on this table -- it's a standard table
(e.g. not fixed or secondary, etc).
This is the only table in this DB that has no stats. Thoughts???
Rich
Rich Jesse System/Database Administrator
rich.jesse@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
