Q

What is the recommended size of Oracle data files for SAP?

This expert tip provides tips on how to restrict Oracle data file sizes for maximum SAP performance.

What is the recommended size for Oracle data files?
It's impossible to give you a simple answer to this question. Generally, the data files size has no effect on activities in the database. However, you should keep the following points in mind:

• If you keep the data files smaller, they can be individually restored more quickly during a backup.

• The smaller the data files are, the more data files there are; thus, the longer BEGIN BACKUP operations are likely to take in online backups.

• Data files that are too large aggravate performance problems that are caused by inode locking (When you change a block in a file, operating systems set an exclusive lock on the file, which means that you cannot make a parallel change to the same data. On UNIX, this lock is also called an inode lock).

• Set the DB_FILES Oracle parameter to a high value. Otherwise, new data files cannot be created once this limit is reached.

• When there is a large number of data files and, at the same time, operating system resources are not adequately configured, critical errors such as "file table overflow" can occur, which may cause the database to crash.

In general, it seems a good idea to restrict data file sizes to between 2GB and 20GB.

This was first published in October 2008

Dig deeper on SAP application integration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close