finding the what/when of gathered stats in database
hi,
Is there an SQL for how can I find out if the database is gathering schema stats daily or weekly, is there some scheduler table that gives an idea or do I have to check it in another way?
I'm sort of lost with regards to gather stats because I thought the database does this automatically and no need interfere except on rare occasions when window between gathering stats is insufficient
edit: Oracle 11gR2 Linux 6
thanks