RE: Re: test

2003-09-07 Thread Rajesh Dayal
I am really happy to see such responses for my test !! 

BTW, I was just checking whether I have successfully been un-subscribed for 
my old mail-id and subscribed with new one. 

But disappointed to see that un-subscription mail reached much later than test
Mail (which actually I sent before).

And yes, will silently be watching the testG launch through net. My Damagement
Doesn't think it's worth attending these launches. ;-((

Regards,

Rajesh Dayal
Senior Oracle DBA (OCP 8,8i,9i)
International Information Technology Company LLC


 -Original Message-
Sent:   Sunday, September 07, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
Subject:Fwd: Re: test

No, no, no, no. You just live on the wrong side of the world, these days.

TestG is old, gone, dead. It's Test/g/ now. Has been for a couple of 
weeks. Notice the italics. Don't make users more ten'se than neccessary.

The first one who sees a production version of Tense/g /will forever be 
known as the g-spotter.

Connor McDonald wrote:

>I would not bother to use Test, because TestG is
>coming out very shortly. A lot of the Test programs
>have not been Test'd on version TestG which tends to
>make users a little testy
>
>:-)
>
> --- Mogens_Nørgaard <[EMAIL PROTECTED]> wrote: > I
>also need to test.
>  
>
>>Mogens
>>
>>[EMAIL PROTECTED] wrote:
>>
>>
>>
>>>
>>>Search the web by email! mailto:[EMAIL PROTECTED]
>>>adding your search to the subject line like this:
>>>search summer vacations
>>>
>>>
>>>test
>>> 
>>>
>>>  
>>>
>>-- 
>>Please see the official ORACLE-L FAQ:
>>http://www.orafaq.net
>>-- 
>>Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
>>  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
>web: http://www.oracledba.co.uk
>web: http://www.oaktable.net
>email: [EMAIL PROTECTED]
>
>"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he 
>will sit in a boat and drink beer all day"
>
>
>Want to chat instantly with your online friends?  Get the FREE Yahoo!
>Messenger http://uk.messenger.yahoo.com/
>  
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: [EMAIL PROTECTED]

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

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

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


RE: Urgent INFO needed. - OFF TOPIC

2003-09-07 Thread VIVEK_SHARMA

Well-Spoken Indeed

-Original Message-
Sent: Friday, September 05, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L

Yes, in your experience...and maybe most of the other lister's
experience...majority of the time its true...
That's because you people are the best DBAs I've seen...
Your experiences...10...15 years...some of you have a little over 3 years and are
already experts...
Of course a lot of other people are less skilled than you are...
But I am not sure if you represent the rest of the US DBAs...or if I represent the
rest of the 3rd world DBAs...
Again, as I have said...some peopler are just better than others...that's my
opinion...obviously, yours is a lot different than mine...

I don't know you, Joe, well enough to judge you.
So I won't call you names.

Joe Testa wrote:

> Fact of the matter is the majority of the time its true, like it or
> not.  Those of you who know me, know I DON'T do politically correct, I
> call a spade a spade.
>
> Its true at the officer level in a company(and I'm there in the company
> I'm in now), its all about dollars and cents, especially today.   Thats
> why you see it as much as you do.
>
> My example:  I worked for an online training company, they were paying
> me $25/hr to do online tutoring or web based oracle DBA classes., I was
> with them from the beginning just like alot of other tutors from around
> th world.  We were told in early/mid 2002, we've decided to outsource
> all tutoring to India, so if you're interested in teaching your
> replacements, we'll keep you on board for a little extra time.  The end
> was near and someone had asked me how long I'd been doing it, how long I
> was a DBA and how long did I plan on doing it, i gave them the truthful
> answer, about 4 yrs, 10 years as a DBA and not much longer since it was
> all being outsourced to India, got my a$$ fired from the job before my
> time was up.   Basically the concept was: "we can go to India and pay
> $2.50, 10% of what we pay you and we really dont care about the quality
> because they will pick up their English language from previous answers
> you and others have submitted to students throughout the years.".
>
> You tell me I  shouldn't have an attitude, you're as full of garbage as
> them.
>
> Joe
>
> PS: for those who want to know the company, email me direct, i'll be
> glad to share.
>
> Maria Aurora de la Vega wrote:
>
> > Its quite unfair for DBAs to blame their job loss/fear of job loss to
> > DBAs in India or some other countries with cheaper labor.
> > And to say that "you get what you pay for" or insinuating that cheaper
> > labor means less quality...is definitely out of line...
> > some people are just better than others...that's it...it has nothing
> > to do with geography or nationality...
> > some of the best DBAs...or IT professionals in general...are in fact
> > indians...
> > Point is its not the indians' fault jobs just come knocking at their
> > doors...
> > we all want better jobs and better pay...if it comes to me i'll grab
> > it no doubt... would I think about other DBAs who were taken off to
> > accomodate me? of course not. I have nothing to do with their decision
> > to outsource...and even if I stress myself worrying about it...can I
> > do anything about it? no...so, what do I do...I'd take advantage of
> > course...
> > I've come to believe no one is indispensable...even if you've served
> > 5, 10, 15 years in a company...there's always a reason to take you out
> > no matter how good you are...
> > And sometimes companies think...do I really need someone that good and
> > costs a lot more? or can we do with someone quite average but can get
> > the job done and costs a lot less?
> >
> > Tony Johnson wrote:
> >
> >>  All I know about it is that for every new job in India one more DBA
> >> is out of work here in the United States.
> >>
> >> -Original Message-
> >> *From:* Ora DBA [mailto:[EMAIL PROTECTED]
> >> *Sent:* Wednesday, September 03, 2003 5:30 AM
> >> *To:* Multiple recipients of list ORACLE-L
> >> *Subject:* Urgent INFO needed.
> >>
> >> Dear Friends,
> >>
> >> One of my friends has got the offer from CSC india ltd. Please
> >> respond this mail if any one from CSC india ltd? just to know
> >> some info , thats it.
> >>
> >> Any info regarding this is appreciated. Please give me your mail
> >> id and contacts..
> >>
> >> Thanks a lot.
> >>
> >> Regards
> >>
> >> Oracle DBA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: VIVEK_SHARMA
  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 ORA

Re: Forms 3 and 9i

2003-09-07 Thread Mogens Nørgaard
Nah, that's not neccessary. It's the same guy that took them from 7 to 8 
and who will take them from 9 to 10 :-), namely our Jutland Department 
named Johannes.

We had a meeting about iAS in the Danish user group the other day 
(OUGDK) titled "Can you get by without iAS?", in other words is it 
possible to create solutions without iAS. The answer, except for Forms & 
Reports, is of course yes, but you would then have to put a lot of stuff 
together yourself, and Oracle does a rather OK job on the Java front 
there. But that's another story.

The interesting discussion quickly became what to do about Forms & 
Reports. Everybody agreed there isn't much of a future for these 
products, but what would they use instead? A lot of Forms-folks noted 
that 1) Forms works very well these days and 2) Java code is so much 
bigger and more complicated. So although we all pretty much agreed that 
it's Java or .Net as development platforms in the coming years, people 
would still (especially in the large shops) continue using Forms.

Mogens

Smart Aleck DBA wrote:

.. and be sure to document for the next poor slob
that has to act as admin for this mess


On Thu, 21 Aug 2003, Peter Gram wrote:

 

Hi

Yes it is posible to use Forms 3.x agenst a version 9.x database.
My friend and coworker have implanted it at site on a sun box.
The way to do this is to install Forms 3.x ( 7.2.x dist ?)
in a new $OH and apliey a Forms 4 patch (xxx) to the forms $OH.
Set the unix environment var. TWO_TASK to point to a IPC alias
to the listener that can connect to the 9.x database.
The hard part is to find the Forms 4 patch (xx) it is not possible
to order it from Oracle support but I think it as distributed with
the 7.3.x Oracle database kit !


Senthil Kumar wrote:

   

Hi All,

Will forms 3 works with 9i. Any known issues in this.

TIA,
Senthil.
 

--
Peter Gram, Miracle A/S
Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696
mail  : [EMAIL PROTECTED] - http://MiracleAS.dk
Upcoming events:
DatabaseForum 2003, Lalandia 2-4 October
Visit   http://miracleas.dk/events/DBF2003/invitation.html
Miracle Master Class with Tom Kyte, 12-14 January 2004



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Peter Gram
 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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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: DB2 has a foot in the door

2003-09-07 Thread Mogens Nørgaard
Cost is the easy one. They run comparable to Microsoft or thereabout. 
They have various options I haven't looked at yet, that might make them 
more expensive than that. The DB2 on mainframes and the DB2 on Unix, for 
instance, were written by different teams. Which might explain why they 
didn't port the time-based instrumentation from the mainframe 
environment to the Unix port. So yeah, you probably can't just take code 
and move it. They have a pretty good porting tool between Oracle and 
DB2, though. We thought that was rather neat when we ran it against one 
of our customer's database definitions. The PL/SQL conversion came out 
alright, too, although there of course are things they can't do and vice 
versa.

Broadly speaking, I think you can divide the databases of the world into 
three categories:

1. Oracle, with very good locking strategies, very good read consistency 
model, very good performance measurement instrumentation (time-based).
2. Other relational databases such as DB2, Sybase, SQL Server, Informix, 
etc. where they all share the same (to us Oracle-techies) strange 
locking philosophy, the same consistency model where you have to code 
more, and no wait-interface.
3. The rest.

re 2: The locking philosophy difference means that you can still have 
readers block writers and writers block readers, unless you specifically 
handle how to do it on the transactional level. This explains why 
cloning databases for reporting purposes is so popular with other 
databases compared to the Oracle world :).

IBM has pointed out in various whitepapers something which to us doesn't 
make sense, but which might make sense to others: If you want to have a 
portable application, you should probably choose one of the category II 
databases, since they're all pretty much alike in their behaviour on the 
important aspects of locking and read consistency. If you have to go to 
or from Oracle to or from another database, you'd have to change code a 
good deal or live with non-optimal conditions after the migration.

Mogens

Tom Ryan wrote:

have you used DB2? How does it compare to Oracle? Ive seen tom kyte write
that each platform that DB2 runs on is in essence a different database and
you cant take code from one platform and move it to another.
are the features comparable? what about cost?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, September 07, 2003 8:54 AM
 

VERY interesting. They refused to do site licensing at a 2
installation here. Thank you for this tip.
Rachel Carmichael wrote:

   

