RE: Oracle books

2001-05-08 Thread Matthew M. Teixeira

Just to throw in my 2 cents (and you owe me a penny back), some good
references that I have read include:

Practical Oracle8i - Jonathan Lewis
Great look at the features of Oracle 8i from high up: not an
incredibly technical book but a refreshing read

Oracle Performance Tuning Tips & Techniques - Niemiec
Excellent for tuning suggestions

Oracle 8i Complete Reference 
If you write any SQL or PL/SQL procedures, you want this book on
yourdesk

Books I have on my desk to read that we're reviewed positively on
Amazon:

Oracle8i Administration & Management - Ault
Oracle SQL High Performance Tuning - Harrison

Books I have yet to get that I understand are excellent:

Oracle8i DBA Tips & Techniques

And a book to stay away from:

Oracle DBA Handbook
I have it on my desk and very rarely have I found an answer to
my  question in that book

Hope that helps a little bit

Matthew M. Teixeira
[EMAIL PROTECTED]


-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, May 08, 2001 3:38 PM
To: Multiple recipients of list ORACLE-L

It kinda depends on your environment, but I like:

Oracle8i DBA Handbook
Oracle Press

Oracle8i Backup and Recovery
Oracle Press

Oracle 24x7 Tips and Techniques
Oracle Press

Oracle Networking 101
Oracle Press

Oracle Documentation
http://otn.oracle.com

This covers much of the core Oracle DBA stuff.  For some advanced
topics:

Oracle Internal Services: Waits, Latches...
Steve Adams
O'Reilly

Unix for Oracle
Don Burleson
O'Reilly

(Can't remember exact name) Oracle Performance Tuning
Guy Harrison
(Publisher?)

Haven't read book yet, but looks good:
Oracle STATS Pack
Don Burleson
Oracle Press

Hope that helps

Ed Haskins
Oracle DBA
Verizon Wireless

-Original Message-
Sent: Tuesday, May 08, 2001 2:32 PM
To: Multiple recipients of list ORACLE-L


Being a relatively new and often times struggling Oracle DBA I was
wondering
what 3 or 4 books everyone recommends as a must have reference/knowledge
base in day to day support/programming of their databases.

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

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

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

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

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

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

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

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



RE: Table autonumber field

2001-05-08 Thread Jacques Kilchoer
Title: RE: Table autonumber field 





> -Original Message-
> From: Mike T [mailto:[EMAIL PROTECTED]]
> 
> I need to create an autonumber field in an Oracle Table (from 
> a SQL server table identity field) , I was looking for a 
> default value that I could assign (select max(ID) + 1)  or 
> some way to create an identity field
> or use a trigger after insert but nothing seems to work for 
> me. Any help would be appreciated, This field also has to be 
> the primary Key .


Read the Oracle SQL manual about the use of sequences and triggers. Here's an example:
SQL> create sequence s ;


Sequence created.


SQL> create table t (id number primary key, name varchar2 (30)) ;


Table created.


SQL> create trigger b4it
  2  before insert on t
  3  for each row
  4  begin
  5 select s.nextval into :new.id from dual ;
  6  end ;
  7  /


Trigger created.


SQL> insert into t (name) values ('Mao Chu') ;


1 row created.


SQL> insert into t (name) values ('Mohandas Gandhi') ;


1 row created.


SQL> commit ;


Commit complete.


SQL> select * from t ;


    ID NAME
-- --
 1 Mao Chu
 2 Mohandas Gandhi


--
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com





RE: consistency in cost?

2001-05-08 Thread Henry Poras

Sam,
Thanks for the answer. I am having no trouble invoking the CBO. What is
confusing me is its apparent(?) inconsistency. If I EXPLAIN a query with the
instance using 'CHOOSE' in init.ora I get a different plan than if I EXPLAIN
the same query on the same database on the same hardware with the instance
using 'RULE' but a 'CHOOSE' hint in the query.

Henry

-Original Message-
Sent: Tuesday, May 08, 2001 11:45 PM
To: Multiple recipients of list ORACLE-L


If the system is Rule based and you code Hints, the CBO will be
automatically invoked
Sam


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, May 08, 2001 10:12 PM


> Forgive my ignorance but I thought hints were only for cost based
optimizer.
>
>
> Have you checked in case anybody has changed any parameters while the
system
> is running as I know that changing the hash_area_size can change the
> execution plan?.  Are you using parallelism as if a table had to be
> recreated for any reason and its degree changed it might do a FTS?
>
> Cheers
>
> Iain Nicoll
>
>
> -Original Message-
> Sent: 08 May 2001 17:31
> To: Multiple recipients of list ORACLE-L
>
>
> Jared,
> The only difference is about a weeks worth of extra data. Well, the
hardware
> is also different (Ultra450 vs. Ultra 5000. Also 1 vs 4 CPU). But
> regardless, shouldn't init.ora optimizer_mode=choose be identical to
> optimizer_mode=rule with hint=choose? If I have the time, I'll try to set
up
> a couple of systems and examine by moving stats and taking some 10053
dumps.
> (one of the ones giving me a problem is in production so I have limited
play
> time there).
>
> Henry
>
> -Original Message-
> Sent: Tuesday, May 08, 2001 12:56 AM
> To: [EMAIL PROTECTED]; Henry Poras
>
>
>
> Henry,
>
> You say 'nearly identical'.
>
> What are the differences?
>
> Are the 2 databases on the same platform?
>
> If not, what are the differences, hardware and OS?
>
> Jared
>
>
> On Monday 07 May 2001 21:55, Henry Poras wrote:
> > I am working with an 8.1.6 database on Solaris 2.6 and I am wondering if
> > there is any consistency in the optimizer. We have two nearly identical
> > databases (one a clone from two weeks ago). A five table join has nearly
> > the identical execution plan on the two databases. The difference is in
> the
> > access method of the fourth table in the join; in one case it is
accessed
> > by a FTS and in the other, by Index. This difference has a large effect
on
> > performance. Statistics are nearly identical for this table in both
> > databases (I looked at dba_tables, dba_indexes, dba_col_tables). Also,
the
> > init.ora is the same. When I changed the optimizer_mode to rule and
added
> a
> > 'choose' hint to the query, the execution plan was different again. I
will
> > look into this a bit further and post my results. Just wondering about
> > other's experiences. Thanks.
> >
> > Henry
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Henry Poras
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nicoll, Iain (Calanais)
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Re: consistency in cost?

2001-05-08 Thread Sam Roberts

If the system is Rule based and you code Hints, the CBO will be
automatically invoked
Sam


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, May 08, 2001 10:12 PM


> Forgive my ignorance but I thought hints were only for cost based
optimizer.
>
>
> Have you checked in case anybody has changed any parameters while the
system
> is running as I know that changing the hash_area_size can change the
> execution plan?.  Are you using parallelism as if a table had to be
> recreated for any reason and its degree changed it might do a FTS?
>
> Cheers
>
> Iain Nicoll
>
>
> -Original Message-
> Sent: 08 May 2001 17:31
> To: Multiple recipients of list ORACLE-L
>
>
> Jared,
> The only difference is about a weeks worth of extra data. Well, the
hardware
> is also different (Ultra450 vs. Ultra 5000. Also 1 vs 4 CPU). But
> regardless, shouldn't init.ora optimizer_mode=choose be identical to
> optimizer_mode=rule with hint=choose? If I have the time, I'll try to set
up
> a couple of systems and examine by moving stats and taking some 10053
dumps.
> (one of the ones giving me a problem is in production so I have limited
play
> time there).
>
> Henry
>
> -Original Message-
> Sent: Tuesday, May 08, 2001 12:56 AM
> To: [EMAIL PROTECTED]; Henry Poras
>
>
>
> Henry,
>
> You say 'nearly identical'.
>
> What are the differences?
>
> Are the 2 databases on the same platform?
>
> If not, what are the differences, hardware and OS?
>
> Jared
>
>
> On Monday 07 May 2001 21:55, Henry Poras wrote:
> > I am working with an 8.1.6 database on Solaris 2.6 and I am wondering if
> > there is any consistency in the optimizer. We have two nearly identical
> > databases (one a clone from two weeks ago). A five table join has nearly
> > the identical execution plan on the two databases. The difference is in
> the
> > access method of the fourth table in the join; in one case it is
accessed
> > by a FTS and in the other, by Index. This difference has a large effect
on
> > performance. Statistics are nearly identical for this table in both
> > databases (I looked at dba_tables, dba_indexes, dba_col_tables). Also,
the
> > init.ora is the same. When I changed the optimizer_mode to rule and
added
> a
> > 'choose' hint to the query, the execution plan was different again. I
will
> > look into this a bit further and post my results. Just wondering about
> > other's experiences. Thanks.
> >
> > Henry
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Henry Poras
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nicoll, Iain (Calanais)
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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



Table autonumber field

2001-05-08 Thread Mike T

Total Newbie
I need to create an autonumber field in an Oracle Table (from a SQL server table 
identity field) , I was looking for a default value that I could assign (select 
max(ID) + 1)  or some way to create an identity field
or use a trigger after insert but nothing seems to work for me. Any help would be 
appreciated, This field also has to be the primary Key .
TIA
MT

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

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

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



Re: OT: Off Topic - Blah, Blah, Blah...

2001-05-08 Thread Jared Still

On Tuesday 08 May 2001 15:02, Kimberly Smith wrote:
> Jared, are you saying that because we know what we are doing
> we go off topic more?

Well, yeah, in a round about kind of way.

I'm not sure at the moment how to put it without
offending some folks.

Lemme think about it;  I'll get back to it later.

Jared

>
> -Original Message-
> Sent: Tuesday, May 08, 2001 12:00 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> It's not just you, there are more off topic posts.
>
> Oracle-L also has a much higher percentage
> of people that actually know what they're doing,
> and aren't afraid to read the manual.
>
> Jared
>
> On Tuesday 08 May 2001 11:06, [EMAIL PROTECTED] wrote:
> > As I type, I'm guilty of committing what I'm about to rant about...
> >
> > It's not much of a "rant", but...
> >
> > I, like many on this list (ORACLE-L), subscribe and participate in both
> > this and the Lazy-DBA list.  Is it just me, or does this list (ORACLE-L)
> > have way more Off Topic posts??  I don't mean Off Topic as in: "UNIX vs.
> > NT" or "Should I learn Java or C# to enhance my skills?", but
> > rather...well, I think you know what I mean.  I'm not necessarily
> > complaining, just making an observation!!
> >
> > Ed Haskins
> > Oracle DBA
> > Verizon Wireless
> >
> >
> > -Original Message-
> > Sent: Tuesday, May 08, 2001 1:26 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > I have been informed privately that some may find this remark offensive,
> > perhaps even deeply so.
> >
> > For those people:  "Sorry!, that wasn't my intent."
> >
> > || -Original Message-
> > || From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
> > || Sent: Tuesday, May 08, 2001 12:23 PM
> > || To: Multiple recipients of list ORACLE-L
> > || Subject: OT RE: Taking your time when a crisis occurs
> > ||
> > ||
> > || Barbie doesn't talk when he takes her
> > || clothes off.
> > ||
> > || || -Original Message-
> > || || From: David A. Barbour [mailto:[EMAIL PROTECTED]]
> > || || Sent: Monday, May 07, 2001 10:35 PM
> > || || To: Multiple recipients of list ORACLE-L
> > || || Subject: Re: Taking your time when a crisis occurs
> > || ||
> > || ||
> > || || Eric,
> > || ||
> > || || What's with you and Barbie?
> > || ||
> > || || David A. Barbour
> > || ||
> > || || "Eric D. Pierce" wrote:
> > || || >  RE: Taking your time when a crisis occurs
> > || || >
> > || || > -
> > || || >
> > || || > http://www.amazon.com/exec/obidos/ASIN2/B4SU3E
> > || || >
> > || || > Barbie as Glinda from The Wizard of Oz
> > || || >
> > || || >
> > || || > Our Price: $19.99
> > || || > Availability: Usually ships within 24 hours.
> > || || >
> > || || > Manufacturer's age: 3 years and up
> > || || > Shipping: Currently, item can be shipped only within the U.S.
> > || || > Shipping weight: 0.7 pounds.
> > || || > Note: Giftwrapping not available for this item.
> > || || > Packaging: This item may be delivered in the
> > || ||
> > || || manufacturer's original
> > || ||
> > || || > packaging, which could reveal the contents of the box.
> > || || > ASIN: B4SU3E
> > || || >
> > || || > >From Toysrus.com & Amazon.com
> > || || >
> > || || > Editorial Review
> > || || >
> > || || > "Are you a good witch or a bad witch?" A good witch, of
> > ||
> > || course--and
> > ||
> > || || > pretty as well! Dressed as Glinda, the good witch of
> > ||
> > || the North from
> > ||
> > || || > the beloved book and movie The Wizard of Oz, Barbie is
> > ||
> > || welcomed to
> > ||
> > || || > Munchkinland. She has long, curly strawberry-blonde hair
> > || ||
> > || || topped by a
> > || ||
> > || || > tall lavender-pink crown, and she's wearing a sparkling
> > ||
> > || pink satin
> > ||
> > || || > ball gown ornamented with silver stars and butterflies.
> > || ||
> > || || She also has
> > || ||
> > || || > on a silver braided belt. Her outfit is completed with
> > || ||
> > || || pink heels and
> > || ||
> > || || > a long, lavender magic wand that fits in her hand. Raise
> > || ||
> > || || her arm (or
> > || ||
> > || || > press the button on her back), and you'll hear the
> > ||
> > || wand's magical
> > ||
> > || || > "brrinnng!" sound or Glinda's voice saying, "Tap your
> > || ||
> > || || heels together
> > || ||
> > || || > three times." Sound effects are produced by three
> > ||
> > || included button
> > ||
> > || || > cell batteries, which can be replaced. Say it again,
> > || ||
> > || || Glinda, just so
> > || ||
> > || || > we'll never forget: "There's no place like home."
> > ||
> > || --Marcie Bovetz
> > ||
> > || || > Safety Information
> > || || > Choking hazard: Small parts. Not for children under 3 years.
> > || || >
> > || || > -
> > || || >
> > || || > On 7 May 2001, at 10:21, Marianne Brooks wrote:
> > || || > > Hmm, shaved head, why didn't I think of that?  I would
> > || ||
> > || || imagine a woman with
> > || ||
> > || || > > a shaved head might be as effective...add a tatoo, some
> > || ||
> > || || leather pa

SORRY - I am a junk mail delete me

2001-05-08 Thread sinardyxing



Out Look Rule wizard testing

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

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

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



Re: Oracle tuning book

2001-05-08 Thread Rachel Carmichael

yes I can see him in that tent "I have come to save your database with the 
new world from on high -- tune with wait events" (Gaja, you know I love you, 
right?)

Mogens is pretty darned smart, I lump him in with the "Gaja/Cary 
Millsap/Craig Shallahamer" crowd... people who can teach me much and who I 
feel privileged to have met


>From: Don Granaman <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Oracle tuning book
>Date: Tue, 08 May 2001 16:45:25 -0800
>
>I'm not sure about the "Mogens as god" deal, but Gaja is a fine evangelist!
>I very large tent would have been a fine venue for the "...Tuning Myths and
>Folklore" session!
>
>-- Don Granaman (AKA OraSaurus)
>
>Kevin Kostyszyn wrote:
> >
> > Just a quick one, what do you have to be to be and Oracle God?
> >
> > -Original Message-
> > Carmichael
> > Sent: Tuesday, May 08, 2001 3:27 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > Nah, he'd mess with your last name, not first :)
> >
> > Okay folks, to clue those who weren't there in, at IOUG, at a 
>presentation
> > by Mogens Norgaard (an Oracle God as far as I am concerned), he played 
>games
> > with the spelling of Gaja's last name as well as Craig Shallahamer's... 
>in
> > fun, but boy did Gaja jump :)
> >
> > Rachel
> >
> > >From: "Deshpande, Kirti" <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > >Subject: RE: Oracle tuning book
> > >Date: Tue, 08 May 2001 09:32:54 -0800
> > >
> > >Yes it is..
> > >That's my official full first name..
> > >Hope Mogens doesn't get any ideas  ;)
> > >
> > >- Kirti
> > >
> > > > -Original Message-
> > > > From:   Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]]
> > > > Sent:   Tuesday, May 08, 2001 10:46 AM
> > > > To: Multiple recipients of list ORACLE-L
> > > > Subject:RE: Oracle tuning book
> > > >
> > > > Kirti,
> > > >
> > > > Is that your name on the book with Gaja?
> > > >
> > > > Raj
> > > > __
> > > > Rajendra Jamadagni  MIS, ESPN Inc.
> > > > Rajendra dot Jamadagni at ESPN dot com
> > > > Any opinion expressed here is personal and doesn't reflect that of 
>ESPN
> > > > Inc.
> > > >
> > > > QOTD: Any clod can have facts, but having an opinion is an art !
> > > >
> > > > 
>*
> > > >
> > > > This e-mail message is confidential, intended only for the named
> > > > recipient(s) above and may contain information that is privileged,
> > > > attorney work product or exempt from disclosure under applicable 
>law. If
> > > > you have received this message in error, or are not the named
> > > > recipient(s), please immediately notify ESPN at (860) 766-2000 and
> > >delete
> > > > this e-mail message from your computer, Thank you.
> > > >
> > > > 
>*
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: Jamadagni, Rajendra
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > > San Diego, California-- Public Internet access / Mailing 
>Lists
> > > > 
> > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed from).  You may
> > > > also send the HELP command for other information (like subscribing).
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Deshpande, Kirti
> > >   INET: [EMAIL PROTECTED]
> > >
> > >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > >San Diego, California-- Public Internet access / Mailing Lists
> > >
> > >To REMOVE yourself from this mailing list, send an E-Mail message
> > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > >the message BODY, include a line containing: UNSUB ORACLE-L
> > >(or the name of mailing list you want to be removed from).  You may
> > >also send the HELP command for other information (like subscribing).
> >
> > _
> > Get your FREE download of MSN Explorer at http://explorer.msn.com
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > -

Re: ??? object visibility

2001-05-08 Thread Glen Mitchell


Actually thinking about it, I should have said ...
"The table name that the synonym (or view) is referencing is probably
not called associate or is not in your current schema, hence
the non-existence error..."
 
Glen Mitchell wrote:
My guess would be that you are actually looking at
a synonym (or view) called associate.
The table name that the synonym (or view) is referencing is probably
not called associate, hence the non-existence error when trying to truncate
the table called associate.  Run the following query to verify ...
select synonym_name, table_name from user_synonyms where synonym_name
like 'ASSOCIATE';
Glen
Janet Linsy wrote:
Hi all,
I got a table, when I do desc, delete, it works, but
when I do truncate, I got error "table or view does
not exist".  Any idea?
SQL> desc associate --> can see the table
SQL> select count(*) from associate;  --> works
 1
SQL> truncate table associate; --> got error below
truncate table associate
  
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> SQL> delete associate;  --> works
SQL>
Thanks
Janet
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janet Linsy
  INET: [EMAIL PROTECTED]
Fat City Network Services    -- (858) 538-5051 
FAX: (858) 538-5051
San Diego, California    --
Public Internet access / Mailing Lists

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

-- 
Glen Mitchell   NZ Phone: +64 9 3730400
Energy Research Lab URL: http://www.peace.com
Peace Software  Email: [EMAIL PROTECTED]
 

-- 
Glen Mitchell   NZ Phone: +64 9 3730400
Energy Research Lab URL: http://www.peace.com
Peace Software  Email: [EMAIL PROTECTED]
 


RE: join across database link

2001-05-08 Thread Kimberly Smith

Actually there is a similar bug in 8.1.7.  Basically, don't describe
across db links.

-Original Message-
Sent: Tuesday, May 08, 2001 6:41 PM
To: Multiple recipients of list ORACLE-L



Let's do the ez one first.

On Tuesday 08 May 2001 11:42, [EMAIL PROTECTED] wrote:
> When I do a describe across the link I get "ORA-12663-Services required by
> the client not available on the server."

This is a bug, don't worry about it.  The only fix is to upgrade your
database from 7.3 to 8.something.   It only affects the 'describe' command.


> When I connect to the  NT and run the query by hand it also hangs.  But I
> can join the NT table to each of the AIX tables and get instant results -
I
> just cannot join all three.

Turn tracing on for the session and check out the trace file.  In all 
likelihood the session is not actually hung, just running very slowly.

You can also monitor v$sess_io to see what activity is taking place
for the session.

Check out the explain plan.  Do you have a copy of the explain plan
from when it worked?  Of course you don't, neither does anyone else.

If you did, you could compare them.  As it is, take a look at it, as it
may be rather revealing.

Jared

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

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

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

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

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



Re: ??? object visibility

2001-05-08 Thread Glen Mitchell


My guess would be that you are actually looking at a synonym (or view)
called associate.
The table name that the synonym (or view) is referencing is probably
not called associate, hence the non-existence error when trying to truncate
the table called associate.  Run the following query to verify ...
select synonym_name, table_name from user_synonyms where synonym_name
like 'ASSOCIATE';
Glen
Janet Linsy wrote:
Hi all,
I got a table, when I do desc, delete, it works, but
when I do truncate, I got error "table or view does
not exist".  Any idea?
SQL> desc associate --> can see the table
SQL> select count(*) from associate;  --> works
 1
SQL> truncate table associate; --> got error below
truncate table associate
  
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> SQL> delete associate;  --> works
SQL>
Thanks
Janet
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janet Linsy
  INET: [EMAIL PROTECTED]
Fat City Network Services    -- (858) 538-5051 
FAX: (858) 538-5051
San Diego, California    --
Public Internet access / Mailing Lists

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

-- 
Glen Mitchell   NZ Phone: +64 9 3730400
Energy Research Lab URL: http://www.peace.com
Peace Software  Email: [EMAIL PROTECTED]
 


Re: join across database link

2001-05-08 Thread Jared Still


Let's do the ez one first.

On Tuesday 08 May 2001 11:42, [EMAIL PROTECTED] wrote:
> When I do a describe across the link I get "ORA-12663-Services required by
> the client not available on the server."

This is a bug, don't worry about it.  The only fix is to upgrade your
database from 7.3 to 8.something.   It only affects the 'describe' command.


> When I connect to the  NT and run the query by hand it also hangs.  But I
> can join the NT table to each of the AIX tables and get instant results - I
> just cannot join all three.

Turn tracing on for the session and check out the trace file.  In all 
likelihood the session is not actually hung, just running very slowly.

You can also monitor v$sess_io to see what activity is taking place
for the session.

Check out the explain plan.  Do you have a copy of the explain plan
from when it worked?  Of course you don't, neither does anyone else.

If you did, you could compare them.  As it is, take a look at it, as it
may be rather revealing.

Jared

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

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

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



Re: Inserts slowing down on OLTP systems

2001-05-08 Thread Jared Still


As Rachel already said, don't bother with hit ratios.

They are in fact nearly useless for any kind of tuning.

For a good ( but verbose ) paper on the subject, goto
www.hotsos.com

Jared


On Monday 07 May 2001 17:55, Vikas Kawatra wrote:
> Anyone have ideas on why OLTP database inserts would slow down by 100% from
> levels 15 days ago ?
>
> We alreay checked hit ratios in shared pool , checked for any storage
> issues etc
>
> thanks
>
> vikas
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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



