Results 1 to 2 of 2

Thread: V$ Tables

  1. #1
    Join Date
    Nov 2006
    Posts
    2

    Unanswered: V$ Tables

    Hi I want to retrieve the following details from the V$ tables, Please help me out with the table names and column names for the following Insformation. Even if some one could provie the exact SQL, It will be much appreciated.

    1. DB User ID
    2. Tables being hit during the operation
    3. Stored procedures being Called
    4. Duration of Execution
    5. NT Domain ID of user
    6. Application name which is calling the DB Objects (SP/Table/sql)

    Thanks In Advance

  2. #2
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    You can take a look a v$session_longops, but as its name implies, you will only see operations there that takes a while to run (3 seconds and forth), most of the information you want you can retrieve it from there.

Posting Permissions

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