how to find out peak workload and peak workload hours ?
We have recieved a query from client.
they want us to tell them peak work load (volume of data database manage at peak work load hours).
now the question is how to find out peak workload and peak workload hour in live prod database?
i do not think AWR report will give any clue on this even if when extract it for the hours when my database is into some daily planned activity with lots of transactions.
share your findings? thanks