If the user already has his information displayed on the screen( retrieve
already took place) and his/her machine freezes it is definitely application
problem, may be networking problem but not back end problem.  Printing
problem is not an Oracle problem.  
If he/she is retrieving while printing it may be either.  But still
indications are your programmers didn't write good code.
As to your question regarding the session I think it is not an unusual
behavior.  Check it in couple of minutes.  It should be gone.

-----Original Message-----
Sent: Wednesday, August 15, 2001 12:11 PM
To: Multiple recipients of list ORACLE-L


I have Oracle 7.3.4 running on Windoze NT4.0.  I have been trying to
determine if I have an application problem or a database problem.  I have an
application called MP2 that is causing a user to have their PC freeze up
when they try to print from the application.  I ran a trace on their session
to see what is going on.  I have not looked at the trace file yet but when I
was doing this I noticed that when this person had a session open that I
could see with the query

SELECT sid,serial#,osuser from v$session;

That when they re-booted, their original session stayed open on Oracle.
Should a re-boot have ended the session.  When they logged back in another
session opened and the first one stayed open also.  Is this normal??

Thanks,

Dave
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Reply via email to