100%(8)8 out of 8 people found this document helpful
This preview shows page 2 - 4 out of 5 pages.
Redo Log Files: Max # of logfiles per group = UnlimitedRedo Log File Size: Min size = 4 MBTablespaces: Max # per database = 64 KBigfile Tablespaces: A bigfile tablespace contains only one datafile or tempfile, which can contain up to
DBMS Assigned: ORACLEapproximately 4 billion blocks. The maximum size ofthe single datafile or tempfile is 128 terabytes (TB) for a tablespace with 32 K blocks and 32 TB for a tablespace with 8 K blocks.Smallfile Tablespaces: A smallfile tablespace is a traditional Oracle tablespace, which can contain 1022datafiles or tempfiles, each of which can contain up to approximately 4 million blocksExternal Tables File: Max= Dependent on OSLogicalIndexes: Max per table = Unlimited; Total size of indexed column= 75 % of the database Block Size minus some overheadColumns: Per table= 1000 Max; Per Index= 32 max; per bitmapped index= 30 maxConstraints: Max per column=UnlimitedRows: UnlimitedUsers & Roles: 2,147,483,638Tables: Max per clustered table= 32; max per database= UnlimitedPurchase CostsBelow are examples from the standard price list of the Oracle Website. There is a possibility of discounts once we establishall variablesEnterprise Edition = $47,000Advanced Security = $15,000Advanced Analytics = $23,000Cloud Management Pack for Oracle DB = 7,500Partitioning = 11,500Compression = 11,500AdministrationEvaluate how Oracle and its applications can best usethe available computer resources: disk drive availability, tape drive, available memoryInstall Oracle Database server software and any front end tools and database applications that access the databasePlan how the logical storage structure of the databasewill affect system performance and various database management operationsEnrolling users and maintaining system securitycarry out the backup strategy you planned for the