storagesummit

Storage for Oracle DB
Storage experts discuss how to get superior performance from your Oracle database.
   10 years ago
#StorageSummitStorage BackupWikibon and storage experts discuss how to meet backup SLAs and reduce costs.
Jeff Frick
What are some of the "easy" things that most dbas miss to increase performance?
Dave Vellante
use a "flash-first" architecture and balance out the storage infrastructure
Jeff Frick Is "Flash First" for new apps, new infrastructure only, or is anyone rolling flash back into older apps/infrastructure? Assume better ROI in former case.
brian bulkowski The number of flash storage offerings will EXPLODE in the next 6 months. At @aerospikedb , I have very interesting beta gear from multiple startups. All blow away @oraclehardware in terms of price - density - iops.
Dave Vellante
here's the difference in efficiency b/tween a traditional cached array and a flash-first architecture in an oracle DB environment http://wikibon.org/w/images/4/44/ZFSFigure3a.jpg
Dave Vellante
one key to storage performance has always been the rate at which a cache can de-stage to the spinning disk backend. With a flash-first architecture the persistent flash medium handles this problem much better than an async trickle to b/end disk
Kerstin Woods
One item is storage visibility - DBAs can use tools like #Oracle #ZFS DTrace to see the DB and VM impact to the storage.
cmosoares
One easy one is data compression. Customer experience with Oracle Database Hybrid Columnar Compression shows resulting improvement in query speeds of 3x-8x.
John Furrier
Question: What does storage efficiency mean?
Tim Crawford
From a technical perspective or from a data management perspective. The answers are vastly different.
John Furrier trying to frame a reference on strategies and tactics so both to be discussed
Dave Vellante great point tim - it also means being able to efficiently manage the storage from a people standpoint
Dave Vellante
it means being able to get as much 'value' out of the storage you pay for (e.g. the % of raw storage you can actually use) - where value is a balance of capacity & perf. based on your application needs
Dave Vellante
so from an oracle DB standpoint efficiency is getting consistent, predictable performance & low management costs with less storage - "doing more w/less"
cmosoares
In other words, lowering over TCO.
John Furrier
Welcome to the oracle Storage Crowdchat. Enter questions or topics and reply in threaded manner. Remember to vote for threads and/or comments that you like; best votes sort to top;
Dave Vellante
Hello everyone - welcome to the chat on best storage practices in Oracle