??? object visibility

2001-05-08 Thread Janet Linsy

Hi all,

I got a table, when I do desc, delete, it works, but
when I do truncate, I got error "table or view does
not exist".  Any idea?

SQL> desc associate --> can see the table

SQL> select count(*) from associate;  --> works

 1

SQL> truncate table associate; --> got error below

truncate table associate
   *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> SQL> delete associate;  --> works
SQL> 


Thanks

Janet


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janet Linsy
  INET: [EMAIL PROTECTED]

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

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



Re: Oracle tuning book

2001-05-08 Thread Don Granaman

I'm not sure about the "Mogens as god" deal, but Gaja is a fine evangelist!
I very large tent would have been a fine venue for the "...Tuning Myths and
Folklore" session!

-- Don Granaman (AKA OraSaurus)

Kevin Kostyszyn wrote:
> 
> Just a quick one, what do you have to be to be and Oracle God?
> 
> -Original Message-
> Carmichael
> Sent: Tuesday, May 08, 2001 3:27 PM
> To: Multiple recipients of list ORACLE-L
> 
> Nah, he'd mess with your last name, not first :)
> 
> Okay folks, to clue those who weren't there in, at IOUG, at a presentation
> by Mogens Norgaard (an Oracle God as far as I am concerned), he played games
> with the spelling of Gaja's last name as well as Craig Shallahamer's... in
> fun, but boy did Gaja jump :)
> 
> Rachel
> 
> >From: "Deshpande, Kirti" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: Oracle tuning book
> >Date: Tue, 08 May 2001 09:32:54 -0800
> >
> >Yes it is..
> >That's my official full first name..
> >Hope Mogens doesn't get any ideas  ;)
> >
> >- Kirti
> >
> > > -Original Message-
> > > From:   Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]]
> > > Sent:   Tuesday, May 08, 2001 10:46 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject:RE: Oracle tuning book
> > >
> > > Kirti,
> > >
> > > Is that your name on the book with Gaja?
> > >
> > > Raj
> > > __
> > > Rajendra Jamadagni  MIS, ESPN Inc.
> > > Rajendra dot Jamadagni at ESPN dot com
> > > Any opinion expressed here is personal and doesn't reflect that of ESPN
> > > Inc.
> > >
> > > QOTD: Any clod can have facts, but having an opinion is an art !
> > >
> > > *
> > >
> > > This e-mail message is confidential, intended only for the named
> > > recipient(s) above and may contain information that is privileged,
> > > attorney work product or exempt from disclosure under applicable law. If
> > > you have received this message in error, or are not the named
> > > recipient(s), please immediately notify ESPN at (860) 766-2000 and
> >delete
> > > this e-mail message from your computer, Thank you.
> > >
> > > *
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Jamadagni, Rajendra
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing Lists
> > > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like subscribing).
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Deshpande, Kirti
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
> 
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Kostyszyn
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list,

Re: Looking for opions on I/Watch from Quest

2001-05-08 Thread Stephen Andert

We are using it here with mixed results.  One of our biggest issues is the fact that 
it will go down without notice and therefore not notify us of pending problems.  
Another problem is that we have a very specific on-call schedule that varies by time 
of day and from week to week.  We have not found a manageable way to page according to 
our business rules.  

Other than that, it is a pretty good tool.  I prefer to use Spotlight to look at the 
system "live" and SQLab Xpert to tune SQL.

YMMV, HTH, etc.
Stephen Andert

>>> [EMAIL PROTECTED] 05/08/01 12:43PM >>>
I am looking for opions on their tool.  I am installing and setting it up
right now.  Is anyone out there using it and do you like it?  Can you
compare it to OEM (which I actually hate).


Kimberly Smith
Database Administrator
EDS - Fujitsu/GMD
Phone: (503) 669-6050
Fax: (503) 669-5705
Email : [EMAIL PROTECTED] 

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

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

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



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

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

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



RE: E-mail from Alert Logs

2001-05-08 Thread Guidry, Chris

Hello,
I use BLAT which can be found on page 2 of Command Line Mail Tools
at http://www.freedownloadscenter.com/Email_Tools/.

--
Chris J. Guidry  P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]

> -Original Message-
> From: Rao, Maheswara [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 12:37 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: E-mail from Alert Logs
> 
> Bunyamin,
> 
> Could you please send the attachment directly to me?
> 
> Thanks,
> 
> Rao
> 
> [EMAIL PROTECTED]
> 
> -Original Message-
> Sent: Thursday, May 03, 2001 9:52 AM
> To: Multiple recipients of list ORACLE-L
> 
>  There is a program (AUTOMAIL) which sends an email to anyone you idntify
> when there is a change in a file. Look at it . It is attached .
> 
> 
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Thursday, May 03, 2001 3:00 PM
> 
> 
> > Hi List
> >
> > Is there any way of receiving an e-mail or sms , whenever a ORA- error
> > appears in the Oracle Alert Log, or when something unexpected happens to
> > the Oracle Instance ?
> >
> >
> > TIA
> >
> > Saj
> >
> > --
> > Sajid Iqbal
> > Database Team Leader
> >
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Sajid Iqbal
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rao, Maheswara
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Guidry, Chris
  INET: [EMAIL PROTECTED]

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

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



RE: Oracle tuning book

2001-05-08 Thread Thater, William

On Tue, 8 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon:

->brilliant :)

Well, that let's me out.;-)

--
Bill Thater Certifieable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
fortune: No such file or directory

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

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

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



RE: OT RE: sorry,

2001-05-08 Thread Eric D. Pierce

that is correct, sir!

On 8 May 2001, at 12:56, David Messer wrote:

> Is this to extol the virtues of chasing some wild ass or are you suggesting
> a meeting in Tonopah?

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

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

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



tkprof and security?

2001-05-08 Thread Chris Rezek

I want to enable our developers to use tkprof for their own tuning work
without giving them general ALTER SESSION privileges.  What's the
minimal set of permissions do they need to use explain plan and tkprof?

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

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

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



RE: Urgent Date Problem

2001-05-08 Thread Khedr, Waleed

It seems that the environment variable TZ was not set correctly in the
Oracle account before starting the database.

-Original Message-
Sent: Tuesday, May 08, 2001 4:06 PM
To: Multiple recipients of list ORACLE-L


Hi Everybody

I need advise for one of mine problem. I am  trying to
access database from ODBC test in Windows to Server on
UNIX and when doing 

select sysdate from dual;

then are getting  let say 12:00pm

and when trying to run the same query on the server by
telnet to server, it is working fine and giving
current time of 11:00am. The problem is been seen from
the Daylight Saving time Change. 

Due to this problem, mine application is also rporting
the time difference of 1 hour in mine one of the Date
column which is populated by trigger containg same
Sysdate value assigne to the vaiable and then using
that variable to insert into the tables. The problem
is reported only after the Daylight saving Change

Thanks in Advance for everybody comments and help


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Navtej B
  INET: [EMAIL PROTECTED]

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

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

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

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



Re:Looking for opions on I/Watch from Quest

2001-05-08 Thread dgoulet

Kimberley,

We tried it, nice graphics, that's about all.  As far as functionality vs
OEM, there is no comparison.  You can't do much in I/Watch except disconnect
someone.  Therefore as a pretty monitor it just was not worth the money.

Dick Goulet

Reply Separator
Author: Kimberly Smith <[EMAIL PROTECTED]>
Date:   5/8/2001 11:43 AM

I am looking for opions on their tool.  I am installing and setting it up
right now.  Is anyone out there using it and do you like it?  Can you
compare it to OEM (which I actually hate).


Kimberly Smith
Database Administrator
EDS - Fujitsu/GMD
Phone: (503) 669-6050
Fax: (503) 669-5705
Email : [EMAIL PROTECTED]

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

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

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

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

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



Re: Enterprise Manger

2001-05-08 Thread Rodd Holman

WELCOME BACK BAMBI!!!

Great to see you back.
What version of Oracle and OEM are you dealing with?  Don't know if you 
have MetaStink access, but I found this out there.  Hope it might be helpful.

Rodd Holman
[EMAIL PROTECTED]
 

Doc ID: 
  Note:114682.1
  Subject: 
  TROUBLESHOOTING GUIDE: How To Troubleshoot A VTK-1000
  Error
  Type: 
  BULLETIN
  Status: 
  PUBLISHED

  
Content Type: 
  
   TEXT/PLAIN
  
Creation Date: 
  
   07-JUL-2000
  
Last Revision Date: 
  
   07-MAR-2001



  TROUBLESHOOTING GUIDE: VTK-1000 Error
  =

  Goal: How to troubleshoot a VTK-1000 error.


  Fact: Oracle Enterprise Manager 

  Change: NOTE ROLE: 
  The Enterprise Manager (EM) Console connects to a middle-tier service 
called the 
  Management Server (OMS).  If this connection attempt fails for any 
reason, the 
  EM Client will receive the error: 

 VTK-1000: Unable to connect to Management Server 
 Please verify that you have entered the correct name and
 status of the Oracle Management Server   
 OK


  Fix: The VTK-1000 error can occur due to problems with the EM Client 
setup 
  or because the Management Server is not started.  To troubleshoot the 
error, 
  begin at the EM Client:

  EM Client: 
  1.  Verify the Management Server hostname listed in the EM Console 
logon window 
  is the correct hostname.  
  For additional information, see [NOTE:1067911.6]

  2.  Verify the Management Server hostname is reachable through TCP/IP 
from the 
  EM Client system.  
  For additional information, see [NOTE:1077548.6]

  3.  Verify the EM Console and Management Server are at the same patch 
level.


  Next, go to the Management Server:
  4.  Verify the Management Server is started.  
  For additional information, see:
  [NOTE:107235.1] How To Start A Management Server From A Dos Prompt 
on NT
  [NOTE:117193.1] How To Start A Management Server Running DHCP
  [NOTE:109494.1] How To Start A Management Server On Unix

  If the Management Server will not start, turn on OMS logging and 
look in 
  the oms log file for possible failure messages.  

  NOTE: For instructions on how to log the OMS startup process, see 
Additional Troubleshooting hints listed below.

  If the EM client is setup correctly, check the Management Server:
  See [NOTE:133799.1] Troubleshooting Guide: How to Troubleshoot Problems 
starting
  the Management Server.




  Additional Troubleshooting
  --

  If the solutions listed above do not resolve the VTK-1000, additional 
debugging
  information must be captured.

  1.  To Trace the EM Console, see [NOTE:106074.1].

  2.  To Trace the OMS, see [NOTE:68741.1].

  Additional debugging information can also be found in [NOTE:69522.1].


  References
  ---
  General Setup Information:
  [NOTE:107241.1]  QUICK START GUIDE Enterprise Manager 2.1

  EM Client Problems:
  [NOTE:1067911.6] Logging into EM Console Fails with VTK-1000 When OMS 
Hostname 
   is Incorrect
  [NOTE:1077548.6] Logging into EM Console Fails with VTK-1000 After 
Changing the 
   OMS Hostname
  .

>> Original Message <<

On 5/8/01, 3:17:01 PM, Bambi Bellows <[EMAIL PROTECTED]> wrote regarding 
Enterprise Manger:


> Greetings, Fellow OraHax!  Long time no see.  I've been off doing 
interesting things for awhile and have been pretty quiet.  I've got a 
problem and I'm pretty embarrassed by it.  Let me write embedded SQL/Korn 
shell or do funky DBA things all day but don't make me use a GUI!  But, 
well, we do what we have to.

> Anyway, I have Enterprise Manager running on a remote NT box.  I have 
created a repository owner (entmgr) and made sure that the service is 
running.  If I try going into enterprise manager with just the SID, I get 
VTK-1000.  If I try to log in specifying the machine name (which I tried on 
a lark... it doesn't make sense to me to specify the machine name), I get 
"invalid login credential supplied".

> aTdHvAaNnKcSe!
> Bambi.
> --

> ___
> Get your free email from http://www.mail.com

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

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

RE: OT: Off Topic - Blah, Blah, Blah...

2001-05-08 Thread Kimberly Smith

Jared, are you saying that because we know what we are doing
we go off topic more?

-Original Message-
Sent: Tuesday, May 08, 2001 12:00 PM
To: Multiple recipients of list ORACLE-L



It's not just you, there are more off topic posts.

Oracle-L also has a much higher percentage
of people that actually know what they're doing,
and aren't afraid to read the manual.

Jared


On Tuesday 08 May 2001 11:06, [EMAIL PROTECTED] wrote:
> As I type, I'm guilty of committing what I'm about to rant about...
>
> It's not much of a "rant", but...
>
> I, like many on this list (ORACLE-L), subscribe and participate in both
> this and the Lazy-DBA list.  Is it just me, or does this list (ORACLE-L)
> have way more Off Topic posts??  I don't mean Off Topic as in: "UNIX vs.
> NT" or "Should I learn Java or C# to enhance my skills?", but
> rather...well, I think you know what I mean.  I'm not necessarily
> complaining, just making an observation!!
>
> Ed Haskins
> Oracle DBA
> Verizon Wireless
>
>
> -Original Message-
> Sent: Tuesday, May 08, 2001 1:26 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I have been informed privately that some may find this remark offensive,
> perhaps even deeply so.
>
> For those people:  "Sorry!, that wasn't my intent."
>
> || -Original Message-
> || From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
> || Sent: Tuesday, May 08, 2001 12:23 PM
> || To: Multiple recipients of list ORACLE-L
> || Subject: OT RE: Taking your time when a crisis occurs
> ||
> ||
> || Barbie doesn't talk when he takes her
> || clothes off.
> ||
> || || -Original Message-
> || || From: David A. Barbour [mailto:[EMAIL PROTECTED]]
> || || Sent: Monday, May 07, 2001 10:35 PM
> || || To: Multiple recipients of list ORACLE-L
> || || Subject: Re: Taking your time when a crisis occurs
> || ||
> || ||
> || || Eric,
> || ||
> || || What's with you and Barbie?
> || ||
> || || David A. Barbour
> || ||
> || || "Eric D. Pierce" wrote:
> || || >  RE: Taking your time when a crisis occurs
> || || >
> || || > -
> || || >
> || || > http://www.amazon.com/exec/obidos/ASIN2/B4SU3E
> || || >
> || || > Barbie as Glinda from The Wizard of Oz
> || || >
> || || >
> || || > Our Price: $19.99
> || || > Availability: Usually ships within 24 hours.
> || || >
> || || > Manufacturer's age: 3 years and up
> || || > Shipping: Currently, item can be shipped only within the U.S.
> || || > Shipping weight: 0.7 pounds.
> || || > Note: Giftwrapping not available for this item.
> || || > Packaging: This item may be delivered in the
> || ||
> || || manufacturer's original
> || ||
> || || > packaging, which could reveal the contents of the box.
> || || > ASIN: B4SU3E
> || || >
> || || > >From Toysrus.com & Amazon.com
> || || >
> || || > Editorial Review
> || || >
> || || > "Are you a good witch or a bad witch?" A good witch, of
> ||
> || course--and
> ||
> || || > pretty as well! Dressed as Glinda, the good witch of
> ||
> || the North from
> ||
> || || > the beloved book and movie The Wizard of Oz, Barbie is
> ||
> || welcomed to
> ||
> || || > Munchkinland. She has long, curly strawberry-blonde hair
> || ||
> || || topped by a
> || ||
> || || > tall lavender-pink crown, and she's wearing a sparkling
> ||
> || pink satin
> ||
> || || > ball gown ornamented with silver stars and butterflies.
> || ||
> || || She also has
> || ||
> || || > on a silver braided belt. Her outfit is completed with
> || ||
> || || pink heels and
> || ||
> || || > a long, lavender magic wand that fits in her hand. Raise
> || ||
> || || her arm (or
> || ||
> || || > press the button on her back), and you'll hear the
> ||
> || wand's magical
> ||
> || || > "brrinnng!" sound or Glinda's voice saying, "Tap your
> || ||
> || || heels together
> || ||
> || || > three times." Sound effects are produced by three
> ||
> || included button
> ||
> || || > cell batteries, which can be replaced. Say it again,
> || ||
> || || Glinda, just so
> || ||
> || || > we'll never forget: "There's no place like home."
> ||
> || --Marcie Bovetz
> ||
> || || > Safety Information
> || || > Choking hazard: Small parts. Not for children under 3 years.
> || || >
> || || > -
> || || >
> || || > On 7 May 2001, at 10:21, Marianne Brooks wrote:
> || || > > Hmm, shaved head, why didn't I think of that?  I would
> || ||
> || || imagine a woman with
> || ||
> || || > > a shaved head might be as effective...add a tatoo, some
> || ||
> || || leather pants and a
> || ||
> || || > > scowl and I've got a new me! :-)
> || || >
> || || > ...
> || || >
> || || > --
> || || > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> || || > --
> || || > Author: Eric D. Pierce
> || || >   INET: [EMAIL PROTECTED]
> || || >
> || || > Fat City Network Services-- (858) 538-5051  FAX:
> ||
> || (858) 538-5051
> ||
> || || > San Diego, California-- Public Internet access /
> || ||
> || || Mailing Lists
> ||
> || --

RE: Oracle tuning book

2001-05-08 Thread Rachel Carmichael

brilliant :)


>From: "Kevin Kostyszyn" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Oracle tuning book
>Date: Tue, 08 May 2001 11:55:33 -0800
>
>Just a quick one, what do you have to be to be and Oracle God?
>
>-Original Message-
>Carmichael
>Sent: Tuesday, May 08, 2001 3:27 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Nah, he'd mess with your last name, not first :)
>
>Okay folks, to clue those who weren't there in, at IOUG, at a presentation
>by Mogens Norgaard (an Oracle God as far as I am concerned), he played 
>games
>with the spelling of Gaja's last name as well as Craig Shallahamer's... in
>fun, but boy did Gaja jump :)
>
>Rachel
>
>
> >From: "Deshpande, Kirti" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: Oracle tuning book
> >Date: Tue, 08 May 2001 09:32:54 -0800
> >
> >Yes it is..
> >That's my official full first name..
> >Hope Mogens doesn't get any ideas  ;)
> >
> >- Kirti
> >
> > > -Original Message-
> > > From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]]
> > > Sent: Tuesday, May 08, 2001 10:46 AM
> > > To:   Multiple recipients of list ORACLE-L
> > > Subject:  RE: Oracle tuning book
> > >
> > > Kirti,
> > >
> > > Is that your name on the book with Gaja?
> > >
> > > Raj
> > > __
> > > Rajendra JamadagniMIS, ESPN Inc.
> > > Rajendra dot Jamadagni at ESPN dot com
> > > Any opinion expressed here is personal and doesn't reflect that of 
>ESPN
> > > Inc.
> > >
> > > QOTD: Any clod can have facts, but having an opinion is an art !
> > >
> > > *
> > >
> > > This e-mail message is confidential, intended only for the named
> > > recipient(s) above and may contain information that is privileged,
> > > attorney work product or exempt from disclosure under applicable law. 
>If
> > > you have received this message in error, or are not the named
> > > recipient(s), please immediately notify ESPN at (860) 766-2000 and
> >delete
> > > this e-mail message from your computer, Thank you.
> > >
> > > *
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Jamadagni, Rajendra
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing Lists
> > > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like subscribing).
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Deshpande, Kirti
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Kevin Kostyszyn
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMA

RE: OT RE: sorry,

2001-05-08 Thread Rachel Carmichael

well yeah, that's the point!



