Further question: Oracle 32bit / 64bit
OK help me out here... We are contemplating moving up to the new Sun/Solaris "sunfire" architecture, which is a 64-bit platform. We would be moving from multiple Solaris 32-bit machines. What are my options as far as running Oracle 8.1.6.x? Upgrade? Re-install and move data? Run Oracle 32-bit on the 64-bit platform? Thanks. -- Forwarded by Dan Hubler/DS/MICORP on 07/17/2001 03:33 PM --- "Rao, Maheswara" <[EMAIL PROTECTED]>@fatcity.com on 07/17/2001 04:10:46 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Mitchell, We have both 32 bit and 64 bit Oracle 817 running on Solaris 7. The easiest way is --- When you log onto SQL, then you would get a message similar to following: Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64 bit production Now, if you are running 32 bit version, you get the following message Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production Please observe that the above message is not telling whether it is 32 or 64. But for 64 bit, the message specifically tells you. Thanks, Rao -Original Message- Sent: Tuesday, July 17, 2001 3:38 PM To: Multiple recipients of list ORACLE-L Dear DBAs How can I know my Oracle running on 32 or 64bit ? I am considering change configuration of SGA. Currently OS is updated to 8g memory on aix 4.3.3. The limit is 2gb for 32bit ? I only know if you switch from 32bit to 64bit or vice-a-versa, then you also need to run UTLIRP.SQL script which recompiles all PL/SQL modules and alters certain dictionary tables. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
Anybody heard of LECCO?
Has anyone heard about a company called LECCO Technology and their products which supposedly use "artificial intelligence" to re-write and optimize SQL statements? -- 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 vs DB2
Maybe I am wrong here but.. My understanding is that you can use standard or enterprise for any appication you wish. If your application communicates with the Web/internet, you have to license the product based on UPU's; they will not accept a named user license. ??? Dennis Taylor <[EMAIL PROTECTED]>@fatcity.com on 04/24/2001 01:22:56 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: At 09:31 AM 4/24/01 -0800, you wrote: > > >Why the enterprise license for Oracle? > Because that's what they require. Dennis Taylor Don't be fooled by old cliches - He who laughs last may have just figured out the joke. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor 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: 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 vs DB2
Why the enterprise license for Oracle? Dennis Taylor <[EMAIL PROTECTED]>@fatcity.com on 04/24/2001 10:57:11 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Disclaimer: I am *not* trying to start a religious war, and I am *not* trying to advocate DB2. I am simply offended. Thus this post. As some may remember, I'm doing an evaluation of Oracle vs DB2 vs SQLServer to determine our future direction. Here's a datum that makes a significant difference to us, dollar-wise. With Oracle, in order to make a database accessible to the internet through a web page, you have to buy an unlimited-user enterprise license. We had a senior sales person in our office yesterday, and we asked this question a number of different ways. He bobbed and he weaved, but he did not deny it. And the quote he supplied afterwards does not address the issue at all. Cost of unlimited-user Enterprise version for our installation (your mileage may vary) = Approx $160,000 Cdn. IBM, for the same purpose, will sell you DB2 UDB Workgroup edition (1 user), and something called WE Internet Access, for a total price of $6000 Cdn. I have a written quote from an IBM salescritter to this effect. $6000. $160,000. $6000. $160,000. Hm. Let me think. I respectfully submit that Oracle's pricing structure is out of line with market realities, and may have to undergo significant revision. Dennis Taylor Don't be fooled by old cliches - He who laughs last may have just figured out the joke. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor 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: 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 8.1.6 recovery featurs
Is "true" tablespace point-in-time recovery a feature of Oracle 8.1.6.x? By "true" I mean that it is NOT the concept they brought forward with 7.3.x where you recover datafiles to another instance; roll that forward and then export the data back to the original instance. Does RMAN somehow enable this idea? Thanks. -- 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: Migration from 7.3.4 to 8.1.6
After engaging Oracle WWS concerning this issue we have learned that there have been a significant number of complaints regarding performance when upgrading to 8.1.6.x. It appears that re-running your ANALYZE is not enough. Dropping statistics and then running ANALYZE might be required. -- Forwarded by Dan Hubler/DS/MICORP on 03/26/2001 11:41 AM --- Dan Hubler 03/23/2001 01:46 PM To: "Ruiz, Mary A (CAP, CDI)" <[EMAIL PROTECTED]> @ MICORPEX cc: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Optimizer mode was CHOOSE in both releases. Statistics are estimated at 10 percent. Used command-line migration tool. Thanks for replying. "Ruiz, Mary A (CAP, CDI)" <[EMAIL PROTECTED]> on 03/23/2001 12:37:15 PM To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> cc: Dan: Thanks for your answer. What is your optimizer method in the 8.1.6 db vs. what it was in 7.3.4 ? (I think Oracle 8 defaults to Choose) Do you have statistics computed or estimated on the table ? What method did you use to migrate ? export / import, migration assistant , or command-line migration tool ? I would also look at indexes on the table, Maybe the query is using an index when it should not or vice-versa. Thanks in advance, Mary -Original Message- Sent: Friday, March 23, 2001 11:11 AM To: Multiple recipients of list ORACLE-L The thing that is killing us is a single query. This query does a group by. It also references some user-defined functions in the column-list of the SELECT statement. These user-defined functions are actually SELECTS from 2 other small tables. It is not behaving the same way it did in version 7.3.4. The table that the query runs against is pretty big (700,000 rows across 4 gig). The 2 tables referenced by the user-defined functions are very small (10-20 rows). "Ruiz, Mary A (CAP, CDI)" <[EMAIL PROTECTED]> on 03/22/2001 04:18:30 PM To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> cc: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Dan: What kinds of problems ? I am beginning a migration of a hybrid OLTP / OLAP database from 7.3.4 to 8.1.5 on Solaris 2.6 We are planning to take 6 weeks to "clean up" the database and fix the chained /migrated rows before we migrate (mainly on the big tables). We will spend a month testing on a migrated copy before migrating production. Our apps are custom Powerbuilder apps. I decided to go to 8.1.5 because our other databases are 8.1.5, and just live with the fact I cannot import a table from a multiple-table export. (that bugs me to no end) I am most interested in responses to this post. Maybe some truly compelling reasons to go to 8.1.6 , although I heard about hanging listener problems with that version which scared me. thanks in advance, Mary Ruiz / Atlanta -Original Message- Sent: Thursday, March 22, 2001 3:46 PM To: Multiple recipients of list ORACLE-L We just migrated the first of our environments from 7.3.4 to 8.1.6 ( Solaris 2.6 ). We have run into a couple of problems that only seem to appear when processing large tables or large amounts of data. This is kind of what we expected because we did not have the resources to do full-blown, production size testing. Anybody have any information on things that go wrong with this type of migration? -- 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). -- 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). -- 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,
Re: User define functions (queries) in SELECT statements
Thanks for replying. I need to start this by correcting the subject line I put on this originally. I am talking about user-defined FUNCTIONS within a SELECT. Sorry. The explain plans look exactly the same. Strangely enough, the small tables that are read in the user-defined functions do NOT appear in the explain plan (!?!?!?!?!!?). Yes.we did re-analyze after the software upgrade. Thanks again. "Charlie Mengler" <[EMAIL PROTECTED]> on 03/23/2001 11:55:17 AM To: [EMAIL PROTECTED] cc: What do the before (V7) and after (V8) explain plans look like? Have you (re)analyzed all tables & indexes used by the query? [EMAIL PROTECTED] wrote: > > We have run into a big performance issue with our migration from 7.3.4 to > 8.1.6. > > A single query that SELECTs from a large table, also contains user-defined > functions that > appear in the column-list of the SELECT. > > This query is running many times longer than under the old version. > > Anybody see this before? > > (Solaris 2.6) > > -- > 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). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct 858-831-2229 San Diego, CA 92131 The future is here. It is just not evenly distributed. -- 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: Migration from 7.3.4 to 8.1.6
The thing that is killing us is a single query. This query does a group by. It also references some user-defined functions in the column-list of the SELECT statement. These user-defined functions are actually SELECTS from 2 other small tables. It is not behaving the same way it did in version 7.3.4. The table that the query runs against is pretty big (700,000 rows across 4 gig). The 2 tables referenced by the user-defined functions are very small (10-20 rows). "Ruiz, Mary A (CAP, CDI)" <[EMAIL PROTECTED]> on 03/22/2001 04:18:30 PM To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> cc: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Dan: What kinds of problems ? I am beginning a migration of a hybrid OLTP / OLAP database from 7.3.4 to 8.1.5 on Solaris 2.6 We are planning to take 6 weeks to "clean up" the database and fix the chained /migrated rows before we migrate (mainly on the big tables). We will spend a month testing on a migrated copy before migrating production. Our apps are custom Powerbuilder apps. I decided to go to 8.1.5 because our other databases are 8.1.5, and just live with the fact I cannot import a table from a multiple-table export. (that bugs me to no end) I am most interested in responses to this post. Maybe some truly compelling reasons to go to 8.1.6 , although I heard about hanging listener problems with that version which scared me. thanks in advance, Mary Ruiz / Atlanta -Original Message- Sent: Thursday, March 22, 2001 3:46 PM To: Multiple recipients of list ORACLE-L We just migrated the first of our environments from 7.3.4 to 8.1.6 ( Solaris 2.6 ). We have run into a couple of problems that only seem to appear when processing large tables or large amounts of data. This is kind of what we expected because we did not have the resources to do full-blown, production size testing. Anybody have any information on things that go wrong with this type of migration? -- 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). -- 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).
User define queries in SELECT statements
We have run into a big performance issue with our migration from 7.3.4 to 8.1.6. A single query that SELECTs from a large table, also contains user-defined functions that appear in the column-list of the SELECT. This query is running many times longer than under the old version. Anybody see this before? (Solaris 2.6) -- 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).
Migration from 7.3.4 to 8.1.6
We just migrated the first of our environments from 7.3.4 to 8.1.6 ( Solaris 2.6 ). We have run into a couple of problems that only seem to appear when processing large tables or large amounts of data. This is kind of what we expected because we did not have the resources to do full-blown, production size testing. Anybody have any information on things that go wrong with this type of migration? -- 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).
Connection manager
Looking for some help with Connection Manager. Suddenly got hit with a NAT issue from a customer site. Any suggestions on the use of Connection manager to alleviate this situation would be appreciated. Also: a) Does Connection manager require the use of MTS? b) Is Connection manager available with both Standard edition and Enterprise edition? -- 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).
One more time: redo logging and Oracle 8.1.6
Just rolled out version 8.1.6 to our first "serious" application. It appears that more redo is being generated with the newer software. Does that sound accurate? Or is my application owner not telling me the truth regarding his activities? Upgrade was from v7.3.4.4 to v8.1.6.x on Solaris 2.6. -- 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).
Redo logging with version 8.1.6.x
Just rolled out version 8.1.6 to our first "serious" application. It appears that more redo is being generated with the newer software. Does that sound accurate? Or is my application owner not telling me the truth regarding his activities? -- 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).
Slightly off topic: Peoplesoft apps. versus Oracle apps.
I have to participate in a conference call next week to discuss PeopleSoft financials versus Oracle financials. The conference call will include an "expert" from the Meta-Group. I would appreciate any insight into the differences between these two applications. Thanks. -- 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).
