Temp usage [message #387876] |
Sat, 21 February 2009 04:02  |
ganeshsv
Messages: 51 Registered: January 2006
|
Member |
|
|
HI,
When we are trying to execute the below DDL statement,it causes temp segment usgae error.
TABLE_TEST table contains 44 million records , all 10 numeric columns.
CREATE TABLE TRY1 AS
SELECT /*+ NOPARALLEL(a) FROM TABLE_TEST a
UNION ALL
SELECT /*+ NOPARALLEL(a) FROM TABLE_TEST a
UNION ALL
SELECT /*+ NOPARALLEL(a) FROM TABLE_TEST a;
This is an existing code.
We just removed the NOPARALLEL hint and this code started working fine (i.e there was no temp usage).
Can you please let know why this NOPARALLEL hint caused the temp usage?
Thanks in advance.
Regds,
GS
|
|
|
|
Re: Temp usage [message #387878 is a reply to message #387877] |
Sat, 21 February 2009 04:11   |
ganeshsv
Messages: 51 Registered: January 2006
|
Member |
|
|
HI,
Apologize. Missed the code.
Here is the complete code
CREATE TABLE TRY1 AS
SELECT /*+ NOPARALLEL(a)*/ col1, col2 FROM TABLE_TEST a
UNION ALL
SELECT /*+ NOPARALLEL(a)*/ col1, col3 FROM TABLE_TEST a
UNION ALL
SELECT /*+ NOPARALLEL(a)*/ col1, col4 FROM TABLE_TEST a
Thanks in advance.
Regds,
GS
|
|
|
Re: Temp usage [message #387894 is a reply to message #387878] |
Sat, 21 February 2009 09:48  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
It is not formatted and we have no idea of what you did to claim what you said.
Also we have no idea of your environment (table parallelism, indexes, statistics, execution plans...)
Regards
Michel
[Updated on: Sat, 21 February 2009 09:48] Report message to a moderator
|
|
|