Oracle Archive Block Size
How to Check Archive Block Size ? To monitor the applying performance of a standby database, we usually make a query on V$MANAGED_STANDBY like this:… Read More »Oracle Archive Block Size
V$LOG
How to Resolve ORA-01624: log needed for crash recovery of instance
ORA-01624 ORA-01624 means that the redo log group that you want to operate with is needed for recovery once the database startup after a crash.… Read More »How to Resolve ORA-01624: log needed for crash recovery of instance
How to Move Redo Log Location in Oracle
Move LogFile Performance Considerations To improve overall performance, sometimes, we may consider to move redo logs to the location with faster disks, like Solid-State Drive… Read More »How to Move Redo Log Location in Oracle
How to Check Oracle Database Size
At least two scenarios that you may need to know the database size. Server upgrade or migration You have to plan the size of storage… Read More »How to Check Oracle Database Size
How to Resize Redo Logs in Oracle
Increase Redo Log Size The default size of redo logs during installation is 50MB which is too small for production databases. Of course, you can… Read More »How to Resize Redo Logs in Oracle