Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What is needed to specify Oracle instance

Re: What is needed to specify Oracle instance

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Thu, 19 Oct 2006 06:38:20 +0100
Message-ID: <jdadncEnZZbfkqrYnZ2dnUVZ8tydnZ2d@pipex.net>


DA Morgan wrote:

> Barry Bulsara wrote:

>> Hello, I am helping to produce an internal report about the performance
>> of some SQL queries and how they can be improved. The DBA has cloned
>> the production database on two identical (identical to each other and
>> the production database server) computers in the company and we are
>> comparing the response in seconds of the "old" SQL queries vs. the
>> "new" for a small subset of the problem queries. This is the background
>> and the final report is almost ready.
>>
>> To specify the computer in the report it is easy, Sun V210, ram 16GB,
>> dual ultrasparc IIIi, RAID whatever etc. I've got the details for the
>> O/S too. But to fully specify the Oracle version I am not sure what I
>> need to write.
>>
>> On the list I have
>>
>> 1. Oracle version
>> 2. Content of ora.init
>>
>> Is this it? There's no RAC, each database has been created using
>> standard DBCA install parameters where offered.
>>
>> Thank you
>> Barry
> 
> One way would be:
> 
> SELECT dbid
> FROM gv$database;
> 

depends on how the cloning was done, there's every chance that this will return the same value for both.

-- 

Niall Litchfield
Oracle DBA
http://www.orawin.info/services/
Received on Thu Oct 19 2006 - 00:38:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US