利用OracleDatabase12c實現(xiàn)自動化信息生命周期管理課件利用OracleDatabase12c實現(xiàn)自動化信息生命周期管理Oracle系統(tǒng)技術(shù)產(chǎn)品管理高級總監(jiān)KevinJernigan利用OracleDatabase12c實現(xiàn)自動化信息以下內(nèi)容旨在概述產(chǎn)品的總體發(fā)展方向。該內(nèi)容僅供參考，不可納入任何合同。

本演示不承諾提供任何材料、代碼或功能，也不應(yīng)將其作為購買決策的依據(jù)。此處所述有關(guān)Oracle產(chǎn)品的任何特性或功能的開發(fā)、發(fā)布以及相應(yīng)的日程安排均由Oracle自行決定。以下內(nèi)容旨在概述產(chǎn)品的總體發(fā)展方向。該內(nèi)容僅供參考，不可納入議題數(shù)據(jù)增長熱圖自動數(shù)據(jù)優(yōu)化熱圖和ADO的優(yōu)勢議題數(shù)據(jù)增長數(shù)據(jù)多樣性和使用量不斷增加

2011年數(shù)據(jù)量達1,800EB，到2020年將增長20倍

移動到2013年，移動設(shè)備將成為第一大Internet訪問設(shè)備大數(shù)據(jù)

大型客戶數(shù)據(jù)量超過50PB企業(yè)數(shù)據(jù)庫數(shù)據(jù)每年增長45%云80%的新應(yīng)用程序及其數(shù)據(jù)規(guī)制到2015年，

存檔數(shù)據(jù)將達300EB社交業(yè)務(wù)

到2015年，年交易額將達300億當(dāng)今的驅(qū)動力新興的增長因素數(shù)據(jù)多樣性和使用量不斷增加

2011年數(shù)據(jù)量達1,800管理存儲面臨的挑戰(zhàn)在不影響性能的情況下壓縮數(shù)據(jù)在不產(chǎn)生額外成本的情況下管理更多的數(shù)據(jù)根據(jù)使用情況分層和壓縮數(shù)據(jù)管理存儲面臨的挑戰(zhàn)在不影響性能的情況下壓縮數(shù)據(jù)在不產(chǎn)生額外成信息生命周期管理

在其生命周期內(nèi)管理數(shù)據(jù)

“用于從信息構(gòu)建之初到最終處置確保其業(yè)務(wù)價值與最適當(dāng)且經(jīng)濟有效的IT基礎(chǔ)架構(gòu)保持一致的策略、流程、實踐和工具?！?/p>

存儲聯(lián)網(wǎng)行業(yè)協(xié)會(SNIA)數(shù)據(jù)管理論壇$$$總擁有成本(TCO)?$$$高價值中等價值低價值風(fēng)險值信息生命周期管理

在其生命周期內(nèi)管理數(shù)據(jù)

“用于從信息構(gòu)建之?dāng)?shù)據(jù)壓縮減少存儲占用空間，更快速地讀取壓縮數(shù)據(jù)熱數(shù)據(jù)版權(quán)所有

?2012，Oracle和/或其分支機構(gòu)。保留所有權(quán)利。機密－

Oracle保密信息8溫數(shù)據(jù)存檔數(shù)據(jù)1110101010101010011010101010110100010110110001101001010000010011100010101011010010110100101100010100100111110010010000100010101011010001010101011101010011010111000010100010110111010101001010010010000100010101011010010110100111000010100100101000010010000100010101011100110103倍

高級行壓縮1010101011101010011010111000010100010110111010101001010010010000100010101011010010110100111000010100100101000010010000100010101011010011010101011101010011010111000010100010110111010101001010010010000100010101011010010110100111000010100100101000010010000100010101011100110111001100011101010倍

列查詢壓縮10101010111010100110101110000101000101101110101010010100100100001000101010110100101101001110000101001001010000100100001000101010110100110101010111010100110101110000101000101101110101010010100100100001000101010110100101101001110000101001001010000100100001000101010111001101110015倍

