Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2008
    Posts
    464

    Unanswered: dbms_application_info

    Hi

    I have an application which generates reports from the database and sends them out by email to users.

    I tried to capture how exactly the application was accessing the database and SQLMON shows:

    Code:
    Timestamp: 10:29:49.733
    begin
      dbms_application_info.set_action(:p1);
    end;
    :P1 = 'Checking for schedules'
    ----------------------------------
    Timestamp: 10:29:49.749
    begin
      dbms_application_info.set_action(:p1);
    end;
    :P1 = ''
    ----------------------------------
    Timestamp: 10:29:49.749
    begin
      dbms_application_info.set_client_info(:p1);
    end;
    :P1 = ''
    Is there any way I can debug further? I don't know how to use this info. The application I believe is written in perl.

    Regards
    Shajju

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Oct 2002
    Location
    Cape Town, South Africa
    Posts
    253

    Question

    Quote Originally Posted by shajju View Post
    Is there any way I can debug further?
    I assume you mean how to get more information on what the report engine is running.

    I would suggest SQL trace as being your most effective method of recording SQL run by any process.
    Using SQL Trace and TKPROF

  4. #4
    Join Date
    Aug 2008
    Posts
    464
    Thanks Anacedent. I did check google but probably gave up too soon.

    Thanks dayneo. Will research using SQL Trace. It must be far better than SQL MON.

Posting Permissions

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