My database (oracle 184.108.40.206.0) will call another database's (oracle 9i cluster) view through DB Link to get some data.
If we are to access the data for the first time in a particular session, it gives the output within a second.
But if we access the data after 45mins in the same session(already connection is open), the query is running for 9 mins it throws an oracle error.
There is no network issue also(solaris 5.8 server).
select * from where =;
synonym is created in my database for remote database view (schema_name.view_name@dblink_name)
please find the Oracle error below:
ORA-02068: following severe error from RAMBOMAX
ORA-03113: end-of-file on communication channel
SID EVENT STATE WAIT_TIME SECONDS_IN_WAIT P1 P2 P3 SQL_HASH_VALUE
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.