I have a query with 6 parallels hint. The query plan shows that 6 parallels are working, but when I check the v$session with the sql id of the query it shows only one session.
How is that possible?
To see this working, head to your live site.
1 Comment
Share Your ThoughtsSign up to leave a comment.
There are many possible causes, such as some of the factors given above, for why you are not running in parallel.
Resource manager,
Other sessions running in parallel
Initialization parameters,
Optimizer costing