大型數(shù)據(jù)庫系統(tǒng)分析與設計:Less05-Storage_第1頁
大型數(shù)據(jù)庫系統(tǒng)分析與設計:Less05-Storage_第2頁
大型數(shù)據(jù)庫系統(tǒng)分析與設計:Less05-Storage_第3頁
大型數(shù)據(jù)庫系統(tǒng)分析與設計:Less05-Storage_第4頁
大型數(shù)據(jù)庫系統(tǒng)分析與設計:Less05-Storage_第5頁
已閱讀5頁,還剩21頁未讀, 繼續(xù)免費閱讀

下載本文檔

版權說明:本文檔由用戶提供并上傳,收益歸屬內(nèi)容提供方,若內(nèi)容存在侵權,請進行舉報或認領

文檔簡介

1、Managing Database Storage StructuresObjectivesAfter completing this lesson, you should be able to do the following:Describe how table row data is stored in blocksDefine the purpose of tablespaces and data filesCreate and manage tablespacesObtain tablespace informationDescribe the main concepts and f

2、unctionality of Automatic Storage Management (ASM)Storage StructuresDatabaseTablespaceSegmentExtentOracle datablockLogicalPhysicalOSblockOS fileHow Table Data Is StoredTablespaceTable ATable BSegmentSegmentRowsColumnsTableBlocksRow pieceExtentAnatomy of a Database BlockBlock headerFree spaceRow data

3、GrowthTablespaces and Data FilesThe Oracle database stores data logically in tablespaces and physically in data files.Tablespaces:Can belong to only one databaseConsist of one or more data filesAre further divided into logical units of storageData files:Can belong to only onetablespace and one datab

4、aseAre a repository for schema object dataDatabaseTablespaceData filesSpace Management in TablespacesLocally managed tablespace:Free extents are managed in the tablespace.A bitmap is used to record free extents.Each bit corresponds to a block or group of blocks.The bit value indicates free or used e

5、xtents.The use of locally managed tablespaces is recommended.Dictionary-managed tablespace:Free extents are managed by the data dictionary.Appropriate tables are updated when extents are allocated or unallocated.These tablespaces are supported only for backward compatibility.Creating a New Tablespac

6、eCreating a New Tablespace(Notes Only Slide)Storage for Locally Managed TablespacesStorage for Locally Managed Tablespaces Full Notes PageTablespaces in the Preconfigured DatabaseSYSTEMSYSAUXTEMPUNDOTBS1USERSEXAMPLETablespaces in the Preconfigured Database Full Notes PageAltering a TablespaceAlterin

7、g a Tablespace Full Notes PageAltering a Tablespace Full Notes PageActions with TablespacesActions with TablespacesFull Notes PageDropping TablespacesViewing Tablespace InformationWhere We AreUsing tablespaces to separate dataCreating various types of tablespacesManaging tablespacesObtaining tablesp

8、ace informationDescribe the main concepts and functionality of Automatic Storage Management (ASM)What Is Automatic Storage Management?Is a portable and high-performancecluster file systemManages Oracle database filesSpreads data across disksto balance loadMirrors dataSolves many storage management c

9、hallengesASMFilesystemVolumemanagerApplicationDatabaseOperating systemASM: Key Features and BenefitsStripes files, but not logical volumesProvides online disk reconfiguration and dynamic rebalancingAllows for adjustable rebalancing speedProvides redundancy on a per-file basisSupports only Oracle dat

10、abase filesIs cluster awareIs automatically installedASM: ConceptsDatabaseTablespaceSegmentExtentOracle datablockData filePhysicalblockASM diskASM fileAllocation unitFile systemfileorRaw deviceASMdisk groupSummaryIn this lesson, you should have learned how to:Describe how table row data is stored in blocksDefine the purpose of tablespaces and data filesCreate and manage tablespacesObtain tablespace informationDescribe the main concepts and functionality of ASM, such as:Disk mirroringDynamic rebalancingAS

溫馨提示

  • 1. 本站所有資源如無特殊說明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
  • 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請聯(lián)系上傳者。文件的所有權益歸上傳用戶所有。
  • 3. 本站RAR壓縮包中若帶圖紙,網(wǎng)頁內(nèi)容里面會有圖紙預覽,若沒有圖紙預覽就沒有圖紙。
  • 4. 未經(jīng)權益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
  • 5. 人人文庫網(wǎng)僅提供信息存儲空間,僅對用戶上傳內(nèi)容的表現(xiàn)方式做保護處理,對用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對任何下載內(nèi)容負責。
  • 6. 下載文件中如有侵權或不適當內(nèi)容,請與我們聯(lián)系,我們立即糾正。
  • 7. 本站不保證下載資源的準確性、安全性和完整性, 同時也不承擔用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。

評論

0/150

提交評論