How would you force a log switch?

Question Posted / guest

4 Answers
13861 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How would you force a log switch?..

Answer / guest

alter system switch logfile

Regards
Abhinav Phadnis

Is This Answer Correct ?

19 Yes

2 No

How would you force a log switch?..

Answer / rajesh naidu

ALTER SYSTEM SWITCH LOGFILE BY THIS WAY U CAN FORCE TO LOG
SWITCH

Is This Answer Correct ?

5 Yes

2 No

How would you force a log switch?..

Answer / senthil

By this way also you can force log switch:

ALTER SYSTEM CHECKPOINT

FAST_START_MTTR_TARGET="timeSpecification"

Is This Answer Correct ?

4 Yes

5 No

How would you force a log switch?..

Answer / amsu

ALTER SYSTEM CHECKPOINT GLOBAL; AND
ALTER SYSTEM ARCHIVELOG CURRENT;

Is This Answer Correct ?

0 Yes

5 No

Post New Answer

More DB Administration Interview Questions

What is RAID and what are different types of RAID configurations?

1 Answers

What is transparent data encryption? : sql server DBA

0 Answers

What are the ways tablespaces can be managed and how do they differ?

2 Answers IBM,

How do you resize a data file?

2 Answers

How many packages we have in db

1 Answers Tesco,

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers TCS,

What is the importance of a recovery model? : sql server DBA

0 Answers

What is a system database and what is a user database? : sql server DBA

0 Answers

how can you implement fine-grained auditing?

0 Answers Oracle,

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers TCS,

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers

Why would you call update statistics? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here