Database Administration (MOSC)

MOSC Banner

finding the what/when of gathered stats in database

edited Jun 11, 2019 4:45PM in Database Administration (MOSC) 5 commentsAnswered ✓

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

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