DBMS_STATS on RAC

  • From: "steve montgomerie" <stmontgo@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 21 Sep 2006 16:47:40 -0400

Is there a way for me to do this

DBMS_STATS.GATHER_SCHEMA_STATS(ownname => 'SYSADM',degree=> 8,cascade =>
TRUE );

so that It will run all available nodes/processors of the cluster ?

FYI we are using Wink 2k RAC 9207 with two quad boxes (DELL 6650)

Oracle support says no - that I'd have to somehow break it up.

Other related posts:

  • » DBMS_STATS on RAC