Re: Which SQL is executing
SELECT T.SQL_TEXT FROM V$SQLTEXT T,V$SESSION S WHERE S.SQL_ADDRESS=T.ADDRESS ORDER BY T.PIECE; Sam - Original Message - From: Chuan Zhang To: Multiple recipients of list ORACLE-L Sent: Monday, June 04, 2001 9:30 AM Subject: Which SQL is executing Hi All, From v$open_cursor, I know every SQL opened and parsed in one session. Is there any way to know which SQL is running. Or put another way, canall the SQLs in one session be sorted in timing order dynamically? Any clue would be much appreciated. Chuan
Redo Log contention
Hello all, How does one measure if there is a contention for redo logs? 1. Is it that I see that the Log file parallel write has waited for more than 0 (zero)? or 2. You divide:- redo log space requests/no. of redo log entries 0.0002 Please advise. rgds, raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Friday Chocolate thought.
Well Mark, that was amazing !!! If you haven't already tried Marks recipe (posted in March) I urge you to try it. Absolutely gorgeous. Lee -Original Message- Sent: 01 June 2001 21:35 To: Robertson Lee - lerobe; Multiple recipients of list ORACLE-L Lee, Have fun, as for me, I'm off to the UK for three weeks. Mail from the list has been temporarily turned off, thanks Bruce your ListGuru works very well. See you all when I get back around June 25th!! Dick Goulet Reply Separator Author: Robertson Lee - lerobe [EMAIL PROTECTED] Date: 6/1/2001 8:05 AM Guys, I am attempting Mark Leiths chocolate cake this weekend. (Rachels chocolate mousse cake in a couple of weeks). I will let you all in on the results on Monday (if I can get out of my sofa !!) 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. !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META content=MSHTML 5.00.2920.0 name=GENERATOR/HEAD BODY DIVFONT face=Arial size=2SPAN class=578020215-01062001Guys,/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=578020215-01062001/SPAN/FONTnbsp;/DIV DIVFONT face=Arial size=2SPAN class=578020215-01062001I am attempting Mark Leiths chocolate cake this weekend. (Rachels chocolate mousse cake in a couple of weeks). /SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=578020215-01062001/SPAN/FONTnbsp;/DIV DIVFONT face=Arial size=2SPAN class=578020215-01062001I will let you all in on the results on Monday (if I can get out of my sofa !!)/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=578020215-01062001/SPAN/FONTnbsp;/DIV DIVFONT face=Arial size=2SPAN class=578020215-01062001Lee/SPAN/FONT/DIV P!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN/P DIVnbsp;/DIVCODEFONT SIZE=3BR BR The information contained in this communication isBR confidential, is intended only for the use of the recipientBR named above, and may be legally privileged. If the reader BR of this message is not the intended recipient, you areBR hereby notified that any dissemination, distribution orBR copying of this communication is strictly prohibited. BR If you have received this communication in error, please BR re-send this communication to the sender and delete the BR original message or any copy of it from your computerBR system.BR /FONT/CODE/BODY/HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: urgent regarding server manager..
Saurabh, I believe the only command line option for server manager is @script So you'll need to create a .sql script that contains the connect statement. Keep in mind that server manager is going away in 9i so you should start using sqlplus for 8i+. HTH, -- Anita --- Saurabh Sharma [EMAIL PROTECTED] wrote: hi all, i want help regarding automation of connecting to server manager through script file. i want when i run script, it automatically launch svrmgr program and simultaneously pass the connect string so that it gives me svrmgr connected. while passing the connect string along with svrmgr80 command at c prompt results in msg too many parameters.. can anyone help getting me started. thanks in advance. saurabh __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.
Thank you very much, Ruth, but it doesn't our problem. We have same tnsnames in our server and client machines. Best regards. Miguel. 01/06/2001 20.51 Ruth Gramolini [EMAIL PROTECTED] 01/06/2001 20.06 Por favor, responda a [EMAIL PROTECTED] Remitente [EMAIL PROTECTED] Do you have a tnsnames file on the server you are using to access sqlplus? If not, put a copy of your tnsnames file and set you ORACLE_SID before trying sqlplus. Just a thot... Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 01, 2001 9:45 AM Hi folks, again. I was subscribed two years ago and I'm stay here again. I'm facing to a curious problem with Oracle 8.1.6.3 over Solaris 2.6. When I connect to sqlplus via tnsnames.ora I'm getting following errors: SQL*Plus: Release 8.1.6.0.0 - Production on Fri Jun 1 10:08:58 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Enter password: ERROR: ORA-01012: not logged on SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level. Connected to: Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production With the Partitioning and Parallel Server options JServer Release 8.1.6.3.0 - Production SQL select * from dual; select * from dual * ERROR at line 1: ORA-01012: not logged on SQL But when I connect from same machine where reside Oracle, I have no problems. ¿Anybody knows something about that?. Thank you very mucha in advance. Regards. Miguel Urosa. Este mensaje y los documentos que, en su caso, lleve anexos, pueden contener información confidencial. Por ello, se informa a quien lo reciba por error que la información contenida en el mismo es reservada y su uso no autorizado está prohibido legalmente, por lo que en tal caso le rogamos que nos lo comunique por la misma vía o por teléfono (901 113 113) , se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). |--| | Destinatario Multiple recipients of list ORACLE-L [EMAIL PROTECTED] | | Copia| |--| Este mensaje y los documentos que, en su caso, lleve anexos, pueden contener información confidencial. Por ello, se informa a quien lo reciba por error que la información contenida en el mismo es reservada y su uso no autorizado está prohibido legalmente, por lo que en tal caso le rogamos que nos lo comunique por la misma vía o por teléfono (901 113 113) , se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. -- 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
RE: Friday Chocolate thought.
Sorry did I mention that it was even nicer, slightly warm with double cream poured over the top -Original Message- Sent: 04 June 2001 10:16 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Thanks, Lee. It was bad enough that you had to let us know you were going to make chocolate cake, but then you have to go and flaunt how good it was! I bet you were the type to bring candy to school when you didn't have enough for the whole class ;) -- Anita --- Robertson Lee - lerobe [EMAIL PROTECTED] wrote: Well Mark, that was amazing !!! If you haven't already tried Marks recipe (posted in March) I urge you to try it. Absolutely gorgeous. Lee -Original Message- Sent: 01 June 2001 21:35 To: Robertson Lee - lerobe; Multiple recipients of list ORACLE-L Lee, Have fun, as for me, I'm off to the UK for three weeks. Mail from the list has been temporarily turned off, thanks Bruce your ListGuru works very well. See you all when I get back around June 25th!! Dick Goulet Reply Separator Author: Robertson Lee - lerobe [EMAIL PROTECTED] Date: 6/1/2001 8:05 AM Guys, I am attempting Mark Leiths chocolate cake this weekend. (Rachels chocolate mousse cake in a couple of weeks). I will let you all in on the results on Monday (if I can get out of my sofa !!) 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. !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META content=MSHTML 5.00.2920.0 name=GENERATOR/HEAD BODY DIVFONT face=Arial size=2SPAN class=578020215-01062001Guys,/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=578020215-01062001/SPAN/FONTnbsp;/DIV DIVFONT face=Arial size=2SPAN class=578020215-01062001I am attempting Mark Leiths chocolate cake this weekend. (Rachels chocolate mousse cake in a couple of weeks). /SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=578020215-01062001/SPAN/FONTnbsp;/DIV DIVFONT face=Arial size=2SPAN class=578020215-01062001I will let you all in on the results on Monday (if I can get out of my sofa !!)/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=578020215-01062001/SPAN/FONTnbsp;/DIV DIVFONT face=Arial size=2SPAN class=578020215-01062001Lee/SPAN/FONT/DIV P!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN/P DIVnbsp;/DIVCODEFONT SIZE=3BR BR The information contained in this communication isBR confidential, is intended only for the use of the recipientBR named above, and may be legally privileged. If the reader BR of this message is not the intended recipient, you areBR hereby notified that any dissemination, distribution orBR copying of this communication is strictly prohibited. BR If you have received this communication in error, please BR re-send this communication to the sender and delete the BR original message or any copy of it from your computerBR system.BR /FONT/CODE/BODY/HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ 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: Robertson Lee -
RE: Friday Chocolate thought.
Thanks, Lee. It was bad enough that you had to let us know you were going to make chocolate cake, but then you have to go and flaunt how good it was! I bet you were the type to bring candy to school when you didn't have enough for the whole class ;) -- Anita --- Robertson Lee - lerobe [EMAIL PROTECTED] wrote: Well Mark, that was amazing !!! If you haven't already tried Marks recipe (posted in March) I urge you to try it. Absolutely gorgeous. Lee -Original Message- Sent: 01 June 2001 21:35 To: Robertson Lee - lerobe; Multiple recipients of list ORACLE-L Lee, Have fun, as for me, I'm off to the UK for three weeks. Mail from the list has been temporarily turned off, thanks Bruce your ListGuru works very well. See you all when I get back around June 25th!! Dick Goulet Reply Separator Author: Robertson Lee - lerobe [EMAIL PROTECTED] Date: 6/1/2001 8:05 AM Guys, I am attempting Mark Leiths chocolate cake this weekend. (Rachels chocolate mousse cake in a couple of weeks). I will let you all in on the results on Monday (if I can get out of my sofa !!) 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. !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META content=MSHTML 5.00.2920.0 name=GENERATOR/HEAD BODY DIVFONT face=Arial size=2SPAN class=578020215-01062001Guys,/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=578020215-01062001/SPAN/FONTnbsp;/DIV DIVFONT face=Arial size=2SPAN class=578020215-01062001I am attempting Mark Leiths chocolate cake this weekend. (Rachels chocolate mousse cake in a couple of weeks). /SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=578020215-01062001/SPAN/FONTnbsp;/DIV DIVFONT face=Arial size=2SPAN class=578020215-01062001I will let you all in on the results on Monday (if I can get out of my sofa !!)/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=578020215-01062001/SPAN/FONTnbsp;/DIV DIVFONT face=Arial size=2SPAN class=578020215-01062001Lee/SPAN/FONT/DIV P!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN/P DIVnbsp;/DIVCODEFONT SIZE=3BR BR The information contained in this communication isBR confidential, is intended only for the use of the recipientBR named above, and may be legally privileged. If the reader BR of this message is not the intended recipient, you areBR hereby notified that any dissemination, distribution orBR copying of this communication is strictly prohibited. BR If you have received this communication in error, please BR re-send this communication to the sender and delete the BR original message or any copy of it from your computerBR system.BR /FONT/CODE/BODY/HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBA_OBJECTS
Bunyamin, Why don't you use v$locked_object ? "Bunyamin K. Karadeniz" wrote: I want to select locked_objects in a view.I runCREATE OR REPLACE VIEW V_BUN_LOCKED_OBJECTS ASSELECT sn.username, m.sid, m.type, DECODE(m.lmode, 0, 'None' , 1, 'Null' , 2, 'Row Share' , 3, 'Row Excl.' , 4, 'Share' , 5, 'S/Row Excl.' , 6, 'Exclusive' , lmode, ltrim(to_char(lmode,'990'))) lmode, DECODE(m.request, 0, 'None' , 1, 'Null' , 2, 'Row Share' , 3, 'Row Excl.' , 4, 'Share' , 5, 'S/Row Excl.' , 6, 'Exclusive' , request, ltrim(to_char(request,'990'))) request, obj1.object_name objname, obj2.object_name objname FROM v$session sn, V$lock m, dba_objects obj1, dba_objects obj2 WHERE sn.sid = m.sid AND m.id1 = obj1.object_id (+) AND m.id2 = obj2.object_id (+) AND lmode != 4 ;and gives error or ora-942. Can not find dba_objects .But with the same user I can query dba_objects table since my user has dba privilege.The inside of view runs perfectly.Why can it be?? -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. *
RE: COCO Proposal Review
So tell me Lee, how was the choccy cake? :) -Original Message- Lee - lerobe Sent: Monday, June 04, 2001 08:55 To: Multiple recipients of list ORACLE-L Damn, thought it was something to do with Chocolate -Original Message- Sent: 02 June 2001 00:15 To: Multiple recipients of list ORACLE-L All, I have just thrown together a proposal I plan on sending out to a bunch of Oracle related groups (user groups etc..) to attempt to get some help in putting together training for OCP. Primarily I'm just using OCP as a basis for creating free Oracle training. Some of you may already be aware of my fledgling web site (work of love). Anyway I would like to get your comments on the proposal as I suppose I have probably missed responding to some fairly obvious questions in my zeal to get it out. Please contact me offline because I don't want to cludge up the list with this, just want to get your opinions both negative and positive and address what you think might be questions that would arise. Thanks to all who help me out, there are some very cool and very competant pro's on this list. Save the flames regarding paper OCP's as the training is not going to be an exam cram but real training and no need to throw out the baby with the bath water. http://www.freetechnicaltraining.com/docs/cocp_proposal.doc - Ethan Post -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: COCO Proposal Review
Already put the verdict out mate. Tremendous You were right though. I couldn't wait for it to cool down even, never mind 24 hours. My sister already wants me to make another dozen !! Lee -Original Message- Sent: 04 June 2001 11:31 To: Multiple recipients of list ORACLE-L So tell me Lee, how was the choccy cake? :) -Original Message- Lee - lerobe Sent: Monday, June 04, 2001 08:55 To: Multiple recipients of list ORACLE-L Damn, thought it was something to do with Chocolate -Original Message- Sent: 02 June 2001 00:15 To: Multiple recipients of list ORACLE-L All, I have just thrown together a proposal I plan on sending out to a bunch of Oracle related groups (user groups etc..) to attempt to get some help in putting together training for OCP. Primarily I'm just using OCP as a basis for creating free Oracle training. Some of you may already be aware of my fledgling web site (work of love). Anyway I would like to get your comments on the proposal as I suppose I have probably missed responding to some fairly obvious questions in my zeal to get it out. Please contact me offline because I don't want to cludge up the list with this, just want to get your opinions both negative and positive and address what you think might be questions that would arise. Thanks to all who help me out, there are some very cool and very competant pro's on this list. Save the flames regarding paper OCP's as the training is not going to be an exam cram but real training and no need to throw out the baby with the bath water. http://www.freetechnicaltraining.com/docs/cocp_proposal.doc - Ethan Post -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail
Re: DBA_OBJECTS
Because your privileges to select against DBA_OBJECTS was granted through a role and role privileges are disabled in views. You'll need to have select privileges explicitly granted on the underlying objects. HTH, -- Anita --- Bunyamin K. Karadeniz [EMAIL PROTECTED] wrote: I want to select locked_objects in a view. I run CREATE OR REPLACE VIEW V_BUN_LOCKED_OBJECTS AS SELECT sn.username, m.sid, m.type, DECODE(m.lmode, 0, 'None' , 1, 'Null' , 2, 'Row Share' , 3, 'Row Excl.' , 4, 'Share' , 5, 'S/Row Excl.' , 6, 'Exclusive' , lmode, ltrim(to_char(lmode,'990'))) lmode, DECODE(m.request, 0, 'None' , 1, 'Null' , 2, 'Row Share' , 3, 'Row Excl.' , 4, 'Share' , 5, 'S/Row Excl.' , 6, 'Exclusive' , request, ltrim(to_char(request,'990'))) request, obj1.object_name objname, obj2.object_name objname FROM v$session sn, V$lock m, dba_objects obj1, dba_objects obj2 WHERE sn.sid = m.sid AND m.id1 = obj1.object_id (+) AND m.id2 = obj2.object_id (+) AND lmode != 4 ; and gives error or ora-942. Can not find dba_objects . But with the same user I can query dba_objects table since my user has dba privilege. The inside of view runs perfectly. Why can it be?? __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Auto Extend
Hi John, I still haven't learned not to make sweeping statements on mailing lists = ) I expected someone to raise SMON or checkpoint overheads so I added necessarily very deliberately. Agreed, I'd tend to keep the number of files down to a reasonable number but I've run a database with 3,500 datafiles and it didn't choke on log switches at all. As you say, appropriately sized redo logs can mitigate the effects to some extent. Regards, Mike Hately, Oracle DBA John Kanagaraj [EMAIL PROTECTED] Neither large files nor small files are evil. As with all things, fit the solution to the problem. Small files can leave you with lots of separate datafiles which isn't necessarily a drag on performance but can be an administrative chore and can cause more wasted space due to that pesky 'end-of-datafile' free extent. Mike, I will have to disagree with you about small files not necessarily being a drag on performance. Given a specific size of a database, it would be better to go in for larger files (avoiding the 2Gb pitfall if possible) since each datafile adds its own component to the flurry of I/O activity that takes place during log switch, i.e. when all datafile headers need to be updated. In simpler terms, (Large number of) Small datafiles + small redo logs + high DML activity = disaster during (the frequent) log switches... People who want to set up databases larger than a terabyte will inevitably have a budget to invest in new kit and buy-in to up to date OS and software levels. Not everyone has that luxury and a lot of legacy kit doesn't like 2GB+ files. That's only my opinion but really, why play around with any area that is demonstrably strewn with bugs unless you need to? Fully agreed! John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: What causes a last_analyzed date of 00-000-00?
Cherie, The only bug I'm aware of on this is a bug I encountered on 8.1.6 (bug 1161906), but it was fixed in 8.1.7.0.0, so you shouldn't be encountering it on 8.1.7.1 and AFAIK it did not happen in 7.3.x. Bug 1161906 resulted in 00-000-00 dates in last_analyzed when stats were computed on indexes when stats had not been computed or estimated on the tables. The obvious workaround was to calculate table stats before index stats. HTH, -- Anita --- [EMAIL PROTECTED] wrote: I just migrated a database from 7.3.4 to 8.1.7.1 on Sun Solaris 2.6. I do not believe that there were any statistics on this database before it was migrated. During the process of the migration, I followed the instruction and switched optimizer_mode from rule to choose. After it was upgraded, there were some pockets of extremely poor performance. On a hunch, I looked at the last_analyzed date of all my non-system tables. I was surprised to see that about a third of the tables seemed to have junk statistics in existence with a last_analyzed date of 00-000-00. What might have caused these statistics to be out there? I doubt that we had pre-existing statistics because I've had them prior to upgrades and afterwards they've continued to have the same valid dates on them as they had before the upgrade. Anybody seen these junk statistics before? I got rid of them and everything was fine but I'd like to prevent them from being created the next time that we do a 7.3.4 to 8.1.7.1 upgrade. Any light anyone can shed is appreciated. Thanks, Cherie -- 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). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: urgent regarding server manager..
1. upgrade to unix 2. start using sqlplus instead of server manager, its going away joe Saurabh Sharma wrote: hi all, i want help regarding automation of connecting to server manager through script file. i want when i run script, it automatically launch svrmgr program and simultaneously pass the connect string so that it gives me svrmgr connected. while passing the connect string along with svrmgr80 command at c prompt results in msg too many parameters.. can anyone help getting me started. thanks in advance. saurabh -- 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).
performance impact of optimizer_search_limit
Hi, Oracle 8.0.5 AIX 4.3.3 I have improved the response time of one of my 8 table join queries by increasing optimizer_search_limit from the default 5 to 8. At the value of 8 the plan changes and has made a 10 min query run in under 5 seconds. The optimizer is set to CHOOSE with the statistics up to date and a sample size of 20%. This is a third party application and I don't have access to the source code to add hints. The value of optimizer_max_permutations has been left at 8. I know that this makes the optimizer now check 8!=40320 permutations instead of 5!=120 permutations. I expect the parse time to increase but does anyone have any experience as to the performance impact that this may have? Any horror stories? Thanks in advance. Steve Wilkes _ Oracle DBA npower = This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify gpupower.co.uk or [EMAIL PROTECTED] This outgoing e-mail (and any attachments) has been checked (using Sophos Sweep 3.45 + patches) before leaving us (UK 08457 353637), and has been found to be clean from any virus infection. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wilkes, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Help! ORA-00164 - autonomous trans problem in 8.1.7 NOT in 8.1.5
Doug, This is a case where something slipped by in one release, but was caught in a later release (shades of Personal Oracle 8.0.3 which had complete EE functionality by mistake). 8i doesn't support autonomous transactions within distributed transactions, but it wasn't officially prevented with the ORA-164 error until 8.1.6+. Supposedly this functionality will be available in 9i, but not necessarily the first release. HTH, -- Anita --- Doug C [EMAIL PROTECTED] wrote: Recently upgraded a development database from 8.1.5 to 8.1.7 with the u080105 script. There is now a certain type of code that errors out with a ORA-00164 autonomous transaction disallowed within distributed transaction. But the same code works on 8.1.5, as if a piece of functionality was actually cut out by the upgrade. There's a metalink hit on a forum where an Oracle rep makes the following statement: Autonomous transaction are not supported in a distributed transaction. Database links and autonomous transactions are two database technologies that do in fact not work together. Also.. Autonomous transaction are not supported in a distributed transaction. In 8i this will be the case. We are considering extending autonomous transactions to be able to be used even in a distributed transaction, in the future releases. Ok.. so it sounds like it shouldn't work in *ANY* Oracle release.. but it works in 8.1.5 - Here's a basic piece of the code that *works* in 8.1.5 and does *not* in a LATER release ... 8.1.7 The database link is clearly the distributed problem that is bothering it.. CREATE OR REPLACE PROCEDURE vwmtest AS v_date DATE; PROCEDURE write_log IS pragma AUTONOMOUS_TRANSACTION; BEGIN insert into ofs_log values ('VWMTEST','D',0,SYSDATE,SYSDATE,0,0,0,0,1,'F','B','3'); - just a log table - we want to make an entry regardless of whether the parent transaction completes. commit; EXCEPTION WHEN OTHERS THEN dbms_output.put_line('OThers failure in write_log'); END write_log; BEGIN -- the source of the problem SELECT super_date INTO v_date from AREMOTETABLE@ADATABASELINK where part = 54; WRITE_LOG; -- the autonomous transaction EXCEPTION WHEN OTHERS THEN dbms_output.put_line('Others error in vwmtest'); END vwmtest; I've left some of the table definitions out but the concept is clear. Despite the info I found on Oracle's knowledge baset.. This WORKS on a PRIOR release.. 8.1.5... Any ideas? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: COCO Proposal Review
Good! I just saw your other post.. I have to concur - the cake is out of this world!! Glad I brought a smile to another chocolate lovers face.. Mark -Original Message- Lee - lerobe Sent: Monday, June 04, 2001 11:40 To: Multiple recipients of list ORACLE-L Already put the verdict out mate. Tremendous You were right though. I couldn't wait for it to cool down even, never mind 24 hours. My sister already wants me to make another dozen !! Lee -Original Message- Sent: 04 June 2001 11:31 To: Multiple recipients of list ORACLE-L So tell me Lee, how was the choccy cake? :) -Original Message- Lee - lerobe Sent: Monday, June 04, 2001 08:55 To: Multiple recipients of list ORACLE-L Damn, thought it was something to do with Chocolate -Original Message- Sent: 02 June 2001 00:15 To: Multiple recipients of list ORACLE-L All, I have just thrown together a proposal I plan on sending out to a bunch of Oracle related groups (user groups etc..) to attempt to get some help in putting together training for OCP. Primarily I'm just using OCP as a basis for creating free Oracle training. Some of you may already be aware of my fledgling web site (work of love). Anyway I would like to get your comments on the proposal as I suppose I have probably missed responding to some fairly obvious questions in my zeal to get it out. Please contact me offline because I don't want to cludge up the list with this, just want to get your opinions both negative and positive and address what you think might be questions that would arise. Thanks to all who help me out, there are some very cool and very competant pro's on this list. Save the flames regarding paper OCP's as the training is not going to be an exam cram but real training and no need to throw out the baby with the bath water. http://www.freetechnicaltraining.com/docs/cocp_proposal.doc - Ethan Post -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED]
RE: Redo Log contention
log parallel write and log file sync are good indications of redo log problems. This isn't directly considered contention but more like the disk medium is too slow to keep up. redo log space requests generally are log buffer related, meaning the buffer may be too small. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 4:16 AM To: Multiple recipients of list ORACLE-L Hello all, How does one measure if there is a contention for redo logs? 1. Is it that I see that the Log file parallel write has waited for more than 0 (zero)? or 2. You divide:- redo log space requests/no. of redo log entries 0.0002 Please advise. rgds, raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
9i download
I keep trying to download 9i and the files keep being invalid gzip files. Anyone else have this problem or have successfully downloaded this monster? I have downloaded each file 3-4 times now in the last 2 days. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Renaming columns ...
Hi Raj, 1. There is a way to do it. And Mr. Steve A. has some good info about it ( its implications) on his web site. (Sorry I do not have a direct URL link to it). I believe this works for all versions. 2. Yes, it does. I have played with it on my test database. However, I will not do this on a Production database as it involves a direct DML to modify sys.COL$. And Oracle does not recommend doing such things to your databases. I am not sure if renaming column is supported in 9i. Anyone else know for sure? If you are using 8i, the safe way to address this is to add a new column to the table, populate it with the contents from the old, and drop the old column. If the column is not nullable, and if there are plenty of nullable columns towards the end of the table, I suggest considering reorganization of the table. I just did that (reorg) in the last couple of weeks with a 60Mil row table to get the new not nullable columns towards the 'head' of the table. HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 8:51 AM To: Multiple recipients of list ORACLE-L Subject: Renaming columns ... Hi all, although I am searching information on Metalink and OTN, I just want to ask this question to the list ... 1. Is it possible to rename a column? (we have lots of columns that need to be renamed). Which version supports it? 2. Does renaming automatically takes care of indexes? Coding will be a lot of manual labor, but that's okay we can handle it. Thanks in advance Raj __ Rajendra JamadagniMIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Check/Remove stray shared_memory_segment and semaphore
this is the error in my trace file and can U tell me where to find for this doc about glibc- cat ora_810.trc *** DUMP FILE SIZE IS LIMITED TO 0 BYTES *** - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Friday, June 01, 2001 10:15 PM Subject: Re: Check/Remove stray shared_memory_segment and semaphore Hi Look under $ORACLE_HOME/bin for oracle executable. Do you see the file ? There was an installation bug and the relink fails with out creating the executable. If you do see the file then, check under $ORACLE_HOME/rdbms/log for any alert messages or traces. Also, Did you follow the procedure to use glibc-2.1 instead of glibc-2.2 ? ThanksRiyaj "Re-yas" ShamsudeenCertified Oracle DBAi2 technologies www.i2.com "Apps Sol" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/01/01 11:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Check/Remove stray shared_memory_segment and semaphoreFolks,I am trying to start a new db on one of my new Linux box Dell 2450 , RHAT 7.0 and 8.1.6 .. 1GB ram and huge disk space .. but I get a error at SVRMGR ORA-03113: end-of-file on communication channelwhen I further checked and changed my SID to a new one .. no luck I even tried DBASSIST (Hate to do it though) no luck ..there is no error in my alert log Can any one tell me what are the things i need to look into ..CheersRK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Apps SolINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Check/Remove stray shared_memory_segment and semaphore
I was looking all day long for this doc.. can U point me to the right doc number .. Cheers - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, June 02, 2001 6:56 PM Not necessary to use glibc-2.1, Oracle has a patch for using with glibc-2.2. It's on the download page for linux Oracle, it's at technet.oracle.com. It is a set of stubs that point 2.1 calls to 2.2 functions. It requires relinking Oracle and includes instructions. Jared On Friday 01 June 2001 19:15, [EMAIL PROTECTED] wrote: Hi Look under $ORACLE_HOME/bin for oracle executable. Do you see the file ? There was an installation bug and the relink fails with out creating the executable. If you do see the file then, check under $ORACLE_HOME/rdbms/log for any alert messages or traces. Also, Did you follow the procedure to use glibc-2.1 instead of glibc-2.2 ? Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com Apps Sol [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/01/01 11:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Check/Remove stray shared_memory_segment and semaphore Folks, I am trying to start a new db on one of my new Linux box Dell 2450 , RHAT 7.0 and 8.1.6 .. 1GB ram and huge disk space .. but I get a error at SVRMGR ORA-03113: end-of-file on communication channel when I further checked and changed my SID to a new one .. no luck I even tried DBASSIST (Hate to do it though) no luck .. there is no error in my alert log Can any one tell me what are the things i need to look into .. Cheers RK Content-Type: text/html; charset=us-ascii; name=Attachment: 1 Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Apps Sol INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Renaming columns ...
Kirti, Thanks for the info, BTW are there any significant advantages of moving NOT NULL columns towards HEAD of the table? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i is on technet (NT)
That's definitely what they do. Anyone want to sell me a Sparc box? Not you Spence, the shipping costs would bankrupt me !!! = ) Mike -- 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).
Database writer
Hi all, I added db writer processes last week to try and improve performance of one of my 8.1.7 db's on NT. Does anyone know if there is a way to see if Oracle actually started the additional db writer processes? I added db_writer_processes to the init file, the instance started so I am assuming that the db writer processes are working. But we all know what happens when we assume something. Any ideas would be appreciated. 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).
OPS, TAF and jAVA
We are looking at using TAF (never used before) for application fail over. First, any guidelines we should be aware of in general. Second any specific concerns using TAF with applications using JAVA. Any stuff on how does TAF and OPS work in harmony? Regards Murali Vallath _ 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).
RE: COCO Proposal Review
Ingredients: 225g soft unsalted butter 375g dark muscovado sugar 2 large eggs - beaten 1 teaspoon vanilla extract 100g best dark chocolate - melted 200g plain flour 1 teaspoon bicarbonate of soda 250ml boiling water 23*13*7cm loaf tin Preheat the oven to 190c/gas mark 5, put in a baking sheet case of gooey sticky drips later;) and grease and line the loaf tin. The lining is important as this is a very damp cake: use parchment, Bake-O-Glide or one of those loaf-tin-shaped paper cases. Cream the butter and sugar, either with a wooden spoon or an electric hand held mixer, then add the eggs and vanilla, beating in well. Next fold in the melted and now slightly cooled chocolate, taking care to blend well, but being careful not to over beat. You want the ingredients combined: you DON'T want a light airy mass. Then gently add the flour, to which you've added the bicarb, alternately spoon by spoon, with the boiling water until you have a smooth and fairly liquid batter. Pour into the lined loaf tin and bake for 30 mins. turn the oven down to 170c/gas mark 3 and continue to cook for another 15 mins. The cake will still be a bit squidgy inside, so an inserted cake-tester or skewer won't come out completely clean. Place the loaf tin on a rack, and leave to get completely cold (if you can resist it G) before turning it out. (The *Author* recommends leaving it for a day - hhuummm you won't get that far I can guarantee). Don't worry if it sinks in the middle: indeed it WILL do so because its such a dense and damp cake. Regards Mark -Original Message- Spence Sent: Monday, June 04, 2001 03:26 To: Multiple recipients of list ORACLE-L Anyone have this recipe handy that everyone is flaunting? Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 6:31 AM To: Multiple recipients of list ORACLE-L So tell me Lee, how was the choccy cake? :) -Original Message- Lee - lerobe Sent: Monday, June 04, 2001 08:55 To: Multiple recipients of list ORACLE-L Damn, thought it was something to do with Chocolate -Original Message- Sent: 02 June 2001 00:15 To: Multiple recipients of list ORACLE-L All, I have just thrown together a proposal I plan on sending out to a bunch of Oracle related groups (user groups etc..) to attempt to get some help in putting together training for OCP. Primarily I'm just using OCP as a basis for creating free Oracle training. Some of you may already be aware of my fledgling web site (work of love). Anyway I would like to get your comments on the proposal as I suppose I have probably missed responding to some fairly obvious questions in my zeal to get it out. Please contact me offline because I don't want to cludge up the list with this, just want to get your opinions both negative and positive and address what you think might be questions that would arise. Thanks to all who help me out, there are some very cool and very competant pro's on this list. Save the flames regarding paper OCP's as the training is not going to be an exam cram but real training and no need to throw out the baby with the bath water. http://www.freetechnicaltraining.com/docs/cocp_proposal.doc - Ethan Post -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Oracel Support was Re: MaterializeRe: Snapshot Logs Explanation Needed
Hi All, Anita is absolutely right. Before making any changes to the data dictionary call Oracle support. Before using undocumented parameters call Oracle Support. Before doing anything that you do not know all of the side effects for, CALL ORACLE SUPPORT!!! You pay them enough, so use them. Dave A. Bardeen wrote: Dave, /* SOAPBOX ON */ I'm well aware that hacking the data dictionary is possible, but you'll never see me advocating that on the list. I believe hacking should be done only as a last resort to save a db or avoid rebuilding it and even then should be done only under the guidance of Oracle Support. In many cases even they won't let you make the changes, but will require dial-in access so they can make the changes to ensure that they're done properly. Since there are virtually no PK/FK relationships defined in the data dictionary it's far too easy to miss one of the relationships and end up with a corrupted dictionary. Said corruption may not manifest itself until days, weeks, or months later, at which point you'll have a bigger and messier problem than the original one. So even if you practice this on a test db and it seems to work OK, it might just be that you haven't performed the operations that would reveal the corruption. Definitely not something I want to attempt via email. IMHO the disclaimers backup first and use at your own risk are insufficient. /* SOAPBOX OFF */ -- Anita --- Dave Morgan [EMAIL PROTECTED] wrote: Hi Anita, I'm not sure if you are the original poster but There is a way to force a view into fast refresh mode after you have restructured the snapshot logs WARNING: This is unsupported by Oracle and involves messing with the data dictionary. I once had to create a 4GB snapshot over an ISDN line This was done by creating the snapshot locally, exporting, ftp, import and then: In DBA_SNAPSHOTS (I believe) I compared the entry in the local database to the remote. One field was different in my case. A simple update to the data dictionary enabled the FAST REFRESH to take place. THIS IS DANGEROUS STUFF :) Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- 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 Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Renaming columns ...
There is an oracle-supplied *.sql file to do this ...in the rdbms/admin directory as i recall. You will, of course, have to RTFM online and do some tinkering. I am so old that I can't remember much more about this, but anything to do with Diana sure perks me up. ahem. || -Original Message- || From: Joseph Raj [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 04, 2001 12:46 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: Renaming columns ... || || || This is right from Guru Steeve Adam's site || || No, if the table is referred to in any stored PL/SQL || program units, you || must first drop those program units and then manually delete || the rows for || that table (based on its OBJ# from OBJ$) from the 4 data || dictionary tables || beginning with IDL. The IDL tables contain the DIANA for the || table, which || includes a knowledge of the old column name. That is why you || need to get rid || of it. If you do this, it is perfectly safe to change column || names directly, || even with stored PL/SQL. || Please note, however, that it is also perfectly unsupported. || So think twice || before doing this on a production system. The supported way || to solve this || problem is to rename the table, and interpose a view to || translate the column || name. || || ps check up http://www.ixora.com.au || and do a search. this was from one of the qa of 99. || || regards hth, || Joseph Raj Kumar || - Original Message - || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || Sent: Monday, June 04, 2001 7:20 PM || || || Hi all, || || although I am searching information on Metalink and OTN, I || just want to || ask || this question to the list ... || || 1. Is it possible to rename a column? (we have lots of || columns that need || to || be renamed). Which version supports it? || 2. Does renaming automatically takes care of indexes? || || Coding will be a lot of manual labor, but that's okay we || can handle it. || || Thanks in advance || Raj || __ || Rajendra Jamadagni MIS, ESPN Inc. || Rajendra dot Jamadagni at ESPN dot com || Any opinion expressed here is personal and doesn't reflect || that of ESPN || Inc. || || QOTD: Any clod can have facts, but having an opinion is an art ! || || || || || * || 1 || || This e-mail message is confidential, intended only for the named || recipient(s) above and may contain information that is || privileged, attorney || work product or exempt from disclosure under applicable law. || If you have || received this message in error, or are not the named || recipient(s), please || immediately notify corporate MIS at (860) 766-2000 and || delete this e-mail || message from your computer, Thank you. || || || * || 1 || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Jamadagni, Rajendra ||INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like || subscribing). || || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Joseph Raj || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send
RE: Oracle 9i is on technet (NT)
Now I would bet Linux will be next, not NT Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 9:51 AM To: Multiple recipients of list ORACLE-L Does this prove that they write Oracle on Solaris, then port it over to the other platforms? : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Steps for removing jobs
Usefull article, but it missed one useful bit... * You can only manage your own jobs, even if you're a DBA user. -Not quite true, check out the DBMS_IJOB package. Does the same things as DBMS_JOB (submit, change delete jobs, etc) but lets you specify the 'owning' user. I found it in the O'Reilly Oracle Built-in Packages book It saves messing around with password-swapping and becoming other users. Simon Anderson -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i download
I found you absolutely have to use get right, anything from oracle site you generally have to download a few times to get it to actully work, sometimes I am lucky. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 12:22 PM To: Multiple recipients of list ORACLE-L I could never successfully download the file. I ended up getting the CD. [EMAIL PROTECTED] 06/04/01 11:15AM I keep trying to download 9i and the files keep being invalid gzip files. Anyone else have this problem or have successfully downloaded this monster? I have downloaded each file 3-4 times now in the last 2 days. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 SQLServer archiving
Hi James, Well his clients disagree with you, and since they have actually worked with him, I prefer to trust their judgement. And while SQL2000 may have logs mirrored by the database, SQLServer 7 did not. Dave James Xing wrote snip Your friend is Not a MSSQL/NT/2000 expert, apparently! snip -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- 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 Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Database writer
Look under ps. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Hi all, I added db writer processes last week to try and improve performance of one of my 8.1.7 db's on NT. Does anyone know if there is a way to see if Oracle actually started the additional db writer processes? I added db_writer_processes to the init file, the instance started so I am assuming that the db writer processes are working. But we all know what happens when we assume something. Any ideas would be appreciated. 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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 9i download
I could never successfully download the file. I ended up getting the CD. [EMAIL PROTECTED] 06/04/01 11:15AM I keep trying to download 9i and the files keep being invalid gzip files. Anyone else have this problem or have successfully downloaded this monster? I have downloaded each file 3-4 times now in the last 2 days. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Renaming columns ...
This is right from Guru Steeve Adam's site No, if the table is referred to in any stored PL/SQL program units, you must first drop those program units and then manually delete the rows for that table (based on its OBJ# from OBJ$) from the 4 data dictionary tables beginning with IDL. The IDL tables contain the DIANA for the table, which includes a knowledge of the old column name. That is why you need to get rid of it. If you do this, it is perfectly safe to change column names directly, even with stored PL/SQL. Please note, however, that it is also perfectly unsupported. So think twice before doing this on a production system. The supported way to solve this problem is to rename the table, and interpose a view to translate the column name. ps check up http://www.ixora.com.au and do a search. this was from one of the qa of 99. regards hth, Joseph Raj Kumar - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 04, 2001 7:20 PM Hi all, although I am searching information on Metalink and OTN, I just want to ask this question to the list ... 1. Is it possible to rename a column? (we have lots of columns that need to be renamed). Which version supports it? 2. Does renaming automatically takes care of indexes? Coding will be a lot of manual labor, but that's okay we can handle it. Thanks in advance Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Renaming columns ...
Yes renaming a column is supported, in fact you can change almost every aspect of a table online. it works parallel to existing table, right before switching them over, it gets the latest DML applied, then switches over. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 11:27 AM To: Multiple recipients of list ORACLE-L Hi Raj, 1. There is a way to do it. And Mr. Steve A. has some good info about it ( its implications) on his web site. (Sorry I do not have a direct URL link to it). I believe this works for all versions. 2. Yes, it does. I have played with it on my test database. However, I will not do this on a Production database as it involves a direct DML to modify sys.COL$. And Oracle does not recommend doing such things to your databases. I am not sure if renaming column is supported in 9i. Anyone else know for sure? If you are using 8i, the safe way to address this is to add a new column to the table, populate it with the contents from the old, and drop the old column. If the column is not nullable, and if there are plenty of nullable columns towards the end of the table, I suggest considering reorganization of the table. I just did that (reorg) in the last couple of weeks with a 60Mil row table to get the new not nullable columns towards the 'head' of the table. HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 8:51 AM To: Multiple recipients of list ORACLE-L Subject: Renaming columns ... Hi all, although I am searching information on Metalink and OTN, I just want to ask this question to the list ... 1. Is it possible to rename a column? (we have lots of columns that need to be renamed). Which version supports it? 2. Does renaming automatically takes care of indexes? Coding will be a lot of manual labor, but that's okay we can handle it. Thanks in advance Raj __ Rajendra JamadagniMIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! -- 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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Check/Remove stray shared_memory_segment and semaphore
I have it. If you want the tar file just e-mail me directly and I send it to you. -Original Message- Sent: Monday, June 04, 2001 10:21 AM To: Multiple recipients of list ORACLE-L I was looking all day long for this doc.. can U point me to the right doc number .. Cheers - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, June 02, 2001 6:56 PM Not necessary to use glibc-2.1, Oracle has a patch for using with glibc-2.2. It's on the download page for linux Oracle, it's at technet.oracle.com. It is a set of stubs that point 2.1 calls to 2.2 functions. It requires relinking Oracle and includes instructions. Jared On Friday 01 June 2001 19:15, [EMAIL PROTECTED] wrote: Hi Look under $ORACLE_HOME/bin for oracle executable. Do you see the file ? There was an installation bug and the relink fails with out creating the executable. If you do see the file then, check under $ORACLE_HOME/rdbms/log for any alert messages or traces. Also, Did you follow the procedure to use glibc-2.1 instead of glibc-2.2 ? Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com Apps Sol [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/01/01 11:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Check/Remove stray shared_memory_segment and semaphore Folks, I am trying to start a new db on one of my new Linux box Dell 2450 , RHAT 7.0 and 8.1.6 .. 1GB ram and huge disk space .. but I get a error at SVRMGR ORA-03113: end-of-file on communication channel when I further checked and changed my SID to a new one .. no luck I even tried DBASSIST (Hate to do it though) no luck .. there is no error in my alert log Can any one tell me what are the things i need to look into .. Cheers RK Content-Type: text/html; charset=us-ascii; name=Attachment: 1 Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Apps Sol INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 9i download
Note sure if your using a download manager Chris, I used ReGet (Tucows.com) the other day to get 8.1.7.3 and it worked really great. - E -Original Message- Sent: Monday, June 04, 2001 9:22 AM To: Multiple recipients of list ORACLE-L I could never successfully download the file. I ended up getting the CD. [EMAIL PROTECTED] 06/04/01 11:15AM I keep trying to download 9i and the files keep being invalid gzip files. Anyone else have this problem or have successfully downloaded this monster? I have downloaded each file 3-4 times now in the last 2 days. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 9i is on technet (NT)
I want one too, I need one for home to run StarOffice. A Starfire(?) would be all right I think. Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle 9i is on technet (NT) That's definitely what they do. Anyone want to sell me a Sparc box? Not you Spence, the shipping costs would bankrupt me !!! = ) Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i is on technet (NT)
In a perfect world maybe, but 80% or more of the business world is using some form of windows!! -Original Message- Sent: Monday, June 04, 2001 12:10 PM To: Multiple recipients of list ORACLE-L It just proves what we all knew . Unix Not NT. Never NT ... -Original Message- Sent: Monday, June 04, 2001 8:51 AM To: Multiple recipients of list ORACLE-L Does this prove that they write Oracle on Solaris, then port it over to the other platforms? : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database writer
Kev, Trying to add multiple DBWR processes on NT is useless since NT uses asynch. I/O. If you remember, all the Oracle processes (DBWR, LGWR, CKPT, ARCH, etc.) run as threads under the oracle.exe process. Multiple DBWR processes are definitely a Unix thing! Also, here's something from MetaStink on the issue: Oracle on NT only allows/needs a single database writer process (DBWR). Multiple DBWRs on UNIX is not multiple real DBWRs which all go scan for dirty buffers and write them to disk. It's really just one real DBWR and some I/O slaves. The real DBWR tells the slave DBWRs to do I/O. On NT, there's really no need for this since async I/O and NT will take care of all that for you. NT acts as the I/O slaves and the real DBWR [1 DBWR thread] then checks the slaves to see if the I/O is done. Melissa Holman Oracle Support Ed Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Monday, June 04, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Hi all, I added db writer processes last week to try and improve performance of one of my 8.1.7 db's on NT. Does anyone know if there is a way to see if Oracle actually started the additional db writer processes? I added db_writer_processes to the init file, the instance started so I am assuming that the db writer processes are working. But we all know what happens when we assume something. Any ideas would be appreciated. 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: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Database writer
There is a tool in the WinNT Resource Kit that lets you look at individual threads per process. I don't remember what the name is, but it's in there. Try doing a select against v$session and v$bgprocess you should from v$bgprocess you should get a DBW0 and DBW1 under the listing of background processes. select s.sid, s.serial#, s.schemaname, s.program, b.name from v$session s, v$bgprocess b where s.paddr = b.paddr; HTH Rodd Holman Original Message On 6/4/01, 10:55:35 AM, Kevin Kostyszyn [EMAIL PROTECTED] wrote regarding Database writer: Hi all, I added db writer processes last week to try and improve performance of one of my 8.1.7 db's on NT. Does anyone know if there is a way to see if Oracle actually started the additional db writer processes? I added db_writer_processes to the init file, the instance started so I am assuming that the db writer processes are working. But we all know what happens when we assume something. Any ideas would be appreciated. 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: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database writer
Kevin, I apologize for asking but this is for the benefit of others possibly. But how did you determine that your instance may require an additional DBWR process. What led you to think that you had an bottleneck with only one process? Thanks, Ethan -Original Message- Sent: Monday, June 04, 2001 8:56 AM To: Multiple recipients of list ORACLE-L Hi all, I added db writer processes last week to try and improve performance of one of my 8.1.7 db's on NT. Does anyone know if there is a way to see if Oracle actually started the additional db writer processes? I added db_writer_processes to the init file, the instance started so I am assuming that the db writer processes are working. But we all know what happens when we assume something. Any ideas would be appreciated. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Renaming columns ...
Column position has no value what so ever. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 11:31 AM To: Multiple recipients of list ORACLE-L Kirti, Thanks for the info, BTW are there any significant advantages of moving NOT NULL columns towards HEAD of the table? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Database writer
Hi, Kevin, Maybe this query will help: SQLselect PROGRAM from v$process where PROGRAM like '%DBW%'; Regards Vadim Gorbounov Oracle DBA -Original Message- Sent: Monday, June 04, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Hi all, I added db writer processes last week to try and improve performance of one of my 8.1.7 db's on NT. Does anyone know if there is a way to see if Oracle actually started the additional db writer processes? I added db_writer_processes to the init file, the instance started so I am assuming that the db writer processes are working. But we all know what happens when we assume something. Any ideas would be appreciated. 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: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i is on technet (NT)
That has been known for some time. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 9:51 AM To: Multiple recipients of list ORACLE-L Does this prove that they write Oracle on Solaris, then port it over to the other platforms? : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: COCO Proposal Review
Poor Ethan, his serious post about Oracle training has been morphed into chocolate cake recipes. Come on folks, give him a break. Jared On Friday 01 June 2001 16:14, Post, Ethan wrote: All, I have just thrown together a proposal I plan on sending out to a bunch of Oracle related groups (user groups etc..) to attempt to get some help in putting together training for OCP. Primarily I'm just using OCP as a basis for creating free Oracle training. Some of you may already be aware of my fledgling web site (work of love). Anyway I would like to get your comments on the proposal as I suppose I have probably missed responding to some fairly obvious questions in my zeal to get it out. Please contact me offline because I don't want to cludge up the list with this, just want to get your opinions both negative and positive and address what you think might be questions that would arise. Thanks to all who help me out, there are some very cool and very competant pro's on this list. Save the flames regarding paper OCP's as the training is not going to be an exam cram but real training and no need to throw out the baby with the bath water. http://www.freetechnicaltraining.com/docs/cocp_proposal.doc - Ethan Post --- --- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. === === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database writer
Unless Oracle changed the way it reported this, that won't work on NT. Oracle On NT didn't used to report bg procs in the program field of v$session. This may have changed with 8i. I haven't worked with 8i on NT. Used to have to join v$session and v$bgprocess on paddr. Rodd Holman Original Message On 6/4/01, 12:10:53 PM, Vadim Gorbounov [EMAIL PROTECTED] wrote regarding RE: Database writer: Hi, Kevin, Maybe this query will help: SQL select PROGRAM from v$process where PROGRAM like '%DBW%'; Regards Vadim Gorbounov Oracle DBA -Original Message- Sent: Monday, June 04, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Hi all, I added db writer processes last week to try and improve performance of one of my 8.1.7 db's on NT. Does anyone know if there is a way to see if Oracle actually started the additional db writer processes? I added db_writer_processes to the init file, the instance started so I am assuming that the db writer processes are working. But we all know what happens when we assume something. Any ideas would be appreciated. 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: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Renaming columns ...
Kevin, see this link ... http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/server.901/ a90117/tables.htm#12596 this link will be broken, but put it on one line and click ... there is a complete example ... BTW Oracle has done one job very well ... the 9i document search interface, it rocks !! Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *4 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database writer
You can see that at operating system level using next sentence: ps -ef | grep dbwr 04/06/2001 17.55 Kevin Kostyszyn [EMAIL PROTECTED] 04/06/2001 18.10 Por favor, responda a [EMAIL PROTECTED] Remitente [EMAIL PROTECTED] Hi all, I added db writer processes last week to try and improve performance of one of my 8.1.7 db's on NT. Does anyone know if there is a way to see if Oracle actually started the additional db writer processes? I added db_writer_processes to the init file, the instance started so I am assuming that the db writer processes are working. But we all know what happens when we assume something. Any ideas would be appreciated. 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). |--| | Destinatario Multiple recipients of list ORACLE-L [EMAIL PROTECTED] | | Copia| |--| Este mensaje y los documentos que, en su caso, lleve anexos, pueden contener información confidencial. Por ello, se informa a quien lo reciba por error que la información contenida en el mismo es reservada y su uso no autorizado está prohibido legalmente, por lo que en tal caso le rogamos que nos lo comunique por la misma vía o por teléfono (901 113 113) , se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database writer
On Monday 04 June 2001 10:16, Christopher Spence wrote: Look under ps. Really? On NT? Jared Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Hi all, I added db writer processes last week to try and improve performance of one of my 8.1.7 db's on NT. Does anyone know if there is a way to see if Oracle actually started the additional db writer processes? I added db_writer_processes to the init file, the instance started so I am assuming that the db writer processes are working. But we all know what happens when we assume something. Any ideas would be appreciated. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i is on technet (NT)
I vote we do. I am actually trying to see if an Sun Ultra 1 will run Oracle 9i without any problems. If it does, I will through like 25 of them on ebay. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 1:22 PM To: [EMAIL PROTECTED]; Christopher Spence On Monday 04 June 2001 10:16, Christopher Spence wrote: Now I would bet Linux will be next, not NT Interesting observation, should we start a pool? :) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Database writer
Have you tried v$bgprocess ? Regards Mark -Original Message- Kostyszyn Sent: Monday, June 04, 2001 04:56 To: Multiple recipients of list ORACLE-L Hi all, I added db writer processes last week to try and improve performance of one of my 8.1.7 db's on NT. Does anyone know if there is a way to see if Oracle actually started the additional db writer processes? I added db_writer_processes to the init file, the instance started so I am assuming that the db writer processes are working. But we all know what happens when we assume something. Any ideas would be appreciated. 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: 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).
RE: Renaming columns ...
Title: RE: Renaming columns ... To add to Kirti's' comments - The same applies for columns that have default values defined. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. -Original Message- From: Deshpande, Kirti [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Subject: RE: Renaming columns ... Hi Raj, The trailing null columns in a row do not take up any space in the data block. So in a table with many columns, the columns that may contain null values should be defined towards the end of the row to optimize disk space usage. HTH. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 9:32 AM To: 'Deshpande, Kirti'; [EMAIL PROTECTED] Subject: RE: Renaming columns ... Kirti, Thanks for the info, BTW are there any significant advantages of moving NOT NULL columns towards HEAD of the table? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: On the question of What is a Large Database Anyway ?
Can anyone refer me to a site that lists this book as available.. -Original Message- Sent: Monday, June 04, 2001 6:15 AM To: Multiple recipients of list ORACLE-L Cary wrote the intro (and, along with Scott Gossett of Oracle University, Craig Shallahamer and a few other unknowns) did the tech-edit. I had the privilege of doing the developmental edit (this means I got to help Gaja make it fun and understandable for an entry-level tuner). But it also meant I got to read it as Gaja and Kirti were writing it it's a wonderful book and I believe it's actually out now. From: Mogens Nørgaard [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: On the question of What is a Large Database Anyway ? Date: Mon, 04 Jun 2001 00:01:18 -0800 It's a good book. Cary Millsap has even written the intro :). Yep, Gaja will talk about using the wait-interface (available since 7.0.12) instead of all these stupid and mis-leading ratios flying around. That and Jonathan Lewis' book are the best I've seen since Dave Ensors Oracle8 Design book, but that's kind of old now. For the original intro to the wait-interface (or time-based) tuning, you should of course read Anjo Kolks famous YAPP paper. Post, Ethan wrote: I just got back from a little seminar from Quest with Gaja Krishna Vaidyanatha and if he was dead (he's not that I'm aware of) he would be rolling in his grave about your comments on hit rates and SGA sizes. His new book 101 Oracle Performance Tuning will stress that you abandon those hit rates and focus on V$SYSTEM_EVENT, V$SESSION_EVENT and V$SESSION_WAIT in combination with CPU and IO stats. He states that Oracle is rather well designed for physical IO. His presentation was great and I'm definatley going to buy his book because I can learn something from this guy. So maybe those small SGA's aren't so bad after all :) http://www.amazon.com/exec/obidos/ASIN/0072131454/o/qid=991436418/sr=2-1/re f =aps_sr_b_1_1/002-4814740-2092864 - Ethan Post -Original Message- Sent: Friday, June 01, 2001 4:35 PM To: Multiple recipients of list ORACLE-L As most everyone has said so far Its all subjective. What is large to me is a dinky little thing to someone else. Right now at my current job we have around 37 instances on 4 mchines with 2 GB or less of memory and 2 - 4 processors each. These DBs range from a 10 MB to a 70 MB SGA (yes, sounded real small to me when I got here also). These databases are all in the realm of 60 - 100 GB of data each. My last job we had 2 machines running 4 instances. These DBs had SGAs from 350 MB to 980 MB in size with 4 CPUs using 4 GB of memory. As far as size goes, we had upwards of a Terrabyte of data. To me, I have found that I have to treat both setups the same. They really do have the same problems (space, hit rates, drive failures, hardware failures, etc.) You just have to pay closer attention to certain aspects of them differently. With the small SGAs we have to look real close at hit rates and all the Memory Dependent aspects of the DB. With the large amount of data on the other DB we had to look more closely at Data and file related problems. All I am trying to say is . its all subjective. Kevin --- --- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. === === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Venlig hilsen Mogens Nørgaard Technical Director Miracle A/S, Denmark Web: http://MiracleAS.dk Mobile: +45 2527 7100 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?iso-8859-1?Q?N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Size, what is it?
Hi Mogens I agree with all your statements. What I am trying to figure out is what is it that streches the machine. I was quite surprised to see an E450 doing 10GB of transaction logs per day. Pure OLTP using stored procs. I was hoping to get descriptions of the types and amounts of work a large or busy database does along with the description of the hardware that is being used. This would allow a baseline to be developed for estimating. For example how much OLTP work can a Linux 2 CPU machine with lots of memory do? How many DSS users can a similar machine support? I would also like to ask similar questions about other UNIX configurations? VAX/VMS would also be interesting. NT, someone else can do the work if they want :) SUN is also now offering hardware RAID 3 in their RSM2000 array. As I mentioned the Baydel array beats RAID 5 easily, and is substantially cheaper than an equivalent RAID 10 (1+0) array which is my preference. (and everyone elses :) Thanks for your input. Dave Mogens wrote ... My dear friend Cary Millsap once came up with a definition for a VLDB: It's any database that stretches its hardware. I cannot see any relationship between SGA and database sizes. None. RAID-3: Bit-level striping. Incredible it still exists (in my opinion) :). -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- 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 Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: TUSC and Kevin Loney
I guess I am the last to discover this, but Kevin now works for TUSC. No Patrice - you were not the last! I thought Kevin was 'independent', so where did you get this info from? Anyway, TUSC is big in the Oracle area, and I wouldn't be surprised. John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Idea for Very Cool 9i.x Feature
Ethan, http://technet.oracle.com:2000 I recently complained to Oracle about their usage of non standard port numbers (which sometimes are blocked by companies, like ours). So, I received a reply (within 8 hours Surprise !) that Oracle is in the process of moving to standard port numbers for various public services. HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Renaming columns ...
HELP ! -Original Message- From: PHU,JULIA (HP-Sunnyvale,ex2) [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 2:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: Renaming columns ... ALTER TABLE table_name MODIFY ( new_col_name DATATYPE); It works for me in 8i. -Original Message- Sent: Monday, June 04, 2001 11:27 AM To: Multiple recipients of list ORACLE-L Chris: I've been browzing the on-line docs for 9i and the release notes and have seen nothing about renaming a column...can you point me to the location in the docs that give the syntax? Thanks Kevin -Original Message- Sent: Monday, June 04, 2001 1:17 PM To: Multiple recipients of list ORACLE-L Yes renaming a column is supported, in fact you can change almost every aspect of a table online. it works parallel to existing table, right before switching them over, it gets the latest DML applied, then switches over. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -- 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).
OT RE: Database writer
Yea, NT blows. Blows like a fresh wind against the empire. (1st one to name that song lyric reference and i buy you a beer. NT bigots and their families summarily excused from this offer.:) || -Original Message- || From: Christopher Spence [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 04, 2001 2:16 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Database writer || || || Doubt, didnt' see NT, boy NT blows. || || I hate how it doesn't list out the processes. || || Walking on water and developing software from a || specification are easy if || both are frozen. || || Christopher R. Spence || Oracle DBA || Fuelspot || || || || -Original Message- || Sent: Monday, June 04, 2001 1:18 PM || To: [EMAIL PROTECTED]; Christopher Spence || || || On Monday 04 June 2001 10:16, Christopher Spence wrote: || Look under ps. || || Really? On NT? || || Jared || || || Walking on water and developing software from a || specification are easy if || both are frozen. || || Christopher R. Spence || Oracle DBA || Fuelspot || || || || -Original Message- || Sent: Monday, June 04, 2001 11:56 AM || To: Multiple recipients of list ORACLE-L || || || Hi all, || I added db writer processes last week to try and || improve performance || of one || of my 8.1.7 db's on NT. Does anyone know if there is a || way to see if || Oracle actually started the additional db writer || processes? I added || db_writer_processes to the init file, the instance started so I am || assuming || that the db writer processes are working. But we all know || what happens || when we assume something. Any ideas would be appreciated. || || Sincerely, || Kevin Kostyszyn || DBA || Dulcian, Inc || www.dulcian.com || [EMAIL PROTECTED] || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Christopher Spence || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ora-600
Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: TUSC and Kevin Loney
See: http://www.tusc.com/oracle/news/20010222a.html WORLD-RENOWNED ORACLE EXPERT KEVIN LONEY JOINS TUSC CHICAGO (Feb. 22, 2001) -- TUSC, the Oracle Experts, has announced a second major appointment in the past week with the hiring of world-renowned Oracle database administrator Kevin M. Loney. I found this on http://www.kevinloney.com/whatnews.htm -Joe - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 04, 2001 3:56 PM Kevin Loney does work for TUSC and has for some time now. From: John Kanagaraj [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: TUSC and Kevin Loney Date: Mon, 04 Jun 2001 11:31:38 -0800 I guess I am the last to discover this, but Kevin now works for TUSC. No Patrice - you were not the last! I thought Kevin was 'independent', so where did you get this info from? Anyway, TUSC is big in the Oracle area, and I wouldn't be surprised. John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT RE: Renaming columns ...
ARE YOU AN IDIOT || -Original Message- || From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 04, 2001 4:17 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Renaming columns ... || || || HELP ! || || -Original Message- || From: PHU,JULIA (HP-Sunnyvale,ex2) [SMTP:[EMAIL PROTECTED]] || Sent: Monday, June 04, 2001 2:21 PM || To:Multiple recipients of list ORACLE-L || Subject: RE: Renaming columns ... || || ALTER TABLE table_name MODIFY ( new_col_name DATATYPE); || || It works for me in 8i. || || || || -Original Message- || Sent: Monday, June 04, 2001 11:27 AM || To: Multiple recipients of list ORACLE-L || || || Chris: || || I've been browzing the on-line docs for 9i and the release || notes and have || seen nothing about renaming a column...can you point me to || the location in || the docs that give the syntax? || || Thanks || Kevin || || -Original Message- || Sent: Monday, June 04, 2001 1:17 PM || To: Multiple recipients of list ORACLE-L || || || Yes renaming a column is supported, in fact you can change || almost every || aspect of a table online. || it works parallel to existing table, right before || switching them over, it || gets the latest DML applied, then switches over. || || || Walking on water and developing software from a || specification are easy if || both are frozen. || || Christopher R. Spence || Oracle DBA || Fuelspot || || || || -- || 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: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i is on technet (NT)
Nope. HP-UX and AIX are in the next batch. BSOD will be there in August and Linux not before the late October. May be you'll even have to wait for the last week of Novebmer to give thanks to the Oracle Corp. -Original Message- Sent: Monday, June 04, 2001 2:23 PM To: Multiple recipients of list ORACLE-L On Monday 04 June 2001 10:16, Christopher Spence wrote: Now I would bet Linux will be next, not NT Interesting observation, should we start a pool? :) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: performance impact of optimizer_search_limit
DDES! This parameter is session modifiable. To wit: SVRMGR alter session set optimizer_search_limit=400; ORA-00068: invalid value 400 for parameter optimizer_search_limit, must be between 3 and 255 So, IF (you='heavily certified') THEN (wave OCP pigskin over dbms, wait for result) ELSIF (you='DIY type') THEN (wellDIY) ENDIF; || -Original Message- || From: Jared Still [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 04, 2001 2:23 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: performance impact of optimizer_search_limit || || || || Steve, || || I'm curious as the difference in execution plans that || made such a drastic improvement. || || My guess would be it went from a hash join to nested || loops with an index. || || Jared || || || On Monday 04 June 2001 04:55, Wilkes, Steve wrote: || Hi, || || Oracle 8.0.5 || AIX 4.3.3 || || I have improved the response time of one of my 8 table || join queries by || increasing optimizer_search_limit from the default 5 to 8. || At the value of || 8 the plan changes and has made a 10 min query run in || under 5 seconds. The || optimizer is set to CHOOSE with the statistics up to date || and a sample size || of 20%. This is a third party application and I don't have || access to the || source code to add hints. The value of || optimizer_max_permutations has been || left at 8. || || I know that this makes the optimizer now check 8!=40320 || permutations || instead of 5!=120 permutations. I expect the parse time to || increase but || does anyone have any experience as to the performance || impact that this may || have? Any horror stories? || || Thanks in advance. || || Steve Wilkes || || _ || Oracle DBA || npower || || || = || This email and any files transmitted with it are confidential and || intended solely for the use of the individual or entity to || whom they || are addressed. If you have received this email in error || please notify || gpupower.co.uk or [EMAIL PROTECTED] || || This outgoing e-mail (and any attachments) has been checked || (using Sophos Sweep 3.45 + patches) before leaving us (UK || 08457 353637), || and has been found to be clean from any virus infection. || || || = || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Jared Still || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i download
Is that ReGet Junior or Deluxe? Or, does it make a difference? Also, has anyone tried Download Accelerator Plus? It seems to be a similar product. Thanks, Ken Janusz, CPIM I'll second that. It's the only way to get a clean download from technet. Jared On Monday 04 June 2001 10:00, Post, Ethan wrote: Note sure if your using a download manager Chris, I used ReGet (Tucows.com) the other day to get 8.1.7.3 and it worked really great. - E -Original Message- Sent: Monday, June 04, 2001 9:22 AM To: Multiple recipients of list ORACLE-L I could never successfully download the file. I ended up getting the CD. [EMAIL PROTECTED] 06/04/01 11:15AM I keep trying to download 9i and the files keep being invalid gzip files. Anyone else have this problem or have successfully downloaded this monster? I have downloaded each file 3-4 times now in the last 2 days. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: When are the various Bckground process stated during the DATA
RTFalert.log. It contains the start order/timestamp for each. Happy R'ing! - Ross || -Original Message- || From: Rajaram [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 04, 2001 3:46 PM || To: Multiple recipients of list ORACLE-L || Subject: When are the various Bckground process stated during the || DATABASE STARTUP? || || || A quick Q, ||I want to know at what stage the various backgound || process are started during the Database STARTUP. || || Thanks in A. || Rajaram || || || NetZero Platinum || No Banner Ads and Unlimited Access || Sign Up Today - Only $9.95 per month! || http://www.netzero.net || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Rajaram || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OCP Model Questions
Hi, I have got this response from many and checked that the site is OK. May be the problem is with your proxy. I too can't access any site from my office which has an underscore within url, not the case when I access from my home. I think this is something to do with Proxy settings. Please check if you can change proxy settings/ try alternate solutions. -- Krishna From: Viraj Luthra [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OCP Model Questions Date: Mon, 04 Jun 2001 00:10:21 -0800 the url does not work On Sun, 03 Jun 2001 22:10:45 Krishna Kakatur wrote: Hi All, I have compiled some model questions for OCP DBA Test at http://www.oraref.com (mirrored at http://smart_and_handsome.tripod.com/oracle.html). If you have more, I will be happy to add them to the Web Page. -- Krishna _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Krishna Kakatur INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Training Database
Hi John, Here is an archived (my personal) post from Mladan Gogala related to a similar question... Hope this helps.. Regards, -Original Message- From: Mladen Gogala [SMTP:[EMAIL PROTECTED]] Sent: Monday, January 10, 2000 10:54 PM To: oracle list Cc: oracle list Subject:Re: How To Extract A Subset Of The Data There is a product called Move For Servers, which can extract logically consistent sample database (by following foreign keys) from the company called Princeton Softech in Princeton, NJ. Their URL is: http://www.princetonsoftech.com. My company (Oxford Health Plans) uses their product and I'm a very happy customer. - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Smith, John A [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Subject: Training Database 1. Is it possible to setup a database that is a subset of a production database for training purposes (Oracle 10.7 and Oracle 11i)? If so, how is this done? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, John A INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Windows ME and Net8
I would try using the WIN2K Client CD. Good Luck April Wells wrote: We have several clients, mostly running NT or 98, and we have been able to get Net8 to install fine. Using the same CD, we cannot get it to install on Windows ME. I have been trying to get an answer as to support from Metalink, but so far have been unable to get an answer. Does anyone have any experience one way or another? Thank You April Wells -Original Message- Sent: Monday, June 04, 2001 1:24 PM To: April Wells April, Here is the error message that I received when attempting to install Oracle 8.1.6's Net on Windows ME. there was an problem in accessing the staging area. Please make sure the specified values for 'Source' and 'DESTINATION' are valid. The information contained in this e-mail is strictly confidential and for the intended use of the addressee only; it may also be legally privileged and/or price sensitive. Notice is hereby given that any disclosure, use or copying of the information by anyone other than the intended recipient is prohibited and may be illegal. If you have received this message in error, please notify the sender immediately by return e-mail. Corporate Systems, Inc. has taken every reasonable precaution to ensure that any attachment to this e-mail has been swept for viruses. We accept no liability for any damage sustained as a result of software viruses and advise you carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
RE: ora-600
Hi, It generally means Contat Oracle Support. You may try to have your alert log file scanned at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html. Set Search Depth to 0. Very nice little tool from Unal Bilisim. I used it a few times with good results. HTH Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Subject: ora-600 Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT RE: TUSC and Kevin Loney
And Rachel works for Godiva. || -Original Message- || From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 04, 2001 4:37 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: TUSC and Kevin Loney || || || and Steven Feuerstein works for Quest || || || From: Ron Rogers [EMAIL PROTECTED] || Reply-To: [EMAIL PROTECTED] || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || Subject: Re: TUSC and Kevin Loney || Date: Mon, 04 Jun 2001 12:02:09 -0800 || || I just had a meeting with the TUSC organization in Atlanta || GA. and Mike || Ault now works for TUSC also. || Ron Rogers || ROR mª¿ªm || || [EMAIL PROTECTED] 06/04/01 02:51PM || I guess I am the last to discover this, but Kevin now works || for TUSC. || || || Patrice Boivin || Systems Analyst (Oracle Certified DBA) || || Systems Admin Operations | Admin. et Exploit. des systèmes || Technology Services| Services technologiques || Informatics Branch | Direction de l'informatique || Maritimes Region, DFO | Région des Maritimes, MPO || || E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Boivin, Patrice J ||INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Ron Rogers ||INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || || _ || Get your FREE download of MSN Explorer at http://explorer.msn.com || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Rachel Carmichael || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OCP Model Questions
Remove the ). from the url and it works. http://smart_and_handsome.tripod.com/oracle.html Krishna Kakatur [EMAIL PROTECTED] 06/04/01 03:44PM Hi, I have got this response from many and checked that the site is OK. May be the problem is with your proxy. I too can't access any site from my office which has an underscore within url, not the case when I access from my home. I think this is something to do with Proxy settings. Please check if you can change proxy settings/ try alternate solutions. -- Krishna From: Viraj Luthra [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OCP Model Questions Date: Mon, 04 Jun 2001 00:10:21 -0800 the url does not work On Sun, 03 Jun 2001 22:10:45 Krishna Kakatur wrote: Hi All, I have compiled some model questions for OCP DBA Test at http://www.oraref.com (mirrored at http://smart_and_handsome.tripod.com/oracle.html). If you have more, I will be happy to add them to the Web Page. -- Krishna _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Krishna Kakatur INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Database writer
It's right there SID = 2, SERIAL# = 1. The name column is the THREAD running the background process. The program column is the PROCESS under NT which is ORACLE80.EXE. Oracle on NT runs ALL the oracle processes under one process with many threads that's why you need the join to v$bgprocess to get the thread name. Rodd Holman Original Message On 6/4/01, 2:46:19 PM, Raghu Kota [EMAIL PROTECTED] wrote regarding RE: Database writer: But I don't see any Processors for DBWr except ORACLE80.EXE!! SIDSERIAL#SCHEMANAME PROGRAM NAME -- -- -- --- - - 1 1 SYSORACLE80.EXE PMON 2 1 SYSORACLE80.EXE DBW0 3 1 SYSORACLE80.EXE ARCH 4 1 SYSORACLE80.EXE LGWR 5 1 SYSORACLE80.EXE CKPT 6 1 SYSORACLE80.EXE SMON 7 1 SYSORACLE80.EXE RECO 8 7 SYS SNP0 9 7 SYS SNP1 9 rows selected. From: Kevin Kostyszyn [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Database writer Date: Mon, 04 Jun 2001 10:16:07 -0800 That was the query I was looking for. -Original Message- Sent: Monday, June 04, 2001 12:46 PM To: Multiple recipients of list ORACLE-L There is a tool in the WinNT Resource Kit that lets you look at individual threads per process. I don't remember what the name is, but it's in there. Try doing a select against v$session and v$bgprocess you should from v$bgprocess you should get a DBW0 and DBW1 under the listing of background processes. select s.sid, s.serial#, s.schemaname, s.program, b.name from v$session s, v$bgprocess b where s.paddr = b.paddr; HTH Rodd Holman Original Message On 6/4/01, 10:55:35 AM, Kevin Kostyszyn [EMAIL PROTECTED] wrote regarding Database writer: Hi all, I added db writer processes last week to try and improve performance of one of my 8.1.7 db's on NT. Does anyone know if there is a way to see if Oracle actually started the additional db writer processes? I added db_writer_processes to the init file, the instance started so I am assuming that the db writer processes are working. But we all know what happens when we assume something. Any ideas would be appreciated. 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: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
RE: ora-600
It means that you should be calling 1-800-223-1711 and have your CSI ready instead of having fun on this mailing list.. -Original Message- Sent: Monday, June 04, 2001 4:11 PM To: Multiple recipients of list ORACLE-L Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Renaming columns ...
Oops! My apology. It was for datatype changed. Erased what I said. -Original Message- Sent: Monday, June 04, 2001 1:59 PM To: Multiple recipients of list ORACLE-L How does it know which column to rename? At 11:21 AM 6/4/01 -0800, you wrote: ALTER TABLE table_name MODIFY ( new_col_name DATATYPE); It works for me in 8i. -Original Message- Sent: Monday, June 04, 2001 11:27 AM To: Multiple recipients of list ORACLE-L Chris: I've been browzing the on-line docs for 9i and the release notes and have seen nothing about renaming a column...can you point me to the location in the docs that give the syntax? Thanks Kevin -Original Message- Sent: Monday, June 04, 2001 1:17 PM To: Multiple recipients of list ORACLE-L Yes renaming a column is supported, in fact you can change almost every aspect of a table online. it works parallel to existing table, right before switching them over, it gets the latest DML applied, then switches over. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 11:27 AM To: Multiple recipients of list ORACLE-L Hi Raj, 1. There is a way to do it. And Mr. Steve A. has some good info about it ( its implications) on his web site. (Sorry I do not have a direct URL link to it). I believe this works for all versions. 2. Yes, it does. I have played with it on my test database. However, I will not do this on a Production database as it involves a direct DML to modify sys.COL$. And Oracle does not recommend doing such things to your databases. I am not sure if renaming column is supported in 9i. Anyone else know for sure? If you are using 8i, the safe way to address this is to add a new column to the table, populate it with the contents from the old, and drop the old column. If the column is not nullable, and if there are plenty of nullable columns towards the end of the table, I suggest considering reorganization of the table. I just did that (reorg) in the last couple of weeks with a 60Mil row table to get the new not nullable columns towards the 'head' of the table. HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 8:51 AM To: Multiple recipients of list ORACLE-L Subject: Renaming columns ... Hi all, although I am searching information on Metalink and OTN, I just want to ask this question to the list ... 1. Is it possible to rename a column? (we have lots of columns that need to be renamed). Which version supports it? 2. Does renaming automatically takes care of indexes? Coding will be a lot of manual labor, but that's okay we can handle it. Thanks in advance Raj __ Rajendra JamadagniMIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! -- 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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message
RE: Database writer
Well duh? :) Sorry, but isn't the Database Writer an Oracle process? -Original Message- Sent: Monday, June 04, 2001 08:46 To: Multiple recipients of list ORACLE-L But I don't see any Processors for DBWr except ORACLE80.EXE!! SIDSERIAL#SCHEMANAME PROGRAM NAME -- -- -- --- - - 1 1 SYSORACLE80.EXE PMON 2 1 SYSORACLE80.EXE DBW0 3 1 SYSORACLE80.EXE ARCH 4 1 SYSORACLE80.EXE LGWR 5 1 SYSORACLE80.EXE CKPT 6 1 SYSORACLE80.EXE SMON 7 1 SYSORACLE80.EXE RECO 8 7 SYS SNP0 9 7 SYS SNP1 9 rows selected. From: Kevin Kostyszyn [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Database writer Date: Mon, 04 Jun 2001 10:16:07 -0800 That was the query I was looking for. -Original Message- Sent: Monday, June 04, 2001 12:46 PM To: Multiple recipients of list ORACLE-L There is a tool in the WinNT Resource Kit that lets you look at individual threads per process. I don't remember what the name is, but it's in there. Try doing a select against v$session and v$bgprocess you should from v$bgprocess you should get a DBW0 and DBW1 under the listing of background processes. select s.sid, s.serial#, s.schemaname, s.program, b.name from v$session s, v$bgprocess b where s.paddr = b.paddr; HTH Rodd Holman Original Message On 6/4/01, 10:55:35 AM, Kevin Kostyszyn [EMAIL PROTECTED] wrote regarding Database writer: Hi all, I added db writer processes last week to try and improve performance of one of my 8.1.7 db's on NT. Does anyone know if there is a way to see if Oracle actually started the additional db writer processes? I added db_writer_processes to the init file, the instance started so I am assuming that the db writer processes are working. But we all know what happens when we assume something. Any ideas would be appreciated. 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: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official
Re: Idea for Very Cool 9i.x Feature
On Monday 04 June 2001 10:56, Post, Ethan wrote: Where do we submit our ideas for enhancement ideas anyway? If you haven't already, join IOUG. That is where official enhancement requests come from. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT RE: TUSC and Kevin Loney
Steve Feuerstein works for Quest Wow, cool, interesting. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 5:28 PM To: Multiple recipients of list ORACLE-L And Rachel works for Godiva. || -Original Message- || From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 04, 2001 4:37 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: TUSC and Kevin Loney || || || and Steven Feuerstein works for Quest || || || From: Ron Rogers [EMAIL PROTECTED] || Reply-To: [EMAIL PROTECTED] || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || Subject: Re: TUSC and Kevin Loney || Date: Mon, 04 Jun 2001 12:02:09 -0800 || || I just had a meeting with the TUSC organization in Atlanta || GA. and Mike || Ault now works for TUSC also. || Ron Rogers || ROR mª¿ªm || || [EMAIL PROTECTED] 06/04/01 02:51PM || I guess I am the last to discover this, but Kevin now works || for TUSC. || || || Patrice Boivin || Systems Analyst (Oracle Certified DBA) || || Systems Admin Operations | Admin. et Exploit. des systèmes || Technology Services| Services technologiques || Informatics Branch | Direction de l'informatique || Maritimes Region, DFO | Région des Maritimes, MPO || || E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Boivin, Patrice J ||INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Ron Rogers ||INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || || _ || Get your FREE download of MSN Explorer at http://explorer.msn.com || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Rachel Carmichael || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
RE: ora-600
Well, is the answer for all ORA 600's, I have noticed there are different ones. One of my fellow employees just called me and told me that the production instance at a clients site just went down with ORA 600. He said that it said in paren's, (with complications). Now what in the good lords name does that mean? I looked on Metasuck and I haven't seen anything. Is the only answer to call support, or just hammer away until he figures it out? Anyone seen this before. And yes I know, it 8.1.5 on NT.. Kev -Original Message- Kirti Sent: Monday, June 04, 2001 5:16 PM To: Multiple recipients of list ORACLE-L Hi, It generally means Contat Oracle Support. You may try to have your alert log file scanned at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html. Set Search Depth to 0. Very nice little tool from Unal Bilisim. I used it a few times with good results. HTH Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Subject: ora-600 Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i download
I use it on a 56k dial up, and it works great!! Mark -Original Message- [EMAIL PROTECTED] Sent: Monday, June 04, 2001 09:44 To: Multiple recipients of list ORACLE-L Is that ReGet Junior or Deluxe? Or, does it make a difference? Also, has anyone tried Download Accelerator Plus? It seems to be a similar product. Thanks, Ken Janusz, CPIM I'll second that. It's the only way to get a clean download from technet. Jared On Monday 04 June 2001 10:00, Post, Ethan wrote: Note sure if your using a download manager Chris, I used ReGet (Tucows.com) the other day to get 8.1.7.3 and it worked really great. - E -Original Message- Sent: Monday, June 04, 2001 9:22 AM To: Multiple recipients of list ORACLE-L I could never successfully download the file. I ended up getting the CD. [EMAIL PROTECTED] 06/04/01 11:15AM I keep trying to download 9i and the files keep being invalid gzip files. Anyone else have this problem or have successfully downloaded this monster? I have downloaded each file 3-4 times now in the last 2 days. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: ora-600
Raghu, as Mladen said .. it means that u have hit an oracle bug.. generally the first parameter tells Oracle what code path encountered the bug. Other parameters are specific and relavant measures that might vary based on what the first parameter is. In addition, ora-600 is accompanied by a trace file that dumps a lot of crap in addition to the stack tace that is nothing but the sequence of kernel calls that lead to the failure.. hth Deepak -Original Message- Sent: Monday, June 04, 2001 2:47 PM To: Multiple recipients of list ORACLE-L It means that you should be calling 1-800-223-1711 and have your CSI ready instead of having fun on this mailing list.. -Original Message- Sent: Monday, June 04, 2001 4:11 PM To: Multiple recipients of list ORACLE-L Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thapliyal, Deepak INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ora-600
Ora-600 . thats the new race where they make you run around sending them this and that 600 times before they tell you we have no Idea. Its the Oracle Catch-All error. Call Support. They will probably want to see any dump or trace files generated. -Original Message- Sent: Monday, June 04, 2001 5:08 PM To: Multiple recipients of list ORACLE-L Well, is the answer for all ORA 600's, I have noticed there are different ones. One of my fellow employees just called me and told me that the production instance at a clients site just went down with ORA 600. He said that it said in paren's, (with complications). Now what in the good lords name does that mean? I looked on Metasuck and I haven't seen anything. Is the only answer to call support, or just hammer away until he figures it out? Anyone seen this before. And yes I know, it 8.1.5 on NT.. Kev -Original Message- Kirti Sent: Monday, June 04, 2001 5:16 PM To: Multiple recipients of list ORACLE-L Hi, It generally means Contat Oracle Support. You may try to have your alert log file scanned at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html. Set Search Depth to 0. Very nice little tool from Unal Bilisim. I used it a few times with good results. HTH Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Subject: ora-600 Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: TUSC and Kevin Loney
Can't let that happen! If that happened, there would be Tusc DB 1.0 and all us oracle guru's will be useless against that product. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 6:27 PM To: Multiple recipients of list ORACLE-L And tusc has a partnership w/ quest. Weird. tusc does a lot of their recruiting at Barnes and Noble. I think Steve Adams is on the hit list. From: Rachel Carmichael [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: TUSC and Kevin Loney Date: Mon, 04 Jun 2001 12:36:50 -0800 and Steven Feuerstein works for Quest From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: TUSC and Kevin Loney Date: Mon, 04 Jun 2001 12:02:09 -0800 I just had a meeting with the TUSC organization in Atlanta GA. and Mike Ault now works for TUSC also. Ron Rogers ROR mª¿ªm [EMAIL PROTECTED] 06/04/01 02:51PM I guess I am the last to discover this, but Kevin now works for TUSC. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may
Re: don't anger the xoxolate gods / Re: Idea for Very Cool
At 11:16 AM 6/4/01 -0800, you wrote: the punishment for further offence will be to be reborn as a human sized cochroach made to work in marketing. But you are repeating yourself Dennis Taylor One man's beach is another man's erosion. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Database writer
Kevin, What size is your redo log buffer? Jared On Monday 04 June 2001 08:55, Kevin Kostyszyn wrote: Hi all, I added db writer processes last week to try and improve performance of one of my 8.1.7 db's on NT. Does anyone know if there is a way to see if Oracle actually started the additional db writer processes? I added db_writer_processes to the init file, the instance started so I am assuming that the db writer processes are working. But we all know what happens when we assume something. Any ideas would be appreciated. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Compute statisics
I have just received some notes from one our applications support, and they suggest after I compute statistics for the objects within their schema, that I then delete those statistics where num_rows * avg_row_len 65000 ?? What affect could this possibly have on the system ? I thought you would want statistics on all objects for the optimizer to function efficently Thank you in advance Darren - Darren Browett P.EngThis message was transmitted Systems Admin/DBA using 100% recycled electrons Information and Communications Technology. City of Coquitlam P:(604) 927 - 3614 E:[EMAIL PROTECTED] - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: TUSC and Kevin Loney
Who is Kevin Loney? -Original Message- Sent: Monday, June 04, 2001 6:55 PM To: Multiple recipients of list ORACLE-L Can't let that happen! If that happened, there would be Tusc DB 1.0 and all us oracle guru's will be useless against that product. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 6:27 PM To: Multiple recipients of list ORACLE-L And tusc has a partnership w/ quest. Weird. tusc does a lot of their recruiting at Barnes and Noble. I think Steve Adams is on the hit list. From: Rachel Carmichael [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: TUSC and Kevin Loney Date: Mon, 04 Jun 2001 12:36:50 -0800 and Steven Feuerstein works for Quest From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: TUSC and Kevin Loney Date: Mon, 04 Jun 2001 12:02:09 -0800 I just had a meeting with the TUSC organization in Atlanta GA. and Mike Ault now works for TUSC also. Ron Rogers ROR mª¿ªm [EMAIL PROTECTED] 06/04/01 02:51PM I guess I am the last to discover this, but Kevin now works for TUSC. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
how to run procedure containig REF CURSOR as datatype
Hi, What value to pass as io_cursor in the following procedureHow to run the procedures containing REF CURSOR.. create or replace package GetRateSchedules_pkg as TYPE t_cursor is REF CURSOR; procedure GetRateSchedules( temp_id_acc int,acc_cycle_id int,default_pl int,RecordDate date,temp_id_pi_type int,io_cursor in out t_cursor); end; i am getting error when i run the following code: declare TYPE t_cursor is REF CURSOR; io_cursor t_cursor; begin getrateschedules_pkg.getrateschedules(1,2,3,sysdate,4,io_cursor); end; / ORA-01790: expression must have same datatype as corresponding expression. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TUSC and Kevin Loney
And tusc has a partnership w/ quest. Weird. tusc does a lot of their recruiting at Barnes and Noble. I think Steve Adams is on the hit list. As far as I am aware, some of the very respectable 'big guns' at Quest are: Gaja, Eyal Aronoff, Guy Harrison (yes - the one from the 'Oracle SQL tuning' fame), Steven Feuerstein (of PL/SQL fame), And now, as TUSC are: Rich Niemiec (President IOUG-A?), Kevin Loney, Mike Ault, ... So is this coalition a viable alternative to the all-knowing Oracle Support Services? John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: TUSC and Kevin Loney
At TUSC, there are more authors than Rich Niemiec, Mike Ault, and Kevin Loney. There are also Brad Brown, Joe Trezzo, Tony Catalano. -Ari On Mon, 4 Jun 2001, John Kanagaraj wrote: And tusc has a partnership w/ quest. Weird. tusc does a lot of their recruiting at Barnes and Noble. I think Steve Adams is on the hit list. As far as I am aware, some of the very respectable 'big guns' at Quest are: Gaja, Eyal Aronoff, Guy Harrison (yes - the one from the 'Oracle SQL tuning' fame), Steven Feuerstein (of PL/SQL fame), And now, as TUSC are: Rich Niemiec (President IOUG-A?), Kevin Loney, Mike Ault, ... So is this coalition a viable alternative to the all-knowing Oracle Support Services? John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ari D Kaplan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: NT script question ???
Go to http://www.activestate.com, get perl, DBI DBD::Oracle and you'll have all the cripting tools that you'll ever need. Associative arrays, state of the art reuglar expressions, functions, format commands and well documented ways of accessing the oracle database from within a script (O'Reilly book). That version of perl supports Andy Duncan's Orac_DBA and Adam von Nieda's Oracletool (http://www.oracletool.com), two excellent DBA utilities with the unbeatable price. -Original Message- Sent: Saturday, June 02, 2001 7:15 PM To: Multiple recipients of list ORACLE-L Hi, I have couple of questions about bat file in NT 4.0 for Oracle 8.1.5. 1. how to make bat file take parameters. I had a backup.bat, and like to pass in Oracle SID, so the script can backup any database. 2. in the bat file, how to dynamically append date/time into a directory name, like backup_06022001121314 Thank you! Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
export causes segmentation fault
Hi, A friend of mine ran an export and got segmentation fault. It seems to be a bug with 8.1.6 on Solaris 5.8 and relates to character sets. Below is the info supplied by him. Anyone has experienced the same problem or could give a suggestion what to try? I searched Metalink and could not find any references to this problem. Thanks The database was created with charset and ncharset both set to WE8ISO8859P1: select * from NLS_DATABASE_PARAMETERS NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CHARACTERSET WE8ISO8859P1 NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE AMERICAN NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM NLS_DUAL_CURRENCY $ NLS_COMP BINARY NLS_NCHAR_CHARACTERSET WE8ISO8859P1 NLS_RDBMS_VERSION 8.1.6.0.0 --- When exporting the largest table, IF the client has US7ASCII set as the nls charset, the export works fine: $ export NLS_LANG=American_America.US7ASCII $ exp Export: Release 8.1.6.0.0 - Production on Mon Jun 4 10:37:28 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Username: aleg Password: Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - 64bit Production With the Partitioning option JServer Release 8.1.6.0.0 - Production Enter array fetch buffer size: 4096 2560 Export file: expdat.dmp /tmp/x.dmp (2)U(sers), or (3)T(ables): (2)U 3 Export table data (yes/no): yes Compress extents (yes/no): yes Export done in US7ASCII character set and WE8ISO8859P1 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion) About to export specified tables via Conventional Path ... Table(T) or Partition(T:P) to be exported: (RETURN to quit) topicrels . . exporting table TOPICRELS4826389 rows exported Table(T) or Partition(T:P) to be exported: (RETURN to quit) Export terminated successfully without warnings. --- Note the warning: Export done in US7ASCII character set and WE8ISO8859P1 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion), which I guess we expect! Now, if we set the client NLS_LANG to match the database, the export fails: $ export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 $ exp Export: Release 8.1.6.0.0 - Production on Mon Jun 4 10:41:38 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Username: aleg Password: Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - 64bit Production With the Partitioning option JServer Release 8.1.6.0.0 - Production Enter array fetch buffer size: 4096 2560 Export file: expdat.dmp /tmp/x.dmp (2)U(sers), or (3)T(ables): (2)U 3 Export table data (yes/no): yes Compress extents (yes/no): yes Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set About to export specified tables via Conventional Path ... Table(T) or Partition(T:P) to be exported: (RETURN to quit) topicrels . . exporting table TOPICRELS4826389 rows exportedSegmen tation Fault Other tables are exported just fine. The topicrels table looks like this: CREATE TABLE TOPICRELS ( FROMTIDVARCHAR2 (5) NOT NULL, TRTYPE VARCHAR2 (2) NOT NULL, TOTID VARCHAR2 (5) NOT NULL, SEQNUMBER (4)DEFAULT 0, UNCERTAIN CHAR (1)) TABLESPACE USERS NOLOGGING PCTFREE 1 PCTUSED 99 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 77725696 NEXT 4571136 PCTINCREASE 1 MINEXTENTS 1 MAXEXTENTS 121 FREELISTS 1 FREELIST GROUPS 1 ) CACHE; It has 3 indices: CREATE INDEX TRFROMTOTYPE ON TOPICRELS(FROMTID, TOTID, TRTYPE) TABLESPACE INDX PCTFREE 1 STORAGE(INITIAL 151257088 NEXT 6160384 PCTINCREASE 0 ) ; CREATE INDEX TRFROMTYPESEQTOUNC ON TOPICRELS(FROMTID, TRTYPE, SEQ, TOTID, UNCERTAIN) TABLESPACE INDX PCTFREE 1 STORAGE(INITIAL 108134400 NEXT 6160384 PCTINCREASE 0 ) ; CREATE INDEX TRTOTYPEFROM ON TOPICRELS(TOTID, TRTYPE, FROMTID) TABLESPACE INDX PCTFREE 1 STORAGE(INITIAL 138936320 NEXT 6160384 PCTINCREASE 0 ) ; System info: oracle environment: NLS_LANG=American_America.US7ASCII ORACLE_BASE=/usr/local/oracle/app/oracle ORACLE_DOC=/usr/local/oracle/app/oracle/product/8.1.6/doc ORACLE_HOME=/usr/local/oracle/app/oracle/product/8.1.6 ORACLE_SID=ALEG ORA_NLS33=/usr/local/oracle/app/oracle/product/8.1.6/ocommon/nls/admin/d ata PATH=/usr/local/oracle/app/oracle/product/8.1.6/bin:/etc:/usr/ccs/bin:/u sr/local/ bin:/usr/java/bin:/usr/bin:/usr/ucb:/etc:/usr/sbin:/usr/bin:/usr/ucb:/et c:/usr/dt /bin:/usr/sbin:/usr/ccs/bin:/usr/openwin/bin:/usr/local/bin:. $ uname -a SunOS aleg 5.8 Generic_111459-01 sun4u sparc SUNW,Sun-Blade-1000 -- Please see the official ORACLE-L FAQ:
Re: TUSC and Kevin Loney
On Monday 04 June 2001 16:35, Khedr, Waleed wrote: Who is Kevin Loney? http://www.kevinloney.com Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database writer
Title: RE: Database writer you can download a free fully functional trial version of Spotlight on Oracle from the Quest Website at http://www.quest.com/spotlight_oracle/ there is a link to 'download trial' on the left hand side. You can click on the screenshot to get a full size image... but it will tell you everything you need to know about your instance... and what init.ora parameters you can change to improve it. Nick -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 4:08 PM To: Multiple recipients of list ORACLE-L Subject: Re: Database writer Kevin, What size is your redo log buffer? Jared On Monday 04 June 2001 08:55, Kevin Kostyszyn wrote: Hi all, I added db writer processes last week to try and improve performance of one of my 8.1.7 db's on NT. Does anyone know if there is a way to see if Oracle actually started the additional db writer processes? I added db_writer_processes to the init file, the instance started so I am assuming that the db writer processes are working. But we all know what happens when we assume something. Any ideas would be appreciated. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: TUSC and Kevin Loney
Oracle8/8i DBA Handbook Author visit www.kevinloney.com He is pretty good in Oracle . - SathishB - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 04, 2001 7:35 PM Who is Kevin Loney? -Original Message- Sent: Monday, June 04, 2001 6:55 PM To: Multiple recipients of list ORACLE-L Can't let that happen! If that happened, there would be Tusc DB 1.0 and all us oracle guru's will be useless against that product. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 6:27 PM To: Multiple recipients of list ORACLE-L And tusc has a partnership w/ quest. Weird. tusc does a lot of their recruiting at Barnes and Noble. I think Steve Adams is on the hit list. From: Rachel Carmichael [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: TUSC and Kevin Loney Date: Mon, 04 Jun 2001 12:36:50 -0800 and Steven Feuerstein works for Quest From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: TUSC and Kevin Loney Date: Mon, 04 Jun 2001 12:02:09 -0800 I just had a meeting with the TUSC organization in Atlanta GA. and Mike Ault now works for TUSC also. Ron Rogers ROR mª¿ªm [EMAIL PROTECTED] 06/04/01 02:51PM I guess I am the last to discover this, but Kevin now works for TUSC. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access /
RE: Database writer
Nick, Does spotlight support an Oracle server running on NT? The requirements page says: Server Oracle versions from 7.3.3 and above Solaris (2.5, 2.6, 2.7) HP-UX (10.20, 11.00/32 bit, 11.00/64 bit) AIX (4.2, 4.3) Digital (v4.0d, v4.0f) which seems to me to say the Oracle server must be running on Unix and not NT. but then the PDF data sheet says Spotlight requires Windows 95/98/2000/NT and a SQL*Net connection to any Oracle server (7.3.3 or greater) Which is correct? Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, 5 June 2001 11:20 you can download a free fully functional trial version of Spotlight on Oracle from the Quest Website at http://www.quest.com/spotlight_oracle/ there is a link to 'download trial' on the left hand side. You can click on the screenshot to get a full size image... but it will tell you everything you need to know about your instance... and what init.ora parameters you can change to improve it. Nick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: TUSC and Kevin Loney
the heck you say! Good chocolate or none at all... Callebrut From: Mohan, Ross [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: OT RE: TUSC and Kevin Loney Date: Mon, 04 Jun 2001 13:27:38 -0800 And Rachel works for Godiva. || -Original Message- || From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 04, 2001 4:37 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: TUSC and Kevin Loney || || || and Steven Feuerstein works for Quest || || || From: Ron Rogers [EMAIL PROTECTED] || Reply-To: [EMAIL PROTECTED] || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || Subject: Re: TUSC and Kevin Loney || Date: Mon, 04 Jun 2001 12:02:09 -0800 || || I just had a meeting with the TUSC organization in Atlanta || GA. and Mike || Ault now works for TUSC also. || Ron Rogers || ROR mª¿ªm || || [EMAIL PROTECTED] 06/04/01 02:51PM || I guess I am the last to discover this, but Kevin now works || for TUSC. || || || Patrice Boivin || Systems Analyst (Oracle Certified DBA) || || Systems Admin Operations | Admin. et Exploit. des systèmes || Technology Services| Services technologiques || Informatics Branch | Direction de l'informatique || Maritimes Region, DFO | Région des Maritimes, MPO || || E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Boivin, Patrice J ||INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Ron Rogers ||INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || || _ || Get your FREE download of MSN Explorer at http://explorer.msn.com || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Rachel Carmichael || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed
RE: ora-600
ora-600 is a severe error and the codes in parens are debugging codes for Oracle Support CALL SUPPORT when you get an ora-600 and ora-7445 From: Kevin Kostyszyn [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: ora-600 Date: Mon, 04 Jun 2001 14:08:06 -0800 Well, is the answer for all ORA 600's, I have noticed there are different ones. One of my fellow employees just called me and told me that the production instance at a clients site just went down with ORA 600. He said that it said in paren's, (with complications). Now what in the good lords name does that mean? I looked on Metasuck and I haven't seen anything. Is the only answer to call support, or just hammer away until he figures it out? Anyone seen this before. And yes I know, it 8.1.5 on NT.. Kev -Original Message- Kirti Sent: Monday, June 04, 2001 5:16 PM To: Multiple recipients of list ORACLE-L Hi, It generally means Contat Oracle Support. You may try to have your alert log file scanned at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html. Set Search Depth to 0. Very nice little tool from Unal Bilisim. I used it a few times with good results. HTH Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Subject:ora-600 Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).