Re: Database management strategy
Date: Sun, 5 Feb 2012 20:33:12 -0800 (PST)
On Feb 6, 3:22 pm, Yashik Vimal <yashikvi..._at_yahoo.com> wrote:
> 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 ?
There are as many solutions as there is hardware out there.
A few that come to mind and ares relatively simple to implement:
1- Assuming the server hardware can be expanded, then add more disk(s) and/or move existing data to larger disk(s).
2- Clean up - archive/delete - old data and free up the disk space it is using for new data. Requires solid and sound SQL and Oracle DBA knowledge.
3- If this server's use is to be expanded in future, consider using a small SAN device such as Apple's X-Raid or similar. They are cheap and easy to integrate with anything already there.
> Can a single database run on multiple physical Servers ?
Yes. But if your knowledge of Oracle doesn't tell you that already, I strongly suggest you don't go that way unless you are prepared to get some solid external, specialised consultancy.
> your answer in simple and understandable words with less technically
I tried my best. Received on Sun Feb 05 2012 - 22:33:12 CST