How would you force a log switch?

Answer Posted / rajesh naidu

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

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2063


What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

557


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

6519


Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

601


what is the last version,the release date of that version and fix pack of ibm db2 udb?

1520






How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

656


what is asm?

608


what is ora 24313?what is the procedure to exclude that error?

2103


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

564


How can you control the amount of free space in your index pages? : sql server DBA

737


when does an alert gets signaled?

582


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3311


what is a user-defined lock?

590


what are the types of connection load-balancing?

564


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

1419