xplan_tabinfos_vars.sql

--------------------------------------------------------------------------------
-- Author:      Alberto Dell'Era
-- Copyright:   (c) 2008-2021 Alberto Dell'Era http://www.adellera.it
--------------------------------------------------------------------------------

-- map from object id to base table object id
type cache_base_table_object_id_t is table of varchar2(20) index by varchar2(20); -- binary_integer is too small for object_id
m_cache_base_table_object_id cache_base_table_object_id_t;

-- map from object id to basic obj infos
type obj_infos_t is record (
  object_type varchar2(19),
  owner       varchar2(128),
  object_name varchar2(128)
);
type cache_obj_infos_t is table of obj_infos_t index by varchar2(20); -- binary_integer is too small for object_id
m_cache_obj_infos cache_obj_infos_t;

-- map from table object id to list of lines to be printed 
type cache_table_printed_infos_t is table of print_buffer_t index by varchar2(20); -- binary_integer is too small for object_id
m_cache_table_printed_infos cache_table_printed_infos_t;

-- map from gv$sql.program_id to type/owner/objectname
type cache_program_info_t is table of varchar2(100) index by binary_integer;
m_cache_program_info cache_program_info_t;

-- map from owner/objectname gv$sql.program_id 
type cache_program_id_t is table of number index by varchar2(257);
m_cache_program_id cache_program_id_t;

-- map from user_id to username
type cache_username_t is table of varchar2(128) index by binary_integer;
m_cache_username cache_username_t;

-- map from username to user_id 
type cache_user_id_t is table of varchar2(50) index by varchar2(128);
m_cache_user_id cache_user_id_t;

-- list of all referenced table object ids
-- (05/02/2009, to support tabinfos='bottom')
type all_referenced_object_ids_t is table of varchar2(1)  index by varchar2(50);
m_all_referenced_object_ids all_referenced_object_ids_t;