For your reference, here I list packages owned by SYS, which should be granted with EXECUTE privilege to PUBLIC in 19c.
Theoretically, there's no need to re-grant EXECUTE to individual users. If you saw error PLS-00201, you should re-grant SYS packages to PUBLIC to EXECUTE.
- DBMS_ADDM
- DBMS_ADVISOR
- DBMS_APPLICATION_INFO
- DBMS_APP_CONT_PRVT
- DBMS_AQJMS
- DBMS_AQ_EXP_CMT_TIME_TABLES
- DBMS_AQ_EXP_DEQUEUELOG_TABLES
- DBMS_AQ_EXP_HISTORY_TABLES
- DBMS_AQ_EXP_INDEX_TABLES
- DBMS_AQ_EXP_QUEUES
- DBMS_AQ_EXP_QUEUE_TABLES
- DBMS_AQ_EXP_SIGNATURE_TABLES
- DBMS_AQ_EXP_SUBSCRIBER_TABLES
- DBMS_AQ_EXP_TIMEMGR_TABLES
- DBMS_AQ_IMP_INTERNAL
- DBMS_AQ_INV
- DBMS_ASH
- DBMS_ASSERT
- DBMS_AUTO_REPORT
- DBMS_AUTO_TASK
- DBMS_AW
- DBMS_AW_EXP
- DBMS_AW_STATS
- DBMS_AW_XML
- DBMS_BLOCKCHAIN_TABLE
- DBMS_COMPRESSION
- DBMS_CREDENTIAL
- DBMS_CRYPTO_TOOLKIT
- DBMS_CUBE
- DBMS_CUBE_ADVISE
- DBMS_CUBE_ADVISE_SEC
- DBMS_CUBE_EXP
- DBMS_CUBE_LOG
- DBMS_CUBE_UTIL
- DBMS_DATAPUMP
- DBMS_DATA_MINING
- DBMS_DATA_MINING_TRANSFORM
- DBMS_DB_VERSION
- DBMS_DDL
- DBMS_DEBUG
- DBMS_DEBUG_JDWP
- DBMS_DEBUG_JDWP_CUSTOM
- DBMS_DESCRIBE
- DBMS_DIMENSION
- DBMS_DM_MODEL_EXP
- DBMS_DM_MODEL_IMP
- DBMS_EDITIONS_UTILITIES
- DBMS_EDITIONS_UTILITIES2
- DBMS_EPG
- DBMS_ERRLOG
- DBMS_EXPORT_EXTENSION
- DBMS_FBT
- DBMS_FILE_GROUP_EXP
- DBMS_FILE_GROUP_IMP
- DBMS_FREQUENT_ITEMSET
- DBMS_FUSE_PUBLIC
- DBMS_GOLDENGATE_EXP
- DBMS_GOLDENGATE_IMP
- DBMS_HEAT_MAP
- DBMS_HIERARCHY
- DBMS_HS_PARALLEL
- DBMS_ILM
- DBMS_IMMUTABLE_TABLE
- DBMS_INDEX_UTL
- DBMS_INMEMORY
- DBMS_ITRIGGER_UTL
- DBMS_JAVA
- DBMS_JAVASCRIPT
- DBMS_JOB
- DBMS_LCR
- DBMS_LDAP
- DBMS_LDAP_UTL
- DBMS_LOB
- DBMS_LOBUTIL
- DBMS_LOGREP_EXP
- DBMS_LOGREP_IMP
- DBMS_LOGSTDBY_CONTEXT
- DBMS_MDX_ODBO
- DBMS_MEMOPTIMIZE
- DBMS_METADATA
- DBMS_METADATA_DIFF
- DBMS_MVIEW_STATS
- DBMS_NETWORK_ACL_UTILITY
- DBMS_OBFUSCATION_TOOLKIT
- DBMS_OBJECTS_UTILS
- DBMS_ODCI
- DBMS_OUTPUT
- DBMS_PARALLEL_EXECUTE
- DBMS_PART
- DBMS_PCLXUTIL
- DBMS_PICKLER
- DBMS_PLSQL_CODE_COVERAGE
- DBMS_PREDICTIVE_ANALYTICS
- DBMS_PREPROCESSOR
- DBMS_PROFILER
- DBMS_PSP
- DBMS_RANDOM
- DBMS_REFRESH
- DBMS_REPORT
- DBMS_RESOURCE_MANAGER
- DBMS_RESOURCE_MANAGER_PRIVS
- DBMS_RESULT_CACHE_API
- DBMS_RMGR_GROUP_EXPORT
- DBMS_RMGR_PACT_EXPORT
- DBMS_RMGR_PLAN_EXPORT
- DBMS_RMIN
- DBMS_ROWID
- DBMS_RULE
- DBMS_RULEADM_INTERNAL
- DBMS_RULE_ADM
- DBMS_RULE_EXP_EV_CTXS
- DBMS_RULE_EXP_RULES
- DBMS_RULE_EXP_RULE_SETS
- DBMS_RULE_EXP_UTLI
- DBMS_RULE_IMP_OBJ
- DBMS_SCHEDULER
- DBMS_SCHED_ATTRIBUTE_EXPORT
- DBMS_SCHED_CHAIN_EXPORT
- DBMS_SCHED_CLASS_EXPORT
- DBMS_SCHED_CONSTRAINT_EXPORT
- DBMS_SCHED_CREDENTIAL_EXPORT
- DBMS_SCHED_EXPORT_CALLOUTS
- DBMS_SCHED_FILE_WATCHER_EXPORT
- DBMS_SCHED_JOB_EXPORT
- DBMS_SCHED_PROGRAM_EXPORT
- DBMS_SCHED_SCHEDULE_EXPORT
- DBMS_SCHED_WINDOW_EXPORT
- DBMS_SCHED_WINGRP_EXPORT
- DBMS_SCN
- DBMS_SESSION
- DBMS_SNAPSHOT
- DBMS_SNAPSHOT_UTL
- DBMS_SODA
- DBMS_SPACE
- DBMS_SPD
- DBMS_SPM
- DBMS_SQL
- DBMS_SQLDIAG
- DBMS_SQLPA
- DBMS_SQLQ
- DBMS_SQLSET
- DBMS_SQLTUNE
- DBMS_SQLTUNE_UTIL2
- DBMS_SQL_MONITOR
- DBMS_SQL_TRANSLATOR
- DBMS_SQL_TRANSLATOR_EXPORT
- DBMS_STANDARD
- DBMS_STATS
- DBMS_STATS_ADVISOR
- DBMS_STATS_INTERNAL_AGG
- DBMS_STAT_FUNCS
- DBMS_STAT_FUNCS_AUX
- DBMS_STREAMS
- DBMS_STREAMS_PUB_RPC
- DBMS_SUMMARY
- DBMS_SUM_RWEQ_EXPORT
- DBMS_SYNC_REFRESH
- DBMS_TABLE_DATA
- DBMS_TF
- DBMS_TRACE
- DBMS_TRANSACTION
- DBMS_TRANSFORM_EXIMP
- DBMS_TYPES
- DBMS_USER_CERTS
- DBMS_UTILITY
- DBMS_WARNING
- DBMS_XA
- DBMS_XMLGEN
- DBMS_XMLQUERY
- DBMS_XMLSAVE
- DBMS_XMLSCHEMA_UTIL
- DBMS_XMLSTORE
- DBMS_XPLAN
- DBMS_XQUERY
- DBMS_XQUERYINT
- DBMS_XS_SESSIONS
- DBMS_ZHELP_IR
- DIUTIL
- GENCONNECTIONINTERFACE
- GENCURSORMANAGERINTERFACE
- GENDATABASEINTERFACE
- GENDATAPROVIDERINTERFACE
- GENDATATYPEIDCONSTANTS
- GENDEFINITIONMANAGERINTERFACE
- GENMDMCLASSCONSTANTS
- GENMDMOBJECTIDCONSTANTS
- GENMDMPROPERTYIDCONSTANTS
- GENMETADATAPROVIDERINTERFACE
- GENSERVERINTERFACE
- GET_ERROR$
- HTF
- HTP
- JAVA_XA
- JVMRJBC
- JVMRJBCINV
- KUBSAGT
- KUBSD$DESC_INT
- KUPCC
- KUPF$FILE
- KUPM$MCP
- KUPU$UTILITIES
- KUPW$WORKER
- LBAC_EXP
- ODCICONST
- ODM_UTIL
- OJDS_NAMESPACE
- ORA_DM_REFCUR_PKG
- OWA
- OWA_CACHE
- OWA_COOKIE
- OWA_CUSTOM
- OWA_IMAGE
- OWA_MATCH
- OWA_OPT_LOCK
- OWA_PATTERN
- OWA_SEC
- OWA_TEXT
- OWA_UTIL
- PBSDE
- PLITBLM
- PRIVATE_JDBC
- PRVTEMX_SQL
- PRVT_AWR_DATA
- PRVT_AWR_DATA_CP
- PRVT_COMPRESSION
- PRVT_CPADDM
- PRVT_REPORT_TAGS
- PRVT_RTADDM
- SQLJUTL
- STANDARD
- URIFACTORY
- USER_LOCK
- UTL_CALL_STACK
- UTL_COLL
- UTL_COMPRESS
- UTL_ENCODE
- UTL_FILE
- UTL_GDK
- UTL_HTTP
- UTL_I18N
- UTL_IDENT
- UTL_INADDR
- UTL_LMS
- UTL_MATCH
- UTL_NLA
- UTL_RAW
- UTL_REF
- UTL_SMTP
- UTL_TCP
- UTL_URL
- WPG_DOCLOAD
- WPIUTL
- XS_ACL
- XS_ADMIN_UTIL
- XS_DATA_SECURITY
- XS_DIAG
- XS_NAMESPACE
- XS_PRINCIPAL
- XS_ROLESET
- XS_SECURITY_CLASS
Please note that, USER_LOCK is not a default package, it needs to be installed.