what should be PCTUSED ???
J_KJul 8 2009 — edited Jul 8 2009hi
what should be PCTUSED ?? higher or lower ???
if higher lets say 70 ,,,so i can insert rows upto 69% ,,,and datablock will store more rows ,,and block will be quicly on freelist if i delete row from it,,,
if lower lets say 30,,, then i can not insert rows if datablock used upto 30% but it will have more freespace ,,block will be quicly off the freelist if i insert row in it
what could be advantage and disadvantage setting this parameter higher or lower ????
Edited by: jignesh kankrecha on Jul 8, 2009 3:52 AM