Originally posted by Orca777
OR is he WORKING IN PARALLEL Query MODE, so one
Query causes many sessions ?
Parallel queries (or parallel DDL operations) do not create any additional sessions during executions. They merely spawn additional processes, but all those processes still run under the same original session. So this can not be the reason for any "MAX_SESSIONS exceeded" errors.