Procedure Tuning
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Procedure Tuning

  1. #1
    Join Date
    Sep 2005
    Posts
    21

    Procedure Tuning

    Dear All,

    My Procedure is doing DML statements on lots of partition table.It was executed within 4 hours but from last three days it is continuously executing and taking nearly 90% of Cpu resources. I have checked temporary tablespace,undo tablespace both are enough.All update statement are tuned.what all different areas for above should i have to look in ? Please Guide me.

    One same procedure has same logic doing only select on partition table executed within 1 hour.Please Guide me.OS is Linux.

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    What was changed in the "LAST 3 days" in the DB?

    Tamil

  3. #3
    Join Date
    Sep 2005
    Posts
    21
    Client has deployed Oracle RAC's GSD tool on oracle 9i database in last three days

    ---
    dhaval

  4. #4
    Join Date
    Jan 2003
    Location
    Bahrain
    Posts
    109
    Hi,

    +

    Please let me know last three day you can feel the performance issue only on this procedure or in the whole application?

    + Just verify that whether analyse required for this tables. You can easily judge by quering num_rows from dba_tables and count(1) from tables

    + Check the all the related indexes for this tables. Is all the indexes are valid? What is the blevel of these indexes?

    Seelan

  5. #5
    Join Date
    Sep 2005
    Posts
    21
    Dear freinds

    Thanx for your help i have checked trace file of my procedure and i found problem in my procedure.

    Dhaval

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