RE: JDBC and login.sql
- From: "Elliott, Patrick" <patrick.elliott@xxxxxxxxxxxxx>
- To: "Jon.Crisler@xxxxxxx" <Jon.Crisler@xxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 27 Feb 2008 12:39:44 -0600
The way to do this is with a login trigger. login.sql only gets executed for
sqlplus connections.
Pat
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Crisler, Jon
Sent: Wednesday, February 27, 2008 12:29 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: JDBC and login.sql
Does the login.sql get run if a user connects to a 10g db via JDBC ? I want to
put some specific settings for specific JDBC users....such as "alter session
set session_cached_cursors" and the only way I can think of is via login.sql.
[CONFIDENTIALITY AND PRIVACY NOTICE]
Information transmitted by this email is proprietary to Medtronic and is
intended for use only by the individual or entity to which it is addressed, and
may contain information that is private, privileged, confidential or exempt
from disclosure under applicable law. If you are not the intended recipient or
it appears that this mail has been forwarded to you without proper authority,
you are notified that any use or dissemination of this information in any
manner is strictly prohibited. In such cases, please delete this mail from your
records.
To view this notice in other languages you can either select the following link
or manually copy and paste the link into the address bar of a web browser:
http://emaildisclaimer.medtronic.com
- References:
- high "latch: cache buffers chains" waits in 10.2.0.3 DB
- From: bkaltofen@xxxxxx
- Re: high "latch: cache buffers chains" waits in 10.2.0.3 DB
- From: Greg Rahn
- RE: high "latch: cache buffers chains" waits in 10.2.0.3 DB
- From: krish.hariharan
- Re: high "latch: cache buffers chains" waits in 10.2.0.3 DB
- From: Greg Rahn
- Re: high "latch: cache buffers chains" waits in 10.2.0.3 DB
- From: bkaltofen@xxxxxx
- RE: high "latch: cache buffers chains" waits in 10.2.0.3 DB
- From: Shamsudeen, Riyaj
- JDBC and login.sql
- From: Crisler, Jon
Other related posts:
- » JDBC and login.sql
- » Re: JDBC and login.sql
- » RE: JDBC and login.sql
- » Re: JDBC and login.sql
- » RE: JDBC and login.sql
- high "latch: cache buffers chains" waits in 10.2.0.3 DB
- From: bkaltofen@xxxxxx
- Re: high "latch: cache buffers chains" waits in 10.2.0.3 DB
- From: Greg Rahn
- RE: high "latch: cache buffers chains" waits in 10.2.0.3 DB
- From: krish.hariharan
- Re: high "latch: cache buffers chains" waits in 10.2.0.3 DB
- From: Greg Rahn
- Re: high "latch: cache buffers chains" waits in 10.2.0.3 DB
- From: bkaltofen@xxxxxx
- RE: high "latch: cache buffers chains" waits in 10.2.0.3 DB
- From: Shamsudeen, Riyaj
- JDBC and login.sql
- From: Crisler, Jon