Oracle does site licensing... but only if you are a very very large
corporation. Citibank (when I worked there) had one. The company I work
for now has one.
So I don't ask "do we have a license" when I want to install a new
version of Oracle, even if it is a new platform
One of the few things that is easier working in a rigid corporate
environment
--- Mogens_Nørgaard <[EMAIL PROTECTED]> wrote:

 

There's one thing that IBM can do, which Microsoft and Oracle can't
offer: They do site licenses as well as cpu and user licensing. That
just gives them an incredible advantage to management and others who
can
stop thinking about whether they should buy another server, move
stuff
   

from one server to the other, etc. I can't believe Oracle and
 

Microsoft
are not doing it (I think I can guess, but it's still not good).
Mladen Gogala wrote:



   

I believe that the answer to Stephane's question is obvious:
Oracle 10g will cost 10 grands/ CPU. That's where the letter "g"
is coming from.
--
Mladen Gogala
Oracle DBA


-Original Message-
DENNIS WILLIAMS
Sent: Friday, September 05, 2003 5:30 PM
To: Multiple recipients of list ORACLE-L
Stephane
 We've been very excited about Oracle Standard Edition. Helped
 

stave off

   

the interest in MS SQL. Given the budget pressures at many

 

organizations,

   

I'm surprised we don't hear more about this alternative.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, September 05, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L
Hi all,

We're an Oracle shop, over 140 Oracle instances.
Today, architecture has chosen IBM DB2 for BI projects.
The next step I guessed will be to choose DB2 for the new
 

transactionnal

   

applications also.

IBM offers DB2 at 25% less than Oracle.

I wonder if Oracle 10G will come with a new pricing structure ?

Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED]
 



   





 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, Californ

Re: 600-[25012] on delete of IOT table

2003-09-07 Thread zhu chao
hi, GovindanK:
I searched metalink  and cannot find note:287936.999 you mentioned.
And I did not move the IOT index segment and overflow segment online. I
did those operation during system outage.
Thanks.

Regards
zhu chao
msn:[EMAIL PROTECTED]
www.cnoug.org
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 05, 2003 9:54 AM


> Take a look at the Metalink  Note:125149.1
> ALERT: ONLINE Index Rebuild or IOT Table Move can Produce Corrupt Index
> As per the note it affects 8.1.(5/6/7).x
>
> It has the relevant info.
>
> Also take a look at the Docid: 287936.999.
>
> HTH
> GovindanK
>
> > Sun solaris 8/oracle 8.1.7.2 64bit.
> >
> > After some database defrag(via alter table xxx move and alter index xxx
> > rebuild), I got 600-25012 from my delete session and alert file.
> >
> >
> > SQL>  DELETE FROM EOI_PDTLIST WHERE ROWNUM=1;
> >  DELETE FROM EOI_PDTLIST WHERE ROWNUM=1
> >  *
> > ERROR at line 1:
> > ORA-00600: internal error code, arguments: [25012], [15], [32], [], [],
> > [], [],
> > []
> >
> > This is index organized table with overflow segment.
> > Maybe I foget to move that overflow segment, after move overflow segment
,
> > delete is ok.
> >
> > But according to metalink ,maybe there is data corruption. So I ask here
> > if friends in this list has also hit this nasty problem too.
> >
> >
> > Fri Sep  5 04:29:58 2003
> > Errors in file /export/home/oracle/admin/biddb/udump/biddb_ora_3602.trc:
> > ORA-00600: internal error code, arguments: [25012], [15], [32], [], [],
> > [], [], []
> > Fri Sep  5 04:30:33 2003
> > Errors in file /export/home/oracle/admin/biddb/udump/biddb_ora_3602.trc:
> > ORA-00600: internal error code, arguments: [25012], [15], [32], [], [],
> > [], [], []
> > Fri Sep  5 04:36:08 2003
> >
> > I dbved the datafiles of that tablespace , nothing wrong.
> > My account in metalink cannot open Itar now:(
> > Thanks
> >
> > Zhu Chao
> > www.cnoug.org
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: chao_ping
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: GovindanK
>   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: zhu chao
  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).


Parallel index read without "alter index..." ?

2003-09-07 Thread Mark Richard

Hi List,

I was wondering if anyone knows a technique to make a query read an index
in parallel without issuing an "alter index ... parallel 2" command?  With
a table the parallel hint works fine but I've never seen it done for an
index.

The query which requires the hint will be issued as a once-off again a
production environment so modifying the object pernamently is not an option
unfortunately.

Regards,
  Mark.

<<>>
   Privileged/Confidential information may be contained in this message.
  If you are not the addressee indicated in this message
   (or responsible for delivery of the message to such person),
you may not copy or deliver this message to anyone.
In such case, you should destroy this message and kindly notify the sender
   by reply e-mail or by telephone on (61 3) 9612-6999.
   Please advise immediately if you or your employer does not consent to
Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this message
  that do not relate to the official business of
 Transurban City Link Ltd
 shall be understood as neither given nor endorsed by it.
<<<>




<<>>
Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message (or responsible for delivery of 
the message to such person), you may not copy or deliver this message to anyone.
In such a case, you should destroy this message and kindly notify the sender by reply 
e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999.
Please advise immediately if you or your employer does not consent to Internet e-mail 
for messages of this kind.
Opinions, conclusions and other information in this message that do not relate to the 
official business of Transurban Infrastructure Developments Limited and CityLink 
Melbourne Limited shall be understood as neither given nor endorsed by them.
<<>>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Richard
  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 World - Listers get together (proposed Tuesday Sep 9)

2003-09-07 Thread Rachel Carmichael
I swear, he drives insane distances for a drink and dinner.

And Tim -- they NEVER have one drink and then leave these are DBAs
you are speaking of!


--- Tim Gorman <[EMAIL PROTECTED]> wrote:
> I've never been to Open World and this year will be no exception, but
> as it
> turns out I'm working Tues-Fri in Sacramento, only two hours up the
> road or
> so I'm told.  If they release me by 5:00pm then (theoretically) I can
> be at
> Chevy's by 7:00pm or so.  As Rachel and Jared can attest, I'll drive
> insane
> distances after work through the worst traffic to make a happy
> hour...
> 
> If you folks don't just have one drink and then bolt, I'd like to try
> to
> meet some of you for the first time, and others for the umpteenth
> time?
> Gonna be fun...
> 
> Mogens, I'll have a double Margarita for you also.  No salt though,
> but
> perhaps a goat-milk chaser.  I'd likely get my dose of salt from the
> milk,
> as Cary suggested...
> 
> Thanks for putting this all together, John...
> 
> 
> 
> 
> on 9/7/03 3:14 PM, Cary Millsap at [EMAIL PROTECTED] wrote:
> 
> > Yes, I will do that for you, my friend.
> > 
> > 
> > Cary Millsap
> > Hotsos Enterprises, Ltd.
> > http://www.hotsos.com
> > 
> > Upcoming events:
> > - Hotsos Clinic 101 in Sydney
> > - Hotsos Symposium 2004, March 7-10 Dallas
> > - Visit www.hotsos.com for schedule details...
> > 
> > 
> > -Original Message-
> > Mogens Nørgaard
> > Sent: Sunday, September 07, 2003 2:24 AM
> > To: Multiple recipients of list ORACLE-L
> > 9)
> > 
> > Wish I could be there, but I can't. It will be Paris for me this
> year,
> > and of course an award-winner lunch with the editor of Oracle
> Magazine
> > and others :-).
> > 
> > I wish I could be there with you guys, though. Cary - could you
> have a
> > Margarita for me, please? Double, lots of salt?
> > 
> > Mogens
> > 
> > Steve McClure wrote:
> > 
> >> I will try to be there as well.  Possibly two of us, Alec
> Macdonell who
> >> lurks about this list as well.
> >> 
> >> Steve McClure
> >> 
> >> -Original Message-
> >> John Kanagaraj
> >> Sent: Wednesday, September 03, 2003 2:54 PM
> >> To: Multiple recipients of list ORACLE-L
> >> 
> >> 
> >> Hi all,
> >> 
> >> We talked about this earlier and I wanted to get this mail out
> before
> >> everyone participating departs for OOW. I would propose a Lister's
> >> get-together on the evening of Tuesday Sep 9. Monday is the first
> day,
> > Wed
> >> has the 'OracleWorld Appreciation day' in the evening and I am
> assuming
> >> there will be felicatations for Arup and Mogens at this time...
> (and
> > Thu
> >> ends it all).
> >> 
> >> I have the following that have responded (in no particular order):
> Arup
> >> Nanda, Jonathan Gennick, Matthew Adams, Brian McGraw, Ari Kaplan,
> Cary
> >> Millsap (+ other Gurus - Cary brought along Tom Kyte and Kyle
> Hailey
> > last
> >> time?), Connor McDonald (all the way from Down under!), Greg
> > Loughmiller,
> >> Matthew Zito, Molina Gerardo and self.
> >> 
> >> We will meet over Dinner at a restaurant across the street from
> Moscone
> >> Center - probably from about 6:30PM? The address is:
> >> 
> >> Chevy's
> >> 201 3rd Street (corner of 3rd and Howard)
> >> San Francisco, CA 94105
> >> 415-543-8060
> >> 
> >> I will send out a reminder email closer to that time (like Monday
> :)
> > Let me
> >> know if there are additional numbers...
> >> 
> >> John Kanagaraj
> >> DB Soft Inc
> >> Phone: 408-970-7002 (W)
> >> 
> >> Disappointment is inevitable, but Discouragement is optional!
> >> 
> >> ** The opinions and facts contained in this message are entirely
> mine
> > and do
> >> not reflect those of my employer or customers **
> >> --
> >> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >> --
> >> 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.net
> > -- 
> > Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
> > 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

Re: latch free wait event

2003-09-07 Thread Tim Gorman
You sir, are one hell of a great communicator!  I'm placing my order now...


on 9/5/03 7:19 AM, Cary Millsap at [EMAIL PROTECTED] wrote:

