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

What the different components in replication and what is their use? : sql server DBA

0 Answers  


A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  


what are the performance views in an oracle rac environment?

0 Answers   Oracle,


how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,


how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  


what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,


what is the use of ocr?

0 Answers   Oracle,


if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  


why Datapump is faster than traditional export and import

4 Answers   Mphasis,


Explain the difference between a data block, an extent and a segment.

2 Answers  


What are the different sql server versions you have worked on? : sql server DBA

0 Answers  


Categories