Skip to Main Content
Toad Pocket Reference for Oracle, 2nd Edition
book

Toad Pocket Reference for Oracle, 2nd Edition

by Jeff Smith, Patrick McGrath, Bert Scalzo
May 2005
Intermediate to advanced content levelIntermediate to advanced
130 pages
4h 31m
English
O'Reilly Media, Inc.
Content preview from Toad Pocket Reference for Oracle, 2nd Edition
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.
Database Administration ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL Language Pocket Reference, 5th Edition

Oracle PL/SQL Language Pocket Reference, 5th Edition

Steven Feuerstein, Bill Pribyl, Chip Dawes
Oracle RMAN 11g Backup and Recovery

Oracle RMAN 11g Backup and Recovery

Robert Freeman, Matthew Hart
Oracle Database 11g A Beginner's Guide

Oracle Database 11g A Beginner's Guide

Ian Abramson, Michael Abbey, Michael Corey

Publisher Resources

ISBN: 9780596529079