Re: Oracle V$Session Question

Thanks...

Rob

"Guenter Nowak" <guenter.nowak_at_gmx.at> wrote in message news:75b726d3.0301140137.298c31ac_at_posting.google.com...
> "Rob Panosh" <rob_panosh_at_asdsoftware.com> wrote in message
 news:<3e1d767c$1_at_nntp01.splitrock.net>...
> > Hello,
> >
> > When my application connects to the database using ADO "Oracle Provider
 for
> > OLE DB" and I query V$Session WHERE shemaname = 'MYSCHEMA' the column
> > Program show my program name "ProvisApp.Exe". Is the configurable when
 I
> > connect to the database. I want to be able to change this value to be
> > 'Rob - ProductVision'.
> >
> > Any help would be appreciated.
> >
> > TIA,
> > Rob Panosh
>
> hi
>
> from metalink.oracle.com
> Note:1022663.6
> Subject: HOW THE PROGRAM COLUMN OF THE V$SESSION TABLE IS POPULATED
>
> Problem Description:
> ====================
> You are interested in knowning how the PROGRAM column of the V$SESSION
> table
> is populated.
> ***Note: This is the same column used to display the Program Name
> information
> in the Session Manager program under Windows.
> Search words: NT, 95, EXECUTABLE, PROCESS
> Solution Description:
> =====================
> The PROGRAM value is actually obtained by the Oracle interface
> library. This
> is typically ORA??WIN.DLL or ORA??.DLL under the MS-Windows platforms.
> The
> library takes advantage of the fact that it is loaded into the calling
> programs address space at runtime and therefore has access to the
> programs
> startup information. The following are the WinAPI calls used by the
> interface
> library to feed the V$SESSION table's PROGRAM column.
> 32bit SQL*Net:
> --------------
> WinAPI call used -- GetStartupInfo()
> ***Note : Uses the 'lpTitle' member from the STARTUPINFO structure
> parameter
> to populate the PROGRAM column.
> 16bit SQL*Net:
> --------------
> WinAPI call used -- GetModuleFileName()
> ***Note: Uses the 'lpFilename' parameter to populate the PROGRAM
> column.
>
>
>
>
> from metalink.oracle.com
> Note:147413.1
> Subject: Example: How to set V$SESSION Properties Using the JDBC Thin
> Driver (SCR 1463)
>
> Overview
> --------
>
> This sample illustrates how to set V$SESSION properties upon
> connection
> using the JDBC Thin driver. The sample queries the table to confirm
> that
> the property has been set. This specified example sets and queries
> the
> PROGRAM field of the V$SESSION table.
>
> Program Notes
> -------------
>
> o This code connects as user SCOTT. When connecting as another
> user,
> ensure that you have the necessary privileges to view the
> V$SESSION
> table.
>
> o Code was tested using the Oracle 8.1.7 JDBC Thin driver against
> the
> 8.1.7 RDBMS, using the 1.2 JDK on Windows 2000 SR 1.
>
> o Because the functionality illustrated in this sample is specific
> to Java,
> it is applicable only to the JDBC Thin driver, not the OCI driver
> or any
> other programmatic interface. For other programmatic interfaces,
> consider the use of built in packages such as
> DBMS_APPLICATION_INFO.
>
> References
> ----------
>
> Information in this article was taken from Oracle Sample Code
> Repository
> Entry #1463.
>
> Caution
> -------
>
> The sample program in this article is provided for educational
> purposes only
> and is NOT supported by Oracle Support Services. It has been tested
> internally, however, and works as documented. We do not guarantee
> that it
> will work for you, so be sure to test it in your environment before
> relying
> on it.
>
>
> Program
> -------
>
> - - - - - - - - - - - - - - - - Code begins here - - - - - - - - - -
> - - - - - -
>
> /*
> * This sample shows how to set V$SESSION values upon
> * connection using the JDBC Thin drdiver. This sample
> * specifically illustrates setting the PROGRAM property of the
> * V$SESSION table. The sample then queries the PROGRAM
> * field to verify that the field has been set as specified.
> *
> * The same syntax can be used to set any field in the V$SESSION
> * table.
> */
>
> // Import the java.sql package
> import java.sql.*;
>
> class SessionProps
> {
> public static void main (String args [])
> throws SQLException
> {
> // Load the Oracle JDBC driver
> DriverManager.registerDriver(new
> oracle.jdbc.driver.OracleDriver());
>
> java.util.Properties props = new java.util.Properties();
> props.put("v$session.program", "My program!");
>
> // Connect to the database
> Connection conn =
> DriverManager.getConnection
> ("jdbc:oracle:thin:scott/tiger_at_mslangorl:1821:V817",
> props);
>
> // Create a Statement
> Statement stmt = conn.createStatement ();
>
> // Select the PROGRAM field from the V$SESSION table
> ResultSet rset = stmt.executeQuery ("select program from
> v$session");
>
> // Iterate through the result
> while (rset.next ())
> System.out.println (rset.getString (1));
> }
> }
>
>
> - - - - - - - - - - - - - - - - Code ends here - - - - - - - - - -
> - - - - - -
>
> Sample Output
> -------------
>
> ORACLE.EXE
> ORACLE.EXE
> ORACLE.EXE
> Sqlplusw.exe
> null
> My program!
Received on Mon Jan 20 2003 - 19:40:32 CET