Re: ra_pages and io rate

hopehope_123 said: > > Obnoxio , > > -No. They way that the two products approach their disk access is > -completely different.. > > What kind of difference exist?( For os level io calls ,when i strace > the oninit and oracle processes , i see they use pread calls .I think > you mention other differences.) > > > -Why would you want to read the entire table in one shot? > > Since this is a datawarehouse , the majority of accesses are full > table scans , hash joins etc. Tables are huge (10gb. 15gb. etc..) So you're never going to read them in one shot, are you? I would honestly advocate that you go on an IDS System Admin course, then performance tuning, then internals. You're obviously not a clueless noob, and I think you'll get the picture much more quickly by attending structured training. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche A smile is a gift that is free to the giver and precious to the recipient. But giving someone the finger is free too, and I find it more personal and sincere. sending to informix-list