>From: "Mohan, Ross" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT RE: sorry,
>Date: Tue, 08 May 2001 12:17:00 -0800
>
>Yes but no work no pagers.
>
>Just liquids and humans.
>
>|| -Original Message-
>|| From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
>|| Sent: Tuesday, May 08, 2001 3:38 PM
>|| To: Multiple recipients of list ORACLE-L
>|| Subject: Re: OT RE: sorry,
>||
>||
>|| ooh ooh, now, can we set up a REAL meeting like that?
>||
>||
>|| >From: "Mohan, Ross" <[EMAIL PROTECTED]>
>|| >Reply-To: [EMAIL PROTECTED]
>|| >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>|| >Subject: OT RE: sorry,
>|| >Date: Tue, 08 May 2001 10:25:35 -0800
>|| >
>|| >Jared guessed it exactly at 5 minutes.
>|| >
>|| >It works like this...I see myself in a room with
>|| >all the relevant folks from the list. It is saturday.
>|| >all pagers are elsewhere. we have drinks in hand, be
>|| >they hard or soft, and we are talking.
>|| >
>|| >Then, I just type out the conversation.
>|| >
>|| >So, if you read it out loud, you have an idea of how long
>|| >it takes, mutatis mutandis for typing speed and error
>|| >correction, if any.
>|| >
>|| >|| -Original Message-
>|| >|| From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
>|| >|| Sent: Tuesday, May 08, 2001 1:39 PM
>|| >|| To: Multiple recipients of list ORACLE-L
>|| >|| Subject: RE: sorry,
>|| >||
>|| >||
>|| >|| knowing you, you just tossed it off in under 15 minutes :)
>|| >||
>|| >||
>|| >|| >From: "Mohan, Ross" <[EMAIL PROTECTED]>
>|| >|| >Reply-To: [EMAIL PROTECTED]
>|| >|| >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>|| >|| >Subject: RE: sorry,
>|| >|| >Date: Tue, 08 May 2001 08:15:29 -0800
>|| >|| >
>|| >|| >Jared,
>|| >|| >
>|| >|| >:) Thanks
>|| >|| >
>|| >|| >But, how long do you think it took to write this?
>|| >|| >
>|| >|| >Seriously...
>|| >|| >
>|| >|| >Ross
>|| >|| >
>|| >|| >
>|| >|| >
>|| >|| >|| -Original Message-
>|| >|| >|| From: Jared Still [mailto:[EMAIL PROTECTED]]
>|| >|| >|| Sent: Monday, May 07, 2001 9:11 PM
>|| >|| >|| To: Multiple recipients of list ORACLE-L
>|| >|| >|| Subject: Re: sorry,
>|| >|| >||
>|| >|| >||
>|| >|| >||
>|| >|| >|| ROFLMAO!
>|| >|| >||
>|| >|| >|| Geez Ross, do you really have a job?
>|| >|| >||
>|| >|| >|| Like, when do you *work*?
>|| >|| >||
>|| >|| >|| Or is this it?
>|| >|| >||
>|| >|| >|| Jared
>|| >|| >||
>|| >|| >||
>|| >|| >|| PS.  Bruce is more likely to kick you off than I am, and
>|| >|| >|| Jesus doesn't care.
>|| >|| >--
>|| >|| >Please see the official ORACLE-L FAQ: http://www.orafaq.com
>|| >|| >--
>|| >|| >Author: Mohan, Ross
>|| >|| >   INET: [EMAIL PROTECTED]
>|| >|| >
>|| >|| >Fat City Network Services-- (858) 538-5051  FAX:
>|| (858) 538-5051
>|| >|| >San Diego, California-- Public Internet access /
>|| >|| Mailing Lists
>|| >||
>|| >
>|| >|| >To REMOVE yourself from this mailing list, send an
>|| E-Mail message
>|| >|| >to: [EMAIL PROTECTED] (note EXACT spelling of
>|| 'ListGuru') and in
>|| >|| >the message BODY, include a line containing: UNSUB ORACLE-L
>|| >|| >(or the name of mailing list you want to be removed
>|| from).  You may
>|| >|| >also send the HELP command for other information (like
>|| subscribing).
>|| >||
>|| >|| _
>|| >|| Get your FREE download of MSN Explorer at http://explorer.msn.com
>|| >||
>|| >|| --
>|| >|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
>|| >|| --
>|| >|| Author: Rachel Carmichael
>|| >||   INET: [EMAIL PROTECTED]
>|| >||
>|| >|| Fat City Network Services-- (858) 538-5051  FAX:
>|| (858) 538-5051
>|| >|| San Diego, California-- Public Internet access /
>|| >|| Mailing Lists
>|| >||
>|| 
>|| >|| To REMOVE yourself from this mailing list, send an E-Mail message
>|| >|| to: [EMAIL PROTECTED] (note EXACT spelling of
>|| 'ListGuru') and in
>|| >|| the message BODY, include a line containing: UNSUB ORACLE-L
>|| >|| (or the name of mailing list you want to be removed
>|| from).  You may
>|| >|| also send the HELP command for other information (like
>|| subscribing).
>|| >||
>|| >--
>|| >Please see the official ORACLE-L FAQ: http://www.orafaq.com
>|| >--
>|| >Author: Mohan, Ross
>|| >   INET: [EMAIL PROTECTED]
>|| >
>|| >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>|| >San Diego, California-- Public Internet access /
>|| Mailing Lists
>|| >
>|| >To REMOVE yourself from this mailing list, send an E-Mail message
>|| >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>|| >the message BODY, include a line containing: UNSUB ORACLE-L
>|| >(or the name of mailing list 

Re:Pl/sql loop assistance

2001-05-08 Thread dgoulet

Linda,

Looks pretty simple, let's see:

set serveroutput on size 10
declare
  rows_processed number := 0;
begin
  for response in (select docalert_response_id
   from reg.docalert_emails_050401@ncc
   where sent = 1 ) loop
  update reg.docalert_responses@ncp
  set reg.docalert_responses.campaign_response_handled = 1
  where docalert_response_id = response.docalert_response_id;
  rows_processed := rows_processed+sql%rowcount;
  if(rows_processed >= 100) then
  commit;
  rows_processed := 0;
  end if;
  end loop;
  commit;
exception when others then dbms_output.put_line(sqlerrm);
   rollback;
end;
/


That should do it.

Dick Goulet

Reply Separator
Author: "Hagedorn; Linda" <[EMAIL PROTECTED]>
Date:   5/8/2001 10:47 AM

Hello, 

I'm having difficulty coding this loop and am hoping someone can see how
this can be done.   

I have two tables, one on each instance reg.docalert_responses@ncp and
reg.docalert_emails_05040@ncc 

The requirement is to set
ncp.reg.docalert_responses.campaign_response_handled = 1  for all
docalert_response_id's that exist in ncc.reg.docalert_emails_050401 where
sent=1.  Update 100 at a time and commit.  The join column,
docalert_response_id appears in both tables.  

I know I can set autocommit, but I'd really like to see the elegant loop
logic.  The DBLinks are in place.   

Any assistance is appreciated.  

Thanks, Linda 
 
 






Pl/sql loop assistance 



Hello, 


I'm having difficulty coding this loop and am
hoping someone can see how this can be done.   


I have two tables, one on each instance
reg.docalert_responses@ncp and reg.docalert_emails_05040@ncc 


The requirement is to set
ncp.reg.docalert_responses.campaign_response_handled = 1  for all
docalert_response_id's that exist in ncc.reg.docalert_emails_050401 where
sent=1.  Update 100 at a time and commit.  The join column,
docalert_response_id appears in both tables.  

I know I can set autocommit, but I'd really like to
see the elegant loop logic.  The DBLinks are in place.   


Any assistance is appreciated.  

Thanks, Linda 
 
 




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

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

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



Re: OT: Off Topic - Blah, Blah, Blah...

2001-05-08 Thread Rodd Holman

I agree,
This list is like a community with some very knowledgeable and colorful 
characters.  I enjoy the fact that we can discuss very technical items 
with humor and comraderie.  It beats stale tech-only academic discourse 
by a long shot.

Rodd Holman

>> Original Message <<

On 5/8/01, 2:37:40 PM, Rachel Carmichael <[EMAIL PROTECTED]> wrote 
regarding Re: OT: Off Topic - Blah, Blah, Blah...:


> we might, but we also have a LOT of heavily technical posts as well... I
> enjoy the off-topic stuff (at times) when I'm not swamped. And when I am
> swamped, well, the delete key is a wonderful thing.

> I basically hit "delete all" and then review the topics and posters and 
see
> what I really want to read :)



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

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

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



Re: Pl/sql loop assistance

2001-05-08 Thread Diana_Duncan


Linda,

Might I suggest avoiding the "elegant" looping and try some "inelegant"
looping?  It should be faster, although I can't make any promises.

Warning, untested, and you can probably do better than an in() -- but it
should give you the gist...

begin
 loop
  update reg.docalert_responses@ncp
  set campaign_response_handled = 1
  where campaign_response_handled != 1
  and rownum <= 100
  and docalert_response_id in (select docalert_response_id
   from docalert_emails_050401@ncc
   where sent = 1);
  commit;
  exit when sql%notfound;
 end loop;
end;
/

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC  27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]


   

"Hagedorn, 

Linda"   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
Fax to:   

Sent by: Subject: Pl/sql loop assistance   

root@fatcity.  

com

   

   

05/08/2001 

02:47 PM   

Please 

respond to 

ORACLE-L   

   

   





Hello,


I'm having difficulty coding this loop and am hoping someone can see how
this can be done.


I have two tables, one on each instance reg.docalert_responses@ncp and
reg.docalert_emails_05040@ncc


The requirement is to set
ncp.reg.docalert_responses.campaign_response_handled = 1  for all
docalert_response_id's that exist in ncc.reg.docalert_emails_050401 where
sent=1.  Update 100 at a time and commit.  The join column,
docalert_response_id appears in both tables.


I know I can set autocommit, but I'd really like to see the elegant loop
logic.  The DBLinks are in place.


Any assistance is appreciated.

Thanks, Linda









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

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

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



Re:RE: restrict login with known IP address

2001-05-08 Thread dgoulet

Joe,

I'd still suggest the connection manager in it's firewall configuration.  It
was introduced in 8.0 and above.  Works real well, I made the mistake of
configuring mine to knock myself out.  Boy did it ever while allowing anyone
else in.

Dick Goulet

Reply Separator
Author: "Leyden; Joseph" <[EMAIL PROTECTED]>
Date:   5/8/2001 10:36 AM

I'm using 8.0.5
am I hopeless?

-Original Message-
Sent: Tuesday, May 08, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L


Hi Joe,

What version of Oracle do you use?

In 815 and upstair you can use logon trigger.
Inside the trigger try to determine IP address of 
the current session using the following sikvel:

select sys_context('USERENV', 'IP_ADDRESS') from dual;

I haven't tryed this policy yet but I believe it should work.
Let me know if it works for you

Regards,
Ed

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>


> In UNIX,
> Knowing the IP address can I restrict any login 
> to the ORACLE db given this info?
> 
> any help is appreciated ...
> 
> Joe
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Leyden, Joseph
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shevtsov, Eduard
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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



Re: Rename Database on NT

2001-05-08 Thread Rodd Holman

Ron,
To change the database name, do an alter database backup controlfile to 
trace; from svrmgrl.  Then change the create controlfile line to the new 
database name.  Run the script.  To change the services, it's probably 
easier to use oradim and recreate the services with the new name.  The 
other alternative would be to shut all the services down and then do a 
registry crawl to change all the instance name stuff in the reg.

HTH
Rodd Holman

>> Original Message <<

On 5/8/01, 2:15:59 PM, "Smith," Ron "L." <[EMAIL PROTECTED]> wrote regarding 
Rename Database on NT:


> This has probably been answered a million times but...
> Is there any way to rename an Oracle database and all its services on NT?

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

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

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

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



RE: OT RE: sorry,

2001-05-08 Thread Thater, William

On Tue, 8 May 2001,Mohan, Ross scribbled on the wall in glitter crayon:

->Bingo, My Oak-barreled Friend!

Where and when?  And will the Goddess be there so I can get a hug?

--
Bill Thater Certifieable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
fortune: No such file or directory

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

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

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



Re: shutdown

2001-05-08 Thread Keith Shum

Guess you can check the process from the OS side.
If on Unix, could be ps (check server process), netstat (check network
connection)
If on Windows, could be netstat (just checking the network connection)

"Leyden, Joseph" wrote:

> If ORACLE shuts down and the instance ISN''T,
> using SHUTDOWN IMMEDIATE, how can I tell
> who is hanging up oracle?
>
> TIA
>
> Joe
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Leyden, Joseph
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

--
Keith Shum


iLux Corporation
(510) 226-5635
[EMAIL PROTECTED]


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

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

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



shutdown

2001-05-08 Thread Leyden, Joseph

If ORACLE shuts down and the instance ISN''T,
using SHUTDOWN IMMEDIATE, how can I tell
who is hanging up oracle?

TIA

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

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

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



RE: OT RE: sorry,

2001-05-08 Thread Mohan, Ross

Bingo, My Oak-barreled Friend!

|| -Original Message-
|| From: Thater, William [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 08, 2001 3:56 PM
|| To: Mohan, Ross
|| Cc: Multiple recipients of list ORACLE-L
|| Subject: RE: OT RE: sorry,
|| 
|| 
|| On Tue, 8 May 2001,Mohan, Ross scribbled on the wall in 
|| glitter crayon:
|| 
|| ->Yes but no work no pagers.
|| ->
|| ->Just liquids and humans.
|| 
|| You mean single malt and people to talk to where I don't 
|| have to keep my guard up?  I'm IN!
|| --
|| Bill Thater Certifieable ORACLE DBA
|| Telergy, Inc.[EMAIL PROTECTED]
|| ~~
|| You gotta program like you don't need the money,
|| You gotta compile like you'll never get hurt,
|| You gotta run like there's nobody watching,
|| It's gotta come from the heart if you want it to work.
|| ~~
|| fortune: No such file or directory
|| 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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



RE: OT RE: sorry,

2001-05-08 Thread Thater, William

On Tue, 8 May 2001,Mohan, Ross scribbled on the wall in glitter crayon:

->Yes but no work no pagers.
->
->Just liquids and humans.

You mean single malt and people to talk to where I don't have to keep my guard up?  
I'm IN!
--
Bill Thater Certifieable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
fortune: No such file or directory

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

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

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



RE: OT RE: sorry,

2001-05-08 Thread David Messer

Is this to extol the virtues of chasing some wild ass or are you suggesting
a meeting in Tonopah?

DM

-Original Message-
Pierce
Sent: Tuesday, May 08, 2001 1:26 PM
To: Multiple recipients of list ORACLE-L


http://www.tonopahnevada.com/

   "The boomtown of Tonopah was born in 1900,
   when Jim Butler accidentally discovered rich
   silver ore while chasing a wayward burro. "



On 8 May 2001, at 11:37, Rachel Carmichael wrote:

> ooh ooh, now, can we set up a REAL meeting like that?
>
>
> >From: "Mohan, Ross" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: OT RE: sorry,
> >Date: Tue, 08 May 2001 10:25:35 -0800
> >
> >Jared guessed it exactly at 5 minutes.
> >
> >It works like this...I see myself in a room with
> >all the relevant folks from the list. It is saturday.
> >all pagers are elsewhere. we have drinks in hand, be
> >they hard or soft, and we are talking.
> >
> >Then, I just type out the conversation.
> >
> >So, if you read it out loud, you have an idea of how long
> >it takes, mutatis mutandis for typing speed and error
> >correction, if any.

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

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

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


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

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

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



RE: OT OT OT OT OT OT OT RE: sorry,

2001-05-08 Thread Kevin Kostyszyn

All right that's it, Ross is losing it and has way to much
time on his hands!

-Original Message-
Sent: Tuesday, May 08, 2001 4:17 PM
To: Multiple recipients of list ORACLE-L


well, this might interest you:

your original post containing the "pi" had,
as it's timestamp, approximately the error in
your estimate.

"1:39"  vice "1:46".

Numerology anyone?

|| -Original Message-
|| From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 08, 2001 3:38 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: sorry,
||
||
|| Ohh, so close, didn't even realize the pi thingy, must be
|| some sort of
|| unconcious thing going on here!
||
|| -Original Message-
|| Sent: Tuesday, May 08, 2001 2:48 PM
|| To: Multiple recipients of list ORACLE-L
||
||
|| Pi?
||
|| You are too kind by approximately one minute and 46 seconds.
||
|| || -Original Message-
|| || From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
|| || Sent: Tuesday, May 08, 2001 1:39 PM
|| || To: Multiple recipients of list ORACLE-L
|| || Subject: RE: sorry,
|| ||
|| ||
|| || the way Ross's mind functions probably about 3 minutes and
|| || 14 seconds.
|| ||
|| || -Original Message-
|| || Sent: Tuesday, May 08, 2001 12:15 PM
|| || To: Multiple recipients of list ORACLE-L
|| ||
|| ||
|| || Jared,
|| ||
|| || :) Thanks
|| ||
|| || But, how long do you think it took to write this?
|| ||
|| || Seriously...
|| ||
|| || Ross
|| ||
|| ||
|| ||
|| || || -Original Message-
|| || || From: Jared Still [mailto:[EMAIL PROTECTED]]
|| || || Sent: Monday, May 07, 2001 9:11 PM
|| || || To: Multiple recipients of list ORACLE-L
|| || || Subject: Re: sorry,
|| || ||
|| || ||
|| || ||
|| || || ROFLMAO!
|| || ||
|| || || Geez Ross, do you really have a job?
|| || ||
|| || || Like, when do you *work*?
|| || ||
|| || || Or is this it?
|| || ||
|| || || Jared
|| || ||
|| || ||
|| || || PS.  Bruce is more likely to kick you off than I am, and
|| || || Jesus doesn't care.
|| || --
|| || Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| || --
|| || Author: Mohan, Ross
|| ||   INET: [EMAIL PROTECTED]
|| ||
|| || Fat City Network Services-- (858) 538-5051  FAX:
|| (858) 538-5051
|| || San Diego, California-- Public Internet access /
|| || Mailing Lists
|| ||
|| 
|| || To REMOVE yourself from this mailing list, send an E-Mail message
|| || to: [EMAIL PROTECTED] (note EXACT spelling of
|| 'ListGuru') and in
|| || the message BODY, include a line containing: UNSUB ORACLE-L
|| || (or the name of mailing list you want to be removed
|| from).  You may
|| || also send the HELP command for other information (like
|| subscribing).
|| || --
|| || Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| || --
|| || Author: Kevin Kostyszyn
|| ||   INET: [EMAIL PROTECTED]
|| ||
|| || Fat City Network Services-- (858) 538-5051  FAX:
|| (858) 538-5051
|| || San Diego, California-- Public Internet access /
|| || Mailing Lists
|| ||
|| 
|| || To REMOVE yourself from this mailing list, send an E-Mail message
|| || to: [EMAIL PROTECTED] (note EXACT spelling of
|| 'ListGuru') and in
|| || the message BODY, include a line containing: UNSUB ORACLE-L
|| || (or the name of mailing list you want to be removed
|| from).  You may
|| || also send the HELP command for other information (like
|| subscribing).
|| ||
|| --
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| --
|| Author: Mohan, Ross
||   INET: [EMAIL PROTECTED]
||
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access /
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from).  You may
|| also send the HELP command for other information (like subscribing).
||
|| --
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| --
|| Author: Kevin Kostyszyn
||   INET: [EMAIL PROTECTED]
||
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access /
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from).  You may
|| also send the HELP command for other information (like subscribing).
||
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:

RE: OT RE: sorry,

2001-05-08 Thread Hillman, Alex

Now you will have to add such disclaimer to all your messages :-)
I will save it for my own use if needed.

Alex Hillman

-Original Message-
Sent: Tuesday, May 08, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L


LOL

Hi, Anita!  And "yes", you don't want
to knowbut let's get into a room
and talk about it over drinks.

Take care.

- Ross



(Warning: The above remarks contains nothing bad, 
evil, salacious, mean, malacious, sexual, misogynistic 
or politically incorrect. It is simply an offer to 
meet a good friend for drinks. If you find a problem, 
provide yer own apology.) 

|| -Original Message-
|| From: A. Bardeen [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 08, 2001 2:48 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: OT RE: sorry,
|| 
|| 
|| Of course, knowing you, I have to wonder what
|| conversations you didn't share with us... then again,
|| maybe I don't wanna know after all ;)
|| 
|| --- "Mohan, Ross" <[EMAIL PROTECTED]> wrote:
|| > Jared guessed it exactly at 5 minutes. 
|| > 
|| > It works like this...I see myself in a room with
|| > all the relevant folks from the list. It is
|| > saturday. 
|| > all pagers are elsewhere. we have drinks in hand, be
|| > they hard or soft, and we are talking. 
|| > 
|| > Then, I just type out the conversation. 
|| > 
|| > So, if you read it out loud, you have an idea of how
|| > long
|| > it takes, mutatis mutandis for typing speed and
|| > error
|| > correction, if any. 
|| > 
|| > || -Original Message-
|| > || From: Rachel Carmichael
|| > [mailto:[EMAIL PROTECTED]]
|| > || Sent: Tuesday, May 08, 2001 1:39 PM
|| > || To: Multiple recipients of list ORACLE-L
|| > || Subject: RE: sorry,
|| > || 
|| > || 
|| > || knowing you, you just tossed it off in under 15
|| > minutes :)
|| > || 
|| > || 
|| > || >From: "Mohan, Ross" <[EMAIL PROTECTED]>
|| > || >Reply-To: [EMAIL PROTECTED]
|| > || >To: Multiple recipients of list ORACLE-L
|| > <[EMAIL PROTECTED]>
|| > || >Subject: RE: sorry,
|| > || >Date: Tue, 08 May 2001 08:15:29 -0800
|| > || >
|| > || >Jared,
|| > || >
|| > || >:) Thanks
|| > || >
|| > || >But, how long do you think it took to write
|| > this?
|| > || >
|| > || >Seriously...
|| > || >
|| > || >Ross
|| > || >
|| > || >
|| > || >
|| > || >|| -Original Message-
|| > || >|| From: Jared Still [mailto:[EMAIL PROTECTED]]
|| > || >|| Sent: Monday, May 07, 2001 9:11 PM
|| > || >|| To: Multiple recipients of list ORACLE-L
|| > || >|| Subject: Re: sorry,
|| > || >||
|| > || >||
|| > || >||
|| > || >|| ROFLMAO!
|| > || >||
|| > || >|| Geez Ross, do you really have a job?
|| > || >||
|| > || >|| Like, when do you *work*?
|| > || >||
|| > || >|| Or is this it?
|| > || >||
|| > || >|| Jared
|| > || >||
|| > || >||
|| > || >|| PS.  Bruce is more likely to kick you off
|| > than I am, and
|| > || >|| Jesus doesn't care.
|| > || >--
|| > || >Please see the official ORACLE-L FAQ:
|| > http://www.orafaq.com
|| > || >--
|| > || >Author: Mohan, Ross
|| > || >   INET: [EMAIL PROTECTED]
|| > || >
|| > || >Fat City Network Services-- (858) 538-5051 
|| > FAX: (858) 538-5051
|| > || >San Diego, California-- Public Internet
|| > access / 
|| > || Mailing Lists
|| > ||
|| >
|| >
|| > || >To REMOVE yourself from this mailing list, send
|| > an E-Mail message
|| > || >to: [EMAIL PROTECTED] (note EXACT spelling of
|| > 'ListGuru') and in
|| > || >the message BODY, include a line containing:
|| > UNSUB ORACLE-L
|| > || >(or the name of mailing list you want to be
|| > removed from).  You may
|| > || >also send the HELP command for other information
|| > (like subscribing).
|| > || 
|| > ||
|| >
|| _
|| > || Get your FREE download of MSN Explorer at
|| > http://explorer.msn.com
|| > || 
|| > || -- 
|| > || Please see the official ORACLE-L FAQ:
|| > http://www.orafaq.com
|| > || -- 
|| > || Author: Rachel Carmichael
|| > ||   INET: [EMAIL PROTECTED]
|| > || 
|| > || Fat City Network Services-- (858) 538-5051 
|| > FAX: (858) 538-5051
|| > || San Diego, California-- Public Internet
|| > access / 
|| > || Mailing Lists
|| > ||
|| >
|| 
|| > || To REMOVE yourself from this mailing list, send
|| > an E-Mail message
|| > || to: [EMAIL PROTECTED] (note EXACT spelling of
|| > 'ListGuru') and in
|| > || the message BODY, include a line containing:
|| > UNSUB ORACLE-L
|| > || (or the name of mailing list you want to be
|| > removed from).  You may
|| > || also send the HELP command for other information
|| > (like subscribing).
|| > || 
|| > -- 
|| > Please see the official ORACLE-L FAQ:
|| > http://www.orafaq.com
|| > -- 
|| > Author: Mohan, Ross
|| >   INET: [EMAIL PROTECTED]
|| > 
|| > Fat City Network Services-- (858) 538-5051  FAX:
|| > (858) 538-5051
|| > San Diego, California-- Pub

Re: looking for export with dynamic compress script on VMS

2001-05-08 Thread Ruth Gramolini

Go to the LazyDBA website and look for scripts by Rachael Carmichal which do
compressed exports and uncompress imports. The use pipes to accomplish this.

HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, May 08, 2001 3:55 PM


> Hi VMS & DBA gurus,
>
> As part of migration process from Oracle v7 to v8i, we are trying to do
the
> complete export of our database. Due to the lack of disk space, we can not
> land such a big export file.
>
> Our v7 database is on VMS platform and I am looking for the VMS script,
> which does dynamic compression (like the way pipes work on Unix systems)
> while export is running.
>
> If any one has such script and would like share it, please post it on the
> list.
>
> I really appreciate for your help.
>
> Thanks in advance,
>
> Best Regards,
> Prasad
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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



RE: looking for export with dynamic compress script on VMS

2001-05-08 Thread Jesse, Rich

Prasad,

If you are on v7+ of OpenVMS (or is it v7.1+?), you can use the DCL PIPE
command to emulate Unix-style pipes.  Although I haven't tried it, it may
produce something similar.  For example, instead of the traditional DCL:

$ DEFINE/USER SYS$OUTPUT T.T
$ SHOW SYSTEM
$ SEARCH T.T ORA

...which is similar to the unix "ps -ef|grep ORA" command, you can shorten
it up to:

$ PIPE SHOW SYSTEM | SEARCH SYS$PIPE ORA

You may also want to investigate GNUZip for OpenVMS.
http://www.openvms.digital.com/freeware/FREEWARE50/000TOOLS/ should contain
a directory called "ALPHA_IMAGES" (8i will not run on VAXen, just Alphas)
which will contain a GZIP.EXE file for ya.  Yes, I'm aware that the link
will forward you to Compaq's site.  Just in case Ken Olsen is watching from
Somewhere Above...  :)

HTH!

