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

Thread: v$session

  1. #1
    Join Date
    Feb 2002
    Posts
    54
    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?

    Tnx.


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

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Hi,

    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

    Regards
    Jim
    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