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
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
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
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