British Gas Service
Investigated and resolved the poor performance of the SCT Customer Information System (SCMS). An overnight batch run, which had to complete within 5 hours, was overrunning due to the slowness of execution and stalling. Worked closely with production DBAs. Was able to achieve significant reductions in run time allowing the batch job to run within the time window.
Hardware Used
- IBM Ahmdale mainframe
- Solaris UNIX boxes
- IBM Compatible PCs
Software Used |
Version |
| IBM MVS
|
|
| Novel Windows
|
|
| Oracle RDBMS
| 7
|
| Explain Plan
|
|
| PL*SQL
|
|
| Pro*C
|
|
| SQL*Plus
|
|
| TKPROF
|
|
| ECO Tools
|
|
|