> Yes. Even with TIMED_STATISTICS=TRUE, relying on *any* statistic with
> system-wide scope can waste your time. For a 34-page introduction to the
> rationale behind this proposition, see:
> 
>http://www.oreilly.com/catalog/optoraclep/chapter/ch01.pdf
> 
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - Hotsos Clinic 101 in Sydney
> - Hotsos Symposium 2004, March 7-10 Dallas
> - Visit www.hotsos.com for schedule details...
> 
> 
> -Original Message-
> Wolfgang Breitling
> Sent: Thursday, September 04, 2003 6:44 PM
> To: Multiple recipients of list ORACLE-L
> 
> The number of waits is irrelevant. What matters is the time waited which
> in 
> your case shows 0, but I assume that is because you have not set
> timed_statistics to true. Without that the data from v$system_event are
> worthless. Cary will probably step in here and tell you that even with
> timed_statistics that data is at best of dubious worth.
> 
> At 02:49 PM 9/4/2003 -0800, you wrote:
> 
>> System-wide Wait Analysis
>>  for current wait events
>> 
>> 
> Average
>> Event Total  SecondsTotal
> Wait
>> NameWaits  Waiting Timeouts  (in
> secs)
>> -   -   -   -
>> ---
>> latch free1,4590 1,393
> .000
>> 
>> After querying v$system_event my biggest concern is the "latch free"
> wait
>> event. I understand that latch free is "the process waits for a latch
> that
>> is currently busy ( held by another process).How can I drill down
> and
>> find the cause of this?   I have a feeling it is about rollback or redo
>> logs.
>> 
>> thanks,
>> 
>> 
>> 
>> David Ehresmann
>> 
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> --
>> Author: Ehresmann, David
>>   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).
> 
> Wolfgang Breitling
> Oracle7, 8, 8i, 9i OCP DBA
> Centrex Consulting Corporation
> http://www.centrexcc.com
> 

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

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


Re: Oracle World - Listers get together (proposed Tuesday Sep 9)

2003-09-07 Thread Tim Gorman
I've never been to Open World and this year will be no exception, but as it
turns out I'm working Tues-Fri in Sacramento, only two hours up the road or
so I'm told.  If they release me by 5:00pm then (theoretically) I can be at
Chevy's by 7:00pm or so.  As Rachel and Jared can attest, I'll drive insane
distances after work through the worst traffic to make a happy hour...

If you folks don't just have one drink and then bolt, I'd like to try to
meet some of you for the first time, and others for the umpteenth time?
Gonna be fun...

Mogens, I'll have a double Margarita for you also.  No salt though, but
perhaps a goat-milk chaser.  I'd likely get my dose of salt from the milk,
as Cary suggested...

Thanks for putting this all together, John...




on 9/7/03 3:14 PM, Cary Millsap at [EMAIL PROTECTED] wrote:

> Yes, I will do that for you, my friend.
> 
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - Hotsos Clinic 101 in Sydney
> - Hotsos Symposium 2004, March 7-10 Dallas
> - Visit www.hotsos.com for schedule details...
> 
> 
> -Original Message-
> Mogens Nørgaard
> Sent: Sunday, September 07, 2003 2:24 AM
> To: Multiple recipients of list ORACLE-L
> 9)
> 
> Wish I could be there, but I can't. It will be Paris for me this year,
> and of course an award-winner lunch with the editor of Oracle Magazine
> and others :-).
> 
> I wish I could be there with you guys, though. Cary - could you have a
> Margarita for me, please? Double, lots of salt?
> 
> Mogens
> 
> Steve McClure wrote:
> 
>> I will try to be there as well.  Possibly two of us, Alec Macdonell who
>> lurks about this list as well.
>> 
>> Steve McClure
>> 
>> -Original Message-
>> John Kanagaraj
>> Sent: Wednesday, September 03, 2003 2:54 PM
>> To: Multiple recipients of list ORACLE-L
>> 
>> 
>> Hi all,
>> 
>> We talked about this earlier and I wanted to get this mail out before
>> everyone participating departs for OOW. I would propose a Lister's
>> get-together on the evening of Tuesday Sep 9. Monday is the first day,
> Wed
>> has the 'OracleWorld Appreciation day' in the evening and I am assuming
>> there will be felicatations for Arup and Mogens at this time... (and
> Thu
>> ends it all).
>> 
>> I have the following that have responded (in no particular order): Arup
>> Nanda, Jonathan Gennick, Matthew Adams, Brian McGraw, Ari Kaplan, Cary
>> Millsap (+ other Gurus - Cary brought along Tom Kyte and Kyle Hailey
> last
>> time?), Connor McDonald (all the way from Down under!), Greg
> Loughmiller,
>> Matthew Zito, Molina Gerardo and self.
>> 
>> We will meet over Dinner at a restaurant across the street from Moscone
>> Center - probably from about 6:30PM? The address is:
>> 
>> Chevy's
>> 201 3rd Street (corner of 3rd and Howard)
>> San Francisco, CA 94105
>> 415-543-8060
>> 
>> I will send out a reminder email closer to that time (like Monday :)
> Let me
>> know if there are additional numbers...
>> 
>> John Kanagaraj
>> DB Soft Inc
>> Phone: 408-970-7002 (W)
>> 
>> Disappointment is inevitable, but Discouragement is optional!
>> 
>> ** The opinions and facts contained in this message are entirely mine
> and do
>> not reflect those of my employer or customers **
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> --
>> 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.net
> -- 
> Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
> INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Cary Millsap
> INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> T

Re: question for internals experts

2003-09-07 Thread Pete Finnigan
Hi

Have a look at Yong Huangs web site, I cannot remember the URL but there
are links to some of his pages including his X$ speculations on my page
http;//www.petefinnigan.com/orasec.htm - look for Yong Huang

hth

kind regards

Pete

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
writes
>Does oracle store the tablespace_name or any data about a tablespace anywhere 
>else accept TS$? 
>
>Im looking for base data dictionary tables. Not views. Are there any documents 
>out there about how oracle stores information in the data dictionary tables 
>other than what Steve Adams has in his book or on his website? Has anyone else 
>published on this? 
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.net

-- 
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).


Re: external procedure as not-oracle on OS

2003-09-07 Thread Pete Finnigan
Hi

This would be a security risk to have a java callout that can execute
any OS command with group ID DBA, this means it could for instance..
call sqlplus -s and execute a script that changes the SYS
passwordedit the password file and change the password hashes to
known values...why not just delete the data files

please think again and run extproc as a user such as the Unix user
"nobody" then any OS command has less chance of causing damage. See
"Oracle security step-by-step" book for info on how to set it up or Tom
Kytes book, I think mentions this as well.

hth

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).


RE: Oracle World - Listers get together (proposed Tuesday Sep 9)

2003-09-07 Thread Cary Millsap
Yes, I will do that for you, my friend.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic 101 in Sydney
- Hotsos Symposium 2004, March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Mogens Nørgaard
Sent: Sunday, September 07, 2003 2:24 AM
To: Multiple recipients of list ORACLE-L
9)

Wish I could be there, but I can't. It will be Paris for me this year, 
and of course an award-winner lunch with the editor of Oracle Magazine 
and others :-).

I wish I could be there with you guys, though. Cary - could you have a 
Margarita for me, please? Double, lots of salt?

Mogens

Steve McClure wrote:

>I will try to be there as well.  Possibly two of us, Alec Macdonell who
>lurks about this list as well.
>
>Steve McClure
>
>-Original Message-
>John Kanagaraj
>Sent: Wednesday, September 03, 2003 2:54 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi all,
>
>We talked about this earlier and I wanted to get this mail out before
>everyone participating departs for OOW. I would propose a Lister's
>get-together on the evening of Tuesday Sep 9. Monday is the first day,
Wed
>has the 'OracleWorld Appreciation day' in the evening and I am assuming
>there will be felicatations for Arup and Mogens at this time... (and
Thu
>ends it all).
>
>I have the following that have responded (in no particular order): Arup
>Nanda, Jonathan Gennick, Matthew Adams, Brian McGraw, Ari Kaplan, Cary
>Millsap (+ other Gurus - Cary brought along Tom Kyte and Kyle Hailey
last
>time?), Connor McDonald (all the way from Down under!), Greg
Loughmiller,
>Matthew Zito, Molina Gerardo and self.
>
>We will meet over Dinner at a restaurant across the street from Moscone
>Center - probably from about 6:30PM? The address is:
>
>Chevy's
>201 3rd Street (corner of 3rd and Howard)
>San Francisco, CA 94105
>415-543-8060
>
>I will send out a reminder email closer to that time (like Monday :)
Let me
>know if there are additional numbers...
>
>John Kanagaraj
>DB Soft Inc
>Phone: 408-970-7002 (W)
>
>Disappointment is inevitable, but Discouragement is optional!
>
>** The opinions and facts contained in this message are entirely mine
and do
>not reflect those of my employer or customers **
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>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.net
-- 
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: [EMAIL PROTECTED]

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


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

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


Re: offshoring article

2003-09-07 Thread M Rafiq
Most possibly Xerox, but I am not sure...

Regards
Rafiq


Re: DB2 has a foot in the door

2003-09-07 Thread Ryan
how does DB2 compare to oracle cost wise? what about hard ware? does db2
require more hard ware than oracle does?
how does its features compare?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, September 07, 2003 2:24 PM


>
> One of my previous employers had a site license.  Not a huge
> site, but not too small either.  About 5000 employees, lots
> of IT in that business.
>
> Not only a site license, but a 72% discount.  We had a *good*
> negotiator.
>
> Jared
>
> On Sun, 2003-09-07 at 00:34, Mogens Nørgaard wrote:
> > There's one thing that IBM can do, which Microsoft and Oracle can't
> > offer: They do site licenses as well as cpu and user licensing. That
> > just gives them an incredible advantage to management and others who can
> > stop thinking about whether they should buy another server, move stuff
> > from one server to the other, etc. I can't believe Oracle and Microsoft
> > are not doing it (I think I can guess, but it's still not good).
> >
> > Mladen Gogala wrote:
> >
> > >I believe that the answer to Stephane's question is obvious:
> > >Oracle 10g will cost 10 grands/ CPU. That's where the letter "g"
> > >is coming from.
> > >
> > >--
> > >Mladen Gogala
> > >Oracle DBA
> > >
> > >
> > >
> > >-Original Message-
> > >DENNIS WILLIAMS
> > >Sent: Friday, September 05, 2003 5:30 PM
> > >To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >Stephane
> > >We've been very excited about Oracle Standard Edition. Helped stave
off
> > >the interest in MS SQL. Given the budget pressures at many
organizations,
> > >I'm surprised we don't hear more about this alternative.
> > >
> > >Dennis Williams
> > >DBA, 80%OCP, 100% DBA
> > >Lifetouch, Inc.
> > >[EMAIL PROTECTED]
> > >
> > >
> > >-Original Message-
> > >Sent: Friday, September 05, 2003 4:09 PM
> > >To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >Hi all,
> > >
> > >We're an Oracle shop, over 140 Oracle instances.
> > >Today, architecture has chosen IBM DB2 for BI projects.
> > >The next step I guessed will be to choose DB2 for the new
transactionnal
> > >applications also.
> > >
> > >IBM offers DB2 at 25% less than Oracle.
> > >
> > >I wonder if Oracle 10G will come with a new pricing structure ?
> > >
> > >
> > >Stephane Paquette
> > >Administrateur de bases de donnees
> > >Database Administrator
> > >Standard Life
> > >www.standardlife.ca
> > >Tel. (514) 499-7999 7470 and (514) 925-7187
> > >[EMAIL PROTECTED]

> > >
> > >
> > >
> > >
> > >
> > >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
> >   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: Ryan
  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: Dead locks how ?

2003-09-07 Thread Jared Still

There are many kinds of deadlocks in the Oracle world.

The following MetaLink notes will be of interest. 

166924.1
62365.1

There are no doubt others, but these are two I had bookmarked.

Jared

On Sat, 2003-09-06 at 00:54, Mladen Gogala wrote:
> Harvey Deitel: Operating Systems.
> Andrew Tannenbaum: Modern Operating Systems
> Avi Silbershatz: Operating System Concepts
> 
> 
> 
> On 2003.09.06 00:14, Veeraraju_Mareddi wrote:
> > What is a dead lock ? Does oracle manages with a dead lock or DBA has to
> > involve ? What are other locks , latches A DBA has to take care of. Any
> > examples, docs, notes will be helpful.
> > 
> > Thanks
> > Rajuveera
> > **
> > This email (including any attachments) is intended for the sole use of the
> > intended recipient/s and may contain material that is CONFIDENTIAL AND
> > PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
> > distribution or forwarding of any or all of the contents in this message is
> > STRICTLY PROHIBITED. If you are not the intended recipient, please contact
> > the sender by email and delete all copies; your cooperation in this regard
> > is appreciated.
> > **
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Veeraraju_Mareddi
> >   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).
> >
> 
> --
> Mladen Gogala
> Oracle DBA
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Mladen Gogala
>   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).


