Arithmetics
Hi list In PL/SQL, 174413 - 169281.6 (as FLOAT) results in 5131.4 as it should. In Perl, it results in 5131.399. In C++ (GCC on both Linux and MS Windows) it results in 5131.4. I find it pretty irritating that perl doesn't handle that correctly. I know, it's always a problem with floating point arithmetics, but how is it, that perl already says good bye to accurate results while PL/SQL and C both still give the correct result ? Is there any work around or something I have to consider when doing floating point arithmetics in Perl ? I need to have accurate values without rounding them for statistic calculations. TIA, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
AW: Happy Thanksgiving
Try the real manly stuff: Go running in the morning BEFORE breakfast at a low heart rate to burn fat. That works for everybody, even for Double-Bodied-Admins ;). Stefan -Ursprüngliche Nachricht- Von: Mladen Gogala [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 26. November 2003 17:44 An: Multiple recipients of list ORACLE-L Betreff: Re: Happy Thanksgiving Happy Thanksgiving to everybody. As for maintaining the weight, that precisely is the problem. I am unable to lose weight, not to maintain it. There quite an abundance of me, I want to shrink. Does anyone know if oracle 10g has any options for shrinking DBAs? Something like ALTER DBA SET WEIGHT=240LBS BANK_ACCOUNT=10M DROP POINTS FROM DRIVERS LICENSE; On 11/26/2003 10:49:43 AM, "Jamadagni, Rajendra" wrote: > Come to think of it, out fitness center has a special program ... it runs for 8 weeks and the aim is "maintaining the weight" ... no points for loosing any. bi-weekly weight watch and help to maintain weight is included. > > Happy Thanksgiving everyone ... > 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- > [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 26, 2003 10:34 AM > To: Multiple recipients of list ORACLE-L > > > Guys, > > Happy Thanksgiving to everyone. May your bellies be full but your waistline not expand, may you enjoy the time with your family and friends and avoid any of the other drama > > Thanks so much to everyone for their help and camaraderie. > > Just enjoy yaself! > -- > > > ** > 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. > **5 > -- > 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). > 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: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
AW: Experiences with Oracle and MS .Net data providers
I have to remember that as a good example for my wife's German classes. Stefan -Ursprungliche Nachricht- Von: Mladen Gogala [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 25. November 2003 16:20 An: Multiple recipients of list ORACLE-L Betreff: Re: Experiences with Oracle and MS .Net data providers Actually, it was a deliberate word play, just to remind you that not all MS projects are successful. They were talking about porting .NOT to Unix, but gave up. It's a MS-only world. On 11/25/2003 09:54:51 AM, Stefan Jahnke wrote: > Hi Mladen > > Nice metaphor. Did you intentionally use zum Donnerwetter as a little word > play on MS's "Hailstorm" - project (R.I.P.) ?. That get's pretty close to > obscene language, too. I guess I was actually gullible enough to believe > that .NET might be comparable to the Java world. Maybe not ;). Or maybe I > have to keep playing with MONO. > > Stefan > > > -Ursprungliche Nachricht- > Von: Mladen Gogala [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 25. November 2003 15:39 > An: Multiple recipients of list ORACLE-L > Betreff: Re: Experiences with Oracle and MS .Net data providers > > > > On 11/25/2003 07:39:30 AM, Stefan Jahnke wrote: > > Hi > > > >How is it, that data > > providers can be in incompatible in .NET ? > > > > Stefan > > Stefan, lets talk about obscene language. As you know, obscene > language is not always the same. The phrase "zum Donnerwetter" can > and will be understood as swearing, despite the fact that it's utterly > incomprehensible to me why would someone use bad weather as a swearing > phrase. > Two obscene words in Redmond, WA are "compatible" and "standards", which > are used much in the same way as the phrase "zum Donnerwetter" is > used in German language. You should know that .NET is incompatibility > elevated to the level of art. Did you really expect MS product to be > compatible withe anything else except with another MS product? MS products > are not compatible, they are .NET compatible or contemptible, for short. > Your question should be rephrased as: how can anybody realistically expect > .NET provider to be compatible with a non-MS database like Oracle? > > 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: Stefan Jahnke > 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 l
AW: Experiences with Oracle and MS .Net data providers
Hi Mladen Nice metaphor. Did you intentionally use zum Donnerwetter as a little word play on MS's "Hailstorm" - project (R.I.P.) ?. That get's pretty close to obscene language, too. I guess I was actually gullible enough to believe that .NET might be comparable to the Java world. Maybe not ;). Or maybe I have to keep playing with MONO. Stefan -Ursprungliche Nachricht- Von: Mladen Gogala [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 25. November 2003 15:39 An: Multiple recipients of list ORACLE-L Betreff: Re: Experiences with Oracle and MS .Net data providers On 11/25/2003 07:39:30 AM, Stefan Jahnke wrote: > Hi > >How is it, that data > providers can be in incompatible in .NET ? > > Stefan Stefan, lets talk about obscene language. As you know, obscene language is not always the same. The phrase "zum Donnerwetter" can and will be understood as swearing, despite the fact that it's utterly incomprehensible to me why would someone use bad weather as a swearing phrase. Two obscene words in Redmond, WA are "compatible" and "standards", which are used much in the same way as the phrase "zum Donnerwetter" is used in German language. You should know that .NET is incompatibility elevated to the level of art. Did you really expect MS product to be compatible withe anything else except with another MS product? MS products are not compatible, they are .NET compatible or contemptible, for short. Your question should be rephrased as: how can anybody realistically expect .NET provider to be compatible with a non-MS database like Oracle? 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: Stefan Jahnke 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).
AW: Experiences with Oracle and MS .Net data providers
Hi Some coworkers implemented an application using C# and the MS .NET provider for Oracle (9.0.1 DB). One thing I can remember: Mapping C#'s float datatype to Oracle FLOAT (or NUMBER(...)) somehow didn't work that great. Another thing was that they could not use transaction processing via the underlying COM+ components correctly. Something with the threading went wrong. It did work though for SQL*Server, so they assumed the MS provider for Oracle screwed up. Switching to the Oracle provider wasn't an option anymore either, since the interfaces weren't 100% compatible. I don't know about that since I don't know .NET, but I was surprised that that could be the case. I thought it would work like in Java, where the JDBC driver supplier "just" implements a certain set of interfaces. If you don't downcast an ResultSet into for example an OracleResultSet and stick to the methods the standard inteface provides, ... no probs. How is it, that data providers can be in incompatible in .NET ? Stefan -Ursprungliche Nachricht- Von: Grant Allen [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 25. November 2003 06:59 An: Multiple recipients of list ORACLE-L Betreff: Experiences with Oracle and MS .Net data providers Hi all, Would really like to hear any feedback regarding anyone comparing these two .Net data providers (or even some of the others out there - Datadirect, etc.). We're at decision making time, and things like the differences in calling stored procs, returning Ref Cursors, are starting to mean we need to pick one. My gut says go with the Oracle one (keep the technology stack based on the one vendor), but they kludge too many things. (just like in ADO, where they ignored the standard for stored proc calling). Anyway, any comments about your use, likes and dislikes of either would be much appreciated. Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen 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: Stefan Jahnke 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).
AW: Any articles/books that take relational theory and make it
e reader is hereby > notified that > any dissemination, distribution or copying of this e-mail is > prohibited. If > you have received this e-mail in error, please notify the sender by > replying > to this message and delete this e-mail immediately. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Michael Milligan > 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!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel 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: DENNIS WILLIAMS 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: Stefan Jahnke 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).
AW: LF and CR (chr(10)||chr(13)) problem
To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kitty Luo 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: Stefan Jahnke 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).
AW: Geometric mean
Hi I'm not aware of any "out-of-the-box" Oracle solution either (like STDDEV or AVG). Looks like one has to roll ones own statistical functions when it comes to calculating things like modus or median. Is anybody aware of an extension, maybe in form of an old cartridge or a pl/sql library to handle that stuff ? The problem is, that for instance STDDEV is a "normal" SQL function, if you roll your own to calculate other things, you end up having to call a pl/sql function from sql, which isn't really a performance boost. Stefan -UrsprÃngliche Nachricht- Von: Robson, Peter [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 14. November 2003 13:20 An: Multiple recipients of list ORACLE-L Betreff: RE: Geometric mean Thanks for that, Stephane - hmmm, I'm still working on it... will post the successful script when I get it... peter edinburgh > -Original Message- > From: Stephane Faroult [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 13, 2003 5:24 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Geometric mean > > > Peter, > >I am a mere shadow of what I used to be in mathematics, > but wouldn't > POWER(10,AVG(LOG(10,))) > > do it? > > SF > > >- --- Original Message --- - > >From: "Robson, Peter" <[EMAIL PROTECTED]> > >To: Multiple recipients of list ORACLE-L > ><[EMAIL PROTECTED]> > >Sent: Thu, 13 Nov 2003 08:49:24 > > > > > >Has anyone any code (SQL, PL/SQL) that will permit > >the calculation of the > >geometric mean of 'n' values? > > > >appreciated... > > > >peter > >edinburgh > > > > > >ps - yes I know Perl will do it, but that is not > >the answer... > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephane Faroult > 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, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
AW: Looking for help - sql*loader and truncate
Hi Looks like I have to try that one, since truncate should be reasonably faster then replace. Thanks, Stefan -Ursprüngliche Nachricht- Von: Jacques Kilchoer [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 13. November 2003 20:54 An: Multiple recipients of list ORACLE-L Betreff: RE: Looking for help - sql*loader and truncate In that case you could create a procedure owned by the data owner that does the truncate, grant execute on the procedure to the data loader, and use SQL*Plus to call the truncate procedure before the SQL*load starts. > -Original Message- > Stefan Jahnke > > .. and there is another scenario to use replace. As you > mention it, that's > what we do, too ;). The package owner (who owns the > transformation packages) > also does the load, so we use replace here, since I didn't feel like > granting DROP ... to the package user or use the data owner > to do the load. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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: Stefan Jahnke 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).
AW: End of communication channel
Hi Dennis According to Metalink, an ora-03113 on an already established connection points to a terminated Oracle executable. This is not the case, Oracle is still up and running. Unfortunately, it's windows, so I still have to figure out how to see wether the user process has been terminated (should be a thread running within the same process on win ?!). Stefan -Ursprüngliche Nachricht- Von: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 13. November 2003 18:00 An: Multiple recipients of list ORACLE-L Betreff: RE: End of communication channel Stefan - I'm assuming this is the notorious ORA-3113 error? (the text is end of channel) You might start with Note 1020463.3 on Metalink. It covers the obvious stuff that should be checked out before digging deeper. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 13, 2003 5:19 AM To: Multiple recipients of list ORACLE-L Hi list I'm looking for further hints on where to look for problems which may lead to an "end of communication channel" error. Any input (especially networking or operating system problems) appreciated. The server runs 9.0.1.0.1 on Win2k. Not my box, a coworker has trouble with the network/sys admins stating that it can't be a network/system problem. I highly doubt that, since the Oracle service and the listener are both constantly available. No memory problems either. It's just that in the middle of the session, the connection goes down the drain. Any ideas ? TIA, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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: DENNIS WILLIAMS 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: Stefan Jahnke 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).
AW: End of communication channel
Hi According to that ... I guess their routers are fired by coal, like those old steam engines ;). No, seriously, I don't know much about their equipment. It's supposedly "modern equipment mixed with poor skills" ;). I was suggesting to look for dropped packages or problems with MTU size, since it's Win2k to Unix communication. Stefan -Ursprüngliche Nachricht- Von: Barbara Baker [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 13. November 2003 17:24 An: Multiple recipients of list ORACLE-L Betreff: Re: End of communication channel Did you forget who you're talking to? We're the site that still uses VMS and Cobol. We won't see modern routers here for decades. --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > Your router has blades? Is it propeller driven? I > thought that > all modern routers have jet engines by now. > > On 11/13/2003 09:54:25 AM, Barbara Baker wrote: > > Hi, Stefan. > > We had a problem very similar to this one. Fought > it > > for several months. > > > > The final solution: a bad blade in a router. > > > > Good luck. > > Barb > > > > --- Stefan Jahnke <[EMAIL PROTECTED]> wrote: > > > Hi list > > > > > > I'm looking for further hints on where to look > for > > > problems which may lead > > > to an "end of communication channel" error. > > > Any input (especially networking or operating > system > > > problems) appreciated. > > > The server runs 9.0.1.0.1 on Win2k. Not my box, > a > > > coworker has trouble with > > > the network/sys admins stating that it can't be > a > > > network/system problem. I > > > highly doubt that, since the Oracle service and > the > > > listener are both > > > constantly available. No memory problems either. > > > It's just that in the > > > middle of the session, the connection goes down > the > > > drain. > > > > > > Any ideas ? > > > > > > TIA, > > > Stefan > > > > > > > > > > > > > > > -- > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.net > > > -- > > > Author: Stefan Jahnke > > > 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: Barbara Baker > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > > San Diego, California-- Mailing list and > web hosting services > > > - > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like subscribing). > > > > Mladen Gogala > Oracle DBA > > > > 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
AW: End of communication channel
Hi I was thinking in that direction (memory usage, core dumps etc.), but it doesn't seem to be that. It's also not able to establish a relationship like: "If I execute thing A, error B occurs.". Stefan -Ursprüngliche Nachricht- Von: Wartiak Rastislav [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 13. November 2003 16:44 An: Multiple recipients of list ORACLE-L Betreff: RE: End of communication channel what is he doing? eg. when i start endless recursion in pl/sql, serving oracle process dies and end of comm channel occurs. you can check what happens with his process. can you see any core dumps? rw > Hi list > > I'm looking for further hints on where to look for problems > which may lead > to an "end of communication channel" error. > Any input (especially networking or operating system > problems) appreciated. > The server runs 9.0.1.0.1 on Win2k. Not my box, a coworker > has trouble with > the network/sys admins stating that it can't be a > network/system problem. I > highly doubt that, since the Oracle service and the listener are both > constantly available. No memory problems either. It's just that in the > middle of the session, the connection goes down the drain. > > Any ideas ? > > TIA, > Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wartiak Rastislav 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: Stefan Jahnke 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).
End of communication channel
Hi list I'm looking for further hints on where to look for problems which may lead to an "end of communication channel" error. Any input (especially networking or operating system problems) appreciated. The server runs 9.0.1.0.1 on Win2k. Not my box, a coworker has trouble with the network/sys admins stating that it can't be a network/system problem. I highly doubt that, since the Oracle service and the listener are both constantly available. No memory problems either. It's just that in the middle of the session, the connection goes down the drain. Any ideas ? TIA, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
AW: Looking for help.
> loading. > Will > > sqlldr remove the entires in the staging table first prior to > loading? > > 2. There are no changes in the stored procedures, how / why sqlldr > would > > invalidate the sql statement in the stored procedures? > > 3. The error ORA-04031 in this case, is it due to shared memory > > fragmentation? I suspect that the culprint is invalidations. How do > > invalidations cause shared memory fragmentation? > > > > I would appreciate if you can send me some pointers or suggestions. > > > > Thanks, > > KamYee > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Jonathan Gennick > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting > services > > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like > subscribing). > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Stefan Jahnke > > 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: Yechiel Adar > 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: 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: Stefan Jahnke 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).
AW: How do you generate primary keys?
Hi Looks like it's time to read some fine manuals again ;). So in a scenario like this: a) INSERT ... RETURN without the PK is done from Java b) BEFORE INSERT TRIGGER adds the PK, then does the actual insert. c) PK is returned to Java context ? .. c) works ? I'm not sure about that. Figured I just ask, before I actually go ahead and try it out. Stefan -Ursprüngliche Nachricht- Von: Igor Neyman [mailto:[EMAIL PROTECTED] Gesendet: Montag, 10. November 2003 18:54 An: Multiple recipients of list ORACLE-L Betreff: RE: How do you generate primary keys? True, Just in this case "insert" was a point of discussion. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Jamadagni, Rajendra Sent: Monday, November 10, 2003 11:34 AM To: Multiple recipients of list ORACLE-L .. and for updates,delets as well ... 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: Monday, November 10, 2003 11:24 AM To: Multiple recipients of list ORACLE-L Oracle has "RETURNING" clause for insert. Igor Neyman, OCP DBA [EMAIL PROTECTED] ** 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. **5 -- 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: 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: Stefan Jahnke 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).
AW: Looking for help.
err, should be Win2k, even though it feels like Win0.5k sometimes ;).
Stefan
-Ursprüngliche Nachricht-
Von: Nelson, Allan [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 12. November 2003 14:49
An: Multiple recipients of list ORACLE-L
Betreff: RE: Looking for help.
Windows 3000?
-Original Message-
Sent: Wednesday, November 12, 2003 7:44 AM
To: Multiple recipients of list ORACLE-L
Hi
We do something similiar, but instead of deleting the tables beforehand, I
just use the SQL*LOADER REPLACE option. No such problems as described in the
original eMail occured so far. The platform is Oracle 9.2.0.3 on Win3k.
Regards,
Stefan
-Ursprüngliche Nachricht-
Von: Jonathan Gennick [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 12. November 2003 14:34
An: Multiple recipients of list ORACLE-L
Betreff: Fwd: Looking for help.
I don't usually forward my reader email to the list, but the question below
strikes me as rather interesting. In this case, SQL*Loader appears to be
causing all SQL statements that refer to the table being loaded to be
invalidated. Is this normal behavior? Does anyone know why it might be the
case?
--
Best regards,
Jonathan Gennick --- Brighten the corner where you are http://Gennick.com *
906.387.1698 * mailto:[EMAIL PROTECTED]
Join the Oracle-article list and receive one
article on Oracle technologies per month by
email. To join, visit
http://four.pairlist.net/mailman/listinfo/oracle-article,
or send email to [EMAIL PROTECTED] and
include the word "subscribe" in either the subject or body.
Wednesday, November 12, 2003, 1:07:41 AM,
[EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
Hi Jonathan,
I was unable to find the answers from your book "SQL*Loader: The Definitive
Guide" and the web. I am running out of sources. I hope you can help me with
the following questions.
We are using Oracle 9i sqlldr, direct path to load data from external files
into staging tables. After data is loaded, we invoked stored procedures to
transform data and move them to the target tables. The steps are: 1. delete
all entries from 20 staging tables 2. invoke "sqlldr userid=dbimpl/dbimpl
control= direct=true" to load data to all 20 staging tables 3.
invoke stored procedures to transform data from the staging tables to the
final tables. Currently these stored procedures are standalone. 4. invoke
stored procedures to remove out-of-date entries from the final tables.
I monitor invalidations column in v$sqlarea. Every time
after sqlldr is invoked for data loading (step 2), all the
sql statements that reference the staging tables are invalidated, including
"delete from " sql statement. I setup a test and used a java
program to loop steps 1-4 every ~2 minutes. There were no other activities
in the database except data loading and transformation. After a couple days,
I got the following error: ORA-04031: unable to allocate 4212 bytes of
shared memory ("shared pool","unknown object","sga heap(1,0)","stat array
mem")
The questions are:
1. Do we need to delete entries in the staging table prior to loading. Will
sqlldr remove the entires in the staging table first prior to loading? 2.
There are no changes in the stored procedures, how / why sqlldr would
invalidate the sql statement in the stored procedures? 3. The error
ORA-04031 in this case, is it due to shared memory fragmentation? I suspect
that the culprint is invalidations. How do invalidations cause shared memory
fragmentation?
I would appreciate if you can send me some pointers or suggestions.
Thanks,
KamYee
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jonathan Gennick
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from). You may also send the HELP
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stefan Jahnke
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).
AW: Looking for help.
Ok. That's of course true, but I guess it depends on the scenario. With the
truncate option, there is no chance to roll back the activity. If you use
direct path load, I guess it makes more sense to opt for truncate.
Stefan
-Ursprüngliche Nachricht-
Von: Yechiel Adar [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 12. November 2003 18:24
An: Multiple recipients of list ORACLE-L
Betreff: Re: Looking for help.
There are two options to replace all data in the table: REPLACE and TRUNCATE
which are equivalent to truncate and delete sql statements. If you have
staging tables without RI or triggers then use truncate. Using delete just
takes a lot longer and use a lot more resources.
We use TRUNCATE almost exclusively.
Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, November 12, 2003 3:44 PM
> Hi
>
> We do something similiar, but instead of deleting the tables beforehand, I
> just use the SQL*LOADER REPLACE option. No such problems as described in
the
> original eMail occured so far. The platform is Oracle 9.2.0.3 on Win3k.
>
> Regards,
> Stefan
>
> -Ursprüngliche Nachricht-
> Von: Jonathan Gennick [mailto:[EMAIL PROTECTED]
> Gesendet: Mittwoch, 12. November 2003 14:34
> An: Multiple recipients of list ORACLE-L
> Betreff: Fwd: Looking for help.
>
>
> I don't usually forward my reader email to the list, but the
> question below strikes me as rather interesting. In this
> case, SQL*Loader appears to be causing all SQL statements
> that refer to the table being loaded to be invalidated. Is
> this normal behavior? Does anyone know why it might be the
> case?
>
> --
> Best regards,
>
> Jonathan Gennick --- Brighten the corner where you are
> http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
>
> Join the Oracle-article list and receive one
> article on Oracle technologies per month by
> email. To join, visit
> http://four.pairlist.net/mailman/listinfo/oracle-article,
> or send email to [EMAIL PROTECTED] and
> include the word "subscribe" in either the subject or body.
>
> Wednesday, November 12, 2003, 1:07:41 AM,
> [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
> Hi Jonathan,
>
> I was unable to find the answers from your book "SQL*Loader: The
Definitive
> Guide" and the web. I am running out of sources. I hope you can help me
with
> the following questions.
>
> We are using Oracle 9i sqlldr, direct path to load data from external
files
> into
> staging tables. After data is loaded, we invoked stored procedures to
> transform data and move them to the target tables. The steps are:
> 1. delete all entries from 20 staging tables
> 2. invoke "sqlldr userid=dbimpl/dbimpl control= direct=true"
to
> load data to all 20 staging tables
> 3. invoke stored procedures to transform data from the staging tables to
the
> final tables. Currently these stored procedures are standalone.
> 4. invoke stored procedures to remove out-of-date entries from the final
> tables.
>
> I monitor invalidations column in v$sqlarea. Every time
> after sqlldr is invoked for data loading (step 2), all the
> sql statements that reference the staging tables are
> invalidated, including "delete from " sql
> statement. I setup a test and used a java program to loop
> steps 1-4 every ~2 minutes. There were no other activities
> in the database except data loading and transformation.
> After a couple days, I got the following error: ORA-04031:
> unable to allocate 4212 bytes of shared memory ("shared
> pool","unknown object","sga heap(1,0)","stat array mem")
>
> The questions are:
> 1. Do we need to delete entries in the staging table prior to loading.
Will
> sqlldr remove the entires in the staging table first prior to loading?
> 2. There are no changes in the stored procedures, how / why sqlldr would
> invalidate the sql statement in the stored procedures?
> 3. The error ORA-04031 in this case, is it due to shared memory
> fragmentation? I suspect that the culprint is invalidations. How do
> invalidations cause shared memory fragmentation?
>
> I would appreciate if you can send me some pointers or suggestions.
>
> Thanks,
> KamYee
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jonathan Gennick
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note
AW: Looking for help.
Hi
We do something similiar, but instead of deleting the tables beforehand, I
just use the SQL*LOADER REPLACE option. No such problems as described in the
original eMail occured so far. The platform is Oracle 9.2.0.3 on Win3k.
Regards,
Stefan
-Ursprüngliche Nachricht-
Von: Jonathan Gennick [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 12. November 2003 14:34
An: Multiple recipients of list ORACLE-L
Betreff: Fwd: Looking for help.
I don't usually forward my reader email to the list, but the
question below strikes me as rather interesting. In this
case, SQL*Loader appears to be causing all SQL statements
that refer to the table being loaded to be invalidated. Is
this normal behavior? Does anyone know why it might be the
case?
--
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
Join the Oracle-article list and receive one
article on Oracle technologies per month by
email. To join, visit
http://four.pairlist.net/mailman/listinfo/oracle-article,
or send email to [EMAIL PROTECTED] and
include the word "subscribe" in either the subject or body.
Wednesday, November 12, 2003, 1:07:41 AM,
[EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
Hi Jonathan,
I was unable to find the answers from your book "SQL*Loader: The Definitive
Guide" and the web. I am running out of sources. I hope you can help me with
the following questions.
We are using Oracle 9i sqlldr, direct path to load data from external files
into
staging tables. After data is loaded, we invoked stored procedures to
transform data and move them to the target tables. The steps are:
1. delete all entries from 20 staging tables
2. invoke "sqlldr userid=dbimpl/dbimpl control= direct=true" to
load data to all 20 staging tables
3. invoke stored procedures to transform data from the staging tables to the
final tables. Currently these stored procedures are standalone.
4. invoke stored procedures to remove out-of-date entries from the final
tables.
I monitor invalidations column in v$sqlarea. Every time
after sqlldr is invoked for data loading (step 2), all the
sql statements that reference the staging tables are
invalidated, including "delete from " sql
statement. I setup a test and used a java program to loop
steps 1-4 every ~2 minutes. There were no other activities
in the database except data loading and transformation.
After a couple days, I got the following error: ORA-04031:
unable to allocate 4212 bytes of shared memory ("shared
pool","unknown object","sga heap(1,0)","stat array mem")
The questions are:
1. Do we need to delete entries in the staging table prior to loading. Will
sqlldr remove the entires in the staging table first prior to loading?
2. There are no changes in the stored procedures, how / why sqlldr would
invalidate the sql statement in the stored procedures?
3. The error ORA-04031 in this case, is it due to shared memory
fragmentation? I suspect that the culprint is invalidations. How do
invalidations cause shared memory fragmentation?
I would appreciate if you can send me some pointers or suggestions.
Thanks,
KamYee
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jonathan Gennick
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stefan Jahnke
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).
AW: How do you genrate primary keys?
L 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: Stefan Jahnke 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).
AW: Translations needed into Spanish, German, French, Mandarin, T
Hi Ferenc If it's simple words, just send me the list, I can give you a German translation which won't make your codes look too stupid (if I can figure out all the English stuff, that is ;). Stefan -Ursprüngliche Nachricht- Von: Ferenc Mantfeld [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 3. Oktober 2003 04:10 An: Multiple recipients of list ORACLE-L Betreff: Translations needed into Spanish, German, French, Mandarin, Thai Hi All I am looking for a bunch of messages, field names and labels to be translated into German, French, Spanish, Mandarin and Thai. There are about 150 values, and if you are experienced at this stuff (have developed software or codes specifically in any of the languages listed above), please email me privately. It is a quick once-off job that I am willing to pay for. Regards: Ferenc Mantfeld Dreaming costs you nothing. Not dreaming costs you everything. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ferenc Mantfeld 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: Stefan Jahnke 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).
Problems with 9.2.0.4
Hi list I'm encountering a problem where I think it might be related to patch set 9.2.0.4 (since it worked on 9.2.0.3): I load data with SQL*LOADER using the following control file: ** LOAD DATA INFILE 'c:\oracle\admin\\daten\neuessen\\import\mydata.txt' BADFILE 'c:\oracle\admin\\daten\neuessen\ctl\mydata.bad' DISCARDFILE 'c:\oracle\admin\\daten\neuessen\ctl\mydata.dsc' APPEND INTO TABLE schizo.stagingtable FIELDS TERMINATED BY ";" ( id SEQUENCE(MAX), fileid EXPRESSION "831", trialINTEGER EXTERNAL, response INTEGER EXTERNAL, type INTEGER EXTERNAL, correct INTEGER EXTERNAL, latency DECIMAL EXTERNAL ) ** The data looks like this (excerpt): ** 1;0;111;-1;0.000 2;0;111;-1;0.000 3;0;111;-1;0.000 4;4;112;0;0.655 5;0;111;-1;0.000 6;0;111;-1;0.000 7;0;111;-1;0.000 8;0;111;-1;0.000 9;4;113;0;0.476 10;0;111;-1;0.000 ** The SQL*LOADER is called like this: ** HOST c:\oracle\ora9\bin\sqlldr userid=system/mypwd@ control=c:\oracle\admin\\daten\neuessen\ctl\mydata.ctl log=c:\oracle\admin\\daten\neuessen\ctl\mydata.log ** My log file looks like this: ** SQL*Loader: Release 9.2.0.4.0 - Production on Tue Oct 7 09:49:46 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Control File: c:\oracle\admin\\daten\neuessen\ctl\mydata.ctl Data File: c:\oracle\admin\\daten\neuessen\\import\mydata.txt Bad File: c:\oracle\admin\\daten\neuessen\ctl\mydata.bad Discard File: c:\oracle\admin\\daten\neuessen\ctl\mydata.dsc (Allow all discards) Number to load: ALL Number to skip: 0 Errors allowed: 50 Continuation:none specified Path used: Direct Table SCHIZO.STAGINGTABLE, loaded from every logical record. Insert option in effect for this table: APPEND Column Name Position Len Term Encl Datatype -- -- - - IDSEQUENCE (MAX, 1) FILEIDEXPRESSION SQL string for column : "831" TRIAL FIRST * ; CHARACTER RESPONSE NEXT * ; CHARACTER TYPE NEXT * ; CHARACTER CORRECT NEXT * ; CHARACTER LATENCY NEXT * ; CHARACTER Record 1: Rejected - Error on table SCHIZO.STAGINGTABLE. ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist ... Record 51: Rejected - Error on table SCHIZO.STAGINGTABLE. ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist Specify SKIP=51 when continuing the load. MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run. Table SCHIZO.STAGINGTABLE: 0 Rows successfully loaded. 51 Rows not loaded due to data errors. 0 Rows not loaded because all WHEN clauses were failed. 0 Rows not loaded because all fields were null. Bind array size not used in direct path. Column array rows :5000 Stream buffer bytes: 256000 Read buffer bytes: 1048576 Total logical records skipped: 0 Total logical records rejected:51 Total logical records discarded:0 Total stream buffers loaded by SQL*Loader main thread: 51 Total stream buffers loaded by SQL*Loader load thread:0 Run began on Tue Oct 07 09:49:46 2003 Run ended on Tue Oct 07 09:49:47 2003 Elapsed time was: 00:00:01.40 CPU time was: 00:00:00.08 ** The funny thing is: If I run the loader directly as user "SCHIZO" or as "SYS" (O7_DICTIONARY_ACCESSIBILITY=TRUE), it works just fine. BTW: The problem is caused by the Expression, if I get rid of this, not loading any value into "FILEID", it works just fine. Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Aut
AW: 9.2.0.4 patch on linux
Hi
Jared
Did
you extend your pool sizes ?
Users who have JVM (Java enabled) or JVM and
XDB installed on their Oracle9i release 2 databases should ensure the
init.ora parameters SHARED_POOL_SIZE and
JAVA_POOL_SIZE are each 150 MB or more before running the
catpatch.sql upgrade script.
Did
you drop XMLCONCAT before patching ?
Drop the xmlconcat function by running the following commands:
C:\> sqlplus / NOLOG
SQL> connect / AS SYSDBA
SQL> drop public synonym XMLCONCAT;
SQL> drop function XMLCONCAT;
Regards,
Stefan
-Ursprüngliche Nachricht-Von:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Gesendet:
Montag, 6. Oktober 2003 22:39An: Multiple recipients of list
ORACLE-LBetreff: 9.2.0.4 patch on
linuxList,
I ran into some difficulties today while
applying the 9.2.0.4 patch to a 9.2.0.1 db on RH 8.0, and was curious if anyone else had seen
similar problems. After installing the 9.2.0.4 sw ( after installing the
2.2.0.18 OUI of course ) , I started
the database via 'startup migrate' and then ran catpatch.sql.
An ORA-3113 would consistently occur when
the following statement was reached in
the catmetx.sql script: create or
replace force view sys.ku$_xmlschema_view of sys.ku$_xmlschema_t
with object identifier (owner_name,
url) as select '1','0',
u.user#, u.name,
extractvalue(VALUE(s), '/schema/@schemaURL'), s.sys_nc_oid$, case when
under_path(value(r), '/sys/schemas/PUBLIC') = 1
then 0 else 1 end,
s.getclobval(),
-- unstripped
xdb.dbms_xdbutil_int.XMLSchemaStripUsername(XMLTYPE(s.getClobVal()),
u.name)
-- stripped from sys.user$ u, xdb.xdb$schema s, xdb.xdb$resource
r where
extractvalue(VALUE(r), '/Resource/XMLRef') = ref(s) and u.user# =
sys_op_rawtonum(extractvalue(VALUE(r),'/Resource/OwnerID')) AND
(SYS_CONTEXT('USERENV','CURRENT_USERID') IN (u.user#, 0) OR
EXISTS ( SELECT * FROM session_roles
WHERE role='SELECT_CATALOG_ROLE' )) Running this statement from the command line netted the
same results. Querying the
dba_registry view didn't reveal anything unusual: XML stuff was
in the 'LOADED' or 'LOADING'
state. Poking around MetaLink a
bit revealed the others had at times had different trouble with XDB, and had resolved them by recreating the XDB
schema. After running catnoqm.sql
( drops the XDB user ), catpatch.sql was again ran, and everything finished to completion. ( catpatch
calls catproc, which eventually calls catqm.sql, which recreates XDB if needed ) Have any of you experienced similar problems with XDB
while patching or upgrading? Jared
AW: AW: Experiences setting OPEN_CURSORS for Java applications
Hi Craig The whole point of an interceptor is basically to add functionality to a certain type or protocol without changing the interface the client works with. In Java, this is usually accomplished by implementing an extra interface to add things like security or billing based on transactions etc. (I've seen this in CORBA first, hence the reference to it). The developer continues working with the same types she/he used to work with. It often comes along with the factory pattern, where a certain object is created and returned to the calling object. The calling object uses the interface of the type it wanted, not being aware of any additional things. I hope that was confusing enough ;) Right now, we just implemented some "common" PL/SQL packages to deal with logging and error handling etc., but I have to say, the idea to add an extra layer to the JDBC architecture is a great idea. Helps DBAs spotting problems real easy, as you said. Regards, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Tel.: +49 201/45 13-289 mailto:[EMAIL PROTECTED] http://www.bov.de Abonnieren Sie unseren Newsletter: http://www.bov.de/enews Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Craig Munday [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 2. Oktober 2003 15:20 An: Multiple recipients of list ORACLE-L Betreff: Re: AW: Experiences setting OPEN_CURSORS for Java applications Hi, I'm not sure about the Interceptor pattern. Log4j is a great package and I make use of it within JDBC Expert. I started using the new logging API in JDK 1.4 but found most developers were using Log4j so I changed. Log4j seems like a much more mature package anyway. I too think it would be a great tool to be used in the development cycle. Ideally I would like every developer to have it installed while they complete their development in the hope that a number of defects can be eliminated early. In reality though, I find that senior developers and data administrators see the most benefits. Particularly database administrators, probably because they are the ones that are called upon to resolve the errors (such as ORA-1000) when they occur. Let me know if you would like a copy, and I'll email it privately to you - its too big to send to the list. Regards, Craig Munday. At 06:49 AM 1/10/2003 -0800, Stefan Jahnke wrote: >Hi > >Just wondering: How did you implement the "transparancy" aspect ? >Interceptor pattern (as in CORBA) ? >Your tool seems to be a very good thing to use during dev-cycle to log >certain aspects you're interested in (maybe log4j might do the job ?). > >Stefan > >-Ursprüngliche Nachricht- >Von: Craig Munday [mailto:[EMAIL PROTECTED] >Gesendet: Mittwoch, 1. Oktober 2003 02:44 >An: Multiple recipients of list ORACLE-L >Betreff: Re: Experiences setting OPEN_CURSORS for Java applications > > >Tanel, > >I've implemented it as a JDBC driver that is installed as a layer between >your application and the vendor driver that you are using (eg. Oracle, >Postgress, SQL Server, etc.) > >[Java application] - Layer 1 >[JDBC Expert] - Layer 2 >[Oracle Thin Driver] - Layer 3 > | >network > | >[Oracle Server] - Layer 4 > > >It does not parse Java source code and is not a code analyzer, however the >tool will intercept all calls that an application makes on the JDBC API, >analyze them and forward them onto the vendor driver. In this way the tool >is transparent to the application and can be installed or removed without >modification to the application code. > >I would not call it a traffic analyzer because to me that term implies that >it sits on a network and analyzes network traffic much like an Intrusion >Detection System might do. > >Regards, >Craig Munday. > > > > > > >At 04:11 AM 30/09/2003 -0800, you wrote: > > > I've encountered this problem so often that I decided to write a tool > > > (called JDBC Expert) that would help us DBAs (and developers) detect > > > Statement and ResultSet "leaks" in Java applica
AW: UNIX : script help/input
Hi Speaking of Perl, ... maybe somebody (Jared) can help out with some Perl / Windows problems: I'm using ActiveState 5.6 with DBI module, which works fine. Now, since I basically work within a CygWin environment on my laptop, I installed perl there, but there are no DBI modules. The basic problem is, that in order to get the DBI stuff compiled within cygwin, you would need a unix/cygwin wrapper for the OCI dlls, which are common windows dlls coming with the Oracle client (9.2.0.4) in order to import OCI stuff correctly, which is needed by DBI (at least I think so). The dlltool doesn't really help me here, since the dlls supplied by Oracle seem to be stripped (at least, dlltool can't find any symbols). If I try: $ nm oci.dll | grep ' T _' | sed 's/.* T _//' >> oci.def I only get: nm: oci.dll: no symbols Does anybody have an idea how to use the windows oci (or any other Oracle dll) from cygwin ? Otherwise I can also go ahead and toss out cygwin, since accessing Oracle is basically all I need it for. Regards, Stefan -Ursprüngliche Nachricht- Von: Jared Still [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 2. Oktober 2003 00:29 An: Multiple recipients of list ORACLE-L Betreff: RE: UNIX : script help/input > Good! The more the merrier! Welcome to the club. Oh most definitely. As I just finished writing a prototype package for assigning MAC addresses ( we make network stuff - that's a technical term ), I have endured the agonies of doing hex math in PL/SQL. I finally bit the bullet and used string manipulation to convert hex to decimal and do what I needed that way. Couldn't get BITAND to work properly on very large integers. Besides, doing XOR with BITAND in PL/SQL is very painful. UTL_RAW has an XOR, but it requires RAW values and I didn't feel like messing with it. This is all very simple in Perl. Given a MAC of 5AA, with a fixed portion of 500, it is very easy to determine the variable portion of the address via $x = 0x5AA ^ 500. Not quite so simple in PL/SQL. Jared On Wed, 2003-10-01 at 14:44, Mladen Gogala wrote: > On Wed, 2003-10-01 at 14:34, Jamadagni, Rajendra wrote: > > Funny .. I am currently sitting in a Perl class, so I can actually > > read what MG has written. I'll be soon Perl-literate ... > > > > Raj > > > > > > 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
AW: Experiences setting OPEN_CURSORS for Java applications
Hi Just wondering: How did you implement the "transparancy" aspect ? Interceptor pattern (as in CORBA) ? Your tool seems to be a very good thing to use during dev-cycle to log certain aspects you're interested in (maybe log4j might do the job ?). Stefan -Ursprüngliche Nachricht- Von: Craig Munday [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 1. Oktober 2003 02:44 An: Multiple recipients of list ORACLE-L Betreff: Re: Experiences setting OPEN_CURSORS for Java applications Tanel, I've implemented it as a JDBC driver that is installed as a layer between your application and the vendor driver that you are using (eg. Oracle, Postgress, SQL Server, etc.) [Java application] - Layer 1 [JDBC Expert] - Layer 2 [Oracle Thin Driver] - Layer 3 | network | [Oracle Server] - Layer 4 It does not parse Java source code and is not a code analyzer, however the tool will intercept all calls that an application makes on the JDBC API, analyze them and forward them onto the vendor driver. In this way the tool is transparent to the application and can be installed or removed without modification to the application code. I would not call it a traffic analyzer because to me that term implies that it sits on a network and analyzes network traffic much like an Intrusion Detection System might do. Regards, Craig Munday. At 04:11 AM 30/09/2003 -0800, you wrote: > > I've encountered this problem so often that I decided to write a tool > > (called JDBC Expert) that would help us DBAs (and developers) detect > > Statement and ResultSet "leaks" in Java applications. I've found this > > tool so useful and effective at finding resource leaks that I insist any >in > > house developed or third party Java applications are tested with it before > > we release them. > >Just interested, how have you implemented it? Is it a code or traffic >analyzer? > >Tanel. > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Tanel Poder > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- 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: Stefan Jahnke 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).
AW: COBOL TO ORACLE
Hi I'm basically doing the same: We're using PL1 programs to do an "unload" of VSAM files by hand. That actually takes care of multiple record structures and the like. It's a poor-man's normalisation of VSAMs ;). Then, just load the data as it is into a staging DB (Oracle), transform it and push it into the production DB (also Oracle). What I don't understand about the original eMail is the COBOL to Oracle part, but relating to the data ?! I guess moving the HOST based data was meant ? And regarding to connecting to VSAM or the like directly from Designer (via reading the copy books for instance), ... it either doesn't exist or we didn't find it ;). I opt for the first. PS: Having to use Oracle Designer is about as cool as crucification. Stefan -Ursprüngliche Nachricht-Von: Govindan K [mailto:[EMAIL PROTECTED]Gesendet: Mittwoch, 1. Oktober 2003 02:04An: Multiple recipients of list ORACLE-LBetreff: Re: COBOL TO ORACLE >Is there a tool available to move data from COBOL to ORACLE directly? One way to do is get COBOL >data on a flat file and then use SQL*Loader to insert into ORACLE tables. If you are using SQL*Loader make sure to check the log after load. For larger loads i would suggest direct load. >The second question is did anyone use DESIGNER to connect to COBOL to create an ERD and then >transform into ORACLE tabels script? I wonder how a tool will take care of Implicit Redefinition/Multiple Record Structures unless the Developer/DBA mentions them somewhere. HTH GovindanK<-Original Message-> From: Muqthar AhmedSent: 9/30/2003 12:16:28 PMTo: [EMAIL PROTECTED]Subject: Re: COBOL TO ORACLE Hi, Thanks Muqthar Ahmed DBA Author: Muqthar Ahmed INET: [EMAIL PROTECTED] . ___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!
AW: Effective Oracle By Design - Sample chapters
Hi Absolutely great. Interesting details about LMTs and extent allocation for example. I loved his other books, too. Stefan -Ursprüngliche Nachricht- Von: Tanel Poder [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 19. September 2003 00:15 An: Multiple recipients of list ORACLE-L Betreff: Effective Oracle By Design - Sample chapters Hi! Take look at the following link if you want to have a taste of Tom's new book. http://www.osborne.com/products/0072230657/ Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
AW: IBM AIX 32-Bit
Title: IBM AIX 32-Bit Blind guess: I guess you need to allocate 2 words in order to fit in a 64 bit word. Sounds easy ;). Stefan -Ursprüngliche Nachricht-Von: Munish Bajaj [mailto:[EMAIL PROTECTED]Gesendet: Freitag, 19. September 2003 13:05An: Multiple recipients of list ORACLE-LBetreff: RE: IBM AIX 32-Bit Hi, Sorry for intruding, But just curious that how can a 64 bit application run on a 32 bit OS. I always thought that it was never possible. Can u please explain how is this possible Regards Munish -Original Message-From: Shiva Subramaniam [mailto:[EMAIL PROTECTED]Sent: Friday, September 19, 2003 13:10To: Multiple recipients of list ORACLE-LSubject: RE: IBM AIX 32-Bit Yes it can be done - 64 bit oracle can be run in 32 bit os mode. Regards Shiva Subramaniam -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 11:30 PMTo: Multiple recipients of list ORACLE-LSubject: IBM AIX 32-Bit Hi there! I got a question: Can I run Oracle 64 Bit on IBM AIX 32 Bit? I know that AIX 64 Bit can run either Oracle 32 Bit or 64 Bit. Does it also work the other way round? Thanks, Helmut
AW: Nature of Oracle-l has changed
To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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: Stefan Jahnke 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).
AW: Nature of Oracle-l has changed
Hi Stephane Looks like I missed that post amongst all the "very" technical ones ;). I'm working on a development project now (social security), which includes heavy modelling, especially in the arena of historical data etc. So, it looks like I have to go back and browse the archive for your posting. Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Tel.: +49 201/45 13-289 mailto:[EMAIL PROTECTED] http://www.bov.de Abonnieren Sie unseren Newsletter: http://www.bov.de/enews Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Stephane Paquette [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 22. August 2003 16:29 An: Multiple recipients of list ORACLE-L Betreff: RE: Nature of Oracle-l has changed That's why my post on historic tables and views seem lonely ;-) Stephane -Original Message- Jared Still Sent: Friday, August 22, 2003 2:19 AM To: Multiple recipients of list ORACLE-L Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so much anymore. Do you think it's because there are so few development projects taking place? Seems like in house development died with the dot bomb and has not begun to recover. I know at my place of employment there is very little development, but that is due more to the size and nature of this place, as well as the management. ( they don't like in house development :( ) Now I spend my days with stuff like making NetBackup work with Oracle, migrating SAP all over the place and keeping things running. Not that we haven't always done those things, but I miss some not having a good development project. Ah, to do some real data modeling again. Just some food for thought. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: Stefan Jahnke 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).
AW: OpenLDAP instead of OID
Hi Dennis We will do some testing for development DBs using openldap on cygwin (very obscure setup, I know). Afterwards, I might have to move the stuff to AD (since the dev site is more of a windows shop). I will have to read some stuff (I'm more of a UNIX person), so it might take a while before I'm actually going to find the time to do this (like September). Stefan Jahnke Consultant BOV Aktiengesellschaft Tel.: +49 201/45 13-289 mailto:[EMAIL PROTECTED] http://www.bov.de Abonnieren Sie unseren Newsletter: http://www.bov.de/enews Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 19. August 2003 05:30 An: Multiple recipients of list ORACLE-L Betreff: RE: OpenLDAP instead of OID Congratulations Stefan! Thanks for posting this. Do you (or anyone else) have any ideas for doing this with Micro$oft Active Directory? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, August 18, 2003 8:15 AM To: Multiple recipients of list ORACLE-L Hi list Some people where interested in feedback regarding the usage of OpenLDAP instead of OID or Names to resolve TNS strings. Seems to work ;). Here is what to do: Prerequisite: I used openldap-2.0.23 instead of 2.1, since I had to use CygWin to test it locally on my laptop. Bill of materials: CygWin http://www.cygwin.com, I used the latest version, 1.5.2-1test Oracle Client, version >= 8.1.6.x OID LDIFS, can be taken from $ORACLE_HOME/ldap/admin, if the OID option is installed, or from Oracle Disks: Disk3\stage\Components\oracle.oid.server\9.2.0.1.0\1\DataFiles\admin.1.1.jar HowTo: http://home.nc.rr.com/jtlayton/oid2openldap.html Simply follow the howto to get openldap running and include the OID schemas. Then, create an ldap.ora under $ORACLE_HOME/network/admin, which looks like this: DIRECTORY_SERVERS=localhost:389 DIRECTORY_SERVER_TYPE=oid DEFAULT_ADMIN_CONTEXT="cn=Manager,dc=world" ... and change sqlnet.ora to contain: NAMES.DIRECTORY_PATH= (LDAP) Finished, enjoy. Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Tel.: +49 201/45 13-289 mailto:[EMAIL PROTECTED] http://www.bov.de Abonnieren Sie unseren Newsletter: http://www.bov.de/enews Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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: DENNIS WILLIAMS 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, includ
AW: It's an Oracle Fun Friday!
... just hope you didn't stop your remodeling activities after removing the bath tub, toilet bowl, etc. Your wife might eventually complain ;) Stefan -Ursprüngliche Nachricht- Von: Jonathan Gennick [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 8. August 2003 20:04 An: Multiple recipients of list ORACLE-L Betreff: Re: It's an Oracle Fun Friday! Friday, August 8, 2003, 10:29:25 AM, you wrote: JR> Like JR> http://bigip-larryellison.us.oracle.com Coming soon! :) There's also www.larryellison.com, which brings up the same page. Looks like Larry started his own site and then never got around to really doing anything with it. Well, I start a lot of things myself that I never quite finish, like that bathroom remodel upstairs... Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word "subscribe" in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
OpenLDAP instead of OID
Hi list Some people where interested in feedback regarding the usage of OpenLDAP instead of OID or Names to resolve TNS strings. Seems to work ;). Here is what to do: Prerequisite: I used openldap-2.0.23 instead of 2.1, since I had to use CygWin to test it locally on my laptop. Bill of materials: CygWin http://www.cygwin.com, I used the latest version, 1.5.2-1test Oracle Client, version >= 8.1.6.x OID LDIFS, can be taken from $ORACLE_HOME/ldap/admin, if the OID option is installed, or from Oracle Disks: Disk3\stage\Components\oracle.oid.server\9.2.0.1.0\1\DataFiles\admin.1.1.jar HowTo: http://home.nc.rr.com/jtlayton/oid2openldap.html Simply follow the howto to get openldap running and include the OID schemas. Then, create an ldap.ora under $ORACLE_HOME/network/admin, which looks like this: DIRECTORY_SERVERS=localhost:389 DIRECTORY_SERVER_TYPE=oid DEFAULT_ADMIN_CONTEXT="cn=Manager,dc=world" ... and change sqlnet.ora to contain: NAMES.DIRECTORY_PATH= (LDAP) Finished, enjoy. Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Tel.: +49 201/45 13-289 mailto:[EMAIL PROTECTED] http://www.bov.de Abonnieren Sie unseren Newsletter: http://www.bov.de/enews Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
AW: BEA's WebLogic vs. Jdeveloper and iAS
Hi I can't give you a clear answer on this one, but: Is it possible that BEA uses J2EE Connector Architecture to access People Soft ? I've seen this for SAP, it's kind of a standardized J2EE API which allows programmatic access to ERP (and the like) resources. If that's the case, then you should be able to use whatever app server (BEA or iAS) you want, unless BEA has some integrated support to generate code stubs to access People Soft. See also: http://java.sun.com/j2ee/connector/ Have fun, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Tel.: +49 201/45 13-289 mailto:[EMAIL PROTECTED] http://www.bov.de Abonnieren Sie unseren Newsletter: http://www.bov.de/enews Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: MacGregor, Ian A. [mailto:[EMAIL PROTECTED] Gesendet: Sonntag, 17. August 2003 02:44 An: Multiple recipients of list ORACLE-L Betreff: BEA's WebLogic vs. Jdeveloper and iAS We are highly interested in having all our Peoplesoft access which does not use screens created via Peoplesoft tools to pass through an applications server. One group invited the folks from BEA out, and my thought was, "Hey, we are already licensed for enterprise iAS, Jdeveloper and the like. Why pay for yet another development system.?" However BEA's tool produces modules which invoke the Peoplesoft API to put data into Peoplesoft. This is a major issue with us. Does any know if Oracle has anything that does the same? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. 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: Stefan Jahnke 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).
AW: Referencing other schemas' tables in PL/SQL procedure
INET: [EMAIL PROTECTED] (B>>>>>> (B>>>>>>Fat City Network Services-- 858-538-5051 (B>>>http://www.fatcity.com (B>>>>>>San Diego, California-- Mailing list and web (B>>>hosting services (B>>>>>>-- (B>>>--- (B>>>>>>To REMOVE yourself from this mailing list, send an E-Mail message (B>>>>>>to: [EMAIL PROTECTED] (note EXACT spelling of (B>>>'ListGuru') and in (B>>>>>>the message BODY, include a line containing: UNSUB ORACLE-L (B>>>>>>(or the name of mailing list you want to be removed (B>>>from). You may (B>>>>>>also send the HELP command for other information (like (B>>>subscribing). (B>>>>>> (B>>> (B>>> (B>>>DISCLAIMER: (B>>>This message (including attachment if any) is confidential (B>>>and may be privileged. Before opening attachments please (B>>>check them for viruses and defects. MindTree Consulting (B>>>Private Limited (MindTree) will not be responsible for any (B>>>viruses or defects or any forwarded attachments emanating (B>>>either from within MindTree or outside. If you have received (B>>>this message by mistake please notify the sender by return (B>>>e-mail and delete this message from your system. Any (B>>>unauthorized use or dissemination of this message in whole (B>>>or in part is strictly prohibited. Please note that e-mails (B>>>are susceptible to change and MindTree shall not be liable (B>>>for any improper, untimely or incomplete transmission. (B>>>-- (B>>>Please see the official ORACLE-L FAQ: http://www.orafaq.net (B>>>-- (B>>>Author: Naveen Nahata (B>>> INET: [EMAIL PROTECTED] (B>>> (B>>>Fat City Network Services-- 858-538-5051 http://www.fatcity.com (B>>>San Diego, California-- Mailing list and web hosting services (B>>>- (B>>>To REMOVE yourself from this mailing list, send an E-Mail message (B>>>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (B>>>the message BODY, include a line containing: UNSUB ORACLE-L (B>>>(or the name of mailing list you want to be removed from). You may (B>>>also send the HELP command for other information (like subscribing). (B>>>-- (B>>>Please see the official ORACLE-L FAQ: http://www.orafaq.net (B>>>-- (B>>>Author: Paul Vincent (B>>> INET: [EMAIL PROTECTED] (B>>> (B>>>Fat City Network Services-- 858-538-5051 http://www.fatcity.com (B>>>San Diego, California-- Mailing list and web hosting services (B>>>- (B>>>To REMOVE yourself from this mailing list, send an E-Mail message (B>>>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (B>>>the message BODY, include a line containing: UNSUB ORACLE-L (B>>>(or the name of mailing list you want to be removed from). You may (B>>>also send the HELP command for other information (like subscribing). (B>>> (B (B (BDISCLAIMER: (BThis message (including attachment if any) is confidential and may be (Bprivileged. Before opening attachments please check them for viruses and (Bdefects. MindTree Consulting Private Limited (MindTree) will not be (Bresponsible for any viruses or defects or any forwarded attachments (Bemanating either from within MindTree or outside. If you have received this (Bmessage by mistake please notify the sender by return e-mail and delete (Bthis message from your system. Any unauthorized use or dissemination of this (Bmessage in whole or in part is strictly prohibited. Please note that (Be-mails are susceptible to change and MindTree shall not be liable for any (Bimproper, untimely or incomplete transmission. (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Naveen Nahata (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing). (B (B (B (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Stefan Jahnke (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing).
AW: Redo Logs Problem
Hi Poster ;) Just a guess: Is it possible, that a tablespace is still in hot backup mode ? Or: Do you just happen to have more load ? Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Tel.: +49 201/45 13-289 mailto:[EMAIL PROTECTED] http://www.bov.de Abonnieren Sie unseren Newsletter: http://www.bov.de/enews Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder mailto:[EMAIL PROTECTED]. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht-Von: Munish Bajaj [mailto:[EMAIL PROTECTED]Gesendet: Freitag, 1. August 2003 12:34An: Multiple recipients of list ORACLE-LBetreff: Redo Logs Problem Hi Listers, One of my remote Clients is facing a problem with Redo Logs. The Redo Logs and the Archive logs in turn have suddenly started to generate at an alarming Rate. This has suddenly started from the last 1 week without any changes to Database Configuration or any other system settings (as per client). Can anyone please help me and let me know all the reasons that could be responsible for this behavior. Any Help from u will be appreciated. Regards Munish Bajaj
AW: Any German here ? Character set
My wife recommended that to me. She's American, I'm German. She definitely likes English better ... now I can see why ;). Stefan Jahnke Consultant BOV Aktiengesellschaft Tel.: +49 201/45 13-289 mailto:[EMAIL PROTECTED] http://www.bov.de Abonnieren Sie unseren Newsletter: http://www.bov.de/enews Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Henry Poras [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 30. Juli 2003 21:39 An: Multiple recipients of list ORACLE-L Betreff: RE: Any German here ? Character set Check out "The Awful German Language" by Mark Twain http://www.bdsnett.no/klaus/twain/ Henry -Original Message- Stephen Lee Sent: Wednesday, July 30, 2003 12:00 PM To: Multiple recipients of list ORACLE-L When I studied German for two years in college (I've forgotten it all now), I kept thinking that the same person who invented all the goofy spelling in English (remember the joke about "ghoti" being pronounced "fish"?)**, also invented German grammar. No offense to anyone is intended. ** GH as in tough O as in women TI as in motion > -Original Message- > > I'm a hundred percent sure that your German is about a bazillion times > better then my yugoslavian. > And I'm still trying to figure that beast called "English" > ... and they > don't even have Umlaute ;). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras 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: Stefan Jahnke 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).
AW: Any German here ? Character set
I'm a hundred percent sure that your German is about a bazillion times better then my yugoslavian. And I'm still trying to figure that beast called "English" ... and they don't even have Umlaute ;). Err, seriously, I'm from the German part that's closer to the Netherlands (great country, people are less stiff ;)), so if I go to Austria, I need a pocket translator. And now, working in Switzerland doesn't make things better. Nice mountains, I only wish I understood what the people say ;). To get back to the topic: I'm converting data in Switzerland from Mainframe (VSAM/DB2) to Oracle, and they actually have some extra characters (to my surprise). Stefan -Ursprüngliche Nachricht- Von: Mladen Gogala [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 30. Juli 2003 17:29 An: Multiple recipients of list ORACLE-L Betreff: Re: Any German here ? Character set Austrian? Local characters? I was fully convinced that Austrians speak German. As an inhabitant of ex-YU, I did a lot of shopping in Graz and even Munich. There wasn't much difference, even "joo" was the same. Mein Deutsch war ziemlich fliessend fruher, aber jetzt, Ich weiss nicht. God, do I hate writing in German without umlauts and "scharfes S"! On 2003.07.30 11:14, Stefan Jahnke wrote: > Hi > > That's exactly what we use. But it depends on what you have to support: If > you have Oracle running on a Mainframe and your customer is Austrian, there > is D8EBCDIC1141, which supports special local characters. > > Hope that helps, > Stefan > > > Stefan Jahnke > Consultant > BOV Aktiengesellschaft > Tel.: +49 201/45 13-289 > mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > http://www.bov.de <http://www.bov.de/> > Abonnieren Sie unseren Newsletter: http://www.bov.de/enews > <http://www.bov.de/enews> > > Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am > 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day > <http://www.bov.de/microsoft-day> oder mailto:[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> . > > Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter > fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir > um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche > Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen > ausschliessen. > > As you are probably aware, e-mails sent via the Internet can easily be > copied or manipulated by third parties. For this reason we would ask for > your understanding that, for your own protection and ours, we must decline > all legal responsibility for the validity of the statements and comments > given above. > > -Ursprüngliche Nachricht- > Von: Grant Allen [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 30. Juli 2003 16:50 > An: Multiple recipients of list ORACLE-L > Betreff: RE: Any German here ? Character set > > > I'd recommend WE8ISO8859P15 (I think that's it) ... the difference is Euro > support! > > Ciao > Fuzzy > :-) > > > -Original Message- > Goulet, Dick > Sent: Wednesday, July 30, 2003 15:29 > To: Multiple recipients of list ORACLE-L > > > WE8ISO8859P1, supports most western europe needs. > > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Wednesday, July 30, 2003 10:04 AM > To: Multiple recipients of list ORACLE-L > > > > Hi List, > could you please tell me wich Character Set you are using in your database ? > > Thank in advance! > > Philippe > > > > > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
AW: Any German here ? Character set
Title: Any German here ? Character set Hi That's exactly what we use. But it depends on what you have to support: If you have Oracle running on a Mainframe and your customer is Austrian, there is D8EBCDIC1141, which supports special local characters. Hope that helps, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Tel.: +49 201/45 13-289 mailto:[EMAIL PROTECTED] http://www.bov.de Abonnieren Sie unseren Newsletter: http://www.bov.de/enews Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder mailto:[EMAIL PROTECTED]. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht-Von: Grant Allen [mailto:[EMAIL PROTECTED]Gesendet: Mittwoch, 30. Juli 2003 16:50An: Multiple recipients of list ORACLE-LBetreff: RE: Any German here ? Character set I'd recommend WE8ISO8859P15 (I think that's it) ... the difference is Euro support! Ciao Fuzzy :-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Goulet, DickSent: Wednesday, July 30, 2003 15:29To: Multiple recipients of list ORACLE-LSubject: RE: Any German here ? Character set WE8ISO8859P1, supports most western europe needs. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: NGUYEN Philippe (Cetelem) [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 10:04 AMTo: Multiple recipients of list ORACLE-LSubject: Any German here ? Character set Hi List, could you please tell me wich Character Set you are using in your database ? Thank in advance! Philippe
AW: Oracle and OpenLDAP server
Hi Yannis (or John ?) That's GREAT. Exactly what I was looking for. I'll play around with it on the weekend and give some feedback to the list next week (if somebody is interested, that is). Thanks a lot ! Stefan -Ursprüngliche Nachricht- Von: Hatzistavrou John [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 29. Juli 2003 10:44 An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle and OpenLDAP server I have found the following link. It might be what you are looking for http://home.nc.rr.com/jtlayton/oid2openldap.html Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 29, 2003 10:49 AM To: Multiple recipients of list ORACLE-L We don't use it, yet. I considered using AD, because we already have an AD. But, I would prefer OpenLDAP for the UNIX world. OID is not an option since it is pretty much overkill for our needs. Let's try and see ;). Stefan -Ursprüngliche Nachricht- Von: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Gesendet: Montag, 28. Juli 2003 16:05 An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle and OpenLDAP server Stefan - Instead of AD?? I'm still trying to figure out how to get it to work with AD. My impression at this point is that only a few people have played with OID. I really hope you receive a reply because it will probably give me some hints about how to use it with AD. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 28, 2003 4:04 AM To: Multiple recipients of list ORACLE-L Hi Is there a way to get Oracle to work with OpenLDAP instead of OID, NDS or AD ? If so, does anybody know of a good How-To ? TIA, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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: DENNIS WILLIAMS 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: Stefan Jahnke 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: Hatzistavrou John 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: Stefan Jahnke 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 containi
AW: Oracle and OpenLDAP server
We don't use it, yet. I considered using AD, because we already have an AD. But, I would prefer OpenLDAP for the UNIX world. OID is not an option since it is pretty much overkill for our needs. Let's try and see ;). Stefan -Ursprüngliche Nachricht- Von: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Gesendet: Montag, 28. Juli 2003 16:05 An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle and OpenLDAP server Stefan - Instead of AD?? I'm still trying to figure out how to get it to work with AD. My impression at this point is that only a few people have played with OID. I really hope you receive a reply because it will probably give me some hints about how to use it with AD. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 28, 2003 4:04 AM To: Multiple recipients of list ORACLE-L Hi Is there a way to get Oracle to work with OpenLDAP instead of OID, NDS or AD ? If so, does anybody know of a good How-To ? TIA, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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: DENNIS WILLIAMS 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: Stefan Jahnke 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).
AW: Oracle and OpenLDAP server
Thanks. So it looks like I either have to ... create an OID, export everything and change the stuff to be standard LDAP, ... or, maybe: Sniff the network traffic while having Oracle create the Schema (LDAP, not DB) on a win2k Active Directory (if that is standard LDAP stuff, let's see ;). Sounds fabulous. Why the h*&%ll doesn't Oracle just comply to the standard, since they're always all hyper about open standards and complain about Microsoft ?! Stefan -Ursprüngliche Nachricht- Von: Jesse, Rich [mailto:[EMAIL PROTECTED] Gesendet: Montag, 28. Juli 2003 16:59 An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle and OpenLDAP server Yes, but it isn't pretty. Actually, we chose SunOne, but the concept is the same. I can't take any credit for it though as the local LDAP expert employee-turned-consultant figured out how to create the Oracle schema (LDAP schema, not DB schema). I don't know the exact details, but I remember that most of the problem was that the OiD tools don't create LDIFs to RFC standards. This means that while you can export the entire Oracle schema from OiD using ldifwrite, you have to massage the resulting LDIF in order to make it standards-compliant. Once you have that LDIF, you can use it to recreate the schema in OpenLDAP. We only used (TRIED to use) OiD for Oracle network names resolution (i.e. instead of ONAMES) and not user authentication. And at least on 9.0.1 under Linux, we couldn't get the damn thing stable. So we dumped OiD in favor of SunOne for non-Oracle user authentication, and are still using ONAMES for name resolution. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -Original Message- > From: Stefan Jahnke [mailto:[EMAIL PROTECTED] > Sent: Monday, July 28, 2003 4:04 AM > To: Multiple recipients of list ORACLE-L > Subject: Oracle and OpenLDAP server > > > Hi > > Is there a way to get Oracle to work with OpenLDAP instead of > OID, NDS or AD > ? > If so, does anybody know of a good How-To ? > > TIA, > Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
AW: Emacs on SQLPlus, er uh... SQLPlus on emacs.
vi on *nix and cygwin is the friend Stefan Jahnke Consultant BOV Aktiengesellschaft Tel.: +49 201/45 13-289 mailto:[EMAIL PROTECTED] http://www.bov.de Abonnieren Sie unseren Newsletter: http://www.bov.de/enews Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Orr, Steve [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 25. Juli 2003 22:10 An: Multiple recipients of list ORACLE-L Betreff: Emacs on SQLPlus, er uh... SQLPlus on emacs. vi is what I use and it's the predominant editor for SysAdmin/DBA types but I'm curious as to how many DBA's use emacs. I just saw a demo of SQL*Plus running under emacs and it was quite functional... Sorta like and IDE for SQL without Windoze GUI dependencies. Any DBA's use emacs on a daily basis? :wq (Or ZZ) Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve 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: Stefan Jahnke 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).
Oracle and OpenLDAP server
Hi Is there a way to get Oracle to work with OpenLDAP instead of OID, NDS or AD ? If so, does anybody know of a good How-To ? TIA, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
AW: dba age
Aha. Big guy ;). 34yrs, 6'6'', 225lbs. The 5 miles still work and at least due to my height, I'm able to cheat at the chin-up bar ;). Don't panic. Stefan -Ursprüngliche Nachricht- Von: Gogala, Mladen [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 23. Juli 2003 20:14 An: Multiple recipients of list ORACLE-L Betreff: RE: dba age I was born on 1/10/1961 in Zagreb, Croatia, which makes me 42 years of age. My horoscope sign is Ursus (6'4", 260 lbs, used to do greko-roman wrestling, I can still run 5 miles and lift myself on a chin-up bar). People sometimes confuse my age with the answer to certain question from the Doglas Adamses "Hitchiker's Guiide To Galaxy". Don't panic! Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 23, 2003 12:55 PM To: Multiple recipients of list ORACLE-L Tanel. I am personally impressed with your pratical knowledge, based on your responses to this list. Mostly DBA's particpating on this list is 35+ (may in the range of 40-45). Only one DBA is 42 years old for the last 5 years. Guess who Gogala Mladen(don't shoot me as I am your fan). That is his favorite/magic figure 42. However, he can tell his real age if he wants. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Wed, 23 Jul 2003 08:09:56 -0800 Hi! Age isn't the most important criteria for good DBA. Ability to analyze issues and foresee possible consequences of your actions are the most important ones, at least from my point of view. Personally, I just turned 25. Whether I'm experienced or not, I won't speculate, but so far I've lost no data and have kept all my customers happy ;) Tanel. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 23, 2003 6:54 PM Subject: dba age Now this one is difficult folks .. what is average age of an experienced oracle dba ? -ak _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- 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, 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: Gogala, Mladen 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: Stefan Jahnke 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).
AW: Re: Object Types in PL/SQL
Hi Sorry for the late reply ... weekend ;). If I understand you correctly, you do the following: Use "normal" tables (a normalized data model ?), then create an additional Object Type for each table with methods to do DML on that table. From Java, only use stored procs/funcs to manipulate the data. The procs/funcs use the Object Types in return. Java only "knows" these Object Types, not the tables. Advantage: JDBC doesn't have to query for that much metadata, since Java Objects map quite well to Object Types. Is that correct so far ? Stefan -Ursprüngliche Nachricht- Von: Nuno Souto [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 17. Juli 2003 14:05 An: Multiple recipients of list ORACLE-L Betreff: Re: Re: Object Types in PL/SQL - Original Message - > how does the object features improve performance of the jdbc? its fairly common now to have a java or .net(which we are using) and an Oracle backend. > When we started to use JDBC, one of the things I noticed was some very unusual network traffic. Certainly more than I was expecting given the level of statements being executed. A few traces showed a lot of traffic by JDBC driver itself trying to find information about the parameters involved in a ExecutableStatement. I believe this is specific to JDBC 2 and its new MetaData functionality, but I don't know for sure. A little bit of experimentation showed that if we created an object type definition for each table involved in our procedures and used the object type to pass the parameters (each parameter is a column) to the stored procedures, the network traffic dropped dramatically. Now we use a package for each table with an object type matching the table columns used as the single parameter to each function/procedure. Each package has as a minimum a MNG_ and a DEL_ procedure, with the first one handling both INSERT and UPDATE (depending if PK is set to NULL or not). We also write "getters" to access the data, returning a REF CURSOR typed on the same object type. This is not only blinding fast but the network traffic is negligeable. > your comments would be much appreciated. Not really comments, just the experience so far. It might change in the next version. So far it seems to work like a charm, so we're sticking with it. The next step is to get a few of the hierarchical accesses done via O-R views returning a single object with an array for the child object types. First trials seem very promising, but I have to wait for the 9i upgrade: 8i lets me do only one level of hierarchical object. After that, it's XML all the way through! If the customer doesn't kick us all out b4... ;) Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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: Stefan Jahnke 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).
AW: Re: Object Types in PL/SQL
Blind shot: I guess what's meant here is "speed up the development" because you safe your usual OR mapping problems. ??? Prost, Stefan -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 16. Juli 2003 14:20 An: Multiple recipients of list ORACLE-L Betreff: Re: Re: Object Types in PL/SQL how does the object features improve performance of the jdbc? its fairly common now to have a java or .net(which we are using) and an Oracle backend. your comments would be much appreciated. > > From: "Nuno Souto" <[EMAIL PROTECTED]> > Date: 2003/07/16 Wed AM 07:54:32 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Object Types in PL/SQL > > - Original Message - > > We actually don't use Object Types that much (who does anyway ;). But I have > > to say, that I'm a little bit disappointed by Oracle's implementation (Ever > > > I do. Only way to use some of the DMBS_* library items > and one of the best ways of speeding up Java/JDBC interaction. > Not a pure OO implementation, but then again I don't need > one: just a way to get the work done efficiently. > Plus the object-relational views are quite nice to return > object hierarchies (in 9i...). > > Cheers > Nuno Souto > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Nuno Souto > 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: Stefan Jahnke 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).
AW: Object Types in PL/SQL
Thanks all. Looks like I'll have to go with the "add-an-extra-parameter"
method for now as a workaround.
I don't know yet wether we're going to raise a TAR right away. The manual is
a little bit unclear about overriding the default constructor. So I might
contact a friend at Oracle first. I'll post any results on that.
We actually don't use Object Types that much (who does anyway ;). But I have
to say, that I'm a little bit disappointed by Oracle's implementation (Ever
heard of information hiding and encapsulation, Larry ?). If every developer
using the type will be allowed to set the attributes (to whatever value),
what's the point ? How about "private" vs. "public" ?! Well, at least they
give you a way to initialize Object Types somehow.
Stefan
-Ursprüngliche Nachricht-
Von: Pardee, Roy E [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 15. Juli 2003 16:59
An: Multiple recipients of list ORACLE-L
Betreff: RE: Object Types in PL/SQL
This doesn't answer your question directly, but if you aren't able to
override the constructor explicitly, you can probably create a static
function that creates, initializes & returns a tVNR as you would like it.
HTH,
-Roy
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487
-Original Message-
Sent: Tuesday, July 15, 2003 3:49 AM
To: Multiple recipients of list ORACLE-L
Hi list
I have a problem regardint PL/SQL Object Types. According to the fine
manual, it should be
possible to override the default constructor (I'm on 9.2.0.3.0 Win2k). I did
that, Object Type
compiles without complaints:
CREATE OR REPLACE TYPE tVNR AS OBJECT
(
vVNR VARCHAR2(14),
CONSTRUCTOR FUNCTION tVNR(piVNR VARCHAR2)
RETURN SELF AS RESULT,
MEMBER FUNCTION getVNR
RETURN VARCHAR2
) INSTANTIABLE FINAL;
CREATE OR REPLACE TYPE BODY tVNR AS
CONSTRUCTOR FUNCTION tVNR(piVNR VARCHAR2)
RETURN SELF AS RESULT IS
BEGIN
IF (LENGTH(piVNR)=11) THEN
SELF.vVNR := SUBSTR(piVNR,1,4) || '.' || SUBSTR(piVNR,5,4) || '.' ||
SUBSTR(piVNR,9,3);
ELSE
SELF.vVNR := 'invalid';
END IF;
RETURN;
END;
MEMBER FUNCTION getVNR RETURN VARCHAR2 IS
BEGIN
RETURN SELF.vVNR;
END;
END;
Now, everytime I want to create an object like this:
declare
vVNR tVNR;
begin
vVNR := new tVNR('12345678901');
dbms_output.put_line(vVNR.getVNR());
end;
I get the following error message:
ERROR at line 4:
ORA-06550: line 4, column 15:
PLS-00307: too many declarations of 'TVNR' match this call
ORA-06550: line 4, column 3:
PL/SQL: Statement ignored
Looks to me like the PL/SQL enginge isn't able to distinguish the default
constructor from the
overridden (my) version, since they have the same signature (of course).
Any input ? I couldn't find ANY descenct hints in the fine manual or the
Feuerstein book :(.
TIA,
Stefan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stefan Jahnke
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: Pardee, Roy E
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: Stefan Jahnke
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).
AW: AW: Object Types in PL/SQL
Hi
The default constructor is always there, even if you don't provide one.
So, if you declare and implement a constructor that has the same signature
as the default constructor (simply all the attributes as IN parameters,
returning SELF), you automatically override the default constructor.
That is what I want to do. The object type compiles, but if I use it,
PL/SQL tells me that it finds more than one constructors with that
signature, which are the "hidden" default constructor and the one I
implemented (I think). Now, that leaves me clueless, since it should be
possible (manual says so) to override the default constructor from 9.2 on.
Any more ideas ?
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Tel.: +49 201/45 13-289
mailto:[EMAIL PROTECTED]
http://www.bov.de
Abonnieren Sie unseren Newsletter: http://www.bov.de/enews
Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am
24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder
mailto:[EMAIL PROTECTED]
Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir
um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche
Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
ausschliessen.
As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask for
your understanding that, for your own protection and ours, we must decline
all legal responsibility for the validity of the statements and comments
given above.
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 15. Juli 2003 14:44
An: Multiple recipients of list ORACLE-L
Betreff: Re: AW: Object Types in PL/SQL
ok then i missed it. where is the overriding taking place? I saw a base
constructor.. where was the 'override'?
>
> From: Stefan Jahnke <[EMAIL PROTECTED]>
> Date: 2003/07/15 Tue AM 08:30:30 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: AW: Object Types in PL/SQL
>
> Hi
>
> The anonnymous block at the bottom of my email is just a little test
driver.
> Basically, I don't use subtyping here. I just override the default
> constructor.
> If I don't implement a constructor at all, I would look like this:
>
> CREATE OR REPLACE TYPE tVNR AS OBJECT
> (
>
> vVNR VARCHAR2(14),
>
> MEMBER FUNCTION getVNR
> RETURN VARCHAR2
>
> ) INSTANTIABLE FINAL;
>
> CREATE OR REPLACE TYPE BODY tVNR AS
>
> MEMBER FUNCTION getVNR RETURN VARCHAR2 IS
> BEGIN
> RETURN SELF.vVNR;
> END;
> END;
>
> And I would get a hidden, system provided default constructor.
> That would allow me to do the following (tested it):
>
> declare
> vVNR tVNR;
> begin
> vVNR := new tVNR('12345678901');
> dbms_output.put_line(vVNR.getVNR());
> end;
>
> And I would get the output:
>
> 12345678901
>
> Unfortunately, that doesn't give me any control regarding the
initialization
> of vVNR.
> Explanation: VNR = "Versichertennummer", which is kind of the Swiss analog
> to the
> US Social Security ID, only less unique ;).
>
> We don't use Object Relational features IN the database. Just plain
> relational tables.
> What we would like to use are Object Types to encapsulate certain things
> like the above
> shown VNR to ensure data integrity during data conversion for PL/SQL
> programs using
> these types. It's more of a guideline where the developers are constrained
> to use the
> types for certain stuff.
>
> Enjoy your day,
>
> Stefan Jahnke
> Consultant
> BOV Aktiengesellschaft
> Tel.: +49 201/45 13-289
> mailto:[EMAIL PROTECTED]
> http://www.bov.de
> Abonnieren Sie unseren Newsletter: http://www.bov.de/enews
>
> Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am
> 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder
> mailto:[EMAIL PROTECTED]
>
> Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
> fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten
wir
> um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die
rechtliche
> Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
> ausschliessen.
>
> As you are probably aware, e-mails sent via the Internet can easily be
> copied or manipulated by third parties. For this reason we would ask for
> your understanding that, for your own protection and ours, we must decline
> all legal responsibility for the validity of the statements and comments
> given above.
>
>
> -Ursprüngliche Nachric
AW: Object Types in PL/SQL
Hi
The anonnymous block at the bottom of my email is just a little test driver.
Basically, I don't use subtyping here. I just override the default
constructor.
If I don't implement a constructor at all, I would look like this:
CREATE OR REPLACE TYPE tVNR AS OBJECT
(
vVNR VARCHAR2(14),
MEMBER FUNCTION getVNR
RETURN VARCHAR2
) INSTANTIABLE FINAL;
CREATE OR REPLACE TYPE BODY tVNR AS
MEMBER FUNCTION getVNR RETURN VARCHAR2 IS
BEGIN
RETURN SELF.vVNR;
END;
END;
And I would get a hidden, system provided default constructor.
That would allow me to do the following (tested it):
declare
vVNR tVNR;
begin
vVNR := new tVNR('12345678901');
dbms_output.put_line(vVNR.getVNR());
end;
And I would get the output:
12345678901
Unfortunately, that doesn't give me any control regarding the initialization
of vVNR.
Explanation: VNR = "Versichertennummer", which is kind of the Swiss analog
to the
US Social Security ID, only less unique ;).
We don't use Object Relational features IN the database. Just plain
relational tables.
What we would like to use are Object Types to encapsulate certain things
like the above
shown VNR to ensure data integrity during data conversion for PL/SQL
programs using
these types. It's more of a guideline where the developers are constrained
to use the
types for certain stuff.
Enjoy your day,
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Tel.: +49 201/45 13-289
mailto:[EMAIL PROTECTED]
http://www.bov.de
Abonnieren Sie unseren Newsletter: http://www.bov.de/enews
Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am
24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder
mailto:[EMAIL PROTECTED]
Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir
um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche
Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
ausschliessen.
As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask for
your understanding that, for your own protection and ours, we must decline
all legal responsibility for the validity of the statements and comments
given above.
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 15. Juli 2003 14:05
An: Multiple recipients of list ORACLE-L
Betreff: Re: Object Types in PL/SQL
if im reading your code right... looks like your overriding in an anonymous
block. in most OO languages overriding is done by a child class. i dont see
any subclassing here? didnt they add sub-types and 'extends' to 9.2?
btw, are you using object oriented design in your database? How efficient do
you find that?
>
> From: Stefan Jahnke <[EMAIL PROTECTED]>
> Date: 2003/07/15 Tue AM 06:49:25 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Object Types in PL/SQL
>
> Hi list
>
> I have a problem regardint PL/SQL Object Types. According to the fine
> manual, it should be
> possible to override the default constructor (I'm on 9.2.0.3.0 Win2k). I
did
> that, Object Type
> compiles without complaints:
>
> CREATE OR REPLACE TYPE tVNR AS OBJECT
> (
>
> vVNR VARCHAR2(14),
>
> CONSTRUCTOR FUNCTION tVNR(piVNR VARCHAR2)
> RETURN SELF AS RESULT,
>
> MEMBER FUNCTION getVNR
> RETURN VARCHAR2
>
> ) INSTANTIABLE FINAL;
>
> CREATE OR REPLACE TYPE BODY tVNR AS
>
> CONSTRUCTOR FUNCTION tVNR(piVNR VARCHAR2)
> RETURN SELF AS RESULT IS
> BEGIN
> IF (LENGTH(piVNR)=11) THEN
> SELF.vVNR := SUBSTR(piVNR,1,4) || '.' || SUBSTR(piVNR,5,4) || '.' ||
> SUBSTR(piVNR,9,3);
> ELSE
> SELF.vVNR := 'invalid';
> END IF;
> RETURN;
> END;
>
> MEMBER FUNCTION getVNR RETURN VARCHAR2 IS
> BEGIN
> RETURN SELF.vVNR;
> END;
> END;
>
> Now, everytime I want to create an object like this:
>
> declare
> vVNR tVNR;
> begin
> vVNR := new tVNR('12345678901');
> dbms_output.put_line(vVNR.getVNR());
> end;
>
> I get the following error message:
>
> ERROR at line 4:
> ORA-06550: line 4, column 15:
> PLS-00307: too many declarations of 'TVNR' match this call
> ORA-06550: line 4, column 3:
> PL/SQL: Statement ignored
>
> Looks to me like the PL/SQL enginge isn't able to distinguish the default
> constructor from the
> overridden (my) version, since they have the same signature (of course).
>
> Any input ? I couldn't find ANY descenct hints in the fine manual or the
> Feuerstein book :(.
>
> TIA,
> Stefan
>
>
>
>
Object Types in PL/SQL
Hi list
I have a problem regardint PL/SQL Object Types. According to the fine
manual, it should be
possible to override the default constructor (I'm on 9.2.0.3.0 Win2k). I did
that, Object Type
compiles without complaints:
CREATE OR REPLACE TYPE tVNR AS OBJECT
(
vVNR VARCHAR2(14),
CONSTRUCTOR FUNCTION tVNR(piVNR VARCHAR2)
RETURN SELF AS RESULT,
MEMBER FUNCTION getVNR
RETURN VARCHAR2
) INSTANTIABLE FINAL;
CREATE OR REPLACE TYPE BODY tVNR AS
CONSTRUCTOR FUNCTION tVNR(piVNR VARCHAR2)
RETURN SELF AS RESULT IS
BEGIN
IF (LENGTH(piVNR)=11) THEN
SELF.vVNR := SUBSTR(piVNR,1,4) || '.' || SUBSTR(piVNR,5,4) || '.' ||
SUBSTR(piVNR,9,3);
ELSE
SELF.vVNR := 'invalid';
END IF;
RETURN;
END;
MEMBER FUNCTION getVNR RETURN VARCHAR2 IS
BEGIN
RETURN SELF.vVNR;
END;
END;
Now, everytime I want to create an object like this:
declare
vVNR tVNR;
begin
vVNR := new tVNR('12345678901');
dbms_output.put_line(vVNR.getVNR());
end;
I get the following error message:
ERROR at line 4:
ORA-06550: line 4, column 15:
PLS-00307: too many declarations of 'TVNR' match this call
ORA-06550: line 4, column 3:
PL/SQL: Statement ignored
Looks to me like the PL/SQL enginge isn't able to distinguish the default
constructor from the
overridden (my) version, since they have the same signature (of course).
Any input ? I couldn't find ANY descenct hints in the fine manual or the
Feuerstein book :(.
TIA,
Stefan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stefan Jahnke
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).
AW: Privileges and PL/SQL code
Title: RE: Privileges and PL/SQL code
That's what I was afraid of 8-{ ... oh
well.
Since
we have several developer's working on local copies of the code in schemas B, C,
etc.,
I
guess I have to grant privileges to all schemas.
Thanks
for the quick response.
Stefan
Stefan Jahnke Consultant BOV Aktiengesellschaft Tel.: +49 201/45 13-289 mailto:[EMAIL PROTECTED]
http://www.bov.de Abonnieren Sie unseren Newsletter: http://www.bov.de/enews
Kosten senken - strategische IT-Ziele
erreichen! BOV Microsoft Day am 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder
mailto:[EMAIL PROTECTED].
Wie Sie wissen, koennen ueber das Internet
versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden.
Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und
unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und
Aeusserungen ausschliessen.
As you are probably aware, e-mails sent
via the Internet can easily be copied or manipulated by third parties. For this
reason we would ask for your understanding that, for your own protection and
ours, we must decline all legal responsibility for the validity of the
statements and comments given above.
-Ursprüngliche Nachricht-Von: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]Gesendet: Montag, 14. Juli 2003
14:49An: Multiple recipients of list ORACLE-LBetreff:
RE: Privileges and PL/SQL code
If you don't want to do that, create your pl/sql code under
schema A and grant execute on those to B and C.
Sorry ... that's the only way to go ...
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----- From:
Stefan Jahnke [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 14, 2003 8:31 AM To: Multiple recipients of list ORACLE-L Subject: Privileges and PL/SQL code
Hi list
I was wondering if there is any way to get the following to
work:
User A owns all tables, users B,C own PL/SQL code to access
A's tables. To work with A's tables from user B and C,
I would like to create a role to contain all the
object privileges and grant these to B and C.
Didn't use to work, since PL/SQL is not particularly
interested in grants received through roles.
But I don't really want to grant all privileges directly to B
and C (and many more users).
Is there a way in 9i that works better ? Any improvements I
missed out on ?
Thanks in advance, Stefan
-- Please see
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
Privileges and PL/SQL code
Hi list I was wondering if there is any way to get the following to work: User A owns all tables, users B,C own PL/SQL code to access A's tables. To work with A's tables from user B and C, I would like to create a role to contain all the object privileges and grant these to B and C. Didn't use to work, since PL/SQL is not particularly interested in grants received through roles. But I don't really want to grant all privileges directly to B and C (and many more users). Is there a way in 9i that works better ? Any improvements I missed out on ? Thanks in advance, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
AW: JDBC and MTS
Hi Regis That's basically right. As I just posted, we use MTS for development, so that not every developer starts up a local connection pool on their workstation and we also don't end up with too many dedicated server processes. But I think you're right saying that MTS and application side connection pooling is pretty much redundant, if not even the source for trouble. a) the app server should start and monitor the connection pool. b) the client sessions (or app threads within the app server or whatever) request connections from that pool. c) important aspect here is the fact that the app server "thinks" that it maintains a pool of readily available, permanent connections. The clients (or whoever) will just be passed a reference to a certain connection. After they are finished with what they want to do, they put the connection back into the pool (plus some connection re-aquiring mechanism for dead clients and the like). d) That means, that with MTS, a new player shows up, as in the connections held in the connection pool are not permanent (or dedicated in oracle terms). That might lead to some latency while fetching a valid connection from the pool and using it, because when you actually start using it, you end up with some overhead since the dispatcher has to "give" you a connection. e) I don't know for sure, but has anybody ever testet some of the new features like sharing prepared statements between connections (and the possibility to tag a name to a statement for further information / statement fetching) with MTS ? So, I think it's either MTS OR Java Connection Pooling, not BOTH. Open for bashing, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Regis Biassala [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 17. Juni 2003 16:15 An: Multiple recipients of list ORACLE-L Betreff: RE: JDBC and MTS We add: 1. Application (Java) Using a JDBC Connection Pooling (CP)feature... 2. Database Oracle in MTS, pooling or not pooling enabled This was not good for us...so we kept the Java pooling side of the app and Oracle configured to run in dedicated mode. We'got a XML policy file which disables JDBC connection pooling for our application and gives the DBA a choice to configure a MTS... So in our case we two scenarios: 1. DB(MTS) and app(without CP) this is OK 2. DB(dedicated) and app(with CP) Regis -Original Message- Sent: Tuesday, June 17, 2003 1:25 PM To: Multiple recipients of list ORACLE-L OK. Let me get some things straight: a) I'm not a developer. I'm one of those vile creatures called DBAs. I don't program. I troubleshoot other people's programs. Other people program, I nag. When developers start writing bug-free software which uses the database in the most optimal way, my job is gone. b) The whole problem is that even after specifying SRVR=DEDICATED in the connect string, the darned thing still connects as an MTS connection. c) What was the issue that you faced? That was my original question. On 2003.06.17 07:09, Regis Biassala wrote: > Richard is right...If ur Java application uses it own connection > pooling...then do not use MTS...it slows down connections and more...We > faced the same issue here > > Our configuration allows DBA to choose weather connection pooling should > handled by the app or the database... > Use dedicated servers if there's noway you can disable the application > connection pooling... > > > Regis > > -Original Message- > Sent: Tuesday, June 17, 2003 6:05 AM > To: Multiple recipients of list ORACLE-L > > > I used to seen problems with JDBC Thin with MTS on Linux and switching to > a dedicated connection seemed to fix the problem. But JDBC Thin and MTS > worked fine on my Solaris box. Not sure with HP-UX. Is the Java > application > running on an Applic
AW: JDBC and MTS
* > This electronic transmission is strictly confidential and intended solely > for the addressee. It may contain information which is covered by legal, > professional or other privilege. If you are not the intended addressee, > you must not disclose, copy or take any action in reliance of this > transmission. If you have received this transmission in error, > please notify the sender as soon as possible. > > This footnote also confirms that this message has been swept > for computer viruses. > ** > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Regis Biassala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
AW: Using bind variables with ADO in VB
Hi Question: Are you sure that the binding you're referring to (your book excerpt) doesn't mean "early" bindig versus "late" binding in VB using ADO ? Stefan -Ursprüngliche Nachricht- Von: Regis Biassala [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 6. Juni 2003 14:50 An: Multiple recipients of list ORACLE-L Betreff: RE: Using bind variables with ADO in VB That's why developping server side code will help as you can "bind" in PL/SQL...period ! Avoid using thick clients...instead put all your logic in Oracle server side (i.e: write package, procedure and function) Regis -Original Message- Sent: Friday, June 06, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Having read that bind variables will solve all our problems ;-) I've tried to get the developers to use them. There response being: how? I don't know much VB and they don't know what a bind variable is. So I read with interest J Prem's question. Now knowing what to look for, I read further, and found that "ADO also does not bind (compile to p-code) parameterized statements in Oracle" (VB Oracle 8 by Dov Trietsch) 8-( Is it true? Are bind variables that big a deal in VB code anyway? We have a lot of badly written code, so are we better off re-writing the code without bothering about bind variables at the moment? Am I worrying about nothing? And no, it doesn't scale particularly well! Regards Craig Healey ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Healey 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 electronic transmission is strictly confidential and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify the sender as soon as possible. This footnote also confirms that this message has been swept for computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Regis Biassala 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: Stefan Jahnke 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).
AW: Oracle Service on Win2k
Mark, Jack Thanks for the hint. I guess I need more coffee ... Autostart was set. Ouch. And by the way ... which grammar problems ? Can't find any, since English is not even my mother tongue ;). Stefan -Ursprüngliche Nachricht- Von: Mark Leith [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 6. Juni 2003 14:17 An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle Service on Win2k I need more coffee, please excuse my weekend ready brain from it's grammar fart. Mark -Original Message- Mark Leith Sent: 06 June 2003 13:00 To: Multiple recipients of list ORACLE-L Stefan, This is due to a registry entry - ORA_SID_AUTOSTART. Open a registry editor, and navigate to HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOMEn (where n is the number Oracle home of the instance in question, should there be multiple instances), and you should see ORA_SID_AUTOSTART set to TRUE, just change it to FALSE and it your instance won't be started.. HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput & performance -Original Message- Stefan Jahnke Sent: 06 June 2003 12:29 To: Multiple recipients of list ORACLE-L Hi list On Oracle 9.2.0.3.0 (patched from 9.2.0.1.0 ): When i start JUST the service OracleService, most of the times, the database will also be mounted and opened ! Doesn't matter wether I start the service via gui or via "net start OracleService" or "oradim -STARTUP -SID -USRPWD -STARTTYPE srvc", the database will be opened right away. I definitely don't want that. That sh%&%($t can sc%&$/w up my instance. Does anybody encounter the same problems ? Couldn't find anything relevant on metaling, though. Help, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To
Oracle Service on Win2k
Hi list On Oracle 9.2.0.3.0 (patched from 9.2.0.1.0 ): When i start JUST the service OracleService, most of the times, the database will also be mounted and opened ! Doesn't matter wether I start the service via gui or via "net start OracleService" or "oradim -STARTUP -SID -USRPWD -STARTTYPE srvc", the database will be opened right away. I definitely don't want that. That sh%&%($t can sc%&$/w up my instance. Does anybody encounter the same problems ? Couldn't find anything relevant on metaling, though. Help, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
AW: Interesting!
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: Stefan Jahnke 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: Pardee, Roy E 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: Stefan Jahnke 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).
AW: Interesting!
Hi
Possible scenario where it might make sense:
You want to "hide" some implementation from people that use your package.
Since, AFAIK PL/SQL doesn't have information hiding (private, protected,
public etc.),
this might be a way of not showing your private helper method's signature
in your package declaration.
And yes, I am aware of the fact that it only makes sense with procs, funcs
that
you only want to use from within the scope of the proc/func you define them
in.
Otherwise you would end up with duplicate code.
Did I miss anything ?
Stefan
-Ursprüngliche Nachricht-
Von: Khedr, Waleed [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 4. Juni 2003 16:20
An: Multiple recipients of list ORACLE-L
Betreff: RE: Interesting!
I think it's good to have (forgive me Jared :)).
It reminds me with Pascal language.
Waleed
-Original Message-
Sent: Tuesday, June 03, 2003 9:40 PM
To: Multiple recipients of list ORACLE-L
My first real PL/SQL program used this technique. Of course since it was my
first program I ran into a very annoying variable scope issue. Of course
after spending hours debugging the code, I realized I should have taken the
advice of our DBA, the infamous Jared Still, and just used a package. I
have since looked askew at the nesting of procedures. I can't remember the
actual error I encountered. It probably had nothing or very little to do
with my nested procedures, but in my mind I can't consider this to be a good
practice. A package does the same job, and so much cleaner.
P.S. I think this was the first time I noted Jared's annoying habit of
being right
Steve McClure
-Original Message-
Waleed
Sent: Tuesday, June 03, 2003 4:10 PM
To: Multiple recipients of list ORACLE-L
I've just discovered this, never thought if it was possible or not.
Just wanted to share it with you, so forgive me if you know it already.
Procedure can contain other procedures:
create or replace procedure test_test1 as
procedure test_test2 as
begin
dbms_output.put_line('hello2');
end;
function c1 ( p1 in number) return number as
begin
return(p1 * 2);
end;
begin
dbms_output.put_line('hello1');
test_test2;
dbms_output.put_line( c1(10));
end;
Regards,
Waleed
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Khedr, Waleed
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: Steve McClure
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: Khedr, Waleed
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: Stefan Jahnke
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).
AW: Oradesigner9i ERD Diagrams
Hi Tom I always copy the diagrams to VISIO, print it from there. You can adjust stuff (pagesize) better then within Word or the like. But in cases, the diagrams get so big, that just a plotter and 2 square meter paper does the job ;). PS: If you have the Acrobat Distiller installed, it also works very well to send the print to the dummy printer to turn it into a pdf. Stefan -Ursprüngliche Nachricht- Von: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] Gesendet: Montag, 2. Juni 2003 17:40 An: Multiple recipients of list ORACLE-L Betreff: RE: Oradesigner9i ERD Diagrams Jared and all, thanks! GhostScript worked fine. Had to get a Postscript Print driver first, but everything is just hunky-dorey! thanks again Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, May 30, 2003 10:10 PM To: Multiple recipients of list ORACLE-L Tom, I've done this in the past by setting up a PostScript printer in windows, and sending the output to a file, then using the file to generate PDF's from GhostScript. HTH Jared "Mercadante, Thomas F" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/30/2003 12:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Oradesigner9i ERD Diagrams All, Does anybody know how to, instead of printing ERD diagrams to a printer, to send the output to an electronic file, preferrably something like a PDF or HTML format? I find it pretty amazing that we only have one option here - to print it on paper. I know somebody figured this out once by installing a print driver that saved the result to an image file of some kind, but I cant find the reference for it. thanks PS.. I'm using version 9.02 thanks again Tom Mercadante Oracle Certified Professional -- 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). -- 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
AW: Unbreakable, my buns. Upgrade to 9.2/w2k .... repost
Title: Unbreakable, my buns. Upgrade to 9.2/w2k Maybe that's a good opportunity to repost a question before I apply patchsets: I actually planned on applying the Patchset to lift 9.2.0.1.0 up to 9.2.0.3.0. But while downloading, I saw that 9.2.0.3.0 came out on April, 7th, while there was 9.2.0.2.1 from April, 12th. In the Readme, it says: # Earliest version of the product that this patch may be applied to: 9.2.0.2.1 So, what's the way to go ? Apply 9.2.0.2.0 patchset plus patches first ? Or forget about 9.2.0xxx and just go with 9.2.0.3.0 ? Stefan -Ursprüngliche Nachricht-Von: Tony Johnson [mailto:[EMAIL PROTECTED]Gesendet: Mittwoch, 28. Mai 2003 19:57An: Multiple recipients of list ORACLE-LBetreff: RE: Unbreakable, my buns. Upgrade to 9.2/w2k I have upgraded 16 databases ( manually using the scripts and procedures in metablink as a guide ) with very few problems and only then on the 1st ones I did. We were going from 8174 ro 92021 on Win2k SP3. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]Sent: Wednesday, May 28, 2003 9:25 AMTo: Multiple recipients of list ORACLE-LSubject: Unbreakable, my buns. Upgrade to 9.2/w2k For those of you who have upgraded to 9.2 on w2k: How many of you have ended up with such a hosed server that you had to completely wipe Oracle off of it and start with a fresh install (9.2)? It was spectacular! I ended up in this situation and I sure hope it's something I did or didn't do. I sure don't have time for this when I upgrade my production databases. How I long for those days wading through problems in unix... it was so much easier and more enjoyable... I will say this was definately a learning experience. And Tom Mercadante, your document worked like a charm, and saved my a$$... Muchas Gracias! Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa 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).
AW: Cannot allocate new log - checkpoint not complete
hi, see inline comments below ... There are some other effects I can think of. Up to you if these are important / significant to your users. If you make them bigger and you have a standby database then the standby might end up being further behind production (unless you have a script to workaround this) and also in this case you may then not get the files transferring successfully (depends on your network etc). -> His redo logs are 50M right now, that's pretty small. I think it won't hurt to double the size (unless you run the server on really small hardware). Also, if you make them bigger and you have a loss of all redo logs (hopefully unlikely if they are mirrored on mirrored disks) then you will lose more data as it will be a longer period of time since the last archive log was created. -> That's a VERY good point. Haven't thought about it. The bigger the log you loose, the more data is lost (of course). And what about your archive log management scripts - do they keep x days worth of files (in which case the volume of archive log on disk will not change) or do they keep y files - in this case the volume of disks would increase unless the script(s) are altered. Regards, Bruce Reardon -Original Message- Sent: Friday, 4 April 2003 3:44 AM To: Multiple recipients of list ORACLE-L Correct. The only potential disadvantage is that recovery will take longer when bringing up the database after a crash. Jay Miller -Original Message- Sent: Thursday, April 03, 2003 9:39 AM To: Multiple recipients of list ORACLE-L I dissagree, they will be bigger but there will be less of them. If the amount of processed data does not change, I do not think changing the size of the redolog files should affect the total amount fo bytes to be backeup up Thanks for the recommendation anyway ;) Cheers, Fermin. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Stefan Jahnke Enviado el: jueves, 03 de abril de 2003 15:44 Para: Multiple recipients of list ORACLE-L Asunto: AW: Cannot allocate new log - checkpoint not complete Hi I would suggest to increase the redo log size. Doesn't effect you during daily operation, but prevents the database from hanging during nightly batches. No side effects I can think of (except for the fact that, of course, it will take you longer to backup the archived logs since the files are bigger, duh ;). Good luck Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Fermin Bernaus Berraondo [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 3. April 2003 10:04 An: Multiple recipients of list ORACLE-L Betreff: Cannot allocate new log - checkpoint not complete I think I am having problems with my redologs. Under normal circumstances no errors arise, but if I do a massive import of data as I was doing last night, this is what alertSID.log shows from time to time: Wed Apr 2 23:29:52 2003 Thread 1 advanced to log sequence 557295 Current log# 3 seq# 557295 mem# 0: /baandata/oradata/baan/redobaan03.log Wed Apr 2 23:31:11 2003 Thread 1 cannot allocate new log, sequence 557296 Checkpoint not complete Current log# 3 seq# 557295 mem# 0: /baandata/oradata/baan/redobaan03.log Wed Apr 2 23:31:50 2003 In that exact time, everything freezes and the database is dead until a new redolog can be used. I have 3 redologs 50 Mb each. I've read that the error is because too much data is trying to get into the redologs and all of them are full, Oracle does not have the time to reuse a redolog and has to wait until the redolog is ready to be reused. So the solution seems to make these redolog files bigger or to create new ones. What are the side effects of one or the other? will performance under normal work be penalised? .. Fermín Bernaus Berraondo Dpto. de Informática
AW: Cannot allocate new log - checkpoint not complete
Sorry, that wasn't clear enough: I meant the backup time for one individual redo log will increase. Of course your right, ... the overall bytes to be backed up don't increase. Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 3. April 2003 19:44 An: Multiple recipients of list ORACLE-L Betreff: RE: Cannot allocate new log - checkpoint not complete Correct. The only potential disadvantage is that recovery will take longer when bringing up the database after a crash. Jay Miller -Original Message- Sent: Thursday, April 03, 2003 9:39 AM To: Multiple recipients of list ORACLE-L I dissagree, they will be bigger but there will be less of them. If the amount of processed data does not change, I do not think changing the size of the redolog files should affect the total amount fo bytes to be backeup up Thanks for the recommendation anyway ;) Cheers, Fermin. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Stefan Jahnke Enviado el: jueves, 03 de abril de 2003 15:44 Para: Multiple recipients of list ORACLE-L Asunto: AW: Cannot allocate new log - checkpoint not complete Hi I would suggest to increase the redo log size. Doesn't effect you during daily operation, but prevents the database from hanging during nightly batches. No side effects I can think of (except for the fact that, of course, it will take you longer to backup the archived logs since the files are bigger, duh ;). Good luck Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Fermin Bernaus Berraondo [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 3. April 2003 10:04 An: Multiple recipients of list ORACLE-L Betreff: Cannot allocate new log - checkpoint not complete I think I am having problems with my redologs. Under normal circumstances no errors arise, but if I do a massive import of data as I was doing last night, this is what alertSID.log shows from time to time: Wed Apr 2 23:29:52 2003 Thread 1 advanced to log sequence 557295 Current log# 3 seq# 557295 mem# 0: /baandata/oradata/baan/redobaan03.log Wed Apr 2 23:31:11 2003 Thread 1 cannot allocate new log, sequence 557296 Checkpoint not complete Current log# 3 seq# 557295 mem# 0: /baandata/oradata/baan/redobaan03.log Wed Apr 2 23:31:50 2003 In that exact time, everything freezes and the database is dead until a new redolog can be used. I have 3 redologs 50 Mb each. I've read that the error is because too much data is trying to get into the redologs and all of them are full, Oracle does not have the time to reuse a redolog and has to wait until the redolog is ready to be reused. So the solution seems to make these redolog files bigger or to create new ones. What are the side effects of one or the other? will performance
AW: Cannot allocate new log - checkpoint not complete
Hi I would suggest to increase the redo log size. Doesn't effect you during daily operation, but prevents the database from hanging during nightly batches. No side effects I can think of (except for the fact that, of course, it will take you longer to backup the archived logs since the files are bigger, duh ;). Good luck Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Fermin Bernaus Berraondo [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 3. April 2003 10:04 An: Multiple recipients of list ORACLE-L Betreff: Cannot allocate new log - checkpoint not complete I think I am having problems with my redologs. Under normal circumstances no errors arise, but if I do a massive import of data as I was doing last night, this is what alertSID.log shows from time to time: Wed Apr 2 23:29:52 2003 Thread 1 advanced to log sequence 557295 Current log# 3 seq# 557295 mem# 0: /baandata/oradata/baan/redobaan03.log Wed Apr 2 23:31:11 2003 Thread 1 cannot allocate new log, sequence 557296 Checkpoint not complete Current log# 3 seq# 557295 mem# 0: /baandata/oradata/baan/redobaan03.log Wed Apr 2 23:31:50 2003 In that exact time, everything freezes and the database is dead until a new redolog can be used. I have 3 redologs 50 Mb each. I've read that the error is because too much data is trying to get into the redologs and all of them are full, Oracle does not have the time to reuse a redolog and has to wait until the redolog is ready to be reused. So the solution seems to make these redolog files bigger or to create new ones. What are the side effects of one or the other? will performance under normal work be penalised? .. Fermín Bernaus Berraondo Dpto. de Informática SAMMIC, S.A. [EMAIL PROTECTED] http://www.sammic.com Telf. +34 - 943 157 331 Fax +34 - 943 151 276 .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fermin Bernaus Berraondo 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: Stefan Jahnke 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).
AW: Developer OCP, or DBA OCP ..?
Hi I personally think the Oracle Developer track doesn't do very much anyway. A combination of the SUN Java certification program and DBA OCP might be more helpful. A coworker of mine did the latest Developer OCP track and was very disappointed regarding the contents of the classes. Regards, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED]. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht-Von: Salaheldin Aboali [mailto:[EMAIL PROTECTED]Gesendet: Mittwoch, 2. April 2003 07:59An: Multiple recipients of list ORACLE-LBetreff: Developer OCP, or DBA OCP ..? Hi gurus,what do u recommend: taking "Developer OCP" then "DBA OCP", or "DBA OCP" direct ?assuming a person who is currently a 28 years - already is a senior oracle developer.thanx for advice Regards,Salaheldin Aboali--Senior Software Developer Management Information Systems--http://www.mis-kuwait.comPhone:+965.240.64.25+965.240.67.98+965.240.80.92Ext. 235Fax. +965.240.81.53Cell. +965.790.31.65--P.O. Box: 20126 Safat-13062 Kuwait--
AW: perl 5.8 access to oracle
Hi I don't know wether you already solved your problem, but I had to tweak PPM3 to use a local directory. Then, downloaded the modules I need and installed them from there. Have fun, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 11. März 2003 20:00 An: Multiple recipients of list ORACLE-L Betreff: Re: perl 5.8 access to oracle Get DBI and DBD::Oracle from www.xmlproj.com/PPM, courtesy of Ilya Sterin. Jared "Jeffrey Beckstrom" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/11/2003 06:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:perl 5.8 access to oracle Just installed Perl 5.8. Ran ppm3 to install the DBD package and PPM couldn't find it. I looked at activeperl site, it stated dbd for Oracle failed. I have now installed perl 5.6 and can find dbd/dbi files. With Perl 5.8, are you supposed to use something other than dbd/dbi to access an Oracle database? Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 -- 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: Stefan Jahnke 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).
AW: Database Modeling- Normalization - Dinosaurs or What?
Title: RE: Database Modeling- Normalization - Dinosaurs or What? Hi What I don't understand is: If your development department want to go with a VSAM like approach, why do they invest in Oracle. Why not just get a zSeries and stick to VSAM or IMS ? PS: Your working environment sounds like an actual implementation of Purgatory Regards, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED]. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht-Von: April Wells [mailto:[EMAIL PROTECTED]Gesendet: Dienstag, 25. März 2003 14:09An: Multiple recipients of list ORACLE-LBetreff: RE: Database Modeling- Normalization - Dinosaurs or What? Hi Paula Hey... I live in your world. Our "data warehouse" was designed by someone who had never dealt with ANYTHING relational... but based it on VSAM files and tried to make the leap. We have a table with 873 columns in our data warehouse... they call it a FACT table. It has client name and address (well... they are "facts", right... ?). You don't have foreign keys... we don't have PRIMARY keys. We call unique indexes primary keys... but after 10 years of not understanding why queries didn't return data that made sense, they allowed me to put not null constraints on the columns in the unique index (when I told them that they either do that or they answer to the clients). Historically, the DBAs in this company have done little more than implement what programmers designed and then tried to make it work. They WON'T use stored procedures, they don't understand them. THEY write code that sits in files on the OS and call those "programs" via shell scripts. They heard once that it was faster that way in Oracle 2 and so it must be still true, cause COBOL never changes so Oracle must not change. The part I like best, though, is... we have a ONE column table with ONE row... SystemDate... because they can't figure how to get sysdate from dual into a variable and use it in their programs... so they start their data warehouse load run with a truncate to that table, and an insert of the date passed in from the OS so they can load the DW tables. DON'T stop fighting. I think that is what they want. I have been told (in meetings where I have been requested for my DBA input) to sit down and shut up unless I am asked a question when I tried to point out things like... you can't have 1500 columns in a table no matter how fast it will make the queries fly... you can't have table names of 72 characters for descriptive sake... you really can't call a column DATE just because that is what is in it, an arbitrary date... Make them hear you even if they don't listen. Be the biggest pain they can imagine, eventually it will slowly start to pay off, because eventually they will realize (again VERY slowly) that you are right. It is how I got the reputation of being a DBA (Dat Bi#$h April) April -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Monday, March 24, 2003 6:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database Modeling- Normalization - Dinosaurs or What? Guys, The emphasis in many places I have worked is developing quick and dirty systems as quickly as possible and working with developers that don't seem to have very much understanding of Relational Database Theory but who prefer to program using flat files in relational databases - calling it "object-oriented" when it truly is not. Let us just say that it is highly denormalized. As a DBA I care about data integrity, extensibility and scalability but the up and coming esp. SQL Server developer types seem to operate in a world where this doesn't matter - just
AW: Number of bytes used by number data type
Hi everybody
I'm looking for a way to help with space estimations.
Basic idea:
- Run DDLs to create schema.
- Read dba_tab_columns to get the tables, columns (with data types and
sizes) for the schema
- Add the maximum possible length for each column for each table
Problem:
With max(vsize(myColumn)), I'll only get values for current data that's
already been filled into the table.
Is there anything like limits.h in C, that I can check to get the max values
for FLOAT, INTEGER, NUMBER etc., without having to do something like "select
vsize(max_number_value_for_certain_precision) from dual" ?
Or would it be more reasonable to do something like that: e.g. found a
column like "blah NUMBER(4,2)" in the dictionary, then build a statement
like "select vsize(to_number('99.99') from dual" to be run via dynamic sql ?
Any input ?
Regards,
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto: [EMAIL PROTECTED]
Please remove nospam to contact me via email.
visit our website: http://www.bov.de
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp
Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen!
Weitere Informationen unter +49 201/45 13-240 oder E-Mail an
mailto:[EMAIL PROTECTED]
Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten
wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die
rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
ausschliessen.
As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask for
your understanding that, for your own protection and ours, we must decline
all legal responsibility for the validity of the statements and comments
given above.
-Ursprüngliche Nachricht-
Von: Jonathan Lewis [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 20. März 2003 09:14
An: Multiple recipients of list ORACLE-L
Betreff: Re: Number of bytes used by number data type
See notes on
http://www.jlcomp.demon.co.uk/faq/num_size.html
There's also a note on the site (though not in the FAQ)
about reading internal formats and working out what
number it represents.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Now available One-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )
UK___April 8th
UK___April 22nd
Denmark May 21-23rd
USA_(FL)_May 2nd
Next dates for the 3-day seminar:
(see http://www.jlcomp.demon.co.uk/seminar.html )
UK_(Manchester)_May
USA_(CA, TX)_August
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: 19 March 2003 22:18
> Guru's
>
> I want to find out the exact space occupied by a number field. E.g I
want to
> find out the space occupied by a field
> NUMBER(7,2). I know oracle has an alogorithm to figure that out .
>
> A quick response would be highly appreciated
>
>
> RJ
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jonathan Lewis
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: Stefan Jahnke
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).
AW: Remove killed session from v$session
Thanks all, the time for the rollback to take place seems to explain why it takes so long before the session actually disappears from v$session. It's a development system running long data conversion procedures. Hence, there will be lots of rollback. ... and I guess I'll opt for orakill then. Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Arup Nanda [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 21. März 2003 15:39 An: Multiple recipients of list ORACLE-L Betreff: Re: Remove killed session from v$session Stefan, The session stays in the KILLED status because of a lot of reasons - the primary being the rollback being performed for all the changes the session did. At some point the session rollback will be complete and the session will be removed. Don't worry about the session being there. HTH. Arup Nanda - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 21, 2003 8:53 AM > Hi list > > Is there any way to remove a killed session from v$session. Is it even > necessary to do that ? > I ran this: > > select spid, status, osuser, s.program from > v$process p, v$session s where p.addr=s.paddr > > To check for the killed processes' spid in order to remove the thread (it's > 9.2 on win2k) with orakill. > But for the killed process, no process is shown. So, what's left ? Should I > even bother or just wait > till Oracle removes the killed session ? > > Regards, > Stefan > > Stefan Jahnke > Consultant > BOV Aktiengesellschaft > Voice: +49 201 - 4513-298 > Fax: +49 201 - 4513-149 > mailto: [EMAIL PROTECTED] > Please remove nospam to contact me via email. > > visit our website: http://www.bov.de > subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp > > Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! > Weitere Informationen unter +49 201/45 13-240 oder E-Mail an > mailto:[EMAIL PROTECTED] > > Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter > fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten > wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die > rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen > ausschliessen. > > As you are probably aware, e-mails sent via the Internet can easily be > copied or manipulated by third parties. For this reason we would ask for > your understanding that, for your own protection and ours, we must decline > all legal responsibility for the validity of the statements and comments > given above. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stefan Jahnke > 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: Arup Nanda 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
Remove killed session from v$session
Hi list Is there any way to remove a killed session from v$session. Is it even necessary to do that ? I ran this: select spid, status, osuser, s.program from v$process p, v$session s where p.addr=s.paddr To check for the killed processes' spid in order to remove the thread (it's 9.2 on win2k) with orakill. But for the killed process, no process is shown. So, what's left ? Should I even bother or just wait till Oracle removes the killed session ? Regards, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
AW: Usage of mySQL in enterprise environments
Hi I think mySQL is ok, as long as you just use it to dump data into it (like firewall logs etc.) and run reports on the data using simple SQL. But mySQL really s$&%cks when it comes to things like subselects, inline views, stored procedure (and I think the last time, a developer asked me something, I noticed that at least the version he was using (3 something) didn't even support views, you had to go with some temporary tables, which do the job, but it's a totally different concept). So be prepared to do things "not the Oracle way". ... and when it comes to transactions (I think ImmoDB tables do support them ok), the main plus about mySQL (maximum speed on low cost hardware) is gone. Regards, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Hemant K Chitale [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 18. März 2003 12:04 An: Multiple recipients of list ORACLE-L Betreff: Usage of mySQL in enterprise environments I've been asked to consider whether we can use mySQL for non-critical, but probably, enterprise-wide databases [e.g. information stores]. How good is the feedback on mySQL handling Queries, Transactions, ConcurrentUserCounts and DatabaseSize ? Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
AW: From Microsoft Access to Oracle
Hi We extensively used OO4O with Access 2000. It works fine, gives you all the Oracle specific stuff, but ... it's more work, since you have to code more things. I personally think it's worth it, eventhough I wouldn't go with Access in the first place. If it has to be VB, why not use VB 6.0 and Access just to display reports. There are lots of things (e.g. using ocx controls like the MS tree control in Access) that make you want to commit suicide. Nevertheless, the data access itself through OO4O works and we didn't have any problems with it. Regards, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED]. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht-Von: Jay [mailto:[EMAIL PROTECTED]Gesendet: Dienstag, 18. März 2003 13:19An: Multiple recipients of list ORACLE-LBetreff: Re: From Microsoft Access to Oracle The easiest way is to ODBC link the tables and develop like it is an MS Access project. This is not the best way due to security and a host of other issues. I have seen using ADO & oo4o through VBA to make the connection. This seems to work ok, but does require alittle more coding then the average MS Access database project. OTN has some great sections of using ADO and oo4o. - Original Message - From: Santosh Varma To: Multiple recipients of list ORACLE-L Sent: Tuesday, March 18, 2003 1:08 AM Subject: From Microsoft Access to Oracle Hello list, I want to create a new form in Access where user input will be thereand the data entered i have to store it in Oracle database. Can anyone of you guide me in doing this..How ??? Thanks and Regards, Santosh
AW: help -- ora 600
Hi JP With the newest drivers (ojdbc14.jar) for 9.2 it works. Thanks a lot. Regards Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Prem Khanna J [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 13. März 2003 10:44 An: Multiple recipients of list ORACLE-L Betreff: Re: help -- ora 600 Stefan , hope you don't have the right version of classes12.zip in your classpath. if it is not so , u r likely to get ORA-600 even on a simple SELECT. just set that right. HTH. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
help -- ora 600
Hi everybody Oracle 9.2.0.1.0 on Win2k SP2. Issuing the following statement via JDBC thin driver connection leads to ORA-00600: Interner Fehlercode, Argumente: [ttcgcshnd-1], [0], [], [], [], [], [], [] Statement is: SELECT alias0.ENT_ID, alias0.ENT_OID, alias0.ENT_CREATE_USER, alias0.ENT_CREATE_DATE, alias0.ENT_UPDATE_USER, alias0.ENT_UPDATE_DATE, alias0.ENT_TYPE, alias1.PRO_ID, alias1.PRO_NAME, alias1.PRO_VALUE, alias1.PRO_ENT_ID, alias1.PRO_CREATE_USER, alias1.PRO_CREATE_DATE, alias1.PRO_UPDATE_USER, alias1.PRO_UPDATE_DATE FROM AFENTITY alias0 LEFT OUTER JOIN AFPROPERTY alias1 ON alias0.ENT_ID = alias1.PRO_ENT_ID WHERE (alias1.PRO_NAME = 'NAME' AND alias1.PRO_VALUE = 'ADMIN/test') ORDER BY alias0.ENT_ID The statement works fine when it's executed in sql*plus. Other statements before (through jdbc thin connection). Here is the header of the trace file: Dump file f:\oracle\admin\vista9itest\udump\vista9itest_ora_2308.trc Thu Mar 13 09:28:34 2003 ORACLE V9.2.0.1.0 - Production vsnsta=0 vsnsql=12 vsnxtr=3 Windows 2000 Version 5.0 Service Pack 3, CPU type 586 Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production Windows 2000 Version 5.0 Service Pack 3, CPU type 586 Instance name: vista9itest Redo thread mounted by this instance: 1 Oracle process number: 17 Windows thread id: 2308, image: ORACLE.EXE *** SESSION ID:(16.1022) 2003-03-13 09:28:34.000 *** 2003-03-13 09:28:34.000 ksedmp: internal or fatal error ORA-00600: Interner Fehlercode, Argumente: [ttcgcshnd-1], [0], [], [], [], [], [], [] Current SQL statement for this session: SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT' - Call Stack Trace - calling call entryargument values in hex location type point(? means dubious value) _ksedmp+147 CALLrel _ksedst+0 _ksfdmp.108+eCALLrel _ksedmp+03 _kgerinv+83 CALLreg 578B730 3 _kgeasnmierr+13 CALLrel _kgerinv+0 578B730 9CF55B8 6058AD28 1 9C3D3B8 __VInfreq__ttcc2u+a CALLrel _kgeasnmierr+0 578B730 9CF55B8 6058AD28 1 0 1c 0 __PGOSF32__opifcr+3 CALLreg 578B730 5791880 0 0 1 1 fa 9C3D43C 9D0C4B8 _qerflRop+33 CALLreg 9C3DB90 A _qersoFetch+66b CALLreg 9C3DA4C A _qerflFetch+e8 CALL??? 688BC688 1077000 9C3DA4C A _qerjoFetch+ed CALL??? ..1.3_1.filter.30+2 CALL??? 688BC600 7697CC 9C3DB90 A 29 ..1.2_1.filter.25+3 CALLrel _opifch2+0 89 5 9C3DE64 1a I'm wondering about "SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT'". Is this the statement causing the problem ? Works fine within in sql*plus. Also, comparing the output of SELECT * FROM NLS_INSTANCE_PARAMETERS; on the instance that doesn't work with one that does, it shows the same results. What's the deal here ? Any ideas ? TIA, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REM
AW: Cannot delete datafile from O/S -- Help !!
Hi Khanna(?) (B (BHappens alot. Windows still holds a handle to the file. Just wait 'till next (Bscheduled reboot (shouldn't be too long;). (B (BRegards, (BStefan (B (BStefan Jahnke (BConsultant (BBOV Aktiengesellschaft (BVoice: +49 201 - 4513-298 (BFax: +49 201 - 4513-149 (Bmailto: [EMAIL PROTECTED] (BPlease remove nospam to contact me via email. (B (Bvisit our website: http://www.bov.de (Bsubscribe to our newsletter: http://www.bov.de/presse/newsletter.asp (B (BSicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! (BWeitere Informationen unter +49 201/45 13-240 oder E-Mail an (Bmailto:[EMAIL PROTECTED] (B (BWie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter (Bfremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten (Bwir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die (Brechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen (Bausschliessen. (B (BAs you are probably aware, e-mails sent via the Internet can easily be (Bcopied or manipulated by third parties. For this reason we would ask for (Byour understanding that, for your own protection and ours, we must decline (Ball legal responsibility for the validity of the statements and comments (Bgiven above. (B (B (B-Ursprungliche Nachricht- (BVon: Prem Khanna J [mailto:[EMAIL PROTECTED] (BGesendet: Freitag, 7. Marz 2003 11:54 (BAn: Multiple recipients of list ORACLE-L (BBetreff: Cannot delete datafile from O/S -- Help !! (B (B (BGuys, (B (BSQL> drop tablespace DATA14 including contents; (BTablespace dropped. (B (Bthe name of the datafile in DATA14 tablespace is DATA141.DBF (B (BSQL>select * from v$tablespace where name = 'DATA14'; (Bno rows selected (B (BSQL>select * from v$tdatafile where name = 'DATA14.DBF'; (Bno rows selected (B (Bwhen i try to delete the file DATA14.DBF from o/s , it says : (B"Cannot delete DATA14. There has been a sharing violation.The source or (Bdestination file may be in use." (B (Bwhy is it so ? how can i delete the file from O/S ? (Bcan someone help me ? (B (Bthe ENV is 8.1.6 / win2k. (B (BTIA. (BJp. (B (B (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Prem Khanna J (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing). (B (B (B (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Stefan Jahnke (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing).
AW: Programming languages that make DBA's lives easier
Is it smiliar to FORTKNOX ? I heard that there are also big bucks to make. Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED]. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Weiss, Rick [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 21. Februar 2003 15:49 An: Multiple recipients of list ORACLE-L Betreff: RE: Programming languages that make DBA's lives easier FORTRAN - Only one or two of us left that have even heard of it, much less actually made $$$ using it Rick Weiss -Original Message- Sent: Thursday, February 20, 2003 10:59 PM To: Multiple recipients of list ORACLE-L Assembler. On Wednesday 19 February 2003 03:33, Robson, Peter wrote: > I wonder if I can throw in a further caveat to the choices people > would make? > > If you had to choose a programming language in which to write a > program or application in which you wished to conceal your > intellectual property, which would you use? > > peter > edinburgh > > -Original Message- > Sent: Tuesday, February 18, 2003 10:56 AM > To: Multiple recipients of list ORACLE-L > > > > On top of learning Oracle, which programming languages would also > benefit some1 learning Oracle? Perl? Java? How would these languages > be used? > > > > * > This e-mail message, and any files transmitted with it, are > confidential and intended solely for the use of the addressee. If > this message was not addressed to you, you have received it in error > and any copying, distribution or other use of any part of it is > strictly prohibited. Any views or opinions presented are solely those > of the sender and do not necessarily represent those of the British > Geological Survey. The security of e-mail communication cannot be > guaranteed and the BGS accepts no liability for claims arising as a > result of the use of this medium to transmit messages from or to the > BGS. The BGS cannot accept any responsibility for viruses, so please > scan all attachments.http://www.bgs.ac.uk > * Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weiss, Rick 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: Stefan Jahnke INET: [EMAIL
AW: Endianness using External Tables
Title: RE: Endianness using External Tables
It's
pretty inconsistent. Using just "DATA IS BIG ENDIAN" and "BYTEORDERMARK
NOCHECK", it usually doesnn't work, but I also got cases, where it actually did
work. The DDL scripts are generated and the data looks the same.
I used
SQL*LOADER now and it works. I guess we will raise a tar and before that isn't
completely solved, we'll just go with loader again.
Stefan
Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via
email.
visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp
Sicherheitsluecken mit
IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter
+49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED].
Wie Sie wissen, koennen ueber das Internet
versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert
werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu
Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden
Erklaerungen und Aeusserungen ausschliessen.
As you are probably aware, e-mails sent
via the Internet can easily be copied or manipulated by third parties. For this
reason we would ask for your understanding that, for your own protection and
ours, we must decline all legal responsibility for the validity of the
statements and comments given above.
-Ursprüngliche Nachricht-Von: Godlewski, Melissa
[mailto:[EMAIL PROTECTED]]Gesendet: Freitag, 21. Februar
2003 15:06An: Stefan JahnkeBetreff: RE: Endianness using
External Tables
Did you try changing the characterset to
UTF16?
The
only other thing I can think of is to try another datatype instead of integer
try smallint, byteint, zoned or something to see if it will convert
appropriately.
-Original Message-From: Stefan Jahnke
[mailto:[EMAIL PROTECTED]]Sent: Friday, February 21, 2003 8:15
AMTo: Godlewski, MelissaCc: Oracle List Fatcity
(E-Mail)Subject: AW: Endianness using External
Tables
Hi
Melissa
Yes, I tried to do the same on a Windows PC today,
but the results are the same (wrong byte order).
Any other ideas ? I already reached the point,
where I wrote a function, that converts the wrong integers back to hex and
these back to the correct integer.
Shouldn't be the way to go.
Regards,
Stefan
Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED]
Please remove nospam to contact me
via email.
visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp
Sicherheitsluecken mit
IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen
unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED].
Wie Sie wissen, koennen ueber das
Internet versandte E-Mails leicht unter fremden Namen erstellt oder
manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer,
dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit
der vorstehenden Erklaerungen und Aeusserungen ausschliessen.
As you are probably aware, e-mails
sent via the Internet can easily be copied or manipulated by third parties.
For this reason we would ask for your understanding that, for your own
protection and ours, we must decline all legal responsibility for the
validity of the statements and comments given above.
-Ursprüngliche Nachricht-Von: Godlewski, Melissa
[mailto:[EMAIL PROTECTED]]Gesendet: Donnerstag, 20.
Februar 2003 17:22An: Stefan JahnkeBetreff: RE:
Endianness using External Tables
Stefan,
Just as a test, have you tried this to a different OS
system besides LINUX?
-----Original Message- From:
Stefan Jahnke [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 20, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L Subject: Endianness using External Tables
Hi everybody
I'm experiencing some problems with the endian byte order
parameter while processing data files from a
mainframe platform (OS/390). The data contains
integers (smallint, 2 bytes long), which come in big endian format (high byte first). I'm importing the data on a Linux
(PC) platform (Oracle 9.2.0.1.0 on SuSE
7.2).
I used the following parameters:
-- TDOMAIN:
DROP TABLE SHINFRA.X_TDOMAIN;
CREATE TABLE SHINFRA.X_TDOMAIN ( ZID_DOMAIN NUMBER (15,0),
ZHI_ORGEINHEIT NUMBER (15,0), ZHI_SYSEINDAT CHAR (26),
ZHI_SYSERSDAT CHAR (26), ZHI_SYSGUADAT
DATE, ZHI_SYSGUBDAT DATE, ZHI_SYSMSGNR CHAR (2
AW: Endianness using External Tables
Title: RE: Endianness using External Tables
Hi
Melissa
Yes, I
tried to do the same on a Windows PC today, but the results are the same (wrong
byte order).
Any
other ideas ? I already reached the point, where I wrote a function, that
converts the wrong integers back to hex and these back to the correct integer.
Shouldn't be the way to go.
Regards,
Stefan
Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via
email.
visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp
Sicherheitsluecken mit
IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter
+49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED].
Wie Sie wissen, koennen ueber das Internet
versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert
werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu
Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden
Erklaerungen und Aeusserungen ausschliessen.
As you are probably aware, e-mails sent
via the Internet can easily be copied or manipulated by third parties. For this
reason we would ask for your understanding that, for your own protection and
ours, we must decline all legal responsibility for the validity of the
statements and comments given above.
-Ursprüngliche Nachricht-Von: Godlewski, Melissa
[mailto:[EMAIL PROTECTED]]Gesendet: Donnerstag, 20.
Februar 2003 17:22An: Stefan JahnkeBetreff: RE:
Endianness using External Tables
Stefan,
Just as a test, have you tried this to a different OS system
besides LINUX?
-Original Message- From:
Stefan Jahnke [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 20, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Subject: Endianness using External Tables
Hi everybody
I'm experiencing some problems with the endian byte order
parameter while processing data files from a mainframe
platform (OS/390). The data contains integers
(smallint, 2 bytes long), which come in big endian
format (high byte first). I'm importing the data on a Linux (PC)
platform (Oracle 9.2.0.1.0 on SuSE 7.2).
I used the following parameters:
-- TDOMAIN:
DROP TABLE SHINFRA.X_TDOMAIN;
CREATE TABLE SHINFRA.X_TDOMAIN ( ZID_DOMAIN NUMBER (15,0),
ZHI_ORGEINHEIT NUMBER (15,0), ZHI_SYSEINDAT CHAR (26),
ZHI_SYSERSDAT CHAR (26), ZHI_SYSGUADAT
DATE, ZHI_SYSGUBDAT DATE, ZHI_SYSMSGNR CHAR (26),
ZHI_STATUS INTEGER, ZID_DOMAINBEZ NUMBER
(15,0), ZDOMAINNAME CHAR(14) ) ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY SHINFRADATA
ACCESS PARAMETERS ( RECORDS FIXED 138 CHARACTERSET='WE8EBCDIC500' "DATA IS BIG ENDIAN" FIELDS
REJECT ROWS WITH ALL NULL FIELDS
( ZID_DOMAIN
POSITION(1:8) DECIMAL(15,0), ZHI_ORGEINHEIT
POSITION(9:16) DECIMAL(15,0), ZHI_SYSEINDAT
POSITION(17:42) CHAR(26), ZHI_SYSERSDAT
POSITION(43:68) CHAR(26), ZHI_SYSGUADAT
POSITION(69:78) CHAR(10) DATE_FORMAT DATE MASK
"DD.MM.", ZHI_SYSGUBDAT
POSITION(79:88) CHAR(10) DATE_FORMAT DATE MASK
"DD.MM.", ZHI_SYSMSGNR
POSITION(89:114) CHAR(26), ZHI_STATUS POSITION(115:116)
INTEGER,
ZID_DOMAINBEZ POSITION(117:124) DECIMAL(15,0), ZDOMAINNAME
POSITION(125:138) CHAR(14)
) ) LOCATION
('TDOMAIN') ) REJECT LIMIT
UNLIMITED;
The field of interest here is ZHI_STATUS. If it is let's say
00 01 in Hex format in the original data file, I'll
get a 256 decimal in the Oracle database, which points
to a byte order problem, because that would be 01 00. I tried all combinations like DATA IS BIG ENDIAN, LITTLE ENDIAN or
nothing. I get the following log file entries, but the
result remains the same (256 instead of 1):
LOG file opened at 02/20/03 13:53:53
Field Definitions for table X_TDOMAIN Record format FIXED, record length 138 Data in file is in big endian format Reject rows with all null fields
Fields in Data Source:
...
LOG file opened at 02/20/03 13:54:33
Field Definitions for table X_TDOMAIN Record format FIXED, record length 138 Data in file is in little endian format Reject rows with all null fields
Fields in Data Source:
...
LOG file opened at 02/20/03 13:55:26
Field Definitions for table X_TDOMAIN Record format FIXED, record length 138 Data in file has same endianness as the platform
Reject rows with all null fields
Fields in Data Source:
It looks like the DATA IS ENDIAN parameter doesn't do
anything. Is there a mistake / misunderstanding on my
side ? I already checked Metalink, but couldn't find
anyt
Endianness using External Tables
Hi everybody
I'm experiencing some problems with the endian byte order parameter while
processing data files from a mainframe platform (OS/390).
The data contains integers (smallint, 2 bytes long), which come in big
endian format (high byte first). I'm importing the data on a Linux (PC)
platform (Oracle 9.2.0.1.0 on SuSE 7.2).
I used the following parameters:
-- TDOMAIN:
DROP TABLE SHINFRA.X_TDOMAIN;
CREATE TABLE SHINFRA.X_TDOMAIN
(
ZID_DOMAIN NUMBER (15,0),
ZHI_ORGEINHEIT NUMBER (15,0),
ZHI_SYSEINDAT CHAR (26),
ZHI_SYSERSDAT CHAR (26),
ZHI_SYSGUADAT DATE,
ZHI_SYSGUBDAT DATE,
ZHI_SYSMSGNR CHAR (26),
ZHI_STATUS INTEGER,
ZID_DOMAINBEZ NUMBER (15,0),
ZDOMAINNAME CHAR(14)
)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_LOADER
DEFAULT DIRECTORY SHINFRADATA
ACCESS PARAMETERS
(
RECORDS FIXED 138
CHARACTERSET='WE8EBCDIC500'
"DATA IS BIG ENDIAN"
FIELDS
REJECT ROWS WITH ALL NULL FIELDS
(
ZID_DOMAIN POSITION(1:8) DECIMAL(15,0),
ZHI_ORGEINHEIT POSITION(9:16) DECIMAL(15,0),
ZHI_SYSEINDAT POSITION(17:42) CHAR(26),
ZHI_SYSERSDAT POSITION(43:68) CHAR(26),
ZHI_SYSGUADAT POSITION(69:78) CHAR(10) DATE_FORMAT DATE MASK
"DD.MM.",
ZHI_SYSGUBDAT POSITION(79:88) CHAR(10) DATE_FORMAT DATE MASK
"DD.MM.",
ZHI_SYSMSGNR POSITION(89:114) CHAR(26),
ZHI_STATUS POSITION(115:116) INTEGER,
ZID_DOMAINBEZ POSITION(117:124) DECIMAL(15,0),
ZDOMAINNAME POSITION(125:138) CHAR(14)
)
)
LOCATION ('TDOMAIN')
)
REJECT LIMIT UNLIMITED;
The field of interest here is ZHI_STATUS. If it is let's say 00 01 in Hex
format in the original data file, I'll get a 256 decimal in the Oracle
database, which points to a byte order problem, because that would be 01 00.
I tried all combinations like DATA IS BIG ENDIAN, LITTLE ENDIAN or nothing.
I get the following log file entries, but the result remains the same (256
instead of 1):
LOG file opened at 02/20/03 13:53:53
Field Definitions for table X_TDOMAIN
Record format FIXED, record length 138
Data in file is in big endian format
Reject rows with all null fields
Fields in Data Source:
...
LOG file opened at 02/20/03 13:54:33
Field Definitions for table X_TDOMAIN
Record format FIXED, record length 138
Data in file is in little endian format
Reject rows with all null fields
Fields in Data Source:
...
LOG file opened at 02/20/03 13:55:26
Field Definitions for table X_TDOMAIN
Record format FIXED, record length 138
Data in file has same endianness as the platform
Reject rows with all null fields
Fields in Data Source:
It looks like the DATA IS ENDIAN parameter doesn't do anything. Is
there a mistake / misunderstanding on my side ?
I already checked Metalink, but couldn't find anything pointing to a bug
related to external tables and endianness or sql*loader and endianness.
Any ideas ? I'm getting pretty desperate here.
TIA,
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto: [EMAIL PROTECTED]
Please remove nospam to contact me via email.
visit our website: http://www.bov.de
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp
Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen!
Weitere Informationen unter +49 201/45 13-240 oder E-Mail an
mailto:[EMAIL PROTECTED].
Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten
wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die
rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
ausschliessen.
As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask for
your understanding that, for your own protection and ours, we must decline
all legal responsibility for the validity of the statements and comments
given above.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stefan Jahnke
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).
AW: Plain Old Database
Title: Message Hi Steve mod_plsql is pretty much a module that allows you to setup communication between Oracle db and Apache process in a cgi-like way. I have to admin that I don't know exactly, if the pl/sql engine runs embedded within apache like mod_perl for instance. But I don't think so, since I guess it has to run within the context of the database process. By the way, does anybody know if it's possible to compile a "real" apache form apache.org with mod_plsql and dismiss the one oracle delivers ? Regards, Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED]. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht-Von: Orr, Steve [mailto:[EMAIL PROTECTED]]Gesendet: Freitag, 14. Februar 2003 00:20An: Multiple recipients of list ORACLE-LBetreff: RE: Plain Old Database Thanks Allan, > as we all know Oracle is unbreakable, so security isn't an issue. :-) I know mod perl and mod ssl but what's mod plsql? How is it used and why? Anyone using it? Steve -Original Message-From: Nelson, Allan [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 13, 2003 3:46 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Plain Old Database The Apache shipped with the Oracle database has mod perl, mod ssl, and mod plsql installed into it, but is AFAIK a stock Apache distribution otherwise. It includes stuff for JSP's as well. You can't put an i in your name if you don't have web stuff and as we all know Oracle is unbreakable, so security isn't an issue. Allan -Original Message-From: Orr, Steve [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 3:34 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Plain Old Database I'm with you. Oracle behaves too much like Microsoft trying to get you install stuff whether you need it or not. I've come across a lot databases where the installer person installed stuff probably thinking, "I'm not sure if we'll need it or not so I'll just install it anyway." I don't use the dbca stuff but I did the same as you at a shop that used InterMedia. I then modified the generated scripts and only installed what was really needed. I wonder how many databases are vulnerable to hacking because Apache was installed from the Oracle CD's? Is there anything different about the Apache shipped by Oracle vs. what's publically available? Why does Oracle put Apache stuff on the CD's? Curious too, Steve Orr -Original Message- From: Jay Hostetter [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 1:10 PM To: Multiple recipients of list ORACLE-L Subject: Plain Old Database I am preparing to migrate from 8.1.7 to 9.0.2. I was just wondering if I am the only DBA that doesn't like all of this other "stuff" in my database - Ultrasearch, Intermedia, Oracle Text, and XML. I used dbca to generate my database creation scripts, so I could understand what the tool is doing to create the database. I've gone through and commented out these things that we won't be using. Am I in left field on this, or are others installing these options/products "in case" they need them later on (assuming you don't have an immediate need for them)? Same question for the http listener - are most dbas installing it and using it? Just curious. Thanks, Jay __This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwardi
AW: Tuning instance for batch processing
Mark and Dennis
Thanks for the replies. I'm actually doing a data conversion (migrating
mainframe data to Oracle). First step wil be loading all the files into a
staging db using external tables. Then, a lot of insert/update jobs will
run, and finally, we will do some queries / pl/sql stuff to check integrity
(on a logical level). Additionally, the machine will be mine for a whole
day, so I won't have to deal with side effects caused by other processes.
Looks like I should go ahead, start a test with plain vanilla configuration,
run statspack, change some parameters or execute queries in parallel mode,
run statspack and so on. And I think all your other points are also pretty
important, like the use of bind variables, bulk inserts instead of loops
commiting single rows, distribute i/o load etc.
But, it looks like it comes down to: "There is no silver bullet, just
iterative testing" ?
Regards,
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto: [EMAIL PROTECTED]
Please remove nospam to contact me via email.
visit our website: http://www.bov.de
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp
Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen!
Weitere Informationen unter +49 201/45 13-240 oder E-Mail an
mailto:[EMAIL PROTECTED].
Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten
wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die
rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
ausschliessen.
As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask for
your understanding that, for your own protection and ours, we must decline
all legal responsibility for the validity of the statements and comments
given above.
-Ursprüngliche Nachricht-
Von: Mark Richard [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 13. Februar 2003 23:46
An: Multiple recipients of list ORACLE-L
Betreff: Re: Tuning instance for batch processing
Stefan,
Are you looking at tuning in terms of Oracle parameters or rewriting SQL?
I guess one of the first things to consider is: Will the server be doing
anything else at the same time? If the batch jobs are the only thing
running then you tuning should probably focus more on execution time than
execution efficiency. For example, look at things like parallel queries to
load the box and reduce overall execution time.
Other than that the usual rules apply:
1) Use trace and TKPROF to see what's happening.
2) Look at using bind variables in queries that are repeated often to
reduce the parse count.
3) Look at processing a group of records in a single statement rather than
using loops in program logic if at all possible.
4) Look at I/O - do you have the load balanced well across datafiles /
disks.
5) If running on UNIX run sar or top or something similar to determine if
the server is working hard. If not, perhaps you can run jobs in parallel.
5) Are you doing anything unnecessary (ie: executing a statement within a
loop that will return the same value each time).
Even though #5 seems a little silly it can occaisionally work a treat. I
was aked to tune a very ugly query once because a batch job was running for
2 hours. The query, whilst very ugly, ran in under 500ms. Looking at the
program logic showed it was being called about 12,000 times though and was
guaranteed to return the same value each time. Running it once and storing
the result in a variable reduced the batch to under 5 minutes.
Regards,
Mark.
Stefan Jahnke
@bov.de> cc:
Sent by: Subject: Tuning instance for
batch processing
[EMAIL PROTECTED]
om
14/02/2003
01:49
Please respond
to ORACLE-L
Hi list
Does anyone know of any good white papers online (or maybe a Metalink Note
ID, I couldn't really find the right thing) about tuning an Oracle instance
for batch processing ?
Thanks,
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto: [EMAIL PROTECTED]
Please remove nospam to contact me via email.
visit our website: http://www.bov.de
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp
Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen!
Weitere Informationen unter +49 201/45 13-240 oder E-Mail an
mailto:[EMAIL PROTECTED].
Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten
wir um
Tuning instance for batch processing
Hi list Does anyone know of any good white papers online (or maybe a Metalink Note ID, I couldn't really find the right thing) about tuning an Oracle instance for batch processing ? Thanks, Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED]. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
Oracle connection through firewall
Hi everybody Since I'm a networking dummy, here's a question that might be easy to answer: I have to setup client access (Oracle Net) to an Oracle Database through a firewall. So far, I only know that the listener listens on a dedicated port (like 1521). After a client requested a connection, a dedicated server process is started (this is not an MTS environment) and the listener is informed about the port the server process wants to use to communicate with the client. The listener sends this information to the client and from thereon, the client can communicate with the server through this port. Now, I'm wondering about what ports do I have to keep open on the firewall between client and Oracle server ? 1521 is probably not enough, since this let's the client only reach the listener itself. What happens then ? Can I restrict Oracle Net to a range of ports for the server processes to be used (didn't find that in the fine manual) ? If so, how is this done ? Or do I have to go with Oracle connection manager ? Regards, Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED]. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
AW: AW: RMAN: I don't trust it
Hi I just posted that as reply to your question about hsql (what is it ?). But you're right here, it is not very scalable and also not meant to compete with Oracle or PostgreSQL. Enjoy your day, Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED]. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Lyndon Tiu [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 11. Februar 2003 16:54 An: Multiple recipients of list ORACLE-L Betreff: Re: AW: RMAN: I don't trust it Quoting Stefan Jahnke <[EMAIL PROTECTED]>: > Hi Lyndon > > hsql == HypersonicSQL. It's a pure Java, lightweight database > server. Not > suitable for large amounts of data, more the way to go if you're > looking for > an SQL database to embed into your Java app. > I thought we were talking about Oracle and Postgresql here? hsql is not scalable means I'd rather use Access. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu 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: Stefan Jahnke 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).
AW: Error in Rownum Select
Hi Maybe I miss the point, but I don't really see the need for an order by here ? Can't you just dismiss it ? Regards, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED]. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht-Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Gesendet: Dienstag, 11. Februar 2003 16:34An: Multiple recipients of list ORACLE-LBetreff: RE: Error in Rownum SelectIt seems so.. Thanks. RegardsM.Emre HANCIOGLUMasterfoods Services GmbHISI Application SupportTel : +49 2162 500-2576Fax: +49 2162 41497E-Mail: [EMAIL PROTECTED] - Forwarded by Emre M. Hancioglu/VSN/Effem on 11.02.2003 16:10 - "Stephane Faroult" <[EMAIL PROTECTED]> oriolecorp.com 11.02.2003 15:32 Please respond to "Stephane Faroult" To: [EMAIL PROTECTED] cc: Subject: RE: Error in Rownum Select Not absolutely certain of it but I think that allowing 'order by' in views (regular or in-line) is a feature which was introduced with 8.1.6. No easy workaround ...>- --- Original Message --- ->From: [EMAIL PROTECTED]>To: Multiple recipients of list ORACLE-L><[EMAIL PROTECTED]>>Sent: Tue, 11 Feb 2003 05:39:13>>Hello,>Can anyone tell me the reason, why I get an error>because of the "Order >By" in Oracle 8.1.5.>It works fine in 8.1.7 and 9.2.>>declare> v_t number(8);>begin > SELECT tagesdatum into v_t> FROM (SELECT rownum n, tagesdatum> FROM (SELECT tagesdatum> FROM kalender> WHERE tagesdatum <= >to_number(to_char(sysdate,'mmdd'))> AND tag_type = 'A' > ORDER BY tagesdatum DESC> )> )> WHERE n=6; >end; >>>>Regards>>M.Emre HANCIOGLU>Masterfoods Services GmbH>ISI Application Support >Tel : +49 2162 500-2576>Fax: +49 2162 41497>E-Mail: [EMAIL PROTECTED]Regards,Stephane FaroultOriole
AW: RMAN: I don't trust it
Hi Lyndon hsql == HypersonicSQL. It's a pure Java, lightweight database server. Not suitable for large amounts of data, more the way to go if you're looking for an SQL database to embed into your Java app. Regards, Stefan -Ursprüngliche Nachricht- Von: Lyndon Tiu [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 11. Februar 2003 05:14 An: Multiple recipients of list ORACLE-L Betreff: Re: RMAN: I don't trust it On Monday 10 February 2003 07:23 pm, Richard Ji wrote: > Lyndon, > > You are comparing Apple with Orange here. I can backup my hsql database > which is stored in a text file with: > What's hsql ? > cp my_db my_db.backup > I do not undertstand this command. Oracle database files are in binary format. Simply copying does not turn it into text sql scripts. Could you please explain further? Thanks. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu 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: Stefan Jahnke 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).
AW: java
Hi Henry So, it's basically working now ? Or are you still trying to figure out the "why" part ? What does this setup.aix do ? Is it an executable that execs a java process starting setup.jar ? Or is it a script you could post here so I can take a look at it ? Regarding the logs, usually, if a java programm is started and crashes, it gives you a stack trace, depending on some command line parameters (like verbose). > It completed successfully (arrgh!!!) after a week of no luck. Better a week of no luck then a week of no lunch. Good luck, Stefan -Ursprüngliche Nachricht- Von: Henry Poras [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 6. Februar 2003 15:44 An: Multiple recipients of list ORACLE-L Betreff: RE: java Stephan, Thanks for the reply. You were right, it had nothing to do with java 3D. I just wish I knew what caused the problem, but with the lack of controls around here it is tough to test. I noticed the error consistently appeared in one of two spots, so I set up 4 scenarios to test (different sets of environment variables). Scenarios 1&2 gave errorA, while scenarios 3&4 gave errorB. I thought the difference was either due to the different env variables, or maybe some OS resources weren't being cleaned up, so I reran scenarioA. It completed successfully (arrgh!!!) after a week of no luck. I don't have a clue. Oh well. Henry -Original Message- Jahnke Sent: Thursday, January 30, 2003 10:31 AM To: Multiple recipients of list ORACLE-L Hi Henry I don't know anything about Peoplesoft, but it is very unlikely, that any kind of java based installer needs Java 3D. Java 3D is more comparable to the OpenGL libary and I just can't imagine the need for it in an installer, unless you want some neat 3D features like animated scenes of buckets of bytes flying from A to B ;). What Java version does you installer need ? Does it come with it's own runtime ? Is the correct runtime found ? Are there any issues with this particular version on AIX (like with Sun's JDK 1.3.1 on Linux for the Oracle installer) ? Are any Peoplesoft specific libraries needed ? If so, check the classpath on the machine where it works. Regards, Stefan -Ursprüngliche Nachricht- Von: Henry Poras [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 27. Januar 2003 19:30 An: Multiple recipients of list ORACLE-L Betreff: java I have a java question so I figured I'd tap into some of the non-Oracle expertise on this list. I'm doing a PeopleSoft install (basically setup.aix calls a setup.jar file). This worked on one AIX (4.3.3) box, but is dying (with no useful error messages or log files) on another box. Checking the java directories, I noticed java3d is installed on the good box, not on the bad box. This might be it, but my SA is grumbling about adding that piece to the other box. He said it failed because of some missing AIX pieces (patches?). Here are my two questions: 1. Is there any java trace I can use to see where the PeopleSoft install is dying? Can I confirm it's a call to java3d? 2. Can I safely just copy over the java3d directory, lib files, and bin files from one machine to the other? If the original install failed because of some missing OS stuff, this doesn't seem safe to me (but where does java tie in to the OS?) Sorry for the off-topic post. PG Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras 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: Stefan Jahnke 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: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -
AW: Oracle 101 Performance Tuning comes to the rescue again!
Hi Recommended reading in this case: "Balding 101 Shave the rest off". Helped me too and you also get the neat side effect of "looking meaner" ... which helps in management meetings ;) Regards, Stefan -Ursprüngliche Nachricht-Von: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Gesendet: Freitag, 31. Januar 2003 19:57An: Multiple recipients of list ORACLE-LBetreff: RE: Oracle 101 Performance Tuning comes to the rescue again! Kirti, well, maybe it doesn't solve the problem of my forehead getting higher and higher every day, but the technique described in your book is always helpful in determining where problems exist in the system. thanks again Tom Mercadante Oracle Certified Professional -Original Message-From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 1:53 PMTo: [EMAIL PROTECTED]Cc: [EMAIL PROTECTED]Subject: RE: Oracle 101 Performance Tuning comes to the rescue again! Tom, Thanks a lot. I am glad to read that the book is helping you. I am not so sure about ".. solves all problems", though ;) Regards, - Kirti -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 11:52 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle 101 Performance Tuning comes to the rescue again! All, you *MUST* buy this book. I just got called over by the Warehouse people. Their database was hung. We could log-on ok, but certain queries would hang. Ran the four "wait-state" queries and saw that two queries were hung on library cache. the two queries were an analyze table and a MV refresh - using the same table. hung them both out to dry. killed the analyze and the MV started up again. great book. solves all problems. great job Gaja, Kirti and John. you guys do the work, and I look like a hero. thanks again. Tom Mercadante Oracle Certified Professional
AW: java
Hi Henry I don't know anything about Peoplesoft, but it is very unlikely, that any kind of java based installer needs Java 3D. Java 3D is more comparable to the OpenGL libary and I just can't imagine the need for it in an installer, unless you want some neat 3D features like animated scenes of buckets of bytes flying from A to B ;). What Java version does you installer need ? Does it come with it's own runtime ? Is the correct runtime found ? Are there any issues with this particular version on AIX (like with Sun's JDK 1.3.1 on Linux for the Oracle installer) ? Are any Peoplesoft specific libraries needed ? If so, check the classpath on the machine where it works. Regards, Stefan -Ursprüngliche Nachricht- Von: Henry Poras [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 27. Januar 2003 19:30 An: Multiple recipients of list ORACLE-L Betreff: java I have a java question so I figured I'd tap into some of the non-Oracle expertise on this list. I'm doing a PeopleSoft install (basically setup.aix calls a setup.jar file). This worked on one AIX (4.3.3) box, but is dying (with no useful error messages or log files) on another box. Checking the java directories, I noticed java3d is installed on the good box, not on the bad box. This might be it, but my SA is grumbling about adding that piece to the other box. He said it failed because of some missing AIX pieces (patches?). Here are my two questions: 1. Is there any java trace I can use to see where the PeopleSoft install is dying? Can I confirm it's a call to java3d? 2. Can I safely just copy over the java3d directory, lib files, and bin files from one machine to the other? If the original install failed because of some missing OS stuff, this doesn't seem safe to me (but where does java tie in to the OS?) Sorry for the off-topic post. PG Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras 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: Stefan Jahnke 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).
AW: Multiple block sizes in 9i
Hi Jos I used that to store data with different row sizes in areas of the database where the block size fits the row size best. For instance, you have an OLTP database with rows that fit perfectly fine into 4k blocks. Then, you have some tables with "longer" rows. So, you can go ahead and assign that data to reside on an area with 8k blocks. This allows the database to work with buffers, that fit the size of the row best and avoid unnecessary i/o. Regards, Stefan -Ursprüngliche Nachricht-Von: Jos [mailto:[EMAIL PROTECTED]]Gesendet: Donnerstag, 16. Januar 2003 14:14An: Multiple recipients of list ORACLE-LBetreff: Multiple block sizes in 9i List, Oracle 9i supported multiple block sizes, I am wondering under what circumstances one would setup a database with multiple block sizes? Jos Yahoo! Greetings- Send your seasons greetings online this year!
AW: Replication
Hi David It sounds like Advanced Replication to me. The question is: Will the data you move from instance A to instance B also be changed on instance B ? Is it necessary to propagate changes back to instance A ? -> Master-Master Replication. Will the data on instance B remain unchanged and only be queried ? -> Plain vanilla snapshots might be enough. Could you be more precise regarding the requirements here ? But anyway, you can take a look at Oracle's replication guide, it explains all the available options pretty well. Regards, Stefan -Ursprüngliche Nachricht- Von: Ehresmann, David [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 16. Januar 2003 16:09 An: Multiple recipients of list ORACLE-L Betreff: List, I have to move data on a regular basis between two instances of 8.1.7 on two different UNIX servers. The schema is exactly the same. There are 543 tables to be "refreshed". It is only the "new data" on one of the servers to move to the other. What is the best and easiest way to do this? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: Stefan Jahnke 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).
AW: Re: Out of oracle & VB question
Hi That seems to be more of a question for a VB newsgroup. Sorry that I can't help here. Stefan -Ursprüngliche Nachricht- Von: guess who [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 8. Januar 2003 15:04 An: Multiple recipients of list ORACLE-L Betreff: Re: Re: Out of oracle & VB question hi nice to see ur mail...and one thing VB stands for visual basic... Then if it is so,can u help me for the following two questions... Regards, N.Prakash. --- question one : -- Hi guys, Hope all are fineHelp requestThat is,i need some tutorials which contains only multiple choice questions with answersTo be very clear,i need some small technical questions with answers..(one words,choose the correct answers etc. like that.only in visual basic) Not big theories please question two : -- i have a problem in VB...i want to count the no. of forms available in a project ((i.e).vbp).Then after that i have to take the names of the forms from a VB project.Then after that i have to pass the selected form name and i have to turn that string into a frm object, so that i should open the selected form name Can anyone tell me whether there is a way to do it... Its my request... Can any one help me... Regards, [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: guess who 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: Stefan Jahnke 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).
AW: True inner peace
Are you dead ?! -Ursprüngliche Nachricht- Von: mantfield [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 7. Januar 2003 02:59 An: Multiple recipients of list ORACLE-L Betreff: True inner peace By following the simple advice I read in an article, I have finally found inner peace... It said: "The way to achieve inner peace is to finish all the things I had started". So, today I have finished one bottle of cognac, two bottles of red wine, a bottle of Jack Daniels, my Prozac's, and a box of chocolates. Amazing, I feel better already! Pass this on to all those in need of Inner Peace! Ferenc Mantfeld -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mantfield 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: Stefan Jahnke 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).
AW: Unix for oracle dba -- Suggest a book ?
Yes. This is also a very good book. I own an older version for Oracle 8.0.x, but I remember it to be pretty well written and concise. Another remark on Unix books for Oracle DBAs: My company got a copy of Oracle 9i Unix Adminstration Handbook by Don Burleson. It starts at the very beginnings of command line tools and the like, so I already knew that stuff. I was surprised how badly the book was reviewed by the editors (I guess), since there were so many (small but still) glitches in there, starting from the explanation of /etc/passwd to mixing up DOS command line tools and Unix ones. Nothing big, but if you are a total novice, these kind of things might be confusing and a professional book at the price of about 50 bucks shouldn't have that many mistakes. This is very unfortunate, since it is overall a very neat volumen. That almost reminds me of the Couchman OCP study guide. Your were ready to be certified by the time you were able to identify all the errors in the book and to correct them ;). Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
AW: Unix for oracle dba -- Suggest a book ?
I read it and love it. The only thing I was wondering about is the fact, that he uses tcl/tk, which I found most people don't use anymore. Nice surprise. I wasn't quite sure wether oraora was looking for books that gives more of a general overview of books that delve into the depth of unix internals. Anyway, here is my favorite on Unix internals (hence, the name of the book ;): UNIX Internals: The New Frontiers by Uresh Vahalia Eventhough it was published in 1995, it gives you a very good understanding about how things really work and why they work the way they do. Regards, Stefan -Ursprüngliche Nachricht- Von: Hately, Mike (NESL-IT) [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 6. Januar 2003 18:04 An: Multiple recipients of list ORACLE-L Betreff: RE: Unix for oracle dba -- Suggest a book ? If you want to understand how Oracle uses Unix get a copy of James Morle's "Scaling Oracle". It's not a beginner's Unix book but it's accurate and detailed. regards, Mike Hately -Original Message- Sent: 06 January 2003 15:59 To: Multiple recipients of list ORACLE-L Doesn't anyone read the manuals any more?! Oracle9i Installation Guide - Unix http://download-east.oracle.com/docs/html/A96167_01/toc.htm Oracle9i Administrator's Reference - Unix http://download-east.oracle.com/docs/html/A97297_01/toc.htm "James Damiano" <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> .nh.us> cc: Sent by: Subject: Re: Unix for oracle dba -- Suggest a book ? [EMAIL PROTECTED] 01/06/03 06:28 AM Please respond to ORACLE-L I've found a wonderful resource in the following book: "Oracle DBA on Unix and Linux" by Michael Wessler http://www.samspublishing.com It covers some of the differences in features between 8i and 9i as well as handling the specifics of administrating Oracle specifically on Unix platforms. Highly recommended (at least by me). Jim Damiano > Guys, > i know a bit of Linux.and not completely a newbie to Unix. > Can u suggest me a good/best book for Unix ? > ..Unix for oracle DBA. > i.e,tuning unix for good performance of oracle. > any such book available ? > kindly let me know guys. > TIA. > Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Damiano 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: Hately, Mike (NESL-IT) 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: Stefan Jahnke 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-M
AW: AW: Unix for oracle dba -- Suggest a book ?
wow, that was stupid of me !! UNIX System Administration Handbook (3rd Edition) by Evi Nemeth, Garth Snyder, Scott Seebass, Trent R. Hein Unix for Oracle DBAs Pocket Reference by Donald K. Burleson (I copied the ISBN from Amazon). Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
AW: Unix for oracle dba -- Suggest a book ?
Hi oraora I like this one as a general (but in depth) one for Unix Admins, because it has lots of real life stuff: Paperback: 896 pages ; Dimensions (in inches): 1.30 x 9.23 x 7.06 Publisher: Prentice Hall PTR; ISBN: 0130206016; 3rd edition (August 2000) Also this little booklet for Oracle DBAs: Paperback: 104 pages ; Dimensions (in inches): 0.33 x 7.04 x 4.50 Publisher: O'Reilly & Associates; ISBN: 0596000669; 1st edition (May 2001) Regards, Stefan -Ursprüngliche Nachricht- Von: oraora oraora [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 6. Januar 2003 11:14 An: Multiple recipients of list ORACLE-L Betreff: Unix for oracle dba -- Suggest a book ? Guys, i know a bit of Linux.and not completely a newbie to Unix. Can u suggest me a good/best book for Unix ? ..Unix for oracle DBA. i.e,tuning unix for good performance of oracle. any such book available ? kindly let me know guys. TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: oraora oraora 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: Stefan Jahnke 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: Object relational features and performance
Forgot something: For a general understanding, I like the books by Peter Coad and Bruce Eckel. These guys really know how to explain stuff and how to think. regards, Stefan -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/20/2002 8:38 PM Jeremy - Our developers have received a lot of Java training, and if I understand what you are saying, we are planning to do exactly what you describe -- normalized data structures in Oracle and an abstraction layer for the Java programmers. Would you mind to send a UML diagram that describes this "EB + session facade pattern"? Are you doing the entire abstraction on the Java side, or are you calling Oracle stored procedures? On a more general note to everyone, does anyone know of a book that would be helpful for an Oracle DBA that is trying to master what is needed to support Java programmers or make decisions in the area of Java and Oracle? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 20, 2002 12:25 PM To: Multiple recipients of list ORACLE-L > From: Stephane Paquette [ mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ] > > > Is this the future ??? > > I know one big bank where the development is object > oriented and the database (DB2 UDB in this case) is > used as a big flat file. The development is using > java, j2ee, bea weblogic. > Here's another thought. Take a strong look at the J2EE architecture. The concept of Entity Beans + Session Facade pattern is a strong means of maintaining the 2 important concepts of OO and relational data. For quite a while I worked to develop a strong abstraction layer to maintain normalized data in the db, but give the Java developers a true OO API. Now with Entity Beans and intelligent design elements I've got the best of both worlds. Transactional data is most effeciently stored in most cases in normalized form. The issue is to not force OO developers to make the leap in their code. Entity Beans are not strictly OO (since you must reference them by a PK), but are close enough to meet the needs of at least 90% of the enterprise development projects, IMHO. If the data access is minimal, I suppose the above solution would be fine. I'd hate to try to roll out an app with a significant amount of transactions with that structure, though. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: Stefan Jahnke 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: Object relational features and performance
Here is a book I put beneath my pillow: Prentice Hall, SUN Series, Core J2EE Patterns (esp. from page 388 on: Integration tier patterns) by Alur/Crupi/Malks, ISBN-0-13-064884-1 Also alot of specs and papers from the sun java site, like EJB, JTA/JTS (Transactions), JMS (Messaging), JDO (Java Data Objects), JDBC and everything that looks like it might have anything to do with data access, which is most of the J2EE stuff. Enjoy your holidays, though ;). Regards, Stefan -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/20/2002 8:38 PM Jeremy - Our developers have received a lot of Java training, and if I understand what you are saying, we are planning to do exactly what you describe -- normalized data structures in Oracle and an abstraction layer for the Java programmers. Would you mind to send a UML diagram that describes this "EB + session facade pattern"? Are you doing the entire abstraction on the Java side, or are you calling Oracle stored procedures? On a more general note to everyone, does anyone know of a book that would be helpful for an Oracle DBA that is trying to master what is needed to support Java programmers or make decisions in the area of Java and Oracle? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 20, 2002 12:25 PM To: Multiple recipients of list ORACLE-L > From: Stephane Paquette [ mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ] > > > Is this the future ??? > > I know one big bank where the development is object > oriented and the database (DB2 UDB in this case) is > used as a big flat file. The development is using > java, j2ee, bea weblogic. > Here's another thought. Take a strong look at the J2EE architecture. The concept of Entity Beans + Session Facade pattern is a strong means of maintaining the 2 important concepts of OO and relational data. For quite a while I worked to develop a strong abstraction layer to maintain normalized data in the db, but give the Java developers a true OO API. Now with Entity Beans and intelligent design elements I've got the best of both worlds. Transactional data is most effeciently stored in most cases in normalized form. The issue is to not force OO developers to make the leap in their code. Entity Beans are not strictly OO (since you must reference them by a PK), but are close enough to meet the needs of at least 90% of the enterprise development projects, IMHO. If the data access is minimal, I suppose the above solution would be fine. I'd hate to try to roll out an app with a significant amount of transactions with that structure, though. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: Stefan Jahnke 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).
