DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: SQL Statements ?????

  1. #1
    Join Date
    Feb 2003
    Posts
    69

    SQL Statements ?????

    Hi all,

    Where we can find running SQL statements ? View please ???
    HTML

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    v$sqlarea
    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!

  3. #3
    Join Date
    Feb 2003
    Posts
    69
    Thanks for your response and what about v$SQL ????

    What it shows ???
    HTML

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

    "V$SQLAREA - This view lists statistics on shared SQL area and contains one row per SQL string. It provides statistics on SQL statements that are in memory, parsed, and ready for execution."

    "V$SQL - This view lists statistics on shared SQL area without the GROUP BY clause and contains one row for each child of the original SQL text entered."

    v$sql contails the details if you have multiple copies in the shared pool, e.g. if two users issue the same query against independent tables of the same name v$sql will contain both entries whereas v$sqlarea is an aggregate which selects distinct statements.
    Last edited by jovery; 06-06-2003 at 10:50 AM.
    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!

  5. #5
    Join Date
    Feb 2003
    Posts
    69
    ok

    So, when i issued sql statement which takes long time, means not yet given any results. Can we find those statements from V$sqlarea ?

    right ?
    HTML

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

    You can also monitor the execution from v$session_longops
    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!

  7. #7
    Join Date
    Feb 2003
    Posts
    69
    Thanks you very much. i would like to know your mail id. If you have not any problems?
    HTML

  8. #8
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Can I also have your mail ID please. I'd like to send you personal emails.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  9. #9
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Can I have some of your old bank statements please?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  10. #10
    Join Date
    Jan 2001
    Posts
    3,134
    I want a pint of blood and your pin number please.

    MH
    I remember when this place was cool.

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