Home » RDBMS Server » Server Administration » gather statistics on partition table who runs it (Oracle Database 19c Enterprise Edition Release 19.0.0.0.0)
gather statistics on partition table who runs it [message #686621] Fri, 28 October 2022 14:08 Go to next message
wtolentino
Messages: 364
Registered: March 2005
Senior Member
we had big tables and it seems that statistics have been running against it. is there any way to find out who or what jobs runs the gather stats on a table. by just querying the DBA_TAB_STATS_HISTORY we can see the tables that have been analyzed but not who or what jobs that runs it.

this is because we need to control when to run analyzed the big tables. and it is almost like the table is being analyzed everyday.


/forum/fa/14668/0/

please advise. thank you.
Re: gather statistics on partition table who runs it [message #686631 is a reply to message #686621] Wed, 02 November 2022 14:18 Go to previous message
Frank
Messages: 7897
Registered: March 2000
Senior Member
A lot of databases have a nightly maintenance window in which stale statistics are gathered. Check your job schedule?
Previous Topic: XE ORA-12954: The request exceeds the maximum allowed database size of 12 GB
Next Topic: Proxy PDB Connection Fails with Password Error
Goto Forum:
  


Current Time: Sat Jan 28 23:18:52 CST 2023