After upgrade from 10gr2 to 11gr2 some queries are filling the tempfile
Hi Pro,
Although the query is not returning any result (empty) and its running fine on the 10gr2 ,after testing the same query on 11gr2
the temp tablespace become full and raise an error that an uable to extend temp tablespace 128.
I Increased to the temptable space to become 90G but the same problem appear again.
The temptablepace on 10gr2 is only 8G and never received that message
Any way I didn't do a real upgrade to 11gr2 ,but I installed a new 11gr2 and imported the data using impdp.
Any ideas?
Although the query is not returning any result (empty) and its running fine on the 10gr2 ,after testing the same query on 11gr2
the temp tablespace become full and raise an error that an uable to extend temp tablespace 128.
I Increased to the temptable space to become 90G but the same problem appear again.
The temptablepace on 10gr2 is only 8G and never received that message
Any way I didn't do a real upgrade to 11gr2 ,but I installed a new 11gr2 and imported the data using impdp.
Any ideas?
0