Compaq Tru64 Kernel Parameters for Oracle 8.1.6.2
All, Pretty much says it all in the subject line BUT, does anyone have any links to whitepapers with recommendations on this please ?? Oh yes, the Tru64 is at 5.1 Regards Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
RE: Ability for non DBA user to kill session.
Thanks to all who replied. Regards Lee -Original Message- Sent: 18 April 2001 00:10 To: Multiple recipients of list ORACLE-L Hi All, Further to that, it is necessary to use DBMS_SQL or native dynamic SQL for this as PL/SQL does not support ALTER SYSTEM directly. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Wednesday, 18 April 2001 3:37 To: Multiple recipients of list ORACLE-L Create a procedure as SYS (or someone else powerful) which does the 'alter system' and then grant just the proc to the user hth connor --- lerobe - Lee Robertson [EMAIL PROTECTED] wrote: All, Is there a method for allowing a non DBA user to kill their own (and only their own) session. I have had a trawl through Metalink and have seen various methods (using procedures) of doing it but all of these appear to rely on granting the alter system role to the user. Oracle 8.0.5.0.0 Compaq Tru64 4.0f Regards Lee Lee Robertson Acxiom Tel:0191 525 7344 Fax:0191 525 7007 Email: [EMAIL PROTECTED] The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Ability for non DBA user to kill session.
All, Is there a method forallowing a non DBA user to kill their own (and only their own) session. I have had a trawl through Metalink and have seen various methods (using procedures) of doing it but all of these appear to rely on granting the alter system role to the user. Oracle 8.0.5.0.0 Compaq Tru64 4.0f Regards Lee Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
RE: stupid DBA
end the HELP command for other information (like subscribing). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: shell script to compare nos.
Why not simply do the following passing two parameters to the script eg. call the script test.sh and call it so test.sh 2 1 This results in output "VAR1 is greater than VAR2" then test.sh 1 2 this results in output "VAR2 is greater than VAR1" Cheers. #!/bin/ksh VAR1=$1 VAR2=$2 if [ "$VAR1" -gt "$VAR2" ] then echo "VAR1 is greater than VAR2" else echo "VAR2 is greater than VAR1" fi -Original Message- Sent: 11 April 2001 10:01 To: Multiple recipients of list ORACLE-L Hi I'm sure there are better ways but awk does the trick echo $var1 $var2 | awk '{ if ( $1 $2 ) { print "1"} else { print"0" } }' cheers alex Hello, I need some help in comparing 2 nos. in a unix shell. 1) e.g var1="7.04.03" and var2="7.05" I want to test:- if [ "$var2" "$var1" ];then then $var2 version is greater than $var1" fi 2) 2nd condition is :- var1="7.04.03" var2="7.04.02" I want to test:- if [ "$var1" "$var2" ];then then $var1 version is greater than $var2" fi Can some one send me a code? How can I do the above in shell? Can you please help me, a seemingly simple one! Raja Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Apostolopoulos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: shell script to compare nos.
OK then try the following #!/bin/ksh VAR1=$1 VAR2=$2 opersign=`echo "$VAR1 - $VAR2"|bc| cut -c1` if [ "$opersign" = "-" ] then echo "VAR2 is greater than VAR1" else echo "VAR1 is greater than VAR2" fi That should definitely work. Cheers Lee - Using no book and currently at Acxiom in the UK. -Original Message- Sent: 11 April 2001 11:07 To: 'lerobe - Lee Robertson' Hi Lee, This script only works when the numbers to be compared are whole numbers. It always gives out the result "VAR2 is greater than Var1" when the numbers are real like 7.1, 7.023, 8.6, 9.7 etc. How to return the correct result when the numbers are real? BTW which book do you refer for Korn shell scripting? Where are you now? Whom are you working for? Regards, Ranganath -Original Message- Lee Robertson Sent: Wednesday, April 11, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Why not simply do the following passing two parameters to the script eg. call the script test.sh and call it so test.sh 2 1 This results in output "VAR1 is greater than VAR2" then test.sh 1 2 this results in output "VAR2 is greater than VAR1" Cheers. #!/bin/ksh VAR1=$1 VAR2=$2 if [ "$VAR1" -gt "$VAR2" ] then echo "VAR1 is greater than VAR2" else echo "VAR2 is greater than VAR1" fi -Original Message- Sent: 11 April 2001 10:01 To: Multiple recipients of list ORACLE-L Hi I'm sure there are better ways but awk does the trick echo $var1 $var2 | awk '{ if ( $1 $2 ) { print "1"} else { print"0" } }' cheers alex Hello, I need some help in comparing 2 nos. in a unix shell. 1) e.g var1="7.04.03" and var2="7.05" I want to test:- if [ "$var2" "$var1" ];then then $var2 version is greater than $var1" fi 2) 2nd condition is :- var1="7.04.03" var2="7.04.02" I want to test:- if [ "$var1" "$var2" ];then then $var1 version is greater than $var2" fi Can some one send me a code? How can I do the above in shell? Can you please help me, a seemingly simple one! Raja Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Apostolopoulos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE. OCI
Thanks for all the responses guys Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
OCI
All, Using Oracle 8.0.5.0.0 Compaq Tru64 v4.f One of the duhvelopers here wants to use OCI. I am sure it is installed as part of the server installation but where do all the relevant files live for him to use. I can only find oci files in $ORACLE_HOME/rdbms/demo. Is this normal. ?? Regards Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
RE: Small help (To Lee)
Eh ??? I don't think there is any call for that. I told you whereabouts in the doc set the manuals were and suggested that you look there. I am certainly not a "Great and full of experience DBA" as you suggest but was merely passing on what experience I do have whilst coming across a similar problem myself a couple of years ago. FYI, I have been an Oracle DBA for some 4-5 years now. Please bear this in mind when you next need help/advice because it certainly won't be forthcoming from this direction. Not the best way to kick of your "list career" is it ? Lee -Original Message- Sent: 29 March 2001 09:05 To: Multiple recipients of list ORACLE-L Lee, Thanks for your advise, for me this question is just kick off to the world of ORACLE PL/SQL scripting, I don't know why you think that I would like to ask from a Great and full of experiance DBA like you Mr. Lee to spoon feeding me. Again Thank You so much for your advise Xing, -Original Message- Lee Robertson Sent: Thursday, 29 March 2001 3:16 PM To: Multiple recipients of list ORACLE-L Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mai
RE: Oracle Books on Audio Tapes
Hate to out a dampener on all of this but the guy could be blind. -Original Message- Sent: 29 March 2001 11:50 To: Multiple recipients of list ORACLE-L You know he could be listening to it in his sleep too! Sub-conscious levels and all that.. -Original Message- Ghosalkar Sent: Thursday, March 29, 2001 04:45 To: Multiple recipients of list ORACLE-L try 1. get one of those text to voice tools from download.com 2. next keep a tape recorder near ur comp speakers 3. capture all the text from oracle manuals/soft copy of books(which u can find from the ru domains) and convert to voice 4. enjoy the casette while driving to work -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Books on Audio Tapes Long drive to work ..eh ?? -Original Message- From: Apps Sol [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:21 PM To: Multiple recipients of list ORACLE-L Subject:Oracle Books on Audio Tapes Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Errors in Oracle
From the command line do oerr prefix code error number eg For an Oracle error # oerr ora 1658 01658, 0, "unable to create INITIAL extent for segment in tablespace %s" // *Cause: Failed to find sufficient contiguous space to allocate INITIAL/ / extent for segment being created. // *Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the // tablespace or retry with a smaller value for INITIAL Hope this helps Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] -Original Message- Sent: 29 March 2001 11:20 To: Multiple recipients of list ORACLE-L Anyone who can give me a link to a website, where I can see the description of the Ora-errors I get in sql statements and pl/sql-code, so I understand what the error is about and how to fix it. Roland Skldblom -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Books on Audio Tapes
Dear me - is it my job today to get sarcastic jibes thrown at me. Whose turn is it tomorrow. You said originally Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK You could have been getting them for a blind colleague. Oh sod it - why do I bother. at least its Friday tomorrow. I wonder what the recipe will be.. lightly grilled Lee ? -Original Message- Sent: 29 March 2001 16:35 To: Multiple recipients of list ORACLE-L Yeph.. see I am blind and at the same time I can type too.. can U read this??? rk - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 6:15 AM Hate to out a dampener on all of this but the guy could be blind. -Original Message- Sent: 29 March 2001 11:50 To: Multiple recipients of list ORACLE-L You know he could be listening to it in his sleep too! Sub-conscious levels and all that.. -Original Message- Ghosalkar Sent: Thursday, March 29, 2001 04:45 To: Multiple recipients of list ORACLE-L try 1. get one of those text to voice tools from download.com 2. next keep a tape recorder near ur comp speakers 3. capture all the text from oracle manuals/soft copy of books(which u can find from the ru domains) and convert to voice 4. enjoy the casette while driving to work -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Books on Audio Tapes Long drive to work ..eh ?? -Original Message- From: Apps Sol [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:21 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Books on Audio Tapes Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSU
RE: How to break into DBA/Systems work without going broke doing
hout going broke in the process? PS - I have some ideas, but I'm curious about your ideas. Dan -Original Message- Sent: Thursday, March 29, 2001 11:11 AM To: Multiple recipients of list ORACLE-L Cherie, OK, point well taken, so "silver bullet" would translate into "the one item that will succeed when no other does", "magic formula". And, no he never did say he had an OCP, but he did say he was taking a "course" to get his OCP. To me having an OCP certificate without any experience is totally meaningless. All it tells me is that you can memorize information and take a test. It does not tell me that you'll hold up in a crisis or that you really understand the consequences of your actions. That experience speaks volumes more. Now someone with a number of years experience AND an OCP certificate is a different matter altogether. Consequently my question, are new people looking at the OCP as the gateway into a position that they could not otherwise get? BTW: I'm not trying to either criticize or "brow beat" Xing. If that impression has been left, then I apologize. He asked a question, similar ones I field in house each day, and he was given an answer that is similar to the ones I hand out to my developers although I'd have given him the page number too and a whole lot less trash than Xing has gotten from this list. In my mind that is sufficient to the purpose. Now if that creates additional questions, a much longer dissertation on the results is in order. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 3/29/2001 6:35 AM Dick/Lee/Joe, I'm not trying to defend him but unless I have not yet recieved a post in my mail, Xing never said he had an OCP. Plus, Lee, I think you may need to define "silver bullet". It probably doesn't translate for people who don't use English as a second language. Cherie Machler Gelco Information Network (really too busy this morning migrating a database to be sticking my nose where it doesn't belong) [EMAIL PROTECTED]@fatcity.com on 03/29/2001 08:00:45 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Lee Joe, While I do agree that is possible one should try to figure these things out, and this really is a simple one, there does come a time when asking for help is appropriate. In this case Lee's answer is very much so. As far as taking an OCP course, that does torque my jaws. Over the last two years we must have had 10 people looking for a job who's only mention of Oracle on their resume is that they have their OCP certificate. Needless to say, not a one of them has been invited in for an interview. I'll ask the question that's been bugging me for some time, Xing, do you think this is some kind of "silver bullet" to getting a job? Dick Goulet Reply Separator Author: "Joseph S. Testa" [EMAIL PROTECTED] Date: 3/29/2001 4:05 AM Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe lerobe - Lee Robertson wrote: Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailin
RE: Issues with Oracle on a Compaq Tru64 5.1 Cluster
Is this problem specific to the cluster solution or has it manifested itself on non-clustered setups ? We are about to implement a Tru64 5.1 Oracle 8.1.7 system. As I cannot access the tar you mentioned could you please forward on the instructions. Regards Lee -Original Message- Sent: 27 March 2001 22:43 To: Multiple recipients of list ORACLE-L We use COMPAQ tru64 5.1 with Oracle 8.1.7. we had noticed corruption in some all files and had to apply some O/S level patches. We followed the instructions in the following TAR# 13320267.600. You may want to do a dbv on certain files to ensure there is not corruption. Again we did not notice these problems until RMAN complained of corruption. And we noticed corruption in the redo logs. Murali Vallath Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 27 Mar 2001 08:47:20 -0800 We are running Oracle 8.1.6.2.0 on a new Compaq Tru64 cluster running 5.1 patchkit 1. We have had Oracle running for almost 2 months. For the last several days, we have been experiencing severe I/O issues. The databases will freeze-up and claim that they can't access certain files. Occassionally even 'ls' commands will lock up to, but only when accessing certain sub-directories of file systems. Naturally, we are trying to figure out what has changed in the last few days. We know that the Legatto Networker client was installed, and we also had a UPS failure. In an attempt to isolate the problem, we have removed the Legatto Networker client. Our sysadmins are not seeing any problems at the hardware level. We have completed powered the cluster down and brought it back up. When the databases begin locking up, we do see error messages related to various file systems come across the console. For a few days, we thought it might be RMAN, but I haven't used it in the last 2 days and the problems are still occurring. So, my question is - are any of you folks on a Tru64 5.1 cluster and if so, have you seen similar problems? The systems include 3 GS80s, an ES40, and a Storage Area Network for the disks. We are not running OPS and we are not using raw devices. Thank you, Jay Hostetter -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Small help
Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OFF TOPIC - FW: Sony Vaio Japanese error messages
Very funny In Japan, Sony Vaio machines have replaced the impersonal and unhelpful Microsoft error messages with their own Japanese haiku poetry, each only 17 syllables. --- A file that big? It might be very useful. But now it is gone. The Web site you seek Cannot be located but Countless more exist. Chaos reigns within. Reflect, repent, and reboot. Order shall return. ABORTED effort: Close all that you have worked on. You ask way too much. --- Windows 98 crashed. I am the Blue Screen of Death. No one hears your screams. --- Yesterday it worked. Today it is not working. Windows is like that. First snow, then silence. This thousand dollar screen dies So beautifully. With searching comes loss And the presence of absence: ""My Novel"" not found. The Tao that is seen Is not the true Tao, until You bring fresh toner. Stay the patient course. Of little worth is your ire. The network is down. A crash reduces Your expensive computer To a simple stone. Three things are certain: Death, taxes, and lost data. Guess which has occurred. You step in the stream, But the water has moved on. This page is not here. Out of memory. We wish to hold the whole sky, But we never will. Having been erased, The document you're seeking Must now be retyped. The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA Job at a Chocolate Factory
Yep me to, Government, local Software House, multi-national manufacturing company, and currently working for a large American company (UK office) in the Outsourcing Division -Original Message- Sent: 21 March 2001 18:41 To: Multiple recipients of list ORACLE-L Steve, I don't about unique, but variety is what I enjoy. I've worked at a bank, mortgage bank, diesel engine sales and service, city government and am currently working for an insurance company. Stephen Andert The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to store orace errors in database
Apologies to the original author (William Rogge) of this mail for copying. I kept this the last time it was on the list. Regards Lee STARTS HERE === I had time to play around and was able to accomplish this little task. I hope it is of value to you. First, I am on a UNIX platform, not WINDOWS. I was able to use a combination of a shell script (calling sed), an awk script, a sql to create the table and sqlload to populate the table. This is a long message to include all of the files/command lines, but once the data is in the table, quick references to the data is worthwhile. OK, here goes. Oracles .msg file is an odd structure. They liked to mix apostrophes and quotation marks which made sqlload choke. the general structure is as follows: 0, 0, "this is the error" // *Cause: This is the cause of the error // which may run onto multiple lines // *Action: This is what the user should do to correct the problem // which may also run onto multiple lines. / Then they throw in comments like this. There are cases where they changed their structure, like not giving a Cause or not giving an Action. The awk script accounts for this. They even spelled a few of the keywords wrong in places. Step 1. Make " to ' conversion (shell script file). - - - beginning of file cat $ORACLE_HOME/rdbms/mesg/oraus.msg | sed "s/\"/\'/g" orig_oraus.msg - - - end of file The resultant file is saved for later processing. Step 2. Take out the comment lines and prepare to import with SQL*Loader. (awk script) file name do_help.awk - - - beginning of file BEGIN{li=0; val=0; det=0; cau=0; act=0;} {if (substr($0,1,2) == "//") {if (val == 1) {if ($0 ~ " *Cause" || $0 ~ " *Casue") {printf(",\n//\""); det=1; cau=1; for (i = 3; i = NF ; ++i) {printf("%s ",$i) } } else {if ($0 ~ " *Action") {if (cau == 0) {printf(",\n//\"") cau=1; } printf("\",\n//\""); det=1; act=1; for (i = 3; i = NF ; ++i) {printf("%s ",$i) } } else {if (det == 1) {printf("\n//"); for (i = 2; i = NF ; ++i) {if (i2) {printf(" %s",$i) } else {printf("%s",$i) } } } } } } } else {if (substr($0,1,1) ~ "[0-9]") {pl1=substr($0,1,5) pl2=substr($0,16,length($0)-16) val=1; det=0; if (li == 0) {li=li+1; printf(" \"%5s\",\"%s\"", pl1, pl2) cau=0; act=0; } else {if (cau == 0) {printf(",\n//\"") } if (act == 0) {printf("\",\n//\"") } printf("\"\n \"%5s\",\"%s\"", pl1, pl2) cau=0; act=0; } } else {val=0 } } } END {printf("\"\n")} - - - End of file command to execute the file conversion is awk -f do_help.awk orig_oraus.msg oraus.msg Step 3. Create the database table and grant public select access. (sql script) file name cr_help.sql - - - beginning of file create table help (err_num varchar2(7), err_txt varchar2(200), err_cause varchar2(2000), err_action varchar2(2000), primary key (err_num)) / grant select on help to public / - - - end of file Step 4. Run SQL*Loader with the proper control file. (control file) file name imp_help.control - - - beginning of file load data INFILE 'oraus.msg' TRUNCATE CONTINUEIF NEXT (1:2) = '//' into TABLE help FIELDS TERMINATED BY ',' ( err_num char(5) enclosed by '"', err_txt char enclosed by '"', err_causechar(900) enclosed by '"', err_action char(900) enclosed by '"' ) - - - end of file The execution command is: sqlload userid=user/password control=imp_help.control I will state, that due to Oracle's inconsistencies, you will most likely get some bad records. The ones I encountered was because Oracle had miss coded some of the 23xxx error numbers by having a '// ' at the beginning of the error number record. After editing these, and rerunning the awk and sqlload, I was able to get 100% import. The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received thi
RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
cial ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
ermI don't know how this travels. Like a sugary candy which is extremely hard, you do have candy canes in the States for Christmas trees etc ?? Sort of thicker, straighter version and normally minty in the UK - very popular at Seaside resorts where the sweet is manufactured with the name of the resort printed all the way through the middle. Oh God - this is sounding more weird, the more I try and describe it. Any other Brits who have lived/worked extensively in the States care to offer a better translation ?? Cheers Lee -Original Message- Sent: 20 March 2001 13:26 To: Multiple recipients of list ORACLE-L rhubarb flavored rock I'm working on a tentative assumption here that you don't mean actual rocks... translation please! From: lerobe - Lee Robertson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Date: Tue, 20 Mar 2001 00:05:25 -0800 Been drinking it in the UK for most of my 37 years !!! Used to be a plain old pick me up for years (if you ever had to go into hospital or indeed went visiting, you were either given or giving a bottle). Nowadays it is used by sportsmen etc for exactly what you have described. Regards Lee (one of the original Lucozade kids) PS. This was one of my mothers cravings when she was pregnant with me - however she could only drink it whilst eating rhubarb flavoured rock - WEIRD !! -Original Message- Sent: 19 March 2001 20:41 To: Multiple recipients of list ORACLE-L Speaking of sugar... I just returned from Trinidad (on a mission trip to build a church in Toco). While working in the 95 degree sun all day we often walked up to the corner store and bought water and cokes (the coca cola was much sweeter there than in the US, but also less carbonated). What we also found was a product called Lucozade (http://www.lucozade.com/). This was a sport drink essentially made of glucose syrup. From their website - "When you drink it, the glucose gets rapidly absorbed into your bloodstream and gives you a quick burst of energy. Glucose is the natural preferred fuel for the body becuase of the speed with which it can be digested and absorbed. Once absorbed it is a readily available source of fuel, whic all cells of the body can utilise." Official drink of on-call DBAs. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jack C. Applewhite Sent: Monday, March 19, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe Kimberley, I'd be surprised if you can get "real" raw sugar in stores. When I was in the U.S. Peace Corps in Belize in the mid '70s, raw sugar was readily available, since sugar was a primary export from that beautiful little country. If you let a couple of pounds of raw sugar sit in a brown paper bag for a day or two, the molasses would settle to the bottom and puddle - a jar, shaken occasionally, was a better storage option. It was delicious! There's nothing quite like a peanut butter and raw sugar sandwich! Ironically, the Belizians preferred refined, white sugar, since it was considered more "upscale" than the raw sugar. BTW, other advantages to living in a sugar-exporting country included very cheap soft drinks and rum!...Oh, and Reggae! ;-) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -Original Message- Kimberly Smith Sent: Monday, March 19, 2001 9:33 AM To: Multiple recipients of list ORACLE-L Recipe Hey, found out that muscavado sugar is raw sugar. Hopefully I can find it in the stores. If not I am going to Second Cup and "borrowing" a whole bunch of little packets;-) 375g dark muscovado sugar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] F
RE: Offtopic: Canada and America
ine containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Offtopic: Canada and America
Thats what we liked about Vancouver. Although not so much energy as the City of New York I think. Believe me, we will visit NY, if only to keep my wife happy, she is desperate to go there. -Original Message- Sent: 16 March 2001 14:26 To: Multiple recipients of list ORACLE-L but you must come to NY as well! not just the city (although that's a requirement) but upstate NY as well. one of the things I love best about living here is that I have the energy of the city, and I can also have the beauty and peace of the mountains upstate -- all within a 2 hour drive. But then, I'm prejudiced, I've never lived outside the greater NY metropolitan area. :) From: lerobe - Lee Robertson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Offtopic: Canada and America Date: Fri, 16 Mar 2001 00:17:38 -0800 Speaking as a neutral (English), I like both countries just fine and each has its good (and bad) points. Thoroughly enjoyed all of my trips over there (in fact, we have holidayed nowhere else since 1992) and the thing I like best was depending on where you go (in the same country), outlooks on life, habits and cultures seem to be as diverse as that between some countries. Been to British Columbia (x2) and Alberta in Canada Maine, Florida, Washington(x2), Hawaii(x2), California, Nevada and Arizona in the States. Out of the few places I have been to, I vote Vancouver No 1. I took a lot into consideration here but found it to be the place on top of all other things, where I would consider actually living and putting down roots (Honolulu was fantastic however !!). My wife wanted to live in Victoria on the Island, very pretty but a little sleepy for my liking. I've still got a hell of a lot to see and do (so little time and money). Cheers Lee -Original Message- Sent: 15 March 2001 19:06 To: Multiple recipients of list ORACLE-L Where would the US be without Molsen's and Labatt's, Eh?, ya know? -Original Message- Sent: Thursday, March 15, 2001 12:01 PM To: Multiple recipients of list ORACLE-L RANT Typical, a hotmail account spouting off what they know nothing about. Fact: The longest undefended border in the world is between Canada and the US. ( 7000 miles) Granted this reflects better on the US than Canada, as we could put the whole Canadian population along the border and still couldn't hold hands. Question: Name any other state that has lived peacefully beside it's neighbour with 1/10 of the population for almost 200 years? Russia and the Ukraine? China and Tibet? Germany and Denmark? It is almost 200 years because one of the defining moments of Canadian history is the War of 1812. Canadian Geopolitical Summary: We kicked America's butt. American Geopolitical Summary: We kicked Britains butt. British Geopolitical Summary: We kicked Napoleons butt. Pierre Berton's "War of 1812" and "Flames Across the Border" provide a slightly biased but relatively fair view of this conflict from the Canadian viewpoint. There are no similar British or American texts because the Canadian theatre was a very minor and trivial part of this conflict. Canadian Patriotism On Please note that this is the only war America has ever lost. To a bunch of meek and mild Canadians... /CanPat The truth is that the largest force in Canada at the time was the British army. Typically Canadian, one of our nation building moments hardly involved us. I am proud to be Canadian, I am proud to be best friends with America. Thank you, America for being our friend. Does Canada have problems, you bet. Does America have problems, more than us the poor fellows. We do not follow America, we guide it, help it, support it and party with it. And if the rest of the world was as reasonable as they are, Canada could help them too. ( Apologies to the citizens of many states I have slandered with the above comment ) Before you comment on cultures you have not experienced it would be advisable to at least visit there as a tourist. If you work there for a while you may even realize that what is "common knowledge" is wrong. After spending six weeks in Moscow, 2 years ago, I do not believe anything I read in the media (it is both better and worse than it is reported). And yes, there is a separate Canadian culture. (Part of which is wondering if we have a separate culture.) /RANT Sigh.., and the day after I promised Jared I would behave. Dave -- Dave Morgan Senior Database Administrator Internet Barter Inc. www.bartertrust.com 408-910-4183 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public I
RE: DBA job market in Australia and Asia? - OFF TOPIC KIND OF
Erm. has anyone out there taken the time to learn Japanese ?? I am looking at starting in the next couple of weeks and would like to hear if anyone has struggled and know how hard it is - I know French so any comparisons would be great. REPLIES OFF LIST PLEASE !!! I don't want to clutter up the list with any more crap. I suppose it makes a change from the Oravle V Informix V Sybase V SQL Server etc. etc. Regards Lee -Original Message- Sent: 14 March 2001 23:32 To: Multiple recipients of list ORACLE-L Check out http://www.jobnet.com.au for jobs. There is a reasonable demand. As far as visas are concerned, your options are either to get a tourist visa, a working holiday visa, a temporary business stay visa or apply for permanent residency (or marry a citizen!). Details can be found at http://www.immi.gov.au/ If you are confident in your skills and happy to go contracting, then one medium-risk option would be to come here as a tourist , have a bit of a holiday and then contact a management company. They can take a look at your CV and if they are happy that you can work, they will sponsor you for a business visa (up to 4 years). You will then work as a contractor through agencies, paying a small percentage to the management company. Obviously this advice is informal. Ray - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 1:31 AM What's the job market like for Oracle DBAs in Australia (Queensland and NSW)? Is demand being satisfied mostly with local talent? I've heard that's the case for much of the IT market there. Would it be difficult for an American Oracle DBA to secure a work visa in Australia or Asia? Any demand for English-speaking Oracle DBAs in Asia? I've heard English-speaking techs are in high-demand over in Asia, but where specifically and doing what specifically I don't know (possibly technical training conducted in English, or English for programmers/engineers/techs; or technical writing). How would a person go about finding these jobs? Any companies hiring around Boston that would send Oracle DBAs on overseas assignments? Thanks very much. - Dana __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Ray Feighery INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Weird - unable to extend error
Sorry Paul, Do not pass Go and do not collect 200 quid. One of the other guys in here had logged in as system and was creating an index, his temporary tablespace was set to SYSTEM and therefore Joe's diagnosis below was correct. Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] -Original Message- Sent: 09 March 2001 14:26 To: Multiple recipients of list ORACLE-L In this case the "temporary segment" was not a sort segment, but the space allocated for an index while under construction. I'm surprised that no one here caught that! Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message- Sent: Friday, March 09, 2001 7:17 AM To: Multiple recipients of list ORACLE-L smack your fellow DBA around for logging in as system and not his own id, and I still stand by my statement change the system userid temporary tablespace to temp. joe lerobe - Lee Robertson wrote: Sorry Guys, Ignore this message. One of the other DBAs had logged in from home (he gets in later in the morning than me so I never got a chance to speak to him before sending this mail) and attempted to create an index on a table while logged in as system create index user.tabind blah blah .. and thought by using the fully qualified schema name it would appear in the TS he wanted it in. Ho hum Lee Robertson Acxiom Tel:0191 525 7344 Fax:0191 525 7007 Email: [EMAIL PROTECTED] -Original Message- From: lerobe - Lee Robertson [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 08:25 To: Multiple recipients of list ORACLE-L Subject: Weird - unable to extend error Oracle 8.0.5.0.0 Tru64 4.0f Got in this morning (duh duh duh duh) and found a mail from my alerting script from the DB with the following ORA-1652: unable to extend temp segment by 27309 in tablespace SYSTEM As far as I am aware there was absolutely nothing going on on this system and indeed was the first entry in the alert log file for about 2 hours. (Normal operations on this DB stop at about 18:00 - the message appeared at 20:20.). Should I be worried ?? There have been no entries in the alert log since. (saying that though, people don't start using it until about 9am). Lee Robertson Acxiom Tel:0191 525 7344 Fax:0191 525 7007 Email: [EMAIL PROTECTED] The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this ma
RE: Oracle Upgrade DBA Wanted
I also got that email, I told him thanks for the thought but as I am in the UK the commuting alone would probably kill me. -Original Message- Sent: 02 March 2001 14:32 To: Multiple recipients of list ORACLE-L OK Folks, I got this in the old inbox this morning. Most likely it came from one of the job search services like Monster.com. Funny how those services just can't forget you. Anyway it is of no interest to me, I like the New England area and am not interested in moving, but there may be one or more of you who are interested as has been said in the past. So don't shoot the messenger do make appropriate use of the delete key if needed. Dick Goulet Forward Header_ Author: Mike Green [EMAIL PROTECTED] Date: 3/1/2001 7:39 PM Hi Dick My company is currently looking to hire a full-time Senior Oracle DBA with technical, and some functional, experience supporting Oracle Financial apps. Ideally, we're hoping to find someone who has been through a few backend and application upgrades because we need to begin immediately. The initial project involves upgrading from Oracle 7x to 8i on the RDBMS side then phasing out 10.7 smart client and moving to Oracle 11i / 11.5.2. We're also hoping to phase out many of the customizations that have been made to the financial modules such as HR, OM, GL, AR, AP and Payroll. We're located in the Glendale/Pasadena area which is a great place to live. If you or somebody you know is interested in becoming part of our Oracle team, send me a resume. If you're not interested in this job or don't want to be bothered, send me an email and let me know. Thanks, Michael Green Triad Project Management 3452 E Foothill Blvd Suite 530 Pasadena, CA 91107 [EMAIL PROTECTED] 626-793-7314 -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle DBA evolution path - please share your opinion
stem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unix Cron job help
You could set up a marker file at the end of job A. ie if [ 'successful' ] # insert what ever code you would do to check this. then touch job_ok else 'more code if failure' fi # End of script. When job B kicks in just test for existence of file job_ok before backing up to tape. At the end of job B (or start of job A) delete the file. Personally I have the hot backup and the save to tape all in one script, I don't split the actions. Regards Lee -Original Message- Sent: 27 February 2001 06:00 To: Multiple recipients of list ORACLE-L Dear Lister: I have two cron jobs which run at 10:30 PM 2:00 AM, job A performed a DB hot backup and job B will put those backup files into tapes. The problem is job B is based on the success completion of job A. How can I write the unix script for job B to do this check ? Please help. T.I.A. David Jones ITResource _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Jones INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TEMP tablespace segment management
find out from dba_tablespaces what the current pctincrease value is set to. Then alter the storage for that tablespace to be what it was previously. Regards Lee -Original Message- Sent: 26 February 2001 15:25 To: Multiple recipients of list ORACLE-L Hi: Could someone let me know if there is a way to free up temporary segments in a temporary tablespace, other than bouncing the instance. Thank you, Srini -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT RE: metalink - the final word
Title: OT RE: metalink - the final word So, you don't rate it then -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: 22 February 2001 19:46To: Multiple recipients of list ORACLE-LSubject: OT RE: metalink - the final word I think we can all agree that it is a broken toilet of a web site, unable to flush, and as such, unable to ever completely empty itself of the foaming excreta, cognitive waste, and repellent effluvia streaming from its seething geyser of filth. -Original Message- From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Subject: RE: metalink I would agree with that as well. For such a large company I would have to say that they have one of the worst web pages in the history of web pages. I have seen second year students at The New Jersey Institute of Technology develop better web sites than that. Do you realize that I had to do a search for metalink website because I couldn't find the link on their website. Maybe it was like a project of larry's, he offered it up to some 12 year old HTML gurru and let em go? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, Ross Sent: Wednesday, February 21, 2001 11:07 AM To: Multiple recipients of list ORACLE-L Subject: RE: metalink While this pot is stewing, I'll add the following: What the heck is wrong with Oracle? They have InterMedia nee ConText, and the searchability of their "support" site is embarassingly feeble. Why no "smart searches"? Why no automatic notification when a "Forum" response is logged? Why no moderated lists..or listservers. This stuff ( i.e. "service" ) is cheap, and OWS is making a major mistake by slacking on it. Much as I know people do not like Microsoft, ask any developer/manager about subscriptions to Microsoft Developer Networks..it used to be near free, now it's about 2 grand yearly, and you get *boxes and boxes* of CDs with tools, docs, new languages, white papers, sample code, amazing stuff shrug I guess if you're one of the big fish in the sea, you get to do what you want and let the plankton fall into line.. -Original Message- From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: metalink Wow I agree with that!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, Ross Sent: Wednesday, February 21, 2001 9:46 AM To: Multiple recipients of list ORACLE-L Subject: RE: metalink does anybody know what exactly MetaBlink runs on? last I heard it was clustered 6500's with 6 G of RAM. I actually called client relations to let me know, and they have not returned the call. Sun is good stuff, but the site has been truly flakey for a major corporation's flagship support center. shrug -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 9:21 AM To: Multiple recipients of list ORACLE-L Subject: Re:metalink I was trying to use MetaLink yesterday morning (east coast USA) was getting an authorization error. I called OTS customer service who verified they were having a problem. Wonder if some duhveleper got a fat finger in the wrong place. Dick Goulet Reply Separator Author: "Kevin Kostyszyn" [EMAIL PROTECTED] Date: 2/20/2001 12:00 PM Hi all, Is anyone else having problems with metalink today or is it just my network? Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY,
RE: Ugly error in alert log
Nope. Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] -Original Message- Sent: 22 February 2001 15:20 To: Multiple recipients of list ORACLE-L Do you use the same location for your archivelog destination for 2 databases? Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, February 22, 2001 4:20 AM All, Oracle 8.0.6.0.0 Tru64 4.0f Anyone seen this before an d if so how did you solve it. Oracle have so far drawn a big fat blank on this one. Thu Feb 1 00:03:25 2001 ARCH: Archival error occurred on a closed thread. Archiver continuing. Thu Feb 1 00:03:25 2001 ORACLE Instance /usr/users/oracle/scripts/ - Archival Error. Archiver contin uing. ARCH: Connecting to console port... Thu Feb 1 00:03:25 2001 ORA-00305: log 12 of thread 2 inconsistent; belongs to another database ORA-00312: online log 12 thread 2: '/app/oracle/oradata/drd180redo202.log' ARCH: Connecting to console port... Regards TIA Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ugly error in alert log
apologies to everyone who I've led down a blind alley. The archive location does have the SID in the directory structure. I removed it in the email as it is the name of a client. Sorry for that !!! Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] -Original Message- Sent: 22 February 2001 16:56 To: Multiple recipients of list ORACLE-L We usually put our archives in separate subdirectories per database, i.e. \archives\sid name\.arc. Also, are you naming your archives the same? Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 lerobe - Lee Robertson [EMAIL PROTECTED] 2/22/01 10:51:34 AM Nope. Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] -Original Message- Sent: 22 February 2001 15:20 To: Multiple recipients of list ORACLE-L Do you use the same location for your archivelog destination for 2 databases? Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, February 22, 2001 4:20 AM All, Oracle 8.0.6.0.0 Tru64 4.0f Anyone seen this before an d if so how did you solve it. Oracle have so far drawn a big fat blank on this one. Thu Feb 1 00:03:25 2001 ARCH: Archival error occurred on a closed thread. Archiver continuing. Thu Feb 1 00:03:25 2001 ORACLE Instance /usr/users/oracle/scripts/ - Archival Error. Archiver contin uing. ARCH: Connecting to console port... Thu Feb 1 00:03:25 2001 ORA-00305: log 12 of thread 2 inconsistent; belongs to another database ORA-00312: online log 12 thread 2: '/app/oracle/oradata/drd180redo202.log' ARCH: Connecting to console port... Regards TIA Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Speed up import of a 10gb table with a long_raw datatype
You could up your buffer size and also use impst. Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] -Original Message- Sent: 21 February 2001 16:07 To: Multiple recipients of list ORACLE-L DBA's, Does anyone have any tips for speeding up the import of a 10gb table with a long_raw datatype. I've disabled the constraints, dropped the indexes, put the database in noarchivelog mode. My import parameters are: file=/TEMP_MOUNT/imp_cflo/cfuabprd_blob.dmp log=cfuabprd_blob.log fromuser=x touser=xx tables=REPORT_BLOBT indexes=N rows=Y constraints=N feedback=1000 buffer=200 ignore=Y commit=Y Hardware: Sun E10K 4cpu's 3gb ram OS: solaris2.6 Oracle:8.1.6.2.1 TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Speed up import of a 10gb table with a long_raw datatype
Single stream import. I have noticed significant gains in the past when using this but to be honest I haven't yet used it on an Oracle 8 database (someone else out there may be able to say if it still performs). Go to $ORACLE_HOME/rdbms/lib and type make -f ins_rdbms.mk impst if this doesn't work ( as it didn't for me) with errors on "Can't locate file for: -lndw1" do the following make -f ins_rdbms.mk impst LLIBOWSUTL="" Move the executable into $ORACLE_HOME/bin and use as per the imp command. This also works for export, merely substitute all occurences of impst above with expst. Hope this helps. Regards Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] -Original Message- Sent: 21 February 2001 16:51 To: Multiple recipients of list ORACLE-L Thanks Lee, What is the impst command? I'm not familiar with it. ...JIM... [EMAIL PROTECTED] 2/21/01 10:21:01 AM You could up your buffer size and also use impst. Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] -Original Message- Sent: 21 February 2001 16:07 To: Multiple recipients of list ORACLE-L DBA's, Does anyone have any tips for speeding up the import of a 10gb table with a long_raw datatype. I've disabled the constraints, dropped the indexes, put the database in noarchivelog mode. My import parameters are: file=/TEMP_MOUNT/imp_cflo/cfuabprd_blob.dmp log=cfuabprd_blob.log fromuser=x touser=xx tables=REPORT_BLOBT indexes=N rows=Y constraints=N feedback=1000 buffer=200 ignore=Y commit=Y Hardware: Sun E10K 4cpu's 3gb ram OS: solaris2.6 Oracle:8.1.6.2.1 TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Beta program opportunity
Bugger, not much use for us on Tru64 UNIX. Beta testing ends March 29th 2001. Discover how you can find the root of your storage bottlenecks today! Please check out the "Systems Requirements" link at http://www.quest.com/storage_xpert/system_requirements.asp. You can download the product at http://www.quest.com/storage_xpert/. Please send your feedback to [EMAIL PROTECTED] and technical support queries/issues/problems to [EMAIL PROTECTED] The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: FW: [ Danone ] - Hung Oracle Query
Thanks for the responses from you guys. I went back to our developer with your suggestions and he said, wait for this one !!! Oh I did select from all the tables in the query, I just chopped them out when I passed it onto you as I didn't think it was necessary. Original problem was ... Since the database was bounced Thursday morning I have a query which no longer runs - it just hangs. If I take out the join to X_CITY it works fine. I haven't changed any indexes and all the indexes are correct. Any ideas ? Real SQL is as follows. SELECT i.surname, i.forename, a.address_line_1, a.address_line_2, a.address_line_3, a.address_line_4, a.postcode, c.city_desc, cp.phone_number, ce.email_address, i.date_of_birth, i.gender_code, i.ind_is_child, i.date_of_birth_calc_code, i.individual_id, h.household_id FROM changed_hh_keys chh, householdh, address a, x_city c, individual i, consumer_phone cp, consumer_email ce WHERE h.household_id= chh.household_id ANDa.household_id= h.household_id ANDi.household_id= h.household_id ANDc.city_code = a.city_code ANDcp.consumer_id(+) = i.household_id ANDce.consumer_id(+) = i.individual_id ANDi.consumer_type_code != 'H'; and the plan is.. SELECT STATEMENT Optimizer=CHOOSE (Cost=7224597105017 Card=802455897233888000 Bytes=14925679688550300) NESTED LOOPS (Cost=7224597105017 Card=802455897233888000 Bytes=14925679688550300) MERGE JOIN (OUTER) (Cost=7224597105017 Card=501781749669299000 Bytes=8680824269278870) SORT (JOIN) (Cost=7224597102585 Card=69188658282644 Bytes=11070185325223000) NESTED LOOPS (Cost=3327368730 Card=69188658282644 Bytes=11070185325223000) MERGE JOIN (Cost=3327368730 Card=6918865828264370 Bytes=101707327675486) SORT (JOIN) (Cost=3327245772 Card=55237676133 Bytes=6683758812093) NESTED LOOPS (Cost=831 Card=55237676133 Bytes=6683758812093) MERGE JOIN (OUTER) (Cost=831 Card=1054167 Bytes=86441694) SORT (JOIN) TABLE ACCESS (FULL) OF INDIVIDUAL (Cost=826 Card=1285570 Bytes=88704330) SORT (JOIN) (Cost=4 Card=82 Bytes=1066) TABLE ACCESS (FULL) OF CONSUMER_EMAIL (Cost=1 Card=82 Bytes=1066) INDEX (UNIQUE SCAN) OF HOUSEHOLD_PK (UNIQUE) SORT (JOIN) (Cost=122958 Card=12525628 Bytes=325666328) TABLE ACCESS (FULL) OF ADDRESS (Cost=23275 Card=12525628 Bytes=325666328) INDEX (UNIQUE SCAN) OF X_CITY_PK (UNIQUE) SORT (JOIN) (Cost=2432 Card=725237 Bytes=9428081) INDEX (FULL SCAN) OF CONSUMER_PHONE_PK (UNIQUE) (Cost=26 Card=725237 Bytes=9428081) INDEX (UNIQUE SCAN) OF CHANGED_HH_KEYS_PK (UNIQUE) Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] -Original Message- Sent: 09 February 2001 17:52 To: Multiple recipients of list ORACLE-L Why do you even have the tables consumer_phone and consumer_email included in the query? Obviously you don't care if they have entries in them, and you're not selecting any info out of them. Remove them and see what happens. [EMAIL PROTECTED] 02/09/01 11:41AM Can someone have alook at the problem below please and advise. I am stumped. Regards -Original Message- From: jmydde - James Myddelton Sent: 09 February 2001 16:33 To: lerobe - Lee Robertson Cc: rkilbe - Robert Kilbey Subject: [ Danone ] - Hung Oracle Query Lee, Since the database was bounced Thursday morning I have a query which no longer runs - it just hangs. If I take out the join to X_CITY it works fine. I haven't changed any indexes and all the indexes are correct. Any ideas ? James SELECT i.surname FROMchanged_hh_keys chh, householdh, address a, x_city c, individual i, consumer_phone cp, consumer_email ce WHERE h.household_id= chh.household_id AND a.household_id= h.household_id AND i.household_id= h.household_id AND i.consumer_type_code != 'H' AND c.city_code = a.city_code AND cp.consumer_id(+) = i.household_id AND ce.consumer_id(+) = i.individual_id; SELECT STATEMENT
RE: Resouce Allocation
analyze the table in compute mode. Then select bytes from user_tables where table_name = 'MY_TABLE'; -Original Message- Sent: 09 February 2001 14:56 To: Multiple recipients of list ORACLE-L Dear friends I have a little problem I have a table here the description ... create table my_table ( id number primary key. namevarchar2(20), address varchar2(50), notesvarchar2(4000) ); and then ... I inserted one record, and I wanna know ... How to count a resource allocation from one record ? byte ? kb ? I hope one of you can give me a solution to count resource allocation from one record. Thanks regards abimanyu "I'll be back!" Arnold Schwarzenegger -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Vague request
All, Oracle 8.0.5.0.0 Tru64 4.0f See trace output below call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse0 0.00 0.00 0 0 0 0 Execute 7056 0.59 0.53 0 0 0 3 Fetch 7056 4.61 66.18 16127 84526 0 6973 --- -- -- -- -- -- -- total14112 5.20 66.71 16127 84526 0 6976 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 45 (VM_USER) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 0 SORT (ORDER BY) 0NESTED LOOPS 0 NESTED LOOPS 0 TABLE ACCESS (BY INDEX ROWID) OF 'ADDRESS_OCCUPANCY' 0 INDEX (RANGE SCAN) OF 'ADDRESS_OCCUPANCY_I1' (NON-UNIQUE) 0 TABLE ACCESS (BY INDEX ROWID) OF 'ADDRESS' 0 INDEX (UNIQUE SCAN) OF 'ADDRESS_PK' (UNIQUE) 0 TABLE ACCESS (BY INDEX ROWID) OF 'POSTCODE_MOSAIC' 0 INDEX (UNIQUE SCAN) OF 'POSTCODE_PK' (UNIQUE) Can anyone see what is going wrong here. I haven't a clue yet performance is poor. PS. my tkprof interpretation skills are very much in their infancy. TIA Lee Robertson Acxiom Tel:0191 525 7344 Fax:0191 525 7007 Email: [EMAIL PROTECTED] The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).