Organising Oracle's tablespaces in ALEPH
Tags: expert
Last Updated: Nov 09, 2009 17:32
- Description
For historical reasons, ALEPH uses different tablespaces in Oracle according to the "Z" table size, in order to avoid a large number of extensions. The "out of the box" configuration can cause the tablespaces to fill unnecessarily, and force us to expand our database needlessly.
This utility analyses the tablespaces and produces a report that helps to reduce the database size and to avoid adding more dbf files. - Author: Dror Berger
- Additional author(s):
- Institution: Beit Ariela Public Library
- Year: 2009
- License: BSD style
- Short description: Use, modification and distribution of the code are permitted provided the copyright notice, list of conditions and disclaimer appear in all related material.
- Link to terms: [Detailed license terms]
- Skill required for using this code:
Choose one of the following: basic, intermediate, advanced, expert. Please also add your choice as a tag at the bottom of the page.
State
Stable
Programming language
gawk under C-shell
Software requirements
GNU Awk 3.1.5 or higher (gawk). This utility is part of RH Linux, and it is likely, but not tested, that the Solaris native awk will suffice.
Not mandatory - Heirloom mailx 12.4 (or any other command line mail utility, with the ability to send attachments)
Screen captures
Author(s) homepage
Download
http://aleph3.libnet.ac.il/codeshare/chknum.tar.gz
Changes
Release notes
This utility should be used by experts only, and a backup of all relevant Z files should exist before relocating them.
The outputs are named chknum.txt and chknum.html
Upon reviewing the report produced by this utility, you must decide which Z tables to relocate. This is done by changing the table's definitions in the appropriate file_list, and rebuilding the table either via manage-08 for tables that hold actual data such as Z30, or by rerunning the appropriate indexing for tables such as Z98.
Installation instructions
1. Unzip and untar the chknum.tar.gz file.
2. The sections that need to be adjusted in chknum and chknum.awk are clearly marked and can be found at the start of the file.
3. Run the utility using command line or via cron.
TO DO list
Divide errors into different categories.
Analyze ALEPH tables such as tab11_word in accordance with the results.
