Re: check oracle client version on server side??
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: melkin4u@xxxxxxxxx
- Date: Thu, 07 Oct 2010 06:57:26 +0200
I am not sure that even in 11gR2 this column is very useful.
SQL> desc GV$SESSION_CONNECT_INFO
Name Null? Type
----------------------------------------- --------
----------------------------
INST_ID NUMBER
SID NUMBER
SERIAL# NUMBER
AUTHENTICATION_TYPE VARCHAR2(26)
OSUSER VARCHAR2(30)
NETWORK_SERVICE_BANNER VARCHAR2(4000)
CLIENT_CHARSET VARCHAR2(40)
CLIENT_CONNECTION VARCHAR2(13)
CLIENT_OCI_LIBRARY VARCHAR2(27)
CLIENT_VERSION VARCHAR2(40)
CLIENT_DRIVER VARCHAR2(9)
CLIENT_LOBATTR VARCHAR2(23)
CLIENT_REGID NUMBER
SQL> select VIEW_DEFINITION
2 from v$fixed_view_definition
3 where VIEW_NAME = 'GV$SESSION_CONNECT_INFO'
4 /
VIEW_DEFINITION
--------------------------------------------------------------------------------
select inst_id, ksusenum, ksuseser, decode(ksuseaty, 0, 'DATABASE',
1, 'OS', 2,
'NETWORK', 3, 'PROXY', 4, 'SERVER', 5, 'PASSWORD', 6, 'EXTERNAL
ADAPTERS', 7,
'INTERNAL', 8, 'GLOBAL', 9, 'EXTERNAL', 10, 'PASSWORD BASED GLOBAL
USER', '?'),
ksuseunm, ksuseban,
decode(ksusecsid,0,'Unknown',nls_charset_name(ksusecsid))
, decode(bitand(ksuseflags,1), 0, 'Heterogeneous', 'Homogeneous'),
decode(ksuse
cllib,1,'Home-based',2,'Full Instant Client', 3,'XE Instant Cl
ient',4,'Light Weight Instant Client', 5,'OCI','Unknown'), S
YS_OP_VERSION(ksuseclvsn), ksusecldrv, decode(bitand(ksusecllbf,1),
1, 'Client
Temp Lob Rfc On', 'Client Temp Lob Rfc Off'),
ksuseclregid from x$ksusecon w
here bitand(ksuseflg,1)!=0 and bitand(ksuseflg,16)=0
SQL> select ksuseunm, ksuseclvsn, sys_op_version(ksuseclvsn)
2 from x$ksusecon
3 where ksuseclvsn <> 0
4 /
KSUSEUNM KSUSECLVSN
------------------------------ ----------
SYS_OP_VERSION(KSUSECLVSN)
----------------------------------------
oracle 186646784
11.2.0.1.0
oracle 186646784
11.2.0.1.0
oracle 186646784
11.2.0.1.0
KSUSEUNM KSUSECLVSN
------------------------------ ----------
SYS_OP_VERSION(KSUSECLVSN)
----------------------------------------
oracle 186646784
11.2.0.1.0
SQL> select sys_op_version(1234) from dual;
SYS_OP_VER
----------
11.2.0.1.0
SQL>
Looks like a place-holder to me.
Stephane Faroult
RoughSea Ltd <http://www.roughsea.com>
Konagora <http://www.konagora.com>
RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>
On 10/06/2010 11:17 PM, Michael Elkin wrote:
> In Oracle 11g new columns were added to the view
> v$session_connect_info , like CLIENT_VERSION but in 10gR2,
> unfortunately, this column does not exist.
>
> Michael
>
>
> On Wed, Oct 6, 2010 at 7:34 PM, Tyfanie Wineriter
> <tyfaniew@xxxxxxxxxxx <mailto:tyfaniew@xxxxxxxxxxx>> wrote:
>
> I have investigated this thoroughly & concluded that no, it is not
> possible
> in Oracle 10gR2 to discover what version of an Oracle client is
> connecting
> to your database. If someone on here discovers otherwise, I would
> love to
> hear about it.
>
> I have heard that in 11g, there is a new parameter in sys_context
> that does
> have this, but I am not on 11g & have not tested it.
>
>
> ~ Tyfanie Wineriter ~
>
> Database Administrator
> University of Oregon
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> <mailto:oracle-l-bounce@xxxxxxxxxxxxx>
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx
> <mailto:oracle-l-bounce@xxxxxxxxxxxxx>]
> On Behalf Of dba1 mcc
> Sent: Tuesday, October 05, 2010 5:42 AM
> To: oracle-l@xxxxxxxxxxxxx <mailto:oracle-l@xxxxxxxxxxxxx>
> Cc: oracle-db-l@xxxxxxxxxxxxxxxxxxxx
> <mailto:oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
> Subject: check oracle client version on server side??
>
> we have ORACLE 10GR2 on DELL LINUX serve. I have questions relate
> to ORACLE
> client connection:
>
> 1. does there have ways to check on server side each ORACLE client
> connection use which version of ORACLE client (e.g. 9ir2, 10gr2, ..)?
>
> 2. any way to check on server side each ORACLE client if connect
> through
> ODBC. Which ODBC use (e.g. ORACLE ODBC 9ir2, 10gr2, or MS ODBC)?
>
> Thanks.
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
>
> --
> Best Regards
> Michael Elkin
Other related posts:
