Several factors: - san network utilization - you may consider having different data paths for different table spaces as the need dictates - db network utilization - you may consider having different physical interfaces for different applications as the need dictates - db memory utilization - set the cursor_sharing initialization parameter to similar or force - this will reduce the memory requiremetns on the oracle server to a fraction (~1/10th), esp. for Remedy; I am not sure how well the other applications are designed (in terms of the use of bind variables) - db processor utilization - depending on what these apps do, you may have a lot of i/o or parsing, which eats cpu cycles; it is feasible that you can throw enough horsepower at the db box to meet any needs, assuming you choose an architecture capable of handling additional cpus
Unfortunately, there are too many variables in your question to give a straight yes or no answer. In theory, yes, it can be accomplished, but there are many ways in which you can paint yourself into a corner if you make unwise design decisions or oversights. Axton Grams On Thu, Sep 4, 2008 at 10:02 AM, Mohtashim <[EMAIL PROTECTED]>wrote: > ** > > Hi, > > > > I wonder if experienced consultant could help me with this. I'm interested > in knowing if the following applications data can reside on a centralised > Oracle Database. > > > > BMC CMDB > > BMC TMART > > BMC ARS > > BMC Portal > > BMC Foundation Discovery/BMC Topology Discovery > > BMC Capacity management. > > > > > > If we can utilise a centralised Oracle SAN do we know how to size > the physical Oracle server? > > > > I've got theoretical answers to this question, I would therefore appreciate > any practical solution regarding sizing up of Oracle database catering data > from above mentioned application. > > > > Regards, > > > > *Mohtashim Abbasi* > > Remedy Consultant** > > Technosys UK Limited > > DDI : +44208 429 5954 > > Main: +44208 429 5955 > > Mobile: +447590554781 > > Email: [EMAIL PROTECTED] > > Web: *http://www.technosysuk.com* > > 204 - 226 Imperial Drive > > Rayners Lane, Harrow > > Middlesex HA2 7HH > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"