I have 2 enviroments.In one enviroment query runs within 7 seconds ,in another enviroment it takes 4 hours. Both have same memory,cpu core,same partitions.
There is no blockings as well.
memory ultization is 50% and cpu utilization is 60%. What will be a issue?It's nightmare ...
I have rebuilded thee index and updated the stats but no luck.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.