DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 24 of 24

Thread: statspack report

  1. #21
    Join Date
    Sep 2002
    Posts
    411
    THIS IS THE RESULT WE RECENTLY GOT:

    Instance Efficiency Percentages (Target 100%)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Buffer Nowait %: 100.00 Redo NoWait %: 100.00
    Buffer Hit %: 82.78 In-memory Sort %: 99.95
    Library Hit %: 94.15 Soft Parse %: 90.41
    Execute to Parse %: -22.10 Latch Hit %: 99.96
    Parse CPU to Parse Elapsd %: 85.12 % Non-Parse CPU: 99.96

    Shared Pool Statistics Begin End
    ------ ------
    Memory Usage %: 88.41 82.33
    % SQL with executions>1: 44.08 75.78
    % Memory for SQL w/exec>1: 40.65 22.46

    Top 5 Wait Events
    ~~~~~~~~~~~~~~~~~ Wait % Total
    Event Waits Time (cs) Wt Time
    -------------------------------------------- ------------ ------------ -------
    db file scattered read 864,289 ############ 50.00
    db file sequential read 56,338 ############ 50.00
    direct path write 11,160 4,888 .00
    SQL*Net break/reset to client 984 3,544 .00
    log file sync 16,792 2,340 .00


    thing looks better;however, I think there is still FTS going on in the database. The problem is our company is the one who wrote this code. Beside the hint, is there any other way to be sure Oracle used Index, as I mentioned before, all of the indexes are there.

    JEff???? Amar ?????? any advises????

    This database is 8172 and I know 8172 is not good version which had a lot of bugs but I am not sure they are related with this issue.
    Last edited by mike2000; 04-03-2003 at 04:56 PM.

  2. #22
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by marist89

    I get the feeling you are looking for a quick fix for your problems. There's no silver bullet for making poorly written queries go faster, they need to be rewritten. I know it's a lot of work to go back and make them better but, unfortunately, its one of those things that has to be done sometimes.
    Jeff Hunter

  3. #23
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Why do not you set sql_trace = true, and then run tkprof on the trace file?
    This is the best method to know whether your sql is doing FTS or not.

    Tamil

  4. #24
    Join Date
    Sep 2002
    Posts
    411
    thanks,

    more than likely, I know the database does FTS for sure b/c when I add the Oracle hint on one of the reporting table, it run fast.

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