In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-03-29 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
12c R1 test environment
ARCHIVE_LAG_TARGET forces a log switch after the specified amount of time elapses.
A 0 value disables the time-based thread advance feature; otherwise, the value represents the number of seconds. Values larger than 7200 seconds are not of much use in maintaining a reasonable lag in the standby database. The typical, or recommended value is 1800 (30 minutes). Extremely low values can result in frequent log switches, which could degrade performance; such values can also make the archiver process too busy to archive the continuously generated logs.
It is recommended to switch from half an hour to one hour. Below, 60 seconds are set for experimental testing.
SQL > show parameter lagNAME TYPE VALUE-- archive_lag_target integer 0client_result_cache_lag big integer 3000plsql_ccflags stringSQL > alter system set archive_lag_target=60 -- System altered.SQL > show parameter archive_lag_target per second NAME TYPE VALUE---archive_lag_target integer 60SQL > select name COMPLETION_TIME from v$archived_log where name is not null order by COMPLETION_TIME desc NAME COMPLETION_TIME----+ DATADG/arch/log_1_ 406_961866198_585bafa7.arc 2018-01-25 12-04-59+DATADG/arch/log_1_405_961866198_585bafa7.arc 2018-01-25 12-03-59. Omit
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.