REASON
1. You can get significant performance in I/O operations on DB
To verify ASYNCH
To verify whether the oracle executable ($ORACLE_HOME/bin/oracle) was linked with asynchronous I/O, run
In the following example, oracle is linked with asynchronous I/O, otherwise you get nothing.
ldd $ORACLE_HOME/bin/oracle | grep libaio
libaio.so.1 => /usr/lib64/libaio.so.1 (0x0000002a96ef7000)
nm $ORACLE_HOME/bin/oracle | grep io_getevent
w io_getevents@@LIBAIO_0.4
Link ASYNCH to oracle, if it is not linked
shutdown all
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk async_on
make -f ins_rdbms.mk ioracle
startup
Even if oracle is linked it doesn’t mean your ASYNCH is ON.
Change parameter in case of block device like RAW
# init.ora
disk_asynch_io = true
or
#spfile
alter system set disk_asynch_io = true scope=spfile;
and if you have file system like ext3 than add this one also
# init.ora
filesystemio_options = asynch
or
#spfile
alter system set filesystemio_options='ASYNCH' scope=both;
Check your job
ASYNCH is ON
cat /proc/slabinfo | grep kio
kioctx 305 360 384 10 1 : tunables 54 27 8 : slabdata 36 36 0
kiocb 255 255 256 15 1 : tunables 120 60 8 : slabdata 17 17 0
Uninstall, Fall back
shutdown all
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk async_off
make -f ins_rdbms.mk ioracle
startup
ASYNCH is OFF
cat /proc/slabinfo | grep kio
kioctx 121 140 384 10 1 : tunables 54 27 8 : slabdata 14 14 0
kiocb 0 0 256 15 1 : tunables 120 60 8 : slabdata 0 0 0
ReplyDeleteشركة كشف تسربات المياه بالرياض
كشف تسربات المياه
شركة كشف تسربات بالرياض
شركة تنظيف بالرياض
شركة تنظيف منازل بالرياض
ِشركة تنظيف شقق بالرياض
ِشركة تنظيف خزانات بالرياض
ِشركة تنظيف مسابح بالرياض
ِشركة تنظيف كنب بالرياض
شركة ابادة الحشرات بالرياض
شركة مكافحة الصراصير بالرياض
شركة مكافحة الفئران بالرياض
شركة مكافحة البق بالرياض
شركة نقل اثاث بالرياض
شركة نقل عفش بالرياض
نقل اثاث
شركة تنظيف كنب بالدمام
شركة تنظيف كنب بالخبر
شركة تنظيف بالدمام
شركة نظافة بالدمام
tory burch outlet, nike air max, uggs on sale, longchamp, nike air max, ray ban sunglasses, tiffany and co, tiffany jewelry, oakley sunglasses, louis vuitton, ugg boots, oakley sunglasses, ugg boots, louboutin outlet, ray ban sunglasses, prada handbags, michael kors, burberry, oakley sunglasses, nike outlet, louis vuitton outlet, louis vuitton, replica watches, michael kors outlet, michael kors outlet, michael kors outlet, nike free, kate spade outlet, chanel handbags, oakley sunglasses, longchamp outlet, longchamp outlet, polo ralph lauren outlet, replica watches, burberry outlet online, prada outlet, ugg boots, louis vuitton, gucci outlet, louboutin, michael kors outlet, louis vuitton outlet, jordan shoes, ugg boots
ReplyDeletelacoste pas cher, nike air max, vans pas cher, replica handbags, mulberry, michael kors, true religion jeans, air jordan pas cher, north face, air max, ralph lauren uk, oakley pas cher, coach outlet, north face, louboutin pas cher, tn pas cher, sac guess, michael kors, coach purses, nike roshe run, hogan, coach outlet, nike free run uk, sac longchamp, hermes, ray ban pas cher, hollister pas cher, kate spade handbags, nike free, vanessa bruno, timberland, nike air max, michael kors, ray ban uk, lululemon, ralph lauren pas cher, burberry, hollister, nike blazer, michael kors, true religion outlet, longchamp pas cher, nike roshe, true religion jeans, new balance pas cher, air force, converse pas cher, nike air max, abercrombie and fitch, true religion jeans
ReplyDeletemoncler, juicy couture outlet, thomas sabo, swarovski crystal, barbour jackets, canada goose outlet, karen millen, canada goose, replica watches, pandora jewelry, ugg,ugg australia,ugg italia, vans, marc jacobs, louis vuitton, louis vuitton, supra shoes, moncler, canada goose, barbour, bottes ugg, ugg pas cher, doudoune canada goose, links of london, moncler, ray ban, louis vuitton, coach outlet, converse outlet, moncler, montre pas cher, sac louis vuitton pas cher, hollister, moncler, lancel, canada goose outlet, pandora charms, louis vuitton, canada goose uk, hollister, moncler outlet, canada goose, doke gabbana outlet, ugg,uggs,uggs canada, pandora jewelry, moncler, moncler, gucci, ugg boots uk, juicy couture outlet, pandora charms, converse, swarovski, wedding dresses
ReplyDeleteferragamo shoes
ReplyDeleteferragamo outlet
ferragamo shoes
ferragamo outlet
rolex watches
rolex watches outlet
rolex watches
tiffany and co
tiffany outlet
tiffany outlet
tiffany and co
longchamp outlet
longchamp handbags
longchamp outlet
true religion jeans
true religion outlet
true religion jeans
true religion jeans sale
fitflops clearance
fitflops uk
fitflops uk
michael kors uk
michael kors outlet uk
tiffany jewellery
tiffany jewelry
beats headphones
beats headphones
oakley sunglasses uk
oakley sunglasses sale
ray ban sunglasses
ray-ban sunglasses
hollister shirts
lululemon uk
rolex watches for sale
mulberry bags
lllllyuan20160601
air jordans
ReplyDeletecanada goose outlet
ugg boots outlet
true religion jeans outlet
discount nike shoes
christian louboutin outlet
cheap nfl jerseys
rolex replica watches for sale
cheap bottom shoes
hollister clothing store
zhi20161126
air jordan shoes
ReplyDeleteadidas tubular
lacoste outlet
longchamp handbags
michael kors outlet online
kyrie 3 shoes
nike roshe uk
michael kors uk
michael kors outlet online
new england patriots jersey
ReplyDeleteفني كهربائي منازل الفروانية
فني كهربائي منازل الاحمدي
فني كهربائي منازل الجهراء
فني كهربائي منازل حولي