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:
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 | |||
| |||
|