Differences

This shows you the differences between two versions of the page.

--- concurrentstatistics [2015/08/25 08:36] – z0hpvk
+++ concurrentstatistics [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 19: / Line 19: @@
 END;
 /</code>
+Check it is enabled by issuing the following query\\
+<code>SELECT DBMS_STATS.GET_PREFS('CONCURRENT') FROM DUAL;</code>
+After starting a manual or automatic statistics gathering job, you can monitor it
+<code>SELECT target, target_type, job_name, to_char(start_time, 'DD-MON-YYYY HH24:MI:SS') time_started
+FROM dba_optstat_operation_tasks
+WHERE status = 'IN PROGRESS'
+AND opid = (SELECT max(id) FROM dba_optstat_operations
+            WHERE operation = 'gather_schema_stats');</code>