Oracle: V$SQL_SHARED

Columns

select
   column_name
from
   dba_tab_columns d
where
   table_name = 'V_$SQL_SHARED_CURSOR'
order by
   case
      when column_name in ('SQL_ID', 'ADDRESS', 'CHILD_ADDRESS', 'CHILD_NUMBER', 'UNBOUND_CURSOR') then 'A' || to_char(column_id, '9990')
      when column_name in ('REASON'                                                              ) then 'B' || to_char(column_id, '9990')
   -- when column_name in ('USE_FEEDBACK_STATS'                                                  ) then 'C' || to_char(column_id, '9990')
      when column_name in ('CON_ID'                                                              ) then 'Z' || to_char(column_id, '9990')
      else                                                                                              'Y' || column_name
   end
;

Github repository oracle-patterns, path: /Installed/dynamic-performance-views/sql/shared/cursor/columns.sql

`sql_id`
`address`
`child_address`
`child_number`
`unbound_cursor`
`reason`
`acl_mismatch`
`anydata_transformation`
`auth_check_mismatch`
`bind_equiv_failure`
`bind_length_upgradeable`
`bind_mismatch`
`bind_peeked_pq_mismatch`
`bind_uacs_diff`
`buffered_dml_mismatch`
`crossedition_trigger_mismatch`
`cursor_parts_mismatch`
`describe_mismatch`
`different_long_length`
`diff_call_durn`
`edition_mismatch`
`explain_plan_cursor`
`flashback_archive_mismatch`
`flashback_cursor`
`flashback_table_mismatch`
`force_hard_parse`
`hash_match_failed`
`incomp_ltrl_mismatch`
`inst_drtld_mismatch`
`insuff_privs`
`insuff_privs_rem`
`language_mismatch`
`literal_mismatch`
`litrep_comp_mismatch`
`load_optimizer_stats`
`load_runtime_heap_failed`
`lock_user_schema_failed`
`logical_standby_apply`
`logminer_session_mismatch`
`multi_px_mismatch`
`mv_query_gen_mismatch`
`mv_rewrite_mismatch`
`mv_staleobj_mismatch`
`no_trigger_mismatch`
`optimizer_mismatch`
`optimizer_mode_mismatch`
`outline_mismatch`
`overlap_time_mismatch`
`pddl_env_mismatch`
`pdml_env_mismatch`
`plsql_cmp_switchs_diff`
`plsql_debug`
`pq_slave_mismatch`
`purged_cursor`
`px_mismatch`
`remote_mapping_mismatch`
`remote_trans_mismatch`
`roll_invalid_mismatch`
`slave_qc_mismatch`
`sql_type_mismatch`
`stats_row_mismatch`
`stb_object_mismatch`
`top_level_ddl_mismatch`
`top_level_rpi_cursor`
`translation_mismatch`
`typchk_dep_mismatch`
`typecheck_mismatch`
`user_bind_peek_mismatch`
`use_feedback_stats`	indicates whether a child cursor fails to match because of reoptimization.
`con_id`

Oracle: V$SQL_SHARED_CURSOR

Columns

See also