RAC Support

If you have multiple database server boxes, Oracle RAC lets you start an Oracle instance on each server, and have all those instances open the same shared database (or shared set of data files). In this way, you can scale the size of your database server by adding more computers as you add users. Multiple computers, one database. Toad supports Oracle 10g's support for RAC systems.

Additional Information for RAC Connections
When you log into 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.

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.




From Toad® for Oracle 8.5 © Copyright Quest® Software, Inc. 2005. All rights reserved.