OraFAQ Forum: SQL & PL/SQL » SYS_CONTEXT('USERENV','TERMINAL') gives "unknown" result in SQL Developer tool[split]

Home » SQL & PL/SQL » SQL & PL/SQL » SYS_CONTEXT('USERENV','TERMINAL') gives "unknown" result in SQL Developer tool[split]

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SYS_CONTEXT('USERENV','TERMINAL') gives "unknown" result in SQL Developer tool[split] [message #630870]

Mon, 05 January 2015 23:43

prejib
Messages: 126
Registered: March 2009
Location: India

Senior Member

Hi ,
I am getting the result 'unknown' when I execute the below query in sqldeveloper. Can you please help me to solve this ?

select SYS_CONTEXT('USERENV','TERMINAL') from dual;
Also please help me to get the query which is used to identify the client tool like sql developer , Toad etc. which is used to access the Oracle ..

The above details are for uditing purpose.

Regards,
Prejib

Edited by Lalit : topic split from http://www.orafaq.com/forum/t/12918/

[Updated on: Tue, 06 January 2015 09:25] by Moderator

Report message to a moderator

Re: how to find terminal and session id from weblogic. [message #630881 is a reply to message #630870]

Tue, 06 January 2015 01:12

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ You cannot "solve" it. Oracle can give you only what it is given to it. Check with HOST parameter instead of TERMINAL.
2/ With SYS_CONTEXT you have the MODULE parameter but once again it is set only if the program set it.
With V$SESSION you have the PROGRAM and MODULE columns.

Report message to a moderator

Re: how to find terminal and session id from weblogic. [message #630926 is a reply to message #630881]

Tue, 06 January 2015 06:09

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> I am using oracle 8.0.5.
You reap what you sow.
Above is ancient, obsoleted, unsupported & EXTREMELY buggy.

SESSION_ID can be obtained from V$MYSTAT

Report message to a moderator

Re: how to find terminal and session id from weblogic. [message #630930 is a reply to message #630926]

Tue, 06 January 2015 06:15

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Previous poster was running with 8.0.5 (in 2002), the current one's version is unknown. Smile

Report message to a moderator

Re: how to find terminal and session id from weblogic. [message #630937 is a reply to message #630930]

Tue, 06 January 2015 07:30

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

OP seems to shamelessly disobey forum rules even after being registered for close to 6 years Sad

Report message to a moderator

Re: how to find terminal and session id from weblogic. [message #630941 is a reply to message #630937]

Tue, 06 January 2015 08:07

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What does this mean? Which OP? Are you talking to the one that did not come since 10 years?

Report message to a moderator

Re: how to find terminal and session id from weblogic. [message #630944 is a reply to message #630941]

Tue, 06 January 2015 08:36

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Sorry, I mistakenly used "OP". I meant @prejib.

@Michel, how difficult is it for you to understand that my reply was to user " prejib".

P.S. : It is not about replying to an old thread, but I find the new question by user "prejib" to be different from the original topic.

[Updated on: Tue, 06 January 2015 08:38]

Report message to a moderator

Re: how to find terminal and session id from weblogic. [message #630945 is a reply to message #630944]

Tue, 06 January 2015 08:45

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

In this case, as a moderator, you should split the topic not post this kind of stuff.
You could also PM the poster.
Now the topic is really pollute by unrelated stuff.

Quote:

how difficult is it for you to understand that my reply was to user " prejib".

I didn't even understand your whole post and its purpose (and so the target of it, of course).
You said "OP seems to shamelessly disobey forum rules" and do not which "rules" which seem to be one rule.

[Updated on: Tue, 06 January 2015 08:49]

Report message to a moderator

Re: how to find terminal and session id from weblogic. [message #630946 is a reply to message #630945]

Tue, 06 January 2015 08:52

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Yes, I was about to split the topic, and I am doing it now. You first replied to user "prejib" and didn't moderate.

Report message to a moderator

Re: how to find terminal and session id from weblogic. [message #630949 is a reply to message #630946]

Tue, 06 January 2015 10:14

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, it is not compulsory required to do so.
If you think it is needed you can do it instead of chatting.
I already spend more time to moderate than to actually post.
This is the reason there are many moderators, no one can do all the job.

Report message to a moderator

Previous Topic:	Delete using a CTE
Next Topic:	How to find tables with nullable Unique Keys

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 29 07:23:37 CDT 2025