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;