Oraconsultancy - Your Multi Cloud Partner
Cloud Technology blogs by Krishan Jaglan - AWS/OCI Solution Architect - Professional
Amazon Partner
Tuesday, 12 October 2010
Gather Table statistics without without invalidating cursors
Gather stats for EMP table in Scott schema without invalidating the Cursor and Explain plan stored in memory.
execute DBMS_STATS.GATHER_TABLE_STATS('SCOTT','EMP',NO_INVALIDATE=>TRUE);
PL/SQL procedure successfully completed.
Setting NO_INVALIDATE to TRUE will ensure plan/cursor doesn't get invalidated after stats collection.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment