Call (800) 766-1884 for Oracle support & training
Free Oracle Tips

Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance

Free Oracle Tips



BC Oracle tuning

Oracle training

Oracle support

Remote Oracle



  Oracle Tips by Burleson

Database Identification, Options and Configurations screen

On the Database Identification screen you fill in one value, the SID domain name for your database. If you are unsure of the domain to use, type "" or simply the SID name. In my system, the domain is my server name, so I used the sid.tuscgalinux or specifically galinux2.tuscgalinux where the database name (SID) is "galinux1". The screen automatically strips off the domain name (anything after the first period) to create the SID name, and places the SID in the appropriate box for you. Once you have defined the SID and domain and selected the Next button, the Database Options screen (Figure 2.5) is displayed.

Database Options

The Database Options screen lists all available database options. By default, you will see that the Oracle Spatial, Oracle Ultra Search, and Example Schemas have been selected. I suggest unselecting the Example Schemas unless this is to be a learning database, as they are not needed for a production environment. This screen also allows you to add either custom-designed scripts or choose, via browse capabilities, scripts such as catblock.sql, catparr.sql, or other Oracle-provided scripts not run by catproc.sql. Once you have selected the options to be loaded and have specified any custom scripts that you want run, select the Additional database configurations button; the screen that allows you to select, or deselect, the Oracle JVM and Intermedia options is displayed. This additional option screen is shown in Figure 2.6.

Additional Configurations screen.     

Oracle suggests (and I agree) that you add the JVM and Intermedia to your selection of options; they both provide additional power and functionality that are easy to add now, but may be more difficult in a fully functional production environment. Once you have chosen (or not chosen, as the case may be) the JVM and Intermedia options, select the OK button and then the Next button on the Options screen to display the Database Connection Options screen (Figure 2.7).

Database Connection Options screen.

In the Connection Options screen, you choose between using dedicated connections and configuring a multithreaded server (MTS). Generally, if your system isn't serving about 100 connections per CPU to the database, you won't need MTS, however if you will be using large, complex SQL commands you may need to turn on a minimal MTS configuration to ensure that the large pool is utilized. I have seen cases where not using the large pool will generate ORA-04031 and ORA-1037 errors with large, complex SQL. MTS is used when you either have many connections or when you have a very small amount of memory and many connections. If you have sufficient memory resources to serve the connected users, you will want to use dedicated connections. Make your selection, and then either select Next, if you choose dedicated connections, or configure the MTS (called shared connection) parameters; then select OK and Next. The next screen displayed will be the Initialization Parameters screen.

See Code Depot


Oracle performance tuning software 

Oracle performance tuning book


Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel
Oracle training & performance tuning books



Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.