RE: [Fwd: ! READ THIS - Oracle-L@fatcity.com is shutting down as
Jared Still scribbled on the wall in glitter crayon: A repost of a previous message. This is the last day for this address folks. good-bye fatcity my old friend, won't get to talk to you again... -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] This planet has -- or rather had -- a problem, which was this: most of the people living on it were unhappy for pretty much of the time. Many solutions were suggested for this problem, but most of these were largely concerned with the movements of small green pieces of paper, which is odd because on the whole it wasn't the small green pieces of paper that were unhappy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [Fwd: ! READ THIS - Oracle-L@fatcity.com is shutting down as
last post(its kinda like first post on slashdot.org) joe Thater, William wrote: Jared Still scribbled on the wall in glitter crayon: A repost of a previous message. This is the last day for this address folks. good-bye fatcity my old friend, won't get to talk to you again... -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] This planet has -- or rather had -- a problem, which was this: most of the people living on it were unhappy for pretty much of the time. Many solutions were suggested for this problem, but most of these were largely concerned with the movements of small green pieces of paper, which is odd because on the whole it wasn't the small green pieces of paper that were unhappy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Fwd: ! READ THIS - Oracle-L@fatcity.com is shutting down as
So, is anyone posting on the new list? I believe that I'm subscribed there but I'm only getting fatcity posts. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [Fwd: ! READ THIS - Oracle-L@fatcity.com is shutting down as
Jared, I think you should ask the maintainers of orafaq.com to update their information about oracle-l as well, it's the first hit in google when you search for oracle-l. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 30, 2004 5:44 PM Jared Still scribbled on the wall in glitter crayon: A repost of a previous message. This is the last day for this address folks. good-bye fatcity my old friend, won't get to talk to you again... -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] This planet has -- or rather had -- a problem, which was this: most of the people living on it were unhappy for pretty much of the time. Many solutions were suggested for this problem, but most of these were largely concerned with the movements of small green pieces of paper, which is odd because on the whole it wasn't the small green pieces of paper that were unhappy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [Fwd: ! READ THIS - Oracle-L@fatcity.com is shutting down as
Thanks Tanel, Frank is on top of it already. Jared Tanel Poder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/30/2004 08:24 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: [Fwd: ! READ THIS - [EMAIL PROTECTED] is shutting down as Jared, I think you should ask the maintainers of orafaq.com to update their information about oracle-l as well, it's the first hit in google when you search for oracle-l. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 30, 2004 5:44 PM Jared Still scribbled on the wall in glitter crayon: A repost of a previous message. This is the last day for this address folks. good-bye fatcity my old friend, won't get to talk to you again... -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] This planet has -- or rather had -- a problem, which was this: most of the people living on it were unhappy for pretty much of the time. Many solutions were suggested for this problem, but most of these were largely concerned with the movements of small green pieces of paper, which is odd because on the whole it wasn't the small green pieces of paper that were unhappy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Fwd: ! READ THIS - Oracle-L@fatcity.com is shutting down as of
RIP old friend! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, January 29, 2004 12:24 PM To: Multiple recipients of list ORACLE-L A repost of a previous message. This is the last day for this address folks. --- [EMAIL PROTECTED] is shutting down as of 1/31/2004 If you have already subscribed to the new location for Oracle-L, then you may discard this message. To those of you still reading: [EMAIL PROTECTED] will be offline as of 1/31/2004. You will not longer receive posts from Oracle-L as of 1/31/2004, and you will not be able to post to [EMAIL PROTECTED] as of 1/31/2004. The last day for this address is 1/30/2004. The new address is [EMAIL PROTECTED], and instructions for subscribing to the new address may be found at the following URL: http://www.cybcon.com/~jkstill/util/maillist/maillist.html Thanks for reading. Jared ( List Owner ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[Fwd: ! READ THIS - Oracle-L@fatcity.com is shutting down as of
A repost of a previous message. This is the last day for this address folks. --- [EMAIL PROTECTED] is shutting down as of 1/31/2004 If you have already subscribed to the new location for Oracle-L, then you may discard this message. To those of you still reading: [EMAIL PROTECTED] will be offline as of 1/31/2004. You will not longer receive posts from Oracle-L as of 1/31/2004, and you will not be able to post to [EMAIL PROTECTED] as of 1/31/2004. The last day for this address is 1/30/2004. The new address is [EMAIL PROTECTED], and instructions for subscribing to the new address may be found at the following URL: http://www.cybcon.com/~jkstill/util/maillist/maillist.html Thanks for reading. Jared ( List Owner ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fwd: UTL_FILE_DIR on 9iR2
Ah! - got it. To simplify my question I hadn't mentioned that I had more than one allowed directory, and this was where the problem lay: I did: ALTER SYSTEM SET UTL_FILE_DIR = 'directory1, directory2' SCOPE=spfile; Whereas what is required is: ALTER SYSTEM SET UTL_FILE_DIR = 'directory1','directory2' SCOPE=spfile; The first form is accepted by Oracle and looks ok in v$parameter but clearly doesn't do the same thing underneath! Good: this means I can delay implementing DIRECTORYs for a bit longer... (not that I don't want to use them, just that other things have priority) - Bill Date: Fri, 16 Jan 2004 11:15:35 + To: [EMAIL PROTECTED] From: Bill Buchan [EMAIL PROTECTED] Subject: UTL_FILE_DIR on 9iR2 Hi all, I'm looking for some clarification on UTL_FILE_DIR on 9.2. I understand that this parameter is obsolete (Metalink Note 196939.1) and that CREATE DIRECTORY should be used instead. However we wanted to persist with the old method since we already have lots of existing PL/SQL that uses a look up table to decide where to read/write files; yes we'd move to CREATE DIRECTORY eventually but not right now. I thought that although UTL_FILE_DIR was obsolete it was really just deprecated and we could continue using it as before. If UTL_FILE_DIR = '*' then all is indeed well. However if I try to restrict the directories, i.e. UTL_FILE_DIR = '/only/allowed/here' then it does not work (yes, checked filesystem privs). ERROR at line 1: ORA-29280: invalid directory path ORA-06512: at SYS.UTL_FILE, line 18 ORA-06512: at SYS.UTL_FILE, line 424 ORA-06512: at line 4 I can sort of fudge it to work: SQL create directory /only/allowed/here as '/only/allowed/here'; Directory created. SQL grant read on directory /only/allowed/here to public; Grant succeeded. It's annoying to have to create directories with quoted names the same as the paths. Have I missed something or am I just going to have to use CREATE DIRECTORY like this until we have an opportunity to change the PL/SQL? Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[Fwd: Joseph Testa has sent you a 10% discount]
In case any of you are contemplating purchasing Murali's book. joe Original Message Date: Fri, 9 Jan 2004 13:18:19 -0800 To: [EMAIL PROTECTED] Joseph Testa (your thoughtful pal) just bought the following item at Amazon.com and is using our Share the Love program to pass along an additional 10% discount to you. Click the links below to see more product information on your discount list and purchase the following item by *January 16, 2004*. You'll receive an additional 10% discount, thanks to Joseph Testa and Share the Love: http://www.amazon.com/exec/obidos/redirect?tag=love102-20path=stl/2RP8U8SKQ3DLS *Oracle Real Application Clusters http://www.amazon.com/exec/obidos/redirect?tag=love102-20path=stl/2RP8U8SKQ3DLS* by Murali Vallath (Author) ; Paperback Average Customer Review: See all of your discounted items http://www.amazon.com/exec/obidos/redirect?tag=love102-20path=stl/2RP8U8SKQ3DLS Plus, each item you buy may earn Joseph Testa credit toward future Amazon.com purchases. So you save money, Joseph Testa saves money--gee, ain't love grand? (But hurry, this offer expires on January 16, 2004.) Please note that Joseph Testa requested that we send you this savings invitation (but don't worry--since you're Joseph Testa 's friend, we won't use your e-mail address for anything else). If you have additional questions about how the Share the Love program works, please visit our Help department http://www.amazon.com/exec/obidos/tg/browse/-/583406/. Amazon.com Earth's Biggest Selection Find, Discover, and Buy Virtually Anything http://www.amazon.com Please note that this message was sent to the following e-mail address: [EMAIL PROTECTED] To opt out of receiving Share the Love offer e-mails, please visit: http://www.amazon.com/manage-stl-email http://www.amazon.com/exec/obidos/flex-sign-in?opt=apage=misc/login/flex-sign-in-secure.htmlresponse=subst/stores/share-the-love/email-management.html -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [Fwd: Joseph Testa has sent you a 10% discount]
I had I love you and The Latest Security Patch from Microsoft emails stored in my crap folder on my home Linux box but I've recently cleaned it. It might be a good idea to make people on this list feel loved and secure. On 01/09/2004 04:24:29 PM, Joe Testa wrote: In case any of you are contemplating purchasing Murali's book. joe Original Message Date: Fri, 9 Jan 2004 13:18:19 -0800 To: [EMAIL PROTECTED] Joseph Testa (your thoughtful pal) just bought the following item at Amazon.com and is using our Share the Love program to pass along an additional 10% discount to you. Click the links below to see more product information on your discount list and purchase the following item by *January 16, 2004*. You'll receive an additional 10% discount, thanks to Joseph Testa and Share the Love: http://www.amazon.com/exec/obidos/redirect?tag=love102-20path=stl/2RP8U8SKQ3DLS *Oracle Real Application Clusters http://www.amazon.com/exec/obidos/redirect?tag=love102-20path=stl/2RP8U8SKQ3DLS* by Murali Vallath (Author) ; Paperback Average Customer Review: See all of your discounted items http://www.amazon.com/exec/obidos/redirect?tag=love102-20path=stl/2RP8U8SKQ3DLS Plus, each item you buy may earn Joseph Testa credit toward future Amazon.com purchases. So you save money, Joseph Testa saves money--gee, ain't love grand? (But hurry, this offer expires on January 16, 2004.) Please note that Joseph Testa requested that we send you this savings invitation (but don't worry--since you're Joseph Testa 's friend, we won't use your e-mail address for anything else). If you have additional questions about how the Share the Love program works, please visit our Help department http://www.amazon.com/exec/obidos/tg/browse/-/583406/. Amazon.com Earth's Biggest Selection Find, Discover, and Buy Virtually Anything http://www.amazon.com Please note that this message was sent to the following e-mail address: [EMAIL PROTECTED] To opt out of receiving Share the Love offer e-mails, please visit: http://www.amazon.com/manage-stl-email http://www.amazon.com/exec/obidos/flex-sign-in?opt=apage=misc/login/flex-sign-in-secure.htmlresponse=subst/stores/share-the-love/email-management.html -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [Fwd: Joseph Testa has sent you a 10% discount]
What I love is the discount of 43% off at Bookpool.com. That text is only 30% off there. Amazon lost my business way back when the 1-click patent waste matter went down. Pd --- Mladen Gogala [EMAIL PROTECTED] wrote: I had I love you and The Latest Security Patch from Microsoft emails stored in my crap folder on my home Linux box but I've recently cleaned it. It might be a good idea to make people on this list feel loved and secure. On 01/09/2004 04:24:29 PM, Joe Testa wrote: In case any of you are contemplating purchasing Murali's book. joe Original Message Date: Fri, 9 Jan 2004 13:18:19 -0800 To: [EMAIL PROTECTED] Joseph Testa (your thoughtful pal) just bought the following item at Amazon.com and is using our Share the Love program to pass along an additional 10% discount to you. Click the links below to see more product information on your discount list and purchase the following item by *January 16, 2004*. You'll receive an additional 10% discount, thanks to Joseph Testa and Share the Love: http://www.amazon.com/exec/obidos/redirect?tag=love102-20path=stl/2RP8U8SKQ3DLS *Oracle Real Application Clusters http://www.amazon.com/exec/obidos/redirect?tag=love102-20path=stl/2RP8U8SKQ3DLS* by Murali Vallath (Author) ; Paperback Average Customer Review: See all of your discounted items http://www.amazon.com/exec/obidos/redirect?tag=love102-20path=stl/2RP8U8SKQ3DLS Plus, each item you buy may earn Joseph Testa credit toward future Amazon.com purchases. So you save money, Joseph Testa saves money--gee, ain't love grand? (But hurry, this offer expires on January 16, 2004.) Please note that Joseph Testa requested that we send you this savings invitation (but don't worry--since you're Joseph Testa 's friend, we won't use your e-mail address for anything else). If you have additional questions about how the Share the Love program works, please visit our Help department http://www.amazon.com/exec/obidos/tg/browse/-/583406/. Amazon.com Earth's Biggest Selection Find, Discover, and Buy Virtually Anything http://www.amazon.com Please note that this message was sent to the following e-mail address: [EMAIL PROTECTED] To opt out of receiving Share the Love offer e-mails, please visit: http://www.amazon.com/manage-stl-email http://www.amazon.com/exec/obidos/flex-sign-in?opt=apage=misc/login/flex-sign-in-secure.htmlresponse=subst/stores/share-the-love/email-management.html -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
Fwd: Usage error in your E-mail to mailing list 'ORACLE-L' [Postmaster@fatcity.com]
On 2004.01.06 13:59, Mailing List Administrator wrote: *** IT IS IMPORTANT THAT YOU READ THIS MESSAGE *** Your message is being returned to you because of an error in your usage. The mailing list address you sent your message to was: Address: [EMAIL PROTECTED] Description: Oracle RDBMS Community Forum Subject: Re: Top level heaps/subheaps Your posting has been rejected and returned to you because it appeared to be a vacation auto-reply message. If you have received only one of these notices, then please consider this a courtesy notice. If you received more than one of these (perhaps many of these) notices, then your auto-reply program is not cognizent of proper mail ettiquette and you must heed these instructions in future situations like this. While you have an auto-reply responder turned on, all messages which are auto-replied to the mailing list are sent to your mailbox AGAIN, resulting in a quickly increasing endless-loop condition. This not only causes YOUR mailbox to fill up, but it fills the mailboxes of every person who is a subscriber to the list. This filter was put into place to avoid these types of endless-loop situations, and stop them before they get started. A more effective way of dealing with being on vacation is to TEMPORARILY turn off messages from the mailing list. This doesn't require you to unsubscribe -- it merely temporarily stops the flow of messages to your mailbox while you are gone. In order to stop mailing list messages temporarily, send an E-mail message to: [EMAIL PROTECTED] And in the message BODY, include the following command: SET mailing list name NOMAIL Where mailing list name is the name of the mailing list for which you are a subscriber. Note that you can use this at ANY time, and for any reason, not just for vacations. Once you have returned from vacation, issue the following command to resume mail service again: SET mailing list name MAIL If you use the two commands above, once before you leave, and then again after you return, everyone will appreciate your consideration and respect for the list. If you need to know which lists you are subscribed to, use the following command: WHICH And finally, any time you need assistance with ListGuru, send the HELP command in the message body for detailed help on using ListGuru. The body of your original message is being returned to you below. Thank you, [EMAIL PROTECTED] - begin returned message - On 2004.01.06 13:39, Wolfgang Breitling wrote: Welcome back. I was wondering where you've been the last couple of weeks. Thanks, Wolfgang. I was on vacation. Last night I flew in (JFK) with Air France. An experience I don't want to talk about. I hope it's still not too late to wish everybody a happy New Year? -- Mladen Gogala Oracle DBA - end returned message - -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fwd: Stored Outline Problem
Additional information: The problem described below occurs on 9.2.0.4 (Linux). I have just tried re-producing on 8.1.7.4 (Solaris) and it actually worked fine there (hash values in ol$ and v$sql matched). Once again, any input welcome. Thanks, - Bill. Hi all, I'm trying to set up stored outlines and am running into the following problem (OUTLN tables are initially empty and the shared pool has just been flushed): ALTER SESSION SET CREATE_STORED_OUTLINES = TRUE; SELECT 'THISISMYTEST' FROM DUAL; ALTER SESSION SET CREATE_STORED_OUTLINES = FALSE; SQL SELECT HASH_VALUE,SQL_TEXT FROM OUTLN.OL$; HASH_VALUE SQL_TEXT -- 1024768383 SELECT 'THISISMYTEST' FROM DUAL SQL SELECT HASH_VALUE,SQL_TEXT FROM V$SQL WHERE SQL_TEXT LIKE '%THISISMYTEST%'; HASH_VALUE SQL_TEXT -- 2081312514 SELECT 'THISISMYTEST' FROM DUAL 2452395670 SELECT HASH_VALUE,SQL_TEXT FROM V$SQL WHERE SQL_TEXT LIKE '% THISISMYTEST%' Now (as expected) there is now one row in OUTLN.OL$ but the HASH_VALUE != the HASH_VALUE for the given SELECT statement in v$sql. In fact the HASH_VALUE doesn't match anything in v$sql. Obviously (and demonstratively) the outline will not be used if the query hashes to a different value that the outline. Am I missing something? (CREATE ANY OUTLINE is granted) Thanks for any help, - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: Stored Outline Problem
Bill, I tried your example on my systems. On Sun solaris 9.2.0.4 has the same issue of non matching hash values. Sun Solaris 8.1.7.3 has matching hash_values.Bill Buchan [EMAIL PROTECTED] wrote: Additional information:The problem described below occurs on 9.2.0.4 (Linux).I have just tried re-producing on 8.1.7.4 (Solaris) and it actually worked fine there (hash values in ol$ and v$sql matched).Once again, any input welcome.Thanks,- Bill.Hi all,I'm trying to set up stored outlines and am running into the following problem (OUTLN tables are initially empty and the shared pool has just been flushed):ALTER SESSION SET CREATE_STORED_OUTLINES = TRUE;SELECT 'THISISMYTEST' FROM DUAL;ALTER SESSION SET CREATE_STORED_OUTLINES = FALSE;SQL SELECT HASH_VALUE,SQL_TEXT FROM OUTLN.OL$;HASH_VALUE SQL_TEXT-- 1024768383 SEL! ECT 'THISISMYTEST' FROM DUALSQL SELECT HASH_VALUE,SQL_TEXT FROM V$SQL WHERE SQL_TEXT LIKE '%THISISMYTEST%';HASH_VALUE SQL_TEXT-- 2081312514 SELECT 'THISISMYTEST' FROM DUAL2452395670 SELECT HASH_VALUE,SQL_TEXT FROM V$SQL WHERE SQL_TEXT LIKE '% THISISMYTEST%'Now (as expected) there is now one row in OUTLN.OL$ but the HASH_VALUE != the HASH_VALUE for the given SELECT statement in v$sql. In fact the HASH_VALUE doesn't match anything in v$sql.Obviously (and demonstratively) the outline will not be used if the query hashes to a different value that the outline. Am I missing something? (CREATE ANY OUTLINE is granted)Thanks for any help,- Bill.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Bill BuchanINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
Fwd: Looking for help.
I don't usually forward my reader email to the list, but the question below strikes me as rather interesting. In this case, SQL*Loader appears to be causing all SQL statements that refer to the table being loaded to be invalidated. Is this normal behavior? Does anyone know why it might be the case? -- Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Wednesday, November 12, 2003, 1:07:41 AM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: Hi Jonathan, I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. We are using Oracle 9i sqlldr, direct path to load data from external files into staging tables. After data is loaded, we invoked stored procedures to transform data and move them to the target tables. The steps are: 1. delete all entries from 20 staging tables 2. invoke sqlldr userid=dbimpl/dbimpl control=controlFile direct=true to load data to all 20 staging tables 3. invoke stored procedures to transform data from the staging tables to the final tables. Currently these stored procedures are standalone. 4. invoke stored procedures to remove out-of-date entries from the final tables. I monitor invalidations column in v$sqlarea. Every time after sqlldr is invoked for data loading (step 2), all the sql statements that reference the staging tables are invalidated, including delete from stageing_table sql statement. I setup a test and used a java program to loop steps 1-4 every ~2 minutes. There were no other activities in the database except data loading and transformation. After a couple days, I got the following error: ORA-04031: unable to allocate 4212 bytes of shared memory (shared pool,unknown object,sga heap(1,0),stat array mem) The questions are: 1. Do we need to delete entries in the staging table prior to loading. Will sqlldr remove the entires in the staging table first prior to loading? 2. There are no changes in the stored procedures, how / why sqlldr would invalidate the sql statement in the stored procedures? 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? I would appreciate if you can send me some pointers or suggestions. Thanks, KamYee -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: Looking for help.
I wonder whether the invalidation comes about from the use of TRUNCATE, which is considered a DDL statement. I'd guess that any DDL to a table would invalidate existing SQL statements. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Wednesday, November 12, 2003, 8:34:24 AM, Jonathan Gennick ([EMAIL PROTECTED]) wrote: JG I don't usually forward my reader email to the list, but the JG question below strikes me as rather interesting. In this JG case, SQL*Loader appears to be causing all SQL statements JG that refer to the table being loaded to be invalidated. Is JG this normal behavior? Does anyone know why it might be the JG case? JG -- JG Best regards, JG Jonathan Gennick --- Brighten the corner where you are JG http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] JG Join the Oracle-article list and receive one JG article on Oracle technologies per month by JG email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, JG or send email to [EMAIL PROTECTED] and JG include the word subscribe in either the subject or body. JG Wednesday, November 12, 2003, 1:07:41 AM, JG [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: JG Hi Jonathan, JG I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. JG We are using Oracle 9i sqlldr, direct path to load data from external files into JG staging tables. After data is loaded, we invoked stored procedures to JG transform data and move them to the target tables. The steps are: JG 1. delete all entries from 20 staging tables JG 2. invoke sqlldr userid=dbimpl/dbimpl control=controlFile direct=true to JG load data to all 20 staging tables JG 3. invoke stored procedures to transform data from the staging tables to the JG final tables. Currently these stored procedures are standalone. JG 4. invoke stored procedures to remove out-of-date entries from the final JG tables. JG I monitor invalidations column in v$sqlarea. Every time JG after sqlldr is invoked for data loading (step 2), all the JG sql statements that reference the staging tables are JG invalidated, including delete from stageing_table sql JG statement. I setup a test and used a java program to loop JG steps 1-4 every ~2 minutes. There were no other activities JG in the database except data loading and transformation. JG After a couple days, I got the following error: ORA-04031: JG unable to allocate 4212 bytes of shared memory (shared JG pool,unknown object,sga heap(1,0),stat array mem) JG The questions are: JG 1. Do we need to delete entries in the staging table prior to loading. Will JG sqlldr remove the entires in the staging table first prior to loading? JG 2. There are no changes in the stored procedures, how / why sqlldr would JG invalidate the sql statement in the stored procedures? JG 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? JG I would appreciate if you can send me some pointers or suggestions. JG Thanks, JG KamYee JG -- JG Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: Looking for help.
IIRC, direct path loads invalidate indexes. As the execution plan may use this index, it makes sense that any statements referencing these tables will be invalidated and need to be reparsed. I've never tested this, but it makes sense (at least Oracle sense). As for the 4031 errors, could they be related to the reloading of the dictionary cache? I can't quite reason this one out, but it's early here in the Rockies and a storm is blowing in (feel free to hum Ridin' The Storm Out by REO Speedwagon). Daniel Fink Jonathan Gennick wrote: I don't usually forward my reader email to the list, but the question below strikes me as rather interesting. In this case, SQL*Loader appears to be causing all SQL statements that refer to the table being loaded to be invalidated. Is this normal behavior? Does anyone know why it might be the case? -- Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Wednesday, November 12, 2003, 1:07:41 AM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: Hi Jonathan, I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. We are using Oracle 9i sqlldr, direct path to load data from external files into staging tables. After data is loaded, we invoked stored procedures to transform data and move them to the target tables. The steps are: 1. delete all entries from 20 staging tables 2. invoke sqlldr userid=dbimpl/dbimpl control=controlFile direct=true to load data to all 20 staging tables 3. invoke stored procedures to transform data from the staging tables to the final tables. Currently these stored procedures are standalone. 4. invoke stored procedures to remove out-of-date entries from the final tables. I monitor invalidations column in v$sqlarea. Every time after sqlldr is invoked for data loading (step 2), all the sql statements that reference the staging tables are invalidated, including delete from stageing_table sql statement. I setup a test and used a java program to loop steps 1-4 every ~2 minutes. There were no other activities in the database except data loading and transformation. After a couple days, I got the following error: ORA-04031: unable to allocate 4212 bytes of shared memory (shared pool,unknown object,sga heap(1,0),stat array mem) The questions are: 1. Do we need to delete entries in the staging table prior to loading. Will sqlldr remove the entires in the staging table first prior to loading? 2. There are no changes in the stored procedures, how / why sqlldr would invalidate the sql statement in the stored procedures? 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? I would appreciate if you can send me some pointers or suggestions. Thanks, KamYee -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: Looking for help.
Is there a primary key on the table ? Regards, Denny Jonathan Gennick wrote: I don't usually forward my reader email to the list, but the question below strikes me as rather interesting. In this case, SQL*Loader appears to be causing all SQL statements that refer to the table being loaded to be invalidated. Is this normal behavior? Does anyone know why it might be the case? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denny Koovakattu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: Looking for help.
Jonathan, I don't see where the TRUNCATE command is used in the original request message. The 20 staging tables have a delete action against them. The data is sqlldr action to load the tables. The final tables are loaded from the staging tables using a PL/SQL procedure. The final tables are cleaned up using a PL/SQL procedure. The ORA-04031 is most likely caused by one of the PL/SQL procedures not releasing the memory stack. It takes a few days of loading before the failure occures. I would look into the os and possible the I/O. is it buffered and the sqlldr is looking at the physical not buffered area or vise-versa? Are the table cached? The sqlldr command is run and the previous delete from staging tables commands are invalidated? Is there a change of ownership on the tables at this time? Just a few random thoughts that may or may not invoke someone elses thought process. Ron [EMAIL PROTECTED] 11/12/2003 9:34:33 AM I wonder whether the invalidation comes about from the use of TRUNCATE, which is considered a DDL statement. I'd guess that any DDL to a table would invalidate existing SQL statements. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Wednesday, November 12, 2003, 8:34:24 AM, Jonathan Gennick ([EMAIL PROTECTED]) wrote: JG I don't usually forward my reader email to the list, but the JG question below strikes me as rather interesting. In this JG case, SQL*Loader appears to be causing all SQL statements JG that refer to the table being loaded to be invalidated. Is JG this normal behavior? Does anyone know why it might be the JG case? JG -- JG Best regards, JG Jonathan Gennick --- Brighten the corner where you are JG http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] JG Join the Oracle-article list and receive one JG article on Oracle technologies per month by JG email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, JG or send email to [EMAIL PROTECTED] and JG include the word subscribe in either the subject or body. JG Wednesday, November 12, 2003, 1:07:41 AM, JG [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: JG Hi Jonathan, JG I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. JG We are using Oracle 9i sqlldr, direct path to load data from external files into JG staging tables. After data is loaded, we invoked stored procedures to JG transform data and move them to the target tables. The steps are: JG 1. delete all entries from 20 staging tables JG 2. invoke sqlldr userid=dbimpl/dbimpl control=controlFile direct=true to JG load data to all 20 staging tables JG 3. invoke stored procedures to transform data from the staging tables to the JG final tables. Currently these stored procedures are standalone. JG 4. invoke stored procedures to remove out-of-date entries from the final JG tables. JG I monitor invalidations column in v$sqlarea. Every time JG after sqlldr is invoked for data loading (step 2), all the JG sql statements that reference the staging tables are JG invalidated, including delete from stageing_table sql JG statement. I setup a test and used a java program to loop JG steps 1-4 every ~2 minutes. There were no other activities JG in the database except data loading and transformation. JG After a couple days, I got the following error: ORA-04031: JG unable to allocate 4212 bytes of shared memory (shared JG pool,unknown object,sga heap(1,0),stat array mem) JG The questions are: JG 1. Do we need to delete entries in the staging table prior to loading. Will JG sqlldr remove the entires in the staging table first prior to loading? JG 2. There are no changes in the stored procedures, how / why sqlldr would JG invalidate the sql statement in the stored procedures? JG 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? JG I would appreciate if you can send me some pointers or suggestions. JG Thanks, JG KamYee JG -- JG Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
Re: Fwd: Looking for help.
Jonathan, I don't see where truncate is being invoked, though I am not a big user of sql*loader. Truncate should invalidate statements. Daniel Jonathan Gennick wrote: I wonder whether the invalidation comes about from the use of TRUNCATE, which is considered a DDL statement. I'd guess that any DDL to a table would invalidate existing SQL statements. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Wednesday, November 12, 2003, 8:34:24 AM, Jonathan Gennick ([EMAIL PROTECTED]) wrote: JG I don't usually forward my reader email to the list, but the JG question below strikes me as rather interesting. In this JG case, SQL*Loader appears to be causing all SQL statements JG that refer to the table being loaded to be invalidated. Is JG this normal behavior? Does anyone know why it might be the JG case? JG -- JG Best regards, JG Jonathan Gennick --- Brighten the corner where you are JG http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] JG Join the Oracle-article list and receive one JG article on Oracle technologies per month by JG email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, JG or send email to [EMAIL PROTECTED] and JG include the word subscribe in either the subject or body. JG Wednesday, November 12, 2003, 1:07:41 AM, JG [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: JG Hi Jonathan, JG I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. JG We are using Oracle 9i sqlldr, direct path to load data from external files into JG staging tables. After data is loaded, we invoked stored procedures to JG transform data and move them to the target tables. The steps are: JG 1. delete all entries from 20 staging tables JG 2. invoke sqlldr userid=dbimpl/dbimpl control=controlFile direct=true to JG load data to all 20 staging tables JG 3. invoke stored procedures to transform data from the staging tables to the JG final tables. Currently these stored procedures are standalone. JG 4. invoke stored procedures to remove out-of-date entries from the final JG tables. JG I monitor invalidations column in v$sqlarea. Every time JG after sqlldr is invoked for data loading (step 2), all the JG sql statements that reference the staging tables are JG invalidated, including delete from stageing_table sql JG statement. I setup a test and used a java program to loop JG steps 1-4 every ~2 minutes. There were no other activities JG in the database except data loading and transformation. JG After a couple days, I got the following error: ORA-04031: JG unable to allocate 4212 bytes of shared memory (shared JG pool,unknown object,sga heap(1,0),stat array mem) JG The questions are: JG 1. Do we need to delete entries in the staging table prior to loading. Will JG sqlldr remove the entires in the staging table first prior to loading? JG 2. There are no changes in the stored procedures, how / why sqlldr would JG invalidate the sql statement in the stored procedures? JG 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? JG I would appreciate if you can send me some pointers or suggestions. JG Thanks, JG KamYee JG -- JG Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
Re: Fwd: Looking for help.
Daniel, How does using the TRUNCATE command is a sqlldr invalidate anything? The sqlldr truncate command reuses the storage that the table originally used and does not change the HW mark. If there are indexes on the tables then they are placed in the DIRECT PATH state during the load and updated with the now block info. Please explain whet you mean by invalidate. Ron [EMAIL PROTECTED] 11/12/2003 12:04:35 PM Jonathan, I don't see where truncate is being invoked, though I am not a big user of sql*loader. Truncate should invalidate statements. Daniel Jonathan Gennick wrote: I wonder whether the invalidation comes about from the use of TRUNCATE, which is considered a DDL statement. I'd guess that any DDL to a table would invalidate existing SQL statements. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Wednesday, November 12, 2003, 8:34:24 AM, Jonathan Gennick ([EMAIL PROTECTED]) wrote: JG I don't usually forward my reader email to the list, but the JG question below strikes me as rather interesting. In this JG case, SQL*Loader appears to be causing all SQL statements JG that refer to the table being loaded to be invalidated. Is JG this normal behavior? Does anyone know why it might be the JG case? JG -- JG Best regards, JG Jonathan Gennick --- Brighten the corner where you are JG http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] JG Join the Oracle-article list and receive one JG article on Oracle technologies per month by JG email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, JG or send email to [EMAIL PROTECTED] and JG include the word subscribe in either the subject or body. JG Wednesday, November 12, 2003, 1:07:41 AM, JG [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: JG Hi Jonathan, JG I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. JG We are using Oracle 9i sqlldr, direct path to load data from external files into JG staging tables. After data is loaded, we invoked stored procedures to JG transform data and move them to the target tables. The steps are: JG 1. delete all entries from 20 staging tables JG 2. invoke sqlldr userid=dbimpl/dbimpl control=controlFile direct=true to JG load data to all 20 staging tables JG 3. invoke stored procedures to transform data from the staging tables to the JG final tables. Currently these stored procedures are standalone. JG 4. invoke stored procedures to remove out-of-date entries from the final JG tables. JG I monitor invalidations column in v$sqlarea. Every time JG after sqlldr is invoked for data loading (step 2), all the JG sql statements that reference the staging tables are JG invalidated, including delete from stageing_table sql JG statement. I setup a test and used a java program to loop JG steps 1-4 every ~2 minutes. There were no other activities JG in the database except data loading and transformation. JG After a couple days, I got the following error: ORA-04031: JG unable to allocate 4212 bytes of shared memory (shared JG pool,unknown object,sga heap(1,0),stat array mem) JG The questions are: JG 1. Do we need to delete entries in the staging table prior to loading. Will JG sqlldr remove the entires in the staging table first prior to loading? JG 2. There are no changes in the stored procedures, how / why sqlldr would JG invalidate the sql statement in the stored procedures? JG 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? JG I would appreciate if you can send me some pointers or suggestions. JG Thanks, JG KamYee JG -- JG Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink
Re: Fwd: Looking for help.
KamYee, Can we take a look at the SQL*Loader control file? Also the output of select * from v$sql where lower(sql_text) like '%yourstagingtable%' and invalidations 0 Yong Huang --- Jonathan Gennick [EMAIL PROTECTED] wrote: I wonder whether the invalidation comes about from the use of TRUNCATE, which is considered a DDL statement. I'd guess that any DDL to a table would invalidate existing SQL statements. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Wednesday, November 12, 2003, 8:34:24 AM, Jonathan Gennick ([EMAIL PROTECTED]) wrote: JG I don't usually forward my reader email to the list, but the JG question below strikes me as rather interesting. In this JG case, SQL*Loader appears to be causing all SQL statements JG that refer to the table being loaded to be invalidated. Is JG this normal behavior? Does anyone know why it might be the JG case? JG -- JG Best regards, JG Jonathan Gennick --- Brighten the corner where you are JG http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] JG Join the Oracle-article list and receive one JG article on Oracle technologies per month by JG email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, JG or send email to [EMAIL PROTECTED] and JG include the word subscribe in either the subject or body. JG Wednesday, November 12, 2003, 1:07:41 AM, JG [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: JG Hi Jonathan, JG I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. JG We are using Oracle 9i sqlldr, direct path to load data from external files into JG staging tables. After data is loaded, we invoked stored procedures to JG transform data and move them to the target tables. The steps are: JG 1. delete all entries from 20 staging tables JG 2. invoke sqlldr userid=dbimpl/dbimpl control=controlFile direct=true to JG load data to all 20 staging tables JG 3. invoke stored procedures to transform data from the staging tables to the JG final tables. Currently these stored procedures are standalone. JG 4. invoke stored procedures to remove out-of-date entries from the final JG tables. JG I monitor invalidations column in v$sqlarea. Every time JG after sqlldr is invoked for data loading (step 2), all the JG sql statements that reference the staging tables are JG invalidated, including delete from stageing_table sql JG statement. I setup a test and used a java program to loop JG steps 1-4 every ~2 minutes. There were no other activities JG in the database except data loading and transformation. JG After a couple days, I got the following error: ORA-04031: JG unable to allocate 4212 bytes of shared memory (shared JG pool,unknown object,sga heap(1,0),stat array mem) JG The questions are: JG 1. Do we need to delete entries in the staging table prior to loading. Will JG sqlldr remove the entires in the staging table first prior to loading? JG 2. There are no changes in the stored procedures, how / why sqlldr would JG invalidate the sql statement in the stored procedures? JG 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? JG I would appreciate if you can send me some pointers or suggestions. JG Thanks, JG KamYee __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: Looking for help.
Ron, I don't know about the TRUNCATE option w/ sql*loader, but the regular DDL TRUNCATE invalidates sql that references the table. Example: 1 select sql_text, invalidations 2 from v$sql 3* where sql_text = 'select * from emp' SQL / SQL_TEXT INVALIDATIONS -- - select * from emp 0 SQL truncate table emp; Table truncated. SQL select sql_text, invalidations 2 from v$sql 3 where sql_text = 'select * from emp' 4 / SQL_TEXT INVALIDATIONS -- - select * from emp 1 Ron Rogers wrote: Daniel, How does using the TRUNCATE command is a sqlldr invalidate anything? The sqlldr truncate command reuses the storage that the table originally used and does not change the HW mark. If there are indexes on the tables then they are placed in the DIRECT PATH state during the load and updated with the now block info. Please explain whet you mean by invalidate. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: Looking for help.
Yep, truncate invalidates parsed SQL: SQL select count(*) from t3; COUNT(*)-- 0 SQL select sql_text, optimizer_mode, invalidations from v$sql where sql_text like '%select count(*) from t3%'and sql_text not like '%v$sql%'; SQL_TEXT OPTIMIZER_ INVALIDATIONS -- -select count(*) from t3 CHOOSE 1 SQL truncate table t3; Table truncated. SQL select sql_text, optimizer_mode, invalidations from v$sql where sql_text like '%select count(*) from t3%'and sql_text not like '%v$sql%'; SQL_TEXT OPTIMIZER_ INVALIDATIONS -- -select count(*) from t3 NONE 2 Tanel. - Original Message - From: "Jonathan Gennick" [EMAIL PROTECTED] To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 4:34 PM Subject: Re: Fwd: Looking for help. I wonder whether the invalidation comes about from the use of TRUNCATE, which is considered a DDL statement. I'd guess that any DDL to a table would invalidate existing SQL statements. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word "subscribe" in either the subject or body. Wednesday, November 12, 2003, 8:34:24 AM, Jonathan Gennick ([EMAIL PROTECTED]) wrote: JG I don't usually forward my reader email to the list, but the JG question below strikes me as rather interesting. In this JG case, SQL*Loader appears to be causing all SQL statements JG that refer to the table being loaded to be invalidated. Is JG this normal behavior? Does anyone know why it might be the JG case? JG -- JG Best regards, JG Jonathan Gennick --- Brighten the corner where you are JG http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] JG Join the Oracle-article list and receive one JG article on Oracle technologies per month by JG email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, JG or send email to [EMAIL PROTECTED] and JG include the word "subscribe" in either the subject or body. JG Wednesday, November 12, 2003, 1:07:41 AM, JG [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: JG Hi Jonathan, JG I was unable to find the answers from your book "SQL*Loader: The Definitive Guide" and the web. I am running out of sources. I hope you can help me with the following questions. JG We are using Oracle 9i sqlldr, direct path to load data from external files into JG staging tables. After data is loaded, we invoked stored procedures to JG transform data and move them to the target tables. The steps are: JG 1. delete all entries from 20 staging tables JG 2. invoke "sqlldr userid=dbimpl/dbimpl control=controlFile direct=true" to JG load data to all 20 staging tables JG 3. invoke stored procedures to transform data from the staging tables to the JG final tables. Currently these stored procedures are standalone. JG 4. invoke stored procedures to remove out-of-date entries from the final JG tables. JG I monitor invalidations column in v$sqlarea. Every time JG after sqlldr is invoked for data loading (step 2), all the JG sql statements that reference the staging tables are JG invalidated, including "delete from stageing_table" sql JG statement. I setup a test and used a java program to loop JG steps 1-4 every ~2 minutes. There were no other activities JG in the database except data loading and transformation. JG After a couple days, I got the following error: ORA-04031: JG unable to allocate 4212 bytes of shared memory ("shared JG pool","unknown object","sga heap(1,0)","stat array mem") JG The questions are: JG 1. Do we need to delete entries in the staging table prior to loading. Will JG sqlldr remove the entires in the staging table first prior to loading? JG 2. There are no changes in the stored procedures, how / why sqlldr would JG invalidate the sql statement in the stored procedures? JG 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? JG I would appreciate if you can send me some pointers or suggestions. JG Thanks, JG KamYee JG -- JG Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting service
Re[2]: Fwd: Looking for help.
Wednesday, November 12, 2003, 12:04:35 PM, Daniel Fink ([EMAIL PROTECTED]) wrote: DF I don't see where truncate is being invoked, though I am not a big user of sql*loader. DF Truncate should invalidate statements. Sorry. He mentioned in a later email to me that he was using the TRUNCATE option in his control file. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: Looking for help.
Daniel, I understand what is you are saying and what you tested but I don't the why or what it means. Does it mean that the sql command is not going to work? Does it means that you have to issue it again to get it to work? Ref: Doc ID: Note:123214.1 invalid Type: PROBLEM Status: PUBLISHED Seems that truncate command invalidates object definition and existence in library cache. Invalidation can also be seen on temporary tables! .. Jonathan, The memory problem is described in Doc id:1157495.8 Support Description of Bug 1157495 Ron [EMAIL PROTECTED] 11/12/2003 1:14:25 PM Ron, I don't know about the TRUNCATE option w/ sql*loader, but the regular DDL TRUNCATE invalidates sql that references the table. Example: 1 select sql_text, invalidations 2 from v$sql 3* where sql_text = 'select * from emp' SQL / SQL_TEXT INVALIDATIONS -- - select * from emp 0 SQL truncate table emp; Table truncated. SQL select sql_text, invalidations 2 from v$sql 3 where sql_text = 'select * from emp' 4 / SQL_TEXT INVALIDATIONS -- - select * from emp 1 Ron Rogers wrote: Daniel, How does using the TRUNCATE command is a sqlldr invalidate anything? The sqlldr truncate command reuses the storage that the table originally used and does not change the HW mark. If there are indexes on the tables then they are placed in the DIRECT PATH state during the load and updated with the now block info. Please explain whet you mean by invalidate. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: Looking for help.
There is a difference between a statement that is invalid (i.e. won't execute) and one whose execution plan has been invalidated in the shared pool. When the statement is 'invalidated' all it means is that if a process wants to reexecute the statement, it must be reparsed. At this time, the statement may become invalid (column referenced has been dropped). Usually it means that a 'hard parse' occurs and the dictionary info is reloaded and the execution plan is regenerated (may be different than the last). Daniel Ron Rogers wrote: Daniel, I understand what is you are saying and what you tested but I don't the why or what it means. Does it mean that the sql command is not going to work? Does it means that you have to issue it again to get it to work? Ref: Doc ID: Note:123214.1 invalid Type: PROBLEM Status: PUBLISHED Seems that truncate command invalidates object definition and existence in library cache. Invalidation can also be seen on temporary tables! .. Jonathan, The memory problem is described in Doc id:1157495.8 Support Description of Bug 1157495 Ron [EMAIL PROTECTED] 11/12/2003 1:14:25 PM Ron, I don't know about the TRUNCATE option w/ sql*loader, but the regular DDL TRUNCATE invalidates sql that references the table. Example: 1 select sql_text, invalidations 2 from v$sql 3* where sql_text = 'select * from emp' SQL / SQL_TEXT INVALIDATIONS -- - select * from emp 0 SQL truncate table emp; Table truncated. SQL select sql_text, invalidations 2 from v$sql 3 where sql_text = 'select * from emp' 4 / SQL_TEXT INVALIDATIONS -- - select * from emp 1 Ron Rogers wrote: Daniel, How does using the TRUNCATE command is a sqlldr invalidate anything? The sqlldr truncate command reuses the storage that the table originally used and does not change the HW mark. If there are indexes on the tables then they are placed in the DIRECT PATH state during the load and updated with the now block info. Please explain whet you mean by invalidate. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: Looking for help.
Daniel, That is what I thought I read in the doc's, Thanks, Ron [EMAIL PROTECTED] 11/12/2003 3:29:27 PM There is a difference between a statement that is invalid (i.e. won't execute) and one whose execution plan has been invalidated in the shared pool. When the statement is 'invalidated' all it means is that if a process wants to reexecute the statement, it must be reparsed. At this time, the statement may become invalid (column referenced has been dropped). Usually it means that a 'hard parse' occurs and the dictionary info is reloaded and the execution plan is regenerated (may be different than the last). Daniel Ron Rogers wrote: Daniel, I understand what is you are saying and what you tested but I don't the why or what it means. Does it mean that the sql command is not going to work? Does it means that you have to issue it again to get it to work? Ref: Doc ID: Note:123214.1 invalid Type: PROBLEM Status: PUBLISHED Seems that truncate command invalidates object definition and existence in library cache. Invalidation can also be seen on temporary tables! .. Jonathan, The memory problem is described in Doc id:1157495.8 Support Description of Bug 1157495 Ron [EMAIL PROTECTED] 11/12/2003 1:14:25 PM Ron, I don't know about the TRUNCATE option w/ sql*loader, but the regular DDL TRUNCATE invalidates sql that references the table. Example: 1 select sql_text, invalidations 2 from v$sql 3* where sql_text = 'select * from emp' SQL / SQL_TEXT INVALIDATIONS -- - select * from emp 0 SQL truncate table emp; Table truncated. SQL select sql_text, invalidations 2 from v$sql 3 where sql_text = 'select * from emp' 4 / SQL_TEXT INVALIDATIONS -- - select * from emp 1 Ron Rogers wrote: Daniel, How does using the TRUNCATE command is a sqlldr invalidate anything? The sqlldr truncate command reuses the storage that the table originally used and does not change the HW mark. If there are indexes on the tables then they are placed in the DIRECT PATH state during the load and updated with the now block info. Please explain whet you mean by invalidate. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the
Re: Fwd: Looking for help.
Ron and Jonathan, Glad to know the problem is solved. We do need SQL*Loader control file whenever we have such a problem. Any DDL would invalidate a cursor in library cache. I'm testing with the harmless GRANT, which is a DDL. SQL create table yongtst (a number); Table created. SQL delete from yongtst; 0 rows deleted. SQL select sql_text, invalidations from v$sql where sql_text like '%yongtst%'; SQL_TEXT INVALIDATIONS - - delete from yongtst 0 select sql_text, invalidations from v$sql where sql_text like '%yongtst%' 0 SQL grant select on yongtst to system; Grant succeeded. SQL select sql_text, invalidations from v$sql where sql_text like '%yongtst%'; SQL_TEXT INVALIDATIONS - - delete from yongtst 1 select sql_text, invalidations from v$sql where sql_text like '%yongtst%' 0 After GRANT, the delete statement has an invalidation of 1 so a hard parse will occur next time. I think this hard parse is slightly less expensive than a brand new SQL. After invalidation, the cursor (cursor head or parent cursor) still shows up in v$sql, but it disappears from v$sql_plan. A brand new SQL does not have an entry in v$sql. Other harmless DDLs acting on tables are COMMENT, ANALYZE, REVOKE, but not EXPLAIN PLAN as you might believe. Yong Huang --- Ron Rogers [EMAIL PROTECTED] wrote: Daniel, I understand what is you are saying and what you tested but I don't the why or what it means. Does it mean that the sql command is not going to work? Does it means that you have to issue it again to get it to work? Ref: Doc ID: Note:123214.1 invalid Type: PROBLEM Status: PUBLISHED Seems that truncate command invalidates object definition and existence in library cache. Invalidation can also be seen on temporary tables! .. Jonathan, The memory problem is described in Doc id:1157495.8Support Description of Bug 1157495 Ron [EMAIL PROTECTED] 11/12/2003 1:14:25 PM Ron, I don't know about the TRUNCATE option w/ sql*loader, but the regular DDL TRUNCATE invalidates sql that references the table. Example: 1 select sql_text, invalidations 2 from v$sql 3* where sql_text = 'select * from emp' SQL / SQL_TEXT INVALIDATIONS -- - select * from emp 0 SQL truncate table emp; Table truncated. SQL select sql_text, invalidations 2 from v$sql 3 where sql_text = 'select * from emp' 4 / SQL_TEXT INVALIDATIONS -- - select * from emp 1 Ron Rogers wrote: Daniel, How does using the TRUNCATE command is a sqlldr invalidate anything? The sqlldr truncate command reuses the storage that the table originally used and does not change the HW mark. If there are indexes on the tables then they are placed in the DIRECT PATH state during the load and updated with the now block info. Please explain whet you mean by invalidate. Ron __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: RE: RAC for download -- re RAC Pricing and Partitioning
They are indeed, and their prices are (in the order you list them) in addition to the EE price: $20K, $20K, $10K, $10K, $10K. Mogens Hemant K Chitale wrote: oops, I forgot to mention Partitioning pricing. Partitioning is also listed seperately under Enterprise Edition options. This is 25% of the EE price. Thus, EE is US$40K per CPU. RAC is US$60K per CPU [40K + 20K]. Partitioning is US$50K per CPU [40K + 10K] and RAC with Partitioning would be US$70K per CPU ! Data Mining, OLAP, Advanced Security, Spatial and Label Security are also seperately priced options. Hemant Date: Thu, 25 Sep 2003 22:46:40 +0800 To: [EMAIL PROTECTED] From: Hemant K Chitale [EMAIL PROTECTED] Subject: RE: RAC for download -- re RAC Pricing Check oraclestore.com. The default page just shows you the pricing for the DB EE, true. However, when you click on Database under Products in the left panel, you can see Oracle Enterprise Edition Options listed seperately from Oracle Database. RAC is under Enterprise Edition Options while EE is under Database and the RAC price is 50% of the EE price. Thus, an RAC price is 150% of an EE price. Hemant At 11:44 AM 24-09-03 -0800, you wrote: My dear friend, you're wrong. That practice has stopped with 8i. Partitioning option *is* an integral part of 9iEE without an additional check to sign. I got a verbal confirmation from my oracle sales rep and I'll try getting a written (email) one as well. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mogens Nørgaard Sent: Wednesday, September 24, 2003 2:30 PM To: Multiple recipients of list ORACLE-L Subject: Re: RAC for download I've seen the same kind of confusion with respect to the partitioning option, where people have been informed by their sales rep that partitioning option is part of EE. Well, yes, if you pay extra for it. Mogens Hemant K Chitale wrote: If the question is about price [referring to oraclestore], remember that RAC is an option and is generally at a 50% premium on the EE cost. However, Mladen is right in that RAC is on the same CDs as the Enterprise Edition. If your servers are cluster-ready, the OUI automatically includes RAC as an installation option, else, RAC does not apear in the Oracle product list when you run the Installer. Hemant At 06:54 AM 24-09-03 -0800, you wrote: RAC is a part of the EE version, for whichever OS you have. You will still need to purchase the hardware. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of quriyat Sent: Wednesday, September 24, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Subject: RAC for download Hello all Where can i get RAC for download? I don't see one in OTN. Oracle store puts a high tag? Thanks -- -- No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com http://hkchital.tripod.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network
RE: Fwd: RE: RAC for download -- re RAC Pricing and Partitioning
One of the reasons I nearly baarfed (sorry) coffee all over my keyboard when I saw the larryism from Oracle world on IBM's capacity on demand ' yes it is capacity on demand but it costs 45k a processor' pots,kettles,black the whole thing really. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mogens Nørgaard Sent: 26 September 2003 12:05 To: Multiple recipients of list ORACLE-L Subject: Re: Fwd: RE: RAC for download -- re RAC Pricing and Partitioning They are indeed, and their prices are (in the order you list them) in addition to the EE price: $20K, $20K, $10K, $10K, $10K. Mogens Hemant K Chitale wrote: oops, I forgot to mention Partitioning pricing. Partitioning is also listed seperately under Enterprise Edition options. This is 25% of the EE price. Thus, EE is US$40K per CPU. RAC is US$60K per CPU [40K + 20K]. Partitioning is US$50K per CPU [40K + 10K] and RAC with Partitioning would be US$70K per CPU ! Data Mining, OLAP, Advanced Security, Spatial and Label Security are also seperately priced options. Hemant Date: Thu, 25 Sep 2003 22:46:40 +0800 To: [EMAIL PROTECTED] From: Hemant K Chitale [EMAIL PROTECTED] Subject: RE: RAC for download -- re RAC Pricing Check oraclestore.com. The default page just shows you the pricing for the DB EE, true. However, when you click on Database under Products in the left panel, you can see Oracle Enterprise Edition Options listed seperately from Oracle Database. RAC is under Enterprise Edition Options while EE is under Database and the RAC price is 50% of the EE price. Thus, an RAC price is 150% of an EE price. Hemant At 11:44 AM 24-09-03 -0800, you wrote: My dear friend, you're wrong. That practice has stopped with 8i. Partitioning option *is* an integral part of 9iEE without an additional check to sign. I got a verbal confirmation from my oracle sales rep and I'll try getting a written (email) one as well. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mogens Nørgaard Sent: Wednesday, September 24, 2003 2:30 PM To: Multiple recipients of list ORACLE-L Subject: Re: RAC for download I've seen the same kind of confusion with respect to the partitioning option, where people have been informed by their sales rep that partitioning option is part of EE. Well, yes, if you pay extra for it. Mogens Hemant K Chitale wrote: If the question is about price [referring to oraclestore], remember that RAC is an option and is generally at a 50% premium on the EE cost. However, Mladen is right in that RAC is on the same CDs as the Enterprise Edition. If your servers are cluster-ready, the OUI automatically includes RAC as an installation option, else, RAC does not apear in the Oracle product list when you run the Installer. Hemant At 06:54 AM 24-09-03 -0800, you wrote: RAC is a part of the EE version, for whichever OS you have. You will still need to purchase the hardware. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of quriyat Sent: Wednesday, September 24, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Subject: RAC for download Hello all Where can i get RAC for download? I don't see one in OTN. Oracle store puts a high tag? Thanks -- -- No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com http
Fwd: RE: RAC for download -- re RAC Pricing and Partitioning
oops, I forgot to mention Partitioning pricing. Partitioning is also listed seperately under Enterprise Edition options. This is 25% of the EE price. Thus, EE is US$40K per CPU. RAC is US$60K per CPU [40K + 20K]. Partitioning is US$50K per CPU [40K + 10K] and RAC with Partitioning would be US$70K per CPU ! Data Mining, OLAP, Advanced Security, Spatial and Label Security are also seperately priced options. Hemant Date: Thu, 25 Sep 2003 22:46:40 +0800 To: [EMAIL PROTECTED] From: Hemant K Chitale [EMAIL PROTECTED] Subject: RE: RAC for download -- re RAC Pricing Check oraclestore.com. The default page just shows you the pricing for the DB EE, true. However, when you click on Database under Products in the left panel, you can see Oracle Enterprise Edition Options listed seperately from Oracle Database. RAC is under Enterprise Edition Options while EE is under Database and the RAC price is 50% of the EE price. Thus, an RAC price is 150% of an EE price. Hemant At 11:44 AM 24-09-03 -0800, you wrote: My dear friend, you're wrong. That practice has stopped with 8i. Partitioning option *is* an integral part of 9iEE without an additional check to sign. I got a verbal confirmation from my oracle sales rep and I'll try getting a written (email) one as well. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mogens Nørgaard Sent: Wednesday, September 24, 2003 2:30 PM To: Multiple recipients of list ORACLE-L Subject: Re: RAC for download I've seen the same kind of confusion with respect to the partitioning option, where people have been informed by their sales rep that partitioning option is part of EE. Well, yes, if you pay extra for it. Mogens Hemant K Chitale wrote: If the question is about price [referring to oraclestore], remember that RAC is an option and is generally at a 50% premium on the EE cost. However, Mladen is right in that RAC is on the same CDs as the Enterprise Edition. If your servers are cluster-ready, the OUI automatically includes RAC as an installation option, else, RAC does not apear in the Oracle product list when you run the Installer. Hemant At 06:54 AM 24-09-03 -0800, you wrote: RAC is a part of the EE version, for whichever OS you have. You will still need to purchase the hardware. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of quriyat Sent: Wednesday, September 24, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Subject: RAC for download Hello all Where can i get RAC for download? I don't see one in OTN. Oracle store puts a high tag? Thanks -- -- No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com http://hkchital.tripod.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Fwd: Re: Tempfile weirdness
funny how my previous email seems to have been truncated where I put three dots [ie , .] to signifiy 3 lines. Resend : For a critical database where I want to be SURE that the file system has enough space for the TempFile, I run a large SELECT * FROM DBA_SOURCE UNION SELECT * FROM DBA_SOURCE UNION a dot here. another dot here. and a third dot here, signifiying 3 lines. immediately after I startup the Instance [fortunately, the instance startup is supposed to be only once in 1 or 2 years but has practically been once in 3 months]. Hemant At 01:54 PM 17-09-03 -0800, you wrote: Any comments on the following?? When creating index, got ORA-00603: ORACLE server session terminated by fatal error apparently caused by ksedmp: internal or fatal error ORA-01114: IO error writing block to file 121 (block # 149) ORA-27063: skgfospo: number of bytes read/written is incorrect Additional information: 16384 Additional information: 49152 which I determined was caused by attempted write to temp tablespace using a tempfile. The tablespace was dropped and recreated, and all was well again. What I think MIGHT have happened is the tablespace created weeks ago, but not used. So it didn't grab any actual storage. In the mean time, some of the storage might have been used by something else, but storage was released. Now tempfile goes to grab some space, but filesystem is all screwed up about what storage the tempfile should be grabbing. Does this sound plausible? Is there something else going on here? Is this another one of those spiffy cool things in Oracle that are just something else to go wrong and make life a bitch? Note that the index create blew up immediately, so the original tempfile never grabbed any space. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Date: Thu, 18 Sep 2003 08:34:46 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: Hemant K Chitale [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California For a critical database where I want to be SURE that the file system has enough space for the TempFile, I run a large SELECT * FROM DBA_SOURCE UNION SELECT * FROM DBA_SOURCE UNION Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[Fwd: backup problem]
Woop! Dumb question. Never mind. Original Message Date: Tue, 16 Sep 2003 12:02:54 -0500 To: ORACLE-L ORACLE-L [EMAIL PROTECTED] All - I am implementing RMAN on my unix boxes. The dbs are already in archivelog mode for about a year. The system admin was backing up the files from cold backups. Today we realize the backups are no good. The tape is unreadable. Most of the archived logs (.arc) files have been removed from the system. Now I have no way to put them back! How can I set rman to start backing up from today forward? Hoping to get a good backup and dependable from rman. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: LeRoy Kemnitz INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FWD: Checking RMAN backup results
Posted on behalf of Rich Holland ([EMAIL PROTECTED]): Apparently my ISP went off-line for a couple days, and my oracle-L mailing list subscripshun [purposefully spelled incorrectly to avoid the listmangler filters -rjh] was moved to the bounced mailing list. Below is a message I sent on 9/10. I tried searching the online archives @ ListGuru and orafaq with no luck (I can't even find my original posting from 9/10, let alone any replies). If you replied, can you re-send your response via email? I'd greatly appreciate it... Thanks! Rich -- Rich Holland [EMAIL PROTECTED] SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -Original Message- Sent: Wednesday, September 10, 2003 11:13 AM Subject: Checking RMAN backup results Before I reinvent the wheel, I thought I'd ping the list to see how other folks are validating their RMAN backups. In other words, when your backup_full script runs, do you just parse the results looking for RMAN- or ORA- errors, Backup completed successfully etc? Or do you run a validate step and process that? What's the general consensus on automating backup checking? I'd like to just be emailed when there's a problem, rather than doing manual checks every day for the previous night's backups. -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); - end returned message - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fwd: Re: Sparky auth file
Well, what I actually thought you meant from your first answer was to change the init file from a logical to a hard-coded drive name, then that will match the auth file. Something I hadn't thought of until I read your e-mail. So you might have stumbled upon the answer after all. Anyhow, I'm going to give it a shot! Barb --- Mladen Gogala [EMAIL PROTECTED] wrote: Date: Fri, 11 Jul 2003 16:04:24 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From: Mladen Gogala [EMAIL PROTECTED] Subject: Re: Sparky auth file Oooops! I haven't read the whole post before answering. Sorry, I blew it. On 2003.07.11 19:34, Barbara Baker wrote: Ok, this is a REAL reach. But does anyone out there know how to specify the dump directory in the auth file for sparky ... wait ... I'm not there yet on an OpenVMS system? OpenVMS 7.2-1 Oracle 8.1.7.4 Perl 5.6.1 The background dump desitnation from v$parameter is ORA_DUMP. The system logical ORA_DUMP equates to disk$dbtest11:[db_amdev.trace]. Sparky wants to append the trace name file to the end of this. I've tried both ORA_DUMP: and disk$dbtest11:[db_amdev.trace] in the aut file. They don't work. if I use diskname: Authorized directory 'disk$dbtest11:[DB_AMDEV.TRACE]': 16 of 16 '*.trc' files are readable Fri Jul 11 16:20:48 2003 REQ 10.39.8.253 version Fri Jul 11 16:20:48 2003 ACK 10.39.8.253 0 3.04 Fri Jul 11 16:21:30 2003 REQ 10.39.8.253 trcname 'ORA_DUMP', '20c02d0a', 'AMDEV', '16' Fri Jul 11 16:21:30 2003 ACK 10.39.8.253 1 not authorized to read 'ORA_DUMP' (trcfiled.pl v3.04 line 536) if I use ORA_DUMP Fri Jul 11 16:18:34 2003 INFO spid('[.ORA_DUMP]drax11_amdev_fg_oracle_016.trc')='-1' Fri Jul 11 16:18:34 2003 WSVR can't read '[.ORA_DUMP]drax11_amdev_fg_oracle_017.trc' (no such file or directory) I get the error message trace file server daemon has denied your request. Check the trcfiled logfile on 'DRAX11' (ip) at port 2297 for details. I'd be most grateful for any ideas. Thanks!! Barb __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fwd: Hidden Columns
Sorry for wasting bandwidth - found the answer 5 minutes later (found it by looking up histograms in the manual, not DBMS_STATS): For those who want to know - a hidden column is an expression for a function based index. Therefore you can use this option to gather stats when using function based indexes. - Bill. Date: Wed, 28 May 2003 14:42:31 +0100 To: [EMAIL PROTECTED] From: Bill Buchan [EMAIL PROTECTED] Subject: Hidden Columns Hi all, I know this is RTFM but I can't find the right part in the FM to R. So any help would be appreciated: In the context of: DBMS_STATS.GATHER_DATABASE_STATS(method_opt='FOR ALL HIDDEN COLUMNS'); what is a hidden column. I tried gathering stats FOR ALL HIDDEN COLUMNS and it didn't seem to gather any stats for any columns. What is it meant to do? Thanks - Bill. PS. The complete syntax for the column is: FOR ALL [INDEXED | HIDDEN] COLUMNS [size_clause] -- Intasys Billing Technologies Ltd. www.intasysbilling.com 74 Commercial Street, Commercial Quay, Leith, Edinburgh EH6 6LX tel (0)131 625 8200 fax (0)131 625 8201 email [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fwd: db_file_multiblock_read_count + db file scattered read +
My explanation is that blocks 1473, 2566, 2580, 2590, 2617, 2628, 2648, 2681, 2695, 2702, 2714, 2719, 2748, 2760, 2773, 2794, 2798, 2811, and 2819 were already in the buffer pool and the FTS reads around them. Date: Wed, 12 Mar 2003 20:08:48 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: Erroba, Ildefonso N [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] From: Erroba, Ildefonso N [EMAIL PROTECTED] Subject: db_file_multiblock_read_count + db file scattered read + truss Organization: Fat City Network Services, San Diego, California I have been wondering how to set the optimal value of dfmbc (db_file_multiblock_read_count), filesystem pagesize/blocksize, db blk size, in an effort to optimize FTS. I have done testing using event 10046 and truss to find the p3 value on the db file scattered then comparing it with the truss output. It seems that the value in trace file corelates to the truss value (pread64/readv), but I am having trouble trying to explain why lines 12 and 21 on both output files are not using the dfmbc setting of 128 (1M) on the fetch? Also, why is truss showing pread64 and then readv on lines 24..32? I have read the hotsos doc Predicting Multi-Block Read Call Sizes (by Jeff Holt) to get some understanding on how dfmbc affects database I/O. It did not answer cover, though my situation, because the object does not cross extent boundary. Any answers would be highly appreciated. Your collective knowledge would surely help. Any info to other docs or links would also be valuable. Here is the output of event 10046, truss and other info of the test env. 1 WAIT #3: nam='db file scattered read' ela= 6 p1=10 p2=10 p3=128 2 WAIT #3: nam='db file scattered read' ela= 9 p1=10 p2=138 p3=128 3 WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=266 p3=128 4 WAIT #3: nam='db file scattered read' ela= 3 p1=10 p2=394 p3=128 5 WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=522 p3=128 6 WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=650 p3=128 7 WAIT #3: nam='db file scattered read' ela= 5 p1=10 p2=778 p3=128 8 WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=906 p3=128 9 WAIT #3: nam='db file scattered read' ela= 6 p1=10 p2=1034 p3=128 10 WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=1162 p3=128 11 WAIT #3: nam='db file scattered read' ela= 3 p1=10 p2=1290 p3=128 12 WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=1418 p3=55 13 WAIT #3: nam='db file scattered read' ela= 6 p1=10 p2=1474 p3=128 14 WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=1602 p3=128 15 WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=1730 p3=128 16 WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=1858 p3=128 17 WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=1986 p3=128 18 WAIT #3: nam='db file scattered read' ela= 5 p1=10 p2=2114 p3=128 19 WAIT #3: nam='db file scattered read' ela= 4 p1=10 p2=2242 p3=128 20 WAIT #3: nam='db file scattered read' ela= 3 p1=10 p2=2370 p3=128 21 WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2498 p3=68 22 WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2567 p3=13 23 WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2581 p3=9 24 WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2591 p3=26 25 WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2618 p3=10 26 WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2629 p3=19 27 WAIT #3: nam='db file scattered read' ela= 9 p1=10 p2=2649 p3=32 28 WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2682 p3=13 29 WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2696 p3=6 30 WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2703 p3=11 31 WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2715 p3=4 32 WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2720 p3=28 33 WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2749 p3=11 34 WAIT #3: nam='db file scattered read' ela= 1 p1=10 p2=2761 p3=12 35 WAIT #3: nam='db file scattered read' ela= 0 p1=10 p2=2774 p3=20 36 WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2795 p3=3 37 WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2799 p3=12 38 WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2812 p3=7 39 WAIT #3: nam='db file scattered read' ela= 5 p1=10 p2=2820 p3=128 40 WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2948 p3=128 Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Fwd: Re: Listener/Database shutdown sequence
From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Listener/Database shutdown sequence Date: Mon, 03 Mar 2003 08:19:06 -0800 Why do you/they think it matters, regardless of the documentation? You can shut them down in any order you want. Users just get a different error if the listener is up vs. when it is down. Starting up, if services are registered via local_listener or mts_dispatchers, the listener should be up before the database opens. Otherwise, you will have to wait for instance registration with the listener, or force it with 'alter system register'. For dedicated connections, this problem can be avoided with a sid_desc in the listener.ora -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 3 Mar 2003, david davis wrote: Should the databases be shutdown before the listener or the other way around. A DBA here (actually at Service Provider) believes that the listener has to be shutdown before the databases in 8i according to some documentation (they can't recall). I am proposing: Set Oracle 817 environment shutdown database stop 817 listener set Oracle 806 environment stop 806 listener They feel it should be the other order: Shutdown Listeners Shutdown databases -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: RE: newbie dba question - THANKS AGAIN!
Darrell Landrum [EMAIL PROTECTED] wrote: Reply to///Thanks very much to everyne!I should've told you, first mistake sorry, that this is ORACLE 8.0.6 - can I run STATSPACK? Or should I stick with bstat/estat? I will be running stats during times when performance is normal nomal. But what steps in identifying the slowdowns in performace should be taken WHILE the issue is hot and users are on the horn with it? Obviously, they want FAST fix, magic stick. Their thinking is that there is a switch you turn on and that's it you're going fast again. Is there something that can be done in a short time window while the issue is present?Thanks again!"Godlewski, Melissa" <[EMAIL PROTECTED]>wrote:Alex, My 2 cents, First you need to get a baseline of performance during normal business hours, statspak is a great tool to use. When the system start to experience performance problems, then start drilling down to identify t! he issues. Use v$ tables as well as statspak more frequently. Additionally, when you find the sessions causing problems pull the sql and work with the developer to tune it, or identify hot objects you need to manage. Run the 10046 trace on the sessions and collect information on the waits etc. A good place to look is the www.orafaq.com for past list comments/information. A helpful book is Oracle 101 performance tuning by Gaja, Kirti, and John. You can also go to the hotsos site and run your reports through the YAPP to help identify bottlenecks. LOLM.Godlewski-///Alex,Melissa has some good advice here. Your issue is too vague and broad for any reasonable assistance. It seems you're kind of in a trial by fire situation. There are so many things you need to look at and know for trouble shooting performance that, without more information, the most likely offering is a book(s). Unless someone has specifically backported statspack, it is only available from 8! .1.6 forward, so you're stuck with bstat/estat.I haven't read Oracle 101 performance tuning, but I saw Gaja speak at the hotsos symposium and based on that would second Melissa's recommendation for this book. Also, "Expert One-on-One" by Tom Kyte and "Practical Oracle 8i" by Jonathan Lewis (I know it says 8i and you're on 8.0, but there are a lot of concepts and applications the same or similar.) There are probably many other good books which I haven't read.Some sites you should get into very soon (in any order)...http://www.jlcomp.demon.co.uk http://asktom.oracle.com http://www.hotsos.com In the meantime, try and get some traces of troublesome sessions and post those to the list, as well as any stat reports, and we'll offer what help we can. Also, please include any platform information you can get (operating system, etc.). Are your tables getting analyzed?Folks on the list weren't ignoring you, there just wasn't enough information to get ! started.We'll try not to let you have to deal with this alone.Good luck!Darrell Landrum [EMAIL PROTECTED] 02/27/03 05:53PM Note: forwarded message attached.-Do you Yahoo!?Yahoo! Tax Center - forms, calculators, tips, and more-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Darrell LandrumINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso! send the HELP command for other information (like subscribing).Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, and more
Fwd: RE: newbie dba question - another try
Note: forwarded message attached.Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, and more---BeginMessage--- Thanks very much to everyne! I should've told you, first mistake sorry, that this is ORACLE 8.0.6 -can I run STATSPACK? Or should I stick with bstat/estat? I will be running stats during times when performance is normalnomal.But what steps in identifying the slowdowns in performace should be taken WHILE the issue is hot and users are on the horn with it? Obviously, they want FAST fix, magic stick. Their thinking is that there is a switch you turn on and that's it you're going fast again. Is there something that can be done in a short time window while the issue is present? Thanks again! "Godlewski, Melissa" [EMAIL PROTECTED] wrote: Alex, My 2 cents, First you need to get a baseline of performance during normal business hours, statspak is a great tool to use. When the system start to experience performance problems, then start drilling down to identify the issues. Use v$ tables as well as statspak more frequently. Additionally, when you find the sessions causing problems pull the sql and work with the developer to tune it, or identify hot objects you need to manage. Run the 10046 trace on the sessions and collect information on the waits etc. A good place to look is the www.orafaq.com for past list comments/information. Ahelpful book is Oracle 101 performance tuning by Gaja, Kirti, and John. You can also go to the hotsos site and run your reports through the YAPP to help identify bottlenecks. LOL M.Godlewski -Original Message-From: Alex Dashko [mailto:[EMAIL PROTECTED]Sent: Wednesday, February 26, 2003 10:54 PMTo: Multiple recipients of list ORACLE-LSubject: newbie dba question Hello Gurus, I heard that if I can get great ORACLE advice, this is the place, so here is my question. I've been asked to take over an existingdb in production. What would be the right way to get a "quick" understanding on what's happening in it in terms ways for proactive tuning? I amjustgetting startedwhiletrying to be ahead of the curve. Is this something Ishouldbe looking into, or is it more like if it ain't broke, don't fix it? :). It'd be nice to getstarted and have a good view on what's going on. Also, can someone can share their experience onwhatcan be done when customers report intermittent, but rather dramaticslowdowns in the system. Please note, the slowdowns are reported to be occurringin the entire system. What would be a good place to look when this happens and get some quick feedback? Thank you very much! Best regards, Alex Do you Yahoo!?Yahoo! Tax Center - forms, calculators, tips, and moreDo you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, and more---End Message---
Fwd: RE: newbie dba question - another try
Reply to ///Thanks very much to everyne! I should've told you, first mistake sorry, that this is ORACLE 8.0.6 - can I run STATSPACK? Or should I stick with bstat/estat? I will be running stats during times when performance is normal nomal. But what steps in identifying the slowdowns in performace should be taken WHILE the issue is hot and users are on the horn with it? Obviously, they want FAST fix, magic stick. Their thinking is that there is a switch you turn on and that's it you're going fast again. Is there something that can be done in a short time window while the issue is present? Thanks again! Godlewski, Melissa [EMAIL PROTECTED] wrote:Alex, My 2 cents, First you need to get a baseline of performance during normal business hours, statspak is a great tool to use. When the system start to experience performance problems, then start drilling down to identify the issues. Use v$ tables as well as statspak more frequently. Additionally, when you find the sessions causing problems pull the sql and work with the developer to tune it, or identify hot objects you need to manage. Run the 10046 trace on the sessions and collect information on the waits etc. A good place to look is the www.orafaq.com for past list comments/information. A helpful book is Oracle 101 performance tuning by Gaja, Kirti, and John. You can also go to the hotsos site and run your reports through the YAPP to help identify bottlenecks. LOLM.Godlewski- /// Alex, Melissa has some good advice here. Your issue is too vague and broad for any reasonable assistance. It seems you're kind of in a trial by fire situation. There are so many things you need to look at and know for trouble shooting performance that, without more information, the most likely offering is a book(s). Unless someone has specifically backported statspack, it is only available from 8.1.6 forward, so you're stuck with bstat/estat. I haven't read Oracle 101 performance tuning, but I saw Gaja speak at the hotsos symposium and based on that would second Melissa's recommendation for this book. Also, Expert One-on-One by Tom Kyte and Practical Oracle 8i by Jonathan Lewis (I know it says 8i and you're on 8.0, but there are a lot of concepts and applications the same or similar.) There are probably many other good books which I haven't read. Some sites you should get into very soon (in any order)... http://www.jlcomp.demon.co.uk http://asktom.oracle.com http://www.hotsos.com In the meantime, try and get some traces of troublesome sessions and post those to the list, as well as any stat reports, and we'll offer what help we can. Also, please include any platform information you can get (operating system, etc.). Are your tables getting analyzed? Folks on the list weren't ignoring you, there just wasn't enough information to get started. We'll try not to let you have to deal with this alone. Good luck! Darrell Landrum [EMAIL PROTECTED] 02/27/03 05:53PM Note: forwarded message attached. - Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, and more -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: RE: newbie dba question - another try
Thanks Darell! Your advice as well as from others is greatly appreciated. Darrell Landrum [EMAIL PROTECTED] wrote: Reply to///Thanks very much to everyne!I should've told you, first mistake sorry, that this is ORACLE 8.0.6 - can I run STATSPACK? Or should I stick with bstat/estat? I will be running stats during times when performance is normal nomal. But what steps in identifying the slowdowns in performace should be taken WHILE the issue is hot and users are on the horn with it? Obviously, they want FAST fix, magic stick. Their thinking is that there is a switch you turn on and that's it you're going fast again. Is there something that can be done in a short time window while the issue is present?Thanks again!"Godlewski, Melissa" <[EMAIL PROTECTED]>wrote:Alex, My 2 cents, First you need to get a baseline of performance during normal business hours, statspak is a great tool to use. When the system start to experience performance problems, then start drilling down to identify t! he issues. Use v$ tables as well as statspak more frequently. Additionally, when you find the sessions causing problems pull the sql and work with the developer to tune it, or identify hot objects you need to manage. Run the 10046 trace on the sessions and collect information on the waits etc. A good place to look is the www.orafaq.com for past list comments/information. A helpful book is Oracle 101 performance tuning by Gaja, Kirti, and John. You can also go to the hotsos site and run your reports through the YAPP to help identify bottlenecks. LOLM.Godlewski-///Alex,Melissa has some good advice here. Your issue is too vague and broad for any reasonable assistance. It seems you're kind of in a trial by fire situation. There are so many things you need to look at and know for trouble shooting performance that, without more information, the most likely offering is a book(s). Unless someone has specifically backported statspack, it is only available from 8! .1.6 forward, so you're stuck with bstat/estat.I haven't read Oracle 101 performance tuning, but I saw Gaja speak at the hotsos symposium and based on that would second Melissa's recommendation for this book. Also, "Expert One-on-One" by Tom Kyte and "Practical Oracle 8i" by Jonathan Lewis (I know it says 8i and you're on 8.0, but there are a lot of concepts and applications the same or similar.) There are probably many other good books which I haven't read.Some sites you should get into very soon (in any order)...http://www.jlcomp.demon.co.uk http://asktom.oracle.com http://www.hotsos.com In the meantime, try and get some traces of troublesome sessions and post those to the list, as well as any stat reports, and we'll offer what help we can. Also, please include any platform information you can get (operating system, etc.). Are your tables getting analyzed?Folks on the list weren't ignoring you, there just wasn't enough information to get ! started.We'll try not to let you have to deal with this alone.Good luck!Darrell Landrum [EMAIL PROTECTED] 02/27/03 05:53PM Note: forwarded message attached.-Do you Yahoo!?Yahoo! Tax Center - forms, calculators, tips, and more-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Darrell LandrumINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso! send the HELP command for other information (like subscribing).Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, and more
Re: Fwd: RE: newbie dba question - another try
Thanks Darell! Your advice as well as from others is greatly appreciated. Darrell Landrum [EMAIL PROTECTED] wrote: Reply to///Thanks very much to everyne!I should've told you, first mistake sorry, that this is ORACLE 8.0.6 - can I run STATSPACK? Or should I stick with bstat/estat? I will be running stats during times when performance is normal nomal. But what steps in identifying the slowdowns in performace should be taken WHILE the issue is hot and users are on the horn with it? Obviously, they want FAST fix, magic stick. Their thinking is that there is a switch you turn on and that's it you're going fast again. Is there something that can be done in a short time window while the issue is present?Thanks again!"Godlewski, Melissa" <[EMAIL PROTECTED]>wrote:Alex, My 2 cents, First you need to get a baseline of performance during normal business hours, statspak is a great tool to use. When the system start to experience performance problems, then start drilling down to identify t! he issues. Use v$ tables as well as statspak more frequently. Additionally, when you find the sessions causing problems pull the sql and work with the developer to tune it, or identify hot objects you need to manage. Run the 10046 trace on the sessions and collect information on the waits etc. A good place to look is the www.orafaq.com for past list comments/information. A helpful book is Oracle 101 performance tuning by Gaja, Kirti, and John. You can also go to the hotsos site and run your reports through the YAPP to help identify bottlenecks. LOLM.Godlewski-///Alex,Melissa has some good advice here. Your issue is too vague and broad for any reasonable assistance. It seems you're kind of in a trial by fire situation. There are so many things you need to look at and know for trouble shooting performance that, without more information, the most likely offering is a book(s). Unless someone has specifically backported statspack, it is only available from 8! .1.6 forward, so you're stuck with bstat/estat.I haven't read Oracle 101 performance tuning, but I saw Gaja speak at the hotsos symposium and based on that would second Melissa's recommendation for this book. Also, "Expert One-on-One" by Tom Kyte and "Practical Oracle 8i" by Jonathan Lewis (I know it says 8i and you're on 8.0, but there are a lot of concepts and applications the same or similar.) There are probably many other good books which I haven't read.Some sites you should get into very soon (in any order)...http://www.jlcomp.demon.co.uk http://asktom.oracle.com http://www.hotsos.com In the meantime, try and get some traces of troublesome sessions and post those to the list, as well as any stat reports, and we'll offer what help we can. Also, please include any platform information you can get (operating system, etc.). Are your tables getting analyzed?Folks on the list weren't ignoring you, there just wasn't enough information to get ! started.We'll try not to let you have to deal with this alone.Good luck!Darrell Landrum [EMAIL PROTECTED] 02/27/03 05:53PM Note: forwarded message attached.-Do you Yahoo!?Yahoo! Tax Center - forms, calculators, tips, and more-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Darrell LandrumINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso! send the HELP command for other information (like subscribing).Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, and more
Fwd: Re: Optimizer help, get query to run as good as with RULE
Jonathan, Thanks. I am able to get better performance running -- SELECT /*+ CHOOSE */ DISTINCT -- SELECT /*+ RULE */ DISTINCT -- SELECT /*+ index (prcd_instruction, prcd_instruction_pk) */ DISTINCT -- SELECT /*+ index (prcd_instruction_runsheet, prcd_instruction_runsheet_pk) */ DISTINCT -- SELECT /*+ index (part, part_pk) */ DISTINCT -- SELECT /*+ index (stage, stage_pk) */ DISTINCT -- SELECT /*+ use_nl (prcd_instruction) */ DISTINCT -- SELECT /*+ use_nl (part) */ DISTINCT -- SELECT /*+ full(prcd_instruction) parallel(prcd_instruction, 4) */ DISTINCT SELECT /*+ ordered index (part part_pk) use_nl (part ) index (prcd PRCD_IK03) use_nl (prcd) index (PRCD_INSTRUCTION_RUNSHEET PRCD_INSTRUCTION_RUNSHEET_PK) use_nl(PRCD_INSTRUCTION_RUNSHEET) index (STAGE STAGE_PK) use_nl (STAGE) index (RECIPE RECIPE_NDX_1) use_nl (RECIPE) */ DISTINCT PRCD_INSTRUCTION_RUNSHEET.STAGE_NAME, PRCD_INSTRUCTION_RUNSHEET.RECIPE_NAME, PRCD_INSTRUCTION_RUNSHEET.RECIPE_ORDER, PRCD_INSTRUCTION_RUNSHEET.PRCD_ID, PRCD_INSTRUCTION_RUNSHEET.RECIPE_STAGE, PRCD_INSTRUCTION_RUNSHEET.INSTRUCTION_NUMBER, RECIPE.RECIPE_TITLE, PART.PART_NAME, RECIPE.EQP_TYPE, PRCD_INSTRUCTION_RUNSHEET.STAGE_ORDER, STAGE.STAGE_DESC, TO_NUMBER (STAGE.MATCH_ORDER), DECODE (STAGE.MATCH_ORDER, STAGE.STAGE_SORT_ORDER, 'N', 'Y'), PRCD.PRCD_TITLE FROM -- PRCD_INSTRUCTION_RUNSHEET, -- RECIPE, -- PART, -- STAGE, -- PRCD, -- PRCD_INSTRUCTION PRCD_INSTRUCTION, PART, PRCD, PRCD_INSTRUCTION_RUNSHEET, STAGE, RECIPE WHERE ( PART.PART_ID = PRCD_INSTRUCTION.PRCD_ID ) AND ( STAGE.STAGE_ID = PRCD_INSTRUCTION_RUNSHEET.RECIPE_STAGE ) AND ( PRCD.PRCD_ID = PRCD_INSTRUCTION_RUNSHEET.PRCD_ID ) AND ( (RECIPE.RECIPE_NAME = PRCD_INSTRUCTION_RUNSHEET.RECIPE_NAME) AND (RECIPE.RECIPE_ACTIVE_FLAG = 'A') ) AND ( (PRCD.PRCD_ID LIKE PRCD_INSTRUCTION.CALL_PRCD_NAME || '.%') AND (PRCD.PRCD_ACTIVE_FLAG = 'A') ) AND ( ( PRCD_INSTRUCTION_RUNSHEET.HIERARCHICAL = 'Y' ) AND ( PRCD.PRCD_ACTIVE_FLAG = 'A' ) AND ( PART.PART_ACTIVE_FLAG = 'A' ) AND ( PART.OBSELETE_FLAG 'Y' ) AND PRCD_INSTRUCTION_RUNSHEET.PRCD_ID NOT LIKE 'F-%' AND PRCD_INSTRUCTION_RUNSHEET.PRCD_ID NOT LIKE 'L000%' AND PRCD_INSTRUCTION_RUNSHEET.PRCD_ID NOT LIKE 'PCW%' ) / Also, yes, multiple index hints ARE working as SELECT /*+ index (part, part_pk) index (prcd, prcd_ik03) index (prcd_instruction_runsheet prcd_instruction_runsheet_pk) index (stage stage_pk) index (recipe recipe_ndx_1) */ DISTINCT I had encountered an error message when trying multiple index hints earlier and I cannot reproduce it now. I couldn't find examples of multiple hints in the documentation and I came across a Metalink Forum entry posting where Helene Schoone [whose advice I generally respect] had stated You cannot specify multiple tables in the index hint. I didn't catch that she would have meant a single hint but that it did not exclude seperate hints ! Regards Hemant Date: Wed, 19 Feb 2003 13:05:11 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: Jonathan Lewis [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] From: Jonathan Lewis [EMAIL PROTECTED] Subject: Re: Optimizer help, get query to run as good as with RULE hint Organization: Fat City Network Services, San Diego, California Can you clarify what you mean by: I find that I cannot specify multiple Index Hints. Just for the sake of checking a point, arrange the tables in the from clause in the order indicated by the RULE path, viz: PRCD_INSTRUCTION PART PRCD PRCD_INSTRUCTION_RUNSHEET STAGE RECIPE (NB Your plan seems to have displayed the odd order switch on table RECIPE due to v9 table prefetching - which is odd because I had heard it was a cost-based thing). Then put in the ORDERED hint, along with a hint for each table to use the index that appears for that table, with a USE_NL hint viz: /*+ ordered index(part PART_PK) use_nl(part) index(PRCD PRCD_IK03) use_nl(prcd) ... etc ... */ This should give you exactly the same access path as the rule path. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 18 February 2003 04:32 hint Mark, Here's the query in expl_PRCD.sql delete plan_table where statement_id ='PRCD_H'; explain plan set statement_id='PRCD_H' for SELECT /*+ CHOOSE */ DISTINCT -- SELECT /*+ RULE */ DISTINCT -- SELECT /*+ index (prcd_instruction, prcd_instruction_pk) */ DISTINCT -- SELECT /*+ index (prcd_instruction_runsheet, prcd_instruction_runsheet_pk) *T --
RE: Fwd: Histograms on VARCHAR2 columns ?
OK, I'm reading thru Wolfgang Breitling's Fallacies of the Cost Based Optimizer from the link below. Of course, I've got questions! The data presented on pages 5 and 6 just don't jive. How many systems can do a query with twice as much physical I/O in less than half the elapsed time and CPU time of another query? From my experience, IO just doesn't work that way, unless the data was cached at the OS or IO subsystem, which would make the test invalid. Comments??? Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, February 13, 2003 4:30 PM To: Multiple recipients of list ORACLE-L I like white papers. It looks like I'm going to learn something new again! I'll set aside some time tomorrow to peruse it (I have to go drink beer now). Thanks, Allan! :) Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, February 13, 2003 3:54 PM To: Multiple recipients of list ORACLE-L Actually, even if you use bind varaibles histograms affect the density number used by the optimizer, see http://www.centrexcc.com/papers where he shows that without histograms the optimizer ususally makes density equal to the reciprocal of the Number of Distinct Values. With histograms in place,this is no longer true. Allan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fwd: Histograms on VARCHAR2 columns ?
You can see that with a full table scan because of multi-block reads. Generally, assuming blocking reads and multiblock reads, cpu can be low as this op is not cpu intensive. With the first plan you've got read the index, 3 blocks average (head, leaf, and branch) then go get the db block. More cpu here as you have to examine all those blocks and compute a new DBA for each read. Allan -Original Message- Sent: Friday, February 14, 2003 11:44 AM To: Multiple recipients of list ORACLE-L OK, I'm reading thru Wolfgang Breitling's Fallacies of the Cost Based Optimizer from the link below. Of course, I've got questions! The data presented on pages 5 and 6 just don't jive. How many systems can do a query with twice as much physical I/O in less than half the elapsed time and CPU time of another query? From my experience, IO just doesn't work that way, unless the data was cached at the OS or IO subsystem, which would make the test invalid. Comments??? Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, February 13, 2003 4:30 PM To: Multiple recipients of list ORACLE-L I like white papers. It looks like I'm going to learn something new again! I'll set aside some time tomorrow to peruse it (I have to go drink beer now). Thanks, Allan! :) Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, February 13, 2003 3:54 PM To: Multiple recipients of list ORACLE-L Actually, even if you use bind varaibles histograms affect the density number used by the optimizer, see http://www.centrexcc.com/papers where he shows that without histograms the optimizer ususally makes density equal to the reciprocal of the Number of Distinct Values. With histograms in place,this is no longer true. Allan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fwd: Histograms on VARCHAR2 columns ?
Resending and hoping for some responses, even some real-world stories ... ?... Date: Sun, 09 Feb 2003 18:38:35 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] X-Sender: Hemant K Chitale [EMAIL PROTECTED] Subject: Histograms on VARCHAR2 columns ? I have just begun trying Column histograms and have seen a better execution plan for a query on LOTRUN.RECTYPE when a) LOTRUN had about 5million records b) RECTYPE='A' is only 1570 records c) RECTYPE='H' is the other 5mn-1570 records We wanted the RECTYPE Index to be used because all of our queries are on RECTYPE='A' The RBO would do an Index Range Scan which was quite good However, the CBO under CHOOSE would do an Index Fast Full Scan for both values. Once I collected column statistics with ANALYZE TABLE LOTRUN COMPUTE STATISTICS FOR COLUMNS RECTYPE SIZE 10 {I know, I don't need 10 buckets}, a query for RECTYPE='A' does an Index Range Scan with 10 consistent gets while the query for RECTYPE='H' does an Index Fast Full Scan with 10060 consistent gets. Good ! So far so good, I should say. I look at Note 72539.1 on MetaLink and I find this paragraph : STORING CHARACTER VALUES IN HISTOGRAMS -- Character columns have some exceptional behaviour, in as much as we store histogram data for the first 5 bytes of any string. Any predicates that contain strings greater than 5 characters will not use histogram information and the selectivity will be 1 / DISTINCT. Does this mean that a column with, say, 10 or 12 character values but with the same character-string in the first 5 positions would not get meaningful histogram statistics ? Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: Histograms on VARCHAR2 columns ?
I setup histograms on a table a little over a year ago to help with a query that was taking much too long. The query: SELECT MIN(DOCNUM) FROM SAPEDIDC WHERE RECSTAT = 'U' All values for recstat: SELECT recstat, count(*) recstat_count FROM cimuser.SAPEDIDC group by recstat / R RECSTAT_COUNT - - D 14247 Q 2 The SQL is from a canned app: I can't change it. This app uses a lot of literals in the WHERE clause, and there's little I can do about it. Adding a histogram to the column caused the CBO to decide that an index should be used, and the query time went from 30 seconds to 0.01 seconds, as FTS was not longer used. This same result could be achieved with setting 'alter session set optimizer_index_cost_adj = 40', which is now done in a logon trigger for this app's accounts. I also create histograms on all indexed columns for this app. It has been running with acceptable performance now for quite some time. Unfortunately, I am spending all this week helping to install the new and improved version of this app, with a *much* more complex schema. ( You would have to see it to believe it. ) I look forward to a new round of tuning. :) HTH, Jared Hemant K Chitale [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/13/2003 07:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Fwd: Histograms on VARCHAR2 columns ? Resending and hoping for some responses, even some real-world stories ... ?... Date: Sun, 09 Feb 2003 18:38:35 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] X-Sender: Hemant K Chitale [EMAIL PROTECTED] Subject: Histograms on VARCHAR2 columns ? I have just begun trying Column histograms and have seen a better execution plan for a query on LOTRUN.RECTYPE when a) LOTRUN had about 5million records b) RECTYPE='A' is only 1570 records c) RECTYPE='H' is the other 5mn-1570 records We wanted the RECTYPE Index to be used because all of our queries are on RECTYPE='A' The RBO would do an Index Range Scan which was quite good However, the CBO under CHOOSE would do an Index Fast Full Scan for both values. Once I collected column statistics with ANALYZE TABLE LOTRUN COMPUTE STATISTICS FOR COLUMNS RECTYPE SIZE 10 {I know, I don't need 10 buckets}, a query for RECTYPE='A' does an Index Range Scan with 10 consistent gets while the query for RECTYPE='H' does an Index Fast Full Scan with 10060 consistent gets. Good ! So far so good, I should say. I look at Note 72539.1 on MetaLink and I find this paragraph : STORING CHARACTER VALUES IN HISTOGRAMS -- Character columns have some exceptional behaviour, in as much as we store histogram data for the first 5 bytes of any string. Any predicates that contain strings greater than 5 characters will not use histogram information and the selectivity will be 1 / DISTINCT. Does this mean that a column with, say, 10 or 12 character values but with the same character-string in the first 5 positions would not get meaningful histogram statistics ? Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fwd: Histograms on VARCHAR2 columns ?
Remember the caveat that histograms will only work if the SQL isn't using bind variables, the instance isn't set for CURSOR_SHARING=FORCE, and the DB version 9i (the optimizer can peek at bind variable values in 9i). Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, February 13, 2003 11:55 AM To: Multiple recipients of list ORACLE-L I setup histograms on a table a little over a year ago to help with a query that was taking much too long. The query: SELECT MIN(DOCNUM) FROM SAPEDIDC WHERE RECSTAT = 'U' All values for recstat: SELECT recstat, count(*) recstat_count FROM cimuser.SAPEDIDC group by recstat / R RECSTAT_COUNT - - D 14247 Q 2 The SQL is from a canned app: I can't change it. This app uses a lot of literals in the WHERE clause, and there's little I can do about it. Adding a histogram to the column caused the CBO to decide that an index should be used, and the query time went from 30 seconds to 0.01 seconds, as FTS was not longer used. This same result could be achieved with setting 'alter session set optimizer_index_cost_adj = 40', which is now done in a logon trigger for this app's accounts. I also create histograms on all indexed columns for this app. It has been running with acceptable performance now for quite some time. Unfortunately, I am spending all this week helping to install the new and improved version of this app, with a *much* more complex schema. ( You would have to see it to believe it. ) I look forward to a new round of tuning. :) HTH, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fwd: Histograms on VARCHAR2 columns ?
Actually, even if you use bind varaibles histograms affect the density number used by the optimizer, see http://www.centrexcc.com/papers where he shows that without histograms the optimizer ususally makes density equal to the reciprocal of the Number of Distinct Values. With histograms in place,this is no longer true. Allan -Original Message- Sent: Thursday, February 13, 2003 2:34 PM To: Multiple recipients of list ORACLE-L Remember the caveat that histograms will only work if the SQL isn't using bind variables, the instance isn't set for CURSOR_SHARING=FORCE, and the DB version 9i (the optimizer can peek at bind variable values in 9i). Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, February 13, 2003 11:55 AM To: Multiple recipients of list ORACLE-L I setup histograms on a table a little over a year ago to help with a query that was taking much too long. The query: SELECT MIN(DOCNUM) FROM SAPEDIDC WHERE RECSTAT = 'U' All values for recstat: SELECT recstat, count(*) recstat_count FROM cimuser.SAPEDIDC group by recstat / R RECSTAT_COUNT - - D 14247 Q 2 The SQL is from a canned app: I can't change it. This app uses a lot of literals in the WHERE clause, and there's little I can do about it. Adding a histogram to the column caused the CBO to decide that an index should be used, and the query time went from 30 seconds to 0.01 seconds, as FTS was not longer used. This same result could be achieved with setting 'alter session set optimizer_index_cost_adj = 40', which is now done in a logon trigger for this app's accounts. I also create histograms on all indexed columns for this app. It has been running with acceptable performance now for quite some time. Unfortunately, I am spending all this week helping to install the new and improved version of this app, with a *much* more complex schema. ( You would have to see it to believe it. ) I look forward to a new round of tuning. :) HTH, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fwd: Histograms on VARCHAR2 columns ?
Remember the caveat that histograms will only work if the SQL isn't using bind variables, the instance isn't set for CURSOR_SHARING=FORCE, Yes, that's why I'm using them. That's what... This app uses a lot of literals in the WHERE clause, and there's little I can do about it. ... meant. :) Jared Jesse, Rich [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/13/2003 12:34 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Fwd: Histograms on VARCHAR2 columns ? Remember the caveat that histograms will only work if the SQL isn't using bind variables, the instance isn't set for CURSOR_SHARING=FORCE, and the DB version 9i (the optimizer can peek at bind variable values in 9i). Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, February 13, 2003 11:55 AM To: Multiple recipients of list ORACLE-L I setup histograms on a table a little over a year ago to help with a query that was taking much too long. The query: SELECT MIN(DOCNUM) FROM SAPEDIDC WHERE RECSTAT = 'U' All values for recstat: SELECT recstat, count(*) recstat_count FROM cimuser.SAPEDIDC group by recstat / R RECSTAT_COUNT - - D 14247 Q 2 The SQL is from a canned app: I can't change it. This app uses a lot of literals in the WHERE clause, and there's little I can do about it. Adding a histogram to the column caused the CBO to decide that an index should be used, and the query time went from 30 seconds to 0.01 seconds, as FTS was not longer used. This same result could be achieved with setting 'alter session set optimizer_index_cost_adj = 40', which is now done in a logon trigger for this app's accounts. I also create histograms on all indexed columns for this app. It has been running with acceptable performance now for quite some time. Unfortunately, I am spending all this week helping to install the new and improved version of this app, with a *much* more complex schema. ( You would have to see it to believe it. ) I look forward to a new round of tuning. :) HTH, Jared -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fwd: Histograms on VARCHAR2 columns ?
I like white papers. It looks like I'm going to learn something new again! I'll set aside some time tomorrow to peruse it (I have to go drink beer now). Thanks, Allan! :) Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, February 13, 2003 3:54 PM To: Multiple recipients of list ORACLE-L Actually, even if you use bind varaibles histograms affect the density number used by the optimizer, see http://www.centrexcc.com/papers where he shows that without histograms the optimizer ususally makes density equal to the reciprocal of the Number of Distinct Values. With histograms in place,this is no longer true. Allan -Original Message- Sent: Thursday, February 13, 2003 2:34 PM To: Multiple recipients of list ORACLE-L Remember the caveat that histograms will only work if the SQL isn't using bind variables, the instance isn't set for CURSOR_SHARING=FORCE, and the DB version 9i (the optimizer can peek at bind variable values in 9i). Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, February 13, 2003 11:55 AM To: Multiple recipients of list ORACLE-L I setup histograms on a table a little over a year ago to help with a query that was taking much too long. The query: SELECT MIN(DOCNUM) FROM SAPEDIDC WHERE RECSTAT = 'U' All values for recstat: SELECT recstat, count(*) recstat_count FROM cimuser.SAPEDIDC group by recstat / R RECSTAT_COUNT - - D 14247 Q 2 The SQL is from a canned app: I can't change it. This app uses a lot of literals in the WHERE clause, and there's little I can do about it. Adding a histogram to the column caused the CBO to decide that an index should be used, and the query time went from 30 seconds to 0.01 seconds, as FTS was not longer used. This same result could be achieved with setting 'alter session set optimizer_index_cost_adj = 40', which is now done in a logon trigger for this app's accounts. I also create histograms on all indexed columns for this app. It has been running with acceptable performance now for quite some time. Unfortunately, I am spending all this week helping to install the new and improved version of this app, with a *much* more complex schema. ( You would have to see it to believe it. ) I look forward to a new round of tuning. :) HTH, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fwd: Fwd: Undo Segment of 4GB for 1mn 4col update ?
Hmm. Running the update with 100,000 records in the table : Now I get different run-times : 1. 01hr:16min:41.55sec, 386 log-switches [10MB redologs] 2. 00hr:03min:39.76sec, 33 log-switches 3. 00h4:03min:37.56sec, 32 log-switches What I can see is that the SMON was still busy when I started the first run after a SHUTDOWN ABORT and STARTUP [and also in the 5-hour failed attempt]. There doesn't seem to be any Row-Migration : SQL analyze table txn_user.txn_table compute statistics; Table analyzed. SQL select * from dba_tables where table_name = 'TXN_TABLE'; OWNER TABLE_NAME -- -- TABLESPACE_NAMECLUSTER_NAME -- -- IOT_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS -- -- -- -- -- INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE FREELISTS -- --- --- --- -- FREELIST_GROUPS LOG B NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT --- --- - -- -- -- -- AVG_ROW_LEN AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS DEGREE INSTANCES --- - --- -- -- CACHE TABLE_LO SAMPLE_SIZE LAST_ANAL PAR IOT_TYPE T S NES BUFFER_ ROW_MOVE - --- - --- - - --- --- GLO USE DURATIONSKIP_COR MON CLUSTER_OWNER DEPENDEN --- --- --- --- -- TXN_USER TXN_TABLE SYSTEM 10 40 1255 65536 1 2147483645 1 1 YES N 10 1078 73 1433 0 70 7420 5 1 1 N ENABLED 10 21-JAN-03 NO N N NO DEFAULT DISABLED NO NO DISABLED NO DISABLED SQL exit What AM I missing ? Some, silly error .. something I am overlooking ... Oviously, there was some other activity going on.. SMON had been cleaning up the earlier, failed, update. Was it also deleting freed extents in the Undo Tablespace ? [Locally-Managed, SYSTEM Allocation, AUTOMATIC SegmentSpaceManagement] I am going to end up with egg on my face. Hemant - Forwarded message from Hemant K Chitale [EMAIL PROTECTED] - Date: Mon, 20 Jan 2003 17:43:44 -0800 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] oops. The cntr := cntr+1 is missing from the update. The previous update round didn't have a counter, though. I am re-running the update now. Hemant Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fwd: Oracle Security Product Management Issues Security Alert
list, Received this today. Ron [EMAIL PROTECTED] 12/21/02 06:08PM Oracle Security Product Management Issues Security Alert #47 This e-mail contains a critical, technical alert which is being sent as a service to all Oracle MetaLink users. Oracle Security Product Management team has issued the following alert on MetaLink: Oracle Security Alert #47: Security Vulnerabilities in Oracle9i Application Server Doc ID:224215.1 You may view this article by logging on MetaLink at http://metalink.oracle.com and clicking on the Security Alert document #47 in the News Notes section on the My Headlines page. Thank you for using MetaLink. Oracle Support Services -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fwd: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB
Ian, Could you explain how ASSM could be detrimental in a single instance environment ? Vivek, Could you provide details on the issues [BugNos, description of the problem, your findings] you had with ASSM in 9iRAC ? Hemant At 07:09 AM 19-12-02 -0800, you wrote: As part of a RAC benchmark with 9.2 we had faced severe LOCKING on setting segment space management AUTO had to REMOVE it HTH -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 15, 2002 8:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB quotes from Oracle Manuals deleted Bottomline : Either it was a bug or a restriction, it was not possible in 9.0.1 and supposed to be possible in 9.2.0 --- definitely works in 9.2.0.2 Why do you say In a single instance environment unless you are doing something out of the ordinary, use of the clause will probably be detrimental. ? Hemant At 03:03 PM 14-12-02 -0800, you wrote: Was the prohibitition on placing LOB's into tablespaces with automatic segment space management only a bug. I ask because the description of auto segment space management includes the following restrictions quote from 9.0.1 manual deleted One usually associates a bug with something the manual says one can do, but one cannot. I've not seen the 9.0.2 manual. Are the restrictions lifted? In a single instance environment unless you are doing something out of the ordinary, use of the clause will probably be detrimental. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, December 13, 2002 7:19 PM To: Multiple recipients of list ORACLE-L The first time we tried importing our 8.1.5 [OPS] database into 9.0.1 and 9.2.0.1 with EXTENT_MANAGEMENT Local for ALL tablespaces SEGMENT_SPACE_MANAGEMENT Auto we found that tables with LOB segments could not be created. This was a 9.0.1 bug which was expected to have been fixed in 9.2 [I believe it was Bug 1626182, referenced in Note 159078.1] However, after going to 9.2.0.2, I WAS able to create such tables in the database. [the Patchset Notes include a reference to Bug 2326066. Unfortunately, I can't see either bug on MetaLink to verify if both are the same issue] 9iRAC strongly recommends SEGMENT_SPACE_MANAGEMENT Auto instead of using Free_Lists and Free_List_Groups. [Part 3, Appendix B of the 9iRAC Deployment and Performance manual]. Are there any real-life experiences / gotchas with LOB Segments in Locally Managed Tablespaces and Segment_Space_Management Auto ? There seem to be a number of bug-fixes for Segment_Space_Management=AUTO in the 9.2.0.2 PatchSet Release Notes. Hemant K Chitale My web site page is : http://hkchital.tripod.com Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fwd: Re: Reporting - Casting about for ideas
Thanks, David. What I'm looking for is actually a solution to build the infrastructrue for this. And like sqlplus, Oracle Reports can't be used for reporting on SAP systems. Thanks for the idea though. I didn't know about the report caching, and they may come in handy on another project. Jared On Thursday 31 October 2002 16:28, [EMAIL PROTECTED] wrote: We don't use the Oracle Reports Server, but I seem to remember it offers report caching. I did a quick search on Metalink and found this: Note:118223.1 TOLERANCE PARAMETER 3. Creating a backup using the Reports Server One of the parameters of the Reports Server, is the Tolerance parameter. This parameter specifies a certain period in which a report which is ran again will use the cached output iso actually running the report again. Just add the tolerance parameter to the run report command, run the report to file, run the report again, but now to the printer. When you run the report to the printer, the cached output will be used. So if the print fails, you still have the backup of the report printed to a file. And if the tolerance period has not been expired, you even have an extra copy in the cache and can issue the print command again. 4. Example In this example we will first print a report to file and then to the printer. To do this the Reports Command Line Interface is used, but the same can be done from the other run options (see chapter 2). Step 1, print the report to file: RWCLI60 report name connectstring SERVER=repserver DESTYPE=file DESNAME=filename TOLERANCE=#min eg. RWCLI60 emp scott/tiger@orcl SERVER=repsrv6i DESTYPE=file DESNAME=emp TOLERANCE=5 Step 2, print the report to the printer using the cached output from step 1: RWCLI60 report name connectstring SERVER=repserver DESTYPE=printer DESNAME=printername TOLERANCE=#min eg. RWCLI60 emp scott/tiger@orcl SERVER=repsrv6i DESTYPE=printer DESNAME=las4d TOLERANCE=5 Make sure to specify the tolerance parameter in both calls, otherwise the cached output will not be used. In the example a tolerance of 5 minutes is specified, make sure to activate step 2 within 5 minutes of step one, otherwise the cached output will not be used. -Original Message- From: [EMAIL PROTECTED] [mailto:Jared.Still;radisys.com] Sent: Thursday, October 31, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Subject: Reporting - Casting about for ideas Dear List, First, a little background. A coworker and I have been charged with developing and implementing a 'short term' 'Reporting Solution'. Glossary: short term: low cast, fast to implement, throw it away late next year Reporting Solution: Some method to make it easy for users to see oft run reports without re-running them on the production SAP ( and other apps also ) systems. The goal of the 'Reporting Solution' is perceived performance. Only 1 or 2 of these reports have any detrimental performance impact on the servers. The goal is to allow users to view current and historic reports ( up to 90 days ) without being required to wait on reports to run on the application/database servers. This is partly political, partly user friendly. The political part is that we want to do *something* for users so that it looks like we're taking their requirements to heart, even though we don't have the resources to do much right now. The user friendly part is that we want to do *something* for users so that we can make their jobs a little easier, even though we don't have the resources to do much right now. One idea we have is to have an ABAPer ( SAP programmer ) setup the most requested reports to run in batch mode with a specified range of dates and whatever parameters are needed. This would be done periodically, the report output put on a network filer or database or something accessible via browser ( no shared drive type solution, access is to iffy ), and a web page that would allow simple navigation to reports by Category/Date. Click on the report, view your data. One thing that this is *not*, is a data warehouse and/or data marts. This is to be a low cost solution. Some software OK, a server is Ok if necessary. The key is fairly easy and quick implementation. I'm open to any and all ideas you may have for this, experiences doing similar projects, etc. If it uses Oracle software, that's cool, if not, that's cool too. Oracle is involved in any solution: at the very least, that's where all our source data is stored. Thanks for reading this long winded message. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Fwd: checkpoint not complete
Increase the size of redologs and add some more group Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 25 Oct 2002 17:03:47 -0800 I am noticing in the Alert Log that it notes quite often Checkpoint Not Complete. What causes this? Does something need to be tuned? What parameter? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Sardin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get a speedy connection with MSN Broadband. Join now! http://resourcecenter.msn.com/access/plans/freeactivation.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Fwd: [Fwd: RE: Forms 3.0 ; Oracle 8i/9i ; Patch 380665 ; HP-
I found that query-only applications seemed to run OK against 8.x.x databases, but update applications encountered locking problems because of the expanded rowid. (I think Forms 3.0 stores the rowids within the form and only stores part of the expanded rowid). I don't know how you could possibly run Forms 3.0 update applications against 8.x.x or 9.x.x, but then again I am all converted from Forms 3.0 at this point and don't need to worry about it any more. -Original Message- Sent: Thursday, September 26, 2002 3:04 PM To: Multiple recipients of list ORACLE-L 11]] Hi Kurth This is from Johannes that is not on the oracle-l mailing list. I have no knowlegde about patch 380665 but I have a happy customer running Forms 3.0 (version Version 3.0.16.12 from the Oracle 7.2.3 installation CD) in an Oracle 7.2.3 home on Sun Solaris (SunOS 5.7), with TWO_TASK set to point at an Oracle 9i instance on another server. So it can work for sure! I would imagine that there could be problems with the installation and execution of Forms 3.0 on some newer operating systems. I tried for years to find a patch that would allow Forms 3.0 to work with Oracle8.x.x. I think there is a path for NT, but none for Unix. Time to bite the bullet and upgrade to Forms 4.5 or higher. -Original Message- Sent: Wednesday, September 25, 2002 2:59 PM To: Multiple recipients of list ORACLE-L Hello guys, I am trying to figure out the mystery of Patch 380665, which allows Forms 3.0 to be used with Oracle 8.1.7 I have a few questions 1. Does this patch exist or is it just a myth? 2. Is this a Database patch or Forms patch? 3. How to get this patch? I would really appreciate if any of ull have travelled this path of trying to make Forms 3.0 work with Oracle 8i. Thanks Mandar -Original Message- Sent: Wednesday, September 25, 2002 11:34 AM To: Mandar A. Ghosalkar -- SEARCH ORACLE-L 380655 The archive for this mailing list exists, but cannot be accessed. This may be due to the server being down or some other network problem. Please contact [EMAIL PROTECTED] for further assistance. Sorry for the inconvenience. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter. The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance. If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail. Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kurth, Michael J. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who
[Fwd: [Fwd: RE: Forms 3.0 ; Oracle 8i/9i ; Patch 380665 ; HP-UX 11]]
Hi Kurth This is from Johannes that is not on the oracle-l mailing list. I have no knowlegde about patch 380665 but I have a happy customer running Forms 3.0 (version Version 3.0.16.12 from the Oracle 7.2.3 installation CD) in an Oracle 7.2.3 home on Sun Solaris (SunOS 5.7), with TWO_TASK set to point at an Oracle 9i instance on another server. So it can work for sure! I would imagine that there could be problems with the installation and execution of Forms 3.0 on some newer operating systems. I tried for years to find a patch that would allow Forms 3.0 to work with Oracle8.x.x. I think there is a path for NT, but none for Unix. Time to bite the bullet and upgrade to Forms 4.5 or higher. -Original Message- Sent: Wednesday, September 25, 2002 2:59 PM To: Multiple recipients of list ORACLE-L Hello guys, I am trying to figure out the mystery of Patch 380665, which allows Forms 3.0 to be used with Oracle 8.1.7 I have a few questions 1. Does this patch exist or is it just a myth? 2. Is this a Database patch or Forms patch? 3. How to get this patch? I would really appreciate if any of ull have travelled this path of trying to make Forms 3.0 work with Oracle 8i. Thanks Mandar -Original Message- Sent: Wednesday, September 25, 2002 11:34 AM To: Mandar A. Ghosalkar -- SEARCH ORACLE-L 380655 The archive for this mailing list exists, but cannot be accessed. This may be due to the server being down or some other network problem. Please contact [EMAIL PROTECTED] for further assistance. Sorry for the inconvenience. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter. The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance. If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail. Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kurth, Michael J. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk smime.p7s Description: application/pkcs7-signature
Fwd: Diets
The Japanese eat very little fat and suffer fewer heart attacks than the British or Americans. The French eat a lot of fat and also suffer fewer heart attacks than the British or Americans. from a friend,,, The Japanese drink very little red wine and suffer fewer heart attacks than the British or Americans. The Italians drink excessive amounts of red wine and also suffer fewer heart attacks than the British or Americans. The Germans drink a lot of beers and eat lots of sausages and fats and suffer fewer heart attacks than the British or Americans. CONCLUSION: Eat and drink what you like. Speaking English is apparently what kills you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fwd: ORA 4021 when .fmb - it's a bug
For the archives: From another list, found out there is a known bug: It's a known problem with Forms 6 vs Oracle9i. See Oracle MetaLink bug number 2052790. It hasn't been updated since February but it references bug 2166890 which I cannot access. DDL COMMAND HANGS IN SQL*PLUS IF THE TABLE IS USED IN A FORM To: [EMAIL PROTECTED] From: Deborah Lorraine [EMAIL PROTECTED] Subject: ORA 4021 when .fmb with library is opened We have a database problem caused by an .fmb open in developer 6i. I can now consistently reproduce the following scenario that generates ORA 4021, timeout occurred trying to lock a library object: 1. Developer A opens xxx.fmb in form builder, goes for a cup of coffee 2. DBA attempts to grant a privilege against any table in the library invoked by xxx.fmb, and fails after 5 minutes with ORA 4021. In fact, any DDL, including a scenario where DEVELOPER B tries to create his own table with the same table locked by Developer A, but DIFFERENT columns, he will get ORA 4021 also. The table name itself is locked! I first noticed this problem when my dynamically-generated grant scripts repeatedly failed with 4021's after upgrading to 9iR2. Never had that problem before. The only way I could give developer grants was to shutdown the database and restrict access! I thought it was related to pinned packages but that was not the case. Each time, I traced the problem to a pin lock held by an inactive developer session with an open .fmb. Developers are using Developer 6i patch 5a and some use patch 10 (doesn't matter) connecting client/server. I wonder if there some setting in Developer 6i that could be causing it? I'm suspicious, because the problem consistently happens with three of our 15 developers. I don't want to join a developer list to post this question, and really, I believe the problem is in the database. Any ideas? Thanks, Debi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deborah Lorraine INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pls respond...: URGENT
My database okay, its slow, I can't do much work, too much waitingI want to bring as normal processing... From: Fink, Dan [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: Pls respond...: URGENT Date: Tue, 3 Sep 2002 13:58:02 -0600 Peter, What is the problem? What you are asking is not clear, which could be one reason you are not getting a response. Try restating the issue with exactly what the condition of the db is (up or down), what errors are being reported, etc. Dan Fink -Original Message- From: Peter R [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 03, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Subject: Pls respond...: URGENT Hi Friends, My all background processors accessing same file system, I did some reorg this weekend, But I shut down database like 4 times...all processors are waitingAny help will be highly appreicated!!! oracle@baan1 $ ps -ef|grep 14816 oracle 14816 1 2 13:59:00 - 0:49 ora_dbwr_baanIV oracle 80572 18974 2 14:27:27 pts/1 0:00 grep 14816 oracle@baan1 $ ps -ef|grep 15336 oracle 15336 1 0 13:59:00 - 0:12 ora_lgwr_baanIV oracle 83158 18974 2 14:27:55 pts/1 0:00 grep 15336 oracle@baan1 $ ps -ef|grep 17644 oracle 17644 1 0 13:59:00 - 0:16 ora_smon_baanIV oracle 85890 18974 2 14:28:21 pts/1 0:00 grep 17644 oracle@baan1 $ ps -ef|grep 18164 oracle 18164 1 0 13:59:00 - 0:03 ora_db01_baanIV oracle 84380 18974 1 14:28:44 pts/1 0:00 grep 18164 Thanks peter. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Query with a Remote Table over a DB-Link
Resending Date: Wed, 14 Aug 2002 23:42:35 +0800 To: [EMAIL PROTECTED] From: Hemant K Chitale [EMAIL PROTECTED] Subject: Query with a Remote Table over a DB-Link I had always understood that a query which joins a remote table to a local table would pull the entire remote table over and then do the join locally. However, the example in the Oracle9i Database Performance Tuning Guide and Reference (9.2), Chapter 2 Optimizer Operations How the CBO evaluates remote operations [the URL is http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96533/opt_ops.htm#1004878] seems to show that the REMOTE operation actually does a query with a filter against the remote table before pulling data across : How the CBO Evaluates Remote Operations The remote operation indicates that there is a table from another database being accessed through a database link. Example 2-10 has a remote driving table: Example 2-10 How the CBO Evaluates a Query with a Remote Driving Table SELECT c.customer_name, count(*) FROM ra_customers c, so_headers_all@oe h WHERE c.customer_id = h.customer_id AND h.order_number = :b1 GROUP BY c.customer_name; Plan -- SELECT STATEMENT SORT GROUP BY NESTED LOOPS REMOTE TABLE ACCESS BY INDEX ROWID RA_CUSTOMERS INDEX UNIQUE SCAN RA_CUSTOMERS_U1 Remote Database Query Obtained from the Library Cache SELECT ORDER_NUMBER,CUSTOMER_ID FROM SO_HEADERS_ALL H WHERE ORDER_NUMBER=:SYS_B_0; The next example on how the CBO evaluates a query with a Local Driving table is similar -- it passes a WHERE clause to filter the Remote Table. The example even goes on to show how a Hint could be applied to drive the query on the Remote Table. Is this (that a WHERE clause is applied to the Remote table and that the full Remote table is not copied over) true ? Has this been the behaviour since 8i ? What about the Rule-Based Optimizer ? Would it behave the same way ? Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bill Inmon webcast
FYI: Data Warehouse Guru on the Keys to Success: A FREE Webcast by Hyperion Bill Inmon, data warehousing expert, outlines the keys to a successful data warehousing endeavor, including methodology, architecture, the new role of metadata, maximizing your investment, and tips for technology selection. Register today for this free webcast sponsored by Hyperion, delivered live Wednesday, Aug. 14th, and available in replay thereafter. http://itw.itworld.com/GoNow/a14724a62773a79856347a0 -- 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).
(Fwd) Re: System Administrator Appreciation Day
http://ars.userfriendly.org/cartoons/?id=20020726 --- Forwarded message follows --- Also - if you don't already read it, check out today's userfriendly comic, at http://www.userfriendly.org . The 'singer' in the strip is Stef Murkey, marketing type, while the 'singee' is Mike, sysadmin extraordinaire... --- End of forwarded message --- -- 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[2]: Windohs client problems / (Fwd) RE: Reports 9i and Reports 6 on
also see: http://mhorder.com/oracle9i/0072194626.html --- Forwarded message follows --- fwiw, here is the OUI documentation for 9.0.1 http://docs.oracle.com/cd_a91202/901_doc/em.901/a88812 .pdf --- Oracle 8i Installation Guide Release 3 / 8.1.7 for NT http://docs.oracle.com/DOCS_DOT_PDF_Storage/a85302.pdf --- Oracle 8.1.7 Client Multiple Homes documentation: http://docs.oracle.com/cd_a87862/NT817CLI/index.htm (configuration parameters and registry: http://docs.oracle.com/cd_a87862/NT817CLI/win.817/a730 17/apc.htm#1020082 ) --- After installation, the OUI documentation is (typically?) here: F:\Program Files\Oracle\oui\guide\toc.htm Oracle(R) Universal Installer Concepts Guide Release 1.7 ... --- End of forwarded message --- -- 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: Windohs client problems / (Fwd) RE: Reports 9i and Reports 6 on
also see: http://mhorder.com/oracle9i/0072194626.html --- Forwarded message follows --- Most of it was trial and error. Apparently, the old ORANT stuff(dev6) has to be in default_home. I ran into a lot of problems when that was not HOME0 in the registry. OEM was installed by default. I also discovered that oracle agent and oracleids agent can not run at the same time. Depending on what I am trying to do, I have to start and stop various jobs and http servers. This is my development box for trying out new things. I would not recommend this configuration for production. David Peck Baker Hughes Inc. BHBSS-BASIS (713) 625-6649 -Original Message- Sent: Wednesday, July 24, 2002 2:38 PM To: Peck, David; [EMAIL PROTECTED] On 24 Jul 2002 at 11:29, Peck, David wrote: I have 9i r2 of the database, 9idw r2, dev 6i and discoverer 6i on the same Win 2000 box. ok. I have found that you should install the dev 6i first into default_home. Is that documented, or did you determine that from trial-and-error, or hear about it from someone, or ?? I created a separate home for the 9i database and a separate home for 9ids. Did you patch everything? If so, did that go well? Believe it or not, everything works! cool. there are people that will be interested in hearing this. Any chance that ODBC and/or OEM was in the mix? fwiw, on a Win2000 client machine, I had v7 client stuff installed (Y2K installer), then mistakenly installed a trial version of 9i db, uninstalled it (using the 9i OUI , v?), then installed client stuff from 8.1.7.x with the 8.1.7 OUI, and even with that mess, it still works. :) regards, ep -Original Message- Sent: Wednesday, July 24, 2002 1:49 PM To: Multiple recipients of list ODTUG-DEV2K-L Hello List!! Has any one tried installing Reports 9i along with 6i or 6 on the same machine? Do these two go together? Any input will be appreciated. ... -- Author: Peck, David INET: [EMAIL PROTECTED] ... --- End of forwarded message --- -- 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).
Fwd: Lock against Inserts
Aha! Just seen the DBMS_LOCK example in Thomas Kyte's book where he does pretty much what I need (i.e. request a lock on hash(123) before the transaction starts). Still requires setting up a trigger, which I'd hoped to avoid, but if you need to do it this way, it's gotta go in! Thanks - Bill. I have a transaction which issues LOCK TABLE TABLE IN EXCLUSIVE MODE. This is to prevent INSERTs during processing. However this is way too restrictive - we only need to restrict certain types of insert, eg. where col1 = 123. I can do something like SELECT * FROM TABLE WHERE col1 = 123 FOR UPDATE to prevent updates of existing rows of this type, but this will not block further inserts. I could set up an insert trigger to prevent these inserts, but I don't want to error: just wait until the transaction ends. This would appear to make the trigger code too complex - surely there is a way to do this just with simple locks? Any ideas much appreciated! Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: (Fwd)
Eric D. Pierce wrote: trying again... --- Forwarded message follows --- Responsibility / Re: OT -unix Date: Mon, 15 Jul 2002 18:55:37 -0400 Connect the dots, contrary to the highly postured false rectitude that you are conveying, Ellison has a very long track record of sleaze that at a minimum, ought to elicite a great deal of suspicion. I won't debate Larry's personality. I've heard numerous rumors and accusations of sleaze (and skirt-chasing, etc.) and, since I've never met the man, I feel wholly unqualified to comment on his personal behavior. From what I've seen of him in the media, I'll definitely state that he is NOT suffering from any sort of inferiority complex at the very least. That said, few individuals at the helm of any major company can be described as completely humble. (I tend to believe that a healthy ego may be required to succeed in the company-founder/CEO realm). (I will contact McCain's people for additional info, let me know if you would like me to mention you personally :) Assuming that you actually care about corporate responsibility, and aren't just acting pissy for the heck of it, you can find additional background on McCain's position here: http://www.straighttalkamerica.com Most recently, Oracle tried to buy off legislators to thwart an audit of the ELA that Oracle/Logicon put together with the State of California. As far as I'm concerned, all the *ssholes involved in that at Oracle/Logicon, lobbyists, and in the legislature, ought to be in jail. My understanding from various news stories (I could probably dig up links if anyone wants), is that the basic deal with the State of California was a (relatively) typical bundle-deal. Someone determined what California's needs were (probably incorrectly) and sold them a fairly all-encompasing license. Were the salesmen [from what I understand, they were *not* Oracle employees, but were partners] too aggressive? Probably. (Even Oracle's salesforce has been known to be overly aggressive in the past... no really!] As to the buying off the legislators, the article I read simply stated that an email existed from the Oracle Lobbyist to the people at corporate suggested that spreading some money around might make the problem go away. The mere fact that the lobbyist suggested that goes to the sleaze of the lobbyist and the inherenet sleze in dealing with politicians in general. My understanding is that Oracle Corp. did *not* make the recommended contributions. btw, I'm sure that if Ellison had sold lots of stock at the bottom of the market, and then it went way up, no one would complain. As for Larry selling stock, my understanding is that ORCL has *not* been tanked by any company-specific news (relative to this stock sale). So, maybe Larry just got lucky. Maybe Larry was able to read the market and made an educated decision to sell. It's only illegal if you use priviledged (non-public) information to time a trade. (e.g. if Larry sold the stock the day/week before announcing bad numbers, etc.) Consider reading: http://news.com.com/2104-1017-940514.html (A collection of news.com articles on the CA/ORCL problem) As to the John McCain position on Larry Ellison/Oracle, a search on the http://www.straighttalkamerica.com for oracle or Ellison yields nothing. Now, admittedly, I didn't read Mr. McCain's entire site. And, I will say, that, as congress-critters go, Mr. John McCain seems to be a pretty decent guy. So, (Eric), if you have a more specific link, I'd love to see it. Looking at: http://biz.yahoo.com/t/O/ORCL.html at the Insider Trades on ORCL -- 2001-01-30 ELLISON,LAWRENCE J.(RT12/95) Chief Executive Officer 5,000,000 Planned Sale (Estimated proceeds of $152,742,000) 2001-01-29 ELLISON, LAWRENCE J. Chief Executive Officer 5,000,000 Planned Sale (Estimated proceeds of $151,991,265) 2001-01-26 ELLISON, LAWRENCE J. Chief Executive Officer 2,232,000 Planned Sale (Estimated proceeds of $67,797,000) 2001-01-25 ELLISON, LAWRENCE J. Chief Executive Officer 5,000,000 Planned Sale (Estimated proceeds of $149,685,000) 2001-01-24 ELLISON, LAWRENCE J. Chief Executive Officer 5,000,000 Planned Sale (Estimated proceeds of $150,310,000) 2001-01-23 ELLISON, LAWRENCE J. Chief Executive Officer 5,000,000 Planned Sale (Estimated proceeds of $157,420,000) 2001-01-22 ELLISON, LAWRENCE J. Chief Executive Officer 5,000,000 Planned Sale (Estimated proceeds of $159,060,000) 2001-01-22 - 2001-01-31 ELLISON, LAWRENCE J. Chief Executive Officer 29,084,576 Sale at $30.034 - $32.008 per share. (Proceeds of about $902,233,000) 2001-01-22 - 2001-01-29 ELLISON, LAWRENCE J. Chief Executive Officer 22,232,000 Option Exercise at $0.225 per share. Looking at the Graph for ORCL:
Re[2]:RE: (Fwd/2)
AW ^%$, Pardon me! It's Motorola not Magnavox. Damned old age showing itself, again!! Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/17/2002 2:33 PM Magnavox? As in the TV? ;) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/17/2002 12:35 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re:RE: (Fwd/2) Mike, Apple is still trying to compete with MicroSlop having a hard time of it as well. I believe Apple's major problem competing is that Magnavox chip they remain stuck to. MicroSoft went and let someone else build the machines instead of doing it all themselves. Therefore you end up with a monopoly in software in a sea of competing hardware vendors. Panacea at it's best. OH DARN, here comes those Lindows folks with their Linux based windows environment. Darn, someone had to upset the boat sooner or later. (Got to play with one of those WalMart specials with Lindows on it. I'm SERIOUSLY impressed.) Dick Goulet Reply Separator Author: Johnson; Michael [EMAIL PROTECTED] Date: 7/17/2002 11:05 AM There are those that argue Apple provided competition to Microsoft. Not very good competition, but competition nonetheless and so the monopoly argument goes out the window.I agree Microsoft is substandard product, especially with regard to the server based class. However, the market place has spoken very clearly and it is up to someone else to come and take away some of Microsofts Pie ! In 1998, at Oracle OpenWorld, McNally and Ellision completely trashed Microsoft and Bill Gates in one of those open morning sessions.My thought at the time was , instead of bitchin about them , why dont you just go compete against them and put them out of business. Well, its 2002 and Sun / Oracle now have major business problems and Microsoft just seems to keep on truckin. I havent heard much lately from Scott and Larry regarding this issue. Perhaps they are putting together a good technical presentation for Openworld this year and that will give me a good reason to go. maybe I will hear good technical presentations instead of thoughtless meanderings and tirades about folks they are obviously jeoulous of. FWIW. Mike -Original Message- Sent: Tuesday, July 16, 2002 3:19 PM To: '[EMAIL PROTECTED]' Hi Mike, I just got a bit of a chuckle when you mentioned free market system and Microsoft in the same breath. Microsoft didn't get to be the biggest by having the best product. They got it from the best marketing and unscrupulous and illegal business practices (tried to say that without using the over-used Monopoly!). Oracle can make claims that they are the best because they can actually prove some or most those claims. MS can't. Sorry for sounding like a whiner, but it's been a Microsoft day at it's best. Multiple reboots for everyone! Yay! OK, enough whining. It's no fun when you can't whine/complain to someone without having some brewskis! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Johnson, Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 6:03 PM To: Multiple recipients of list ORACLE-L Subject: RE: (Fwd/2) I would add to this .. In a free market system nobody should look at the negative side when people make money off of their hard work or investments. This is the way it is set up. Why not say damn, how did he do it and where do I get in line to get some of that action ? I always find it interesting the envy and/or disgust that some folks have toward people who make alot of money. Think of all the middle class people Larry Ellison and crew put to work who bought homes and cars to drive our economy. I didnt care for any of Larry and Scotts bitchin and moanin about Microsoft and Bill Gates, but I say to Larry .. More power to you to make more money, keep gettin richer and help build our economy. Keep on truckin ! FWIW. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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
Re:RE: RE: (Fwd/2)
Well, Let's see. It looked like Win2000 for the most part, acted like Win2000 only better faster. Their Office look alike package (little different in feel but not functionality) worked like Office2000 just a little faster. And to boot they had a copy of Doom running right off of the Windows CD?!?!?! This stuff is as advertised, Linux for the masses. I was more than impressed by their software distribution model. You pay a single fee for access to the digital warehouse. There's an icon on the desktop access the warehouse, click on a product it downloads installs itself by itself unless you want to customize it in some way (like a custom location or you don't want a specific driver). The hardware requirements are lower than Win2K as well. Seriously, although Linux did provide M$ with some competition these guys have REALLY thrown down the gauntlet. I get the $99 to upgrade to Lindows and at least at home Windows is history. Dick Goulet Reply Separator Author: Jesse; Rich [EMAIL PROTECTED] Date: 7/18/2002 9:46 AM OK, Dick, you can't leave it at that! What SERIOUSLY impressed you, aside from the dirt cheap price? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 2:36 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: (Fwd/2) Mike, Apple is still trying to compete with MicroSlop having a hard time of it as well. I believe Apple's major problem competing is that Magnavox chip they remain stuck to. MicroSoft went and let someone else build the machines instead of doing it all themselves. Therefore you end up with a monopoly in software in a sea of competing hardware vendors. Panacea at it's best. OH DARN, here comes those Lindows folks with their Linux based windows environment. Darn, someone had to upset the boat sooner or later. (Got to play with one of those WalMart specials with Lindows on it. I'm SERIOUSLY impressed.) -- 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).
(Fwd) FW: Oracle 9i Application Server,
fwiw, naming/numbering of 9i AS R2 on Windows: [(9.0.2.0.1) CD Pack v1 for MS Windows] -Original Message- Sent: Wednesday, July 17, 2002 6:55 PM To: [software librarian] ... Thanks for the info. It is correct that I don't need it for the production Oracle database v8.1.7 that I'm trying to get set up currently, but I will probably want to try to blow up a test server with it in a couple of months(/years?). :) Regards, Eric -Original Message- Sent: Wednesday, July 17, 2002 3:08 PM To: Pierce, Eric D Hi Eric, I just received some software from Oracle: 9i Application Server, Release 2 (9.0.2.0.1) CD Pack v1 for MS Windows. As I remember, this is the one that you asked me to order and then decided you didn't want it. In any case, you're my best Oracle customer, so I put it on the shelf. It'll be sitting there until you come by to visit it some day. ... --- End of forwarded message --- -- 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: (Fwd/2)
There are those that argue Apple provided competition to Microsoft. Not very good competition, but competition nonetheless and so the monopoly argument goes out the window.I agree Microsoft is substandard product, especially with regard to the server based class. However, the market place has spoken very clearly and it is up to someone else to come and take away some of Microsofts Pie ! In 1998, at Oracle OpenWorld, McNally and Ellision completely trashed Microsoft and Bill Gates in one of those open morning sessions.My thought at the time was , instead of bitchin about them , why dont you just go compete against them and put them out of business. Well, its 2002 and Sun / Oracle now have major business problems and Microsoft just seems to keep on truckin. I havent heard much lately from Scott and Larry regarding this issue. Perhaps they are putting together a good technical presentation for Openworld this year and that will give me a good reason to go. maybe I will hear good technical presentations instead of thoughtless meanderings and tirades about folks they are obviously jeoulous of. FWIW. Mike -Original Message- Sent: Tuesday, July 16, 2002 3:19 PM To: '[EMAIL PROTECTED]' Hi Mike, I just got a bit of a chuckle when you mentioned free market system and Microsoft in the same breath. Microsoft didn't get to be the biggest by having the best product. They got it from the best marketing and unscrupulous and illegal business practices (tried to say that without using the over-used Monopoly!). Oracle can make claims that they are the best because they can actually prove some or most those claims. MS can't. Sorry for sounding like a whiner, but it's been a Microsoft day at it's best. Multiple reboots for everyone! Yay! OK, enough whining. It's no fun when you can't whine/complain to someone without having some brewskis! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Johnson, Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 6:03 PM To: Multiple recipients of list ORACLE-L Subject: RE: (Fwd/2) I would add to this .. In a free market system nobody should look at the negative side when people make money off of their hard work or investments. This is the way it is set up. Why not say damn, how did he do it and where do I get in line to get some of that action ? I always find it interesting the envy and/or disgust that some folks have toward people who make alot of money. Think of all the middle class people Larry Ellison and crew put to work who bought homes and cars to drive our economy. I didnt care for any of Larry and Scotts bitchin and moanin about Microsoft and Bill Gates, but I say to Larry .. More power to you to make more money, keep gettin richer and help build our economy. Keep on truckin ! FWIW. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: (Fwd/2)
There are those that argue Apple provided competition to Microsoft. Not very good competition, but competition nonetheless and so the monopoly argument goes out the window. Only because years ago, MS put money in it (100 mill?) and promised to port MS Office and IE to Mac to keep it alive, so there appears to be competition. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: (Fwd/2)
Mike - I think you are right. In fact, an author named Gary Rivlin wrote a book named The Plot to Get Bill Gates: An Irreverent Investigation of the World's Richest Man . . . and the People Who Hate Him. This thesis was just what you describe, that many of Bill Gates competitors get themselves so angry over Bill Gates that their actions aren't even in their own best interests. Larry Ellison is a pretty suave, sophisticated person of no small ego, and I've often thought he probably feels it unfair that Bill Gates who is often characterized in the media as presenting a pretty nerdy image is the computer industry's wealthiest figure. Naturally, when the media needs a sound bite they only go to the top individual, which is Bill, rarely others like Larry. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 17, 2002 2:05 PM To: Multiple recipients of list ORACLE-L There are those that argue Apple provided competition to Microsoft. Not very good competition, but competition nonetheless and so the monopoly argument goes out the window.I agree Microsoft is substandard product, especially with regard to the server based class. However, the market place has spoken very clearly and it is up to someone else to come and take away some of Microsofts Pie ! In 1998, at Oracle OpenWorld, McNally and Ellision completely trashed Microsoft and Bill Gates in one of those open morning sessions.My thought at the time was , instead of bitchin about them , why dont you just go compete against them and put them out of business. Well, its 2002 and Sun / Oracle now have major business problems and Microsoft just seems to keep on truckin. I havent heard much lately from Scott and Larry regarding this issue. Perhaps they are putting together a good technical presentation for Openworld this year and that will give me a good reason to go. maybe I will hear good technical presentations instead of thoughtless meanderings and tirades about folks they are obviously jeoulous of. FWIW. Mike -Original Message- Sent: Tuesday, July 16, 2002 3:19 PM To: '[EMAIL PROTECTED]' Hi Mike, I just got a bit of a chuckle when you mentioned free market system and Microsoft in the same breath. Microsoft didn't get to be the biggest by having the best product. They got it from the best marketing and unscrupulous and illegal business practices (tried to say that without using the over-used Monopoly!). Oracle can make claims that they are the best because they can actually prove some or most those claims. MS can't. Sorry for sounding like a whiner, but it's been a Microsoft day at it's best. Multiple reboots for everyone! Yay! OK, enough whining. It's no fun when you can't whine/complain to someone without having some brewskis! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Johnson, Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 6:03 PM To: Multiple recipients of list ORACLE-L Subject: RE: (Fwd/2) I would add to this .. In a free market system nobody should look at the negative side when people make money off of their hard work or investments. This is the way it is set up. Why not say damn, how did he do it and where do I get in line to get some of that action ? I always find it interesting the envy and/or disgust that some folks have toward people who make alot of money. Think of all the middle class people Larry Ellison and crew put to work who bought homes and cars to drive our economy. I didnt care for any of Larry and Scotts bitchin and moanin about Microsoft and Bill Gates, but I say to Larry .. More power to you to make more money, keep gettin richer and help build our economy. Keep on truckin ! FWIW. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message
Re: (Fwd/2)
Hello Eric I think that you misunderstood. snip | Ellison probably took the money and ran when this | became apparent to him and many others. I know I did. So (regardless of whether Ellison is a good example, or not), do you think that there should be *any* accountability for the social damage caused by greed driven unethical accounting practices? /snip He wrote about investors that have stock and sell them when they see that the market sink. What this have to do with shady or outright criminal accounting practices? I agree with you that whoever is responsible for cooking the books should have to pay, from his own money, all the people that got hurt by this. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 7:13 AM trying again... --- Forwarded message follows --- Responsibility / Re: OT Date: Mon, 15 Jul 2002 15:14:39 -0400 | Original Message: | - | From: Johnson, M=2E | Date: Mon, 15 Jul 2002 10:23:21 -0800 | To: ORACLE-L@fatcity=2Ecom | Subject: RE: McCain on Larry Ellison and Corporate Responsibility / Re: = OT | Not defending Ellison for anything,=20 Understood | but it appears | McCain is just another politician who is only interested | in his future and he constantly takes on these reform | ideas and just makes the matter worse That sounds really cynical to me. Are you just speculating, or do you have any info to back that up? Note that Oracle/Ellison attempted to buy off politicians here in Sacramento in order to stop the JLAC (legislative) audit of Oracle's ELA with the State of California Note that Senator Sarbanes was on the same TV program (Meet the Press) as McCain, and generally agreed with McCain that there is a horrible lack of corporate responsibility, and that reforming the institutions designed to protect the public's interests has been made extremely difficult by the influence of corrupt lobbyists and lack of effective campaign reform Tim Russert (a rare TV journalist with some integrity) and the Senators spent most of their time discussing the issue of putting executive stock options on the expense sheets so as to more correctly reflect profitability (or lack thereof) Do you think it better serves the investment community for sleazy corrupt executives to be able to hide their shenanighans from analysts and investors? | Everyone should accept the fact that we are in a bear | market and as such all the boats go down Argh, that is the problem, when you have these outrageous examples of greedy, corrupt corporate executives cashing out (***AFTER COOKING THE BOOKS***), leaving others to sink | Everyone should have been smart enough to sell stocks and | put their money into cash or better yet short stocks | when it was very clear that in the Fall of 2000 after the | initial March 2000 sell off that we were going into | a prolonged Bear market Should have been !?!?! That isn't really the issue. As mentioned above, the issue was how excess greed played out when the books were cooked to create a false impression of profitability | Ellison probably took the money and ran when this | became apparent to him and many others. I know I did. So (regardless of whether Ellison is a good example, or not), do you think that there should be *any* accountability for the social damage caused by greed driven unethical accounting practices? (fwiw, I'm sympathetic to libertarian/Chicago school free market ideology, but I fear that like its opposite, leftist utopianism, when taken to extremes, it doesn't work all that well in the real world.) regards, ep -Original Message- Sent: Monday, July 15, 2002 5:53 AM To: Multiple recipients of list ORACLE-L OT - unix My understanding is that this was the very first time Ellison had ever sol= d Oracle stock, in over 25 years of the company's existence, in 2000, which = is the occasion that McCain (and you) are referring to=2E As you might be aw= are, there was a far greater opportunity for Ellison to cash out and leave Oracle dangling in 1990, when the price dropped from around $20 to $6 almo= st overnight after some financial-earning restatements=2E On that occasion, = he would certainly have had prior knowledge of what was going to happen, to p= ut it mildly=2E In 2000, any foreknowledge of a long-term downturn (26 month= s and counting?) would have been worth far more than $700m, especially to someone holding several billions in equities=2E=2E=2E - Original Message - To: Multiple recipients of list ORACLE-L ORACLE- L@fatcity=2Ecom Sent: Sunday, July 14, 2002 10:13 PM unix Speaking of herds, or at least what is left behind on the ground after they pass: on Meet the Press (TV program), Senator John McCain said that Larry Ellison cashed out $700,000,000 of his Oracle
RE: (Fwd/2)
Eric, Have you considered the POSSIBILITY that Larry sold the stock without the benefit of insider trading, and simply got lucky with his timing? After all, the main reason Oracle stock has lost so much value is not due to problems specific to the company, but due to problems in the market and economy as a whole. So where would the insider info come into play? And if he really did have insider info, and was acting unethically, why not sell more shares? The amount he sold was probably less than 5% of his holdings. I don't mean to defend ceo misconduct, corporate fraud, etc, I just think you need look this particular accusation a little more objectively, especially when you consider its source. I have great respect for McCain's war record and heroism, but now he is a politician, a Senator no less. IMHO, one can't take anything any politician says at face value. Given a choice between honesty and self-promotion, I'm afraid politicians too often choose the latter. And without getting into specifics about McCain, he seems to be second in the Senate only to my own Sen. Schumer in his love of getting on TV (Q: What's the most dangerous place in NY? A: Between Chuck Schumer and a TV camera). Larry makes a convenient and easy target, someone a politician knows he can attack, get a good soundbite, and have very little chance of being challenged. Gary -Original Message- Sent: Tuesday, July 16, 2002 1:13 AM To: Multiple recipients of list ORACLE-L trying again... --- Forwarded message follows --- Responsibility / Re: OT Date: Mon, 15 Jul 2002 15:14:39 -0400 | Original Message: | - | From: Johnson, M=2E | Date: Mon, 15 Jul 2002 10:23:21 -0800 | To: ORACLE-L@fatcity=2Ecom | Subject: RE: McCain on Larry Ellison and Corporate Responsibility / Re: = OT | Not defending Ellison for anything,=20 Understood | but it appears | McCain is just another politician who is only interested | in his future and he constantly takes on these reform | ideas and just makes the matter worse That sounds really cynical to me. Are you just speculating, or do you have any info to back that up? Note that Oracle/Ellison attempted to buy off politicians here in Sacramento in order to stop the JLAC (legislative) audit of Oracle's ELA with the State of California Note that Senator Sarbanes was on the same TV program (Meet the Press) as McCain, and generally agreed with McCain that there is a horrible lack of corporate responsibility, and that reforming the institutions designed to protect the public's interests has been made extremely difficult by the influence of corrupt lobbyists and lack of effective campaign reform Tim Russert (a rare TV journalist with some integrity) and the Senators spent most of their time discussing the issue of putting executive stock options on the expense sheets so as to more correctly reflect profitability (or lack thereof) Do you think it better serves the investment community for sleazy corrupt executives to be able to hide their shenanighans from analysts and investors? | Everyone should accept the fact that we are in a bear | market and as such all the boats go down Argh, that is the problem, when you have these outrageous examples of greedy, corrupt corporate executives cashing out (***AFTER COOKING THE BOOKS***), leaving others to sink | Everyone should have been smart enough to sell stocks and | put their money into cash or better yet short stocks | when it was very clear that in the Fall of 2000 after the | initial March 2000 sell off that we were going into | a prolonged Bear market Should have been !?!?! That isn't really the issue. As mentioned above, the issue was how excess greed played out when the books were cooked to create a false impression of profitability | Ellison probably took the money and ran when this | became apparent to him and many others. I know I did. So (regardless of whether Ellison is a good example, or not), do you think that there should be *any* accountability for the social damage caused by greed driven unethical accounting practices? (fwiw, I'm sympathetic to libertarian/Chicago school free market ideology, but I fear that like its opposite, leftist utopianism, when taken to extremes, it doesn't work all that well in the real world.) regards, ep -Original Message- Sent: Monday, July 15, 2002 5:53 AM To: Multiple recipients of list ORACLE-L OT - unix My understanding is that this was the very first time Ellison had ever sol= d Oracle stock, in over 25 years of the company's existence, in 2000, which = is the occasion that McCain (and you) are referring to=2E As you might be aw= are, there was a far greater opportunity for Ellison to cash out and leave Oracle dangling in 1990, when the price dropped from around $20 to $6 almo= st overnight after some financial-earning restatements=2E On that occasion, = he would certainly have had prior knowledge of what was
RE: (Fwd/2)
(test, posting from www.mail2web.com) Gary, Certainly. I'm waiting for people to present more factual information. (Maybe Larry needed some petty cash for a new boat or something?) Instead, what you see is people defending the social privileges of the wealthy technocorporate elites, and the ethos of sleaze, extreme greed and selfishness that they are mired in. Do you know if Oracle's accounting practices are currently documented in a way that is transparent to investors? I guess a lot of alleged facts will come out after the august deadline that the SEC has imposed for corporate executives to sign off on the validity of their accounting. regards, ep Original Message: - Date: Tue, 16 Jul 2002 08:53:34 -0800 To: [EMAIL PROTECTED] Eric, Have you considered the POSSIBILITY that Larry sold the stock without the benefit of insider trading, and simply got lucky with his timing? After all, the main reason Oracle stock has lost so much value is not due to problems specific to the company, but due to problems in the market and economy as a whole. So where would the insider info come into play? And if he really did have insider info, and was acting unethically, why not sell more shares? The amount he sold was probably less than 5% of his holdings. I don't mean to defend ceo misconduct, corporate fraud, etc, I just think you need look this particular accusation a little more objectively, especially when you consider its source. I have great respect for McCain's war record and heroism, but now he is a politician, a Senator no less. IMHO, one can't take anything any politician says at face value. Given a choice between honesty and self-promotion, I'm afraid politicians too often choose the latter. And without getting into specifics about McCain, he seems to be second in the Senate only to my own Sen. Schumer in his love of getting on TV (Q: What's the most dangerous place in NY? A: Between Chuck Schumer and a TV camera). Larry makes a convenient and easy target, someone a politician knows he can attack, get a good soundbite, and have very little chance of being challenged. Gary -Original Message- Sent: Tuesday, July 16, 2002 1:13 AM To: Multiple recipients of list ORACLE-L trying again... --- Forwarded message follows --- Responsibility / Re: OT Date: Mon, 15 Jul 2002 15:14:39 -0400 | Original Message: | - | From: Johnson, M=2E | Date: Mon, 15 Jul 2002 10:23:21 -0800 | To: ORACLE-L@fatcity=2Ecom | Subject: RE: McCain on Larry Ellison and Corporate Responsibility / Re: = OT | Not defending Ellison for anything,=20 Understood | but it appears | McCain is just another politician who is only interested | in his future and he constantly takes on these reform | ideas and just makes the matter worse That sounds really cynical to me. Are you just speculating, or do you have any info to back that up? Note that Oracle/Ellison attempted to buy off politicians here in Sacramento in order to stop the JLAC (legislative) audit of Oracle's ELA with the State of California Note that Senator Sarbanes was on the same TV program (Meet the Press) as McCain, and generally agreed with McCain that there is a horrible lack of corporate responsibility, and that reforming the institutions designed to protect the public's interests has been made extremely difficult by the influence of corrupt lobbyists and lack of effective campaign reform Tim Russert (a rare TV journalist with some integrity) and the Senators spent most of their time discussing the issue of putting executive stock options on the expense sheets so as to more correctly reflect profitability (or lack thereof) Do you think it better serves the investment community for sleazy corrupt executives to be able to hide their shenanighans from analysts and investors? | Everyone should accept the fact that we are in a bear | market and as such all the boats go down Argh, that is the problem, when you have these outrageous examples of greedy, corrupt corporate executives cashing out (***AFTER COOKING THE BOOKS***), leaving others to sink | Everyone should have been smart enough to sell stocks and | put their money into cash or better yet short stocks | when it was very clear that in the Fall of 2000 after the | initial March 2000 sell off that we were going into | a prolonged Bear market Should have been !?!?! That isn't really the issue. As mentioned above, the issue was how excess greed played out when the books were cooked to create a false impression of profitability | Ellison probably took the money and ran when this | became apparent to him and many others. I know I did. So (regardless of whether Ellison is a good example, or not), do you think that there should be *any* accountability for the social damage caused by greed driven unethical accounting practices? (fwiw, I'm sympathetic to libertarian/Chicago school free market ideology, but I fear that like its
RE: (Fwd/2)
A new boat, Ferrari, Mig fighter jet, mansion, maybe some Japanese art... the man has some serious expenses. Seriously, I know that Oracle had a problem with shady accounting practices many years ago (late 80's, if I recall correctly). Their stock took a huge hit, and they cleaned up their act. As a result, I think that they have been very conservative in there accounting practices ever since, and have not heard any accusations of untoward accounting practices since them. I admit that I know almost nothing about accounting. Still, I think it the height of hypocrisy for politicians to accuse anyone of shady accounting practices, when, as I understand, the federal govt itself doesn't abide by the Generally Accepted Accounting Principles to which corporations are expected to adhere. All the Worldcoms and Enrons added together don't equal the tax dollars flushed down the toilet due to govt waste, corruption, fraud and incompetence. As an example: http://freedom.house.gov/wastewatch/education.asp Having ceo's sign off on their company's books seems sensible enough. I suspect that when the hot air coming from DC blows over, the investigations will prove that existing laws have been broken, and there will be criminal convictions. Most people don't want to wait for investigations to run their course, and politicians pander to this lack of attention span with by pontificating on TV, then passing more laws, which at best are probably redundant, and at worst have unintended side-effects. The politicians, especially Democrats, have also successfully exploited class-envy with their screw-the-rich-we'll protect-the-little-guy act. It usually works well for them, so they take advantage of it at every opportunity. Gary -Original Message- Sent: Tuesday, July 16, 2002 12:30 PM To: [EMAIL PROTECTED]; Kirsh, Gary (test, posting from www.mail2web.com) Gary, Certainly. I'm waiting for people to present more factual information. (Maybe Larry needed some petty cash for a new boat or something?) Instead, what you see is people defending the social privileges of the wealthy technocorporate elites, and the ethos of sleaze, extreme greed and selfishness that they are mired in. Do you know if Oracle's accounting practices are currently documented in a way that is transparent to investors? I guess a lot of alleged facts will come out after the august deadline that the SEC has imposed for corporate executives to sign off on the validity of their accounting. regards, ep Original Message: - Date: Tue, 16 Jul 2002 08:53:34 -0800 To: [EMAIL PROTECTED] Eric, Have you considered the POSSIBILITY that Larry sold the stock without the benefit of insider trading, and simply got lucky with his timing? After all, the main reason Oracle stock has lost so much value is not due to problems specific to the company, but due to problems in the market and economy as a whole. So where would the insider info come into play? And if he really did have insider info, and was acting unethically, why not sell more shares? The amount he sold was probably less than 5% of his holdings. I don't mean to defend ceo misconduct, corporate fraud, etc, I just think you need look this particular accusation a little more objectively, especially when you consider its source. I have great respect for McCain's war record and heroism, but now he is a politician, a Senator no less. IMHO, one can't take anything any politician says at face value. Given a choice between honesty and self-promotion, I'm afraid politicians too often choose the latter. And without getting into specifics about McCain, he seems to be second in the Senate only to my own Sen. Schumer in his love of getting on TV (Q: What's the most dangerous place in NY? A: Between Chuck Schumer and a TV camera). Larry makes a convenient and easy target, someone a politician knows he can attack, get a good soundbite, and have very little chance of being challenged. Gary -Original Message- Sent: Tuesday, July 16, 2002 1:13 AM To: Multiple recipients of list ORACLE-L trying again... --- Forwarded message follows --- Responsibility / Re: OT Date: Mon, 15 Jul 2002 15:14:39 -0400 | Original Message: | - | From: Johnson, M=2E | Date: Mon, 15 Jul 2002 10:23:21 -0800 | To: ORACLE-L@fatcity=2Ecom | Subject: RE: McCain on Larry Ellison and Corporate Responsibility / Re: = OT | Not defending Ellison for anything,=20 Understood | but it appears | McCain is just another politician who is only interested | in his future and he constantly takes on these reform | ideas and just makes the matter worse That sounds really cynical to me. Are you just speculating, or do you have any info to back that up? Note that Oracle/Ellison attempted to buy off politicians here in Sacramento in order to stop the JLAC (legislative) audit of Oracle's ELA with the State of California Note that Senator Sarbanes was on the same TV program
Re: (Fwd/2)
Not sure about cash for a new boat , but I'm sure read, that Ellison is getting his CEO salary in company stocks (not in cash). This could explain, him selling stocks, though 700,000,000 seems little high. The other point is, that Oracle stock didn't drop overnight - it was going down gradually (along with the rest of the market) for last two years. And, no I'm not Larry's defender, just don't like politicians even more. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 1:33 PM (test, posting from www.mail2web.com) Gary, Certainly. I'm waiting for people to present more factual information. (Maybe Larry needed some petty cash for a new boat or something?) Instead, what you see is people defending the social privileges of the wealthy technocorporate elites, and the ethos of sleaze, extreme greed and selfishness that they are mired in. Do you know if Oracle's accounting practices are currently documented in a way that is transparent to investors? I guess a lot of alleged facts will come out after the august deadline that the SEC has imposed for corporate executives to sign off on the validity of their accounting. regards, ep Original Message: - Date: Tue, 16 Jul 2002 08:53:34 -0800 To: [EMAIL PROTECTED] Eric, Have you considered the POSSIBILITY that Larry sold the stock without the benefit of insider trading, and simply got lucky with his timing? After all, the main reason Oracle stock has lost so much value is not due to problems specific to the company, but due to problems in the market and economy as a whole. So where would the insider info come into play? And if he really did have insider info, and was acting unethically, why not sell more shares? The amount he sold was probably less than 5% of his holdings. I don't mean to defend ceo misconduct, corporate fraud, etc, I just think you need look this particular accusation a little more objectively, especially when you consider its source. I have great respect for McCain's war record and heroism, but now he is a politician, a Senator no less. IMHO, one can't take anything any politician says at face value. Given a choice between honesty and self-promotion, I'm afraid politicians too often choose the latter. And without getting into specifics about McCain, he seems to be second in the Senate only to my own Sen. Schumer in his love of getting on TV (Q: What's the most dangerous place in NY? A: Between Chuck Schumer and a TV camera). Larry makes a convenient and easy target, someone a politician knows he can attack, get a good soundbite, and have very little chance of being challenged. Gary -Original Message- Sent: Tuesday, July 16, 2002 1:13 AM To: Multiple recipients of list ORACLE-L trying again... --- Forwarded message follows --- Responsibility / Re: OT Date: Mon, 15 Jul 2002 15:14:39 -0400 | Original Message: | - | From: Johnson, M=2E | Date: Mon, 15 Jul 2002 10:23:21 -0800 | To: ORACLE-L@fatcity=2Ecom | Subject: RE: McCain on Larry Ellison and Corporate Responsibility / Re: = OT | Not defending Ellison for anything,=20 Understood | but it appears | McCain is just another politician who is only interested | in his future and he constantly takes on these reform | ideas and just makes the matter worse That sounds really cynical to me. Are you just speculating, or do you have any info to back that up? Note that Oracle/Ellison attempted to buy off politicians here in Sacramento in order to stop the JLAC (legislative) audit of Oracle's ELA with the State of California Note that Senator Sarbanes was on the same TV program (Meet the Press) as McCain, and generally agreed with McCain that there is a horrible lack of corporate responsibility, and that reforming the institutions designed to protect the public's interests has been made extremely difficult by the influence of corrupt lobbyists and lack of effective campaign reform Tim Russert (a rare TV journalist with some integrity) and the Senators spent most of their time discussing the issue of putting executive stock options on the expense sheets so as to more correctly reflect profitability (or lack thereof) Do you think it better serves the investment community for sleazy corrupt executives to be able to hide their shenanighans from analysts and investors? | Everyone should accept the fact that we are in a bear | market and as such all the boats go down Argh, that is the problem, when you have these outrageous examples of greedy, corrupt corporate executives cashing out (***AFTER COOKING THE BOOKS***), leaving others to sink | Everyone should have been smart enough to sell stocks and | put their money into cash or better yet short stocks | when it was very clear that in the Fall of 2000 after the | initial March 2000 sell off that we were going into | a prolonged Bear market Should have been
Re:RE: (Fwd/2)
Gary, Well if you know almost nothing about accounting, I'm about 200 ft deeper into the waters than you and still know almost nothing about accounting as it turns out. What is more, I don't even want to get acquainted with the bottom feeders in this here ocean! We've always had the saying about Lier's, damned lier's , and statistics well you had better add accountants to the end cause it sure is one heck of a mess. As for politicains, honest politician I believe is still an oxymoron. SO the politicians and crooked CEO's and accountants should be in good company. Dick Goulet Reply Separator Author: Kirsh; Gary [EMAIL PROTECTED] Date: 7/16/2002 10:18 AM A new boat, Ferrari, Mig fighter jet, mansion, maybe some Japanese art... the man has some serious expenses. Seriously, I know that Oracle had a problem with shady accounting practices many years ago (late 80's, if I recall correctly). Their stock took a huge hit, and they cleaned up their act. As a result, I think that they have been very conservative in there accounting practices ever since, and have not heard any accusations of untoward accounting practices since them. I admit that I know almost nothing about accounting. Still, I think it the height of hypocrisy for politicians to accuse anyone of shady accounting practices, when, as I understand, the federal govt itself doesn't abide by the Generally Accepted Accounting Principles to which corporations are expected to adhere. All the Worldcoms and Enrons added together don't equal the tax dollars flushed down the toilet due to govt waste, corruption, fraud and incompetence. As an example: http://freedom.house.gov/wastewatch/education.asp Having ceo's sign off on their company's books seems sensible enough. I suspect that when the hot air coming from DC blows over, the investigations will prove that existing laws have been broken, and there will be criminal convictions. Most people don't want to wait for investigations to run their course, and politicians pander to this lack of attention span with by pontificating on TV, then passing more laws, which at best are probably redundant, and at worst have unintended side-effects. The politicians, especially Democrats, have also successfully exploited class-envy with their screw-the-rich-we'll protect-the-little-guy act. It usually works well for them, so they take advantage of it at every opportunity. Gary -Original Message- Sent: Tuesday, July 16, 2002 12:30 PM To: [EMAIL PROTECTED]; Kirsh, Gary (test, posting from www.mail2web.com) Gary, Certainly. I'm waiting for people to present more factual information. (Maybe Larry needed some petty cash for a new boat or something?) Instead, what you see is people defending the social privileges of the wealthy technocorporate elites, and the ethos of sleaze, extreme greed and selfishness that they are mired in. Do you know if Oracle's accounting practices are currently documented in a way that is transparent to investors? I guess a lot of alleged facts will come out after the august deadline that the SEC has imposed for corporate executives to sign off on the validity of their accounting. regards, ep Original Message: - Date: Tue, 16 Jul 2002 08:53:34 -0800 To: [EMAIL PROTECTED] Eric, Have you considered the POSSIBILITY that Larry sold the stock without the benefit of insider trading, and simply got lucky with his timing? After all, the main reason Oracle stock has lost so much value is not due to problems specific to the company, but due to problems in the market and economy as a whole. So where would the insider info come into play? And if he really did have insider info, and was acting unethically, why not sell more shares? The amount he sold was probably less than 5% of his holdings. I don't mean to defend ceo misconduct, corporate fraud, etc, I just think you need look this particular accusation a little more objectively, especially when you consider its source. I have great respect for McCain's war record and heroism, but now he is a politician, a Senator no less. IMHO, one can't take anything any politician says at face value. Given a choice between honesty and self-promotion, I'm afraid politicians too often choose the latter. And without getting into specifics about McCain, he seems to be second in the Senate only to my own Sen. Schumer in his love of getting on TV (Q: What's the most dangerous place in NY? A: Between Chuck Schumer and a TV camera). Larry makes a convenient and easy target, someone a politician knows he can attack, get a good soundbite, and have very little chance of being challenged. Gary -Original Message- Sent: Tuesday, July 16, 2002 1:13 AM To: Multiple recipients of list ORACLE-L trying again... --- Forwarded message follows --- Responsibility / Re: OT Date: Mon, 15 Jul 2002 15:14:39 -0400 | Original Message: | - | From:
RE: RE: (Fwd/2)
With any luck, they'll all have the privilege of meeting Ray-Ray on Cell Block D. Maybe we should move this to OT, eh? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: (Fwd/2) Gary, Well if you know almost nothing about accounting, I'm about 200 ft deeper into the waters than you and still know almost nothing about accounting as it turns out. What is more, I don't even want to get acquainted with the bottom feeders in this here ocean! We've always had the saying about Lier's, damned lier's , and statistics well you had better add accountants to the end cause it sure is one heck of a mess. As for politicains, honest politician I believe is still an oxymoron. SO the politicians and crooked CEO's and accountants should be in good company. Dick Goulet -- 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: (Fwd/2)
A lot of the current problem goes back to government intervention. Some politicians/bureaucrats complained that CEO salaries were too high or unfair and (as if they were fit to judge) they decided to control the high CEO salary problem via taxation. So guess what happened? Corporate boards felt they needed to better compensate their CEO's and compensation changed to be more oriented to stocks and options. Suddenly CEO became intensely interested in Wall Street perception and stock values, much of which is driven by accounting reports. Business practices changed because of government intervention to solve a problem and the result was an even worse problem. The original government intervention was justified as an attempt to make things more fair for the little people but the result hurt everyone, especially little people like the small investor. LAISSEZ FAIRE!! Less government = increased prosperity. Adam Smith rules. The above explanation is a bit simplistic and doesn't explain everything but the essence has merit. The market may have periods of irrational exuberance but eventually it self corrects. The founding fathers' focus was to have the government be accountable to the public but now the fixation is with having publicly owned organizations be accountable to the government. In reality public companies are accountable to the public and the correction has already taken place in the stock market. The mindset of America has been turned up-side-down and many of its values no longer reflect the values of the founding fathers or its heritage in the constitution. The founding fathers were considered liberals in their day. Liberally and rhetorically yours, :-) Steve Orr P.S. What does this have to do with Oracle? Well it's kind of like tuning with ratios... Making tuning changes with incomplete understanding may have the opposite effect of what was intended. :-) -Original Message- Sent: Tuesday, July 16, 2002 12:19 PM To: Multiple recipients of list ORACLE-L A new boat, Ferrari, Mig fighter jet, mansion, maybe some Japanese art... the man has some serious expenses. Seriously, I know that Oracle had a problem with shady accounting practices many years ago (late 80's, if I recall correctly). Their stock took a huge hit, and they cleaned up their act. As a result, I think that they have been very conservative in there accounting practices ever since, and have not heard any accusations of untoward accounting practices since them. I admit that I know almost nothing about accounting. Still, I think it the height of hypocrisy for politicians to accuse anyone of shady accounting practices, when, as I understand, the federal govt itself doesn't abide by the Generally Accepted Accounting Principles to which corporations are expected to adhere. All the Worldcoms and Enrons added together don't equal the tax dollars flushed down the toilet due to govt waste, corruption, fraud and incompetence. As an example: http://freedom.house.gov/wastewatch/education.asp Having ceo's sign off on their company's books seems sensible enough. I suspect that when the hot air coming from DC blows over, the investigations will prove that existing laws have been broken, and there will be criminal convictions. Most people don't want to wait for investigations to run their course, and politicians pander to this lack of attention span with by pontificating on TV, then passing more laws, which at best are probably redundant, and at worst have unintended side-effects. The politicians, especially Democrats, have also successfully exploited class-envy with their screw-the-rich-we'll protect-the-little-guy act. It usually works well for them, so they take advantage of it at every opportunity. Gary -Original Message- Sent: Tuesday, July 16, 2002 12:30 PM To: [EMAIL PROTECTED]; Kirsh, Gary (test, posting from www.mail2web.com) Gary, Certainly. I'm waiting for people to present more factual information. (Maybe Larry needed some petty cash for a new boat or something?) Instead, what you see is people defending the social privileges of the wealthy technocorporate elites, and the ethos of sleaze, extreme greed and selfishness that they are mired in. Do you know if Oracle's accounting practices are currently documented in a way that is transparent to investors? I guess a lot of alleged facts will come out after the august deadline that the SEC has imposed for corporate executives to sign off on the validity of their accounting. regards, ep Original Message: - Date: Tue, 16 Jul 2002 08:53:34 -0800 To: [EMAIL PROTECTED] Eric, Have you considered the POSSIBILITY that Larry sold the stock without the benefit of insider trading, and simply got lucky with his timing? After all, the main reason Oracle stock has lost so much value is not due to problems specific to the company, but due to problems in the market and economy as a whole. So where would the insider info come into play?
Re: (Fwd/2)
Certainly. I'm waiting for people to present more factual information. (Maybe Larry needed some petty cash for a new boat or something?) As the story was related to me, Ellison has been living off of loans (from banks, not Oracle) for the past couple decades. His alleged reasoning was that his stocks would appreciate far faster than the interest of the loans, thus making it more economical to borrow than to sell. Obviously, with such a plan, you have to pay off sometime, and in 2000 one (or more) of his lenders called in his loans for payment. Again, this is just hearsay, but that's what I've heard... ...so, in essence, he sold stock because he had (large unexpected) debts to pay. The timing of the stock sale wasn't his, it was some banker's... Instead, what you see is people defending the social privileges of the wealthy technocorporate elites, and the ethos of sleaze, extreme greed and selfishness that they are mired in. Oh, you do yourself far too much justice! My own objection was your prolonged and uninformed vitriol lacking anything more than a politician's media release for substantiation. Go measure some cache-hit ratios, please... Do you know if Oracle's accounting practices are currently documented in a way that is transparent to investors? No idea. Not of interest... I guess a lot of alleged facts will come out after the august deadline that the SEC has imposed for corporate executives to sign off on the validity of their accounting. Sure. Whatever. Whaddya say we get back to work and talk techie stuff and quit wasting time on this fluff? signing off on thread -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: (Fwd/2)
I would add to this .. In a free market system nobody should look at the negative side when people make money off of their hard work or investments. This is the way it is set up. Why not say damn, how did he do it and where do I get in line to get some of that action ? I always find it interesting the envy and/or disgust that some folks have toward people who make alot of money. Think of all the middle class people Larry Ellison and crew put to work who bought homes and cars to drive our economy. I didnt care for any of Larry and Scotts bitchin and moanin about Microsoft and Bill Gates, but I say to Larry .. More power to you to make more money, keep gettin richer and help build our economy. Keep on truckin ! FWIW. Mike -Original Message- Sent: Tuesday, July 16, 2002 1:33 PM To: Multiple recipients of list ORACLE-L Certainly. I'm waiting for people to present more factual information. (Maybe Larry needed some petty cash for a new boat or something?) As the story was related to me, Ellison has been living off of loans (from banks, not Oracle) for the past couple decades. His alleged reasoning was that his stocks would appreciate far faster than the interest of the loans, thus making it more economical to borrow than to sell. Obviously, with such a plan, you have to pay off sometime, and in 2000 one (or more) of his lenders called in his loans for payment. Again, this is just hearsay, but that's what I've heard... ...so, in essence, he sold stock because he had (large unexpected) debts to pay. The timing of the stock sale wasn't his, it was some banker's... Instead, what you see is people defending the social privileges of the wealthy technocorporate elites, and the ethos of sleaze, extreme greed and selfishness that they are mired in. Oh, you do yourself far too much justice! My own objection was your prolonged and uninformed vitriol lacking anything more than a politician's media release for substantiation. Go measure some cache-hit ratios, please... Do you know if Oracle's accounting practices are currently documented in a way that is transparent to investors? No idea. Not of interest... I guess a lot of alleged facts will come out after the august deadline that the SEC has imposed for corporate executives to sign off on the validity of their accounting. Sure. Whatever. Whaddya say we get back to work and talk techie stuff and quit wasting time on this fluff? signing off on thread -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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)
trying again... --- Forwarded message follows --- Responsibility / Re: OT -unix Date: Mon, 15 Jul 2002 18:55:37 -0400 Connect the dots, contrary to the highly postured false rectitude that you are conveying, Ellison has a very long track record of sleaze that at a minimum, ought to elicite a great deal of suspicion. (I will contact McCain's people for additional info, let me know if you would like me to mention you personally :) Assuming that you actually care about corporate responsibility, and aren't just acting pissy for the heck of it, you can find additional background on McCain's position here: http://www.straighttalkamerica.com Most recently, Oracle tried to buy off legislators to thwart an audit of the ELA that Oracle/Logicon put together with the State of California. As far as I'm concerned, all the *ssholes involved in that at Oracle/Logicon, lobbyists, and in the legislature, ought to be in jail. btw, I'm sure that if Ellison had sold lots of stock at the bottom of the market, and then it went way up, no one would complain. regards, ep | Original Message: | - | From: Tim Gorman Tim@SageLogix=2Ecom | Date: Mon, 15 Jul 2002 13:02:06 -0800 | To: ORACLE-L@fatcity=2Ecom | Subject: Re: McCain on Larry Ellison and Corporate Responsibility /=20 | Re: OT - unix | | Nope=2E | | I just thought that people are innocent until proven guilty=2E One=20 | thing about someone in Ellison's position is that it would be=20 | impossible for him to *ever* sell stock without having the unfounded | accusations you've quoted being hurled at him=2E So, are you saying=20 | that it is OK to throw such accusations around, when you don't know | anything about anything? Or is there further substantiation for what | you're saying? Does that mean he should never sell stock? Or should | he just live his life and ignore the critics? | | I respect and admire Sen=2E McCain as much as I respect and admire=20 | anyone, but he is not infallible and he (and his staff) can certainly | be off the mark=2E=2E=2E - Original Message - To: Tim Gorman Tim@SageLogix=2Ecom; ORACLE- L@fatcity=2Ecom Sent: Monday, July 15, 2002 10:49 AM unix Tim, It is my understanding that Oracle's stocks have gone up and down wildly several times=2E As you say, the only time I've heard that Larry Ellison cashed out before a plunge happened was the recent one that McCain brought up=2E I'm afraid I fail to see what you think people should conclude from all that=2E Are you saying that it is ok for stock holding workers and investors to get gigantically screwed just because Larry Ellison has only done it once? -- -- mail2web - Check your email from the web at http://mail2web=2Ecom/ =2E --- End of forwarded message --- -- 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).
(Fwd/2)
trying again... --- Forwarded message follows --- Responsibility / Re: OT Date: Mon, 15 Jul 2002 15:14:39 -0400 | Original Message: | - | From: Johnson, M=2E | Date: Mon, 15 Jul 2002 10:23:21 -0800 | To: ORACLE-L@fatcity=2Ecom | Subject: RE: McCain on Larry Ellison and Corporate Responsibility / Re: = OT | Not defending Ellison for anything,=20 Understood | but it appears | McCain is just another politician who is only interested | in his future and he constantly takes on these reform | ideas and just makes the matter worse That sounds really cynical to me. Are you just speculating, or do you have any info to back that up? Note that Oracle/Ellison attempted to buy off politicians here in Sacramento in order to stop the JLAC (legislative) audit of Oracle's ELA with the State of California Note that Senator Sarbanes was on the same TV program (Meet the Press) as McCain, and generally agreed with McCain that there is a horrible lack of corporate responsibility, and that reforming the institutions designed to protect the public's interests has been made extremely difficult by the influence of corrupt lobbyists and lack of effective campaign reform Tim Russert (a rare TV journalist with some integrity) and the Senators spent most of their time discussing the issue of putting executive stock options on the expense sheets so as to more correctly reflect profitability (or lack thereof) Do you think it better serves the investment community for sleazy corrupt executives to be able to hide their shenanighans from analysts and investors? | Everyone should accept the fact that we are in a bear | market and as such all the boats go down Argh, that is the problem, when you have these outrageous examples of greedy, corrupt corporate executives cashing out (***AFTER COOKING THE BOOKS***), leaving others to sink | Everyone should have been smart enough to sell stocks and | put their money into cash or better yet short stocks | when it was very clear that in the Fall of 2000 after the | initial March 2000 sell off that we were going into | a prolonged Bear market Should have been !?!?! That isn't really the issue. As mentioned above, the issue was how excess greed played out when the books were cooked to create a false impression of profitability | Ellison probably took the money and ran when this | became apparent to him and many others. I know I did. So (regardless of whether Ellison is a good example, or not), do you think that there should be *any* accountability for the social damage caused by greed driven unethical accounting practices? (fwiw, I'm sympathetic to libertarian/Chicago school free market ideology, but I fear that like its opposite, leftist utopianism, when taken to extremes, it doesn't work all that well in the real world.) regards, ep -Original Message- Sent: Monday, July 15, 2002 5:53 AM To: Multiple recipients of list ORACLE-L OT - unix My understanding is that this was the very first time Ellison had ever sol= d Oracle stock, in over 25 years of the company's existence, in 2000, which = is the occasion that McCain (and you) are referring to=2E As you might be aw= are, there was a far greater opportunity for Ellison to cash out and leave Oracle dangling in 1990, when the price dropped from around $20 to $6 almo= st overnight after some financial-earning restatements=2E On that occasion, = he would certainly have had prior knowledge of what was going to happen, to p= ut it mildly=2E In 2000, any foreknowledge of a long-term downturn (26 month= s and counting?) would have been worth far more than $700m, especially to someone holding several billions in equities=2E=2E=2E - Original Message - To: Multiple recipients of list ORACLE-L ORACLE- L@fatcity=2Ecom Sent: Sunday, July 14, 2002 10:13 PM unix Speaking of herds, or at least what is left behind on the ground after they pass: on Meet the Press (TV program), Senator John McCain said that Larry Ellison cashed out $700,000,000 of his Oracle stocks just before they lost most of their value (sarcasm: I'm sure he is planning on plowing it back into the company, especially improving quality in OWS and Metalink)=2E regards, ep On 14 Jul 2002 at 16:28, Alex wrote: Date sent: Sun, 14 Jul 2002 16:28:18 -0800 the future To: Multiple recipients of list ORACLE-L ORACLE-L@fatcity=2Ecom =2E=2E=2E As far as DB vendors targeting linux they move in herds and = have just finished their linux port from when linux was a buzzword=2E =2E=2E -- -- mail2web - Check your email from the web at http://mail2web=2Ecom/ =2E --- End of forwarded message --- -- 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,
(Fwd) ORACLE HAS ONCE AGAIN ROYALLY F*ED UP / Re: Looking for Forms 5
Assuming that you can somehow find the patch number (which is the same as the directory name), this is the new patch download facility: ftp updates.oracle.com cd 1647241 binary get p1647241_210_WINNT.zip ---log file--- 230- 230- Welcome to the Oracle Patch Download FTP Server 230- 230- Access 230- -- 230- Access to this system is limited to authorized users of Oracle 230- Metalink. Unauthorized access to or use of this system is prohibited 230- and may subject you to civil and criminal prosecution. Use of this 230- system may be monitored for the purpose of maintaining system 230- security, and system information may be accessed or disclosed under 230- limited circumstances. 230- 230- All transmissions of Oracle software, documentation, source code, 230- technical data or technology must comply with Oracle's Export 230- Compliance Corporate Policy. For more information, refer to Oracle's 230- Internal Export Control Compliance Manual or contact your division's 230- Export Control Officer. 230- 230- Usage 230- - 230- To download a patch, you must know the patch number. At any time you 230- can cd patch number and then ls to find a listing of patches 230- with that number. Enter quote site help to get this welcome banner 230- and additional helpful instructions. 230- 230- Caveats 230- --- 230- - You may not list files or directories from the root directory. 230- - You must select binary transfers for this service to work. 230 ftp --- dir PORT 192,168,0,2,13,85 200 PORT command OK. --- LIST 150 Opening data connection for file listing. total 1 226-Listing complete. Data connection has been closed. 226-It is the policy of this server to deny all 226-requests to list from the root directory. 226-Only diretories with names which match 226 bug numbers exist and there are too many to be listed. ftp: 9 bytes received in 0.00Seconds 9000.00Kbytes/sec. ftp --- quit QUIT 221 Goodbye. Service closing connection. ---end log file--- --- Forwarded message follows --- Looking for Forms 5 patches To: O D T U G - D E V 2 K - L @ f a t c i t y . c o m Go into Metalink and click on the Patches button on the left: Notice: All critical patches have been moved to this new advanced Patch Download screen. As of June 17, 2002, the old patch download area has been decommissioned. Patch Download Screen, Decommission Information --- http://metalink.oracle.com/metalink/plsql/ml2_documents.showNO T?p_id=199805.1 excerpt: As of June 17, 2002, this portion of the MetaLink patch download area has been decommissioned. For your convenience, all critical patches have been moved from this area to the main patch download area. You can access the main patch download area by clicking on the Patches button in the MetaLink navigation menu. In the unlikely event that you are unable to retrieve a critical patch, please create a Metalink iTar, with details of the required patch, for Oracle Support to resolve. Do not use the MetaLink feedback button to request a patch, as this will only delay the resolution. Thank you! The MetaLink team. --- View the latest Applications Release 11i Packs ( http://ap103aru.us.oracle.com/quicklinks/apps.html ), the latest Oracle Server / Tools Patchsets ( http://ap103aru.us.oracle.com/quicklinks/server.html ), or enter your selection criteria below. Patch Download To view a list of available patches, select a product and platform combination from the drop-down lists. Patch Number: Product Family: select a product family ... Limit Search to: select an entry ... Includes File: ... Order by: Release date Patch Number Copyright (c) 1995, 2001 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use. Of course the profoundly sick b*stards that designed the convoluted select criteria list made it impossible to find something simple like a list of patches for forms 5, you have to rummage around amongst various options/suboptions for Developer, Developer Suite, etc. Another victim of Oracle's byzantine product naming/numbering scheme. Note that a simple search for forms 5 patch returned a vast number of entries that do not appear to be relevant. CAN SOMEBODY PLEASE TELL THE DECISION MAKERS AT ORACLE THAT METALINK SUCKS?!?! Moving right along, I look in Top Tech Docs. Internet Developer Tools seems the closest approximation??? (of course forms 5 may, or may not, be used for Internet, but nevermind.) Ah yes, click Oracle Forms. Under Patches, there is almost nothing useful!!! AMAZING! CAN SOMEBODY PLEASE TELL THE DECISION MAKERS AT ORACLE THAT METALINK SUCKS?!?! Ah, but in 64630.1, there is a link to 74145.1 (Developer Version Number Matrix). hm... : Forms 5.0.5 = Developer 2.0 Forms 5.0.6 = Developer 2.1 So, the
Fwd: [Builder.com] Create an SPFILE in 9i
List, Just by coincidence this came in the mail today. Ron ROR mª¿ªm Oracle Tips at Builder.com Online#[EMAIL PROTECTED] 07/12/02 03:05AM Builder http://builder.com.com Presents your ORACLE E-NEWSLETTER for July 12, 2002 ---Advertisement--- THE DATA STORAGE INFO YOU NEED BEFORE YOU BUY Selecting the appropriate data storage solution is vital to your organization's future. When the choice rests on your shoulders, you need the unbiased expert advice you can only get from TechRepublic - so make an informed decision with IT Professional's Guide to Enterprise Storage book and CD-ROM. Don't wait to hit critical mass! Get the insights and articles to help you through the maze of features, benefits, and limitations of a wide range of data storage solutions. http://clickthru.online.com/Click?q=ec-MHyXQVy2A7t5Hez1D55FiEbDabZR --- CREATE AN SPFILE IN ORACLE9i An exciting new feature of Oracle9i is the removal of the init.ora file. Oracle has replaced the init.ora file because you can now change all parameters dynamically with the ALTER SYSTEM commands. With Oracle9 i, you can manage initialization parameters using a binary server parameter file (SPFILE). By default, a new Oracle9i database will be working on a PFILE, so you must create the SPFILE from the PFILE at the SQL prompt. You can create the SPFILE using the CREATE SPFILE statement, which requires connecting as SYSDBA. Connect system/manager as sysdba; CREATE SPFILE FROM PFILE; This command creates an SPFILE in a nondefault location ($ORACLE_HOME/database). However, you can fully qualify the path name in the CREATE SPFILE statement. CREATE SPFILE='/u01/admin/prod/pfile/file_mydb.ora' FROM PFILE=/u01/admin/prod/pfile/initprod.ora'; After creating an SPFILE, you may encounter an error when you bounce the database. To work around this, you have to reconnect as SYSDBA and use the STARTUP command. The addition of the SPFILE has changed the search path for the Oracle startup deck. In Oracle9i, follow these steps to search for the SPFILE: 1. Search for the spfile$ORACLE_SID.ora file in the default location. 2. Look for the spfile.ora. 3. Search for the PFILE by name: init$ORACLE_SID.ora. SPECIFYING SCOPE Once you have an SPFILE, you can change any initialization parameter with the ALTER SYSTEM command. However, there's an important SCOPE parameter that you need to understand. The SCOPE parameter has three values: SPFILE, MEMORY, and BOTH. Let's look at an example of each. Alter system set db_2k_cache_size=100m SCOPE=SPFILE; If you want to make a change to a parameter in the SPFILE without affecting the current instance, you can do so using the SCOPE=SPFILE option of the ALTER SYSTEM statement. This is useful when you want to make a change starting from the next startup and not for the current instance. Alter system set db_2k_cache_size=100m SCOPE=MEMORY; In the example above, the SCOPE=MEMORY option tells Oracle9i to make the change for the life of the instance and to change it back to the default value the next time the database is bounced. Alter system set db_2k_cache_size=100m SCOPE=BOTH; When you specify SCOPE=BOTH, Oracle makes the change immediately, and Oracle will also make the change permanent, even after the database is bounced. Donald Burleson has been a database administrator for 23 years and has written 14 database books and over 100 articles. He is editor in chief of Oracle Internals and runs Burleson Oracle Consulting. READ MORE ABOUT DEVELOPMENT AN INSIDER'S GUIDE TO ORACLE CERTIFICATION Is an OCP certification your ticket to becoming an Oracle DBA, or is it just one of several important criteria? Check out this article for one expert's opinion. http://clickthru.online.com/Click?q=01-9oXDI2jHgIU_QeWv hPwP4lpp69RR WRITING READABLE CODE Following these simple naming conventions and documentation standards simplifies team code maintenance. Try these techniques on your next project and see if they work for you. http://clickthru.online.com/Click?q=16-T_cjI4cFVqlgbfmDYe9uS3KuRhcR CLIMBING TO THE TOP OF THE CORPORATE TECHNOLOGY LADDER Do your technical skills qualify you for an executive role? Before you fire off that resume to a headhunter, you need to consider a number of critical success factors. Here are some practical suggestions for breaking into the VP club. http://clickthru.online.com/Click?q=2b-2FVYINzsBDSyMkgwISVxZQsc8f9R -- NEW AT BUILDER.COM WHERE WILL THE VISUAL BASIC 6.0 DEVELOPERS GO? You love Visual Basic 6.0, but .NET is breathing down your neck. Should you make the move to Visual Basic .NET or C#? Before you make the choice, check out these three dispelled post-VB6 myths. http://clickthru.online.com/Click?q=41-qqJ1IEKImb3rPLMUvMWCV-BU0ciR COUNTING LINES OF CODE CAN HELP MEASURE PROGRESS One developer believes that counting a developer's lines of code
Subject: Re: [Fwd: Please Advise--Your Reaction to Ellison Comme
Hi, as you were discussing that the message was sent to recent posters I guess you are right. I am twice assigned to the list, once at home and once with my office mail account. As I did recent postings to the list from my office account I only received the Ellison Comment mail at my office mail account. Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: [Fwd: Please Advise--Your Reaction to Ellison Comment]
Jesse is probably right, I am a regular reader to this list but not replying/posting, I didn't get this message. My last post to this list was over a month ago. Aleem -Original Message- Sent: Wednesday, July 10, 2002 10:11 PM To: Multiple recipients of list ORACLE-L Subject:RE: [Fwd: Please Advise--Your Reaction to Ellison Comment] Setting CONCEAL won't help, as I was already concealed. They probably joined the list and harvested the addresses of the posters. I'm guessing that those who haven't posted and who are concealed probably didn't get the Antics message. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 07, 2000 3:21 PM To: Jesse, Rich Subject: Response to your ListGuru session [MsgId xxx] -- SET Oracle-L CONCEAL Your address will no longer appear to ListGuru commands which would display it. -- - Ending ListGuru session. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: [Fwd: Please Advise--Your Reaction to Ellison Comment]
I got it too! Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/9/02 10:08 PM Check this out that i got in email, legitimate? joe Original Message Date: Tue, 09 Jul 2002 17:19:30 -0700 Organization: Antics Online, Inc. To: [EMAIL PROTECTED] Dear Oracle User, I'm writing from Antics Online, an independent marketing agency seeking to understand the high-end database marketspace. We are sending out a one-time email questionnaire to a select group of Oracle users to hear about their experiences. If you have a few minutes and can answer the questions below, I would be most grateful. Simply reply to this email with the answers included. All of your answers will be kept strictly confidential. If you would like, we will happily send you a copy of our findings once they are complete. If you aren't interested in responding, please delete this email. In either case, please know that we respect your time and your privacy and will not contact you again unless you let us know that it is okay. Thanks very much for your invaluable insights, Susan Thomas Director of Research, Antics Online http://www.anticsonline.com 1) ELLISON COMMENT At the Oracle AppsWorld conference in April, Larry Ellison said, We?re trying to establish a relationship with our customers where we not only take the time to help you understand how to use our software but how you?re running your business. Do you believe that Oracle will do what Ellison says? Why or why not? How would you like Oracle to help you understand how to run your business? What else would you like Oracle to help with? 2) ORACLE EXPERIENCE What pieces of Oracle software does your company use? Is your experience with this software mostly positive or mostly negative? Why? Do you plan to upgrade any of your Oracle software in the next year? Are you considering competitors? Which ones? Why? 3) A LITTLE ABOUT YOU What is your role in the company? How long have you been there? And finally, would you be willing to talk with us on the phone for about 15 minutes to share more of your ideas? If so, please give us your phone number and a good time to call (let me stress that we are only interested in doing research and will respect your privacy and desire not to be contacted beyond this study). Would you like to receive a copy of our findings via email? THANK YOU VERY MUCH FOR YOUR HELP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: [Fwd: Please Advise--Your Reaction to Ellison Comment]
May have gotten it, but..DELETE key was faster than my shadow so I'm not sure :-) Khedr, Waleed Waleed.Khedr@fmrTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .comcc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RE: [Fwd: Please Advise--Your Reaction to Ellison Comment] [EMAIL PROTECTED] 10-07-2002 09:08 Please respond to ORACLE-L I got it too! Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/9/02 10:08 PM Check this out that i got in email, legitimate? joe Original Message Date: Tue, 09 Jul 2002 17:19:30 -0700 Organization: Antics Online, Inc. To: [EMAIL PROTECTED] Dear Oracle User, I'm writing from Antics Online, an independent marketing agency seeking to understand the high-end database marketspace. We are sending out a one-time email questionnaire to a select group of Oracle users to hear about their experiences. If you have a few minutes and can answer the questions below, I would be most grateful. Simply reply to this email with the answers included. All of your answers will be kept strictly confidential. If you would like, we will happily send you a copy of our findings once they are complete. If you aren't interested in responding, please delete this email. In either case, please know that we respect your time and your privacy and will not contact you again unless you let us know that it is okay. Thanks very much for your invaluable insights, Susan Thomas Director of Research, Antics Online http://www.anticsonline.com 1) ELLISON COMMENT At the Oracle AppsWorld conference in April, Larry Ellison said, We?re trying to establish a relationship with our customers where we not only take the time to help you understand how to use our software but how you?re running your business. Do you believe that Oracle will do what Ellison says? Why or why not? How would you like Oracle to help you understand how to run your business? What else would you like Oracle to help with? 2) ORACLE EXPERIENCE What pieces of Oracle software does your company use? Is your experience with this software mostly positive or mostly negative? Why? Do you plan to upgrade any of your Oracle software in the next year? Are you considering competitors? Which ones? Why? 3) A LITTLE ABOUT YOU What is your role in the company? How long have you been there? And finally, would you be willing to talk with us on the phone for about 15 minutes to share more of your ideas? If so, please give us your phone number and a good time to call (let me stress that we are only interested in doing research and will respect your privacy and desire not to be contacted beyond this study). Would you like to receive a copy of our findings via email? THANK YOU VERY MUCH FOR YOUR HELP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official
Re: [Fwd: Please Advise--Your Reaction to Ellison Comment]
I also got it. Their web site looks legitimate. I do not think that someone will go to all this trouble just to get your opinion. I do not see the hoax value in this. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 10, 2002 5:08 AM Check this out that i got in email, legitimate? joe Original Message Date: Tue, 09 Jul 2002 17:19:30 -0700 Organization: Antics Online, Inc. To: [EMAIL PROTECTED] Dear Oracle User, I'm writing from Antics Online, an independent marketing agency seeking to understand the high-end database marketspace. We are sending out a one-time email questionnaire to a select group of Oracle users to hear about their experiences. If you have a few minutes and can answer the questions below, I would be most grateful. Simply reply to this email with the answers included. All of your answers will be kept strictly confidential. If you would like, we will happily send you a copy of our findings once they are complete. If you aren't interested in responding, please delete this email. In either case, please know that we respect your time and your privacy and will not contact you again unless you let us know that it is okay. Thanks very much for your invaluable insights, Susan Thomas Director of Research, Antics Online http://www.anticsonline.com 1) ELLISON COMMENT At the Oracle AppsWorld conference in April, Larry Ellison said, We?re trying to establish a relationship with our customers where we not only take the time to help you understand how to use our software but how you?re running your business. Do you believe that Oracle will do what Ellison says? Why or why not? How would you like Oracle to help you understand how to run your business? What else would you like Oracle to help with? 2) ORACLE EXPERIENCE What pieces of Oracle software does your company use? Is your experience with this software mostly positive or mostly negative? Why? Do you plan to upgrade any of your Oracle software in the next year? Are you considering competitors? Which ones? Why? 3) A LITTLE ABOUT YOU What is your role in the company? How long have you been there? And finally, would you be willing to talk with us on the phone for about 15 minutes to share more of your ideas? If so, please give us your phone number and a good time to call (let me stress that we are only interested in doing research and will respect your privacy and desire not to be contacted beyond this study). Would you like to receive a copy of our findings via email? THANK YOU VERY MUCH FOR YOUR HELP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Fwd: Please Advise--Your Reaction to Ellison Comment]
It would be nice to know whether Oracle is funding that marketing research, or someone else. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Wednesday, July 10, 2002 6:13 AM To: Multiple recipients of list ORACLE-L Subject:Re: [Fwd: Please Advise--Your Reaction to Ellison Comment] I also got it. Their web site looks legitimate. I do not think that someone will go to all this trouble just to get your opinion. I do not see the hoax value in this. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 10, 2002 5:08 AM Check this out that i got in email, legitimate? joe Original Message Date: Tue, 09 Jul 2002 17:19:30 -0700 Organization: Antics Online, Inc. To: [EMAIL PROTECTED] Dear Oracle User, I'm writing from Antics Online, an independent marketing agency seeking to understand the high-end database marketspace. We are sending out a one-time email questionnaire to a select group of Oracle users to hear about their experiences. If you have a few minutes and can answer the questions below, I would be most grateful. Simply reply to this email with the answers included. All of your answers will be kept strictly confidential. If you would like, we will happily send you a copy of our findings once they are complete. If you aren't interested in responding, please delete this email. In either case, please know that we respect your time and your privacy and will not contact you again unless you let us know that it is okay. Thanks very much for your invaluable insights, Susan Thomas Director of Research, Antics Online http://www.anticsonline.com 1) ELLISON COMMENT At the Oracle AppsWorld conference in April, Larry Ellison said, We?re trying to establish a relationship with our customers where we not only take the time to help you understand how to use our software but how you?re running your business. Do you believe that Oracle will do what Ellison says? Why or why not? How would you like Oracle to help you understand how to run your business? What else would you like Oracle to help with? 2) ORACLE EXPERIENCE What pieces of Oracle software does your company use? Is your experience with this software mostly positive or mostly negative? Why? Do you plan to upgrade any of your Oracle software in the next year? Are you considering competitors? Which ones? Why? 3) A LITTLE ABOUT YOU What is your role in the company? How long have you been there? And finally, would you be willing to talk with us on the phone for about 15 minutes to share more of your ideas? If so, please give us your phone number and a good time to call (let me stress that we are only interested in doing research and will respect your privacy and desire not to be contacted beyond this study). Would you like to receive a copy of our findings via email? THANK YOU VERY MUCH FOR YOUR HELP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also
Re:[Fwd: Please Advise--Your Reaction to Ellison Comment]
Got one too, looks like we found who did the address harvesting? Reply Separator Author: Joe Testa [EMAIL PROTECTED] Date: 7/9/2002 7:08 PM Check this out that i got in email, legitimate? joe Original Message Date: Tue, 09 Jul 2002 17:19:30 -0700 Organization: Antics Online, Inc. To: [EMAIL PROTECTED] Dear Oracle User, I'm writing from Antics Online, an independent marketing agency seeking to understand the high-end database marketspace. We are sending out a one-time email questionnaire to a select group of Oracle users to hear about their experiences. If you have a few minutes and can answer the questions below, I would be most grateful. Simply reply to this email with the answers included. All of your answers will be kept strictly confidential. If you would like, we will happily send you a copy of our findings once they are complete. If you aren't interested in responding, please delete this email. In either case, please know that we respect your time and your privacy and will not contact you again unless you let us know that it is okay. Thanks very much for your invaluable insights, Susan Thomas Director of Research, Antics Online http://www.anticsonline.com 1) ELLISON COMMENT At the Oracle AppsWorld conference in April, Larry Ellison said, We?re trying to establish a relationship with our customers where we not only take the time to help you understand how to use our software but how you?re running your business. Do you believe that Oracle will do what Ellison says? Why or why not? How would you like Oracle to help you understand how to run your business? What else would you like Oracle to help with? 2) ORACLE EXPERIENCE What pieces of Oracle software does your company use? Is your experience with this software mostly positive or mostly negative? Why? Do you plan to upgrade any of your Oracle software in the next year? Are you considering competitors? Which ones? Why? 3) A LITTLE ABOUT YOU What is your role in the company? How long have you been there? And finally, would you be willing to talk with us on the phone for about 15 minutes to share more of your ideas? If so, please give us your phone number and a good time to call (let me stress that we are only interested in doing research and will respect your privacy and desire not to be contacted beyond this study). Would you like to receive a copy of our findings via email? THANK YOU VERY MUCH FOR YOUR HELP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: [Fwd: Please Advise--Your Reaction to Ellison Comment]
I suspect that they spammed the list. I used it to blow off a little steam. Khedr, Waleed To: Multiple recipients of list ORACLE-L Waleed.Khedr[EMAIL PROTECTED] @FMR.COMcc: Sent by: rootSubject: RE: [Fwd: Please Advise--Your Reaction to Ellison Comment] 07/10/2002 03:08 AM Please respond to ORACLE-L I got it too! Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/9/02 10:08 PM Check this out that i got in email, legitimate? joe Original Message Date: Tue, 09 Jul 2002 17:19:30 -0700 Organization: Antics Online, Inc. To: [EMAIL PROTECTED] Dear Oracle User, I'm writing from Antics Online, an independent marketing agency seeking to understand the high-end database marketspace. We are sending out a one-time email questionnaire to a select group of Oracle users to hear about their experiences. If you have a few minutes and can answer the questions below, I would be most grateful. Simply reply to this email with the answers included. All of your answers will be kept strictly confidential. If you would like, we will happily send you a copy of our findings once they are complete. If you aren't interested in responding, please delete this email. In either case, please know that we respect your time and your privacy and will not contact you again unless you let us know that it is okay. Thanks very much for your invaluable insights, Susan Thomas Director of Research, Antics Online http://www.anticsonline.com 1) ELLISON COMMENT At the Oracle AppsWorld conference in April, Larry Ellison said, We?re trying to establish a relationship with our customers where we not only take the time to help you understand how to use our software but how you?re running your business. Do you believe that Oracle will do what Ellison says? Why or why not? How would you like Oracle to help you understand how to run your business? What else would you like Oracle to help with? 2) ORACLE EXPERIENCE What pieces of Oracle software does your company use? Is your experience with this software mostly positive or mostly negative? Why? Do you plan to upgrade any of your Oracle software in the next year? Are you considering competitors? Which ones? Why? 3) A LITTLE ABOUT YOU What is your role in the company? How long have you been there? And finally, would you be willing to talk with us on the phone for about 15 minutes to share more of your ideas? If so, please give us your phone number and a good time to call (let me stress that we are only interested in doing research and will respect your privacy and desire not to be contacted beyond this study). Would you like to receive a copy of our findings via email? THANK YOU VERY MUCH FOR YOUR HELP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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
RE: [Fwd: Please Advise--Your Reaction to Ellison Comment]
I agree. Think it's Oracle! Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/10/02 7:33 AM It would be nice to know whether Oracle is funding that marketing research, or someone else. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Wednesday, July 10, 2002 6:13 AM To: Multiple recipients of list ORACLE-L Subject:Re: [Fwd: Please Advise--Your Reaction to Ellison Comment] I also got it. Their web site looks legitimate. I do not think that someone will go to all this trouble just to get your opinion. I do not see the hoax value in this. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 10, 2002 5:08 AM Check this out that i got in email, legitimate? joe Original Message Date: Tue, 09 Jul 2002 17:19:30 -0700 Organization: Antics Online, Inc. To: [EMAIL PROTECTED] Dear Oracle User, I'm writing from Antics Online, an independent marketing agency seeking to understand the high-end database marketspace. We are sending out a one-time email questionnaire to a select group of Oracle users to hear about their experiences. If you have a few minutes and can answer the questions below, I would be most grateful. Simply reply to this email with the answers included. All of your answers will be kept strictly confidential. If you would like, we will happily send you a copy of our findings once they are complete. If you aren't interested in responding, please delete this email. In either case, please know that we respect your time and your privacy and will not contact you again unless you let us know that it is okay. Thanks very much for your invaluable insights, Susan Thomas Director of Research, Antics Online http://www.anticsonline.com 1) ELLISON COMMENT At the Oracle AppsWorld conference in April, Larry Ellison said, We?re trying to establish a relationship with our customers where we not only take the time to help you understand how to use our software but how you?re running your business. Do you believe that Oracle will do what Ellison says? Why or why not? How would you like Oracle to help you understand how to run your business? What else would you like Oracle to help with? 2) ORACLE EXPERIENCE What pieces of Oracle software does your company use? Is your experience with this software mostly positive or mostly negative? Why? Do you plan to upgrade any of your Oracle software in the next year? Are you considering competitors? Which ones? Why? 3) A LITTLE ABOUT YOU What is your role in the company? How long have you been there? And finally, would you be willing to talk with us on the phone for about 15 minutes to share more of your ideas? If so, please give us your phone number and a good time to call (let me stress that we are only interested in doing research and will respect your privacy and desire not to be contacted beyond this study). Would you like to receive a copy of our findings via email? THANK YOU VERY MUCH FOR YOUR HELP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
RE: [Fwd: Please Advise--Your Reaction to Ellison Comment]
I got one too. It appears they are harvesting the list. Perhaps some polite feedback would be appropriate?? -Original Message- Sent: Tuesday, July 09, 2002 11:08 PM To: Multiple recipients of list ORACLE-L Check this out that i got in email, legitimate? joe Original Message Date: Tue, 09 Jul 2002 17:19:30 -0700 Organization: Antics Online, Inc. To: [EMAIL PROTECTED] Dear Oracle User, I'm writing from Antics Online, an independent marketing agency seeking to understand the high-end database marketspace. We are sending out a one-time email questionnaire to a select group of Oracle users to hear about their experiences. If you have a few minutes and can answer the questions below, I would be most grateful. Simply reply to this email with the answers included. All of your answers will be kept strictly confidential. If you would like, we will happily send you a copy of our findings once they are complete. If you aren't interested in responding, please delete this email. In either case, please know that we respect your time and your privacy and will not contact you again unless you let us know that it is okay. Thanks very much for your invaluable insights, Susan Thomas Director of Research, Antics Online http://www.anticsonline.com 1) ELLISON COMMENT At the Oracle AppsWorld conference in April, Larry Ellison said, We?re trying to establish a relationship with our customers where we not only take the time to help you understand how to use our software but how you?re running your business. Do you believe that Oracle will do what Ellison says? Why or why not? How would you like Oracle to help you understand how to run your business? What else would you like Oracle to help with? 2) ORACLE EXPERIENCE What pieces of Oracle software does your company use? Is your experience with this software mostly positive or mostly negative? Why? Do you plan to upgrade any of your Oracle software in the next year? Are you considering competitors? Which ones? Why? 3) A LITTLE ABOUT YOU What is your role in the company? How long have you been there? And finally, would you be willing to talk with us on the phone for about 15 minutes to share more of your ideas? If so, please give us your phone number and a good time to call (let me stress that we are only interested in doing research and will respect your privacy and desire not to be contacted beyond this study). Would you like to receive a copy of our findings via email? THANK YOU VERY MUCH FOR YOUR HELP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, 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).