Many times, we might want to check if Gather Stats ran on the table and when it ran last time. We can find this query dba_tables or user_tables view. let’s see a few queries related to this How to check gather stats on a table col num_rows format 999999990 heading 'ROWS' col avg_row_len format 9990 […]

The post How to check Gather stats on a table in Oracle appeared first on Techgoeasy.