DB Wiki

User Tools

Site Tools

Trace:
concurrentstatistics

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
concurrentstatistics [2015/08/25 08:42] – [Enabling] z0hpvkconcurrentstatistics [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 20: Line 20:
 /</code> /</code>
 Check it is enabled by issuing the following query\\ Check it is enabled by issuing the following query\\
-<code> SQL> SELECT DBMS_STATS.GET_PREFS('CONCURRENT') FROM DUAL;</code>+<code>SELECT DBMS_STATS.GET_PREFS('CONCURRENT') FROM DUAL;</code>
 After starting a manual or automatic statistics gathering job, you can monitor it 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+<code>SELECT target, target_type, job_name, to_char(start_time, 'DD-MON-YYYY HH24:MI:SS') time_started
 FROM dba_optstat_operation_tasks FROM dba_optstat_operation_tasks
 WHERE status = 'IN PROGRESS' WHERE status = 'IN PROGRESS'
concurrentstatistics.1440492124.txt.gz · Last modified: (external edit)