Prev | Current Page 934 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"


In this installation, we are choosing the General Purpose or Transaction Processing template.
It combines the features of both a data warehouse and an OLTP environment into a single
database; use this option if you must use this database for both environments. Ideally, however,
any database you create should be configured and tuned for the types of users and transactions
on the database.
Database Identification
In step 3 of the DBCA, you will identify the name of the instance along with the global database
name; if you type the fully qualified database name, it will use all characters up to the first
period as the instance name, or Oracle System Identifier (SID). Figure A-2 shows the Database
Identification window.
Note the distinction between a SID, an instance name, and a database. You may have one
or more databases on a server; each database may have one or more instances opening each
database. The instance names that use the same database must be unique. On the server, if
there is more than one instance with the same name (but opening different databases), the SID
associated with the instance must be unique.
TIP
If the global database name needs to be changed in the future, you
must use the alter database command to change it, in addition to
changing it in the initialization parameter file. The global database
name is stored in the data dictionary when the database is created.
Unless you have an existing domain, use the default domain name .


Pages:
922 923 924 925 926 927 928 929 930 931 932 933 934 935 936 937 938 939 940 941 942 943 944 945 946
www.books61.hobbitstory.com tanie noclegi międzyzdroje pokoje windsurfing Władysławowo noclegi e-lady