{"id":13648,"date":"2019-11-14T19:38:46","date_gmt":"2019-11-14T19:38:46","guid":{"rendered":"https:\/\/dbtut.com\/?p=13648"},"modified":"2020-11-10T11:43:21","modified_gmt":"2020-11-10T11:43:21","slug":"how-to-check-archive-log-size-generated-per-day-in-oracle","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/","title":{"rendered":"How To Check Archive Log Size Generated per day in Oracle"},"content":{"rendered":"<p>If the Oracle database is in archive log mode, the redo logs are copied as archive files. Archive files will be transferred to the directory or disk group specified by the db_recovery_file_dest parameter.<\/p>\n<p>You can use the following query to check how much archive log is generated daily. The query result will give the total generated archive log size in mb per day.<\/p>\n\n<h1>Query To Check Archive Log Size Generated per day<\/h1>\n<pre class=\"lang:default decode:true\">SQL&gt; select trunc(COMPLETION_TIME) TIME, SUM(BLOCKS * BLOCK_SIZE)\/1024\/1024 SIZE_MB from V$ARCHIVED_LOG group by trunc (COMPLETION_TIME) order by 1;\r\n\r\nTIME         SIZE_MB\r\n--------- ----------\r\n12-DEC-18 26.8168945\r\n13-DEC-18 906.962891\r\n15-DEC-18 49136.6299\r\n16-DEC-18 950.592285\r\n17-DEC-18 2730.39063\r\n20-DEC-18 2881.69336\r\n22-DEC-18 865.368164\r\n23-DEC-18 862.506836\r\n24-DEC-18 947.997559\r\n26-DEC-18  912.13916\r\n27-DEC-18 516.206055\r\n28-DEC-18 864.518555\r\n29-DEC-18 866.547363\r\n30-DEC-18 859.300293\r\n31-DEC-18 862.097656\r\n02-JAN-19 861.827637\r\n04-JAN-19 864.342773\r\n05-JAN-19  863.86084\r\n06-JAN-19 858.840332\r\n08-JAN-19  860.28125\r\n10-JAN-19 869.404297\r\n12-JAN-19 863.470703\r\n13-JAN-19 865.046387\r\n\r\n23 rows selected.\r\n<\/pre>\n<p>If you want to delete unnecessary archive logs you can read my friends article below.<\/p>\n<p>https:\/\/ittutorial.org\/archivelog-delete-until-time-oracle-database<\/p>\n<p>&nbsp;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13648\" class=\"pvc_stats all  \" data-element-id=\"13648\" 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 the Oracle database is in archive log mode, the redo logs are copied as archive files. Archive files will be transferred to the directory or disk group specified by the db_recovery_file_dest parameter. You can use the following query to check how much archive log is generated daily. The query result will give the total &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13648\" class=\"pvc_stats all  \" data-element-id=\"13648\" 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":13649,"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":[5548,5549,5545,5546,5547,5550,5551,5559,5553,5552,5566,5565,5556,5540,5541,2282,5561,5562,5564,5560,5544,5555,5558,5557,5543,5567,5554,5542,5563],"class_list":["post-13648","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-archive-log-size-in-oracle-11g","tag-archive-log-size-in-oracle-12c","tag-archive-log-size-per-day-oracle","tag-archive-log-size-script","tag-archive-log-size-script-query","tag-calculate-archive-log-size","tag-calculate-archive-log-size-oracle","tag-calculate-the-size-of-archive-log-files-each-day","tag-check-archive-log-file-size","tag-check-archive-log-size","tag-check-archive-logs-size","tag-check-archive-logs-size-generated-per-day","tag-command-to-check-archive-log-size-in-oracle","tag-daily-archive-log-size","tag-daily-archive-log-size-in-oracle","tag-db_recovery_file_dest","tag-display-archive-log-generation-by-day","tag-display-archive-log-generation-per-day","tag-find-archive-logs-size-generated-per-day","tag-how-can-we-calculate-archivelog-size-each-day","tag-how-to-calculate-archive-log-size-in-oracle","tag-how-to-check-archive-log-file-size-in-oracle","tag-how-to-check-archive-log-size-in-oracle-11g","tag-how-to-check-archive-log-size-in-oracle-12c","tag-oracle-find-daily-archive-log-size","tag-oracle-get-archive-log-size","tag-query-to-check-archive-log-size-in-oracle","tag-query-to-find-daily-archive-log-size-in-oracle","tag-varchived_log"],"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 Check Archive Log Size Generated per day in Oracle - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Check Archive Log Size Generated per day in Oracle\" \/>\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\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Check Archive Log Size Generated per day in Oracle - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Check Archive Log Size Generated per day in Oracle\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-14T19:38:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-11-10T11:43:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-21.png\" \/>\n\t<meta property=\"og:image:width\" content=\"481\" \/>\n\t<meta property=\"og:image:height\" content=\"313\" \/>\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\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Check Archive Log Size Generated per day in Oracle\",\"datePublished\":\"2019-11-14T19:38:46+00:00\",\"dateModified\":\"2020-11-10T11:43:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/\"},\"wordCount\":109,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-21.png\",\"keywords\":[\"archive log size in oracle 11g\",\"archive log size in oracle 12c\",\"archive log size per day oracle\",\"archive log size script\",\"archive log size script query\",\"calculate archive log size\",\"calculate archive log size oracle\",\"Calculate the size of archive log files each day\",\"check archive log file size\",\"check archive log size\",\"Check Archive Logs Size\",\"Check Archive Logs Size Generated per day\",\"command to check archive log size in oracle\",\"Daily Archive Log Size\",\"Daily Archive Log Size in oracle\",\"db_recovery_file_dest\",\"Display Archive Log Generation by Day\",\"Display Archive Log Generation per Day\",\"Find Archive Logs Size Generated per day\",\"How can we calculate archivelog size each day\",\"how to calculate archive log size in oracle\",\"how to check archive log file size in oracle\",\"how to check archive log size in oracle 11g\",\"how to check archive log size in oracle 12c\",\"oracle find daily archive log size\",\"oracle get archive log size\",\"query to check archive log size in oracle\",\"query to find daily archive log size in oracle\",\"V$ARCHIVED_LOG\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/\",\"name\":\"How To Check Archive Log Size Generated per day in Oracle - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-21.png\",\"datePublished\":\"2019-11-14T19:38:46+00:00\",\"dateModified\":\"2020-11-10T11:43:21+00:00\",\"description\":\"How To Check Archive Log Size Generated per day in Oracle\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-21.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-21.png\",\"width\":481,\"height\":313},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Check Archive Log Size Generated per day in Oracle\"}]},{\"@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 Check Archive Log Size Generated per day in Oracle - Database Tutorials","description":"How To Check Archive Log Size Generated per day in Oracle","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\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"How To Check Archive Log Size Generated per day in Oracle - Database Tutorials","og_description":"How To Check Archive Log Size Generated per day in Oracle","og_url":"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/","og_site_name":"Database Tutorials","article_published_time":"2019-11-14T19:38:46+00:00","article_modified_time":"2020-11-10T11:43:21+00:00","og_image":[{"width":481,"height":313,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/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\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Check Archive Log Size Generated per day in Oracle","datePublished":"2019-11-14T19:38:46+00:00","dateModified":"2020-11-10T11:43:21+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/"},"wordCount":109,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-21.png","keywords":["archive log size in oracle 11g","archive log size in oracle 12c","archive log size per day oracle","archive log size script","archive log size script query","calculate archive log size","calculate archive log size oracle","Calculate the size of archive log files each day","check archive log file size","check archive log size","Check Archive Logs Size","Check Archive Logs Size Generated per day","command to check archive log size in oracle","Daily Archive Log Size","Daily Archive Log Size in oracle","db_recovery_file_dest","Display Archive Log Generation by Day","Display Archive Log Generation per Day","Find Archive Logs Size Generated per day","How can we calculate archivelog size each day","how to calculate archive log size in oracle","how to check archive log file size in oracle","how to check archive log size in oracle 11g","how to check archive log size in oracle 12c","oracle find daily archive log size","oracle get archive log size","query to check archive log size in oracle","query to find daily archive log size in oracle","V$ARCHIVED_LOG"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/","url":"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/","name":"How To Check Archive Log Size Generated per day in Oracle - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-21.png","datePublished":"2019-11-14T19:38:46+00:00","dateModified":"2020-11-10T11:43:21+00:00","description":"How To Check Archive Log Size Generated per day in Oracle","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-21.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-21.png","width":481,"height":313},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/14\/how-to-check-archive-log-size-generated-per-day-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Check Archive Log Size Generated per day in Oracle"}]},{"@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\/13648","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=13648"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13648\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/13649"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=13648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=13648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=13648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}