{"id":4687,"date":"2023-04-25T13:43:19","date_gmt":"2023-04-25T11:43:19","guid":{"rendered":"https:\/\/www.dbi-services.com\/courses\/oracle-performance-tuning\/"},"modified":"2026-01-13T12:09:23","modified_gmt":"2026-01-13T11:09:23","slug":"oracle-performance-tuning","status":"publish","type":"courses","link":"https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/","title":{"rendered":"Oracle Performance Tuning"},"content":{"rendered":"
\n\n
\"\"<\/figure>\n\n<\/div><\/div><\/section>

Objectifs<\/h2>
\n\n

<\/h2>
  • Comprendre comment Oracle utilise les ressources du syst\u00e8me (CPU, E\/S, m\u00e9moire) et ce qu’il faut v\u00e9rifier lors de la configuration.<\/li>
  • Apprendre comment le Cost-Based-Optimizer (CBO) calcule le chemin d\u2019acc\u00e8s aux donn\u00e9es.<\/li>
  • Ma\u00eetriser les plans d\u2019ex\u00e9cution et les \u00e9tapes de travail correspondantes (balayage des tables, acc\u00e8s aux index, tri \u2026)<\/li>
  • Superviser les performances avec les fonctions des versions Standard et Enterprise (des options de diagnostic aux packs de r\u00e9glage).<\/li>
  • D\u00e9couvrez comment les requ\u00eates peuvent \u00eatre optimis\u00e9es \u00e0 l’aide de fonctions sp\u00e9ciales pour les d\u00e9veloppeurs et\/ou les administrateurs de bases de donn\u00e9es.<\/li>
  • Comprendre les fonctions optionnelles d\u2019Oracle comme Exadata ou In-Memory.<\/li><\/ul>\n\n<\/div><\/div><\/section>

    M\u00e9thode<\/h2>
    \n\n

    <\/h2>
    • Pr\u00e9sentations, exercices pratiques, \u00e9tudes de cas et d\u00e9monstrations orient\u00e9es en fonction des questions<\/li>
    • Discussion et networking durant les pauses et le repas de midi (inclus)<\/li><\/ul>\n\n<\/div><\/div><\/section>

      Cibles<\/h2>
      \n\n

      <\/h2>
      • Cette formation Oracle Performance Tuning s\u2019adresse aux administrateurs de bases de donn\u00e9es souhaitant am\u00e9liorer les performances de leur syst\u00e8me et aux d\u00e9veloppeurs d\u2019applications souhaitant am\u00e9liorer les performances d\u2019applications<\/li><\/ul>\n\n<\/div><\/div><\/section>

        Pr\u00e9requis<\/h2>
        \n\n

        <\/h2>
        • Exp\u00e9rience dans l\u2019administration de bases de donn\u00e9es avec Oracle ou exp\u00e9rience dans le d\u00e9veloppement de logiciels avec Oracle-DB comme syst\u00e8me de gestion de donn\u00e9es<\/li><\/ul>\n\n<\/div><\/div><\/section>

          R\u00e9duction de 5% pour les membres du SOUG, du SwissPUG et de la DOAG.<\/strong><\/p><\/div><\/section>","protected":false},"author":4,"featured_media":8273,"template":"","meta":{"_acf_changed":false},"categories":[35,37],"location":[219,22,21,23],"class_list":["post-4687","courses","type-courses","status-publish","has-post-thumbnail","hentry","category-database","category-oracle","location-bale-2","location-berne","location-nyon","location-zurich"],"acf":[],"yoast_head":"\nOracle Performance Tuning - dbi services<\/title>\n<meta name=\"description\" content=\"D\u00e9couvrez comment optimiser une base de donn\u00e9es et les bonnes pratiques en la mati\u00e8re lors de cette formation Oracle Performance Tuning.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Performance Tuning\" \/>\n<meta property=\"og:description\" content=\"D\u00e9couvrez comment optimiser une base de donn\u00e9es et les bonnes pratiques en la mati\u00e8re lors de cette formation Oracle Performance Tuning.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-13T11:09:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Oracle-Performance-Tuning-Training.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"1200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/\",\"url\":\"https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/\",\"name\":\"Oracle Performance Tuning - dbi services\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Oracle-Performance-Tuning-Training.png\",\"datePublished\":\"2023-04-25T11:43:19+00:00\",\"dateModified\":\"2026-01-13T11:09:23+00:00\",\"description\":\"D\u00e9couvrez comment optimiser une base de donn\u00e9es et les bonnes pratiques en la mati\u00e8re lors de cette formation Oracle Performance Tuning.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Oracle-Performance-Tuning-Training.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Oracle-Performance-Tuning-Training.png\",\"width\":1200,\"height\":1200},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dbi-services.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Formations\",\"item\":\"https:\/\/www.dbi-services.com\/fr\/formations\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Oracle Performance Tuning\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/fr\/\",\"name\":\"dbi services\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi services\",\"url\":\"https:\/\/www.dbi-services.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/06\/dbi-services-by-sequotech-01-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/06\/dbi-services-by-sequotech-01-1.png\",\"width\":3230,\"height\":1100,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/dbiservices\/\",\"https:\/\/x.com\/dbiservices\",\"https:\/\/www.linkedin.com\/company\/dbi-services\/\",\"https:\/\/www.youtube.com\/user\/dbiservices\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle Performance Tuning - dbi services","description":"D\u00e9couvrez comment optimiser une base de donn\u00e9es et les bonnes pratiques en la mati\u00e8re lors de cette formation Oracle Performance Tuning.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/","og_locale":"fr_FR","og_type":"article","og_title":"Oracle Performance Tuning","og_description":"D\u00e9couvrez comment optimiser une base de donn\u00e9es et les bonnes pratiques en la mati\u00e8re lors de cette formation Oracle Performance Tuning.","og_url":"https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/","og_site_name":"dbi services","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_modified_time":"2026-01-13T11:09:23+00:00","og_image":[{"width":1200,"height":1200,"url":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Oracle-Performance-Tuning-Training.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@dbiservices","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/","url":"https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/","name":"Oracle Performance Tuning - dbi services","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Oracle-Performance-Tuning-Training.png","datePublished":"2023-04-25T11:43:19+00:00","dateModified":"2026-01-13T11:09:23+00:00","description":"D\u00e9couvrez comment optimiser une base de donn\u00e9es et les bonnes pratiques en la mati\u00e8re lors de cette formation Oracle Performance Tuning.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/#primaryimage","url":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Oracle-Performance-Tuning-Training.png","contentUrl":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Oracle-Performance-Tuning-Training.png","width":1200,"height":1200},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/fr\/formations\/oracle-performance-tuning\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Formations","item":"https:\/\/www.dbi-services.com\/fr\/formations\/"},{"@type":"ListItem","position":3,"name":"Oracle Performance Tuning"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/fr\/#website","url":"https:\/\/www.dbi-services.com\/fr\/","name":"dbi services","description":"","publisher":{"@id":"https:\/\/www.dbi-services.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/fr\/#organization","name":"dbi services","alternateName":"dbi services","url":"https:\/\/www.dbi-services.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.dbi-services.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/06\/dbi-services-by-sequotech-01-1.png","contentUrl":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/06\/dbi-services-by-sequotech-01-1.png","width":3230,"height":1100,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"]}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/courses\/4687","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/courses"}],"about":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/types\/courses"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/users\/4"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/media\/8273"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/media?parent=4687"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/categories?post=4687"},{"taxonomy":"location","embeddable":true,"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/location?post=4687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}