My Oracle Support Banner

Query Regarding Tablespace Configuartion (Doc ID 2452344.1)

Last updated on JUNE 25, 2019

Applies to:

Oracle FLEXCUBE Universal Banking - Version 12.0.87.1.0 and later
Information in this document applies to any platform.

Goal

As per best practice document, there are multiple tablespaces in which the tables are to be divided in the database.

Now, some tablespaces are getting full rapidly whereas some have lot of space and very few tables.

Bank is concerned if this design is correct as there is lot of unused space.
Attached is the current configuration and usage in production

1. Is is better to use only 1 tablespace instead of so many?
2. How can LOB data be handled if multiple tablespaces are used?


 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.