Re: DB2 has a foot in the door

2003-09-07 Thread Jared Still

One of my previous employers had a site license.  Not a huge
site, but not too small either.  About 5000 employees, lots
of IT in that business.

Not only a site license, but a 72% discount.  We had a *good*
negotiator.

Jared

On Sun, 2003-09-07 at 00:34, Mogens Nørgaard wrote:
> There's one thing that IBM can do, which Microsoft and Oracle can't 
> offer: They do site licenses as well as cpu and user licensing. That 
> just gives them an incredible advantage to management and others who can 
> stop thinking about whether they should buy another server, move stuff 
> from one server to the other, etc. I can't believe Oracle and Microsoft 
> are not doing it (I think I can guess, but it's still not good).
> 
> Mladen Gogala wrote:
> 
> >I believe that the answer to Stephane's question is obvious:
> >Oracle 10g will cost 10 grands/ CPU. That's where the letter "g" 
> >is coming from.
> >
> >--
> >Mladen Gogala
> >Oracle DBA 
> >
> >
> >
> >-Original Message-
> >DENNIS WILLIAMS
> >Sent: Friday, September 05, 2003 5:30 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Stephane
> >We've been very excited about Oracle Standard Edition. Helped stave off
> >the interest in MS SQL. Given the budget pressures at many organizations,
> >I'm surprised we don't hear more about this alternative.
> >
> >Dennis Williams
> >DBA, 80%OCP, 100% DBA
> >Lifetouch, Inc.
> >[EMAIL PROTECTED] 
> >
> >
> >-Original Message-
> >Sent: Friday, September 05, 2003 4:09 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Hi all,
> >
> >We're an Oracle shop, over 140 Oracle instances.
> >Today, architecture has chosen IBM DB2 for BI projects.
> >The next step I guessed will be to choose DB2 for the new transactionnal
> >applications also.
> >
> >IBM offers DB2 at 25% less than Oracle.
> >
> >I wonder if Oracle 10G will come with a new pricing structure ?
> >
> >
> >Stephane Paquette
> >Administrateur de bases de donnees
> >Database Administrator
> >Standard Life
> >www.standardlife.ca
> >Tel. (514) 499-7999 7470 and (514) 925-7187
> >[EMAIL PROTECTED] 
> >
> >
> >
> >
> >  
> >
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
>   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).


Re: question for internals experts

2003-09-07 Thread Tim Gorman
In addition to the DBA_TABLESPACES view which is based on the TS$ table, the
V$TABLESPACE view is based on the X$KCCTS fixed table.  X$ tables are purely
read-only from SQL or any other API into the RDBMS.

I believe that this view came into being relatively recently, in either the
v8.0 or v8.1 timeframe, mainly to support RMAN functionality, I think,
allowing RMAN access to information about tablespaces while the database is
in MOUNT mode.

So, updating the TS$ table would likely turn your database into scrap.

Hope this helps!



on 9/5/03 6:34 PM, Ryan at [EMAIL PROTECTED] wrote:

> we publish from the same staging server daily to our master server. So we
> update our staging server to change the name. Then do the export. We thought
> about changing the export file, but its in binary and we couldnt make it
> work.
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, September 05, 2003 9:24 PM
> 
> 
>> ... A stupid solution might be to prefix the name of each tablespace
>> with the name of the database it was created in ... you might have to
>> play with users' quotas to allow them to create tables in the
>> tablespaces you have plugged in but it is infinitely better than
>> updating SYS tables ... I have done it in the past but always after a
>> very very careful study of the situation and only because I really was
>> cornered (and had a good backup).
>> 
>> Jacques Kilchoer wrote:
>>> 
>>> I think this would be the perfect time for you, as DBA, to explain to
> the Powers That Be that updating SYS.TS$ is a BAD idea and that the
> transportable tablespace plan has to change. You have damning evidence at
> this point in time. You will be doing yourself and your successors a big
> favour.
>>> 
>>> -Original Message-
>>> 
>>> not my call. i posted this on here before. was done that way before i
> got here. Its part of the transportable tablespace plan since you cant have
> multiple tablespaces with the same name in one instance.
>>> 
>>> ... However, for the second time flushing the shared pool has not
> worked. ...
>>> --
>>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>>> --
>>> Author: Jacques Kilchoer
>>>   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).
>> 
>> --
>> Regards,
>> 
>> Stephane Faroult
>> Oriole Software
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> --
>> Author: Stephane Faroult
>>   INET: [EMAIL PROTECTED]
>> 
>> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>> San Diego, California-- Mailing list and web hosting services
>> -
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from).  You may
>> also send the HELP command for other information (like subscribing).
>> 

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

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


RE: Offshore threat

2003-09-07 Thread Richard Ji
Maybe the thieves are running Oracle on HP and they need to
add two more CPU to their server.


