文本瑞通过o培训

1、7Copyright 2009, Oracle. All rights reserved.Managing Database Storage StructuresCopyright 2009, Oracle. All rights reserved.7 - 2ObjectivesAfter completing this lesson, you should be able to:Describe the storage of table row data in blocksCreate and manage tablespacesObtain tablespace informationCo

2、pyright 2009, Oracle. All rights reserved.7 - 3How Table Data Is StoredTablespaceTable ATable BSegmentSegmentRowsColumnsTableBlocksRow pieceExtentCopyright 2009, Oracle. All rights reserved.7 - 4Database Block: ContentsBlock headerFree spaceRow dataGrowthCopyright 2009, Oracle. All rights reserved.7

3、 - 5Exploring the Storage StructureClick the links to view detailed information.Copyright 2009, Oracle. All rights reserved.7 - 6Creating a New TablespaceCopyright 2009, Oracle. All rights reserved.7 - 7Creating a New TablespaceChoose the appropriate Storage TypeCopyright 2009, Oracle. All rights re

4、served.7 - 8Storage for TablespacesCopyright 2009, Oracle. All rights reserved.7 - 9Copyright 2009, Oracle. All rights reserved.7 - 10Tablespaces in the Preconfigured DatabaseUNDOTBS1USERSEXAMPLE (optional)SYSTEMSYSAUXTEMPCopyright 2009, Oracle. All rights reserved.7 - 11Copyright 2009, Oracle. All

5、rights reserved.7 - 12Altering a TablespaceCopyright 2009, Oracle. All rights reserved.7 - 13Copyright 2009, Oracle. All rights reserved.7 - 14Actions with TablespacesCopyright 2009, Oracle. All rights reserved.7 - 15Copyright 2009, Oracle. All rights reserved.7 - 16Dropping TablespacesCopyright 200

6、9, Oracle. All rights reserved.7 - 17Viewing Tablespace InformationCopyright 2009, Oracle. All rights reserved.7 - 18Viewing Tablespace ContentsCopyright 2009, Oracle. All rights reserved.7 - 19Oracle-Managed Files (OMF)Specify file operations in terms of database objects rather than file names.Para

7、meterDescriptionDB_CREATE_FILE_DESTDefines the location of the default file system directory for data files and temporary filesDB_CREATE_ONLINE_LOG_DEST_nDefines the location for redo log files and control file creationDB_RECOVERY_FILE_DEST Default location for the fast recovery areaExample: SQL ALT

8、ER SYSTEM SET DB_CREATE_FILE_DEST = +DATA; SQL CREATE TABLESPACE tbs_1;Copyright 2009, Oracle. All rights reserved.7 - 20Copyright 2009, Oracle. All rights reserved.7 - 21Enlarging the DatabaseYou can enlarge the database in the following ways:Creating a new tablespaceAdding a data file to an existi

9、ng smallfile tablespaceIncreasing the size of a data fileProviding for the dynamic growth of a data fileSYSTEM tablespaceINVENTORY tablespaceDatabaseCopyright 2009, Oracle. All rights reserved.7 - 22QuizA database can have a mixture of Oracle-managed and unmanaged files. 1.True 2.False Copyright 200

10、9, Oracle. All rights reserved.7 - 23QuizBigfile Tablespaces must have 1 file of at least 100 MB. 1.True 2.FalseCopyright 2009, Oracle. All rights reserved.7 - 24SummaryIn this lesson, you should have learned how to:Describe the storage of table row data in blocksCreate and manage tablespacesObtain tablespace informationCopyright 2009, Oracle. All rights reserved.7 - 25Practice 7 Overview:Managing Database Storag