Some Oracle packages that I come across from time to time or that I find interesting include
dbms_advanced_rewrite | |
dbms_advisor | |
dbms_application_info | |
dbms_aq | Interface to advanced queuing: queue and dequeue messages |
dbms_aqadm | Adminstration of queues and queue tables. |
dbms_assert | |
dbms_auto_index | Manage automatic indexes |
dbms_auto_partition | |
dbms_auto_task_admin | Interface to autotask functionalities |
dbms_backup_restore | |
dbms_blockchain_table | |
dbms_cloud | Import data from the Cloud Object Store to an Oracle database. |
dbms_cloud_ai | Use LLMs to generate SQL statements from natural language prompts (for example SELECT AI how many customers have made more than one million in sales) |
dbms_cloud_repo | Access files in git repositories hosted on GitHub, AWS CodeCommit and Azure Repos. |
dbms_comparison | Compare data between two tables and rectify their differences |
dbms_compression | Estimate compression rates for Advanced Compression. |
dbms_credential | Provides an interface for authenticating and impersonating extproc callout functions as well as external jobs, remote jobs and file watchers from the scheduler. |
dbms_crypto | |
dbms_datapump | The Data Pump API |
dbms_db_version | Version numbers, usable for conditional compilation. |
dbms_ddl | |
dbms_debug | Deprecated in favor of dbms_debug_jdwp |
dbms_debug_jdwp | Interface to initiate and control the debugging of PL/SQL stored procedures and Java stored procedures over Java Debug Wire Protocol (JDWP). |
dbms_describe | Provides information about a PL/SQL object. |
dbms_duma_internal | |
dbms_errlog | Create error logging tables into which DML statements can write records that caused an error. |
dbms_epg | Managing the Embedded PL/SQL Gateway. |
dbms_feature_usage_internal | |
dbms_fga | |
dbms_file_transfer | |
dbms_flashback | provides the same functionality as Flashback Query, but Flashback Query is sometimes more convenient. |
dbms_flashback_archive | |
dbms_fs | |
dbms_hadoop | |
dbms_hcheck | One of the 3 new PL/SQL packages in 23c. |
dbms_hierarchy | Support for analytic views and hierarchy objects |
*dbms_ilm | Information Lifecycle Management using Automatic Datamanagement OPtimization (ADO) |
dbms_immutable_table | |
dbms_ischedfw | Encapsulation of some functionality of file watchers. |
dbms_java | |
dbms_javascript | Run JavaScript code in the Oracle DBMS itself. |
dbms_job | Superseded by dbms_scheduler |
dbms_json | Manipulate JSON data. |
dbms_lock | Interface to Oracle Lock Management services. |
dbms_lob | access LOB data |
dbms_lobutil | diagnostic and utility functions for 11g LOBs |
dbms_logrep_imp | |
dbms_logstdby | Configure and manage the logical standby database |
dbms_memoptimize | |
dbms_memoptimize_admin | |
dbms_metadata | allows to extract definitions of objects as DDL statements or XML documents. |
dbms_metadata_diff | exposes the functionality to compare metadata documents in SXML format. |
dbms_mle | Execute JavaScript and exchange data with PL/SQL. Compare with dbms_javascript. |
dbms_monitor | |
dbms_mview | A synonym for dbms_snapshot |
dbms_network_acl_admin | Modify access control lists (ACLs) which in turn control access to external network services via utl_tcp, utl_http, utl_smtp and utl_inaddr. |
dbms_odci | A package that is related to Data Cartridges |
dbms_outln | Manage stored outlines |
dbms_output | Send messages from stored procedures (poor man's debugging) |
dbms_parallel_execute | |
dbms_pdb | Examine and manage pluggable databases (PDBs).w |
dbms_pipe | Allows two or more sessions to communicate with each other. |
dbms_predictive_analytics | |
dbms_preprocessor | |
dbms_privilege_capture | |
dbms_profiler | |
dbms_qopatch | Query installed packages. |
dbms_random | Random number generator (not suitable for Cryptography purposes) |
dbms_redact | Manage data redaction policies. |
dbms_redefinition | |
dbms_registry | Not documented. |
dbms_resource_manager | helps managing the resources on an Oracle database. |
dbms_resumable | In case of hitting a resource (space) limit during a large poperation, suspend the operation, fix the problem and resume execution |
dbms_rls | |
dbms_rolling | |
dbms_rowid | ROWID management |
dbms_rule | |
dbms_scheduler | The API for the scheduler |
dbms_scn | SCN |
dbms_search | |
dbms_service | |
dbms_session | |
dbms_shared_pool | |
dbms_snapshot | dbms_mview is a synonym for dbms_snapshot. |
dbms_space | Analyze segment growth and space requirements |
dbms_space_admin | |
dbms_spd | Manage SQL plan directives |
dbms_spm | Manage SQL plan directives |
dbms_standard | |
dbms_stat_funcs | |
dbms_stats | View or modify optimizer statistics. |
dbms_stats_internal | |
dbms_sql | Execute dynamic SQL statements, compare with execute immediate. |
dbms_sqldiag | |
dbms_sqldiag | |
dbms_sqlhash | Calculate a hash value from a select statement's result set which is useful to verify if two executions of an SQL statements produce the same result. |
dbms_sqlpa | Performance analyzer |
dbms_sql_firewall | One of the 3 new PL/SQL packages in 23c. |
dbms_sql_monitor | Real-Time SQL Monitoring and Real-Time Database Operation information. |
dbms_sql_translator | |
dbms_sqltune | |
dbms_sqltune_util0 | |
dbms_sqlset | Manage SQL Tuning Sets without Oracle Tuning Pack. Compare with dbms_sqltune. |
dbms_sqltune | dbms_sqltune is the traditional package to manage SQL Tuning Sets and requires Oracle Tuning Pack. dbms_sqlset offers the same functionality, but without the Tuning Pack. |
dbms_system | |
dbms_sys_error | Undocumented package to raise error messages. |
dbms_table_data | |
dbms_tf | Used for polymorphic table functions (PTF) |
dbms_trace | |
dbms_transaction | |
dbms_types | |
dbms_type_utility | With one procedure: none. |
dbms_user_certs | |
dbms_utility | Various utility functions. |
dbms_vector | Functions to create vectors (embeddings?) from text. See also the SQL function vector_chunks. |
dbms_wm | Exposes the functionality of the Workspace Manager |
dbms_workload_capture | |
dbms_workload_replay | |
dbms_workload_repository | |
dbms_xdb | |
dbms_xdb_config | Interface for configuring Oracle XML DB and its repository. |
dbms_xplan | Format SQL execution plans. |
dbms_xmlgen | Convert SQL query results to XML |
dbms_xmlquery | |