text: -------------------------------------------------------------------------------
  --
  -- Script:	create_v$my_event.sql
  -- Purpose:	to create a view to select the current sessions wait events
  --
  -- Copyright:	(c) Ixora Pty Ltd
  -- Author:	Steve Adams
  --
  -------------------------------------------------------------------------------
  @save_sqlplus_settings
  set feedback on
  
  create or replace view sys.v_$my_event as
  select * from v$session_event where sid = (select /*+ no_merge */ sid from sys.v_$mystat where rownum = 1)
  /
  set termout off
  drop public synonym v$my_event
  /
  set termout on
  create public synonym v$my_event for sys.v_$my_event
  /
  set termout off
  @as sys 'grant select on v_$my_event to public'
  
  @restore_sqlplus_settings
  