-Original Message-
From:   Mogens Nørgaard [mailto:[EMAIL PROTECTED]
Sent:   Sun 9/7/2003 4:49 AM
To: Multiple recipients of list ORACLE-L
Cc: 
Subject:Re: Offshore threat
While I was still in Oracle, thieves broke into the offices of Oracle in 
Oslo, Norway, and removed two HP cpu's from the main computer there. 
They ignored all the nice laptops on the tables around them. Now, that 
is weird.

Mladen Gogala wrote:

>Two IBM mainframes stolen? Boy, the times are changing! To steal only a
>single 3090 600J,
>one would need a whole infantry division, not just two guys with a dolly. 
>I bet they'll end up running Linux and having a ton of Jared's perl scripts
>on them.
>
>--
>Mladen Gogala
>Oracle DBA 
>
>
>
>-Original Message-
>Wolfe Stephen S GS-11 6 MDSS/SGSI
>Sent: Friday, September 05, 2003 11:14 AM
>To: Multiple recipients of list ORACLE-L
>
>
>http://www.smh.com.au/articles/2003/09/04/1062548967124.html
>
>A - This is social engineering at its finest.
>
>B - There is no security without PHYSICAL security
>
>C - If you don't check up on your outsourcer, then you can apparently get
>the shirt stolen off your back...
>
> 
>
>v/r
>
>Stephen S. Wolfe, GS-11, DAFC
>Data Services Manager
>[EMAIL PROTECTED]
>(813) 827-9974  DSN 651-9974
>
>
>
>  
>
>>-Original Message-
>>From: Stephane Paquette [mailto:[EMAIL PROTECTED]
>>Sent: Thursday, September 04, 2003 3:15 PM
>>To: Multiple recipients of list ORACLE-L
>>Subject: RE: Offshore threat
>>
>>
>>When working at International Air Transport Association
>>(IATA), the company moved around 60 jobs from Geneva and 
>>London to Montreal because it was cheaper here.
>>
>>This is all business as usual.
>>
>>
>>
>>Stephane Paquette
>>Administrateur de bases de donnees
>>Database Administrator
>>Standard Life
>>www.standardlife.ca
>>Tel. (514) 499-7999 7470 and (514) 925-7187
>>[EMAIL PROTECTED] 
>>
>>
>>
>>
>>-Original Message-
>>Mercadante, Thomas F
>>Sent: Thursday, September 04, 2003 2:50 PM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>This is all very funny and interesting.  Anybody read the
>>story in yesterday's NY times?  Mexica has a concern that 
>>their textile industry is being "stolen" by China because it 
>>is cheaper to make products there than in Mexico. Sound familiar?
>>
>>"This is the business we have chosen to be into"  Himen Roth
>>(and I know spelled his first name wrong).
>>
>>
>>-Original Message-
>>Sent: Thursday, September 04, 2003 2:10 PM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>It doesn't work in only one direction. While jobs are bieng
>>lost to cheaper labor markets, Indian companies now have to 
>>compete with frighteningly efficient giants like Nike, Coca 
>>Cola, IBM, Microsoft, GM, Union Carbide  and others. Local 
>>companies are losing the market and have to reduce their 
>>workforce, driving the cost of labor further down and closing 
>>the vicious circle. What  is scary is the fact that we are an 
>>order of magnitude more efficient then the rest of the world, 
>>even with all our PHB's and damagement. How messed up is 
>>everybody else? The only difference between a US DBA and a 
>>cleaning leady, which has also been replaced by an immigrant 
>>a long time ago, is the fact that the DBA has easier access 
>>to the DBA mailing lists. If we weren't crying foul then, 
>>there is no need to do it now. We will simply have to adjust 
>>and do something else. The first thing that comes to mind is 
>>becoming a lawyer. When I want to sue somebody, I'd like to 
>>be represented by a cutthroat yankee lawyer, not by a very 
>>polite and non-aggressive gentleman from India. Lawyers do 
>>need a killer instinct, DBAs do not. For those of us who have 
>>it, it's more of a hindrance then a useful tool. Lawyers and 
>>politicians, fortunately for Indians, will never be 
>>outsourced to India. Here is our chance.
>>
>>
>>--
>>Mladen Gogala
>>Oracle DBA
>>
>>
>>
>>-Original Message-
>>Souto
>>Sent: Thursday, September 04, 2003 12:55 PM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>LOL!
>>
>>Funny how this "globalisation" bull only
>>works in one direction, eh?
>>
>>Cheers
>>Nuno Souto
>>[EMAIL PROTECTED]
>>- Original Message -
>>
>>
>>
>>>** Another programmer who lost his job to an Indian outsourcer is
>>>willing to relocate in India. But Indian officials have 
>>>  
>>>
>>told him they
>>
>>
>>>don't hire Americans. Read about another politicized IT
>>>  
>>>
>>worker in "No
>>
>>
>>>Americans Need Apply."
>>>  
>>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>>--
>>Author: Nuno Souto
>>  INET: [EMAIL PROTECTED]
>>
>>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>>San Diego, California-- Mailing list and web hosting services
>>

Re: DB2 has a foot in the door

2003-09-07 Thread Rachel Carmichael
been too long since I've done any DB2 work for me to remember it.. I
was   barely involved in the work then, primarily the Oracle DBA.

As for the site licenses... these are likely to have been in place for
a LONG time (I left Citibank in '98) and the company I work for now has
been around for a lot of years. 

I suppose it's possible they don't do them anymore, but since they are
already in place, they have to keep it going.


--- Ryan <[EMAIL PROTECTED]> wrote:
> have you used DB2? How does it compare to Oracle? Ive seen tom kyte
> write
> that each platform that DB2 runs on is in essence a different
> database and
> you cant take code from one platform and move it to another.
> 
> are the features comparable? what about cost?
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Sunday, September 07, 2003 8:54 AM
> 
> 
> > VERY interesting. They refused to do site licensing at a 2
> > installation here. Thank you for this tip.
> >
> > Rachel Carmichael wrote:
> >
> > >Oracle does site licensing... but only if you are a very very
> large
> > >corporation. Citibank (when I worked there) had one. The company I
> work
> > >for now has one.
> > >
> > >So I don't ask "do we have a license" when I want to install a new
> > >version of Oracle, even if it is a new platform
> > >
> > >One of the few things that is easier working in a rigid corporate
> > >environment
> > >
> > >
> > >--- Mogens_Nørgaard <[EMAIL PROTECTED]> wrote:
> > >
> > >
> > >>There's one thing that IBM can do, which Microsoft and Oracle
> can't
> > >>offer: They do site licenses as well as cpu and user licensing.
> That
> > >>just gives them an incredible advantage to management and others
> who
> > >>can
> > >>stop thinking about whether they should buy another server, move
> > >>stuff
> > >>from one server to the other, etc. I can't believe Oracle and
> > >>Microsoft
> > >>are not doing it (I think I can guess, but it's still not good).
> > >>
> > >>Mladen Gogala wrote:
> > >>
> > >>
> > >>
> > >>>I believe that the answer to Stephane's question is obvious:
> > >>>Oracle 10g will cost 10 grands/ CPU. That's where the letter "g"
> > >>>is coming from.
> > >>>
> > >>>--
> > >>>Mladen Gogala
> > >>>Oracle DBA
> > >>>
> > >>>
> > >>>
> > >>>-Original Message-
> > >>>DENNIS WILLIAMS
> > >>>Sent: Friday, September 05, 2003 5:30 PM
> > >>>To: Multiple recipients of list ORACLE-L
> > >>>
> > >>>
> > >>>Stephane
> > >>>   We've been very excited about Oracle Standard Edition. Helped
> > >>>
> > >>>
> > >>stave off
> > >>
> > >>
> > >>>the interest in MS SQL. Given the budget pressures at many
> > >>>
> > >>>
> > >>organizations,
> > >>
> > >>
> > >>>I'm surprised we don't hear more about this alternative.
> > >>>
> > >>>Dennis Williams
> > >>>DBA, 80%OCP, 100% DBA
> > >>>Lifetouch, Inc.
> > >>>[EMAIL PROTECTED]
> > >>>
> > >>>
> > >>>-Original Message-
> > >>>Sent: Friday, September 05, 2003 4:09 PM
> > >>>To: Multiple recipients of list ORACLE-L
> > >>>
> > >>>
> > >>>Hi all,
> > >>>
> > >>>We're an Oracle shop, over 140 Oracle instances.
> > >>>Today, architecture has chosen IBM DB2 for BI projects.
> > >>>The next step I guessed will be to choose DB2 for the new
> > >>>
> > >>>
> > >>transactionnal
> > >>
> > >>
> > >>>applications also.
> > >>>
> > >>>IBM offers DB2 at 25% less than Oracle.
> > >>>
> > >>>I wonder if Oracle 10G will come with a new pricing structure ?
> > >>>
> > >>>
> > >>>Stephane Paquette
> > >>>Administrateur de bases de donnees
> > >>>Database Administrator
> > >>>Standard Life
> > >>>www.standardlife.ca
> > >>>Tel. (514) 499-7999 7470 and (514) 925-7187
> > >>>[EMAIL PROTECTED]
> > >>>
> > >>>
> > >>
> > >>
> > >>
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>
> > >>--
> > >>Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > >>--
> > >>Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
> > >>  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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://ww

Re: DB2 has a foot in the door

2003-09-07 Thread Ryan
have you used DB2? How does it compare to Oracle? Ive seen tom kyte write
that each platform that DB2 runs on is in essence a different database and
you cant take code from one platform and move it to another.

are the features comparable? what about cost?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, September 07, 2003 8:54 AM


> VERY interesting. They refused to do site licensing at a 2
> installation here. Thank you for this tip.
>
> Rachel Carmichael wrote:
>
> >Oracle does site licensing... but only if you are a very very large
> >corporation. Citibank (when I worked there) had one. The company I work
> >for now has one.
> >
> >So I don't ask "do we have a license" when I want to install a new
> >version of Oracle, even if it is a new platform
> >
> >One of the few things that is easier working in a rigid corporate
> >environment
> >
> >
> >--- Mogens_Nørgaard <[EMAIL PROTECTED]> wrote:
> >
> >
> >>There's one thing that IBM can do, which Microsoft and Oracle can't
> >>offer: They do site licenses as well as cpu and user licensing. That
> >>just gives them an incredible advantage to management and others who
> >>can
> >>stop thinking about whether they should buy another server, move
> >>stuff
> >>from one server to the other, etc. I can't believe Oracle and
> >>Microsoft
> >>are not doing it (I think I can guess, but it's still not good).
> >>
> >>Mladen Gogala wrote:
> >>
> >>
> >>
> >>>I believe that the answer to Stephane's question is obvious:
> >>>Oracle 10g will cost 10 grands/ CPU. That's where the letter "g"
> >>>is coming from.
> >>>
> >>>--
> >>>Mladen Gogala
> >>>Oracle DBA
> >>>
> >>>
> >>>
> >>>-Original Message-
> >>>DENNIS WILLIAMS
> >>>Sent: Friday, September 05, 2003 5:30 PM
> >>>To: Multiple recipients of list ORACLE-L
> >>>
> >>>
> >>>Stephane
> >>>   We've been very excited about Oracle Standard Edition. Helped
> >>>
> >>>
> >>stave off
> >>
> >>
> >>>the interest in MS SQL. Given the budget pressures at many
> >>>
> >>>
> >>organizations,
> >>
> >>
> >>>I'm surprised we don't hear more about this alternative.
> >>>
> >>>Dennis Williams
> >>>DBA, 80%OCP, 100% DBA
> >>>Lifetouch, Inc.
> >>>[EMAIL PROTECTED]
> >>>
> >>>
> >>>-Original Message-
> >>>Sent: Friday, September 05, 2003 4:09 PM
> >>>To: Multiple recipients of list ORACLE-L
> >>>
> >>>
> >>>Hi all,
> >>>
> >>>We're an Oracle shop, over 140 Oracle instances.
> >>>Today, architecture has chosen IBM DB2 for BI projects.
> >>>The next step I guessed will be to choose DB2 for the new
> >>>
> >>>
> >>transactionnal
> >>
> >>
> >>>applications also.
> >>>
> >>>IBM offers DB2 at 25% less than Oracle.
> >>>
> >>>I wonder if Oracle 10G will come with a new pricing structure ?
> >>>
> >>>
> >>>Stephane Paquette
> >>>Administrateur de bases de donnees
> >>>Database Administrator
> >>>Standard Life
> >>>www.standardlife.ca
> >>>Tel. (514) 499-7999 7470 and (514) 925-7187
> >>>[EMAIL PROTECTED]
> >>>
> >>>
> >>
> >>
> >>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>--
> >>Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >>--
> >>Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
> >>  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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
>   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: Ryan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-

Re: DB2 has a foot in the door

2003-09-07 Thread Mogens Nørgaard
VERY interesting. They refused to do site licensing at a 2 
installation here. Thank you for this tip.

Rachel Carmichael wrote:

Oracle does site licensing... but only if you are a very very large
corporation. Citibank (when I worked there) had one. The company I work
for now has one.
So I don't ask "do we have a license" when I want to install a new
version of Oracle, even if it is a new platform
One of the few things that is easier working in a rigid corporate
environment
--- Mogens_Nørgaard <[EMAIL PROTECTED]> wrote:
 

There's one thing that IBM can do, which Microsoft and Oracle can't 
offer: They do site licenses as well as cpu and user licensing. That 
just gives them an incredible advantage to management and others who
can 
stop thinking about whether they should buy another server, move
stuff 
from one server to the other, etc. I can't believe Oracle and
Microsoft 
are not doing it (I think I can guess, but it's still not good).

Mladen Gogala wrote:

   

I believe that the answer to Stephane's question is obvious:
Oracle 10g will cost 10 grands/ CPU. That's where the letter "g" 
is coming from.

--
Mladen Gogala
Oracle DBA 



-Original Message-
DENNIS WILLIAMS
Sent: Friday, September 05, 2003 5:30 PM
To: Multiple recipients of list ORACLE-L
Stephane
  We've been very excited about Oracle Standard Edition. Helped
 

stave off
   

the interest in MS SQL. Given the budget pressures at many
 

organizations,
   

I'm surprised we don't hear more about this alternative.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Friday, September 05, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L
Hi all,

We're an Oracle shop, over 140 Oracle instances.
Today, architecture has chosen IBM DB2 for BI projects.
The next step I guessed will be to choose DB2 for the new
 

transactionnal
   

applications also.

IBM offers DB2 at 25% less than Oracle.

I wonder if Oracle 10G will come with a new pricing structure ?

Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED]
 


   





 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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: DB2 has a foot in the door

2003-09-07 Thread Rachel Carmichael
Oracle does site licensing... but only if you are a very very large
corporation. Citibank (when I worked there) had one. The company I work
for now has one.

So I don't ask "do we have a license" when I want to install a new
version of Oracle, even if it is a new platform

One of the few things that is easier working in a rigid corporate
environment


--- Mogens_Nørgaard <[EMAIL PROTECTED]> wrote:
> There's one thing that IBM can do, which Microsoft and Oracle can't 
> offer: They do site licenses as well as cpu and user licensing. That 
> just gives them an incredible advantage to management and others who
> can 
> stop thinking about whether they should buy another server, move
> stuff 
> from one server to the other, etc. I can't believe Oracle and
> Microsoft 
> are not doing it (I think I can guess, but it's still not good).
> 
> Mladen Gogala wrote:
> 
> >I believe that the answer to Stephane's question is obvious:
> >Oracle 10g will cost 10 grands/ CPU. That's where the letter "g" 
> >is coming from.
> >
> >--
> >Mladen Gogala
> >Oracle DBA 
> >
> >
> >
> >-Original Message-
> >DENNIS WILLIAMS
> >Sent: Friday, September 05, 2003 5:30 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Stephane
> >We've been very excited about Oracle Standard Edition. Helped
> stave off
> >the interest in MS SQL. Given the budget pressures at many
> organizations,
> >I'm surprised we don't hear more about this alternative.
> >
> >Dennis Williams
> >DBA, 80%OCP, 100% DBA
> >Lifetouch, Inc.
> >[EMAIL PROTECTED] 
> >
> >
> >-Original Message-
> >Sent: Friday, September 05, 2003 4:09 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Hi all,
> >
> >We're an Oracle shop, over 140 Oracle instances.
> >Today, architecture has chosen IBM DB2 for BI projects.
> >The next step I guessed will be to choose DB2 for the new
> transactionnal
> >applications also.
> >
> >IBM offers DB2 at 25% less than Oracle.
> >
> >I wonder if Oracle 10G will come with a new pricing structure ?
> >
> >
> >Stephane Paquette
> >Administrateur de bases de donnees
> >Database Administrator
> >Standard Life
> >www.standardlife.ca
> >Tel. (514) 499-7999 7470 and (514) 925-7187
> >[EMAIL PROTECTED]
> 
> >
> >
> >
> >
> >  
> >
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
>   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).


Re: offshoring article

2003-09-07 Thread Nuno Souto
- Original Message -


> They're hired by the people who came out of those very same
> universities. Most often McKinsey et al are hired to OK decisions that
> management have a hard time OK'ing themselves for various reasons.
>
> To be fair, of all the consulting companies that make money out of
> telling people that water runs downhill, McKinsey are among the very best.
>

guess where Louis Gerstner worked before IBM and Nabisco.
"Jobs for the boys"?...

Cheers
Nuno Souto
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nuno Souto
  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: Congratulations Arup (DBA of the Year)

2003-09-07 Thread Mladen Gogala
On 2003.09.07 05:04, Mogens Nørgaard wrote:
Nope, no Bill O'Reilly isn't available here. What is it and how can I learn  
more about him?
I would enjoy providing a detailed response but I doubt that Jared would
tolerate such an excursion into political pamphlets. I'll send you a private
response tomorrow afternoon (EST). And remember, the spin stops here.
To make a long story short, Bill O'Reilly is a political commentator
from the Fox New, which are, of course, fair and balanced, with the strong
inclinations toward far right. He was organizing boycott of the Dixie Chicks
for speaking against Bush. In other words, Bill O'Reilly is a diluted version
of Joe McCarthy in the 21st century. Fox News can be compared with the Spanish  
Inquisition. As a matter of fact, I did see somewhere the term e-nquisition  
being used to describe Fox News.

--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 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 on RAID - Thanks

2003-09-07 Thread Mogens Nørgaard
Yes. RAID-3 is bit-level striping with a dedicated parity disk. Buy 33 
disks if you're on 32 bit systems, otherwise buy 65. Then you'll have 
fantastic performance as long as you have concurrency for the whole disk 
stripe set to 1.

RAID-4, as used in the IBM Shark systems, have chunk-level striping (I 
can't think of the right word now) and a dedicated parity disk to ensure 
that you have at least one disk with a lot of constant pressure on it.

Jared Still wrote:

  Of course, the Sun engineer is saying "our new RAID 5 is just as fast as
RAID 10 because we stripe parity across all disks".
   

Uh huh.  Does he think this is new?

RAID 3 is the version that has a dedicated parity disk IIRC.

RAID 5 has always striped the parity across all disks.

Jared

On Fri, 2003-08-22 at 08:24, DENNIS WILLIAMS wrote:
 

To whomever posted the link to Gaja's paper Implementing RAID on Oracle -
thank you. I previously had printed and passed this article on to my system
administrator -- no reaction. But yesterday he was building our new Sun
system with all the latest features, and was so excited about the paper that
he asked for a second copy to share with his junior sys admin. He stopped
building the system to take a day to study Gaja's paper in detail.
  Of course, the Sun engineer is saying "our new RAID 5 is just as fast as
RAID 10 because we stripe parity across all disks".
   Since this will be an OLTP system, I am planning on an 8K Oracle block
size, unless anyone has better information on how to pick a block size.
Apparently there are a lot of storage system parameters you can optimize,
but they are based on the Oracle block size.


Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
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.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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: more questions

2003-09-07 Thread Mladen Gogala
On 2003.09.07 05:19, Mogens Nørgaard wrote:
Another fun fact about the OS390 port: If you set max dumb ( :) ) file size  
to 50 MB, then the session will write 50MB, close the file, open another  
one, and continue writing trace data to this one, and so one, until the  
session is done.
I'm not an MVS expert, as a matter of fact, I haven't worked with MVS
for 15 years. Normally, when I want to have a large trace file I do oradebug  
unlimit. Is it available on MVS?
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 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: system tablespace at 50 pct_increase in 9i?

2003-09-07 Thread Mogens Nørgaard
His name was Magnus Lönnroth or Lonnrott or something. He moved to the 
US after coming out with the WOW stuff, and help bring out the OWA or 
whatever it was called.

Mladen Gogala wrote:

Mogens, do you happen to know the name of the Swedish or Norwegian
guy who wrote WOW gateway? He used to be a member of this list. WOW
was the first thing to be able to access the oracle database through
the CGI interface. That guy was phenomenal, I believe that he has had
a part in WebIV as well.
On 2003.09.07 04:34, Mogens Nørgaard wrote:

When I was hired as a DBA by a bank here in 1987 I used 1200 baud 
modems to  dial up and manage the 5.1.22 thing. Of course we used 
Kermit and set host/ x25 - very cool stuff back in those days. And free.

--
Mladen Gogala
Oracle DBA


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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: more questions

2003-09-07 Thread Mogens Nørgaard
Another fun fact about the OS390 port: If you set max dumb ( :) ) file 
size to 50 MB, then the session will write 50MB, close the file, open 
another one, and continue writing trace data to this one, and so one, 
until the session is done.

Tim Gorman wrote:

As an interesting side note, Oracle on MVS/OS390 offers multiplexing of
datafiles, since at least Oracle v6, I believe.  It's just something that
never made the jump to other ports, I guess...


on 9/1/03 9:09 PM, Sinardy Xing at [EMAIL PROTECTED] wrote:

 

how to startup oracle after machine
is bootup?
you must configure your /etc/oratab
Ans:
add this line
your_sid:your_oracle_home:AUTO(auto is keyword)
how to shutdown oracle before Unix is shutdown?
Ans:
I don't think that Oracle provide such feature, but you can write OS script
add to your in your init.d
or simpler way replace your init binary file with your own
for example
# init 6

your new init 

/where is my shutdown script/shutdown oracle.sh
/or perhaps you want to shutdown listener too or other application do it
here/bla.sh
sync
sync
original_init $1
It seems to me that I cannot multiplex data files. Is that true?

Ans:

Yes Oracle only allow you to multiplex your control files and redolog files
but not your data files, however
Oracle do recommend you to do RAID 0 + 1 if you have the $$$.
Sinardy





-Original Message-
Sent: 02 September 2003 11:29
To: Multiple recipients of list ORACLE-L
Hi Greetings,

We are using solaris. I wonder how to startup oracle after machine
is bootup and how to shutdown oracle before unix is shutdown?
I know how to multiplex control files and redo files. It seems to
me that I cannot multiplex data files. Is that true?
Thanks!
Jin
   

 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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: Future demand for DBAs

2003-09-07 Thread Mogens Nørgaard
By the time of the UKOUG conference in December we should have Miracle 
Breweries up and running. Capacity will not exceed two batches per week. 
However, each batch will be 400 liters each. For Cary's information, 
that's about 0.42 gallons.

Niall Litchfield wrote:

Jesse wrote
 

Put down the Bud Light and drink a REAL beer like Three 
Floyds Alpha King, Sierra Nevada Pale Ale, Guinness, or Goose 
Island Honkers Ale.

There's gotta be an "Oracle" hook here somehere...Drink REAL 
beer at OracleWorld!
   

Real Ale Clusters... 
Flashback Query - you know the morning after you ask "Did I really..?"
Grant under any table to... 

Errm in a desperate attempt to keep this vaguely on topic, those going
to the UK for UKOUG in December who might be interested in a Real Ale
evening drop us a line and I'll see if we can't organize something. 

Niall

Stupid offers 'R' Us. 

 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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: Congratulations Arup (DBA of the Year)

2003-09-07 Thread Mogens Nørgaard
Nope, no Bill O'Reilly isn't available here. What is it and how can I 
learn more about him?

As for the pictures, you won't believe how fat I look. In other words, 
it was a good photographer who managed to capture me as I am. Here in 
this country we consider anyone weighing less than 100 kilos feminine. 
If you're not a member of Club 100, you're not a real man, in other words.

For Cary's information, 100 Kilograms is about 4TB Pounds rounded to the 
nearest SquareGallon.

Mladen Gogala wrote:

On 2003.09.07 04:19, Mogens Nørgaard wrote:

Oracle thinks the combined readership of Oracle Magazine and Profit 
Magazine  is about 1 million. Sounds plausible to me.

Of those 1 million, about 10 will see the ugly pictures of me in the  
November issue. Two of them will remember it. The other one will be 
my  financee Anette, who also works in Miracle. But only because she 
can use it  for business purposes, I think.


Mogens, we will never forget your picture, how could we? The fact
that Oracle Magazine is going to publish your picture proves beyond
reasonable doubt that the magazine is fair and balanced, just like
the Fox News. Just a private question: can you enjoy Mr. Bill O'Reilly
in Danemark? Bill O'Reilly is not to be confused with Tim O'Reilly, the
publisher of Cary's book, among other things.
--
Mladen Gogala
Oracle DBA


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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: How can I measure my DB performance.

2003-09-07 Thread Mogens Nørgaard
And if you have nothing better to do, study the Full Disclosure Reports. 
There's still cheating going on. More about that AFTER I get the award 
:-))).

Stephane Faroult wrote:

http://www.tpc.org

 

Jake
 Compare to what? Another database? To what its
performance should be?
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, August 28, 2003 6:59 PM
To: Multiple recipients of list ORACLE-L
Is there a standard query I can run to compare the
performance of a db.
(Kind of like bogomips for unix)
Thanks,
Jake Johnson
[EMAIL PROTECTED]
Plutoid - http://www.plutoid.com - Shop Plutoid for
the best prices on
Rims, Tires, and Wheel Packages.
   

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?UTF-8?B?TW9nZW5zIE7DuHJnYWFyZA==?=
 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: system tablespace at 50 pct_increase in 9i?

2003-09-07 Thread Mladen Gogala
Mogens, do you happen to know the name of the Swedish or Norwegian
guy who wrote WOW gateway? He used to be a member of this list. WOW
was the first thing to be able to access the oracle database through
the CGI interface. That guy was phenomenal, I believe that he has had
a part in WebIV as well.
On 2003.09.07 04:34, Mogens Nørgaard wrote:
When I was hired as a DBA by a bank here in 1987 I used 1200 baud modems to  
dial up and manage the 5.1.22 thing. Of course we used Kermit and set host/ 
x25 - very cool stuff back in those days. And free.

--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 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: Offshore threat

2003-09-07 Thread Mogens Nørgaard
While I was still in Oracle, thieves broke into the offices of Oracle in 
Oslo, Norway, and removed two HP cpu's from the main computer there. 
They ignored all the nice laptops on the tables around them. Now, that 
is weird.

Mladen Gogala wrote:

Two IBM mainframes stolen? Boy, the times are changing! To steal only a
single 3090 600J,
one would need a whole infantry division, not just two guys with a dolly. 
I bet they'll end up running Linux and having a ton of Jared's perl scripts
on them.

--
Mladen Gogala
Oracle DBA 



-Original Message-
Wolfe Stephen S GS-11 6 MDSS/SGSI
Sent: Friday, September 05, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
http://www.smh.com.au/articles/2003/09/04/1062548967124.html

A - This is social engineering at its finest.

B - There is no security without PHYSICAL security

C - If you don't check up on your outsourcer, then you can apparently get
the shirt stolen off your back...


v/r

Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974  DSN 651-9974


 

-Original Message-
From: Stephane Paquette [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 3:15 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Offshore threat
When working at International Air Transport Association
(IATA), the company moved around 60 jobs from Geneva and 
London to Montreal because it was cheaper here.

This is all business as usual.



Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED] 




-Original Message-
Mercadante, Thomas F
Sent: Thursday, September 04, 2003 2:50 PM
To: Multiple recipients of list ORACLE-L
This is all very funny and interesting.  Anybody read the
story in yesterday's NY times?  Mexica has a concern that 
their textile industry is being "stolen" by China because it 
is cheaper to make products there than in Mexico. Sound familiar?

"This is the business we have chosen to be into"  Himen Roth
(and I know spelled his first name wrong).
-Original Message-
Sent: Thursday, September 04, 2003 2:10 PM
To: Multiple recipients of list ORACLE-L
It doesn't work in only one direction. While jobs are bieng
lost to cheaper labor markets, Indian companies now have to 
compete with frighteningly efficient giants like Nike, Coca 
Cola, IBM, Microsoft, GM, Union Carbide  and others. Local 
companies are losing the market and have to reduce their 
workforce, driving the cost of labor further down and closing 
the vicious circle. What  is scary is the fact that we are an 
order of magnitude more efficient then the rest of the world, 
even with all our PHB's and damagement. How messed up is 
everybody else? The only difference between a US DBA and a 
cleaning leady, which has also been replaced by an immigrant 
a long time ago, is the fact that the DBA has easier access 
to the DBA mailing lists. If we weren't crying foul then, 
there is no need to do it now. We will simply have to adjust 
and do something else. The first thing that comes to mind is 
becoming a lawyer. When I want to sue somebody, I'd like to 
be represented by a cutthroat yankee lawyer, not by a very 
polite and non-aggressive gentleman from India. Lawyers do 
need a killer instinct, DBAs do not. For those of us who have 
it, it's more of a hindrance then a useful tool. Lawyers and 
politicians, fortunately for Indians, will never be 
outsourced to India. Here is our chance.

--
Mladen Gogala
Oracle DBA


-Original Message-
Souto
Sent: Thursday, September 04, 2003 12:55 PM
To: Multiple recipients of list ORACLE-L
LOL!

Funny how this "globalisation" bull only
works in one direction, eh?
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
   

** Another programmer who lost his job to an Indian outsourcer is
willing to relocate in India. But Indian officials have 
 

told him they
   

don't hire Americans. Read about another politicized IT
 

worker in "No
   

Americans Need Apply."
 

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



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

Re: latch free wait event

2003-09-07 Thread Mogens Nørgaard
"Can" instead of "Will" is probably only in the case where there's only 
one user on the system :-))).

