Professional Web Applications Themes

Identify source of a query - Oracle Server

Hi All, I have trouble identifying the source of this query: ===================== SELECT /*+cursor_sharing_exact dynamic_sampling(0) no_monitoring*/ COUNT(*)....... .. .. .. from tablename ==================== Please help, any help is greatly appreciated, Thanks, Lily...

  1. #1

    Default Identify source of a query

    Hi All,

    I have trouble identifying the source of this query:

    =====================
    SELECT /*+cursor_sharing_exact dynamic_sampling(0) no_monitoring*/
    COUNT(*).......
    ..
    ..
    ..
    from tablename
    ====================

    Please help, any help is greatly appreciated,

    Thanks,

    Lily
    Lily Guest

  2. #2

    Default Re: Identify source of a query


    A little more of the query would have been
    helpful, as I think we would have seen some
    very boring column aliases as well as a CASE
    statement, and possible a SAMPLE clause.

    It looks like the start of a query run by run-time
    dynamic sampling - during which dynamic sampling
    is switched off, bind variable substitution is blocked,
    and column_monitoring is disabled.

    --
    Regards

    Jonathan Lewis
    http://www.jlcomp.demon.co.uk

    The educated person is not the person
    who can answer the questions, but the
    person who can question the answers -- T. Schick Jr


    One-day tutorials:
    http://www.jlcomp.demon.co.uk/tutorial.html


    Three-day seminar:
    see http://www.jlcomp.demon.co.uk/seminar.html
    ____UK___November


    The Co-operative Oracle Users' FAQ
    http://www.jlcomp.demon.co.uk/faq/ind_faq.html


    "Lily" <com> wrote in message
    news:google.com... 


    Jonathan Guest

  3. #3

    Default Re: Identify source of a query

    Lily wrote:
     

    And you aren't going to tell us what Oracle version or edition.
    And you aren't going to tell us what front-end tools are installed.
    And you aren't going to tell us what middle-tier may be involved.
    And you aren't going to tell us what applications are being run.
    And you aren't going to give us patch levels.
    Heck you aren't even going to give us the SQL statement you used to
    create this pseudo-query.

    I guess it is coming from magenta. To be more specific a very deep
    magenta with a sort of mesh pattern with silver bells on it. ;-)

    --
    Daniel Morgan
    http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
    http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
    damorganx.washington.edu
    (replace 'x' with a 'u' to reply)

    Daniel Guest

  4. #4

    Default Re: Identify source of a query

    Oops, sorry, okay here goes again..... :)

    RDBMS Version: 9iR2
    Operating System and Version: Solaris 2.8

    The first part of the query is as followed:
    =====================
    SELECT /*+cursor_sharing_exact dynamic_sampling(0) no_monitoring*/
    count(*),count(distinct
    "ID"),sum(vsize("ID")),substrb(dump(min("ID"),16,0 ,32),1,120),substrb(dump(max("ID"),16,0,32),1,120) ,count(distinct
    "TABLE_NAME"),sum(vsize("TABLE_NAME")),substrb(dum p(min(substrb("TABLE_NAME",1,32)),16,0,32),1,120), substrb(dump(max(substrb
    ....
    ....
    from TABLE_NAME;
    ====================

    And am assuming this query is generated after invoking
    dbms_stats.gather_table_stats procedure. And my question now is how
    can I find out which user executed this procedure, and how often it's
    being executed. It seems to affect performance.

    Thank you much,
    Lily
    Lily Guest

Similar Threads

  1. Query to identify and change uppercase data
    By MikeyJ in forum Coldfusion Database Access
    Replies: 5
    Last Post: August 18th, 12:20 PM
  2. Need to Identify nulls in a CF Query
    By garthsenior in forum Coldfusion - Advanced Techniques
    Replies: 7
    Last Post: October 25th, 01:08 PM
  3. Replies: 2
    Last Post: August 6th, 02:08 AM
  4. Adding a new record when the record source is a query.
    By Andy in forum Microsoft Access
    Replies: 0
    Last Post: July 29th, 01:41 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139