列存檔壓縮數(shù)據(jù)壓縮減少存儲占用空間，更快速地讀取壓縮數(shù)據(jù)熱數(shù)據(jù)版權(quán)所有OracleAdvancedCompression

透明、更小、更快100%對應(yīng)用程序透明跨CPU、DRAM、閃存、磁盤和網(wǎng)絡(luò)的端到端成本/性能優(yōu)勢更快地運行：OLTP應(yīng)用（事務(wù)和分析）和DW減少數(shù)據(jù)庫占用空間節(jié)省資本支出和運營支出通過減少數(shù)據(jù)庫在DRAM內(nèi)存中占用的空間來增加云的ROIOracleAdvancedCompression

透明OracleAdvancedCompression

新特性、新特性名稱OracleAdvancedCompressionOracleDatabase11gOracleDatabase12cOLTP壓縮高級行壓縮安全文件壓縮高級LOB壓縮安全文件重復(fù)消除高級LOB重復(fù)消除混合列壓縮混合列壓縮新特性熱圖（對象和行級別）新特性自動數(shù)據(jù)優(yōu)化新特性臨時優(yōu)化OracleAdvancedCompression

新特了解數(shù)據(jù)使用模式

數(shù)據(jù)庫“熱圖”100111101001111011000101101001011000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001100100111001111000100101101001010011000101101001011011100100111001111000100110111001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001000101101001011011100100111001111000000101101001011011100111101001111000100101101001010011100100111001111000100111111001111000100111101001111011100110111001111000100100111001111000100111111001111000100111101001111011100110111001111000100111101001111000111110010011100111100010010011100111101001111010011110100100111001111000100100111001111000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001100100111001111000100101101001010011000101101001011011100100111001111000000101101001011011100111101001111000100101101001010011100100111001111000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000000101101001011011100111101001111000100101101001010011000101101001011011100100111001111000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000000101101001011011100111101001111000100101101001010011000101101001011011100100111001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001000101101001011011100100111001111000100111111001111000100111101001111011100110111001111000100111101001111000100111101001111000100110111001111000100100111001111000100111111001111000100111101001111011100110111001111000了解數(shù)據(jù)使用模式

數(shù)據(jù)庫“熱圖”10011110100111了解數(shù)據(jù)使用模式

數(shù)據(jù)庫“熱圖”100111101001111011000101101001011000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001100100111001111000100101101001010011000101101001011011100100111001111000100110111001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001000101101001011011100100111001111000000101101001011011100111101001111000100101101001010011100100111001111000100111111001111000100111101001111011100110111001111000100100111001111000100111111001111000100111101001111011100110111001111000100111101001111000111110010011100111100010010011100111101001111010011110100100111001111000100100111001111000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001100100111001111000100101101001010011000101101001011011100100111001111000000101101001011011100111101001111000100101101001010011100100111001111000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000000101101001011011100111101001111000100101101001010011000101101001011011100100111001111000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000000101101001011011100111101001111000100101101001010011000101101001011011100100111001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001000101101001011011100100111001111000100111111001111000100111101001111011100110111001111000100111101001111000100111101001111000100110111001111000100100111001111000100111111001111000100111101001111011100110111001111000了解數(shù)據(jù)使用模式

數(shù)據(jù)庫“熱圖”10011110100111熱圖

跟蹤目標(biāo)“熱圖”跟蹤數(shù)據(jù)庫級熱圖展示被使用的表和分區(qū)塊級熱圖展示塊級的最新修改全面性段級同時展示讀取和寫入將索引查詢和全表掃描區(qū)分開來自動排除統(tǒng)計信息收集、DDL、表重定義等高性能無需任何成本的對象級塊級成本<5%活躍頻繁訪問偶爾訪問休眠積極更新不常更新，但頻繁查詢不常查詢也很少更新長期分析和合規(guī)性熱冷熱圖

跟蹤目標(biāo)“熱圖”跟蹤積極更新不常更新，但頻繁查詢不常查熱圖

EnterpriseManager熱圖

EnterpriseManager01011011101010100101001001000010001010101101001011010011100001010010存檔數(shù)據(jù)011100001010001011011101010100101001001000010001010101101001011010101001010010010001自動數(shù)據(jù)優(yōu)化

