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شركة كشف تسربات المياه بالرياض
كشف تسربات المياه
شركة كشف تسربات بالرياض
شركة تنظيف بالرياض
شركة تنظيف منازل بالرياض
ِشركة تنظيف شقق بالرياض
ِشركة تنظيف خزانات بالرياض
ِشركة تنظيف مسابح بالرياض
ِشركة تنظيف كنب بالرياض
شركة ابادة الحشرات بالرياض
شركة مكافحة الصراصير بالرياض
شركة مكافحة الفئران بالرياض
شركة مكافحة البق بالرياض
شركة نقل اثاث بالرياض
شركة نقل عفش بالرياض
نقل اثاث
شركة تنظيف كنب بالدمام
شركة تنظيف كنب بالخبر
شركة تنظيف بالدمام
شركة نظافة بالدمام
baby oil
ReplyDeletepan
plate
rice ladle
bucket
glass
basin
powder
lotion
spoon
watch
shoe
slippers
tire
egg
hat
cigarette
hangers
veil
strange people
crazy
dish rack
helmets
doll
shampoo
soap
bread
cake
cheese
chicken
bra
shorts
bag
book
scissors
knife
towel
cable
roof tile
flower
balm
light
car
scissors
ashtray
fan
stove
sheath
broom
duster
baby oil
pan
plate
rice ladle
bucket
glass
basin
powder
lotion
spoon
watch
shoe
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
ReplyDeletebottega veneta, ferragamo shoes, timberland boots, oakley, soccer jerseys, wedding dresses, herve leger, nike air max, chi flat iron, instyler, mcm handbags, lululemon, nike huarache, baseball bats, ralph lauren, hollister, asics running shoes, iphone cases, mac cosmetics, hollister, insanity workout, ipad cases, valentino shoes, iphone 6s cases, jimmy choo shoes, north face outlet, nfl jerseys, iphone 6 plus cases, iphone 6s plus cases, ghd, iphone 6 cases, babyliss, nike roshe, abercrombie and fitch, soccer shoes, celine handbags, north face outlet, giuseppe zanotti, nike trainers, louboutin, beats by dre, new balance, mont blanc, s5 cases, vans shoes, birkin bag, iphone 5s cases, longchamp, p90x workout, reebok shoes
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
20160914 junda
ReplyDeletelouis vuitton handbags
reebok outlet store
ray ban sunglasses
true religion jeans
true religion jeans
true religion sale
michael kors handbags
toms shoes
mulberry bags
hermes outlet
ugg boots
hollister clothing
toms shoes
louis vuitton outlet
christian louboutin outlet
michael kors outlet online
ugg sale
ferragamo outlet
swarovski crystal
air max 90
coach outlet
louis vuitton pas cher
cheap nhl jerseys
coach outlet store
michael kors handbags
michael kors bags
nike outlet store
cheap uggs
coach outlet
replica watches
nike air max uk
christian louboutin online
ralph lauren polo shirts
longchamp pas cher
canada goose jackets
michael kors outlet online
michael kors wallet
ray ban sunglasses
burberry outlet
tory burch shoes
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فني كهربائي منازل الفروانية
فني كهربائي منازل الاحمدي
فني كهربائي منازل الجهراء
فني كهربائي منازل حولي