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?
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