Cary Millsap wrote:

Yes. Even with TIMED_STATISTICS=TRUE, relying on *any* statistic with
system-wide scope can waste your time. For a 34-page introduction to the
rationale behind this proposition, see:
http://www.oreilly.com/catalog/optoraclep/chapter/ch01.pdf

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101 in Sydney
- Hotsos Symposium 2004, March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
Wolfgang Breitling
Sent: Thursday, September 04, 2003 6:44 PM
To: Multiple recipients of list ORACLE-L
The number of waits is irrelevant. What matters is the time waited which
in 
your case shows 0, but I assume that is because you have not set 
timed_statistics to true. Without that the data from v$system_event are 
worthless. Cary will probably step in here and tell you that even with 
timed_statistics that data is at best of dubious worth.

At 02:49 PM 9/4/2003 -0800, you wrote:

 

   System-wide Wait Analysis
for current wait events
   

Average
 

Event Total  SecondsTotal
   

Wait
 

NameWaits  Waiting Timeouts  (in
   

secs)
 

-   -   -   -
---
latch free1,4590 1,393
   

.000
 

After querying v$system_event my biggest concern is the "latch free"
   

wait
 

event. I understand that latch free is "the process waits for a latch
   

that
 

is currently busy ( held by another process).How can I drill down
   

