
86
|
Toad Pocket Reference for Oracle
The Database Browser has full support for running against
Real Application Clusters (RAC) instances. When RAC is
detected, this screen’s information will be gathered from the
appropriate GV$ tables. You will simply note the addition of
an extra column in grid outputs for the instance ID. More-
over, this screen is aware of the current connection’s instance
versus the instance of a requested operation, and will
autoconnect to the proper instance, perform the task and
then disconnect—all without requiring you to do anything.
Modifying Oracle Parameters
There is an Oracle Parameters tab within the Database
Browser screen, but the Oracle Parameters screen provides
much more powerful capabilities, allowing you to view Ora-
cle’s INIT.ora file from Toad. Selecting DBA
➝ Oracle Param-
eters opens a window that displays your INIT.ora parameters
in a grid format with the following column headings:
Option
Displays the parameter name.
Settings
Shows the current value specified for that parameter.
Default
Indicates whether the current parameter value is set to
the default value.
Description
Provides a brief description of the parameter’s function.
Session Modifiable, System Modifiable
Both columns display “Yes” or “No”, indicating the
parameter’s modifiable status.