Members   Search   Help    Register    Login   Home
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: 122
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: 3359
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
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 Go to previous messageGo to next message
smunir362
Messages: 122
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 Go to previous message
ThomasG
Messages: 1940
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:readonly TOAD...and a lacy guy
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 1 03:12:55 CST 2009

Total time taken to generate the page: 0.63666 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.