and
 

find the cause of this?   I have a feeling it is about rollback or redo
logs.
thanks,



David Ehresmann

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

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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: 32 or 64?

2003-09-07 Thread Mogens Nørgaard
Yep. If you benefit from using more memory than what 32 bit stuff can 
handle, then of course 64 bit will help. If you don't benefit from more 
memory (that's likely to be the case for most), then 64 will just add 
overhead. But if the vendors are pushing 64 bit, then management will 
buy it. It has to be better, since the number is bigger (Law Of Bigger 
Numbers - LOBN). One could speculate that the next version of Oracle 
might only be available on 64 bit platforms, except of course on Intel.

Mogens

PS: And Anjo will do a presentation about this 64 bit stuff at the 
Database Forum here RSN.

Karniotis, Stephen wrote:

The added benefit comes with technology's ability to address/reference
disk/memory/etc. in the 64-bit address space.  Additionally straight 64-bit
computing offers some added performance versus the concatenation of two
32-bit words.  Tim is correct in that some performance degradation can be
experienced if not implemented properly.
Now, several vendors, as Joe Testa indicated, are converting all binaries to
64-bit and will not support 32-bit any longer.  HP, Oracle, Sun, etc. are
some prime examples.  Expect the conversion/migration to take some time as
32-bit apps are still out there and will not be changed for several years.
Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct:	(313) 227-4350
Mobile:	(248) 408-2918
Email:	[EMAIL PROTECTED] 
Web:	www.compuware.com 

-Original Message-
Sent:   Monday, August 18, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: 32 or 64?
There are no performance benefits from the software change;  in fact,
anecdotal evidence is that there might even be a hit, since we're now moving
more data about (i.e. 64-bit integers instead of 32-bit integers), but that
is certainly debatable.  Some very simple testing with C programs on
dedicated servers should be able to lay that to rest...
Bigger SGA and PGA along with access to the latest and greatest (?) software
*probably* falls into the category of a benefit, right?  The reason it may
not be a benefit is that then folks see the ability to add more RAM as an
all-round panacea.  There's something purifying about having to make do
within limitations...
Not aware of any specific bugs related to wordsize.

By the way, switching between wordsize isn't that hard.  Check out the
script "?/rdbms/admin/utlirp.sql" and the package UTL_RP and some related
MetaLink notes...


on 8/18/03 9:14 AM, Daniel Fink at [EMAIL PROTECTED] wrote:

 

From a technical and business perspective, what are the reasons to migrate
from 32-bit to 64-bit Oracle? Are there known bugs/problems with one
   

version
 

that are not present in the other?

Daniel Fink
   

 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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: Congratulations Arup (DBA of the Year)

2003-09-07 Thread Mladen Gogala
On 2003.09.07 04:19, Mogens Nørgaard wrote:
Oracle thinks the combined readership of Oracle Magazine and Profit Magazine  
is about 1 million. Sounds plausible to me.

Of those 1 million, about 10 will see the ugly pictures of me in the  
November issue. Two of them will remember it. The other one will be my  
financee Anette, who also works in Miracle. But only because she can use it  
for business purposes, I think.
Mogens, we will never forget your picture, how could we? The fact
that Oracle Magazine is going to publish your picture proves beyond
reasonable doubt that the magazine is fair and balanced, just like
the Fox News. Just a private question: can you enjoy Mr. Bill O'Reilly
in Danemark? Bill O'Reilly is not to be confused with Tim O'Reilly, the
publisher of Cary's book, among other things.
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 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: system tablespace at 50 pct_increase in 9i?

2003-09-07 Thread Mogens Nørgaard
When I was hired as a DBA by a bank here in 1987 I used 1200 baud modems 
to dial up and manage the 5.1.22 thing. Of course we used Kermit and set 
host/x25 - very cool stuff back in those days. And free.

WebIV was fantastic. It was created by a few guys in Oracle UK Support, 
among them David Ruthven, who now runs DDR there. It combined free text 
search on both TAR's (called something else back then, like PMS) and 
notes, mostly written by the most productive person in Oracle ever (he's 
still around, he's still as productive) whose name I have forgotten 
right now. Damn.

Mladen Gogala wrote:

Same here. I've actually had 14400 modem on my desk. Before that, I 
was using 9600 modems and kermit or "SET HOST/X25"
(once upon a time on a VAX far, far away)
--
Mladen Gogala
Oracle DBA

-Original Message-
*From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On
Behalf Of *Arup Nanda
*Sent:* Monday, August 18, 2003 11:14 AM
*To:* Multiple recipients of list ORACLE-L
*Subject:* Re: system tablespace at 50 pct_increase in 9i?
Tim, WebIV? I must have skipped a generation; I used the
OraSupport forum on CompuServe before the MetaLink. You had to
subscribe to CompuServe; and it was accessible only through
dial-up; so we had dial-up lines at our desk, had to buy external
modems, and all that. And I thought WebIV was and still is only
for Oracle Consulting and Support Staff.
Arup
- Original Message -
*From:* Tim Gorman 
*To:* Multiple recipients of list ORACLE-L

*Sent:* Monday, August 18, 2003 9:44 AM
*Subject:* Re: system tablespace at 50 pct_increase in 9i?
Good point! Another war story...

Some 6 years ago, during v7.3.3 timeframe, a DBA decided to
modify INITIAL, NEXT, and PCTINCREASE of everything, including
stuff in SYSTEM. Unfortunately, he chose first to do this in
pre-PROD (to become PROD following week). Turns out he ran
into a little-known bug (aren’t they all, at first?) whereby
any ALTER TABLE to the table named SYS.BOOTSTRAP$ causes a
single bit to be set in the segment header block. This single
bit being set causes ORA-00600 on instance startup.
You guessed it: the night before go live, they had a junior
DBA stop and restart the instance at 12:30am. Poor guy stayed
up all night, I got there around 6:00am, we found the cause
and convinced Oracle Support to dial in and BBED the problem
into submission by 1:00pm. MetaLink didn’t exist in those days
— we had access to MetaLink’s predecessor, called “WebIV”...
Don’t change the stuff in the SYSTEM tablespace, which
includes the tablespace itself. Keep “foreign stuff” (i.e. not
belonging to SYS, SYSTEM, MDSYS, ORDSYS, OUTLN, etc) out of it
and just leave it alone.


on 8/18/03 4:59 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:

i thought you should leave the system table space to the
defaults? Ive never touched System.
you really should change system to locally managed
tablespaces?
>
> From: Tim Gorman <[EMAIL PROTECTED]>
> Date: 2003/08/17 Sun PM 11:19:23 EDT
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> Subject: Re: system tablespace at 50 pct_increase in 9i?
>
> Better yet, use locally-managed SYSTEM tablespace and
dispense with the
> issue altogether?
>
>
> on 8/17/03 5:39 PM, Ryan at [EMAIL PROTECTED] wrote:
>
> > any idea why oracle has the system tablespace using 50
pct_increase in 9i? I k
> > now it did that in the past, but why not set it to zero?
> >
> > Ryan
> >
>
>
>
>

Better yet, use locally-managed SYSTEM tablespace and
dispense with the issue altogether?
on 8/17/03 5:39 PM, Ryan at [EMAIL PROTECTED] wrote:

any idea why oracle has the system tablespace using 50
pct_increase in 9i? I k now it did that in the past,
but why not set it to zero?
Ryan



**
*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, prin

Re: Congratulations Arup (DBA of the Year)

2003-09-07 Thread Mogens Nørgaard
And Tom Kyte is Author of the Year, by the way. Man, I feel honored and 
humble at being in company with Arup and Tom on this stuff. At least 
they do real work. All directors do is talk to other directors on the 
mobile or have lunch with other directors.

Niall Litchfield wrote:

Congratulations indeed Arup. Well deserved. 
I believe that Mogens is also named Educator of the Year. 

Niall

 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
Behalf Of [EMAIL PROTECTED]
Sent: 28 August 2003 15:54
To: Multiple recipients of list ORACLE-L
Subject: Congratulations Arup (DBA of the Year) 



Just came to know from CTOUG news that Oracle has chosen Arup 
Nanda(our List member) as "DBA of the Year".

Congratulations Arup. thought I will share this news with the group.

CTOUG Board Member, Arup Nanda, Chosen as "DBA of the Year" 
Oracle has chosen our very own CTOUG board member, Arup 
Nanda, as the "DBA of the Year", out of some quarter million 
DBAs worldwide. There will be a felicitation ceremony at 
OracleWorld and the award recipients will be featured in 
Nov-Dec issue of Oracle Magazine. Thought you would like to 
know, as a part of the CTOUG community. In his interview, he 
has mentioned CTOUG, so watch for it.  Arup is President of 
Proligence (http://www.proligence.com/).

Thanks.

Best Regards,
Prasad


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

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

   

 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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: Congratulations Arup (DBA of the Year)

2003-09-07 Thread Mogens Nørgaard
Well, the title is "You PROBABLY don't need RAC", and I did actually 
(but just for fun to see his reaction) propose to Cary that I would do a 
"You Probably Don't Need Oracle" presentation at the Hotsos Symposium. 
He didn't reply to that. So instead I'll do "You probably don't need a 
goat".

The reason - according to Jeff Spicer, the editor of Oracle Magazine - 
that I got an award was because of some stuff we've been doing here in 
Denmark together with Oracle Denmark. They include Specials and the DBA 
Nightschool.

We call them Specials, but they're nothing else than targeted, special 
days where a certain topic (usually narrow, eg Partitioning, MVs, etc.) 
are covered by guys who both know the stuff theoretically and from real 
work. Many moons ago Oracle's own Lex de Haan started up something 
called Technical Seminars whereby I and others would travel the world 
and teach specialised topics for a day or two. I just copied Lex' ideas 
from back then and teamed up with Oracle Denmark's Education Director 
Henrik Wegge. It doesn't take away business from the "normal" classes, 
since this is for experienced participants, and it's a good way of 
keeping in touch with the experienced folks out there.

The DBA Nightschool is something we did back in the Premium Services 
days in Oracle: DBAs will meet every Tuesday from 1700 to 2000 and go 
through a number of advanced topics and get to mix with other DBAs over 
the quick dinner or during the short breaks. We've taken it up again 
this year, and the topics include 8.1.7 New Features (there were certain 
things in 8.1.7 that were never covered in the 8i or 9i New Features 
classes because of timings), 10046, 10053, Throw-Away of rows, 10104, 
maybe some 10g stuff :).

It was the guys at the Danish Oracle User Group (OUGDK) board that set 
me up for this award thing, and I'm very grateful for that, by the way. 
I got the call from Jeff Spicer during dinner at the DBA Nightschool, so 
it was kind of cool.

I've always teased Cary with the fact that anything in America is 
award-winning these days. Well, suddenly I see it in a completely 
different light! Or maybe not.

Mogens



Tanel Poder wrote:

RE: Congratulations Arup (DBA of the Year)
 

hmmm... award to Mogens maybe for writing 'You Don't Need RAC' paper
I think his next paper will 'You don't need Grid Computing'  ... 
   

I certainly hope it won't be "You don't need Oracle" or something similar ;)

Tanel.

 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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: Congratulations Arup (DBA of the Year)

2003-09-07 Thread Mogens Nørgaard
Oracle thinks the combined readership of Oracle Magazine and Profit 
Magazine is about 1 million. Sounds plausible to me.

Of those 1 million, about 10 will see the ugly pictures of me in the 
November issue. Two of them will remember it. The other one will be my 
financee Anette, who also works in Miracle. But only because she can use 
it for business purposes, I think.

Tim Gorman wrote:

I think that it is Oracle Magazine that is actually awarding this, isn't it?
That provides a clue to the source and methods...
Does anyone pay for a subscription to Oracle Magazine?  Probably not -- the
price of subscription is generally to fill out a real or virtual
"subscription card", on which "Job Title" is queried.  From that, they
probably get their number of "a quarter-million DBAs worldwide".  Just my
guess.  Either that, or they do what I do and just pull the numbers out of
my...er...thin air...
I believe that Arup was awarded this honor and distinction for activities
that have come to the attention of Oracle Magazine, namely articles written
and published, work performed for Open World, IOUG-A, and SELECT magazine,
local Oracle Users Groups, and (possibly?) exposure on this list from the
excellent advice and explanations he's provided...
...and possibly from review of TARs opened, processed, and closed...  :-)

Of course it seems unlikely that "#1 DBA" can be chosen by any scientific
method, but however they did it I think they made an excellent choice
regardless!  I've always appreciated Arup's contributions to this list and
had the pleasure of seeing his presentation at NYOUG last December.
---

And congratulations to Mogens for being named "Educator of the Year"!  The
leader of the junta which runs the Oak Table Forum has probably forgotten
(or drowned?) more information than the rest of us have ever learned, but
he's quite generous with the information he has resident.  I've always
learned something whenever he says anything!  In fact, just recently he
related the method of milking a nanny goat who has mastitis (yes, carefully
and gently for starters, watch the horns...)  :-)


