Profile Usage Curiosity (WAS) Re: user holding session even after a re-boot
On Wed, 15 Aug 2001, [EMAIL PROTECTED] wrote: > I was talking about the connection profiles that you can use to > set resource limits when you run the > > create profile > > command. > > With this you can create a profile for a set of users that you > can then attach to a user either when you create it or thru the > alter user command. > > The profile lets you set such things as CONNECT_TIME and > IDLE_TIME. Maybe the IDLE_TIME setting might let those > processes drop off. I haven't actually used these before. I have always just had a couple of application users which were defined for the needs of applications. Was curious to hear some others give overviews on how and why have people used these. They seem to be a very good way to control access when you have a large number of people that will be accessing your database through an ad-hoc tool, like sqlplus, instead of a specific application. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Galen Boyer 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).
Platform dependency on released connections (WAS) Re: user holding session even after a re-boot
On Wed, 15 Aug 2001, [EMAIL PROTECTED] wrote: > Guess the bottom line is the behavior of a released connection > is platform dependent. What do you guys think? I would hope this isn't the case. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Galen Boyer 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).
RE: user holding session even after a re-boot
Title: RE: user holding session even after a re-boot 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).
RE: user holding session even after a re-boot
I was talking about the connection profiles that you can use to set resource limits when you run the create profile command. With this you can create a profile for a set of users that you can then attach to a user either when you create it or thru the alter user command. The profile lets you set such things as CONNECT_TIME and IDLE_TIME. Maybe the IDLE_TIME setting might let those processes drop off. To see what your current profile settings are when logged in as one of the users do a select * from user_resource_limits. Mine currently say : COMPOSITE_LIMIT UNLIMITED SESSIONS_PER_USERUNLIMITED CPU_PER_SESSION UNLIMITED CPU_PER_CALL UNLIMITED LOGICAL_READS_PER_SESSIONUNLIMITED LOGICAL_READS_PER_CALL UNLIMITED IDLE_TIMEUNLIMITED CONNECT_TIME UNLIMITED PRIVATE_SGA UNLIMITED I have no profile setup for this user and my default sets all to unlimited. -Original Message- Sent: Wednesday, August 15, 2001 12:56 PM To: Multiple recipients of list ORACLE-L 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). -- 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 fro
RE: user holding session even after a re-boot
Title: RE: user holding session even after a re-boot Well, that sounds like an optimal environment, Kevin. I've seen Oracle client zombie sessions hang around for days and chew up CPU. I had to write a shell script to identify these sessions and kill them in both the OS and in Oracle. This was HP/UX. I've seen the same thing on Solaris. And so I'm told OpenVMS does not have this problem. Profiles will timeout a session that is idle, not one that is busy cranking away on who knows what statement it was executing when the messy app either dropped the connection unexpectedly or the user rebooted. That is, unless you set a different resource limit on the profile and assign it to the app user. I found that was very messy and I got more complaints than anything else. Guess the bottom line is the behavior of a released connection is platform dependent. Lisa Koivu Gimp and Oracle DBA Ft. Lauderdale, FL, USA -Original Message- From: Kevin Lange [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 12:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: user holding session even after a re-boot 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).
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).
RE: user holding session even after a re-boot
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).
RE: user holding session even after a re-boot
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).