RE: Linking to a SQL Server

[Weaver, Walt]

I have.

It works.

The steps:
1. Connect to Oracle.
2. Connect to SQL Server.
3. Transfer data, maybe using Perl. Or Python (this is for my buddy
Steve Orr).
4. If it doesn't work, contact a call center in India. They know
everything.

Generic connectivity is, indeed, supported on Linux. I'll bet it's
supported at Russel Athletic too.

Now, here's the hard part. Try to get up the balls to try it yourself. I
know it's hard, but I'll bet you can do it.

If you can't, spend some time watching old reruns of Mr. Roger's
Neighborhood.

--Walt (I've fallen down and can't get up) Weaver
  Bozeman, Montana
  On behalf of absolutely nobody but myself.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Shiva Maran
> Sent: Tuesday, November 25, 2003 11:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Linking to a SQL Server
> 
> 
> Hi All,
> 
>   Has any of you had an exprience in accessing SQL Server 
> data from Oracle database. I am woking on Oracle 9i on RH 
> Linux 9. Does it work?? If so can you please list the steps 
> that I need to try to do the same.
>   Also wanted to clarify if generic connectivity is supported 
> on Linux. Oracle documentation seems to have only examples on 
> Unix and NT.
> 
> Thanks
> ShivaM
> 
> DISCLAIMER: This e-mail contains proprietary information some 
> or all of which may be legally privileged.
> It is for the intended recipient only. If an addressing or 
> transmission error has misdirected this e-mail,
> please notify the author by replying to this e-mail. If you 
> are not the intended recipient, you must not use, 
> save, disclose, distribute, copy, print or relay this e-mail.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Shiva Maran
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing)
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  INET: [EMAIL PROTECTED]

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

RE: RE: Offshore protests

[Weaver, Walt]

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

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

RE: Re: Cary's book -- Out of stock !

[Weaver, Walt]

Title: Message



And 
don't forget the new Harry Potter book
 
--Walt 
Weaver
  
