Mastering the Oracle Stack, One Post at a Time.
Oracle Database 11g, 11gR2
We are in the middle of migrating several databases to a new data center. One of the requirement is to do rigorous load and stress tests on the new servers to make sure they can handle the load and the configuration is correct. For this purpose, there are several load/stress test scripts are written and … Read more
This blog identifies the DBA steps required to migrate databases from one disk array to another. Identify the ASM diskgroups and their disk (LUN) sizes Login to the ASM instance and identify the LUNs allocated to server. SQL> SET PAGES 999 SQL> col name format a15 For 11g ASM: SQL> select d.group_number, g.name, d.os_mb from … Read more