Re: oracle performance

hpuxrac wrote:
> DA Morgan wrote:

>> Charles Hooper wrote:
>>
>>> My comments referring to tuning the database instance may not have been
>>> as clear as I had hoped.
>> And just to get semantically picky there is no such thing as a database
>> instance.

With all due respect for Tom, and my respect for him is immense, I think you will find that if you review Oracle Database Concepts these terms are defined.

"This combination of the SGA and the Oracle processes is called an Oracle instance."
Source:
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14220/startup.htm#CNCPT601

Then please consider what happens when you issue the following command:

SQL> drop database;

When you issue this statement, Oracle Database drops the database and deletes all control files and datafiles listed in the control file. If the database used a server parameter file (spfile), it is also deleted. Source:
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_8009.htm#sthref8446

Given that you are a RAC expert I would expect you would also have noticed that SRVCTL has both a -d and -i switch. There is a reason for the distinction. Which is why I noted in my original post that while this was not that important with stand-alone it is critical when discussing RAC.

I'm not making up these definitions. They are the ones published in the on-line Oracle docs.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org