Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How would you force a log switch?

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  


Categories