| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Temporary space
I don't know the answer Enrique.
But an educated guess might be to use the v$temp_space_header_view.
Take a sample couple of your jobs and monitor that view to see what
space I used (non parallel mode). Then re-run the jobs using parallel
2,4,8 (if you have time) and try and quantify what the ratio differences
are.
When you find out let the list know.
My guess is that there will not be a substantial difference apart from some overhead (I am guessing no more than 10% increase in space utilisation when using degree=8)
HTH
John
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Enrique
Fernandez-Pampillon
Sent: 08 September 2005 14:47
To: oracle-l_at_freelists.org
Subject: Temporary space
Does anyone know where to find information related to how increase the necessary temporary space when I increase the parallel degree?
We have a large data warehouse (20Tb). and lately some ORA-01652 have raised when we execute some insert /*+ append */ select.
I have decrease the parallel_query, parallel_dml and parallel_ddl parameters and the insert /*+ append */ takes a long time but it works.
Thank you very much
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 08 2005 - 09:43:16 CDT
 |
 |