Reduce parse calls for sequences
How can i reduce the parse call for this following statement.
Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
4,871 4,871 1.64 9bzcyzd56pb79 select SESSION_ACTIVE_SEQ_ID.NEXTVAL from DUAL
SQL ordered by Parse Calls
this query is one of the top list in AWR .
how can i reduce the parse time for this statement.
Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
4,871 4,871 1.64 9bzcyzd56pb79 select SESSION_ACTIVE_SEQ_ID.NEXTVAL from DUAL
SQL ordered by Parse Calls
this query is one of the top list in AWR .
how can i reduce the parse time for this statement.
1]how can i tune it to reduce the parse call.
2] i have changed a cache parameter from 20 to 200 . how can i monitor the benifits before & after from the AWR reports.
pls advice.
bipsy
0