Bozeman, Montana

  
  -Original Message-From: David Wagoner 
  [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 
  2003 10:00 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Re: Cary's book -- Out of stock 
  !
  UPS just delivered my copy of Cary's book to the office!  
  Can't wait to read it, but first I plan to finish the books I'm currently 
  reading:
  - The Art and Science of Oracle Performance Tuning (Chris 
  Lawson) - Oracle SQL High-Performance Tuning (Guy 
  Harrison) 
  No telling when I'll get to finish Tom Kyte's new book, which 
  from the first couple dozen pages appears to be excellent.
  So many books, so little time... 
  Best regards, 
  David B. Wagoner Database 
  Administrator Arsenal Digital Solutions 

  -Original Message- From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, September 22, 2003 10:05 AM To: 
  Multiple recipients of list ORACLE-L Subject: Re: Re: 
  Cary's book -- Out of stock ! 
  what was the initial printing? 
  congrats Cary. Hope I can get a copy soon. > > From: Rachel Carmichael 
  <[EMAIL PROTECTED]> > Date: 2003/09/22 
  Mon AM 09:09:40 EDT > To: Multiple recipients of 
  list ORACLE-L <[EMAIL PROTECTED]> > 
  Subject: Re: Cary's book -- Out of stock ! > 
  > It's up to the publisher as to when they will 
  print more, Cary has no > control over that. 
  > > However... it apparently 
  never GOT to Amazon, as I had it on pre-order > 
  there, and it is still listed as "to be released" and not shipping :( 
  > > > --- Prem Khanna J <[EMAIL PROTECTED]> wrote: 
  > > Hi List, > > 
  > > I have placed an order for Cary's book 
  @bookpool. > > Does someone know when it will be 
  in stock ? > > > > 
  Can Mr.Cary Millsap let me know that ? > > 
  > > Regards, > > 
  Jp. > > > > 
  > > -- > > Please 
  see the official ORACLE-L FAQ: http://www.orafaq.net > > -- 
  > > Author: Prem Khanna J > >   INET: [EMAIL PROTECTED] > > > > Fat City Network 
  Services    -- 858-538-5051 http://www.fatcity.com > > San 
  Diego, California    -- Mailing list 
  and web hosting services > > 
  - 
  > > To REMOVE yourself from this mailing list, send an 
  E-Mail message > > to: [EMAIL PROTECTED] 
  (note EXACT spelling of 'ListGuru') and in > > 
  the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed 
  from).  You may > > also send the HELP 
  command for other information (like subscribing). > 
  > > 
  __ > Do you 
  Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use 
  web site design software > http://sitebuilder.yahoo.com > -- 
  > Please see the official ORACLE-L FAQ: http://www.orafaq.net 
  > -- > Author: Rachel 
  Carmichael >   INET: 
  [EMAIL PROTECTED] > > Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  > San Diego, 
  California    -- Mailing list and web 
  hosting services > 
  - 
  > To REMOVE yourself from this mailing list, send an 
  E-Mail message > to: [EMAIL PROTECTED] (note 
  EXACT spelling of 'ListGuru') and in > the message 
  BODY, include a line containing: UNSUB ORACLE-L > 
  (or the name of mailing list you want to be removed from).  You 
  may > also send the HELP command for other 
  information (like subscribing). > 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.net -- 
  Author: <[EMAIL PROTECTED]   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: Anyone have a copy of DUL ??

[Weaver, Walt]

Okay, okay, I'll check the archives.

--Walt 

> -Original Message-
> From: Richard Ji [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 18, 2003 3:20 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Anyone have a copy of DUL ??
> 
> See the original post which asked this question.
> 
> -Original Message-
> Sent: Thursday, September 18, 2003 4:50 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Which site?
> 
> I've been skimming over this thread and missed it.
> 
> Thanks,
> --Walt Weaver
>   Bozeman, Montana
> 
> > -Original Message-
> > From: Jared Still [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, September 18, 2003 2:25 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Anyone have a copy of DUL ??
> >
> > Yes, there are.
> >
> > The paper that explains the naming of X$ tables I
> > found to be particularly interesting.
> >
> > Jared
> >

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  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: Migration 9201 to 9203 doc needed

[Weaver, Walt]

Title: Migration 9201 to 9203 doc needed









Unless I’m really missing something,
going from 9.2.0.1 to 9.2.0.3 is just a patch install, and the README.html
included in the patch should tell you what you need to do.

 

--Walt Weaver

  
Bozeman, Montana

 



-Original Message-
From: Martin, Alan (Contractor)
(DLIS) [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 18, 2003
3:00 PM
To: Multiple recipients of list
ORACLE-L
Subject: Migration 9201 to 9203
doc needed

 

Does
anyone have the subject Metalink note? Oracle's gateway problems are preventing
access to ML. 

Thanx,

Alan Martin 
Defense Logistics Info Service

RE: Anyone have a copy of DUL ??

[Weaver, Walt]

Which site? 

I've been skimming over this thread and missed it.

Thanks,
--Walt Weaver
  Bozeman, Montana

> -Original Message-
> From: Jared Still [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 18, 2003 2:25 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Anyone have a copy of DUL ??
> 
> Yes, there are.
> 
> The paper that explains the naming of X$ tables I
> found to be particularly interesting.
> 
> Jared
> 
> On Thu, 2003-09-18 at 08:14, Pete Finnigan wrote:
> > Hi Juan,
> >
> > There are some interesting papers on the rest of this site as wqell
if
> > you scroll around the directories.
> >
> > kind regards
> >
> > Pete
> > --
> > Pete Finnigan
> > email:[EMAIL PROTECTED]
> > Web site: http://www.petefinnigan.com - Oracle security audit
> specialists
> > Book:Oracle security step-by-step Guide - see http://store.sans.org
for
> details.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Pete Finnigan
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
services
> >
-
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> 
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jared Still
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  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: Is Cary's new book shipping now?

[Weaver, Walt]

Title: Message









Aw, man, now that stupid “Annie”
song is gonna be running through my head for the rest
of the day.

 

Thanks a lot, Brian.

 

--Walt Weaver

   Bozeman, Montana

 



-Original Message-
From: Brian McGraw
[mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 16, 2003
9:20 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Is Cary's new book
shipping now?

 

I believe the official publication date is
09/17.

 

“Tomorrow, Tomorrow…
You’re only a Day Away”

 

Brian

 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mladen
Gogala
Sent: Tuesday, September 16, 2003 10:05
AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Is Cary's new book
shipping now?

 



September 2003.





 





 



--
Mladen Gogala
Oracle DBA 



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni,
Rajendra
Sent: Tuesday, September 16, 2003
10:44 AM
To: Multiple recipients of list
ORACLE-L
Subject: Is Cary's new book
shipping now?

Anyone know? Hotsos says
expected in 09/2003  Oreilly shows info as if it is shipping, bookpool
tells me my order is still partially out of stock.

Cary any ideas when it is
going to be published? 

Thanks 
Raj



Rajendra
dot Jamadagni at nospamespn dot com 
All
Views expressed in this email are strictly personal. 
QOTD:
Any clod can have facts, having an opinion is an art ! 





 





Note:





This message is for the named person's use only. 
It may contain confidential, proprietary or legally privileged
information.  No confidentiality or privilege is waived or lost by any
mistransmission.  If you receive this message in error, please
immediately delete it and all copies of it from your system, destroy any hard
copies of it and notify the sender.  You must not, directly or indirectly,
use, disclose, distribute, print, or copy any part of this message if you are
not the intended recipient. Wang Trading LLC and
any of its subsidiaries each reserve the right to monitor all e-mail
communications through its networks.  Any views expressed in this message
are those of the individual sender, except where the message states otherwise
and the sender is authorized to state them to be the views of any such entity.





 





 

RE: question about migrating to 9i

[Weaver, Walt]

Little tidbits I kind of like is setting a
default temporary tablespace and setting it in the
create database statement. You can also change the sys and system passwords in
the create database statement. Plus, you can create the undo tablespace there too.

 

I seem to be creating a lot of 9i
databases around here right now and that stuff comes in kind of handy.   :>)

 

--Walt Weaver

   Bozeman, Montana

 



-Original Message-
From: Ryan
[mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 09, 2003
3:59 PM
To: Multiple recipients of list
ORACLE-L
Subject: question about migrating
to 9i

 



Im not going to physically do the migration, but I want to
make sure certain features are set up. Let me know if Im missing any of the
basics(anything that is a pain to add on my own later). 





 





Locally Managed tablespaces are the default right? 





Automatic Segment Allocation





Undo Tablespace





SPFILE





 





any other goodies Im forgetting? Just basic settings. rest I
can do myself. 

RE: A basic replication question

[Weaver, Walt]

Well, that's what the users want.   :>)

But, due to the way our web hosting security is set up we can't do it.

--Walt

> -Original Message-
> From: Thater, William [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 03, 2003 11:49 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: A basic replication question
> 
> Weaver, Walt  scribbled on the wall in glitter crayon:
> 
> > Okay, we have a request for quite a few of our customers for
read-only
> > copies of their databases they can do their ad-hoc queries on. These
> > read-only databases need to as closely matched to the production
> > database as possible, i.e., exact, from their point of view.
> 
> can they use a read only login for it?  just set up a username with no
> quota
> and grant it select on the tables it needs.  or am i missing something
> here?
> 
> --
> Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  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).

A basic replication question

[Weaver, Walt]

Okay, we have a request for quite a few of our customers for read-only
copies of their databases they can do their ad-hoc queries on. These
read-only databases need to as closely matched to the production
database as possible, i.e., exact, from their point of view.

I've looked into some options to do this. Since we're going to 9i fairly
soon I was thinking of setting up logical standbys, but I've read some
pretty bad things about logical standbys -- typical new buggy Oracle
product.

I've also started into looking at basic replication: maybe just simple
updateable snapshots refreshed every now and then. 

So, for the past couple of days I've gone through Metalink, Technet, and
the mail archives on Oracle-l trying to learn about simple, basic,
readonly replication.

The problem is, all of the manuals, white papers, etc. I've found don't
deal with how to set up and administer simple basic replication. It's
all mixed in with multi-master replication, Advanced Replication, and
stuff like that.

I'm new to replication and would like to basically start learning the
basics for basic replication, basically.

Can anyone point me to a document that talks about basic read-only
replication only? Or am I fooling myself into thinking there is such a
thing?

Thanks,
--Walt Weaver
  Bozeman, Montana
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  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:

[Weaver, Walt]

Are you an idiot?

 



-Original Message-
From: Odland, Brad [mailto:[EMAIL PROTECTED]

Sent: Wednesday, August 20, 2003
9:21 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: 

 



Explaining what?





 





-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 19, 2003
8:09 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE:


Personally, I got tired of explaining it to newbies.





 
  
   
  
  
  "Eberhard, Jeff"
  <[EMAIL PROTECTED]> 
  Sent
  by: [EMAIL PROTECTED] 
   08/19/2003 03:54 PM 
   Please
  respond to ORACLE-L 
  
  
          
   
        To:        Multiple recipients of
  list ORACLE-L <[EMAIL PROTECTED]> 
   
        cc:         
   
        Subject:        RE:
  
 





whatever happened to "are you an idiot?"

-Original Message-
Sent: Tuesday, August 19, 2003 4:50 PM
To: Multiple recipients of list ORACLE-L



sorry, no help available. 




                Benny Pei
<[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED] 


08/19/2003 03:24 PM 
Please respond to ORACLE-L 


       
       To:        Multiple recipients
of list ORACLE-L
<[EMAIL PROTECTED]> 
       cc:         
       Subject:        



help

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Benny Pei
INET: [EMAIL PROTECTED]

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




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Eberhard, Jeff
 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: cursor_sharing in 8.1.7.4 - good or bad

[Weaver, Walt]

As a counterpoint, we’ve been using cursor_sharing=force in 8.1.7.4 on Linux for quite some
time now and with great success. I’d say it’s worth a try. The only
problem I’ve seen with cursor_sharing=force is
an incompatibility with certain processes in sqlloader,
but nothing we can’t work around. 

 

Cursor_sharing in 8.1.7.2 was a complete disaster on Linux, but they seem to have
gotten it working well in 8.1.7.4.

 

--Walt Weaver

  
Bozeman, Montana

 



-Original Message-
From: raju pa
[mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 19, 2003
1:49 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: cursor_sharing in
8.1.7.4 - good or bad

 



Hi,





  No. I recommend that you do not change cursor_sharing if you are
doing it just to get rid of 4031. There could be serious problems. ora-600
etc. Maybe Oracle has fixed everything in latest 817 but I suggest
not to take that chance.





  For 4031 you can do the following : pin pl/sql sql
preferably at startup, use bind variables and periodically check for sql not
using bind variables. Goodluck. 







"Fedock, John
(KAM.RHQ)" <[EMAIL PROTECTED]> wrote:









 





Does anyone have any experience using cursor_sharing in
8.1.7.4?    I feel I need to use it due to literal SQL
statements being used.  We have had misc 4031 errors off and on and I feel
this is my last hope.  I have a very busy OPFS server (HP-UX).  





 





I did try using cursor_sharing in 8.1.7.2, and I remember
incorrect sorting and other unexpected results happening.





 





Thanks for any input.





 





 





John





 





 



John
Fedock 
"K" Line America, Inc. 
www.kline.com  
*
[EMAIL PROTECTED]


 



 













Do you Yahoo!?
SBC
Yahoo! DSL - Now only $29.95 per month!

RE: 9i then 8i Installs

[Weaver, Walt]

Well, I'm on Linux, not Windows, but I installed 8.1.7 on a box running
9.2 a couple of weeks ago with no problems. Didn't do anything out of
the ordinary, just ran a plain ol' regular install.

--Walt Weaver
  Bozeman, Montana

> -Original Message-
> From: Jay [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 01, 2003 2:34 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 9i then 8i Installs
> 
> Hello:
> 
> I got an odd request today to install 8.1.7 on an existing server
which is
> running 9.2 (Windows 2000).
> Has anyone successfully been able to install Oracle 8.1.7 on the same
> Windows Server that already has 9.2 running?
> I know that if you install 8.1.7 then 9.2 both in different homes it
will
> work, but I have never seen it work where 9.2 was installed first.
> I have not been able to locate a test box yet and was wondering if it
is
> possible and if so if there are any pitfalls I should watchout for,
other
> then the standard Windows stuff
> 
> Thanks In advance,
> Jay
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jay
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  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: bad press for oracle....

[Weaver, Walt]

Title: bad press for oracle









Hasn’t he already settled once with
SCO? I read somewhere about SCO buying the license rights to some obscure
version of DOS and then suing Microsoft. There was some kind of settlement
made.

 

--Walt Weaver

  Bozeman, Montana

 



-Original Message-
From: Goulet, Dick
[mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 24, 2003 2:19
PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: bad press for
oracle

 



What the heck, why not.  Then Mr
Gates can figure out what to do about SCO.  Of cource, buy them as well!!!





 



Dick
Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 



-Original Message-
From: Gogala, Mladen
[mailto:[EMAIL PROTECTED]
Sent: Thursday, July 24, 2003 2:54
PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: bad press for
oracle



Microsoft is buying IBM?





 



Mladen
Gogala 
Oracle
DBA 
Phone:(203)
459-6855 
Email:[EMAIL PROTECTED]




-Original Message-
From: Goulet, Dick
[mailto:[EMAIL PROTECTED]
Sent: Thursday, July 24, 2003 2:29
PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: bad press for
oracle



Lets see, if memory is serving, Dial is
signing an IT outsourcing deal with EDS.  EDS & Oracle are NOT friends. 
EDS & IBM are.  Oracle apps do not run on DB2, SAP does.  SAP
& EDS are friends.  Do we see a connection there??





 



Dick
Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 



-Original Message-
From: Chris Stephens
[mailto:[EMAIL PROTECTED]
Sent: Thursday, July 24, 2003 12:50 PM
To: Multiple recipients of list
ORACLE-L
Subject: bad press for oracle

http://rss.com.com/2110-1017_3-5053453.html?type=pt&part=rss&tag=feed&subj=news


 

RE: Veritas NetBackup and RMAN on 9i

[Weaver, Walt]

Okay, unregard, I think. I finally got around to reading the Recovery
Manager Users Guide and things are unchanged from 8i. So, I'm missing
something on the Netbackup configuration side, methinks...

--Walt

> -Original Message-
> From: Weaver, Walt
> Sent: Wednesday, July 23, 2003 2:55 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Veritas NetBackup and RMAN on 9i
> 
> Anybody using NetBackup with RMAN on Oracle 9i?
> 
> I'm currently trying to configure NetBackup on a soon-to-be production
> 9i database and I guess things are a bit different than 8i as I can't
> find the libobk.so library anywhere.
> 
> At least that's what I think is going on.
> 
> If anyone (Ruth?) is doing this could you give me a push in the right
> direction as far as configuration is concerned?
> 
> I'm doing the RTFM thing right now but thought I might be able get
some
> quick information from the list...
> 
> Thanks,
> --Walt Weaver
>   Bozeman, Montana
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Weaver, Walt
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  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).

Veritas NetBackup and RMAN on 9i

[Weaver, Walt]

Anybody using NetBackup with RMAN on Oracle 9i?

I'm currently trying to configure NetBackup on a soon-to-be production
9i database and I guess things are a bit different than 8i as I can't
find the libobk.so library anywhere.

At least that's what I think is going on.

If anyone (Ruth?) is doing this could you give me a push in the right
direction as far as configuration is concerned?

I'm doing the RTFM thing right now but thought I might be able get some
quick information from the list...

Thanks,
--Walt Weaver
  Bozeman, Montana
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  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: Recent reports on outages caused by DB2 and 9iRAC issues

[Weaver, Walt]

Title: RE: Recent reports on outages caused by DB2 and 9iRAC issues









He-he. I stil have my SAC shoulder patch –
a mock of one – with that phrase and it shows a fist holding a pair of –
well Dick, you have one too, I’ll bet.  
:>)

 

--Walt Weaver

  Former KC-135 puke

 



-Original Message-
From: Goulet, Dick
[mailto:[EMAIL PROTECTED] 
Sent: Friday, July 18, 2003 12:35
PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Recent reports on
outages caused by DB2 and 9iRAC issues

 



Raj,





 





    My previous boss's
attitude was:





 





    To error is Human.





    To forgive is not SAC
policy.





 





SAC= Starategic Air Command.





 



Dick
Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]
Sent: Friday, July 18, 2003 2:00
PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Recent reports on
outages caused by DB2 and 9iRAC issues

Dick,


we don't
share the same boss ... do we? 
Raj 


Rajendra dot Jamadagni at
nospamespn dot com 
All Views expressed in this email
are strictly personal. 
QOTD: Any clod can have facts,
having an opinion is an art ! 

 

-Original
Message- 
From: Goulet, Dick [mailto:[EMAIL PROTECTED]] 
Sent: Friday, July 18, 2003 1:39 PM

To: Multiple recipients of list
ORACLE-L 
Subject: RE: Recent reports on
outages caused by DB2 and 9iRAC issues 

 

I prefer
my bosses attitude on the subject of mistakes: 
Admit that you did it & then go
fix it.  We'll crucify you later, if we have the time. 
For some reason, known only to the
Devil himself, they never find the time. 

RE: LISTENER ON LINUX

[Weaver, Walt]

That's because it's truncating the line. Try ps -eflll instead.

--Walt Weaver
  Bozeman, Montana

> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf
Of
> > Seema Singh
> > Sent: Friday, July 11, 2003 17:20
> > To: Multiple recipients of list ORACLE-L
> > Subject: LISTENER ON LINUX
> >
> >
> > Hi
> > When I try to see listener process on Linux box by ps -ef
> > |grep tns .It
> > doen't show but when I tried to see the status thru lsnrctl status
> > listener_name .its shows service handler.
> > How to check whether listener is running or not and how to start
that?
> > thx
> > -seema
> >
> > _
> > STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
> > http://join.msn.com/?page=features/junkmail
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Seema Singh
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
services
> >
-
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Grant Allen
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  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: Tech meetings

[Weaver, Walt]

Hey Jeff, just out of curiousity, do you guys all get company cars?

--Walt Weaver
  Bozeman, Montana

> -Original Message-
> From: Eberhard, Jeff [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 09, 2003 10:35 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Tech meetings
> 
> When I first began working here years ago we had a scheduled lunch
> meeting/training every Friday for the IS Department.  Lunch was
provided
> and
> someone was given the task to present some technical topic.  A lot of
> times
> it was watching a training video, such as a training video for Visual
> Basic.
> Eventually it died because the guy scheduling the meetings had left
the
> company.  Every once in a while we try to resurrect the "Weekly
Training
> Meeting".  My current boss (which was an employee turned manager)
wants to
> have the meetings but doesn't want to provide the lunch.  Guess what?
No
> one shows up after the first meeting.  It's amazing what an incentive
a
> little bit of food is.
> 
> --Jeff
> 
> -Original Message-
> Sent: Wednesday, July 09, 2003 1:39 AM
> To: Multiple recipients of list ORACLE-L

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  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: ER Tools (was: erwin)

[Weaver, Walt]

Last time we purchased ERWin (a number of years ago in a previous life)
it was around $4k, IIRC.

You might want to check out ER Studio by Embarcadero, although it's not
cheap either.

--Walt Weaver
  Bozeman, Montana

> -Original Message-
> From: Jesse, Rich [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 07, 2003 1:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: ER Tools (was: erwin)
> 
> Anyone care to ballpark a $$$ on the registered version of ERwin?  I'm
> guessing it's expensive, and Computer ASSociates doesn't exactly trip
my
> trigger.
> 
> I'm trying to find a low-cost ER tool in order to get some simple data
> modeling done.  So far, this is what I've found (VERY briefly):
> 
> 1)  Visio.  Needs Enterprise edition.  The UI is a pain, as far as I'm
> concerned.  Pain, pain, pain.  Cheapest viable option so far at less
than
> $500/user.  It can be used for more than just data modeling.
> 
> 2)  Oracle 9iDS.  Hugely bloated.  Relies on a 3GB (minimum)
repository
> for
> some stupid reason.  Apparently can't buy just Designer, which is all
we
> need.  Difficult to get started (concepts and management of workspace,
> container).  Slow on a 2.4Ghz PC w/512MB RAM, although this may be due
to
> me
> having to create the [EMAIL PROTECTED] repository DB on the same PC.  Very
> comprehensive, though, from what I've seen.  Can't access drawings
from
> the
> OS, since they're (probably) in the repository.
> 
> 3)  No freeware tools such as dia, VisioModeler (pre-MS version of
Visio),
> OpenOffice, or Koffice seemed to be able to draw crow's foot diagrams.
> 
> 4)  Sybase PowerBuilder.  Didn't check out the download yet, although
a
> demo
> of an older version (v6) seems like it would work.  Not impressed with
> Sybase in general and it's probably in the $1Ks/user.
> 
> 5)  Data Architect from TheKompany.com only does physical modelling
and
> their Kivio product doesn't seem to support crow's foot.
> 
> 6)  DeZign from datanamic.com.  Haven't downloaded the demo yet, but
the
> single screenshot looks promising.  And at $149/user or $119/user for
10
> licenses, I'm hoping...
> 
> I've been looking thru past messages found on orafaq.com (better
searching
> than fatcity.com) and this is the majority of what I've been able to
find.
> Anyone have more to add?
> 
> Rich
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
> 
> 
> > -Original Message-
> > From: Jay Wade [mailto:[EMAIL PROTECTED]
> > Sent: Monday, July 07, 2003 9:49 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: erwin
> >
> >
> > hello:
> >
> > The below has info about the product:
> > http://www3.ca.com/Solutions/Product.asp?ID=260
> >
> > The below has the download link:
> > http://www3.ca.com/Solutions/Collateral.asp?CID=33655&ID=260
> >
> >
> >
> > >From: <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > >Subject: erwin
> > >Date: Mon, 07 Jul 2003 04:54:25 -0800
> > >
> > >How can I found a trial version of erwin
> > >
> > >Danke...
> > >Arslan.
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  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: LINUX instance startup problem

[Weaver, Walt]

What version of Red Hat?

--Walt

> -Original Message-
> From: Seema Singh [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 03, 2003 1:09 PM
> To: Multiple recipients of list ORACLE-L
> Subject: LINUX instance startup problem
> 
> Hi,
> I'm having problem during startup of instance on LINUX.I have oracle
8.1.7
> on red hat.
> When I start instance it try to come upto  this below lines
> background_dump_dest =
> user_dump_dest   =
> core_dump_dest   =
> 
> after that I'm getting following message
> SVRMGR> connect internal;
> Connected.
> SVRMGR> startup;
> ORA-03113: end-of-file on communication channel
> SVRMGR> connect internal;
> Password: ORA-03113: end-of-file on communication channel
> SVRMGR>
> When I see semaphore and shared memory.Its locked.I'm unable to get
into
> server manager without killing all shared mem process.
> Let me know how to fix this problem pl
> thx
> -seema
> 
> _
> MSN 8 with e-mail virus protection service: 2 months FREE*
> http://join.msn.com/?page=features/virus
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  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: ORA-04031

[Weaver, Walt]

What patch level of 8.1.7 are you on??

--Walt


> --- "Schauss, Peter" <[EMAIL PROTECTED]> wrote:
> > One of our third party applications gave us the
> > following message:
> >
> > ORA-04031: unable to allocate 4192 bytes of shared
> > memory
> >
> > Environment is Oracle 8.1.7 on AIX 4.3.2
> >
> > The output from "select * from v$sgastat showed
> > about 3 mb free
> > out of a total of 40 mb of shared pool.  I increased
> > the
> > size of shared pool to 60 mb and started to watch
> > the
> > "shared pool"/"free memory" value in v$sgastat.  It
> > seems to vary
> > between about 3 and 11 mb.
> >
> > 1.  What is the application likely to be doing that
> > requires it to
> > allocate shared pool?
> >
> > 2.  How do I know when I have the shared pool value
> > in init.ora set high
> > enough so that I won't get the ORA-04031 errors?
> >
> > 3.  Is there any other init.ora parameter I ought to
> > be looking at here?
> >
> > Thanks,
> > Peter Schauss
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > --
> > Author: Schauss, Peter
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California-- Mailing list and web
> > hosting services
> >
> -
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
> 
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jose Luis Delgado
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> ---------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  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: MySQL in the future?

[Weaver, Walt]

I'll second Tim's choices. Got both books and they're excellent.

BTW, I got the MySQL Cookbook at the Rocky Mountain Oracle Users Group
Conference.   :>)

--Walt Weaver
  Bozeman, Montana

> -Original Message-
> From: M Rafiq [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 19, 2003 10:10 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: MySQL in the future?
> 
> Tim,
> 
> Thanks
> Regards
> Rafiq
> 
> 
> 
> 
> Date: Thu, 19 Jun 2003 02:24:39 -0800
> 
> On Wed, Jun 18, 2003 at 09:10:39AM -0800, M Rafiq wrote:
>  > Tim,
>  > May be a an off-topic question to you or anybody who can answer.
>  >
>  > What is the best source / books to learn mysql quickest possible
> without
>  > too much cost to an individual?
> 
> The online docs are good:
>http://www.mysql.com/doc/en/index.html
> 
> For dead trees, these are good:
>http://www.amazon.com/exec/obidos/tg/detail/-/0735712123
>http://www.amazon.com/exec/obidos/tg/detail/-/0596001452
> 
> Tim.
> 
>  > I am asking this because in my recent job search I found couple of
good
>  > companies are also using mysql.
>  >
>  > Regards
>  > Rafiq

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  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: MySQL in the future?

[Weaver, Walt]

We've been using MySQL extensively for three years now and haven't seen
any of this kind of behavior. In fact, MySQL AB has been very enjoyable
to work with and we've been able to bend their ear to put features into
MySQL that we'd like to have. And, as Tim Bunce says, we've found their
support to be excellent. 

We pay a certain amount for licensing fees and support, but it's
miniscule compared to the Oracle licenses we have to pay for.

--Walt (an Oracle bigot, but pretty impressed with MySQL) Weaver
  Bozeman, Montana

> -Original Message-
> From: Goulet, Dick [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 19, 2003 8:13 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: MySQL in the future?
> 
> I think we've all seen and are once again seeing a similar maneuver.
Can
> you get MySql from mysql.org, sure but it's going to be left way in
the
> dirt by MySql AB until their version is the only acceptable one out
there.
> Course by then it probably will acquire a different name. and of
course a
> higher price tag.  Only the lawyers win!!!
> 
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
> 
> -Original Message-
> Sent: Wednesday, June 18, 2003 11:35 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I'm glad I'm not a lawyer. What does distribute internally mean? I
work
> for company X and write an application to use a MySQL database. I take
the
> zip file I downloaded from MySQL and install it to another server, and
now
> two sets of people are using the database on different machines with
the
> same application. Does that mean I distributed it internally?
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  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: ??? Linux/Oracle 8.1.7 2GB file size limit ???

[Weaver, Walt]

FWIW, we use 2048m here. 

--Walt (who feels obligated to make some posts since Steve's off today) Weaver
  Bozeman, Montana

> -Original Message-
> From: Jared Still [mailto:[EMAIL PROTECTED]
> Sent: Sunday, June 08, 2003 11:00 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???
> 
> 
> 
> Just curious how you arrived at the 1900 meg number.
> 
> Why not use 2000m?
> 
> Oracle defines gigabytes in binary, not decimal as
> drive mfg's do, so 2000m would be fine.
> 
> Not a criticism, just wondering.
> 
> Jared
> 
> On Sunday 08 June 2003 09:29, Yechiel Adar wrote:
> > We have been hit by a bug in autoextend that corrupted a 
> database (8.1.6)
> > on NT.
> > It seems that the bug was exported to Linux as well.
> >
> > We now use all datafiles with autoextend up to 1900 MB.
> > We also define a second datafile with 200MB initial and 
> autoextend to 1900
> > MB.
> > Whenever the last datafile starts to grow we define a new 
> one with 200MB
> > etc.
> >
> > Seems to work so far.
> >
> > Yechiel Adar
> > Mehish
> > - Original Message -
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Sent: Wednesday, June 04, 2003 5:40 PM
> >
> > > I've just been informed that there is a 2GB datafile size 
> limit with
> >
> > Oracle 8.1.7 on Linux... PERIOD. This despite the fact that 
> we've had files
> > in excess of this for some time and they work just fine. 
> The problem occurs
> > when the autoextend "feature" reaches the 2GB threshhold. 
> Of course, Oracle
> > didn't tell me this until after about 4 days of back and 
> forth testing for
> > them. (There is no such O/S file size limit.) I've reviewed 
> the Linux
> > release notes, the Linux install guide, the Linux admin 
> guide and the
> > contents of $ORACLE_HOME/relnotes and I don't find any such 
> limitation in
> > the documentation. Did I miss it? Can anyone find any such published
> > limitation in the docs? Is this a secret?
> >
> > > Peeved at Oracle... AGAIN,
> > > Steve Orr
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Orr, Steve
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 
> http://www.fatcity.com
> > > San Diego, California-- Mailing list and web 
> hosting services
> > > 
> -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 
> 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed 
> from).  You may
> > > also send the HELP command for other information (like 
> subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jared Still
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  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: 10i

[Weaver, Walt]

Too late, Stephen. Everyone knows about the GUI button now. Word's out.

--Walt

> -Original Message-
> From: Karniotis, Stephen [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 29, 2003 3:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: 10i
> 
> 
> OK everyone.  Traffic cop time.  Everyone that is a beta 
> partner for 10i
> MUST KEEP THEIR MOUTH SHUT.  Don't get anyone in trouble, 
> please.  We as
> partners pushed Oracle for these beta programs.  
> Conversations like this
> only hurt the process.
> 
> Thank You
> 
> Stephen P. Karniotis
> Product Architect
> Compuware Corporation
> Direct:   (248) 865-4350
> Mobile:   (248) 408-2918
> Email:[EMAIL PROTECTED]
> Web:  www.compuware.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  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: linux intel support matrix

[Weaver, Walt]

They make you work in the afternoon

--Walt Weaver
  Bozeman, Montana

> -Original Message-
> From: bill thater [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 04, 2003 2:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: linux intel support matrix
> 
> 
> [EMAIL PROTECTED] wrote:
> > Bill,
> >  Welcome back!!! I haven't read you in a long time. Hope 
> all is well.
> > Ron
> 
> just got a 3 month contract after being out of work since the end of 
> june.  guess that's the end of my afternoon naps, and my 
> afternoon beer, 
> for a while.;-)
> 
> -- 
> --
> Bill "Shrek" Thater  ORACLE DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  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: Oh Dear, Mr. Ellison's at it again

[Weaver, Walt]

 I thought the same thing. Being the hubristic person that he is I doubt he will 
ever think about it himself...

--Walt Weaver
  Bozeman, Montana

> -Original Message-
> From: Goulet, Dick [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 02, 2003 11:45 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Oh Dear, Mr. Ellison's at it again
> 
> 
> Wonder if anyone has clued him into MySql and PostGreSql yet!!
> 
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA 
> -- 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  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: Usage of mySQL in enterprise environments

[Weaver, Walt]

Title: RE: Usage of mySQL in enterprise environments





We're a big user of MySQL here and I wouldn't compare it to MS Access any more than I would compare Oracle to MS Access. MySQL has made great strides in the last couple of years and once InnoDB matures a bit it'll add a lot of features that MySQL currently lacks, like transaction processing. 

Postgres is definitely more "Oracle-like" and we looked into it as a possible replacement for MySQL but stuck with MySQL for performance reasons (although some of the performance problems we had with Postgres might have been self-inflicted -- I won't go into details).

BTW, hot backups and roll-forward are, indeed, available with MySQL. We're also using MySQL's replication feature with great success.

I wouldn't be surprised if, in a couple of years, we drop Oracle completely and go 100% MySQL. Oracle's ridiculous pricing schemes and general lack of response to customers (or at least us) have frustrated us no end. Once MySQL/InnoDB matures a bit we'll have no reason to waste money on Oracle.

--Walt Weaver
  Bozeman, Montana


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 18, 2003 7:14 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re:Usage of mySQL in enterprise environments
> 
> 
> Hemant,
> 
> MySql is akin to M$ Access.  Use it accordingly for 
> things that can be lost
> forever without damage.  Seriously in a MySql database each 
> schema is a
> subdirectory of where they put the database main directory.  
> That point is not a
> negotiable item either, it's in /var/mysql (if memory 
> serves).  Then each table
> and index become separate files within the subdirectory.  
> Backup is COLD only
> and while Immodb does handle transactional data there is no 
> such thing as roll
> forward and the table(s) have to be specifically configured 
> to use it.  Also it
> is NOT free but close thereto ($549 per server at last look see).  
> 
> In my opinion a better choice is PostGreSql 
> (www.postgresql.org).  It's a
> totally free download, comes in RPM's which makes install so 
> much easier, can do
> a "hot backup" or more likely an export, is totally 
> transactional, the database
> directory is an environment variable so you can put it 
> anywhere.  An it's speed
> is comparable to MySql, but it does stored 
> functions/procedures, etc...  Much
> more like Oracle, but not exactly the same.  For a zero cost 
> database I find it
> very nice.  Heck it even comes with a TOAD like (close, but 
> way no cookie) query
> tool!!
> 
> Dick Goulet
> 
> Reply Separator
> Author: Hemant K Chitale <[EMAIL PROTECTED]>
> Date:   3/18/2003 3:03 AM
> 
> 
> I've been asked to consider whether we can use
> mySQL for non-critical, but probably, enterprise-wide
> databases [e.g. information stores].
> 
> How good is the feedback on mySQL handling Queries,
> Transactions, ConcurrentUserCounts and DatabaseSize ?
> 
> Hemant K Chitale
> http://hkchital.tripod.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Hemant K Chitale
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California    -- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: 
>   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: OTC: Perl Book

[Weaver, Walt]

Title: RE: OTC:  Perl Book





Perl for Oracle DBAs is a good one. I picked one up at RMOUG.


It's so good I've put down the Harry Potter book I was reading.


--Walt Weaver
  Bozeman, Montana


> -Original Message-
> From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 13, 2003 8:44 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: OTC: Perl Book
> 
> 
> Jared Still, the list owner, has one out:
> 
> Perl for Oracle DBAs from O'Reilly press
> 
> 
> --- Jeffrey Beckstrom <[EMAIL PROTECTED]> wrote:
> > Looks like I have a need write a Perl program to access a database. 
> > Any suggestions on a good book.
> > 
> > 
> > 
> > Jeffrey Beckstrom
> > Database Administrator
> > Greater Cleveland Regional Transit Authority
> > 1240 W. 6th Street
> > Cleveland, Ohio 44113
> > (216) 781-4204
> > 
> 
> 
> __
> Do you Yahoo!?
> Yahoo! Web Hosting - establish your business online
> http://webhosting.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Rachel Carmichael
>   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: POLL: Database to DBA ratio

[Weaver, Walt]

Title: RE: POLL: Database to DBA ratio





We have 4 production Oracle databases and 3 DBA's. 


Of course, we have additional duties as well. I spend many afternoons out at the airport as a baggage handler for Horizon Airlines.

--Walt Weaver
  Bozeman, Montana


> -Original Message-
> From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 12, 2003 11:59 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: POLL: Database to DBA ratio
> 
> 
> We have over 400 databases,  90%+ are Oracle under various 
> versions, platforms. 
> 
> Today have 19 DBAs. Two weeks from now there will be 17. 
> 
> Rightsizing to continue in the 2nd Quarter 
> 
> - Kirti 
> 
> -Original Message-
> Sent: Wednesday, March 12, 2003 12:09 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> We have 7 DBAs.  105 production databases (97 24x7), ranging 
> from 2 GB OLTP
> to 800 GB data warehouses.  395 devl/alpha/beta databases 
> ranging in size
> from very small (1 GB) to production-sized.  About 1/3 of the 
> production
> databases have at least 1 (usually more) development effort 
> going on at any
> given time.
> 
> Most of our time (lives?) is spent just keeping things up and 
> running.  The
> on-call guy averages between 50 to 100 pages per week (record 
> is in the
> 230-range).  Tuning and testing new stuff is fairly uncommon 
> - as we have
> time.
> 
> 
>   
> 
>   
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Deshpande, Kirti
>   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: "Take Care of your DBAs"

[Weaver, Walt]

Title: RE: "Take Care of your DBAs"





Hey Rick, is it snowing up in Helena?


It's been raining here in Bozeman. RAINING! Like it's July or something.


Some guys I work with drove up around Selkirk last weekend to go skiing. It rained two inches on Sunday there, so they said the hell with it and drove back to go skiing at Bridger Bowl. Hope it's not raining there today.

The Pacific Decadal Oscillation sucks, man.


--Walt Weaver
  Bozeman, Montana


-Original Message-
From: Weiss, Rick [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 30, 2003 9:56 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: "Take Care of your DBAs"



You ought to see what happens in Phoenix when it rains. Wrecks, traffic
snarls, yuck. It must be the fact that they never see anything remotely
resembling water (except in pools).


Oh yeah, that's right. I left there years ago for Montana.


Never mind. Snow, rain, four seasons. This is living


Rick Weiss


-Original Message-
Sent: Thursday, January 30, 2003 9:01 AM
To: Multiple recipients of list ORACLE-L



You gentlemen do not know what it is like to have snow related traffic
problems. In Atlanta a snow flake can cause a multi-car pileup with a 3 hour
commute delay. Why just having cold weather (20 degrees F) will cause
schools to close. Boy I miss New England. Transplanted CT Yankee, Ron


>>> [EMAIL PROTECTED] 01/30/03 10:09AM >>>


> 
> It's nice to have four seasons.
> 


As long as the temperature doesn't drop under 60 during any of those four
seasons. Four feet of snow? Here in CT, we had few inches and the traffic
collapsed. What do you drive? Sherman tank?
-- 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weiss, Rick
  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: Americas Cup

[Weaver, Walt]

Title: RE: Americas Cup



I 
thought Lutz owns an L-39. I was told this by a local pilot who just bought an 
L-39.
 
There 
are MIG 15's, 17's, and 21's in the U.S. but I wasn't aware of any 
Foxbats.
 
--Walt

  -Original Message-From: Igor Neyman 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003 1:55 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  Americas Cup
  There are lots of MIG25 in this country.
  GM's VP Lutz is flying one.
   
  Igor Neyman, OCP DBA[EMAIL PROTECTED]  
  
   
   
  
- Original Message ----- 
    From: 
Weaver, 
Walt 
To: Multiple recipients of list ORACLE-L 

Sent: Monday, January 20, 2003 3:24 
PM
Subject: RE: Americas Cup

Did he finally get it? Last I heard U.S. Customs wouldn't let him 
bring it in the country.

  -Original Message-From: Gogala, Mladen 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003 12:50 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Americas Cup
  Well, Larry Ellison allegedly has MiG 25 which is 
  an interceptor airplane
  armed to blow other airplanes out of the sky. It 
  doesn't have any weapon
  system to sink a ship. He should purchase 
  few F-16 and A-10 planes. 
  Those can be used against ships.  Speaking 
  of the race, allegedly those GPS 
  navigation systems they use in the modern yachts 
  are running SQL Server. 
  Larry couldn't have won with a 
  software like that. 
  
    -Original Message-From: Weaver, Walt 
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003 
1:05 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Americas Cup
Well, I guess now he can use the boat for target 
practice when he's flying around in his fighter jet... 
--Walt Weaver   Bozeman, 
Montana 
-Original Message- From: 
Fowler, Kenneth R [mailto:[EMAIL PROTECTED]] 
Sent: Monday, January 20, 2003 10:09 AM 
To: Multiple recipients of list ORACLE-L 
Subject: Americas Cup 
Larry Ellison has spent 95 million (US) attempting to 
become the challenger to Team New Zealand for 
the Americas Cup.  Unfortunately did not make the grade... 
http://www.stuff.co.nz/stuff/sundaystartimes/auckland/0,2106,2204857a6469,00 
.html 
Ken _ Clinical and Regulatory Informatics - Groton/New London 
Coordinator, Business and Technical Services 
Tel: (860) 732-0026 Fax: (860) 715-8346 
Email: mailto:[EMAIL PROTECTED] 

LEGAL NOTICE Unless expressly 
stated otherwise, this message is confidential and may be privileged. It 
is intended for the addressee(s) only. Access to this E-mail by anyone 
else is unauthorized. If you are not an addressee, any disclosure or 
copying of the contents of this E-mail or any action taken (or not 
taken) in reliance on it is unauthorized and may be unlawful. If you are 
not an addressee, please inform the sender immediately.
-- Please see the official 
ORACLE-L FAQ: http://www.orafaq.net -- Author: Fowler, Kenneth R 
  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: Americas Cup

[Weaver, Walt]

Title: RE: Americas Cup



Did he 
finally get it? Last I heard U.S. Customs wouldn't let him bring it in the 
country.

  -Original Message-From: Gogala, Mladen 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003 12:50 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Americas Cup
  Well, Larry Ellison allegedly has MiG 25 which is an 
  interceptor airplane
  armed to blow other airplanes out of the sky. It 
  doesn't have any weapon
  system to sink a ship. He should purchase 
  few F-16 and A-10 planes. 
  Those can be used against ships.  Speaking of 
  the race, allegedly those GPS 
  navigation systems they use in the modern yachts are 
  running SQL Server. 
  Larry couldn't have won with a software 
  like that. 
  
-Original Message-----From: Weaver, Walt 
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003 1:05 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Americas Cup
Well, I guess now he can use the boat for target practice 
when he's flying around in his fighter jet... 
--Walt Weaver   Bozeman, 
Montana 
-Original Message- From: 
Fowler, Kenneth R [mailto:[EMAIL PROTECTED]] 
Sent: Monday, January 20, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Subject: Americas Cup 
Larry Ellison has spent 95 million (US) attempting to become 
the challenger to Team New Zealand for the Americas 
Cup.  Unfortunately did not make the grade... 
http://www.stuff.co.nz/stuff/sundaystartimes/auckland/0,2106,2204857a6469,00 
.html 
Ken _ Clinical and Regulatory Informatics - Groton/New London 
Coordinator, Business and Technical Services 
Tel: (860) 732-0026 Fax: (860) 715-8346 Email: mailto:[EMAIL PROTECTED] 

LEGAL NOTICE Unless expressly stated 
otherwise, this message is confidential and may be privileged. It is 
intended for the addressee(s) only. Access to this E-mail by anyone else is 
unauthorized. If you are not an addressee, any disclosure or copying of the 
contents of this E-mail or any action taken (or not taken) in reliance on it 
is unauthorized and may be unlawful. If you are not an addressee, please 
inform the sender immediately.
-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.net -- Author: Fowler, Kenneth R   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: Americas Cup

[Weaver, Walt]

Title: RE: Americas Cup





Well, I guess now he can use the boat for target practice when he's flying around in his fighter jet...


--Walt Weaver
  Bozeman, Montana


-Original Message-
From: Fowler, Kenneth R [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L
Subject: Americas Cup



Larry Ellison has spent 95 million (US) attempting to become the challenger
to Team New Zealand for the Americas Cup.  Unfortunately did not make the
grade...


http://www.stuff.co.nz/stuff/sundaystartimes/auckland/0,2106,2204857a6469,00
.html


Ken
_
Clinical and Regulatory Informatics - Groton/New London
Coordinator, Business and Technical Services
Tel: (860) 732-0026 Fax: (860) 715-8346
Email: mailto:[EMAIL PROTECTED]




LEGAL NOTICE
Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Fowler, Kenneth R
  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: Happy Holidays!!

[Weaver, Walt]

Title: RE: Happy Holidays!!





Perhaps you're thinking of Guy Ruth Hammond.


--Walt Weaver
  Bozeman, Montana


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 20, 2002 1:38 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Happy Holidays!!




I have never met RUTH and I apologize in advance if I am wrong but I
thought I remember a post long ago indicating Ruth G is male?
Again a big oops if incorrect.





    
    Rachel  
    Carmichael   To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>    
    
    ahoo.com>    Subject: RE: Happy Holidays!!  
    Sent by:    
    [EMAIL PROTECTED]  
    om  
    
    
    12/20/2002  
    02:28 PM    
    Please respond  
    to ORACLE-L 
    
    





from this list:


Ruth Gramolini and April Wells are going, they are presenting.


I don't know if I am presenting or not, I was accepted as an alternate
and today is the cutoff for the speakers to confirm they are going. But
I'll be there whether or not I present



--- [EMAIL PROTECTED] wrote:
> No offense guys, but having only small boy children (whom I love
> dearly),
> working in a 90% male IT support organization (cause I like men) -
> can't
> help feeling like what I really need now is some good woman friends -
> preferably ones that both work and are raising children.  Are any of
> them
> going to IOUG?
>
> -Original Message-
> Sent: Friday, December 20, 2002 11:40 AM
> To: Multiple recipients of list ORACLE-L
>
>
> from what Jared tells me, in the first 50 names on the list
> (alphabetical>?) he found 11 out of 50 names that were obviously
> female
> first names.
>
> not the best statistic (1/5 of an admittedly small sample). but
> better
> than it was a few years ago. What I really like seeing is that more
> and
> more women are answering questions here as well
>
>
> --- Lisa Corell Auerbach <[EMAIL PROTECTED]> wrote:
> > Hi Rachel - you wrote -
> >
> > > I'm more interested in the numbers to see if this field is less
> > male-centric than others.
> > >
> >
> > I don't post very often, but I'm another in the orawoman category.
> >
> > Lisa
> > (now the DBA at Henrico County Public Schools)
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Lisa Corell Auerbach
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> > San Diego, California    -- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> >
>
>
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rachel Carmichael
>   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
> th

RE: Happy Holidays!!

[Weaver, Walt]

Title: RE: Happy Holidays!!





At this point of the discussion I'd just like to come out of the closet and let everyone know that I am, indeed, 100% male.

Thanks,
--Walt Weaver
  Bozeman, Montana


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 20, 2002 8:35 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Happy Holidays!!




Rachel,


I suspect that there are many more than ten female subscribers to the list.


However, I'd have to agree that there are at least a dozen women who post
somewhat regularly.


Going to our local Oracle User's Group meeting, there are about 25% women
in attendance at the meeting when I look over the crowd.   I'm seeing a lot
more young women at the meetings lately.


Cherie Machler
Oracle DBA
Gelco Information Network



    
    Rachel  
    Carmichael   To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>    
    
    ahoo.com>    Subject: Re: Happy Holidays!!  
    Sent by:    
    [EMAIL PROTECTED]  
    om  
    
    
    12/20/02 08:04  
    AM  
    Please respond  
    to ORACLE-L 
    
    





I'm sure if Jared had time, energy or inclination, he could do a guess
from the membership list. However, some names are not intuitively
obvious as to gender.


Not counting lurkers, since I can't tell who they are, I think there
are at least 10 women on the list


I'm more interested in the numbers to see if this field is less
male-centric than others.



--- "Panicker, Thankam S." <[EMAIL PROTECTED]> wrote:
> Thanks to all for responding to my post on Oracle and Peoplesoft. I
> will be
> making the move this
> New Year. I wish I had found out about this List earlier. It is great
> to see
> people sharing their knowledge.
> Happy Holidays to every one!!
>
> Rachael, I have all my shopping done and gifts packed. :-)
> Wish we had a count of our kind on the list.(You know - orawoman
> kind.)
>
> Sumathy
>
>
>
>
> -Original Message-
> Sent: Thursday, December 19, 2002 11:35 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> I would agree with Joan  - we spend lots of time refreshing databases
> here.
> We were responsible for all of the application servers, web servers,
> process schedulers, etc. until a technical architecture team was
> formed.
> That has helped tremendously since my team can concentrate on the
> Oracle
> side. We have a very large Peoplesoft Financials environment here
> (along with HR and budgets) so we have lots to keep busy with and
> opportunities to use additional Oracle functionality (we have a large
> replicated environment, use lots of partitioning, etc) . I would
> also
> recommend you at least take a PeopleTools course or one of the
> administration courses mentioned by Joan so you understand how
> Peoplesoft
> stores and uses metadata.    As far as book recommendations the only
> decent
> book that I have is the "Peoplesoft Administrator's Guide" by Darrell
> Bilbrey which is good for someone new to Peoplesoft.  We really
> do most
> of the normal functions that any DBA would do regardless of
> Peoplesoft.
> Database still has to be backed up, tuned, and maintained like any
> other
> Oracle database - I consider myself to be an Oracle/Peoplesoft DBA,
> not a
> Peoplesoft/Oracle DBA if that helps you any.
>
> You will also learn to hate PS Query if your users have ad-hoc query
> access.    :-)
>
> John Dailey
> Oracle DBA
> ING Americas - Application Services
> Atlanta, GA
>
>
>
>
>
>
>
>
>
>
>   "Joan Hsieh"
>
>   

RE: STATSPACK

[Weaver, Walt]

Title: RE: STATSPACK



Ayup. 
I go to the store every Friday afternoon and pick up a statspack of Stroh's 
Lite.
 
--Walt 
Weaver
  
Bozeman, Montana

  -Original Message-From: Farnsworth, Dave 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 
  11, 2002 9:39 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: STATSPACK
  I 
  think it's a new way of packaging beer.  Either that or it's an Oracle 
  tuning utility.  I like the beer idea better though.
   
  Dave
  
-Original Message-From: Eriovaldo Andrietta 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 11, 2002 
10:15 AMTo: Multiple recipients of list 
ORACLE-LSubject: Re: STATSPACK
 
Friends :
 
What does it mean : STATSPACK 
?
 
Regards 
 
Eriovaldo
 
 
 

  - Original Message - 
  From: 
  Koivu, Lisa 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Monday, December 09, 2002 3:24 
  PM
  Subject: RE: STATSPACK
  
  Wow that does sound way 
  cool  Thanks for sending this Barbara. 
  
-Original Message- 
From:   Barbara Baker [SMTP:[EMAIL PROTECTED]] 
Sent:   Monday, December 09, 2002 12:04 PM To: Multiple recipients of list ORACLE-L 
Subject:    
Re: STATSPACK 
Seema: 
Head to Tim Gorman's site ( www.evdbt.com ) and find his sppurpkg.sql download.  It uses dbms_jobs 
to run with a purge each set number of days. 
It's really slick. 
Barb 
 Seema Singh 
<[EMAIL PROTECTED]> 
wrote: 

  HiHow to clean all old STATSPACK 
  data?Thx-Seema_STOP 
  MORE SPAM with the new MSN 8 and get 2 months FREE*http://join.msn.com/?page=features/junkmail--Please 
  see the official ORACLE-L FAQ: http://www.orafaq.com--Author: 
  Seema SinghINET: [EMAIL PROTECTED]Fat City Network 
  Services -- 858-538-5051 http://www.fatcity.comSan Diego, 
  California -- Mailing list and web hosting 
  services-To 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe 
  message BODY, include a line containing: UNSUB ORACLE-L(or the 
  name of mailing list you want to be removed from). You mayalso 
  send the HELP comm! and for other information (like 
  subscribing).
  
_ Do you 
Yahoo!?Yahoo! Mail Plus 
 - Powerful. Affordable. Sign up now 

RE: Increase size of data files and rollback segments

[Weaver, Walt]

Title: RE: Increase size of data files and rollback segments



Au 
contraire, I welcome Jeremiah just about anywhere, as long as he doesn't drink 
too much of my beer.
 
Read 
between the lines, David. There's a message there. 
:>)
 
--Walt 
Weaver
  
Bozeman, Montana

  -Original Message- From: 
  Nguyen, David M [mailto:[EMAIL PROTECTED]] 
  Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: Increase size of data files and rollback segments 
  
  Jeremiah, 
  I am seeking for help.  If you are not willing to help 
  then just SHUT your mouth.  I don't think we 
  welcome such people like you here. 
  David 
  -Original Message- Sent: 
  Monday, December 09, 2002 5:39 AM To: Multiple 
  recipients of list ORACLE-L 
  On Mon, 9 Dec 2002, Nguyen, David M wrote: 
  > How do I increase size of oracle data files and rollback 
  segments and Can I > do it 
  when database is online? 
  Unfortunately these sizes are fixed, and based on your level 
  of license with Oracle Corp.  If you need to 
  increase the size of your datafiles or rollback 
  segments, you must contact your Oracle sales representative and request additional power units. 
  If you find that you run in a dynamic enough environment, you 
  may wish to upgrade to a more sophisticated database 
  system such as MS SQL Server or Filemaker Pro, both of 
  which allow dynamic resizing. 
  :-) 
  -- Jeremiah Wilton http://www.speakeasy.net/~jwilton 
  
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton   INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California    -- Mailing list and web 
  hosting services - 
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list you want to be removed from).  You may also 
  send the HELP command for other information (like subscribing). 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com -- Author: Nguyen, David M   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: IOUG 2003

[Weaver, Walt]

I remember it being $75 too.

--Walt

-Original Message-
Sent: Wednesday, November 27, 2002 11:34 AM
To: Multiple recipients of list ORACLE-L


I did.  Wasn't the renewal $75 last year, or am I dating myself?  

If so, a 67% increase is pretty substantial to me.

Brian

-Original Message-
Walt
Sent: Wednesday, November 27, 2002 9:54 AM
To: Multiple recipients of list ORACLE-L

Speaking of IOUG, did anyone else get a membership renewal email
recently?

Seems to me the annual dues have gone up significantly this year.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, November 27, 2002 8:04 AM
To: Multiple recipients of list ORACLE-L


Okay, so I'm trying to get costs for conferences etc so my boss can
budget for them.

I go to the IOUG site and look at costs for the 2003 conference. I see
"register online" so I click on it. They have it set up for speaker
registration already, and ask for the email confirmation code you
received.

Has anyone on this list, who submitted an abstract, actually RECEIVED a
response? Either acceptance or rejection? I haven't.

How can you set something up to allow people to register if they don't
know which way to register?

Sheesh. I can't even register for the University Session I want because
I don't know what status I should use when registering.

Rachel

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  INET: [EMAIL PROTECTED]

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



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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: IOUG 2003

[Weaver, Walt]

Speaking of IOUG, did anyone else get a membership renewal email recently?

Seems to me the annual dues have gone up significantly this year.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, November 27, 2002 8:04 AM
To: Multiple recipients of list ORACLE-L


Okay, so I'm trying to get costs for conferences etc so my boss can
budget for them.

I go to the IOUG site and look at costs for the 2003 conference. I see
"register online" so I click on it. They have it set up for speaker
registration already, and ask for the email confirmation code you
received.

Has anyone on this list, who submitted an abstract, actually RECEIVED a
response? Either acceptance or rejection? I haven't.

How can you set something up to allow people to register if they don't
know which way to register?

Sheesh. I can't even register for the University Session I want because
I don't know what status I should use when registering.

Rachel

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: Slightly OT - Who would you take with you...

[Weaver, Walt]

om).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert
  INET: [EMAIL PROTECTED]

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

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

RE: Oracle is a time machine!!

[Weaver, Walt]

I bet Goulet is old enough to remember when this happened.

He's probably still pissed off at missing a paycheck.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Friday, November 22, 2002 11:19 AM
To: Multiple recipients of list ORACLE-L


I get the same date for Oct 5 - 15 (10/15/02).

Good thing I don't deal with dates that far back.  ;^)

-- 

Alan Davey
[EMAIL PROTECTED]
212-604-0200  x106

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: Shared_pool

[Weaver, Walt]

Same way I figure out how full my septic tank is. Take the top off.

--Walt Weaver
  Bozeman, Montana

On Wed, Nov 06, 2002 at 04:34:28PM -0800, Jos Someone wrote:
> 
> List,
> 
> How do I find out how full my shared_pool is?
-- 

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

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

RE: RE: Oracle DBA with SAP Needed

[Weaver, Walt]

ing: 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 Lange
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Oracle DBA with SAP Needed

[Weaver, Walt]

The fact that the job's in or near Toledo might have something to do with
the salary. I doubt the cost of living is that high around there.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, November 06, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L


I doubt they can fill this position at that salary.

Oracle DBA's that work with SAP can easily earn much more than that.

Jared






"Markham, Richard" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/06/2002 07:56 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Oracle DBA with SAP Needed


What does "Base Salary is 55K-to maybe high 60s Firm." mean?  You can 
throw the possibility of a raise out the window? =) 
-Original Message- 
Sent: Wednesday, November 06, 2002 9:49 AM 
To: Multiple recipients of list ORACLE-L 

If you are an Oracle DBA With SAP experience looking for a stable company 
where you can work within a great team environment, this company in 
Toledo, 
Ohio 
is the place for you. This Fortune 500 employer has experienced steady 
growth over 
the hundred years it has been in business and is looking for a top notch 
candidate. 
This company is located in a very reasonable cost of living area and 
offers 
a varied choice 
of neighborhood communities. 
If you are looking for a place to grow within your career in a smaller 
city 
atmosphere 
this is the opportunity to check out. 
Relocation Assistance is provided. 
PLEASE DO NOT send your resume for this position UNLESS you have the 
skills 
outlined below for this position. 
DO NOT send your resume unless you have a stable work history. 
Candidates whose work history includes frequent job changes connot be 
considered. 
If you are employed by a consulting company you must have a long term 
project history. 
This is a full time staff position so no sub-contractors or third parties 
please. 
NO H-1B candidates please. 
*Requirements: 
-MUST be a team player. 
-3+ years Oracle DBA experience. 
-SAP experience 
-Must have experience with:Installation, Backup and recovery, 
Implementation, Conversion, 
 Performance tuning, Troubleshooting, Development, Database Design, 
Monitoring, and Support. 
-MUST have excellent communications skills 
-Major plusses are: SQL Backtrack, DB Artisan, Powerbuilder, Shell 
scripting 
and experience with 
 Sybase and/or SQL Server. 
Base Salary is 55K-to maybe high 60s Firm. 
The employer itself offers a comprehensive medical plan, dental insurance, 
life insurance, 
sick leave and disability plans, a retirement plan, vacation days, a 401K 
Plan, and much more. 
For immediate consideration, please email your resume as an attachment to: 
OraStaff, Inc. 
Email: [EMAIL PROTECTED] 
Phone: 1-800-549-8502. 
Please Use Job Code: one/Toledo/DBA-SAP/Jenni 
I pay referral fees. 
So please contact me if you know of anyone who would be 
qualified/interested 
in the position described above- if it is not a match for your skills. 
Thanks. 




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


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Weaver, Walt
  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 

RE: RE: Get together at OOW

[Weaver, Walt]

Oooh, low blow, man.   :>)

I'll take a good landing in Red Square over a coward's way out any day of
the week.

That's it, Jared. I'm heading for the OT list. Anyone want to follow me?

Loves and kisses (with deference to Dom Phoc),

--Walt Weaver
  Bozeman, Montana

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 11/3/2002 7:28 PM

> I've got a GPS, Dick; that should get my stagecoach in the general
area of
> northern California.
>
> Get a good paint, then vector me for final to the Moscone Center. I'll
take
> it from there.
>

...geez Walt, I'm hoping you take after Matthius Rust and not Mohammed
Atta...

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

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

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

RE: RE: Get together at OOW

[Weaver, Walt]

AIL 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: Cary Millsap
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Freeman, Robert
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Weaver, Walt
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: Get together at OOW

[Weaver, Walt]

That should be no problem.

I can hear Dick now: "Trust you soul to God, Walt, 'cause I got your ass".

Typical scope dope.:>)   :>)

--Walt (who doesn't know his soul from a hole in a ground) Weaver

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 11/1/2002 2:22 PM

Hey Walt,

You should be able to hop onto your sailplane and glide from the Montana
mountain tops towards the West coast. Dick Goulet (exUSAF Radar) should
be
able to provide you a glide-path :)

Now this is getting OT and I need to watch my mouth (oops I meant my
fingers!)

John 

>-Original Message-
>From: Weaver, Walt [mailto:wweaver@;rightnow.com]
>Sent: Friday, November 01, 2002 12:12 PM
>To: Multiple recipients of list ORACLE-L
>Subject: RE: Get together at OOW
>
>
>Well, heck, count me in. I'll be at OOW too, assuming I can find San
>Francisco. Which coast is it on?
>
>--Walt Weaver
>  Bozeman, Montana
>
>---
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: Get together at OOW

[Weaver, Walt]

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

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

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

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

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Weaver, Walt
  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: QUERY?

[Weaver, Walt]

Man, I can't think of a thing that would cause this.

I'd suggest running tkprof or somesuch on the query in both environments but
it probably wouldn't do any good.

Comparing indexes? Nah, forget it. Not worth the time.

What else, what else???

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Thursday, October 24, 2002 10:40 AM
To: Multiple recipients of list ORACLE-L


Hi
Can some one suggest whats wrong in this query?The same query run fine on 
development db but not running on production?
select count(a.xxx_id)
from   gorp_cats_stats_view a ,
static_pages b
where  b.xxx_id = a.xxx_id
andb.words like '%test%'
anda.main not like '%test%'
anda.url not like '%test%'

order by a.url

Thx
-Seema







_
Protect your PC - get McAfee.com VirusScan Online 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

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

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

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

RE: oracle or mssql

[Weaver, Walt]

No it doesn't.

MicroSoft is a card-carrying member of the Axis Of Evil.

Last I heard they were developing nuclear weapons, probably in a huge bunker
under Bill Gates' house.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, October 23, 2002 8:54 AM
To: Multiple recipients of list ORACLE-L


It depends on your companies needs.

On Tue, 22 Oct 2002 [EMAIL PROTECTED] wrote:

> Hi list
>
> Please input why my boss must invest into oracle rather than the cheaper
> mssql.
> His opinion is that most features are almost the same but mssql does that
at
> half the price as oracle does.
> So why he should not choose mssql is the question
>
>
>
>
> g.g. kor
> rdw ict groningen
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: Get together at OOW

[Weaver, Walt]

> > > > > 
> > > > > -- 
> > > > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > > > -- 
> > > > > Author: 
> > > > >   INET: [EMAIL PROTECTED]
> > > > > 
> > > > > Fat City Network Services-- 858-538-5051
> > > http://www.fatcity.com
> > > > > San Diego, California-- Mailing list
> and
> > > web hosting
> > > > services
> > > > >
> > > >
> > >
> >
>
-
> > > > > To REMOVE yourself from this mailing list,
> send
> > > an E-Mail message
> > > > > to: [EMAIL PROTECTED] (note EXACT
> spelling of
> > > 'ListGuru') and in
> > > > > the message BODY, include a line containing:
> > > UNSUB ORACLE-L
> > > > > (or the name of mailing list you want to be
> > > removed from).  You may
> > > > > also send the HELP command for other
> information
> > > (like
> > > > subscribing).
> > > > > 
> > > > -- 
> > > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > > -- 
> > > > Author: John Kanagaraj
> > > >   INET: [EMAIL PROTECTED]
> > > > 
> > > > Fat City Network Services-- 858-538-5051
> > > http://www.fatcity.com
> > > > San Diego, California-- Mailing list
> and
> > > web hosting services
> > > >
> > >
> >
>
-
> > > > To REMOVE yourself from this mailing list,
> send an
> > > E-Mail message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling
> of
> > > 'ListGuru') and in
> > > > the message BODY, include a line containing:
> UNSUB
> > > ORACLE-L
> > > > (or the name of mailing list you want to be
> > > removed from).  You may
> > > > also send the HELP command for other
> information
> > > (like subscribing).
> > > 
> > > 
> > >
> __
> > > Do you Yahoo!?
> > > Y! Web Hosting - Let the expert host your web
> site
> > > http://webhosting.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
> > > 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). 
> > 
> > =
> > Connor McDonald
> > http://www.oracledba.co.uk
> > http://www.oaktable.net
> > 
> > "Remember amateurs built the ark - Professionals
> built the Titanic"
> > 
> > __
> > Do You Yahoo!?
> > Everything you'll ever need on one web page
> > from News and Sport to Email and Music Charts
> > http://uk.my.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > -- 
> > Author: =?iso-8859-1?q?Connor=20McDonald?=
> >   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

RE: CodeNotes for Oracle9i... Destress on the way home!...OT

[Weaver, Walt]

red. I
> wouldn't 
> >rule out something like this being made available within the next 
> >decade...
> >
> >So far, I have only talked about the tech side of things here -
> there 
> >are many dangers and negative side effects to the personal and
> societal
> 
> >aspects. More of that later!
> >
> >Slightly crazy today, aren't I?
> >John
> ><< WINMAIL.DAT >>
> 
> > 
>  
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: John Kanagaraj
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name
> of
> mailing list you want to be removed from).  You may also send the
> HELP
> command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name
> of
> mailing list you want to be removed from).  You may also send the
> HELP
> command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Grabowy, Chris
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Fink, Dan
>   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
> 
=== message truncated ===


__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fink, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: SOLARIS to linux

[Weaver, Walt]

How about a database link?

--Walt (RTFM are my middle initials) Weaver
  Bozeman, Montana

-Original Message-
Sent: Thursday, October 10, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L


Yes,Let me know is any other way  except EXPORT/import I can do ?

Thx
-Seema


>From: "Deshpande, Kirti" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: SOLARIS to linux
>Date: Wed, 09 Oct 2002 19:03:41 -0800
>
>One needs to use export/import while changing hardware platforms for Oracle
>databases.
>
>- Kirti
>
>-Original Message-
>Sent: Wednesday, October 09, 2002 4:19 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi
>Can any one share data migration from sun solaris to linux ?
>Thx
>-Seema
>
>
>_
>Send and receive Hotmail on your mobile device: http://mobile.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 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Deshpande, Kirti
>   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).


