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

Thread: v$session

Hybrid View

  1. #1
    Join Date
    Feb 2002
    Good Day!

    How come i cant see the values of the program column when i query the v$session? My database is 8.1.7 running on solaris 8.

    I used to do this in 8.1.6, and i can see the values but now in 8.1.7 i cant.

    By the way, this is the query i used:

    select username,terminal,program
    from v$session

    Do i need to run some patches?


    Manifest plainness,
    embrace simplicity,
    reduce selfishness,
    have few desires. LAO TZU

  2. #2
    Join Date
    Jan 2002
    Up s**t creek

    Are you running the 8.1.6 client against the 8.1.7 database, if you are it's possible your hitting a bug which is fixed in the 8.1.7 client.

    The bug reference is 1237128

    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

Posting Permissions

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

Click Here to Expand Forum to Full Width