The cost and card values shown in the execution plan are not NOT very high. Hence, no need to fill out TEMP tablespace.

Are you sure that tables and indexes are analyzed with proper estimate?

Take a extended trace data for this query. It will show you the actual temp usage.

Tamil