Delete indexes to free database.
Transaction: SE11, DB02
用DB02根據Index Usage(DB02>Performance>Indexes>Index Usage),篩選出一些User seeks為0的使用者自定義的Index,用SE11一一刪除,節省出50GB空間.
下一步驟是挑一個空閒日,shrink database 或 shrink datafiles.
等來年空間緊張時,再來得篩選沒人用的SAP的Index.
[@more@]來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/167898/viewspace-1028750/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- How Indexes Grow and PctfreeIndex
- C malloc() free(), C++ new() delete()C++delete
- 從free(p)到delete[]p (轉)delete
- 轉：malloc VS new, free VS deletedelete
- malloc/free 和 new /delete 的區別 (轉)delete
- C++之new、delete 與malloc、free的異同C++delete
- malloc free與new delete的區別和聯絡delete
- standby database to primary database.Database
- new/delete 和malloc/free 的區別一般彙總delete
- Step 11: Back Up the Database. (69)Database
- Rebuild IndexesRebuildIndex
- ORACLE INDEXESOracleIndex
- Oracle - Tables/IndexesOracleIndex
- Reverse Key IndexesIndex
- ORACLE -> NULL & INDEXESOracleNullIndex
- Overview of Partitioned IndexesViewIndex
- Local Partitioned IndexesIndex
- Global Nonpartitioned IndexesIndex
- Extents in Indexes (19)Index
- 翻譯（九）——Clustered Indexes: Stairway to SQL Server Indexes Level 3IndexAISQLServer
- skip_unusable_indexesIndex
- The Secrets of Oracle Bitmap IndexesOracleIndex
- Restrictions on Create Bitmap IndexesRESTIndex
- Global Range Partitioned IndexesIndex
- Global Hash Partitioned IndexesIndex
- Maintenance of Global Partitioned IndexesAINaNIndex
- Overview of Indexes (194)ViewIndex
- Indexes and Nulls (198)IndexNull
- delete input 與 delete all inputdelete
- delete OBSOLETE 與 delete expirieddelete
- deletedelete
- Sparse Indexes vs unique indexIndex
- SKIP_UNUSABLE_INDEXES InitializationIndex
- Choosing Composite IndexesIndex
- 建立Function-Based IndexesFunctionIndex
- Bitmap Indexes and Nulls (224)IndexNull
- Partitioned Indexes on Composite PartitionsIndex
- 慎用 skip_unused_indexesIndex