The SHARD_ENABLE keyword allows the PL/SQL CREATE function statement to indicate that the function evaluation can be pushed down into the shards.

Note that the parallel_enable_clause uses the PARALLEL_ENABLE keyword, which is used to parallelize the execution of a query with the PL/SQL function within one shard.

However, the SHARD_ENABLE keyword, is used to parallelize the query across all shards. Therefore, these two keywords are different and can be used simultaneously to achieve parallel execution within and across shards.

Existing PL/SQL functions called from a cross-shard query (CSQ) will be executed on the shard catalog and won’t be pushed to the shards. To benefit from the PL/SQL functions support, you need to re-run CREATE or replace the PL/SQL functions with the keyword SHARD_ENABLE.

See SHARD_ENABLE Clause in Oracle Database PL/SQL Language Reference for more information about syntax and usage.