ora-12801 parallel query server
Hi, User is running a sql script which has "create table as select " , "insert into table select", and update statements in one sql script.
The script was executed by user and I can see 1 user in OS but see 4 oracle users running the program each as p000,p001,p002,p003.
can anyone give little input why I can see 4 oracle users. Is that because the queries running in parallel ?? But if it is a script does not it execute one after the other.
User got a error later
ORA - 12801 error signalled in parallel query server p003.
ORA-01652 unable to extend temp segment by 1024 in tablepsace temp.
The temp tablespace is 8G. This is happening because of the process running in parallel.
where is the problem occuring? is that because of parallel queries. what is ultimate solution.
I appriciate your help