profiles
From: Andreas Photiou <azpe0_at_eng.amdahl.com>
Date: 1995/05/18
Message-ID: <1995May18.231705.13314_at_ccc.amdahl.com>#1/1
Date: 1995/05/18
Message-ID: <1995May18.231705.13314_at_ccc.amdahl.com>#1/1
I am working on profiles on Oracle using a parallel server on sparc m/c.
Even though my sessions_per_user are equal or more than the actual sessions of that user still it qives me an error. Here is the query. I set the sessions_per_user to 1.
SQL> select /*+ parallel(a,8,1) full(a) */ count(*) from main ;
ERROR:
ORA-12801: error signaled in parallel query server P003
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit, maximum 1
Does the parallel server create extra sessions and so how many?
thanks andreas
azpe0_at_eng.amdahl.com
Received on Thu May 18 1995 - 00:00:00 CEST