Re: Partition Drops is effecting performance adversely...

Ravi,

Have you consider using local indexing instead of global indexes? My
1.6T database also uses weekly partitions with local indexes. Several
tables are about 30 million rows per partition or 2 billion rows total.
Stats are collected on the partitions that are loading; older
partition tablespaces are placed into "read only" mode as they age.
Dropping a partition is fast and easy and does not invalidate any
indexes or stored procedures.

Margaret

.

Relevant Pages

  • Re: Total disaster recovery
    ... MS Exchange installation and databases, SBS monitoring and Companyweb. ... The partition was totally lost, all existing backups of this partition also ... I have managed a partial re-installation, with only a new database required ...
    (microsoft.public.exchange.admin)
  • Re: Can I make only 4 partition per hardrive?
    ... >> That is just such bad advice, I scarcely know where to begin... ... so I have the database files on a partition for themselves. ... >dhcp config /etc ...
    (alt.os.linux)
  • Re: Issues with unique object IDs in persistence
    ... the effective footprint by Derby is 0. ... Customer finds program stopped working properly. ... An embedded database can run fine without problems. ... The typical user that even learns of the partition might try reformatting it, probably with catastrophic consequences. ...
    (comp.lang.java.programmer)
  • Re: Moving databases
    ... moving the DBs to that drive? ... Exchange Enterprise 2003 single exchange server setup. ... Log files are located on a seperate partition. ... a offline defrag to shrink the database size. ...
    (microsoft.public.exchange.admin)
  • Re: Seeking understanding of my "gc cr multi block request" waits
    ... people talking openly about having to partition their RAC databases so ... Partitioning affects the database not the instance and certainly not ... Read my response in the original thread. ...
    (comp.databases.oracle.server)