摘要：
本章主要就是讲解，Oracle提供了哪些手段让我们的访问速度更快!ObjectivesAfter completing this lesson,you should be able to do the following:Compare and evalate the different storage structuessExamine different data access methodsImplement different partitionion methodsData Storage Structures最最普通的表集群表（将几个相互关联的表，一起放在一个块里面，读写的时候只进 阅读全文
摘要：
Index ReorganizationIndexes on volatile tables are a performance problem.Only entirely empty index blocks go to the free list.If a block contains only one entry,it must be maintained.You may need to rebuild indexes.Monitoring Indexes SpaceTo collect usage statistics regarding an index:(搜集索引的相关数据)SQL 阅读全文
摘要：
Database Block SizeMinimize block visits by:Using a large block sizePacking rows tightlyPreventing row migrationPacking rows tightly与Preventing row migraion是一对矛盾体.如果packing rows tightly过量，就会导致row migration.DB_BLOCK_SIZE ParameterThe database block size:Is defined by the DB_BLOCK_SIZE parameter.Is se 阅读全文
摘要：
Locally Managed ExtentsCreate a locally managed tablespace:(以后所有的表空间管理方式都需要使用Locally managed method)SQL>CREATE TABLESPACE user_data_1DATAFILE '/u01/oradata/sid_name/1m_1.dbf'SIZE 100MEXTENT MANAGEMENT LOCALUNIFORM SIZE 2M;With the Oracle database the default extent management is local.Pro 阅读全文
摘要：
ObjectivesAfter completing this lesson,you should be able to do the following:Use automatic segment space managementUse manual segment space managementDescribe the use of Oracle block parametersRecover space from sparsely populated segmentsDescribe and detect chaining and migration of Oracle blocksP 阅读全文