on 8/28/03 2:34 PM, Pete Sharman at [EMAIL PROTECTED] wrote:

 

And did you really think we DON'T monitor tars raised???  :)

Pete

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long term Oracle DBA.


-Original Message-
Hallas, John, Tech Dev
Sent: Friday, August 29, 2003 2:00 AM
To: Multiple recipients of list ORACLE-L
Not being a party pooper but what does DBA of the Year actually  mean.
What criteria was used. How can Oracle know about a quarter of a million
DBA's unless it monitors tars raised.
John

-Original Message- [mailto:[EMAIL PROTECTED]
Sent: 28 August 2003 15:54
To: Multiple recipients of list ORACLE-L


Just came to know from CTOUG news that Oracle has chosen Arup Nanda(our
List member) as "DBA of the Year".
Congratulations Arup. thought I will share this news with the group.

CTOUG Board Member, Arup Nanda, Chosen as "DBA of the Year" Oracle has
chosen our very own CTOUG board member, Arup Nanda, as the "DBA of the
Year", out of some quarter million DBAs worldwide. There will be a
felicitation ceremony at OracleWorld and the award recipients will be
featured in Nov-Dec issue of Oracle Magazine. Thought you would like to
know, as a part of the CTOUG community. In his interview, he has
mentioned CTOUG, so watch for it.  Arup is President of Proligence
(http://www.proligence.com/).
Thanks.

Best Regards,
Prasad
   

 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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).