import

_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: * Sr. Oracle 8i DBA Needed in NYC- Locals Only..

[Weaver, Walt]

Wow.

I haven't been considering a move from Montana to NYC, but...

--Walt

> --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> > well, if it's what I think it is (although I didn't know it went to 
> > Orastaff), it's working with me :)
> > 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  INET: [EMAIL PROTECTED]

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

RE: Oracle D.B.A. required in M.A.

[Weaver, Walt]

Yeah. Wow. Must be the first time in corporate bureaucracy history that sort
of thing has happened.

I'm shocked.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, October 02, 2002 11:15 AM
To: Multiple recipients of list ORACLE-L


You know what, this means the people who are hiring does not know what 
they are looking for.

Gene Sais wrote:

>lol, i love #1 & #2, developer but not a development dba.  good luck in
your search, quite a few requirements :)
>
>gene
>
>  
>
>>>>[EMAIL PROTECTED] 10/02/02 11:50AM >>>
>>>>
>>>>
>In my company, we require Oracle D.B.A. to maintain 
>development and production Oracle databases.  This is a 
>permanent position.  Our compnay is 24 yrs. old company.
>
>Our company is situated on Route 128 in M.A.
>
>We require the candidate urgently. If interested, please 
>send your resumes within the next two days to the 
>following e-mail: [EMAIL PROTECTED] 
>
>Following are the details for the job:
>
>Our environment: Solaris 7 and solaris 8.
>
>Databases versions: 804, 8.1.6.1, 8.1.7.3
>
>OLTP databases and datawarehouse.
>
>Veritas File System.
>
>Middleware: Tuxedo and MQ series
>
>Quest, DataMirror - Replication products
>
>Apps: WebLogic
>
>Following is the skill set for the candidate:
>
>Following are essential requirements for an Oracle DBA.
>
>1. Must have worked as Oracle developer at least 3 years.
>
>2. Must have been working as Oracle DBA at least for the 
>last 3 years in a
>PRODUCTION environment in 8i. (We don't want development 
>DBA's).
>
>3. Must have excellent knowledge in installing Oracle 
>software and its
>products. Must have installed patches in his earlier job.
>
>4. Thorough knowledge in Backup and Recovery procedures. 
>Must be able to
>solve scenarios during the interview.
>
>5. Good knowlege in Oracle tuning process. Must be able 
>to solve scenarios
>during the interview.
>
>4. Must have good knowledge in running various 
>statistical packages like
>STATSPACK.
>
>5. Excellent knowledge in shell programming and 
>understanding of awk and
>sed usage.
>
>6. Must be very familiar with Solaris 7 and higher 
>versions. Must have
>general understanding of tuning/performance processes 
>involved on Unix
>level. Should be able to give us various scenarious 
>he/she faced during
>his
>career in tuning.
>
>7. Must have good understanding of PL/SQL, SQL.
>
>8. Must be familiar with OMS and its tools.
>
>9. Must have thorough understanding of RAID concepts and 
>its use in
>Oracle.
>And good knowledge on Oracle OFA methodology - -- This 
>is must.
>
>10. Must have good knowledge on normalization techniques.
>
>11. Must be familiar with Oracle Standby databases and 
>their running. --
>This is essential.
>
>12. Good communication skills and team work.
>
>Optional but would have weightage:
>
>1. Oracle 9i knowledge
>
>2. Oracle RAC environment experience.
>
>3. Datawarehous knowledge and issues involved in setting 
>up production
>datawarehouses
>
>4. Understanding of Veritas
>
>5. Knowledge about design tools like Oracle 
>Designer/ERwin
>
>6. Knowledge about Quest
>
>7. Knowledge about DataMirror
>
>8. General understanding of WebLogic
>
>9. Understanding Tuxedo or MQM
>
>10. Knowledge in C programing.
>
>
>Rao
>
>
>
>
>  
>


-- 
ltiu
3/4 OCP 9i Eh?


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-----
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: DUAL Was: Consulting Position Available-Oracle DBA/Developer/

[Weaver, Walt]

Thanks, Jan.

Are you still at work?

--Walt (1.85254E-16ly tall) Weaver

-Original Message-
Sent: Friday, September 20, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L
DBA/Developer/


7.0

JP

On Friday 20 September 2002 20:29, you wrote:
> Jan,
>
> Which version of PostgrSQL are you using?
>
> --Walt Weaver
>   Bozeman, Montana
>
> -Original Message-
> Sent: Friday, September 20, 2002 11:35 AM
> To: Multiple recipients of list ORACLE-L
> DBA/Developer/
>
>
> We are using PostgreSQL, but still have problems with statistics.
> Sometimes after VACUUM ANALYZE optimizer doesn't use indexes
> and performance goes down.
>
> JP
>
> On Friday 20 September 2002 18:43, you wrote:
> > Ditto for PostgreSQL. For portability you can create a dual table but
you
> > have to ensure that it only has one row. ;-)   I finding that
portability
> > between PostgreSQL and Oracle is easier than most... same to_date,
> > to_char functions, and stuff. Seems like that's part of Postgres'
> > strategy.
> >
> >
> > -Original Message-
> > Sent: Friday, September 20, 2002 9:24 AM
> > To: Multiple recipients of list ORACLE-L
> > DBA/Developer/NYC
> >
> >
> >
> > As well as in MySQL
> >
> > >There is no need for such table in SQL Server.
> > >If you need, you do just:
> > >
> > >select 'whatever'
> > >
> > >without "from" clause.
> >
> > Gints Plivna
> > IT Sistçmas, Meríeïa 13, LV1050 Rîga
> > http://www.itsystems.lv/gints/

-- 
 Pruner Jan
   [EMAIL PROTECTED]
 http://jan.pruner.cz/
-
Only Robinson Crusoe had all his work done by Friday
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Weaver, Walt
  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: DUAL Was: Consulting Position Available-Oracle DBA/Developer/

[Weaver, Walt]

Jan,

Which version of PostgrSQL are you using?

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Friday, September 20, 2002 11:35 AM
To: Multiple recipients of list ORACLE-L
DBA/Developer/


We are using PostgreSQL, but still have problems with statistics.
Sometimes after VACUUM ANALYZE optimizer doesn't use indexes
and performance goes down.

JP

On Friday 20 September 2002 18:43, you wrote:
> Ditto for PostgreSQL. For portability you can create a dual table but you
> have to ensure that it only has one row. ;-)   I finding that portability
> between PostgreSQL and Oracle is easier than most... same to_date, to_char
> functions, and stuff. Seems like that's part of Postgres' strategy.
>
>
> -Original Message-
> Sent: Friday, September 20, 2002 9:24 AM
> To: Multiple recipients of list ORACLE-L
> DBA/Developer/NYC
>
>
>
> As well as in MySQL
>
> >There is no need for such table in SQL Server.
> >If you need, you do just:
> >
> >select 'whatever'
> >
> >without "from" clause.
>
> Gints Plivna
> IT Sistçmas, Meríeïa 13, LV1050 Rîga
> http://www.itsystems.lv/gints/

-- 
 Pruner Jan
   [EMAIL PROTECTED]
 http://jan.pruner.cz/
-
Only Robinson Crusoe had all his work done by Friday
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Weaver, Walt
  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: Catalog & target db on different version & O/S

[Weaver, Walt]

t; > 
> > > 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: Tim Gorman
> > >   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: Ruth Gramolini
> >   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: Tim Gorman
>   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: Ruth Gramolini
  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: Weaver, Walt
  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 Arm Twisting?

[Weaver, Walt]

Anybody know if Anita Bardeen is still working for Oracle 
Support?
 
--Walt 
Weaver
  
Bozeman, Montana

  -Original Message-From: Rodd Holman 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 14, 2002 
  10:54 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Oracle Arm Twisting?Yes, Oracle support sucks, and is 
  staffed with morons.  However one thing you get with Oracle support that 
  you cannot get with third party support is bug fixes and product 
  upgrades.  If you want this without a support contract, you need to buy 
  new licenses each time you upgrade. Rodd On Wed, 2002-08-14 at 
  11:13, Steven Lembark wrote: 
  -- Naveen Nahata <[EMAIL PROTECTED]>

> Now they say, that this can't be done and the product license will be
> terminated if we want this. The thing is that Oracle support is useless(I
> get more help from this forum :) ), but we still want it, just in case.

Ever heard of "FUD"? That's what Oracle is selling you if
you think their support is that bad: fear of not having
support that you don't want because you think it's bad.

Q:  Does anyone know of any reliable 3rd party support for
Oracle?

--
Steven Lembark   2930 W. Palmer
Workhorse Computing   Chicago, IL 60647
+1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Lembark
  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: missed Anjo's webcast..

[Weaver, Walt]

Same here.

--Walt

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, August 09, 2002 2:50 PM
To: Multiple recipients of list ORACLE-L


Ditto.  Put me down for at least one copy!  

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, August 09, 2002 3:10 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: missed Anjo's webcast..
> 
> Cary,
> 
> I'd like to place my pre-order on that book right now please.
> 
> Rachel
> 
> --- Cary Millsap <[EMAIL PROTECTED]> wrote:
> > * * *
> > 
> > Within the next few months, I hope to have completed my book project
> > ("Oracle Response Time Optimization" or some-such). The questions on
> > this list are exceptionally good inspiration for such a project, by
> > the
> > way. When the book is finished, if I still haven't convinced you,
> > then I
> > simply won't have done my job.
> > 
> > 
> > Cary Millsap
> > Hotsos Enterprises, Ltd.
> > http://www.hotsos.com
> 
-- 
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: Weaver, Walt
  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: Shark Tank: Works, shmerks -- how much did it cost?

[Weaver, Walt]

Huh. So true.

Back in the old days when I worked in a large, not-to-be-named, insurance
company in Denver I had an experience similar to this.

At the time (1989) the company was mainframe-centric, and was just delving
into client-server. Company finally decided to go full-bore to client-server
and started a large project to do so, and contracted with Oracle with what
was at the time Oracle's largest contract ever.

Turned out well, with much pain, but there were a lot of people who said it
could be done with much less cost with current systems (mainframe). They may
have been right.

Oh, well. Maybe not a good analogy. 

For the last five years I've worked with two small, successful (so far)
companies who have been very cost-conscious. Getting money to buy a new
server is like pulling teeth. It's been very interesting, but overall the
experience has been better than in the not-to-be-named insurance company.

Seems to me that a company with a good business plan, for the most part, is
going to be more successful than a company that throws money at things. Of
course, having lots of money in the bank to throw at things helps a lot.
Microsoft/Oracle is a great example.  :>)

Anyway, in my experience working for a small company has been pretty
positive vs. working for a large one. I get a bit more say in what's going
on. Plus, I don't have to work in Denver any more.

--Walt Weaver
  Bozeman, Montana

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 8/8/2002 3:38 PM

Ok, this is kind of off topic, but it does have 
Oracle in it at least once.

I just couldn't resist sending this to the list.

How many of us have had an experience similar to this?

I've had at least two I can think of.

The worst was after a merger, and we went with the
other companies more expensive, proprietary system
for a data warehouse. (Ours was Oracle on AIX, theirs
was TeraData on NCR )

The reason?  And I heard this with my own ears coming
from the mouth of a VP:

"It was a business decision. Our system is only 2 
million dollars, and theirs is 11 million, so we're 
going with theirs."

This from a business that hadn't made money in 4 years.

-


Shark Tank: Works, shmerks -- how much did it cost?

This sysadmin pilot fish discovers that his company needs to
distribute updates to a cluster of Unix servers.

"Simple enough," says fish. "I write some scripts that copy the data
out and append it to the files that need it. It all works well and it
tests out great."

But as the deadline for the rollout approaches, fish learns that the
company has spent a six-figure wad of dough on a big commercial
software package to distribute the data -- including a full-time
engineer to run it.

"My scripts are ripped out and replaced by a set of four dedicated
distribution servers running this giant package," says fish.

OK, he can live with that. After all, his scripts are being replaced
by four servers and a dedicated engineer.

But there are implementation problems, and bugs, and the deadline is
missed, and expenses on the project skyrocket. The dedicated engineer
is spending all her time on the phone with the vendor's tech support,
just trying to get things working.

Meanwhile, fish's scripts are still humming along perfectly in the
preproduction environment. Say, fish suggests to management, maybe we
should forget about giant six-figure, four-server packages and consider
implementing this simple, effective solution that actually works.

And management turns him down cold.

The reason? "If we use a home-rolled solution, we won't have tech
support," his boss tells him.

"And, as we have seen, we make heavy use of tech support for this
problem."


_

Can't get enough Tank?

Check out other bite-sized bits of humor, rumors, gossip and fun at
The Sharkives:

http://www.computerworld.com/departments/opinions/sharktank


-- 
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: Weaver, Walt
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Inte

RE: Oracle Corp. move to India

[Weaver, Walt]

Anybody read Bob Lewis' Survival Guide column in InfoWorld? A few weeks ago
he talked about programming jobs in the U.S. going the way of manufacturing
jobs, with more and more going overseas to developing countries.

He claimed that programmers/developers will be going the way of textile
workers soon.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, July 31, 2002 1:40 PM
To: Multiple recipients of list ORACLE-L



Heard on the BBC radio at lunch that Oracle Corp. is moving alot of
operations to India, 1800 new jobs.  
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

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

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

[Weaver, Walt]

It's an undocumented pseudocolumn in dual...

-Original Message-
Sent: Wednesday, July 31, 2002 7:03 AM
To: Multiple recipients of list ORACLE-L


What is drivel?

> -Original Message-
> From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
> Sent: 31 July 2002 10:34
> To: Multiple recipients of list ORACLE-L
> Subject: Re: OT: plot by "elitists" confirmed...
> 
> 
> shallow drivel
> 
> On 30 Jul 2002 at 13:48, Tim Gorman wrote:
> 
> > ...from <http://www.gksoft.com/a/fun/unix-c-hoax.html>...
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Eric D. Pierce
>   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 message (including any attachments) is confidential and may be 
legally privileged.  If you are not the intended recipient, you should 
not disclose, copy or use any part of it - please delete all copies 
immediately and notify the Hays Group Email Helpdesk at
[EMAIL PROTECTED]
Any information, statements or opinions contained in this message
(including any attachments) are given by the author.  They are not 
given on behalf of Hays unless subsequently confirmed by an individual
other than the author who is duly authorised to represent Hays.
 
A member of the Hays plc group of companies.
Hays plc is registered in England and Wales number 2150950.
Registered Office Hays House Millmead Guildford Surrey GU2 4HJ.
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lord, David - CSG
  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: Weaver, Walt
  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: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

[Weaver, Walt]

 Here we go again. So who's gonna be the first one with the abacus
joke this time?

--Walt (who makes Rachel look like a spring chicken) Weaver
  Bozeman, Montana

-Original Message-
Sent: Tuesday, July 30, 2002 1:20 PM
To: Multiple recipients of list ORACLE-L


Hex editor? geez you youngsters have it soft, in MY day we ran magnets
over the disks to encode the "ones" and "zeros"   :)



--- [EMAIL PROTECTED] wrote:
> No, I use a hex editor and directly write the bits to disk.
> 
> Isn't that the way everyone here does it?
> 
> Jared
> 
> 
> 
> 
> 
> "Straub, Dan" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 07/30/2002 10:25 AM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:RE: Guys:  Is this worth $1,749 for 8 year
> Oracle veteran DBA
> 
> 
> > > 
> > > ...hardcore DBAs might never use GUI tools. 
> > > 
> > 
> > I fit that category.  :) 
> > 
> What about the OUI? Don't you use that? :) 
> Dan. 
> 
> 
> -- 
> 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).


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.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: Weaver, Walt
  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: Differing statuses returned from dba_rollback_segs and v$roll

[Weaver, Walt]

Okay, but if dba_rollback_segs displays a status of "needs recovery", then
v$rollstat shows... what? "offline"? "online"?

Seems to me that to get a full idea of the segment status both views need to
be queried, otherwise you might miss something.

Thanks,
--Walt

-Original Message-
Sent: Monday, July 29, 2002 3:39 PM
To: Multiple recipients of list ORACLE-L
v$rollstat


I *think* the difference that dba_rollback_segs is a static view, while
v$rollstat is dynamic.

So the static view shows the segments as ONLINE, which they were, even
though they were also full

The dynamic view shows what is happening at that moment in time, which
is that the segments were FULL.

It's an explanation, not a great one, but an explanation.


