Geek Articles

Categories

 

Subscribe

Daily Updates Subscribe geekarticles update via email Subscribe geekarticles update via RSS

 
GeekArticles FAQ Oracle FAQ

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

 


Related Articles

 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



Post Comment

Name:


Email:
 (Optional. Used for Notification)

Title:

 
Comment:


Validation Code:
 <=>  (Enter this code in text box)





Latest Articles

 

Popular Articles

Sponsored Links