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 idenitfy who's filling up DATA1 TABLESPACE.

Veera_VNov 8 2014 — edited Nov 8 2014

DB:11.2.0.3

2 node RAC - Data files resides on ASM disk group

Usage of DATA1 tablespace was increated to 20GB suddenly. How to check who/which objects used it.

I checked the application tables and its tables growth was similar to last 1 week.

No New objects created - [based on dba_objects].

Please advise.

-Veera

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 6 2014

Added on Nov 8 2014

#general-database-discussions

4 comments

1,078 views