# Log switch loop, plsql

**URL:** <https://www.batmunkh.net/t/log-switch-loop-plsql/423>\
**Category:** Oracle Database\
**Tags:** plsql, loop\
**Created:** [December 7, 2017, 5:20pm UTC](https://www.batmunkh.net/t/log-switch-loop-plsql/423 "2017-12-07T17:20:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [December 7, 2017, 5:20pm UTC](https://www.batmunkh.net/t/log-switch-loop-plsql/423/1 "2017-12-07T17:20:16Z")

</div>

2 минут тутамд log switch хийх жишээ… Ажлын шаардлагаар sleep ашиглаж үзэв…

```
begin
while(true) loop
execute immediate 'alter system switch logfile';
DBMS_LOCK.sleep(120);
end loop;
end;
/
```