|
-
 Originally Posted by gtcol
... also changed the disk (as advised by our IT team)
It is expected to get better performance when you "change the disk", this happens because of when you move from the "bad-old" disk to the "new-good" disk usually you do it by resorting to exp/imp or sqlcopy command or create-table-as-select over a dblink.
In all the above mentioned cases you are actually reorganizing the objects, rebuilding indexes and perhaps gathering fresh statistics. In such an scenario you would get better peformance no matter if you move the data to a "new" disk or if you stay in your "old"one.
Interesting enough, Systems guys usually have a genetic disorder than prevents them for understanding or even acknowledging that fact then they keep suggesting moving to a new-good disk... it works all the time!
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote