Temporary space 2005-09-08 - By Hallas, John, Tech Dev
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@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Enrique
Fernandez-Pampillon
Sent: 08 September 2005 14:47
To: oracle-l@(protected)
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 (See ORA-01652.ora-code.com) 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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
Enrique
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
|
|
