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!

Anyway to classify active & passive tables

User538816-OCSep 22 2015 — edited Sep 22 2015

Dear Experts,

I would like to classify tables in EBS DB (11.2.0.3.0) in active (tables where frequent DML operations happening(<365days)) and passive (backup, conversion, one time load data tables) for one of the requirement. Please help me is there any way to segregate this.

Note: In few cases same tablespace used for both type of tables & we are collecting GSS for all schemas.

Thanks in advance!

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 20 2015

Added on Sep 22 2015

#general-database-discussions

4 comments

277 views