DB Wiki

User Tools

Site Tools

Trace: • sqlplus
concurrentstatistics

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
concurrentstatistics [2015/08/25 09:05] – [Enabling] z0hpvkconcurrentstatistics [2015/08/25 09:06] (current) – [Enabling] z0hpvk
Line 22: Line 22:
 <code>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.1440493536.txt.gz · Last modified: (external edit)