Results 1 to 2 of 2

Thread: source file

  1. #1
    Join Date
    Nov 2003
    Location
    kualalumpur
    Posts
    89

    Unanswered: source file

    Hi all DBAs,
    Iam into Fine tuning of the database.(oracle8.1.6-HPUX11.0).
    I got all the sql statements which r causing the most cpu usage.
    But,even after fine tuning the queries I need to replace them with the old ones.but they could be coming from a jsp file are a forms or report.
    How to identify the corresponding file..
    I mean to say how to identify the source file of the query.
    Please help me in this regard.
    thanks in advance.
    sridhar

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Either ask around, or use a filesearch tool like GREP to search all possible source files! The server knows nothing about "source files" so it cannot possibly help.

Posting Permissions

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