Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 13 2018
Added on Dec 12 2017
2 comments
183 views