The Library is currently in the process of being upgraded from Oracle Database Version 18.104.22.168 to 22.214.171.124.
Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs,
and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news.
There is absolutely not a byte of truth to these irresponsible rumors.
Sqltune internal utility procedures and functions that do not access dictionary objects.
Some of these utilities are called as part of upgrade and downgrade scripts.
Returns TRUE if this is the root container of a CDB or FALSE is returned for PDBs and for non-CDB
con_name OUT VARCHAR2,
con_id OUT NUMBER)
conn / as sysdba
IF dbms_sqltune_util0.cdb_is_root(cname, cid) THEN
dbms_output.put_line('ROOT: ' || cname);
dbms_output.put_line('ROOT: ' || TO_CHAR(cid));
ELSIF dbms_sqltune_util0.cdb_is_pdb(cname, cid) THEN
dbms_output.put_line('PDB: ' || cname);
dbms_output.put_line('PDB: ' || TO_CHAR(cid));
dbms_output.put_line('No Idea Where I Am');
Given the value of a bind_data column in raw type this function returns the number of bind values contained in the column
dbms_sqltune_util0.get_binds_count(bind_data IN RAW) RETURN PLS_INTEGER;
WHERE is_bind_sensitive = 'Y'
AND rownum = 1;