/orasash

Oracle Simulation ASH

Primary LanguagePLSQL

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('<db_link>')

PL/SQL procedure successfully completed.

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

...

Marcin