|
-
Hi,
The top of your Temp-Ts allocates Blocks is the High-Water-Mark.
This means that the place could be free for new transaction even it is allocated.
You can monitor which SQL uses the temp-Ts actuall.
Recreating Temp will not help you.
You have to identify and tune the SQL's which fill the Temp-Ts
Orca
SELECT /*+ORDERED*/su.tablespace,
se.sid,
se.user#,
se.serial#,
su.blocks,
su.segtype,
sa.sql_text
FROM v$sort_usage su
,v$sqlarea sa
,v$session se
WHERE su.session_addr = se.saddr
AND se.sql_address = sa.address(+)
/
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|