基于使用情況的數(shù)據(jù)壓縮

版權(quán)所有

?2012，Oracle和/或其分支機構(gòu)。保留所有權(quán)利。機密－

Oracle保密信息15熱數(shù)據(jù)3倍

高級行壓縮溫數(shù)據(jù)10倍

列查詢壓縮100001010010010100101011011100001010101010111010100110101110000101000101101115倍

列存檔壓縮011101010100101000010001010101011100001010111001010010010100101011011101101010101010111010100110101110000101110101100110101010111010100110101110000101000101101110101010010100100100001000101010110100101101001110000101001001010000100100001000101010111001101010100101001001000010001101010101110101001101011100001010001011011101010100101001001000010001010101101001011010011100001010010010100001001000010001010101101001010000101001001010010101101110000101010101011101010011010111000010100010110111010101001010010010000100010101011010010110100111000010100100101000010010000100010101110010100100101001010110111011010101010101110101001101011100001010001011011101010101110101001101011100001011101011001010110111010101001010010010000簡單的聲明式SQL擴展

自動數(shù)據(jù)優(yōu)化

ALTERTABLEsalesILMadd活躍頻繁訪問偶爾訪問休眠

OLTP壓縮（2至4倍）僅影響候選行在DRAM和閃存中緩存rowstorecompressadvancedrowafter2daysofnoupdate數(shù)據(jù)倉庫壓縮（10倍）高性能存儲compressforquerylowafter1weekofnoupdate數(shù)據(jù)倉庫壓縮（10倍）低成本的存儲tiertoSATA

Tablespace存檔壓縮（15至50倍）存檔存儲compressforarchivehighafter6monthsnoaccess簡單的聲明式SQL擴展

自動數(shù)據(jù)優(yōu)化

ALTERTAB自動數(shù)據(jù)優(yōu)化向表添加壓縮和分層策略版權(quán)所有?2012，Oracle和/或其分支機構(gòu)。保留所有權(quán)利。17按時間分區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)如果分區(qū)在30天內(nèi)未修改，則使用行壓縮來壓縮分區(qū)如果分區(qū)在180天內(nèi)未修改，則使用列壓縮來壓縮分區(qū)自動數(shù)據(jù)優(yōu)化向表添加壓縮和分層策略版權(quán)所有?2012，O自動數(shù)據(jù)優(yōu)化跟蹤段和塊活動的熱圖版權(quán)所有?2012，Oracle和/或其分支機構(gòu)。保留所有權(quán)利。18按時間分區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)自動數(shù)據(jù)優(yōu)化跟蹤段和塊活動的熱圖版權(quán)所有?2012，Or自動數(shù)據(jù)優(yōu)化策略會自動應(yīng)用到表版權(quán)所有?2012，Oracle和/或其分支機構(gòu)。保留所有權(quán)利。19按時間分區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)自動數(shù)據(jù)優(yōu)化策略會自動應(yīng)用到表版權(quán)所有?2012，Ora自動數(shù)據(jù)優(yōu)化策略會自動應(yīng)用到表版權(quán)所有?2012，Oracle和/或其分支機構(gòu)。保留所有權(quán)利。20按時間分區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)自動數(shù)據(jù)優(yōu)化策略會自動應(yīng)用到表版權(quán)所有?2012，Ora自動數(shù)據(jù)優(yōu)化策略會自動應(yīng)用到表版權(quán)所有?2012，Oracle和/或其分支機構(gòu)。保留所有權(quán)利。21按時間分區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)自動數(shù)據(jù)優(yōu)化策略會自動應(yīng)用到表版權(quán)所有?2012，Ora自動數(shù)據(jù)優(yōu)化減少存儲占用空間，更快速地讀取壓縮數(shù)據(jù)版權(quán)所有?2012，Oracle和/或其分支機構(gòu)。保留所有權(quán)利。機密－Oracle保密信息22按時間分區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)自動數(shù)據(jù)優(yōu)化減少存儲占用空間，更快速地讀取壓縮數(shù)據(jù)版權(quán)所有自動數(shù)據(jù)優(yōu)化將數(shù)據(jù)自動分層至成本較低的存儲版權(quán)所有?2012，Oracle和/或其分支機構(gòu)。保留所有權(quán)利。23按時間分區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)第1層存儲第2層存儲如果表格空間接近全滿，則使用存檔壓縮將最舊的分區(qū)進行壓縮，并且將其移動至第2層存儲自動數(shù)據(jù)優(yōu)化將數(shù)據(jù)自動分層至成本較低的存儲版權(quán)所有?20自動數(shù)據(jù)優(yōu)化