--- "Weaver, Walt" <[EMAIL PROTECTED]> wrote:
> Okay, so today one of our QA databases suddenly started spewing out
> ora-1552
> errors. Turned out all of the rollback segments had a status of FULL.
> The
> problem was quickly fixed by taking the rollback segments offline,
> then back
> online. The reason why the rollback segments all became FULL is
> another
> story.
> 
> Anyway, before the problem was fixed we queried both
> dba_rollback_segs and
> v$rollstat to get the status of the rollback segments. v$rollstat
> returned
> FULL, but dba_rollback_segs returned ONLINE.
> 
> I thought this was interesting (I'm easily amused) so I dug up the
> DDL for
> the two views (shown below). The two views appear to get their
> information
> from two different places, and both use DECODEs to make the status
> meaningful. But, there's no DECODE value for FULL in
> dba_rollback_segs. In
> fact, the status values for the two can be quite different.
> 
> Why are they different? This bothers me. Steve Orr is off fishing
> today so
> he's not here to provide a rational explanation.
> 
> Is anyone else bothered by this? Or, should I just laugh it off, pick
> up the
> shattered pieces of my life, and soldier on?
> 
> I've also posted this on the appropriate (I think) Metalink forum.
> 
> Thanks,
> --Walt Weaver
>   Bozeman, Montana
> 
> 
> 
> 
> create or replace view DBA_ROLLBACK_SEGS
> (SEGMENT_NAME, OWNER, TABLESPACE_NAME, SEGMENT_ID, FILE_ID,
> BLOCK_ID,
>  INITIAL_EXTENT, NEXT_EXTENT,
>  MIN_EXTENTS, MAX_EXTENTS, PCT_INCREASE,
>  STATUS, INSTANCE_NUM, RELATIVE_FNO)
> as
> select un.name, decode(un.user#,1,'PUBLIC','SYS'),
>ts.name, un.us#, f.file#, un.block#,
>s.iniexts * ts.blocksize,
>decode(bitand(ts.flags, 3), 1, to_number(NULL),
>   s.extsize * ts.blocksize),
>s.minexts, s.maxexts,
>decode(bitand(ts.flags, 3), 1, to_number(NULL),
>   s.extpct),
>decode(un.status$, 2, 'OFFLINE', 3, 'ONLINE',
>   4, 'UNDEFINED', 5, 'NEEDS RECOVERY',
>   6, 'PARTLY AVAILABLE', 'UNDEFINED'),
>decode(un.inst#, 0, NULL, un.inst#), un.file#
> from sys.undo$ un, sys.seg$ s, sys.ts$ ts, sys.file$ f
> where un.status$ != 1
>   and un.ts# = s.ts#
>   and un.file# = s.file#
>   and un.block# = s.block#
>   and s.type# = 1
>   and s.ts# = ts.ts#
>   and un.ts# = f.ts#
>   and un.file# = f.relfile#
> ===
> GV$ROLLSTAT
> select
>
inst_id,kturdusn,kturdext,kturdsiz,kturdwrt,kturdnax,kturdget,kturdwat,
> d
> ecode(kturdopt, -1,to_number(null), kturdopt),
> kturdhwm,kturdnsh,kturdnwp,kturdn
> ex, kturdash,kturdaae, decode(kturdflg, 0,'ONLINE', 2,'PENDING
> OFFLINE',
> 3,'OFFL
> INE', 4, 'FULL', 'UNKNOWN'), kturdcex, kturdcbk from x$kturd
> where
> kturd
> siz!=0 and kturdflg != 3
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Weaver, Walt
>   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!?
Yahoo! Health - Feel better, live better
htt

Differing statuses returned from dba_rollback_segs and v$rollstat

[Weaver, Walt]

Okay, so today one of our QA databases suddenly started spewing out ora-1552
errors. Turned out all of the rollback segments had a status of FULL. The
problem was quickly fixed by taking the rollback segments offline, then back
online. The reason why the rollback segments all became FULL is another
story.

Anyway, before the problem was fixed we queried both dba_rollback_segs and
v$rollstat to get the status of the rollback segments. v$rollstat returned
FULL, but dba_rollback_segs returned ONLINE.

I thought this was interesting (I'm easily amused) so I dug up the DDL for
the two views (shown below). The two views appear to get their information
from two different places, and both use DECODEs to make the status
meaningful. But, there's no DECODE value for FULL in dba_rollback_segs. In
fact, the status values for the two can be quite different.

Why are they different? This bothers me. Steve Orr is off fishing today so
he's not here to provide a rational explanation.

Is anyone else bothered by this? Or, should I just laugh it off, pick up the
shattered pieces of my life, and soldier on?

I've also posted this on the appropriate (I think) Metalink forum.

Thanks,
--Walt Weaver
  Bozeman, Montana




create or replace view DBA_ROLLBACK_SEGS
(SEGMENT_NAME, OWNER, TABLESPACE_NAME, SEGMENT_ID, FILE_ID, BLOCK_ID,
 INITIAL_EXTENT, NEXT_EXTENT,
 MIN_EXTENTS, MAX_EXTENTS, PCT_INCREASE,
 STATUS, INSTANCE_NUM, RELATIVE_FNO)
as
select un.name, decode(un.user#,1,'PUBLIC','SYS'),
   ts.name, un.us#, f.file#, un.block#,
   s.iniexts * ts.blocksize,
   decode(bitand(ts.flags, 3), 1, to_number(NULL),
  s.extsize * ts.blocksize),
   s.minexts, s.maxexts,
   decode(bitand(ts.flags, 3), 1, to_number(NULL),
  s.extpct),
   decode(un.status$, 2, 'OFFLINE', 3, 'ONLINE',
  4, 'UNDEFINED', 5, 'NEEDS RECOVERY',
  6, 'PARTLY AVAILABLE', 'UNDEFINED'),
   decode(un.inst#, 0, NULL, un.inst#), un.file#
from sys.undo$ un, sys.seg$ s, sys.ts$ ts, sys.file$ f
where un.status$ != 1
  and un.ts# = s.ts#
  and un.file# = s.file#
  and un.block# = s.block#
  and s.type# = 1
  and s.ts# = ts.ts#
  and un.ts# = f.ts#
  and un.file# = f.relfile#
===
GV$ROLLSTAT
select
inst_id,kturdusn,kturdext,kturdsiz,kturdwrt,kturdnax,kturdget,kturdwat, d
ecode(kturdopt, -1,to_number(null), kturdopt),
kturdhwm,kturdnsh,kturdnwp,kturdn
ex, kturdash,kturdaae, decode(kturdflg, 0,'ONLINE', 2,'PENDING OFFLINE',
3,'OFFL
INE', 4, 'FULL', 'UNKNOWN'), kturdcex, kturdcbk from x$kturd where
kturd
siz!=0 and kturdflg != 3
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: MUST read Oracle Architecture - Abrief Intro

[Weaver, Walt]

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: the ora certified masters cert - finally bloody sick

[Weaver, Walt]

Psst! Kirti, I have the questions to the exam. Meet me in the alley behind
the drugstore downtown and we can hash out a deal...

--Walt

-Original Message-
Sent: Thursday, June 27, 2002 8:19 AM
To: Multiple recipients of list ORACLE-L


I will now return to my 8i OCP prep. 
Anyone wants to sell the student guides from 8i NF ILT ???  ;-)) 

- Kirti 

-Original Message-
Sent: Thursday, June 27, 2002 6:13 AM
To: Multiple recipients of list ORACLE-L


Mike,

If you got the impression from anything I've posted here that I believe
anyone who has gotten the OCP title is a liar and a cheat then I am
very sorry as that is NOT the impression I meant to give.

I think the OCP exam itself is worthless and not a measure of what a
DBA knows. I think there are many DBAs out there who can add "OCP" to
their resume who are wonderful DBAs (let's see, I read and learn from
your posts, Joe Testa's, Kevin Loney has it as well and others)

What I object to is the presumption that if you have those letters on
your resume you are AUTOMATICALLY a good DBA.

Rachel

--- Hately Mike <[EMAIL PROTECTED]> wrote:
> I've been pretty quiet while you all said that the OCP program was
> pretty
> worthless because I can see your point. I don't believe that it
> proves that
> the holder is technically better than someone has isn't certified.
> From my
> point of view, though, I'm convinced that in a tight market it's
> helped to
> get me into interviews and that justifies the cost to me. 
> Now, however, you're straying towards calling OCP DBAs liars and
> cheats and
> implying that we're dangerous to have on site and I'm sorry but I'm
> not
> going to have that.
> What merit is there in saying "doctors have malpractice insurance and
> OCP
> ... should have one too.". Where's the evidence for that kind of
> witless
> comment?
> I originally took my OCP after amassing 10 years of DBA experience. I
> don't
> want to get into a pissing contest over this but it grates on me to
> have it
> constantly implied that OCP is just there to make up for lack of
> ability.
> I'm aware that many of you (Don for instance) have qualified their
> statements by saying that applies to "a few" or "some" but the
> implication
> is still that the majority of OCPs are trying to make up for some
> sort of
> technical deficiency.
> 
> If you don't want to spend the money or the time then that's fine by
> me. I
> certainly won't it necessary to criticise you for it.
> 
> Regards,
> Mike Hately
> 
> No, really; I usually have a sense of humour.
> 
> -Original Message-
> Sent: 27 June 2002 08:13
> To: Multiple recipients of list ORACLE-L
> 
> 
> From my experience with a few DBAs that waved their OCP around like
> it was a
> Nobel prize, some probably should have malpractice insurance.  Lots
> of it.
> 
> Don Granaman
> [Certifiable OraSaurus - NOCP]
> 
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: Deleting large table and the correct log buffer size

[Weaver, Walt]

Being a non-certified MySQL DBA, I can assure you that delete performance in
Oracle is VERY disappointing if you've transitioned over from MySQL.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, June 26, 2002 2:35 PM
To: Multiple recipients of list ORACLE-L


Good point, Jared. A thought occurs to me. Is it possible the Sybase
architecture lends itself to deletes more than the Oracle architecture. As
you study the Oracle architecture you note several places where Oracle is
tuned for high insert/update performance at the expense of the delete
performance. Perhaps someone on the list with experience in both Oracle and
Sybase can comment on whether Sybase is faster at deletes. If that is true,
I could see a DBA coming from a Sybase background might expect Oracle
deletes to be much faster, while those of us who have only Oracle experience
might have a different expectation.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, June 26, 2002 3:06 PM
To: Multiple recipients of list ORACLE-L


Personally, I'd be pretty happy with a 400K row delete
only taking 10 minutes.

Jared





"Vasu Ramasamy" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/26/2002 09:49 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Deleting large table and the correct log buffer size


Hello Gurus,
  Ours is  basically a Sybase shop. But moving towards Oracle. We are in
the process of conversion. I have a problem in deleting a large number
of rows. To delete 400,000 rows approx., it takes nearly 10 minutes to
complete and sometimes hogs system. It is a simple delete statement,
delete all rows. We do not want to use truncate statement. I try to find
why it is taking so much time by checking the wait events. The session
event wait statistics is provided below.


SIDEVENT
TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED

--

AVERAGE_WAIT  MAX_WAIT
--
27latch
free
1010 20
   2 2

27log buffer
space
298   271  29267
  98.2114094   104

27log file switch
completion   11
10   1069
  97.1818182   103

27log file
sync
3 2221
  73.667   103

27db file sequential
read3222
0   7695
  2.38826816   589

27db file scattered
read  271
0493
  1.81918819   236

27file
open
4 0  0
   0 0


   The log_buffer_space wait event looks like is the culprit with
total_wait =298, total_timeout = 271, and time_waited = 29267 ( 1/100th
of a second). Are these normal values for this wait event? The log
buffer init param is set to 20MB. To set up the init params, we took the
advice of the consultant DBA who worked for a short time (6 months) to
help us to set up servers. While I was going through the DBA hand books,
( 101 Oracle performance tuning by gaja krishna vaidyanatha and other)
it clearly says that setting higher value will cause trouble. He
recommends to set it to 1MB. I tried with 4MB log buffer, the wait stats
for log_buffer_space just doubles.

   Can you please advice me what should be the correct size for log
buffer?
   Do you see any problem with wait stats provided above?

  If you need further details, let me know please.

   Thanks

Vasu


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: Once again : Oracle vs Sql Server

[Weaver, Walt]

No.

-Original Message-
Sent: Tuesday, June 18, 2002 3:28 PM
To: Multiple recipients of list ORACLE-L


Hi all,

Any non-biaised study between Oracle and Sql Server
available ?

TIA

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  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: Weaver, Walt
  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 DB2 DBA Needed in Nebraska (near Colorado border)

[Weaver, Walt]

Huh. I'd be able to make it from Denver to Sidney in two hours in my
airplane, but not by car...

Sidney's a nice town, though.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, June 12, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L


Company in Sidney, Nebraska has an Oracle /DB2 DBA  position opening on  its
IT staff.
Sidney is a small town, 2 hours from Denver.. 30 mins from Sterling, CO so
it's very close 
to the CO/NE border.
The area has a very, very low cost of living, so renting or buying a house
is tremendously 
low compared to most other areas of the country.

An excellent Relocation Package is offered.

Description:
The selected candidate will perform typical DBA tasks to ensure reliable and
scheduled availability of multiple development and production databases.
This position will be responsible for monitoring and tuning databases for
optimum performance, 
working with application developers during all phases of the application
development life cycle,
designing and implementing physical database design, influencing all aspects
of 
application architecture and design, and assisting in troubleshooting
application problems.

PLEASE Do Not send your resume for this position UNLESS you have the
qualifications for this position.

Please Do Not send your resume unless you have a stable work history.
Candidates whose work history includes frequent job changes connot be
considered.
If you are employed by a consulting company you must have a long term
project history.

This is a full time staff position so no sub-contractors or third parties
please.

No H-1B candidates please.

Requirements:
-4+ years of Oracle database administration experience
 on HP, SUN, or NT platforms (version 8.x or higher)
-Solid DB2 database administration experience on
 AS400, HP, SUN, or NT platforms.
-4+ years of experience writing and tuning complex SQL.
-Experience in logical and physical relational database
 design and data modeling
-Good communication skills, ability to work well with
 others and multi-task.
-U.S. citizens or permanent residency

The base salary range depends on experience...range is up to 85K..and
possible bonus.
They also offer a comprehensive benefits package, including generous
product discounts, profit sharing, 401K savings plan,
and Health and Dental coverage.

For  immediate consideration, please send your resume as a Word attachment
to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
Please use job code: One/Sidney/Oracle/DB2/KW
ph: 1-800 -549-8502

All Submissions are handled in confidence.

*We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the posiition described above- if it is not a match for your skills.
Thanks,
Bill Law

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: OraStaff
  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: Weaver, Walt
  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: set command

[Weaver, Walt]

Title: RE: set command




How 
about set linesize?
 
--Walt 
Weaver
  
Bozeman, Montana

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 2002 
  7:58 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: set command
  Guys, 
  Building scripts from SQL generating SQL in Oracle on 
  Unix.  I know that there are set commands so that Oracle does not put CR 
  or LF in the middle of a long command.  Does anyone know these off the 
  top of their head?
  Thanks, Paula 
  set array...? set maxdata...? 
  

RE: MySQL versus Oracle

[Weaver, Walt]

If there's only one user accessing it, yes.

--Walt

-Original Message-
Sent: Friday, May 31, 2002 3:44 PM
To: Multiple recipients of list ORACLE-L


a) It's blindingly fast as a single user database, faster then oracle.

Really?  Even with a 30 million record table?

-Original Message-
Sent: Friday, May 31, 2002 12:41 PM
To: Multiple recipients of list ORACLE-L


I read few articles in Linux magazine and had it installed on
my box for a while and here are my impressions:

a) It's blindingly fast as a single user database, faster then oracle.
b) It uses more or less standard SQL minus all the unnecessary functions 
   like substr, decode, nvl and alike which nobody ever uses anyway (evil
grin).
c) It's small. You can have both software and a small database within 150M
d) I didn't learn how to do recovery. It doesn't have hot backups. You have
to
   shut it down to make a sensible backup.
e) It's easy to configure and doesn't have too many things to set up.

Allegedly, the present version (I did my dirty work back in August 2001) can
use
Perl as a scripting language, I don't know whether DBI/DBD is needed for
that and
it can cope with committs and rollbacks. 


> -Original Message-
> From: Joe Testa [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 31, 2002 10:39 AM
> To: Multiple recipients of list ORACLE-L
> Subject: MySQL versus Oracle
> 
> 
> Anyone on the list done a comparison(or worked with both) MySQL and 
> Oracle and can give me the good/bad points of My SQL?
> 
> Doing interviewer thing and someone has My SQL who would like to move 
> into the oracle world and i know nothing about mySQL and am 
> wondering if 
> the transition from one to the other is easily done.
> 
> thanks, joe
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Joe Testa
>   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: Ji, Richard
  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: Weaver, Walt
  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: RE: Jr.DBA, Mid level DBA, Sr.DBA

[Weaver, Walt]

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: Weaver, Walt
  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: MySQL versus Oracle

[Weaver, Walt]

Yes, that's exactly what I meant.

-Original Message-
Sent: Friday, May 31, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L



The transition to oracle from mysql is a great deal
more complicated than the inverse. I am hoping that is
what you meant :}

--- "Weaver, Walt" <[EMAIL PROTECTED]> wrote:
> We use both here, use'em as back-end databases for
> our hosted web sites.
> 
> MySQL is fast, easy to set up and maintain, and
> free. Works great for our
> small and medium-sized web sites. But, it doesn't
> scale as well as Oracle
> and we've had better luck using Oracle with our
> large, active sites. MySQL
> with MyISAM table types has table-level locking
> only, and a large number of
> concurrent selects can slow things down
> tremendously.
> 
> IMHO, maintaining a MySQL database is more of a
> SysAdmin job than a DBA job,
> and I don't think you'll have much of a problem with
> the transition. 
> 
> We recently finished up some benchmarking, using
> Oracle and MySQL with
> MyISAM and InnoDB table types. I can send you the
> test report if you'd like.
> 
> I personally think MySQL has a bright future, and
> when 4.1 comes out (not
> expected for a year or so) it could start making a
> real dent in the database
> market. It has certainly helped us here; we've been
> able to keep our Oracle
> licensing costs to a minimum by using MySQL for the
> majority of our sites.
> 
> If you'd like more information, Joe, email me
> directly.
> 
> --Walt Weaver
>   Bozeman, Montana 
> 
> -Original Message-
> Sent: Friday, May 31, 2002 8:39 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Anyone on the list done a comparison(or worked with
> both) MySQL and 
> Oracle and can give me the good/bad points of My
> SQL?
> 
> Doing interviewer thing and someone has My SQL who
> would like to move 
> into the oracle world and i know nothing about mySQL
> and am wondering if 
> the transition from one to the other is easily done.
> 
> thanks, joe
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Joe Testa
>   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: Weaver, Walt
>   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!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Pass
  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: Weaver, Walt
  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: MySQL versus Oracle

[Weaver, Walt]

We use both here, use'em as back-end databases for our hosted web sites.

MySQL is fast, easy to set up and maintain, and free. Works great for our
small and medium-sized web sites. But, it doesn't scale as well as Oracle
and we've had better luck using Oracle with our large, active sites. MySQL
with MyISAM table types has table-level locking only, and a large number of
concurrent selects can slow things down tremendously.

IMHO, maintaining a MySQL database is more of a SysAdmin job than a DBA job,
and I don't think you'll have much of a problem with the transition. 

We recently finished up some benchmarking, using Oracle and MySQL with
MyISAM and InnoDB table types. I can send you the test report if you'd like.

I personally think MySQL has a bright future, and when 4.1 comes out (not
expected for a year or so) it could start making a real dent in the database
market. It has certainly helped us here; we've been able to keep our Oracle
licensing costs to a minimum by using MySQL for the majority of our sites.

If you'd like more information, Joe, email me directly.

--Walt Weaver
  Bozeman, Montana 

-Original Message-
Sent: Friday, May 31, 2002 8:39 AM
To: Multiple recipients of list ORACLE-L


Anyone on the list done a comparison(or worked with both) MySQL and 
Oracle and can give me the good/bad points of My SQL?

Doing interviewer thing and someone has My SQL who would like to move 
into the oracle world and i know nothing about mySQL and am wondering if 
the transition from one to the other is easily done.

thanks, joe


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  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: Weaver, Walt
  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: {9i New Features: V$SQL_PLAN}

[Weaver, Walt]

Kewl! Oracle has finally grasped the concept 
of a slow query log.
 
Glad to see Oracle is at least trying to 
catch up to MySQL.
 
--Walt Weaver
   Bozeman, Montana

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 07, 2002 7:48 
  AMTo: Multiple recipients of list ORACLE-LSubject: {9i 
  New Features: V$SQL_PLAN}
  Welcome to the next installment of 9i new features(and yes when 9iR2 is 
  released, we'll start this series all over again, woohoo)
   
  In the mean time, here is the scoop on v$sql_plan view.
   
  This view provides a way of examining the execution plan for cursors 
  that were recently executed.
   
  The view has about the same info as the output of an explain plan and 
  this is intentional, the big difference is output from an explainis in 
  theory what would happen but this view contains the actual plan as to what 
  happened.
   
  So is this of any use, probably, think about this, you can now see 
  the plan that was executed.  This has some really kewl uses for 
  thoseof us who are still not up to speed in the whole "wait state" tuning 
  concept(which yours truly is included).
   
  This help you see that bad code in the database.
   
  So of the columns in this view, which one are most useful
   
  Address and hash_value join to v$sqlarea.Address,hash_value and 
  child_number join to v$sqlAddress and hash_value join to v$sqltext
   
  Most of the rest of the columns are what you'd find in a normal plan 
  table.
   
  There's not much else to say about this v$ view, except if nothing 
  else, I've finally now know which columns to join on on those v$sql* 
  views.
   
  Like always, send hate mail to /dev/null, all others to [EMAIL PROTECTED].
   
  Joe
   
  PS:  anyone have any special requests that they'd like to know about 
  but don't have the time, let me know.

RE: Licences for testing

[Weaver, Walt]

Last time I checked Oracle on Linux is free if it's used for testing only.
If you don't mind using Linux (we use it extensively) it could be a viable
option.

--Walt Weaver
  Bozeman, Montana

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002 7:43 AM
To: Multiple recipients of list ORACLE-L




You could talk to your sales rep about short-term licensing, or you could
just
do it and hope they don't discover it. I've found that "temporary servers"
have
a tendency to become permanent though.


|+--->
||   |
||   |
||  Sean.ONeill@o|
||  rganon.ie|
||   |
||  05/03/2002   |
||  08:08 AM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+--->
  >|
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: Licences for testing|
  >|




We're planning to set-up some "test" servers here and I'm wondering what the
"practice" is out there regarding licences for same.  This is only for short
term testing and to "try out" various DR scenarios etc.  I'd guess there's
an "Oracle" view which would be if you install on server you pay a licence,
(correct?).  Is there some workaround for this?.  All creative ideas welcome
:)

-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]


