Call (800) 766-1884 for Oracle support & training
Free Oracle Tips

Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance

Free Oracle Tips



BC Oracle tuning

Oracle training

Oracle support

Remote Oracle




Donald K. Burleson

Oracle Tips  

Disk Space Availability

More installations are probably messed up due to disk space availability than any other cause. Disk fragmentation doesn’t seem to be a problem under UNIX or NT, however I do suggest you defragment any NT system that has been in operation for extended periods of time prior to the Oracle installation unless you are installing to fresh disks. With most modern systems, disk space is allocated dynamically. This means that as a file needs space, it is granted space wherever it is available on a disk. On active systems, where files are created, updated, and deleted or moved to different disks, this results in fragmentation. This can result in problems for the DBA on NT systems since most aren’t provided with a disk defragmentation tool.

The Oracle DBA User Account 

Other than the ADMINISTRATOR on NT, or the ROOT or SUPERUSER account on UNIX, the Oracle DBA account, usually called ORACLE, will be one of the most powerful accounts on the system. This is required due to the Oracle system being more like an operating system than just a set of executables. In order to start up and shut down, create the required files, and allow global sharing of the kernel and perhaps the tools, the Oracle DBA account needs much broader privileges than a normal user account. The account must have the privilege to create directories, files, and other system objects, as well as the ability to place objects in shared memory.

This is an excerpt by Mike Ault’s book “Oracle Administration & Management”.  If you want more current Oracle tips by Mike Ault, check out his new book “Mike Ault’s Oracle Internals Monitoring & Tuning Scripts” or Ault’s Oracle Scripts Download.




Oracle performance tuning software 

Oracle performance tuning book


Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel
Oracle training & performance tuning books



Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.