Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find the sessions/user consuming more temp tablespace

665881Sep 1 2009 — edited Sep 1 2009

Environment details
IBM-AIX 64 bit
Oracle 10.2.0.4.0

Recently we encountered the issue of sudden peak in CPU utilization and temp tablespace usage. We are noticing this issue after Apr CPU 2009 patch and upgrade to 10.2.0.4.

Recently temp space was full and we added 18 GB of space to temp tablespace, within few hours, they are also consumed.

Application team is telling that they did not modify any code. ADDM report suggests most of the recommendations related to SQL tuning only

not sure about the real issue. Can somebody tell me how I can find what are all sessions/user consuming high temp tablespace

Edited by: user1368801 on Sep 1, 2009 5:32 PM

This post has been answered by Satishbabu Gunukula on Sep 1 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 29 2009

Added on Sep 1 2009

#general-database-discussions, #issue, #performance

2 comments

7,672 views