DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: web application page/form/uery taking longer time to submit/execute

  1. #1
    Join Date
    Nov 2001

    web application page/form/uery taking longer time to submit/execute

    Application user is sitting in Remote area accessiing
    wed based application saying that his one of his web
    page(form) is taking longer time to submit/execute,
    he says there were no problems till yesterday but this
    problem started today only

    As a DBA i know there are 4 database running on same
    server but iam New oracle DBA i donot know which appliaction
    or database he is using. My senior DBA says there are no
    changes on database side or no parameters change,
    no OS side change

    Could any one tell me what are the different step by
    step solution can i give to applicatuion user.what could
    lead this type of problems

    Tks in advance
    J Gangadhar

  2. #2
    Join Date
    Aug 2001
    Do you have any Weblogic SERVER pool. Ask the USER which server in the pool is he hitting (IP address).From this u can know if the server is heavely loaded, if so restarting the weblogic on the server might solve the issue.If this is not the issue.issue top command on the DB server and check for process id consuming high CPU and based on the process id use the following SQL to find the ORACLE SESSION ID and from the session id find the HIGH RESOURCE SQL

    select s.sid, s.serial#
    from v$session s, v$process p
    where s.paddr = p.addr
    and p.spid = &pid ---unix process id

    select sql_text from v$sql a , v$session b
    where a.hash_value = b.sql_hash_value
    and b.sid = &sid --- oracle session id

    also u can use this SQL to find out the WAIT EVENT by the ACTIVE session.From the EVENT NAME u can know if a SQL is doing FULL TABLE SCAN or buffer busy wait or other wait event

    select sw.sid,s.serial#,sa.sql_text,sw.event,s.schemaname "oracle user",s.osuser "os user",s.machine from v$session_Wait sw,v$sqlarea sa,v$session s where s.status='ACTIVE' and s.sql_hash_value=sa.hash_value
    and s.sid = sw.sid;

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