This forum is currently locked. You can't register or post questions at this time. (read more)

Estimation storage and Memory.

All posts relating to Oracle database administration.

Moderator: Tim...

Kakakoko
Member
Posts: 22
Joined: Mon Dec 02, 2013 5:37 am

Estimation storage and Memory.

Postby Kakakoko » Tue Mar 18, 2014 2:29 pm

Hi,

If the maximum size of database equals 20 terabytes,How much storage space for backing up should be considered?I wanted to know if the maximum size of data equals 20 TB, we need backup storage space 20 TB?
What type of storage do you recommend?(such as Tape,External Hard,Attached Disk ...)


And another question:
The system that oracle running on How much RAM should be have and How much of RAM should be allocate to oracle (in the case of the memory management in SGA is automatic)?
IFU:
the Data Block size is 32 KB.
The more of queries retrieves blob data. The size of blob data are between 4 KB and 100 KB.
A query may retrieves 10,000 blob data.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Estimation storage and Memory.

Postby Tim... » Tue Mar 18, 2014 3:56 pm

Hi.

Wow. This is pretty much impossible to answer because there are so many factors. The only safe answer is, "It depends..."

1) It depends what type of backups you are planning to do. You are going to need at least a full copy of the database, which is 20 terabytes, but what sort of recovery window do you want? How long ago do you want to be able to recover too? If you need to recover to any time in the last month, then you are going to need a lot more space than just recovering to the last know good state.

2) Data Volatility: How much of your data is changing. If it is just a few records a day, then you will approach the backups differently to large percentages of change per day.

3) Downtime: If you are not allowed to have any downtime, your options are different compared to a "load once a week and do cold backup" approach.

4) Backup Location: Disk backups will be quicker, but may be very expensive for large databases. Tapes may be cheaper but slower. Assorted enterprise backup solutions are available. You probably need to speak to some vendors about available solutions and costing.

5) RAM: Allocate approximately 70-80% of your physical RAM to your Oracle instance (SGA+PGA). From there, monitor and adjust. This of course assumes that the only thing running on the machine is Oracle. How much RAM to use? Depends entirely on workload and required performance. Impossible for me to predict.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 3 guests

cron