Select queries running slow on Physical Standby database
edited Jun 23, 2019 3:10AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered
Hello,
The physical standby database in our environment is in read only with apply mode, all our reporting queries run on this instance.
We are running into a performance issue where a select query takes 10 mins to complete in Primary database and where as the same query takes 10 hours to complete in physical standby database.
We have compared the following in both primary and stand by
1. init paramters
2. SGA and PGA
3. CPU, Memory
4. Query plan and hashvalue
5. Indexes
All the above are same on both primary and standby database. We are hitting a road block here and any help is highly appreciated.
0