[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

history tablespace temp usage

Posted on 2016-11-27
2
Medium Priority
?
83 Views
Last Modified: 2016-11-28
Hello,

After restart the database, is it possible to get which query consume excessively  tablespace temp?

Thanks

regards
0
Comment
Question by:bibi92
2 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 2000 total points
ID: 41903106
If you are licensed for the diagnostic pack then try this...

select * from dba_hist_active_sess_history order by temp_space_allocated desc nulls last


see what comes out on top


if you are not, and if you had stats pack collection, you could try looking there.
0
 

Author Closing Comment

by:bibi92
ID: 41903783
Thanks regards
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

640 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question