OraFAQ Forum: Client Tools » Worksheet (Oracle 8/9i database tool)

Home » SQL & PL/SQL » Client Tools » Worksheet (Oracle 8/9i database tool) (Oracle 9i 9.2.0.8 Linux)

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

Worksheet (Oracle 8/9i database tool) [message #427033]

Tue, 20 October 2009 12:38

smunir362
Messages: 306
Registered: September 2007

Senior Member

Hi Gurus,
I am using Worksheet (oracle 8) and (oracle 9i)
When I query program from v$session then NULL is displayed.

My question is how to check that the session is using worksheet.

[EDITED by LF: disabled smilies in this post]

[Updated on: Tue, 20 October 2009 16:02] by Moderator

Report message to a moderator

Re: Worksheet (Oracle 8/9i database tool) [message #427035 is a reply to message #427033]

Tue, 20 October 2009 12:56

BlackSwan
Messages: 26759
Registered: January 2009
Location: SoCal

Senior Member

>When I query program from v$session then NULL is displayed.
query machine from v$session

>My question is how to check that the session is using worksheet.
verify it is your PC

Report message to a moderator

Re: Worksheet (Oracle 8/9i database tool) [message #427095 is a reply to message #427035]

Wed, 21 October 2009 02:20

smunir362
Messages: 306
Registered: September 2007

Senior Member

machine is computer name not program.
So it is not the way...
If some other machines are using worksheet and sqlplus. Then how to identify which machine is using worksheet.

Report message to a moderator

Re: Worksheet (Oracle 8/9i database tool) [message #427106 is a reply to message #427095]

Wed, 21 October 2009 02:50

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Depends on how worksheet identifies itself.

Do as BlackSwan suggested. Select your session based on your machine, and see what there is in program, client_info, etc....

Report message to a moderator

Previous Topic:	How to do remote debugging using SQL Dveloper
Next Topic:	Show all fetched rows?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 01 23:43:36 CST 2021