Turn off Parallel Query for instance
533034May 22 2008 — edited May 23 2008I have a new 10g RAC instance, on Windows 2003 64, which was just converted from 8i. It is currently a 1 node cluster. The database was built with parallelism turned on and now we are experiencing severe performance degradation. Quest spotlight keeps raising alarms regarding queries being forced to serialize. I have been told it would probably be better to turn parallelism off entirely (this is an OLTP instance). What parms and what settings do I need to set them to in order to shut of parallel query for the instance?