The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
73 views

How to measure improvement after splitting tablespaces into multiple disk volumes? (Oracle 10g AWR)

I have a recently released 10 000 user analytical application that is suffering from performance issues because of excessive amount of transactions. Apart from re writing many of the SQLs in the ...
2
votes
1answer
416 views

When is a row added to DBA_HIST_SQLSTAT?

I don't understand the criteria that entails an additional record in the dba_hist_sqlstat view. I have expected there to be at most one entry per sql_id and snap_id, that is, the following statement ...