One can disable parallel query at a session level by running the following ALTER SESSION statement. You can use this to identify if PARALLEL query is a cause of the problem.

SQL> ALTER SESSION DISABLE PARALLEL QUERY;

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.