V2.2 – Installs on Windows or Unix on Standard Edition

New version of S-ASH package has been published. It can be downloaded from SourceForge project OraSASH .

New features:

- improved configuration setup and internal error logging

- support for Oracle RAC – it has been tested on Oracle SE RAC 11.2

- support for collection from multi databases – tested with 2 databases running in RAC – 2 x 2 instances

- improved method of capture SQL text and plans

- sash_xplan package to display SQL plan directly from repository table in dbms_xplan format

This version of S-ASH is supporting database 10g and 11g only – if you need support for 8i or 9i please contact author.

Whole code can be downloaded from SourceForge. Zip package

————————————————————————————
Bugs
If you find a bug or issue with this version please log it using SourceForge bug tracker

If you have any problems or questions feel free to add comments here or contact me directly
Marcin Przepiorowski

————————————————————————————

Installation steps :

Target Database as user SYS

1. create user and view on target – targ_1_userview.sql

Repository Database

As user SYS

1. create a sash user – using following script – repo_0_user.sql – as user SYS on repository database
2. add sys procedure to kill jobs – repo_1_sys_procedure.sql – as user SYS on repository database

As user SASH

1. create repository – run as SASH user – repo_1_tables.sql
2. create repository management package – repo_2_pkg.sql
3. create a sash packages on repository database – repo_4_packages.sql
4. create sash version of dbms_xplan to see plans from sash repository – repo_6_xplan.sql

Configuration steps

1. Login as user SASH on repository database
2. Add database(s) instance(s) to repository using following package
   exec sash_repo.add_db(‘svr1-vip’, <listener_port>, <target password for sash user>, ‘<dbname>’, ‘<instance_name>’, <instance_number>, ‘<db_version>’, <number of cores>);
   select db_link from sash.sash_targets;
   exec sash_pkg.configure_db(”);
   exec sash_pkg.set_dbid(”);

   ex. one instance

   exec sash_repo.add_db(‘svr1′, 1521, ‘sash’, ‘test’, ‘test1′, 1, ’11.2.0.2′, 8);
   exec sash_pkg.configure_db(‘test1′);

   ex. RAC

   exec sash_repo.add_db(‘svr1-vip’, 1521, ‘sash’, ‘test’, ‘test1′, 1, ’11.2.0.2′, 8);
   exec sash_repo.add_db(‘svr2-vip’, 1521, ‘sash’, ‘test’, ‘test2′, 2, ’11.2.0.2′, 8);
   exec sash_pkg.configure_db(‘test1′);
   exec sash_pkg.set_dbid(‘test1′);

3. setup jobs
   
exec sash_repo.setup_jobs