Re: SEGMENT STATISTICS not populating, STATISTICS_LEVEL=TYPICAL
- From: Peter Hitchman <pjhoraclel@xxxxxxxxx>
- To: pdthedba@xxxxxxxxx
- Date: Fri, 5 Aug 2011 20:44:34 +0100
Hi,
I tried this with 11.2.0.2 with the same statistics setting and I get
the same result. I wonder if this is because sys.col_usage$ is some
kind of "special" object.
What sort of table are you looking at in your application schema that
has the FTS?
By the way this post from Jonathan Lewis indicates that AWR does not
report segment scans -
http://jonathanlewis.wordpress.com/segment-scans/
Regards
Pete
--
//www.freelists.org/webpage/oracle-l
Other related posts:
