How would you force a log switch?
Answers were Sorted based on User's Feedback
Answer / guest
alter system switch logfile
Regards
Abhinav Phadnis
Is This Answer Correct ? | 19 Yes | 2 No |
Answer / rajesh naidu
ALTER SYSTEM SWITCH LOGFILE BY THIS WAY U CAN FORCE TO LOG
SWITCH
Is This Answer Correct ? | 5 Yes | 2 No |
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 |
Answer / amsu
ALTER SYSTEM CHECKPOINT GLOBAL; AND
ALTER SYSTEM ARCHIVELOG CURRENT;
Is This Answer Correct ? | 0 Yes | 5 No |
Name a tablespace automatically created when you create a database.
now one user in online.now i want drop him..how do u drop him?
How does Oracle guarantee data integrity of data changes?
What the different components in replication and what is their use? : sql server DBA
How to make a replica of existing oracle server to another server?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What are the recovery models for a database? : sql server DBA
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is the difference between the SQL Loader and IMPORT utilities?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What happens on checkpoint? : sql server DBA
what is the purpose of catlaog in oracle rman?