Database Software

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Compress workspace tree takes too long

bicaroroDec 12 2017 — edited Jan 16 2018

Hello,

We are using Workspace Manager in a 11.2.0.3 single database in a linux Box.

We had recently problems when compressing workspaces. It takes too long when doing DBMS_WM.CompressWorkspacetree, five days and more...

We are using: DBMS_WM.CompressWorkspacetree('LIVE',remove_latest_deleted_rows => TRUE);

We believe that it is due to a table that is too big, that it is being processed for days and days. This table contains 20 M rows.

Is there any way to accelerate the compression process?

Help will be appreciated

Regards.

Rob.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 13 2018

Added on Dec 12 2017

#database-key-features, #workspace-manager

2 comments

289 views