Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unanswered: catching v$session.program while active

    Wonderful world of no documentation.

    'They' want to change tables that are being used by programs. These programs, which are unknown, may or may not be doing SELECT statements against the tables to be changed.

    Can't figure out a truly successful method to capture the username and program of a program that becomes active for mere seconds, while executing SELECT statements, then becomes inactive or dissappears. Thus the bond between the username/program and the actual SQL has evaporated.

    Need to know what programs are doing SELECT statements against certain tables. You can safely assume the tables are known, and SELECT statements are being run against them. Using 8i. All else is unknown.

    Any help, suggestions, advice would be greatly appreciated.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: catching v$session.program while active

    Originally posted by tear327
    Wonderful world of no documentation.

    'They' want to change tables that are being used by programs. These programs, which are unknown, may or may not be doing SELECT statements against the tables to be changed.

    Can't figure out a truly successful method to capture the username and program of a program that becomes active for mere seconds, while executing SELECT statements, then becomes inactive or dissappears. Thus the bond between the username/program and the actual SQL has evaporated.

    Need to know what programs are doing SELECT statements against certain tables. You can safely assume the tables are known, and SELECT statements are being run against them. Using 8i. All else is unknown.

    Any help, suggestions, advice would be greatly appreciated.
    AUDIT SELECT ON OWNER.TABLE_NAME;


    HTH & YMMV!

Posting Permissions

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