Database Administration (MOSC)

MOSC Banner

Temp tablespace monitoring: how to find which query is take more space in temp tablespace than other

Hello,

I am trying to find out which query is taking more temp space, I have following query which is returning no results,

select u.username, s.sql_fulltext, u.segtype, u.extents, u.blocks from v$tempseg_usage u, v$sql s where s.sql_id = u.sql_id;

I found this on web, was expecting result, but v$tempseg_usage is empty. Is there any setting by which we can have data in v$tempseg_usage.

My oracle version is 19c and x64 win server2019 is h/w configuration.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center