Explain force logging feature in 9i.
- 1 Answers
- 694 Views
- I also Faced
- E-Mail Answers
Answer / Pawan Kumar Tiwari
Force Logging is a feature introduced in Oracle 9i that ensures every transaction, whether committed or rolled back, gets written to the online redo logs. This is useful for recovering the database to any point in time without the risk of losing uncommitted transactions during recovery. To enable force logging, use the following command: `ALTER DATABASE FORCE LOGGING;`
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the different types of backup available in the oracle?
How many control files should you have?
What are the various ingredients of sga?
What do you understand by recovery catalog?
When configuring sqlnet on the server what files must be set up?
How to drop an oracle database?
How do I become an administrator?
You see multiple extents in the temporary tablespace. Is this a problem?
What is the main function of database?
What are the types of schemas?
What is pga_aggregate_target?
You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?
Oracle General 
