Re: Oracle Version 8 as read only
Hi Tims ideas are good but also take a cold backup of the database before the read only period starts so that even if someone manages to alter data it can be restored back to its previous state. By the way when you say read only does that apply to batch processes and general system ageing? - if so you need to ensure you back up after each batch run so it can be restored to a fixed position if someone manages to change anything. always remember least privilege principle!! hope this helps kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Oracle Version 8 as read only
We are in the process of upgrading our peoplesoft app, using an oracle database of 8.0.5 to 9i. During the upgrade we still need access to the old 8.0.5 database as readonly. I have read all the doc's but it appears I cannot open the database as read only. Looks like I could if the version was 8i. Does anybody have any pointers on how I could accomplish this. Thanks Darren. -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 Version 8 as read only
Darren, Couldn't you just open the database with a user that has all the necessary privileges revoked? -Original Message- Browett, Darren Sent: Wednesday, November 26, 2003 3:44 PM To: Multiple recipients of list ORACLE-L We are in the process of upgrading our peoplesoft app, using an oracle database of 8.0.5 to 9i. During the upgrade we still need access to the old 8.0.5 database as readonly. I have read all the doc's but it appears I cannot open the database as read only. Looks like I could if the version was 8i. Does anybody have any pointers on how I could accomplish this. Thanks Darren. -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: nelson flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 Version 8 as read only
You can't. Even if you were to set all possible tablespaces to READ ONLY, you'll find that it doesn't prevent folks from dropping objects. All you can do is restrict people to schemas/accounts which do not own any objects and do not have permissions to create any. That way, you can restrict them to CREATE SESSION, ALTER SESSION, and SELECT permissions only. on 11/26/03 4:44 PM, Browett, Darren at [EMAIL PROTECTED] wrote: We are in the process of upgrading our peoplesoft app, using an oracle database of 8.0.5 to 9i. During the upgrade we still need access to the old 8.0.5 database as readonly. I have read all the doc's but it appears I cannot open the database as read only. Looks like I could if the version was 8i. Does anybody have any pointers on how I could accomplish this. Thanks Darren. -- Darren Browett P.Eng This message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 Version 8 as read only
Looks like that is what we will be doing, basically creating a generic user with read-only privileges. All the current users will have their password changed so they cannot access the system. Darren -Original Message- Sent: Wednesday, November 26, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Darren, Couldn't you just open the database with a user that has all the necessary privileges revoked? -Original Message- Browett, Darren Sent: Wednesday, November 26, 2003 3:44 PM To: Multiple recipients of list ORACLE-L We are in the process of upgrading our peoplesoft app, using an oracle database of 8.0.5 to 9i. During the upgrade we still need access to the old 8.0.5 database as readonly. I have read all the doc's but it appears I cannot open the database as read only. Looks like I could if the version was 8i. Does anybody have any pointers on how I could accomplish this. Thanks Darren. -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: nelson flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 Version 8 as read only
Consider also using ALTER USER xxx ACCOUNT LOCK instead of changing the passwords... on 11/26/03 6:49 PM, Browett, Darren at [EMAIL PROTECTED] wrote: Looks like that is what we will be doing, basically creating a generic user with read-only privileges. All the current users will have their password changed so they cannot access the system. Darren -Original Message- Sent: Wednesday, November 26, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Darren, Couldn't you just open the database with a user that has all the necessary privileges revoked? -Original Message- Browett, Darren Sent: Wednesday, November 26, 2003 3:44 PM To: Multiple recipients of list ORACLE-L We are in the process of upgrading our peoplesoft app, using an oracle database of 8.0.5 to 9i. During the upgrade we still need access to the old 8.0.5 database as readonly. I have read all the doc's but it appears I cannot open the database as read only. Looks like I could if the version was 8i. Does anybody have any pointers on how I could accomplish this. Thanks Darren. -- Darren Browett P.Eng This message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
oracle version
Hello All, OS: Solaris DB: Oracle Can somebody tell me how to know in what version or patchset level the oracle home is ? when I go and see in $ORACLE_HOME, I couldn't find whether it is 8.1.7.3 , 8.1.7.4 or 8.1.7.0 or some other. How to know exactly at which version the $ORACLE_HOME is? Thanks and regards, Srinivas __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 version
From sql : select * from product_component_version; It can either be shown when logging into sqlplus (check the headers). Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 05, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Hello All, OS: Solaris DB: Oracle Can somebody tell me how to know in what version or patchset level the oracle home is ? when I go and see in $ORACLE_HOME, I couldn't find whether it is 8.1.7.3 , 8.1.7.4 or 8.1.7.0 or some other. How to know exactly at which version the $ORACLE_HOME is? Thanks and regards, Srinivas __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Hatzistavrou John INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 version
select banner from sys.v_$version; will give u the version number santosh -Original Message- sreenivasa Sent: Wednesday, March 05, 2003 1:19 PM To: Multiple recipients of list ORACLE-L Hello All, OS: Solaris DB: Oracle Can somebody tell me how to know in what version or patchset level the oracle home is ? when I go and see in $ORACLE_HOME, I couldn't find whether it is 8.1.7.3 , 8.1.7.4 or 8.1.7.0 or some other. How to know exactly at which version the $ORACLE_HOME is? Thanks and regards, Srinivas __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: FW: oracle version
Hi, I need it to check from O/S level. not from database level. can somebody give any hints. Thanks and Regards, Srinivas -Original Message- From: Hatzistavrou John [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: oracle version From sql : select * from product_component_version; It can either be shown when logging into sqlplus (check the headers). Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 05, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Hello All, OS: Solaris DB: Oracle Can somebody tell me how to know in what version or patchset level the oracle home is ? when I go and see in $ORACLE_HOME, I couldn't find whether it is 8.1.7.3 , 8.1.7.4 or 8.1.7.0 or some other. How to know exactly at which version the $ORACLE_HOME is? Thanks and regards, Srinivas __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Hatzistavrou John INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: FW: oracle version
did u try the inventory logs ? Babu kommareddy sreenivasa To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: om Subject: Re: FW: oracle version Sent by: [EMAIL PROTECTED] 03/05/03 01:09 PM Please respond to ORACLE-L Hi, I need it to check from O/S level. not from database level. can somebody give any hints. Thanks and Regards, Srinivas -Original Message- From: Hatzistavrou John [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: oracle version From sql : select * from product_component_version; It can either be shown when logging into sqlplus (check the headers). Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 05, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Hello All, OS: Solaris DB: Oracle Can somebody tell me how to know in what version or patchset level the oracle home is ? when I go and see in $ORACLE_HOME, I couldn't find whether it is 8.1.7.3 , 8.1.7.4 or 8.1.7.0 or some other. How to know exactly at which version the $ORACLE_HOME is? Thanks and regards, Srinivas __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Hatzistavrou John INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http
Re: Oracle version??
In the registry My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\inst_loc specifies the location of the inventory folder (defaults to C:\Program Files\Oracle\Inventory). Note: some Oracle patches do replace oracle.exe without using the Oracle Universal Installer (OUI) so the inventory would have no record of the patch (e.g. 8.1.7.4.6). Inside the inventory folder, Components and Patches have folders for components installed by OUI. For example, my inventory folder contains these folders: N:\Oracle\Inventory\Components\oracle.server\8.1.7.0.0\1\resources N:\Oracle\Inventory\Components\oracle.server\9.0.1.1.1\1\resources N:\Oracle\Inventory\Components\oracle.server\9.2.0.1.0\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\8.1.7.4.1\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\9.0.1.4.0\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\9.2.0.2.1\1\resources Note: the version numbers (folder names) do match my OUI installation of Oracle servers and patches. When using Windows XP Pro, the properties of oracle.exe is interesting - the version displayed near the top is 0.0.0.0, yet the File Version near the bottom of the dialog box does display the correct version. Wonder how Windows XP Pro finds the correct version, while Windows 2000 Pro can't see it. Have Fun :) Rajesh Dayal wrote: Hi Sunil, The tragedy is that even if you logon to database, you may not find the precise patch level from database. The best location is orainventory/log directory. OK on MS machines C:\Program Files\Oracle\Inventory\logs. Go to this directory and check the latest log file from this location. HTH, Rajesh -Original Message- Sent: Thursday, February 27, 2003 7:09 AM To: Multiple recipients of list ORACLE-L List, Can Oracle version be determined based on size of Oracle.EXE file on Windows? I am looking for a valid way of determining the patch level without having to log onto the database and check v$instance. appreciate any feedback. Sunil Nookala Dell Corp. Austin, TX. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 version??
List, Can Oracle version be determined based on size of Oracle.EXE file on Windows? I am looking for a valid way of determining the patch level without having to log onto the database and check v$instance. appreciate any feedback. Sunil Nookala Dell Corp. Austin, TX. What if the only differences are in DLLs ? Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 version??
Hi Chip, I am talking of log directory(N:\Oracle\Inventory\logs and not N:\Oracle\Inventory\components), where every Installer action is logged and not . This doesn't matter whether your Oracle.exe is replaced or not. All of your OUI actions will be logged with all the relevant information and typically the file names are of following format. installActions2003-01-21_12-01-02PM.log So if you put little extra effort digging these files (depending on size, timestamp etc.) you can find out what is last activity you performed on what ORACLE_HOME and so the precise patch level is also available there... And that YP-ZP I mean XP, I would really hate to see a Oracle Database on that ;-)... Cheers, Rajesh -Original Message- Sent: Thursday, February 27, 2003 11:59 AM To: Multiple recipients of list ORACLE-L In the registry My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\inst_loc specifies the location of the inventory folder (defaults to C:\Program Files\Oracle\Inventory). Note: some Oracle patches do replace oracle.exe without using the Oracle Universal Installer (OUI) so the inventory would have no record of the patch (e.g. 8.1.7.4.6). Inside the inventory folder, Components and Patches have folders for components installed by OUI. For example, my inventory folder contains these folders: N:\Oracle\Inventory\Components\oracle.server\8.1.7.0.0\1\resources N:\Oracle\Inventory\Components\oracle.server\9.0.1.1.1\1\resources N:\Oracle\Inventory\Components\oracle.server\9.2.0.1.0\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\8.1.7.4.1\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\9.0.1.4.0\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\9.2.0.2.1\1\resources Note: the version numbers (folder names) do match my OUI installation of Oracle servers and patches. When using Windows XP Pro, the properties of oracle.exe is interesting - the version displayed near the top is 0.0.0.0, yet the File Version near the bottom of the dialog box does display the correct version. Wonder how Windows XP Pro finds the correct version, while Windows 2000 Pro can't see it. Have Fun :) Rajesh Dayal wrote: Hi Sunil, The tragedy is that even if you logon to database, you may not find the precise patch level from database. The best location is orainventory/log directory. OK on MS machines C:\Program Files\Oracle\Inventory\logs. Go to this directory and check the latest log file from this location. HTH, Rajesh -Original Message- Sent: Thursday, February 27, 2003 7:09 AM To: Multiple recipients of list ORACLE-L List, Can Oracle version be determined based on size of Oracle.EXE file on Windows? I am looking for a valid way of determining the patch level without having to log onto the database and check v$instance. appreciate any feedback. Sunil Nookala Dell Corp. Austin, TX. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 version??
My inventory logs (19 files, 16.6 MB) do have a verbose record of OUI actions. Note: all the installation logs can be deleted to clean up space. Also, the inventory logs only record OUI actions. The Oracle 8.1.7.4.6 patch installation does not use OUI (the DBA manually copies many files into the Oracle Home), which does cause a mismatch between the inventory version and the actual version installed. On the OUI opening screen, the "Installed Products..." button can be used to display the current inventory. Thus, I was looking in the inventory folder trying to guess what OUI is using. Looking again, I found some more interesting folders: N:\Oracle\Inventory\PatchSets\oracle.server\8.1.7.4.1\1\resources N:\Oracle\Inventory\PatchSets\oracle.server\9.0.1.4.0\1\resources N:\Oracle\Inventory\PatchSets\oracle.server\9.2.0.2.1\1\resources The inventory folders does provide a way to quickly get an idea of the oracle server version(s) installed by OUI. Use the inst_loc registry key to find the inventory location, then look for "oracle.server" within "Components" and "PatchSets"; the included folders have the version numbers. Have Fun :) Rajesh Dayal wrote: Hi Chip, I am talking of log directory(N:\Oracle\Inventory\logs and not N:\Oracle\Inventory\components), where every Installer action is logged and not . This doesn't matter whether your Oracle.exe is replaced or not. All of your OUI actions will be logged with all the relevant information and typically the file names are of following format. installActions2003-01-21_12-01-02PM.log So if you put little extra effort digging these files (depending on size, timestamp etc.) you can find out what is last activity you performed on what ORACLE_HOME and so the precise patch level is also available there... And that YP-ZP I mean XP, I would really hate to see a Oracle Database on that ;-)... Cheers, Rajesh -Original Message- Sent: Thursday, February 27, 2003 11:59 AM To: Multiple recipients of list ORACLE-L In the registry "My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\inst_loc" specifies the location of the inventory folder (defaults to C:\Program Files\Oracle\Inventory). Note: some Oracle patches do replace oracle.exe without using the Oracle Universal Installer (OUI) so the inventory would have no record of the patch (e.g. 8.1.7.4.6). Inside the inventory folder, "Components" and "Patches" have folders for components installed by OUI. For example, my inventory folder contains these folders: N:\Oracle\Inventory\Components\oracle.server\8.1.7.0.0\1\resources N:\Oracle\Inventory\Components\oracle.server\9.0.1.1.1\1\resources N:\Oracle\Inventory\Components\oracle.server\9.2.0.1.0\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\8.1.7.4.1\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\9.0.1.4.0\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\9.2.0.2.1\1\resources Note: the version numbers (folder names) do match my OUI installation of Oracle servers and patches. When using Windows XP Pro, the properties of oracle.exe is interesting - the version displayed near the top is 0.0.0.0, yet the "File Version" near the bottom of the dialog box does display the correct version. Wonder how Windows XP Pro finds the correct version, while Windows 2000 Pro can't see it. Have Fun :) Rajesh Dayal wrote: Hi Sunil, The tragedy is that even if you logon to database, you may not find the precise patch level from database. The best location is orainventory/log directory. OK on MS machines C:\Program Files\Oracle\Inventory\logs. Go to this directory and check the latest log file from this location. HTH, Rajesh -Original Message- Sent: Thursday, February 27, 2003 7:09 AM To: Multiple recipients of list ORACLE-L List, Can Oracle version be determined based on size of Oracle.EXE file on Windows? I am looking for a valid way of determining the patch level without having to log onto the database and check v$instance. appreciate any feedback. Sunil Nookala Dell Corp. Austin, TX. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City
Oracle version??
List, Can Oracle version be determined based on size of Oracle.EXE file on Windows? I am looking for a valid way of determining the patch level without having to log onto the database and check v$instance. appreciate any feedback. Sunil Nookala Dell Corp. Austin, TX. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 version??
Hi Sunil, The tragedy is that even if you logon to database, you may not find the precise patch level from database. The best location is orainventory/log directory. OK on MS machines C:\Program Files\Oracle\Inventory\logs. Go to this directory and check the latest log file from this location. HTH, Rajesh -Original Message- Sent: Thursday, February 27, 2003 7:09 AM To: Multiple recipients of list ORACLE-L List, Can Oracle version be determined based on size of Oracle.EXE file on Windows? I am looking for a valid way of determining the patch level without having to log onto the database and check v$instance. appreciate any feedback. Sunil Nookala Dell Corp. Austin, TX. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 version??
I just plugged through a $ strings oracle to see if the version information is in there anyplace. On an 8.1.7 kernel, I was surprised to find that version numbers all the way from 8.0.0 through 8.2.0 show up in the file. The string I was really looking for was Oracle8i Enterprise Edition Release %d.%d.%d.%d.%d %s--the release number is stored in five separate variables, which are printed through this printf format string... However, there are a couple of tricks you might engage. I just did this on my Linux system and found what version my kernel *thinks* it is: $ strace -s100 oracle 21 | grep Oracle.*Release This strace command catches the kernel's write() call of the release number into a background trace file. You could also look at the background trace files if you wanted to conserve the overhead of invoking the oracle executable. The thing exit()s, so I think it's safe to run it this way, but you probably don't want the side effects of extra trace file writing, etc. I think peeking into the trace file is a possible solution for you, but then I'd take the wise advice of people of those on the list who might be able to prove that the kernel can actually lie about its own release number... Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - RMOUG Training Days 2003, Mar 5-6 Denver - Hotsos Clinic 101, Mar 25-27 London -Original Message- Dayal Sent: Wednesday, February 26, 2003 11:49 PM To: Multiple recipients of list ORACLE-L Hi Sunil, The tragedy is that even if you logon to database, you may not find the precise patch level from database. The best location is orainventory/log directory. OK on MS machines C:\Program Files\Oracle\Inventory\logs. Go to this directory and check the latest log file from this location. HTH, Rajesh -Original Message- Sent: Thursday, February 27, 2003 7:09 AM To: Multiple recipients of list ORACLE-L List, Can Oracle version be determined based on size of Oracle.EXE file on Windows? I am looking for a valid way of determining the patch level without having to log onto the database and check v$instance. appreciate any feedback. Sunil Nookala Dell Corp. Austin, TX. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: same sql: different db block gets in different oracle version
Tablescans in Oracle 8 start with 4 current gets (db block gets) on the segment header block - in Oracle 9 tablescans start with 2 consistent gets on the segment header. I can't tell you why you have 12 current gets rather than 4 - but if the tests aren't identical, the physical reads and extra current gets may be related to delayed cleanout on a first read. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 22 January 2003 07:42 Hi, dba friends: Look at the following test result, the first one is from oracle9.2, and the second is from the oracle 817. The table is same, and as you see, the execution path is the same. But there is difference in statistics: db_block_gets, in oracle92, it is 0, and in oracle817, it is not. And i noticed that in oracle8i, all sql that does only query with execution path full scan of table/index,there will always be db_block_gets, while in 9i, select won't make db_block_gets. As tom said, db_block_gets is increased when data is accessed for update, how does this query generate this statistics? ORA92 select count(*) from abc; COUNT(*) -- 1 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=6 Card=1) 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF 'ABC' (Cost=6 Card=1) Statistics -- 0 recursive calls 0 db block gets 27 consistent gets 0 physical reads 0 redo size 379 bytes sent via SQL*Net to client 503 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed ORA817 select count(*) from abc; COUNT(*) -- 1 Elapsed: 00:00:00.26 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF 'ABC' Statistics -- 0 recursive calls 12 db block gets 28 consistent gets 24 physical reads 0 redo size 367 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: same sql: different db block gets in different oracle version
Check your setting parameter for db_block_gets and compare between oracle9.2 and oracle817. Is it equivalent setting parameter ? -Original Message- From: chao_ping [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 1:54 PM To: Multiple recipients of list ORACLE-L Subject: same sql: different db block gets in different oracle version Hi, dba friends: Look at the following test result, the first one is from oracle9.2, and the second is from the oracle 817. The table is same, and as you see, the execution path is the same. But there is difference in statistics: db_block_gets, in oracle92, it is 0, and in oracle817, it is not. And i noticed that in oracle8i, all sql that does only query with execution path full scan of table/index,there will always be db_block_gets, while in 9i, select won't make db_block_gets. As tom said, db_block_gets is increased when data is accessed for update, how does this query generate this statistics? ORA92 select count(*) from abc; COUNT(*) -- 1 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=6 Card=1) 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF 'ABC' (Cost=6 Card=1) Statistics -- 0 recursive calls 0 db block gets 27 consistent gets 0 physical reads 0 redo size 379 bytes sent via SQL*Net to client 503 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed ORA817 select count(*) from abc; COUNT(*) -- 1 Elapsed: 00:00:00.26 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF 'ABC' Statistics -- 0 recursive calls 12 db block gets 28 consistent gets 24 physical reads 0 redo size 367 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Re: same sql: different db block gets in different oracle version
Jonathan Lewis, Thanks very much for your reply. Yes, in oracle 8i on sun solaris, the db block gets of fulltable scan is always 4block, no matter what the size of the table is. But in my tests in linux/817, it always show 12(8170 and 8172).I run the full scan again and again, but the value does not change. And another problem is why in oracle9i, there is no db_block_gets when doing full segment scan.I checked asktom.oracle.com, but unable to find the answer. And i also tested 9.0.1 on sun solaris , when very small, db_block_gets is 6,while larger tables(12K records from dba_tables), db_block_gets is 12. Scanning the segment header caused the current mode read,is it because of scanning the buffer pool head and getting the cache buffer chains latch in exclusive mode,and the buffer head will be moved the other end lru list? why scanning the other data block does not cause the current read? Sorry, I asked to much, and maybe they are meanless, but if possible, I still want to know. Sony kristanto, what kind of parameters do you think will affect the db_block_gets? I will post them. Thanks. Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) === 2003-01-22 00:33:00 ,you wrote£º=== Tablescans in Oracle 8 start with 4 current gets (db block gets) on the segment header block - in Oracle 9 tablescans start with 2 consistent gets on the segment header. I can't tell you why you have 12 current gets rather than 4 - but if the tests aren't identical, the physical reads and extra current gets may be related to delayed cleanout on a first read. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 22 January 2003 07:42 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: same sql: different db block gets in different oracle version
Cho, This is not unusual. I suspect your db_cache_size (or db_block_buffers) in 9.2 is more than db_block_buffers in 8.1. When you do a FTS, all the blocks are loaded into the buffers first time so 'db block gets' is a non zero value (it's the physical IO). The next time you do this, the blocks are found in the buffer already, so there is no physical IO, hence a zero value for 'db block gets'. However, your logical reads (consistent gets) should be the same and they are the same. In 817, run the query once again and see the 'db block gets' , it should be 0. If not then check if db_block_buffers is less than db_cache_size (or db_block_buffers) in 9.2. HTH. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 22, 2003 1:53 AM Hi, dba friends: Look at the following test result, the first one is from oracle9.2, and the second is from the oracle 817. The table is same, and as you see, the execution path is the same. But there is difference in statistics: db_block_gets, in oracle92, it is 0, and in oracle817, it is not. And i noticed that in oracle8i, all sql that does only query with execution path full scan of table/index,there will always be db_block_gets, while in 9i, select won't make db_block_gets. As tom said, db_block_gets is increased when data is accessed for update, how does this query generate this statistics? ORA92 select count(*) from abc; COUNT(*) -- 1 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=6 Card=1) 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF 'ABC' (Cost=6 Card=1) Statistics -- 0 recursive calls 0 db block gets 27 consistent gets 0 physical reads 0 redo size 379 bytes sent via SQL*Net to client 503 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed ORA817 select count(*) from abc; COUNT(*) -- 1 Elapsed: 00:00:00.26 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF 'ABC' Statistics -- 0 recursive calls 12 db block gets 28 consistent gets 24 physical reads 0 redo size 367 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Re: same sql: different db block gets in different oracle version
One reason for seeing more db_block_gets than you expect on a full segment scan is that every extent map block (of which the segment header block is just one) is accessed differently. If you have small extents and large objects, you may have overshoot the maximum extents allowed in the segment header block - so the 12 db_block_gets could indicate 2 extra map blocks. NOTE - Oracle 9 simply does not do 4 CU gets on map blocks. 8.14 CU gets per map block 9.22 CR gets per map block 9.02 gets, but can't remember if they are CU or CR Also - bigger tables = more map blocks may have been used Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 22 January 2003 15:47 version Jonathan Lewis, Thanks very much for your reply. Yes, in oracle 8i on sun solaris, the db block gets of fulltable scan is always 4block, no matter what the size of the table is. But in my tests in linux/817, it always show 12(8170 and 8172).I run the full scan again and again, but the value does not change. And another problem is why in oracle9i, there is no db_block_gets when doing full segment scan.I checked asktom.oracle.com, but unable to find the answer. And i also tested 9.0.1 on sun solaris , when very small, db_block_gets is 6,while larger tables(12K records from dba_tables), db_block_gets is 12. Scanning the segment header caused the current mode read,is it because of scanning the buffer pool head and getting the cache buffer chains latch in exclusive mode,and the buffer head will be moved the other end lru list? why scanning the other data block does not cause the current read? Sorry, I asked to much, and maybe they are meanless, but if possible, I still want to know. Sony kristanto, what kind of parameters do you think will affect the db_block_gets? I will post them. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
same sql: different db block gets in different oracle version
Hi, dba friends: Look at the following test result, the first one is from oracle9.2, and the second is from the oracle 817. The table is same, and as you see, the execution path is the same. But there is difference in statistics: db_block_gets, in oracle92, it is 0, and in oracle817, it is not. And i noticed that in oracle8i, all sql that does only query with execution path full scan of table/index,there will always be db_block_gets, while in 9i, select won't make db_block_gets. As tom said, db_block_gets is increased when data is accessed for update, how does this query generate this statistics? ORA92 select count(*) from abc; COUNT(*) -- 1 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=6 Card=1) 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF 'ABC' (Cost=6 Card=1) Statistics -- 0 recursive calls 0 db block gets 27 consistent gets 0 physical reads 0 redo size 379 bytes sent via SQL*Net to client 503 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed ORA817 select count(*) from abc; COUNT(*) -- 1 Elapsed: 00:00:00.26 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF 'ABC' Statistics -- 0 recursive calls 12 db block gets 28 consistent gets 24 physical reads 0 redo size 367 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Oracle Version on Unix
I know this was discussed a short time ago, but how do I determine if the Oracle 817 version installed on a Sun Unix box is 32 or 64 bit? I'm looking at migrating to 9.2/64 bit and noticed that I cannot directly migrate a 32bit version to 64 bit. Thanks Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 11, 2002 2:18 PM To: Multiple recipients of list ORACLE-L My house is insured and I'm contemplating a ground up redecoration. As for being an infidel, the God is great and Larry Wall is his prophet. I'm a true believer. -Original Message- From: Naveen Nahata [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 12:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks Please don't use wrong words like these for the Al Qaida members, you risk termed an 'infidel' and getting your house attacked by a suicide bomber :-) -Original Message- Sent: Wednesday, September 11, 2002 9:44 PM To: Multiple recipients of list ORACLE-L Nope. Developers are not normal users and Al Quaida members are not normal members of society. Both are very dangerous. -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks I have a problem with normal users monitoring locks. Do you consider developers to be normal users? Given the number of locking problems which you can trace back to the code, I would have no problem in that case. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul 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: Gogala, Mladen 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: Naveen Nahata 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: Gogala, Mladen 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: Mercadante, Thomas F 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
RE: Oracle Version on Unix
file $ORACLE_HOME/bin/oracle -Original Message- Sent: Wednesday, September 11, 2002 2:04 PM To: Multiple recipients of list ORACLE-L I know this was discussed a short time ago, but how do I determine if the Oracle 817 version installed on a Sun Unix box is 32 or 64 bit? I'm looking at migrating to 9.2/64 bit and noticed that I cannot directly migrate a 32bit version to 64 bit. Thanks Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 11, 2002 2:18 PM To: Multiple recipients of list ORACLE-L My house is insured and I'm contemplating a ground up redecoration. As for being an infidel, the God is great and Larry Wall is his prophet. I'm a true believer. -Original Message- From: Naveen Nahata [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 12:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks Please don't use wrong words like these for the Al Qaida members, you risk termed an 'infidel' and getting your house attacked by a suicide bomber :-) -Original Message- Sent: Wednesday, September 11, 2002 9:44 PM To: Multiple recipients of list ORACLE-L Nope. Developers are not normal users and Al Quaida members are not normal members of society. Both are very dangerous. -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks I have a problem with normal users monitoring locks. Do you consider developers to be normal users? Given the number of locking problems which you can trace back to the code, I would have no problem in that case. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul 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: Gogala, Mladen 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: Naveen Nahata 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: Gogala, Mladen 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: Mercadante, Thomas F 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
Re: Oracle Version on Unix
file $ORACLE_HOME/bin/oracle On Wed, 2002-09-11 at 15:03, Mercadante, Thomas F wrote: I know this was discussed a short time ago, but how do I determine if the Oracle 817 version installed on a Sun Unix box is 32 or 64 bit? I'm looking at migrating to 9.2/64 bit and noticed that I cannot directly migrate a 32bit version to 64 bit. Thanks Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Stauffer 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 Version on Unix
Just login with sqlplus you'll get: Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production If it's 64 bit it tells you. -Original Message- Sent: Wednesday, September 11, 2002 2:04 PM To: Multiple recipients of list ORACLE-L I know this was discussed a short time ago, but how do I determine if the Oracle 817 version installed on a Sun Unix box is 32 or 64 bit? I'm looking at migrating to 9.2/64 bit and noticed that I cannot directly migrate a 32bit version to 64 bit. Thanks Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 11, 2002 2:18 PM To: Multiple recipients of list ORACLE-L My house is insured and I'm contemplating a ground up redecoration. As for being an infidel, the God is great and Larry Wall is his prophet. I'm a true believer. -Original Message- From: Naveen Nahata [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 12:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks Please don't use wrong words like these for the Al Qaida members, you risk termed an 'infidel' and getting your house attacked by a suicide bomber :-) -Original Message- Sent: Wednesday, September 11, 2002 9:44 PM To: Multiple recipients of list ORACLE-L Nope. Developers are not normal users and Al Quaida members are not normal members of society. Both are very dangerous. -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks I have a problem with normal users monitoring locks. Do you consider developers to be normal users? Given the number of locking problems which you can trace back to the code, I would have no problem in that case. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul 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: Gogala, Mladen 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: Naveen Nahata 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: Gogala, Mladen 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Oracle Version on Unix
There are couple of methods to determine it. One is when you login as sqlplus, it will show the word 64 bit in the banner. Or if you do file $ORACLE_HOME/bin/oracle oracle: ELF 64-bit MSB executable SPARCV9 Version 1, dynamically linked, not stripped It shows whether is a 32bit or 64bit executable. -Original Message- Sent: Wednesday, September 11, 2002 3:04 PM To: Multiple recipients of list ORACLE-L I know this was discussed a short time ago, but how do I determine if the Oracle 817 version installed on a Sun Unix box is 32 or 64 bit? I'm looking at migrating to 9.2/64 bit and noticed that I cannot directly migrate a 32bit version to 64 bit. Thanks Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 11, 2002 2:18 PM To: Multiple recipients of list ORACLE-L My house is insured and I'm contemplating a ground up redecoration. As for being an infidel, the God is great and Larry Wall is his prophet. I'm a true believer. -Original Message- From: Naveen Nahata [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 12:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks Please don't use wrong words like these for the Al Qaida members, you risk termed an 'infidel' and getting your house attacked by a suicide bomber :-) -Original Message- Sent: Wednesday, September 11, 2002 9:44 PM To: Multiple recipients of list ORACLE-L Nope. Developers are not normal users and Al Quaida members are not normal members of society. Both are very dangerous. -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks I have a problem with normal users monitoring locks. Do you consider developers to be normal users? Given the number of locking problems which you can trace back to the code, I would have no problem in that case. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul 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: Gogala, Mladen 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: Naveen Nahata 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: Gogala, Mladen 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--
RE: Oracle Version on Unix
Title: RE: Oracle Version on Unix Chapter 7 Section Changing the Word-Size of your Current Release within the Oracle 9i Database Migration Manual. I dont see why you couldn't do: file ${ORACLE_HOME}/bin/oracle to determine the word size. -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 3:04 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Version on Unix I know this was discussed a short time ago, but how do I determine if the Oracle 817 version installed on a Sun Unix box is 32 or 64 bit? I'm looking at migrating to 9.2/64 bit and noticed that I cannot directly migrate a 32bit version to 64 bit. Thanks Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 11, 2002 2:18 PM To: Multiple recipients of list ORACLE-L My house is insured and I'm contemplating a ground up redecoration. As for being an infidel, the God is great and Larry Wall is his prophet. I'm a true believer. -Original Message- From: Naveen Nahata [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 12:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks Please don't use wrong words like these for the Al Qaida members, you risk termed an 'infidel' and getting your house attacked by a suicide bomber :-) -Original Message- Sent: Wednesday, September 11, 2002 9:44 PM To: Multiple recipients of list ORACLE-L Nope. Developers are not normal users and Al Quaida members are not normal members of society. Both are very dangerous. -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks I have a problem with normal users monitoring locks. Do you consider developers to be normal users? Given the number of locking problems which you can trace back to the code, I would have no problem in that case. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul 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: Gogala, Mladen 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: Naveen Nahata 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: Gogala, Mladen 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing
RE: Oracle Version on Unix
Go to $ORACLE_HOME/lib and do nm ibclntsh.so|grep fgetpos64 If your output is nonempty, your oracle is 64 bit. -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 3:04 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Version on Unix I know this was discussed a short time ago, but how do I determine if the Oracle 817 version installed on a Sun Unix box is 32 or 64 bit? I'm looking at migrating to 9.2/64 bit and noticed that I cannot directly migrate a 32bit version to 64 bit. Thanks Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 11, 2002 2:18 PM To: Multiple recipients of list ORACLE-L My house is insured and I'm contemplating a ground up redecoration. As for being an infidel, the God is great and Larry Wall is his prophet. I'm a true believer. -Original Message- From: Naveen Nahata [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 12:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks Please don't use wrong words like these for the Al Qaida members, you risk termed an 'infidel' and getting your house attacked by a suicide bomber :-) -Original Message- Sent: Wednesday, September 11, 2002 9:44 PM To: Multiple recipients of list ORACLE-L Nope. Developers are not normal users and Al Quaida members are not normal members of society. Both are very dangerous. -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks I have a problem with normal users monitoring locks. Do you consider developers to be normal users? Given the number of locking problems which you can trace back to the code, I would have no problem in that case. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul 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: Gogala, Mladen 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: Naveen Nahata 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: Gogala, Mladen 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858
RE: Oracle Version on Unix
Dennis, You da'man. Thank you! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 11, 2002 3:23 PM To: Multiple recipients of list ORACLE-L file $ORACLE_HOME/bin/oracle -Original Message- Sent: Wednesday, September 11, 2002 2:04 PM To: Multiple recipients of list ORACLE-L I know this was discussed a short time ago, but how do I determine if the Oracle 817 version installed on a Sun Unix box is 32 or 64 bit? I'm looking at migrating to 9.2/64 bit and noticed that I cannot directly migrate a 32bit version to 64 bit. Thanks Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 11, 2002 2:18 PM To: Multiple recipients of list ORACLE-L My house is insured and I'm contemplating a ground up redecoration. As for being an infidel, the God is great and Larry Wall is his prophet. I'm a true believer. -Original Message- From: Naveen Nahata [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 12:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks Please don't use wrong words like these for the Al Qaida members, you risk termed an 'infidel' and getting your house attacked by a suicide bomber :-) -Original Message- Sent: Wednesday, September 11, 2002 9:44 PM To: Multiple recipients of list ORACLE-L Nope. Developers are not normal users and Al Quaida members are not normal members of society. Both are very dangerous. -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks I have a problem with normal users monitoring locks. Do you consider developers to be normal users? Given the number of locking problems which you can trace back to the code, I would have no problem in that case. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul 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: Gogala, Mladen 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: Naveen Nahata 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: Gogala, Mladen 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Oracle Version on Unix
If you are using the manual upgrade method, then you can go from 32-bit 8.1.7 to 64-bit 9.2.0.1 directly. Don't quote me though, because all the documentation I have seen says that you have to first go from 32-bit 8.1.7 to 32-bit 9.2.0.1 and then to 64-bit 9.2.0.1. I think Oracle is just being extra cautious here. I have recently upgraded (manual upgrade) a dev database from 32-bit 8.1.7 to 64-bit 9.2.0.1 (directly) and so far have not seen anything unusual. HTH, Gerardo -Original Message- Sent: Wednesday, September 11, 2002 12:39 PM To: Multiple recipients of list ORACLE-L Dennis, You da'man. Thank you! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 11, 2002 3:23 PM To: Multiple recipients of list ORACLE-L file $ORACLE_HOME/bin/oracle -Original Message- Sent: Wednesday, September 11, 2002 2:04 PM To: Multiple recipients of list ORACLE-L I know this was discussed a short time ago, but how do I determine if the Oracle 817 version installed on a Sun Unix box is 32 or 64 bit? I'm looking at migrating to 9.2/64 bit and noticed that I cannot directly migrate a 32bit version to 64 bit. Thanks Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 11, 2002 2:18 PM To: Multiple recipients of list ORACLE-L My house is insured and I'm contemplating a ground up redecoration. As for being an infidel, the God is great and Larry Wall is his prophet. I'm a true believer. -Original Message- From: Naveen Nahata [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 12:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks Please don't use wrong words like these for the Al Qaida members, you risk termed an 'infidel' and getting your house attacked by a suicide bomber :-) -Original Message- Sent: Wednesday, September 11, 2002 9:44 PM To: Multiple recipients of list ORACLE-L Nope. Developers are not normal users and Al Quaida members are not normal members of society. Both are very dangerous. -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks I have a problem with normal users monitoring locks. Do you consider developers to be normal users? Given the number of locking problems which you can trace back to the code, I would have no problem in that case. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul 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: Gogala, Mladen 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: Naveen Nahata 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: Gogala, Mladen 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,
Oracle Version Numbers Explained
There was some discussion recently (in the thread on Apache and iAS) on version numbers of Oracle and how confusing they have become. Here is a document that explains the version numbers, at least for the RDBMS. It lost it's authorship along the way, so forgive me for not crediting it. If you have ever wondered what an Oracle release number really means; included below is the break down and how to find out what you are running via a query against a Data Dictionary view. It has changed a little starting with Release 9.2. For the Release number: 9.2.0.1.0 , the significance of each number (reading from left to right) is shown below: Number Significance__ 9 1 Major database release number 2 1 Database maintenance release number 0 1 Application server release number 1 1Component specific release number 0 1Platform specific release number ( Starting with release 9.2, maintenance releases of Oracle are denoted by a change to the second digit of a release number. In previous releases, the third digit indicated a particular maintenance release.) Major Database Release Number This is the most general identifier. It represents a major new edition (or version) of the software that contains significant new functionality. Database Maintenance Release Number This digit represents a maintenance release level. Some new features may also be included. Application Server Release Number This digit reflects the release level of the Oracle9i Application Server (Oracle9iAS). Component Specific Release Number This digit identifies a release level specific to a component. Different components can have different numbers in this position depending upon, for example, component patch sets or interim releases. Platform Specific Release Number This digit identifies a platform specific release. Usually this is a patch set. Where different platforms require the equivalent patch set, this digit will be the same across the effected platforms. How to Check Your Current Release Number: To identify the release of the Oracle database server that is currently installed and to see the release levels of other Oracle components you are using, query the Data Dictionary view PRODUCT_COMPONENT_VERSION. Here is a sample query. (Yes, the old instructor part of me wants your Sql*Plus session to be readable, so included are 3 Sql*Plus commands before the query since each of these column widths are 65.:-) ) COL PRODUCT FORMAT A40 COL VERSIONFORMAT A15 COL STATUS FORMAT A15 SELECT * FROM PRODUCT_COMPONENT_VERSION; PRODUCTVERSION STATUS --- --- NLSRTL 9.2.0.1.0 Production Oracle9i Enterprise Edition 9.2.0.1.0 Production PL/SQL 9.2.0.1.0 Production TNS for Solaris: 9.2.0.1.0 Production Optionally, you can query against the V$VERSION view to see component-level information as well. (Other product release levels may increment independently of the database server.) Regards, Chris Gait -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 version usage
At a recent NYOUG meeting the question was asked of of around 150 or so attendees (very rough estimate) how many had 9i on a production system. Two people raised their hands. Jay Miller -Original Message- Sent: Tuesday, May 14, 2002 7:44 PM To: Multiple recipients of list ORACLE-L I am especially interested in percentage of 7.3 and 8.0 installation. Maybe it is a good idea to mail me directly and I then will post the results. Alex Hillman -Original Message- Hillman Sent: Monday, May 13, 2002 9:23 PM To: Multiple recipients of list ORACLE-L Maybe the question was not correctly formulated. Anybody has some knowledge or maybe gess about percentages of 7.3, 8.0, 8.1 and 9 in production and prognosys for a year. Maybe some studies were published? Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Alex Hillman Sent: Saturday, May 11, 2002 12:03 AM To: Multiple recipients of list ORACLE-L Subject: Oracle version usage Anybody knows what percentage of production databases are 7.3, 8.0 and 8.1 and prognosys in an year. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman 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: Alex Hillman 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: Alex Hillman 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: Miller, Jay 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 version usage
On Fri, May 17, 2002 at 02:03:25PM -0800, Miller, Jay wrote: At a recent NYOUG meeting the question was asked of of around 150 or so attendees (very rough estimate) how many had 9i on a production system. Two people raised their hands. -- similar experience at Atlantic Oracle Training Conference a few weeks ago in D.C. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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 version usage
Hey Alex, How are things hanging down in our lovely captial? BTW, are you still down there? I seem to remember reading about something like this either in the IOUG rag or on the website. Perhaps you would be willing to take a poll on the list? If Jared doesn't mind? Everyone email you directly? A few simple poll questions? CYA Chris -Original Message- Sent: Monday, May 13, 2002 9:23 PM To: Multiple recipients of list ORACLE-L Maybe the question was not correctly formulated. Anybody has some knowledge or maybe gess about percentages of 7.3, 8.0, 8.1 and 9 in production and prognosys for a year. Maybe some studies were published? Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Alex Hillman Sent: Saturday, May 11, 2002 12:03 AM To: Multiple recipients of list ORACLE-L Subject: Oracle version usage Anybody knows what percentage of production databases are 7.3, 8.0 and 8.1 and prognosys in an year. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman 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: Alex Hillman 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: Grabowy, Chris 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 version usage
Alex - There was an article about Oracle that came out recently in the media. Toward the bottom it listed a percentage of production systems that were using 9i. It was pretty small, as expected. I poked around a little, but couldn't locate the article in the time I had available. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 13, 2002 8:23 PM To: Multiple recipients of list ORACLE-L Maybe the question was not correctly formulated. Anybody has some knowledge or maybe gess about percentages of 7.3, 8.0, 8.1 and 9 in production and prognosys for a year. Maybe some studies were published? Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Alex Hillman Sent: Saturday, May 11, 2002 12:03 AM To: Multiple recipients of list ORACLE-L Subject: Oracle version usage Anybody knows what percentage of production databases are 7.3, 8.0 and 8.1 and prognosys in an year. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman 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: Alex Hillman 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: DENNIS WILLIAMS 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 version usage
I am especially interested in percentage of 7.3 and 8.0 installation. Maybe it is a good idea to mail me directly and I then will post the results. Alex Hillman -Original Message- Hillman Sent: Monday, May 13, 2002 9:23 PM To: Multiple recipients of list ORACLE-L Maybe the question was not correctly formulated. Anybody has some knowledge or maybe gess about percentages of 7.3, 8.0, 8.1 and 9 in production and prognosys for a year. Maybe some studies were published? Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Alex Hillman Sent: Saturday, May 11, 2002 12:03 AM To: Multiple recipients of list ORACLE-L Subject: Oracle version usage Anybody knows what percentage of production databases are 7.3, 8.0 and 8.1 and prognosys in an year. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman 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: Alex Hillman 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: Alex Hillman 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 version usage
Maybe the question was not correctly formulated. Anybody has some knowledge or maybe gess about percentages of 7.3, 8.0, 8.1 and 9 in production and prognosys for a year. Maybe some studies were published? Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Alex Hillman Sent: Saturday, May 11, 2002 12:03 AM To: Multiple recipients of list ORACLE-L Subject: Oracle version usage Anybody knows what percentage of production databases are 7.3, 8.0 and 8.1 and prognosys in an year. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman 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: Alex Hillman 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).
Oracle version usage
Anybody knows what percentage of production databases are 7.3, 8.0 and 8.1 and prognosys in an year. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman 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).
Oracle Version for New Database
All, I am trying to decide on a version of Oracle for a new database that will hold a number of small apps, mainly web apps using apache web server. Last time I set up a database I used 8.1.6.2.1 (this is Solaris 2.6 BTW) and I had no end of problems with incremental snapshots causing "waited too long for row cache enque lock" in the alert log file which I believe is now a known problem with simple replication in this version. Does anyone know if the problem is fixed in a more recent version? What would be a good choice for a new database to hopefully provide both a stable RDBMS as well as access to new features etc? Thanks, Ken _ Clinical and Regulatory Informatics - Groton/New London Coordinator, Business and Technical Services Tel: (860) 732-0026Fax: (860) 715-8346 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fowler, Kenneth R 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).