Can query V $SORT_USAGE view access to relevant information,
The SEC @ ora10g & gt; Select the username, in tablespace, session_num sid, sqladdr sqlhash, segtype, extents, blocks the from v $sort_usage;

The USERNAME in TABLESPACE SID SQLADDR SQLHASH SEGTYPE EXTENTS BLOCKS
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
The SEC TEMP aec58 DATA of 1 1029988163 389 370 128
The SEC TEMP aec58 INDEX 1 1029988163 389 370 128

Visible on the SEC user created in a temporary table and its indexes are stored in a temporary tablespace TEMP,
When creating the user can specify the user's default temporary table space, so that different users to create a temporary table when you can use their own temporary table space, mutual interference,

CodePudding user response:

to learn

CodePudding user response:

When users less, can consider such use;

CodePudding user response: