Re: linux Oracle -- best combination

2001-08-27 Thread Stefan Jahnke

Hi,

not that I want to sound like smart Alec, but I think his name is
Michael Hasenstein. 
Literally translated, that would be Mr. Bunnystone. Much better than
Hesselstein ;).

Gogala, Mladen schrieb:
 
 And, above all, they have a very knowledgeable guy helping
 people on the Linux-Oracle mailing  list. Michael Hesseltein
 is doing a terrific job there!
 
  -Original Message-
  From: Dwayne Cox [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, August 22, 2001 5:11 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Re: linux  Oracle -- best combination
 
 
 
  In a previous job, I was running Red Hat 6.2 and Oracle
  8.1.7.  This was
  quite stable.  Keep in mind that we were not supporting
  hundreds of users.
 
  I prefer SuSE because of the docs so I was pleased to see
  them become the
  'lead' platform for Oracle on Linux.  Still, I have not had a
  chance to
  test its stability in comparison to Red Hat.  I have a system
  up, though,
  so we'll see.
 
  My .005 cents worth...
 
 
 
  __
  Dwayne Cox
  DBA, Development Dept.
  Info Tech, Inc.
  [EMAIL PROTECTED]
  http://www.infotechfl.com
  ___
  The opinions expressed are the author's own unless otherwise stated
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Dwayne Cox
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).
 
 -
 This Mail has been checked for Viruses
 Attention: Encrypted mails can NOT be checked!
 
 **
 
 Diese Mail wurde auf Viren geprueft
 Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden!
 -

-- 
 
| Regards,   |
| Stefan Jahnke  |
| @:D2 Vodafone, Abt.: FBOM  |
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stefan Jahnke
  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: linux Oracle -- best combination

2001-08-23 Thread Jaeck Stephan

There is a SuSE-specific Oracle-List

Send a mail to
  [EMAIL PROTECTED]

or visit
http://www.suse.de/en/support/mailinglists/index.html


Stephan


-Original Message-
Sent: Thursday, August 23, 2001 1:51 AM
To: Multiple recipients of list ORACLE-L


Do you mean ORACLE-LINUX-L at [EMAIL PROTECTED] or is there another
Linux-Oracle mailing list?

-Original Message-
Sent: Wednesday, August 22, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L


And, above all, they have a very knowledgeable guy helping
people on the Linux-Oracle mailing  list. Michael Hesseltein
is doing a terrific job there!

 -Original Message-
 From: Dwayne Cox [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 22, 2001 5:11 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: linux  Oracle -- best combination
 
 
 
 In a previous job, I was running Red Hat 6.2 and Oracle 
 8.1.7.  This was
 quite stable.  Keep in mind that we were not supporting 
 hundreds of users.
 
 I prefer SuSE because of the docs so I was pleased to see 
 them become the
 'lead' platform for Oracle on Linux.  Still, I have not had a 
 chance to
 test its stability in comparison to Red Hat.  I have a system 
 up, though,
 so we'll see.
 
 My .005 cents worth...
 
 
 
 __
 Dwayne Cox
 DBA, Development Dept.
 Info Tech, Inc.
 [EMAIL PROTECTED]
 http://www.infotechfl.com
 ___
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jaeck Stephan
  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: linux Oracle -- best combination

2001-08-22 Thread Joe Testa

I've not really checked out Suse, you have to buy it versus being able
to get RH for free?

joe
Scott wrote:
 
 I believe that Oracle has decided that when porting to
 linux all products will be ported to SuSE and then
 perform post release certifications on Redhat. I
 believe stability and support of multiple Linux
 distributions was a factor in this decision. I run
 both Redhat and SuSE and I actually perfer SuSE. SuSE
 has a lot of packages it distributes with there
 product. The only thing is the SuSE wont create ISO
 images for download and Redhat will.
 
 Scott
 
 --- Brian McGraw [EMAIL PROTECTED]
 wrote:
  Correct me if I'm wrong, but wasn't Red Hat Oracle's
  preferred Linux
  distribution, right up until the time they announced
  the availability of the Red
  Hat Database (PostgreSQL)?
 
  Brian
 
  Christopher Spence wrote:
 
   I would be curious to see these tests going
  forward, seeing as RedHat
   support is difficult to do with 9i and such.  And
  suse now being Oracle's
   perfered linux.  I wonder if these results have
  changed.  I never really
   played with Oracle on Linux, but if I ever had to,
  I would be curious.
  
   Do not criticize someone until you walked a mile
  in their shoes, that way
   when you criticize them, you are a mile a way and
  have their shoes.
  
   Christopher R. Spence
   Oracle DBA
   Phone: (978) 322-5744
   Fax:(707) 885-2275
  
   Fuelspot
   73 Princeton Street
   North, Chelmsford 01863
  
  
   -Original Message-
   Sent: Tuesday, August 21, 2001 1:53 PM
   To: Multiple recipients of list ORACLE-L
  
   Lisa and others,
  
About a year ago, I was working for a company
  as a Linux systems
   engineer (Read as: Tech guy doing sales support).
  Most of our customers
   wanted Linux systems, and it was my responsibility
  to provide them the
   correct combination of Linux and hardware to meet
  their needs.  I had an ISO
   9002 compliance to maintain as I provided testing
  and supporting data to our
   clients.
  
   My first test was RedHat linux 6.1 with Oracle
  8.1.5.  I don't have the
   benchmarks any more, but it worked the best.
  
   SCO Unix was bought by Caldera Linux and is not
  yet being implemented to the
   full capability (IMHO).
  
   Mandrake, SuSe, Storm were all tested as well,
  And had less satisfactory
   performance and reliability.
  
   Slackware 7 was the next best solution, followed
  by TurboLinux 6.
  
   All of these configurations were tested on the
  same machine, completely
   formatted and the same installation performed on
  each test cycle.
  
   I hope this is helpful information.
  
   Daniel Curry
   Systems Administrator
   CGtime, Inc.
   625 Second Street
   Suite 201
   San Francisco, CA 94107
   ph: 415-348-6516
   fx: 415-348-6505
   cell: 510-304-7889
  
   -Original Message-
   Sent: Tuesday, August 21, 2001 9:36 AM
   To: Multiple recipients of list ORACLE-L
  
   Lisa
  
   SuSe is the best so I have been told. I am about
  to install 8i on 7.1 and
   another guy here is installing 9i on 7.2.
  
   Totally untested on my behalf as I haven't started
  yet but that is the best
   I have been told.
  
   Probably of no use whatsoever !!!
  
   Lee
   -Original Message-
   Sent: 21 August 2001 16:51
   To: Multiple recipients of list ORACLE-L
   Sorry everyone, I know you were just discussing
  this recently.
   What is the most stable combination of Oracle 
  Linux?  What would you
   recommend?  I want to say the consensus was SCO
  Linux but I don't quite
   remember.
   Thank you
   Lara Croft
   Oracle Database Administrator
   Fairfield Resorts, Inc
  
  
   The information contained in this communication is
  confidential, is intended
   only for the use of the recipient named above, and
  may be legally
   privileged. If the reader
   of this message is not the intended recipient, you
  are
   hereby notified that any dissemination,
  distribution or
   copying of this communication is strictly
  prohibited.
   If you have received this communication in error,
  please
   re-send this communication to the sender and
  delete the
   original message or any copy of it from your
  computer
   system.
   --
   Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
   --
   Author: Daniel Curry
 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:
  

RE: linux Oracle -- best combination

2001-08-22 Thread Jamadagni, Rajendra

Now Caldera is opening up original unix code under GPL (or a modifed version
of that), there will be even more fun in various versions that are available
freely.

Cheers
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art !

*2

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.

*2

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  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: linux Oracle -- best combination

2001-08-22 Thread Christopher Spence

PostGresSQL has been out for years, and is not RedHat specific, all
distributions have included it.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Tuesday, August 21, 2001 5:36 PM
To: Multiple recipients of list ORACLE-L


Correct me if I'm wrong, but wasn't Red Hat Oracle's preferred Linux
distribution, right up until the time they announced the availability of the
Red Hat Database (PostgreSQL)?

Brian

Christopher Spence wrote:

 I would be curious to see these tests going forward, seeing as RedHat 
 support is difficult to do with 9i and such.  And suse now being 
 Oracle's perfered linux.  I wonder if these results have changed.  I 
 never really played with Oracle on Linux, but if I ever had to, I 
 would be curious.

 Do not criticize someone until you walked a mile in their shoes, that 
 way when you criticize them, you are a mile a way and have their 
 shoes.

 Christopher R. Spence
 Oracle DBA
 Phone: (978) 322-5744
 Fax:(707) 885-2275

 Fuelspot
 73 Princeton Street
 North, Chelmsford 01863


 -Original Message-
 Sent: Tuesday, August 21, 2001 1:53 PM
 To: Multiple recipients of list ORACLE-L

 Lisa and others,

  About a year ago, I was working for a company as a Linux systems 
 engineer (Read as: Tech guy doing sales support).  Most of our 
 customers wanted Linux systems, and it was my responsibility to 
 provide them the correct combination of Linux and hardware to meet 
 their needs.  I had an ISO 9002 compliance to maintain as I provided 
 testing and supporting data to our clients.

 My first test was RedHat linux 6.1 with Oracle 8.1.5.  I don't have 
 the benchmarks any more, but it worked the best.

 SCO Unix was bought by Caldera Linux and is not yet being implemented 
 to the full capability (IMHO).

 Mandrake, SuSe, Storm were all tested as well,  And had less 
 satisfactory performance and reliability.

 Slackware 7 was the next best solution, followed by TurboLinux 6.

 All of these configurations were tested on the same machine, 
 completely formatted and the same installation performed on each test 
 cycle.

 I hope this is helpful information.

 Daniel Curry
 Systems Administrator
 CGtime, Inc.
 625 Second Street
 Suite 201
 San Francisco, CA 94107
 ph: 415-348-6516
 fx: 415-348-6505
 cell: 510-304-7889

 -Original Message-
 Sent: Tuesday, August 21, 2001 9:36 AM
 To: Multiple recipients of list ORACLE-L

 Lisa

 SuSe is the best so I have been told. I am about to install 8i on 7.1 
 and another guy here is installing 9i on 7.2.

 Totally untested on my behalf as I haven't started yet but that is the 
 best I have been told.

 Probably of no use whatsoever !!!

 Lee
 -Original Message-
 Sent: 21 August 2001 16:51
 To: Multiple recipients of list ORACLE-L
 Sorry everyone, I know you were just discussing this recently. What is 
 the most stable combination of Oracle  Linux?  What would you 
 recommend?  I want to say the consensus was SCO Linux but I don't 
 quite remember. Thank you
 Lara Croft
 Oracle Database Administrator
 Fairfield Resorts, Inc


 The information contained in this communication is confidential, is 
 intended only for the use of the recipient named above, and may be 
 legally privileged. If the reader of this message is not the intended 
 recipient, you are hereby notified that any dissemination, 
 distribution or copying of this communication is strictly prohibited.
 If you have received this communication in error, please
 re-send this communication to the sender and delete the
 original message or any copy of it from your computer
 system.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Daniel Curry
   INET: [EMAIL PROTECTED]

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

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
 the 

RE: linux Oracle -- best combination

2001-08-22 Thread Grabowy, Chris

You can download Suse, but you have over 6,000 files to download.  It's all
in a specific directory on there FTP server.

On the other hand, for RH you can just download a few ISO files and burn
them into CDs.  Easy.

I believe that Suse Personal, with CD and manuals, is 30 bucks.  I am
assuming that the personal version will run Oracle, since its seems the
Pro(70 bucks) version is for clustering, etc.

Chris

-Original Message-
Sent: Wednesday, August 22, 2001 7:51 AM
To: Multiple recipients of list ORACLE-L


I've not really checked out Suse, you have to buy it versus being able
to get RH for free?

joe
Scott wrote:
 
 I believe that Oracle has decided that when porting to
 linux all products will be ported to SuSE and then
 perform post release certifications on Redhat. I
 believe stability and support of multiple Linux
 distributions was a factor in this decision. I run
 both Redhat and SuSE and I actually perfer SuSE. SuSE
 has a lot of packages it distributes with there
 product. The only thing is the SuSE wont create ISO
 images for download and Redhat will.
 
 Scott
 
 --- Brian McGraw [EMAIL PROTECTED]
 wrote:
  Correct me if I'm wrong, but wasn't Red Hat Oracle's
  preferred Linux
  distribution, right up until the time they announced
  the availability of the Red
  Hat Database (PostgreSQL)?
 
  Brian
 
  Christopher Spence wrote:
 
   I would be curious to see these tests going
  forward, seeing as RedHat
   support is difficult to do with 9i and such.  And
  suse now being Oracle's
   perfered linux.  I wonder if these results have
  changed.  I never really
   played with Oracle on Linux, but if I ever had to,
  I would be curious.
  
   Do not criticize someone until you walked a mile
  in their shoes, that way
   when you criticize them, you are a mile a way and
  have their shoes.
  
   Christopher R. Spence
   Oracle DBA
   Phone: (978) 322-5744
   Fax:(707) 885-2275
  
   Fuelspot
   73 Princeton Street
   North, Chelmsford 01863
  
  
   -Original Message-
   Sent: Tuesday, August 21, 2001 1:53 PM
   To: Multiple recipients of list ORACLE-L
  
   Lisa and others,
  
About a year ago, I was working for a company
  as a Linux systems
   engineer (Read as: Tech guy doing sales support).
  Most of our customers
   wanted Linux systems, and it was my responsibility
  to provide them the
   correct combination of Linux and hardware to meet
  their needs.  I had an ISO
   9002 compliance to maintain as I provided testing
  and supporting data to our
   clients.
  
   My first test was RedHat linux 6.1 with Oracle
  8.1.5.  I don't have the
   benchmarks any more, but it worked the best.
  
   SCO Unix was bought by Caldera Linux and is not
  yet being implemented to the
   full capability (IMHO).
  
   Mandrake, SuSe, Storm were all tested as well,
  And had less satisfactory
   performance and reliability.
  
   Slackware 7 was the next best solution, followed
  by TurboLinux 6.
  
   All of these configurations were tested on the
  same machine, completely
   formatted and the same installation performed on
  each test cycle.
  
   I hope this is helpful information.
  
   Daniel Curry
   Systems Administrator
   CGtime, Inc.
   625 Second Street
   Suite 201
   San Francisco, CA 94107
   ph: 415-348-6516
   fx: 415-348-6505
   cell: 510-304-7889
  
   -Original Message-
   Sent: Tuesday, August 21, 2001 9:36 AM
   To: Multiple recipients of list ORACLE-L
  
   Lisa
  
   SuSe is the best so I have been told. I am about
  to install 8i on 7.1 and
   another guy here is installing 9i on 7.2.
  
   Totally untested on my behalf as I haven't started
  yet but that is the best
   I have been told.
  
   Probably of no use whatsoever !!!
  
   Lee
   -Original Message-
   Sent: 21 August 2001 16:51
   To: Multiple recipients of list ORACLE-L
   Sorry everyone, I know you were just discussing
  this recently.
   What is the most stable combination of Oracle 
  Linux?  What would you
   recommend?  I want to say the consensus was SCO
  Linux but I don't quite
   remember.
   Thank you
   Lara Croft
   Oracle Database Administrator
   Fairfield Resorts, Inc
  
  
   The information contained in this communication is
  confidential, is intended
   only for the use of the recipient named above, and
  may be legally
   privileged. If the reader
   of this message is not the intended recipient, you
  are
   hereby notified that any dissemination,
  distribution or
   copying of this communication is strictly
  prohibited.
   If you have received this communication in error,
  please
   re-send this communication to the sender and
  delete the
   original message or any copy of it from your
  computer
   system.
   --
   Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
   --
   Author: Daniel Curry
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051
  FAX: (858) 538-5051
   San Diego, California-- Public 

RE: linux Oracle -- best combination

2001-08-22 Thread Christopher Spence

Yeah, the other thing, 6000 files which consist of 500Mb is about 10x slower
to download than 1 file which is 600Mb

The TCP protocol, ramps, which means, it gets up to speed within the first
few seconds of delivery, when your downloading many small files, your
bandwidth is cut down by 10 fold if not more.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Wednesday, August 22, 2001 10:17 AM
To: Multiple recipients of list ORACLE-L


You can download Suse, but you have over 6,000 files to download.  It's all
in a specific directory on there FTP server.

On the other hand, for RH you can just download a few ISO files and burn
them into CDs.  Easy.

I believe that Suse Personal, with CD and manuals, is 30 bucks.  I am
assuming that the personal version will run Oracle, since its seems the
Pro(70 bucks) version is for clustering, etc.

Chris

-Original Message-
Sent: Wednesday, August 22, 2001 7:51 AM
To: Multiple recipients of list ORACLE-L


I've not really checked out Suse, you have to buy it versus being able to
get RH for free?

joe
Scott wrote:
 
 I believe that Oracle has decided that when porting to
 linux all products will be ported to SuSE and then
 perform post release certifications on Redhat. I
 believe stability and support of multiple Linux
 distributions was a factor in this decision. I run
 both Redhat and SuSE and I actually perfer SuSE. SuSE
 has a lot of packages it distributes with there
 product. The only thing is the SuSE wont create ISO
 images for download and Redhat will.
 
 Scott
 
 --- Brian McGraw [EMAIL PROTECTED]
 wrote:
  Correct me if I'm wrong, but wasn't Red Hat Oracle's preferred Linux
  distribution, right up until the time they announced
  the availability of the Red
  Hat Database (PostgreSQL)?
 
  Brian
 
  Christopher Spence wrote:
 
   I would be curious to see these tests going
  forward, seeing as RedHat
   support is difficult to do with 9i and such.  And
  suse now being Oracle's
   perfered linux.  I wonder if these results have
  changed.  I never really
   played with Oracle on Linux, but if I ever had to,
  I would be curious.
  
   Do not criticize someone until you walked a mile
  in their shoes, that way
   when you criticize them, you are a mile a way and
  have their shoes.
  
   Christopher R. Spence
   Oracle DBA
   Phone: (978) 322-5744
   Fax:(707) 885-2275
  
   Fuelspot
   73 Princeton Street
   North, Chelmsford 01863
  
  
   -Original Message-
   Sent: Tuesday, August 21, 2001 1:53 PM
   To: Multiple recipients of list ORACLE-L
  
   Lisa and others,
  
About a year ago, I was working for a company
  as a Linux systems
   engineer (Read as: Tech guy doing sales support).
  Most of our customers
   wanted Linux systems, and it was my responsibility
  to provide them the
   correct combination of Linux and hardware to meet
  their needs.  I had an ISO
   9002 compliance to maintain as I provided testing
  and supporting data to our
   clients.
  
   My first test was RedHat linux 6.1 with Oracle
  8.1.5.  I don't have the
   benchmarks any more, but it worked the best.
  
   SCO Unix was bought by Caldera Linux and is not
  yet being implemented to the
   full capability (IMHO).
  
   Mandrake, SuSe, Storm were all tested as well,
  And had less satisfactory
   performance and reliability.
  
   Slackware 7 was the next best solution, followed
  by TurboLinux 6.
  
   All of these configurations were tested on the
  same machine, completely
   formatted and the same installation performed on
  each test cycle.
  
   I hope this is helpful information.
  
   Daniel Curry
   Systems Administrator
   CGtime, Inc.
   625 Second Street
   Suite 201
   San Francisco, CA 94107
   ph: 415-348-6516
   fx: 415-348-6505
   cell: 510-304-7889
  
   -Original Message-
   Sent: Tuesday, August 21, 2001 9:36 AM
   To: Multiple recipients of list ORACLE-L
  
   Lisa
  
   SuSe is the best so I have been told. I am about
  to install 8i on 7.1 and
   another guy here is installing 9i on 7.2.
  
   Totally untested on my behalf as I haven't started
  yet but that is the best
   I have been told.
  
   Probably of no use whatsoever !!!
  
   Lee
   -Original Message-
   Sent: 21 August 2001 16:51
   To: Multiple recipients of list ORACLE-L
   Sorry everyone, I know you were just discussing
  this recently.
   What is the most stable combination of Oracle 
  Linux?  What would you
   recommend?  I want to say the consensus was SCO
  Linux but I don't quite
   remember.
   Thank you
   Lara Croft
   Oracle Database Administrator
   Fairfield Resorts, Inc
  
  
   The information contained in this communication is
  confidential, is intended
   only for the use of 

RE: linux Oracle -- best combination

2001-08-22 Thread JOE TESTA



6000 files, what a pita, guess i'll stay with hacking rh to run oracle 
:)


joe
 [EMAIL PROTECTED] 08/22/01 10:16AM You 
can download Suse, but you have over 6,000 files to download. It's 
allin a specific directory on there FTP server.On the other hand, 
for RH you can just download a few ISO files and burnthem into CDs. 
Easy.I believe that Suse Personal, with CD and manuals, is 30 
bucks. I amassuming that the personal version will run Oracle, since 
its seems thePro(70 bucks) version is for clustering, 
etc.Chris-Original Message-Sent: Wednesday, August 
22, 2001 7:51 AMTo: Multiple recipients of list ORACLE-LI've not 
really checked out Suse, you have to buy it versus being ableto get RH for 
free?joeScott wrote:  I believe that Oracle has 
decided that when porting to linux all products will be ported to SuSE 
and then perform post release certifications on Redhat. I 
believe stability and support of multiple Linux distributions was a 
factor in this decision. I run both Redhat and SuSE and I actually 
perfer SuSE. SuSE has a lot of packages it distributes with 
there product. The only thing is the SuSE wont create ISO images 
for download and Redhat will.  Scott  --- Brian 
McGraw [EMAIL PROTECTED] wrote:  
Correct me if I'm wrong, but wasn't Red Hat Oracle's  preferred 
Linux  distribution, right up until the time they announced 
 the availability of the Red  Hat Database (PostgreSQL)? 
  Brian   Christopher Spence 
wrote:I would be curious to see these tests 
going  forward, seeing as RedHat   support is 
difficult to do with 9i and such. And  suse now being 
Oracle's   perfered linux. I wonder if these results 
have  changed. I never really   played with 
Oracle on Linux, but if I ever had to,  I would be curious. 
"Do not criticize someone until you walked a 
mile  in their shoes, that way   when you criticize 
them, you are a mile a way and  have their shoes."  
   Christopher R. Spence   Oracle 
DBA   Phone: (978) 322-5744   
Fax: (707) 885-2275 
Fuelspot   73 Princeton Street   North, 
Chelmsford 01863   
-Original Message-   Sent: Tuesday, August 21, 2001 1:53 
PM   To: Multiple recipients of list ORACLE-L  
   Lisa and others,
 About a year ago, I was working for a 
company  as a Linux systems   engineer (Read as: 
Tech guy doing sales support).  Most of our customers  
 wanted Linux systems, and it was my responsibility  to provide 
them the   correct combination of Linux and hardware to 
meet  their needs. I had an ISO   9002 
compliance to maintain as I provided testing  and supporting data to 
our   clients. My first test 
was RedHat linux 6.1 with Oracle  8.1.5. I don't have 
the   benchmarks any more, but it worked the best.  
   SCO Unix was bought by Caldera Linux and is not 
 yet being implemented to the   full capability 
(IMHO). Mandrake, SuSe, Storm were all 
tested as well,  And had less satisfactory   
performance and reliability. Slackware 7 was 
the next best solution, followed  by TurboLinux 6.  
   All of these configurations were tested on the 
 same machine, completely   formatted and the same 
installation performed on  each test cycle.  
   I hope this is helpful information.  
   Daniel Curry   Systems 
Administrator   CGtime, Inc.   625 Second 
Street   Suite 201   San Francisco, CA 
94107   ph: 415-348-6516   fx: 
415-348-6505   cell: 510-304-7889
 -Original Message-   Sent: Tuesday, August 21, 2001 
9:36 AM   To: Multiple recipients of list ORACLE-L  
   Lisa SuSe is the best 
so I have been told. I am about  to install 8i on 7.1 and 
  another guy here is installing 9i on 7.2.   
  Totally untested on my behalf as I haven't started  yet 
but that is the best   I have been told.  
   Probably of no use whatsoever !!!  
   Lee   -Original Message- 
  Sent: 21 August 2001 16:51   To: Multiple recipients 
of list ORACLE-L   Sorry everyone, I know you were just 
discussing  this recently.   What is the most stable 
combination of Oracle   Linux? What would you 
  recommend? I want to say the consensus was SCO  
Linux but I don't quite   remember.   Thank 
you   Lara Croft   Oracle Database 
Administrator   Fairfield Resorts, Inc   
The information contained in this communication 
is  confidential, is intended   only for the use of 
the recipient named above, and  may be legally   
privileged. If the reader   of this message is not the intended 
recipient, you  are   hereby notified that any 
dissemination,  distribution or   copying of this 
communication is strictly  prohibited.   If you have 
received this communication in error,  please   
re-send this communication to the sender and  delete the 
  original message or any copy of it from your  
computer   system.   --   Please 
see the official ORACLE-L FAQ:  http://www.orafaq.com   
--   Author: Daniel Curry   INET: 
[EMAIL PROTECTED] Fat City Network 
Services -- (858) 538-5051  FAX: (858) 
538-5051   San Diego, 
California -- 

Re: linux Oracle -- best combination

2001-08-22 Thread Jared Still


Joe,

It's cheap.  $60-70 for the pro version.

Even though I've been a long time RH user, I prefer SuSE
simply for the documentation and admin utils.

Jared


On Wednesday 22 August 2001 04:50, Joe Testa wrote:
 I've not really checked out Suse, you have to buy it versus being able
 to get RH for free?

 joe

 Scott wrote:
  I believe that Oracle has decided that when porting to
  linux all products will be ported to SuSE and then
  perform post release certifications on Redhat. I
  believe stability and support of multiple Linux
  distributions was a factor in this decision. I run
  both Redhat and SuSE and I actually perfer SuSE. SuSE
  has a lot of packages it distributes with there
  product. The only thing is the SuSE wont create ISO
  images for download and Redhat will.
 
  Scott
 
  --- Brian McGraw [EMAIL PROTECTED]
 
  wrote:
   Correct me if I'm wrong, but wasn't Red Hat Oracle's
   preferred Linux
   distribution, right up until the time they announced
   the availability of the Red
   Hat Database (PostgreSQL)?
  
   Brian
  
   Christopher Spence wrote:
I would be curious to see these tests going
  
   forward, seeing as RedHat
  
support is difficult to do with 9i and such.  And
  
   suse now being Oracle's
  
perfered linux.  I wonder if these results have
  
   changed.  I never really
  
played with Oracle on Linux, but if I ever had to,
  
   I would be curious.
  
Do not criticize someone until you walked a mile
  
   in their shoes, that way
  
when you criticize them, you are a mile a way and
  
   have their shoes.
  
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
   
Fuelspot
73 Princeton Street
North, Chelmsford 01863
   
   
-Original Message-
Sent: Tuesday, August 21, 2001 1:53 PM
To: Multiple recipients of list ORACLE-L
   
Lisa and others,
   
 About a year ago, I was working for a company
  
   as a Linux systems
  
engineer (Read as: Tech guy doing sales support).
  
   Most of our customers
  
wanted Linux systems, and it was my responsibility
  
   to provide them the
  
correct combination of Linux and hardware to meet
  
   their needs.  I had an ISO
  
9002 compliance to maintain as I provided testing
  
   and supporting data to our
  
clients.
   
My first test was RedHat linux 6.1 with Oracle
  
   8.1.5.  I don't have the
  
benchmarks any more, but it worked the best.
   
SCO Unix was bought by Caldera Linux and is not
  
   yet being implemented to the
  
full capability (IMHO).
   
Mandrake, SuSe, Storm were all tested as well,
  
   And had less satisfactory
  
performance and reliability.
   
Slackware 7 was the next best solution, followed
  
   by TurboLinux 6.
  
All of these configurations were tested on the
  
   same machine, completely
  
formatted and the same installation performed on
  
   each test cycle.
  
I hope this is helpful information.
   
Daniel Curry
Systems Administrator
CGtime, Inc.
625 Second Street
Suite 201
San Francisco, CA 94107
ph: 415-348-6516
fx: 415-348-6505
cell: 510-304-7889
   
-Original Message-
Sent: Tuesday, August 21, 2001 9:36 AM
To: Multiple recipients of list ORACLE-L
   
Lisa
   
SuSe is the best so I have been told. I am about
  
   to install 8i on 7.1 and
  
another guy here is installing 9i on 7.2.
   
Totally untested on my behalf as I haven't started
  
   yet but that is the best
  
I have been told.
   
Probably of no use whatsoever !!!
   
Lee
-Original Message-
Sent: 21 August 2001 16:51
To: Multiple recipients of list ORACLE-L
Sorry everyone, I know you were just discussing
  
   this recently.
  
What is the most stable combination of Oracle 
  
   Linux?  What would you
  
