Home » SQL & PL/SQL » Client Tools » Worksheet (Oracle 8/9i database tool) (Oracle 9i 9.2.0.8 Linux)
Worksheet (Oracle 8/9i database tool) [message #427033] Tue, 20 October 2009 12:38 Go to next message
smunir362
Messages: 294
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 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
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
Re: Worksheet (Oracle 8/9i database tool) [message #427095 is a reply to message #427035] Wed, 21 October 2009 02:20 Go to previous messageGo to next message
smunir362
Messages: 294
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.
Re: Worksheet (Oracle 8/9i database tool) [message #427106 is a reply to message #427095] Wed, 21 October 2009 02:50 Go to previous message
ThomasG
Messages: 3185
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....
Previous Topic: How to do remote debugging using SQL Dveloper
Next Topic: Show all fetched rows?
Goto Forum:
  


Current Time: Wed Sep 28 14:16:43 CDT 2016

Total time taken to generate the page: 0.16852 seconds