Re: Database management strategy
Date: Mon, 6 Feb 2012 09:12:20 -0800 (PST)
On Feb 5, 8:22 pm, Yashik Vimal <yashikvi..._at_yahoo.com> wrote:
> Hi there ! I am not a total stranger to database management but at
> the same time neither am i a database expert by any means. I got a
> serious hypothetical question. Assuming i have a Oracle database that
> has been Online for a while and it is slowly running out of physical
> hard disk space. How will anyone approach this issue strategically ?
> Can a single database run on multiple physical Servers ?Appreciate
> your answer in simple and understandable words with less technically
> thks in advance
In addition to Noon's basics, there would be some dependency on what you currently have: Oracle version, platform, storage, data volume and application. If it is more than some arbitrary age or version, long-term (5 years plus) strategic planning would be called for. If it is much more, sometimes throwing everything out and upgrading everything to what is currently hot can make sense.
For example: If you are on 9.2 Oracle, you need to upgrade.
jgReceived on Mon Feb 06 2012 - 11:12:20 CST