ALTER SYSTEM CHECKPOINT GLOBAL; AND ALTER SYSTEM ARCHIVELOG CURRENT;

How would you force a log switch?

Question Posted / amsu

Answer Posted / amsu

ALTER SYSTEM CHECKPOINT GLOBAL; AND
ALTER SYSTEM ARCHIVELOG CURRENT;

Is This Answer Correct ?

0 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is the difference between dropping a database and taking a database offline? : sql server DBA

1012

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

992

How to start SQL Server in minimal configuration mode?

7802

What is the importance of a recovery model? : sql server DBA

964

how can you get actual data change values from previous transactions in oracle?

1032

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1917

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2402

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2134

What is the default fill factor value? : sql server DBA

1057

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1053

which background process invoke at the time of upgradation tell me???

2659

What the different types of replication and why are they used? : sql server DBA

1103

how can you communicate with operating system files from oracle?

979

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

962

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

2033