recommend?  I want to say the consensus was SCO
  
   Linux but I don't quite
  
remember.
Thank you
Lara Croft
Oracle Database Administrator
Fairfield Resorts, Inc
   
   
The information contained in this communication is
  
   confidential, is intended
  
only for the use of the recipient named above, and
  
   may be legally
  
privileged. If the reader
of this message is not the intended recipient, you
  
   are
  
hereby notified that any dissemination,
  
   distribution or
  
copying of this communication is strictly
  
   prohibited.
  
If you have received this communication in error,
  
   please
  
re-send this communication to the sender and
  
   delete the
  
original message or any copy of it from your
  
   computer
  
system.
--
Please see the official ORACLE-L FAQ:
  
   http://www.orafaq.com
  
--
Author: Daniel Curry
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- (858) 538-5051
  
   FAX: (858) 538-5051
  
San Diego, 

Re: linux Oracle -- best combination

2001-08-22 Thread JOE TESTA



and its only 2.3K :) 

guess i'm spoiled being able to grab darn near anything that oracle has 
from technet.

joe
 [EMAIL PROTECTED] 08/22/01 11:00AM 
True, but now RedHat pushes it as the 'Red Hat 
Database'...http://www.redhat.com/products/software/database/Christopher 
Spence wrote: PostGresSQL has been out for years, and is not RedHat 
specific, all distributions have included it. "Do not 
criticize someone until you walked a mile in their shoes, that way when 
you criticize them, you are a mile a way and have their shoes." 
Christopher R. Spence Oracle DBA Phone: (978) 322-5744 
Fax: (707) 885-2275 Fuelspot 73 
Princeton Street North, Chelmsford 01863 
-Original Message- Sent: Tuesday, August 21, 2001 5:36 
PM To: Multiple recipients of list ORACLE-L Correct me 
if I'm wrong, but wasn't Red Hat Oracle's preferred Linux distribution, 
right up until the time they announced the availability of the Red Hat 
Database (PostgreSQL)? Brian Christopher Spence 
wrote:  I would be curious to see these tests going forward, 
seeing as RedHat  support is difficult to do with 9i and such. 
And suse now being  Oracle's perfered linux. I wonder if these 
results have changed. I  never really played with Oracle on 
Linux, but if I ever had to, I  would be curious. 
  "Do not criticize someone until you walked a mile in their 
shoes, that  way when you criticize them, you are a mile a way and 
have their  shoes."   Christopher R. 
Spence  Oracle DBA  Phone: (978) 322-5744  
Fax: (707) 885-2275   Fuelspot 
 73 Princeton Street  North, Chelmsford 01863 
   -Original Message-  Sent: 
Tuesday, August 21, 2001 1:53 PM  To: Multiple recipients of list 
ORACLE-L   Lisa and others,  
 About a year ago, I was working for a company 
as a Linux systems  engineer (Read as: Tech guy doing sales 
support). Most of our  customers wanted Linux systems, and it 
was my responsibility to  provide them the correct combination of 
Linux and hardware to meet  their needs. I had an ISO 9002 
compliance to maintain as I provided  testing and supporting data to 
our clients.   My first test was RedHat linux 6.1 with 
Oracle 8.1.5. I don't have  the benchmarks any more, but it 
worked the best.   SCO Unix was bought by Caldera Linux 
and is not yet being implemented  to the full capability 
(IMHO).   Mandrake, SuSe, Storm were all tested as 
well, And had less  satisfactory performance and 
reliability.   Slackware 7 was the next best solution, 
followed by TurboLinux 6.   All of these configurations 
were tested on the same machine,  completely formatted and the same 
installation performed on each test  cycle.  
 I hope this is helpful information.   Daniel 
Curry  Systems Administrator  CGtime, Inc.  
625 Second Street  Suite 201  San Francisco, CA 
94107  ph: 415-348-6516  fx: 415-348-6505  
cell: 510-304-7889   -Original Message- 
 Sent: Tuesday, August 21, 2001 9:36 AM  To: Multiple recipients 
of list ORACLE-L   Lisa   SuSe 
is the best so I have been told. I am about to install 8i on 7.1  
and another guy here is installing 9i on 7.2.   Totally 
untested on my behalf as I haven't started yet but that is the  best 
I have been told.   Probably of no use whatsoever 
!!!   Lee  -Original 
Message-  Sent: 21 August 2001 16:51  To: Multiple 
recipients of list ORACLE-L  Sorry everyone, I know you were just 
discussing this recently. What is  the most stable combination of 
Oracle  Linux? What would you  recommend? I want to 
say the consensus was SCO Linux but I don't  quite remember. Thank 
you  Lara Croft  Oracle Database Administrator 
 Fairfield Resorts, IncThe 
information contained in this communication is confidential, is  
intended only for the use of the recipient named above, and may be  
legally privileged. If the reader of this message is not the intended 
 recipient, you are hereby notified that any dissemination,  
distribution or copying of this communication is strictly prohibited. 
 If you have received this communication in error, please  
re-send this communication to the sender and delete the  original 
message or any copy of it from your computer  system.  
--  Please see the official ORACLE-L FAQ: http://www.orafaq.com  -- 
 Author: Daniel Curry  INET: 
[EMAIL PROTECTED]   Fat City Network 
Services -- (858) 538-5051 FAX: (858) 538-5051 
 San Diego, California -- Public 
Internet access / Mailing Lists  
 
 To REMOVE yourself from this mailing list, send an E-Mail message 
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
 the message BODY, include a line containing: UNSUB ORACLE-L (or the 
 name of mailing list you want to be removed from). You may also 
send  the HELP command for other information (like 
subscribing).  --  Please see the official ORACLE-L FAQ: 
http://www.orafaq.com  
--  Author: Christopher Spence  INET: 
[EMAIL PROTECTED]   Fat City Network 
Services -- (858) 538-5051 FAX: 

RE: linux Oracle -- best combination

2001-08-22 Thread Koivu, Lisa
Title: RE: linux  Oracle -- best combination





Have you tried an index hint on the first query yet? 


Have you tried NVL(cmm_id,101) = 101,
NVL(cust_id,101) = 101
NVL(Friendly_session_id,100) = 100
loc_to_utc(NVL(creation_date,21-jun-2001')) between your dates?


-Original Message-
From: Vikas Kawatra [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, August 22, 2001 13:12
To: Multiple recipients of list ORACLE-L
Subject: RE: linux  Oracle -- best combination


We're trying to re-write some SQL such that the index on columns in the
where clause is used.Logically ,the query is as below .But this query does
not use the Index .However ,if we re-write it as below(see 2nd query) - the
index is used :but the query returns incorrect results .Can you suggest any
changes to the original query? 


note :
1)we have a index on cmm_id,cust_id,friendly_session_id,creation_date
2)We want to return rows from the table even if all columns in where clause
are NULL 


Thanks 


vikas



SELECT friendly_session_id,
 cmm_id,
  cust_id,
 hold_amount,
  virtual_balance_amount,
  creation_date,
  session_id
 FROM sals_session
 WHERE ( CMM_ID = '101' or cmm_id IS NULL )
 AND ( CUST_ID =101 or cust_id IS NULL )
 AND ( FRIENDLY_SESSION_ID = 100 or friendly_session_id IS NULL )
 AND (CREATION_DATE is NULL OR loc_to_utc(creation_date) between
'21-JUN-2001' and '21-AUG-2001');




SELECT friendly_session_id,
 cmm_id,
  cust_id,
 hold_amount,
  virtual_balance_amount,
  creation_date,
  session_id
 FROM sals_session
 WHERE cmm_id = nvl(cmm_id,0)
 AND cust_id = nvl(cust_id,0)
 AND friendly_session_id =nvl(friendly_session_id ,0)
 AND (creation_date is NULL OR loc_to_utc(creation_date) between
'21-JUN-2001' and '21-AUG-2001');
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vikas Kawatra
 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: linux Oracle -- best combination

2001-08-22 Thread JOE TESTA



granted $60 is not much but its A LOT more than free :)

