Performance Issue with PLP_GLBALANCEAGGRBYACCTSEGCODS

Modify the override SQL for session PLP_GLBalanceAggrByAcctSegCodes, to add hint

/*+ OPT_PARAM('_GBY_HASH_AGGREGATION_ENABLED', 'true')
USE_HASH(W_GL_BALANCE_F, W_GL_ACCOUNT_D) */

this will improve the performance.