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 read history TEMP tablespace data or statements that caused rapid growth.

Sultan_AamerFeb 22 2015 — edited Feb 23 2015

We have Oracle XE DB, 11G R2 11.2.0.2.0 on Windows 64.

We face repetitive overgrowth of Temp tablespace.

We need to know the SQL statements that caused the massive growth.

I would like to have you thoughts and expreriences on that.

Thanks a lot in advance.

J A

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 23 2015

Added on Feb 22 2015

#general-database-discussions

4 comments

1,507 views