Rich Jesse  System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 14:56
> To: Multiple recipients of list ORACLE-L
> Subject: looking for export with dynamic compress script on VMS
> 
> 
> Hi VMS & DBA gurus,
> 
> As part of migration process from Oracle v7 to v8i, we are 
> trying to do the
> complete export of our database. Due to the lack of disk 
> space, we can not
> land such a big export file.
> 
> Our v7 database is on VMS platform and I am looking for the 
> VMS script,
> which does dynamic compression (like the way pipes work on 
> Unix systems)
> while export is running.
> 
> If any one has such script and would like share it, please 
> post it on the
> list.
> 
> I really appreciate for your help.
> 
> Thanks in advance,
> 
> Best Regards,
> Prasad
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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



RE: OT RE: sorry,

2001-05-08 Thread Scott . Shafer

Eric,

Are you thinking of a little UFO chasing at night?  They can shoot you for
going too near Groom Lake...

Scott Shafer
San Antonio, TX
210-581-6217

> -Original Message-
> From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 3:26 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: OT RE: sorry,
> 
> http://www.tonopahnevada.com/
> 
>"The boomtown of Tonopah was born in 1900,
>when Jim Butler accidentally discovered rich 
>silver ore while chasing a wayward burro. "
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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



Re: OT RE: sorry,

2001-05-08 Thread Eric D. Pierce

http://www.tonopahnevada.com/

   "The boomtown of Tonopah was born in 1900,
   when Jim Butler accidentally discovered rich 
   silver ore while chasing a wayward burro. "



On 8 May 2001, at 11:37, Rachel Carmichael wrote:

> ooh ooh, now, can we set up a REAL meeting like that?
> 
> 
> >From: "Mohan, Ross" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: OT RE: sorry,
> >Date: Tue, 08 May 2001 10:25:35 -0800
> >
> >Jared guessed it exactly at 5 minutes.
> >
> >It works like this...I see myself in a room with
> >all the relevant folks from the list. It is saturday.
> >all pagers are elsewhere. we have drinks in hand, be
> >they hard or soft, and we are talking.
> >
> >Then, I just type out the conversation.
> >
> >So, if you read it out loud, you have an idea of how long
> >it takes, mutatis mutandis for typing speed and error
> >correction, if any.

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

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

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



Enterprise Manger

2001-05-08 Thread Bambi Bellows

Greetings, Fellow OraHax!  Long time no see.  I've been off doing interesting things 
for awhile and have been pretty quiet.  I've got a problem and I'm pretty embarrassed 
by it.  Let me write embedded SQL/Korn shell or do funky DBA things all day but don't 
make me use a GUI!  But, well, we do what we have to.

Anyway, I have Enterprise Manager running on a remote NT box.  I have created a 
repository owner (entmgr) and made sure that the service is running.  If I try going 
into enterprise manager with just the SID, I get VTK-1000.  If I try to log in 
specifying the machine name (which I tried on a lark... it doesn't make sense to me to 
specify the machine name), I get "invalid login credential supplied". 

aTdHvAaNnKcSe!
Bambi.
-- 

___
Get your free email from http://www.mail.com

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

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

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



RE: OT RE: sorry,

2001-05-08 Thread Mohan, Ross

Yes but no work no pagers. 

Just liquids and humans. 

|| -Original Message-
|| From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 08, 2001 3:38 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: OT RE: sorry,
|| 
|| 
|| ooh ooh, now, can we set up a REAL meeting like that?
|| 
|| 
|| >From: "Mohan, Ross" <[EMAIL PROTECTED]>
|| >Reply-To: [EMAIL PROTECTED]
|| >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
|| >Subject: OT RE: sorry,
|| >Date: Tue, 08 May 2001 10:25:35 -0800
|| >
|| >Jared guessed it exactly at 5 minutes.
|| >
|| >It works like this...I see myself in a room with
|| >all the relevant folks from the list. It is saturday.
|| >all pagers are elsewhere. we have drinks in hand, be
|| >they hard or soft, and we are talking.
|| >
|| >Then, I just type out the conversation.
|| >
|| >So, if you read it out loud, you have an idea of how long
|| >it takes, mutatis mutandis for typing speed and error
|| >correction, if any.
|| >
|| >|| -Original Message-
|| >|| From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
|| >|| Sent: Tuesday, May 08, 2001 1:39 PM
|| >|| To: Multiple recipients of list ORACLE-L
|| >|| Subject: RE: sorry,
|| >||
|| >||
|| >|| knowing you, you just tossed it off in under 15 minutes :)
|| >||
|| >||
|| >|| >From: "Mohan, Ross" <[EMAIL PROTECTED]>
|| >|| >Reply-To: [EMAIL PROTECTED]
|| >|| >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
|| >|| >Subject: RE: sorry,
|| >|| >Date: Tue, 08 May 2001 08:15:29 -0800
|| >|| >
|| >|| >Jared,
|| >|| >
|| >|| >:) Thanks
|| >|| >
|| >|| >But, how long do you think it took to write this?
|| >|| >
|| >|| >Seriously...
|| >|| >
|| >|| >Ross
|| >|| >
|| >|| >
|| >|| >
|| >|| >|| -Original Message-
|| >|| >|| From: Jared Still [mailto:[EMAIL PROTECTED]]
|| >|| >|| Sent: Monday, May 07, 2001 9:11 PM
|| >|| >|| To: Multiple recipients of list ORACLE-L
|| >|| >|| Subject: Re: sorry,
|| >|| >||
|| >|| >||
|| >|| >||
|| >|| >|| ROFLMAO!
|| >|| >||
|| >|| >|| Geez Ross, do you really have a job?
|| >|| >||
|| >|| >|| Like, when do you *work*?
|| >|| >||
|| >|| >|| Or is this it?
|| >|| >||
|| >|| >|| Jared
|| >|| >||
|| >|| >||
|| >|| >|| PS.  Bruce is more likely to kick you off than I am, and
|| >|| >|| Jesus doesn't care.
|| >|| >--
|| >|| >Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| >|| >--
|| >|| >Author: Mohan, Ross
|| >|| >   INET: [EMAIL PROTECTED]
|| >|| >
|| >|| >Fat City Network Services-- (858) 538-5051  FAX: 
|| (858) 538-5051
|| >|| >San Diego, California-- Public Internet access /
|| >|| Mailing Lists
|| >|| 
|| >
|| >|| >To REMOVE yourself from this mailing list, send an 
|| E-Mail message
|| >|| >to: [EMAIL PROTECTED] (note EXACT spelling of 
|| 'ListGuru') and in
|| >|| >the message BODY, include a line containing: UNSUB ORACLE-L
|| >|| >(or the name of mailing list you want to be removed 
|| from).  You may
|| >|| >also send the HELP command for other information (like 
|| subscribing).
|| >||
|| >|| _
|| >|| Get your FREE download of MSN Explorer at http://explorer.msn.com
|| >||
|| >|| --
|| >|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| >|| --
|| >|| Author: Rachel Carmichael
|| >||   INET: [EMAIL PROTECTED]
|| >||
|| >|| Fat City Network Services-- (858) 538-5051  FAX: 
|| (858) 538-5051
|| >|| San Diego, California-- Public Internet access /
|| >|| Mailing Lists
|| >|| 
|| 
|| >|| To REMOVE yourself from this mailing list, send an E-Mail message
|| >|| to: [EMAIL PROTECTED] (note EXACT spelling of 
|| 'ListGuru') and in
|| >|| the message BODY, include a line containing: UNSUB ORACLE-L
|| >|| (or the name of mailing list you want to be removed 
|| from).  You may
|| >|| also send the HELP command for other information (like 
|| subscribing).
|| >||
|| >--
|| >Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| >--
|| >Author: Mohan, Ross
|| >   INET: [EMAIL PROTECTED]
|| >
|| >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| >San Diego, California-- Public Internet access / 
|| Mailing Lists
|| >
|| >To REMOVE yourself from this mailing list, send an E-Mail message
|| >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| >the message BODY, include a line containing: UNSUB ORACLE-L
|| >(or the name of mailing list you want to be removed from).  You may
|| >also send the HELP command for other information (like subscribing).
|| 
|| _
|| Get your FREE download of MSN Explorer at http://explorer.msn.com
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Rachel Carm

RE: sorry,

2001-05-08 Thread Kevin Kostyszyn

Ohh, so close, didn't even realize the pi thingy, must be some sort of
unconcious thing going on here!

-Original Message-
Sent: Tuesday, May 08, 2001 2:48 PM
To: Multiple recipients of list ORACLE-L


Pi?

You are too kind by approximately one minute and 46 seconds.

|| -Original Message-
|| From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 08, 2001 1:39 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: sorry,
||
||
|| the way Ross's mind functions probably about 3 minutes and
|| 14 seconds.
||
|| -Original Message-
|| Sent: Tuesday, May 08, 2001 12:15 PM
|| To: Multiple recipients of list ORACLE-L
||
||
|| Jared,
||
|| :) Thanks
||
|| But, how long do you think it took to write this?
||
|| Seriously...
||
|| Ross
||
||
||
|| || -Original Message-
|| || From: Jared Still [mailto:[EMAIL PROTECTED]]
|| || Sent: Monday, May 07, 2001 9:11 PM
|| || To: Multiple recipients of list ORACLE-L
|| || Subject: Re: sorry,
|| ||
|| ||
|| ||
|| || ROFLMAO!
|| ||
|| || Geez Ross, do you really have a job?
|| ||
|| || Like, when do you *work*?
|| ||
|| || Or is this it?
|| ||
|| || Jared
|| ||
|| ||
|| || PS.  Bruce is more likely to kick you off than I am, and
|| || Jesus doesn't care.
|| --
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| --
|| Author: Mohan, Ross
||   INET: [EMAIL PROTECTED]
||
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access /
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from).  You may
|| also send the HELP command for other information (like subscribing).
|| --
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| --
|| Author: Kevin Kostyszyn
||   INET: [EMAIL PROTECTED]
||
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access /
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from).  You may
|| also send the HELP command for other information (like subscribing).
||
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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

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

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

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



(Fwd) Re: oracle 817 won't start...

2001-05-08 Thread Eric D. Pierce


--- Forwarded message follows ---

(also see 136214.1 ?
  "startup and shutdown related registry entry's 
   for 8i on windows NT - 2000"
)


 Microsoft Servers and Utilities Technical Forum 


 Displayed below are the messages of the selected thread. 

 Thread Status: Closed 


...

 RDBMS Version: 8.1.7
 Operating System and Version: Windows 2000 Advanced Server
 Error Number (if applicable): ORA-27101

...
 From: x x 19-Jan-01 14:45 
 Subject: Re : Database Startup via Windows 2000 Advanced Server 
Services 

 One additional bit of information is that I can open up a DOS prompt 
set my ORACLE_SID use and use svrmgrl. I first have
 to do a shutdown abort, but can then do a startup and the database 
works fine. No problems connecting or anything.
 However, if I reboot after that, I return to the same issue. Even 
after restarting the database manually, I cannot go into the
 services and restart the database. I get the following message from 
Microsoft Management Console: Could not start the
 OracleServiceSTOEMADM service on Local Computer. Ther service did 
not return an error. This could be an internal
 Windows error or an internal service error. If the problem persists, 
contact your system administrator. (STOEMADM is my
 instance name). This definately points to a registry/services 
problem. I still cannot find anything wrong in the registry or the
 service. Any ideas? 

...

 From: Oracle, Gina Thunder 23-Jan-01 21:33 
 Subject: Re : Database Startup via Windows 2000 Advanced Server 
Services 

 Verify that ORACLE_SID is set and points to a valid 8.1.7 database 
which is up and running. Previously when the
 ORACLE_HOME or ORACLE_SID was set incorrectly, in the 'oracle' or 
client user's environment, only ora-1034 was
 reported. ORA-01034 "ORACLE not available" With 8.1.7, the ora-27101 
is reporting that the shared memory key
 generated by the client doesn't match any currently existing keys. 
This is to be expected if the ORACLE_HOME used by the
 client isn't the same as the one used to startup the database with 
OR the ORACLE_SID is not correctly referencing the right
 instance. 

 If your ORACLE_SID is correctly set, confirm that ORA_SID_AUTOSTART 
of registry is set to TRUE. There was an
 internal bug (1283305/1317791)logged on the autostart not working 
properly, however, the bug was to be fixed in 8.1.7. Let
 me know if you are still having problems after checking the above 
parameters. 

 Gina 
 Oracle Support Services 

...


 From: x x 25-Jan-01 20:33 
 Subject: Re : Database Startup via Windows 2000 Advanced Server 
Services 

 I found a TNS error that was occuring during service startup. If you 
comment out the
 SQLNET.AUTHENTICATION_SERVICES= (NTS) in your 
$ORACLE_HOME/network/admin/sqlnet.ora file, the problem
 goes away 


 From: Oracle, Gina Thunder 30-Jan-01 16:34 
 Subject: Re : Database Startup via Windows 2000 Advanced Server 
Services 

 Thank you for both of your updates to this post. New problems can be 
posted by creating a new thread. 

...

 From: Oracle, Gina Thunder 26-Feb-01 14:48 
 Subject: Re : Re : Database Startup via Windows 2000 Advanced Server 
Services 

 This issue is docuemented in bug 
1522966. The workaround is to comment out the
 SQLNET.AUTHENTICATION_SERVICES= (NTS) in your 
%ORACLE_HOME%/network/admin/sqlnet.ora as has been
 stated. This bug has a fix in patchset: : 8.1.7.0.1. 

...


 From: Oracle, Gina Thunder 02-May-01 22:21 
 Subject: Re : Re : Database Startup via Windows 2000 Advanced Server 
Services 

 The latest 8.1.7 patch is 8.1.7.1.2. This patch needs to be applied 
to 8.1.7.1.1 (this patch contains the fix). Both of these
 patches can be found on MetaLink by using the "NEW! click here for 
all product patches" link. The base bug is documented
 within the readme as: 1336566. Thank you for this post. 

...


   Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. 
Legal Notices and Terms of Use.

Content-description: Text from file 'oracle-NT-shut-start-registry.txt'



Doc ID:  Note:136214.1
 registry entry's for 8i onCreation Date:   26-FEB-2001
 windows NT - 2000 Last Revision
Type:BULLETIN  Date:03-APR-2001
Status:  REVIEWED

PURPOSE
---
To give an overview of the startup and shutdown related registry entry's
for 8i on windows NT / 2000.

An overview of the startup and shutdown related entry's
---

note: there are 3 bugs with this functionality:

  bug:1568668 shows that the shutdown options
  are not working on 8.1.7.0.0,
  8.1.5 and 8.1.6 are NOT affected by this bug.
  A fix is foreseen in 8.1.7.1.

  bug:724051 is that an NT shutdown does not perform a clean
  database shutdown due to a change in behavior from WINNT SP4
  and higher versions.
  Stopping the service itself is working fine, the fix is
  placing an ORAIMR8.dll in the Oracle

Urgent Date Problem

2001-05-08 Thread Navtej B

Hi Everybody

I need advise for one of mine problem. I am  trying to
access database from ODBC test in Windows to Server on
UNIX and when doing 

select sysdate from dual;

then are getting  let say 12:00pm

and when trying to run the same query on the server by
telnet to server, it is working fine and giving
current time of 11:00am. The problem is been seen from
the Daylight Saving time Change. 

Due to this problem, mine application is also rporting
the time difference of 1 hour in mine one of the Date
column which is populated by trigger containg same
Sysdate value assigne to the vaiable and then using
that variable to insert into the tables. The problem
is reported only after the Daylight saving Change

Thanks in Advance for everybody comments and help


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Navtej B
  INET: [EMAIL PROTECTED]

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

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



RE: Inserts slowing down on OLTP systems

2001-05-08 Thread John Kanagaraj

Hi Vikas,

In simple words, a block split happens when an INSERT needs to add an entry
into a leaf block and finds it full, requiring it to 'split' and balance
itself by migrating half the index entries into the new block (at's why it's
called a B Tree or 'Balanced' tree). More details in the oh-so-rarely-read
Server Concepts manual...

As far as specific events go, you may need to look at 'latch free' waits -
trace the p2 values from v$session_wait (usually 'cache buffer chains')
using the following sqls

select event, count(*) from v$session_wait 
group by event

select p2, count(*) from v$session_wait 
where event = 'latch free' 
group by p2

select * from v$latchname where latch# in ()

V$SYSTEM_EVENT will tell about the system as a whole while V$SESSION_WAIT
will tell you what that particular process is waiting for. Are many INSERTs
doen in parallel? There could also be an issue with FREELISTS (that's a
different ballgame altogether).

What you should probably do is to investigate your 'Index badness' using the
following:

ANALYZE INDEX &&index_name VALIDATE STRUCTURE;

col name heading 'Index Name'  format a30
col del_lf_rows  heading 'Deleted|Leaf Rows'   format 
col lf_rows_used heading 'Used|Leaf Rows'  format 
col ibadness heading '% Deleted|Leaf Rows' format 999.9

SELECT name,   del_lf_rows,   lf_rows - del_lf_rows
lf_rows_used,
   to_char(del_lf_rows / (lf_rows)*100,'999.9') ibadness
FROM index_stats   where name = upper('&&index_name');

undefine index_name

As a rule of thumb if 10-15% of the table data changes, then you should 
consider rebuilding the index.  

Hth,
John Kanagaraj
Oracle Applications DBA
Hitach Data Systems, Santa Clara
Work : (408) 970 7002

>-Original Message-
>From: Vikas Kawatra [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, May 08, 2001 10:52 AM
>To: Multiple recipients of list ORACLE-L
>Subject: RE: Inserts slowing down on OLTP systems
>
>
>What specific events should I look for in these tables ! - 
>atleast the imp
>ones - 
>And What's a block split ?
>
>vikas
>
>-Original Message-
>Sent: Tuesday, May 08, 2001 6:32 AM
>To: Multiple recipients of list ORACLE-L
>
>
>instead of checking hit ratios, try looking at wait events in 
>v$session_event, v$system_event and v$session_wait.
>
>also -- how many indexes are on these tables? How much data is in the 
>tables? If the indexes are doing constant block splits on the 
>insert you are
>
>basically rebuilding the index each time.. this can have a 
>major impact on 
>performance.
>
>Rachel
>
>
>>From: Vikas Kawatra <[EMAIL PROTECTED]>
>>Reply-To: [EMAIL PROTECTED]
>>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>>Subject: Inserts slowing down on OLTP systems
>>Date: Mon, 07 May 2001 16:55:28 -0800
>>
>>Anyone have ideas on why OLTP database inserts would slow 
>down by 100% from
>>levels 15 days ago ?
>>
>>We alreay checked hit ratios in shared pool , checked for any storage 
>>issues
>>etc
>>
>>thanks
>>
>>vikas
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: Vikas Kawatra
>>   INET: [EMAIL PROTECTED]
>>
>>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>>San Diego, California-- Public Internet access / Mailing Lists
>>
>>To REMOVE yourself from this mailing list, send an E-Mail message
>>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>>the message BODY, include a line containing: UNSUB ORACLE-L
>>(or the name of mailing list you want to be removed from).  You may
>>also send the HELP command for other information (like subscribing).
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Rachel Carmichael
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Vikas Kawatra
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT sp

RE: OT RE: sorry,

2001-05-08 Thread Mohan, Ross

LOL

Hi, Anita!  And "yes", you don't want
to knowbut let's get into a room
and talk about it over drinks.

Take care.

- Ross



(Warning: The above remarks contains nothing bad, 
evil, salacious, mean, malacious, sexual, misogynistic 
or politically incorrect. It is simply an offer to 
meet a good friend for drinks. If you find a problem, 
provide yer own apology.) 

|| -Original Message-
|| From: A. Bardeen [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 08, 2001 2:48 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: OT RE: sorry,
|| 
|| 
|| Of course, knowing you, I have to wonder what
|| conversations you didn't share with us... then again,
|| maybe I don't wanna know after all ;)
|| 
|| --- "Mohan, Ross" <[EMAIL PROTECTED]> wrote:
|| > Jared guessed it exactly at 5 minutes. 
|| > 
|| > It works like this...I see myself in a room with
|| > all the relevant folks from the list. It is
|| > saturday. 
|| > all pagers are elsewhere. we have drinks in hand, be
|| > they hard or soft, and we are talking. 
|| > 
|| > Then, I just type out the conversation. 
|| > 
|| > So, if you read it out loud, you have an idea of how
|| > long
|| > it takes, mutatis mutandis for typing speed and
|| > error
|| > correction, if any. 
|| > 
|| > || -Original Message-
|| > || From: Rachel Carmichael
|| > [mailto:[EMAIL PROTECTED]]
|| > || Sent: Tuesday, May 08, 2001 1:39 PM
|| > || To: Multiple recipients of list ORACLE-L
|| > || Subject: RE: sorry,
|| > || 
|| > || 
|| > || knowing you, you just tossed it off in under 15
|| > minutes :)
|| > || 
|| > || 
|| > || >From: "Mohan, Ross" <[EMAIL PROTECTED]>
|| > || >Reply-To: [EMAIL PROTECTED]
|| > || >To: Multiple recipients of list ORACLE-L
|| > <[EMAIL PROTECTED]>
|| > || >Subject: RE: sorry,
|| > || >Date: Tue, 08 May 2001 08:15:29 -0800
|| > || >
|| > || >Jared,
|| > || >
|| > || >:) Thanks
|| > || >
|| > || >But, how long do you think it took to write
|| > this?
|| > || >
|| > || >Seriously...
|| > || >
|| > || >Ross
|| > || >
|| > || >
|| > || >
|| > || >|| -Original Message-
|| > || >|| From: Jared Still [mailto:[EMAIL PROTECTED]]
|| > || >|| Sent: Monday, May 07, 2001 9:11 PM
|| > || >|| To: Multiple recipients of list ORACLE-L
|| > || >|| Subject: Re: sorry,
|| > || >||
|| > || >||
|| > || >||
|| > || >|| ROFLMAO!
|| > || >||
|| > || >|| Geez Ross, do you really have a job?
|| > || >||
|| > || >|| Like, when do you *work*?
|| > || >||
|| > || >|| Or is this it?
|| > || >||
|| > || >|| Jared
|| > || >||
|| > || >||
|| > || >|| PS.  Bruce is more likely to kick you off
|| > than I am, and
|| > || >|| Jesus doesn't care.
|| > || >--
|| > || >Please see the official ORACLE-L FAQ:
|| > http://www.orafaq.com
|| > || >--
|| > || >Author: Mohan, Ross
|| > || >   INET: [EMAIL PROTECTED]
|| > || >
|| > || >Fat City Network Services-- (858) 538-5051 
|| > FAX: (858) 538-5051
|| > || >San Diego, California-- Public Internet
|| > access / 
|| > || Mailing Lists
|| > ||
|| >
|| >
|| > || >To REMOVE yourself from this mailing list, send
|| > an E-Mail message
|| > || >to: [EMAIL PROTECTED] (note EXACT spelling of
|| > 'ListGuru') and in
|| > || >the message BODY, include a line containing:
|| > UNSUB ORACLE-L
|| > || >(or the name of mailing list you want to be
|| > removed from).  You may
|| > || >also send the HELP command for other information
|| > (like subscribing).
|| > || 
|| > ||
|| >
|| _
|| > || Get your FREE download of MSN Explorer at
|| > http://explorer.msn.com
|| > || 
|| > || -- 
|| > || Please see the official ORACLE-L FAQ:
|| > http://www.orafaq.com
|| > || -- 
|| > || Author: Rachel Carmichael
|| > ||   INET: [EMAIL PROTECTED]
|| > || 
|| > || Fat City Network Services-- (858) 538-5051 
|| > FAX: (858) 538-5051
|| > || San Diego, California-- Public Internet
|| > access / 
|| > || Mailing Lists
|| > ||
|| >
|| 
|| > || To REMOVE yourself from this mailing list, send
|| > an E-Mail message
|| > || to: [EMAIL PROTECTED] (note EXACT spelling of
|| > 'ListGuru') and in
|| > || the message BODY, include a line containing:
|| > UNSUB ORACLE-L
|| > || (or the name of mailing list you want to be
|| > removed from).  You may
|| > || also send the HELP command for other information
|| > (like subscribing).
|| > || 
|| > -- 
|| > Please see the official ORACLE-L FAQ:
|| > http://www.orafaq.com
|| > -- 
|| > Author: Mohan, Ross
|| >   INET: [EMAIL PROTECTED]
|| > 
|| > Fat City Network Services-- (858) 538-5051  FAX:
|| > (858) 538-5051
|| > San Diego, California-- Public Internet
|| > access / Mailing Lists
|| >
|| 
|| > To REMOVE yourself from this mailing list, send an
|| > E-Mail message
|| > to: [EMAIL PROTECTED] (note E

Re: OT RE: sorry,

2001-05-08 Thread Rachel Carmichael

ooh ooh, now, can we set up a REAL meeting like that?


>From: "Mohan, Ross" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: OT RE: sorry,
>Date: Tue, 08 May 2001 10:25:35 -0800
>
>Jared guessed it exactly at 5 minutes.
>
>It works like this...I see myself in a room with
>all the relevant folks from the list. It is saturday.
>all pagers are elsewhere. we have drinks in hand, be
>they hard or soft, and we are talking.
>
>Then, I just type out the conversation.
>
>So, if you read it out loud, you have an idea of how long
>it takes, mutatis mutandis for typing speed and error
>correction, if any.
>
>|| -Original Message-
>|| From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
>|| Sent: Tuesday, May 08, 2001 1:39 PM
>|| To: Multiple recipients of list ORACLE-L
>|| Subject: RE: sorry,
>||
>||
>|| knowing you, you just tossed it off in under 15 minutes :)
>||
>||
>|| >From: "Mohan, Ross" <[EMAIL PROTECTED]>
>|| >Reply-To: [EMAIL PROTECTED]
>|| >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>|| >Subject: RE: sorry,
>|| >Date: Tue, 08 May 2001 08:15:29 -0800
>|| >
>|| >Jared,
>|| >
>|| >:) Thanks
>|| >
>|| >But, how long do you think it took to write this?
>|| >
>|| >Seriously...
>|| >
>|| >Ross
>|| >
>|| >
>|| >
>|| >|| -Original Message-
>|| >|| From: Jared Still [mailto:[EMAIL PROTECTED]]
>|| >|| Sent: Monday, May 07, 2001 9:11 PM
>|| >|| To: Multiple recipients of list ORACLE-L
>|| >|| Subject: Re: sorry,
>|| >||
>|| >||
>|| >||
>|| >|| ROFLMAO!
>|| >||
>|| >|| Geez Ross, do you really have a job?
>|| >||
>|| >|| Like, when do you *work*?
>|| >||
>|| >|| Or is this it?
>|| >||
>|| >|| Jared
>|| >||
>|| >||
>|| >|| PS.  Bruce is more likely to kick you off than I am, and
>|| >|| Jesus doesn't care.
>|| >--
>|| >Please see the official ORACLE-L FAQ: http://www.orafaq.com
>|| >--
>|| >Author: Mohan, Ross
>|| >   INET: [EMAIL PROTECTED]
>|| >
>|| >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>|| >San Diego, California-- Public Internet access /
>|| Mailing Lists
>|| >
>|| >To REMOVE yourself from this mailing list, send an E-Mail message
>|| >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>|| >the message BODY, include a line containing: UNSUB ORACLE-L
>|| >(or the name of mailing list you want to be removed from).  You may
>|| >also send the HELP command for other information (like subscribing).
>||
>|| _
>|| Get your FREE download of MSN Explorer at http://explorer.msn.com
>||
>|| --
>|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
>|| --
>|| Author: Rachel Carmichael
>||   INET: [EMAIL PROTECTED]
>||
>|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>|| San Diego, California-- Public Internet access /
>|| Mailing Lists
>|| 
>|| To REMOVE yourself from this mailing list, send an E-Mail message
>|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>|| the message BODY, include a line containing: UNSUB ORACLE-L
>|| (or the name of mailing list you want to be removed from).  You may
>|| also send the HELP command for other information (like subscribing).
>||
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Mohan, Ross
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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



OT OT OT OT OT OT OT RE: sorry,

2001-05-08 Thread Mohan, Ross

well, this might interest you: 

your original post containing the "pi" had, 
as it's timestamp, approximately the error in 
your estimate. 

"1:39"  vice "1:46". 

Numerology anyone?

|| -Original Message-
|| From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 08, 2001 3:38 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: sorry,
|| 
|| 
|| Ohh, so close, didn't even realize the pi thingy, must be 
|| some sort of
|| unconcious thing going on here!
|| 
|| -Original Message-
|| Sent: Tuesday, May 08, 2001 2:48 PM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Pi?
|| 
|| You are too kind by approximately one minute and 46 seconds.
|| 
|| || -Original Message-
|| || From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
|| || Sent: Tuesday, May 08, 2001 1:39 PM
|| || To: Multiple recipients of list ORACLE-L
|| || Subject: RE: sorry,
|| ||
|| ||
|| || the way Ross's mind functions probably about 3 minutes and
|| || 14 seconds.
|| ||
|| || -Original Message-
|| || Sent: Tuesday, May 08, 2001 12:15 PM
|| || To: Multiple recipients of list ORACLE-L
|| ||
|| ||
|| || Jared,
|| ||
|| || :) Thanks
|| ||
|| || But, how long do you think it took to write this?
|| ||
|| || Seriously...
|| ||
|| || Ross
|| ||
|| ||
|| ||
|| || || -Original Message-
|| || || From: Jared Still [mailto:[EMAIL PROTECTED]]
|| || || Sent: Monday, May 07, 2001 9:11 PM
|| || || To: Multiple recipients of list ORACLE-L
|| || || Subject: Re: sorry,
|| || ||
|| || ||
|| || ||
|| || || ROFLMAO!
|| || ||
|| || || Geez Ross, do you really have a job?
|| || ||
|| || || Like, when do you *work*?
|| || ||
|| || || Or is this it?
|| || ||
|| || || Jared
|| || ||
|| || ||
|| || || PS.  Bruce is more likely to kick you off than I am, and
|| || || Jesus doesn't care.
|| || --
|| || Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| || --
|| || Author: Mohan, Ross
|| ||   INET: [EMAIL PROTECTED]
|| ||
|| || Fat City Network Services-- (858) 538-5051  FAX: 
|| (858) 538-5051
|| || San Diego, California-- Public Internet access /
|| || Mailing Lists
|| || 
|| 
|| || To REMOVE yourself from this mailing list, send an E-Mail message
|| || to: [EMAIL PROTECTED] (note EXACT spelling of 
|| 'ListGuru') and in
|| || the message BODY, include a line containing: UNSUB ORACLE-L
|| || (or the name of mailing list you want to be removed 
|| from).  You may
|| || also send the HELP command for other information (like 
|| subscribing).
|| || --
|| || Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| || --
|| || Author: Kevin Kostyszyn
|| ||   INET: [EMAIL PROTECTED]
|| ||
|| || Fat City Network Services-- (858) 538-5051  FAX: 
|| (858) 538-5051
|| || San Diego, California-- Public Internet access /
|| || Mailing Lists
|| || 
|| 
|| || To REMOVE yourself from this mailing list, send an E-Mail message
|| || to: [EMAIL PROTECTED] (note EXACT spelling of 
|| 'ListGuru') and in
|| || the message BODY, include a line containing: UNSUB ORACLE-L
|| || (or the name of mailing list you want to be removed 
|| from).  You may
|| || also send the HELP command for other information (like 
|| subscribing).
|| ||
|| --
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| --
|| Author: Mohan, Ross
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from).  You may
|| also send the HELP command for other information (like subscribing).
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Kevin Kostyszyn
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from).  You may
|| also send the HELP command for other information (like subscribing).
|| 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

RE: Rename Database on NT

2001-05-08 Thread Kevin Kostyszyn

If you make a copy of it and rebuild the controlfiles you can call it
something else.  Or, if you just want to change the name in a way, why don't
you give it a different alias?

-Original Message-
L.
Sent: Tuesday, May 08, 2001 3:16 PM
To: Multiple recipients of list ORACLE-L


This has probably been answered a million times but...
Is there any way to rename an Oracle database and all its services on NT?

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

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

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

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

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

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



RE: Oracle tuning book

2001-05-08 Thread Gogala, Mladen

I read the book from Sean Hull and Andy Duncan, and it is a really good
book.
The only thing that was expecting in that one was a brief description of
mod_plsql
and a few examples. Other then that, it mentions practically every open
source tool
worth mentioning. I love the description of Matt's OraSoft tools. This book
is an 
excellent resource for anyone in need of good oracle tools on Linux, unix
and even
(@#$!) NT (Activestate part). I can only wholeheartedly recommend that book
to anyone
willing to consider the open source oracle tools. I would also like to abuse
this message 
by asking Andy Duncan when can we expect Orac_DBA version 1.2.1 (or > 1.2?)

-Original Message-
Sent: Tuesday, May 08, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L


OK Rachel, based on your recommendation alone I am going after management
to get that book so my other half has an idea what I am talking about when I

ask him to do something.  I just love training new DBA's.

-Original Message-
Sent: Tuesday, May 08, 2001 6:26 AM
To: Multiple recipients of list ORACLE-L


one that will be out in a few weeks... Oracle Performance Tuning 101 by Gaja

Krishna Vaidyanatha, a member of this list. (Oracle Press)

No, I do not get anything for promoting this book -- except perhaps a hug 
from Gaja the next time I see him (but I'd get that anyway)

I was privileged to do the developmental edit on the book -- major good 
stuff in a READABLE manner, especially for a beginner. I learned a lot.

Should be out by the end of May, I believe you can pre-order it already.

Rachel


>From: "Seema Singh" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle tuning book
>Date: Mon, 07 May 2001 14:11:39 -0800
>
>Hi
>Which book is good for oracle tuning(8i)?
>Thanks
>-Seema
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Seema Singh
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

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

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

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

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



RE: sorry,

2001-05-08 Thread Thater, William

On Tue, 8 May 2001,[EMAIL PROTECTED] scribbled on the wall in...:

->I was thinking Spetznaz, but I guess the 82nd will do...  ;-)

Spetznaz are much more humane.;-)
--
Bill Thater Certifieable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
fortune: No such file or directory

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

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

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



RE: standby database in managed recovery mode

2001-05-08 Thread Srinagesh Battula

What is your standby_archive_dest set to? can u show us the params from the
init.ora

> -Original Message-
> From: Richard Huntley [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 03, 2001 10:21 AM
> To: Multiple recipients of list ORACLE-L
> Subject: FW: standby database in managed recovery mode
> 
> 
> > Suggestions anyone??  I'm attempting to get a standby 
> database to run in
> > managed recovery mode, so that the archived logs 
> > are automatically applied, however, when running the 
> command 'recover
> > managed standby database' I receive the following error message:
> > SVRMGR> recover managed standby database;
> > ORA-00308: cannot open archived log
> > '/u03/apps/oracle/admin/db/arch/1_194.arc'
> > ORA-27037: unable to obtain file status
> > SVR4 Error: 2: No such file or directory
> > Additional information: 3
> > 
> > This is after I've brought the primary and standby up to 
> the same max
> > recid number in the v$log_history.  I have attempted to rebuild the
> > standby database and also to execute the command 'recover 
> standby database
> > until cancel' after confirming that all archived log files 
> were in the
> > proper location, however I'm always prompted for the next 
> archive log
> > which doesn't exist yet and I can't get into "managed" 
> recovery mode.
> > I've also went to the primary database, forced a log switch and then
> > applied the newest archived log file, but that hasn't 
> worked either.  
> > 
> > 
> > Richard Huntley
> > Software Developer
> > Phone: (800) 223-3732  (614) 880-1817
> > E-mail: [EMAIL PROTECTED]
> > MindLeaders (www.mindleaders.com)
> > 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Richard Huntley
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Srinagesh Battula
  INET: [EMAIL PROTECTED]

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

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



Rename Database on NT

2001-05-08 Thread Smith, Ron L.

This has probably been answered a million times but...
Is there any way to rename an Oracle database and all its services on NT?
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

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

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



RE: sorry,

2001-05-08 Thread Scott . Shafer

I was thinking Spetznaz, but I guess the 82nd will do...  ;-)

Scott Shafer
San Antonio, TX
210-581-6217

> -Original Message-
> From: Thater, William [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 12:46 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: sorry,
> 
> On Tue, 8 May 2001,[EMAIL PROTECTED] scribbled on the wall
> in...:
> 
> ->Why does it have to be an either/or choice?  Lets do 'em all!!!   ;-)
> 
> A la the 82nd Airborne?;-)
> --
> Bill Thater Certifieable ORACLE DBA
> Telergy, Inc.[EMAIL PROTECTED]
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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



looking for export with dynamic compress script on VMS

2001-05-08 Thread Prasada . Gunda1

Hi VMS & DBA gurus,

As part of migration process from Oracle v7 to v8i, we are trying to do the
complete export of our database. Due to the lack of disk space, we can not
land such a big export file.

Our v7 database is on VMS platform and I am looking for the VMS script,
which does dynamic compression (like the way pipes work on Unix systems)
while export is running.

If any one has such script and would like share it, please post it on the
list.

I really appreciate for your help.

Thanks in advance,

Best Regards,
Prasad


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

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

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



RE: Oracle tuning book

2001-05-08 Thread Kevin Kostyszyn

Just a quick one, what do you have to be to be and Oracle God?

-Original Message-
Carmichael
Sent: Tuesday, May 08, 2001 3:27 PM
To: Multiple recipients of list ORACLE-L


Nah, he'd mess with your last name, not first :)

Okay folks, to clue those who weren't there in, at IOUG, at a presentation
by Mogens Norgaard (an Oracle God as far as I am concerned), he played games
with the spelling of Gaja's last name as well as Craig Shallahamer's... in
fun, but boy did Gaja jump :)

Rachel


>From: "Deshpande, Kirti" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Oracle tuning book
>Date: Tue, 08 May 2001 09:32:54 -0800
>
>Yes it is..
>That's my official full first name..
>Hope Mogens doesn't get any ideas  ;)
>
>- Kirti
>
> > -Original Message-
> > From:   Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]]
> > Sent:   Tuesday, May 08, 2001 10:46 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: Oracle tuning book
> >
> > Kirti,
> >
> > Is that your name on the book with Gaja?
> >
> > Raj
> > __
> > Rajendra Jamadagni  MIS, ESPN Inc.
> > Rajendra dot Jamadagni at ESPN dot com
> > Any opinion expressed here is personal and doesn't reflect that of ESPN
> > Inc.
> >
> > QOTD: Any clod can have facts, but having an opinion is an art !
> >
> > *
> >
> > This e-mail message is confidential, intended only for the named
> > recipient(s) above and may contain information that is privileged,
> > attorney work product or exempt from disclosure under applicable law. If
> > you have received this message in error, or are not the named
> > recipient(s), please immediately notify ESPN at (860) 766-2000 and
>delete
> > this e-mail message from your computer, Thank you.
> >
> > *
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jamadagni, Rajendra
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Deshpande, Kirti
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

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

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

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



RE: Looking for opions on I/Watch from Quest

2001-05-08 Thread Kevin Kostyszyn

I would also be interested in this.  I have used Quest's Spotlight on Oracle
and actually found it quite useful.
Kev

-Original Message-
Smith
Sent: Tuesday, May 08, 2001 3:44 PM
To: Multiple recipients of list ORACLE-L


I am looking for opions on their tool.  I am installing and setting it up
right now.  Is anyone out there using it and do you like it?  Can you
compare it to OEM (which I actually hate).


Kimberly Smith
Database Administrator
EDS - Fujitsu/GMD
Phone: (503) 669-6050
Fax: (503) 669-5705
Email : [EMAIL PROTECTED]

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

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

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

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

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

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



RE: Oracle books

2001-05-08 Thread Ed . Haskins

It kinda depends on your environment, but I like:

Oracle8i DBA Handbook
Oracle Press

Oracle8i Backup and Recovery
Oracle Press

Oracle 24x7 Tips and Techniques
Oracle Press

Oracle Networking 101
Oracle Press

Oracle Documentation
http://otn.oracle.com

This covers much of the core Oracle DBA stuff.  For some advanced topics:

Oracle Internal Services: Waits, Latches...
Steve Adams
O'Reilly

Unix for Oracle
Don Burleson
O'Reilly

(Can't remember exact name) Oracle Performance Tuning
Guy Harrison
(Publisher?)

Haven't read book yet, but looks good:
Oracle STATS Pack
Don Burleson
Oracle Press

Hope that helps

Ed Haskins
Oracle DBA
Verizon Wireless

-Original Message-
Sent: Tuesday, May 08, 2001 2:32 PM
To: Multiple recipients of list ORACLE-L


Being a relatively new and often times struggling Oracle DBA I was wondering
what 3 or 4 books everyone recommends as a must have reference/knowledge
base in day to day support/programming of their databases.

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

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

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

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

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



RE: Hey, looks like MS got .NET to work!!

2001-05-08 Thread Eric D. Pierce

nope.

There is a "Greg Johnson" @

http://www.cclabs.missouri.edu/people/staff.shtml

but, can't get to his home page either.

(however: http://iatservices.missouri.edu/communicator/security.html 
,
http://www.cclabs.missouri.edu/things/instruction/perl/prelude/ 
,
http://iatservices.missouri.edu/security/discussion/
)



On 8 May 2001, at 9:32, Mohan, Ross wrote:

> yep...locked downdo you have a copy?
...

> || An interesting article on "Information War" used to be up at
> || the following site, but it looks like they locked it down:
> || 
> ||http://www.cclabs.missouri.edu/~johnsong/infowar/


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

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

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



RE: Oracle tuning book

2001-05-08 Thread Rachel Carmichael

Nah, he'd mess with your last name, not first :)

Okay folks, to clue those who weren't there in, at IOUG, at a presentation 
by Mogens Norgaard (an Oracle God as far as I am concerned), he played games 
with the spelling of Gaja's last name as well as Craig Shallahamer's... in 
fun, but boy did Gaja jump :)

Rachel


>From: "Deshpande, Kirti" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Oracle tuning book
>Date: Tue, 08 May 2001 09:32:54 -0800
>
>Yes it is..
>That's my official full first name..
>Hope Mogens doesn't get any ideas  ;)
>
>- Kirti
>
> > -Original Message-
> > From:   Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]]
> > Sent:   Tuesday, May 08, 2001 10:46 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: Oracle tuning book
> >
> > Kirti,
> >
> > Is that your name on the book with Gaja?
> >
> > Raj
> > __
> > Rajendra Jamadagni  MIS, ESPN Inc.
> > Rajendra dot Jamadagni at ESPN dot com
> > Any opinion expressed here is personal and doesn't reflect that of ESPN
> > Inc.
> >
> > QOTD: Any clod can have facts, but having an opinion is an art !
> >
> > *
> >
> > This e-mail message is confidential, intended only for the named
> > recipient(s) above and may contain information that is privileged,
> > attorney work product or exempt from disclosure under applicable law. If
> > you have received this message in error, or are not the named
> > recipient(s), please immediately notify ESPN at (860) 766-2000 and 
>delete
> > this e-mail message from your computer, Thank you.
> >
> > *
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jamadagni, Rajendra
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Deshpande, Kirti
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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



Re: restrict login with known IP address

2001-05-08 Thread plomax

Joe,
I know that using OCM - Net8 Connection Manager has the features you
require.
I have not yet needed to do implement it although it was considered.
Features are
- control client access to target servers
- setup filters to permit/restrict access to a server based on
i server hostid (or IP address)
ii target hostid ("   )
ii destination db name
HTH
Peter

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, May 08, 2001 6:25 PM


> In UNIX,
> Knowing the IP address can I restrict any login
> to the ORACLE db given this info?
>
> any help is appreciated ...
>
> Joe
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Leyden, Joseph
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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



RE: Inserts slowing down on OLTP systems

2001-05-08 Thread Rachel Carmichael

well, try looking for the ones with high total_waits (v$session_event and 
v$system_event) and then drill down from there into v$session_wait to see 
what the wait is on


>From: Vikas Kawatra <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Inserts slowing down on OLTP systems
>Date: Tue, 08 May 2001 09:52:15 -0800
>
>What specific events should I look for in these tables ! - atleast the imp
>ones -
>And What's a block split ?
>
>vikas
>
>-Original Message-
>Sent: Tuesday, May 08, 2001 6:32 AM
>To: Multiple recipients of list ORACLE-L
>
>
>instead of checking hit ratios, try looking at wait events in
>v$session_event, v$system_event and v$session_wait.
>
>also -- how many indexes are on these tables? How much data is in the
>tables? If the indexes are doing constant block splits on the insert you 
>are
>
>basically rebuilding the index each time.. this can have a major impact on
>performance.
>
>Rachel
>
>
> >From: Vikas Kawatra <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Inserts slowing down on OLTP systems
> >Date: Mon, 07 May 2001 16:55:28 -0800
> >
> >Anyone have ideas on why OLTP database inserts would slow down by 100% 
>from
> >levels 15 days ago ?
> >
> >We alreay checked hit ratios in shared pool , checked for any storage
> >issues
> >etc
> >
> >thanks
> >
> >vikas
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Vikas Kawatra
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Vikas Kawatra
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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



RE: oracle 817 won't start...

2001-05-08 Thread Kevin Kostyszyn

I have had this error in the past and it was an error in the init.ora file.
Check and make sure that someone didn't make changes to it and forgot to
comment out some code.

-Original Message-
Sent: Tuesday, May 08, 2001 3:16 PM
To: Multiple recipients of list ORACLE-L


Hi All,
I'm experimenting with oracle 817 on a w2k box. It was
running fine, but this morning it refused to start.
When I tried to log onto the oracle server, I got the
following error message:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

I searched the web for a solution and tried a few
things including using ORADIM to auto start the oracle
server, but nothing seemed to work. As far as I know,
there's no system change since I started it last time
and all oracle related services appeared to be
running.

Any idea what the problem could be?

Thanks a lot.

WL


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: lwm
  INET: [EMAIL PROTECTED]

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

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

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

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

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



Re: Oracle books

2001-05-08 Thread Thater, William

On Tue, 8 May 2001,Keith Myers scribbled on the wall in glitter crayon:

->Being a relatively new and often times struggling Oracle DBA I was wondering
->what 3 or 4 books everyone recommends as a must have reference/knowledge
->base in day to day support/programming of their databases.
->
->
One I recommend and use is Oracle DBA 101.  My advice, get it, read it, highlight it, 
and scribble notes in the margins.  Mine sits next to me as I work.  I just wish it 
had wider margins for note scribbling.;-)

