with 9i I could keep my DB total memory around 768 meg of ram.. With 10i I am currently at 2 Gig, performance drops off around 1.2 gig or so.. optimum is around 1920 .. Hope this helps the dba some.. But if he thinks he doesn't need this much and thinks he knows better.. all I have to say is "sorry duud, your performance is not getting any better, till he goes". 10.iworks great, but is a memory intensive. hope that helps some..
env 10.2.0.3 on solaris 10, sun fire V240 tell him to use addm ! On 6/19/07, Francois - BTT <[EMAIL PROTECTED]> wrote:
** Hi Shamhoon Did you get any feedback from the list regarding this issue. We experience a similar problem now. Regards Francois *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Jaffaree, Shamhoon *Sent:* 24 April 2007 05:25 PM *To:* arslist@ARSLIST.ORG *Subject:* Slow Performance when migrated from 9i to 10 G ** Did any one experience performance slowness after migrating to 10G from 9i Oracle? We did an upgrade from 9i to 10G with ARS 7.0 and performance has gone down badly. The DBA is investigating with Oracle did any one of you had the same problem. Any information would be helpful. Thanks *Shamhoon Zenath Jaffaree* *Remedy Application Architect* *Tel. 609-520-5890* [EMAIL PROTECTED] __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___
-- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"