Hi,

OEM for locally managed temporary tablespace assigned as temporary tablespace to all users shows used space at 99.7%.

There are no entries in dba_free_space, dba_segments, dba_lmt_free_space & dba_lmt_used_space for this TS.

I think this info is not correct. It is like some HWM. I do not get errors for temp space allocation by quries.

1. How do I see actually how much of temp space is used by all sessions?

2. Is there any way to show correct info in OEM?

Kailash Pareek