sqlplus test/test@pdb11
ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = 'DEFAULT_PLAN';
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=8;
SHOW PARAMETER PROCESSES;
BEGIN
DBMS_STATS.SET_GLOBAL_PREFS('CONCURRENT','ALL');
END;
/
SELECT DBMS_STATS.GET_PREFS('CONCURRENT') FROM DUAL;
EXEC DBMS_STATS.GATHER_SCHEMA_STATS('SH');
EXEC DBMS_STATS.SET_GLOBAL_PREFS('CONCURRENT','OFF');
SELECT DBMS_STATS.GET_PREFS('CONCURRENT') FROM DUAL;
-- 別セッション
SET LINESIZE 1000
COLUMN TARGET FORMAT a8
COLUMN TARGET_TYPE FORMAT a25
COLUMN JOB_NAME FORMAT a14
COLUMN START_TIME FORMAT a40
SELECT TARGET, TARGET_TYPE, JOB_NAME,
TO_CHAR(START_TIME, 'dd-mon-yyyy hh24:mi:ss')
FROM DBA_OPTSTAT_OPERATION_TASKS
WHERE STATUS = 'IN PROGRESS'
AND OPID = (SELECT MAX(ID)
FROM DBA_OPTSTAT_OPERATIONS
WHERE OPERATION = 'gather_schema_stats');
