Learn to add an extra datafile to a tablespace, resize an existing datafile and use autoextend. TechRepublic Improving throughput and availability of your Oracle8i database is one of the prime goals for e-commerce systems. Inc. This is a collection of dozens of Oracle technical papers by Craig A. Shallahamer, Barbara Matthews, Cary Millsap, and others dated from 1994 until present. Topics include fragmentation, migration, storage, tuning, and more. Although not guaranteed to work for your specific environment or to be error-free, these Oracle scripts may increase your speed on a few tasks or at least serve as a good starting point in creating a customized program.
Scripts are available for backup, parameters, query optimization, and more.
This article by Donald Burleson explores partitioning in Oracle8i and presents examples of the coding involved. Optimal physical database design for Oracle8i DBAzine This paper is full of recommendations for Oracle 8i database design and performance improvements. Beginning with a detailed definition of physical database design, Dave Ensor leads you through index organized tables, index compression, and much more. Hotsos Hotsos Enterprises, Ltd Downloads, scripts, and tips devoted to improving Oracle performance. This is an excellent collection of free, original scripts for Oracle DBA's, including ones devoted to tuning, object information, rollback segments, tablespaces, locks, and more.