Results 1 to 3 of 3

Thread: [Oracle 9i] Connecting DBA views

  1. Nov 5th, 2009, 04:38 PM #1
    abhijit
    abhijit is offline

    Thread Starter
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,228

    [Oracle 9i] Connecting DBA views

    How do you monitor SQL queries that your session is running? I know there's v$session and v$sqlarea views. What's the relationship between these two?

    Any ideas?
    Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
    save a blobFileStreamDataTable To Text Filemy blog
    Reply With Quote Reply With Quote
  2. Nov 5th, 2009, 08:31 PM #2
    leinad31
    leinad31 is offline
    PowerPoster
    Join Date
    Nov 2002
    Location
    Manila
    Posts
    7,629

    Re: [Oracle 9i] Connecting DBA views

    http://www.orafaq.com/node/758

    v$session.saddr = v$open_cursor.saddr
    v$open_cursor.hash_value = v$sqlarea.hash_value

    Be mindful of performance hit when querying these tables though, e.g. don't try to select values for all sessions as other users may "hang".
    Last edited by leinad31; Nov 5th, 2009 at 08:37 PM.
    Roman Numerals, Number In Words,Indian Currency Format, Modified Insertion Sort, Fibonacci
    Reply With Quote Reply With Quote
  3. Nov 6th, 2009, 12:14 AM #3
    leinad31
    leinad31 is offline
    PowerPoster
    Join Date
    Nov 2002
    Location
    Manila
    Posts
    7,629

    Re: [Oracle 9i] Connecting DBA views

    Also, depending on oracle db version, v$sqlarea.sqltext may be incomplete/truncated. In which case you will have to retrieve query parts from v$sqltext
    Roman Numerals, Number In Words,Indian Currency Format, Modified Insertion Sort, Fibonacci
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this 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