Re: slowness on database when connecting to DB

Posted by ErmanArslansOracleBlog on Jun 25, 2018; 7:45am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/slowness-on-database-when-connecting-to-DB-tp6220p6258.html

I said network team, but I also said other things ..

Here ->

Again, You have lots of waits when querying the records from a remote database using a dblink..
Why is that so? Consider improving your design -- I don't know your exact neeeds, but for example, you may use Materialized views. Using MWs you query one time from the db links and populate your db and then you query the MW locally. Currrently I think you query from the dblink directly on-the-fly. This may also be necessary(if you need so) but consider revising it.

Network team should check the network between these databases.. (databases accessed by dblink)
Also a check is needed the database and the client because in AWR, there are also "SQL*Net more data to client" waits.. I don't that the type and size of data you are querying from your application, but you may consider improving your desing for this as well..