Oracle schema, database & system statistics - set to auto gather seems to have stopped auto gathering. What table is the stats actually stored?
Posted on 2006-03-24
Help, It seems like just this week that our production database has quit collecting stats. after our flow is ran.
I'm concerned that space might be low is why.. But not sure. What sys table is stats. stored? How can I check and see if this is the issue.
Use to be when checking and running looking for stale the sql came right back but now it just runs and runs after a flow.
Then refreshes of mviews is taking much longer also.
I need to get the stats back on track.
The only thing I could think of was storage.