{"id":9743,"date":"2019-08-13T11:05:45","date_gmt":"2019-08-13T09:05:45","guid":{"rendered":"http:\/\/arumel.com\/?p=9743"},"modified":"2019-08-13T11:13:37","modified_gmt":"2019-08-13T09:13:37","slug":"awr-warehouse-por-supuesto","status":"publish","type":"post","link":"https:\/\/arumel.com\/es\/awr-warehouse-por-supuesto\/","title":{"rendered":"AWR Warehouse? Por supuesto!"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Resulta emocionante, y es lo que pretendo trasladar en este art\u00edculo, la idea de disponer de un repositorio centralizado de awr de todas las bases de datos Oracle de la compa\u00f1\u00eda.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Realmente pienso\u2026 c\u00f3mo has podido vivir sin uno?!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Para entender qu\u00e9 nos puede aportar comienzo explicando qu\u00e9 es AWR.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">AWR es una de las herramientas m\u00e1s potentes de las que dispone Oracle para realizar un seguimiento y diagn\u00f3sticos del rendimiento de nuestras bases de datos Oracle.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Su funcionamiento consiste en ir tomando informaci\u00f3n del rendimiento de la base de datos en periodos regulares, por defecto cada hora y retenci\u00f3n de 8 d\u00edas, de las siguientes fuentes:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Estad\u00edsticas a nivel de objeto, tanto de acceso como estad\u00edsticas de uso.<\/li><li>Time Model Statistics (V$SYS_TIME_MODEL y V$SESS_TIME_MODEL)<\/li><li>Estad\u00edsticas de sisrtema y de sesi\u00f3n (V$SYSSTAT y V$SESSTAT)<\/li><li>ASH (Active Session History)<\/li><li>Consultas SQL con carga alta en el sistema<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Por defecto dicha informaci\u00f3n se encontrar\u00eda en el SYSAUX de cada una de ellas, lo cual nos acaba llevando mayor tiempo de backup, mayor tiempo de upgrade y mayor ocupaci\u00f3n de espacio de almacenamiento, adem\u00e1s de poder impactar en el en rendimiento de producci\u00f3n la consulta de dicha informaci\u00f3n.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Recordemos que para poder beneficiarnos de AWR precisaremos que las bases de datos sean Enterprise Edition con  diagnostics + tuning pack.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Conociendo ya qu\u00e9 es AWR ahora pensamos, qu\u00e9 ventajas puede aportarme un repositorio centralizado de AWR?<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Liberar espacio y eliminar impacto de rendimiento en los sistemas de producci\u00f3n.<\/li><li>Retenci\u00f3n INIFINITA si queremos (es configurable). Tranquilidad! existe particionamiento de la informaci\u00f3n por dbid y snap_id de las tablas WRH$ (DBA_HIST_) \ud83d\ude42<\/li><li>Consultar la informaci\u00f3n directamente y poder cruzar entre bases de datos. Pongamos un ejemplo: inspeccionar y comparar la informaci\u00f3n relativa a un sql_id particular, como consumo de cpu, IO o plan de ejecuci\u00f3n, entre preproducci\u00f3n y producci\u00f3n.<\/li><li>Comparar el rendimiento entre periodods del sistema en producci\u00f3n\u2026 hasta a\u00f1os atr\u00e1s!<\/li><li>Ver evoluci\u00f3n del rendimiento de las distintas bases de datos en el tiempo, pudiendo agregar \u00e9sta seg\u00fan nuestra necesidades.<\/li><li>El repositorio de AWR podr\u00e1 ser una base de datos single instance, sin licenciamiento adicional.<\/li><li>Podr\u00e1 ser fuente de informaci\u00f3n para ADDM, ASH analytics\u2026<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">C\u00f3mo funciona?<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.oracle.com\/ocom\/groups\/public\/%40otn\/documents\/digitalasset\/2301735.jpg?w=1080&#038;ssl=1\" alt=\"awrw-art1-jpeg\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">El proceso de funcionamiento es muy simple, mediante una serie de jobs que resultan en procesamiento ETL. Describo las fases:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Extracci\u00f3n de la informaci\u00f3n de AWR (ficheros dmp) en origen.<\/li><li>Transferencia. Un job de EM transferir\u00e1 dicha informaci\u00f3n a intervalos regulares uns staging area en el host de AWR Warehouse, en el cual ser\u00e1 procesada<\/li><li>Carga. Un job de base de datos cargar\u00e1 dicha informaci\u00f3n de forma regular de forma incremental (asergur\u00e1ndose que se importan todos los snapshots que no han sido aun cargados) <\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">No hace falta decir que dicha informaci\u00f3n puede ser explotada a trav\u00e9s de CloudControl, adem\u00e1s de poder crear tus propios informes de rendimiento seg\u00fan las necesidades del negocio \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Resulta emocionante, y es lo que pretendo trasladar en este art\u00edculo, la idea de disponer de un repositorio centralizado de awr de todas las bases de datos Oracle de la compa\u00f1\u00eda. Realmente pienso\u2026 c\u00f3mo has podido vivir sin uno?! Para entender qu\u00e9 nos puede aportar comienzo explicando qu\u00e9 es AWR. AWR es una de las [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":9578,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"off","_et_pb_old_content":"<!-- wp:paragraph -->\n<p>Resulta emocionante, y es lo que pretendo trasladar en este art\u00edculo, la idea de disponer de un repositorio centralizado de awr de todas las bases de datos Oracle de la compa\u00f1\u00eda.<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>Realmente pienso\u2026 c\u00f3mo has podido vivir sin uno?!<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>Para entender qu\u00e9 nos puede aportar comienzo explicando qu\u00e9 es AWR.<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>AWR es una de las herramientas m\u00e1s potentes de las que dispone Oracle para realizar un seguimiento y diagn\u00f3sticos del rendimiento de nuestras bases de datos Oracle.<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>Su funcionamiento consiste en ir tomando informaci\u00f3n del rendimiento de la base de datos en periodos regulares, por defecto cada hora y retenci\u00f3n de 8 d\u00edas, de las siguientes fuentes:<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:list -->\n<ul><li>Estad\u00edsticas a nivel de objeto, tanto de acceso como estad\u00edsticas de uso.<\/li><li>Time Model Statistics (V$SYS_TIME_MODEL y V$SESS_TIME_MODEL)<\/li><li>Estad\u00edsticas de sisrtema y de sesi\u00f3n (V$SYSSTAT y V$SESSTAT)<\/li><li>ASH (Active Session History)<\/li><li>Consultas SQL con carga alta en el sistema<\/li><\/ul>\n<!-- \/wp:list -->\n\n<!-- wp:paragraph -->\n<p>Por defecto dicha informaci\u00f3n se encontrar\u00eda en el SYSAUX de cada una de ellas, lo cual nos acaba llevando mayor tiempo de backup, mayor tiempo de upgrade y mayor ocupaci\u00f3n de espacio de almacenamiento, adem\u00e1s de poder impactar en el en rendimiento de producci\u00f3n la consulta de dicha informaci\u00f3n.<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>Recordemos que para poder beneficiarnos de AWR precisaremos que las bases de datos sean Enterprise Edition con  diagnostics + tuning pack.<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>Conociendo ya qu\u00e9 es AWR ahora pensamos, qu\u00e9 ventajas puede aportarme un repositorio centralizado de AWR?<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:list -->\n<ul><li>Liberar espacio y eliminar impacto de rendimiento en los sistemas de producci\u00f3n.<\/li><li>Retenci\u00f3n INIFINITA si queremos (es configurable). Tranquilidad! existe particionamiento de la informaci\u00f3n por dbid y snap_id de las tablas WRH$ (DBA_HIST_) :)<\/li><li>Consultar la informaci\u00f3n directamente y poder cruzar entre bases de datos. Pongamos un ejemplo: inspeccionar y comparar la informaci\u00f3n relativa a un sql_id particular, como consumo de cpu, IO o plan de ejecuci\u00f3n, entre preproducci\u00f3n y producci\u00f3n.<\/li><li>Comparar el rendimiento entre periodods del sistema en producci\u00f3n\u2026 hasta a\u00f1os atr\u00e1s!<\/li><li>Ver evoluci\u00f3n del rendimiento de las distintas bases de datos en el tiempo, pudiendo agregar \u00e9sta seg\u00fan nuestra necesidades.<\/li><li>El repositorio de AWR podr\u00e1 ser una base de datos single instance, sin licenciamiento adicional.<\/li><li>Podr\u00e1 ser fuente de informaci\u00f3n para ADDM, ASH analytics\u2026<\/li><\/ul>\n<!-- \/wp:list -->\n\n<!-- wp:paragraph -->\n<p>C\u00f3mo funciona?<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:image {\"align\":\"center\"} -->\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img src=\"https:\/\/www.oracle.com\/ocom\/groups\/public\/@otn\/documents\/digitalasset\/2301735.jpg\" alt=\"awrw-art1-jpeg\" \/><\/figure><\/div>\n<!-- \/wp:image -->\n\n<!-- wp:paragraph -->\n<p>El proceso de funcionamiento es muy simple, mediante una serie de jobs que resultan en procesamiento ETL. Describo las fases:<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:list -->\n<ul><li>Extracci\u00f3n de la informaci\u00f3n de AWR (ficheros dmp) en origen.<\/li><li>Transferencia. Un job de EM transferir\u00e1 dicha informaci\u00f3n a intervalos regulares uns staging area en el host de AWR Warehouse, en el cual ser\u00e1 procesada<\/li><li>Carga. Un job de base de datos cargar\u00e1 dicha informaci\u00f3n de forma regular de forma incremental (asergur\u00e1ndose que se importan todos los snapshots que no han sido aun cargados) <\/li><\/ul>\n<!-- \/wp:list -->\n\n<!-- wp:paragraph -->\n<p>No hace falta decir que dicha informaci\u00f3n puede ser explotada a trav\u00e9s de CloudControl, adem\u00e1s de poder crear tus propios informes de rendimiento seg\u00fan las necesidades del negocio :)<\/p>\n<!-- \/wp:paragraph -->","_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":true,"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],"tags":[420,14,421],"class_list":["post-9743","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-awr","tag-oracle","tag-warehouse"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>AWR Warehouse? Por supuesto! - 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\/awr-warehouse-por-supuesto\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AWR Warehouse? Por supuesto! - Arumel\" \/>\n<meta property=\"og:description\" content=\"Resulta emocionante, y es lo que pretendo trasladar en este art\u00edculo, la idea de disponer de un repositorio centralizado de awr de todas las bases de datos Oracle de la compa\u00f1\u00eda. Realmente pienso\u2026 c\u00f3mo has podido vivir sin uno?! Para entender qu\u00e9 nos puede aportar comienzo explicando qu\u00e9 es AWR. AWR es una de las [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/arumel.com\/es\/awr-warehouse-por-supuesto\/\" \/>\n<meta property=\"og:site_name\" content=\"Arumel\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-13T09:05:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-08-13T09:13:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/arumel.com\/wp-content\/uploads\/2019\/07\/ilustracion.sxsbandin.rodaballo-1024x749.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"749\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Carla Mu\u00f1oz L\u00f3pez\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Carla Mu\u00f1oz L\u00f3pez\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/awr-warehouse-por-supuesto\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/awr-warehouse-por-supuesto\\\/\"},\"author\":{\"name\":\"Carla Mu\u00f1oz L\u00f3pez\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/ad6b4e40f9cf337835a3c478b69e425d\"},\"headline\":\"AWR Warehouse? Por supuesto!\",\"datePublished\":\"2019-08-13T09:05:45+00:00\",\"dateModified\":\"2019-08-13T09:13:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/awr-warehouse-por-supuesto\\\/\"},\"wordCount\":526,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/awr-warehouse-por-supuesto\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/ilustracion.sxsbandin.rodaballo.jpg?fit=2391%2C1748&ssl=1\",\"keywords\":[\"awr\",\"oracle\",\"warehouse\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/arumel.com\\\/es\\\/awr-warehouse-por-supuesto\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/awr-warehouse-por-supuesto\\\/\",\"url\":\"https:\\\/\\\/arumel.com\\\/es\\\/awr-warehouse-por-supuesto\\\/\",\"name\":\"AWR Warehouse? Por supuesto! - Arumel\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/awr-warehouse-por-supuesto\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/awr-warehouse-por-supuesto\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/ilustracion.sxsbandin.rodaballo.jpg?fit=2391%2C1748&ssl=1\",\"datePublished\":\"2019-08-13T09:05:45+00:00\",\"dateModified\":\"2019-08-13T09:13:37+00:00\",\"author\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/ad6b4e40f9cf337835a3c478b69e425d\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/awr-warehouse-por-supuesto\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/arumel.com\\\/es\\\/awr-warehouse-por-supuesto\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/awr-warehouse-por-supuesto\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/ilustracion.sxsbandin.rodaballo.jpg?fit=2391%2C1748&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/ilustracion.sxsbandin.rodaballo.jpg?fit=2391%2C1748&ssl=1\",\"width\":2391,\"height\":1748},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/arumel.com\\\/es\\\/awr-warehouse-por-supuesto\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/arumel.com\\\/es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AWR Warehouse? Por supuesto!\"}]},{\"@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\\\/ad6b4e40f9cf337835a3c478b69e425d\",\"name\":\"Carla Mu\u00f1oz L\u00f3pez\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c34c1c226ea43a0f2cb28cb8f651067a07412b928f194304d39b31df68a0342c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c34c1c226ea43a0f2cb28cb8f651067a07412b928f194304d39b31df68a0342c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c34c1c226ea43a0f2cb28cb8f651067a07412b928f194304d39b31df68a0342c?s=96&d=mm&r=g\",\"caption\":\"Carla Mu\u00f1oz L\u00f3pez\"},\"sameAs\":[\"www.linkedin.com\\\/in\\\/carla-munoz-lopez\"],\"url\":\"https:\\\/\\\/arumel.com\\\/es\\\/author\\\/carla\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AWR Warehouse? Por supuesto! - 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\/awr-warehouse-por-supuesto\/","og_locale":"es_ES","og_type":"article","og_title":"AWR Warehouse? Por supuesto! - Arumel","og_description":"Resulta emocionante, y es lo que pretendo trasladar en este art\u00edculo, la idea de disponer de un repositorio centralizado de awr de todas las bases de datos Oracle de la compa\u00f1\u00eda. Realmente pienso\u2026 c\u00f3mo has podido vivir sin uno?! Para entender qu\u00e9 nos puede aportar comienzo explicando qu\u00e9 es AWR. AWR es una de las [&hellip;]","og_url":"https:\/\/arumel.com\/es\/awr-warehouse-por-supuesto\/","og_site_name":"Arumel","article_published_time":"2019-08-13T09:05:45+00:00","article_modified_time":"2019-08-13T09:13:37+00:00","og_image":[{"width":1024,"height":749,"url":"https:\/\/arumel.com\/wp-content\/uploads\/2019\/07\/ilustracion.sxsbandin.rodaballo-1024x749.jpg","type":"image\/jpeg"}],"author":"Carla Mu\u00f1oz L\u00f3pez","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Carla Mu\u00f1oz L\u00f3pez","Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/arumel.com\/es\/awr-warehouse-por-supuesto\/#article","isPartOf":{"@id":"https:\/\/arumel.com\/es\/awr-warehouse-por-supuesto\/"},"author":{"name":"Carla Mu\u00f1oz L\u00f3pez","@id":"http:\/\/arumel.com\/#\/schema\/person\/ad6b4e40f9cf337835a3c478b69e425d"},"headline":"AWR Warehouse? Por supuesto!","datePublished":"2019-08-13T09:05:45+00:00","dateModified":"2019-08-13T09:13:37+00:00","mainEntityOfPage":{"@id":"https:\/\/arumel.com\/es\/awr-warehouse-por-supuesto\/"},"wordCount":526,"commentCount":0,"image":{"@id":"https:\/\/arumel.com\/es\/awr-warehouse-por-supuesto\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2019\/07\/ilustracion.sxsbandin.rodaballo.jpg?fit=2391%2C1748&ssl=1","keywords":["awr","oracle","warehouse"],"articleSection":["Oracle"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/arumel.com\/es\/awr-warehouse-por-supuesto\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/arumel.com\/es\/awr-warehouse-por-supuesto\/","url":"https:\/\/arumel.com\/es\/awr-warehouse-por-supuesto\/","name":"AWR Warehouse? Por supuesto! - Arumel","isPartOf":{"@id":"http:\/\/arumel.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/arumel.com\/es\/awr-warehouse-por-supuesto\/#primaryimage"},"image":{"@id":"https:\/\/arumel.com\/es\/awr-warehouse-por-supuesto\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2019\/07\/ilustracion.sxsbandin.rodaballo.jpg?fit=2391%2C1748&ssl=1","datePublished":"2019-08-13T09:05:45+00:00","dateModified":"2019-08-13T09:13:37+00:00","author":{"@id":"http:\/\/arumel.com\/#\/schema\/person\/ad6b4e40f9cf337835a3c478b69e425d"},"breadcrumb":{"@id":"https:\/\/arumel.com\/es\/awr-warehouse-por-supuesto\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/arumel.com\/es\/awr-warehouse-por-supuesto\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/arumel.com\/es\/awr-warehouse-por-supuesto\/#primaryimage","url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2019\/07\/ilustracion.sxsbandin.rodaballo.jpg?fit=2391%2C1748&ssl=1","contentUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2019\/07\/ilustracion.sxsbandin.rodaballo.jpg?fit=2391%2C1748&ssl=1","width":2391,"height":1748},{"@type":"BreadcrumbList","@id":"https:\/\/arumel.com\/es\/awr-warehouse-por-supuesto\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/arumel.com\/es\/"},{"@type":"ListItem","position":2,"name":"AWR Warehouse? Por supuesto!"}]},{"@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\/ad6b4e40f9cf337835a3c478b69e425d","name":"Carla Mu\u00f1oz L\u00f3pez","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/c34c1c226ea43a0f2cb28cb8f651067a07412b928f194304d39b31df68a0342c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c34c1c226ea43a0f2cb28cb8f651067a07412b928f194304d39b31df68a0342c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c34c1c226ea43a0f2cb28cb8f651067a07412b928f194304d39b31df68a0342c?s=96&d=mm&r=g","caption":"Carla Mu\u00f1oz L\u00f3pez"},"sameAs":["www.linkedin.com\/in\/carla-munoz-lopez"],"url":"https:\/\/arumel.com\/es\/author\/carla\/"}]}},"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9uvW6-2x9","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":8954,"url":"https:\/\/arumel.com\/es\/oracle-18c-zero-impact-patching-grid-infrastructure-clusterware-asm\/","url_meta":{"origin":9743,"position":0},"title":"Oracle 18c &#8211; \u00abZero Impact Patching\u00bb para Grid Infrastructure (Clusterware + ASM)","author":"Alberto Pereiro","date":"1 de marzo 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\/03\/anoitecer-e1519906558263.jpg?fit=1200%2C570&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/03\/anoitecer-e1519906558263.jpg?fit=1200%2C570&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/03\/anoitecer-e1519906558263.jpg?fit=1200%2C570&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/03\/anoitecer-e1519906558263.jpg?fit=1200%2C570&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/03\/anoitecer-e1519906558263.jpg?fit=1200%2C570&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":8197,"url":"https:\/\/arumel.com\/ca\/recomendaciones-para-la-red-de-interconexion-en-rac\/","url_meta":{"origin":9743,"position":1},"title":"Recomendaciones para la red de interconexi\u00f3n en RAC","author":"Alberto Pereiro","date":"21 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\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":8199,"url":"https:\/\/arumel.com\/es\/recomendaciones-para-la-de-la-red-de-interconexion-en-rac\/","url_meta":{"origin":9743,"position":2},"title":"Recomendaciones para la red de interconexi\u00f3n en RAC","author":"Alberto Pereiro","date":"21 de julio de 2017","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\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":8211,"url":"https:\/\/arumel.com\/eu\/recomendaciones-para-la-red-de-interconexion-en-rac\/","url_meta":{"origin":9743,"position":3},"title":"Recomendaciones para la red de interconexi\u00f3n en RAC","author":"Alberto Pereiro","date":"21 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\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/ilustracion.vera_.suricata.01.png?fit=977%2C1117&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":8968,"url":"https:\/\/arumel.com\/eu\/oracle-18c-zero-impact-patching-grid-infrastructure-clusterware-asm\/","url_meta":{"origin":9743,"position":4},"title":"Oracle 18c &#8211; \u00abZero Impact Patching\u00bb para Grid Infrastructure (Clusterware + ASM)","author":"Alberto Pereiro","date":"1 de marzo de 2018","format":false,"excerpt":"","rel":"","context":"En &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/eu\/oracle-eu\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8964,"url":"https:\/\/arumel.com\/oracle-18c-zero-impact-patching-grid-infrastructure-clusterware-asm\/","url_meta":{"origin":9743,"position":5},"title":"Oracle 18c &#8211; \u00abZero Impact Patching\u00bb para Grid Infrastructure (Clusterware + ASM)","author":"Alberto Pereiro","date":"1 de marzo de 2018","format":false,"excerpt":"","rel":"","context":"Entrada similar","block_context":{"text":"Entrada similar","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2019\/07\/ilustracion.sxsbandin.rodaballo.jpg?fit=2391%2C1748&ssl=1","_links":{"self":[{"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts\/9743","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\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/comments?post=9743"}],"version-history":[{"count":6,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts\/9743\/revisions"}],"predecessor-version":[{"id":9750,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts\/9743\/revisions\/9750"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/media\/9578"}],"wp:attachment":[{"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/media?parent=9743"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/categories?post=9743"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/tags?post=9743"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}