Product tip - Increasing disk storage capacity for Solaris-Oracle servers

When configuring Unix file systems for the Oracle DBMS, you should keep in mind that Oracle doesn't create a very large number of data files, but a few very large files instead.

Because of this, it is not necessary to have a great number of bytes per inode (the inode density) for this kind of file system. The default is 2048 bytes per inode. It is very reasonable, for instance, to use 1M Byte (1,048,576 bytes) per inode. This leads to 1788 inodes for a file system of 1.41G Bytes, which is more than sufficient. You can change the inode density parameter using the following command:

# newfs  -i  1048576  'raw-device'

Also, since the Oracle DBMS preallocates disk space, it is not necessary to keep the default 10% of file system free space reservation in order to permit extension of files . It can use a 1% free space reservation, using the following command:

# tunefs -m 1 'filesystem'

About the author: This tip was written by Cesar Joaquim Rodrigues da Silva.

Requires Free Membership to View

This was first published in February 2001

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:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.