本季度今年此前幾年針對快速OLTP的行存儲針對快速分析的壓縮列存儲10倍壓縮15倍壓縮數(shù)據(jù)使用逐漸減少后，高級數(shù)據(jù)優(yōu)化會自動將數(shù)據(jù)轉(zhuǎn)換為列壓縮的在線數(shù)據(jù)針對最大壓縮的存檔壓縮列存儲

報表合規(guī)性和報表OLTP自動數(shù)據(jù)優(yōu)化 本季度今年此前幾年針對快速OLTP針對快速強大的策略規(guī)范

自動數(shù)據(jù)優(yōu)化

聲明式策略規(guī)范：條件動作altertablesalesilmaddpolicyrowstorecompressadvancedsegmentafter3daysofnomodification;條件為數(shù)據(jù)創(chuàng)建、訪問、修改后的時段動作為壓縮分層或表格空間分層策略繼承自表格空間或表格新表格繼承自表格空間；也可以應(yīng)用于現(xiàn)有表格新分區(qū)（包括間隔分區(qū)）繼承自表格強大的策略規(guī)范

自動數(shù)據(jù)優(yōu)化

聲明式策略規(guī)范：條件動作最多可將占用空間縮小15倍，加快查詢速度行壓縮和存檔壓縮補充了高級行壓縮最佳實踐：第1步：針對整個DB使用高級行壓縮，然后第2步：更新逐漸減少后，ADO自動將數(shù)據(jù)轉(zhuǎn)換為列壓縮，主要用于報表=>列查詢速度和縮小10倍的占用空間第3步：數(shù)據(jù)使用進一步減少后，ADO自動將其轉(zhuǎn)換為存檔壓縮，不再頻繁查詢 =>占用空間縮小15至50倍針對OLTP的自動數(shù)據(jù)優(yōu)化最多可將占用空間縮小15倍，加快查詢速度行壓縮和存檔壓基于熱圖優(yōu)化數(shù)據(jù)

針對DW的自動數(shù)據(jù)優(yōu)化

數(shù)據(jù)通常通過批量加載進入負載主要來自于查詢，甚至在加載時也是如此

第1步：

批量加載直接進入列壓縮縮小10倍的占用空間，列查詢速度

第2步：

當(dāng)數(shù)據(jù)不常查詢時，ADO自動將其轉(zhuǎn)換為存檔壓縮，并將其移動至成本較低的存儲數(shù)據(jù)保持在線，占用空間縮小15至50倍，同時降低存儲成本基于熱圖優(yōu)化數(shù)據(jù)

針對DW的自動數(shù)據(jù)優(yōu)化

數(shù)據(jù)通常針對列的快速、靈活加載和查詢

采用未壓縮、最快速的列查詢，實現(xiàn)最為快速的加載混合負載通常使用Java應(yīng)用或第3方工具插入并更新不使用批量加載的數(shù)據(jù)，所以不能使用列第1步：加載到未壓縮、常規(guī)插入和更新快速加載，靈活使用常規(guī)OLTP應(yīng)用程序執(zhí)行加載第2步：更新逐漸減少后，ADO會將數(shù)據(jù)移至行壓縮、列壓縮或低成本存儲加快查詢速度，占用空間減少3至10倍自動數(shù)據(jù)優(yōu)化－混合使用針對列的快速、靈活加載和查詢

采用未壓縮、最快速的列查詢，實計劃的策略執(zhí)行

自動數(shù)據(jù)優(yōu)化

即時和后臺策略執(zhí)行策略在維護時段執(zhí)行可以根據(jù)需要手動執(zhí)行策略可以進行擴展，以整合業(yè)務(wù)規(guī)則用戶可以添加自定義條件，以便控制下單 （例如，自訂單發(fā)貨日起3個月內(nèi)）計劃的策略執(zhí)行

自動數(shù)據(jù)優(yōu)化

即時和后臺策略執(zhí)行優(yōu)化的備份

自動移動只讀數(shù)據(jù)SQL>altertableemployeeilmaddpolicytiertoData2READOnLYafter180daysofnomodification優(yōu)化的備份

自動移動只讀數(shù)據(jù)SQL>altertable備份和恢復(fù)

自動數(shù)據(jù)優(yōu)化

讀取/寫入表空間最常讀取的數(shù)據(jù)移動到只讀表空間10倍壓縮15倍壓縮只讀TBS數(shù)據(jù)使用逐漸減少后，自動數(shù)據(jù)優(yōu)化自動將其移至只讀表空間，數(shù)據(jù)備份將在該過程后進行且只備份一次報表合規(guī)性和報表OLTP備份和恢復(fù)

自動數(shù)據(jù)優(yōu)化

讀取/寫入最常讀取的數(shù)據(jù)移動到總結(jié)

熱圖和自動數(shù)據(jù)優(yōu)化熱圖自動跟蹤訪問數(shù)據(jù)庫感知：維護作業(yè)、備份等不影響熱圖自動數(shù)據(jù)優(yōu)化易于使用的聲明式語法，用于定義數(shù)據(jù)壓縮和移動策略可通過特定于業(yè)務(wù)的邏輯進行擴展針對Oracle數(shù)據(jù)庫數(shù)據(jù)自動化和簡化ILM總結(jié)

熱圖和自動數(shù)據(jù)優(yōu)化熱圖利用OracleDatabase12c實現(xiàn)自動化信息生命周期管理課件利用OracleDatabase12c實現(xiàn)自動化信息生命周期管理課件利用OracleDatabase12c實現(xiàn)自動化信息生命周期管理課件利用OracleDatabase12c實現(xiàn)自動化信息生命周期管理Oracle系統(tǒng)技術(shù)產(chǎn)品管理高級總監(jiān)KevinJernigan利用OracleDatabase12c實現(xiàn)自動化信息以下內(nèi)容旨在概述產(chǎn)品的總體發(fā)展方向。該內(nèi)容僅供參考，不可納入任何合同。

本演示不承諾提供任何材料、代碼或功能，也不應(yīng)將其作為購買決策的依據(jù)。此處所述有關(guān)Oracle產(chǎn)品的任何特性或功能的開發(fā)、發(fā)布以及相應(yīng)的日程安排均由Oracle自行決定。以下內(nèi)容旨在概述產(chǎn)品的總體發(fā)展方向。該內(nèi)容僅供參考，不可納入議題數(shù)據(jù)增長熱圖自動數(shù)據(jù)優(yōu)化熱圖和ADO的優(yōu)勢議題數(shù)據(jù)增長數(shù)據(jù)多樣性和使用量不斷增加

2011年數(shù)據(jù)量達1,800EB，到2020年將增長20倍

移動到2013年，移動設(shè)備將成為第一大Internet訪問設(shè)備大數(shù)據(jù)

大型客戶數(shù)據(jù)量超過50PB企業(yè)數(shù)據(jù)庫數(shù)據(jù)每年增長45%云80%的新應(yīng)用程序及其數(shù)據(jù)規(guī)制到2015年，

存檔數(shù)據(jù)將達300EB社交業(yè)務(wù)

到2015年，年交易額將達300億當(dāng)今的驅(qū)動力新興的增長因素數(shù)據(jù)多樣性和使用量不斷增加

