BASH (ASH without Diagnostic Pack) now works on RAC

Version 6 of BASH is available. If you already have it installed, you can use the SQL*Plus update script update_v5tov6.sql.


  • Made sure BASH works on Oracle 12c
  • BASH is now compatible with RAC on Oracle 11.1 and higher. Each instance runs its own collector through a separate scheduler job.

    Scheduler jobs are created and deleted when starting and stopping the collector through EXEC BASH.BASH.RUN;. The collector detects new instances when running and creates collector jobs for them.

    The following public synonyms to select the collected data now exist:

    BASH$ACTIVE_SESSION_HISTORY: ASH data from the current instance
    BASH$HIST_ACTIVE_SESS_HISTORY: Historic ASH data from the current instance
    BASHG$ACTIVE_SESSION_HISTORY: ASH data from all instances
    BASHG$HIST_ACTIVE_SESS_HISTORY: Historic ASH data from all instancess