Janine
Thx for the response:
"Spontaneously dies" means this:
19:18 - end of schedule proc, excessive time taken (61 seconds)
19:22 - ns_getform select user_id etc...from users
(Somebody trying to login)
19:22 select passwd
19:22 update sec_sessions
19:22 select from wt_users (our extension to users)
19:22 update users set last_visit
The user logging in then gets a msg - page not available
when you do ps ax | grep nsd - all the nsd threads are gone.
nada.
I agree with you - with such simple queries - it is definitely not a db issue (Ora vs PG)
