orasash

Oracle Simulation ASH

Project home page - http://pioro.github.io/orasash/

Change log:

Change Log:

2.3.1 repo_schema.sql

• new column in sashX table - osuser varchar2(30)
• new column in sash_event_names - event_id number
• change in v$active_session_history view definition for following columns qc_instance_id,qc_session_id,qc_session_serial#

sash_pkg.sql

• changes related to new columns

sash_repo.sql

• using DBID as a part of job name
• support for same database name on different hosts

installation script

• fix of hardcoded sash schema
• some other minor fixes

If you want to keep old data with new version of sash you need to do all 3 changes from repo_schema.sql manually.

2.4-rc1

This version of S-ASH is collecting event histograms, OS statistics from Oracle and sys time model.

v$active_session_history is still a main view but the following AWR views are now simulated:

• dba_hist_snapshot
• dba_hist_sysmetric_history
• dba_hist_sqlstat
• dba_hist_active_sess_history
• dba_hist_event_histogram
• dba_hist_sys_time_model

File changes:

sash_xplan.sql

• fix for duplicated sql_id / plan_hash for RAC monitoring
• view SASH_PLAN_TABLE moved from repo_schema.sql

sash_pkg.sql

• fix for hostname with dash
• collect_osstat - new procedure to collect v$osstat
• collect_sys_time_model - new procedure to collect v$sys_time_model
• collect_event_histogram - new procedure to collect v$event_histogram

sash_repo.sql

• fix for hostname with dash

repo_schema.sql

• add inst_num column to sash_target table
• all views are using dbid and inst_num - so if you want to consolidate results from RAC use raw sash tables
• split views to other file
• sash_sqlstats and sash_event_histogram have a "poor man" paritioning

switchdb.sql / current.sql

• instance switch added

upgarde: TODO from 2.3.1 to 2.4 without data loss

Number of metric changed - steps to run if you upgraded from lower version

PROD_SASH@XE > delete from sash_sysmetric_names where dbid = ;

21 rows deleted.

PROD_SASH@XE > commit;

Commit complete.

PROD_SASH@XE > exec sash_pkg.get_metrics('')

PL/SQL procedure successfully completed.

PROD_SASH@XE > select * from sash_sysmetric_names where dbid = ;

...

Marcin