Defragmentation for ASO cubes — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Defragmentation for ASO cubes

edited Aug 2, 2018 2:36AM in Essbase 1 comment

Summary

Defragmentation for ASO cubes

Content

Hi All,

 

We need ASO cubes to be defragmented, to achieve it we tried the following steps,

 

1. Export the data >> Clear the data in the cube >> Reload the data.

2. Export the data >> Clear the data in the cube >> Compact the outline >> Reload the data.

 

but the above steps dint bring the cache hit-ratio to 1.

 

Anyone please let us know the procedure for ASO Defrag.

 

Is it advisable to run defrag ASO cube.

 

Thanks,

William

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!