Another is Oracle Backup and Recovery, same advice.

And for a third... ORACLE SQL & PL/SQL Annotated Archives.

YMMV, yadda yadda yadda.

--
Bill Thater Certifieable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
fortune: No such file or directory

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

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

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



RE: Off Topic - Blah, Blah, Blah...

2001-05-08 Thread Kevin Kostyszyn

I agree, humor = happy DBA

-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, May 08, 2001 2:37 PM
To: Multiple recipients of list ORACLE-L


Yeah, but its good for "color" and the occasional comic relief.  After all,
dba'ing is pretty high pressure at times...

Scott Shafer
San Antonio, TX
210-581-6217

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 1:06 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  OT: Off Topic - Blah, Blah, Blah...
>
> As I type, I'm guilty of committing what I'm about to rant about...
>
> It's not much of a "rant", but...
>
> I, like many on this list (ORACLE-L), subscribe and participate in both
> this
> and the Lazy-DBA list.  Is it just me, or does this list (ORACLE-L) have
> way
> more Off Topic posts??  I don't mean Off Topic as in: "UNIX vs. NT" or
> "Should I learn Java or C# to enhance my skills?", but rather...well, I
> think you know what I mean.  I'm not necessarily complaining, just making
> an
> observation!!
>
> Ed Haskins
> Oracle DBA
> Verizon Wireless
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

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

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

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

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

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



Looking for opions on I/Watch from Quest

2001-05-08 Thread Kimberly Smith

I am looking for opions on their tool.  I am installing and setting it up
right now.  Is anyone out there using it and do you like it?  Can you
compare it to OEM (which I actually hate).


Kimberly Smith
Database Administrator
EDS - Fujitsu/GMD
Phone: (503) 669-6050
Fax: (503) 669-5705
Email : [EMAIL PROTECTED]

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

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

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



Re: OT: Off Topic - Blah, Blah, Blah...

2001-05-08 Thread Rachel Carmichael

we might, but we also have a LOT of heavily technical posts as well... I 
enjoy the off-topic stuff (at times) when I'm not swamped. And when I am 
swamped, well, the delete key is a wonderful thing.

I basically hit "delete all" and then review the topics and posters and see 
what I really want to read :)


>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: OT: Off Topic - Blah, Blah, Blah...
>Date: Tue, 08 May 2001 10:06:12 -0800
>
>As I type, I'm guilty of committing what I'm about to rant about...
>
>It's not much of a "rant", but...
>
>I, like many on this list (ORACLE-L), subscribe and participate in both 
>this
>and the Lazy-DBA list.  Is it just me, or does this list (ORACLE-L) have 
>way
>more Off Topic posts??  I don't mean Off Topic as in: "UNIX vs. NT" or
>"Should I learn Java or C# to enhance my skills?", but rather...well, I
>think you know what I mean.  I'm not necessarily complaining, just making 
>an
>observation!!
>
>Ed Haskins
>Oracle DBA
>Verizon Wireless
>
>
>-Original Message-
>Sent: Tuesday, May 08, 2001 1:26 PM
>To: Multiple recipients of list ORACLE-L
>
>
>I have been informed privately that some may find this remark offensive,
>perhaps even deeply so.
>
>For those people:  "Sorry!, that wasn't my intent."
>
>|| -Original Message-
>|| From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
>|| Sent: Tuesday, May 08, 2001 12:23 PM
>|| To: Multiple recipients of list ORACLE-L
>|| Subject: OT RE: Taking your time when a crisis occurs
>||
>||
>|| Barbie doesn't talk when he takes her
>|| clothes off.
>||
>|| || -Original Message-
>|| || From: David A. Barbour [mailto:[EMAIL PROTECTED]]
>|| || Sent: Monday, May 07, 2001 10:35 PM
>|| || To: Multiple recipients of list ORACLE-L
>|| || Subject: Re: Taking your time when a crisis occurs
>|| ||
>|| ||
>|| || Eric,
>|| ||
>|| || What's with you and Barbie?
>|| ||
>|| || David A. Barbour
>|| ||
>|| || "Eric D. Pierce" wrote:
>|| || >
>|| || >  RE: Taking your time when a crisis occurs
>|| || >
>|| || > -
>|| || >
>|| || > http://www.amazon.com/exec/obidos/ASIN2/B4SU3E
>|| || >
>|| || > Barbie as Glinda from The Wizard of Oz
>|| || >
>|| || >
>|| || > Our Price: $19.99
>|| || > Availability: Usually ships within 24 hours.
>|| || >
>|| || > Manufacturer's age: 3 years and up
>|| || > Shipping: Currently, item can be shipped only within the U.S.
>|| || > Shipping weight: 0.7 pounds.
>|| || > Note: Giftwrapping not available for this item.
>|| || > Packaging: This item may be delivered in the
>|| || manufacturer's original
>|| || > packaging, which could reveal the contents of the box.
>|| || > ASIN: B4SU3E
>|| || >
>|| || >
>|| || >
>|| || > >From Toysrus.com & Amazon.com
>|| || > Editorial Review
>|| || >
>|| || > "Are you a good witch or a bad witch?" A good witch, of
>|| course--and
>|| || > pretty as well! Dressed as Glinda, the good witch of
>|| the North from
>|| || > the beloved book and movie The Wizard of Oz, Barbie is
>|| welcomed to
>|| || > Munchkinland. She has long, curly strawberry-blonde hair
>|| || topped by a
>|| || > tall lavender-pink crown, and she's wearing a sparkling
>|| pink satin
>|| || > ball gown ornamented with silver stars and butterflies.
>|| || She also has
>|| || > on a silver braided belt. Her outfit is completed with
>|| || pink heels and
>|| || > a long, lavender magic wand that fits in her hand. Raise
>|| || her arm (or
>|| || > press the button on her back), and you'll hear the
>|| wand's magical
>|| || > "brrinnng!" sound or Glinda's voice saying, "Tap your
>|| || heels together
>|| || > three times." Sound effects are produced by three
>|| included button
>|| || > cell batteries, which can be replaced. Say it again,
>|| || Glinda, just so
>|| || > we'll never forget: "There's no place like home."
>|| --Marcie Bovetz
>|| || > Safety Information
>|| || > Choking hazard: Small parts. Not for children under 3 years.
>|| || >
>|| || > -
>|| || >
>|| || > On 7 May 2001, at 10:21, Marianne Brooks wrote:
>|| || >
>|| || > > Hmm, shaved head, why didn't I think of that?  I would
>|| || imagine a woman with
>|| || > > a shaved head might be as effective...add a tatoo, some
>|| || leather pants and a
>|| || > > scowl and I've got a new me! :-)
>|| || >
>|| || > ...
>|| || >
>|| || > --
>|| || > Please see the official ORACLE-L FAQ: http://www.orafaq.com
>|| || > --
>|| || > Author: Eric D. Pierce
>|| || >   INET: [EMAIL PROTECTED]
>|| || >
>|| || > Fat City Network Services-- (858) 538-5051  FAX:
>|| (858) 538-5051
>|| || > San Diego, California-- Public Internet access /
>|| || Mailing Lists
>|| || >
>|| ||
>|| 
>|| || > To REMOVE yourself from this mailing list, send an
>|| E-Mail message
>|| || > to: [EMAIL PROTECTED] (note EXACT spelling of
>|| 'ListGuru') and in
>|| || > the message BODY, include a line containing: UNSUB ORACLE-L
>

OT RE: sorry,

2001-05-08 Thread Mohan, Ross

Jared guessed it exactly at 5 minutes. 

It works like this...I see myself in a room with
all the relevant folks from the list. It is saturday. 
all pagers are elsewhere. we have drinks in hand, be
they hard or soft, and we are talking. 

Then, I just type out the conversation. 

So, if you read it out loud, you have an idea of how long
it takes, mutatis mutandis for typing speed and error
correction, if any. 

|| -Original Message-
|| From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 08, 2001 1:39 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: sorry,
|| 
|| 
|| knowing you, you just tossed it off in under 15 minutes :)
|| 
|| 
|| >From: "Mohan, Ross" <[EMAIL PROTECTED]>
|| >Reply-To: [EMAIL PROTECTED]
|| >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
|| >Subject: RE: sorry,
|| >Date: Tue, 08 May 2001 08:15:29 -0800
|| >
|| >Jared,
|| >
|| >:) Thanks
|| >
|| >But, how long do you think it took to write this?
|| >
|| >Seriously...
|| >
|| >Ross
|| >
|| >
|| >
|| >|| -Original Message-
|| >|| From: Jared Still [mailto:[EMAIL PROTECTED]]
|| >|| Sent: Monday, May 07, 2001 9:11 PM
|| >|| To: Multiple recipients of list ORACLE-L
|| >|| Subject: Re: sorry,
|| >||
|| >||
|| >||
|| >|| ROFLMAO!
|| >||
|| >|| Geez Ross, do you really have a job?
|| >||
|| >|| Like, when do you *work*?
|| >||
|| >|| Or is this it?
|| >||
|| >|| Jared
|| >||
|| >||
|| >|| PS.  Bruce is more likely to kick you off than I am, and
|| >|| Jesus doesn't care.
|| >--
|| >Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| >--
|| >Author: Mohan, Ross
|| >   INET: [EMAIL PROTECTED]
|| >
|| >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| >San Diego, California-- Public Internet access / 
|| Mailing Lists
|| >
|| >To REMOVE yourself from this mailing list, send an E-Mail message
|| >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| >the message BODY, include a line containing: UNSUB ORACLE-L
|| >(or the name of mailing list you want to be removed from).  You may
|| >also send the HELP command for other information (like subscribing).
|| 
|| _
|| Get your FREE download of MSN Explorer at http://explorer.msn.com
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Rachel Carmichael
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from).  You may
|| also send the HELP command for other information (like subscribing).
|| 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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



RE: OT: Off Topic - Blah, Blah, Blah...

2001-05-08 Thread Kevin Kostyszyn

Pipe down Haskins!!

-Original Message-
Sent: Tuesday, May 08, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L



It's not just you, there are more off topic posts.

Oracle-L also has a much higher percentage
of people that actually know what they're doing,
and aren't afraid to read the manual.

Jared


On Tuesday 08 May 2001 11:06, [EMAIL PROTECTED] wrote:
> As I type, I'm guilty of committing what I'm about to rant about...
>
> It's not much of a "rant", but...
>
> I, like many on this list (ORACLE-L), subscribe and participate in both
> this and the Lazy-DBA list.  Is it just me, or does this list (ORACLE-L)
> have way more Off Topic posts??  I don't mean Off Topic as in: "UNIX vs.
> NT" or "Should I learn Java or C# to enhance my skills?", but
> rather...well, I think you know what I mean.  I'm not necessarily
> complaining, just making an observation!!
>
> Ed Haskins
> Oracle DBA
> Verizon Wireless
>
>
> -Original Message-
> Sent: Tuesday, May 08, 2001 1:26 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I have been informed privately that some may find this remark offensive,
> perhaps even deeply so.
>
> For those people:  "Sorry!, that wasn't my intent."
>
> || -Original Message-
> || From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
> || Sent: Tuesday, May 08, 2001 12:23 PM
> || To: Multiple recipients of list ORACLE-L
> || Subject: OT RE: Taking your time when a crisis occurs
> ||
> ||
> || Barbie doesn't talk when he takes her
> || clothes off.
> ||
> || || -Original Message-
> || || From: David A. Barbour [mailto:[EMAIL PROTECTED]]
> || || Sent: Monday, May 07, 2001 10:35 PM
> || || To: Multiple recipients of list ORACLE-L
> || || Subject: Re: Taking your time when a crisis occurs
> || ||
> || ||
> || || Eric,
> || ||
> || || What's with you and Barbie?
> || ||
> || || David A. Barbour
> || ||
> || || "Eric D. Pierce" wrote:
> || || >  RE: Taking your time when a crisis occurs
> || || >
> || || > -
> || || >
> || || > http://www.amazon.com/exec/obidos/ASIN2/B4SU3E
> || || >
> || || > Barbie as Glinda from The Wizard of Oz
> || || >
> || || >
> || || > Our Price: $19.99
> || || > Availability: Usually ships within 24 hours.
> || || >
> || || > Manufacturer's age: 3 years and up
> || || > Shipping: Currently, item can be shipped only within the U.S.
> || || > Shipping weight: 0.7 pounds.
> || || > Note: Giftwrapping not available for this item.
> || || > Packaging: This item may be delivered in the
> || ||
> || || manufacturer's original
> || ||
> || || > packaging, which could reveal the contents of the box.
> || || > ASIN: B4SU3E
> || || >
> || || > >From Toysrus.com & Amazon.com
> || || >
> || || > Editorial Review
> || || >
> || || > "Are you a good witch or a bad witch?" A good witch, of
> ||
> || course--and
> ||
> || || > pretty as well! Dressed as Glinda, the good witch of
> ||
> || the North from
> ||
> || || > the beloved book and movie The Wizard of Oz, Barbie is
> ||
> || welcomed to
> ||
> || || > Munchkinland. She has long, curly strawberry-blonde hair
> || ||
> || || topped by a
> || ||
> || || > tall lavender-pink crown, and she's wearing a sparkling
> ||
> || pink satin
> ||
> || || > ball gown ornamented with silver stars and butterflies.
> || ||
> || || She also has
> || ||
> || || > on a silver braided belt. Her outfit is completed with
> || ||
> || || pink heels and
> || ||
> || || > a long, lavender magic wand that fits in her hand. Raise
> || ||
> || || her arm (or
> || ||
> || || > press the button on her back), and you'll hear the
> ||
> || wand's magical
> ||
> || || > "brrinnng!" sound or Glinda's voice saying, "Tap your
> || ||
> || || heels together
> || ||
> || || > three times." Sound effects are produced by three
> ||
> || included button
> ||
> || || > cell batteries, which can be replaced. Say it again,
> || ||
> || || Glinda, just so
> || ||
> || || > we'll never forget: "There's no place like home."
> ||
> || --Marcie Bovetz
> ||
> || || > Safety Information
> || || > Choking hazard: Small parts. Not for children under 3 years.
> || || >
> || || > -
> || || >
> || || > On 7 May 2001, at 10:21, Marianne Brooks wrote:
> || || > > Hmm, shaved head, why didn't I think of that?  I would
> || ||
> || || imagine a woman with
> || ||
> || || > > a shaved head might be as effective...add a tatoo, some
> || ||
> || || leather pants and a
> || ||
> || || > > scowl and I've got a new me! :-)
> || || >
> || || > ...
> || || >
> || || > --
> || || > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> || || > --
> || || > Author: Eric D. Pierce
> || || >   INET: [EMAIL PROTECTED]
> || || >
> || || > Fat City Network Services-- (858) 538-5051  FAX:
> ||
> || (858) 538-5051
> ||
> || || > San Diego, California-- Public Internet access /
> || ||
> || || Mailing Lists
> ||
> || 
> ||
> || || > To REMOVE yourself from this mailing list, sen

Re: OT RE: sorry,

2001-05-08 Thread A. Bardeen

Of course, knowing you, I have to wonder what
conversations you didn't share with us... then again,
maybe I don't wanna know after all ;)

--- "Mohan, Ross" <[EMAIL PROTECTED]> wrote:
> Jared guessed it exactly at 5 minutes. 
> 
> It works like this...I see myself in a room with
> all the relevant folks from the list. It is
> saturday. 
> all pagers are elsewhere. we have drinks in hand, be
> they hard or soft, and we are talking. 
> 
> Then, I just type out the conversation. 
> 
> So, if you read it out loud, you have an idea of how
> long
> it takes, mutatis mutandis for typing speed and
> error
> correction, if any. 
> 
> || -Original Message-
> || From: Rachel Carmichael
> [mailto:[EMAIL PROTECTED]]
> || Sent: Tuesday, May 08, 2001 1:39 PM
> || To: Multiple recipients of list ORACLE-L
> || Subject: RE: sorry,
> || 
> || 
> || knowing you, you just tossed it off in under 15
> minutes :)
> || 
> || 
> || >From: "Mohan, Ross" <[EMAIL PROTECTED]>
> || >Reply-To: [EMAIL PROTECTED]
> || >To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> || >Subject: RE: sorry,
> || >Date: Tue, 08 May 2001 08:15:29 -0800
> || >
> || >Jared,
> || >
> || >:) Thanks
> || >
> || >But, how long do you think it took to write
> this?
> || >
> || >Seriously...
> || >
> || >Ross
> || >
> || >
> || >
> || >|| -Original Message-
> || >|| From: Jared Still [mailto:[EMAIL PROTECTED]]
> || >|| Sent: Monday, May 07, 2001 9:11 PM
> || >|| To: Multiple recipients of list ORACLE-L
> || >|| Subject: Re: sorry,
> || >||
> || >||
> || >||
> || >|| ROFLMAO!
> || >||
> || >|| Geez Ross, do you really have a job?
> || >||
> || >|| Like, when do you *work*?
> || >||
> || >|| Or is this it?
> || >||
> || >|| Jared
> || >||
> || >||
> || >|| PS.  Bruce is more likely to kick you off
> than I am, and
> || >|| Jesus doesn't care.
> || >--
> || >Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> || >--
> || >Author: Mohan, Ross
> || >   INET: [EMAIL PROTECTED]
> || >
> || >Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> || >San Diego, California-- Public Internet
> access / 
> || Mailing Lists
> ||
>
>
> || >To REMOVE yourself from this mailing list, send
> an E-Mail message
> || >to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> || >the message BODY, include a line containing:
> UNSUB ORACLE-L
> || >(or the name of mailing list you want to be
> removed from).  You may
> || >also send the HELP command for other information
> (like subscribing).
> || 
> ||
>
_
> || Get your FREE download of MSN Explorer at
> http://explorer.msn.com
> || 
> || -- 
> || Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> || -- 
> || Author: Rachel Carmichael
> ||   INET: [EMAIL PROTECTED]
> || 
> || Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> || San Diego, California-- Public Internet
> access / 
> || Mailing Lists
> ||
>

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

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


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

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

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

RE: restrict login with known IP address

2001-05-08 Thread Leyden, Joseph

I'm using 8.0.5
am I hopeless?

-Original Message-
Sent: Tuesday, May 08, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L


Hi Joe,

What version of Oracle do you use?

In 815 and upstair you can use logon trigger.
Inside the trigger try to determine IP address of 
the current session using the following sikvel:

select sys_context('USERENV', 'IP_ADDRESS') from dual;

I haven't tryed this policy yet but I believe it should work.
Let me know if it works for you

Regards,
Ed

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>


> In UNIX,
> Knowing the IP address can I restrict any login 
> to the ORACLE db given this info?
> 
> any help is appreciated ...
> 
> Joe
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Leyden, Joseph
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shevtsov, Eduard
  INET: [EMAIL PROTECTED]

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

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

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

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



Re: consistency in cost?

2001-05-08 Thread Jared Still


Actually, changing the number of CPU's in the box will
affect when hash joins are used.  

Jared

On Tuesday 08 May 2001 11:12, Nicoll, Iain (Calanais) wrote:
> Forgive my ignorance but I thought hints were only for cost based
> optimizer.
>
>
> Have you checked in case anybody has changed any parameters while the
> system is running as I know that changing the hash_area_size can change the
> execution plan?.  Are you using parallelism as if a table had to be
> recreated for any reason and its degree changed it might do a FTS?
>
> Cheers
>
> Iain Nicoll
>
>
> -Original Message-
> Sent: 08 May 2001 17:31
> To: Multiple recipients of list ORACLE-L
>
>
> Jared,
> The only difference is about a weeks worth of extra data. Well, the
> hardware is also different (Ultra450 vs. Ultra 5000. Also 1 vs 4 CPU). But
> regardless, shouldn't init.ora optimizer_mode=choose be identical to
> optimizer_mode=rule with hint=choose? If I have the time, I'll try to set
> up a couple of systems and examine by moving stats and taking some 10053
> dumps. (one of the ones giving me a problem is in production so I have
> limited play time there).
>
> Henry
>
> -Original Message-
> Sent: Tuesday, May 08, 2001 12:56 AM
> To: [EMAIL PROTECTED]; Henry Poras
>
>
>
> Henry,
>
> You say 'nearly identical'.
>
> What are the differences?
>
> Are the 2 databases on the same platform?
>
> If not, what are the differences, hardware and OS?
>
> Jared
>
> On Monday 07 May 2001 21:55, Henry Poras wrote:
> > I am working with an 8.1.6 database on Solaris 2.6 and I am wondering if
> > there is any consistency in the optimizer. We have two nearly identical
> > databases (one a clone from two weeks ago). A five table join has nearly
> > the identical execution plan on the two databases. The difference is in
>
> the
>
> > access method of the fourth table in the join; in one case it is accessed
> > by a FTS and in the other, by Index. This difference has a large effect
> > on performance. Statistics are nearly identical for this table in both
> > databases (I looked at dba_tables, dba_indexes, dba_col_tables). Also,
> > the init.ora is the same. When I changed the optimizer_mode to rule and
> > added
>
> a
>
> > 'choose' hint to the query, the execution plan was different again. I
> > will look into this a bit further and post my results. Just wondering
> > about other's experiences. Thanks.
> >
> > Henry
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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



RE: Off Topic - Blah, Blah, Blah...

2001-05-08 Thread Scott . Shafer

Yeah, but its good for "color" and the occasional comic relief.  After all,
dba'ing is pretty high pressure at times...

Scott Shafer
San Antonio, TX
210-581-6217

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 1:06 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  OT: Off Topic - Blah, Blah, Blah...
> 
> As I type, I'm guilty of committing what I'm about to rant about...
> 
> It's not much of a "rant", but...
> 
> I, like many on this list (ORACLE-L), subscribe and participate in both
> this
> and the Lazy-DBA list.  Is it just me, or does this list (ORACLE-L) have
> way
> more Off Topic posts??  I don't mean Off Topic as in: "UNIX vs. NT" or
> "Should I learn Java or C# to enhance my skills?", but rather...well, I
> think you know what I mean.  I'm not necessarily complaining, just making
> an
> observation!!
> 
> Ed Haskins
> Oracle DBA
> Verizon Wireless
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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



Re: Taking your time when a crisis occurs

2001-05-08 Thread Eric D. Pierce


totally random madness!



http://images.amazon.com/images/P/B4T8RM.01.LZZZ.jpg

http://www.amazon.com/exec/obidos/ASIN/B4T8RM

---
   Ken as Scarecrow from the Wizard of Oz

  From Toysrus.com & Amazon.com

  Editorial Review

   Ken is ready to follow Dorothy down the yellow brick road to re-create
   their adventures from the movie The Wizard of Oz. He has the painted
   eyebrows and nose of the Scarecrow, with the same wrinkled face and chin
   to show that his head is really supposed to be stuffed with straw. But
   this scarecrow does have brains, and he's holding his tiny rolled-up
   diploma in one hand to prove it. 

[COULD IT BE OCP???]

Ken wears a scarecrow costume--a green
   velour shirt and brown velour pants with appropriate patches and touches
   of straw created from frayed yellow ribbon. He's jointed at the neck,
   elbows, waist, and knees so he can sit down to rest with Dorothy and all
   his other pals from the movie, which are also available in this line of
   dolls. --Marcie Bovetz  