2011年數(shù)據(jù)量達1,800管理存儲面臨的挑戰(zhàn)在不影響性能的情況下壓縮數(shù)據(jù)在不產(chǎn)生額外成本的情況下管理更多的數(shù)據(jù)根據(jù)使用情況分層和壓縮數(shù)據(jù)管理存儲面臨的挑戰(zhàn)在不影響性能的情況下壓縮數(shù)據(jù)在不產(chǎn)生額外成信息生命周期管理

在其生命周期內(nèi)管理數(shù)據(jù)

“用于從信息構(gòu)建之初到最終處置確保其業(yè)務(wù)價值與最適當(dāng)且經(jīng)濟有效的IT基礎(chǔ)架構(gòu)保持一致的策略、流程、實踐和工具?！?/p>

存儲聯(lián)網(wǎng)行業(yè)協(xié)會(SNIA)數(shù)據(jù)管理論壇$$$總擁有成本(TCO)?$$$高價值中等價值低價值風(fēng)險值信息生命周期管理

在其生命周期內(nèi)管理數(shù)據(jù)

“用于從信息構(gòu)建之?dāng)?shù)據(jù)壓縮減少存儲占用空間，更快速地讀取壓縮數(shù)據(jù)熱數(shù)據(jù)版權(quán)所有

?2012，Oracle和/或其分支機構(gòu)。保留所有權(quán)利。機密－

Oracle保密信息42溫數(shù)據(jù)存檔數(shù)據(jù)1110101010101010011010101010110100010110110001101001010000010011100010101011010010110100101100010100100111110010010000100010101011010001010101011101010011010111000010100010110111010101001010010010000100010101011010010110100111000010100100101000010010000100010101011100110103倍

高級行壓縮1010101011101010011010111000010100010110111010101001010010010000100010101011010010110100111000010100100101000010010000100010101011010011010101011101010011010111000010100010110111010101001010010010000100010101011010010110100111000010100100101000010010000100010101011100110111001100011101010倍

列查詢壓縮10101010111010100110101110000101000101101110101010010100100100001000101010110100101101001110000101001001010000100100001000101010110100110101010111010100110101110000101000101101110101010010100100100001000101010110100101101001110000101001001010000100100001000101010111001101110015倍

列存檔壓縮數(shù)據(jù)壓縮減少存儲占用空間，更快速地讀取壓縮數(shù)據(jù)熱數(shù)據(jù)版權(quán)所有OracleAdvancedCompression

透明、更小、更快100%對應(yīng)用程序透明跨CPU、DRAM、閃存、磁盤和網(wǎng)絡(luò)的端到端成本/性能優(yōu)勢更快地運行：OLTP應(yīng)用（事務(wù)和分析）和DW減少數(shù)據(jù)庫占用空間節(jié)省資本支出和運營支出通過減少數(shù)據(jù)庫在DRAM內(nèi)存中占用的空間來增加云的ROIOracleAdvancedCompression

透明OracleAdvancedCompression

新特性、新特性名稱OracleAdvancedCompressionOracleDatabase11gOracleDatabase12cOLTP壓縮高級行壓縮安全文件壓縮高級LOB壓縮安全文件重復(fù)消除高級LOB重復(fù)消除混合列壓縮混合列壓縮新特性熱圖（對象和行級別）新特性自動數(shù)據(jù)優(yōu)化新特性臨時優(yōu)化OracleAdvancedCompression

新特了解數(shù)據(jù)使用模式

數(shù)據(jù)庫“熱圖”100111101001111011000101101001011000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001100100111001111000100101101001010011000101101001011011100100111001111000100110111001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001000101101001011011100100111001111000000101101001011011100111101001111000100101101001010011100100111001111000100111111001111000100111101001111011100110111001111000100100111001111000100111111001111000100111101001111011100110111001111000100111101001111000111110010011100111100010010011100111101001111010011110100100111001111000100100111001111000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001100100111001111000100101101001010011000101101001011011100100111001111000000101101001011011100111101001111000100101101001010011100100111001111000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000000101101001011011100111101001111000100101101001010011000101101001011011100100111001111000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000000101101001011011100111101001111000100101101001010011000101101001011011100100111001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001000101101001011011100100111001111000100111111001111000100111101001111011100110111001111000100111101001111000100111101001111000100110111001111000100100111001111000100111111001111000100111101001111011100110111001111000了解數(shù)據(jù)使用模式

