Oracle parallel query is generally used for data warehousing applications and is not appropriate for Content Platform Engine. Oracle parallel query can cause query execution plans to use table scans instead of the expected database indexes.
For more information, see Slow Content Platform Engine query performance when using Oracle Parallel Query.