Identified the Tuning Portion On Report Generation Performance
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Identified the Tuning Portion On Report Generation Performance

  1. #1
    Join Date
    Oct 2000
    Posts
    250

    Question

    Hello everyone,
    Currently I am facing some performance on the (Oracle Reports) performance running on Oracle Database 8.0.5 standard edition. The users normally will 'feel' the performance degrade when more than 2 users running same or different reports. Sometimes the user need to wait for few hours to generate a report. I check the hitratio is 98%.

    I had checked all SQL statement - it looks fine. The tables has about few hunderd thousand records. I cannot use the table partition as the Oracle Standard Edition not provide it. Is anyone have any idea to solve this problem.

    Thanks.

  2. #2
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    Maybe the report is trying to make some DML (Insert/Update/Delete) in some locked table(s) , and it is wating for the locks ?
    Try (or ask for your DBA) to trace the session of this report in the database, and check the wait views in the database, to find EXACTLY what your report is waiting for.

    Regards,

    Chiappa

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I have read from Tomīs Website that



    o When you query from the PARENT to the CHILD. Consider the EMP, DEPT
    example again. It is very common to query the EMP table in the context of a
    deptno. If you frequently query:

    select * from dept, emp
    where emp.deptno = dept.deptno and dept.deptno = :X;

    to generate a report or something, you'll find not having the index in place
    will slow down the queries.



    May be this is your case?

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    The other reason could be inadequate temporary space or memory.

    Run utlbstat and utlestat to collect statistics and analysis again.

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