This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: O'Neill, Sean
  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: Weaver, Walt
  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: ITS THE PHB, STOOOOPID (was: anti-virus spam)

[Weaver, Walt]

Ball in your court, Mr. Pierce.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, May 01, 2002 3:00 PM
To: Multiple recipients of list ORACLE-L



Hmmm, I'm guessing you're a student at csus and not a professional
there.  Grow up.


-Original Message-
Sent: Wednesday, May 01, 2002 4:42 PM
To: Multiple recipients of list ORACLE-L


It is kind of amazing how irrelevant and lacking in substance this 
discussion is.

It has been explained that the original offender's email server was 
configured in *stupid mode* because of damagement, not because of 
the techies.

fyi: PHB = pointed headed boss

( http://kltp.kldp.org/eunjea/jargon/?idx=PHB ) 


to clarify: it is a complete outrage that an email server is set up 
to barf out a whole screen full of worthless, erroneous and time 
wasting "virus warning" messages back to a message sender *MONTHS* 
(almost a *YEAR*?) after a text attachment has been sent to the 
list.

certainly the above situation qualifies for the WHAT THE F* award 
of the week, doesn't it?

certainly the list owner's attention ought to be brought to bear on 
whether or not a subscriber ought to be allowed to remain if their 
system is generating such a huge pile of unwanted fecal material, 
and certainly consideration should be given to pressuring the email 
admin, or other f*ing d*kheads in positions of "respoinsibility" at 
said subscriber's corporation/organization into reversing their 
f*ing stupid email configuration policy, no?

presumably an expression of outrage at the f*ing stupidity of said 
f*ing email server configuration would tend to put the issue on 
someones f*ing radar screen more than some "polite" request that 
everyone ignores?

anyways, Tim was wrong in thinking that I was insulting fatcity's 
email admin.

Tim's observations about language and tone were irrelevant and 
lacking in substance, and frankly, regardless of Tim's many other 
undoubtedly great/vast/endless virtues, culinary or not, I don't 
care about such ninny-like posturing and false rectitude anyway, so 
his advice was completely wasted on me.

I'm sure everyone was infinitely amused and entertained by your 
story of being fooled into eating a dead animals' testicles 
(apparently that topic wasn't covered in 5th grade).

regards,
ep


ORACLE-L Digest -- Volume 2002, Number 121
> --
> 
>  From: Mogens =?ISO-8859-1?Q?N=F8rgaard?= <[EMAIL PROTECTED]>
>  Date: Tue, 30 Apr 2002 18:17:09 +0200
>  Subject: Re: ANTI-VIRUS SPAM - YOUR EMAIL ADMIN IS A DIKHEAD
> 
> --030707020805030006050203
> Content-Type: text/plain; charset=us-ascii; format=flowed
> Content-Transfer-Encoding: 7bit
> 
> Sigh. I wish I understood half the words used in this exchange. Or
maybe
> not. But I still think Tim is a cool guy and I'm looking forward to
> drinking beer with him next time we meet. The first time I met with
Tim
> was in Denver where he tricked me into eating  something he called
Rocky
> Mountain Oysters. If he ever makes it to Denmark I'll trick him into
> eating our world-famous blood sausage.
> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  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: Seefelt, Beth
  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: Weaver, Walt
  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

RE: hi i'm back amongst the living

[Weaver, Walt]

Joe,

Glad you had a good time. Sorry I didn't make it, my company pulled funding
at the last minute.

As far as Oracle and Linux is concerned, I have a lot of experience. You
have to install Linux first. That makes everything else a lot easier.

--Walt Weaver
  Bozeman, Montana

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 4/18/2002 6:38 PM

Lots of good stuff at IOUG conference this year, the food sucked, blah.


Technical sessions were good(the few i went to), met some people been 
talking to for years on this forum.  Party was as sea world, it was ok. 
  We thought maybe Shamu was going to eat Rich N, but that didnt happen.

For those of you who didnt make it :(,  maybe next year in Orlando, FL 
at the Swan/Dolphin hotel, april 27-may 1st.

Lots of first time presenters and for those of you who know Marlene 
Theriault, she did her last IOUG presentation this time around, she's 
officially retiring from the Oracle world.

She's doing the european one and then she's quitting, no more books
either.

We'll miss her dearly.

So for those of you who've contemplated presenting before a conference, 
call for papers should be in jul/aug at latest for Orlando.

I think i'm done with logminer, milked it for too many years, next year 
i'm toying around with a couple of ideas:

1.  Recovery Concepts: Let's blow up a database and do live recovery 
during the presentation"

2.  Linux:  Can I really do a no-brainer install of linux and oracle?, 
Here are the steps.

Oh well, off to dinner and chillin for one more day.


For those who didn't make it, we missed you.

Joe




-- 
Joseph S Testa
Data Management Consulting
http://www.dmc-it.com
614-791-9000

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S Testa
  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: Weaver, Walt
  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: MySQL vs. Oracle database

[Weaver, Walt]

In our testing the Berkeley table types were hopelessly slow and bloated,
taking up much more space than MyISAM or InnoDB table types.

We had more success with the InnoDB table type, and will be implementing
them some time in the future. InnoDB supports referential integrity.

The table types aren't really a special component; they're implemented via
an argument when the source is compiled.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Thursday, April 18, 2002 3:03 AM
To: Multiple recipients of list ORACLE-L



By default MySQL has no transactions
You have to add special component to access "transactional safe tables"
called Berkeley db tables. You can commit and rollback on only these
tables. For others every wrong (not syntactically, but for example
inserting characters into number column) insert and update will succeed. If
MySQL cannot insert provided values it uses default values.

One of the biggest pains is (maybe was, I don't know about MySQL 4.xxx)
that it has no foreign keys :

I have created class diagramms for both Oracle and Mysql servers for my
studies in University. It cannot be treated as feature comparison but just
simple overview of these two images will show the situation i.e. compare
object count on these images :-)
And I have to say that Oracle diagramm isn't complete!

Oracle server class diagramm
http://www.itsystems.lv/gints/files/oracle/oracle_s.htm

Mysql server class diagramm
http://www.itsystems.lv/gints/files/mysql/mysql.htm


Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/



 

  "Bunyamin K.

  Karadeniz"   To:   Multiple recipients
of list ORACLE-L <[EMAIL PROTECTED]>
 Subject:  Re: MySQL vs.
Oracle database  
  Sent by:

  [EMAIL PROTECTED]

 

 

  2002.04.18 10:43

  Please respond to

  ORACLE-L

 

 





I have not been so much with MySQL  , But want to share my experience.

Firstly , it is very fast ...This makes me suspicious , I wonder if it is
trusted to be integral .
Seem like no control ..Does not contain rollbacks , may be this .. Then how
does it rollback ?

I have used a version where stored procs ,functions are unavailable ..
Wonder if it has now..






Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729

The degree of normality in a database
is inversely proportional to that of its DBA.

- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 10:31 PM


>
>
> -- "Weaver, Walt" <[EMAIL PROTECTED]>
>
> > I don't think you're wrong. MySQL gets dissed frequently on this list,
but
> > it's really a nice little product. IMHO it's much closer to Oracle than
> > Access.
> >
> > It works well for us. Doesn't scale like Oracle, but works well.
>
> In some ways it scales better than Oracle. For load+query
> (a.k.a., "warehouse") operations it can be faster than
> Oracle because it doesn't get tangled up with rollbacks,
> etc. On systms with many "instances" it also can be much
> simpler to administer.
>
> --
> Steven Lembark   2930 W. Palmer
> Workhorse Computing   Chicago, IL 60647
> +1 800 762 1582
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Steven Lembark
>   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: Bunyamin K. Karadeniz
  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')

RE: MySQL vs. Oracle database

[Weaver, Walt]

I don't think you're wrong. MySQL gets dissed frequently on this list, but
it's really a nice little product. IMHO it's much closer to Oracle than
Access.

It works well for us. Doesn't scale like Oracle, but works well.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, April 17, 2002 11:50 AM
To: Multiple recipients of list ORACLE-L


Alex,

Just wondering why do you think MySQL is closer to
Access than to Oracle. I have played with MySQL a
little and it is a relational database like Oracle 
(not sure if access is one), uses a SQL, can have
logging and archiving just like Oracle. Again I'm not
sure whether access have all this. To me, if Oracle is
a BMW and MySQL is a Chevy (as someone else compared),
access would be a horse cart at best. Am I wrong?

Gene
--- Alex <[EMAIL PROTECTED]> wrote:
> Check google. Anyway they are completely different.
> MySQL is more like
> Access than Oracle.
> 
> On Wed, 17 Apr 2002, Nguyen, David M wrote:
> 
> > What is different between MySQL and Oracle
> database?  Someone says they are
> > the same as they are just database.  From DBA or
> developer point of view,
> > what do you say?
> > 
> > Thanks,
> > David
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > -- 
> > Author: Nguyen, David M
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from).  You may
> > also send the HELP command for other information
> (like subscribing).
> > 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Alex
>   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!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  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: Weaver, Walt
  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: MySQL vs. Oracle database

[Weaver, Walt]

Well, MySQL and Oracle are very different, but there's a world of difference
between MySQL and Access too. It's quite possible to use MySQL as a backend
database for web hosting and get good performance and decent reliability. I
haven't heard of Access being used for that sort of thing.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, April 17, 2002 11:03 AM
To: Multiple recipients of list ORACLE-L


Check google. Anyway they are completely different. MySQL is more like
Access than Oracle.

On Wed, 17 Apr 2002, Nguyen, David M wrote:

> What is different between MySQL and Oracle database?  Someone says they
are
> the same as they are just database.  From DBA or developer point of view,
> what do you say?
> 
> Thanks,
> David
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Alex
  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: Weaver, Walt
  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: MySQL vs. Oracle database

[Weaver, Walt]

There is a world of difference between'em.

We use both here, Oracle for our large, active customers, and MySQL for our
smaller customers, to avoid as much as possible having to pay Oracle's
ridiculous licensing fees. Our smaller customers don't need Oracle's
scalability and reliability, and MySQL works well for'em.

Check out http://www.mysql.com. Lots of information on MySQL there, and it's
a good start to understanding what MySQL can and can't do, compared to
Oracle.

--Walt Weaver
  Bozeman, Montana



-Original Message-
Sent: Wednesday, April 17, 2002 9:34 AM
To: Multiple recipients of list ORACLE-L


What is different between MySQL and Oracle database?  Someone says they are
the same as they are just database.  From DBA or developer point of view,
what do you say?

Thanks,
David
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nguyen, David M
  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: Weaver, Walt
  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: WHICH UNIX FOR ORACLE?

[Weaver, Walt]

Nope, just been in major lurk mode for the past few months.  :>)

--Walt

-Original Message-
Sent: Friday, April 05, 2002 11:02 AM
To: [EMAIL PROTECTED]; Weaver, Walt



Nice to hear from you Walt.  I'd begun to think you'd crashed
your sailplane into the side of a mountain or something. :)

Jared

