{"id":12131,"date":"2019-05-16T22:00:59","date_gmt":"2019-05-16T22:00:59","guid":{"rendered":"https:\/\/dbtut.com\/?p=12131"},"modified":"2019-05-16T22:01:00","modified_gmt":"2019-05-16T22:01:00","slug":"how-to-change-awr-retention-and-interval-values","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/","title":{"rendered":"How To Change AWR Retention and Interval Values"},"content":{"rendered":"<p>If Tuning and Diagnostic Packs is installed, automatic snapshots can be created with AWR and we can get information about the database performance among the related snapshots. Tuning and Diagnostic Packs require a separate license from the database.<\/p>\n<h3>What is interval and retention?<\/h3>\n<p><strong>interval<\/strong> means to the interval of automatic snapshot, <strong>retention<\/strong> means to how long the snapshot information is stored.<\/p>\n<p>&#8211; retention: If set to 0, it is stored indefinitely. In minutes. The required value for 30 days will be 30 * 24 * 60 = 64800.<br \/>\n&#8211; interval: If set to 0, AWR is turned off. It takes the value in minutes.<\/p>\n<p>You can find the current values \u200b\u200bwith the following query.<\/p>\n<pre class=\"lang:default decode:true \">SELECT EXTRACT (DAY FROM snap_interval) * 24 * 60\n+ EXTRACT (HOUR FROM snap_interval) * 60\n+ EXTRACT (MINUTE FROM snap_interval)\nsnapshot_interval,\nEXTRACT (DAY FROM retention) * 24 * 60\n+ EXTRACT (HOUR FROM retention) * 60\n+ EXTRACT (MINUTE FROM retention)\nretention_interval\nFROM dba_hist_wr_control;<\/pre>\n<h3>Change retention and interval values<\/h3>\n<p>You can change the existing values \u200b\u200bwith the dbms_workload_repository.modify_snapshot_settings procedure as follows.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; exec dbms_workload_repository.modify_snapshot_settings(retention=&gt;21600, interval=&gt;30);<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_12131\" class=\"pvc_stats all  \" data-element-id=\"12131\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>If Tuning and Diagnostic Packs is installed, automatic snapshots can be created with AWR and we can get information about the database performance among the related snapshots. Tuning and Diagnostic Packs require a separate license from the database. What is interval and retention? interval means to the interval of automatic snapshot, retention means to how &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_12131\" class=\"pvc_stats all  \" data-element-id=\"12131\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":12132,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[4055,4046,4064,4047,4065,4059,4056,4052,4051,4050,4049,4057,4062,4063,4053,4060,4061,4058,4054,4045,4048,4044],"class_list":["post-12131","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-awr-automatic-snapshot-settings","tag-awr-interval","tag-awr-report-for-specific-time-interval","tag-awr-retention","tag-awr-retention-period-in-days","tag-awr-retention-settings","tag-change-awr-retention-interval","tag-change-retention-and-interval","tag-change-retention-and-interval-in-awr","tag-change-snapshot-interval","tag-change-snapshot-retention","tag-changing-awr-snapshot-retention-and-interval","tag-check-awr-retention-in-days","tag-dba_hist_wr_control","tag-how-to-change-awr-retention-period","tag-how-to-check-awr-retention-period-in-oracle-database","tag-how-to-check-if-awr-snapshot-is-enabled","tag-how-to-modify-awr-snapshot-interval-setting","tag-modify-awr-automatic-snapshot-settings","tag-snapshot-interval","tag-snapshot-retention","tag-what-is-interval-and-retention"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Change AWR Retention and Interval Values - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Change AWR Retention and Interval Values\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Change AWR Retention and Interval Values - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Change AWR Retention and Interval Values\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-16T22:00:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-05-16T22:01:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-21.png\" \/>\n\t<meta property=\"og:image:width\" content=\"567\" \/>\n\t<meta property=\"og:image:height\" content=\"390\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Change AWR Retention and Interval Values\",\"datePublished\":\"2019-05-16T22:00:59+00:00\",\"dateModified\":\"2019-05-16T22:01:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/\"},\"wordCount\":137,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-21.png\",\"keywords\":[\"AWR Automatic Snapshot Settings\",\"awr interval\",\"awr report for specific time interval\",\"awr retention\",\"awr retention period in days\",\"AWR Retention Settings\",\"Change AWR Retention &amp; Interval\",\"change retention and interval\",\"change retention and interval in awr\",\"change snapshot interval\",\"change snapshot retention\",\"Changing AWR Snapshot Retention and Interval\",\"check awr retention in days\",\"dba_hist_wr_control\",\"How to change AWR retention period?\",\"how to check awr retention period in oracle database\",\"how to check if awr snapshot is enabled\",\"How to modify awr snapshot interval setting\",\"Modify AWR Automatic Snapshot Settings\",\"snapshot interval\",\"snapshot retention\",\"What is interval and retention\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/\",\"name\":\"How To Change AWR Retention and Interval Values - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-21.png\",\"datePublished\":\"2019-05-16T22:00:59+00:00\",\"dateModified\":\"2019-05-16T22:01:00+00:00\",\"description\":\"How To Change AWR Retention and Interval Values\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-21.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-21.png\",\"width\":567,\"height\":390},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Change AWR Retention and Interval Values\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Change AWR Retention and Interval Values - Database Tutorials","description":"How To Change AWR Retention and Interval Values","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:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/","og_locale":"en_US","og_type":"article","og_title":"How To Change AWR Retention and Interval Values - Database Tutorials","og_description":"How To Change AWR Retention and Interval Values","og_url":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/","og_site_name":"Database Tutorials","article_published_time":"2019-05-16T22:00:59+00:00","article_modified_time":"2019-05-16T22:01:00+00:00","og_image":[{"width":567,"height":390,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-21.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Change AWR Retention and Interval Values","datePublished":"2019-05-16T22:00:59+00:00","dateModified":"2019-05-16T22:01:00+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/"},"wordCount":137,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-21.png","keywords":["AWR Automatic Snapshot Settings","awr interval","awr report for specific time interval","awr retention","awr retention period in days","AWR Retention Settings","Change AWR Retention &amp; Interval","change retention and interval","change retention and interval in awr","change snapshot interval","change snapshot retention","Changing AWR Snapshot Retention and Interval","check awr retention in days","dba_hist_wr_control","How to change AWR retention period?","how to check awr retention period in oracle database","how to check if awr snapshot is enabled","How to modify awr snapshot interval setting","Modify AWR Automatic Snapshot Settings","snapshot interval","snapshot retention","What is interval and retention"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/","url":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/","name":"How To Change AWR Retention and Interval Values - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-21.png","datePublished":"2019-05-16T22:00:59+00:00","dateModified":"2019-05-16T22:01:00+00:00","description":"How To Change AWR Retention and Interval Values","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-21.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-21.png","width":567,"height":390},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/16\/how-to-change-awr-retention-and-interval-values\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Change AWR Retention and Interval Values"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/12131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=12131"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/12131\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/12132"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=12131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=12131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=12131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}