Ashmon views

drop view v$active_session_history;
create view v$active_session_history as
 select
        ash.dbid           ,
        ash.sample_time     ,
        ash.session_id      ,
        ash.session_state   ,
        ash.session_serial# ,
        ash.user_id         ,
        ash.sql_address     ,
        ash.sql_plan_hash_value  ,
        ash.sql_child_number  ,
        ash.sql_id          ,
        ash.sql_opcode      ,
        decode(ash.session_type,81,'BACKGROUND','FOREGROUND') session_type   ,
     --  ash.event           ,
        ash.event#          ,
        ash.seq#            ,
        ash.p1              ,
        ash.p2              ,
        ash.p3              ,
        ash.wait_time       ,
        ash.time_waited     ,
        ash.current_obj#    ,
        ash.current_file#   ,
        ash.current_block#  ,
        ash.program         ,
        ash.module          ,
        ash.action          ,
        ash.FIXED_TABLE_SEQUENCE ,
        ash.sample_id       ,
        ash.machine         ,
        ash.terminal        ,
        e.name event,
        g.wait_class
 from
      sash ash,
      sash_event_names e,
      waitgroups g
 where
 e.event# = ash.event# and
 e.name = g.name(+)
/
create view dba_hist_active_sess_history as
select * from v$active_session_history where rownum < 1 ;

drop view v$SQLTEXT_WITH_NEWLINES;
create view v$SQLTEXT_WITH_NEWLINES as
   select *
   from  sash_sqltxt;

drop view v$instance;
create view v$instance as
   select
   sid  instance_name,
   host host_name,
   version
 from sash_targets
 where dbid = (select dbid from sash_curhost);

drop view v$parameter;
create view v$parameter as
   select *
   from sash_params;

drop view dba_users;
create view dba_users as
   select *
   from sash_users;