DBA_PROFILES, and if a user has been assigned a profile other than default, it will be in DBA_USERS
-----Original Message-----
From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, August 15, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: user holding session even after a re-boot
Where can I find their profiles. If your talking about the .profile then is
there a Windoze equivalent cuz I'm not on unix. :(
Dave
-----Original Message-----
Sent: Wednesday, August 15, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L
I have found that if they did not close their session properly, as in the
case of a reboot, that sessions can hang around until they timeout and die
on their own. You can see about the timeout settings in their profiles.
-----Original Message-----
Sent: Wednesday, August 15, 2001 11:11 AM
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: Kevin Lange
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: 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).