How would you force a log switch?

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

Name a tablespace automatically created when you create a database.

5 Answers  


now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,


How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,


What the different components in replication and what is their use? : sql server DBA

0 Answers  


How to make a replica of existing oracle server to another server?

3 Answers  






suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers   Oracle,


What are the recovery models for a database? : sql server DBA

0 Answers  


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  


What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  


Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  


What happens on checkpoint? : sql server DBA

0 Answers  


what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,


Categories