PBCS - Restructure cube

2625007 Oct 4, 2018 3:25 PM

Running a PBCS job - to restructure a bso cube daily would not have any negative effect - Is that correct?

( i know it will just delete unnecessary missing blocks if any & defragment the cube)

Thanks in anticipation.

1. Re: PBCS - Restructure cube

JohnGoodwin Oct 4, 2018 3:47 PM (in response to 2625007)

There wouldn't be much point if it had a negative effect though probably best to do it while users are not trying to update data, depending on size of the database and whether dense changes had been made it could take a while to restructure.

Cheers

John
Like Show 0 Likes(0)

Actions
2. Re: PBCS - Restructure cube

2625007 Oct 4, 2018 4:59 PM (in response to JohnGoodwin)

Thanks a lot, John!

Really appreciate your help & guidance always
Like Show 0 Likes(0)

Actions

Join the world’s largest interactive community dedicated to Oracle technologies.