statspack report
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: statspack report

  1. #1
    Join Date
    Apr 2001
    Posts
    257

    statspack report

    Does anybody know good documentations that can help me understand the report generated by Statspack? Particularly what's meaningful and what's not.

    Thanks,

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Which is the problem with the Oracle Documentation ?

    Cheers

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Report:

    Latch Name -- Where -- Misses -- Sleeps -- Sleeps
    ------------------------ -------------------------- ------- ---------- -------
    checkpoint queue latch -- kcbk0rrd: update recovery -- 0 -- 13 -- 0
    library cache -- kglhdgn: child: -- 0 -- 9 -- 5
    library cache -- kglic -- 0 -- 5 -- 1
    redo writing -- kcrfsr -- 0 -- 1 -- 0
    redo writing -- kcrfss -- 0 -- 1 -- 2


    Which documentation explain the where section? Thanks.
    Last edited by Calvin_Qiu; 04-04-2003 at 10:58 AM.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Most of the reports in statspack give wait statistics that too they are not correct.
    Only the top 10 SQL statements are useful. Rest of the reports are useless. I would suggest do not use it.

    Start learning how to use some of the internal tables like X$.....

    Tamil

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