Archive Log mode can have a large impact on the performance of your Oracle database since it logs every single change to the data. If you don’t require this level of rollback then here are the commands to switch it off:
- Login to sqlplus – sqlplus / as sysdba
- Check your current log mode to make sure you are using archive logging – select log_mode from v$database;
- Shutdown the database – shutdown immediate;
- Mount the database but do not start it for operation - startup mount;
- Set noarchivelog mode - alter database noarchivelog;
- Open the database for normal operation - alter database open;
Done.