标题: a small [打印本页] 作者: 拉斯德乌拉 时间: 2015-12-26 05:34:10 标题: a small
at the same time asdisk level striping greatly benefits many Oracle databases, Oracle databases require striping at a more granular level. Unless we will be able to stripe in sizes of not up to the cylinder size for the disk, the disk may have seek contention because the read-write head moves between the cylinders. ?In a perfect world, we'd like to have just a single hot spot on each disk. Carving several hot tablespaces across a small selection of disks would create a situation where the roving hot spots would move between the disks, making an I/O bottleneck whenever two or more hot spots reside at the similar spindle. The goal is to have the active Oracle blocks residing at the similar cylinder or at worst, closely adjacent cylinders to attenuate seek delay at the disk device.Also, beware that imrightfile striping couldcause collisions when the recent spots converge on a single disk. Striping an application tablespace on the filesystem or Oracle level couldcreate a situation where hot spots migrate across spindles, caemployingI/O bottlenecks whenever hot spots seemat the similar spindle.If disk cost isn't a consideration, each hot application or ERP tablespace should reside entidepend on a single spindle. Unfortunately, commercial disks are becoming larger once a year, and that it is rather trickyto seek out small disk devices that contain not up to three gigabytes of storage. Another problem with all kinds of striping is the los angelesck of availskillof small disk spindles. simply10 years ago, the storage disk was considered huge at 1 gigabyte of storage. Today, it's hard to seek out disks smaller than 8 gigabytes. the los angelesrger disks mean thon tlisted here are fewer disk spindles, and less possibilitiesfor striping. because it's occasionallymost unlikelyto isolate ERP tablespaces on separate disks without wasting an enormous quantityof disk space, the Oracle Administrator need tobalance active with inactive ERP tablespace across his or her disks. AlalthoughmaximumOracle DBA associate the striping technique with very large tables, a small, but very active, ERP table will experience relief from bugger busy waits by striping. this system can also be very useful for small ERP reference tables which are simultaneously updated by many transactions. The tables are characterized by a comparatively small selection of rows with a small row length. as a result of the los angelesrge quantityof updating, these tables will experience buffer busy waits, despite the fact thon the datablocks are alin a positionwithin the database buffer cache.Therefore, table striping is the most suitable way to circumvent physical disk I/O contention in addition to it's improving performance bottleneck of your ERP application database.
Improve Oracle Database Performance employingknowledgeFile Striping
??
NBA Jerseys Outlet
NBA Jerseys Sale
Cheap NBA Jerseys
Wholesale NBA Jerseys