93%(29)27 out of 29 people found this document helpful
This preview shows page 1 - 4 out of 7 pages.
Running head: IT 204 MILESTONE FOUR 1IT 204 Milestone FourChristian Gregory CarsonSouthern New Hampshire UniversityAssigned DBMS: Oracle
IT 204 MILESTONE FOUR 2Data Size LimitsVarious data type limits include:•BFILE – 4GB (This is a data type used to store a link to a file stored outside of the database. The maximum size is up to 4GB, although this is operating system specific).•BLOB – 4GB – 1 (A binary large object is a data type that can hold up to 4GB of data. This is useful for storing digitized information like images, video, and audio).•CLOB – 4GB – 1 (A character large object is a data type that can hold up to 4 GB of data,and is useful for storing text. The number of LOB columns per table is only limited by the maximum number of columns per table, which is 1000).•CHAR – 2000 bytes (CHAR is a data type which is used to store fixed-length character data).•Literal – 4000 characters (A literal can be a number, character, or string).•NCHAR – 2000 bytes per row, or 2000 characters (NCHAR is a fixed length data type which can be used to store national language support or multibyte character set data).•Number - +/-(38 9’s) x10^125•Precision – 38 significant digits•VARCHAR2 – 4000 bytes (VARCHAR2 is a data type used to store variable-length character data).•VARCHAR – 4000 bytes (Same as VARCHAR2, however this should not be used as it is reserved for future usage).A lot of the physical database item limits are based upon operating system. If you would like to increase those limits, it is recommended to license another processor. Some of these limits thatare dependent on operating systems include:•Database Block Size•Controlfiles•Database files•Database file size•Redo log file size•External tables file
IT 204 MILESTONE FOUR 3Different logical database limits include:•Indexes – Maximum per table (Unlimited), total size of indexed column (75% of the database block size minus some overhead).•Columns – Per table (1000 columns), per index (32 columns), per bitmapped index (30 columns).•Constraints – Maximum per column (unlimited)•Rows – Maximum number per table (unlimited)•Users and Roles – 2,147,483,638•Tables – Maximum per clustered table (32 tables), maximum per database (unlimited).