Database Tuning (MOSC)

MOSC Banner

Big file tablespace

edited Jul 18, 2010 11:03PM in Database Tuning (MOSC) 3 commentsAnswered
 Hi,

My oracle database version is 10.2.0.4 . OS version is windows 64 bit. It has one
 bigfile tablespaces.Its size is 900 GB. and day by day it is growing. In case of
any failure there could be chances of whole datafile loss. This is the default tablespace of transaction user.  In bigfile tablespace we cannot add another datafile .

So I want to create another tablespace of general smallfile tablespace and change the default tablespace of  transaction user to new smallfile tablespaces.

I want to know if I will change the above is there any performance degradation or any problem ?

Please help..

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center