Re: rebuilding indexes - sure to cause a ruckus
Hi Tanel, I recommend a strong cup of coffee and a small nap 1/2 way through ;) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 7:44 AM Ouch, I gotta take a day off to read this one ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: rebuilding indexes - sure to cause a ruckus
Hi Paul, The long one includes a discussion on why you should generally coalesce rather than rebuild indexes ;) Cheers Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 8:44 AM somewhat on the longish side??? I'd hate to see a long article! ;-) --- Richard Foote [EMAIL PROTECTED] wrote: Hi Yong, Saying there are a few errors is being a little kind to Don's Inside Oracle Indexing article. In part, these are some of the issues I raised directly with Don in a number of emails (warning somewhat on the longish side ;): __ 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: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: rebuilding indexes - sure to cause a ruckus
Hi Steve, I agree completely, but the question is would you rebuild it afterwards ? Cheers ;-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 9:29 AM I think it needs an index. ;-) -Original Message- Paul Baumgartel Sent: Monday, December 08, 2003 3:44 PM To: Multiple recipients of list ORACLE-L somewhat on the longish side??? I'd hate to see a long article! ;-) --- Richard Foote [EMAIL PROTECTED] wrote: Hi Yong, Saying there are a few errors is being a little kind to Don's Inside Oracle Indexing article. In part, these are some of the issues I raised directly with Don in a number of emails (warning somewhat on the longish side ;): -- 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: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: can't see a SQL generated by Crystal Report
Are you sure that Crystal does not do any local processing on the data? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 12:39 AM Hi all: I'm trying to catch a DDL generated by Crystal report. I'm using the following query to do that: select sql_text from v$sqltext where ( address, hash_value ) in (select sql_address, sql_hash_value from v$session where username = UPPER('username')) order by piece I am catching a SQL, but that SQL returns different amount of rows than the report when executed through a Crystal. Is there something wrong with my query (it is running under Oracle 817) that makes it miss some data? thanks Gene __ 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: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Re: Oracle and Novell eDirectory LDAP
IIRC Oracle is going to support only OID as LDAP. You need to set up OID and use a product like DIRXML to propagate updates from Novell to OID. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:34 PM Hi, We are in the preliminary analysis of implementing an assurance package (Sunguard's Compass) based on Oracle (Oracle 9.2.04, Oracle 9iAS Web Services and Forms on AIX 5.2). We are using Novell eDirectory as our LDAP. I looked on Metalink but did not find much thing. The way I understand it is that you must load the LDAP info into Oracle Internet Directory. Am I right ? Anybody using Novell eDirectory integrated with Oracle ? TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 poste 7470 [EMAIL PROTECTED] -- 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: 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).
Antw: CLONE db
on metalink check: Doc ID: 212346.1 kr mr [EMAIL PROTECTED] 12/09 1:04 Hi, I have hotbackup for x date.I want to create clone to another box on Linux(Oracle9i). is it possible to clone with same instance name on diffrent box with diffrent file location?I think yes. Can someone send me correct steps how to clone on linux box? Thx -Seema _ Get holiday tips for festive fun. http://special.msn.com/network/happyholidays.armx -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Antw: Re: Oracle and Novell eDirectory LDAP
we use some java plugins for novell to contct ldap for authentication. used more than two years - no problems. BUT: we taylored it to our needs - and do NOT use OID at all. kr mr [EMAIL PROTECTED] 12/09 9:59 IIRC Oracle is going to support only OID as LDAP. You need to set up OID and use a product like DIRXML to propagate updates from Novell to OID. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:34 PM Hi, We are in the preliminary analysis of implementing an assurance package (Sunguard's Compass) based on Oracle (Oracle 9.2.04, Oracle 9iAS Web Services and Forms on AIX 5.2). We are using Novell eDirectory as our LDAP. I looked on Metalink but did not find much thing. The way I understand it is that you must load the LDAP info into Oracle Internet Directory. Am I right ? Anybody using Novell eDirectory integrated with Oracle ? TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 poste 7470 [EMAIL PROTECTED] -- 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Client (9.2.0.4)
Hi, I find the information concerning upgrading to Oracle 9.2.0.4 on the server and upgrading to ODP.NET 9.2.0.4.01 on the client a little confusing. Se readme for patchset nr 3262475 The upgrade on the server to 9.2.0.4 is ok and the upgrade on the client is no problem. But should you install the ODP.NET also on the server or is this only a client install? Furthermore, Does Oracle Client (9.2.0.4) exists? The ODP.NET 9.2.0.4.01 includes only Oracle Client 9.2.0.1 and I can't find 9.2.0.4 anywhere. It is mentioned but I can't find It. I would be delighted if someone could explain to me how this installations should be done. We have a Windows Plattform, both on the server and the client. Regards Anders Bengtsson -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anders Bengtsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Antwort: OpenLDAP instead of OID
Hi folks, here is the requested paper. Mit freundlichen Grüßen Andreas Teich dawaConprise GmbH c/o Investitionsbank Berlin Informationstechnologie Spichernstrasse 2 10777 Berlin Tel.: 030/2125-2513 Fax: 030/2125-2534 In UNIX Land On a quiet Night, you can hear the Windows machines reboot. Mladen Gogala [EMAIL PROTECTED] Gesendet von: [EMAIL PROTECTED] 09.12.2003 06:19 Bitte antworten an ORACLE-L An:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopie: Thema:OpenLDAP instead of OID Stefan Jahnke and Denis Williams have recently posted recipe for replacing OiD with OpenLDAP. The road runner page is no longer accessible. Does anybody have a copy? If so, please publish the location, because I'm trying it right now. Please, if anybody has that page, post it again or forward it privately. Thanks in advance. The message I'm talking about is below. -- Mladen Gogala Oracle DBA -Original Message- DENNIS WILLIAMS Sent: Monday, August 18, 2003 11:30 PM To: Multiple recipients of list ORACLE-L 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, include a line containing: UNSUB ORACLE-L (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
Re: Re: Oracle and Novell eDirectory LDAP
You are talking about Novell using LDAP. I am talking about Oracle using LDAP, especially with enterprise user. I was told that version 9i or 10g will support only OID as LDAP. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 1:54 PM we use some java plugins for novell to contct ldap for authentication. used more than two years - no problems. BUT: we taylored it to our needs - and do NOT use OID at all. kr mr [EMAIL PROTECTED] 12/09 9:59 IIRC Oracle is going to support only OID as LDAP. You need to set up OID and use a product like DIRXML to propagate updates from Novell to OID. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:34 PM Hi, We are in the preliminary analysis of implementing an assurance package (Sunguard's Compass) based on Oracle (Oracle 9.2.04, Oracle 9iAS Web Services and Forms on AIX 5.2). We are using Novell eDirectory as our LDAP. I looked on Metalink but did not find much thing. The way I understand it is that you must load the LDAP info into Oracle Internet Directory. Am I right ? Anybody using Novell eDirectory integrated with Oracle ? TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 poste 7470 [EMAIL PROTECTED] -- 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: A brief detour....;-)
I am just glad that so many on this read /. too ... that's my homepage ... on my Firebird browser. 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- Bobak, Mark Sent: Tuesday, December 09, 2003 12:54 AM To: Multiple recipients of list ORACLE-L Vladimir, Nice solution! I had first briefly considered a SQL solution, but it didn't immediately come to mind, and the PL/SQL recursive solution was pretty straightforward, so, I went that direction. I wasn't really too concerned about expense, in this case;-) I don't see too many practical applications. ;-) -Mark -Original Message- From: Vladimir Begun [mailto:[EMAIL PROTECTED] Sent: Mon 12/8/2003 8:19 PM To: Multiple recipients of list ORACLE-L Cc: Subject:Re: A brief detour;-) Bobak, Mark wrote: Here it is: [...] This concludes this public service announcement. We now return you to our regularly scheduled programming. Interesting. PL/SQL recursive solutions are expensive, though. :) Did not check it, maybe something alike was posted already... SET VERIFY OFF PAGES 200 DEFINE disks=7 REM Please do not use all_objects :) DEFINE big_table=all_objects COLUMN Implementation Plan FORMAT A20 SPOOL hanoi_solution.txt SELECT 'Move it from ' || TO_CHAR(MOD(BITAND(ROWNUM, ROWNUM - 1), 3) + 1) || ' to ' || TO_CHAR(MOD(-BITAND(-ROWNUM - 1, -ROWNUM), 3) + 1) AS Implementation Plan FROM big_table WHERE ROWNUM POWER(2, disks) AND disks 8 / SPOOL OFF Should work correctly. Regards, -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **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).
RE: dc_used_extents ,dc_free_extents and dc_histogram_defs
and what they don't tell you that there are 3000 undocumented parameters because they are undocumented. As one finds all bugs (or should I say easter eggs) in our code, we will tell them one by one to you. 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: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Monday, December 08, 2003 4:14 PMTo: Multiple recipients of list ORACLE-LSubject: Re: dc_used_extents ,dc_free_extents and dc_histogram_defs 10g has about 30 "basic" parameters such are db_name andsga_target, a real bunch of "advanced" parameters and the rest are undocumented parameters. So, the marketing people can already say you got less than 100 tunable params.. Tanel. **This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**4
RE: Database management techniques and frameworks
Orr, Steve scribbled on the wall in glitter crayon: I'm not assuming such a tool exists... It indeed does exist because the salesman who happened to be selling it said so and it must be of course it does, and they'll install it for you because they can install and tune it EXACTLY THE SAME WAY for every installation. so see you don't need your DBA any more, just install the whiz-bang tool and follow the bouncing prompt and all you troubles will be far away. until it shows red for some reason and nobody can find out why. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] ..one of the strongest motives that lead men to art and science is escape from everyday life with its painful crudity and hopeless dreariness, from the fetters of one's own ever-shifting desires. A finely tempered nature longs to escape from the personal life into the world of objective perception and thought. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OS calls with java stored procedures
Im playing with the example in tom kytes book. we have alot of korn shell scripts that we use as functions. We 'echo' out values to standard out. is there anyway to catch this echo with a java stored procedure? I thought about redirecting it to a file and reading it in with utl_file, but that makes it more complex. any other way to do this? -- 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).
RE: dc_used_extents ,dc_free_extents and dc_histogram_defs
-Original Message-From: Denny Koovakattu [mailto:[EMAIL PROTECTED]Sent: Monday, December 08, 2003 10:14 PMTo: Multiple recipients of list ORACLE-LSubject: Re: dc_used_extents ,dc_free_extents and dc_histogram_defs And how do you join one ?Denny[Shrek] you have to be specially honored by theGreat and Powerful Larry.;-) at least i think so because every time i tried to join, they never even replied.;-) -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] Knowing others is Wisdom, knowing yourself is Enlightenment. - LaoTzu
two oracle pl/sql programmers needed (50k/yr)
please send an email to me,if you're interested. _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OS calls with java stored procedures
I'm working from memory here, but there is a procedure in a built-in package, I think it is DBMS_JAVA, that redirects standard output from a Java Stored Procedure to the same buffer that DBMS_OUTPUT uses. You call this procedure, then your Java method, and then you can SET SERVEROUTPUT ON to see the output in SQL*Plus or you can read it with DBMS_OUTPUT.GET and DBMS_OUTPUT.GET_LINE. -Original Message- Sent: Tuesday, December 09, 2003 8:35 AM To: Multiple recipients of list ORACLE-L Im playing with the example in tom kytes book. we have alot of korn shell scripts that we use as functions. We 'echo' out values to standard out. is there anyway to catch this echo with a java stored procedure? I thought about redirecting it to a file and reading it in with utl_file, but that makes it more complex. any other way to do this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Antw: Re: Re: Oracle and Novell eDirectory LDAP
what we have is an novell ldap with jave plugins used by oracle IAS to authenticate users. we started once with OID but stayed then with novell. check it for yourself - http://mdwis.mdw.ac.at/ - we had to run a config script that allows us to use the novell ldap instead of OID. I don't know this config script by heart. later on I wrote a separate authentication routine to identify against novall ldap. but we decided not to use it since we found a configuration that did the job for us. hope this helps. further details must be dug out - if allowed to disclose. kr mr [EMAIL PROTECTED] 12/09 1:54 You are talking about Novell using LDAP. I am talking about Oracle using LDAP, especially with enterprise user. I was told that version 9i or 10g will support only OID as LDAP. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 1:54 PM we use some java plugins for novell to contct ldap for authentication. used more than two years - no problems. BUT: we taylored it to our needs - and do NOT use OID at all. kr mr [EMAIL PROTECTED] 12/09 9:59 IIRC Oracle is going to support only OID as LDAP. You need to set up OID and use a product like DIRXML to propagate updates from Novell to OID. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:34 PM Hi, We are in the preliminary analysis of implementing an assurance package (Sunguard's Compass) based on Oracle (Oracle 9.2.04, Oracle 9iAS Web Services and Forms on AIX 5.2). We are using Novell eDirectory as our LDAP. I looked on Metalink but did not find much thing. The way I understand it is that you must load the LDAP info into Oracle Internet Directory. Am I right ? Anybody using Novell eDirectory integrated with Oracle ? TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 poste 7470 [EMAIL PROTECTED] -- 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California
RE: migrate 8.1.7 to 9.2.0
Hey Bambi - how are ya girl. It is and I changed by oratab to use the 9.2.0 OFA home. I am thinking perhaps that ##$$%% LD_LIBRARY_PATH again. -Original Message- Bellow, Bambi Sent: Monday, December 08, 2003 5:59 PM To: Multiple recipients of list ORACLE-L Make sure your ORACLE_SID and ORACLE_HOME are set. -Original Message- [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:34 PM To: Multiple recipients of list ORACLE-L Guys, I am working through a manual migration from 8i to 9i on Solaris 2.8. I am using the guide in Note: 159657.1. I shutdown the 8.1.7 database, copied network and init files - then run sqlplus / as sysdba or sqlplus /nolog connect sys/jfjfj as sysdba I get ORA-12545: Connect failed because target host or object does not exist. What target host - what object I had to change domain name and set ORA_NLS33 if that matters?? I can't find anything on Metastink that seems relevant although a great deal of stuff on this error code. Help. -- 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: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [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).
Antw: Antwort: OpenLDAP instead of OID
requires an external link. this one doesn't work. mr [EMAIL PROTECTED] 12/09 1:54 Hi folks, here is the requested paper. Mit freundlichen Grüßen Andreas Teich dawaConprise GmbH c/o Investitionsbank Berlin Informationstechnologie Spichernstrasse 2 10777 Berlin Tel.: 030/2125-2513 Fax:030/2125-2534 In UNIX Land On a quiet Night, you can hear the Windows machines reboot. Mladen Gogala [EMAIL PROTECTED] Gesendet von: [EMAIL PROTECTED] 09.12.2003 06:19 Bitte antworten an ORACLE-L An: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopie: Thema: OpenLDAP instead of OID Stefan Jahnke and Denis Williams have recently posted recipe for replacing OiD with OpenLDAP. The road runner page is no longer accessible. Does anybody have a copy? If so, please publish the location, because I'm trying it right now. Please, if anybody has that page, post it again or forward it privately. Thanks in advance. The message I'm talking about is below. -- Mladen Gogala Oracle DBA -Original Message- DENNIS WILLIAMS Sent: Monday, August 18, 2003 11:30 PM To: Multiple recipients of list ORACLE-L 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, include a line containing: UNSUB ORACLE-L (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
RE: OS calls with java stored procedures
ummm ... something like system('`my_code`'); --- check there are backticks ... Not sure if it will run, but hey ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Tuesday, December 09, 2003 8:35 AM To: Multiple recipients of list ORACLE-L Im playing with the example in tom kytes book. we have alot of korn shell scripts that we use as functions. We 'echo' out values to standard out. is there anyway to catch this echo with a java stored procedure? I thought about redirecting it to a file and reading it in with utl_file, but that makes it more complex. any other way to do this? ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: two oracle pl/sql programmers needed (50k/yr)
System Manager: Where are these positions located geographically? Me - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 7:44 AM please send an email to me,if you're interested. _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
leaf node 90-10 splits
Hi! I wonder why does statistic leaf node 90-10 splits imply that right-hand index leaf block is split as 90-10, not 100-0 as it really is. (tested on 9.2.0.4 W2k). Historical reasons? 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).
RE: OpenLDAP instead of OID
Dear All, I have emailed to Jeff and his link is back up. Kind Regards, Hatzistavrou Yannis -Original Message- Sent: Tuesday, December 09, 2003 7:19 AM To: Multiple recipients of list ORACLE-L Stefan Jahnke and Denis Williams have recently posted recipe for replacing OiD with OpenLDAP. The road runner page is no longer accessible. Does anybody have a copy? If so, please publish the location, because I'm trying it right now. Please, if anybody has that page, post it again or forward it privately. Thanks in advance. The message I'm talking about is below. -- Mladen Gogala Oracle DBA -Original Message- DENNIS WILLIAMS Sent: Monday, August 18, 2003 11:30 PM To: Multiple recipients of list ORACLE-L 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, include a line containing: UNSUB ORACLE-L (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
Re: dc_used_extents ,dc_free_extents and dc_histogram_defs
I believe that we should start using Postgres or MySQL, not to infringe on oracle secrets. After all, those secrets must be mighty precious when they're protecting them from their own customers. I believe that the whole thing is about giving consultants time to master oracle 10 before releasing it, and then start exerting pressure to migrate, so the chosen few will skim some dough. This is a radical departure from oracle behavior until now, where the software was available for testing and learning long before it was suitable for production. This relative openmindedness of the Oracle Corp. was one of the reasons that Oracle has become so popular. Some bright marketing talent decided it should change and I really do not intend to go with the flow. Fortunately, there are other databases and oracle's behavior is motivating me to start giving them serious considerations. If nobody was using oracle, their secrets would be perfectly safe. On 12/09/2003 08:34:27 AM, Thater, William wrote: -Original Message- Sent: Monday, December 08, 2003 10:14 PM To: Multiple recipients of list ORACLE-L And how do you join one ? Denny [Shrek] you have to be specially honored by the Great and Powerful Larry.;-) at least i think so because every time i tried to join, they never even replied.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Knowing others is Wisdom, knowing yourself is Enlightenment. - LaoTzu 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).
RE: Antw: Re: Re: Oracle and Novell eDirectory LDAP
Markus - Do you use Novell instead of tnsnames.ora as well as authenticating users? We use MS AD. Any insights as to how your method could be applied to MS AD? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 7:54 AM To: Multiple recipients of list ORACLE-L what we have is an novell ldap with jave plugins used by oracle IAS to authenticate users. we started once with OID but stayed then with novell. check it for yourself - http://mdwis.mdw.ac.at/ - we had to run a config script that allows us to use the novell ldap instead of OID. I don't know this config script by heart. later on I wrote a separate authentication routine to identify against novall ldap. but we decided not to use it since we found a configuration that did the job for us. hope this helps. further details must be dug out - if allowed to disclose. kr mr [EMAIL PROTECTED] 12/09 1:54 You are talking about Novell using LDAP. I am talking about Oracle using LDAP, especially with enterprise user. I was told that version 9i or 10g will support only OID as LDAP. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 1:54 PM we use some java plugins for novell to contct ldap for authentication. used more than two years - no problems. BUT: we taylored it to our needs - and do NOT use OID at all. kr mr [EMAIL PROTECTED] 12/09 9:59 IIRC Oracle is going to support only OID as LDAP. You need to set up OID and use a product like DIRXML to propagate updates from Novell to OID. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:34 PM Hi, We are in the preliminary analysis of implementing an assurance package (Sunguard's Compass) based on Oracle (Oracle 9.2.04, Oracle 9iAS Web Services and Forms on AIX 5.2). We are using Novell eDirectory as our LDAP. I looked on Metalink but did not find much thing. The way I understand it is that you must load the LDAP info into Oracle Internet Directory. Am I right ? Anybody using Novell eDirectory integrated with Oracle ? TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 poste 7470 [EMAIL PROTECTED] -- 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Re: OpenLDAP instead of OID
Thanks! I've saved the HTML locally. Thanks again! On 12/09/2003 09:39:25 AM, Hatzistavrou John wrote: Dear All, I have emailed to Jeff and his link is back up. Kind Regards, Hatzistavrou Yannis -Original Message- Sent: Tuesday, December 09, 2003 7:19 AM To: Multiple recipients of list ORACLE-L Stefan Jahnke and Denis Williams have recently posted recipe for replacing OiD with OpenLDAP. The road runner page is no longer accessible. Does anybody have a copy? If so, please publish the location, because I'm trying it right now. Please, if anybody has that page, post it again or forward it privately. Thanks in advance. The message I'm talking about is below. -- Mladen Gogala Oracle DBA -Original Message- DENNIS WILLIAMS Sent: Monday, August 18, 2003 11:30 PM To: Multiple recipients of list ORACLE-L 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, include a line containing: UNSUB ORACLE-L (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
RE: rebuilding indexes - sure to cause a ruckus
This message's a keeper! Thanks! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Monday, December 08, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Hi Yong, Saying there are a few errors is being a little kind to Don's Inside Oracle Indexing article. [truncate drop storage] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OpenLDAP instead of OID
We had some issues here with OpenLDAP. So we went with SunOne instead, which is still free for low usage (100K LDAP entries). AFAIK, perfect uptime and replication in the past year or so... Just another option to consider... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Monday, December 08, 2003 11:19 PM To: Multiple recipients of list ORACLE-L Stefan Jahnke and Denis Williams have recently posted recipe for replacing OiD with OpenLDAP. The road runner page is no longer accessible. Does anybody have a copy? If so, please publish the location, because I'm trying it right now. Please, if anybody has that page, post it again or forward it privately. Thanks in advance. The message I'm talking about is below. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OpenLDAP instead of OID
Mladen - Glad your issue is resolved. In the interest of accuracy, this Dennis Williams hasn't looked at OpenLDAP. Our network guys think MS AD is where it's at and I'm hoping someone will figure out how to get Oracle working with MS AD. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Thanks! I've saved the HTML locally. Thanks again! On 12/09/2003 09:39:25 AM, Hatzistavrou John wrote: Dear All, I have emailed to Jeff and his link is back up. Kind Regards, Hatzistavrou Yannis -Original Message- Sent: Tuesday, December 09, 2003 7:19 AM To: Multiple recipients of list ORACLE-L Stefan Jahnke and Denis Williams have recently posted recipe for replacing OiD with OpenLDAP. The road runner page is no longer accessible. Does anybody have a copy? If so, please publish the location, because I'm trying it right now. Please, if anybody has that page, post it again or forward it privately. Thanks in advance. The message I'm talking about is below. -- Mladen Gogala Oracle DBA -Original Message- DENNIS WILLIAMS Sent: Monday, August 18, 2003 11:30 PM To: Multiple recipients of list ORACLE-L 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, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
RE: Database management techniques and frameworks
Makes me remember the story I was told about damagement running around telling users to log off because the latches are red ;) -- Denny Koovakattu Quoting Thater, William [EMAIL PROTECTED]: Orr, Steve scribbled on the wall in glitter crayon: I'm not assuming such a tool exists... It indeed does exist because the salesman who happened to be selling it said so and it must be of course it does, and they'll install it for you because they can install and tune it EXACTLY THE SAME WAY for every installation. so see you don't need your DBA any more, just install the whiz-bang tool and follow the bouncing prompt and all you troubles will be far away. until it shows red for some reason and nobody can find out why. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] ..one of the strongest motives that lead men to art and science is escape from everyday life with its painful crudity and hopeless dreariness, from the fetters of one's own ever-shifting desires. A finely tempered nature longs to escape from the personal life into the world of objective perception and thought. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This message was sent using IMP, the Internet Messaging Program. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denny Koovakattu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: A brief detour....;-)
Hate to say this but you are a bit late. I had my students at University and here at Compuware create three to four different versions of the Tower's of Hanoi solution in PL/SQL. Used PL/SQL tables, stack processing, recursion (yes it can be done), and others. I also had (yep had - lost this) one for both PL/I and TSO/CLIST Dialog Manager VMS DCL. I actually created screens where you could dynamically choose the number of pegs and pieces. It also verified that you were putting smaller pieces on top of larger ones (one of the core rules for Tof H). Isn't programming great? Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Bobak, Mark Sent: Monday, December 08, 2003 4:19 PM To: Multiple recipients of list ORACLE-L Subject:A brief detour;-) So, I saw on SlashDot (http://www.slashdot.org/) a story about a guy who has over 100 different implementations of the Towers of Hanoi solution, each in a different language. Since he didn't have one in PL/SQL, I decided to write one. Here it is: create or replace package hanoi is from_peg constant number := 1; to_pegconstant number := 3; using_peg constant number := 2; procedure play(n number); end hanoi; / create or replace package body hanoi is procedure do_hanoi(n number, from_peg number, to_peg number, using_peg number) is begin if(n 0) then do_hanoi(n-1,from_peg, using_peg, to_peg); dbms_output.put_line('move '||from_peg||' -- '||to_peg); do_hanoi(n-1, using_peg, to_peg, from_peg); end if; end; procedure play(n number) is begin do_hanoi(n, from_peg, to_peg, using_peg); end; end; / This concludes this public service announcement. We now return you to our regularly scheduled programming. -Mark PS Yes, it's a slow day;-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: A brief detour....;-)
Is there any for windows command shell? :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 5:24 PM Hate to say this but you are a bit late. I had my students at University and here at Compuware create three to four different versions of the Tower's of Hanoi solution in PL/SQL. Used PL/SQL tables, stack processing, recursion (yes it can be done), and others. I also had (yep had - lost this) one for both PL/I and TSO/CLIST Dialog Manager VMS DCL. I actually created screens where you could dynamically choose the number of pegs and pieces. It also verified that you were putting smaller pieces on top of larger ones (one of the core rules for Tof H). Isn't programming great? Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- Bobak, Mark Sent: Monday, December 08, 2003 4:19 PM To: Multiple recipients of list ORACLE-L Subject: A brief detour;-) So, I saw on SlashDot (http://www.slashdot.org/) a story about a guy who has over 100 different implementations of the Towers of Hanoi solution, each in a different language. Since he didn't have one in PL/SQL, I decided to write one. Here it is: create or replace package hanoi is from_peg constant number := 1; to_pegconstant number := 3; using_peg constant number := 2; procedure play(n number); end hanoi; / create or replace package body hanoi is procedure do_hanoi(n number, from_peg number, to_peg number, using_peg number) is begin if(n 0) then do_hanoi(n-1,from_peg, using_peg, to_peg); dbms_output.put_line('move '||from_peg||' -- '||to_peg); do_hanoi(n-1, using_peg, to_peg, from_peg); end if; end; procedure play(n number) is begin do_hanoi(n, from_peg, to_peg, using_peg); end; end; / This concludes this public service announcement. We now return you to our regularly scheduled programming. -Mark PS Yes, it's a slow day;-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
On Partitions
We have a data warehouse around 850gb. I have a question on procedure. We only keep 2 months data in several groupings by month, with 3 months ready.. So, say Nov is in M1 and Dec is in M2. At the end of December, we will create an empty January which will go back into M1 and we will be tuncating and dropping November. Question, we can hold empty months, so we could split the empty partitions early? Now when it comes time to split the December partition and create the slot for January in M1, will that clobber the statistics in the December partition and will they need to be created again? Would there be anything to gain by creating January in M1 when December in M2 is empty? We are fortunate that the loads are one big load, then analyze like December when the time comes. Then there should be no more activity except reading. So once loaded and we analyze the partition for December, and if we had ALREADY split out January BEFORE that loading, do the stats stay consistent for the December partition and it does NOT have to analyzed once again? Or since we split out January and this split cause no records to leave the December partition because they have not been loaded yet, is this nothing to worry about? Thanks. -- Maks 13308 Thornridge Ct Midlothian, VA 23112 804-744-1545 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OpenLDAP instead of OID
Then I have to apologize to each and every Dennis Williams for slanderous allegations. It wasn't my intention to hurt any Dennis Williams. On 12/09/2003 10:14:25 AM, DENNIS WILLIAMS wrote: Mladen - Glad your issue is resolved. In the interest of accuracy, this Dennis Williams hasn't looked at OpenLDAP. Our network guys think MS AD is where it's at and I'm hoping someone will figure out how to get Oracle working with MS AD. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Thanks! I've saved the HTML locally. Thanks again! On 12/09/2003 09:39:25 AM, Hatzistavrou John wrote: Dear All, I have emailed to Jeff and his link is back up. Kind Regards, Hatzistavrou Yannis -Original Message- Sent: Tuesday, December 09, 2003 7:19 AM To: Multiple recipients of list ORACLE-L Stefan Jahnke and Denis Williams have recently posted recipe for replacing OiD with OpenLDAP. The road runner page is no longer accessible. Does anybody have a copy? If so, please publish the location, because I'm trying it right now. Please, if anybody has that page, post it again or forward it privately. Thanks in advance. The message I'm talking about is below. -- Mladen Gogala Oracle DBA -Original Message- DENNIS WILLIAMS Sent: Monday, August 18, 2003 11:30 PM To: Multiple recipients of list ORACLE-L 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
Re: A brief detour....;-)
You are bringing up old memories. I had both PL/1 and assembler (IBM mainframe) in the early 70's. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 5:24 PM Hate to say this but you are a bit late. I had my students at University and here at Compuware create three to four different versions of the Tower's of Hanoi solution in PL/SQL. Used PL/SQL tables, stack processing, recursion (yes it can be done), and others. I also had (yep had - lost this) one for both PL/I and TSO/CLIST Dialog Manager VMS DCL. I actually created screens where you could dynamically choose the number of pegs and pieces. It also verified that you were putting smaller pieces on top of larger ones (one of the core rules for Tof H). Isn't programming great? Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- Bobak, Mark Sent: Monday, December 08, 2003 4:19 PM To: Multiple recipients of list ORACLE-L Subject: A brief detour;-) So, I saw on SlashDot (http://www.slashdot.org/) a story about a guy who has over 100 different implementations of the Towers of Hanoi solution, each in a different language. Since he didn't have one in PL/SQL, I decided to write one. Here it is: create or replace package hanoi is from_peg constant number := 1; to_pegconstant number := 3; using_peg constant number := 2; procedure play(n number); end hanoi; / create or replace package body hanoi is procedure do_hanoi(n number, from_peg number, to_peg number, using_peg number) is begin if(n 0) then do_hanoi(n-1,from_peg, using_peg, to_peg); dbms_output.put_line('move '||from_peg||' -- '||to_peg); do_hanoi(n-1, using_peg, to_peg, from_peg); end if; end; procedure play(n number) is begin do_hanoi(n, from_peg, to_peg, using_peg); end; end; / This concludes this public service announcement. We now return you to our regularly scheduled programming. -Mark PS Yes, it's a slow day;-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Re: Database management techniques and frameworks
Serves them right for not using mauve database, which, as everybody knows, uses the least RAM. On 12/09/2003 10:24:27 AM, Denny Koovakattu wrote: Makes me remember the story I was told about damagement running around telling users to log off because the latches are red ;) -- Denny Koovakattu Quoting Thater, William [EMAIL PROTECTED]: Orr, Steve scribbled on the wall in glitter crayon: I'm not assuming such a tool exists... It indeed does exist because the salesman who happened to be selling it said so and it must be of course it does, and they'll install it for you because they can install and tune it EXACTLY THE SAME WAY for every installation. so see you don't need your DBA any more, just install the whiz-bang tool and follow the bouncing prompt and all you troubles will be far away. until it shows red for some reason and nobody can find out why. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] ..one of the strongest motives that lead men to art and science is escape from everyday life with its painful crudity and hopeless dreariness, from the fetters of one's own ever-shifting desires. A finely tempered nature longs to escape from the personal life into the world of objective perception and thought. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This message was sent using IMP, the Internet Messaging Program. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denny Koovakattu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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).
RE: A brief detour....;-)
I used to have a macro for VI but have lost it. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Tuesday, December 09, 2003 10:25 AM To: Multiple recipients of list ORACLE-L Hate to say this but you are a bit late. I had my students at University and here at Compuware create three to four different versions of the Tower's of Hanoi solution in PL/SQL. Used PL/SQL tables, stack processing, recursion (yes it can be done), and others. I also had (yep had - lost this) one for both PL/I and TSO/CLIST Dialog Manager VMS DCL. I actually created screens where you could dynamically choose the number of pegs and pieces. It also verified that you were putting smaller pieces on top of larger ones (one of the core rules for Tof H). Isn't programming great? ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
dropping materialized view
Hi, I have a serious problem in dropping a snapshot/mview I cannot find whatever constraint is blocking this. Any advice is appreciated SQL drop snapshot deca.mediums; drop snapshot deca.mediums * ERROR at line 1: ORA-02449: unique/primary keys in table referenced by foreign keys SQL drop materialized view deca.mediums; drop materialized view deca.mediums * ERROR at line 1: ORA-02449: unique/primary keys in table referenced by foreign keys SQL SELECT * FROM dba_constraints where table_name = 'MEDIUMS'; no rows selected I get the samen results when dropping as owner and as sys Details: Oracle 9.2.0.4 HP-UX11.11 Tnx, Jeroen
RE: Antw: Re: Re: Oracle and Novell eDirectory LDAP
NO - not instead of tnsnames.ora. We stuck to the tnsnames.ora files. We had it once, but this was rather tricky to get it working at that time. Especially the uploading of certificates thet we made ourselves ... - but we had already a solution to update the OID on a daily/hourly basis for user authentication. We then decided not to use/need it, because we only need IAS authentication for users who have an NOVELL account - about thousand people like employees, students, parttimers... MS AD: we don't have it. may I propose: you need an interface or procedure - possibly java or even c. Then configure ORACLE to use this procedure, and update e.g. on an hourly basis. You must make up your mind who (MS or OID) administers - esp changes - passwords. kr MR [EMAIL PROTECTED] 12/09 3:59 Markus - Do you use Novell instead of tnsnames.ora as well as authenticating users? We use MS AD. Any insights as to how your method could be applied to MS AD? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 7:54 AM To: Multiple recipients of list ORACLE-L what we have is an novell ldap with jave plugins used by oracle IAS to authenticate users. we started once with OID but stayed then with novell. check it for yourself - http://mdwis.mdw.ac.at/ - we had to run a config script that allows us to use the novell ldap instead of OID. I don't know this config script by heart. later on I wrote a separate authentication routine to identify against novall ldap. but we decided not to use it since we found a configuration that did the job for us. hope this helps. further details must be dug out - if allowed to disclose. kr mr [EMAIL PROTECTED] 12/09 1:54 You are talking about Novell using LDAP. I am talking about Oracle using LDAP, especially with enterprise user. I was told that version 9i or 10g will support only OID as LDAP. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 1:54 PM we use some java plugins for novell to contct ldap for authentication. used more than two years - no problems. BUT: we taylored it to our needs - and do NOT use OID at all. kr mr [EMAIL PROTECTED] 12/09 9:59 IIRC Oracle is going to support only OID as LDAP. You need to set up OID and use a product like DIRXML to propagate updates from Novell to OID. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:34 PM Hi, We are in the preliminary analysis of implementing an assurance package (Sunguard's Compass) based on Oracle (Oracle 9.2.04, Oracle 9iAS Web Services and Forms on AIX 5.2). We are using Novell eDirectory as our LDAP. I looked on Metalink but did not find much thing. The way I understand it is that you must load the LDAP info into Oracle Internet Directory. Am I right ? Anybody using Novell eDirectory integrated with Oracle ? TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 poste 7470 [EMAIL PROTECTED] -- 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message
RE: dc_used_extents ,dc_free_extents and dc_histogram_defs
8 snip 8 Well, I think part of the problem is a perception (how valid it is I don't think I'm in a position to say, but the perception certainly exists) that allowing access to the code too early simply provides ammunition for competitors to be far more prepared than we'd like them to be. :) 8 pins 8 And hackers... Oh, wait, never mind. Oracle is UNBREAKABLE! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rebuilding indexes - sure to cause a ruckus
Richard's explanation and example from c.d.o.s now has a permanent tinyurl link ... http://tinyurl.com/yflq if anyone is interested ... this might be better for bookmarks. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Monday, December 08, 2003 4:29 PM To: Multiple recipients of list ORACLE-L Hi Yong, Saying there are a few errors is being a little kind to Don's Inside Oracle Indexing article. [ rest snipped ] ** 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).
RE: Antw: Re: Re: Oracle and Novell eDirectory LDAP
Markus - Thanks for your ideas. Basically our issue isn't Oracle logins, but Oracle connections (replacing tnsnames.ora). For us, the user doesn't directly log into Oracle, but the application handles the login for them. However, I was searching for an alternative to maintaining tnsnames.ora on each client. I considered the Oracle Names server, but Oracle has announced this is going away in favor of OID. But my network guys favor MS AD. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 10:09 AM To: Multiple recipients of list ORACLE-L NO - not instead of tnsnames.ora. We stuck to the tnsnames.ora files. We had it once, but this was rather tricky to get it working at that time. Especially the uploading of certificates thet we made ourselves ... - but we had already a solution to update the OID on a daily/hourly basis for user authentication. We then decided not to use/need it, because we only need IAS authentication for users who have an NOVELL account - about thousand people like employees, students, parttimers... MS AD: we don't have it. may I propose: you need an interface or procedure - possibly java or even c. Then configure ORACLE to use this procedure, and update e.g. on an hourly basis. You must make up your mind who (MS or OID) administers - esp changes - passwords. kr MR [EMAIL PROTECTED] 12/09 3:59 Markus - Do you use Novell instead of tnsnames.ora as well as authenticating users? We use MS AD. Any insights as to how your method could be applied to MS AD? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 7:54 AM To: Multiple recipients of list ORACLE-L what we have is an novell ldap with jave plugins used by oracle IAS to authenticate users. we started once with OID but stayed then with novell. check it for yourself - http://mdwis.mdw.ac.at/ - we had to run a config script that allows us to use the novell ldap instead of OID. I don't know this config script by heart. later on I wrote a separate authentication routine to identify against novall ldap. but we decided not to use it since we found a configuration that did the job for us. hope this helps. further details must be dug out - if allowed to disclose. kr mr [EMAIL PROTECTED] 12/09 1:54 You are talking about Novell using LDAP. I am talking about Oracle using LDAP, especially with enterprise user. I was told that version 9i or 10g will support only OID as LDAP. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 1:54 PM we use some java plugins for novell to contct ldap for authentication. used more than two years - no problems. BUT: we taylored it to our needs - and do NOT use OID at all. kr mr [EMAIL PROTECTED] 12/09 9:59 IIRC Oracle is going to support only OID as LDAP. You need to set up OID and use a product like DIRXML to propagate updates from Novell to OID. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:34 PM Hi, We are in the preliminary analysis of implementing an assurance package (Sunguard's Compass) based on Oracle (Oracle 9.2.04, Oracle 9iAS Web Services and Forms on AIX 5.2). We are using Novell eDirectory as our LDAP. I looked on Metalink but did not find much thing. The way I understand it is that you must load the LDAP info into Oracle Internet Directory. Am I right ? Anybody using Novell eDirectory integrated with Oracle ? TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 poste 7470 [EMAIL PROTECTED] -- 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: 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
Re: dropping materialized view
Please try this select table_name, constraint_name from all_constraints where r_constraint_name in ( select constraint_name from all_constraints where table_name = 'MEDIUMS') it should give you the table_name constraint names that are not allowing you to drop your table. You will have to disable these constraints before dropping your table mediums. Mohammed Shakir --- Jeroen van Sluisdam [EMAIL PROTECTED] wrote: Hi, I have a serious problem in dropping a snapshot/mview I cannot find whatever constraint is blocking this. Any advice is appreciated SQL drop snapshot deca.mediums; drop snapshot deca.mediums * ERROR at line 1: ORA-02449: unique/primary keys in table referenced by foreign keys SQL drop materialized view deca.mediums; drop materialized view deca.mediums * ERROR at line 1: ORA-02449: unique/primary keys in table referenced by foreign keys SQL SELECT * FROM dba_constraints where table_name = 'MEDIUMS'; no rows selected I get the samen results when dropping as owner and as sys Details: Oracle 9.2.0.4 HP-UX11.11 Tnx, Jeroen = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: rebuilding indexes - sure to cause a ruckus
What sort of Oak Table member are you, Richard? Any Oak Table member worth their weight in toilet paper would certainly execute DBMS_POWERNAP part way through, but the strong cup of coffee definitely needs a large shot of whiskey substituted for it! :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Richard Foote Sent: Tuesday, December 09, 2003 7:35 PM To: Multiple recipients of list ORACLE-L Hi Tanel, I recommend a strong cup of coffee and a small nap 1/2 way through ;) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 7:44 AM Ouch, I gotta take a day off to read this one ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dc_used_extents ,dc_free_extents and dc_histogram_defs
That perception came into being quite recently. I believe that Oracle Corp. should change that perception and they need our help to do so. As I've said before, if nobody was using oracle, their secrets would be perfectly safe, just as Ingres or dBase IV secrets are. Graveyard is full of companies whose secrets are safe. On 12/09/2003 11:34:25 AM, Bellow, Bambi wrote: 8 snip 8 Well, I think part of the problem is a perception (how valid it is I don't think I'm in a position to say, but the perception certainly exists) that allowing access to the code too early simply provides ammunition for competitors to be far more prepared than we'd like them to be. :) 8 pins 8 And hackers... Oh, wait, never mind. Oracle is UNBREAKABLE! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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).
RE: dc_used_extents ,dc_free_extents and dc_histogram_defs
No no. That's the rings of Saturn made of lost airline luggage, discarded accordions, and now secrets. I think microchannel bus is up there. -Original Message- Graveyard is full of companies whose secrets are safe. -- 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).
Oracle AS 10g
Has been posted for HP/UX and Solaris on OTN. http://otn.oracle.com/software/products/ias/devuse.html I don't see Windows in their certification matrix, but they mention Red Hat linux 2.1. No SuSE. http://otn.oracle.com/software/products/ias/files/as-certification-904.html Maybe they will update this later. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sequences and cursors
hi here are the specs of my db: version 8.1.7 on windows,open_cursors=500 i am facing a certain issue. we have a few sessions running out of cursor(ora-1000) and i used 1000 event to dump trace on these sessions. i found a certain statement select seq.nextval from dual; being repeated more than 350 times of the available 500 cursors. the dev say nothing has changed nor has there been a increase in the load. can you please advise me whther this could be a issue or am i missing something here thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sai Selvaganesan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dc_used_extents ,dc_free_extents and dc_histogram_defs
There was an announcement on the OTN, but nobody replied to email. When reading this list, I get impression that quite a few people were able to get the software so far and that the shroud of secrecy over the whole thing is maintained in order for them to gain advantage over the rest of customers. Anyway, Christmas is almost here. When do the rest us, not so important customers, get to see 10g? Speaking of Mogens, I believe that he has 10g. Whatever the intention was, it was a marketing blunder. As a customer, I'm less then happy with the impossibility of getting to know 10g despite the multitude of materials posted about it. I even tried to get 10g CDs from my oracle sales rep. but the guy conveniently forgets everything about it whenever he talks to me. Who knows, may be after reading this the marketing guys decide to put out a limited production version? Prolonging the hype would not serve any useful purpose, except may be, to further annoy your customers. On 12/09/2003 12:14:25 PM, Pete Sharman wrote: Generally, the announcements are made at events like OracleWorld, through OTN and so forth that the beta program is open. Depending on the release, the program may not even get announced unless it's big enough. IIRC, the beta program for 9.2 was open to only a small number of customers and wasn't announced to the world at large, whereas the 10g program was announced (again IIRC - it's 4 am for me and I haven't had my first coffee yet!) at OracleWorld in San Fran in September? Of course, there are some companies that are almost always invited to join the beta program for the database because of the type of customer they are and the type of work they do - customers like Amazon, for example, may fall into that category. Customers like Mogens definitely don't. :-) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Denny Koovakattu Sent: Tuesday, December 09, 2003 2:14 PM To: Multiple recipients of list ORACLE-L And how do you join one ? Denny Pete Sharman wrote: Well, you could have joined the beta program if you were THAT interested, Mladen! Ducks and runs. :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Mladen Gogala Sent: Tuesday, December 09, 2003 6:59 AM To: Multiple recipients of list ORACLE-L Larry Ellison has publicly stated that his goal is to produce a database with less then 100 tunable parameters. Allegedly, he came rather close with 10g. As far as 10g is concerned, I'm rather disappointed with the marketing hype being created with oracle not making an early version available. I don't plan on migrating to 10g until I learn it well and if some oracle sales guy tries to exert pressure on me to migrate, he will get a very stable sign used by English archers after the battle at Agincourt to signify that they still have all the fingers needed to operate a longbow. I've had my fill of white papers and articles and now I want to see the software. On 12/08/2003 02:24:33 PM, [EMAIL PROTECTED] wrote: .. And there used to be all these dc_ parameters that one could set, giving the dba control over the dictionary cache, which was not a part of the shared pool. And then came Oracle V7, with the shared_pool_size, wresting that control. Regards Mladen Gogala [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] ading.com cc: Sent by: Subject: Re: dc_used_extents ,dc_free_extents and dc_histogram_defs [EMAIL PROTECTED] ity.com 12/08/2003 01:29 PM Please respond to ORACLE-L Well, once upon a time, in a land far, far away, there was Oracle V6 with something called TPO, which was essentially row locking + PL/SQL V1 (no stored procedures). My guess is that Cary Millsap, Anjo Kolk, Steve Feuerstein and Howard Rogers know a thing or two about the Jurassic period in the database development. BTW, that was also when buffer hit ratio was invented. The entries that you see are remnants from oracle v6, together with the table called V$ROWCACHE and are both religiously maintained for the compatibility reasons, because Oracle Corp. doesn't want to disappoint
Re: A brief detour....;-)
Bobak, Mark wrote: Nice solution! I had first briefly considered a SQL solution, but it didn't I like simple ones. immediately come to mind, and the PL/SQL recursive solution was pretty straightforward, so, I went that direction. I wasn't really too concerned about expense, in this case;-) I don't see too many practical applications. ;-) I did not want to discuss this particular case. It's a good one. Good as an example. There was/is a practical application of recursive solution ( 9i) -- check standard.replace which is not so nice if it's heavily used. regards, -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: can't see a SQL generated by Crystal Report
I'm not sure. I'm talking to the application team to see what exactly is being done behind the scene. I do know that I can't capture queries running via ColdFusion server and thought that there may be something like that with Crystal. Gene --- Yechiel Adar [EMAIL PROTECTED] wrote: Are you sure that Crystal does not do any local processing on the data? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 12:39 AM Hi all: I'm trying to catch a DDL generated by Crystal report. I'm using the following query to do that: select sql_text from v$sqltext where ( address, hash_value ) in (select sql_address, sql_hash_value from v$session where username = UPPER('username')) order by piece I am catching a SQL, but that SQL returns different amount of rows than the report when executed through a Crystal. Is there something wrong with my query (it is running under Oracle 817) that makes it miss some data? thanks Gene __ 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: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: rebuilding indexes - sure to cause a ruckus
Thanks, Richard. I'll read your long message more carefully later. I like your statement that rebuilding an index or not is not rocket science. One needs to measure the performance before and after the rebuild and make a conclusion himself. Many times we discuss performance issues and get very technical and sophisticated, without showing experimental results! Having been a science researcher before, I'd like to emphasize that facts speak louder than theories. There may be 10,000 24x7 databases in the world that don't easily allow even testing an index rebuild. But there may be 100 times more production databases in the world that are not 24x7. The individual DBA needs to do his control study and conclude, using experts' opinions as reference. Yong Huang __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dropping materialized view
select table_name, constraint_name from all_constraints where r_constraint_name in ( select constraint_name from all_constraints where table_name = 'SNAP$_MEDIUMS') -Oorspronkelijk bericht- Mohammed, Thanks for your reaction but this doesn't help. I think table must be snap$_mediums and when I issue your query I get: TABLE_NAME CONSTRAINT_NAMESTATUS -- -- DEBTOR_CLAIM_COMPONENTSFK_DCC_MEDIUMS DISABLED I even tried disabling all constraints. I tried removing the view Through enterprise manager, it looked ok because it doesn't show there Anymore but in the dictionary it does. I tried set constraints all deferred; drop table snap$_mediums; alter table snap$_mediums drop primary key all do not seem to work, I am starting to think I have somehow corrupted the dictionary. I hope you can shed some light on this Regards, Jeroen Van: Mohammed Shakir [mailto:[EMAIL PROTECTED] Verzonden: dinsdag 9 december 2003 17:59 Aan: Multiple recipients of list ORACLE-L Onderwerp: Re: dropping materialized view Please try this select table_name, constraint_name from all_constraints where r_constraint_name in ( select constraint_name from all_constraints where table_name = 'MEDIUMS') it should give you the table_name constraint names that are not allowing you to drop your table. You will have to disable these constraints before dropping your table mediums. Mohammed Shakir --- Jeroen van Sluisdam [EMAIL PROTECTED] wrote: Hi, I have a serious problem in dropping a snapshot/mview I cannot find whatever constraint is blocking this. Any advice is appreciated SQL drop snapshot deca.mediums; drop snapshot deca.mediums * ERROR at line 1: ORA-02449: unique/primary keys in table referenced by foreign keys SQL drop materialized view deca.mediums; drop materialized view deca.mediums * ERROR at line 1: ORA-02449: unique/primary keys in table referenced by foreign keys SQL SELECT * FROM dba_constraints where table_name = 'MEDIUMS'; no rows selected I get the samen results when dropping as owner and as sys Details: Oracle 9.2.0.4 HP-UX11.11 Tnx, Jeroen = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: A brief detour....;-)
My memories of PL/1 are more unusual - I programmed a pre-CPM Z80 based machine in its own dialect of PL/1 in the late 70s early 80s. -Original Message- Sent: Tuesday, December 09, 2003 10:49 AM To: Multiple recipients of list ORACLE-L You are bringing up old memories. I had both PL/1 and assembler (IBM mainframe) in the early 70's. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dc_used_extents ,dc_free_extents and dc_histogram_defs
Well, as you'd suspect I don't have any control over these sorts of decisions! I didn't actually see the announcement on OTN, so I'm not sure who the email would have gone to. There was a way Oracle employees could invite customers to be part of the beta program, sp presumably your sales rep didn't think you were important enough to be on the program. ;) Seriously, before Jared tells us to take this conversation offline, let me make a couple of final points on this: 1. From Oracle's perspective, the beta program is an enormous amount of work, and requires a lot of ongoing management of the customers involved. For that reason, the beta program is not really designed to be open to everyone. 2. If you think you really have a valid interest in being on the beta program for future releases and are prepared to put in the work that's involved with the beta program (logging bugs, testing new functionality and so on), let me know and I can send you information on how to join future beta programs as they occur. Since the beta proposals are actually voted on, a compelling case will help with actually getting on the beta program. 3. If you are simply interested in playing with the new features, rather than seriously stress testing them, then I probably can't help you. Decisions on early adopter sorts of programs that are set up to handle people who want to play are beyond my level at Oracle. As for Mogens, I know he's on the beta program. I got him there, along with a few of the other Oakies. It was a suggestion I came up with because if we can get people like Mogens, Cary, Jonathan and Steve (who are the four I suggested to Development) to say what a wonderful product 10g is, then that's a really telling statement. I'm not sure that any of them have said it yet, though! :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Mladen Gogala Sent: Wednesday, December 10, 2003 5:40 AM To: Multiple recipients of list ORACLE-L There was an announcement on the OTN, but nobody replied to email. When reading this list, I get impression that quite a few people were able to get the software so far and that the shroud of secrecy over the whole thing is maintained in order for them to gain advantage over the rest of customers. Anyway, Christmas is almost here. When do the rest us, not so important customers, get to see 10g? Speaking of Mogens, I believe that he has 10g. Whatever the intention was, it was a marketing blunder. As a customer, I'm less then happy with the impossibility of getting to know 10g despite the multitude of materials posted about it. I even tried to get 10g CDs from my oracle sales rep. but the guy conveniently forgets everything about it whenever he talks to me. Who knows, may be after reading this the marketing guys decide to put out a limited production version? Prolonging the hype would not serve any useful purpose, except may be, to further annoy your customers. On 12/09/2003 12:14:25 PM, Pete Sharman wrote: Generally, the announcements are made at events like OracleWorld, through OTN and so forth that the beta program is open. Depending on the release, the program may not even get announced unless it's big enough. IIRC, the beta program for 9.2 was open to only a small number of customers and wasn't announced to the world at large, whereas the 10g program was announced (again IIRC - it's 4 am for me and I haven't had my first coffee yet!) at OracleWorld in San Fran in September? Of course, there are some companies that are almost always invited to join the beta program for the database because of the type of customer they are and the type of work they do - customers like Amazon, for example, may fall into that category. Customers like Mogens definitely don't. :-) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Denny Koovakattu Sent: Tuesday, December 09, 2003 2:14 PM To: Multiple recipients of list ORACLE-L And how do you join one ? Denny Pete Sharman wrote: Well, you could have joined the beta program if you were THAT interested, Mladen! Ducks and runs. :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Mladen Gogala Sent: Tuesday, December 09, 2003 6:59 AM To: Multiple recipients of list ORACLE-L Larry Ellison has publicly stated that his goal is to produce a database with less then 100 tunable parameters. Allegedly, he came rather close with 10g. As far as 10g is concerned, I'm rather disappointed with the marketing hype being created with oracle not
RE: PERL?
I don't think any UNIX shell has some package or module written for any database. So the only way to talk to Oracle is using shell as a wrapper around sqlplus (or any application you developed). In sqlplus, you can use bind variables easily. In this sense, we can say shell does allow you to use bind variables. Speaking of Perl versus shell, Perl may still be quite primitive in supporting two-way communication with an external program e.g. sqlplus. (I have an example at www.stormloader.com/yonghuang/computer/OracleAndPerl.html#2waytosqlplus using IPC::Open2). But I think a KornShell coprocess (not a here document) does it nicely, i.e. piping a SQL command in and reading the result back, piping another command in, reading again, without exiting your sqlplus session. If you use Perl DBI (or the old OraPerl), Jared may know this but I'm not sure if you can send any arbitary SQL command such as explain plan, shutdown... and read its output. Yong Huang One BIG advantage of Perl is DBI. Via shell you can't use bind variables which sometimes come in handy. An admin dweeb here developed a __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: can't see a SQL generated by Crystal Report
I happen to know that you have to work hard to keep Crystal from doing a SELECT * and doing its own filtering and grouping. It can be done, but you have to KNOW that that is what you want to do, i.e. novices will let Crystal do what it wants. -Original Message- Sent: Tuesday, December 09, 2003 1:45 PM To: Multiple recipients of list ORACLE-L I'm not sure. I'm talking to the application team to see what exactly is being done behind the scene. I do know that I can't capture queries running via ColdFusion server and thought that there may be something like that with Crystal. Gene --- Yechiel Adar [EMAIL PROTECTED] wrote: Are you sure that Crystal does not do any local processing on the data? Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Data Guard
Jumbo frames are new to me. The Ethernet Definitive Guide book says it was proposed by one vendor and adopted by several, so may not have good interoperability. But I wonder how much performance improvement there is by going from MTU 1500 with SDU 8k to MTU 8k with SDU 8k. I assume the lower the OSI level, the faster assembling and disassembling those protocol data units is done. Yong Huang With TCP over standard ethernet the maximum transfer unit (MTU) is about 1500 bytes, this means if you want to send 2000 bytes over network, you have to fragment it in 2 packets and send them separately. This means double packet headers, double latency etc. Jumbo frames is a capability of some Gbit ethernet cards which allow them to transfer about 9000 bytes in a single packet. SDU is session level transfer unit (session data unit). When you enable jumbo frames and set MTU/SDU to 8192 for example, you'll fit much more in single packet, thus increasing performance for larger transactions. __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dropping materialized view
Disabling constraint (when you want to drop the parent table) will not help. This should help: Alter table DEBTOR_CLAIM_COMPONENTS drop constraint FK_DCC_MEDIUMS. After this you should be able to drop MV. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Jeroen van Sluisdam Sent: Tuesday, December 09, 2003 2:40 PM To: Multiple recipients of list ORACLE-L select table_name, constraint_name from all_constraints where r_constraint_name in ( select constraint_name from all_constraints where table_name = 'SNAP$_MEDIUMS') -Oorspronkelijk bericht- Mohammed, Thanks for your reaction but this doesn't help. I think table must be snap$_mediums and when I issue your query I get: TABLE_NAME CONSTRAINT_NAMESTATUS -- -- DEBTOR_CLAIM_COMPONENTSFK_DCC_MEDIUMS DISABLED I even tried disabling all constraints. I tried removing the view Through enterprise manager, it looked ok because it doesn't show there Anymore but in the dictionary it does. I tried set constraints all deferred; drop table snap$_mediums; alter table snap$_mediums drop primary key all do not seem to work, I am starting to think I have somehow corrupted the dictionary. I hope you can shed some light on this Regards, Jeroen Van: Mohammed Shakir [mailto:[EMAIL PROTECTED] Verzonden: dinsdag 9 december 2003 17:59 Aan: Multiple recipients of list ORACLE-L Onderwerp: Re: dropping materialized view Please try this select table_name, constraint_name from all_constraints where r_constraint_name in ( select constraint_name from all_constraints where table_name = 'MEDIUMS') it should give you the table_name constraint names that are not allowing you to drop your table. You will have to disable these constraints before dropping your table mediums. Mohammed Shakir --- Jeroen van Sluisdam [EMAIL PROTECTED] wrote: Hi, I have a serious problem in dropping a snapshot/mview I cannot find whatever constraint is blocking this. Any advice is appreciated SQL drop snapshot deca.mediums; drop snapshot deca.mediums * ERROR at line 1: ORA-02449: unique/primary keys in table referenced by foreign keys SQL drop materialized view deca.mediums; drop materialized view deca.mediums * ERROR at line 1: ORA-02449: unique/primary keys in table referenced by foreign keys SQL SELECT * FROM dba_constraints where table_name = 'MEDIUMS'; no rows selected I get the samen results when dropping as owner and as sys Details: Oracle 9.2.0.4 HP-UX11.11 Tnx, Jeroen = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Re: sequences and cursors
What tool are you using? HAve you considered putting select from the sequence in an explicit cursor, open it, fetch it and close it again? What Have in mind is something like this: declare cursor csr is select sai.nextval from dual; num integer :=0; ind integer :=10; begin while (ind=0) loop open csr; fetch csr into num; close csr; dbms_output.put_line('Sai is:'||num); ind:=ind-1; end loop; end; / Here is the output: QL / Sai is:13 Sai is:14 Sai is:15 Sai is:16 Sai is:17 Sai is:18 Sai is:19 Sai is:20 Sai is:21 Sai is:22 Sai is:23 PL/SQL procedure successfully completed. On 12/09/2003 01:39:25 PM, Sai Selvaganesan wrote: hi here are the specs of my db: version 8.1.7 on windows,open_cursors=500 i am facing a certain issue. we have a few sessions running out of cursor(ora-1000) and i used 1000 event to dump trace on these sessions. i found a certain statement select seq.nextval from dual; being repeated more than 350 times of the available 500 cursors. the dev say nothing has changed nor has there been a increase in the load. can you please advise me whther this could be a issue or am i missing something here thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sai Selvaganesan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Windows clustering???
I'm guessing they're not running Oracle on this VMS cluster. I really liked the part about the most difficult part was explaining to managers why it was unnecessary to shut systems down, even during the physical relocation. http://www.theinquirer.net/?article=13002 Imagine if DEC had any marketing... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Data Guard
Hi All, I am working on a similar project here. I am wondering if anyone in the list ever compared Oracle Data Guard with iReflect from Data Mirror. Please share your experience with us. Thanks, Kitty -Original Message- Sent: Monday, December 08, 2003 6:54 PM To: Multiple recipients of list ORACLE-L Hi Carel, What if 50% of tables doesn't have Primary/Unique keys, how it is going be with LSB then? Can you please explain more. with thanks, Vi --- Carel-Jan Engel [EMAIL PROTECTED] wrote: Comments inline At 14:54 8-12-03 -0800, you wrote: Hi Carel, That is good help, can you please send me the pdf that you implemented there then. Was on its way already Tell me one thing I agree that we some times (rather most of the time ) generate less redo so we should be smooth. Can you tell me is there any releation between LSB and Primary keys, I read like LCR(logical Change Request) is based on Primary keys as It does not depends on Transaction at that time. Because LSB 'reverse engineers' SQL from the redolog info, it needs to get hold of the right rows. The rows get inserted/updated/deleted, and _a_ unique identification, not being the rowid, is required. So, every row needs to be uniquely identified. Have you implemnented LSB successfully? Yes, using a PSB / LSB combination for standby and reporting purposes respectively. with many thanks, Vi. --- Carel-Jan Engel [EMAIL PROTECTED] wrote: Comments inline At 13:34 8-12-03 -0800, you wrote: Hi Tanel, Much appreciated, The fact is I am interested in Logical standby rather than physical. Our 30-50% of our Production data needs to be replicated to another database and where they will have their processing and batches. It all depends on the amount of redolog you generate. When that's pretty much, you waste some resources by transporting online/archived redologs you actually don't need. Now We didn't go to Snapshot because It is on multiple tables (where we didnot have PK's and many tables) and due to performance issue I didn't want to use Snapshots (they did not want any tables to be truncate before being loaded even via snapshots). So, they don't like nologging operations like truncate, not even on the standby database? The best option I think is Logical Standby Database. Or Can you please suggest me any other means. Replication should be quicker like once in every 20 minutes, Even Transportable tablespacs does not work here since they need all tables to 24*7. LSB might work, but do not consider the option of failing over to it. Be aware that, altough in maximum protection mode your redolog arrives at the SB system within the transaction, it doesn't get applied there instantly. SQL Application takes place _after_ the log-switch on the Primary. When you take 10 minutes of redolog, and perform a logswitch, the SQL Apply process might even take longer than 10 minutes to complete processing of the redologfile. There is a risk that not every transaction arrives within 20 minutes at the LSB. So, your log-switching frequency and the amount of redo you generate per unit of time both play a major role in the refresh rate of the LSB. I'll send you the PDF of a DG Special I did in Kista a few months ago. Regards, Carel-Jan -- There will allwasy be another 10 last bugs -- Any suggestion would be more helpful. with thanks, Vi. --- Tanel Poder [EMAIL PROTECTED] wrote: Hi All, can any one let me know kindly the following info. 1) Has any one used the Oracle 9i Data Guard? Yes, physical standby and successfully. 2) If yes then, is there any performance impact on Target/Source server database. Your database has to be in archivelog mode, but when you are thinking such solutions as DG, then you probably are already running archivelog anyway. If you run in maximum protection or maximum availability, yes there is. The impact depends mainly on network connection between primary and standby(s) and the speed of redolog disks. You could tune these by using faster network, enabling jumbo frames and SDU size if using Gbit ethernet, also setting lgwr and log apply processes priority higher than others. 3) any drawbacks using Data Guard. You should set your database or critical tablespaces to force logging mode in order to transfer all changes to standby in physical standby. That means, performance improvements which take advantage of nologging operations (such insert append nologging
RE: dropping materialized view
Oops I feel very stupid, thanks a lot Igor this did the tric. Regards Jeroen -Oorspronkelijk bericht- Van: Igor Neyman [mailto:[EMAIL PROTECTED] Verzonden: dinsdag 9 december 2003 21:09 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: dropping materialized view Disabling constraint (when you want to drop the parent table) will not help. This should help: Alter table DEBTOR_CLAIM_COMPONENTS drop constraint FK_DCC_MEDIUMS. After this you should be able to drop MV. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Jeroen van Sluisdam Sent: Tuesday, December 09, 2003 2:40 PM To: Multiple recipients of list ORACLE-L select table_name, constraint_name from all_constraints where r_constraint_name in ( select constraint_name from all_constraints where table_name = 'SNAP$_MEDIUMS') -Oorspronkelijk bericht- Mohammed, Thanks for your reaction but this doesn't help. I think table must be snap$_mediums and when I issue your query I get: TABLE_NAME CONSTRAINT_NAMESTATUS -- -- DEBTOR_CLAIM_COMPONENTSFK_DCC_MEDIUMS DISABLED I even tried disabling all constraints. I tried removing the view Through enterprise manager, it looked ok because it doesn't show there Anymore but in the dictionary it does. I tried set constraints all deferred; drop table snap$_mediums; alter table snap$_mediums drop primary key all do not seem to work, I am starting to think I have somehow corrupted the dictionary. I hope you can shed some light on this Regards, Jeroen Van: Mohammed Shakir [mailto:[EMAIL PROTECTED] Verzonden: dinsdag 9 december 2003 17:59 Aan: Multiple recipients of list ORACLE-L Onderwerp: Re: dropping materialized view Please try this select table_name, constraint_name from all_constraints where r_constraint_name in ( select constraint_name from all_constraints where table_name = 'MEDIUMS') it should give you the table_name constraint names that are not allowing you to drop your table. You will have to disable these constraints before dropping your table mediums. Mohammed Shakir --- Jeroen van Sluisdam [EMAIL PROTECTED] wrote: Hi, I have a serious problem in dropping a snapshot/mview I cannot find whatever constraint is blocking this. Any advice is appreciated SQL drop snapshot deca.mediums; drop snapshot deca.mediums * ERROR at line 1: ORA-02449: unique/primary keys in table referenced by foreign keys SQL drop materialized view deca.mediums; drop materialized view deca.mediums * ERROR at line 1: ORA-02449: unique/primary keys in table referenced by foreign keys SQL SELECT * FROM dba_constraints where table_name = 'MEDIUMS'; no rows selected I get the samen results when dropping as owner and as sys Details: Oracle 9.2.0.4 HP-UX11.11 Tnx, Jeroen = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:
Creating the Java System
All, I am attempting to install the Java system in a 9.2 database on Sun Solaris. This is a db that I migrated up to 9.2 from 8.1.7. I am getting the following: SQL create or replace java system 2 / create or replace java system * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 2 ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 11 I get this when I run the initjvm.sql text. Java_Shared_Pool is at 32 M. Thanks for any ideas. 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).
RE: Oracle Data Guard
I have never worked on Network stuff. But is there any easy parameters we could set in sqlnet.ora so that we could increase the DB performance by increase the network transfer rate (without doing anything else)? BTW my sqlnet.ora (on a Sun Box) has only two lines: -- bash-2.03$ more sqlnet.ora # SQLNET.ORA Network Configuration File: /oracle/product/8.1.7/network/admin/sqlnet.ora # Generated by Oracle configuration tools. NAMES.DEFAULT_DOMAIN = incyte.com NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) Guang -Original Message- Yong Huang Sent: Tuesday, December 09, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Jumbo frames are new to me. The Ethernet Definitive Guide book says it was proposed by one vendor and adopted by several, so may not have good interoperability. But I wonder how much performance improvement there is by going from MTU 1500 with SDU 8k to MTU 8k with SDU 8k. I assume the lower the OSI level, the faster assembling and disassembling those protocol data units is done. Yong Huang With TCP over standard ethernet the maximum transfer unit (MTU) is about 1500 bytes, this means if you want to send 2000 bytes over network, you have to fragment it in 2 packets and send them separately. This means double packet headers, double latency etc. Jumbo frames is a capability of some Gbit ethernet cards which allow them to transfer about 9000 bytes in a single packet. SDU is session level transfer unit (session data unit). When you enable jumbo frames and set MTU/SDU to 8192 for example, you'll fit much more in single packet, thus increasing performance for larger transactions. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dropping materialized view
Don't (feel stupid) :) It happens to all of us... Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Jeroen van Sluisdam Sent: Tuesday, December 09, 2003 3:39 PM To: Multiple recipients of list ORACLE-L Oops I feel very stupid, thanks a lot Igor this did the tric. Regards Jeroen -Oorspronkelijk bericht- Van: Igor Neyman [mailto:[EMAIL PROTECTED] Verzonden: dinsdag 9 december 2003 21:09 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: dropping materialized view Disabling constraint (when you want to drop the parent table) will not help. This should help: Alter table DEBTOR_CLAIM_COMPONENTS drop constraint FK_DCC_MEDIUMS. After this you should be able to drop MV. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Jeroen van Sluisdam Sent: Tuesday, December 09, 2003 2:40 PM To: Multiple recipients of list ORACLE-L select table_name, constraint_name from all_constraints where r_constraint_name in ( select constraint_name from all_constraints where table_name = 'SNAP$_MEDIUMS') -Oorspronkelijk bericht- Mohammed, Thanks for your reaction but this doesn't help. I think table must be snap$_mediums and when I issue your query I get: TABLE_NAME CONSTRAINT_NAMESTATUS -- -- DEBTOR_CLAIM_COMPONENTSFK_DCC_MEDIUMS DISABLED I even tried disabling all constraints. I tried removing the view Through enterprise manager, it looked ok because it doesn't show there Anymore but in the dictionary it does. I tried set constraints all deferred; drop table snap$_mediums; alter table snap$_mediums drop primary key all do not seem to work, I am starting to think I have somehow corrupted the dictionary. I hope you can shed some light on this Regards, Jeroen Van: Mohammed Shakir [mailto:[EMAIL PROTECTED] Verzonden: dinsdag 9 december 2003 17:59 Aan: Multiple recipients of list ORACLE-L Onderwerp: Re: dropping materialized view Please try this select table_name, constraint_name from all_constraints where r_constraint_name in ( select constraint_name from all_constraints where table_name = 'MEDIUMS') it should give you the table_name constraint names that are not allowing you to drop your table. You will have to disable these constraints before dropping your table mediums. Mohammed Shakir --- Jeroen van Sluisdam [EMAIL PROTECTED] wrote: Hi, I have a serious problem in dropping a snapshot/mview I cannot find whatever constraint is blocking this. Any advice is appreciated SQL drop snapshot deca.mediums; drop snapshot deca.mediums * ERROR at line 1: ORA-02449: unique/primary keys in table referenced by foreign keys SQL drop materialized view deca.mediums; drop materialized view deca.mediums * ERROR at line 1: ORA-02449: unique/primary keys in table referenced by foreign keys SQL SELECT * FROM dba_constraints where table_name = 'MEDIUMS'; no rows selected I get the samen results when dropping as owner and as sys Details: Oracle 9.2.0.4 HP-UX11.11 Tnx, Jeroen = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Re: Creating the Java System
I would advise full export and then executing create database controlfile reuse datafile.logfile... command before initjvm and everything will work. On 12/09/2003 03:44:26 PM, Mercadante, Thomas F wrote: All, I am attempting to install the Java system in a 9.2 database on Sun Solaris. This is a db that I migrated up to 9.2 from 8.1.7. I am getting the following: SQL create or replace java system 2 / create or replace java system * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 2 ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 11 I get this when I run the initjvm.sql text. Java_Shared_Pool is at 32 M. Thanks for any ideas. 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). 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).
RE: Creating the Java System
gee thanks. where do you live? I'll meet you at your car. I'll be the one with the baseball bat. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 09, 2003 4:09 PM To: Multiple recipients of list ORACLE-L I would advise full export and then executing create database controlfile reuse datafile.logfile... command before initjvm and everything will work. On 12/09/2003 03:44:26 PM, Mercadante, Thomas F wrote: All, I am attempting to install the Java system in a 9.2 database on Sun Solaris. This is a db that I migrated up to 9.2 from 8.1.7. I am getting the following: SQL create or replace java system 2 / create or replace java system * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 2 ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 11 I get this when I run the initjvm.sql text. Java_Shared_Pool is at 32 M. Thanks for any ideas. 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). 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: 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).
RE: PERL?
On Tue, 9 Dec 2003, Yong Huang wrote: Speaking of Perl versus shell, Perl may still be quite primitive in supporting two-way communication with an external program e.g. sqlplus. (I have an example at www.stormloader.com/yonghuang/computer/OracleAndPerl.html#2waytosqlplus using IPC::Open2). But I think a KornShell coprocess (not a here document) does it nicely, i.e. piping a SQL command in and reading the result back, piping another command in, reading again, without exiting your sqlplus session. If you use Perl DBI (or the old OraPerl), Jared may know this but I'm not sure if you can send any arbitary SQL command such as explain plan, shutdown... and read its output. I think Perl with Expect.pm could likely do this without much effort. Expect allows you to interact with just about anything that uses a terminal. One fun case comes to mind. We have this LED sign (think large rectangular array of LEDs), with an undocumented serial interface protocol. All that came with it to control it was this old DOS program which would talk to the sign over a serial port. So I whipped up a Perl script which used Expect to interact with dosemu (a Linux DOS emulator) to run the program, which interacted with the sign, all running on Linux. Works pretty good. Expect.pm is also nice to interact with network hardware that offers telnet/shell command interfaces. Interacting with sqlplus via Expect.pm would be pretty easy as well, I would think. It basically works like this: - Spawn the program you want to interact with - Expect a particular regex of output from the spawned process - Act based on that output (send commands, run processes, annoy the NT admin with net send packets, etc) - Wash, rinse, repeat. -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database management techniques and frameworks
Mladen Gogala wrote: Serves them right for not using mauve database, which, as everybody knows, uses the least RAM. According to my source(taped up in my cubicle), mauve has the most ram. ;) -Brian -- / * Brian Haas[EMAIL PROTECTED] * * Database AdministratorMusician's Friend, Inc.* * Phone:(541)774-5211 http://www.musiciansfriend.com * / -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Haas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Creating the Java System
Try these metalink notes: Oracle Notes 209870.1 149393 pay particular attention to sys_trig_enabled=false HTH, Mike Mercadante, Thomas F [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tate.ny.us cc: Sent by: Subject: RE: Creating the Java System [EMAIL PROTECTED] 12/09/2003 04:19 PM Please respond to ORACLE-L gee thanks. where do you live? I'll meet you at your car. I'll be the one with the baseball bat. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 09, 2003 4:09 PM To: Multiple recipients of list ORACLE-L I would advise full export and then executing create database controlfile reuse datafile.logfile... command before initjvm and everything will work. On 12/09/2003 03:44:26 PM, Mercadante, Thomas F wrote: All, I am attempting to install the Java system in a 9.2 database on Sun Solaris. This is a db that I migrated up to 9.2 from 8.1.7. I am getting the following: SQL create or replace java system 2 / create or replace java system * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 2 ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 11 I get this when I run the initjvm.sql text. Java_Shared_Pool is at 32 M. Thanks for any ideas. 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). 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
RE: Creating the Java System
Thomas, This error seems to vaguely ring a bell. You may try: http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOTp_id=209870.1 Hope that's helpful. -Mark -Original Message- Sent: Tuesday, December 09, 2003 4:19 PM To: Multiple recipients of list ORACLE-L gee thanks. where do you live? I'll meet you at your car. I'll be the one with the baseball bat. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 09, 2003 4:09 PM To: Multiple recipients of list ORACLE-L I would advise full export and then executing create database controlfile reuse datafile.logfile... command before initjvm and everything will work. On 12/09/2003 03:44:26 PM, Mercadante, Thomas F wrote: All, I am attempting to install the Java system in a 9.2 database on Sun Solaris. This is a db that I migrated up to 9.2 from 8.1.7. I am getting the following: SQL create or replace java system 2 / create or replace java system * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 2 ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 11 I get this when I run the initjvm.sql text. Java_Shared_Pool is at 32 M. Thanks for any ideas. 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). 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: 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: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Creating the Java System
Well, if you cannot create or replace Java system, then you have a problem with the data dictionary. The table that is returning too many records is, quite likely, a SYS-owned table. You may beat me to the pulp but I still think that it will probably be necessary to re-create your database. Migration migrates 8i data dictionary to 9i. It is a complicated process and I don't exactly know how it's done, but I know this: if your data dictionary is foobar, you have to recreate the database and use full import. Let me guess: you have quite a few gigabytes to export? Why beat me up because of that? Buy me a pizza, cholesterol will get me sooner or later. On 12/09/2003 04:19:27 PM, Mercadante, Thomas F wrote: gee thanks. where do you live? I'll meet you at your car. I'll be the one with the baseball bat. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 09, 2003 4:09 PM To: Multiple recipients of list ORACLE-L I would advise full export and then executing create database controlfile reuse datafile.logfile... command before initjvm and everything will work. On 12/09/2003 03:44:26 PM, Mercadante, Thomas F wrote: All, I am attempting to install the Java system in a 9.2 database on Sun Solaris. This is a db that I migrated up to 9.2 from 8.1.7. I am getting the following: SQL create or replace java system 2 / create or replace java system * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 2 ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 11 I get this when I run the initjvm.sql text. Java_Shared_Pool is at 32 M. Thanks for any ideas. 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). 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: 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). 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
RE: dc_used_extents ,dc_free_extents and dc_histogram_defs
Pete, Is Mladen bigger than you??? Carel-Jan At 16:44 8-12-03 -0800, you wrote: Well, I think part of the problem is a perception (how valid it is I don't think I'm in a position to say, but the perception certainly exists) that allowing access to the code too early simply provides ammunition for competitors to be far more prepared than we'd like them to be. :) And no apologies needed. Particularly from someone that's bigger than me! :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Mladen Gogala Sent: Tuesday, December 09, 2003 11:29 AM To: Multiple recipients of list ORACLE-L On 2003.12.08 17:24, Pete Sharman wrote: Well, you could have joined the beta program if you were THAT interested, Mladen! I missed the opportunity because I was amid changing jobs. I tried to lay my hands on the software several times since then, to no avail. Ducks and runs. :) No need, Pete. I've always appreciated your advice and expertize. Your posts have been very useful to me on more then one occasion. I am the one to apologize for blowing off some steam, but I must confess, that I don't understand such secrecy, especially not after it has already been announced. -- 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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). DBA!ert, Independent Oracle Consultancy Kastanjelaan 61C 2743 BX Waddinxveen The Netherlands tel. +31 (0) 182 640 428 fax +31 (0) 182 640 429 mobile+31 (0) 653 911 950 e-mail [EMAIL PROTECTED]
Re: Oracle Data Guard
Hi Vi, Rows NEED unique identification. So, if there are bunches of raw data with no unique identifier whatsoever (remember, rowid is not allowed) LSB can't generate a where-clause what row to update or delete on the SB database. It's generating SQL based on redolog info, and has to come up with an UPDATE table SET WHERE unique id = unique id. The unique id may be a multi-column key. There is an escape. Enabling supplemental logging can add extra info to do the unique identification, when no usable keys are available. This will cause some extra logging to be generated, there ain't no such thing as a free lunch. For detailed information read chapter 4.1.5 4.1.6 in the Oracle Data Guard Concepts and Administration manual, part no. A96653-02. regards, Carel-Jan At 15:54 8-12-03 -0800, you wrote: Hi Carel, What if 50% of tables doesn't have Primary/Unique keys, how it is going be with LSB then? Can you please explain more. with thanks, Vi - --- Carel-Jan Engel [EMAIL PROTECTED] wrote: Comments inline At 14:54 8-12-03 -0800, you wrote: Hi Carel, That is good help, can you please send me the pdf that you implemented there then. Was on its way already Tell me one thing I agree that we some times (rather most of the time ) generate less redo so we should be smooth. Can you tell me is there any releation between LSB and Primary keys, I read like LCR(logical Change Request) is based on Primary keys as It does not depends on Transaction at that time. Because LSB 'reverse engineers' SQL from the redolog info, it needs to get hold of the right rows. The rows get inserted/updated/deleted, and _a_ unique identification, not being the rowid, is required. So, every row needs to be uniquely identified. Have you implemnented LSB successfully? Yes, using a PSB / LSB combination for standby and reporting purposes respectively. with many thanks, Vi. --- Carel-Jan Engel [EMAIL PROTECTED] wrote: Comments inline At 13:34 8-12-03 -0800, you wrote: Hi Tanel, Much appreciated, The fact is I am interested in Logical standby rather than physical. Our 30-50% of our Production data needs to be replicated to another database and where they will have their processing and batches. It all depends on the amount of redolog you generate. When that's pretty much, you waste some resources by transporting online/archived redologs you actually don't need. Now We didn't go to Snapshot because It is on multiple tables (where we didnot have PK's and many tables) and due to performance issue I didn't want to use Snapshots (they did not want any tables to be truncate before being loaded even via snapshots). So, they don't like nologging operations like truncate, not even on the standby database? The best option I think is Logical Standby Database. Or Can you please suggest me any other means. Replication should be quicker like once in every 20 minutes, Even Transportable tablespacs does not work here since they need all tables to 24*7. LSB might work, but do not consider the option of failing over to it. Be aware that, altough in maximum protection mode your redolog arrives at the SB system within the transaction, it doesn't get applied there instantly. SQL Application takes place _after_ the log-switch on the Primary. When you take 10 minutes of redolog, and perform a logswitch, the SQL Apply process might even take longer than 10 minutes to complete processing of the redologfile. There is a risk that not every transaction arrives within 20 minutes at the LSB. So, your log-switching frequency and the amount of redo you generate per unit of time both play a major role in the refresh rate of the LSB. I'll send you the PDF of a DG Special I did in Kista a few months ago. Regards, Carel-Jan -- There will allwasy be another 10 last bugs -- Any suggestion would be more helpful. with thanks, Vi. --- Tanel Poder [EMAIL PROTECTED] wrote: Hi All, can any one let me know kindly the following info. 1) Has any one used the Oracle 9i Data Guard? Yes, physical standby and successfully. 2) If yes then, is there any performance impact on Target/Source server database. Your database has to be in archivelog mode, but when you are thinking such solutions as DG, then you probably are already running archivelog anyway. If you run in maximum protection or maximum availability, yes there is. The impact depends mainly on network connection between primary and standby(s) and the speed of redolog disks. You could tune these by using faster network, enabling jumbo frames and SDU size if
RE: A brief detour....;-)
Back in the early 80's at school we had a towers of hanoi running in PL/1 On Nixdorf 8820, a teletype with matrix printer, printing out the full configuration after every move you made Regards, Carel-Jan -- There will always be another 10 last bugs -- At 07:24 9-12-03 -0800, you wrote: Hate to say this but you are a bit late. I had my students at University and here at Compuware create three to four different versions of the Tower's of Hanoi solution in PL/SQL. Used PL/SQL tables, stack processing, recursion (yes it can be done), and others. I also had (yep had - lost this) one for both PL/I and TSO/CLIST Dialog Manager VMS DCL. I actually created screens where you could dynamically choose the number of pegs and pieces. It also verified that you were putting smaller pieces on top of larger ones (one of the core rules for Tof H). Isn't programming great? Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Bobak, Mark Sent: Monday, December 08, 2003 4:19 PM To: Multiple recipients of list ORACLE-L Subject:A brief detour;-) So, I saw on SlashDot (http://www.slashdot.org/) a story about a guy who has over 100 different implementations of the Towers of Hanoi solution, each in a different language. Since he didn't have one in PL/SQL, I decided to write one. Here it is: create or replace package hanoi is from_peg constant number := 1; to_pegconstant number := 3; using_peg constant number := 2; procedure play(n number); end hanoi; / create or replace package body hanoi is procedure do_hanoi(n number, from_peg number, to_peg number, using_peg number) is begin if(n 0) then do_hanoi(n-1,from_peg, using_peg, to_peg); dbms_output.put_line('move '||from_peg||' -- '||to_peg); do_hanoi(n-1, using_peg, to_peg, from_peg); end if; end; procedure play(n number) is begin do_hanoi(n, from_peg, to_peg, using_peg); end; end; / This concludes this public service announcement. We now return you to our regularly scheduled programming. -Mark PS Yes, it's a slow day;-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: PERL?
All *SQL* commands will work work with the DBI. 'SHUTDOWN' is not a SQL command, it is a sqlplus command, and therefor will not work with the DBI. This has been checked into, and Oracle does not make this functionality available via OCI, so shutting down and starting a database on *nix requires sqlplus. Here is one of the few instances where Win32 makes things easier than on *nix: Oracle can be stopped and started via a service, which means you can easily shut it down via the command line, and via the Win32 Perl module Win32::Service. If you want in depth discussion on this check the archives for the dbi-users list. I don't recall where the archives are, but the list is found at lists.perl.org. Jared Yong Huang [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/09/2003 11:54 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: PERL? I don't think any UNIX shell has some package or module written for any database. So the only way to talk to Oracle is using shell as a wrapper around sqlplus (or any application you developed). In sqlplus, you can use bind variables easily. In this sense, we can say shell does allow you to use bind variables. Speaking of Perl versus shell, Perl may still be quite primitive in supporting two-way communication with an external program e.g. sqlplus. (I have an example at www.stormloader.com/yonghuang/computer/OracleAndPerl.html#2waytosqlplus using IPC::Open2). But I think a KornShell coprocess (not a here document) does it nicely, i.e. piping a SQL command in and reading the result back, piping another command in, reading again, without exiting your sqlplus session. If you use Perl DBI (or the old OraPerl), Jared may know this but I'm not sure if you can send any arbitary SQL command such as explain plan, shutdown... and read its output. Yong Huang One BIG advantage of Perl is DBI. Via shell you can't use bind variables which sometimes come in handy. An admin dweeb here developed a __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rebuilding indexes - sure to cause a ruckus
And in case you miss it in Richard's terse message, one of the big reasons that it is not 'rocket science' is that you can perform operations that modify the index(es), and perform block dumps of the index as you go. You can see exactly what Oracle is doing with the index. Jared Yong Huang [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/09/2003 11:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: rebuilding indexes - sure to cause a ruckus Thanks, Richard. I'll read your long message more carefully later. I like your statement that rebuilding an index or not is not rocket science. One needs to measure the performance before and after the rebuild and make a conclusion himself. Many times we discuss performance issues and get very technical and sophisticated, without showing experimental results! Having been a science researcher before, I'd like to emphasize that facts speak louder than theories. There may be 10,000 24x7 databases in the world that don't easily allow even testing an index rebuild. But there may be 100 times more production databases in the world that are not 24x7. The individual DBA needs to do his control study and conclude, using experts' opinions as reference. Yong Huang __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle8i and oracle9i in the same machine
Hi everybody I have been running oracle817 since long time on WindowsNTNow I installed Oracle9i on the same machine and I cannot use both at the same time. How can I resolve this problem regards, Mauricio Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
RE: rebuilding indexes - sure to cause a ruckus
Science is the belief in the ignorance of experts. --Richard Feynman Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Yong Huang Sent: Tuesday, December 09, 2003 1:45 PM To: Multiple recipients of list ORACLE-L Thanks, Richard. I'll read your long message more carefully later. I like your statement that rebuilding an index or not is not rocket science. One needs to measure the performance before and after the rebuild and make a conclusion himself. Many times we discuss performance issues and get very technical and sophisticated, without showing experimental results! Having been a science researcher before, I'd like to emphasize that facts speak louder than theories. There may be 10,000 24x7 databases in the world that don't easily allow even testing an index rebuild. But there may be 100 times more production databases in the world that are not 24x7. The individual DBA needs to do his control study and conclude, using experts' opinions as reference. Yong Huang __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Client (9.2.0.4)
-Original Message- From: Anders Bengtsson [mailto:[EMAIL PROTECTED] Sent: Tuesday, 9 December 2003 23:24 To: Multiple recipients of list ORACLE-L Subject: Oracle Client (9.2.0.4) Hi, I find the information concerning upgrading to Oracle 9.2.0.4 on the server and upgrading to ODP.NET 9.2.0.4.01 on the client a little confusing. Se readme for patchset nr 3262475 The upgrade on the server to 9.2.0.4 is ok and the upgrade on the client is no problem. But should you install the ODP.NET also on the server or is this only a client install? It's a client side driver ... so unless your Oracle server is also running client code requiring ODP.Net, don't install it on the server. If you do need to install it on the server, patch the server to 9.2.0.4 first! If you don't, you'll have copious DLL version mismatches (with missing and invalid entry points), and nothing will start (no instances, nothing (except maybe a listener :-)). Culprits include orageneric.dll, etc. (can you tell I made this mistake myself?). Reinstalling 9.2.0.1 is the only option if you make this mistake (the databases themselves are fine - just a wasted afternoon watching the Oracle installer). The 9.2.0.4 patch for the server is quite painless ... just takes a while to run catupgrade.sql (or whatever it was called). Furthermore, Does Oracle Client (9.2.0.4) exists? The ODP.NET 9.2.0.4.01 includes only Oracle Client 9.2.0.1 and I can't find 9.2.0.4 anywhere. It is mentioned but I can't find It. No, there's no 9.2.0.4 client patch for windows. You can apply the ODP.Net provider directly to a 9.2.0.1 client - though it will prompt you to upgrade the installer to 2.2.0.18 first (a painless exercise). I would be delighted if someone could explain to me how this installations should be done. We have a Windows Plattform, both on the server and the client. Hope that helps, Anders. Ciao Fuzzy :-) -- 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).
RE: rebuilding indexes - sure to cause a ruckus
Shh!! Nonsense! It's all black magic and conjecture! How else are we going to be highly paid Oracle consultants, if everyone knows all this stuff is provable and demonstrable?? ;-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, December 09, 2003 5:15 PMTo: Multiple recipients of list ORACLE-LSubject: Re: rebuilding indexes - sure to cause a ruckusAnd in case you miss it in Richard's terse message, one of the big reasons that it is not 'rocket science' is that you can perform operations that modify the index(es), and perform block dumps of the index as you go. You can see exactly what Oracle is doing with the index. Jared Yong Huang [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/09/2003 11:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: rebuilding indexes - sure to cause a ruckusThanks, Richard. I'll read your long message more carefully later. I like yourstatement that rebuilding an index or not is not rocket science. One needs tomeasure the performance before and after the rebuild and make a conclusionhimself. Many times we discuss performance issues and get very technical andsophisticated, without showing experimental results! Having been a scienceresearcher before, I'd like to emphasize that facts speak louder than theories.There may be 10,000 24x7 databases in the world that don't easily allow eventesting an index rebuild. But there may be 100 times more production databasesin the world that are not 24x7. The individual DBA needs to do his controlstudy and conclude, using experts' opinions as reference.Yong Huang__Do you Yahoo!?New Yahoo! Photos - easier uploading and sharing.http://photos.yahoo.com/-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Yong HuangINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: PERL?
I've written one shell script using the coprocess. I don't like using it. But that's just me. I think one way of describing ksh (for the male readers out there, anyway) is that ksh is like the legally blonde girlfriend: There are times when you wish there was more intelligence there. But she has enough features to satisfy; and she's so easy, you just going back to her. -Original Message- I don't think any UNIX shell has some package or module written for any database. So the only way to talk to Oracle is using shell as a wrapper around sqlplus (or any application you developed). In sqlplus, you can use bind variables easily. In this sense, we can say shell does allow you to use bind variables. Speaking of Perl versus shell, Perl may still be quite primitive in supporting two-way communication with an external program e.g. sqlplus. (I have an example at www.stormloader.com/yonghuang/computer/OracleAndPerl.html#2way tosqlplus using IPC::Open2). But I think a KornShell coprocess (not a here document) does it nicely, i.e. piping a SQL command in and reading the result back, piping another command in, reading again, without exiting your sqlplus session. If you use Perl DBI (or the old OraPerl), Jared may know this but I'm not sure if you can send any arbitary SQL command such as explain plan, shutdown... and read its output. Yong Huang One BIG advantage of Perl is DBI. Via shell you can't use bind variables which sometimes come in handy. An admin dweeb here developed a __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
Documenting databases
Recently our database manager has asked us to do the unthinkable document our databases! To make matters worse, and without our input, he went ahead and created a schema and put it in an Access database (using tables to make it look like a speadsheet). Either we use his idea or come up with something else. So, I thought I'd ask everyone on the list how you do it. Text files? In a database (oracle, or other)? Spreadsheets? What are the pros and cons? Etc Thanks, Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Data Guard
Hi Kitty, Never heard of that, but I'm interested in your experiences, and the architecture of iReflect. The only advantage of Data Guard I can tell you is that it comes for free with your Oracle licences. Regards, Carel-Jan -- There will allways be another 10 last bugs -- At 12:14 9-12-03 -0800, you wrote: Hi All, I am working on a similar project here. I am wondering if anyone in the list ever compared Oracle Data Guard with iReflect from Data Mirror. Please share your experience with us. Thanks, Kitty -Original Message- Sent: Monday, December 08, 2003 6:54 PM To: Multiple recipients of list ORACLE-L Hi Carel, What if 50% of tables doesn't have Primary/Unique keys, how it is going be with LSB then? Can you please explain more. with thanks, Vi --- Carel-Jan Engel [EMAIL PROTECTED] wrote: Comments inline At 14:54 8-12-03 -0800, you wrote: Hi Carel, That is good help, can you please send me the pdf that you implemented there then. Was on its way already Tell me one thing I agree that we some times (rather most of the time ) generate less redo so we should be smooth. Can you tell me is there any releation between LSB and Primary keys, I read like LCR(logical Change Request) is based on Primary keys as It does not depends on Transaction at that time. Because LSB 'reverse engineers' SQL from the redolog info, it needs to get hold of the right rows. The rows get inserted/updated/deleted, and _a_ unique identification, not being the rowid, is required. So, every row needs to be uniquely identified. Have you implemnented LSB successfully? Yes, using a PSB / LSB combination for standby and reporting purposes respectively. with many thanks, Vi. --- Carel-Jan Engel [EMAIL PROTECTED] wrote: Comments inline At 13:34 8-12-03 -0800, you wrote: Hi Tanel, Much appreciated, The fact is I am interested in Logical standby rather than physical. Our 30-50% of our Production data needs to be replicated to another database and where they will have their processing and batches. It all depends on the amount of redolog you generate. When that's pretty much, you waste some resources by transporting online/archived redologs you actually don't need. Now We didn't go to Snapshot because It is on multiple tables (where we didnot have PK's and many tables) and due to performance issue I didn't want to use Snapshots (they did not want any tables to be truncate before being loaded even via snapshots). So, they don't like nologging operations like truncate, not even on the standby database? The best option I think is Logical Standby Database. Or Can you please suggest me any other means. Replication should be quicker like once in every 20 minutes, Even Transportable tablespacs does not work here since they need all tables to 24*7. LSB might work, but do not consider the option of failing over to it. Be aware that, altough in maximum protection mode your redolog arrives at the SB system within the transaction, it doesn't get applied there instantly. SQL Application takes place _after_ the log-switch on the Primary. When you take 10 minutes of redolog, and perform a logswitch, the SQL Apply process might even take longer than 10 minutes to complete processing of the redologfile. There is a risk that not every transaction arrives within 20 minutes at the LSB. So, your log-switching frequency and the amount of redo you generate per unit of time both play a major role in the refresh rate of the LSB. I'll send you the PDF of a DG Special I did in Kista a few months ago. Regards, Carel-Jan -- There will allwasy be another 10 last bugs -- Any suggestion would be more helpful. with thanks, Vi. --- Tanel Poder [EMAIL PROTECTED] wrote: Hi All, can any one let me know kindly the following info. 1) Has any one used the Oracle 9i Data Guard? Yes, physical standby and successfully. 2) If yes then, is there any performance impact on Target/Source server database. Your database has to be in archivelog mode, but when you are thinking such solutions as DG, then you probably are already running archivelog anyway. If you run in maximum protection or maximum availability, yes there is. The impact depends mainly on network connection between primary and standby(s) and the speed of redolog disks. You could tune these by using faster network, enabling jumbo frames and SDU size if using Gbit ethernet, also setting lgwr and log apply processes priority higher than others. 3) any drawbacks using Data Guard.
Re: sequences and cursors
thanks mladen. will give this a shot...again thanks a bunch sai --- Mladen Gogala [EMAIL PROTECTED] wrote: What tool are you using? HAve you considered putting select from the sequence in an explicit cursor, open it, fetch it and close it again? What Have in mind is something like this: declare cursor csr is select sai.nextval from dual; num integer :=0; ind integer :=10; begin while (ind=0) loop open csr; fetch csr into num; close csr; dbms_output.put_line('Sai is:'||num); ind:=ind-1; end loop; end; / Here is the output: QL / Sai is:13 Sai is:14 Sai is:15 Sai is:16 Sai is:17 Sai is:18 Sai is:19 Sai is:20 Sai is:21 Sai is:22 Sai is:23 PL/SQL procedure successfully completed. On 12/09/2003 01:39:25 PM, Sai Selvaganesan wrote: hi here are the specs of my db: version 8.1.7 on windows,open_cursors=500 i am facing a certain issue. we have a few sessions running out of cursor(ora-1000) and i used 1000 event to dump trace on these sessions. i found a certain statement select seq.nextval from dual; being repeated more than 350 times of the available 500 cursors. the dev say nothing has changed nor has there been a increase in the load. can you please advise me whther this could be a issue or am i missing something here thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sai Selvaganesan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sai Selvaganesan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dc_used_extents ,dc_free_extents and dc_histogram_defs
From what I understand, hes even bigger than you! J Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carel-Jan Engel Sent: Wednesday, December 10, 2003 9:00 AM To: Multiple recipients of list ORACLE-L Subject: RE: dc_used_extents ,dc_free_extents and dc_histogram_defs Pete, Is Mladen bigger than you??? Carel-Jan At 16:44 8-12-03 -0800, you wrote: Well, I think part of the problem is a perception (how valid it is I don't think I'm in a position to say, but the perception certainly exists) that allowing access to the code too early simply provides ammunition for competitors to be far more prepared than we'd like them to be. :) And no apologies needed. Particularly from someone that's bigger than me! :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Mladen Gogala Sent: Tuesday, December 09, 2003 11:29 AM To: Multiple recipients of list ORACLE-L On 2003.12.08 17:24, Pete Sharman wrote: Well, you could have joined the beta program if you were THAT interested, Mladen! I missed the opportunity because I was amid changing jobs. I tried to lay my hands on the software several times since then, to no avail. Ducks and runs. :) No need, Pete. I've always appreciated your advice and expertize. Your posts have been very useful to me on more then one occasion. I am the one to apologize for blowing off some steam, but I must confess, that I don't understand such secrecy, especially not after it has already been announced. -- 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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). DBA!ert, Independent Oracle Consultancy Kastanjelaan 61C 2743 BX Waddinxveen The Netherlands tel. +31 (0) 182 640 428 fax +31 (0) 182 640 429 mobile+31 (0) 653 911 950 e-mail [EMAIL PROTECTED]
Re: sequences and cursors
thanks mlade..i will surely give this a shot. can you please tell me whether a sequence creates such issues. as mentioned earlier, the developers claim that no code has changed. im am not able to give any kind of reason for this though the trace shows this statement being called more than 350 times. thanks sai --- Mladen Gogala [EMAIL PROTECTED] wrote: What tool are you using? HAve you considered putting select from the sequence in an explicit cursor, open it, fetch it and close it again? What Have in mind is something like this: declare cursor csr is select sai.nextval from dual; num integer :=0; ind integer :=10; begin while (ind=0) loop open csr; fetch csr into num; close csr; dbms_output.put_line('Sai is:'||num); ind:=ind-1; end loop; end; / Here is the output: QL / Sai is:13 Sai is:14 Sai is:15 Sai is:16 Sai is:17 Sai is:18 Sai is:19 Sai is:20 Sai is:21 Sai is:22 Sai is:23 PL/SQL procedure successfully completed. On 12/09/2003 01:39:25 PM, Sai Selvaganesan wrote: hi here are the specs of my db: version 8.1.7 on windows,open_cursors=500 i am facing a certain issue. we have a few sessions running out of cursor(ora-1000) and i used 1000 event to dump trace on these sessions. i found a certain statement select seq.nextval from dual; being repeated more than 350 times of the available 500 cursors. the dev say nothing has changed nor has there been a increase in the load. can you please advise me whther this could be a issue or am i missing something here thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sai Selvaganesan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sai Selvaganesan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Documenting databases
On Tue, 9 Dec 2003 [EMAIL PROTECTED] wrote: Recently our database manager has asked us to do the unthinkable document our databases! To make matters worse, and without our input, he went ahead and created a schema and put it in an Access database (using tables to make it look like a speadsheet). Either we use his idea or come up with something else. So, I thought I'd ask everyone on the list how you do it. Text files? In a database (oracle, or other)? Spreadsheets? What are the pros and cons? Etc How about in each database itself. COMMENT ON TABLE|COLUMN tab|tab.col IS '...' comes to mind. It's simplistic, yes, but at least you don't have to remember where you put your documentation... HTH, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Oracle8i and oracle9i in the same machine
Some reading. Note:73963.1 on Metalink, which ends with: Further reading --- The Oracle platform specific Windows documentation contains more information on configuring multiple Oracle homes. Please refer to the following manuals: 8i Oracle8i Administrator's Guide for Windows NT 9i Oracle9i Database Getting Started for Windows At 14:29 9-12-03 -0800, you wrote: Hi everybody I have been running oracle817 since long time on WindowsNT Now I installed Oracle9i on the same machine and I cannot use both at the same time. How can I resolve this problem regards, Mauricio Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing Regards, Carel-Jan -- There will allwasy be another 10 last bugs --
RE: dc_used_extents ,dc_free_extents and dc_histogram_defs
Good heavens. Carel-Jan At 14:59 9-12-03 -0800, you wrote: From what I understand, hes even bigger than you! J Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Carel-Jan Engel Sent: Wednesday, December 10, 2003 9:00 AM To: Multiple recipients of list ORACLE-L Subject: RE: dc_used_extents ,dc_free_extents and dc_histogram_defs Pete, Is Mladen bigger than you??? Carel-Jan At 16:44 8-12-03 -0800, you wrote: Well, I think part of the problem is a perception (how valid it is I don't think I'm in a position to say, but the perception certainly exists) that allowing access to the code too early simply provides ammunition for competitors to be far more prepared than we'd like them to be. :) And no apologies needed. Particularly from someone that's bigger than me! :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Mladen Gogala Sent: Tuesday, December 09, 2003 11:29 AM To: Multiple recipients of list ORACLE-L On 2003.12.08 17:24, Pete Sharman wrote: Well, you could have joined the beta program if you were THAT interested, Mladen! I missed the opportunity because I was amid changing jobs. I tried to lay my hands on the software several times since then, to no avail. Ducks and runs. :) No need, Pete. I've always appreciated your advice and expertize. Your posts have been very useful to me on more then one occasion. I am the one to apologize for blowing off some steam, but I must confess, that I don't understand such secrecy, especially not after it has already been announced. -- 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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OS calls with java stored procedures
Yes, it's exec dbms_java.set_output(2000); Richard Ji -Original Message- Sent: Tuesday, December 09, 2003 8:50 AM To: Multiple recipients of list ORACLE-L I'm working from memory here, but there is a procedure in a built-in package, I think it is DBMS_JAVA, that redirects standard output from a Java Stored Procedure to the same buffer that DBMS_OUTPUT uses. You call this procedure, then your Java method, and then you can SET SERVEROUTPUT ON to see the output in SQL*Plus or you can read it with DBMS_OUTPUT.GET and DBMS_OUTPUT.GET_LINE. -Original Message- Sent: Tuesday, December 09, 2003 8:35 AM To: Multiple recipients of list ORACLE-L Im playing with the example in tom kytes book. we have alot of korn shell scripts that we use as functions. We 'echo' out values to standard out. is there anyway to catch this echo with a java stored procedure? I thought about redirecting it to a file and reading it in with utl_file, but that makes it more complex. any other way to do this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Documenting databases
Dan, That's a good idea for documenting structures inside the database. However, my database manager wants more high level info: database name / host, oracle version, listeners, applications that use it, cron job descriptions and times, main schemas and what they are used for, lists of developers names that access the databse, etc... Alan Daniel Hanks [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] c.com cc: Sent by: Subject: Re: Documenting databases [EMAIL PROTECTED] .com 12/09/2003 04:09 PM Please respond to ORACLE-L On Tue, 9 Dec 2003 [EMAIL PROTECTED] wrote: Recently our database manager has asked us to do the unthinkable document our databases! To make matters worse, and without our input, he went ahead and created a schema and put it in an Access database (using tables to make it look like a speadsheet). Either we use his idea or come up with something else. So, I thought I'd ask everyone on the list how you do it. Text files? In a database (oracle, or other)? Spreadsheets? What are the pros and cons? Etc How about in each database itself. COMMENT ON TABLE|COLUMN tab|tab.col IS '...' comes to mind. It's simplistic, yes, but at least you don't have to remember where you put your documentation... HTH, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Documenting databases
I think you can download a software called DataPublisher from AgileInfoSoftware, it will automatically document the database for you. http://www.agileinfosoftware.com/download/products.asp. The output is very impressive. Eric - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 17:49 Recently our database manager has asked us to do the unthinkable document our databases! To make matters worse, and without our input, he went ahead and created a schema and put it in an Access database (using tables to make it look like a speadsheet). Either we use his idea or come up with something else. So, I thought I'd ask everyone on the list how you do it. Text files? In a database (oracle, or other)? Spreadsheets? What are the pros and cons? Etc Thanks, Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] -- 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: Eric King INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Oracle8i and oracle9i in the same machine
This is rather vague. What does I cannot use both at the same time actually mean? I use both on NT 4 sp 6 without a problem. Jared Mauricio V?lez [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/09/2003 02:29 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle8i and oracle9i in the same machine Hi everybody I have been running oracle817 since long time on WindowsNT Now I installed Oracle9i on the same machine and I cannot use both at the same time. How can I resolve this problem regards, Mauricio Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
Re: Creating the Java System
I have been in this situation a couple times. You *can* fix your system so that java can be built successfully. It requires perusal of a few articles on MetaLink, and some persistance. Jared Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/09/2003 01:49 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Creating the Java System Well, if you cannot create or replace Java system, then you have a problem with the data dictionary. The table that is returning too many records is, quite likely, a SYS-owned table. You may beat me to the pulp but I still think that it will probably be necessary to re-create your database. Migration migrates 8i data dictionary to 9i. It is a complicated process and I don't exactly know how it's done, but I know this: if your data dictionary is foobar, you have to recreate the database and use full import. Let me guess: you have quite a few gigabytes to export? Why beat me up because of that? Buy me a pizza, cholesterol will get me sooner or later. On 12/09/2003 04:19:27 PM, Mercadante, Thomas F wrote: gee thanks. where do you live? I'll meet you at your car. I'll be the one with the baseball bat. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 09, 2003 4:09 PM To: Multiple recipients of list ORACLE-L I would advise full export and then executing create database controlfile reuse datafile.logfile... command before initjvm and everything will work. On 12/09/2003 03:44:26 PM, Mercadante, Thomas F wrote: All, I am attempting to install the Java system in a 9.2 database on Sun Solaris. This is a db that I migrated up to 9.2 from 8.1.7. I am getting the following: SQL create or replace java system 2 / create or replace java system * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 2 ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 11 I get this when I run the initjvm.sql text. Java_Shared_Pool is at 32 M. Thanks for any ideas. 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). 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: 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
Re: Documenting databases
The internal stuff can be documented with OraSnap. Just google for it. It's free, detailed, and easy to setup and automate. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/09/2003 03:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Documenting databases Dan, That's a good idea for documenting structures inside the database. However, my database manager wants more high level info: database name / host, oracle version, listeners, applications that use it, cron job descriptions and times, main schemas and what they are used for, lists of developers names that access the databse, etc... Alan Daniel Hanks [EMAIL PROTECTED]To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] c.com cc: Sent by: Subject: Re: Documenting databases [EMAIL PROTECTED] .com 12/09/2003 04:09 PM Please respond to ORACLE-L On Tue, 9 Dec 2003 [EMAIL PROTECTED] wrote: Recently our database manager has asked us to do the unthinkable document our databases! To make matters worse, and without our input, he went ahead and created a schema and put it in an Access database (using tables to make it look like a speadsheet). Either we use his idea or come up with something else. So, I thought I'd ask everyone on the list how you do it. Text files? In a database (oracle, or other)? Spreadsheets? What are the pros and cons? Etc How about in each database itself. COMMENT ON TABLE|COLUMN tab|tab.col IS '...' comes to mind. It's simplistic, yes, but at least you don't have to remember where you put your documentation... HTH, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PERL?
I agree. I once wrote a whole set of functions to run sql and sqlplus scripts directly from the command line. I didn't find it useful enough to continue. And it's rather tricky to program. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/09/2003 02:29 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: PERL? I've written one shell script using the coprocess. I don't like using it. But that's just me. I think one way of describing ksh (for the male readers out there, anyway) is that ksh is like the legally blonde girlfriend: There are times when you wish there was more intelligence there. But she has enough features to satisfy; and she's so easy, you just going back to her. -Original Message- I don't think any UNIX shell has some package or module written for any database. So the only way to talk to Oracle is using shell as a wrapper around sqlplus (or any application you developed). In sqlplus, you can use bind variables easily. In this sense, we can say shell does allow you to use bind variables. Speaking of Perl versus shell, Perl may still be quite primitive in supporting two-way communication with an external program e.g. sqlplus. (I have an example at www.stormloader.com/yonghuang/computer/OracleAndPerl.html#2way tosqlplus using IPC::Open2). But I think a KornShell coprocess (not a here document) does it nicely, i.e. piping a SQL command in and reading the result back, piping another command in, reading again, without exiting your sqlplus session. If you use Perl DBI (or the old OraPerl), Jared may know this but I'm not sure if you can send any arbitary SQL command such as explain plan, shutdown... and read its output. Yong Huang One BIG advantage of Perl is DBI. Via shell you can't use bind variables which sometimes come in handy. An admin dweeb here developed a __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
Re: Documenting databases
Don't know if this has been mentioned or if it does enough of what you're looking for but you can pick up something called RDA (remote diagnostic agent) from Oracle that'll give you an overview of OS setup, Network, performance (very high level), and RDBMS info. And the result is web-a-fied which might please your manager. I forget whether I found this in metalink or technet... Kip |The internal stuff can be documented with OraSnap. |Just google for it. It's free, detailed, and easy to setup and automate. |Jared |[EMAIL PROTECTED] |Sent by: [EMAIL PROTECTED] | 12/09/2003 03:34 PM | Please respond to ORACLE-L |To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] |cc: |Subject:Re: Documenting databases |Dan, |That's a good idea for documenting structures inside the database. |However, my database manager wants more high level info: database name / |host, oracle version, listeners, applications that use it, cron job |descriptions and times, main schemas and what they are used for, lists of |developers names that access the databse, etc... |Alan | Daniel Hanks | [EMAIL PROTECTED]To: Multiple |recipients of list ORACLE-L [EMAIL PROTECTED] | c.com cc: | Sent by: Subject: Re: Documenting |databases | [EMAIL PROTECTED] | .com | 12/09/2003 04:09 | PM | Please respond to | ORACLE-L |On Tue, 9 Dec 2003 [EMAIL PROTECTED] wrote: | Recently our database manager has asked us to do the unthinkable | document our databases! To make matters worse, and without our input, |he | went ahead and created a schema and put it in an Access database (using | tables to make it look like a speadsheet). Either we use his idea or |come | up with something else. | So, I thought I'd ask everyone on the list how you do it. Text |files? | In a database (oracle, or other)? Spreadsheets? What are the pros and | cons? Etc | |How about in each database itself. |COMMENT ON TABLE|COLUMN tab|tab.col IS '...' |comes to mind. It's simplistic, yes, but at least you don't have to |remember where you put your documentation... |HTH, |-- Dan | | Daniel Hanks - Systems/Database Administrator | About Inc., Web Services Division | |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Daniel Hanks | INET: [EMAIL PROTECTED] |Fat City Network Services-- 858-538-5051 http://www.fatcity.com |San Diego, California-- Mailing list and web hosting services |- |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(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). Content-type: text/html; charset=us-ascii brfont size=2 face=sans-serifThe internal stuff can be documented with OraSnap./font br brfont size=2 face=sans-serifJust google for it. nbsp;It's free, detailed, and easy to setup and automate./font br brfont size=2 face=sans-serifJared/font brfont size=2 face=sans-serifbr /font br br br table width=100% tr valign=top td tdfont size=1 face=sans-serifb[EMAIL PROTECTED]/b/font brfont size=1 face=sans-serifSent by: [EMAIL PROTECTED]/font pfont size=1 face=sans-serifnbsp;12/09/2003 03:34 PM/font brfont size=2 face=sans-serifnbsp;/fontfont size=1 face=sans-serifPlease respond to ORACLE-L/font br tdfont size=1 face=Arialnbsp; nbsp; nbsp; nbsp; /font brfont size=1 face=sans-serifnbsp; nbsp; nbsp; nbsp; To: nbsp; nbsp; nbsp; nbsp;Multiple recipients of list ORACLE-L lt;[EMAIL PROTECTED]gt;/font brfont size=1 face=sans-serifnbsp; nbsp; nbsp; nbsp; cc: nbsp; nbsp; nbsp; nbsp;/font brfont size=1 face=sans-serifnbsp; nbsp; nbsp; nbsp; Subject: nbsp; nbsp; nbsp; nbsp;Re: