we are having problem with this big report it seems that the report is using huge amout of memory we have doubles the amount of pga_aggregate_target to 239mb still getting this error. is there anyway to calculate the value for pga_aggregate_target for this particular session or sql statment?
or figure out how much of it its using ?
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.