數(shù)據(jù)庫“熱圖”10011110100111了解數(shù)據(jù)使用模式

數(shù)據(jù)庫“熱圖”100111101001111011000101101001011000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001100100111001111000100101101001010011000101101001011011100100111001111000100110111001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001000101101001011011100100111001111000000101101001011011100111101001111000100101101001010011100100111001111000100111111001111000100111101001111011100110111001111000100100111001111000100111111001111000100111101001111011100110111001111000100111101001111000111110010011100111100010010011100111101001111010011110100100111001111000100100111001111000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001100100111001111000100101101001010011000101101001011011100100111001111000000101101001011011100111101001111000100101101001010011100100111001111000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000000101101001011011100111101001111000100101101001010011000101101001011011100100111001111000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000000101101001011011100111101001111000100101101001010011000101101001011011100100111001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001000101101001011011100100111001111000100111111001111000100111101001111011100110111001111000100111101001111000100111101001111000100110111001111000100100111001111000100111111001111000100111101001111011100110111001111000了解數(shù)據(jù)使用模式

數(shù)據(jù)庫“熱圖”10011110100111熱圖

跟蹤目標(biāo)“熱圖”跟蹤數(shù)據(jù)庫級熱圖展示被使用的表和分區(qū)塊級熱圖展示塊級的最新修改全面性段級同時展示讀取和寫入將索引查詢和全表掃描區(qū)分開來自動排除統(tǒng)計信息收集、DDL、表重定義等高性能無需任何成本的對象級塊級成本<5%活躍頻繁訪問偶爾訪問休眠積極更新不常更新，但頻繁查詢不常查詢也很少更新長期分析和合規(guī)性熱冷熱圖

跟蹤目標(biāo)“熱圖”跟蹤積極更新不常更新，但頻繁查詢不常查熱圖

EnterpriseManager熱圖

EnterpriseManager01011011101010100101001001000010001010101101001011010011100001010010存檔數(shù)據(jù)011100001010001011011101010100101001001000010001010101101001011010101001010010010001自動數(shù)據(jù)優(yōu)化

基于使用情況的數(shù)據(jù)壓縮

版權(quán)所有

?2012，Oracle和/或其分支機構(gòu)。保留所有權(quán)利。機密－

Oracle保密信息49熱數(shù)據(jù)3倍

高級行壓縮溫數(shù)據(jù)10倍

列查詢壓縮100001010010010100101011011100001010101010111010100110101110000101000101101115倍

列存檔壓縮011101010100101000010001010101011100001010111001010010010100101011011101101010101010111010100110101110000101110101100110101010111010100110101110000101000101101110101010010100100100001000101010110100101101001110000101001001010000100100001000101010111001101010100101001001000010001101010101110101001101011100001010001011011101010100101001001000010001010101101001011010011100001010010010100001001000010001010101101001010000101001001010010101101110000101010101011101010011010111000010100010110111010101001010010010000100010101011010010110100111000010100100101000010010000100010101110010100100101001010110111011010101010101110101001101011100001010001011011101010101110101001101011100001011101011001010110111010101001010010010000簡單的聲明式SQL擴展

自動數(shù)據(jù)優(yōu)化

ALTERTABLEsalesILMadd活躍頻繁訪問偶爾訪問休眠

OLTP壓縮（2至4倍）僅影響候選行在DRAM和閃存中緩存rowstorecompressadvancedrowafter2daysofnoupdate數(shù)據(jù)倉庫壓縮（10倍）高性能存儲compressforquerylowafter1weekofnoupdate數(shù)據(jù)倉庫壓縮（10倍）低成本的存儲tiertoSATA

Tablespace存檔壓縮（15至50倍）存檔存儲compressforarchivehighafter6monthsnoaccess簡單的聲明式SQL擴展

自動數(shù)據(jù)優(yōu)化

ALTERTAB自動數(shù)據(jù)優(yōu)化向表添加壓縮和分層策略版權(quán)所有?2012，Oracle和/或