Slide
‹#› of 37
Result
uSystem ran as fast as originally predicted.
ØExtra waits caused by data cases via DBLink were
negligible (less than 0.01/request
- average of 3000 requests/hour).
ØNo time lost writing logs
ØLess I/O à less
sessions à less resources used à less waits à faster response à less sessions …
uUsing a large number of partitions, less chances of creating a “hot block”, since all indexes were
local.
uLessons learned:
ØIn the Oracle environment, everything is linked
together.
ØAny changes can lead to a “domino effect.”
