Benefits - Perceptive Content Database IN_DB_UTIL Package for Oracle Server - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

• Provides a framework to pass specific, common parameters between procedures and functions.
• Provides a mechanism to view specific details about session activity from any other database session to expose the actions and progress for any procedures leveraging the framework. These session attributes are stored in memory (SYS_CONTEXT) and exposed using the IN_CONTEXT_PRINT stored procedure.
• Provides a framework to leverage MAX_MINUTES within scripts to define an end time for scripts that have incremental workloads.
• Provides a framework to help prevent against the accidental overlap of executing scripts when leveraging one of the three defined identifiers.
• Provides a collection of procedures and functions for common database tasks which are leveraged by the IN_DB_UPGRADE package during database schema upgrades.
• Provides a collection of procedures and functions to assist with calculating throughput metrics to report on the performance of scripted operations.
• Provides a collection of procedures and functions to perform various database maintenance tasks such as deleting old audit data or rebuilding indexes.