Database Administration (MOSC)

MOSC Banner

Session Break During Procedure Execution

edited Jul 11, 2012 5:01AM in Database Administration (MOSC) 7 commentsAnswered
Hi,we are facing very strange issue. we have a database and our development team have written different procedure used  for multiple purpose. some of them are doing data insert and number of records varies from 5000 to 1500000  and some of them are used for normalization i-e take data from .CSV file and normalize it and then insert into an specified table. 

now problem is since last few days we are facing session termination issue. when we execute to run any procedure it get terminated without writing any error message in alert log. and then we have to rerun the procedure again and same procedure get executed successfully. we are running 10gR2(10.2.0.4) on IBM AIX6.1. one more thing there is a firewall between server and client from where we execute the procedure. and there is also a distance b/w client station and server location about 20KM. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center