Understanding AWR snapshots
Hi,
Assuming the snapshots frequency is every quarter of hour.
Assuming that a query is considered as expensive when it spends 1 minute to run : the probability to catch an expensive query during a snapshot is very low.
AWR documentation says that we have to use awrrpt.sql in order to analyze snapshots.
But what does it mean to compare two snapshots where nothing occurs ?
The snapshot is a picture of the database at a particular moment or on a particular period ?
Frederic.
Assuming that a query is considered as expensive when it spends 1 minute to run : the probability to catch an expensive query during a snapshot is very low.
AWR documentation says that we have to use awrrpt.sql in order to analyze snapshots.
But what does it mean to compare two snapshots where nothing occurs ?
The snapshot is a picture of the database at a particular moment or on a particular period ?
Frederic.
0