joe
 [EMAIL PROTECTED] 08/22/01 11:56AM 
Joe,It's cheap. $60-70 for the pro 
version.Even though I've been a long time RH user, I prefer 
SuSEsimply for the documentation and admin utils.JaredOn 
Wednesday 22 August 2001 04:50, Joe Testa wrote: I've not really checked 
out Suse, you have to buy it versus being able to get RH for 
free? joe Scott wrote:  I believe 
that Oracle has decided that when porting to  linux all products 
will be ported to SuSE and then  perform post release certifications 
on Redhat. I  believe stability and support of multiple 
Linux  distributions was a factor in this decision. I run 
 both Redhat and SuSE and I actually perfer SuSE. SuSE  has a 
lot of packages it distributes with there  product. The only thing 
is the SuSE wont create ISO  images for download and Redhat 
will.   Scott   --- Brian McGraw 
[EMAIL PROTECTED]   
wrote:   Correct me if I'm wrong, but wasn't Red Hat 
Oracle's   preferred Linux   distribution, right 
up until the time they announced   the availability of the 
Red   Hat Database (PostgreSQL)?
 Brian Christopher Spence wrote: 
   I would be curious to see these tests going  
   forward, seeing as RedHat
  support is difficult to do with 9i and such. And  
   suse now being Oracle's
  perfered linux. I wonder if these results have  
   changed. I never really   
   played with Oracle on Linux, but if I ever had to,  
   I would be curious. 
 "Do not criticize someone until you walked a mile   
  in their shoes, that way  when 
you criticize them, you are a mile a way and 
have their shoes."  Christopher R. 
SpenceOracle DBAPhone: (978) 
322-5744Fax: (707) 885-2275 
  Fuelspot73 
Princeton StreetNorth, Chelmsford 01863  
-Original 
Message-Sent: Tuesday, August 21, 2001 1:53 
PMTo: Multiple recipients of list ORACLE-L  
 Lisa and others,
   About a year ago, I was working for 
a company as a Linux systems  
engineer (Read as: Tech guy doing sales 
support). Most of our customers  
wanted Linux systems, and it was my 
responsibility to provide them the 
 correct combination of Linux and hardware to 
meet their needs. I had an ISO 
 9002 compliance to maintain as I provided 
testing and supporting data to our 
 clients. 
  My first test was RedHat linux 6.1 with Oracle  
   8.1.5. I don't have the   
   benchmarks any more, but it worked the best.   
SCO Unix was bought by Caldera Linux and is 
not yet being implemented to the 
 full capability (IMHO).   
Mandrake, SuSe, Storm were all tested as 
well, And had less satisfactory  
performance and reliability.   
Slackware 7 was the next best solution, 
followed by TurboLinux 6.  
All of these configurations were tested on 
the same machine, completely  
formatted and the same installation performed 
on each test cycle.  
I hope this is helpful information.  
 Daniel CurrySystems 
AdministratorCGtime, Inc.625 
Second StreetSuite 201San 
Francisco, CA 94107ph: 415-348-6516   
 fx: 415-348-6505cell: 510-304-7889  
 -Original Message-   
 Sent: Tuesday, August 21, 2001 9:36 AMTo: Multiple 
recipients of list ORACLE-L   
Lisa   SuSe is the best so I have 
been told. I am about to install 8i on 7.1 
and  another guy here is installing 9i 
on 7.2.   Totally untested on my 
behalf as I haven't started yet but that is 
the best  I have been told.  
 Probably of no use whatsoever !!!  
 Lee-Original 
Message-Sent: 21 August 2001 16:51   
 To: Multiple recipients of list ORACLE-LSorry 
everyone, I know you were just discussing 
this recently.  What is the most stable 
combination of Oracle  Linux? 
What would you  recommend? I want 
to say the consensus was SCO Linux but I 
don't quite  remember.   
 Thank youLara CroftOracle 
Database AdministratorFairfield Resorts, Inc 
 The information 
contained in this communication is 
confidential, is intended  only for the 
use of the recipient named above, and may be 
legally  privileged. If the 
readerof this message is not the intended recipient, 
you are 
 hereby notified that any dissemination, 
distribution or  copying of this 
communication is strictly 
prohibited.  If you have received this 
communication in error, please  
re-send this communication to the sender and 
delete the  
original message or any copy of it from your 
computer  system.
--Please see the official ORACLE-L FAQ:  
   http://www.orafaq.com   
   --Author: Daniel Curry   
 INET: [EMAIL PROTECTED] 
  Fat City Network Services -- (858) 538-5051 
FAX: (858) 538-5051
  San Diego, California -- 
Public Internet access / 

RE: linux Oracle -- best combination

2001-08-22 Thread Vikas Kawatra

We're trying to re-write some SQL such that the index on columns in the
where clause is used.Logically ,the query is as below .But this query does
not use the Index .However ,if we re-write it as below(see 2nd query) - the
index is used :but the query returns incorrect results .Can you suggest any
changes to the original query? 

note :
 1)we have a index on cmm_id,cust_id,friendly_session_id,creation_date
 2)We want to return rows from the table even if all columns in where clause
are NULL 

Thanks 

vikas


SELECT friendly_session_id,
  cmm_id,
  cust_id,
  hold_amount,
  virtual_balance_amount,
  creation_date,
  session_id
 FROM sals_session
 WHERE ( CMM_ID = '101' or  cmm_id IS NULL )
 AND ( CUST_ID =101 or cust_id IS NULL )
 AND ( FRIENDLY_SESSION_ID = 100 or friendly_session_id IS NULL )
 AND (CREATION_DATE is NULL OR loc_to_utc(creation_date) between
'21-JUN-2001' and '21-AUG-2001');



SELECT friendly_session_id,
  cmm_id,
  cust_id,
  hold_amount,
  virtual_balance_amount,
  creation_date,
  session_id
 FROM sals_session
 WHERE cmm_id = nvl(cmm_id,0)
 AND cust_id = nvl(cust_id,0)
 AND friendly_session_id =nvl(friendly_session_id ,0)
 AND (creation_date is NULL OR loc_to_utc(creation_date) between
'21-JUN-2001' and '21-AUG-2001');
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vikas Kawatra
  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: linux Oracle -- best combination

2001-08-22 Thread Dwayne Cox


In a previous job, I was running Red Hat 6.2 and Oracle 8.1.7.  This was
quite stable.  Keep in mind that we were not supporting hundreds of users.

I prefer SuSE because of the docs so I was pleased to see them become the
'lead' platform for Oracle on Linux.  Still, I have not had a chance to
test its stability in comparison to Red Hat.  I have a system up, though,
so we'll see.

My .005 cents worth...



