"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible.
I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
This package is for shared utility functions that need to be part of an INVOKER rights package. Like the other dbms_sqltune_util# packages, it should NOT be documented.
If a function only needs to be accessible from the dbms_sqltune/sqldiag/etc feature layer, do not put it here, but rather in the infrastructure layer (prvssqlf). This layer is for code that should be globally accessible, even from the internal package.
Snapshot ID must be between <beginning snap_id> and <max_possible_valid_snap_id>;
Used by dbms_sqltune.unpack_sqlsets_bulk: Gets the list of binds of a given SQL statement from a table and converts the list of binds into a varray as required by sqlset_row.
sql_id IN VARCHAR2,
plan_hash_value IN NUMBER,
sqlset_name IN VARCHAR2,
sqlset_owner IN VARCHAR2,
table_name IN VARCHAR2)
Validates the execution name of an SPA task to ensure it was a Compare Performance (type id 5) while if NULL was supplied, it returns the name of the most recent compare execution for the given SPA task
task_name IN VARCHAR2,
task_owner IN VARCHAR2,
exec_name IN OUT VARCHAR2)