Hello All, Hope every one is doing good!! I have a question. Can select 1 from dual can cause the Temp tablespace Full ? I see from Toad several sessions of a user executing select 1 from dual causing the Temp space full. Can some one of you put some light on this one. -- Thanks & Regards Nilesh Oracle DBA (sqlplus "/as sysdba" is my world) "As our circle of knowledge expands, so does the circumference of darkness surrounding it."--Einstein "All men die, few men ever truly live" -- Braveheart "You can get help from teachers, but you are going to have to learn a lot by yourself, sitting alone in a room." --Dr. Seuss "Know me for what I do and for not what I am. Judge me for what I can do and not for what I have done."-Unknown "Don't walk in front of me, I may not follow. Don't walk behind me, I may not lead. Just walk beside me and be my friend."- Albert Camus "Never argue with an idiot. They drag you down to their level and then beat you with experience." - Unknown