RE: Oracle books
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
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?
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?
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
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...
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
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
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
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
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
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
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
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
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
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
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
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
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,
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?
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
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
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
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...
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
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,
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
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...
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
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
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
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,
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
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
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,
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,
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,
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,
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,
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
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
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,
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,
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
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,
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,
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...
--- 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
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
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,
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,
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,
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
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
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,
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
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
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,
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
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
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
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
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!!
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
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
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
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...
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
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...
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
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...
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,
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...
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,
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
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?
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...
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
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...
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
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
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
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,
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
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...
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
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 ???
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,
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
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
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
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
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
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
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
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?
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
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...
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,
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,
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).
