DBMS storage capacity

Posted on 2004-11-04
Last Modified: 2013-11-15
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!

Question by:happyprogramming
    LVL 9

    Accepted Solution

    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.
    LVL 44

    Assisted Solution

    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.


    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    A quick step-by-step overview of installing and configuring Carbonite Server Backup.
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
    This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now