Databases Reference
In-Depth Information
In Step 9, Janice decides to install the sample schemas. They will help her test
out the new features of Oracle 10
g
. However, once the new database is put into
production, she will remove the sample schemas, because they could pose a secu-
rity risk in addition to putting a drain on system performance if users are training
with this database.
The next screen allows Janice to further refine the memory parameters that
Oracle suggests in a data warehouse environment given the server resources, but
she accepts the defaults for now. She will perform some advanced tuning once
the data warehouse queries have been designed and tested. She does decrease the
percentage of memory allocated for this instance from 40 percent down to 25
percent, however, since there is already another Oracle instance on this server.
