{"id":14691,"date":"2020-01-13T07:05:18","date_gmt":"2020-01-13T07:05:18","guid":{"rendered":"https:\/\/dbtut.com\/?p=14691"},"modified":"2020-10-02T08:24:16","modified_gmt":"2020-10-02T08:24:16","slug":"how-to-check-and-change-redo-log-switch-frequency","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/","title":{"rendered":"How To Check and Change Redo Log Switch Frequency"},"content":{"rendered":"

If you want to learn What the Redo Log is, you should read the article named “Oracle Redo Log And Archive Log”. I will tell you finding and changing log switch frequency in this article.<\/p>\n

If there is a performance problem in the database, you should look at the REDO LOG Switch frequency. If the log switch frequency is too much, it causes a significant performance problem in the database.<\/p>\n

For example; if a very high IMPORT or DELETE operation is to be performed and the database FORCE LOGGING cannot be disabled, then it makes sense to add a new ONLINE REDO LOG as much as the size of the data to be IMPORTED, and then delete this ONLINE REDO LOG after the operation is finished.<\/p>\n\n

Check Redo Log Switch Frequency<\/h2>\n
\tSQL>\n\tset linesize 300\n\tset pagesize 5000\n\tset trimspool on\n\tcolumn 00 format 99 heading \"00:00\"\n\tcolumn 01 format 99 heading \"1am\"\n\tcolumn 02 format 99 heading \"2am\"\n\tcolumn 03 format 99 heading \"3am\"\n\tcolumn 04 format 99 heading \"4am\"\n\tcolumn 05 format 99 heading \"5am\"\n\tcolumn 06 format 99 heading \"6am\"\n\tcolumn 07 format 99 heading \"7am\"\n\tcolumn 08 format 99 heading \"8am\"\n\tcolumn 09 format 99 heading \"9am\"\n\tcolumn 10 format 99 heading \"10am\"\n\tcolumn 11 format 99 heading \"11am\"\n\tcolumn 12 format 99 heading \"12:00\"\n\tcolumn 13 format 99 heading \"1pm\"\n\tcolumn 14 format 99 heading \"2pm\"\n\tcolumn 15 format 99 heading \"3pm\"\n\tcolumn 16 format 99 heading \"4pm\"\n\tcolumn 17 format 99 heading \"5pm\"\n\tcolumn 18 format 99 heading \"6pm\"\n\tcolumn 19 format 99 heading \"7pm\"\n\tcolumn 20 format 99 heading \"8pm\"\n\tcolumn 21 format 99 heading \"9pm\"\n\tcolumn 22 format 99 heading \"10pm\"\n\tcolumn 23 format 99 heading \"11pm\"\n\tcolumn 24 format 99 heading \"12pm\"\n\tcolumn \"Day\" format a3\n\t\n\tprompt\n\tprompt Redo Log Switches\n\tprompt\n\t\n\tSELECT trunc (first_time) \"Date\",\n\tto_char (trunc (first_time),'Dy') \"Day\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 0, 1)) \"00\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 1, 1)) \"01\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 2, 1)) \"02\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 3, 1)) \"03\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 4, 1)) \"04\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 5, 1)) \"05\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 6, 1)) \"06\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 7, 1)) \"07\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 8, 1)) \"08\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 9, 1)) \"09\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 10, 1)) \"10\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 11, 1)) \"11\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 12, 1)) \"12\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 13, 1)) \"13\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 14, 1)) \"14\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 15, 1)) \"15\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 16, 1)) \"16\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 17, 1)) \"17\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 18, 1)) \"18\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 19, 1)) \"19\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 20, 1)) \"20\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 21, 1)) \"21\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 22, 1)) \"22\",\n\tsum (decode (to_number (to_char (FIRST_TIME, 'HH24')), 23, 1)) \"23\"\n\tfrom v$log_history\n\twhere trunc (first_time) >= (trunc(sysdate) - 14) -- last X days. 0 = today only. 1 = today and yesterday\n\tgroup by trunc (first_time)\norder by trunc (first_time) DES<\/pre>\n
\"\"<\/p>\n
In addition, the Mbps values of the generated redo log can be calculated as follows.<\/p>\n
select round(avg(mb)) mb_avg, round(avg(mb)*8) mbit_avg, round(avg(mb)*8\/86400,2) mbps_avg, round(max(mb)*8\/86400,2) mbps_max from (\nselect trunc(first_time) tdate, sum(blocks*block_size)\/1024\/1024 as mb from v$archived_log where first_time<trunc(sysdate)\nand dest_id=1\ngroup by trunc(first_time));<\/pre>\n
The information of Redo Logs in the database can be found as follows;<\/p>\n
SELECT l.thread#, lf.group#, l.bytes, l.members, lf.member, lf.status, lf.type\nFROM v$log l, v$logfile lf\nWHERE l.group# = lf.group#\nORDER BY 1, 2, 5;<\/pre>\n
\"\"<\/p>\n
Change Redo Log Switch Frequency<\/h2>\n
The log switch operation takes place when Online Redo Logs are full. If you increase redo log size your log switch frequenct will be reduced. But you may want to perform the Log switch operation periodically. This can be done with the ARCHIVE_LAG_TARGET parameter. ARCHIVE_LAG_TARGET parameter forces log switch.<\/p>\n
Let’s test it. We suppose that we have a data guard in this example.<\/p>\n\n
Query the current value of the parameter<\/h4>\n
[Primary-1] SQL> show parameter archive_lag_target;\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\narchive_lag_target                   integer     0\n<\/pre>\n
Check current archive log sequence numbers<\/h4>\n
[Primary-1] SQL> select max(sequence#),thread# from v$archived_log where first_time  >  to_date('27\/01\/2017 13:41:50', 'DD-MM-YYYY HH24:MI:SS')  group by thread#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n           312          1\n           167          2<\/pre>\n
[Physical-1] SQL> select max(sequence#),thread# from v$archived_log where first_time  >  to_date('27\/01\/2017 13:41:50', 'DD-MM-YYYY HH24:MI:SS')  group by thread#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n           312          1\n           167          2<\/pre>\n
[Logical-1] SQL> SELECT max(sequence#),thread#,applied FROM dba_logstdby_log where first_time  >  to_date('27\/01\/2017 13:41:50', 'DD-MM-YYYY HH24:MI:SS')  group by thread#, applied;\n\nMAX(SEQUENCE#)    THREAD# APPLIED\n-------------- ---------- --------\n           312          1 YES\n           167          2 YES\n<\/pre>\n
Change the ARCHIVE_LAG_TARGET Parameter<\/h4>\n
[Primary-1] SQL> alter system set archive_lag_target=60 scope=both sid='*';\n\nSystem altered.<\/pre>\n
It is learned from ALERT LOG whether or not Log Switch operation is performed every minute. Or you can query with the script I shared at the beginning of the article.<\/p>\n
When the value of the parameter is changed, the changes in ALERT LOG are as follows:<\/strong><\/p>\n
[Primary-1]—–>ALERT_LOG<\/strong><\/p>\n
Thu Feb 02 07:24:06 2017\nALTER SYSTEM SET archive_lag_target=60 SCOPE=BOTH;\nThu Feb 02 07:24:07 2017\nThread 1 advanced to log sequence 314 (LGWR switch)\nCurrent log# 2 seq# 314 mem# 0: +DATA\/primary\/onlinelog\/group_2.262.932222811\nThu Feb 02 07:24:07 2017\nDeleted Oracle managed file +FRA\/primary\/archivelog\/2017_01_23\/thread_2_seq_61.529.934026075\nThu Feb 02 07:24:07 2017\nArchived Log entry 5586 added for thread 1 sequence 313 ID 0x69a3f5e6 dest 1:\nLNS: Standby redo logfile selected for thread 1 sequence 314 for destination LOG_ARCHIVE_DEST_2\nThu Feb 02 07:24:07 2017\nLNS: Standby redo logfile selected for thread 1 sequence 314 for destination LOG_ARCHIVE_DEST_3<\/pre>\n
[Primary-2]—–>ALERT_LOG<\/strong><\/p>\n
Thu Feb 02 07:24:14 2017\nThread 2 advanced to log sequence 169 (LGWR switch)\nCurrent log# 3 seq# 169 mem# 0: +DATA\/primary\/onlinelog\/group_3.266.932223145\nThu Feb 02 07:24:14 2017\nDeleted Oracle managed file +FRA\/primary\/archivelog\/2017_01_23\/thread_1_seq_62.527.934026069\nLNS: Standby redo logfile selected for thread 2 sequence 169 for destination LOG_ARCHIVE_DEST_2\nThu Feb 02 07:24:15 2017\nArchived Log entry 5589 added for thread 2 sequence 168 ID 0x69a3f5e6 dest 1:\nThu Feb 02 07:24:15 2017\nLNS: Standby redo logfile selected for thread 2 sequence 169 for destination LOG_ARCHIVE_DEST_3<\/pre>\n
[Standby-1]—–>ALERT_LOG<\/strong><\/p>\n
Thu Feb 02 07:23:53 2017\nMedia Recovery Waiting for thread 1 sequence 314 (in transit)\nRecovery of Online Redo Log: Thread 1 Group 5 Seq 314 Reading mem 0\nMem# 0: +DATA\/standby\/onlinelog\/group_5.267.932283683\nMem# 1: +FRA\/standby\/onlinelog\/group_5.260.932283683\nMedia Recovery Waiting for thread 2 sequence 169 (in transit)\nRecovery of Online Redo Log: Thread 2 Group 8 Seq 169 Reading mem 0\nMem# 0: +DATA\/standby\/onlinelog\/group_8.270.932283685\nMem# 1: +FRA\/standby\/onlinelog\/group_8.263.932283685<\/pre>\n
[Standby-2]—–>ALERT_LOG<\/strong><\/p>\n
Thu Feb 02 07:24:08 2017\nRFS[1]: Selected log 5 for thread 1 sequence 314 dbid 1769705496 branch 934378910\nThu Feb 02 07:24:08 2017\nArchived Log entry 3069 added for thread 1 sequence 313 ID 0x69a3f5e6 dest 1:\nThu Feb 02 07:24:09 2017\nArchived Log entry 3070 added for thread 2 sequence 168 ID 0x69a3f5e6 dest 1:\nThu Feb 02 07:24:09 2017\nRFS[2]: Selected log 8 for thread 2 sequence 169 dbid 1769705496 branch 934378910<\/pre>\n\n
How we can force a log switch?<\/h3>\n
You can force log switch with the below command;<\/p>\n
ALTER SYSTEM SWITCH LOGFILE;<\/pre>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
If you want to learn What the Redo Log is, you should read the article named “Oracle Redo Log And Archive Log”. I will tell you finding and changing log switch frequency in this article. If there is a performance problem in the database, you should look at the REDO LOG Switch frequency. If the …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":484,"featured_media":14698,"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":[7696,1212,7697,7695,7689,7694,7677,7684,7682,7676,7678,7690,7688,7687,7731,7680,7666,7670,7667,7668,7675,7683,7693,7673,7671,7692,7674,7669,7729,7691,7686,7681,7685,7672,7679,7698,7730],"class_list":["post-14691","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-alter-archive_lag_target-parameter","tag-archive_lag_target","tag-archive_lag_target-parameter","tag-change-the-archive_lag_target-parameter","tag-check-archive-log-switch-frequency","tag-check-log-switch-frequency","tag-check-log-switch-frequency-oracle","tag-find-log-switch-frequency","tag-how-to-change-redo-log-switch-frequency","tag-how-to-check-archive-log-switch-frequency-in-oracle","tag-how-to-check-how-many-log-switch-frequency-in-oracle","tag-how-to-check-log-switch-frequency","tag-how-to-check-redo-log-switch-frequency-in-sql-developer","tag-how-to-find-redo-log-switch-frequency","tag-how-we-can-force-a-log-switch","tag-log-file-switch-frequency","tag-log-switch-frequency","tag-log-switch-frequency-oracle","tag-log-switch-frequency-script","tag-log-switch-frequency-script-oracle","tag-oracle-archive-log-switch-frequency","tag-oracle-change-log-switch-frequency","tag-oracle-determine-log-switch-frequency","tag-oracle-log-switch-frequency-query","tag-oracle-log-switch-frequency-tips","tag-oracle-query-log-switch-frequency","tag-oracle-redo-log-switch-frequency-query","tag-oracle-redo-log-switch-frequency-script","tag-oracle-reduce-log-switches","tag-query-log-switch-frequency","tag-query-to-check-redo-log-switch-frequency","tag-query-to-find-log-file-switch-frequency","tag-query-to-find-redo-log-switch-frequency","tag-redo-log-switch-frequency-oracle-11g","tag-redo-log-switch-frequency-oracle-12c","tag-show-parameter-archive_lag_target","tag-what-is-redo-log-switch-in-oracle"],"aioseo_notices":[],"yoast_head":"\nHow To Check and Change Redo Log Switch Frequency - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Find and Change Redo Log Switch Frequency\" \/>\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\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Check and Change Redo Log Switch Frequency - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Find and Change Redo Log Switch Frequency\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-13T07:05:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-02T08:24:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-9.png\" \/>\n\t<meta property=\"og:image:width\" content=\"465\" \/>\n\t<meta property=\"og:image:height\" content=\"306\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Onur ARDAHANLI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Onur ARDAHANLI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"How To Check and Change Redo Log Switch Frequency\",\"datePublished\":\"2020-01-13T07:05:18+00:00\",\"dateModified\":\"2020-10-02T08:24:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/\"},\"wordCount\":351,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-9.png\",\"keywords\":[\"ALTER ARCHIVE_LAG_TARGET Parameter\",\"ARCHIVE_LAG_TARGET\",\"archive_lag_target parameter\",\"Change the ARCHIVE_LAG_TARGET Parameter\",\"check archive log switch frequency\",\"Check Log Switch Frequency\",\"check log switch frequency oracle\",\"find log switch frequency\",\"how to change redo log switch frequency\",\"how to check archive log switch frequency in oracle\",\"how to check how many log switch frequency in oracle\",\"how to check log switch frequency\",\"how to check redo log switch frequency in sql developer\",\"how to find redo log switch frequency\",\"How we can force a log switch?\",\"log file switch frequency\",\"log switch frequency\",\"log switch frequency oracle\",\"log switch frequency script\",\"log switch frequency script oracle\",\"oracle archive log switch frequency\",\"oracle change log switch frequency\",\"oracle determine log switch frequency\",\"oracle log switch frequency query\",\"oracle log switch frequency tips\",\"oracle query log switch frequency\",\"oracle redo log switch frequency query\",\"oracle redo log switch frequency script\",\"oracle reduce log switches\",\"query log switch frequency\",\"query to check redo log switch frequency\",\"query to find log file switch frequency\",\"query to find redo log switch frequency\",\"redo log switch frequency oracle 11g\",\"redo log switch frequency oracle 12c\",\"show parameter archive_lag_target\",\"What is redo log switch in Oracle?\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/\",\"name\":\"How To Check and Change Redo Log Switch Frequency - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-9.png\",\"datePublished\":\"2020-01-13T07:05:18+00:00\",\"dateModified\":\"2020-10-02T08:24:16+00:00\",\"description\":\"How To Find and Change Redo Log Switch Frequency\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-9.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-9.png\",\"width\":465,\"height\":306},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Check and Change Redo Log Switch Frequency\"}]},{\"@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\/7fcd466cd0d347ec64aaa48f18f780c6\",\"name\":\"Onur ARDAHANLI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"caption\":\"Onur ARDAHANLI\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Check and Change Redo Log Switch Frequency - Database Tutorials","description":"How To Find and Change Redo Log Switch Frequency","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\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/","og_locale":"en_US","og_type":"article","og_title":"How To Check and Change Redo Log Switch Frequency - Database Tutorials","og_description":"How To Find and Change Redo Log Switch Frequency","og_url":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/","og_site_name":"Database Tutorials","article_published_time":"2020-01-13T07:05:18+00:00","article_modified_time":"2020-10-02T08:24:16+00:00","og_image":[{"width":465,"height":306,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-9.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"How To Check and Change Redo Log Switch Frequency","datePublished":"2020-01-13T07:05:18+00:00","dateModified":"2020-10-02T08:24:16+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/"},"wordCount":351,"commentCount":4,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-9.png","keywords":["ALTER ARCHIVE_LAG_TARGET Parameter","ARCHIVE_LAG_TARGET","archive_lag_target parameter","Change the ARCHIVE_LAG_TARGET Parameter","check archive log switch frequency","Check Log Switch Frequency","check log switch frequency oracle","find log switch frequency","how to change redo log switch frequency","how to check archive log switch frequency in oracle","how to check how many log switch frequency in oracle","how to check log switch frequency","how to check redo log switch frequency in sql developer","how to find redo log switch frequency","How we can force a log switch?","log file switch frequency","log switch frequency","log switch frequency oracle","log switch frequency script","log switch frequency script oracle","oracle archive log switch frequency","oracle change log switch frequency","oracle determine log switch frequency","oracle log switch frequency query","oracle log switch frequency tips","oracle query log switch frequency","oracle redo log switch frequency query","oracle redo log switch frequency script","oracle reduce log switches","query log switch frequency","query to check redo log switch frequency","query to find log file switch frequency","query to find redo log switch frequency","redo log switch frequency oracle 11g","redo log switch frequency oracle 12c","show parameter archive_lag_target","What is redo log switch in Oracle?"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/","url":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/","name":"How To Check and Change Redo Log Switch Frequency - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-9.png","datePublished":"2020-01-13T07:05:18+00:00","dateModified":"2020-10-02T08:24:16+00:00","description":"How To Find and Change Redo Log Switch Frequency","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-9.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-9.png","width":465,"height":306},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-check-and-change-redo-log-switch-frequency\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Check and Change Redo Log Switch Frequency"}]},{"@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\/7fcd466cd0d347ec64aaa48f18f780c6","name":"Onur ARDAHANLI","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","caption":"Onur ARDAHANLI"},"url":"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14691","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\/484"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=14691"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14691\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14698"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14691"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14691"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14691"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}