Skip to Main content Skip to Navigation
Master Thesis

Migration des bases de données de Oracle 10g vers Oracle 11g et mise en place d’un système de collecte centralisée des métriques des bases de données

Abstract : In an environment that has proved its robustness and efficiency, which runs daily without any major hitch, a change in technology is always a leap into uncharted waters. Therefore, in order to reassure all stakeholders of such a system (that is to say in particular, its users), it is necessary to ensure the non- regression of the change.
When this change of technology relates to the database, the first concern is the performance of queries that are run daily and – often, after a long optimization effort – give perfect satisfaction. Fortunately, Oracle databases offer us (increasingly over the versions) metrics needed to study this regression.
Within AceTP project at BNP Paribas Securities Services, I had the honor to lead a project to upgrade all the databases, and thus create and implement tools to collect and to analyze these metrics. Once the migration is complete, these tools will be reused with the aim of monitoring the production... until the next migration?
Document type :
Master Thesis
Complete list of metadata

https://dumas.ccsd.cnrs.fr/dumas-01143016
Contributor : Cnam - Service Commun de la Documentation - Bibliothèque Centrale <>
Submitted on : Thursday, April 16, 2015 - 2:55:55 PM
Last modification on : Saturday, February 8, 2020 - 12:14:02 PM
Long-term archiving on: : Monday, September 14, 2015 - 9:51:22 AM

Identifiers

  • HAL Id : dumas-01143016, version 1

Collections

Citation

Philippe Lefèvre. Migration des bases de données de Oracle 10g vers Oracle 11g et mise en place d’un système de collecte centralisée des métriques des bases de données. Base de données [cs.DB]. 2014. ⟨dumas-01143016⟩

Share

Metrics

Record views

360

Files downloads

6079