Drop or Rebuild Indexes with MANY MANY extents

Author: asktom.oracle.com | Published: 4th Feb 2008 | Visited: 100 times | Add Comment
Filed in: Oracle FAQ

Hi Tom, We are upgrading an 8174 database to 10203 and doing some maintenance beforehand. I discovered a partitioned table with 4 locally parititoned indexes. The table is OK but the index partitions were created mainly with 16k extents. The lar...

Read Article

Sponsored Links

• Toatl free space and largest extents Hi Tom, I am new to this blog. I have one doubt regarding fragmentation. select TABLESPACE_NAME, sum(BYTES), max(BYTES) from dba_free_space group by TABLESPACE_NAME; If we give this query we will get sum(BYTES)- ...

• Implement Drag and Drop in Your Windows Forms Applications Find out how to empower your users by supporting drag and drop features in your Windows Forms applicati ...

• Drag and Drop on a Windows Form How to insert an image on a form in runtime mode, dragging it to the right position and by using a database retrieve the position and shape when starting the application up a ...

• Drop Down menu in Silverlight 2 Drop Down menu using popup control in Silverlig ...

• Customizable ComboBox Drop-Down A combobox control with a customizable drop-d ...

• Indexes on single Partition of the table I have a table which has been partitioned by the months.Also in the same table i have an indexes in 4 columns. I used partition as we will be loading the data everymonth. We will be having around 9 million rows everymonth. While inserting the rows ...

• Jigsaw Puzzle Game using Ajax Drag and Drop (ASP.NET 2.0 AJAX Futures November CTP) Jigsaw Puzzle Game using Ajax Drag and Drop (ASP.NET 2.0 AJAX Futures November ...

• Implementing Drag Drop Operations for browser based WPF Applications (XBAP) Simple implementation of Drag and Drop operation without full trust require ...

• Dynamically adjusting the size of a drop-down list and adding color to the back-ground and fore-grou... To adjust the size of the drop-down list dynamically at the client-side and adding back-ground and fore-ground color to the drop-down l ...

• Working with CSS Background Images?Part 3: Creating Background Images with a Drop Shadow Create cool background images in Fireworks and put them in your pages with Dreamwea ...

Next: OLTP table structure