Devart Forums

Posted: **Tue 15 Mar 2016 03:02**

Hi everyone,

In our applications we typically use a non-direct method of connecting, and the MACHINE column of V$SESSION is correctly populated with the domain and terminal, as below:

Code: Select all

var oracleConnection1 = new OracleConnection();
oracleConnection1.Direct = false;
oracleConnection1.Server = "DEV";
oracleConnection1.UserId = "MYSCHEMA";
oracleConnection1.Password = "xxx";

MACHINE = 'MYDOMAIN\MYLAPTOP'

However when I use Direct Mode the MACHINE column just has the terminal name:

Code: Select all

oracleConnection2.Direct = true;
oracleConnection2.Server = "Server01";
oracleConnection2.Port = 1521;
oracleConnection2.Sid = "DEV";
oracleConnection2.UserId = "MYSCHEMA";
oracleConnection2.Password = "xxx";
oracleConnection2.Open();

MACHINE = 'MYLAPTOP'

Additionally, I also noticed that the process was 00000:00000.

We are unable to use the non-direct mode in this particular case, but we rely on the values in the MACHINE column for other processes.

Does anyone know any workarounds or fixes? We're running C# against Devart.Data.Oracle.dll v 8.5.602.0.

Thanks,
Jonathan

Posted: **Tue 15 Mar 2016 13:51**

Currently this is a normal behavior, and dotConnect for Oracle does not support output of the domain to the "machine" column and output of the "process" column values in the Direct mode. We will investigate the possibility to support domains for the "machine" column and values for the "process" column in the Direct mode and post here about the results as soon as possible.

Posted: **Wed 16 Mar 2016 01:36**

Thanks for the quick reply! I look forward to hearing how it goes.

Posted: **Wed 13 Apr 2016 01:10**

Hi again,

Any news on whether this will be modified or not?

Cheers,
Jonathan

Posted: **Wed 13 Apr 2016 14:14**

We are investigating the issue and will notify you about the result as soon as possible, but we can't tell any timeframe at the moment.

Posted: **Wed 05 Oct 2016 13:04**

We have supported the output of the domain to the "machine" column and output of the "process" column values in the Direct mode. We will post here when the corresponding build of dotConnect for Oracle is available for download.

Posted: **Thu 06 Oct 2016 15:24**

New build of dotConnect for Oracle 9.1.121 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=34384

Posted: **Mon 07 Nov 2016 04:20**

Fantastic, thanks for the update!

Devart Forums

Direct Mode does not supply domain name in V$SESSION.MACHINE column

Direct Mode does not supply domain name in V$SESSION.MACHINE column

Re: Direct Mode does not supply domain name in V$SESSION.MACHINE column

Re: Direct Mode does not supply domain name in V$SESSION.MACHINE column

Re: Direct Mode does not supply domain name in V$SESSION.MACHINE column

Re: Direct Mode does not supply domain name in V$SESSION.MACHINE column

Re: Direct Mode does not supply domain name in V$SESSION.MACHINE column

Re: Direct Mode does not supply domain name in V$SESSION.MACHINE column

Re: Direct Mode does not supply domain name in V$SESSION.MACHINE column