{"id":7901,"date":"2017-07-12T00:38:04","date_gmt":"2017-07-11T22:38:04","guid":{"rendered":"http:\/\/arumel.com\/?p=7901\/"},"modified":"2017-07-13T16:57:23","modified_gmt":"2017-07-13T14:57:23","slug":"stored-outlines-en-standard-edition","status":"publish","type":"post","link":"https:\/\/arumel.com\/es\/stored-outlines-en-standard-edition\/","title":{"rendered":"Stored Outlines en Standard Edition"},"content":{"rendered":"<h1><span style=\"color: #000000;\">\u00bfPuedo usar Stored Outlines con una Standard Edition?<\/span><\/h1>\n<p><span style=\"text-decoration: underline;\"><strong>S\u00cd<\/strong><\/span> desde la versi\u00f3n 10g.<\/p>\n<p>Podr\u00eda parecer una respuesta evidente o simple, pero no lo es tanto, ya que se trata de una funcionalidad documentada de manera contradictoria por parte de Oracle.<\/p>\n<p>&nbsp;<\/p>\n<h1><span style=\"color: #000000;\">Plan Stability vs SQL Plan Management<\/span><\/h1>\n<p>Hay dos conceptos que tener en cuenta en relaci\u00f3n con los Stored Outlines. <strong>Plan Stability<\/strong> (pre 11g) y <strong>SQL Plan Management<\/strong> o <strong>SPM<\/strong> (&gt;= 11g). Stored Outlines es parte de las funcionalidades de Plan Stability, como podemos ver en la doc de Oracle que enlaza <a href=\"https:\/\/hoopercharles.wordpress.com\/2011\/12\/02\/stored-outlines-plan-stability-are-an-enterprise-edition-feature-a-self-conflicting-story\/\">Charle&#8217;s Hooper en su blog<\/a>. Plan Stability, en 8i y 9i <span style=\"text-decoration: underline;\">es una funcionalidad documentada exclusivamente como Enterprise<\/span>, por lo que no es posible su uso con Standard Edition.<\/p>\n<p>SPM es una evoluci\u00f3n de Plan Stability, pero no sustituye a \u00e9ste, sino que es una nueva funcionalidad con nuevos componentes (como los SQL Baselines) para mejorar a su predecesor, Plan Stability. De este modo, a partir de 11g, tenemos la posibilidad de emplear las dos opciones PS y SPM.<\/p>\n<p>En una BD 12c, en la que coexisten las dos funcionalidades, vemos en una Standard Edition una importante diferencia entre las dos opciones:<\/p>\n<pre class=\"theme:terminal lang:default decode:true\">select parameter, value\r\nfrom v$option\r\nwhere parameter in ('Plan Stability','SQL Plan Management')\r\n\r\nPARAMETER\t     VALUE\r\n-------------------- -----\r\nPlan Stability\t     TRUE\r\nSQL Plan Management  FALSE\r\n<\/pre>\n<p>Plan Stability est\u00e1 habilitado, pero SPM no. Sabemos que SPM no es usable en SE y, de manera l\u00f3gica est\u00e1 deshabilitado impidiendo su uso involuntario. De hecho, muchas funcionalidades Enterprise Edition est\u00e1n deshabilitadas en Standard Edition, como Spatial, Partitioning, Parallel Execution o Basic Compression. Pese a eslab\u00f3n, sabemos que no siempre opciones Oracle habilitadas implican que pueden ser usadas, como ocurre habitualmente (m\u00e1s antes de 11gR2 y SE) con los packs de Diagnostics y Tuning de la BD, o incluso el acceso a la propia AWR que sigue habilitada en SE por defecto aunque los packs EM no lo est\u00e1n.<\/p>\n<p>&nbsp;<\/p>\n<h1><span style=\"color: #000000;\">\u00bfD\u00f3nde est\u00e1 la confirmaci\u00f3n del uso de Stored Outlines?<\/span><\/h1>\n<p>No conozco un documento en el que se muestre de manera expl\u00edcita en versiones 10g o posteriores. En la defensa de esta afirmaci\u00f3n tenemos:<\/p>\n<ul>\n<li>Las versiones 8i y 9i incluyen Plan Stability (Stored Outlines) entre las funcionalidades exclusivas de Enterprise. <a href=\"https:\/\/docs.oracle.com\/cd\/B19306_01\/license.102\/b14199\/editions.htm#DBLIC109\">Esta distinci\u00f3n deja de aparecer en 10g<\/a>.<\/li>\n<li>Con la aparici\u00f3n de SPM, de nuevo la documentaci\u00f3n Oracle hace referencia a una funcionalidad exclusiva para la edici\u00f3n Enterprise. Pese a ello, sigue sin haber referencias a limitaciones de licenciamento de los Stored Outlines en Standard Edition. SPM no incluye Stored Outlines, sino que los sustituye.<\/li>\n<li>La edici\u00f3n Standard, cuando menos en las versiones 10g en adelante, traen habilitada esta opci\u00f3n por defecto y permite sin problemas el uso de Stored Outlines.<\/li>\n<li>Pese a la duda, como partner Oracle escal\u00e9 la duda internamente, obteniendo como respuesta que s\u00ed, que es una opci\u00f3n disponible en Standard Edition no siendo necesaria ninguna licencia adicional. De todos modos, una consulta similar 3 a\u00f1os antes hab\u00eda recibido contestaci\u00f3n contraria, pero en aquel caso la respuesta hablaba de manera incorrecta de SPM, cuando Stored Outlines est\u00e1 claramente fuera de ese paquete funcional. Pese a mi insistencia en la pregunta, en esa ocasi\u00f3n la pregunta muri\u00f3 sin respuesta oficial.<\/li>\n<\/ul>\n<p>Por lo tanto, con estas premisas, incluyendo la confirmaci\u00f3n expl\u00edcita de Oracle, aceptamos Stored Outlines como opci\u00f3n a tener en cuenta para solucionar problemas con Standard Edition.<\/p>\n<p>&nbsp;<\/p>\n<h1><span style=\"color: #000000;\">Pero las Stored Oulines est\u00e1n <em>deprecated<\/em>, \u00bfpor qu\u00e9 usarlas?<\/span><\/h1>\n<p>Cierto, la versi\u00f3n 11g fue la primera en la que los Stored Outlines pasaron a ser un componente cuya funcionalidad fue sustitu\u00edda (y ampliada) por una nueva funcionalidad agrupada en el que Oracle nombr\u00f3 SPM (SQL Plan Management). As\u00ed, 11g anunci\u00f3 el fin del mantenimiento evolutivo de los Stored Outlines, que pasaron a estar <em>deprecated<\/em>. Pese a esto, tanto 11g como 12c mantienen funcionalmente estos componentes, y de hecho, la nota MOS <span id=\"kmPgTpl:sd_r1:0:dv_rDoc:0:ol22\" class=\"xq\"><label>Stored Outline Quick Reference (Doc ID 67536.1)<\/label> habla de ellos como \u00ab<em>legacy technique for providing plan stability<\/em>\u00ab.<\/span><\/p>\n<p>A\u00fan as\u00ed, si tu ecosistema es Standard Edition, pronto ver\u00e1s que no existen alternativas para fijar un plan de ejecuci\u00f3n, por lo que esta opci\u00f3n se convierte en un aut\u00e9ntico lujo cuando se trata de solucionar problemas de rendimiento en SE, incluso cuando estamos trabajando en una versi\u00f3n 12c. Salvo el empleo de hints, que pasan por la modificaci\u00f3n del c\u00f3digo de la aplicaci\u00f3n, muchas veces algo imposible en el corto plazo, no contamos con otra herramienta que nos permita fijar c\u00f3mo debe ejecutarse una consulta.<\/p>\n<p>&nbsp;<\/p>\n<h1><span style=\"color: #000000;\">Ejemplo de creaci\u00f3n de un Stored Outline<\/span><\/h1>\n<p>Se trata en este caso de un ejemplo en una BD en versi\u00f3n 12.1.0.1 en la que por motivos no completamente identificados (se aplicaron varias soluciones, como la aplicaci\u00f3n de un parche espec\u00edfico para un bug identificado en un SR o la deshabilitaci\u00f3n de determinadas funcionalidades del optimizador con la supervisi\u00f3n de Soporte Oracle), en determinadas ocasiones, una consulta que dura menos de 5 segundos, pasa a tardar varios minutos tras sufrir un cambio no esperado en el plan. Ante la imposibilidad de identificar el origen del problema, optamos por la creaci\u00f3n de un Stored Outline tras haber identificado un plan de ejecuci\u00f3n que se muestra v\u00e1lido independientemente de los valores de las bind variables empleadas en m\u00faltiples ejecuciones.<\/p>\n<p>Partimos sun SQL con sqlid=81uujczagk9bf. En el entorno disponemos en memoria del cursor correspondiente, del que obtenemos su informaci\u00f3n.<\/p>\n<pre class=\"theme:terminal lang:default decode:true\">select sql_id, hash_value, child_number, plan_hash_value, loaded_versions, open_versions, users_opening, users_executing, fetches, executions, loads, parse_calls, invalidations, first_load_time\r\nfrom v$sql\r\nwhere sql_id='81uujczagk9bf'  2    3  ;\r\n\r\nSQL_ID\t      HASH_VALUE CHILD_NUMBER PLAN_HASH_VALUE LOADED_VERSIONS OPEN_VERSIONS USERS_OPENING USERS_EXECUTING    FETCHES EXECUTIONS      LOADS PARSE_CALLS INVALIDATIONS FIRST_LOAD_TIME\r\n------------- ---------- ------------ --------------- --------------- ------------- ------------- --------------- ---------- ---------- ---------- ----------- ------------- ------------------------------\r\n81uujczagk9bf 3573097838\t    0\t    317020229\t\t    1\t\t  0\t\t0\t\t0\t   5\t      1 \t 5\t     1\t\t   2 2017-07-06\/10:20:13\r\n81uujczagk9bf 3573097838\t    1\t   3438832455\t\t    1\t\t  0\t\t0\t\t0\t 166\t     37 \t 5\t    33\t\t   3 2017-07-06\/10:20:13<\/pre>\n<p>Vemos que en el cursor contamos con dos planes. Tras tener monitorizado el comportamiento de las consultas, sabemos que el segundo plan, con 37 ejecuciones, es correcto y la duraci\u00f3n de las consultas con este plan son las esperadas. Cuando se produce el incidente, este plan u otro similar es invalidado y se carga en memoria el plan incorrecto. Vamos a crear el Stored Outline para fijar el plan con plan_hash_value 3438832455, que como vemos, es el hijo n\u00famero n\u00famero 1 del cursor 3573097838.<\/p>\n<pre class=\"theme:terminal lang:default decode:true \">begin\r\n \tdbms_outln.create_outline(\r\n\t\thash_value =&gt; '3573097838',\r\n\t\tchild_number =&gt; 1,\r\n\t\tcategory =&gt; 'default'\r\n\t);\r\nend;\r\n\/<\/pre>\n<p>Lo que acabamos de hacer es invocar al procedimiento <em>dbms_outln.create_online<\/em>, indicando el SQL para el que fijaremos el plan (empleando el hash_value y no el sql_id), el identificador de hijo del cursor, y con la categor\u00eda default , que es la que emplear\u00eda el procedimiento por defecto tambi\u00e9n si no especificamos nada. En este caso no necesitamos hacer ning\u00fan tipo de distinci\u00f3n por categor\u00eda, por lo que este valor es v\u00e1lido para nosotros. Vemos el nuevo objeto en la BD:<\/p>\n<pre class=\"theme:terminal lang:default decode:true\">column name format a30\r\ncolumn owner format a15\r\ncolumn category format a10\r\ncolumn version format a10\r\nselect name, owner, category, used, enabled, version\r\nfrom dba_outlines\r\n\/\r\n\r\nNAME\t\t\t       OWNER\t       CATEGORY   USED\t ENABLED  VERSION\r\n------------------------------ --------------- ---------- ------ -------- ----------\r\nSYS_OUTLINE_17071016074710901  ARUMEL\t       default\t  UNUSED ENABLED  12.1.0.1.0<\/pre>\n<p>Al emplear <em>dbms_outl.create_online<\/em> para crear el outline a partir de la informaci\u00f3n en la shared pool, no nos es posible establecer un nombre, obteniendo uno generado de manera autom\u00e1tica por el sistema con el formato SYS_OUTLINE_<em>timestamp<\/em>. Modificamos el nombre para que sea mas descriptivo.<\/p>\n<pre class=\"theme:terminal lang:default decode:true \">alter outline SYS_OUTLINE_17071016074710901 rename to fixacion_plan_batch_arumel;\r\n\r\nOutline altered.\r\n\r\n\r\ncolumn name format a30\r\ncolumn owner format a15\r\ncolumn category format a10\r\ncolumn version format a10\r\nselect name, owner, category, used, enabled, version\r\nfrom dba_outlines\r\n\/\r\n\r\nNAME\t\t\t       OWNER\t       CATEGORY   USED\t ENABLED  VERSION\r\n------------------------------ --------------- ---------- ------ -------- ----------\r\nFIXACION_PLAN_BATCH_ARUMEL     ARUMEL\t       default\t  UNUSED ENABLED  12.1.0.1.0<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00bfPuedo usar Stored Outlines con una Standard Edition? S\u00cd desde la versi\u00f3n 10g. Podr\u00eda parecer una respuesta evidente o simple, pero no lo es tanto, ya que se trata de una funcionalidad documentada de manera contradictoria por parte de Oracle. &nbsp; Plan Stability vs SQL Plan Management Hay dos conceptos que tener en cuenta en [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":7884,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[62,27,50],"tags":[],"class_list":["post-7901","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","category-portada-es","category-slider-post-es"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Stored Outlines en Standard Edition - Arumel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/arumel.com\/es\/stored-outlines-en-standard-edition\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Stored Outlines en Standard Edition - Arumel\" \/>\n<meta property=\"og:description\" content=\"\u00bfPuedo usar Stored Outlines con una Standard Edition? S\u00cd desde la versi\u00f3n 10g. Podr\u00eda parecer una respuesta evidente o simple, pero no lo es tanto, ya que se trata de una funcionalidad documentada de manera contradictoria por parte de Oracle. &nbsp; Plan Stability vs SQL Plan Management Hay dos conceptos que tener en cuenta en [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/arumel.com\/es\/stored-outlines-en-standard-edition\/\" \/>\n<meta property=\"og:site_name\" content=\"Arumel\" \/>\n<meta property=\"article:published_time\" content=\"2017-07-11T22:38:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-07-13T14:57:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083-1024x678.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"678\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Alberto Pereiro\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alberto Pereiro\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/stored-outlines-en-standard-edition\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/stored-outlines-en-standard-edition\\\/\"},\"author\":{\"name\":\"Alberto Pereiro\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/1cdc5947f4270801792b02ec92332edc\"},\"headline\":\"Stored Outlines en Standard Edition\",\"datePublished\":\"2017-07-11T22:38:04+00:00\",\"dateModified\":\"2017-07-13T14:57:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/stored-outlines-en-standard-edition\\\/\"},\"wordCount\":1146,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/stored-outlines-en-standard-edition\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/IMX0083.jpg?fit=4928%2C3264&ssl=1\",\"articleSection\":[\"Oracle\",\"portada\",\"slider-post\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/arumel.com\\\/es\\\/stored-outlines-en-standard-edition\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/stored-outlines-en-standard-edition\\\/\",\"url\":\"https:\\\/\\\/arumel.com\\\/es\\\/stored-outlines-en-standard-edition\\\/\",\"name\":\"Stored Outlines en Standard Edition - Arumel\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/stored-outlines-en-standard-edition\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/stored-outlines-en-standard-edition\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/IMX0083.jpg?fit=4928%2C3264&ssl=1\",\"datePublished\":\"2017-07-11T22:38:04+00:00\",\"dateModified\":\"2017-07-13T14:57:23+00:00\",\"author\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/1cdc5947f4270801792b02ec92332edc\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/stored-outlines-en-standard-edition\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/arumel.com\\\/es\\\/stored-outlines-en-standard-edition\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/stored-outlines-en-standard-edition\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/IMX0083.jpg?fit=4928%2C3264&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/IMX0083.jpg?fit=4928%2C3264&ssl=1\",\"width\":4928,\"height\":3264},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/stored-outlines-en-standard-edition\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/arumel.com\\\/es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Stored Outlines en Standard Edition\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#website\",\"url\":\"http:\\\/\\\/arumel.com\\\/\",\"name\":\"Arumel\",\"description\":\"Outro sitio WordPress m\u00e1is\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/arumel.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/1cdc5947f4270801792b02ec92332edc\",\"name\":\"Alberto Pereiro\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g\",\"caption\":\"Alberto Pereiro\"},\"url\":\"https:\\\/\\\/arumel.com\\\/es\\\/author\\\/alberto\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Stored Outlines en Standard Edition - Arumel","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:\/\/arumel.com\/es\/stored-outlines-en-standard-edition\/","og_locale":"es_ES","og_type":"article","og_title":"Stored Outlines en Standard Edition - Arumel","og_description":"\u00bfPuedo usar Stored Outlines con una Standard Edition? S\u00cd desde la versi\u00f3n 10g. Podr\u00eda parecer una respuesta evidente o simple, pero no lo es tanto, ya que se trata de una funcionalidad documentada de manera contradictoria por parte de Oracle. &nbsp; Plan Stability vs SQL Plan Management Hay dos conceptos que tener en cuenta en [&hellip;]","og_url":"https:\/\/arumel.com\/es\/stored-outlines-en-standard-edition\/","og_site_name":"Arumel","article_published_time":"2017-07-11T22:38:04+00:00","article_modified_time":"2017-07-13T14:57:23+00:00","og_image":[{"width":1024,"height":678,"url":"https:\/\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083-1024x678.jpg","type":"image\/jpeg"}],"author":"Alberto Pereiro","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Alberto Pereiro","Tiempo de lectura":"7 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/arumel.com\/es\/stored-outlines-en-standard-edition\/#article","isPartOf":{"@id":"https:\/\/arumel.com\/es\/stored-outlines-en-standard-edition\/"},"author":{"name":"Alberto Pereiro","@id":"http:\/\/arumel.com\/#\/schema\/person\/1cdc5947f4270801792b02ec92332edc"},"headline":"Stored Outlines en Standard Edition","datePublished":"2017-07-11T22:38:04+00:00","dateModified":"2017-07-13T14:57:23+00:00","mainEntityOfPage":{"@id":"https:\/\/arumel.com\/es\/stored-outlines-en-standard-edition\/"},"wordCount":1146,"commentCount":0,"image":{"@id":"https:\/\/arumel.com\/es\/stored-outlines-en-standard-edition\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=4928%2C3264&ssl=1","articleSection":["Oracle","portada","slider-post"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/arumel.com\/es\/stored-outlines-en-standard-edition\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/arumel.com\/es\/stored-outlines-en-standard-edition\/","url":"https:\/\/arumel.com\/es\/stored-outlines-en-standard-edition\/","name":"Stored Outlines en Standard Edition - Arumel","isPartOf":{"@id":"http:\/\/arumel.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/arumel.com\/es\/stored-outlines-en-standard-edition\/#primaryimage"},"image":{"@id":"https:\/\/arumel.com\/es\/stored-outlines-en-standard-edition\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=4928%2C3264&ssl=1","datePublished":"2017-07-11T22:38:04+00:00","dateModified":"2017-07-13T14:57:23+00:00","author":{"@id":"http:\/\/arumel.com\/#\/schema\/person\/1cdc5947f4270801792b02ec92332edc"},"breadcrumb":{"@id":"https:\/\/arumel.com\/es\/stored-outlines-en-standard-edition\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/arumel.com\/es\/stored-outlines-en-standard-edition\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/arumel.com\/es\/stored-outlines-en-standard-edition\/#primaryimage","url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=4928%2C3264&ssl=1","contentUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=4928%2C3264&ssl=1","width":4928,"height":3264},{"@type":"BreadcrumbList","@id":"https:\/\/arumel.com\/es\/stored-outlines-en-standard-edition\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/arumel.com\/es\/"},{"@type":"ListItem","position":2,"name":"Stored Outlines en Standard Edition"}]},{"@type":"WebSite","@id":"http:\/\/arumel.com\/#website","url":"http:\/\/arumel.com\/","name":"Arumel","description":"Outro sitio WordPress m\u00e1is","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/arumel.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"http:\/\/arumel.com\/#\/schema\/person\/1cdc5947f4270801792b02ec92332edc","name":"Alberto Pereiro","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g","caption":"Alberto Pereiro"},"url":"https:\/\/arumel.com\/es\/author\/alberto\/"}]}},"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9uvW6-23r","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":7898,"url":"https:\/\/arumel.com\/eu\/stored-outlines-en-standard-edition\/","url_meta":{"origin":7901,"position":0},"title":"Stored Outlines en Standard Edition","author":"Alberto Pereiro","date":"12 de julio de 2017","format":false,"excerpt":"","rel":"","context":"En &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/eu\/oracle-eu\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":7899,"url":"https:\/\/arumel.com\/ca\/stored-outlines-en-standard-edition\/","url_meta":{"origin":7901,"position":1},"title":"Stored Outlines en Standard Edition","author":"Alberto Pereiro","date":"12 de julio de 2017","format":false,"excerpt":"","rel":"","context":"En &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/ca\/oracle-ca\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":7890,"url":"https:\/\/arumel.com\/stored-outlines-en-standard-edition\/","url_meta":{"origin":7901,"position":2},"title":"Stored Outlines en Standard Edition","author":"Alberto Pereiro","date":"12 de julio de 2017","format":false,"excerpt":"","rel":"","context":"En &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/oracle-2\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":7900,"url":"https:\/\/arumel.com\/en\/stored-outlines-en-standard-edition\/","url_meta":{"origin":7901,"position":3},"title":"Stored Outlines en Standard Edition","author":"Alberto Pereiro","date":"12 de julio de 2017","format":false,"excerpt":"","rel":"","context":"En &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/en\/oracle-en\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":9019,"url":"https:\/\/arumel.com\/es\/mejora-de-rendimiento-con-indexacion-de-valores-null-en-oracle\/","url_meta":{"origin":7901,"position":4},"title":"Mejora de rendimiento con indexaci\u00f3n de valores NULL en Oracle","author":"Alberto Pereiro","date":"19 de abril de 2018","format":false,"excerpt":"","rel":"","context":"En &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/es\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/04\/riders.on_.the_.storm_.jpg?fit=1200%2C595&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/04\/riders.on_.the_.storm_.jpg?fit=1200%2C595&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/04\/riders.on_.the_.storm_.jpg?fit=1200%2C595&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/04\/riders.on_.the_.storm_.jpg?fit=1200%2C595&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/04\/riders.on_.the_.storm_.jpg?fit=1200%2C595&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":9023,"url":"https:\/\/arumel.com\/ca\/mejora-de-rendimiento-con-indexacion-de-valores-null-en-oracle\/","url_meta":{"origin":7901,"position":5},"title":"Mejora de rendimiento con indexaci\u00f3n de valores NULL en Oracle","author":"Alberto Pereiro","date":"19 de abril de 2018","format":false,"excerpt":"","rel":"","context":"En &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/ca\/oracle-ca\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/04\/riders.on_.the_.storm_.jpg?fit=1200%2C595&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/04\/riders.on_.the_.storm_.jpg?fit=1200%2C595&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/04\/riders.on_.the_.storm_.jpg?fit=1200%2C595&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/04\/riders.on_.the_.storm_.jpg?fit=1200%2C595&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/04\/riders.on_.the_.storm_.jpg?fit=1200%2C595&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=4928%2C3264&ssl=1","_links":{"self":[{"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts\/7901","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/comments?post=7901"}],"version-history":[{"count":5,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts\/7901\/revisions"}],"predecessor-version":[{"id":8011,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts\/7901\/revisions\/8011"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/media\/7884"}],"wp:attachment":[{"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/media?parent=7901"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/categories?post=7901"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/tags?post=7901"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}