Stack Overflow
Stack Overflow

Questions tagged [statspack]

7 questions
2
votes
4 answers

Performance report for Postgresql

Oracle creates nicely HTML-formatted workload reports (AWR) that list things like instance statistics, wait events, the top ten heavy SQL statements (by number of executions, number of disk reads, and so on). Is there a similar tool for Postgresql?
Thilo
  • 257,207
  • 101
  • 511
  • 656
2
votes
2 answers

Customize Oracle AWR report

Oracle creates nicely HTML-formatted workload reports (AWR) that list things like instance statistics, wait events, the top ten heavy SQL statements (by number of executions, number of disk reads, and so on). Are there (easy) ways to customize this…
Thilo
  • 257,207
  • 101
  • 511
  • 656
1
vote
1 answer

analyzing STATSPACK report

I am looking for a free tool that can analyzes ORACLE 9i statspack report and recommend ways to optimize the DB. Is there such a tool or something similar ?
dov.amir
  • 11,489
  • 7
  • 45
  • 51
1
vote
2 answers

Statspack reporting high number of executions, higher than the total in V$sql

I have been investigating some performance issues in our production system. One piece of SQL jumped out as having a very high execution count, coupled with non stellar performance, peaking at 20+ times a second per node, with an execution time of ~…
Carlovski
  • 121
  • 4
0
votes
1 answer

Is there any parameter in Oracle statspack report to indicate how many commits are done?

Looking at Oracle Statspack report, which has snap of exactly at before and after of the batch program, is it possible to say how much commits has been done on database? How many transaction has been done?
dowonderatwill
  • 109
  • 1
  • 15
0
votes
1 answer

Query plan normalization in statspack

I understand statspack (from Oracle) can display query plan information with snap level 6. I understand that if there is a variation in plan statistics then the same query plan will have multiple entries (same hash value) for same query plan in the…
user179056
  • 604
  • 19
  • 36
0
votes
1 answer

Mysql Statspack Equivalent

Logging inefficient queries and query frequency in MySQL We have a pour performing mysql DB. And I'm interested in logging queries and their frequency to assess which ones my time is best spent on. We have slow query logging but these queries aren't…
Lex
  • 4,749
  • 3
  • 45
  • 66