Server Recommendations
I have a question, I have to make a decision on the purchase of a new web server for a multiteir Oracle based system. So here are my two remaining options, all other things remaining equal, on a system which has 100% dynamically generated web pages. 1. A server with one 2ghz CPU. or 2. A server with two 1ghz CPU. Which will provide more power? A little more food for though. Would a server with a 1ghz CPU and 512mb RAM be adequate for a Oracle backed web site, which the pages are all 100% dynamic? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tom Schruefer 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: Apple rack-mounted servers
Interesting. Has anyone purchased and/or installed one of these X Servers? Being essentially UNIX, I'd prefer one of these over a MacOS server or WinXX. Background, we are looking to replace about 10 MacOS servers in our High Schools right now. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Boivin, > Patrice J > Sent: Tuesday, August 13, 2002 1:45 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Apple rack-mounted servers > > > No longer OT! Oracle says 9I will run on Apple's new servers? > > http://www.apple.com/xserve/reaction.html > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, August 13, 2002 12:45 PM > To: '[EMAIL PROTECTED]' > Subject: OT: Apple rack-mounted servers > > My brother just sent me this link... > > http://www.apple.com/xserve/ > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Boivin, Patrice J > 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: Tom Schruefer 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).
ORA-27101 Error
ORA-27101 = Shared Memory Realm is not available I have seen references to this error and how to repair it on UNIX systems, but what is to be done on Win2000 when this thing rears its ugly head? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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 Logs Question
Here is the background of the stiuation I am facing. We are piloting a application that uses a hybred store and forward system to aggregate all of our disparate student data into one central database. Currently there are 20 schools integrated into the system with another 48 to go, those 20 schools hold about half of our 46k student population. The system allows (requires) student demographics to be entered through a web client, while grades, attendance, health, conduct, etc. are uploaded over night. The system comes with the redo log file size set to 5k, which when the users in the 20 pilot schools get going causes a log switch about every 90 seconds. In my limited, steep learning curve expereince, this does not seem like a good thing. Add to that, they cancelled the Oracle Tuning class, which I have to wait until the system is in to take now. So my questions (that the books don't really seem to want to answer): How frequently should redo log file switches occur? How large should my redo logs be? I am guessing the answer to both of these questions is, It Depends. So my question really is, how do I determine what the correct settings for my installation are? Tom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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: Redo Logs Question
Thanks for the input, the server is a Dell PowerEdge 6500. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, December 31, 2001 11:05 AM > Tom: > >File sizes of 5k are not good. If you have the room on your server, I > would increase that significantly. Perhaps to 50-60m. Log switching every > 90 sec. is not good. > >There are many INIT.ORA parameters that control the performance of redo > logs. LOG_BUFFERS or LOG_BUFFER_SIZE is one of them. This defaults, I > believe, to 32k. Increase this to over 512k. There are many more. Look at > your INIT.ORA settings. > >Also, if you can identify the type of hardware you are running as a > database server, we can give you some additional choices. > > Thank You > > Stephen P. Karniotis > Technical Alliance Manager > Compuware Corporation > Direct: (248) 865-4350 > Mobile: (248) 408-2918 > Email: [EMAIL PROTECTED] > Web: www.compuware.com > > > -Original Message- > Sent: Monday, December 31, 2001 10:20 AM > To: Multiple recipients of list ORACLE-L > Subject: Redo Logs Question > > Here is the background of the stiuation I am facing. > > We are piloting a application that uses a hybred store and forward system to > aggregate all of our disparate student data into one central database. > Currently there are 20 schools integrated into the system with another 48 to > go, those 20 schools hold about half of our 46k student population. > > The system allows (requires) student demographics to be entered through a > web client, while grades, attendance, health, conduct, etc. are uploaded > over night. > > The system comes with the redo log file size set to 5k, which when the users > in the 20 pilot schools get going causes a log switch about every 90 > seconds. In my limited, steep learning curve expereince, this does not seem > like a good thing. Add to that, they cancelled the Oracle Tuning class, > which I have to wait until the system is in to take now. > > So my questions (that the books don't really seem to want to answer): > > How frequently should redo log file switches occur? > > How large should my redo logs be? > > > I am guessing the answer to both of these questions is, It Depends. So my > question really is, how do I determine what the correct settings for my > installation are? > > > Tom > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tom Schruefer > 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: Karniotis, Stephen > 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: Tom Schruefer 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).
Statspack Problem
I am running 8.1.6 on a Win2000 SP2 machine. When I try running 'statscre.sql' as SYS, the first script completes fine, but when the second script tries to connect perfstat/perfstat , I get the error, "You are no longer connected to Oracle TNS:ORA-12154". Of course the system then proceeds to attempt to run the other two scripts returning about a hundred "not connected" error messages. The Perfstat user was created and I did not have the chance to intervene and change its password. Any ideas as to why the script would fail to connect? I connected as internal in the first place to run the script, so I don't think its TNS. _________ Tom Schruefer - [EMAIL PROTECTED] 410-313-6825 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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: Statspack Problem
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Reardon, > Bruce (CALBBAY) > Sent: Monday, May 20, 2002 10:08 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Statspack Problem > > > Have you connected via BEQ or Net8 initially? > Have you got oracle_sid set as an environment variable, as it > looks like the connect perfstat/perfstat uses a BEQ connection. > It does not look as though the SID_NAME parameter was set on the system I was trying to install too. Although it was set on my test system, maybe thats why it worked in test but not production. Anyway, I am off to try again. Thanks for the idea. > After connecting as sys, can you now do a "connect > perfstat/perfstat" (though maybe the scripts cleaned up on error > and deleted the perfstat user. > Yes, I can login as 'perfstat', and any other user as well, it looks like the script was able to create the user. > HTH, > Bruce Reardon > > -Original Message- > Sent: Tuesday, 21 May 2002 11:39 > > I am running 8.1.6 on a Win2000 SP2 machine. > > When I try running 'statscre.sql' as SYS, the first script completes fine, > but when the second script tries to connect perfstat/perfstat , I get the > error, "You are no longer connected to Oracle TNS:ORA-12154". Of > course the > system then proceeds to attempt to run the other two scripts > returning about > a hundred "not connected" error messages. > > The Perfstat user was created and I did not have the chance to > intervene and > change its password. Any ideas as to why the script would fail > to connect? > > I connected as internal in the first place to run the script, so I don't > think its TNS. > Tom Schruefer - [EMAIL PROTECTED] > 410-313-6825 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Reardon, Bruce (CALBBAY) > 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: Tom Schruefer 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).
ID This Wait stat
You know I could have all the documentation for Oracle printed on my brain, buy all the books ever written about the subject, but the primary wait problem that comes up will never be directly addressed. So, what exactly does 'Slave Wait' mean and what can I do about it? I am using DBWR Slaves, since it did not seem as though starting additional DBWR's was appropriate on a Win2000 system. Here are the Top 5 wait events as per Statpack and my shinny new 'Oracle Performance Tuning 101' book: Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time - -- slave wait 66,5936,793,939 88.85 PX Deq: Execution Msg 28,960 407,167 5.33 PX Deq: Table Q Normal 19,864 302,480 3.96 PX Deq Credit: send blkd3,685 123,671 1.62 PX Deq: Signal ACK 3,2145,294 .07 I have a pretty good idea that 2-5 are for parallel query option, although I still have to figure out just what they mean. Any help would be greatly appreciated. _________ Tom Schruefer - [EMAIL PROTECTED] 410-313-6825 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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: Statspack Problem
I ran 'statscre' again and got the same message again. It seemed to prevent SQL*Plus from logging into any account. So, I quit, re-started SQL*Plus and logged in as Perfstat and ran the remaining two scripts, which then completed without incident. I have been able to take a couple snapshots with statspack over the last 3 hours and now I have another question. But new question, new email. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom > Schruefer > Sent: Tuesday, May 21, 2002 11:53 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Statspack Problem > > > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Reardon, > > Bruce (CALBBAY) > > Sent: Monday, May 20, 2002 10:08 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Statspack Problem > > > > > > Have you connected via BEQ or Net8 initially? > > Have you got oracle_sid set as an environment variable, as it > > looks like the connect perfstat/perfstat uses a BEQ connection. > > > > It does not look as though the SID_NAME parameter was set on the system I > was trying to install too. Although it was set on my test system, maybe > thats why it worked in test but not production. > > Anyway, I am off to try again. Thanks for the idea. > > > After connecting as sys, can you now do a "connect > > perfstat/perfstat" (though maybe the scripts cleaned up on error > > and deleted the perfstat user. > > > > Yes, I can login as 'perfstat', and any other user as well, it looks like > the script was able to create the user. > > > > HTH, > > Bruce Reardon > > > > -Original Message- > > Sent: Tuesday, 21 May 2002 11:39 > > > > I am running 8.1.6 on a Win2000 SP2 machine. > > > > When I try running 'statscre.sql' as SYS, the first script > completes fine, > > but when the second script tries to connect perfstat/perfstat , > I get the > > error, "You are no longer connected to Oracle TNS:ORA-12154". Of > > course the > > system then proceeds to attempt to run the other two scripts > > returning about > > a hundred "not connected" error messages. > > > > The Perfstat user was created and I did not have the chance to > > intervene and > > change its password. Any ideas as to why the script would fail > > to connect? > > > > I connected as internal in the first place to run the script, so I don't > > think its TNS. > > Tom Schruefer - [EMAIL PROTECTED] > > 410-313-6825 > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Reardon, Bruce (CALBBAY) > > 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: Tom Schruefer > 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: Tom Schruefer 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: ID This Wait stat
Arrggghhh. Well that was a easy problem to fix, just define 'wait' differently. Now on to the next item on my list. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rachel > Carmichael > Sent: Tuesday, May 21, 2002 5:16 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: ID This Wait stat > > > according to the docs and a friend in COE, slave wait is an "idle > event" -- it means that the dbwr slave is waiting for something to do > > in other words, it ain't busy... not a "real" wait > > > --- Tom Schruefer <[EMAIL PROTECTED]> wrote: > > > > You know I could have all the documentation for Oracle printed on my > > brain, > > buy all the books ever written about the subject, but the primary > > wait > > problem that comes up will never be directly addressed. > > > > So, what exactly does 'Slave Wait' mean and what can I do about it? > > > > > > I am using DBWR Slaves, since it did not seem as though starting > > additional > > DBWR's was appropriate on a Win2000 system. > > > > Here are the Top 5 wait events as per Statpack and my shinny new > > 'Oracle > > Performance Tuning 101' book: > > > > Top 5 Wait Events > > ~ Wait > > % > > Total > > Event Waits Time (cs) > > Wt > > Time > > > > - > > -- > > slave wait 66,593 > > 6,793,939 > > 88.85 > > PX Deq: Execution Msg 28,960 > > 407,167 > > 5.33 > > PX Deq: Table Q Normal 19,864 > > 302,480 > > 3.96 > > PX Deq Credit: send blkd3,685 > > 123,671 > > 1.62 > > PX Deq: Signal ACK 3,214 > > 5,294 > > .07 > > > > > > I have a pretty good idea that 2-5 are for parallel query option, > > although I > > still have to figure out just what they mean. > > > > > > Any help would be greatly appreciated. > > > > _ > > Tom Schruefer - [EMAIL PROTECTED] > > 410-313-6825 > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Tom Schruefer > > 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). > > > __ > Do You Yahoo!? > LAUNCH - Your Yahoo! Music Experience > http://launch.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > 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: Tom Schruefer 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: ID This Wait stat
Now that's a truly useful site, someone could make that into one of those Pocket DBA books. ;-> Thanks Lots... > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > [EMAIL PROTECTED] > Sent: Tuesday, May 21, 2002 7:20 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: ID This Wait stat > > > You can ignore them. > > See: http://www.ixora.com.au/q+a/waits.htm > > > > > > "Tom Schruefer" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 05/21/2002 01:32 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:ID This Wait stat > > > > You know I could have all the documentation for Oracle printed on my > brain, > buy all the books ever written about the subject, but the primary wait > problem that comes up will never be directly addressed. > > So, what exactly does 'Slave Wait' mean and what can I do about it? > > > I am using DBWR Slaves, since it did not seem as though starting > additional > DBWR's was appropriate on a Win2000 system. > > Here are the Top 5 wait events as per Statpack and my shinny new 'Oracle > Performance Tuning 101' book: > > Top 5 Wait Events > ~ Wait % > Total > Event Waits Time (cs) Wt > Time > > - > -- > slave wait 66,5936,793,939 > 88.85 > PX Deq: Execution Msg 28,960 407,167 > 5.33 > PX Deq: Table Q Normal 19,864 302,480 > 3.96 > PX Deq Credit: send blkd3,685 123,671 > 1.62 > PX Deq: Signal ACK 3,2145,294 > .07 > > > I have a pretty good idea that 2-5 are for parallel query option, > although > I > still have to figure out just what they mean. > > > Any help would be greatly appreciated. > > _ > Tom Schruefer - [EMAIL PROTECTED] > 410-313-6825 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tom Schruefer > 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: Tom Schruefer 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).
Question about OFA and RAID 5
Any suggestions on the message below would be greatly appreciated. Thanks in advance. I have been appointed our new Oracle DBA and have since been taking classes and reading books. I quite enjoyed the recent thread on OFA. I seem to have a bit of a quandary, here it is. We have 68 schools with 46,000 students, each with their own student database, we have purchased a product that will allow us to aggregate all of these databases into one central database. This project is but one step toward a centralized student data system, which we currently do not have the infrastructure for. Here is the suggested configuration for the database server for this product. 2 9GB HD in a RAID 1 - Suggested for the OS and LOGS 6 18GB HD in RAID 5 - Database 1 18GB HD Hot Spare I realize that something of this nature would allow for a lot of disk through-put (I would think), but it doesn't really allow for a OFA configuration. I should clarify at this time that there were two choices for the DB either Oracle or SQL Server, we chose Oracle. I have a suspicion that this configuration is either intended to maximize database access, at the expense of recoverability or its the SQL Server version of OFA, or both. If it is both is there a way to provide for OFA and also maximize disk access? BTW, I actually purchased a system with much more disk space than the above, 14 18gb HD and 2 9gb HD. -- Howard County Public School System, Maryland, USA [EMAIL PROTECTED] The views expressed in this message do not represent the views of the Howard County Public School System, blaa, blaa, blaa. You get the idea. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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: O9i Licensing
IL 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). > >_ >Get your FREE download of MSN Explorer at http://explorer.msn.com > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Rachel Carmichael > 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). > -- Howard County Public School System, Maryland, USA [EMAIL PROTECTED] The views expressed in this message do not represent the views of the Howard County Public School System, blaa, blaa, blaa. You get the idea. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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: how to check BG process in WIN2000
I would be interested in that as well, I was able to do that in OS2, Win2000 should have caught up by now. You can verify that the background processes have started though. Go to the "Event Viewer" from the "Admin Tools" menu/folder (found in Programs and/or Control Panels) and select "Application Log". BTW, as I found out after messing with Win2000, these logs can fill up and prevent required services from launching. >Jon Walthour - [EMAIL PROTECTED] on 7/12/2001 3:08 PM writes us: > >Seema: > >As far as I know, all the Oracle background processes on Windows >NT/2000 run under the oracle executable. So, in Task Manager, >for example, all you can see is the resource usage of oracle.exe, >not of the individual processes. The only way I know to monitor >the individual Oracle processes on NT/2000 is from within the >database. > >Hope this helps. > >-- > >Jon Walthour, OCDBA >Oracle DBA >Computer Horizons >Cincinnati, Ohio > >>--- Original Message --- >>From: "Seema Singh" <[EMAIL PROTECTED]> >>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >>Date: 7/12/01 2:40:58 PM >> > >>Hi >>How to check Oracle background processes in WIN2000. >>Like ps -ef |grep smon in unix >>Thanks >>-Seema >>_ >>Get your FREE download of MSN Explorer at http://explorer.msn.com >> >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: Seema Singh >> 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: Jon Walthour > 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). > ---------- Howard County Public School System, Maryland, USA [EMAIL PROTECTED] The views expressed in this message do not represent the views of the Howard County Public School System, blaa, blaa, blaa. You get the idea. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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: P4 MAchine - Oracle setup CAUTION
Where do the replacement files come from, how can one tell you have the correct version? I have had this problem, it is a bug with the Pentium 4 chip. My work around, is fine for installing Oracle client's, but the full DB is a bit more difficult. - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 13, 2002 9:18 AM Subject: P4 MAchine - Oracle setup CAUTION I want to share with you a solution . The problem is : On Pentium 4 machines , windows gives java.exe error everysecond. The solution is : replace the jvm.dll and symcjit.dll in the jre directory of 9i db CD to where you find them on your oracle home and program files. Then the life is better.. Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA.
Two RAID Adapters????
I know I'm asking this question at 5pm on a Friday afternoon, but lets see who doesn't have anything to do this weekend. I have a PowerEdge 6500 with two PERC3/DC adapters, how do I get them to work together? I have read the docs and visited the Dell support site, but the information they contain is rather unclear. Thanks in advance for any help or suggestions you can give. -- Howard County Public School System, Maryland, USA [EMAIL PROTECTED] Voice # 410-313-6825 The views expressed in this message do not represent the views of the Howard County Public School System, blaa, blaa, blaa. You get the idea. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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 license prices
>Helmut Daiminger - [EMAIL PROTECTED] on 4/9/2001 4:36 PM writes us: >Hi! > >Sorry to ask this question again, but I can't find the old thread that >already discussed that topic several weeks ago. > >What is the Oracle license price per Power Unit? For Enterprise Edition and >Standard Edition? >Does th eoperating system matter? No. > >A power unit is MHz * 1.0 for Intel processors and MHz * 1.5 for RISC >processors, right? > Actually its Number of Computers * Number of Processors * MHZ * 1.0 Intel Number of Computers * Number of Processors * MHZ * 1.5 RISC Number of Computers * MIPS * 24 Mainframe Systems There is a calculator available, the URL is way to long to email. Go to the <http://oraclestore.oracle.com> and at the bottom of the Oracle 8i paragraphs there is a link named Click on that. Search on "Universal Power Unit Calculation ", there you will find a link to the power unit calculator. >This is 8.1.6 on Win2k. > >Thanks, >Helmut > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Helmut Daiminger > 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). > -- Howard County Public School System, Maryland, USA [EMAIL PROTECTED] The views expressed in this message do not represent the views of the Howard County Public School System, blaa, blaa, blaa. You get the idea. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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).
Q: v8.1.7: What is the Paging Server ?
Playing around with Win2000 and the Services Control Panel I noticed that the Oracle installer installed a service named "Paging Server". Now the name kinda makes it obvious what it does, or maybe not, but there does not seem to be any documentation about how to use it. I have checked the: Oracle Docs CD Knowledge Base Message Boards All to no avail. I am a pre-newbe DBA, so any help you guys can give is greatly appreciated. -- Howard County Public School System, Maryland, USA [EMAIL PROTECTED] The views expressed in this message do not represent the views of the Howard County Public School System, blaa, blaa, blaa. You get the idea. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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's pricing
I don't think your far from the mark. SQL Server is cheaper and on paper functionally equivalent to Oracle. But, for implementations of over 25 users you must buy a processor license for SQL Server, a license for which there is no upgrade path. So when MS pushes out "SQL Server 2000" (already on the market) and then "SQL Server 200x", and "SQL Server yo-yo", while dropping support for Server 2000. You must upgrade at $20k a processor, so after 5 years MS has as much of your money as Oracle, they were just sneaker about it. For small work group use, SQL Server beats Oracle price wise, but if you need lots of users online, the pricing equals out. >From looking over MS pricing model, it seems to me that SQL Server is really priced toward organizations that have out grown Access. But MS markets it as an equivalent product to Oracle. Maybe just more MS FUD? >Kimberly Smith - [EMAIL PROTECTED] on 4/25/2001 5:33 PM writes us: >I find a lot of the discussions about Oracle's pricing be too much when not >taking into account anything else way to funny. >First off, yes I could get SQL Server for a whole lot less then Oracle but I >sure would not be able to run the fab on it. >You simply can't compare one thing to another thing and say they do the same >thing. Now I would do a small application >that is not critical in SQL Server if there was no Oracle in house already. >As for DB2, it has a few issues where if you >try and do certain things you really do end up very close to an Oracle >price. > > >Kimberly Smith >Database Administrator >EDS - Fujitsu/GMD >Phone: (503) 669-6050 >Fax: (503) 669-5705 >Email : [EMAIL PROTECTED] > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Kimberly Smith > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Howard County Public School System, Maryland, USA [EMAIL PROTECTED] The views expressed in this message do not represent the views of the Howard County Public School System, blaa, blaa, blaa. You get the idea. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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).
Q: Oracle Year End???
I have heard, but have not been able to confirm that May is Oracle's fiscal year-end. Does anyone have any information regarding this? I have also heard that May, being Oracles' year-end is the best month to buy. Has anyone had experience with this? -- Howard County Public School System, Maryland, USA [EMAIL PROTECTED] The views expressed in this message do not represent the views of the Howard County Public School System, blaa, blaa, blaa. You get the idea. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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).
Compare Standard Edition to Enterprise Edition
Could some kind soul direct me toward the web page that contains the comparison between the two different versions of the Oracle DB ? - I used to know where it was, but the link is gone. - I promise to answer this question if it is asked again. -- Howard County Public School System, Maryland, USA [EMAIL PROTECTED] The views expressed in this message do not represent the views of the Howard County Public School System, blaa, blaa, blaa. You get the idea. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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: Compare Standard Edition to Enterprise Edition
Thanks very much, I found a much more limited list on another part of the Oracle web sites, but this was the one I needed. Anyway, all you have to do is drop the 'l' at the end of 'html' and you are there. http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server .817/a76962/ch4.htm >Kevin Kostyszyn - [EMAIL PROTECTED] on 5/9/2001 5:30 PM writes us: >I believe it is.. >technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76 >962/ch4.html > >-Original Message- >Schruefer >Sent: Wednesday, May 09, 2001 5:11 PM >To: Multiple recipients of list ORACLE-L > > > > >Could some kind soul direct me toward the web page that contains the >comparison between the two different versions of the Oracle DB ? > >- I used to know where it was, but the link is gone. >- I promise to answer this question if it is asked again. > > > >-- >Howard County Public School System, Maryland, USA >[EMAIL PROTECTED] > >The views expressed in this message do not represent the views of the >Howard County Public School System, blaa, blaa, blaa. You get the idea. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Tom Schruefer > 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: Kevin Kostyszyn > 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). > -- Howard County Public School System, Maryland, USA [EMAIL PROTECTED] The views expressed in this message do not represent the views of the Howard County Public School System, blaa, blaa, blaa. You get the idea. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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: Data Reporting tools
We are currently looks at a product named Crystal Reports from the company below, they seem to have a number of products along the lines of your query. http://www.crystaldecisions.com/ >[EMAIL PROTECTED] - [EMAIL PROTECTED] on 5/10/2001 2:11 PM writes us: >To ALL, > >I've been given a project to find a way to make data easily available >to end >users, preferably via a thin client (read that as browser based). We're >looking >at Discoverer 3000 and 9iAS, but the boss wants to know what other options >are >out there. The general idea would be to have a client/server based tool >that we >could deploy to the power users (of which we have only a few). These >individuals are NOT programmers nor in the IS group, but they know the >data. We >want them to create the queries/reports (with graphics included which the >Discoverer viewer does not do) and then publish them via the database. >This is >a lot of what Discoverer does, but are there other tools out there that do >the >same? Any recommendations??? > >Dick Goulet >Senior Oracle DBA >Vicor Corporation >-- >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). > -- Howard County Public School System, Maryland, USA [EMAIL PROTECTED] The views expressed in this message do not represent the views of the Howard County Public School System, blaa, blaa, blaa. You get the idea. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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: OT: this is the last thing we need
You know what, you should have followed your own advice. Instead of telling all of us why this should not be discussed on ORACLE-L, then proceeding to do just that. Thanks for paying so much attention. >[EMAIL PROTECTED] - [EMAIL PROTECTED] on 2/16/2001 1:01 PM writes us: >OHHH, bad subject matter for mail lists. Politics & Religion should remain >prohibited subjects, just because the "FLAME:ON, HIGH" gets set so often. >BUT, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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: Anyone using CA products?
Oooppp I ordered one of those posters 2 weeks ago and it came today. Very nice. We have CA-Datacom, Datareporter, Vollie, FAQS, etc. and several other of their products, needless to say our Systems Programmer has become extremely adept at getting out of them what we need. He loves to argue and pesters the living shit out of them until they give in. Of course he (Systems Programmer) maintains that for Mainframe software CA support is just fine, but when you get to PC stuff it falls off quite a bit. CA probably puts all their support dollars into the Mainframe side. Tom >Witold Iwaniec - [EMAIL PROTECTED] on 2/26/2001 12:56 PM writes us: > >A simple little thing - I asked for the Oracle 8i Data Dictionary >poster. The QA Specialist said that she would be happy to send it >to me and of course it hasnt arrived yet - about a year... > >I can really live without the poster but it tells me something about >the company. If they said they didn't supply it or run out of it or >whatever else excuse that they can not send it, I would have had >more respect for them. What's the point of making yourself looking >very bad with such a little thing. It looks like the support is not >much different... > >Witold >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Witold Iwaniec > 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: Tom Schruefer 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: Anyone using CA products?
Oooppp I ordered one of those posters 2 weeks ago and it came today. Very nice. We have CA-Datacom, Datareporter, Vollie, FAQS, etc. and several other of their products, needless to say our Systems Programmer has become extremely adept at getting out of them what we need. He loves to argue and pesters the living out of them until they give in. Of course he (Systems Programmer) maintains that for Mainframe software CA support is just fine, but when you get to PC stuff it falls off quite a bit. CA probably puts all their support dollars into the Mainframe side. Tom >Witold Iwaniec - [EMAIL PROTECTED] on 2/26/2001 12:56 PM writes us: > >A simple little thing - I asked for the Oracle 8i Data Dictionary >poster. The QA Specialist said that she would be happy to send it >to me and of course it hasnt arrived yet - about a year... > >I can really live without the poster but it tells me something about >the company. If they said they didn't supply it or run out of it or >whatever else excuse that they can not send it, I would have had >more respect for them. What's the point of making yourself looking >very bad with such a little thing. It looks like the support is not >much different... > >Witold >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Witold Iwaniec > 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: Tom Schruefer 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 Licensing
As luck would have it I was evaluating the prices of Oracle and then SQL Server today. My question at this point is, what kind of prices does Microsoft charge for support, I was pretending to purchase SQL Server and noticed that no mention is made about product support. Using the "Power Unit" method MS and Oracle come out within about $5k of each other, but when you get to their Enterprise editions, MS is just under $20k where as Oracle is way out there. The cheaoest I could get Oracle, with unlimited users (which is what I need). On a 1ghz Intel, single processor machine with a 2 yr lic, Oracle Enterprise costs $45,600 (thats if you want support with your DB). If it were my money $20k vs. $45k+, hummm. I'm no Friend-of-Bill, but one has to wonder how Oracle can compete with such a huge price difference. Is MS doing to Oracle what it did to Netscape and dozens of other companies? Tom >Martin Kendall - [EMAIL PROTECTED] on 3/5/2001 4:45 PM writes us: >I'm following this thread and a worrying thought has crossed my mind:- > >If Oracle carries on with this pricing model, soon we will all be looking >for a new job..scary :-) > >Martin Kendall > >-Original Message- >Sent: 02 March 2001 22:00 >To: Multiple recipients of list ORACLE-L > > >Last time I danced with our sales rep, power units were per server, not per >user... so the power unit price would be 400*100 = 40,000 for an unlimited >(Ha! >at 200mhz?) number of users. If you ask nicely, yours may agree to convert >any >concurrent or named user licenses you have into power unit credits. > >Dennis Taylor wrote: > >> At 06:25 AM 3/2/01 -0800, you wrote: >> >the mire. At any rate, there are suppose to be two basic licensing >> schemes, and >> >GOD only knows how many "allowed" permutations: >> > >> >1) Power Units which equates to the number of processors times the >> speed of >> >the processors in Megahertz. Oh, BTW: it matters if their Intel or Risc >> >processors too. Risc processors are more expensive. In general this is >the >> >MOST expensive way to go. >> > >> >> I went to the oracle site and did some calcs for adding users to Oracle >> Enterprise. Kept sayin g to myself, "Naw, they must mean *hundreds* of >> megahertz". Anyway, for a very behind-the-curve system (2x200mhz >> ppro's), it works out to $4000 per additional user. >> >> Or I can look at Interbase/Firebird, which is free. >> >> Today I will be assigning one of my staff the task of downloading, >> installing, and evaluating Firebird. >> >> The only way I can imagine that Oracle thinking can be going is: "Hey, >> revenues are dropping because of competition from free and less expensive >> dbms's". "No problem. Raise prices to make up the shortfall". Then I say >to >> myself, "Naw, no-one can be that stupid". Then I check the per-user prices >> again >> >> Dennis Taylor >> >> Good we must love, and must hate ill, >> For ill is ill, and good good still. >> >> -- >> 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: Martin Kendall > 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: Tom Schruefer INET:
RE: Oracle Licensing
Looking for a job in Oracle sales? This is a pretty convincing argument. Thanks for the additional info. >Jeffery Stevenson - [EMAIL PROTECTED] on 3/6/2001 10:10 AM writes us: >Well, if you don't want product updates/upgrades for Oracle then you can >knock about $15K off of that $45K for Oracle (and with SQL Server it looks >like you can only upgrade the user licenses and not the processor >licensing--looks like to upgrade you'd have to buy the new version anyways). >Now for SQL Server support, there is a good pricing "menu" here for MS >support for SQL Server: > This seems to be the kicker. Its nice to be able to plan ahead to avoid future pitfalls, unfortunately most purchasing decisions don't seem to be made that way. A lot of times purchasing decisions are made based on the budget available today and not how much it will cost the company 2 years from now. M$ is famous for forcing users of its products, particularly business users to upgrade-or-else, if they want continued support. If Oracle could somehow account for this, like once a company purchases its database, they are likely to stay and upgrade. Its the reason so much desktop software is cheap, the companies actually make most of their money on upgrades. [snip some very convincing arguments] > >Now look at this scenario: > >I have a box with four 500 Mhz CPUs. > >Oracle with support and updates (the 2 year licensing scenario): $85,500 >Microsoft without support and without updates: $79,996 > Price wise (only), you would only pay half that if you got a box with 2 1000mhz CPU's. Thats a 2 CPU license at $39,998. If thats correct, it a hole MS is sure to plug. >After all, the MS processor licensing is $1 per CPU. Now let's throw in >a hypothetical that one year after buying your MS SQL Server, a new version >comes out that just blows the previous version away--it fixes all the >problems that your specific site has been having, it's faster, it's more >scalable, it's more reliable and it will even start brewing coffee for you >when it logs a database problem late at night. Now to upgrade to this new >version (unless MS provides an upgrade option for the processor licensing in >the future), it would cost you another $79,996 (and the same scenario with >Oracle would only cost you the price to have them ship you the media...if >you want it on disk that is). Anyways, just some things to think about with >all of this. :) > >***Now, we all seem to agree that the current licensing scenario for Oracle >is a bit prohibitive...maybe we should collaborate and think of a pricing >scenario that is fair, yet still competitive for them, and maybe if we get >enough people to suggest it to them (and mention that they'd probably get a >higher volume of sales with these pricing options)... Perhaps dropping their price and charging a bit more for upgrades, which for Oracle seem to come out frequently enough. First upgrade is free, etc., etc.. Oracle may also consider developing a much more user friendly (consumer) version of is Oracle Personal DB. Tom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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).