Re: Database management strategy

From: Noons <>
Date: Sun, 5 Feb 2012 20:33:12 -0800 (PST)
Message-ID: <>

On Feb 6, 3:22 pm, Yashik Vimal <> 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.

> Appreciate
> your answer in simple and understandable words with less technically

I tried my best. Received on Sun Feb 05 2012 - 22:33:12 CST

Original text of this message