Database Administration (MOSC)

MOSC Banner

Temp tablespace usage details

edited Nov 19, 2017 4:04AM in Database Administration (MOSC) 5 commentsAnswered

Hi All

Yesterday one of my critical production database temp table space usage was high and got full  between 10 to 11am usage during that time. we need to find why sql queries or sql_id which is consuming more temp usage during that time. i'm looking for  sql query to find temp usage during that time . could someone help me on this.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center