I have a question about this issue and it's still a mysteries, could someone throw out some hint.
We have a procedure on our client database, it access to our database through DB Link, basically the proc go to our database and grab the data and pull it to their database do some business logic and update some of the records on our database. The two tables on our side is not big (<100 rows). For some reason, every time the procedure was executed, it froze. After some analysis, the DBA requested to do SQL* trace during the execution of the proc.
Is his approach is appropriate??? Could anyone think of the reason??? BTW, my database and the client database was connected via fiber optics. could it be the firewall set up or configuration????