
54
|
Toad Pocket Reference for Oracle
Use NOPARALLEL hint in data grids
Uses the NOPARALLEL hint in the data grids, making
the queries consume less of Oracle’s resources when dis-
playing data from tables that have parallelism.
Objects Panel
As mentioned previously, the lefthand side (LHS) of the
Schema Browser displays the Objects panel (an example is
shown in Figure 11). When you specify an object type in the
Tab/Dropdown/Treeview selector, the Schema Browser lists
all of the objects of that type for the schema selected. The
Schema Browser defaults to the login schema for the current
session.
Toad checks your Oracle version and displays or suppresses
Schema Browser tabs accordingly. For instance, the Schema
Browser does not attempt to report on policies or libraries
when connected to an Oracle 7.x database (which does not
support such objects).
The Schema Browser lets you create, alter, copy, drop,
export, enable, disable, compile, and perform a variety of
other actions on the objects you select. Note, however, that
the current Oracle privileges of the logged-in user determine
which actions you are allowed to perform. These privileges
also affect your ability to display and alter objects owned by
other schemas.
An Oracle schema could be composed of many thousands of
objects per object type. The Schema Browser allows you to
filter the objects list in the Objects panel using the Filter but-
ton on the LHS ...