would like to know memory usage past weeks for allocated Memory_Target.

Hello Team,

would like to take / query a report which should tell me the utilization of my memory_Target/SGA with interval of every hours or so for past few weeks, where it should provide min and maxium usage of Memory for each day as well.

I need to create above report by using oracle dictionaries so that will come to know what is the average and peak memory etc., Hence we could able to decide capacity of the existing where in if we allocate more how much / what way will

get benefit out of it.

Hence kindly provide / update the scripts which will provide above expected reports.