---


On 7 May 2001, at 18:35, David A. Barbour wrote:

Date sent:  Mon, 07 May 2001 18:35:24 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> What's with you and Barbie?

...

> > http://www.amazon.com/exec/obidos/ASIN2/B4SU3E
...


> > "Are you a good witch or a bad witch?" A good witch, of course--and
> > pretty as well! Dressed as Glinda, the good witch of the North from
> > the beloved book and movie The Wizard of Oz, Barbie is welcomed to
> > Munchkinland. 


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

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

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



oracle 817 won't start...

2001-05-08 Thread lwm

Hi All,
I'm experimenting with oracle 817 on a w2k box. It was
running fine, but this morning it refused to start.
When I tried to log onto the oracle server, I got the
following error message:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

I searched the web for a solution and tried a few
things including using ORADIM to auto start the oracle
server, but nothing seemed to work. As far as I know,
there's no system change since I started it last time
and all oracle related services appeared to be
running. 

Any idea what the problem could be?

Thanks a lot.

WL


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: lwm
  INET: [EMAIL PROTECTED]

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

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



join across database link

2001-05-08 Thread blair

A query that has run for a long time has suddenly started hanging.  The query
joins 3 tables - 2 of them across a link.  The query runs on an RDBMS 8.0.5 NT.
The  tables across the link are on AIX RDBMS 7.3.2.3.  All indexes are VALID.

When I connect to the  NT and run the query by hand it also hangs.  But I can
join the NT table to each of the AIX tables and get instant results - I just
cannot join all three.

When I do a describe across the link I get "ORA-12663-Services required by the
client not available on the server."  

Any ideas for further troubleshooting?

..tom


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

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

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



RE: OT RE: OT RE: Taking your time when a crisis occurs

2001-05-08 Thread Hillman, Alex

Now I think that it was a very insencitive sexist remark? :-) 

Alex Hillman



-Original Message-
Sent: Tuesday, May 08, 2001 1:26 PM
To: Multiple recipients of list ORACLE-L


I have been informed privately that some may find this remark offensive,
perhaps even deeply so. 

For those people:  "Sorry!, that wasn't my intent."

|| -Original Message-
|| From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 08, 2001 12:23 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: OT RE: Taking your time when a crisis occurs
|| 
|| 
|| Barbie doesn't talk when he takes her
|| clothes off. 
|| 
|| || -Original Message-
|| || From: David A. Barbour [mailto:[EMAIL PROTECTED]]
|| || Sent: Monday, May 07, 2001 10:35 PM
|| || To: Multiple recipients of list ORACLE-L
|| || Subject: Re: Taking your time when a crisis occurs
|| || 
|| || 
|| || Eric,
|| || 
|| || What's with you and Barbie?
|| || 
|| || David A. Barbour
|| || 
|| || "Eric D. Pierce" wrote:
|| || > 
|| || >  RE: Taking your time when a crisis occurs
|| || > 
|| || > -
|| || > 
|| || > http://www.amazon.com/exec/obidos/ASIN2/B4SU3E
|| || > 
|| || > Barbie as Glinda from The Wizard of Oz
|| || > 
|| || > 
|| || > Our Price: $19.99
|| || > Availability: Usually ships within 24 hours.
|| || > 
|| || > Manufacturer's age: 3 years and up
|| || > Shipping: Currently, item can be shipped only within the U.S.
|| || > Shipping weight: 0.7 pounds.
|| || > Note: Giftwrapping not available for this item.
|| || > Packaging: This item may be delivered in the 
|| || manufacturer's original
|| || > packaging, which could reveal the contents of the box.
|| || > ASIN: B4SU3E
|| || > 
|| || > 
|| || > 
|| || > >From Toysrus.com & Amazon.com
|| || > Editorial Review
|| || > 
|| || > "Are you a good witch or a bad witch?" A good witch, of 
|| course--and
|| || > pretty as well! Dressed as Glinda, the good witch of 
|| the North from
|| || > the beloved book and movie The Wizard of Oz, Barbie is 
|| welcomed to
|| || > Munchkinland. She has long, curly strawberry-blonde hair 
|| || topped by a
|| || > tall lavender-pink crown, and she's wearing a sparkling 
|| pink satin
|| || > ball gown ornamented with silver stars and butterflies. 
|| || She also has
|| || > on a silver braided belt. Her outfit is completed with 
|| || pink heels and
|| || > a long, lavender magic wand that fits in her hand. Raise 
|| || her arm (or
|| || > press the button on her back), and you'll hear the 
|| wand's magical
|| || > "brrinnng!" sound or Glinda's voice saying, "Tap your 
|| || heels together
|| || > three times." Sound effects are produced by three 
|| included button
|| || > cell batteries, which can be replaced. Say it again, 
|| || Glinda, just so
|| || > we'll never forget: "There's no place like home." 
|| --Marcie Bovetz
|| || > Safety Information
|| || > Choking hazard: Small parts. Not for children under 3 years.
|| || > 
|| || > -
|| || > 
|| || > On 7 May 2001, at 10:21, Marianne Brooks wrote:
|| || > 
|| || > > Hmm, shaved head, why didn't I think of that?  I would 
|| || imagine a woman with
|| || > > a shaved head might be as effective...add a tatoo, some 
|| || leather pants and a
|| || > > scowl and I've got a new me! :-)
|| || > 
|| || > ...
|| || > 
|| || > --
|| || > Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| || > --
|| || > Author: Eric D. Pierce
|| || >   INET: [EMAIL PROTECTED]
|| || > 
|| || > Fat City Network Services-- (858) 538-5051  FAX: 
|| (858) 538-5051
|| || > San Diego, California-- Public Internet access / 
|| || Mailing Lists
|| || > 
|| || 
|| 
|| || > To REMOVE yourself from this mailing list, send an 
|| E-Mail message
|| || > to: [EMAIL PROTECTED] (note EXACT spelling of 
|| 'ListGuru') and in
|| || > the message BODY, include a line containing: UNSUB ORACLE-L
|| || > (or the name of mailing list you want to be removed 
|| from).  You may
|| || > also send the HELP command for other information (like 
|| || subscribing).
|| || -- 
|| || Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| || -- 
|| || Author: David A. Barbour
|| ||   INET: [EMAIL PROTECTED]
|| || 
|| || Fat City Network Services-- (858) 538-5051  FAX: 
|| (858) 538-5051
|| || San Diego, California-- Public Internet access / 
|| || Mailing Lists
|| || 
|| 
|| || To REMOVE yourself from this mailing list, send an E-Mail message
|| || to: [EMAIL PROTECTED] (note EXACT spelling of 
|| 'ListGuru') and in
|| || the message BODY, include a line containing: UNSUB ORACLE-L
|| || (or the name of mailing list you want to be removed 
|| from).  You may
|| || also send the HELP command for other information (like 
|| subscribing).
|| || 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Mohan, Ross
||   INET: [EMAIL PROTE

Oracle books

2001-05-08 Thread Keith Myers

Being a relatively new and often times struggling Oracle DBA I was wondering
what 3 or 4 books everyone recommends as a must have reference/knowledge
base in day to day support/programming of their databases.

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

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

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



RE: OT RE: sorry,

2001-05-08 Thread Scott . Shafer

Certifiably!  

Scott Shafer
San Antonio, TX
210-581-6217

> -Original Message-
> From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 12:33 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  OT RE: sorry,
> 
> "Are you an idiot?"
> 
> ;-)
> 
> || -Original Message-
> || From: [EMAIL PROTECTED]
> || [mailto:[EMAIL PROTECTED]]
> || Sent: Tuesday, May 08, 2001 12:23 PM
> || To: Multiple recipients of list ORACLE-L
> || Subject: RE: sorry,
> || 
> || 
> || Why does it have to be an either/or choice?  Lets do 'em all!!!   ;-)
> || 
> || Scott Shafer
> || San Antonio, TX
> || 210-581-6217
> || 
> || > -Original Message-
> || > From:Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> || > Sent:Monday, May 07, 2001 4:52 PM
> || > To:  Multiple recipients of list ORACLE-L
> || > Subject: RE: sorry,
> || > 
> || > Folks, let's deal with this in the following fashion"
> || > 
> || > 
> || > 0) Whine and bemoan the loss of decency in everyday life, 
> || >  the callowness, the reprehensible lack of self-control,
> || >  and the horrid manners of Robert Hutchins.
> || > 
> || > 1) Send out a team to Robert's place of business and 
> || >  either stone the walls, picket on the sidewalk, 
> || >  or promise a boycott of all office products that
> || >  will bring Staples to its knees in Chapter 13, 
> || >  forcing his management to fire him, leaving him
> || >  jobless and loveless in a cruel, bitter world, 
> || >  finally so miserable that he commits suicide. 
> || > 
> || > 2) Pat ourselves on the back that 'we'd never do something
> || >  that rude.' and wait for the next offender. 
> || > 
> || > 
> || > OR
> || > 
> || > 
> || > 0) Go after the "idiot" directly, in full psycho, old world
> || >  SA fashion. "You should know better", "Read the Trucking
> || >  Manual", "Get off the list until you know better", etc. 
> || >  Drive him off the list in the way that only the members
> || >  of an elite technocracy can.
> || > 
> || > 1) Send out a team to Lando's place of business and apply
> || >  the same methods as at Staples, mutatis mutandis, 
> || >  forcing Dulcian into Chapter 13.
> || > 
> || > 2) Pat ourselves on the back, etc. 
> || > 
> || > 
> || > OR
> || > 
> || > 0) From now on, no matter who writes, on what topic, and 
> || >  regardless of content, we as a list respond with a flurry
> || >  of emails that say only "Are you an idiot". This actually 
> || >  contains less letters than "Read the Freaking Manual" and 
> || >  has a certain personal flair in addition to its obvious social
> || > charms.
> || > 
> || > 1) Wait until Jared, Bruce, Jesus, or whoever is REALLY in charge
> || >  of the list kicks us ALL off the list, one by one.
> || > 
> || > 2) But, immediately get a new account under a new name, and keep 
> || >  joining the list, and answering people's technical questions 
> || >  with "Are you an idiot?" For added value, send a bunch of 
> || >  technical questions of your own to the list-admin address, 
> || >  despite any corrections you may receive. 
> || > 
> || > 
> || > OR
> || > 
> || > 
> || > We could just forget the whole damn thing. ( sung to the tune
> || > of "Potato, Potatoe,...Let's Call The Whole Thing Off")
> || > 
> || > 
> || > Yours in Joy and Cosmic Bemusement, 
> || > 
> || > 
> || > etc. 
> || >  years. Finally, the list itself will turn
> || > 
> || > 
> || > || -Original Message-
> || > || From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
> || > || Sent: Monday, May 07, 2001 5:21 PM
> || > || To: Multiple recipients of list ORACLE-L
> || > || Subject: RE: sorry,
> || > || 
> || > || 
> || > || Amazingyet true..
> || > || 
> || > || -Original Message-
> || > || Sent: Monday, May 07, 2001 5:01 PM
> || > || To: Multiple recipients of list ORACLE-L
> || > || 
> || > || 
> || > || Boy, did I call that one, or what?
> || > ||  
> || > || Whoo-eee, here comes my career at Psychic
> || > || Friends Network, doing MS-product support!
> || > -- 
> || > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> || > -- 
> || > Author: Mohan, Ross
> || >   INET: [EMAIL PROTECTED]
> || > 
> || > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> || > San Diego, California-- Public Internet access / 
> || Mailing Lists
> || > 
> || 
> || > To REMOVE yourself from this mailing list, send an E-Mail message
> || > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> || > the message BODY, include a line containing: UNSUB ORACLE-L
> || > (or the name of mailing list you want to be removed from).  You may
> || > also send the HELP command for other information (like 
> || subscribing).
> || -- 
> || Please see the official ORACLE-L FAQ: http://www.orafaq.com
> || -- 
> || Author: 
> ||   INET: [EMAIL PROTECTED]
> || 
> || Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> || 

RE: E-mail from Alert Logs

2001-05-08 Thread Rao, Maheswara

Bunyamin,

Could you please send the attachment directly to me?

Thanks,

Rao

[EMAIL PROTECTED]

-Original Message-
Sent: Thursday, May 03, 2001 9:52 AM
To: Multiple recipients of list ORACLE-L

 There is a program (AUTOMAIL) which sends an email to anyone you idntify
when there is a change in a file. Look at it . It is attached .


- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 03, 2001 3:00 PM


> Hi List
>
> Is there any way of receiving an e-mail or sms , whenever a ORA- error
> appears in the Oracle Alert Log, or when something unexpected happens to
> the Oracle Instance ?
>
>
> TIA
>
> Saj
>
> --
> Sajid Iqbal
> Database Team Leader
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sajid Iqbal
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rao, Maheswara
  INET: [EMAIL PROTECTED]

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

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



Re: OT: Off Topic - Blah, Blah, Blah...

2001-05-08 Thread Jared Still


It's not just you, there are more off topic posts.

Oracle-L also has a much higher percentage
of people that actually know what they're doing,
and aren't afraid to read the manual.

Jared


On Tuesday 08 May 2001 11:06, [EMAIL PROTECTED] wrote:
> As I type, I'm guilty of committing what I'm about to rant about...
>
> It's not much of a "rant", but...
>
> I, like many on this list (ORACLE-L), subscribe and participate in both
> this and the Lazy-DBA list.  Is it just me, or does this list (ORACLE-L)
> have way more Off Topic posts??  I don't mean Off Topic as in: "UNIX vs.
> NT" or "Should I learn Java or C# to enhance my skills?", but
> rather...well, I think you know what I mean.  I'm not necessarily
> complaining, just making an observation!!
>
> Ed Haskins
> Oracle DBA
> Verizon Wireless
>
>
> -Original Message-
> Sent: Tuesday, May 08, 2001 1:26 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I have been informed privately that some may find this remark offensive,
> perhaps even deeply so.
>
> For those people:  "Sorry!, that wasn't my intent."
>
> || -Original Message-
> || From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
> || Sent: Tuesday, May 08, 2001 12:23 PM
> || To: Multiple recipients of list ORACLE-L
> || Subject: OT RE: Taking your time when a crisis occurs
> ||
> ||
> || Barbie doesn't talk when he takes her
> || clothes off.
> ||
> || || -Original Message-
> || || From: David A. Barbour [mailto:[EMAIL PROTECTED]]
> || || Sent: Monday, May 07, 2001 10:35 PM
> || || To: Multiple recipients of list ORACLE-L
> || || Subject: Re: Taking your time when a crisis occurs
> || ||
> || ||
> || || Eric,
> || ||
> || || What's with you and Barbie?
> || ||
> || || David A. Barbour
> || ||
> || || "Eric D. Pierce" wrote:
> || || >  RE: Taking your time when a crisis occurs
> || || >
> || || > -
> || || >
> || || > http://www.amazon.com/exec/obidos/ASIN2/B4SU3E
> || || >
> || || > Barbie as Glinda from The Wizard of Oz
> || || >
> || || >
> || || > Our Price: $19.99
> || || > Availability: Usually ships within 24 hours.
> || || >
> || || > Manufacturer's age: 3 years and up
> || || > Shipping: Currently, item can be shipped only within the U.S.
> || || > Shipping weight: 0.7 pounds.
> || || > Note: Giftwrapping not available for this item.
> || || > Packaging: This item may be delivered in the
> || ||
> || || manufacturer's original
> || ||
> || || > packaging, which could reveal the contents of the box.
> || || > ASIN: B4SU3E
> || || >
> || || > >From Toysrus.com & Amazon.com
> || || >
> || || > Editorial Review
> || || >
> || || > "Are you a good witch or a bad witch?" A good witch, of
> ||
> || course--and
> ||
> || || > pretty as well! Dressed as Glinda, the good witch of
> ||
> || the North from
> ||
> || || > the beloved book and movie The Wizard of Oz, Barbie is
> ||
> || welcomed to
> ||
> || || > Munchkinland. She has long, curly strawberry-blonde hair
> || ||
> || || topped by a
> || ||
> || || > tall lavender-pink crown, and she's wearing a sparkling
> ||
> || pink satin
> ||
> || || > ball gown ornamented with silver stars and butterflies.
> || ||
> || || She also has
> || ||
> || || > on a silver braided belt. Her outfit is completed with
> || ||
> || || pink heels and
> || ||
> || || > a long, lavender magic wand that fits in her hand. Raise
> || ||
> || || her arm (or
> || ||
> || || > press the button on her back), and you'll hear the
> ||
> || wand's magical
> ||
> || || > "brrinnng!" sound or Glinda's voice saying, "Tap your
> || ||
> || || heels together
> || ||
> || || > three times." Sound effects are produced by three
> ||
> || included button
> ||
> || || > cell batteries, which can be replaced. Say it again,
> || ||
> || || Glinda, just so
> || ||
> || || > we'll never forget: "There's no place like home."
> ||
> || --Marcie Bovetz
> ||
> || || > Safety Information
> || || > Choking hazard: Small parts. Not for children under 3 years.
> || || >
> || || > -
> || || >
> || || > On 7 May 2001, at 10:21, Marianne Brooks wrote:
> || || > > Hmm, shaved head, why didn't I think of that?  I would
> || ||
> || || imagine a woman with
> || ||
> || || > > a shaved head might be as effective...add a tatoo, some
> || ||
> || || leather pants and a
> || ||
> || || > > scowl and I've got a new me! :-)
> || || >
> || || > ...
> || || >
> || || > --
> || || > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> || || > --
> || || > Author: Eric D. Pierce
> || || >   INET: [EMAIL PROTECTED]
> || || >
> || || > Fat City Network Services-- (858) 538-5051  FAX:
> ||
> || (858) 538-5051
> ||
> || || > San Diego, California-- Public Internet access /
> || ||
> || || Mailing Lists
> ||
> || 
> ||
> || || > To REMOVE yourself from this mailing list, send an
> ||
> || E-Mail message
> ||
> || || > to: [EMAIL PROTECTED] (note EXACT spelling of
> ||
> || 'ListGuru') and in
> ||
> 

OT RE: OT RE: OT RE: Taking your time when a crisis occurs

2001-05-08 Thread Mohan, Ross

That's the word on the street, yea. 

|| -Original Message-
|| From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 08, 2001 2:42 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: OT RE: OT RE: Taking your time when a crisis occurs
|| 
|| 
|| Now I think that it was a very insencitive sexist remark? :-) 
|| 
|| Alex Hillman
|| 
|| 
|| 
|| -Original Message-
|| Sent: Tuesday, May 08, 2001 1:26 PM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| I have been informed privately that some may find this 
|| remark offensive,
|| perhaps even deeply so. 
|| 
|| For those people:  "Sorry!, that wasn't my intent."
|| 
|| || -Original Message-
|| || From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
|| || Sent: Tuesday, May 08, 2001 12:23 PM
|| || To: Multiple recipients of list ORACLE-L
|| || Subject: OT RE: Taking your time when a crisis occurs
|| || 
|| || 
|| || Barbie doesn't talk when he takes her
|| || clothes off. 
|| || 
|| || || -Original Message-
|| || || From: David A. Barbour [mailto:[EMAIL PROTECTED]]
|| || || Sent: Monday, May 07, 2001 10:35 PM
|| || || To: Multiple recipients of list ORACLE-L
|| || || Subject: Re: Taking your time when a crisis occurs
|| || || 
|| || || 
|| || || Eric,
|| || || 
|| || || What's with you and Barbie?
|| || || 
|| || || David A. Barbour
|| || || 
|| || || "Eric D. Pierce" wrote:
|| || || > 
|| || || >  RE: Taking your time when a crisis occurs
|| || || > 
|| || || > -
|| || || > 
|| || || > http://www.amazon.com/exec/obidos/ASIN2/B4SU3E
|| || || > 
|| || || > Barbie as Glinda from The Wizard of Oz
|| || || > 
|| || || > 
|| || || > Our Price: $19.99
|| || || > Availability: Usually ships within 24 hours.
|| || || > 
|| || || > Manufacturer's age: 3 years and up
|| || || > Shipping: Currently, item can be shipped only within the U.S.
|| || || > Shipping weight: 0.7 pounds.
|| || || > Note: Giftwrapping not available for this item.
|| || || > Packaging: This item may be delivered in the 
|| || || manufacturer's original
|| || || > packaging, which could reveal the contents of the box.
|| || || > ASIN: B4SU3E
|| || || > 
|| || || > 
|| || || > 
|| || || > >From Toysrus.com & Amazon.com
|| || || > Editorial Review
|| || || > 
|| || || > "Are you a good witch or a bad witch?" A good witch, of 
|| || course--and
|| || || > pretty as well! Dressed as Glinda, the good witch of 
|| || the North from
|| || || > the beloved book and movie The Wizard of Oz, Barbie is 
|| || welcomed to
|| || || > Munchkinland. She has long, curly strawberry-blonde hair 
|| || || topped by a
|| || || > tall lavender-pink crown, and she's wearing a sparkling 
|| || pink satin
|| || || > ball gown ornamented with silver stars and butterflies. 
|| || || She also has
|| || || > on a silver braided belt. Her outfit is completed with 
|| || || pink heels and
|| || || > a long, lavender magic wand that fits in her hand. Raise 
|| || || her arm (or
|| || || > press the button on her back), and you'll hear the 
|| || wand's magical
|| || || > "brrinnng!" sound or Glinda's voice saying, "Tap your 
|| || || heels together
|| || || > three times." Sound effects are produced by three 
|| || included button
|| || || > cell batteries, which can be replaced. Say it again, 
|| || || Glinda, just so
|| || || > we'll never forget: "There's no place like home." 
|| || --Marcie Bovetz
|| || || > Safety Information
|| || || > Choking hazard: Small parts. Not for children under 3 years.
|| || || > 
|| || || > -
|| || || > 
|| || || > On 7 May 2001, at 10:21, Marianne Brooks wrote:
|| || || > 
|| || || > > Hmm, shaved head, why didn't I think of that?  I would 
|| || || imagine a woman with
|| || || > > a shaved head might be as effective...add a tatoo, some 
|| || || leather pants and a
|| || || > > scowl and I've got a new me! :-)
|| || || > 
|| || || > ...
|| || || > 
|| || || > --
|| || || > Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| || || > --
|| || || > Author: Eric D. Pierce
|| || || >   INET: [EMAIL PROTECTED]
|| || || > 
|| || || > Fat City Network Services-- (858) 538-5051  FAX: 
|| || (858) 538-5051
|| || || > San Diego, California-- Public Internet access / 
|| || || Mailing Lists
|| || || > 
|| || || 
|| || 
|| 
|| || || > To REMOVE yourself from this mailing list, send an 
|| || E-Mail message
|| || || > to: [EMAIL PROTECTED] (note EXACT spelling of 
|| || 'ListGuru') and in
|| || || > the message BODY, include a line containing: UNSUB ORACLE-L
|| || || > (or the name of mailing list you want to be removed 
|| || from).  You may
|| || || > also send the HELP command for other information (like 
|| || || subscribing).
|| || || -- 
|| || || Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| || || -- 
|| || || Author: David A. Barbour
|| || ||   INET: [EMAIL PROTECTED]
|| || || 
|| || || Fat City Network Services-- (858) 5

