-
Title
Toad for RAC -
Description
I am not able to see RAC specific information in a few places in TOAD.
For example in Database Browser - Instance tab, Database Tab, Sessions tab, they are always empty and not show anything.
I would like to know what other screens are different for Toad for RAC in new version 11.5.1
I used Toad for single instance database but not for RAC and do not find anything different currently.
My license is for RAC edition.
-
Resolution
One is able to see RAC specific information in the following places with Toad for Oracle.
There is nothing different between installers (Toad for Oracle Xpert edition against a Toad DBA Suite for Oracle – RAC Edition. As matter of fact, Toad for Oracle Xpert edition ). The difference is the addition of the Quest Software, Benchmark Factory for Databases (Oracle Edition inc RAC) and Spotlight on RAC (seat-based license).
See the following blog for details.
http://www.toadworld.com/BLOGS/tabid/67/EntryId/492/A-New-Toad%C2%AE-DBA-Suite-for-Oracle-RAC.aspx
Concerning Toad for Oracle, when you log in to a RAC connection, Toad notes this fact and makes additional information available in some of its windows to help you manage that connection.
Caption
If a RAC connection is in effect, the caption of the Toad Main window will reflect this by showing: TOAD: RAC [n], where n is the session id.
Connection bar
In the connection bar, RAC connections are listed as SCHEMA@RAC[n], where n is the instance number of the connection.
Database Monitor
Within the database monitor, all information is provided as per a single connection. However, it is summarized or aggregated for all the instances that compose the RAC cluster. For example, looking at SGA memory - if each RAC instance is 150 MB, and you have two RAC instances, this column will display 300MB. See Database Monitor in Toad for Oracle Help for more information.
Oracle Parameters Screen
RAC database single grid view - The Single Grid checkbox above the grid and to the right of the toolbar toggles whether Toad displays a single grid or a multi-grid. Toad sorts first by default on the option and then by the instance name for easier readability.
RAC database multi-grid view - If you choose the multi-grid view, Toad displays a separate tab for each RAC instance.
http://www.toadworld.com/BLOGS/tabid/67/EntryId/492/A-New-Toad%C2%AE-DBA-Suite-for-Oracle-RAC.aspx