Re: OWS-05566 caused by ORA-12202
Hi Rhojel, I'm sure you know this, but that error message usually leads you straight to Oracle support. Are the protocols on each box the same? Are the sqlnet.ora files the same? Or do they at least each have AUTOMATIC_IPC set to OFF? Regards, Melanie --- [EMAIL PROTECTED] wrote: > Hi Melanie, > > This was how the application was implemented in my > new company, they used > OAS 408. > Still gettingfamiliar with their application.. this > is what happened: I > transferred the dev DB > to another host for maintenance purposes and when I > tried to configure a > DAD > for that DB in OAS, I got that error. > BTW, I thought 817 comes with some AS components > only (like Apache)? > Anyway, thanks for taking the time. > > Best Regards, > Rhojel > > > > > Melanie Caffrey <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 11/18/2003 12:14 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:Re: OWS-05566 caused by > ORA-12202 > > > Hi Rhojel, > > 8.1.7 comes with the 9iAS installed automatically as > part of the regular software install. > > May I ask why you're using OAS? > > Regards, > Melanie > > --- [EMAIL PROTECTED] wrote: > > I would like to make an application in OAS 408 to > > connect to an 817 > > database. When I try to create a DAD to establish > > this connection, I get > > this error: "OWS-05566 caused by ORA-12202: TNS > > internal navigation > > error". Can anyone enlighten me on what these > errors > > mean and how to work > > around it? > > DB is 8.1.7.1.1 on WinNT 4 SP6a, Net version > > 8.1.7.1.0. > > Application Server is OAS 408 on WinNT 4 SP6a, Net > > version 8.0.5. > > Any help would be appreciated. > > > > Best Regards, > > Rhojel Echano > > > > > > > __ > Do you Yahoo!? > Protect your identity with Yahoo! Mail AddressGuard > http://antispam.yahoo.com/whatsnewfree > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Melanie Caffrey > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > > __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OWS-05566 caused by ORA-12202
Hi Rhojel, 8.1.7 comes with the 9iAS installed automatically as part of the regular software install. May I ask why you're using OAS? Regards, Melanie --- [EMAIL PROTECTED] wrote: > I would like to make an application in OAS 408 to > connect to an 817 > database. When I try to create a DAD to establish > this connection, I get > this error: "OWS-05566 caused by ORA-12202: TNS > internal navigation > error". Can anyone enlighten me on what these errors > mean and how to work > around it? > DB is 8.1.7.1.1 on WinNT 4 SP6a, Net version > 8.1.7.1.0. > Application Server is OAS 408 on WinNT 4 SP6a, Net > version 8.0.5. > Any help would be appreciated. > > Best Regards, > Rhojel Echano > > __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Multithreaded server - effect of POOLING=ON option
Hi Peter, There are many parameters for this particular option: ON, OFF, YES, NO, IN, OUT, TRUE, FALSE, BOTH (not even sure I've exhausted the entire list here) Used for connection pooling, the values you choose for this parameter impact your idle network connections. For more info, feel free to check out this link: http://download-west.oracle.com/docs/cd/B10501_01/network.920/a96580/mts.htm#453787 hth, melanie --- "Schauss, Peter" <[EMAIL PROTECTED]> wrote: > Thanks for all of the input on the multi-threaded > server. I have one > more question: > > What is the effect of the POOLING option on the > MTS_DISPATCHERS > specification? > > Thanks, > Peter Schauss > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Schauss, Peter > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Change dedicated server to shared server
Well all, I finally checked out what I stated below this weekend, and, unfortunately, the new 9i init.ora parameters are not there in the text. :-( (New edition maybe, Jonathan? :-) ) *However*, the book is still outstanding in terms of setting up MTS initially, AND troubleshooting, AND checking out the various MTS dynamic performance views while testing. All you have to do is swap the 9i init.ora parameters from the 9i documentation set with the ones listed in the text (if you're using 9i) which is really no biggy. Melanie --- Melanie Caffrey <[EMAIL PROTECTED]> wrote: > Hi Stephen, > > Check out the Shared Server/MTS chapter. The last > few > pages of this chapter should introduce the new 9i > init.ora parameters. > > And, I agree. I like this book very much. > > Melanie > > --- Stephen Andert <[EMAIL PROTECTED]> > wrote: > > Well, I just paged through the front part and it > > says nothing about 9i > > coverage. I don't use MTS, so I'm not a good > judge > > on what it covers > > that may apply to 9i or not. The rest of the book > I > > can judge and find > > it (IMHO) to be a very good book on Oracle Network > > communication, both > > with good clear overviews as well as detailed > > references for > > troubleshooting and configuration. > > > > Stephen > > > > >>> [EMAIL PROTECTED] 11/07/03 09:19AM >>> > > The actual titile is "Oracle Net8: Configuration > > and > > Troubleshooting", > > but I remember a good start to 9i's Oracle Net > > features being included > > as well. > > > > Melanie > > > > -Original Message- > > Sent: Friday, November 07, 2003 10:58 AM > > To: '[EMAIL PROTECTED]' > > > > > > > > If you purchase "Oracle Networking > (something > > or other) :-) " by > > Jonathan Gennick and Hugo Toledo, this should give > > you an excellent > > start. > > > > > > I can't recall, off the top of my head if the new > > MTS 9i init.ora > > parameters are included in this text. > > > > I believe that the latest edition of this book > does > > include them, > > though > > ... > > > > HTH, > > Melanie > > > > -Original Message- > > Mauricio Vilez > > Sent: Friday, November 07, 2003 10:34 AM > > To: Multiple recipients of list ORACLE-L > > > > > > > > Hi > > > > Can somebody tell me the steps for changing my > > server configuration > > from > > dedicated server to shared server? > > > > Thanks > > > > > > > > _ > > > > Do you Yahoo!? > > Protect <http://antispam.yahoo.com/whatsnewfree> > > your identity with > > Yahoo! Mail AddressGuard > > > > > > > > > > > ** > > This email is intended only for the use of the > > individual or > > entity to which it is addressed and may contain > > information > > that is privileged, confidential and exempt from > > disclosure > > under applicable law. If the reader of this e-mail > > message is > > not the intended recipient, or the employee or > agent > > responsible > > for delivery of the message to the intended > > recipient, you are > > hereby notified that any dissemination, > distribution > > or copying of > > this > > communication is prohibited. If you have received > > this e-mail > > in error, please notify us immediately by > telephone > > at (212) 686-6004 > > and also indicate the sender's name. > > > > Thank You > > > > www.proximo.com > > > > [EMAIL PROTECTED] > > > > > * > > > > > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.net > > -- > > Author: Stephen Andert > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 > > http://www.fatcity.com > > San Diego, California-- Mailing list and > web > > hosting services > > > - > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in &
RE: Uncle Larry, wake up!!!
This is true, Tom. Some technologies never die ... Personally, COBOL and CICS are not my favorite skillsets, *but* if it ever comes down to going back to coding in COBOL or being unemployed then --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > it's a quiet little secret in consultant-land right > now that the older > technologies are in play. as the older-folks > retire, there is a need for > cobol-based support. especially in NY state > agencies. > > > -Original Message- > Sent: Friday, November 07, 2003 3:04 PM > To: Multiple recipients of list ORACLE-L > > > Goulet, Dick scribbled on the wall in glitter > crayon: > > > OH, ANCIENT History!! > > u... do i admit to getting a job hit last week > because i know CICS?;-) > > it's still out there and still being used. > > -- > Bill "Shrek" Thater ORACLE DBA > "I'm going to work my ticket if I can..." -- Gilwell > song > [EMAIL PROTECTED] > > A hundred times every day I remind myself that my > inner and outer life are > based on the labours of others. - Albert Einstein > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Thater, William > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Mercadante, Thomas F > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: How do you generate primary keys?
ect or body. > > > > > > > >-- > > > >Please see the official ORACLE-L FAQ: > http://www.orafaq.net > > > >-- > > > >Author: Jonathan Gennick > > > > INET: [EMAIL PROTECTED] > > > > > > > >Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > > > >San Diego, California-- Mailing list > and web > > hosting services > > > > > > >- > > > >To REMOVE yourself from this mailing list, send > an E-Mail message > > > >to: [EMAIL PROTECTED] (note EXACT spelling > of > > 'ListGuru') and in > > > >the message BODY, include a line containing: > UNSUB > > ORACLE-L (or the > > > >name of mailing list you want to be removed > from). You > > may also send > > > >the HELP command for other information (like > subscribing). > > > > > > Hemant K Chitale > > > Oracle 9i Database Administrator Certified > Professional > > > My personal web site is : > http://hkchital.tripod.com > > > > > > > > > -- > > > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > > > -- > > > Author: Hemant K Chitale > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > > > San Diego, California-- Mailing list and > web > > hosting services > > > > > > - > > > To REMOVE yourself from this mailing list, send > an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > > the message BODY, include a line containing: > UNSUB ORACLE-L (or the > > > name of mailing list you want to be removed > from). You may > > also send > > > the HELP command for other information (like > subscribing). > > > > > > -- > > > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > > > -- > > > Author: Cary Millsap > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > > > San Diego, California-- Mailing list and > web > > hosting services > > > > > > - > > > To REMOVE yourself from this mailing list, send > an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > > the message BODY, include a line containing: > UNSUB ORACLE-L (or the > > > name of mailing list you want to be removed > from). You may > > also send > > > the HELP command for other information (like > subscribing). > > > > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > > -- > > Author: <[EMAIL PROTECTED] > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > > San Diego, California-- Mailing list and > web hosting services > > > - > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') > > and in the message BODY, include a line > containing: UNSUB > > ORACLE-L (or the name of mailing list you want to > be removed > > from). You may also send the HELP command for > other > > information (like subscribing). > > > > > ** > > ** > > ** > > This 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.net > > -- > > Author: Jamadagni, Rajendra > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > > San Diego, California-- Mailing list and > web hosting services > > > - > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') > > and in the message BODY, include a line > containing: UNSUB > > ORACLE-L (or the name of mailing list you want to > be removed > > from). You may also send the HELP command for > other > > information (like subscribing). > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > > -- > > Author: Cary Millsap > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > > San Diego, California-- Mailing list and > web hosting services > > > - > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') > > and in the message BODY, include a line > containing: UNSUB > > ORACLE-L (or the name of mailing list you want to > be removed > > from). You may also send the HELP command for > other > > information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Niall Litchfield > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Change dedicated server to shared server
Hi Stephen, Check out the Shared Server/MTS chapter. The last few pages of this chapter should introduce the new 9i init.ora parameters. And, I agree. I like this book very much. Melanie --- Stephen Andert <[EMAIL PROTECTED]> wrote: > Well, I just paged through the front part and it > says nothing about 9i > coverage. I don't use MTS, so I'm not a good judge > on what it covers > that may apply to 9i or not. The rest of the book I > can judge and find > it (IMHO) to be a very good book on Oracle Network > communication, both > with good clear overviews as well as detailed > references for > troubleshooting and configuration. > > Stephen > > >>> [EMAIL PROTECTED] 11/07/03 09:19AM >>> > The actual titile is "Oracle Net8: Configuration > and > Troubleshooting", > but I remember a good start to 9i's Oracle Net > features being included > as well. > > Melanie > > -Original Message- > Sent: Friday, November 07, 2003 10:58 AM > To: '[EMAIL PROTECTED]' > > > > If you purchase "Oracle Networking (something > or other) :-) " by > Jonathan Gennick and Hugo Toledo, this should give > you an excellent > start. > > > I can't recall, off the top of my head if the new > MTS 9i init.ora > parameters are included in this text. > > I believe that the latest edition of this book does > include them, > though > ... > > HTH, > Melanie > > -Original Message- > Mauricio Vilez > Sent: Friday, November 07, 2003 10:34 AM > To: Multiple recipients of list ORACLE-L > > > > Hi > > Can somebody tell me the steps for changing my > server configuration > from > dedicated server to shared server? > > Thanks > > > > _ > > Do you Yahoo!? > Protect <http://antispam.yahoo.com/whatsnewfree> > your identity with > Yahoo! Mail AddressGuard > > > > > ** > This email is intended only for the use of the > individual or > entity to which it is addressed and may contain > information > that is privileged, confidential and exempt from > disclosure > under applicable law. If the reader of this e-mail > message is > not the intended recipient, or the employee or agent > responsible > for delivery of the message to the intended > recipient, you are > hereby notified that any dissemination, distribution > or copying of > this > communication is prohibited. If you have received > this e-mail > in error, please notify us immediately by telephone > at (212) 686-6004 > and also indicate the sender's name. > > Thank You > > www.proximo.com > > [EMAIL PROTECTED] > > * > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Stephen Andert > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Change dedicated server to shared server
Title: Message The actual titile is "Oracle Net8: Configuration and Troubleshooting", but I remember a good start to 9i's Oracle Net features being included as well. Melanie -Original Message-----From: Melanie Caffrey [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 10:58 AMTo: '[EMAIL PROTECTED]'Subject: RE: Change dedicated server to shared server If you purchase "Oracle Networking (something or other) :-) " by Jonathan Gennick and Hugo Toledo, this should give you an excellent start. I can't recall, off the top of my head if the new MTS 9i init.ora parameters are included in this text. I believe that the latest edition of this book does include them, though ... HTH, Melanie -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mauricio VilezSent: Friday, November 07, 2003 10:34 AMTo: Multiple recipients of list ORACLE-LSubject: Change dedicated server to shared server Hi Can somebody tell me the steps for changing my server configuration from dedicated server to shared server? Thanks Do you Yahoo!?Protect your identity with Yahoo! Mail AddressGuard **This email is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this e-mail message is not the intended recipient, or the employee or agent responsible for delivery of the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of thiscommunication is prohibited. If you have received this e-mail in error, please notify us immediately by telephone at (212) 686-6004and also indicate the sender's name. Thank You www.proximo.com [EMAIL PROTECTED] *
RE: Change dedicated server to shared server
Title: Message If you purchase "Oracle Networking ... (something or other) :-) " by Jonathan Gennick and Hugo Toledo, this should give you an excellent start. I can't recall, off the top of my head if the new MTS 9i init.ora parameters are included in this text. I believe that the latest edition of this book does include them, though .. HTH, Melanie -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mauricio VilezSent: Friday, November 07, 2003 10:34 AMTo: Multiple recipients of list ORACLE-LSubject: Change dedicated server to shared server Hi Can somebody tell me the steps for changing my server configuration from dedicated server to shared server? Thanks Do you Yahoo!?Protect your identity with Yahoo! Mail AddressGuard **This email is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this e-mail message is not the intended recipient, or the employee or agent responsible for delivery of the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of thiscommunication is prohibited. If you have received this e-mail in error, please notify us immediately by telephone at (212) 686-6004and also indicate the sender's name. Thank You www.proximo.com [EMAIL PROTECTED] *
Re: Wow, Man, Flashbacks!
Just spoke with someone off the list. Let me clarify something. It is recommended that rollback segments not be used. But I didn't actually try to use them, so I'm not sure. I used the recommended AUM. --- Melanie Caffrey <[EMAIL PROTECTED]> wrote: > Yes, this is correct. > > Rollback segments cannot be used. > > --- Stephen Andert <[EMAIL PROTECTED]> > wrote: > > Bambi, > > > > Are you using automatic undo management or manual? > > > I think that > > flashback can only be used with auto. > > > > Stephen > > > > >>> [EMAIL PROTECTED] 11/06/03 10:04AM >>> > > Hi Folks! > > > > I got waylaid(?) when I got in this morning and > > these user dudes were > > talking about using flashbacks, and I was like > > "Woah! Dudes! Let's > > just > > chill on this for a couple of minutes". So, I > went > > back to my desk > > and > > checked out a cool article on it... > > > > > http://www.oracle-base.com/Articles/9i/FlashbackQuery.asp > > > > > > And it looks like it's like, killer, yknow? So, I > > was thinking "well, > > we've > > got sufficiently large undo segments for this, I > > don't see a problem > > with > > it" but that didn't sound terribly cool, and > anyway, > > before I go > > willy-nilly > > saying this is the niftiest thing Oracle's done in > > years, I thought I > > would > > run it by you guys and see if anybody out there is > > running with > > flashbacks > > and whether there have been any problems with it. > > > > Yer far-out pal, > > Bambi. > > > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.net > > -- > > Author: Bellow, Bambi > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 > > http://www.fatcity.com > > San Diego, California-- Mailing list and > web > > hosting services > > > - > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be > removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.net > > -- > > Author: Stephen Andert > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 > > http://www.fatcity.com > > San Diego, California-- Mailing list and > web > > hosting services > > > --------- > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be > removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > __ > Do you Yahoo!? > Protect your identity with Yahoo! Mail AddressGuard > http://antispam.yahoo.com/whatsnewfree > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Melanie Caffrey > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Wow, Man, Flashbacks!
Yes, this is correct. Rollback segments cannot be used. --- Stephen Andert <[EMAIL PROTECTED]> wrote: > Bambi, > > Are you using automatic undo management or manual? > I think that > flashback can only be used with auto. > > Stephen > > >>> [EMAIL PROTECTED] 11/06/03 10:04AM >>> > Hi Folks! > > I got waylaid(?) when I got in this morning and > these user dudes were > talking about using flashbacks, and I was like > "Woah! Dudes! Let's > just > chill on this for a couple of minutes". So, I went > back to my desk > and > checked out a cool article on it... > > http://www.oracle-base.com/Articles/9i/FlashbackQuery.asp > > > And it looks like it's like, killer, yknow? So, I > was thinking "well, > we've > got sufficiently large undo segments for this, I > don't see a problem > with > it" but that didn't sound terribly cool, and anyway, > before I go > willy-nilly > saying this is the niftiest thing Oracle's done in > years, I thought I > would > run it by you guys and see if anybody out there is > running with > flashbacks > and whether there have been any problems with it. > > Yer far-out pal, > Bambi. > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Bellow, Bambi > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Stephen Andert > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Wow, Man, Flashbacks!
Hi Bambi, I hate to sound repetitive, but, it depends. :-) It depends on how far you want to flash back to. One of my clients was being audited last year by their parent company. I put in a retention period of about a week at a time. Without divulging much from my confidentiality agreement with them, we were really trying to figure out what certain users were doing within the company, and we provided proof of such. Using the flashback query feature made this incredibly easy to do! Of course, you have to be careful with your UNDO segments, as you know. I didn't try going backwards for more than a week. That was all we needed at the time. I also turned this feature off once we were done. Other than UNDO segment growth, which I planned for in advance, I didn't have any problems with it. And it made the task at hand incredibly easy. But, I wouldn't recommend putting it in place unless you really need it. My $0.02, Melanie --- "Bellow, Bambi" <[EMAIL PROTECTED]> wrote: > Hi Folks! > > I got waylaid(?) when I got in this morning and > these user dudes were > talking about using flashbacks, and I was like > "Woah! Dudes! Let's just > chill on this for a couple of minutes". So, I went > back to my desk and > checked out a cool article on it... > > http://www.oracle-base.com/Articles/9i/FlashbackQuery.asp > > And it looks like it's like, killer, yknow? So, I > was thinking "well, we've > got sufficiently large undo segments for this, I > don't see a problem with > it" but that didn't sound terribly cool, and anyway, > before I go willy-nilly > saying this is the niftiest thing Oracle's done in > years, I thought I would > run it by you guys and see if anybody out there is > running with flashbacks > and whether there have been any problems with it. > > Yer far-out pal, > Bambi. > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Bellow, Bambi > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PCTFREE and PCTUSED
Uh, oh. No wonder I confused you with what I wrote Mladen. The below should read if the PCTFREE value is 10, NOT 90. See what happens when you compose emails when taking antihistamines. Don't worry. I'm not doing any storage tuning at the present moment ... :) Melanie --- Melanie Caffrey <[EMAIL PROTECTED]> wrote: > Ummm ... Mladen? > > MG> 1) If the free space percentage in the block > falls > MG> below PCTFREE, , the block is > MG> taken off the free list. > > Don't you mean if the free space percentage goes > *above* the value in PCTFREE? > > Unless I'm reading you incorrectly, don't you mean > that, say, if the PCTFREE value is 90, and the block > becomes 91% full, then the block is taken off the > free > list? > > (Maybe this is what you mean and I'm not reading you > correctly ) > > --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > > OK, I used to teach DBA courses and that was one > of > > my favorite topics so let > > me give it a shot here: > > 1) If the free space percentage in the block falls > > below PCTFREE, the block is > > taken off the free list. Heuristically speaking, > we > > can say that oracle does > > its best to keep the block PCTFREE free. > > > > 2) When the block is taken off the free list and > > records are deleted, the > > block is not returned to the free list until the > > percentage of used space > > doesn't fall below PCTUSED. Again, heuristically > > speaking, oracle tries to > > keep blocks at least PCTUSED used. > > > > I believe that your question was about the need > for > > two parameters, in other > > words, why do we need both of them, why don't we > > return block to free list > > after the percentage of free space grows above > > PCTFREE? The answer is that > > free list handling is overhead, which means that > the > > database is working on > > its own structures and not working on the user > data. > > It's easy to conceive a > > busy transaction table to which records are > > frequently added and from which > > they're frequently removed. Having only one > > parameter would significantly > > increase the amount of time spent in moving blocks > > to and from the free list, > > and significantly increase the overhead. You can > > test it by setting up a table > > with PCTFREE+PCTUSED=100. In other word, the > answer > > to your question is that > > two parameters are needed to reduce the overhead > of > > the free list maintenance. > > > > Fortunately, if you are on Oracle v9.2 and above, > > you can avoid the whole > > thing by creating your tablespaces in such a way > > that the objects in them have > > free lists managed by oracle (SEGMENT SPACE > > MANAGEMENT AUTO clause). > > > > > > > > On 2003.11.04 18:09, Maryann Atkinson wrote: > > > Suppose I have the following settings which > happen > > to be > > > the defaults as well: > > > > > > PCTFREE 10 > > > PCTUSED 40 > > > > > > > > > I am trying to figure out what PCTUSED is really > > used for. > > > My book is telling me that is used so that > Oracle > > knows > > > whether to keep a block in the "free-list". > > > > > > My point is this: If PCTFREE is 10%, that means > > the block can be > > > up to 90% full, right? > > > > > > Well, if the block happens to be 60% full at the > > moment, then Oracle > > > knows that this block is not full enough because > > 60 is less than 90, > > > so it can keep it in the free list. I dont see > > what PCTUSED is needed, > > > it kind of seems I can accomplish the same with > > just one parm, > > > that being PCTFREE. > > > > > > But Oracle wouldnt have just put a parm there > > without any usage, > > > so I guess there's something I dont see... > > > > > > Any ideas/examples? Any good reasoning anywhere? > > > > > > Thanks, > > > maa > > > > > >-- > > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.net > > >-- > > > Author: Maryann Atkinson > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- 858-538-5051 > > http://www.fatcity.com > > > San Diego, Calif
Re: PCTFREE and PCTUSED
OK. I think we're essentially saying the same thing. But in two different ways. --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > No, I don't mean that. If the free space percentage > goes above PCTFREE, that > means that there is more then PCTFREE % free space > in the block. Block is > thus eligible for free list. If the percentage of > free space falls below > PCTFREE, that means that there is less then PCTFREE > % of free space. Block is > taken off the free list. > > On 2003.11.04 20:19, Melanie Caffrey wrote: > > Ummm ... Mladen? > > > > MG> 1) If the free space percentage in the block > falls > > MG> below PCTFREE, , the block is > > MG> taken off the free list. > > > > Don't you mean if the free space percentage goes > > *above* the value in PCTFREE? > > > > Unless I'm reading you incorrectly, don't you mean > > that, say, if the PCTFREE value is 90, and the > block > > becomes 91% full, then the block is taken off the > free > > list? > > > > (Maybe this is what you mean and I'm not reading > you > > correctly ) > > > > --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > > > OK, I used to teach DBA courses and that was one > of > > > my favorite topics so let > > > me give it a shot here: > > > 1) If the free space percentage in the block > falls > > > below PCTFREE, the block is > > > taken off the free list. Heuristically speaking, > we > > > can say that oracle does > > > its best to keep the block PCTFREE free. > > > > > > 2) When the block is taken off the free list and > > > records are deleted, the > > > block is not returned to the free list until the > > > percentage of used space > > > doesn't fall below PCTUSED. Again, heuristically > > > speaking, oracle tries to > > > keep blocks at least PCTUSED used. > > > > > > I believe that your question was about the need > for > > > two parameters, in other > > > words, why do we need both of them, why don't we > > > return block to free list > > > after the percentage of free space grows above > > > PCTFREE? The answer is that > > > free list handling is overhead, which means that > the > > > database is working on > > > its own structures and not working on the user > data. > > > It's easy to conceive a > > > busy transaction table to which records are > > > frequently added and from which > > > they're frequently removed. Having only one > > > parameter would significantly > > > increase the amount of time spent in moving > blocks > > > to and from the free list, > > > and significantly increase the overhead. You can > > > test it by setting up a table > > > with PCTFREE+PCTUSED=100. In other word, the > answer > > > to your question is that > > > two parameters are needed to reduce the overhead > of > > > the free list maintenance. > > > > > > Fortunately, if you are on Oracle v9.2 and > above, > > > you can avoid the whole > > > thing by creating your tablespaces in such a way > > > that the objects in them have > > > free lists managed by oracle (SEGMENT SPACE > > > MANAGEMENT AUTO clause). > > > > > > > > > > > > On 2003.11.04 18:09, Maryann Atkinson wrote: > > > > Suppose I have the following settings which > happen > > > to be > > > > the defaults as well: > > > > > > > > PCTFREE 10 > > > > PCTUSED 40 > > > > > > > > > > > > I am trying to figure out what PCTUSED is > really > > > used for. > > > > My book is telling me that is used so that > Oracle > > > knows > > > > whether to keep a block in the "free-list". > > > > > > > > My point is this: If PCTFREE is 10%, that > means > > > the block can be > > > > up to 90% full, right? > > > > > > > > Well, if the block happens to be 60% full at > the > > > moment, then Oracle > > > > knows that this block is not full enough > because > > > 60 is less than 90, > > > > so it can keep it in the free list. I dont see > > > what PCTUSED is needed, > > > > it kind of seems I can accomplish the same > with > > > just one parm, > > > > that being PCTFREE. >
Re: PCTFREE and PCTUSED
Ummm ... Mladen? MG> 1) If the free space percentage in the block falls MG> below PCTFREE, , the block is MG> taken off the free list. Don't you mean if the free space percentage goes *above* the value in PCTFREE? Unless I'm reading you incorrectly, don't you mean that, say, if the PCTFREE value is 90, and the block becomes 91% full, then the block is taken off the free list? (Maybe this is what you mean and I'm not reading you correctly ) --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > OK, I used to teach DBA courses and that was one of > my favorite topics so let > me give it a shot here: > 1) If the free space percentage in the block falls > below PCTFREE, the block is > taken off the free list. Heuristically speaking, we > can say that oracle does > its best to keep the block PCTFREE free. > > 2) When the block is taken off the free list and > records are deleted, the > block is not returned to the free list until the > percentage of used space > doesn't fall below PCTUSED. Again, heuristically > speaking, oracle tries to > keep blocks at least PCTUSED used. > > I believe that your question was about the need for > two parameters, in other > words, why do we need both of them, why don't we > return block to free list > after the percentage of free space grows above > PCTFREE? The answer is that > free list handling is overhead, which means that the > database is working on > its own structures and not working on the user data. > It's easy to conceive a > busy transaction table to which records are > frequently added and from which > they're frequently removed. Having only one > parameter would significantly > increase the amount of time spent in moving blocks > to and from the free list, > and significantly increase the overhead. You can > test it by setting up a table > with PCTFREE+PCTUSED=100. In other word, the answer > to your question is that > two parameters are needed to reduce the overhead of > the free list maintenance. > > Fortunately, if you are on Oracle v9.2 and above, > you can avoid the whole > thing by creating your tablespaces in such a way > that the objects in them have > free lists managed by oracle (SEGMENT SPACE > MANAGEMENT AUTO clause). > > > > On 2003.11.04 18:09, Maryann Atkinson wrote: > > Suppose I have the following settings which happen > to be > > the defaults as well: > > > > PCTFREE 10 > > PCTUSED 40 > > > > > > I am trying to figure out what PCTUSED is really > used for. > > My book is telling me that is used so that Oracle > knows > > whether to keep a block in the "free-list". > > > > My point is this: If PCTFREE is 10%, that means > the block can be > > up to 90% full, right? > > > > Well, if the block happens to be 60% full at the > moment, then Oracle > > knows that this block is not full enough because > 60 is less than 90, > > so it can keep it in the free list. I dont see > what PCTUSED is needed, > > it kind of seems I can accomplish the same with > just one parm, > > that being PCTFREE. > > > > But Oracle wouldnt have just put a parm there > without any usage, > > so I guess there's something I dont see... > > > > Any ideas/examples? Any good reasoning anywhere? > > > > Thanks, > > maa > > > >-- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > >-- > > Author: Maryann Atkinson > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > > San Diego, California-- Mailing list and > web hosting services > > > - > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like subscribing). > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > ----- > To REMOVE yourself from this mailing lis
RE: Database Normalization
Thanks, Rachel. Obvious answers like the below elude my overworked and sleep-deprived brain right now :) Long work weekend and all that ... Guess I'll leave poor Sams alone, then. -Original Message- Rachel Carmichael Sent: Monday, November 03, 2003 2:15 PM To: Multiple recipients of list ORACLE-L change the url to www.tinyurl.com/th7i --- Melanie Caffrey <[EMAIL PROTECTED]> wrote: > > Hi Jared, > > > Just so I'm clear which one to avoid, are you referring to the one > that links to the excerpt from this book? > > Sams Teach Yourself SQL in 21 Days, Second Edition > > The reason I'm asking is I entered your URL below but received a "Page > Not Found" error. > > When I searched the TinyURL site for "normalization" hits, this is > what I came up with. > > Thanks, > Melanie > > -Original Message- > [EMAIL PROTECTED] > Sent: Monday, November 03, 2003 1:34 PM > To: Multiple recipients of list ORACLE-L > > > > > List, > > Doing some reading on Normalization today. We actually have the > opportunity to create a database and app, and it's been so long since > I've done this > on a real > project, a refresher was in order. > > I have the annoying habit of knowing what to do with normalization, > based on past education and experience, but having difficulty > explaining it to others. > This is the kind > of thing that makes Cary Millsap nuts. ( read the book if you don't > know > why ) > > Mladen would no doubt find this very simple. > > Anyway, in the course of finding some recent web pages on this, one of > the better > was at a SQL server magazine site: > http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887&pg=1 > > The reason for writing however, was to show you the worst one so far: > www.tinyurl/th7i > > Basically, 'normalize unless it's inconvenient'. > > Jared > > > __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this e-mail message is not the intended recipient, or the employee or agent responsible for delivery of the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is prohibited. If you have received this e-mail in error, please notify us immediately by telephone at (212) 686-6004 and also indicate the sender's name. Thank You www.proximo.com [EMAIL PROTECTED] * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database Normalization
Title: Message Hi Jared, Just so I'm clear which one to avoid, are you referring to the one that links to the excerpt from this book? Sams Teach Yourself SQL in 21 Days, Second Edition The reason I'm asking is I entered your URL below but received a "Page Not Found" error. When I searched the TinyURL site for "normalization" hits, this is what I came up with. Thanks, Melanie -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Monday, November 03, 2003 1:34 PMTo: Multiple recipients of list ORACLE-LSubject: Database Normalization List, Doing some reading on Normalization today. We actually have the opportunity to create a database and app, and it's been so long since I've done this on a real project, a refresher was in order. I have the annoying habit of knowing what to do with normalization, based on past education and experience, but having difficulty explaining it to others. This is the kind of thing that makes Cary Millsap nuts. ( read the book if you don't know why ) Mladen would no doubt find this very simple. Anyway, in the course of finding some recent web pages on this, one of the better was at a SQL server magazine site: http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887&pg=1 The reason for writing however, was to show you the worst one so far: www.tinyurl/th7i Basically, 'normalize unless it's inconvenient'. Jared
RE: dba interview questions
; - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L (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, including > attachments, is strictly confidential and for the intended use of the > addressee only; it may also contain > proprietary, price sensitive, or legally privileged information. > Notice is hereby given that > any disclosure, distribution, dissemination, use, or copying of the > information by anyone > other than the intended recipient is strictly prohibited and may be > illegal. If you have > received this communication in error, please notify the sender > immediately by reply e-mail, > delete this communication, and destroy all copies. > > > Corporate Systems, Inc. has taken reasonable precautions to ensure > that any attachment to this e-mail has been swept for viruses. We > specifically disclaim all liability and will > accept no responsibility for any damage sustained as a result of > software viruses and advise > you to carry out your own virus checks before opening any attachment. > __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services ------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cache a table
Title: Message Just to add to Alex's point below, John Beresniewicz wrote a paper some time ago (about two or three years) that effectively explains the different buffer pools, and provides test results of the mid-point insertion algorithms: http://www.orapub.com/cgi/genesis.cgi?p1=sub&p2=abs122 If you don't already have a user account on the orapub site, it's quick to create one, and, of course, free. Cheers, Melanie -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Tuesday, October 21, 2003 5:34 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Cache a table John,Tom, There is a difference between pools {DEFAULT vs. KEEP and RECYCLE}. By default only DEFAULT pool use "mid-point" insert. It is controlled by hidden parameters _db_percent_hot_default (Percent of default buffer pool considered hot) default 50 _db_percent_hot_keep (Percent of keep buffer pool considered hot) default 0 _db_percent_hot_recycle (Percent of recycle buffer pool considered hot) default 0 Table's attribute "CACHE" controls whether blocks read by FTS will be placed on LRU or MRU end of the LRU list, but only up to _small_table_threshold (threshold level of table size for forget-bit enabled during scan), default is 2% of db_block_size. Alex. -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 21, 2003 12:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: Cache a table I always wondered why Oracle thought this was a useful table attribute. My gut feeling is that it is an extra that does little. For example, say we want to keep a code table in memory because it is constantly being hit for column verifiction. By definition, if a table is constantly being queried, it's segments will be in memory because they never age out. That sounds like cacheing to me. And then I remember a specific piece of Oracle documentation saying that, even though we may mark a table to be "cached", it *still* may be aged out if memory is needed for other data blocks. Like I said, sounds a little like "here you have it, and here you don't". I'm sure that my impression is wrong and someone will correct me. But I doubt I will use the "CACHE" option anytime soon. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, October 21, 2003 2:54 PM To: Multiple recipients of list ORACLE-L My understanding is that the KEEP and RECYCLE Pools are just 'names' in the sense that they are placeholders for assigning an object to the BUFFER_POOL { KEEP | RECYCLE | DEFAULT } clause, and that the 'aging' algorithms for KEEP and RECYCLE are exactly the same. Assigning a specific object to one of these named pools segregates objects by retention-requirements. Thus, KEEP does not imply a different treatment of the Buffers - rather it makes sure that objects that you would like to 'keep' around are specifically directed to a common pool and vice versa Does anyone have additional information that can verify this? I heard this from a knowledgeable Oracle instructor in an Oracle Tuning training Class. John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevitable, but Discouragement is optional! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** >-Original Message- >From: Tim Gorman [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, October 21, 2003 6:59 AM >To: Multiple recipients of list ORACLE-L >Subject: Re: Cache a table > > >Good points, Arup. > >Actually, I would argue that there is better reason to >consider using the >RECYCLE pool than to consider how to "cache" tables or use the >KEEP pool. >The advantage of effective use of the RECYCLE pool is better >behavior in the >rest of the Buffer Cache... > >When you think of it, the default DEFAULT buffer pool and the >KEEP pool have >essentially the same purpose: long-term caching of blocks. >What keeps them >from accomplishing that mission but objects whose blocks waste >space and >energy cycling into and out from the Buffer Cache? > >It's kind of like a school teacher admonishing his/her class that "a >troublesome few have ruined things for everybody". When I was in >school, "troublemakers" were segregated from the rest of the class, >sometimes cumulatively into a separate classroom (we called ourselves >"the mentals" >and read Mad magazines all the time, which accounts for a lot, then and >now). Nowadays, I'm sure that such a measure isn't considered >for fear of >lawsuit for hurting the "self-esteem" of the poor dears. >Never mind the >confusion between the useless feel-good phrase "self-esteem" >and the more >u
RE: sometimes pressure seems to get the best of us.
No problem. I understand. Listen. Two similar messages I wrote went through. They seem to be taking about an hour to post. And sometimes, they're scrambled and out of order. A second post will be coming through, and it looks like the original post you just responded to. Please just ignore it. It looked like my messages weren't going through, so I sent one twice. But I am not one to beat a dead horse. Please ignore the second post. :-) Cheers, Melanie P.S. I'm glad you ultimately got the answers you were looking for. -Original Message- MaryAnn Atkinson Sent: Friday, October 17, 2003 5:34 PM To: Multiple recipients of list ORACLE-L I am the one who needs to apologize, dont hold it agaist me though, its just sometimes pressure seems to get the best of us. Sorry, maa --- Melanie Caffrey <[EMAIL PROTECTED]> wrote: > MaryAnn, > > I, of course, do not have a problem with you asking a question, > absolutely not. > > It was just your inference that we have you read it in the "National > Enquirer", if I'm quoting your email correctly, seemed pretty harsh. > > I thought you worked with Oracle stuff. If you do not, then I > apologize. > > And of course, you can pose any question you want to, on this list. > > No flames, I promise. > > Peace, > Melanie > > -Original Message- > Maryann Atkinson > Sent: Friday, October 17, 2003 5:04 PM > To: Multiple recipients of list ORACLE-L > > For Melanie Caffrey, > > Woww... Was your interference RUDE or what? > > > > Several people have offered you very clear and very good > suggestions. > > First of all, mel, I didnt reply to "several people", I replied to > one. > Was that one you? > > > > And really, you SHOULD be reading the Oracle manuals. > > Second of all, mel, I dont really need a lecture, thank you very > much! > Third of all missy, what I was told was to read up on this and that. > I had not been told to read "the manual", or even which one. > > > > Otherwise, why did you take a job working with Oracle technology? > > Fourth of all, mel, noone ever told you I took a job working with > Oracle Technology. > > Fifth of all, I didnt know that having a job working with Oracle > technology is a requirement for me to be in this list and ask a > question. > Is it? > > Please, very please, pretty please, flames belong back to the 90s, > I never meant any, so please dont give me any yourself. > > I just dont get that mentality, I just asked a question, a simple > little lowly question, if you dont have an answer, please dont reply > at all, I will not hold it against you, or against anyone, I couldnt > > possibly. > But please dont make me feel bad for asking it telling me to go read > on > (vaguely like that), just let it go... > > many-many thanks, > maa > > > And anything of personal nature, you can email me personally, > you know, there is no reason to involve the whole list... > > > At 04:09 PM 10/17/2003, you wrote: > >MaryAnn, > >First of all, Wow! Is your reply to this group ever rude. > > > >Several people have offered you very clear and very good > suggestions. > > > >And really, you SHOULD be reading the Oracle manuals. Otherwise, > why > >did you take a job working with Oracle technology? > > > >I don't think the problem is with the answers you've received, but > in > >your disinterest in listening to them. > > > >Melanie > > > > > >-Original Message- > >MaryAnn Atkinson > >Sent: Friday, October 17, 2003 2:43 PM > >To: Multiple recipients of list ORACLE-L > > > >I still dont get it... > >I dont know what I have done to have me confused more > >than I first asked the question... > > > > > >--- [EMAIL PROTECTED] wrote: > > > My bad. The SQL is not quite right: 'append' is a hint: > > > alter table resource nologging; > > > >dont know what nologging does. > > > > > > > insert /*+ append */ into resource > > > select * from rqmt; > > > >me no understand... me no see 1000 anywhere... > > > > > Read up on direct load insert in the concepts manual, > > > along with nologging. > > > >And one more thing... If I asked the question, thats just it, > >I asked a question. If anyone knows the answer, please offer it > here, > >but dont tell me to go read it up in the national enquirer or > >I-dont-know-where-you-mean... > > > >Folks, please, if we have something to offer, lets go ahead, > >if
FW: For Melanie Caffrey
MaryAnn, I, of course, do not have a problem with you asking a question, absolutely not. It was just your inference that we have you read it in the "National Enquirer", if I'm quoting your email correctly, seemed pretty harsh. You didn't respond to one person, you responded to the entire list. Given the answers that appeared in this list, it seems that no one besides me read your full response to Jared's suggestion. You state that >And one more thing... If I asked the question, thats just it, >I asked a question. If anyone knows the answer, please offer it here, >but dont tell me to go read it up in the national enquirer or >I-dont-know-where-you-mean... We all read the Web and the Oracle docs in addition to the great answers we receive on this list. If I were to take offense at someone telling me to read, then I wouldn't be able to perform my job, on most occasions. You appeared annoyed that you were asked to read up on certain topics. I thought you worked with Oracle stuff. You state below that you do not. If you do not, then I apologize. And of course, you can pose any question you want to, on this list. No flames, I promise. Peace, Melanie -Original Message- Maryann Atkinson Sent: Friday, October 17, 2003 5:04 PM To: Multiple recipients of list ORACLE-L For Melanie Caffrey, Woww... Was your interference RUDE or what? > > Several people have offered you very clear and very good suggestions. First of all, mel, I didnt reply to "several people", I replied to one. Was that one you? > > And really, you SHOULD be reading the Oracle manuals. Second of all, mel, I dont really need a lecture, thank you very much! Third of all missy, what I was told was to read up on this and that. I had not been told to read "the manual", or even which one. > > Otherwise, why did you take a job working with Oracle technology? Fourth of all, mel, noone ever told you I took a job working with Oracle Technology. Fifth of all, I didnt know that having a job working with Oracle technology is a requirement for me to be in this list and ask a question. Is it? Please, very please, pretty please, flames belong back to the 90s, I never meant any, so please dont give me any yourself. I just dont get that mentality, I just asked a question, a simple little lowly question, if you dont have an answer, please dont reply at all, I will not hold it against you, or against anyone, I couldnt possibly. But please dont make me feel bad for asking it telling me to go read on (vaguely like that), just let it go... many-many thanks, maa And anything of personal nature, you can email me personally, you know, there is no reason to involve the whole list... At 04:09 PM 10/17/2003, you wrote: >MaryAnn, >First of all, Wow! Is your reply to this group ever rude. > >Several people have offered you very clear and very good suggestions. > >And really, you SHOULD be reading the Oracle manuals. Otherwise, why >did you take a job working with Oracle technology? > >I don't think the problem is with the answers you've received, but in >your disinterest in listening to them. > >Melanie > > >-Original Message- >MaryAnn Atkinson >Sent: Friday, October 17, 2003 2:43 PM >To: Multiple recipients of list ORACLE-L > >I still dont get it... >I dont know what I have done to have me confused more >than I first asked the question... > > >--- [EMAIL PROTECTED] wrote: > > My bad. The SQL is not quite right: 'append' is a hint: > > alter table resource nologging; > >dont know what nologging does. > > > > insert /*+ append */ into resource > > select * from rqmt; > >me no understand... me no see 1000 anywhere... > > > Read up on direct load insert in the concepts manual, > > along with nologging. > >And one more thing... If I asked the question, thats just it, >I asked a question. If anyone knows the answer, please offer it here, >but dont tell me to go read it up in the national enquirer or >I-dont-know-where-you-mean... > >Folks, please, if we have something to offer, lets go ahead, >if not, just bypass that email and read another one... > >thanks, >maa > > > > > > > > Bypass the redo and undo - no need for commits. > > > > Just back it up when finished. > > > > Jared > > > > > > > > > > > > > > > > MaryAnn Atkinson <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 10/16/2003 01:49 PM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:Re: insert and commit 1000 records at
RE: For Melanie Caffrey
MaryAnn, I, of course, do not have a problem with you asking a question, absolutely not. It was just your inference that we have you read it in the "National Enquirer", if I'm quoting your email correctly, seemed pretty harsh. I thought you worked with Oracle stuff. If you do not, then I apologize. And of course, you can pose any question you want to, on this list. No flames, I promise. Peace, Melanie -Original Message- Maryann Atkinson Sent: Friday, October 17, 2003 5:04 PM To: Multiple recipients of list ORACLE-L For Melanie Caffrey, Woww... Was your interference RUDE or what? > > Several people have offered you very clear and very good suggestions. First of all, mel, I didnt reply to "several people", I replied to one. Was that one you? > > And really, you SHOULD be reading the Oracle manuals. Second of all, mel, I dont really need a lecture, thank you very much! Third of all missy, what I was told was to read up on this and that. I had not been told to read "the manual", or even which one. > > Otherwise, why did you take a job working with Oracle technology? Fourth of all, mel, noone ever told you I took a job working with Oracle Technology. Fifth of all, I didnt know that having a job working with Oracle technology is a requirement for me to be in this list and ask a question. Is it? Please, very please, pretty please, flames belong back to the 90s, I never meant any, so please dont give me any yourself. I just dont get that mentality, I just asked a question, a simple little lowly question, if you dont have an answer, please dont reply at all, I will not hold it against you, or against anyone, I couldnt possibly. But please dont make me feel bad for asking it telling me to go read on (vaguely like that), just let it go... many-many thanks, maa And anything of personal nature, you can email me personally, you know, there is no reason to involve the whole list... At 04:09 PM 10/17/2003, you wrote: >MaryAnn, >First of all, Wow! Is your reply to this group ever rude. > >Several people have offered you very clear and very good suggestions. > >And really, you SHOULD be reading the Oracle manuals. Otherwise, why >did you take a job working with Oracle technology? > >I don't think the problem is with the answers you've received, but in >your disinterest in listening to them. > >Melanie > > >-Original Message- >MaryAnn Atkinson >Sent: Friday, October 17, 2003 2:43 PM >To: Multiple recipients of list ORACLE-L > >I still dont get it... >I dont know what I have done to have me confused more >than I first asked the question... > > >--- [EMAIL PROTECTED] wrote: > > My bad. The SQL is not quite right: 'append' is a hint: > > alter table resource nologging; > >dont know what nologging does. > > > > insert /*+ append */ into resource > > select * from rqmt; > >me no understand... me no see 1000 anywhere... > > > Read up on direct load insert in the concepts manual, > > along with nologging. > >And one more thing... If I asked the question, thats just it, >I asked a question. If anyone knows the answer, please offer it here, >but dont tell me to go read it up in the national enquirer or >I-dont-know-where-you-mean... > >Folks, please, if we have something to offer, lets go ahead, >if not, just bypass that email and read another one... > >thanks, >maa > > > > > > > > Bypass the redo and undo - no need for commits. > > > > Just back it up when finished. > > > > Jared > > > > > > > > > > > > > > > > MaryAnn Atkinson <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 10/16/2003 01:49 PM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:Re: insert and commit 1000 records at a time > > > > > > > > --- [EMAIL PROTECTED] wrote: > > > That will work, slowly. > > > You might like to try something like this > > > insert into resource > > > nologging > > > select * from rqmt > > > append; > > > > > > How's that commiting every 1000 records? > > > > > Read up on the 'append' and 'nologging' first. > > > > ??? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Maryann Atkinson <[EMAIL PROTECTED]> > > > Sent by: [EMAIL PROTECTED] > > > 10/16/2003 08:54 AM > > > Please
RE: insert and commit 1000 records at a time
d for other information (like > subscribing). > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > Author: MaryAnn Atkinson > INET: [EMAIL PROTECTED] __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MaryAnn Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT California
I know this should really be on the OT list, but, I couldn't help laughing at the below. And all along, I thought Mladen's original comment was actually just a clever amalgamation of "governor" and "terminator". Whatever the original intent, it's still funny. :-) -Original Message- [EMAIL PROTECTED] Sent: Thursday, October 16, 2003 2:29 PM To: Multiple recipients of list ORACLE-L Check your Latin...that's "Gubernator"... |How, in the world, did a man with such a poor taste in movies |build such a huge company like Oracle Corp? No wonder that Arnie |has become a guvernator of CA. BTW, has anyone here seen the |"Demolition Man"? It's not an Arnie movie, but the scene with the |"Schwartzenegger presidential library" got completely new meaning. |On 10/16/2003 01:09:32 PM, "Boivin, Patrice J" wrote: |> I found this quote in Sillicon Valley News: |> |> Q U O T E D |> |> "I'd just like to say for the record, 'Commando' is one of my |> favorite |> movies." |> -- Oracle Chairman and Chief Executive Larry Ellison offers some |> thoughts on |> Arnold Schwarzenegger, California's governor-elect. |> (ref. |> http://www.siliconvalley.com/mld/siliconvalley/business/columnists/gmsv/ 7011 |> 848.htm ) |> |> I wonder what's happening in California for Oracle Corp, HP's CEO is |> part of |> Arnold's transition team, but not much comment about Oracle in that |> state. |> I know about the contract controversy, maybe that's why we didn't |> hear |> much. |> |> Patrice. |> |> -- |> Please see the official ORACLE-L FAQ: http://www.orafaq.net |> -- |> Author: Boivin, Patrice J |> INET: [EMAIL PROTECTED] |> |> Fat City Network Services-- 858-538-5051 http://www.fatcity.com |> San Diego, California-- Mailing list and web hosting services |> - |> To REMOVE yourself from this mailing list, send an E-Mail message |> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |> the message BODY, include a line containing: UNSUB ORACLE-L |> (or the name of mailing list you want to be removed from). You may |> also send the HELP command for other information (like subscribing). |> |Mladen Gogala |Oracle DBA |Note: |This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. |Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Mladen Gogala | INET: [EMAIL PROTECTED] |Fat City Network Services-- 858-538-5051 http://www.fatcity.com |San Diego, California-- Mailing list and web hosting services |- |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To
RE: 8.1.7 Support Extension?
Hi Brad, This one caught me off guard too. You are right in that it was *originally* 12/31/2003. However, check out Metalink Note 148054.1, dated 10/09/2003. The extension is noted there. Regards, Melanie -Original Message- Odland, Brad Sent: Wednesday, October 15, 2003 10:14 AM To: Multiple recipients of list ORACLE-L When did they annouce that? Wasn't the end of error correction 12/31/2003? Brad -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database just stops, now 8.1.7 support
Ah, I see. Thank you, Paul. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Drake Sent: Wednesday, October 15, 2003 10:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Database just stops, now 8.1.7 support Melanie, If we didn't have issues with CBO behavior differences, I would be pushing harder to move to 9.2.0.4. The only thing that saved a rollback to 8.1.7.4.6 was setting optimizer_features_enable=8.1.7. Paul "Caffrey, Melanie" <[EMAIL PROTECTED]> wrote: Oh, OK. I just looked at Metalink and saw that this announcement took place less than a week ago. I guess the original announcement of desupport panicked quite a few people. Hence the extension. Anyway, since I've already recommended upgrades to 9i, I'm going to stick with it. No reason to encourage anybody to stick with old technology unless they are in dire financial straits ... -Original Message- Sent: Wed 10/15/2003 9:14 AM To: Multiple recipients of list ORACLE-L Cc: support for 8i has been extended to 12/31/2004 --- "Caffrey, Melanie" <[EMAIL PROTECTED]>wrote: > Paul, > > My question is a little off-topic here, but since Ron has already > discovered the source of his problem ... > > You state below that Oracle has "extended support for a year of > 8.1.7". > > What do you mean exactly? For instance, when does support actually > end, then? > > The reason I ask is that the word from Ken Jacobs in September was > that 8i would only be supported through the end of this calendar > year. > > This is incredibly relevant information, for I will have to guide my > clients accordingly. > > Regards, > Melanie > > -Original Message- > From: Paul Drake [mailto:[EMAIL PROTECTED] > Sent: Tue 10/14/2003 4:59 PM > To: Multiple recipients of list ORACLE-L > Cc: > Subject: Re: Database just stops > > > Ron, > > Its highly likely that if you were to open a TAR on this, that the > analyst would recite the following: > > "please apply the currently supported patc! hset" - which would be > 8.1.7.4.1. > > Unfortunately, there are numerous security fixes that have been made > available that are not in a full patchset release (one that can be > applied with OUI) - e.g. patchset 8.1.7.4.12. I'd recommend having > the security fixes in place, but Oracle is less than wonderful about > how they word the use of one-off patchsets. So, if you're risk-averse > in terms of applying patchsets instead of being risk-averse in terms > of some user running load with a long username/password > and crashing the instance (security), at least apply the 8.1.7.4.1 > patchset. > > There is exploit code in the wild (shipped by oracle) that can crash > an instance. > You should be able to find an entry in the listener.log file for > this. > It is highly unlikely that this is causing the crash, however. > (email me backchannel, as I don't want to ! > > IMHO: Oracle should release an 8.1.7.5.x patchset so that the > security fixes are in a full patchset release. Now that they've > extended support for a year of 8.1.7, there really isn't an excuse > not to. > > Unless you get lucky, you're going to have to apply a patchset. > So why not just apply the patchset (properly, after reading the > release notes, full backups, exports, etc) and see if that takes care > of the problem? > > More often then not, the issue has been encountered by some other > user, they filed a tar >> bug report >> bug fix >> patch (a lengthy > process). > > hth. > > Paul > > "Smith, Ron L." <[EMAIL PROTECTED]>wrote: > > I have an Oracle 8.1.7.0 database running on an MS2000 server. A > few times a day the database just stops running for no reason. > There are no messages in the alert or trace! logs. Nothing in the > Event logs. It just stops. > > When I restart the database it goes through crash recovery but > comes up fine. > > Anyone have any ideas? > > Thanks! > Ron Smith > > > _ > > Do you Yahoo!? > The New Yahoo! Shopping > > - with improved product search > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Caffrey, Melanie > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT ! spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECT
RE: Data Modelling Tools for a DBAs Job
If you're using Rational Rose, are you interested in UML modeling? For if so, you might want to check out a tool created by Dulcian, Inc. called BRIM. http://www.dulcian.com It's a free tool, but I do believe that you must contact them for an initial consultation. I am not sure about all of the specifics involved in what your relationship with this company would need to be. It's worth a look, though. One of the tool's designers demo-ed this for me at ODTUG last June and it looks pretty good. HTH, Melanie -Original Message- quriyat Sent: Monday, October 13, 2003 8:34 PM To: Multiple recipients of list ORACLE-L How essential the following tools to a DBAs job? (viz) Rational Rose, Clear case for Versioning etc. What are Data Modelling tools avbl. in the market and which are widely used (other than Oracle Designer)?. TIA ___ No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: quriyat INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hiding the names of Web Toolkit procedures in Browser Address boxes
Hi Pete, Thanks much for the links to your papers! The client has not stated as such that they'd like to hide the fact that it is a Web toolkit based site, for the rest of the URL would still be visible: http://the_server/pls/the_dad/ It appears to be only the package name/procedure name, or, when used, just the procedure name, that they'd ultimately like to keep hidden. Thanks again, Melanie -Original Message- Pete Finnigan Sent: Monday, October 13, 2003 5:19 PM To: Multiple recipients of list ORACLE-L Address boxes Hi Melanie you could use synonyms to hide the real names of the procedures if this is a suitable alternative to showing procedure names but it doesn't alter the fact that someone could then just call these synonyms if the goal is SQL injection. You might be interested in the three papers I wrote for security focus on SQL injection in Oracle - see http://www.pet efinnigan.com/orasec.htm for the links - they are near the top of the page. Is the concern to hide the fact that it is a web toolkit based site? kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hiding the names of Web Toolkit procedures in Browser Address boxes
Igor, Possibly. I've not tried this approach. Have you? Is the synonym, in fact, then displayed as opposed to the procedure name, in your address line? I am temporarily away from the testing site or I would test this out straight away. Thank you for your feedback. Cheers, Melanie -Original Message- Igor Neyman Sent: Monday, October 13, 2003 2:19 PM To: Multiple recipients of list ORACLE-L Address boxes Will your customer allow displaying a synonym instead of the stored procedure name? Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Melanie Caffrey Sent: Monday, October 13, 2003 1:04 PM To: Multiple recipients of list ORACLE-L boxes Hello Listers, I'm trying to work out a solution for a client that I've not been able to find any substantial documentation for. Anybody familiar with the 9iAS and the PL/SQL Web Toolkit out there? I thought I was, but a client of mine has come up with a very interesting (and, I believe, very reasonable) request. They'd like to ensure that, say, when a user clicks on a hyperlink, for instance, the name of the subsequently called procedure is not displayed in the address line of the browser; in other words, no visibility of the name of the called procedure to the user using the Web app. There is a lot of documentation on aliasing directory paths in Apache, but not procedure names, per se. Particularly since, naturally, the Apache server is open source. The solution I use must be Oracle-specific (I ... er ... believe). I could throw up a JS window that temporarily covers the address window, but that is not really an ideal solution. Has anyone ever tried this before? TIA, Melanie Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Hiding the names of Web Toolkit procedures in Browser Address boxes
Hello Listers, I'm trying to work out a solution for a client that I've not been able to find any substantial documentation for. Anybody familiar with the 9iAS and the PL/SQL Web Toolkit out there? I thought I was, but a client of mine has come up with a very interesting (and, I believe, very reasonable) request. They'd like to ensure that, say, when a user clicks on a hyperlink, for instance, the name of the subsequently called procedure is not displayed in the address line of the browser; in other words, no visibility of the name of the called procedure to the user using the Web app. There is a lot of documentation on aliasing directory paths in Apache, but not procedure names, per se. Particularly since, naturally, the Apache server is open source. The solution I use must be Oracle-specific (I ... er ... believe). I could throw up a JS window that temporarily covers the address window, but that is not really an ideal solution. Has anyone ever tried this before? TIA, Melanie Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 10g new featuers seminars from oracle
There was one here, in New York, last Thursday. If whatever you've been invited to has a title that runs along the lines of "The Launch of 10g", then it's safe to say that it's probably pure marketing. Melanie -Original Message- [EMAIL PROTECTED] Sent: Monday, October 13, 2003 11:24 AM To: Multiple recipients of list ORACLE-L my company just got invited to on next month in Wash DC. Anyone know if these will have meet or will they just be fluff? I dont want to waste my time going to a sales pitch. they had one last week that was just marketing. One of our guys went to it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SDU in 9.2.0.4 - dynamic registration
Does this help? http://otn.oracle.com/deploy/availability/pdf/MAA_DG_NetBestPrac.pdf Melanie -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Drake Sent: Tuesday, October 07, 2003 9:40 PM To: Multiple recipients of list ORACLE-L Subject: SDU in 9.2.0.4 - dynamic registration I thought that I saw something posted somewhere recently concerning the TNS listener SDU setting an support for non-2k sizes with dynamic registration in 9.2.0.4. Must have seen it late night, can't track it down. Has anyone come across this? At 2 sites, it was a choice between connect-time failover (not transparent) working or non-default SDU/TDU. I'd really like to have an SDU=16kb with connect-time failover. thanks, Paul Do you Yahoo!? The New Yahoo! Shopping - with improved product search
RE: auditing is my friend
Hear, hear, Paul! I too, am a big fan of auditing. It can make your life so much easier. Cheers, Melanie -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Drake Sent: Tuesday, October 07, 2003 8:14 PM To: Multiple recipients of list ORACLE-L Subject: auditing is my friend Hi. I just wanted to plug the use of auditing. By simply enabling audit session, I detemined that users that were accessing a database via a vpn connection were being timed out (LOGOFF BY CLEANUP). It wasn't the application that was causing the apparent hangs, it was the network. How bout that? The entry in dba_audit_trail even included the host IP_Address, proving that the users victimized by a vpn timeout policy were in a different network range. You don't know what kind of info you're missing - until you run it for a few days and troll it. Its like "law and order" without needing a subpoena. :D Pd Do you Yahoo!? The New Yahoo! Shopping - with improved product search
RE: Unintentional Humor
Dan, It was never my intention to make you or anyone else feel bad. And I certainly feel the same frustrations that you felt when looking at the Web site to begin with. I agree completely that the page in question showed a significant lack of attention to the information presented and that the overall impression is one of carelessness on the part of those who put the piece together. No argument here, trust me. I guess what I was saying here was that ultimately, the author, is the one who suffers in such a circumstance. And I was trying to give him the benefit of the doubt by saying that perhaps he wasn’t even aware that the advertisement had been put together yet, let alone placed in full visible view of everyone. When I found out more about all parties involved with this particular book (information I was admittedly ignorant about when I wrote my original response – lucky for me someone emailed me personally and set me straight), then I understood better that this never really should have taken place to begin with. And, of course, I knew that *ideally* this never should have taken place. But, I was told that in this particular instance, it *really* should never have taken place. Trust me, your point and everyone else’s is well taken. I respect the opinions and viewpoints of the folks here at Oracle-L. It’s why I subscribe. Melanie -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Fink Sent: Monday, October 06, 2003 5:15 PM To: Multiple recipients of list ORACLE-L Subject: Re: Unintentional Humor Melanie, There is truth in what you said originally. As soon as I read your original email, I felt bad. I appreciate your willingness to stand up and disagree. Some of us take issue, rightly so, with the content of the page, but we (me included!) should do a better job of critiquing the page in a more constructive manner. While we did not explicitly paint the author with the same brush that we used to go after the web page, the implications are pretty clear. Yes, the page contains many egregious errors and has probably been written by someone in marketing without a clue as to what Oracle is. The text makes no sense in several places and the program listing is just plain wrong. I don't mean to justify what we did, but we all get frustrated with the bad information or lazy people out there who don't take the time to look at something critically or even RTFM. Cary's earlier story about the drill sergeant hit home with many of us. As a result, we have short fuses for this kind of 'crap'. And it is not just on the list, but it is with many of our colleagues and coworkers...even managers. It fits well in the 'professional development' category of interpersonal skills. I'll shut up now... Dan Melanie Caffrey wrote: Well all, I've been corrected in my statements below, and I am always one to own up to my mistakes (or misstatements). I guess what I should have said is that in SOME cases, there is not always a clear communication between all parties involved when an advertisement is made. In this case, I have been informed otherwise. So, what initially looked to me like innocent, albeit egregious, mistakes in a book advertisement, were apparently just plain egregious. So, you are all correct. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Melanie Caffrey Sent:Monday, October 06, 20033:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: Unintentional Humor Alright.Now, I feel I have to defend this poor guy.For if I don't, who will? First of all, the book title lists the covered items as Hidden programs - COMMA - export/import - COMMA And so forth. VERY different from something like Hidden programs:export/import, SQL*Loader, etc. Secondly, I'm sure the author didn't mock up his own press page. These things are typically created by some "editor" of sorts at the accompanying publisher. And, if any of you have ever published a book before, you should be intimately familiar with the fact that, nine times out of ten, the people writing these press releases *really* don't know what they're writing about. A few catch phrases thrown around here and there and it's assumed to be good enough. What somebody should have told Dave Moore is "NEVER let any press mockups or releases go out without you having gone over them with a fine-toothed comb". Otherwise, what just took place in this thread is bound to happen .. Now I can't speak to the efficacy or accuracy of his book.All I'm saying is take Web pages, particularly Web pages on publisher Web sites that are touting books they want to sell, with a grain of salt.And don't dump on the poor author until you've read his book ... -Original Message-
RE: Unintentional Humor
Well all, I’ve been corrected in my statements below, and I am always one to own up to my mistakes (or misstatements). I guess what I should have said is that in SOME cases, there is not always a clear communication between all parties involved when an advertisement is made. In this case, I have been informed otherwise. So, what initially looked to me like innocent, albeit egregious, mistakes in a book advertisement, were apparently just plain egregious. So, you are all correct. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Melanie Caffrey Sent: Monday, October 06, 2003 3:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: Unintentional Humor Alright. Now, I feel I have to defend this poor guy. For if I don’t, who will? First of all, the book title lists the covered items as Hidden programs – COMMA – export/import – COMMA And so forth. VERY different from something like Hidden programs: export/import, SQL*Loader, etc. Secondly, I’m sure the author didn’t mock up his own press page. These things are typically created by some “editor” of sorts at the accompanying publisher. And, if any of you have ever published a book before, you should be intimately familiar with the fact that, nine times out of ten, the people writing these press releases *really* don’t know what they’re writing about. A few catch phrases thrown around here and there and it’s assumed to be good enough. What somebody should have told Dave Moore is “NEVER let any press mockups or releases go out without you having gone over them with a fine-toothed comb”. Otherwise, what just took place in this thread is bound to happen … Now I can’t speak to the efficacy or accuracy of his book. All I’m saying is take Web pages, particularly Web pages on publisher Web sites that are touting books they want to sell, with a grain of salt. And don’t dump on the poor author until you’ve read his book … -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephane Paquette Sent: Monday, October 06, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: Unintentional Humor You mean the hidden $ORACLE_HOME/bin directory Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Daniel Fink Sent: Monday, October 06, 2003 3:04 PM To: Multiple recipients of list ORACLE-L Subject: Re: Unintentional Humor I see what you mean. Too funny! Hmm...I guess I've been wrong all these years. And all that time I wasted reading the official documentation on such "undocumented" and "hidden" programs like export/import, sql*loader, tkprof... [EMAIL PROTECTED] wrote: OK, well I thought it was funny. Doing a google search on some Oracle stuff, I found the following page. http://www.dba-oracle.com/bp/bp_book6_utils.htm Scroll down a bit? Do you see the funny part? Jared
RE: Unintentional Humor
Alright. Now, I feel I have to defend this poor guy. For if I don’t, who will? First of all, the book title lists the covered items as Hidden programs – COMMA – export/import – COMMA And so forth. VERY different from something like Hidden programs: export/import, SQL*Loader, etc. Secondly, I’m sure the author didn’t mock up his own press page. These things are typically created by some “editor” of sorts at the accompanying publisher. And, if any of you have ever published a book before, you should be intimately familiar with the fact that, nine times out of ten, the people writing these press releases *really* don’t know what they’re writing about. A few catch phrases thrown around here and there and it’s assumed to be good enough. What somebody should have told Dave Moore is “NEVER let any press mockups or releases go out without you having gone over them with a fine-toothed comb”. Otherwise, what just took place in this thread is bound to happen … Now I can’t speak to the efficacy or accuracy of his book. All I’m saying is take Web pages, particularly Web pages on publisher Web sites that are touting books they want to sell, with a grain of salt. And don’t dump on the poor author until you’ve read his book … -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephane Paquette Sent: Monday, October 06, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: Unintentional Humor You mean the hidden $ORACLE_HOME/bin directory Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Daniel Fink Sent: Monday, October 06, 2003 3:04 PM To: Multiple recipients of list ORACLE-L Subject: Re: Unintentional Humor I see what you mean. Too funny! Hmm...I guess I've been wrong all these years. And all that time I wasted reading the official documentation on such "undocumented" and "hidden" programs like export/import, sql*loader, tkprof... [EMAIL PROTECTED] wrote: OK, well I thought it was funny. Doing a google search on some Oracle stuff, I found the following page. http://www.dba-oracle.com/bp/bp_book6_utils.htm Scroll down a bit? Do you see the funny part? Jared
RE: Sql query : select max timestamp value from table
Johann, Take the timestamp out of your group by. Cheers, Melanie *** Melanie Caffrey Proximo Consulting Services, Inc. [EMAIL PROTECTED] (212) 686-6004 Ext. 32 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Johan Muller Sent: Thursday, October 02, 2003 10:45 AM To: Multiple recipients of list ORACLE-L Subject: Sql query : select max timestamp value from table I have multiple timestamps values for single ip in a table, I need the max(timestamp) for each ip I select out. example: timestamp ip 2003-09-29 13:20:23 68.209.182.4 2003-09-29 13:20:44 68.209.182.4 2003-10-02 12:53:38 68.209.182.4 2003-10-02 12:35:06 68.75.94.158 2003-10-02 12:52:03 68.97.33.69 Thus select distinct ip, max(timestamp) from table group by ip, timestamp; returns every timestamp value per ip. Any ideas on how to get only the max(timestamp) for each ip?
RE: Last Call for RMOUG Training Days 2004
Uhhh Dan? The Website states that the deadline has been extended to Oct. 1st. Which is more correct? You or the Website? Just so I know to turn to a few people here and tell them to hurry up. Of course, I should probably just do that anyway. :-) -Original Message- Daniel Fink Sent: Monday, September 29, 2003 3:45 PM To: Multiple recipients of list ORACLE-L Today is the last day to submit an abstract for Rocky Mountain Oracle User Group Training Days 2004 in sunny and snowy Denver, Colorado. Last year, we had sessions from oracle-lers Cary, Anjo, Rachel, Tim as well as Stephan Haisley, Gary Goodman, Kent Graziano, Dave Ensor, Craig Shallahamer and Kevin Loney. Don't forget to bring your skis and sunscreen! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 10g: SQL Plus
Nope. Sqlplusw is the little gui usually available off of your start -> programs window menu items. isqlplus is Web-based and invoked through a browser. For example, Invoking the following type of url will bring it up in your browser: http://your_server_name:your_port_number/isqlplus Note that you do need the Apache server installed and running in order to use this. However, when you install Oracle, unless you specify otherwise, this will happen automatically if you choose the default installation. And, actually, you only need to specify the port number (above) if you'd like to choose a port number other than the one (I believe it's still 7778 unless it's changed) that Oracle assigns by default. HTH, Melanie -Original Message- KENNETH JANUSZ Sent: Monday, September 22, 2003 11:00 PM To: Multiple recipients of list ORACLE-L Is sqlplusw the same as iSQL/Plus? Thanks, Ken - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, September 22, 2003 6:09 PM > They were supposed to get rid of sqlplusw > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, September 22, 2003 23:09 > > > > Hej Jay > > > > Yes it stil there :-) > > > > > > Jay Wade wrote: > > > > > Hello: > > > > > > Was watching Larry Ellison's key note and he mentioned that they still > > > have SQL Plus in 10g. > > > I heard rumor that it was removed. Since it seems as though some from > > > this list have seen it does it still have SQL Plus or has it been > > > removed? > > > > > > Thanks In Advance, > > > Jay > > > > > > _ > > > High-speed Internet access as low as $29.95/month (depending on the > > > local service providers in your area). Click here. > > > https://broadband.msn.com > > > > > > > -- > > Peter Gram, Miracle A/S > > Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 > > mail : [EMAIL PROTECTED] - http://MiracleAS.dk > > > > Upcoming events: > > DatabaseForum 2003, Lalandia 2-4 October > > Visit http://miracleas.dk/events/DBF2003/invitation.html > > > > Miracle Master Class with Tom Kyte, 12-14 January 2004 > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Peter Gram > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is Cary's new book shipping now?
You know, Dwayne, there's no reason you shouldn't purchase all three. :-) The two Kyte books are not the same. You'll obtain excellent knowledge from all of them. Cheers, Melanie -Original Message- Dwayne Cox Sent: Wednesday, September 17, 2003 1:30 PM To: Multiple recipients of list ORACLE-L Why oh why did I not wait? I tracked down and purchased Tom's previous Expert One-on-One Oracle a couple months ago. I even checked to make sure a new edition was not forthcoming. *sigh* Did not check enough I guess. I'll have to compare the two to see if I want to 'upgrade'. I am waiting, impatiently, for Cary's book (preordered on Amazon). I just attended the Oracle9i Performance Tuning Class and am quite pumped about tuning. Especially since we have recently experienced some performance issues. Dwayne -- Dwayne Cox Info Tech, Inc. Gainesville, FL Cary Millsap wrote: > Tom's book, by the way, is spectacular. > > > > Cary Millsap > Hotsos Enterprises, Ltd. > http://www.hotsos.com > > Upcoming events: > - Hotsos Clinic <http://www.hotsos.com/training/clinic101> 101 in > Sydney > - Hotsos Symposium 2004 <http://www.hotsos.com/events/symposium/2004> > March 7-10 Dallas > - Visit www.hotsos.com for schedule details... > > -Original Message- > Jamadagni, Rajendra > Sent: Tuesday, September 16, 2003 11:40 AM > To: Multiple recipients of list ORACLE-L > > > > Thanks Cary I have your new book and Tom's new book on order .. > > > > Raj > > > > Rajendra dot Jamadagni at nospamespn dot com > All Views expressed in this email are strictly personal. > QOTD: Any clod can have facts, having an opinion is an art ! > > -Original Message- > Sent: Tuesday, September 16, 2003 12:05 PM > To: Multiple recipients of list ORACLE-L > > Raj, > > > > The book will be in the O'Reilly warehouses tomorrow (9/17), presumably > outbound to stores on the same or next day. I'd expect preorders to > arrive at customers' homes on or near this weekend. > > > Cary Millsap > > > > -- Dwayne Cox Corporate DBA Info Tech, Inc. 5700 SW 34th Street, Suite 1235 Gainesville, FL 32608 email: [EMAIL PROTECTED] phone: 352.381.4521 fax: 352.381. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ref_cursor's
Suzy, Personally, I'm a huge fan of ref cursors, and with many current releases of Oracle, ref cursors are the only way to return arrays to a client program. Are you returning arrays or just single variables to your C program? Performance sort of depends on clarifying this point first. If he's generating multiple OUT parameters, it would be much easier for him to use REF cursors. With our applications, I use them all the time and I would be more than happy to send you some code examples, if you'd like. Best regards, Melanie -Original Message- Vordos, Suzy Sent: Wednesday, September 17, 2003 4:35 PM To: Multiple recipients of list ORACLE-L I've RTFM'd looking for advantages/disadvantages of ref_cursors vs. out parameters. We have a developer who insists on using out parameters instead of ref_cursors. He hasn't coded PL/SQL since Oracle7. The application program that calls the PL/SQL package is written in C#. I'm at a loss for words. I'm not a PL/SQL expert, but it seems that ref_cursors have the advantage of not needing to define PL/SQL variables, and that it's easier to pass a result set back to the calling program. I also assume that ref_cursors have better performance. Can someone clarify this? Maybe I'm confused. Thanks, Suzy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vordos, Suzy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is Cary's new book shipping now?
n Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Oracle Press OCP exam guide frustrations
> > For those that have completed the OCP exam, is this what I am to expect? > > Does anyone know of any other resources I might be able to use? How are > the OCP exam guides published by Sybex? > > Any help would be greatly appreciated. > > Regards, > Craig. > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Craig Munday > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Rajesh Dayal > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Munday INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Express yourself with MSN Messenger 6.0 -- download now! http://www.msnmessenger-download.com/tracking/reach_general -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Cal
RE: RE: Oracle Press OCP exam guide frustrations
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Craig Munday > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > > San Diego, California-- Mailing list and web hosting > services > > > > - > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Rajesh Dayal > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > > San Diego, California-- Mailing list and web hosting > services > > > > - > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: <[EMAIL PROTECTED] > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Melanie Caffrey > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ryan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Melanie Caffrey > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Oracle Press OCP exam guide frustrations
u want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Melanie Caffrey > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Oracle Press OCP exam guide frustrations
One may as well get used to putting forth some extra expenditure when getting certified now. The publisher, Coriolis, went under. And now Oracle is requiring that you complete at least one of their prep courses (irrespective of whether you believe you need it or not) in order to become OCP-certified for 9i. -Original Message- [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 11:00 AM To: Multiple recipients of list ORACLE-L they are not outstanding. they are ok? They are also expensive. I have found the Coriolis books to be better than the Osborne books in quality. They dont have 9i ones. you can get the 8.0/8i ones for $9/each at maryland-merchant.com Im using those myself, then the docs. I didnt like the osborne books. > > From: "Rajesh Dayal" <[EMAIL PROTECTED]> > Date: 2003/09/16 Tue AM 10:09:24 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Oracle Press OCP exam guide frustrations > > Try out self study materials from http://www.selftestsoftware.com they are simply outstanding. > I have always found them helpful for all my exams. But at same time I never totally rely on them, > I first complete my ground work with standard syllabus (available on Oracle OCP site) and Oracle > Documentation then only I Open them ;-). > > HTH, > > Rajesh Dayal > Senior Oracle DBA (OCP 8,8i,9i) > International Information Technology Company LLC > > > -Original Message- > Sent: Tuesday, September 16, 2003 2:14 PM > To: Multiple recipients of list ORACLE-L > Subject: Fwd: Oracle Press OCP exam guide frustrations > > All, > > I just purchased a Oracle9i Fundamentals I exam guide published by Oracle > Press and am very disappointed with the quality of the publication. There > seems to be quite a few mistakes, misleading sentences and typos (not in > the Errata) which is very frustrating. > > Also, there is a question in the "Managing Tablespaces and Datafiles" > chapter that replies on the order of the multiple-choices, however the quiz > software randomises the choices so the question no longer makes sense - and > is impossible to answer as presented. > > For those that have completed the OCP exam, is this what I am to expect? > > Does anyone know of any other resources I might be able to use? How are > the OCP exam guides published by Sybex? > > Any help would be greatly appreciated. > > Regards, > Craig. > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Craig Munday > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Rajesh Dayal > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosti