{"id":3017,"date":"2022-06-06T19:29:28","date_gmt":"2022-06-06T17:29:28","guid":{"rendered":"https:\/\/devbloomppm.wpengine.com\/?p=3017"},"modified":"2026-08-05T09:43:36","modified_gmt":"2026-08-05T07:43:36","slug":"configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware","status":"publish","type":"post","link":"https:\/\/bloomppm.com\/fr\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\/","title":{"rendered":"Configuration du nombre maximal de sessions d\u2019une base de donn\u00e9es Oracle pour Planisware"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"3017\" class=\"elementor elementor-3017\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-22f5647 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"22f5647\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e69c542\" data-id=\"e69c542\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b2c4aed elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"b2c4aed\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-21e7dc7 elementor-widget elementor-widget-spacer\" data-id=\"21e7dc7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fb764c9 elementor-widget elementor-widget-heading\" data-id=\"fb764c9\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"title1\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-medium\">Introduction<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7c1997c elementor-widget elementor-widget-text-editor\" data-id=\"7c1997c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Lorsque l\u2019on installe un environnement Planisware Server en cluster (plusieurs Intranet Servers) connect\u00e9 \u00e0 un sch\u00e9ma de base de donn\u00e9es Oracle il est utile de v\u00e9rifier que la base Oracle est bien configur\u00e9e pour ce type de fonctionnement. En particulier lorsque l\u2019on a un nombre important d\u2019Intranet Server d\u00e9marr\u00e9s il faut v\u00e9rifier que le nombre maximal de sessions autoris\u00e9es sur la base de donn\u00e9es est bien param\u00e9tr\u00e9.<\/p><p>Services Planisware et interactions avec la base de donn\u00e9es<\/p><p>Les services Planisware communiquent vers la base de donn\u00e9es via le module Planisware Connect. Le module Connect n\u2019\u00e9tablit pas de connexion pour son compte propre mais pour celui des services applicatifs suivants :<\/p><p style=\"padding-left: 40px;\"><strong>\u2192 Intranet Server (ma\u00eetre et esclave)<\/strong><br \/><strong>\u2192 Dispatch<\/strong><br \/><strong>\u2192 TimeCard HTML<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b0956d7 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"b0956d7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7440077 elementor-widget elementor-widget-spacer\" data-id=\"7440077\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-74cdd93 elementor-widget elementor-widget-heading\" data-id=\"74cdd93\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"title2\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-medium\">Estimation du nombre de sessions oracle n\u00e9cessaires au fonctionnement de Planisware<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c78c4d9 elementor-widget elementor-widget-text-editor\" data-id=\"c78c4d9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Il convient de s\u2019interroger sur le nombre de connexions (sessions) \u00e9tablies par chaque processus Planisware avec la base. A titre informatif voici le nombre de sessions oracle ouvertes par type de processus Planisware sur un environnement sous Planisware 5 SP1 :<\/p><p><em>Intranet Server<\/em><\/p><p style=\"padding-left: 40px;\"><strong>\u2192 1 session pour le Watchdog Intranet Server<\/strong><br \/><strong>\u2192 2 sessions par Intranet Server (master ou slave)<\/strong><\/p><p><em>Dispatch<\/em><\/p><p style=\"padding-left: 40px;\"><strong>\u2192 3 sessions pour le Dispatch<\/strong><\/p><p><em>TimeCard HTML<\/em><\/p><p style=\"padding-left: 40px;\"><strong>\u2192 4 sessions par TimeCard HTML (master ou slave)<\/strong><\/p><p><em>Client lourd ou batchs<\/em><\/p><p style=\"padding-left: 40px;\"><strong>\u2192 1 connexion par client lourd ou batch lanc\u00e9<\/strong><\/p><p>A cela se rajouteront les connexions ponctuelles des processus fork\u00e9s (\u00e0 estimer en fonction de l\u2019utilisation des forks dans votre application Planisware).<\/p><p>Ainsi par exemple pour un environnement Planisware avec :<\/p><p style=\"padding-left: 40px;\"><strong>\u2192 1 Dispatch<\/strong><br \/><strong>\u2192 8 IS slaves<\/strong><\/p><p>Le nombre minimum de sessions oracle ouvertes par les services Planisware sera de 3 (Dispatch) + 17 (Intranet Server), soient 20 sessions hors processus fork\u00e9s. Si on estime 1 fork par IS slave dans notre exemple on arrive \u00e0 28 sessions simultan\u00e9es pour les processus Planisware.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7845c04 elementor-widget-divider--view-line_text elementor-widget-divider--element-align-center elementor-widget elementor-widget-divider\" data-id=\"7845c04\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e1f3ff4 elementor-widget elementor-widget-spacer\" data-id=\"e1f3ff4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7e8e3de elementor-widget elementor-widget-heading\" data-id=\"7e8e3de\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"title3\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-medium\">V\u00e9rification du nombre de sessions oracle ouvertes pour une application Planisware en fonctionnement<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e82b3da elementor-widget elementor-widget-text-editor\" data-id=\"e82b3da\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Il est \u00e9galement possible de v\u00e9rifier \u00e0 chaud le nombre de sessions ouvertes par Planisware sur une base. Pour cela il suffira de se connecter avec un utilisateur oracle administrateur de la base (SYSTEM par exemple) et d\u2019ex\u00e9cuter une requ\u00eate SQL du type suivant :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-36ef21a elementor-widget elementor-widget-text-editor\" data-id=\"36ef21a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"color: #993366;\">select * from v$session where MODULE like &amp;#39;%OPX2%&amp;#39;;<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2e26bca elementor-widget elementor-widget-text-editor\" data-id=\"2e26bca\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Cette commande est valable pour un environnement P5 SP3. Elle permettra d\u2019afficher toutes les sessions de base de donn\u00e9es ouvertes par les processus Planisware.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b862749 elementor-widget-divider--view-line_text elementor-widget-divider--element-align-center elementor-widget elementor-widget-divider\" data-id=\"b862749\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7a41127 elementor-widget elementor-widget-spacer\" data-id=\"7a41127\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-037fd7c elementor-widget elementor-widget-heading\" data-id=\"037fd7c\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"title4\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-medium\">V\u00e9rification du param\u00e8tre oracle sur le nombre maxi de sessions de BDD<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ebae902 elementor-widget elementor-widget-text-editor\" data-id=\"ebae902\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Le param\u00e8tre \u00ab\u00a0*.session\u00a0\u00bb initialis\u00e9 au d\u00e9marrage de la base indique le nombre maximal de sessions simultan\u00e9es que la base de donn\u00e9es Oracle va accepter. Au-del\u00e0 toute nouvelle tentative d\u2019acc\u00e8s \u00e0 la base de donn\u00e9es sera refus\u00e9e.<\/p><p>Attention ce param\u00e8tre est un param\u00e8tre global pour toute la base de donn\u00e9es (non sp\u00e9cifique \u00e0 un sch\u00e9ma ou un utilisateur). Ce quota est notamment partag\u00e9 avec les utilisateurs SYS et SYSTEM.<\/p><p>On peut v\u00e9rifier la valeur du param\u00e8tre \u00ab\u00a0*.session\u00a0\u00bb en lisant sa valeur dans le fichier \u00ab\u00a0spfile.ora\u00a0\u00bb de la base.<\/p><p>Ce nombre doit \u00eatre sup\u00e9rieur au nombre de sessions simultan\u00e9es estim\u00e9es pour les services Planisware. Comme indiqu\u00e9 pr\u00e9c\u00e9demment, comme ce param\u00e8tre est valable pour toute la base de donn\u00e9es, on ne doit pas oublier d\u2019inclure les connexions autres que celles de notre environnement Planisware :<\/p><p style=\"padding-left: 40px;\"><strong>\u2192 Sessions syst\u00e8me oracle (SYS et SYSTEM)<\/strong><br \/><strong>\u2192 Acc\u00e8s \u00e0 la base de donn\u00e9es via des outils tels que SQL Developer<\/strong><br \/><strong>\u2192 Acc\u00e8s direct \u00e0 la base via SQLPLUS<\/strong><br \/><strong>\u2192 Autres applications poss\u00e9dant un sch\u00e9ma sur la m\u00eame base<\/strong><br \/><strong>\u2192 \u2026<\/strong><\/p><p>En cas de mauvaise estimation de cette valeur maximum de sessions autoris\u00e9e sur la base de donn\u00e9es on il y aura dysfonctionnement des processus qui tenteront de se connecter \u00e0 la base (refus d\u2019acc\u00e8s \u00e0 la base de donn\u00e9es).<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Calculer le nombre de sessions Oracle consomm\u00e9es par un cluster Planisware et ajuster le param\u00e8tre global.<\/p>\n","protected":false},"author":9,"featured_media":1100,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"left","neve_meta_author_avatar":"","neve_post_elements_order":"[\"meta\",\"thumbnail\",\"content\",\"tags\",\"comments\"]","neve_meta_disable_header":"off","neve_meta_disable_footer":"","neve_meta_disable_title":"","_themeisle_gutenberg_block_has_review":false,"cybocfi_hide_featured_image":"yes","footnotes":""},"categories":[9],"tags":[56],"class_list":["post-3017","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-non-classifiee","tag-planisware"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.5 (Yoast SEO v28.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Sessions Oracle et cluster Planisware<\/title>\n<meta name=\"description\" content=\"Calculer les sessions Oracle consomm\u00e9es par un cluster Planisware et ajuster le param\u00e8tre global dans le spfile.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bloomppm.com\/fr\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\/\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\\\/\"},\"author\":{\"name\":\"Alice Coscia\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#\\\/schema\\\/person\\\/70bfd279f3e18f0eecfa256931542f72\"},\"headline\":\"Configuration du nombre maximal de sessions d\u2019une base de donn\u00e9es Oracle pour Planisware\",\"datePublished\":\"2022-06-06T17:29:28+00:00\",\"dateModified\":\"2026-08-05T07:43:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\\\/\"},\"wordCount\":661,\"publisher\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/bloomppm.com\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/planisware-logo.png\",\"keywords\":[\"Planisware\"],\"articleSection\":[\"Non classifi\u00e9(e)\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\\\/\",\"url\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\\\/\",\"name\":\"Sessions Oracle et cluster Planisware\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/bloomppm.com\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/planisware-logo.png\",\"datePublished\":\"2022-06-06T17:29:28+00:00\",\"dateModified\":\"2026-08-05T07:43:36+00:00\",\"description\":\"Calculer les sessions Oracle consomm\u00e9es par un cluster Planisware et ajuster le param\u00e8tre global dans le spfile.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/bloomppm.com\\\/fr\\\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Configuration du nombre maximal de sessions d\u2019une base de donn\u00e9es Oracle pour Planisware\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#website\",\"url\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/\",\"name\":\"BLOOM PPM\",\"description\":\"We make your projects grow\",\"publisher\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#organization\",\"name\":\"Bloom PPM\",\"url\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/bloomppm.com\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/Blue_without_background.png\",\"contentUrl\":\"https:\\\/\\\/bloomppm.com\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/Blue_without_background.png\",\"width\":602,\"height\":204,\"caption\":\"Bloom PPM\"},\"image\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/bloomppm\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#\\\/schema\\\/person\\\/70bfd279f3e18f0eecfa256931542f72\",\"name\":\"Alice Coscia\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/78e17445df21b4802dbcd0ad4f4999611564d6f76fa19ec43b21aed20cb99a21?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/78e17445df21b4802dbcd0ad4f4999611564d6f76fa19ec43b21aed20cb99a21?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/78e17445df21b4802dbcd0ad4f4999611564d6f76fa19ec43b21aed20cb99a21?s=96&d=mm&r=g\",\"caption\":\"Alice Coscia\"},\"url\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/author\\\/alice-cosciabloomppm-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Sessions Oracle et cluster Planisware","description":"Calculer les sessions Oracle consomm\u00e9es par un cluster Planisware et ajuster le param\u00e8tre global dans le spfile.","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:\/\/bloomppm.com\/fr\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\/","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/bloomppm.com\/fr\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\/#article","isPartOf":{"@id":"https:\/\/bloomppm.com\/fr\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\/"},"author":{"name":"Alice Coscia","@id":"https:\/\/bloomppm.com\/fr\/#\/schema\/person\/70bfd279f3e18f0eecfa256931542f72"},"headline":"Configuration du nombre maximal de sessions d\u2019une base de donn\u00e9es Oracle pour Planisware","datePublished":"2022-06-06T17:29:28+00:00","dateModified":"2026-08-05T07:43:36+00:00","mainEntityOfPage":{"@id":"https:\/\/bloomppm.com\/fr\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\/"},"wordCount":661,"publisher":{"@id":"https:\/\/bloomppm.com\/fr\/#organization"},"image":{"@id":"https:\/\/bloomppm.com\/fr\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\/#primaryimage"},"thumbnailUrl":"https:\/\/bloomppm.com\/wp-content\/uploads\/2020\/10\/planisware-logo.png","keywords":["Planisware"],"articleSection":["Non classifi\u00e9(e)"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/bloomppm.com\/fr\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\/","url":"https:\/\/bloomppm.com\/fr\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\/","name":"Sessions Oracle et cluster Planisware","isPartOf":{"@id":"https:\/\/bloomppm.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bloomppm.com\/fr\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\/#primaryimage"},"image":{"@id":"https:\/\/bloomppm.com\/fr\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\/#primaryimage"},"thumbnailUrl":"https:\/\/bloomppm.com\/wp-content\/uploads\/2020\/10\/planisware-logo.png","datePublished":"2022-06-06T17:29:28+00:00","dateModified":"2026-08-05T07:43:36+00:00","description":"Calculer les sessions Oracle consomm\u00e9es par un cluster Planisware et ajuster le param\u00e8tre global dans le spfile.","breadcrumb":{"@id":"https:\/\/bloomppm.com\/fr\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bloomppm.com\/fr\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/bloomppm.com\/fr\/configuration-du-nombre-maximal-de-sessions-dune-base-de-donnees-oracle-pour-planisware\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bloomppm.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Configuration du nombre maximal de sessions d\u2019une base de donn\u00e9es Oracle pour Planisware"}]},{"@type":"WebSite","@id":"https:\/\/bloomppm.com\/fr\/#website","url":"https:\/\/bloomppm.com\/fr\/","name":"BLOOM PPM","description":"We make your projects grow","publisher":{"@id":"https:\/\/bloomppm.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bloomppm.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/bloomppm.com\/fr\/#organization","name":"Bloom PPM","url":"https:\/\/bloomppm.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/bloomppm.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/bloomppm.com\/wp-content\/uploads\/2020\/10\/Blue_without_background.png","contentUrl":"https:\/\/bloomppm.com\/wp-content\/uploads\/2020\/10\/Blue_without_background.png","width":602,"height":204,"caption":"Bloom PPM"},"image":{"@id":"https:\/\/bloomppm.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/bloomppm\/"]},{"@type":"Person","@id":"https:\/\/bloomppm.com\/fr\/#\/schema\/person\/70bfd279f3e18f0eecfa256931542f72","name":"Alice Coscia","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/78e17445df21b4802dbcd0ad4f4999611564d6f76fa19ec43b21aed20cb99a21?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/78e17445df21b4802dbcd0ad4f4999611564d6f76fa19ec43b21aed20cb99a21?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/78e17445df21b4802dbcd0ad4f4999611564d6f76fa19ec43b21aed20cb99a21?s=96&d=mm&r=g","caption":"Alice Coscia"},"url":"https:\/\/bloomppm.com\/fr\/author\/alice-cosciabloomppm-com\/"}]}},"_links":{"self":[{"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/posts\/3017","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/comments?post=3017"}],"version-history":[{"count":4,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/posts\/3017\/revisions"}],"predecessor-version":[{"id":5457,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/posts\/3017\/revisions\/5457"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/media\/1100"}],"wp:attachment":[{"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/media?parent=3017"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/categories?post=3017"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/tags?post=3017"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}