Hi there
See www.chriskempster.com and the hints/tips for a article on timeouts for
DBA's.
Re this, check for blocking processes, exec sp_who2 for starters.
Also check the article and go through the various timeouts being (default and
set values).
Cheers
Chris K
Oracle LazyDBA home page