Where are SQL plan directives stored in the database?

When SQL Plan Directives are created, they are stored in memory, more precisely in the Shared Pool. The database writes the SQL Plan Directives to the SYSAUX tablespace periodically. If you want to manually write the SQL Plan Directives to disk, you can use: DBMS_SPD.FLUSH_SQL_PLAN_DIRECTIVE.
For More Information Please Refer:

You May Also Like to Read: