DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Program Name without using V$SESSION

  1. 03-06-2006, 06:51 AM #1
    plochert
    plochert is offline Junior Member
    Join Date
    Nov 2004
    Posts
    8

    Program Name without using V$SESSION

    Hi,
    I try to get the user program name which is connected to Oracle 9i. I can't use V$SESSION. I didn't find anything in sys_context() function pour the program name. How can I get this information ?
    Thanks
    Reply With Quote Reply With Quote
  2. 03-06-2006, 07:33 AM #2
    KenCunningham
    KenCunningham is offline Member
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    Which Operating System? If unix, does ps -ef show anything? If Windows, does task manager show the session?
    If I have to choose between two evils, I always like to choose the one I haven't tried yet.
    Reply With Quote Reply With Quote
  3. 03-06-2006, 08:13 AM #3
    plochert
    plochert is offline Junior Member
    Join Date
    Nov 2004
    Posts
    8
    Oracle 9 - HP UX
    But I try to get this information from a trigger and I can't use v$session because of privilege
    Reply With Quote Reply With Quote
  4. 03-06-2006, 08:16 AM #4
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    get the privelege then, if you need it you need it
    Reply With Quote Reply With Quote
  5. 03-06-2006, 10:10 AM #5
    gandolf989's Avatar
    gandolf989
    gandolf989 is offline Senior Advisor
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You could always create a view, or a function owned by another schema that only returns information for the calling session.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width