How would you force a log switch?
- 4 Answers
- 11414 Views
- I also Faced
- E-Mail Answers
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 |
What is dcl? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Compare and contrast TRUNCATE and DELETE for a table.
What is transparent data encryption? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
How can you rebuild an index?
What is the difference between dropping a database and taking a database offline? : sql server DBA
How does Oracle guarantee data integrity of data changes?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
what is the difference between db2start command and start database manager command?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1403)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3304)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
