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
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What is transparent data encryption? : sql server DBA
what are the types of connection load-balancing?
how can you initialize log miner?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
what is logical system in sap basis
What is dbcc? : sql server DBA
what is grd?
What is the difference between clustered and non-clustered index? : sql server DBA
how can you enable flashback feature?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are statistics, under what circumstances they go out of date, how do you update them?
What the different components in replication and what is their use? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA