Q
Problem solve Get help with specific problems with your technologies, process and projects.

Advantages to placing APO cubes in their own tablespace

Are there any advantages to placing your APO cubes in their own tablespace?

You have two advantages in placing your cubes (or any other database segment) in their own tablespace. First, you can move that object easily to balance I/O among different physical disk drives. It is harder to do that if the object is in a tablespace with other objects.

Second, you can perform backup and recovery operations on just this object much easier than if the object is in a tablespace with other objects.

The biggest downside to this approach is that you do not want to have too many tablespaces as to make the database difficult to manage.


Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close