Not really.

Point 1 -- they most likely don't have a terminal (middle tier I suspect or running on a platform like windoze that does not have the concept of a terminal).

Point 2 -- if you use the Oracle jdbc drivers, they do set the machine name properly, i've never seen them NOT set it.


Point 3 -- the OSUSER is the osuser running the dedicated or shared server, not the remote OS user.


Using DBMS_APPLICATION_INFO, you can set this information manually into v$session -- the client_info, action and module columns.



Followup to comment

I just tried it out:

$ cat Emp.java
import java.sql.*;

class Emp
{
public static void main(String[] args) throws SQLException
{
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;

try
{
// Load Oracle driver
DriverManager.registerDriver
(new oracle.jdbc.driver.OracleDriver());
String connect_string =
"jdbc:oracle:oci8:@ora8i.us.oracle.com";

// Connect to the local database
conn = DriverManager.getConnection
(connect_string,"scott", "tiger");

// Query the employee names by job
ps = conn.prepareStatement
( "select username || ',' || server ||','|| osuser||','||machine||','||terminal " +
" from v$session " +
"where sid = ( select sid from v$mystat where rownum = 1 )" );

rs = ps.executeQuery();

while (rs.next())
System.out.println( rs.getString(1) );

rs.close();
ps.close();
conn.close();
}
catch (Exception e)
{
System.out.println(e + "\n");
}
finally
{
if ( rs != null ) rs.close();
if ( ps != null ) ps.close();
if ( conn != null ) conn.close();
}
}
}

$ javac Emp.java

$ java Emp
SCOTT,DEDICATED,tkyte,aria,pts/5


followup to comment

did you use the THICK or THIN drivers. I used OCI8.