DBMS storage capacity

For example if i purchase any oracle DBMS, how can i manage my storage is it depends upon my server capacity or DBMS contains storage capacity for instance 100 gigs etc.

Please suggest me to understand!

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

u have choices :
- u can set all your datafiles to fixed size. if some application will requre more space than allocated - it gets an error
- u can set all your datafiles to be autoextend. if some application will require more space than is currently allocated, file grows, until hit limit of OS dataspace.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
However, you should remember that you are ultimately limited by the storage space on the server - the DBMS does not provide independent storage.  If you have a RAID which has a capacity of 120 Gb, then that is the upper limit of the starage capacity of your ORACLE (or SQL Server or...) instances.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.