How would you force a log switch?

Question Posted / guest

4 Answers
13706 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

Explain materialized views and how they are used.

0 Answers

Explain what partitioning is and what its benefit is.

2 Answers

i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers Infozech, Wipro,

How to start SQL Server in minimal configuration mode?

1 Answers

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers

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

2 Answers IBM,

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

7 Answers TCS,

Query processing is slow(eg select query)how will u solve that

3 Answers TCS,

what are the performance views in an oracle rac environment?

0 Answers Oracle,

Name two files used for network connection to a database.

5 Answers

what is the purpose of catlaog in oracle rman?

2 Answers Value Labs,

What are the steps you will take to improve performance of a poor performing query?

0 Answers

For more DB Administration Interview Questions Click Here