11g Manage System Parameters
Oracle 11g New Features Tips by Donald BurlesonJune 28, 2015
Oracle 11g New Features Tips
Figure 4.15 below shows the system parameters
that are available to the DBA. To access the System Parameters
interface click the Schema tab, then Workspaces. Also, Under Related
Links, the System Parameters option can be found.
Figure 4.15 System Parameters interface
Granting privileges on Workspaces can also be
achieved within 11g OEM, as shown in Figure 4.16.
Figure 4.16 Granting privileges on
Workspaces in 11g OEM
OEM is a management tool for DBAs that extends
beyond the database. An academic definition of management
includes the activities of planning, organizing, controlling and
directing. OEM is able to provide the DBA with the ability to
plan for growth, organize data, control access and data usage and
direct the RDBMS through a fairly intuitive interface.
However, becoming familiar with Oracle
Enterprise Manager requires an investment of time on the part of the
DBA. This investment is well advised considering the benefits
provided by this ever evolving tool.
E.F. Codd said that future users of large
databases must be protected from having to know how the data is
organized in the machine. OEM helps remove the DBA from having
to know extensive operating system commands. OEM also provides
a management interface between the DBA and the underlying database
and operating system. This is significant because it nearly
eliminates the need for experience with burdensome OS command line
syntax that is required to display server-side information.
These commands are obviously different between Windows, UNIX and
Linux, and offers variances between flavors of Linux.
Oracle Enterprise Manager gives a first glimpse
of the 482 new features introduced in Oracle 11g. Many of
these new features can be configured and taken advantage of within
The new features of OEM covered in this chapter