My query is failing due to Temp TS (extents getting over). Where can I check the total size allocated for the Tablespace. Checked v$sort_segment to find out that my Tablespace has 358016 total_extents. my db_block_size is 8k and so I presume that my Temp TS is 2.8GB. Checked other views (dba_data_files, dba_free_space, dba_extents) but could not find any info on Temp TS. I also want to find out what filesystem my Temp TS belongs to, before I add. The query eats up the Temp TS very fast (15 minutes) and fails.
Click Here to Expand Forum to Full Width