Oracle Database Discussions

Dear friends,

My database (oracle 9.2.0.8.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 <synonym> where <column_name>=<Value>;

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
--- ----- ----- --------- --------------- -- -- -- ---------------

547 SQL*Net message to client WAITED KNOWN TIME -1 0 1413697536 1 0 951575186

283 SQL*Net message from dbli WAITING 0 441 675562835 1 0 3503340408

298 SQL*Net message from dbli WAITING 0 199 675562835 1 0 3503340408

572 SQL*Net message from dbli WAITING 0 485 675562835 1 0 3503340408

632 SQL*Net message from dbli WAITING 0 358 675562835 1 0 3503340408

634 SQL*Net message from dbli WAITING 0 250 675562835 1 0 3503340408

581 SQL*Net message from dbli WAITING 0 208 675562835 1 0 3503340408

561 SQL*Net message from dbli WAITING 0 376 675562835 1 0 3503340408

520 SQL*Net message from dbli WAITING 0 413 675562835 1 0 3503340408


What could be the reason for this? could some one please help me on this?

Thanks,
Prathap