Re: What is needed to specify Oracle instance

From: gazzag <gareth_at_jamms.org>
Date: 19 Oct 2006 03:26:23 -0700
Message-ID: <1161253583.531788.308000@m73g2000cwd.googlegroups.com>

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

1. Oracle version can be found by logging into the database as SYSTEM and issuing the following command:

select * from v$version;

e.g. on one of my systems:

SQL> select * from v$version;

BANNER

---

Oracle9i Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for 32-bit Windows: Version 9.2.0.4.0 - Production NLSRTL Version 9.2.0.4.0 - Production

SQL> 2. Your Oracle initialisation file, or init.ora is a text file configuration file and generally will take the form of init<database_sid>.ora. However, there's a little more to it than that and, until you can supply the group with your Oracle version using the above-mentioned step, ay further advice is of limited values.

HTH -g Received on Thu Oct 19 2006 - 05:26:23 CDT