 |
|
Oracle Tips by Burleson |
A Look
Into the Future
Anyone paying attention while reading this book
should be coming to a conclusion that disks will soon be relegated to
the job of acting as backing store to massive arrays of solid state
drives. It is an inescapable result of the massive improvements in
memory sizes and huge reductions in memory cost.
Even Oracle, with their moves towards CPU-based
costing and away from I/O based costing models in the cost based
optimizer, can see the writing on the wall: disks will soon be for
backup only with the real power resting in solid state memory based
data storage.
For years, Oracle and other database providers
focused considerable time and money on squeezing the last drop of
performance out of disk arrays. This consisted of tortuously
minimizing I/O path length, reducing code branches, improving the bus
architectures simply because the disks at the end of the chain just
could not get much faster. Now, other users can reap the benefits of
all that work by replacing the spinning rust with SSD.
What will this mean in the future? First, Oracle
and other manufacturers will need to concentrate on the database
internals to fully utilize the power and speed provided by SSD.
Eventually, the entire I/O subsystem will be replaced by the memory
subsystem. Gone will be the host bus adapters, fibre connects, and
other disk related architectures as more efficient methods are
developed for accessing this high speed, high capacity SSD resource.
Future generations of users will ask if mechanical devices were ever
really used to store data.
The
above book excerpt is from:
Oracle
Solid State Disk Tuning
High Performance Oracle
tuning with RAM disk
ISBN
0-9744486-5-6
Donald K. Burleson & Mike Ault
http://www.rampant-books.com/book_2005_1_ssd.htm
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
