Ask the Expert

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

What is the recommended size for Oracle data files?

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: