Database - RAC/Scalability (MOSC)

MOSC Banner

Concurrent Statistic gathering not possible when connected via service?

edited Feb 15, 2018 10:38AM in Database - RAC/Scalability (MOSC) 2 commentsAnswered

i am trying to speed up the optimzer statistics gathering with the 'concurrency' option. This works fine, when the connection is established using the generic database service or direct connection to an instance,

but not, when connected through a service. Isn't it possible to spawn jobs when connected through a service?

Setup:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

with  "Database Patch Set Update : 12.1.0.2.180116 (26925311)"

RAC

Parameter:

job_queue_processes: 100

resource_manager_plan:default_plan

parallel_force_local=true

select dbms_stats.get_prefs('CONCURRENT') from dual;

DBMS_STATS.GET_PREFS('CONCURRENT')

------------------------------------------------------------------------------------------------------------------------

ALL

service used:

]# srvctl config service -service job_class_xxx1-db xxxtest

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center