Re: ORA-06573 ???

2001-05-08 Thread Jared Still


You nailed it Don,  I saw the same thing.

You cannot use DBMS_OUTPUT in a function
called by a SQL statement, regardless of pragma
statements. 

I've tried it before, couldn't do it.  This was on pre 
8i versions of Oracle however.  The rules have 
changed on 8i, it may work.  

Jared


On Tuesday 08 May 2001 08:00, Don Jerman wrote:
> May be naive, but it seems to me that
>
> DBMS_OUTPUT.ENABLE(64000);
>
> must be altering the state of the DBMS_OUTPUT package -- and it doesn't
> seem to be needed by the funciton -- why not try without it?
>
> Stefan Jahnke wrote:
> > Hi,
> >
> > I get this error if I give a (standalone) function in a where clause:
> >
> > ORA-06573: Function WSNADDR modifies package state, cannot be used here
> >
> > What exactly does it mean and how can I workaround it ? The statement I
> > tried to issue looks like this:
> >
> > select rtrim(substr(wsnaddr(env_wsnaddr),45,3)) IP, db_instance_node
> > MACHINE
> >   from environment e, dbinstancenode dn
> >  where
> > rtrim(substr(wsnaddr(env_wsnaddr),45,3))=rtrim(substr(db_inst_node_desc,1
> >1,3)); * -> here's the problem.
> >
> > WSNADDR is a self-defined function that looks like this:
> >
> > CREATE OR REPLACE FUNCTION WSNADDR (v_WSNAddress IN VARCHAR2) RETURN
> > VARCHAR2 IS
> > v_Port  VARCHAR2(8);
> > v_IPAddrVARCHAR2(8);
> > v_IPDecode  VARCHAR2(16);
> > v_IPPartVARCHAR2(3);
> > v_DecodeWSN VARCHAR2(60);
> >
> > BEGIN
> >   DBMS_OUTPUT.ENABLE(64000);
> >   v_Port := SUBSTR(v_WSNAddress,3,8);
> >   v_IPAddr := SUBSTR(v_WSNAddress,11,8);
> >   v_IPDecode := '';
> >   FOR v_Index IN 0 .. 3 LOOP
> > v_IPPart := TO_CHAR(HEXTONUMBER(SUBSTR(v_IPAddr,2*v_Index+1,2)));
> > IF (v_Index < 3) THEN
> >   v_IPDecode := v_IPDecode || v_IPPart || '.';
> > ELSE
> >   v_IPDecode := v_IPDecode || v_IPPart;
> > END IF;
> >   END LOOP;
> >   v_DecodeWSN := 'Port: ' || v_Port || ' 0xIP: ' || v_IPAddr || ' IP: '
> >
> > || v_IPDecode;
> >
> >   RETURN v_DecodeWSN;
> > END WSNADDR;
> > /
> >
> > The above used function HEXTONUMBER just converts a hex into a number
> > (what a surprise ;).
> > The purpose of this function is to turn Tuxedo WSN addresses into a
> > readable format. WSN addresses look like this:
> >
> > 0x000285ca8b07ca49
> >
> > They contain the IP and the port where the service runs. The function's
> > output looks like this:
> >
> > Port: 000285ca 0xIP: 8b07ca49 IP: 139.7.202.73
> >
> > Any ideas ?
> >
> > --
> > Regards,
> > Stefan Jahnke
> > BOV AG
> > @:D2 Vodafone, Abt.: FIBM
> > AMS-Gebäude: E6 R08
> > Tel.: 0211/533-4893
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Stefan Jahnke
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).


Content-Type: text/x-vcard; charset="us-ascii"; name="djerman.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Don Jerman

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

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

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



RE: sorry,

2001-05-08 Thread Mohan, Ross

Pi? 

You are too kind by approximately one minute and 46 seconds. 

|| -Original Message-
|| From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 08, 2001 1:39 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: sorry,
|| 
|| 
|| the way Ross's mind functions probably about 3 minutes and 
|| 14 seconds.
|| 
|| -Original Message-
|| Sent: Tuesday, May 08, 2001 12:15 PM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Jared, 
|| 
|| :) Thanks
|| 
|| But, how long do you think it took to write this?
|| 
|| Seriously...
|| 
|| Ross
|| 
|| 
|| 
|| || -Original Message-
|| || From: Jared Still [mailto:[EMAIL PROTECTED]]
|| || Sent: Monday, May 07, 2001 9:11 PM
|| || To: Multiple recipients of list ORACLE-L
|| || Subject: Re: sorry,
|| || 
|| || 
|| || 
|| || ROFLMAO!
|| || 
|| || Geez Ross, do you really have a job? 
|| || 
|| || Like, when do you *work*?
|| || 
|| || Or is this it?
|| || 
|| || Jared
|| || 
|| || 
|| || PS.  Bruce is more likely to kick you off than I am, and 
|| || Jesus doesn't care.
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Mohan, Ross
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from).  You may
|| also send the HELP command for other information (like subscribing).
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Kevin Kostyszyn
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from).  You may
|| also send the HELP command for other information (like subscribing).
|| 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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



RE: restrict login with known IP address

2001-05-08 Thread Vadim Gorbounov

Hello, Joseph
Try something like this

CREATE OR REPLACE TRIGGER IP_CATCH AFTER LOGON ON DATABASE
BEGIN
  if ora_client_ip_address = '172.16.0.175' then 
 raise_application_error(-20001, 'No way from '||ora_client_ip_address);
  end if;
END;
/

HTH 
Vadim Gorbounov
Oracle DBA


-Original Message-
Sent: Tuesday, May 08, 2001 1:26 PM
To: Multiple recipients of list ORACLE-L


In UNIX,
Knowing the IP address can I restrict any login 
to the ORACLE db given this info?

any help is appreciated ...

Joe

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

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

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

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

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



Re: SQL query needing Oracle cast

2001-05-08 Thread Jared Still


Christophe,

I'm not sure why you are trying to use CAST and MULTICAST
as these are for use with object oriented features of Oracle.

Below is an example of Top N queries.  The 8i version is somewhat
simpler, as an 'ORDER BY' is allowed in the subquery.

This example also has one less level of subquery.  Yours appears
to be more complex than necessary.

HTH

Jared

--

drop table limit_tab;

create table limit_tab ( x number );

insert into limit_tab values(0);
insert into limit_tab values(1);
insert into limit_tab values(2);
insert into limit_tab values(3);
insert into limit_tab values(4);
insert into limit_tab values(5);
insert into limit_tab values(6);
insert into limit_tab values(7);
insert into limit_tab values(8);
insert into limit_tab values(9);

commit;

-- Oracle 8.1.x
select ilv.x
from 
(
select x
from limit_tab
order by x
) ilv
where rownum <=3
/


-- Oracle 8.0.x

select x
from limit_tab lt
where 3 > (
select count(*) 
from limit_tab
where x < lt.x
)
order by x
/

--

On Tuesday 08 May 2001 06:25, Christophe Schockaert wrote:
> I am using Oracle 8.0.5
>
> Christophe
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jared Still
> > Sent: lundi 7 mai 2001 21:17
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: SQL query needing Oracle cast
> >
> >
> >
> > Chris, there are other ways to do this, but they are version dependant.
> >
> > Which version of Oracle are you using?
> >
> > Jared
> >
> > On Monday 07 May 2001 14:07, Christophe Schockaert wrote:
> > > Hi all,
> > >
> > > I need to get the top N values from a table.
> > > It's quite easy to formulate in english, but rather interesting
> >
> > to write in
> >
> > > SQL.
> > > I found a solution at
> >
> > http://www.4guysfromrolla.com/webtech/110498-1.shtml
> >
> > > The example has a table ItemCost containing ItemNumberID (int) and Cost
> > > (money).
> > > The query is:
> > >
> > > SELECT rank, ItemNumberID, Cost
> > > FROM (SELECT T1.ItemNumberID, T1.Cost,
> > >  (SELECT COUNT(DISTINCT T2.Cost) FROM ItemCost T2
> > >   WHERE T1.Cost <= T2.Cost) AS rank
> > >   FROM ItemCost T1) AS X
> > > WHERE rank > >
> > > The problem is that Oracle refuses the (select COUNT ...) in the second
> > > SELECT clause.
> > > It seems that I have to use CAST but I'm getting lost with the syntax.
> > > According to the documentation, I have to use CAST(MULTISET ...) if the
> > > query will result in several rows. It is also said that scalar
> >
> > subqueries
> >
> > > as argument of the CAST operator are not valid in Oracle8. Do I have to
> > > consider SELECT COUNT as a scalar subquery ? It is not a
> >
> > multi-rows query
> >
> > > anyway.
> > > However, whether I use CAST, CAST(MULTISET) or just the example above,
> > > I get an error from Oracle.
> > >
> > > Does anybody know how I can translate the example to Oracle, or
> >
> > how I can
> >
> > > write a query in the Oracle SQL syntax which will give me the
> >
> > result I want
> >
> > > ?
> > >
> > >
> > > Thanks in advance,
> > >
> > > Christophe
> > >
> > > --->  mailto:[EMAIL PROTECTED]
> > >
> > > Once it's perfectly aimed, the flying arrow goes straight to its
> > > target. Thus, don't worry when things go right.
> > > There will be enough time to worry about if they go wrong.
> > > Then, it's time to fire a new arrow towards another direction.
> > > Don't sink.  Adapt yourself !  The archer has to shoot accurately and
> > > quickly.
> > > [Words of Erenthar, the bowman ranger]  <---
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jared Still
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

Pl/sql loop assistance

2001-05-08 Thread Hagedorn, Linda
Title: Pl/sql loop assistance 





Hello, 


I'm having difficulty coding this loop and am hoping someone can see how this can be done.   


I have two tables, one on each instance reg.docalert_responses@ncp and reg.docalert_emails_05040@ncc 


The requirement is to set ncp.reg.docalert_responses.campaign_response_handled = 1  for all docalert_response_id's that exist in ncc.reg.docalert_emails_050401 where sent=1.  Update 100 at a time and commit.  The join column, docalert_response_id appears in both tables.  

I know I can set autocommit, but I'd really like to see the elegant loop logic.  The DBLinks are in place.   


Any assistance is appreciated.  

Thanks, Linda 
 
 





Re: restrict login with known IP address

2001-05-08 Thread Shevtsov, Eduard

Hi Joe,

What version of Oracle do you use?

In 815 and upstair you can use logon trigger.
Inside the trigger try to determine IP address of 
the current session using the following sikvel:

select sys_context('USERENV', 'IP_ADDRESS') from dual;

I haven't tryed this policy yet but I believe it should work.
Let me know if it works for you

Regards,
Ed

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>


> In UNIX,
> Knowing the IP address can I restrict any login 
> to the ORACLE db given this info?
> 
> any help is appreciated ...
> 
> Joe
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Leyden, Joseph
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shevtsov, Eduard
  INET: [EMAIL PROTECTED]

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

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



RE: restrict login with known IP address

2001-05-08 Thread pierre . olaru

Yes, it is possible thorugh protocol.ora. Practically, you must configure the 
excluded IP addresses using excluded nodes option.

Regards,
Pierre

-Original Message-
From:   LeydenJ [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, May 08, 2001 7:26 PM
To: ORACLE-L
Cc: LeydenJ
Subject:restrict login with known IP address

In UNIX,
Knowing the IP address can I restrict any login 
to the ORACLE db given this info?

any help is appreciated ...

Joe

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

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

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


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

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

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



RE: Oracle tuning book

2001-05-08 Thread Deshpande, Kirti

Yes it is..
That's my official full first name..
Hope Mogens doesn't get any ideas  ;)

- Kirti

> -Original Message-
> From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 10:46 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Oracle tuning book
> 
> Kirti,
> 
> Is that your name on the book with Gaja?
> 
> Raj
> __
> Rajendra JamadagniMIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't reflect that of ESPN
> Inc.
> 
> QOTD: Any clod can have facts, but having an opinion is an art !
> 
> *
> 
> This e-mail message is confidential, intended only for the named
> recipient(s) above and may contain information that is privileged,
> attorney work product or exempt from disclosure under applicable law. If
> you have received this message in error, or are not the named
> recipient(s), please immediately notify ESPN at (860) 766-2000 and delete
> this e-mail message from your computer, Thank you.
> 
> *
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Jamadagni, Rajendra
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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



RE: restrict login with known IP address

2001-05-08 Thread Adams, Matthew (GEA, 088130)
Title: RE: restrict login with known IP address





use the


tcp.invited_nodes 


paramter in a protocol.ora file (.protocol.ora if you
are on 8.1.6 due)



R. Matt Adams  - GE Appliances - [EMAIL PROTECTED]
  Meddle not in the affairs of troff, 
  for it is subtle and quick to anger.




> -Original Message-
> From: Leyden, Joseph [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 1:26 PM
> To: Multiple recipients of list ORACLE-L
> Subject: restrict login with known IP address
> 
> 
> In UNIX,
> Knowing the IP address can I restrict any login 
> to the ORACLE db given this info?
> 
> any help is appreciated ...
> 
> Joe
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Leyden, Joseph
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California    -- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 





RE: consistency in cost?

2001-05-08 Thread Nicoll, Iain (Calanais)

Forgive my ignorance but I thought hints were only for cost based optimizer.


Have you checked in case anybody has changed any parameters while the system
is running as I know that changing the hash_area_size can change the
execution plan?.  Are you using parallelism as if a table had to be
recreated for any reason and its degree changed it might do a FTS?

Cheers

Iain Nicoll


-Original Message-
Sent: 08 May 2001 17:31
To: Multiple recipients of list ORACLE-L


Jared,
The only difference is about a weeks worth of extra data. Well, the hardware
is also different (Ultra450 vs. Ultra 5000. Also 1 vs 4 CPU). But
regardless, shouldn't init.ora optimizer_mode=choose be identical to
optimizer_mode=rule with hint=choose? If I have the time, I'll try to set up
a couple of systems and examine by moving stats and taking some 10053 dumps.
(one of the ones giving me a problem is in production so I have limited play
time there).

Henry 

-Original Message-
Sent: Tuesday, May 08, 2001 12:56 AM
To: [EMAIL PROTECTED]; Henry Poras



Henry,

You say 'nearly identical'.

What are the differences?

Are the 2 databases on the same platform?

If not, what are the differences, hardware and OS?

Jared


On Monday 07 May 2001 21:55, Henry Poras wrote:
> I am working with an 8.1.6 database on Solaris 2.6 and I am wondering if
> there is any consistency in the optimizer. We have two nearly identical
> databases (one a clone from two weeks ago). A five table join has nearly
> the identical execution plan on the two databases. The difference is in
the
> access method of the fourth table in the join; in one case it is accessed
> by a FTS and in the other, by Index. This difference has a large effect on
> performance. Statistics are nearly identical for this table in both
> databases (I looked at dba_tables, dba_indexes, dba_col_tables). Also, the
> init.ora is the same. When I changed the optimizer_mode to rule and added
a
> 'choose' hint to the query, the execution plan was different again. I will
> look into this a bit further and post my results. Just wondering about
> other's experiences. Thanks.
>
> Henry
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Henry Poras
  INET: [EMAIL PROTECTED]

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

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

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

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



RE: Oracle tuning book

2001-05-08 Thread Rachel Carmichael

yup -- Kirti wrote it with Gaja and did a heck of a job too!


>From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Oracle tuning book
>Date: Tue, 08 May 2001 07:46:29 -0800
>
>Kirti,
>
>Is that your name on the book with Gaja?
>
>Raj
>__
>Rajendra Jamadagni MIS, ESPN Inc.
>Rajendra dot Jamadagni at ESPN dot com
>Any opinion expressed here is personal and doesn't reflect that of ESPN 
>Inc.
>
>QOTD: Any clod can have facts, but having an opinion is an art !
>
>*
>
>This e-mail message is confidential, intended only for the named 
>recipient(s) above and may contain information that is privileged, attorney 
>work product or exempt from disclosure under applicable law. If you have 
>received this message in error, or are not the named recipient(s), please 
>immediately notify ESPN at (860) 766-2000 and delete this e-mail message 
>from your computer, Thank you.
>
>*
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jamadagni, Rajendra
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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



OT: Off Topic - Blah, Blah, Blah...

2001-05-08 Thread Ed . Haskins

As I type, I'm guilty of committing what I'm about to rant about...

It's not much of a "rant", but...

I, like many on this list (ORACLE-L), subscribe and participate in both this
and the Lazy-DBA list.  Is it just me, or does this list (ORACLE-L) have way
more Off Topic posts??  I don't mean Off Topic as in: "UNIX vs. NT" or
"Should I learn Java or C# to enhance my skills?", but rather...well, I
think you know what I mean.  I'm not necessarily complaining, just making an
observation!!

Ed Haskins
Oracle DBA
Verizon Wireless


-Original Message-
Sent: Tuesday, May 08, 2001 1:26 PM
To: Multiple recipients of list ORACLE-L


I have been informed privately that some may find this remark offensive,
perhaps even deeply so. 

For those people:  "Sorry!, that wasn't my intent."

|| -Original Message-
|| From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 08, 2001 12:23 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: OT RE: Taking your time when a crisis occurs
|| 
|| 
|| Barbie doesn't talk when he takes her
|| clothes off. 
|| 
|| || -Original Message-
|| || From: David A. Barbour [mailto:[EMAIL PROTECTED]]
|| || Sent: Monday, May 07, 2001 10:35 PM
|| || To: Multiple recipients of list ORACLE-L
|| || Subject: Re: Taking your time when a crisis occurs
|| || 
|| || 
|| || Eric,
|| || 
|| || What's with you and Barbie?
|| || 
|| || David A. Barbour
|| || 
|| || "Eric D. Pierce" wrote:
|| || > 
|| || >  RE: Taking your time when a crisis occurs
|| || > 
|| || > -
|| || > 
|| || > http://www.amazon.com/exec/obidos/ASIN2/B4SU3E
|| || > 
|| || > Barbie as Glinda from The Wizard of Oz
|| || > 
|| || > 
|| || > Our Price: $19.99
|| || > Availability: Usually ships within 24 hours.
|| || > 
|| || > Manufacturer's age: 3 years and up
|| || > Shipping: Currently, item can be shipped only within the U.S.
|| || > Shipping weight: 0.7 pounds.
|| || > Note: Giftwrapping not available for this item.
|| || > Packaging: This item may be delivered in the 
|| || manufacturer's original
|| || > packaging, which could reveal the contents of the box.
|| || > ASIN: B4SU3E
|| || > 
|| || > 
|| || > 
|| || > >From Toysrus.com & Amazon.com
|| || > Editorial Review
|| || > 
|| || > "Are you a good witch or a bad witch?" A good witch, of 
|| course--and
|| || > pretty as well! Dressed as Glinda, the good witch of 
|| the North from
|| || > the beloved book and movie The Wizard of Oz, Barbie is 
|| welcomed to
|| || > Munchkinland. She has long, curly strawberry-blonde hair 
|| || topped by a
|| || > tall lavender-pink crown, and she's wearing a sparkling 
|| pink satin
|| || > ball gown ornamented with silver stars and butterflies. 
|| || She also has
|| || > on a silver braided belt. Her outfit is completed with 
|| || pink heels and
|| || > a long, lavender magic wand that fits in her hand. Raise 
|| || her arm (or
|| || > press the button on her back), and you'll hear the 
|| wand's magical
|| || > "brrinnng!" sound or Glinda's voice saying, "Tap your 
|| || heels together
|| || > three times." Sound effects are produced by three 
|| included button
|| || > cell batteries, which can be replaced. Say it again, 
|| || Glinda, just so
|| || > we'll never forget: "There's no place like home." 
|| --Marcie Bovetz
|| || > Safety Information
|| || > Choking hazard: Small parts. Not for children under 3 years.
|| || > 
|| || > -
|| || > 
|| || > On 7 May 2001, at 10:21, Marianne Brooks wrote:
|| || > 
|| || > > Hmm, shaved head, why didn't I think of that?  I would 
|| || imagine a woman with
|| || > > a shaved head might be as effective...add a tatoo, some 
|| || leather pants and a
|| || > > scowl and I've got a new me! :-)
|| || > 
|| || > ...
|| || > 
|| || > --
|| || > Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| || > --
|| || > Author: Eric D. Pierce
|| || >   INET: [EMAIL PROTECTED]
|| || > 
|| || > Fat City Network Services-- (858) 538-5051  FAX: 
|| (858) 538-5051
|| || > San Diego, California-- Public Internet access / 
|| || Mailing Lists
|| || > 
|| || 
|| 
|| || > To REMOVE yourself from this mailing list, send an 
|| E-Mail message
|| || > to: [EMAIL PROTECTED] (note EXACT spelling of 
|| 'ListGuru') and in
|| || > the message BODY, include a line containing: UNSUB ORACLE-L
|| || > (or the name of mailing list you want to be removed 
|| from).  You may
|| || > also send the HELP command for other information (like 
|| || subscribing).
|| || -- 
|| || Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| || -- 
|| || Author: David A. Barbour
|| ||   INET: [EMAIL PROTECTED]
|| || 
|| || Fat City Network Services-- (858) 538-5051  FAX: 
|| (858) 538-5051
|| || San Diego, California-- Public Internet access / 
|| || Mailing Lists
|| || 
|| 
|| || To REMOVE yourself from this mailing lis

RE: sorry,

2001-05-08 Thread Rachel Carmichael

knowing you, you just tossed it off in under 15 minutes :)


>From: "Mohan, Ross" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: sorry,
>Date: Tue, 08 May 2001 08:15:29 -0800
>
>Jared,
>
>:) Thanks
>
>But, how long do you think it took to write this?
>
>Seriously...
>
>Ross
>
>
>
>|| -Original Message-
>|| From: Jared Still [mailto:[EMAIL PROTECTED]]
>|| Sent: Monday, May 07, 2001 9:11 PM
>|| To: Multiple recipients of list ORACLE-L
>|| Subject: Re: sorry,
>||
>||
>||
>|| ROFLMAO!
>||
>|| Geez Ross, do you really have a job?
>||
>|| Like, when do you *work*?
>||
>|| Or is this it?
>||
>|| Jared
>||
>||
>|| PS.  Bruce is more likely to kick you off than I am, and
>|| Jesus doesn't care.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Mohan, Ross
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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



RE: sorry,

2001-05-08 Thread Rachel Carmichael

knowing you, you just tossed it off in under 15 minutes :)


>From: "Mohan, Ross" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: sorry,
>Date: Tue, 08 May 2001 08:15:29 -0800
>
>Jared,
>
>:) Thanks
>
>But, how long do you think it took to write this?
>
>Seriously...
>
>Ross
>
>
>
>|| -Original Message-
>|| From: Jared Still [mailto:[EMAIL PROTECTED]]
>|| Sent: Monday, May 07, 2001 9:11 PM
>|| To: Multiple recipients of list ORACLE-L
>|| Subject: Re: sorry,
>||
>||
>||
>|| ROFLMAO!
>||
>|| Geez Ross, do you really have a job?
>||
>|| Like, when do you *work*?
>||
>|| Or is this it?
>||
>|| Jared
>||
>||
>|| PS.  Bruce is more likely to kick you off than I am, and
>|| Jesus doesn't care.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Mohan, Ross
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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



  1   2   >