DBMS_STATS on RAC

From: steve montgomerie <stmontgo_at_gmail.com>
Date: Thu, 21 Sep 2006 16:47:40 -0400
Message-ID: <5d4504220609211347xb5f6d29m47604ff9547e6d17@mail.gmail.com>

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.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 21 2006 - 15:47:40 CDT