__
Dwayne Cox
DBA, Development Dept.
Info Tech, Inc.
[EMAIL PROTECTED]
http://www.infotechfl.com
___
The opinions expressed are the author's own unless otherwise stated
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dwayne Cox
  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: linux Oracle -- best combination

2001-08-22 Thread Gogala, Mladen

And, above all, they have a very knowledgeable guy helping
people on the Linux-Oracle mailing  list. Michael Hesseltein
is doing a terrific job there!

 -Original Message-
 From: Dwayne Cox [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 22, 2001 5:11 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: linux  Oracle -- best combination
 
 
 
 In a previous job, I was running Red Hat 6.2 and Oracle 
 8.1.7.  This was
 quite stable.  Keep in mind that we were not supporting 
 hundreds of users.
 
 I prefer SuSE because of the docs so I was pleased to see 
 them become the
 'lead' platform for Oracle on Linux.  Still, I have not had a 
 chance to
 test its stability in comparison to Red Hat.  I have a system 
 up, though,
 so we'll see.
 
 My .005 cents worth...
 
 
 
 __
 Dwayne Cox
 DBA, Development Dept.
 Info Tech, Inc.
 [EMAIL PROTECTED]
 http://www.infotechfl.com
 ___
 The opinions expressed are the author's own unless otherwise stated
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Dwayne Cox
   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).



RE: linux Oracle -- best combination

2001-08-22 Thread Molina, Gerardo

Do you mean ORACLE-LINUX-L at [EMAIL PROTECTED] or is there another
Linux-Oracle mailing list?

-Original Message-
Sent: Wednesday, August 22, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L


And, above all, they have a very knowledgeable guy helping
people on the Linux-Oracle mailing  list. Michael Hesseltein
is doing a terrific job there!

 -Original Message-
 From: Dwayne Cox [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 22, 2001 5:11 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: linux  Oracle -- best combination
 
 
 
 In a previous job, I was running Red Hat 6.2 and Oracle 
 8.1.7.  This was
 quite stable.  Keep in mind that we were not supporting 
 hundreds of users.
 
 I prefer SuSE because of the docs so I was pleased to see 
 them become the
 'lead' platform for Oracle on Linux.  Still, I have not had a 
 chance to
 test its stability in comparison to Red Hat.  I have a system 
 up, though,
 so we'll see.
 
 My .005 cents worth...
 
 
 
 __
 Dwayne Cox
 DBA, Development Dept.
 Info Tech, Inc.
 [EMAIL PROTECTED]
 http://www.infotechfl.com
 ___
 The opinions expressed are the author's own unless otherwise stated
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Dwayne Cox
   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: Molina, Gerardo
  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: linux Oracle -- best combination

2001-08-21 Thread Daniel Curry

Lisa and others,
 
 About a year ago, I was working for a company as a Linux systems
engineer (Read as: Tech guy doing sales support).  Most of our customers
wanted Linux systems, and it was my responsibility to provide them the
correct combination of Linux and hardware to meet their needs.  I had an
ISO 9002 compliance to maintain as I provided testing and supporting
data to our clients.
 
My first test was RedHat linux 6.1 with Oracle 8.1.5.  I don't have the
benchmarks any more, but it worked the best.
 
SCO Unix was bought by Caldera Linux and is not yet being implemented to
the full capability (IMHO).
 
Mandrake, SuSe, Storm were all tested as well,  And had less
satisfactory performance and reliability.  
 
Slackware 7 was the next best solution, followed by TurboLinux 6.
 
All of these configurations were tested on the same machine, completely
formatted and the same installation performed on each test cycle.
 
I hope this is helpful information.
 
Daniel Curry
Systems Administrator
CGtime, Inc. 
625 Second Street 
Suite 201
San Francisco, CA 94107 
ph: 415-348-6516
fx: 415-348-6505 
cell: 510-304-7889
 
-Original Message-
Sent: Tuesday, August 21, 2001 9:36 AM
To: Multiple recipients of list ORACLE-L
 
Lisa
 
SuSe is the best so I have been told. I am about to install 8i on 7.1
and another guy here is installing 9i on 7.2.
 
Totally untested on my behalf as I haven't started yet but that is the
best I have been told.
 
Probably of no use whatsoever !!!
 
Lee
-Original Message-
Sent: 21 August 2001 16:51
To: Multiple recipients of list ORACLE-L
Sorry everyone, I know you were just discussing this recently.  
What is the most stable combination of Oracle  Linux?  What would you
recommend?  I want to say the consensus was SCO Linux but I don't quite
remember.  
Thank you 
Lara Croft 
Oracle Database Administrator 
Fairfield Resorts, Inc 
 


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited. 
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Daniel Curry
  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: linux Oracle -- best combination

2001-08-21 Thread Christopher Spence

I would be curious to see these tests going forward, seeing as RedHat
support is difficult to do with 9i and such.  And suse now being Oracle's
perfered linux.  I wonder if these results have changed.  I never really
played with Oracle on Linux, but if I ever had to, I would be curious.  

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Tuesday, August 21, 2001 1:53 PM
To: Multiple recipients of list ORACLE-L


Lisa and others,
 
 About a year ago, I was working for a company as a Linux systems
engineer (Read as: Tech guy doing sales support).  Most of our customers
wanted Linux systems, and it was my responsibility to provide them the
correct combination of Linux and hardware to meet their needs.  I had an ISO
9002 compliance to maintain as I provided testing and supporting data to our
clients.
 
My first test was RedHat linux 6.1 with Oracle 8.1.5.  I don't have the
benchmarks any more, but it worked the best.
 
SCO Unix was bought by Caldera Linux and is not yet being implemented to the
full capability (IMHO).
 
Mandrake, SuSe, Storm were all tested as well,  And had less satisfactory
performance and reliability.  
 
Slackware 7 was the next best solution, followed by TurboLinux 6.
 
All of these configurations were tested on the same machine, completely
formatted and the same installation performed on each test cycle.
 
I hope this is helpful information.
 
Daniel Curry
Systems Administrator
CGtime, Inc. 
625 Second Street 
Suite 201
San Francisco, CA 94107 
ph: 415-348-6516
fx: 415-348-6505 
cell: 510-304-7889
 
-Original Message-
Sent: Tuesday, August 21, 2001 9:36 AM
To: Multiple recipients of list ORACLE-L
 
Lisa
 
SuSe is the best so I have been told. I am about to install 8i on 7.1 and
another guy here is installing 9i on 7.2.
 
Totally untested on my behalf as I haven't started yet but that is the best
I have been told.
 
Probably of no use whatsoever !!!
 
Lee
-Original Message-
Sent: 21 August 2001 16:51
To: Multiple recipients of list ORACLE-L
Sorry everyone, I know you were just discussing this recently.  
What is the most stable combination of Oracle  Linux?  What would you
recommend?  I want to say the consensus was SCO Linux but I don't quite
remember.  
Thank you 
Lara Croft 
Oracle Database Administrator 
Fairfield Resorts, Inc 
 


The information contained in this communication is confidential, is intended
only for the use of the recipient named above, and may be legally
privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited. 
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Daniel Curry
  INET: [EMAIL PROTECTED]

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

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

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

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



Re: linux Oracle -- best combination

2001-08-21 Thread Brian McGraw

Correct me if I'm wrong, but wasn't Red Hat Oracle's preferred Linux
distribution, right up until the time they announced the availability of the Red
Hat Database (PostgreSQL)?

Brian

Christopher Spence wrote:

 I would be curious to see these tests going forward, seeing as RedHat
 support is difficult to do with 9i and such.  And suse now being Oracle's
 perfered linux.  I wonder if these results have changed.  I never really
 played with Oracle on Linux, but if I ever had to, I would be curious.

 Do not criticize someone until you walked a mile in their shoes, that way
 when you criticize them, you are a mile a way and have their shoes.

 Christopher R. Spence
 Oracle DBA
 Phone: (978) 322-5744
 Fax:(707) 885-2275

 Fuelspot
 73 Princeton Street
 North, Chelmsford 01863


 -Original Message-
 Sent: Tuesday, August 21, 2001 1:53 PM
 To: Multiple recipients of list ORACLE-L

 Lisa and others,

  About a year ago, I was working for a company as a Linux systems
 engineer (Read as: Tech guy doing sales support).  Most of our customers
 wanted Linux systems, and it was my responsibility to provide them the
 correct combination of Linux and hardware to meet their needs.  I had an ISO
 9002 compliance to maintain as I provided testing and supporting data to our
 clients.

 My first test was RedHat linux 6.1 with Oracle 8.1.5.  I don't have the
 benchmarks any more, but it worked the best.

 SCO Unix was bought by Caldera Linux and is not yet being implemented to the
 full capability (IMHO).

 Mandrake, SuSe, Storm were all tested as well,  And had less satisfactory
 performance and reliability.

 Slackware 7 was the next best solution, followed by TurboLinux 6.

 All of these configurations were tested on the same machine, completely
 formatted and the same installation performed on each test cycle.

 I hope this is helpful information.

 Daniel Curry
 Systems Administrator
 CGtime, Inc.
 625 Second Street
 Suite 201
 San Francisco, CA 94107
 ph: 415-348-6516
 fx: 415-348-6505
 cell: 510-304-7889

 -Original Message-
 Sent: Tuesday, August 21, 2001 9:36 AM
 To: Multiple recipients of list ORACLE-L

 Lisa

 SuSe is the best so I have been told. I am about to install 8i on 7.1 and
 another guy here is installing 9i on 7.2.

 Totally untested on my behalf as I haven't started yet but that is the best
 I have been told.

 Probably of no use whatsoever !!!

 Lee
 -Original Message-
 Sent: 21 August 2001 16:51
 To: Multiple recipients of list ORACLE-L
 Sorry everyone, I know you were just discussing this recently.
 What is the most stable combination of Oracle  Linux?  What would you
 recommend?  I want to say the consensus was SCO Linux but I don't quite
 remember.
 Thank you
 Lara Croft
 Oracle Database Administrator
 Fairfield Resorts, Inc


 The information contained in this communication is confidential, is intended
 only for the use of the recipient named above, and may be legally
 privileged. If the reader
 of this message is not the intended recipient, you are
 hereby notified that any dissemination, distribution or
 copying of this communication is strictly prohibited.
 If you have received this communication in error, please
 re-send this communication to the sender and delete the
 original message or any copy of it from your computer
 system.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Daniel Curry
   INET: [EMAIL PROTECTED]

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

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED]  |
| http://bmcgraw.home.mindspring.com |
--


