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
Yup, its a parallel query issue. You (probably) need more TEMP when operating with PQ. If you are not specifying your degree with a hint, you might look at the tables involved. They probably have a degree > 0. To turn PQ off, you can override the default degree with +PARALLEL(table_alias,1).
parallel_query is in v$parameters. Thank you.
Write now user is runing the query in the same way he used to run. The query is running in parallel. if I make the table noparallel now, will there be any effect for the user when the query is running.
If I make the table noparallel will there be any problem by changing the degree from parallel to noparallel.