1001111 Alberta Ltd. There are only 10 kinds of people in the world-- Those who understand binary, and those who don't." [rec.humor.funny]

Service Offerings
1001111 Alberta Ltd is an IT Systems Consultancy specializing in the design and construction of high volume, high availability, data management systems. Our services include systems, network and database design and management including 24 hour on call support.
In addition we have extensive experience with ETL (Extract, Transform, and Load) projects many of which involved porting data from mainframes (EBCDIC) to ASCII character sets on UNIX and MS Windows

Oracle Scripts
Stand Alone Oracle Tuning scripts: The following are two scripts that provide insight into the current level of performance in an oracle database. The great advantage of these scripts is that no objects are created in the SYS or SYSTEM schemas. All calculations are done through inline views and anonymous blocks of PL/SQL.
Short Version Long Version
Oracle Hot Backup Script: This script performs online Oracle hot backups and is usually run as a cronjob. The script runs under the Bourne shell and will function properly in any/all UNIX systems (Tested on SUN/HP/AIX/LINUX). The script is very simple yet comprehensive. Actions taken are:
  • switch archive log
  • for each tablespace
    • start backup mode
    • compress or copy datafiles
    • end backup mode
  • switch archive log
  • copy controlfiles
  • create ASCII text controlfile
  • copy init.ora for the database from $ORACLE_HOME/dbs
  • copy all *.ora from $ORACLE_HOME/network/admin

While backups are done to disk, the original incarnations used tar to dump to tape. Since much of the complexity of backup scripts is due to tape handling requirements new disk hardware has made it feasible to dump databases to a single large disk or array and let the operating system or the backup software deal with tape handling complexity. Extremely useful for mirroring or silvering large arrays.
Oracle Hot Backup Script Hot Backup Environment File

Past Contributions

Assisted in moving 1.2 TB of customer and billing data owned by Epcor Utilities from DB2 on an IBM mainframe to Oracle 10G on HPUX on time and under budget.
Designed the backend for Acculogs a 4 terabyte dataset of Western Canadian well log files.
Implemented an Oracle database/Apache webserver system capable of handling over 1000 concurrent connections, supporting over 600,000 users for Canada's second largest ISP
Technical reviewer for O'Reilly books on the subject of Oracle Parallel Servera
Contributor to the SANS Oracle Security Guide edited by Pete Finnigan
Designed and implemented Oracle Parallel Server on IBM RS6000 HACMP clusters located in Santa Clara, California for Bartertrust.

Contact Us

Phone: 403-399-2442
Email: Sales and Support
Fax: 403-488-5046
Mailing Address: PO Box 971
Calgary, Alberta
T2P 2K4

Valid XHTML 1.0 Transitional Valid CSS!