On Friday 05 April 2002 09:08, Weaver, Walt wrote:
> As Steve's bunkermate I'll second the Linux thing. We're having good luck
> with Linux here.
>
> I've done AIX and Solaris, and Linux is up there with'em.
>
> --Walt Weaver
>   Bozeman, Montana
>
> -Original Message-
> Sent: Friday, April 05, 2002 9:31 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Lot's of listers have presented nice lists but if you don't have Linux on
> your list then your experience is woefully incomplete. Long live Linux!
The
> war is on and those who don't join this camp soon will find themselves on
> the losing side! :-)
>
> I did HPUX. I did Solaris. Now I'm doing Linux and life is wonderful.
>
> Unopinionatedly yours,
> Archie Bunker Steve Orr
>
>
> -Original Message-
> Sent: Friday, April 05, 2002 8:34 AM
> To: Multiple recipients of list ORACLE-L
>
>
> My experiance is just the opposite :
>
> 1. Solaris
> 2. Solaris
> 3. Solaris
> 4. HP-UX
> 5. AIX
> 6. Digital Unix
> 7. SCO Unix
>
> Solaris has much better features and is more reliable as per my
experience.
> For eg. only Solaris provides the option to use Asynchronous I/O for file
> systems
> as well as raw devices. Asynchronous I/O on HP will b used only while
> accessing
> raw devices.
> I think that the Oracle software is primarily written on Solaris these
> days.
>
> Samir
>
> Samir Sarkar
> Oracle DBA
> SchlumbergerSema
> Email :  [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> Phone : +44 (0) 115 - 957 6028
> EPABX : +44 (0) 115 - 957 6418 Ext. 76028
> Fax : +44 (0) 115 - 957 6018
>
>
> -Original Message-
> Sent: 05 April 2002 15:08
> To: Multiple recipients of list ORACLE-L
>
>
> Well, I will put in my two cents since everyone else is.
> 1.HP-UX
> 2.HP-UX
> 3.HP-UX
> 4.Solaris
>
>
> Oracle works equally well on both of them (IMO) but HP provides you with
> better support, better hardware, better reliability, etc.  Course, none
> of that is free.
>
> All in all I have not been disappointed per say with Solaris (which
> is a good thing cause I will be working with it ALOT from here on
> it) but I have had far less issues with HP.
>
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Thursday, April 04, 2002 12:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Another shot across the bow:
>
> Hp-UX if you like to sleep at night
> Solaris if you want speed and sleepless nights
> Aix if neither of the above is of any value in your life
> Linux if both are valuable & $$$ are a consideration
>
> Dick Goulet
>
> Reply Separator
> Author: "Gene Sais" <[EMAIL PROTECTED]>
> Date:   4/4/2002 9:24 AM
>
> here go the wars :)
> 1. Solaris
> 2. HP UX
> 3. IBM AIX
>
> imho, in order.  this is definitely in the archives.
>
> gene
>
> >>> [EMAIL PROTECTED] 04/04/02 11:36AM >>>
>
> We are searching about which unix is best ?
> We will apply 9ias and 8.1.7 DB . plus Oracle Portal.
> Can you direct me to a link for comparison about SOLARIS , AIX , HP-UX
for
> performance and other options ..
> Thank you ...
>
>
> Bunyamin K. Karadeniz
> Oracle DBA / Developer
> Civilian IT Department
> Havelsan A.S. Eskisehir yolu
> 7.km Ankara Turkey
> Phone: +90 312 2873565 / 1217
> Mobile : +90 535 3357729
>
> The degree of normality in a database
> is inversely proportional to that of its DBA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: WHICH UNIX FOR ORACLE?

[Weaver, Walt]

As Steve's bunkermate I'll second the Linux thing. We're having good luck
with Linux here.

I've done AIX and Solaris, and Linux is up there with'em.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Friday, April 05, 2002 9:31 AM
To: Multiple recipients of list ORACLE-L


Lot's of listers have presented nice lists but if you don't have Linux on
your list then your experience is woefully incomplete. Long live Linux! The
war is on and those who don't join this camp soon will find themselves on
the losing side! :-)

I did HPUX. I did Solaris. Now I'm doing Linux and life is wonderful. 

Unopinionatedly yours,
Archie Bunker Steve Orr


-Original Message-
Sent: Friday, April 05, 2002 8:34 AM
To: Multiple recipients of list ORACLE-L


My experiance is just the opposite :

1. Solaris
2. Solaris
3. Solaris
4. HP-UX
5. AIX
6. Digital Unix 
7. SCO Unix

Solaris has much better features and is more reliable as per my experience.
For eg. only Solaris provides the option to use Asynchronous I/O for file
systems 
as well as raw devices. Asynchronous I/O on HP will b used only while
accessing 
raw devices.
I think that the Oracle software is primarily written on Solaris these days.

Samir

Samir Sarkar
Oracle DBA 
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0) 115 - 957 6418 Ext. 76028
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 05 April 2002 15:08
To: Multiple recipients of list ORACLE-L


Well, I will put in my two cents since everyone else is.
1.HP-UX
2.HP-UX
3.HP-UX
4.Solaris


Oracle works equally well on both of them (IMO) but HP provides you with
better support, better hardware, better reliability, etc.  Course, none
of that is free.  

All in all I have not been disappointed per say with Solaris (which
is a good thing cause I will be working with it ALOT from here on
it) but I have had far less issues with HP.

-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, April 04, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L


Another shot across the bow:

Hp-UX if you like to sleep at night
Solaris if you want speed and sleepless nights
Aix if neither of the above is of any value in your life
Linux if both are valuable & $$$ are a consideration

Dick Goulet 

Reply Separator
Author: "Gene Sais" <[EMAIL PROTECTED]>
Date:   4/4/2002 9:24 AM

here go the wars :)
1. Solaris
2. HP UX
3. IBM AIX

imho, in order.  this is definitely in the archives.

gene

>>> [EMAIL PROTECTED] 04/04/02 11:36AM >>>
We are searching about which unix is best ? 
We will apply 9ias and 8.1.7 DB . plus Oracle Portal. 
Can you direct me to a link for comparison about SOLARIS , AIX , HP-UX  for
performance and other options .. 
Thank you ...


Bunyamin K. Karadeniz   
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu 
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729

The degree of normality in a database 
is inversely proportional to that of its DBA.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  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: Weaver, Walt
  INET: [EMAIL PROTECTED]

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

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

RE: Oracle vs. MS SQL EE vs. SE

[Weaver, Walt]

Check out the following URL; it will get you started.

http://www.microsoft.com/partner/licensing/embeddedlicensing/faqs/sqllicensi
ng_faq.asp

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Monday, March 18, 2002 8:48 AM
To: Multiple recipients of list ORACLE-L


I have been asked to compare Oracle and Microsoft SQL Server. I notice that
Microsoft has introduced Standard Edition and Enterprise Edition versions.
Can anyone point me to resources that will help me compare these versions
with Oracle versions?
My impression is that Oracle introduced SE as a way to have something
equivalent to MS SQL. Now I am concerned that MS is trying to have SE and EE
versions to show equivalence to Oracle. But I need some evidence to
demonstrate this.
Any assistance will be appreciated.
Dennis Williams 
DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: The use of schemas

[Weaver, Walt]

Just for grins, tell him you've decided to put the whole application on
MySQL, and see what he does with the schema idea.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, February 13, 2002 1:00 PM
To: Multiple recipients of list ORACLE-L


Jim,

How do you know?  Yes, he wants separate tablespaces for every schema.
I wonder if he knows he can still put tables into separate tablespaces
without using separate schemas. :)

And maybe for fun.  I am going to recommend back that we use a schema
per table!

Rich


>From: [EMAIL PROTECTED] (Jim Hawkins)
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: The use of schemas
>Date: Wed, 13 Feb 2002 11:30:51 -0800
>
>Check your consultant's credentials.  From what you've indicated, there is 
>absolutely no reason to do this.  Tell him he will get to do all the 
>management of synonyms, permissions, and schema exports.  I suppose he also

>wants separate tablespaces for each of these schemas as well?
>
>Jim Hawkins
>Oracle Database Administrator
>
>
>
>"oracle dba" <[EMAIL PROTECTED]> wrote:
>
> >Hi all,
> >
> >Our consultant has presented a schema design which I have never seen
> >(not that I have seen all the designs in the world) but I also failed
> >to see the advantage.
> >
> >Basically our application consists of 35 tables and all is under one
> >schema named after the application.  Granted, the application has many
> >components such as billing tables, event tables etc.
> >
> >Now the consultant wants to split all 35 tables into as many as 8
> >different schemas!  Such as a billing schema, a event schema.  To me
> >this only complicates the whole thing as now you have to manage 8
> >schemas and manage many grants, synonyms.  Not to mention some tables
> >are not clear cut as which component it belongs to.  I just don't see
> >what this buys us.
> >
> >Has anyone seen such a approach? And what's the benefit of doing so?
> >
> >Thanks
> >
> >_
> >Join the world's largest e-mail service with MSN Hotmail.
> >http://www.hotmail.com
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: oracle dba
> >  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).
> >
>--
>_
>Jim Hawkins
>Oracle Database Administrator
>[EMAIL PROTECTED]
>
>
>
>__
>Your favorite stores, helpful shopping tools and great gift ideas. 
>Experience the convenience of buying online with Shop@Netscape! 
>http://shopnow.netscape.com/
>
>Get your own FREE, personal Netscape Mail account today at 
>http://webmail.netscape.com/
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jim Hawkins
>   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).




_
Send and receive Hotmail on your mobile device: http://mobile.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: oracle dba
  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

RE: Re[2]: Linux taking over at Oracle

[Weaver, Walt]

I think Larry lives in his own dream world. We're currently using Oracle on
inexpensive Linux servers, but that probably won't last for long.

Our Oracle licenses cost over $65,000 per server. The servers cost about
$30,000 each, and the OS is essentially free. Makes no sense at all. If
Oracle continues to insist on using its ridiculous pricing schemes we'll
probably become an all-MySQL shop, at least after InnoDB matures a bit.

I've worked with Oracle for fifteen years now, and Larry's even more flaky
now than he was back then.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Friday, February 01, 2002 6:45 AM
To: Multiple recipients of list ORACLE-L


Jonathan,

I remember reading an article in Oracle Magazine about a year to year &
a
half ago, where Uncle Larry was prostelatizing us to create one large
database
vs. having lots of small ones.  So the screw turns once more!!  Also I
remember
Oracle being torqued at RedHat some time ago & find that 9i is NOT certified
on
RedHat.  Guess that will change!  Also, for those who remember, Uncle Larry
did
predict that the "database would replace the operating system" some years
ago. 
Funny how these ideas change, don't materialize, or have other problems that
prevent them becoming reality.  But then I guess that's what you get trying
to
read a foggy crystal ball!! :-)

My problem with all of this is that he's pointing us towards cheaper
computers and operating systems, but will the cost of Oracle itself follow??
I
doubt it.  Which puts a pile of us in a rather sticky position.  How do you
justify $40K for Oracle on a $10K computer with a $0 OS?

My brain hurts.

Dick Goulet

BTW: Uncle Larry torqued off Apple (MacOS) some years ago when he dropped
support for it all together.

Reply Separator
Author: Jonathan Gennick <[EMAIL PROTECTED]>
Date:   1/31/2002 6:35 PM

Interesting news. Makes me wonder though. Remember when
Oracle moved to support client-server computing? Now Larry
derides client-server and distributed computing saying
that it's cheaper to have just one big system. How many
times have you heard Larry talk about how Oracle's
consolidated their email servers? Makes me wonder whether
five years down the road Larry will be telling us that it's
"silly to run a database on 50 cheap boxes" because it's
much easier to administer one big one.

Best regards,

Jonathan Gennick   
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com

Thursday, January 31, 2002, 2:36:21 PM, you wrote:
AMG0> Ellison says Oracle's 'whole business' to run on Linux

AMG0> The Oracle chairman and CEO said the company will replace three Unix
AMG0> servers
AMG0> that run the bulk of its business applications with a cluster of Intel
AMG0> Corp.
AMG0> servers running Linux.

AMG0> http://computerworld.com/nlt/1%2C3590%2CNAV47_STO67867_NLTAM%2C00.html

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Gennick
  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: Weaver, Walt
  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: RTFM questions (formally RE: PL/SQL)

[Weaver, Walt]

I strongly suggest you not experiment with this on your production database.

--Walt

-Original Message-
Sent: Tuesday, January 29, 2002 1:16 PM
To: Multiple recipients of list ORACLE-L


I'm a complete newbie, so I may be off-base here, but I believe that
truncating a table does not delete any data from the table.  It moves the
cursor up, thereby closing up the "empty space" where data has previously
been deleted.

--JoJo


-Original Message-
Sent: Tuesday, January 29, 2002 10:46 AM
To: Multiple recipients of list ORACLE-L


To our resident Oracle Expert who just 6 months (July 26 2001) ago posted
the following e-mail


If I remember rightly, deleting rows from the table does NOT free up
tablespace. In order to do that you have to trunctate the table (although
this of course deletes all data from the table)...I can't for the life of me
remember how you adjust the space the table is actually using after doing a
delete...(to everyone else) would an analyze work?

Kev.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: NetSaint

[Weaver, Walt]

Sorry, we have yet to monitor our databases with it. We're using it to
monitor our web servers and database servers, and to a lesser extent our EMC
boxes.

--Walt

-Original Message-
Sent: Tuesday, January 29, 2002 10:56 AM
To: Multiple recipients of list ORACLE-L


Walt:

What database 'stuff' are you monitoring with it?  So far,
they have the basic 'check_oracle' plug-in working, and they're
asking me what else to watch.  I've asked them back - what do they
want to watch?  Are you in UNIX/Linux/NT?

Thanks,
Mike

-Original Message-
Sent: Tuesday, January 29, 2002 8:50 AM
To: Multiple recipients of list ORACLE-L


We're using NetSaint here. Does the job for us, and it's a bit cheaper than
CA Unicenter...

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Tuesday, January 29, 2002 9:12 AM
To: Multiple recipients of list ORACLE-L


Has anybody heard of/used/liked/hated NetSaint?  One of our
UNIX administrators is pushing this as a cheap alternative to
CA UniCenter, and he wants to start using it to monitor systems
and databases.

Please let me know your opinions, thoughts, and locations of any
resources you are aware of.

Thanx,
Mike

---
===
Michael P. Vergara
Guidant Corporation
Oracle DBA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  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: Weaver, Walt
  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: Vergara, Michael (TEM)
  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: Weaver, Walt
  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: NetSaint

[Weaver, Walt]

We're using NetSaint here. Does the job for us, and it's a bit cheaper than
CA Unicenter...

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Tuesday, January 29, 2002 9:12 AM
To: Multiple recipients of list ORACLE-L


Has anybody heard of/used/liked/hated NetSaint?  One of our
UNIX administrators is pushing this as a cheap alternative to
CA UniCenter, and he wants to start using it to monitor systems
and databases.

Please let me know your opinions, thoughts, and locations of any
resources you are aware of.

Thanx,
Mike

---
===
Michael P. Vergara
Guidant Corporation
Oracle DBA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  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: Weaver, Walt
  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: RE: sqlplus question

[Weaver, Walt]

Kewl! That means I get to start taking drugs again.

I am a happy boy. I'll whiz over to the OT list and give Kimberly a ring.
Does she like to climb mountains?

-Original Message-
Sent: Tuesday, January 29, 2002 8:25 AM
To: Multiple recipients of list ORACLE-L


Walt, don't worry. He's speaking "WaReZ" speak. You have to
follow the White Rabbit to get out. 

For further instructions, see Kimberly. She enjoys questions like these. 

-Original Message-

I'm lost here...

--Walt

-Original Message-
Sent: Monday, January 28, 2002 10:50 PM
To: Multiple recipients of list ORACLE-L



Well, you can check the manual but use the package dbms_output.put_job that
willfix it when you are inoracle but ifyoua re
in unix environment you must use crontab

Hope this is of help for you


Roland









-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  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: Weaver, Walt
  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: RE: sqlplus question

[Weaver, Walt]

I'm lost here...

--Walt

-Original Message-
Sent: Monday, January 28, 2002 10:50 PM
To: Multiple recipients of list ORACLE-L



Well, you can check the manual but use the package dbms_output.put_job that
willfix it when you are inoracle but ifyoua re
in unix environment you must use crontab

Hope this is of help for you


Roland





"Weaver, Walt" <[EMAIL PROTECTED]>@fatcity.com den 2002-01-28 14:45 PST

Sänd svar till [EMAIL PROTECTED]

Sänt av:  [EMAIL PROTECTED]


Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Kopia:

Cron? At?

-Original Message-
Sent: Monday, January 28, 2002 3:21 PM
To: Multiple recipients of list ORACLE-L


Hello,
I need to run some script using Oracle Sqlplus.  The script is only suppose
to run certain days of week.
Does anyone have a suggestion how to do that.

Thank you.
--
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: Weaver, Walt
  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: Weaver, Walt
  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: sqlplus question

[Weaver, Walt]

Cron? At?

-Original Message-
Sent: Monday, January 28, 2002 3:21 PM
To: Multiple recipients of list ORACLE-L


Hello,
I need to run some script using Oracle Sqlplus.  The script is only suppose
to run certain days of week.
Does anyone have a suggestion how to do that.

Thank you.
-- 
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: Weaver, Walt
  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:

[Weaver, Walt]

HELP

-Original Message-
Sent: Monday, January 28, 2002 1:34 PM
To: Multiple recipients of list ORACLE-L


Walt started it. 


-Original Message-

Ahem...

Is this thing on? 

OK.

For those of you that are new, have short memories or are easily confused,
this post was not serious.  It was a joke.  One look at the senders 
address
will confirm that.

How do I turn this thing off?

Jared
( the list owner,  SA, OCP and Part Time Perl Evangelist )


















-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  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: Weaver, Walt
  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:

[Weaver, Walt]

HELP

-Original Message-
Sent: Monday, January 28, 2002 11:26 AM
To: Multiple recipients of list ORACLE-L


INDEX ORACLE-L
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kempf, Reed
  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: Weaver, Walt
  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 calculate Last and First Day of Month?

[Weaver, Walt]

select last_day(add_months(sysdate,-1)) from dual;

-Original Message-
Sent: Wednesday, January 23, 2002 2:38 PM
To: Multiple recipients of list ORACLE-L


It is the 1st. I've already got quick help on that...

thanks


--- Charlie Mengler <[EMAIL PROTECTED]> wrote:
> I would have thought that the "first day of the
> month"
> is ALWAYS the 1st, as in 1 (ONE)!
> 
> Please explain why it needs to be calculated or 
> could be a value other than ONE.
> 
> > 
> > >>> [EMAIL PROTECTED] 01/23/02 10:35AM >>>
> > Hey guys,
> > 
> > I know this is propablby easy, but I'm a bit
> > overwhelmed here this week. Can you please tell me
> how
> > to get first and last days of the month given
> SYSDATE?
> > 
> > thanks a lot
> > 
> > Regards
> >
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Charlie Mengler
>   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!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  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: Weaver, Walt
  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).