RE: Oracle - 32bit/64bit??

2002-07-23 Thread Vikas Khanna

If 64 bit then 
Oracle9i Enterprise Edition Release 9.0.1.2.0 - 64bit Production
else 
Oracle9i Enterprise Edition Release 9.0.1.2.0
end if;

Vikas Khanna 
-Original Message-
Sent: Tuesday, July 23, 2002 3:54 PM
To: Multiple recipients of list ORACLE-L


Just log into the database using sqlplus and it will tell you

/u01/app/oracle>sqlplus /

SQL*Plus: Release 9.0.1.0.0 - Production on Tue Jul 23 10:16:50 2002

(c) Copyright 2001 Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.0.1.2.0 - 64bit Production
With the Partitioning option
JServer Release 9.0.1.2.0 - Production

SQL>


-Original Message-
Sent: 23 July 2002 00:09
To: Multiple recipients of list ORACLE-L


Hi,
Does anyone know how I can verify if a database is 32 or 64 bit?

Thanks.

elain



_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: elain he
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.
Statements and opinions expressed in this e-mail may not represent those of
the company. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender immediately and delete the material
from any computer.



==

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Adrian Roe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vikas Khanna
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Oracle - 32bit/64bit??

2002-07-23 Thread Adrian Roe

Just log into the database using sqlplus and it will tell you

/u01/app/oracle>sqlplus /

SQL*Plus: Release 9.0.1.0.0 - Production on Tue Jul 23 10:16:50 2002

(c) Copyright 2001 Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.0.1.2.0 - 64bit Production
With the Partitioning option
JServer Release 9.0.1.2.0 - Production

SQL>


-Original Message-
Sent: 23 July 2002 00:09
To: Multiple recipients of list ORACLE-L


Hi,
Does anyone know how I can verify if a database is 32 or 64 bit?

Thanks.

elain



_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: elain he
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to which it is 
addressed and may contain confidential and/or privileged material.
Statements and opinions expressed in this e-mail may not represent those of the 
company. Any review, retransmission, dissemination or other use of, or taking of any 
action in reliance upon, this information by persons or entities other than the 
intended recipient is prohibited. If you received this in error, please contact the 
sender immediately and delete the material from any computer.


==

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Adrian Roe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Oracle - 32bit/64bit??

2002-07-22 Thread kkennedy

As someone mentioned on the list, not too recently, use the following command:
file $ORACLE_HOME/bin/oracle

On my machine with 32 bit Oracle, I get:
/keg2/oracle/product/8.1.7/bin/oracle:  ELF 32-bit MSB executable SPARC Version 1, 
dynamically linked, not stripped

HTH
Kevin Kennedy
First Point Energy Corporation 

-Original Message-
Sent: Monday, July 22, 2002 4:09 PM
To: Multiple recipients of list ORACLE-L


Hi,
Does anyone know how I can verify if a database is 32 or 64 bit?

Thanks.

elain



_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: elain he
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: kkennedy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Oracle 32bit / 64bit

2001-07-17 Thread Rao, Maheswara

Mitchell,

We have both 32 bit and 64 bit Oracle 817 running on Solaris 7.

The easiest way is --- When you log onto SQL, then you would get a message
similar to following:

Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64 bit production

Now, if you are running 32 bit version, you get the following message

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production

Please observe that the above message is not telling whether it is 32 or 64.
But for 64 bit, the message specifically tells you.


Thanks,

Rao

-Original Message-
Sent: Tuesday, July 17, 2001 3:38 PM
To: Multiple recipients of list ORACLE-L


Dear DBAs

How can I know  my Oracle running on 32 or 64bit ?
I am considering change configuration of SGA. Currently OS is updated to 8g
memory on aix 4.3.3.
The limit is 2gb for 32bit ?

I only know if you switch  from 32bit to 64bit or vice-a-versa, then  you
also need to run UTLIRP.SQL script which recompiles all PL/SQL modules and
alters certain dictionary tables.


Mitchell



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rao, Maheswara
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Oracle 32bit / 64bit

2001-07-17 Thread Kimberly Smith

Actually, as soon as you sign onto SQL*Plus is good enough.
Oracle8i Enterprise Edition Release 8.1.5.0.0, 64 bit - Production
Oracle8i Enterprise Edition Release 8.1.7.1.0 - Production
Note the difference between the two.

-Original Message-
Sent: Tuesday, July 17, 2001 1:00 PM
To: Multiple recipients of list ORACLE-L


Easiest way I know is do a select * from v$session, if the session id is 8
digits your running 32 bit, if it is 16 your running 64 bit.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Tuesday, July 17, 2001 3:38 PM
To: Multiple recipients of list ORACLE-L


Dear DBAs

How can I know  my Oracle running on 32 or 64bit ?
I am considering change configuration of SGA. Currently OS is updated to 8g
memory on aix 4.3.3. The limit is 2gb for 32bit ?

I only know if you switch  from 32bit to 64bit or vice-a-versa, then  you
also need to run UTLIRP.SQL script which recompiles all PL/SQL modules and
alters certain dictionary tables.


Mitchell



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mitchell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Oracle 32bit / 64bit

2001-07-17 Thread Deshpande, Kirti

The SQL*Plus banner will display if using 64bit. If it does not say '64bit'
then it's 32bit. 

Here is what I get with 9.0.1 64-bit on HP-UX:

Connected to:
Oracle9i Enterprise Edition Release 9.0.1.0.0 - 64bit Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production

I do not have 8.1.x in 64-bit but I think the same thing would be true there
as well.

HTH,

Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Mitchell [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, July 17, 2001 2:38 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: Oracle 32bit / 64bit
> 
> Dear DBAs
> 
> How can I know  my Oracle running on 32 or 64bit ?
> I am considering change configuration of SGA. Currently OS is updated to
> 8g
> memory on aix 4.3.3.
> The limit is 2gb for 32bit ?
> 
> I only know if you switch  from 32bit to 64bit or vice-a-versa, then  you
> also need to run UTLIRP.SQL script which recompiles all PL/SQL modules and
> alters certain dictionary tables.
> 
> 
> Mitchell
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mitchell
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Oracle 32bit / 64bit

2001-07-17 Thread Christopher Spence

Easiest way I know is do a select * from v$session, if the session id is 8
digits your running 32 bit, if it is 16 your running 64 bit.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Tuesday, July 17, 2001 3:38 PM
To: Multiple recipients of list ORACLE-L


Dear DBAs

How can I know  my Oracle running on 32 or 64bit ?
I am considering change configuration of SGA. Currently OS is updated to 8g
memory on aix 4.3.3. The limit is 2gb for 32bit ?

I only know if you switch  from 32bit to 64bit or vice-a-versa, then  you
also need to run UTLIRP.SQL script which recompiles all PL/SQL modules and
alters certain dictionary tables.


Mitchell



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mitchell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: Oracle 32bit / 64bit

2001-07-17 Thread Mitchell

Dear DBAs

How can I know  my Oracle running on 32 or 64bit ?
I am considering change configuration of SGA. Currently OS is updated to 8g
memory on aix 4.3.3.
The limit is 2gb for 32bit ?

I only know if you switch  from 32bit to 64bit or vice-a-versa, then  you
also need to run UTLIRP.SQL script which recompiles all PL/SQL modules and
alters certain dictionary tables.


Mitchell



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mitchell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).