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.

Changes:

  • 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

About these ads
This entry was posted in Mumbai. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s