| performance hurt after dropping the parititons [message #382491] |
Thu, 22 January 2009 11:32  |
skumar.dba
Messages: 82
Registered: October 2007
|
Member |
|
|
Experts,
we are keeping 13 months data on production and before 13 months on reporting database. after copying data from prod to reporting database, we are dropping data on production.
after dropping the partition on prod we are getting massive performance hit.
i am using this following script
alter table xxxx drop partition xxx_0208 update global indexes;
how to find out where is the problem and rectify this problem
after dropping the partition what are the precaution i need to take care.
i am checking the object status, index status (local/global) on the is table.
stats are update for the current partition. and i ran manual stats collection for entire table.
please kindly help me to find out the problem.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
