In
previous sections of this chapter, we described many of the basic initialization parameters that
a DBA needs to understand. Unless you have specific memory requirements, such as other
memory-intensive applications running on the same server, select the Typical radio button to
specify 40% of system memory for the combined SGA and PGA areas. If you select Automatic
Memory Management, Oracle will automatically reallocate memory within the SGA and between
the SGA and PGA for optimal performance. On this same window you can click the All Initialization
Parameters button to review the settings for all other initialization parameters.
Security Settings
On the window in Figure A-10, you can enable or disable the enhanced default security settings,
which are new to Oracle Database 11g. The default security settings turn on auditing for many
different system privileges such as creating a session (connecting to the database) and creating
or dropping users, profiles, or procedures. If this auditing becomes a performance issue, you can
run DBCA after the database has been created to turn off these enhanced audit settings. For more
information on security and auditing, see Chapter 9.
Database Storage
On the DBCA Database Storage window in Figure A-11, you can review and revise the locations
of the control files, datafiles, and redo log files, as well as multiplex the control files and create
redo log file groups. The names and locations of the control files on this window determine the
value of CONTROL_FILES in the initialization parameter file or SPFILE.
Pages:
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951