How would you force a log switch?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What types of replication are supported in sql server? : sql server DBA

589


What would you do with an "in-doubt" distributed transaction?

1407


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

6479


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

578


who owns the operating system files created by the utl_file package?

550






Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1486


how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

2958


Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

1710


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

534


what are the types of connection load-balancing?

553


What are the commands used in dcl? : sql server DBA

567


Why does Oracle not permit the use of PCTUSED with indexes?

2311


What are statistics, under what circumstances they go out of date, how do you update them?

1799


What is the default fill factor value? : sql server DBA

565


I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

1636