DIFF. BETWEEN tablespace temporary & temporary tablespace

DIFF. BETWEEN tablespace temporary & temporary tablespace

 

  

Hai all,
kindly let me know the folling

1..What is the diff between tablespace temporary and temporary tablespace? What is the advantage?

2..When a SQl hangs which view should be looked into for the reason?

3..When a database is shutdown with immediate or Normal operation it hangs ? What could be the reasons?

Thanks & regards.
Joydeep Roy

Oracle LazyDBA home page