For how many years have you been working
with physical servers? Software Defined Servers can improve performance and
security while lowering complexity and cost. With Software Defined Servers
you define servers with an optimum configuration to your environment rather
than being memory starved and cpu over-provisioned. Find out how you can
improve your computing environment with
TidalScale. your friends.
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)