Re: RAC PARALLEL
From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Wed, 26 Oct 2011 00:59:44 +0800
Message-ID: <CAM_ddu9j+=qf=kKd1RXKH13MxHAdNrd=qhmLgkwjbYaM=xQq1Q_at_mail.gmail.com>
because there is plenty of CPU available, to make the delete stable, How about disable the automatic DOP, and manually set the parallel degree in the delete sql?
--
Regards
Sidney Chen
Date: Wed, 26 Oct 2011 00:59:44 +0800
Message-ID: <CAM_ddu9j+=qf=kKd1RXKH13MxHAdNrd=qhmLgkwjbYaM=xQq1Q_at_mail.gmail.com>
because there is plenty of CPU available, to make the delete stable, How about disable the automatic DOP, and manually set the parallel degree in the delete sql?
--
Regards
Sidney Chen
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 25 2011 - 11:59:44 CDT