What is Log Switch ?

Question Posted / guest

2 Answers
5583 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is Log Switch ?..

Answer / guest

The point at which ORACLE ends writing to one online
redo log file and begins writing to another is called a log
switch.

Is This Answer Correct ?

11 Yes

1 No

What is Log Switch ?..

Answer / rajendra biswal

A log switch occurs when one online redo log has been
filled and the next online redo log is going to be filled.
A log switch always triggers a checkpoint.

Is This Answer Correct ?

3 Yes

1 No

Post New Answer

More Database Management Interview Questions

when All datafiles related to a Tablespace are removed ?

0 Answers

i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........

0 Answers

What is the use of RECORD LENGTH option in EXP command ?

2 Answers

What is buffer manager?

0 Answers

What is database partition key?

0 Answers

What happens when my integer identity runs out of scope?

0 Answers

Can we use a Restricted packaged procedure in WHEN_TEXT_ITEM trigger ?

1 Answers

Why is database used?