-- 
Please see the official ORACLE-L FAQ: 

Re: linux Oracle -- best combination

2001-08-21 Thread Scott

I believe that Oracle has decided that when porting to
linux all products will be ported to SuSE and then
perform post release certifications on Redhat. I
believe stability and support of multiple Linux
distributions was a factor in this decision. I run
both Redhat and SuSE and I actually perfer SuSE. SuSE
has a lot of packages it distributes with there
product. The only thing is the SuSE wont create ISO
images for download and Redhat will.

Scott


--- Brian McGraw [EMAIL PROTECTED]
wrote:
 Correct me if I'm wrong, but wasn't Red Hat Oracle's
 preferred Linux
 distribution, right up until the time they announced
 the availability of the Red
 Hat Database (PostgreSQL)?
 
 Brian
 
 Christopher Spence wrote:
 
  I would be curious to see these tests going
 forward, seeing as RedHat
  support is difficult to do with 9i and such.  And
 suse now being Oracle's
  perfered linux.  I wonder if these results have
 changed.  I never really
  played with Oracle on Linux, but if I ever had to,
 I would be curious.
 
  Do not criticize someone until you walked a mile
 in their shoes, that way
  when you criticize them, you are a mile a way and
 have their shoes.
 
  Christopher R. Spence
  Oracle DBA
  Phone: (978) 322-5744
  Fax:(707) 885-2275
 
  Fuelspot
  73 Princeton Street
  North, Chelmsford 01863
 
 
  -Original Message-
  Sent: Tuesday, August 21, 2001 1:53 PM
  To: Multiple recipients of list ORACLE-L
 
  Lisa and others,
 
   About a year ago, I was working for a company
 as a Linux systems
  engineer (Read as: Tech guy doing sales support). 
 Most of our customers
  wanted Linux systems, and it was my responsibility
 to provide them the
  correct combination of Linux and hardware to meet
 their needs.  I had an ISO
  9002 compliance to maintain as I provided testing
 and supporting data to our
  clients.
 
  My first test was RedHat linux 6.1 with Oracle
 8.1.5.  I don't have the
  benchmarks any more, but it worked the best.
 
  SCO Unix was bought by Caldera Linux and is not
 yet being implemented to the
  full capability (IMHO).
 
  Mandrake, SuSe, Storm were all tested as well, 
 And had less satisfactory
  performance and reliability.
 
  Slackware 7 was the next best solution, followed
 by TurboLinux 6.
 
  All of these configurations were tested on the
 same machine, completely
  formatted and the same installation performed on
 each test cycle.
 
  I hope this is helpful information.
 
  Daniel Curry
  Systems Administrator
  CGtime, Inc.
  625 Second Street
  Suite 201
  San Francisco, CA 94107
  ph: 415-348-6516
  fx: 415-348-6505
  cell: 510-304-7889
 
  -Original Message-
  Sent: Tuesday, August 21, 2001 9:36 AM
  To: Multiple recipients of list ORACLE-L
 
  Lisa
 
  SuSe is the best so I have been told. I am about
 to install 8i on 7.1 and
  another guy here is installing 9i on 7.2.
 
  Totally untested on my behalf as I haven't started
 yet but that is the best
  I have been told.
 
  Probably of no use whatsoever !!!
 
  Lee
  -Original Message-
  Sent: 21 August 2001 16:51
  To: Multiple recipients of list ORACLE-L
  Sorry everyone, I know you were just discussing
 this recently.
  What is the most stable combination of Oracle 
 Linux?  What would you
  recommend?  I want to say the consensus was SCO
 Linux but I don't quite
  remember.
  Thank you
  Lara Croft
  Oracle Database Administrator
  Fairfield Resorts, Inc
 
 
  The information contained in this communication is
 confidential, is intended
  only for the use of the recipient named above, and
 may be legally
  privileged. If the reader
  of this message is not the intended recipient, you
 are
  hereby notified that any dissemination,
 distribution or
  copying of this communication is strictly
 prohibited.
  If you have received this communication in error,
 please
  re-send this communication to the sender and
 delete the
  original message or any copy of it from your
 computer
  system.
  --
  Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
  --
  Author: Daniel Curry
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051 
 FAX: (858) 538-5051
  San Diego, California-- Public Internet
 access / Mailing Lists
 


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