RE: Dynamic select query
THIS WILL WORK and shud be more efficient than instr() or 'select from dual' SELECT * FROM shipment WHERE ship_name like '%' || ship_id || '%'; Regards Naveen -Original Message- Sent: Tuesday, December 17, 2002 6:44 PM To: Multiple recipients of list ORACLE-L Another way to perform the same task: select * from shipment a where ship_name like (select '%' || a.ship_id || '%' from dual); I wonder how efficient this is compared to using the INSTR() function. Regards, Charu -Original Message- Kevin Sent: Tuesday, December 17, 2002 12:45 PM To: Multiple recipients of list ORACLE-L Try: SQL SELECT * 2FROM shipment 3 WHERE ship_name LIKE '%ABC%'; SHI SHIP_NAME --- -- ABC 1ABC123 DEF ABC1234 GHI 1234ABC K. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 17 December 2002 10:39 To: Multiple recipients of list ORACLE-L Hi all, I have a table by name shipment with two columns say ship_id and ship_name and data as follows: SHIP_ID SHIP_NAME - --- ABC 1ABCLMN XYZ 23XYZ1112 ABB 123LM I want to select all the columns in shipment table which has ship_id as string in the ship_name column. For example, ship_id 'ABC' is present in '1ABCLMN'. So that record should be selected. The ship_id string may start from any position and end at any position in ship_name column. So I cannot use the substr function in this case. How do I write the select clause for this requirement? Any help in this regard is very much appreciated. Thanks and Regards, Ranganath WARNING: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Krishnaswamy, Ranganath INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
RE: Open the password
You can recreate the password file, you can recreate the instance with a different password, and you can also connect from the server machine by simple 'connect internal' in sqlplus. just check the value of ORACLE_SID, it should be pointing to the DB Regards Naveen -Original Message- Sent: Wednesday, December 18, 2002 12:44 PM To: Multiple recipients of list ORACLE-L Dear everyone, I already installed oracle 8i database on my server, to make my system secured I changed my 'INTERNAL' password but I forget to write the changed in my book, and now I can't enter to 'INTERNAL' because I forget the password. Please inform me how to open it again perhaps you have tips and tricks how to solve it. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Open the password
Dear Sony, Make your REMOTE_LOGIN_PASSWORD_FILE in INIT as Exclusive,restart the instance and then change the password of SYS. The password of INTERNAL will also be changed and will be the same as SYS. Best Regards Jai Sony kristanto [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/18/02 12:43 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Open the password Dear everyone, I already installed oracle 8i database on my server, to make my system secured I changed my 'INTERNAL' password but I forget to write the changed in my book, and now I can't enter to 'INTERNAL' because I forget the password. Please inform me how to open it again perhaps you have tips and tricks how to solve it. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Open the password
by the way, don't you use post-it ;-) -Original Message- Sent: Wednesday, December 18, 2002 12:44 PM To: Multiple recipients of list ORACLE-L Dear everyone, I already installed oracle 8i database on my server, to make my system secured I changed my 'INTERNAL' password but I forget to write the changed in my book, and now I can't enter to 'INTERNAL' because I forget the password. Please inform me how to open it again perhaps you have tips and tricks how to solve it. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Online Redifinition in 8i ?
No. You could probably simulate something close with a lot of hard work hth connor --- VIVEK_SHARMA [EMAIL PROTECTED] wrote: Does the Feature Online Redefinition for RE-Organizign Objects , Adding Fields , Converting to Partitioned Table Exist in Oracle 8i ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: export porblem ???
Hi Is it possible you FTP'd the export file across to the new machine in ASCII mode (the default on win systems)? Always ensure you use BINARY mode - the stray LF's get substituted by CRLF's inside the export file and it really messes up the internals and can sometimes the imp utility to skip to the end without reporting an error. Regards Dale - DataBee: Software that creates small referentially correct Oracle test and development environments at the push of a button. http://www.DataBee.com i am exporting a DB of size 10G. it totally has 33 tables. everything completes succesfully and even the log file says EXPORT COMPLETED SUCCESSFULLY WITHOUT ANY WARNING. But while importing it,only 17 tables are imported. after that the cursor stands still and the import does not process further.the remaining 16 tables are not imported at all. why is it so ? have any of you come across such situation ? will datafiles of size greater than 2G cause such problem ? the DB is on oracle 8.1.6/Win2k. kindly let me know guys. TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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: password
And that is what it *should* be used for :) -Original Message- [EMAIL PROTECTED] Sent: 17 December 2002 19:35 To: Multiple recipients of list ORACLE-L Yes, it's a dictionary based cracker. Could be useful for checking for weak passwords. For $4, I'm going to see what it does. :) Jared John Kanagaraj [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2002 10:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: password Jared, This seems to be a 'brute force' dictionary based attack, as I believe the Oracle password is a one-way trapdoor (just as UNIX). I don't think this will be able to crack a strong password created from say a combination of the first characters of an arbitrary sentence. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 So WHO is the Reason for the Season?! Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 9:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: password Hmm... Well maybe you *can* crack oracle passwords. I've just ordered the full version of this product. ( $4, I don't think I need to bother the purchasing department ). I'll let you know how it works. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: export porblem ???
Thanx guys for all your guidance. Thanx Kirti. i found that an index on table 17 caused all the delay and took a long time to be created. when i said IMP FILE=ABC.DAT INDEXES=N ROWS=Y i was able to get all the tables. but still,while importing i get the error IMP-00019: row rejected due to ORACLE error 1401 IMP-3: ORACLE error 1401 encountered ORA-01401: inserted value too large for column Column 1 1110384 Column 2 15798 Column 3 D Column 4 ++ Column 5 candy this causes a few rows to be skipped in some table. - ORA-01401: inserted value too large for column - if this is true , it should not have allowed that particular row to be inserted while doing INSERT ? why does this occur while importing ? can someone explain me ? TIA. Jp. On Tue, 17 Dec 2002 Deshpande, Kirti wrote : Are you importing indexes? How many indexes there are on table #17? Is the DB in archive log mode? Is the archiver getting stuck? - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: export porblem ???
Thanx guys for all your guidance. Dale, i found that an index on table 17 caused all the delay and took a long time to be created. when i said IMP FILE=ABC.DAT INDEXES=N ROWS=Y i was able to get all the tables. but still,while importing i get the error IMP-00019: row rejected due to ORACLE error 1401 IMP-3: ORACLE error 1401 encountered ORA-01401: inserted value too large for column Column 1 1110384 Column 2 15798 Column 3 D Column 4 ++ Column 5 candy this causes a few rows to be skipped in some table. - ORA-01401: inserted value too large for column - if this is true , it should not have allowed that particular row to be inserted while doing INSERT ? why does this occur while importing ? can someone explain me ? TIA. Jp. On Wed, 18 Dec 2002 [EMAIL PROTECTED] wrote : Hi Is it possible you FTP'd the export file across to the new machine in ASCII mode (the default on win systems)? Always ensure you use BINARY mode - the stray LF's get substituted by CRLF's inside the export file and it really messes up the internals and can sometimes the imp utility to skip to the end without reporting an error. Regards Dale -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: export porblem ???
Thanx guys for all your guidance. Thanx Adar. i found that an index on table 17 caused all the delay and took a long time to be created. when i said IMP FILE=ABC.DAT INDEXES=N ROWS=Y i was able to get all the tables. but still,while importing i get the error IMP-00019: row rejected due to ORACLE error 1401 IMP-3: ORACLE error 1401 encountered ORA-01401: inserted value too large for column Column 1 1110384 Column 2 15798 Column 3 D Column 4 ++ Column 5 candy this causes a few rows to be skipped in some table. - ORA-01401: inserted value too large for column - if this is true , it should not have allowed that particular row to be inserted while doing INSERT ? why does this occur while importing ? can someone explain me ? TIA. Jp. On Tue, 17 Dec 2002 Yechiel Adar wrote : Hello After building a table the import builds constraint and indexes. If you got a big table that can take awhile. Check with task/performance monitor if the instance is idle or working. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:28 AM guys, i am exporting a DB of size 10G. it totally has 33 tables. everything completes succesfully and even the log file says EXPORT COMPLETED SUCCESSFULLY WITHOUT ANY WARNING. But while importing it,only 17 tables are imported. after that the cursor stands still and the import does not process further.the remaining 16 tables are not imported at all. why is it so ? have any of you come across such situation ? will datafiles of size greater than 2G cause such problem ? the DB is on oracle 8.1.6/Win2k. kindly let me know guys. TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: password
Jared's answer still stands you can't --- faisal ahmad [EMAIL PROTECTED] wrote: HR htmldiv style='background-color:'DIV Pquistion is this that how can dba see a user,s password in readable outputt. i mean if password is tiger it should be seen as tigerBRBR/P/DIV DIV/DIV DIV/DIVgt;From: [EMAIL PROTECTED] DIV/DIVgt;To: [EMAIL PROTECTED] DIV/DIVgt;CC: [EMAIL PROTECTED] DIV/DIVgt;Subject: Re: password DIV/DIVgt;Date: Tue, 17 Dec 2002 08:46:13 -0800 DIV/DIVgt; DIV/DIVgt;You can't. DIV/DIVgt; DIV/DIVgt; DIV/DIVgt; DIV/DIVgt; DIV/DIVgt; DIV/DIVgt; DIV/DIVgt;faisal ahmad [EMAIL PROTECTED] DIV/DIVgt;Sent by: [EMAIL PROTECTED] DIV/DIVgt; 12/16/2002 08:09 PM DIV/DIVgt; Please respond to ORACLE-L DIV/DIVgt; DIV/DIVgt; DIV/DIVgt; To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] DIV/DIVgt; cc: DIV/DIVgt; Subject: password DIV/DIVgt; DIV/DIVgt; DIV/DIVgt;how can a dba see the password of a user. DIV/DIVgt; DIV/DIVgt;The new MSN 8: smart spam protection and 2 months FREE* DIV/DIVgt;-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: faisal ahmad INET: [EMAIL PROTECTED] Fat City Network DIV/DIVgt;Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services DIV/DIVgt;- To DIV/DIVgt;REMOVE yourself from this mailing list, send an E-Mail message to: DIV/DIVgt;[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the DIV/DIVgt;message BODY, include a line containing: UNSUB ORACLE-L (or the name of DIV/DIVgt;mailing list you want to be removed from). You may also send the HELP DIV/DIVgt;command for other information (like subscribing). DIV/DIV/divbr clear=allhrAdd photos to your e-mail with a href=http://g.msn.com/8HMUEN/2022;MSN 8./a Get 2 months FREE*./html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: faisal ahmad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: export porblem ???
Why are you sending it repeatedy? or is there a virus? Regards Naveen -Original Message- Sent: Wednesday, December 18, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Thanx guys for all your guidance. Thanx Adar. i found that an index on table 17 caused all the delay and took a long time to be created. when i said IMP FILE=ABC.DAT INDEXES=N ROWS=Y i was able to get all the tables. but still,while importing i get the error IMP-00019: row rejected due to ORACLE error 1401 IMP-3: ORACLE error 1401 encountered ORA-01401: inserted value too large for column Column 1 1110384 Column 2 15798 Column 3 D Column 4 ++ Column 5 candy this causes a few rows to be skipped in some table. - ORA-01401: inserted value too large for column - if this is true , it should not have allowed that particular row to be inserted while doing INSERT ? why does this occur while importing ? can someone explain me ? TIA. Jp. On Tue, 17 Dec 2002 Yechiel Adar wrote : Hello After building a table the import builds constraint and indexes. If you got a big table that can take awhile. Check with task/performance monitor if the instance is idle or working. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:28 AM guys, i am exporting a DB of size 10G. it totally has 33 tables. everything completes succesfully and even the log file says EXPORT COMPLETED SUCCESSFULLY WITHOUT ANY WARNING. But while importing it,only 17 tables are imported. after that the cursor stands still and the import does not process further.the remaining 16 tables are not imported at all. why is it so ? have any of you come across such situation ? will datafiles of size greater than 2G cause such problem ? the DB is on oracle 8.1.6/Win2k. kindly let me know guys. TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OAS 4.0.8.1 move
I have a 4.0.8.1 Oracle Application Server implementation on a Solaris 2 .6 box that I am trying to move to a new, presumably identical, box. We are moving it by simply copying all of the datafiles from one box to the other. We can not get it to start! If any one can offer a suggestion, it would be appreciated. Our current problem (after issuing owsctl start) is: - Please wait while the command is being processed on host frog ... Starting ORB process... waiting for ORB to be ready... ORB is not responding. Please restart manually... OWS-20214: The OAS processes can not be started, because the CORBA orb processes can not be started. - there is an associated file, oasoorb674.out, which contains: YDUT-1571, ydcnm.c 789: unexpected IDL:omg.org/CORBA/NO_PERMISSION:1.0 from yocdii.c 720 YDUT-1571, ydcnm.c 493: unexpected IDL:omg.org/CORBA/NO_PERMISSION:1.0 from yocdii.c 720 Init function of module ydn returned an error ERROR: load of module ydn failed - The only differences between the boxes are the IP and the 'name resolution'. The source box uses dns first but the target box resolves names locally first and then uses dns. The nodenames are the same. owsctl start -nodemgr works owsctl status -T works Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wiegand, Kurt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[OT] Patch for PostgreSQL to perform hierarchical queries in Oracle's style.
http://gppl.terminal.ru/ JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Larry E's new toy ?
Chicken feed. Only 100,000,000$ Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 5:13 PM http://www.computerworld.com/hardwaretopics/storage/story/0,10801,76748,00.h tml Enjoy :) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: password
Oracle7 Server Release 7.3.4.5.0 - Production With the distributed, parallel query and Spatial Data options PL/SQL Release 2.3.4.5.0 - Production SQL create user test identified by test; User created. SQL select password from dba_users where username = 'TEST'; PASSWORD -- 7A0F2B316C212D67 SQL drop user test; User dropped. SQL create user hohoho identified by test; User created. SQL select password from dba_users where username = 'HOHOHO'; PASSWORD -- 2C49BD93B9733CA0 SQL drop user hohoho; User dropped. -Original Message- Sent: Tuesday, December 17, 2002 8:24 PM To: Multiple recipients of list ORACLE-L SQL*Plus: Release 9.2.0.2.0 - Production on Tue Dec 17 17:19:55 2002 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.2.0 - Production SQL create user test identified by test; User created. SQL select password from dba_users where username = 'TEST'; PASSWORD -- 7A0F2B316C212D67 SQL -Original Message- Sent: Tuesday, December 17, 2002 2:26 PM To: Multiple recipients of list ORACLE-L created a user test identified by test on 2 separate systems in db's with different names The password value was the same Can someone verify if it is the same on their system Create user test identified by test; select password from dba_users where username = 'TEST'; PASSWORD -- 7A0F2B316C212D67 -Original Message- on my db LTRACK1 SQL select password from dba_users where username = 'TEST'; PASSWORD -- 7A0F2B316C212D67 bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wiegand, Kurt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Application Server on .net
Oracle produced some .NET items, mostly connectivity-related. http://otn.oracle.com/tech/windows/content.html Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message-From: David Mitchell [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 17, 2002 9:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle Application Server on .net It sounds like there's a considerable amount of confusion about this from some of the responses to this question so far. There are lots of .Nets currently in the Microsoft world. There's Visual Studio .Net which is a development environment. There's the .Net CLR which is a runtime environment for a variety of OS's (primarily Microsoft's) and then there's the upcoming Windows .Net Server 2003 which is the successor to Windows 2000 Server. I assume from yourdescription that you are talking about Windows .Net Server 2003 which is currently in Release Candidate 2 status. If this is what you are talking about then it is most definitely an operating system and has nothing to do with OAS. I wouldn't expect any .NetServer compatibilityfrom Oracle until the OS is actually released by Microsoft (currently scheduled for April 2003). David -Original Message-From: Barbara Baker [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 17, 2002 3:34 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle Application Server on .net List: I have a developer trying to install Oracle9i Application Server Release 2 (9.0.3) on a .net server. He's using the install disk for Windows NT and 2000. Needless to say, it gives him an error and throws up. He considers .net just another operating system like np or 2000. I think of it morelike a competitorfor OAS. At any rate, I can't find any mention of .net on either Metalink or OTN (except how much better OAS is than .net) Does anyone know if Oraclehas an application server installation for .net? If so, do you know how I might get it? Is this a silly question? Should I be hanging my head in shame?? Thanks in advance for any information. Barb Do you Yahoo!?Yahoo! Mail Plus - Powerful. Affordable. Sign up now
RE: slow query help
Joan,
Can't this be done as a series of ors instead of the union alls as this
would presumably reduce it to one full table scan of each table.
e.g.
SELECT T11.TRUNK TRUNK_FOUND
,T21.IDTARGET_ID
,T21.SSN TARGET_SSN
,T21.FULLNAME TARGET_FULLNAME
,T21.LASTNAME TARGET_LASTNAME
,T21.MIDDLENAMETARGET_MIDDLENAME
,T21.FIRSTNAME TARGET_FIRSTNAME
,T21.DOB TARGET_DOB
,T21.GENDERTARGET_GENDER
FROM SM_NEW_LOAD T21
,PR_IDENTITY T11
WHERE (T21.SSN IN ( T11.SSN,T11.HRID,SISID,MEDID,AFFID )
OR T21.ID IN (T11.SSN,T11.HRID,SISID,MEDID,AFFID )
OR EXISTS (SELECT 1
FROM PR_ALT_IDS
WHERE TRUNK = T11.TRUNK
AND ALT_ID IN (T21.SSN,T21.ID)))
OR (REPLACE(UPPER(T11.LASTNAME),'-',' ') =
REPLACE(UPPER(T21.LASTNAME),'-',' ')
AND UPPER(T11.FIRSTNAME) = UPPER(T21.FIRSTNAME) )
OR (REPLACE(UPPER(T11.LASTNAME),'-',' ') =
REPLACE(UPPER(T21.LASTNAME),'-',' ')
AND ((INSTR(UPPER(T11.FIRSTNAME),UPPER(T21.MIDDLENAME),1) = 1 AND
INSTR(UPPER(T11.MIDDLENAME),UPPER(T21.FIRSTNAME),1) = 1 )
OR (INSTR(UPPER(T21.FIRSTNAME),UPPER(T11.MIDDLENAME),1) = 1 AND
INSTR(UPPER(T21.MIDDLENAME),UPPER(T11.FIRSTNAME),1) = 1 )))
OR (UPPER(T11.LASTNAME) = UPPER(T21.FIRSTNAME)
AND UPPER(T11.FIRSTNAME) = UPPER(T21.LASTNAME))
OR ((INSTR(' '||REPLACE(UPPER(T11.LASTNAME),'-',' ')||' ','
'||UPPER(T21.LASTNAME)|| ' ' ) 0
OR INSTR(' '||REPLACE(UPPER(T21.LASTNAME),'-',' ')||' ','
'||UPPER(T11.LASTNAME)||' ') 0 )
AND UPPER(T11.FIRSTNAME) = UPPER(T21.FIRSTNAME)
AND (T11.MIDDLENAME IS NULL OR T21.MIDDLENAME IS NULL OR
UPPER(SUBSTR(T11.MIDDLENAME,1,1)) = UPPER(SUBSTR(T21.MIDDLENAME,1,1)) ))
OR (UPPER(T21.LASTNAME) = UPPER(T11.LASTNAME) AND
(INSTR(UPPER(T21.FIRSTNAME),UPPER(T11.FIRSTNAME),1) 0 OR
INSTR(UPPER(T11.FIRSTNAME),UPPER(T21.FIRSTNAME),1) 0 ) AND
(INSTR(UPPER(T21.MIDDLENAME),UPPER(T11.MIDDLENAME),1) 0 OR
INSTR(UPPER(T11.MIDDLENAME),UPPER(T21.MIDDLENAME),1) 0 ))
-Original Message-
Sent: 17 December 2002 19:35
To: Multiple recipients of list ORACLE-L
Hi,
This is the query bothered us very much recently. It run at least 15
min. and sometimes crashed the temp tablespace. Do you have any idea how
to make it run better. Our developer tried used two cursors to compare
the result, but the result is not optimized. We tried used last name and
first name function based index on sm_new_load table. If someone
interested in this query, I can sent you the execution plan.
Thanks in advanced,
Joan
SELECT T11.TRUNK TRUNK_FOUND,T21.ID TARGET_ID,T21.SSN
TARGET_SSN,T21.FULLNAME
TARGET_FULLNAME,T21.LASTNAME TARGET_LASTNAME,T21.MIDDLENAME
TARGET_MIDDLENAME,T21.FIRSTNAME TARGET_FIRSTNAME,T21.DOB TARGET_DOB,
T21.GENDER TARGET_GENDER
FROM
SM_NEW_LOAD T21,PR_IDENTITY T11 WHERE ( T21.ROWID,T11.ROWID ) IN
(SELECT
T22.ROWID,T12.ROWID FROM
PR_IDENTITY T12,SM_NEW_LOAD T22 WHERE T22.SSN
IN ( T12.SSN,T12.HRID,SISID,MEDID,AFFID ) OR T22.ID IN (
T12.SSN,T12.HRID,
SISID,MEDID,AFFID ) OR EXISTS (SELECT 1 FROM
PR_ALT_IDS WHERE TRUNK = T12.TRUNK AND ALT_ID IN ( T22.SSN,T22.ID
)) UNION ALL
SELECT T22.ROWID,
T12.ROWID FROM
SM_NEW_LOAD T22,PR_IDENTITY T12 WHERE
REPLACE(UPPER(T12.LASTNAME),'-',' ') =
REPLACE(UPPER(T22.LASTNAME),'-',' ')
AND UPPER(T12.FIRSTNAME) = UPPER(T22.FIRSTNAME) UNION ALL
SELECT
T23.ROWID,T13.ROWID FROM
SM_NEW_LOAD T23,PR_IDENTITY T13 WHERE
REPLACE(UPPER(T13.LASTNAME),'-',' ') =
REPLACE(UPPER(T23.LASTNAME),'-',' ')
AND ((INSTR(UPPER(T13.FIRSTNAME),UPPER(T23.MIDDLENAME),1) = 1 AND
INSTR(UPPER(T13.MIDDLENAME),UPPER(T23.FIRSTNAME),1) = 1 ) OR
(INSTR(UPPER(T23.FIRSTNAME),UPPER(T13.MIDDLENAME),1) = 1 AND
INSTR(UPPER(T23.MIDDLENAME),UPPER(T13.FIRSTNAME),1) = 1 )) UNION ALL
SELECT
T24.ROWID,T14.ROWID FROM
SM_NEW_LOAD T24,PR_IDENTITY T14 WHERE
UPPER(T14.LASTNAME) = UPPER(T24.FIRSTNAME) AND UPPER(T14.FIRSTNAME) =
UPPER(T24.LASTNAME) UNION ALL SELECT T25.ROWID,T15.ROWID FROM
SM_NEW_LOAD T25,PR_IDENTITY T15 WHERE (INSTR(' ' ||
REPLACE(UPPER(T15.LASTNAME),'-',' ') || ' ' ,' ' ||
UPPER(T25.LASTNAME)
|| ' ' ) 0 OR INSTR(' ' || REPLACE(UPPER(T25.LASTNAME),'-',' ') ||
' ' ,
' ' || UPPER(T15.LASTNAME) || ' ' ) 0 ) AND UPPER(T15.FIRSTNAME) =
UPPER(T25.FIRSTNAME) AND (T15.MIDDLENAME IS NULL OR T25.MIDDLENAME
IS
NULL OR UPPER(SUBSTR(T15.MIDDLENAME,1,1)) =
UPPER(SUBSTR(T25.MIDDLENAME,1,
1)) ) UNION ALL
SELECT T27.ROWID,T17.ROWID FROM
PR_IDENTITY T17,
SM_NEW_LOAD T27 WHERE UPPER(T27.LASTNAME) = UPPER(T17.LASTNAME) AND
(INSTR(UPPER(T27.FIRSTNAME),UPPER(T17.FIRSTNAME),1) 0 OR
INSTR(UPPER(T17.FIRSTNAME),UPPER(T27.FIRSTNAME),1) 0 ) AND
Re: Oracle 8i/HP-UX,Solaris,Windows/Active Directory Question
Thanks Jesse I am going to start it with 9.2.0 so hopefully it will be better. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 8:44 PM Yechiel, We weren't able to get OID replication to be stable for more than a few weeks under 9.0.1. After a week or two, it would just flake out like it needed to make more than 10 or 20 connections to the DBs and it halted. The only solution was to bounce OID -- not the DBs, just the LDAP part. This interruption also caused problems with the replication. In more than one instance, we needed to fully rebuild the slave. Since we only have about 1000 entries, it was no big deal to recreate (15 minutes), but unnerving enough that we felt that a replicated OID was not ready for a production environment. Aparently, we were one of the first to attempt to use OID on Linux as Oracle Support didn't even have a Linux box to verify some of the problems we had. They had claimed to be running replicated OID on Solaris (and maybe Winders -- I forget) without major problems, however, since our LDAP project dropped OID in favor of Sun One (with full replication), I have no reason to test it. As far as our failover, we developed a load balancer in house that would automagically detect which LDAP boxes were available and use those. For startup and shutdown of OID and, optionally, replication, I developed some scripts in Korn for our Linux boxes. If you'd like a copy, I'll make them available with the standard legal disclaimers. Mike, check with your Oracle Sales Rep on licensing for OID. It comes with 9iAS, but I don't know if it's separately licensable. If you really really really want to use Active Death -- erm, Directory -- you'll still need to have OID act as a gateway between it and Oracle. As far as the Oracle DB's concerned, it only talks to OID. Marketing will tell you that the DB talks to any v3-compliant LDAP, but they don't tell you it's only thru the separately licensable OID. Well, I should say by supported means because a co-worker was able to get Oracle Networking to talk with Sun One by converting Oracle's proprietary LDIFs (don't let them tell you their LDIF files are fully v3-compliant!!!) to standards. Also, be prepared to be GUI-fied. There are many operations with OID, particularly in the installation and setup, that are GUI-only! Also, 7.x cannot authenticate or do names resolution to LDAP. I'm not sure, but I think that started with 8i. I need to stop babbling now and get back to work... ;) HTH! GL! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Yechiel Adar [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 1:24 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle 8i/HP-UX,Solaris,Windows/Active Directory Question I am currently busy with the same project. Junk tnsnames.ora for OID. I installed OID 9.2.0.1. I then converted the tnsnames.ora to OID entries with no problems. I then tried to access the OID from 8.1.6 client and got zilch, nada, gurnisht etc. . After Deborah from Oracle Israel came in she told me that I need to create the Oracle Context under an entry in the root and not in the OID root itself. After we did that 8.1.6 and 9.2.0.1 clients worked with OID version 9.2.0.1. Still testing on my machine. After we solve the problem of replication and Failover (two OID servers with the client automatically switching from one to the other in case of failure (not clustering)) I will think about moving it to the users. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 2:08 AM Happy Holidays Everyone! I have been hacking around the MetalLink site looking for how to move from using a TNSNAMES.ORA file to Active Directory. We use a mixed environment of HP-UX, Solaris, and Windows, with versions of Oracle from 7.3.4 (really!) to 9iR2. All the notes and docs I can find seem to be only for a Windows environment. Any pointers to docs or tips would be appreciated. Thanks, Mike --- == = Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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
RE: Re: export problem ???
oraora - I doubt that Import did insert that record. The message says it skipped that record. Check the table to see whether it was inserted. What did you set for the parameter IGNORE? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 18, 2002 4:19 AM To: Multiple recipients of list ORACLE-L Thanx guys for all your guidance. Thanx Adar. i found that an index on table 17 caused all the delay and took a long time to be created. when i said IMP FILE=ABC.DAT INDEXES=N ROWS=Y i was able to get all the tables. but still,while importing i get the error IMP-00019: row rejected due to ORACLE error 1401 IMP-3: ORACLE error 1401 encountered ORA-01401: inserted value too large for column Column 1 1110384 Column 2 15798 Column 3 D Column 4 ++ Column 5 candy this causes a few rows to be skipped in some table. - ORA-01401: inserted value too large for column - if this is true , it should not have allowed that particular row to be inserted while doing INSERT ? why does this occur while importing ? can someone explain me ? TIA. Jp. On Tue, 17 Dec 2002 Yechiel Adar wrote : Hello After building a table the import builds constraint and indexes. If you got a big table that can take awhile. Check with task/performance monitor if the instance is idle or working. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:28 AM guys, i am exporting a DB of size 10G. it totally has 33 tables. everything completes succesfully and even the log file says EXPORT COMPLETED SUCCESSFULLY WITHOUT ANY WARNING. But while importing it,only 17 tables are imported. after that the cursor stands still and the import does not process further.the remaining 16 tables are not imported at all. why is it so ? have any of you come across such situation ? will datafiles of size greater than 2G cause such problem ? the DB is on oracle 8.1.6/Win2k. kindly let me know guys. TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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).
Re: Online Redifinition in 8i ?
Not all that hard - but I don't like the bit that starts update obj$ set Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 18 December 2002 09:40 No. You could probably simulate something close with a lot of hard work hth connor --- VIVEK_SHARMA [EMAIL PROTECTED] wrote: Does the Feature Online Redefinition for RE-Organizign Objects , Adding Fields , Converting to Partitioned Table Exist in Oracle 8i ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Unable to load shared libraries.
Jared, I installed the development tools and that worked!! Thanks Sumathy - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Panicker, Thankam S. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Direct Path Inserts and Partition Splits
Which version of Oracle ? 8.1 or 9.2 ? It could make a difference because of the 'free split' change in code that appeared in 9.2. I don't recall the error I got - but some time back I was working on a partition exchange strategy and testing the effects of tablespace corruption in mid-exchange. One of the scenarios I built managed to leave me with a partition in a non-existent tablespace, but the partition could not be dropped because it didn't exist. Clearly some form of dictionary corruption on partition maintenance - so there are some oddities to be cleaned. It might also be an idea to check of the OCI program manages to hold a cursor open that should have been invalidated on the split. Is it possible that when suspended, the program then pushed its current data set into a partition/data segment that simply did not exist in the data dictionary ? Can you add a little detail about the structure of the PT and its missing elements. Do you have multiple partitions per day, with some giving 8103 when queried by name; or is it one partition per day, but queries which extend into the gap give the 8103 ? Have you tried running with a level 4 on 10046 yet to see the actual dictionary accesses that Oracle attempts when looking for the critical data (probably have to bounce the database to get the best effects here); of checked the contents of the obj$, and related tables around the object numbers and data object numbers of the damaged bits to see if there is any data there that does not fit the pattern ? I tend to disagree with your comment about splitting on the fly being silly, by the way - as soon as Oracle introduced MAXVALUE, they introduced an implicit requirement either for an unbreakable mechanism for doing a split in real-time, or for a mechanism for shunting data above the current high_value into a holding table. (Requiring end-user code to handle rogue data would otherwise introduce a significant overhead on processing times). Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The CO-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 17 December 2002 23:14 A program inserts via OCI DirectPath telemetry data into a time-based partition every 30 seconds, each insert acquiring an exclusive lock on the table. The users decided to further split the partition receiving the inserts by time. Each of the new partitions is stale, by that I mean their high values are all previous to the present data. The split was done on December 4th carved out partitions for November 26, 27, 28, 29, and 30. While the split is going on, the program buffered the next inserts. Once the split is done the program continues its inserts into the original partition. (During the split Oracle acquires locks which prevent data manipulation) I realize that splitting a partition on the fly like this is a silly thing to do. It was never going to be part of the production system. However I was not sure if doing so would work. We tried it and the result may have been data dictionary corruption; i.e., ORA-8103 errors. Data in the November 26, November 27, about 22.5 hours of November 28, November 29, November 30 and the input partition remain visible. It's only the 1/5 hours of the November 28th partition which is inaccessible. In a way it's very much like a block corruption problem.Some additional information: all objects in the database are valid, all indexes are usable, besides there were no indexes involved in the split operation. DBV reports no problem with any of the database files. Oracle support also blames it on the split activity. I am anxious because there is a big push to put this system into production. I need to be sure the corruption was caused by the split. We won't be that silly again. Unfortunately the corruption was not discovered immediately afterwards. The split as the cause is really just a guess. Has anyone else seen unexplained 8103 errors after partition management? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP
[no subject]
SETORACLE-L DIGEST EDOUARD DORMIDONTOV
RE: Larry E's new toy ?
Yes, reality check: If you're making less than US$50,000 per day, you're not a member of the upper class. So save your pennies. ; ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Wednesday, December 18, 2002 7:14 AM To: Multiple recipients of list ORACLE-L Chicken feed. Only 100,000,000$ Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 5:13 PM http://www.computerworld.com/hardwaretopics/storage/story/0,10801,76748,00.h tml Enjoy :) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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.com -- 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).
RE: slow query help
Joan - Just a random thought inspired by your explanation. Is this query a part of cleaning data for a data warehouse? Or worse yet, is the developer attempting to use this query in an attempt to avoid creating a data warehouse? Normally the best solution for the situation you describe is to create a data warehouse. If those words scare you, just say that it is a couple of tables to provide cleaned data. Then you can pull data from one system at a time, clean it, and store it. Based on your description, be aware that even if the query is made to work, as my grandpappy would say with bailing wire and chewing gum, it may be very fragile and need constant attention. Developers have this nasty habit of moving along to the next development project and you, the DBA, are stuck with a problem. The developer gets all the glory for making it work. You get all the blame because it keeps breaking. Not pretty. Anyway, this is what I got out of your explanation, and if I'm off base, just ignore this message. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 17, 2002 8:49 PM To: Multiple recipients of list ORACLE-L Mark, This is a new in-house developed the school directory system. The source data come from all over the different systems. The data quite dirty in some case. I am not sure how the business rule was defined yet. The developer knew her query was nasty, so she turned on me for help. This query is part of the whole process. As you said, it compares all the possible same person feed from all the systems (med, sis,law...)and insert it to another table. I think you and Stephane's suggestions are very valuable and I will definitely ask her to review her design of this processing. (sigh, we are not that experienced and good on this) After I work more with developer and get more knowledge of this application. I'd like to ask some detail of your experience in such searching logic. many thanks, Joan Mark Richard wrote: I tend to agree with Stephane... It looks like that query was possibly generated by a tool. If not you should go talk to the person who wrote it. Find out what the business rules are and write it from scratch. In reality the query keeps hitting the same two tables, presumably looking for rows that have just been loaded which match existing rows in another table based on the names matching in some fashion (ie: perhaps incorrect firstname/middlename usage, etc). Some of Stephane's suggestions will also help. We store customer names as case sensitive but we obviously need to do a case-insensitive search from our application to find customers. The easiest way out - store the name twice (we have firstname and firstnameasupper, lastname and lastnameasupper, etc). Obviously the indexes sit on the asupper columns. Sure there is a slight amount of duplicated data, but it is done for a reason and let's us search customers very fast whist still preserving the nuance's that customers like to see when you send a bill to them. Perhaps you need to store some columns which have had replace and upper applied. Finally since the query seems to accept pretty much any combination of lastname, firstname, middlename you could concatenate the three columns into a namesearch column are just perform three instr searches on that column, as opposed to trying every possibility - that should save Oracle some heartache. Regards, Mark. Stephane Faroult To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] sfaroult@orio cc: le.com Subject: Re: slow query help Sent by: [EMAIL PROTECTED] om 18/12/2002 07:58 Please respond to ORACLE-L Joan Hsieh wrote: Hi, This is the query bothered us very much recently. It run at least 15 min. and sometimes crashed the temp tablespace. Do you have any idea how to make it run better. Our developer tried used two cursors to compare the result, but the result is not optimized. We tried used last name and first name function based index on sm_new_load table. If someone interested in this query, I can sent you the execution plan. Thanks in advanced, Joan SELECT T11.TRUNK TRUNK_FOUND,T21.ID TARGET_ID,T21.SSN TARGET_SSN,T21.FULLNAME TARGET_FULLNAME,T21.LASTNAME TARGET_LASTNAME,T21.MIDDLENAME TARGET_MIDDLENAME,T21.FIRSTNAME TARGET_FIRSTNAME,T21.DOB TARGET_DOB, T21.GENDER TARGET_GENDER FROM SM_NEW_LOAD T21,PR_IDENTITY T11 WHERE ( T21.ROWID,T11.ROWID ) IN (SELECT T22.ROWID,T12.ROWID FROM PR_IDENTITY T12,SM_NEW_LOAD T22 WHERE T22.SSN IN ( T12.SSN,T12.HRID,SISID,MEDID,AFFID ) OR T22.ID IN ( T12.SSN,T12.HRID, SISID,MEDID,AFFID ) OR EXISTS
Re: db block Size for Indexes Tablespaces in 9.2 ?
I think there are too many generic arguments available for picking the 'right' block size for your indexes. The one that is most appropriate is likely to depend on the nature of the activity (load vs. query), nature of the index (unique, nearly unique, far from unique), data clustering, order of data arrival, frequency of data arrival, pattern of data deletion/update, stability of volume, nature of queries (big or small range scans), potential of modifying number of branches, buffering effects, and whether or not you are using a filesystem with or without direct i/o. Given another 10 minutes I might come up with a few more ideas. Your strategy should be to identify the extreme, and critical, characteristics of your system and play to them - small block size may be appropriate, reverse indexes may be appropriate, getting rid of the synthetic key that is likely to cause a problem may be appropriate. But don't assume that anything as trivial as tweaking a block size is a driving feature of making your index work well. Which test case would you like to see - the one I did for company X that showed they needed a small block size, or the one I did for company Y that showed they needed a large block size ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 18 December 2002 05:59 Hi Arup , List Your point is Correct about High buffer busy wait Contention During Large OLTP Insert /Updates. High buffer busy wait on Corresponding INDEX during INSERT Operations was Observed during our previous benchmark which overcame by Converting to REVERSE Index as the Field Value was Sequentially Increasing . Following Article advocates HIGHER Block Size for Index , Strangely :- http://www.tusc.com/oracle/download/author.html#loneyk What may be the Commonly followed Best practice for DB_BLOCK_SIZE for Index Tablespaces in 9.2 ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: db block Size for Indexes Tablespaces in 9.2 ?
Title: RE: db block Size for Indexes Tablespaces in 9.2 ? We use 8k for data and 8k for indexes in our OLTP system ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! 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.*2
RE: Oracle Application Server on .net
There is a good paper on .NET at www.arstechnica.com, right-hand column. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 17, 2002 10:04 PM To: Multiple recipients of list ORACLE-L The way it was explained to me was that Windows.net or Windows .NET server is an OS, while .net is a framework or topology ( don't really know much about it). Was that incorrect? Don't really care too much, just want to make proper use of buzzwords at meetings. Jared Reardon, Bruce (CALBBAY) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2002 04:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle Application Server on .net Net does refer to an OS (in addition to referring to a platform / group of languages). To see some information from Oracle on this have a look at http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=16 1546.1p_database_id=NOT This includes ...In the future Microsoft will be delivering server editions of Windows XP, these will use the Windows .NET Server naming convention. ... To see some details on Microsoft's web site look at http://www.microsoft.com/windows.netserver/default.mspx Windows .NET Server 2003 Release Candidate 2 is here. You can download it from http://www.microsoft.com/windows.netserver/preview/default.mspx What error does the developer doing the install get? Regards, Bruce Reardon -Original Message- Sent: Wednesday, 18 December 2002 10:54 AM Net is not an OS. The developer (here it comes) doesn't know what he's talking about. -Original Message- Sent: Tuesday, December 17, 2002 3:34 PM List: I have a developer trying to install Oracle9i Application Server Release 2 (9.0.3) on a .net server. He's using the install disk for Windows NT and 2000. Needless to say, it gives him an error and throws up. He considers .net just another operating system like np or 2000. I think of it more like a competitor for OAS. At any rate, I can't find any mention of .net on either Metalink or OTN (except how much better OAS is than .net) Does anyone know if Oracle has an application server installation for .net? If so, do you know how I might get it? Is this a silly question? Should I be hanging my head in shame?? Thanks in advance for any information. Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: OS/2 is officially dead as of Dec 10, 2002
Do they have to pay licensing fees to Microsoft for win-os/2 I wonder. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 17, 2002 5:31 PM To: Multiple recipients of list ORACLE-L Patrice, Tuesday, December 17, 2002, 2:40:38 PM, you wrote: B http://www.pcmag.com/article2/0,4149,767456,00.asp The reports of OS/2's death are somewhat exaggerated: http://www.russharvey.bc.ca/rhc/os2/ecs.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: slow query help
Title: RE: slow query help Joan, Here is a suggestion ... if this is going to be your most used part, I'd look into Intermedia ... you'll have a lot more options to work with and they will work good. Until then, I'd recommend replacing instr() with appropriate LIKE clause because at-least it will help you use an index. Through a DB trigger ensure that all names (first/middle/last) are always in UPPER so you don't have to pur UPPER or deal with FBI. Initially I thought of merging all clauses into one, but then I realized, Oracle will end up doing what I un-did (it will replace all OR conditions to UNION ALL anyways). Happy Holidays Everyone !! Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! 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.*2
RE:
EDOUARD, EDOUARD, EDOUARD HELP! -Original Message-From: Edouard Dormidontov [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 18, 2002 7:24 AMTo: Multiple recipients of list ORACLE-LSubject: SETORACLE-L DIGEST EDOUARD DORMIDONTOV
RE: Re: export problem ???
oraora, Did the original export come from a database that you have access to? Check the description on the table that had failed to insert some rows. The original source table has different sizes on the columns than the tables you are importing into, That is why some records are getting rejected as ORA-01401: inserted value too large for column Ron [EMAIL PROTECTED] 12/18/02 07:27AM oraora - I doubt that Import did insert that record. The message says it skipped that record. Check the table to see whether it was inserted. What did you set for the parameter IGNORE? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 18, 2002 4:19 AM To: Multiple recipients of list ORACLE-L Thanx guys for all your guidance. Thanx Adar. i found that an index on table 17 caused all the delay and took a long time to be created. when i said IMP FILE=ABC.DAT INDEXES=N ROWS=Y i was able to get all the tables. but still,while importing i get the error IMP-00019: row rejected due to ORACLE error 1401 IMP-3: ORACLE error 1401 encountered ORA-01401: inserted value too large for column Column 1 1110384 Column 2 15798 Column 3 D Column 4 ++ Column 5 candy this causes a few rows to be skipped in some table. - ORA-01401: inserted value too large for column - if this is true , it should not have allowed that particular row to be inserted while doing INSERT ? why does this occur while importing ? can someone explain me ? TIA. Jp. On Tue, 17 Dec 2002 Yechiel Adar wrote : Hello After building a table the import builds constraint and indexes. If you got a big table that can take awhile. Check with task/performance monitor if the instance is idle or working. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:28 AM guys, i am exporting a DB of size 10G. it totally has 33 tables. everything completes succesfully and even the log file says EXPORT COMPLETED SUCCESSFULLY WITHOUT ANY WARNING. But while importing it,only 17 tables are imported. after that the cursor stands still and the import does not process further.the remaining 16 tables are not imported at all. why is it so ? have any of you come across such situation ? will datafiles of size greater than 2G cause such problem ? the DB is on oracle 8.1.6/Win2k. kindly let me know guys. TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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
Re: Open the password
Connect as the DBA and change the SYS and SYSTEM passwords. Recreate the ORAPWD file. Just a few suggestions. Ron [EMAIL PROTECTED] 12/18/02 02:13AM Dear everyone, I already installed oracle 8i database on my server, to make my system secured I changed my 'INTERNAL' password but I forget to write the changed in my book, and now I can't enter to 'INTERNAL' because I forget the password. Please inform me how to open it again perhaps you have tips and tricks how to solve it. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Backup DB files to the Tape
Just remember, I you don't have the database shutdown while you back them up the backups will be unusable. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:29 AM Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . Regards Dilmohan Ashraf Salaymeh wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:
Happy digesting :-) sorry, Jared, - couldn't resist Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Edouard Dormidontov To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 18, 2002 8:23 AM SETORACLE-L DIGEST EDOUARD DORMIDONTOV
RE: Backup DB files to the Tape
I will add a vote for cpio. I have found it to be so reliable that I used cpio, instead of a dump utility, to back up Unix boxes. It never failed. In the past, I found that tar had filename length limitation that was shorter than what the OS permitted (80 characters iirc -- that's filename, not path). This happened when I worked in a development environment that used Rogue Wave tools. During software builds, files would be generated with ridiculously long names, and tar could not handle these. Time has passed since the days I had to backup Unix servers, but iirc cpio could correctly handle all types of special files (devices, etc.), and tar could not (as I said, iirc). If you are just experimenting, there is another utility called pax, which is latin for peace, the idea being that it will bring peace to the Tar Wars where tar2d2 is always fighting c3pio. I get the impression that neither group was willing to abandon its favorite utility and adopt pax, so the fight goes on. -Original Message- Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Capacity Planning -- Expecting the DB growth !!!
One thing I don't think I've seen mentioned is the issue of storage configuration and uptime requirements impact on capacity planning. Is the planned system 7x24 or will there be maintenance windows to add storage? Can storage be added hot or is downtime required. These issues will require the fudge factor to be adjusted accordingly. Mike Hand Polaroid Corp. -Original Message- Sent: Tuesday, December 17, 2002 5:01 PM To: Multiple recipients of list ORACLE-L One problem I've run into when doing some rudimentary cap planning is that much of it is directly related to how much business our Sales force predicts we will generate next year. I've looked at the growth of our general ledger tables and our sales order tables and it's mostly driven by the amount of business we do (we manufacture printing controls). So, some insight into the business by Sales or other company execs may help, too. That, and a fudge factor. One of our larger audit tables had 300% more rows in 2000 than in 1999 because of planned inventory moves used in implementing lean manufacturing. No way I could have predicted that one, but a fudge factor softened the blow a bit. Just my $.02 (before taxes), Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OAS 4.0.8.1 move
Kurt, If the ip address/hostname are not identical on the new box it won't run, you have to re-install it from cd. All of the network configs are hard coded during install and there is no way to change them. I went through this a couple of years ago when the SA changed the ip address to a 10 .10... on a dev box. ...JIM... [EMAIL PROTECTED] 12/18/02 5:43:42 AM I have a 4.0.8.1 Oracle Application Server implementation on a Solaris 2 .6 box that I am trying to move to a new, presumably identical, box. We are moving it by simply copying all of the datafiles from one box to the other. We can not get it to start! If any one can offer a suggestion, it would be appreciated. Our current problem (after issuing owsctl start) is: - Please wait while the command is being processed on host frog ... Starting ORB process... waiting for ORB to be ready... ORB is not responding. Please restart manually... OWS-20214: The OAS processes can not be started, because the CORBA orb processes can not be started. - there is an associated file, oasoorb674.out, which contains: YDUT-1571, ydcnm.c 789: unexpected IDL:omg.org/CORBA/NO_PERMISSION:1.0 from yocdii.c 720 YDUT-1571, ydcnm.c 493: unexpected IDL:omg.org/CORBA/NO_PERMISSION:1.0 from yocdii.c 720 Init function of module ydn returned an error ERROR: load of module ydn failed - The only differences between the boxes are the IP and the 'name resolution'. The source box uses dns first but the target box resolves names locally first and then uses dns. The nodenames are the same. owsctl start -nodemgr works owsctl status -T works Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wiegand, Kurt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:
Ok, I'll ask the obligatory 'Are you stupid?' Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 9:19 AM EDOUARD, EDOUARD, EDOUARD HELP! -Original Message- Sent: Wednesday, December 18, 2002 7:24 AM To: Multiple recipients of list ORACLE-L SET ORACLE-L DIGEST EDOUARD DORMIDONTOV -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Backup DB files to the Tape
Hi!! Check for the -K option of the TAR command... is for supporting files 2 Gb... if you do not have that option, you could use CPIO HTH JL --- Ashraf Salaymeh [EMAIL PROTECTED] wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Backup DB files to the Tape
Ruth, Does this mean hot backups don't work for UnixWare 7.1? Otherwise, cp, cpio, ufsdump or any other method of copying the disk file from location a to location b should be ok, shouldn't it? John -Original Message- Sent: Wednesday, December 18, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Just remember, I you don't have the database shutdown while you back them up the backups will be unusable. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:29 AM Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . Regards Dilmohan Ashraf Salaymeh wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 bug 2316137
We've just started experiencing a problem where a client-server Forms 4.5 application hangs and then produces this error: ORA-00600: internal error code, arguments: [kksscl-inf-inl-loop], [1500], [0], [1], [41], [41], [], [] Our database is version 9.2 and we found reference to a bug on metalink, 2316137, though we can't see the details. We are planning an off-hours upgrade to 9.2.0.2 which is said to fix this problem; in the meantime, we can clear up the condition causing this error by bouncing the instance. Then things work for a while until the error starts to occur again (last time it cleared up for about a week). Since it is several weeks before I can get the downtime to apply the upgrade, I'm wondering if anyone has had experience with this problem and whether there is a temporary fix short of updating the Oracle software. Thanks -- Glenn Stauffer [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Capacity Planning -- Expecting the DB growth !!!
Jared, Can you send me the script you use. I can't even figure out the syntax for DBMS_SPACE from the docs. I would be very grateful Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 3:58 PM I use DBMS_SPACE to calculate the actual size of all data objects in our SAP databases. The data is collected once a week. Once a month I use the collected data to create an aggregate table via Oracle's linear regression and partitioning SQL operators. Run the projections for the current month, end of year, the 2 following 6 month periods, put the data in excel and chart it. Earlier this year my projection for SAP running out of space was 6/28/02. There were some delays in getting the new storage hardware installed. Guess which day we ran out of space? ;) That was just dumb luck that it happened the same day, but now people believe my projections. :) I opted for the use of DBMS_SPACE, as that is the best way to find out how much space is actually being used for data. I didn't care about allocated empty blocks, or how big the tablespaces were. There's now about 14 months of data for this, and though growth is not alwasy linear, it's still better than a SWAG. Jared Reddy, Madhusudana [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2002 11:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Capacity Planning -- Expecting the DB growth !!! Hello All, It should include all as you said , but since I do not belong to a capacity planning group in my shop , I mostly concentrate on the DB growth . I have taken Sales as business object to correlate with the DB size . I think in our case both of them are directly proportional. ( Business objects may vary from shop to shop ) first step I have done is calculating the : Growth factor = avg. History Db growth / avg Hist Sales growth Second Step : identifying the Sales projection for the next fiscal year ( Ie. I have to get sales growth percentage from the business team , for example 15% and multiply with sales history, for each week I guess.) 3rd step: Now I have sales projection and growth Factor , and can the projected DB growth . Well The above is the thing I am working on by having some queries to get the data from the DB. Also I have to automate the whole process . I would like to know how this Capacity planning followed in your shop. What's your answer when your group manager asks how much disk we need for holiday prep ?? Like this we can have many questions. I know somebody is having a better approach getting followed . Would appreciate if you share with us. or somebody can better help me in identifying the Q? from managers Thank YOU all for your replies Madhu -Original Message- Sent: Tuesday, December 17, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Check the link Kirti has posted (orapub). Is capacity planning only on the database size ? In my mind it also includes : Transaction description (online and batch) Transaction frequency (online and batch) Transaction window Networking requirements Number of users (all and concurrent) Overall disk space (inside and outside the database) Availability --- Reddy, Madhusudana [EMAIL PROTECTED] a écrit : Hello All, I am currently working on capacity planning of the database , expecting the database size based on the business object ,sales ( Historical data). I am not sure about the approach I am following . I believe there might be some better approach followed in some shop to estimate the DB size , even by considering events like thanks giving , holiday season and all. Also I have to automate this process. Would like to know some best suggestions you always have in this forum. Would you help me in identifying some formulae. Any kind of documentation will be a great help !!! Thanks in advance, Madhu ATTACHMENT part 2 image/gif name=Blank Bkgrd.gif = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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:
DUAL Yechiel AdarMehish - Original Message - From: Farnsworth, Dave To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 18, 2002 4:19 PM Subject: RE: EDOUARD, EDOUARD, EDOUARD HELP! -Original Message-From: Edouard Dormidontov [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 18, 2002 7:24 AMTo: Multiple recipients of list ORACLE-LSubject: SETORACLE-L DIGEST EDOUARD DORMIDONTOV
RE: Methods to get DDL
Bob; I do have a set of sqlplus scripts that we wrote for 7.3.4 that generate DDL for objects in the database. So, you can write your own. All the neccessary information is in the catalog. -Original Message- Sent: Wednesday, December 18, 2002 9:16 AM To: Multiple recipients of list ORACLE-L I finally have a bit of time and was wondering what are different methods to get DDL other than Export rows=n Using Quest SQL navigator Using The Databee tool Ideally Id like to get it from a sql plus command but Im pretty sure that's not available. DDL dosnt seem to be available from DBA studio either... Im wondering what methods people are using? I'd like a quick way to get the ddl for say... One index Thanks in advance bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Online Redifinition in 8i ?
if you use perl on your site, I can send you my perl scripts, which I copied from from 9i DBMS_REDEF. hth -Original Message- Sent: Wednesday, December 18, 2002 3:49 AM To: Multiple recipients of list ORACLE-L No. You could probably simulate something close with a lot of hard work hth connor --- VIVEK_SHARMA [EMAIL PROTECTED] wrote: Does the Feature Online Redefinition for RE-Organizign Objects , Adding Fields , Converting to Partitioned Table Exist in Oracle 8i ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shao, Chunning INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Methods to get DDL
There are scripts out there that will do the job, though most of them start to fall down if the indexes are at all unusual. I bought a book a couple of years ago with a whole selection of scripts to create ddl for database objects - It should still be available on Amazon. Cheers Simon Anderson Please respond to [EMAIL PROTECTED] I finally have a bit of time and was wondering what are different methods to get DDL other than Export rows=n Using Quest SQL navigator Using The Databee tool Ideally Id like to get it from a sql plus command but Im pretty sure that's not available. DDL dosnt seem to be available from DBA studio either... Im wondering what methods people are using? I'd like a quick way to get the ddl for say... One index Thanks in advance bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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: Methods to get DDL
Again, why NO Oracle version specified? If on 9i DB, then use DBMS_METADATA HTH YMMV HAND! Bob Metelsky bmetelsky@cps92.To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] com cc: Sent by: Subject: Methods to get DDL [EMAIL PROTECTED] 12/18/2002 07:15 AM Please respond to ORACLE-L I finally have a bit of time and was wondering what are different methods to get DDL other than Export rows=n Using Quest SQL navigator Using The Databee tool Ideally Id like to get it from a sql plus command but Im pretty sure that's not available. DDL dosnt seem to be available from DBA studio either... Im wondering what methods people are using? I'd like a quick way to get the ddl for say... One index Thanks in advance bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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[2]: OT: OS/2 is officially dead as of Dec 10, 2002
Patrice, I really don't know much about it. I just remembered a feeling of shock and wonderment when I was reading a webpage where someone was installing eComStation. I just wanted to pass that same wonderment along :-) -rje BPJ Do they have to pay licensing fees to Microsoft for win-os/2 I wonder. B http://www.pcmag.com/article2/0,4149,767456,00.asp BPJ The reports of OS/2's death are somewhat exaggerated: BPJ http://www.russharvey.bc.ca/rhc/os2/ecs.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Methods to get DDL
Eekk! Sorry - 8.17 on win2k Again, why NO Oracle version specified? If on 9i DB, then use DBMS_METADATA HTH YMMV -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Methods to get DDL
I finally have a bit of time and was wondering what are different methods to get DDL other than Export rows=n Using Quest SQL navigator Using The Databee tool Ideally Id like to get it from a sql plus command but Im pretty sure that's not available. DDL dosnt seem to be available from DBA studio either... Im wondering what methods people are using? I'd like a quick way to get the ddl for say... One index Thanks in advance bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Informix backups
The SysAdmin is backing up the filesystems/raw partitions where the informix db resides w/out putting the db in hot backup mode. He was told by a consultant, all you have to do is backup the informix logs and db files for full recovery. As an Oracle DBA and not familiar w/ informix, is this informix db backup recoverable? Thanks, Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 bug 2316137
Title: RE: Oracle bug 2316137 You could always install oracle in another oracle home, Patch that home Then all you need is 1 min down time to shutdown the db and bring it up with the other patched oracle. -Original Message- From: Glenn Stauffer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:20 AM To: Multiple recipients of list ORACLE-L Subject: Oracle bug 2316137 We've just started experiencing a problem where a client-server Forms 4.5 application hangs and then produces this error: ORA-00600: internal error code, arguments: [kksscl-inf-inl-loop], [1500], [0], [1], [41], [41], [], [] Our database is version 9.2 and we found reference to a bug on metalink, 2316137, though we can't see the details. We are planning an off-hours upgrade to 9.2.0.2 which is said to fix this problem; in the meantime, we can clear up the condition causing this error by bouncing the instance. Then things work for a while until the error starts to occur again (last time it cleared up for about a week). Since it is several weeks before I can get the downtime to apply the upgrade, I'm wondering if anyone has had experience with this problem and whether there is a temporary fix short of updating the Oracle software. Thanks -- Glenn Stauffer [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:
I thought, it was: ARE YOU AN IDIOT? :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:04 AM Ok, I'll ask the obligatory 'Are you stupid?' Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 9:19 AM EDOUARD, EDOUARD, EDOUARD HELP! -Original Message- Sent: Wednesday, December 18, 2002 7:24 AM To: Multiple recipients of list ORACLE-L SET ORACLE-L DIGEST EDOUARD DORMIDONTOV -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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:RE: password
Anyone know who that hacker is?? Reply Separator Author: Mark Leith [EMAIL PROTECTED] Date: 12/17/2002 6:23 AM Yes, you can do this, but it still doesn't tell you the users *current* password does it? Has anyone tried: http://home.earthlink.net/~adamshalon/oracle_password_cracker/ ? Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: 17 December 2002 13:59 To: Multiple recipients of list ORACLE-L Subject: RE: password And you can use it to change it to your convenience and later get this encrypted password IN without the knowledge of the user.. Regards Jai Paulo Gomes [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/02 06:08 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: password nope u can get the encripted password from the oracle dictionáry -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: terça-feira, 17 de Dezembro de 2002 11:34 To: Multiple recipients of list ORACLE-L Subject: RE: password Check the post-it note on their monitor? :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paulo Gomes Sent: 17 December 2002 10:55 To: Multiple recipients of list ORACLE-L Subject: RE: password he can't but he can change it to a new one and then put the old back on -Original Message- From: faisal ahmad [mailto:[EMAIL PROTECTED]] Sent: terça-feira, 17 de Dezembro de 2002 4:09 To: Multiple recipients of list ORACLE-L Subject: password how can a dba see the password of a user. -- The new MSN 8: smart spam protection and 2 months FREE* -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: faisal ahmad INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --- -- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META content=text/html; charset=iso-8859-1 http-equiv=Content-Type META content=MSHTML 5.00.3510.1100 name=GENERATOR/HEAD BODY DIVFONT color=#ff face=Arial size=2SPAN class=986091614-17122002Yes, you can do this, but it still doesn't tell you the users *current* password does it? /SPAN/FONT/DIV DIVFONT color=#ff face=Arial size=2SPAN class=986091614-17122002/SPAN/FONTnbsp;/DIV DIVFONT color=#ff face=Arial size=2SPAN class=986091614-17122002Has anyone tried:/SPAN/FONT/DIV DIVFONT color=#ff face=Arial size=2SPAN class=986091614-17122002/SPAN/FONTnbsp;/DIV DIVFONT color=#ff face=Arial size=2SPAN class=986091614-17122002A href=http://home.earthlink.net/~adamshalon/oracle_password_cracker/;http://hom e.earthlink.net/~adamshalon/oracle_password_cracker//A/SPAN/FONT/DIV DIVFONT color=#ff face=Arial size=2SPAN class=986091614-17122002/SPAN/FONTnbsp;/DIV DIVFONT color=#ff face=Arial size=2SPAN class=986091614-17122002?/SPAN/FONT/DIV DIVFONT color=#ff face=Arial size=2SPAN class=986091614-17122002/SPAN/FONTnbsp;/DIV DIVFONT color=#ff face=Arial size=2SPAN class=986091614-17122002Mark/SPAN/FONT/DIV BLOCKQUOTE DIV align=left class=OutlookMessageHeader dir=ltrFONT face=Tahoma size=2-Original Message-BRBFrom:/B [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]BOn Behalf Of /B[EMAIL PROTECTED]BRBSent:/B 17 December 2002 13:59BRBTo:/B Multiple recipients of list ORACLE-LBRBSubject:/B RE: passwordBRBR/DIV/FONTBRFONT face=sans-serif size=2And you can use it to change it to your convenience and later/FONT BRFONT face=sans-serif size=2get this encrypted password IN without the knowledge of/FONT BRFONT face=sans-serif size=2the user../FONT BRFONT face=sans-serif size=2BRRegardsBRJai/FONT BRBRBR TABLE width=100% TBODY TR vAlign=top TD TDFONT face=sans-serif size=1BPaulo Gomes lt;[EMAIL PROTECTED]gt;/B/FONT BRFONT face=sans-serif size=1Sent by: [EMAIL PROTECTED]/FONT PFONT face=sans-serif size=112/17/02 06:08 PM/FONT BRFONT face=sans-serif size=1Please respond to ORACLE-L/FONT BR/P TDFONT face=Arial size=1nbsp; nbsp; nbsp; nbsp; /FONTBRFONT face=sans-serif size=1nbsp; nbsp; nbsp; nbsp; To: nbsp; nbsp; nbsp; nbsp;Multiple recipients of list ORACLE-L
Re:RE: password
Try this sql script:
/*
* DBA Skeleton Key
*
* This script will allow one to crash into any Oracle account.
* The only restriction is that the invoker must have the
* 'alter any user' system priviledge.
*/
accept usrname char prompt 'Enter account name to crack: '
set verify off
break on name
column gname new_value _name noprint
select substr(global_name,1,instr(global_name,'.')-1)gname
from global_name;
clear breaks
break on password
column password new_value _pwd noprint
select password from dba_users
where username = upper('usrname');
alter user usrname identified by dummy;
connect usrname/dummy@_name
alter user usrname identified by values '_pwd';
@login
Reply Separator
Author: Mark Leith [EMAIL PROTECTED]
Date: 12/17/2002 3:34 AM
Check the post-it note on their monitor?
:)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paulo Gomes
Sent: 17 December 2002 10:55
To: Multiple recipients of list ORACLE-L
Subject: RE: password
he can't but he can change it to a new one and then put the old back on
-Original Message-
From: faisal ahmad [mailto:[EMAIL PROTECTED]]
Sent: terça-feira, 17 de Dezembro de 2002 4:09
To: Multiple recipients of list ORACLE-L
Subject: password
how can a dba see the password of a user.
The new MSN 8: smart spam protection and 2 months FREE* -- Please see
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: faisal ahmad
INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051
http://www.fatcity.com San Diego, California -- Mailing list and web hosting
services ---
-- To REMOVE yourself from this mailing list, send an E-Mail message to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message
BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list
you want to be removed from). You may also send the HELP command for other
information (like subscribing).
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEAD
META content=text/html; charset=iso-8859-1 http-equiv=Content-Type
META content=MSHTML 5.00.3510.1100 name=GENERATOR/HEAD
BODY
DIVFONT color=#ff face=Arial size=2SPAN class=923033611-17122002Check
the post-it note on their monitor? /SPAN/FONT/DIV
DIVFONT color=#ff face=Arial size=2SPAN
class=923033611-17122002/SPAN/FONTnbsp;/DIV
DIVFONT color=#ff face=Arial size=2SPAN
class=923033611-17122002:)/SPAN/FONT/DIV
BLOCKQUOTE style=MARGIN-RIGHT: 0px
DIV align=left class=OutlookMessageHeader dir=ltrFONT face=Tahoma
size=2-Original Message-BRBFrom:/B [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]BOn Behalf Of /BPaulo GomesBRBSent:/B 17
December 2002 10:55BRBTo:/B Multiple recipients of list
ORACLE-LBRBSubject:/B RE: passwordBRBR/DIV/FONT
DIVFONT color=#ff face=Arial size=2SPAN class=201495710-17122002he
can't but he can change it to a new one and then put the old back
on/SPAN/FONT/DIV
BLOCKQUOTE
DIV align=left class=OutlookMessageHeader dir=ltrFONT face=Tahoma
size=2-Original Message-BRBFrom:/B faisal ahmad
[mailto:[EMAIL PROTECTED]]BRBSent:/B terça-feira, 17 de
Dezembro de 2002 4:09BRBTo:/B Multiple recipients of list
ORACLE-LBRBSubject:/B passwordBRBR/DIV/FONT
DIV
DIVhow can a dba see the password of a user./DIV/DIVBR clear=all
HR
The new A href=http://g.msn.com/8HMAEN/2018;MSN 8:/A smart spam
protection and 2 months FREE* -- Please see the official ORACLE-L FAQ:
http://www.orafaq.com -- Author: faisal ahmad INET:
[EMAIL PROTECTED] Fat City Network Services -- 858-538-5051
http://www.fatcity.com San Diego, California -- Mailing list and web hosting
services
- To
REMOVE yourself from this mailing list, send an E-Mail message to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message
BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list
you want to be removed from). You may also send the HELP command for other
information (like subscribing). /BLOCKQUOTE/BLOCKQUOTE/BODY/HTML
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
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
Itanium 2
Title: Itanium 2 Has anybody out there tried and Itanium 2 system? I read that oracle is supposed to certify 9i on it at the end of the month. But I was wondering if anybody had installed one of the Developer Release's. If so what kind of performance did it give you? Anywhere close to what Intel is claiming?
RE: Stored procedure memory problem
Venu, Another issue to be concerned about is the possibility of encountering an ORA-1555 error. This error may be triggered by a condition called 'Fetch Across Commits'. The cursor must maintain read consistency while it is open. If you are updating the source data and the undo entries are overwritten (assuming you commit periodically), then a read consistent version cannot be created. There are two docs/presentations to review. The first is 'Cats Dogs and ORA-01555' which is available at www.evdbt.com/papers.htm. The other is 'UNDO Internals' at www.optimaldba.com/library.html. Dan Fink -Original Message- Sent: Tuesday, December 17, 2002 8:54 PM To: Multiple recipients of list ORACLE-L A small question to all gurus on the list... I have a stored procedure (SP) which runs at specific intervals. It fetches a list of user names and few (2 columns) of their details into a cursor and processes them one by one in a cursor FOR loop. Now my question is, Is there a chance of the SP running out of memory when the number of users increases (may be a few hundreds of thousands). If yes how to estimate the maximum number of user names my cursor can handle? Is there any calculation for this? How to overcome this problem? Is there anything else that has to be taken into account when doing this? Thanks in advance! Venu G. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Methods to get DDL
Oracle Enterprise Manager 9.2 version has it. Right click on the object and choose Show Object DDL If you use 9.2, you can use dbms_metadata.get_ddl procedure. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:15 AM I finally have a bit of time and was wondering what are different methods to get DDL other than Export rows=n Using Quest SQL navigator Using The Databee tool Ideally Id like to get it from a sql plus command but Im pretty sure that's not available. DDL dosnt seem to be available from DBA studio either... Im wondering what methods people are using? I'd like a quick way to get the ddl for say... One index Thanks in advance bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: db block Size for Indexes Tablespaces in 9.2 ?
I have a rule - don'thand out advise with limited information - it may be "factually challenged". and sometimes I break my own rules - as in this case. But then again, this is not "advise"; merely my opinion based on the very limited background information I had. I agree - the panacea to an index "buffer busy waits" is not simply the block size; rather a complex co-determination of several factors and solutions like reverse key indexes, block size, free lists, elimination of synthetic keys, the load pattern, etc. But given that selects are 60% of the queries transaction rate is high to very high OLTP is primary for performance tuning what options do we have? Elimination of synthetic keys _MAY_ not be an option in this case, due to third party application, etc. Reverse key Indexes have their own problems - they consume more space and sometimes the optimizer does a index fullscan instead of a row get. So the only thing a DBA can possibly do at this time is in block sizes. Again, this is, of course, my assumption. So given the information by the questioner - the biggest bang for the buck is by specifying the smaller block size. It may however be different if a bench mark is performed at the site using the specific customer profile. As to the article, Vivek, I read it thoroughly and I still stand by what I said. The author primarily advocates that more blevels are bad for performance a higher block size contains more rows per block more rows implies less blevel and, therefore, a large block size implies better performance However, this probably ignores the buffer busy waits condition. More rows in a block implies that two sessions are more likely to access rows in the same block - creating a buffer busy condition - more so in a RAC environment. So I advocate less number of rows in a block. The author also relies heavily on the index rebuilds a lot to eliminate the blevels, not just block sizes. Caveat - see the most waits occurring in your system - if after a smaller block size your index "db file sequential read" increases, then you are better off using a larger block size and suffer buffer busy waits. Benchmark, benchmark. There is no substitute for benchmark specific to your situation. In my shop, we have 9.2 in a DW environment where the block size is the same (16K) for indexes and tables. For other two OLTP based apps, I have defined 8K tables and 4K indexes for a third party app. I did a benchmark to see the effects and that was the conclusion. Unfortunately I didn't save it. HTH. Arup Nanda - Original Message - From: "Jonathan Lewis" [EMAIL PROTECTED] To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 6:19 AM Subject: Re: db block Size for Indexes Tablespaces in 9.2 ? I think there are too many generic arguments available for picking the 'right' block size for your indexes. The one that is most appropriate is likely to depend on the nature of the activity (load vs. query), nature of the index (unique, nearly unique, far from unique), data clustering, order of data arrival, frequency of data arrival, pattern of data deletion/update, stability of volume, nature of queries (big or small range scans), potential of modifying number of branches, buffering effects, and whether or not you are using a filesystem with or without direct i/o. Given another 10 minutes I might come up with a few more ideas. Your strategy should be to identify the extreme, and critical, characteristics of your system and play to them - small block size may be appropriate, reverse indexes may be appropriate, getting rid of the synthetic key that is likely to cause a problem may be appropriate. But don't assume that anything as trivial as tweaking a block size is a driving feature of making your index work well. Which test case would you like to see - the one I did for company X that showed they needed a small block size, or the one I did for company Y that showed they needed a large block size ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 18 December 2002 05:59 Hi Arup , List Your point is Correct about High "buffer busy wait" Contention During Large OLTP Insert /Updates. High "buffer busy wait" on Corresponding INDEX during INSERT Operations was Observed during our previous benchmark which overcame by Converting to REVERSE Index as the Field Value was Sequentially Increasing . Following Article advocates HIGHER Block Size for Index , Strangely :-
RE: slow query help
Raj, I thought it would only do the union all if it was able to use an index and all the instr's look as though they'd stop that. Even then I thought it was generally just rule that would do that unless you used the use_concat hint. I can't see why a full table scan of each wouldn't be fairly efficient unless the result set is only a small fraction of the total possible rows. I may have missed some e-mails which make the above statements irrevelant, if so my apologies. Iain -Original Message- Sent: 18 December 2002 13:55 To: Multiple recipients of list ORACLE-L Joan, Here is a suggestion ... if this is going to be your most used part, I'd look into Intermedia ... you'll have a lot more options to work with and they will work good. Until then, I'd recommend replacing instr() with appropriate LIKE clause because at-least it will help you use an index. Through a DB trigger ensure that all names (first/middle/last) are always in UPPER so you don't have to pur UPPER or deal with FBI. Initially I thought of merging all clauses into one, but then I realized, Oracle will end up doing what I un-did (it will replace all OR conditions to UNION ALL anyways). Happy Holidays Everyone !! Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicoll, Iain INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 bug 2316137
Title: RE: Oracle bug 2316137 If you have cursor_sharing=force ... can you use cursor_sharing=exact and see if the error reproduces? I think (and I could be wrong) that this setting will at-least buy you some time. Search for 'kksscl-inf-inl-loop' including bug database, you'll find many references. Basically it means the process has gone into an infinite loop scanning shared cursors. Have you talked to OWS ... time to call them. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Glenn Stauffer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:20 AM To: Multiple recipients of list ORACLE-L Subject: Oracle bug 2316137 We've just started experiencing a problem where a client-server Forms 4.5 application hangs and then produces this error: ORA-00600: internal error code, arguments: [kksscl-inf-inl-loop], [1500], [0], [1], [41], [41], [], [] Our database is version 9.2 and we found reference to a bug on metalink, 2316137, though we can't see the details. We are planning an off-hours upgrade to 9.2.0.2 which is said to fix this problem; in the meantime, we can clear up the condition causing this error by bouncing the instance. Then things work for a while until the error starts to occur again (last time it cleared up for about a week). Since it is several weeks before I can get the downtime to apply the upgrade, I'm wondering if anyone has had experience with this problem and whether there is a temporary fix short of updating the Oracle software. Thanks -- Glenn Stauffer [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.*2
Re: career questions
I have gone the consulting route three times in my career. Here are some observations in no particular order of importance. Solo is a tough way to go. You have to find the business and do the work. Either, done right is a full time job. In spite of the fact that as professionals we place a lot of weight on technical expertise, the people that hire you frequently do not know how to evaluate your skills. Being able to fit into their comfort zone is frequently more important than abilities. If you can consistently make your deadlines you are going to build a solid reputation. People who hire you like on time, on budget performance. Do not be too intimidated by a specific set of required skills. My first Oracle gig resulted from a conflict between a director and an IT manager. The Director knew exactly what she wanted and the IT manager was sending her project to the back of the bus. After the project was successfully implemented, 18 months later, I asked her why she had hired me over all of the people with Oracle experience. Her answer was simple, You listened to me. She knew what she wanted and she felt I could deliver it for her. That lucky assignment opened a whole new career for me. Integrity matters. Your word does need to be your bond as a consultant. If you work for a consulting firm, make sure that they can deliver the kind of assignments that are good for your career. I worked at one for about six months in a variety of different assignments. Some Oracle, some not. When I complained about the lack of consistent Oracle work, one of my coworkers laid it all out for me, This is a good place to work if you are a money whore. I wanted my life defined by more than money so I left. My two cents worth and you get what you pay for. --- Maria Aurora VT de la Vega [EMAIL PROTECTED] wrote: Gurus, I have been an Oracle DBA for almost 5 years and would like very much to venture into independent Oracle consulting (part-time). As i have spent most of these 5 years as a sole DBA for different companies, studying and learning the ropes of Oracle Administration through books, magazines, test machines and this list, I feel confident enough to handle most Oracle issues. At the same time, I still have that feeling of inadequacy. I am not sure if I am good enough to offer my services to local companies. That said, I'd like to ask every one who are into consulting (on their own or as a part-time gig) what are the technical and soft skills necessary before I even think about consulting. How would you know that you're technically ready for it. And how do I get started. Tips are welcome too! Thanks everyone. =) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
iAS 1.0.2.2.2a vs 9iR2 db
I know this is probably hopeless, but has anyone managed to let the Oracle Portal Configuration Assistant bundled with iAS 1.0.2.2.2a for win32 connect to a 9i database? It wants to connect as SYS, and of course 9i only wants sys to connect as sysdba. This if for my home sandbox PC, I don't have enough RAM on it to install ias 9iR2, so I am trying to jam iAS 1.0.2.2.2a in there. If connections to 9i are not possible I suppose I will have to use 8.1.7.4.6. for that machine. Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Capacity Planning -- Expecting the DB growth !!!
Thanks, Dave! I just started looking into using DBMS_SPACE. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 11:14 AM Ruth, have you seen this doc on metastink? It might be helpful. Note:116923.1 Dave -Original Message- Sent: Wednesday, December 18, 2002 9:04 AM To: Multiple recipients of list ORACLE-L Jared, Can you send me the script you use. I can't even figure out the syntax for DBMS_SPACE from the docs. I would be very grateful Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 3:58 PM I use DBMS_SPACE to calculate the actual size of all data objects in our SAP databases. The data is collected once a week. Once a month I use the collected data to create an aggregate table via Oracle's linear regression and partitioning SQL operators. Run the projections for the current month, end of year, the 2 following 6 month periods, put the data in excel and chart it. Earlier this year my projection for SAP running out of space was 6/28/02. There were some delays in getting the new storage hardware installed. Guess which day we ran out of space? ;) That was just dumb luck that it happened the same day, but now people believe my projections. :) I opted for the use of DBMS_SPACE, as that is the best way to find out how much space is actually being used for data. I didn't care about allocated empty blocks, or how big the tablespaces were. There's now about 14 months of data for this, and though growth is not alwasy linear, it's still better than a SWAG. Jared Reddy, Madhusudana [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2002 11:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Capacity Planning -- Expecting the DB growth !!! Hello All, It should include all as you said , but since I do not belong to a capacity planning group in my shop , I mostly concentrate on the DB growth . I have taken Sales as business object to correlate with the DB size . I think in our case both of them are directly proportional. ( Business objects may vary from shop to shop ) first step I have done is calculating the : Growth factor = avg. History Db growth / avg Hist Sales growth Second Step : identifying the Sales projection for the next fiscal year ( Ie. I have to get sales growth percentage from the business team , for example 15% and multiply with sales history, for each week I guess.) 3rd step: Now I have sales projection and growth Factor , and can the projected DB growth . Well The above is the thing I am working on by having some queries to get the data from the DB. Also I have to automate the whole process . I would like to know how this Capacity planning followed in your shop. What's your answer when your group manager asks how much disk we need for holiday prep ?? Like this we can have many questions. I know somebody is having a better approach getting followed . Would appreciate if you share with us. or somebody can better help me in identifying the Q? from managers Thank YOU all for your replies Madhu -Original Message- Sent: Tuesday, December 17, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Check the link Kirti has posted (orapub). Is capacity planning only on the database size ? In my mind it also includes : Transaction description (online and batch) Transaction frequency (online and batch) Transaction window Networking requirements Number of users (all and concurrent) Overall disk space (inside and outside the database) Availability --- Reddy, Madhusudana [EMAIL PROTECTED] a écrit : Hello All, I am currently working on capacity planning of the database , expecting the database size based on the business object ,sales ( Historical data). I am not sure about the approach I am following . I believe there might be some better approach followed in some shop to estimate the DB size , even by considering events like thanks giving , holiday season and all. Also I have to automate this process. Would like to know some best suggestions you always have in this forum. Would you help me in identifying some formulae. Any kind of documentation will be a great help !!! Thanks in advance, Madhu ATTACHMENT part 2 image/gif name=Blank Bkgrd.gif = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting
RE: Informix backups
Title: RE: Informix backups by all means Gene, test it... and watch out for that boogeyman named Rman. Lisa Koivu Oracle Database Something. Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Gene Sais [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:20 AM To: Multiple recipients of list ORACLE-L Subject: OT: Informix backups The SysAdmin is backing up the filesystems/raw partitions where the informix db resides w/out putting the db in hot backup mode. He was told by a consultant, all you have to do is backup the informix logs and db files for full recovery. As an Oracle DBA and not familiar w/ informix, is this informix db backup recoverable? Thanks, Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Methods to get DDL
Any non-totally-up-to-date tool will typically struggle to get *all* of the ddl. A good example would be in 9i where the table compression flag has unfortunately been left off the dba_tables view. The info is of course there (tucked away in seg$) but you're setting yourself up for a lot of work if you head down into those levels.. Similarly, if you wanted a constraint which was based on an index with different columns. Obviously you need to create the index before the constraint. Pre-9 you have to go hacking around cdef$... ugh! I'd stick with exp rows=n hth connor --- Koivu, Lisa [EMAIL PROTECTED] wrote: Bob, TOAD (freeware version) will do it for you also. However, as far as scheduling something to run regularly, exp rows=n is the easiest. Lisa Koivu Oracle Datablackeye Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- Sent: Wednesday, December 18, 2002 10:16 AM To: Multiple recipients of list ORACLE-L I finally have a bit of time and was wondering what are different methods to get DDL other than Export rows=n Using Quest SQL navigator Using The Databee tool Ideally Id like to get it from a sql plus command but Im pretty sure that's not available. DDL dosnt seem to be available from DBA studio either... Im wondering what methods people are using? I'd like a quick way to get the ddl for say... One index Thanks in advance bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:
You're right of course, sorry, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:30 AM I thought, it was: ARE YOU AN IDIOT? :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:04 AM Ok, I'll ask the obligatory 'Are you stupid?' Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 9:19 AM EDOUARD, EDOUARD, EDOUARD HELP! -Original Message- Sent: Wednesday, December 18, 2002 7:24 AM To: Multiple recipients of list ORACLE-L SET ORACLE-L DIGEST EDOUARD DORMIDONTOV -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:
ðÏÍÏÝØ! -Original Message- Sent: Wednesday, December 18, 2002 10:30 AM To: Multiple recipients of list ORACLE-L I thought, it was: ARE YOU AN IDIOT? :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:04 AM Ok, I'll ask the obligatory 'Are you stupid?' Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 9:19 AM EDOUARD, EDOUARD, EDOUARD HELP! -Original Message- Sent: Wednesday, December 18, 2002 7:24 AM To: Multiple recipients of list ORACLE-L SET ORACLE-L DIGEST EDOUARD DORMIDONTOV -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Capacity Planning -- Expecting the DB growth !!!
Ruth, have you seen this doc on metastink? It might be helpful. Note:116923.1 Dave -Original Message- Sent: Wednesday, December 18, 2002 9:04 AM To: Multiple recipients of list ORACLE-L Jared, Can you send me the script you use. I can't even figure out the syntax for DBMS_SPACE from the docs. I would be very grateful Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 3:58 PM I use DBMS_SPACE to calculate the actual size of all data objects in our SAP databases. The data is collected once a week. Once a month I use the collected data to create an aggregate table via Oracle's linear regression and partitioning SQL operators. Run the projections for the current month, end of year, the 2 following 6 month periods, put the data in excel and chart it. Earlier this year my projection for SAP running out of space was 6/28/02. There were some delays in getting the new storage hardware installed. Guess which day we ran out of space? ;) That was just dumb luck that it happened the same day, but now people believe my projections. :) I opted for the use of DBMS_SPACE, as that is the best way to find out how much space is actually being used for data. I didn't care about allocated empty blocks, or how big the tablespaces were. There's now about 14 months of data for this, and though growth is not alwasy linear, it's still better than a SWAG. Jared Reddy, Madhusudana [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2002 11:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Capacity Planning -- Expecting the DB growth !!! Hello All, It should include all as you said , but since I do not belong to a capacity planning group in my shop , I mostly concentrate on the DB growth . I have taken Sales as business object to correlate with the DB size . I think in our case both of them are directly proportional. ( Business objects may vary from shop to shop ) first step I have done is calculating the : Growth factor = avg. History Db growth / avg Hist Sales growth Second Step : identifying the Sales projection for the next fiscal year ( Ie. I have to get sales growth percentage from the business team , for example 15% and multiply with sales history, for each week I guess.) 3rd step: Now I have sales projection and growth Factor , and can the projected DB growth . Well The above is the thing I am working on by having some queries to get the data from the DB. Also I have to automate the whole process . I would like to know how this Capacity planning followed in your shop. What's your answer when your group manager asks how much disk we need for holiday prep ?? Like this we can have many questions. I know somebody is having a better approach getting followed . Would appreciate if you share with us. or somebody can better help me in identifying the Q? from managers Thank YOU all for your replies Madhu -Original Message- Sent: Tuesday, December 17, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Check the link Kirti has posted (orapub). Is capacity planning only on the database size ? In my mind it also includes : Transaction description (online and batch) Transaction frequency (online and batch) Transaction window Networking requirements Number of users (all and concurrent) Overall disk space (inside and outside the database) Availability --- Reddy, Madhusudana [EMAIL PROTECTED] a écrit : Hello All, I am currently working on capacity planning of the database , expecting the database size based on the business object ,sales ( Historical data). I am not sure about the approach I am following . I believe there might be some better approach followed in some shop to estimate the DB size , even by considering events like thanks giving , holiday season and all. Also I have to automate this process. Would like to know some best suggestions you always have in this forum. Would you help me in identifying some formulae. Any kind of documentation will be a great help !!! Thanks in advance, Madhu ATTACHMENT part 2 image/gif name=Blank Bkgrd.gif = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of
RE: Methods to get DDL
Create Your own script or find one in internet that uses data dictionary. Gints Plivna -Original Message- Sent: trediena, 2002. gada 18. decembr 17:16 To: Multiple recipients of list ORACLE-L I finally have a bit of time and was wondering what are different methods to get DDL other than Export rows=n Using Quest SQL navigator Using The Databee tool Ideally Id like to get it from a sql plus command but Im pretty sure that's not available. DDL dosnt seem to be available from DBA studio either... Im wondering what methods people are using? I'd like a quick way to get the ddl for say... One index Thanks in advance bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Methods to get DDL
Title: RE: Methods to get DDL Bob, TOAD (freeware version) will do it for you also. However, as far as scheduling something to run regularly, exp rows=n is the easiest. Lisa Koivu Oracle Datablackeye Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:16 AM To: Multiple recipients of list ORACLE-L Subject: Methods to get DDL I finally have a bit of time and was wondering what are different methods to get DDL other than Export rows=n Using Quest SQL navigator Using The Databee tool Ideally Id like to get it from a sql plus command but Im pretty sure that's not available. DDL dosnt seem to be available from DBA studio either... Im wondering what methods people are using? I'd like a quick way to get the ddl for say... One index Thanks in advance bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Kind of OT : Sungard Compass
Hi, Beginning january , I'll be on a team to implement Sungard Compass product which run on Oracle 817. Any comment on that product ? TIA = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Methods to get DDL
Title: RE: Methods to get DDL From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Im wondering what methods people are using? I'd like a quick way to get the ddl for say... One index TOAD
Re: Backup DB files to the Tape
I was thinking of simply copying the datafiles using the OS facilities. If you are putting hot backups to tape directly I am not sure that they will be usable for recovery. RMAN requires a third party media manager to handle backups to tape. If rman can't do it, I am not sure that homegrown scripts can either. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:24 AM Ruth, Does this mean hot backups don't work for UnixWare 7.1? Otherwise, cp, cpio, ufsdump or any other method of copying the disk file from location a to location b should be ok, shouldn't it? John -Original Message- Sent: Wednesday, December 18, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Just remember, I you don't have the database shutdown while you back them up the backups will be unusable. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:29 AM Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . Regards Dilmohan Ashraf Salaymeh wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--
RE: Stored procedure memory problem
Title: RE: Stored procedure memory problem As long as you are committing transactions, you shouldn't worry. Beware of leaking Oracle processes though ... they might harm you. On 9012 we have two packages that run ALL the time basically they de-queue from a multiple of AQs and perform post-processing on them. We bounce these processes once in about 3 weeks (stop, wait 1 second, restart) or when PGA crosses 126M. We have seen them causing havoc when PGA exceeds 128M, due to leaking smon on (oracle and os) version combination. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! 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.*2
RE: Methods to get DDL
Title: RE: Methods to get DDL The only problem with TOAD I have is I soon forgot where information is stored to write the script by hand. It is a nice tool, I have been using it since late 96, but that's a problem with all GUIs ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Jeremy Pulcifer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:30 AM To: Multiple recipients of list ORACLE-L Subject: RE: Methods to get DDL From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Im wondering what methods people are using? I'd like a quick way to get the ddl for say... One index TOAD *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: Win2K Mount Points
Nigel, Finally, as this is my first post to the list, perhaps I should introduce myself as a lurker(!): Congratulations on your change in status! RE the mount points: I'm still fairly OS illiterate with many features of NT/Win2k. Do you have a good URL that would explain the use of mount points? Sorry for not being much help on this topic, but thanks for sharing your experiences. Jared Nigel Cemm [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2002 03:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Win2K Mount Points Hello, I have been tasked to upgrade an existing Openserver 5 / 7.3.4 installation to a Win2K / 8.1.7 installation. The hardware is an IBM 8500R 8-way with 4GB main memory and 32 mirrored pairs. Under Unix it is simple to mount each filesystem at an appropriate mount point. However, the traditional method of using drive letters in Windows is somewhat limited by the number of available letters. The obvious solution with NTFS5 is to use mount points - which is what I have done. I have a directory located in $ORACLE_BASE under which I have mounted 25 of the mirrored pairs, i.e. all of the filesystems that will be used exclusively by Oracle Currently, the Openserver installation is still live and I am configuring the Win2K installation on identical h/w for a period of testing. Whilst I have had not had any issues with using NTFS5 mount points, I have been scratting around trying to find real-world experience of such a configuration. The official Oracle line (via an iTAR that I filed) is that as the base OS is fully supported, i.e. supported without certain features being excluded, the use of mount points is okay. However, should I observe any issues with such a configuration then any queries should be directed to Microsoft. The response is fair enough, I guess, but it didn't provide what I was asking for. Therefore, I would like to ask the wider audience if they have any experience of such a configuration, i.e. any known issues with NTFS5 mount points in general, the number that is safe to use beneath a base directory, recovery issues etc. I should point out that the application data that is stored in the database is roughly 80% static and 20% hot and in the ideal world the static data could be stored on a smaller number of larger arrays to allow the h/w to do most of the load balancing. However, I have no say in h/w matters so this isn't really an option for me. Finally, as this is my first post to the list, perhaps I should introduce myself as a lurker(!): I have enjoyed following the various discussion threads on a daily basis. The collaboration of people helping each other with common issues and the willingness to share expertise etc makes ORACLE-L a powerful resource. Many thanks. --- nigel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nigel Cemm INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: password
Downloaded and installed the tool. Not terribly sophistcated. If the word is not in the dictionary, it won't find it. For instance, a password of 'SHOE' will be discovered, but changing the O to a zero so that it reads 'SH0E', and the password cracker will not find it. If this were to be used as a serious security tool, you would be better off studying some of the well known password crackers and duplicating the algorithms in PL/SQL. Jared Mark Leith [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/18/2002 01:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: password And that is what it *should* be used for :) -Original Message- [EMAIL PROTECTED] Sent: 17 December 2002 19:35 To: Multiple recipients of list ORACLE-L Yes, it's a dictionary based cracker. Could be useful for checking for weak passwords. For $4, I'm going to see what it does. :) Jared John Kanagaraj [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2002 10:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: password Jared, This seems to be a 'brute force' dictionary based attack, as I believe the Oracle password is a one-way trapdoor (just as UNIX). I don't think this will be able to crack a strong password created from say a combination of the first characters of an arbitrary sentence. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 So WHO is the Reason for the Season?! Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 9:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: password Hmm... Well maybe you *can* crack oracle passwords. I've just ordered the full version of this product. ( $4, I don't think I need to bother the purchasing department ). I'll let you know how it works. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Capacity Planning -- Expecting the DB growth !!!
I can forward a script that shows how to use DBMS_SPACE.
The other stuff I mentioned is not exactly in packagable form.
Just use:
exec show_space('SCOTT','EMP')
Jared
create or replace procedure show_space (
p_segname in varchar2
, p_owner in varchar2 default user
, p_type in varchar2 default 'TABLE'
, p_partition in varchar2 default null
)
as
l_free_blocks number;
l_total_blocks number;
l_total_bytes number;
l_unused_bytes number;
l_unused_blocks number;
l_LastusedExtFileId number;
l_LastUsedExtBlockIdnumber;
l_last_used_block number;
l_segname varchar2(30);
l_owner varchar2(30);
l_type varchar2(20);
l_partition varchar2(30);
procedure p( p_label in varchar2, p_num in number )
is
begin
dbms_output.put_line(rpad(p_label,40,'.')||p_num);
end;
begin
l_segname := upper(p_segname);
l_owner := upper(p_owner);
l_type := upper(p_type);
l_partition := upper(p_partition);
dbms_space.free_blocks (
segment_owner = l_owner
, segment_name = l_segname
, segment_type = l_type
, partition_name= l_partition
, freelist_group_id = 0
, free_blks = l_free_blocks
);
dbms_space.unused_space (
segment_owner = l_owner
, segment_name = l_segname
, segment_type = l_type
, partition_name= l_partition
, total_blocks = l_total_blocks
, total_bytes = l_total_bytes
, unused_blocks = l_unused_blocks
, unused_bytes = l_unused_bytes
, last_used_block = l_last_used_block
, last_used_extent_file_id = l_LastusedExtFileId
, last_used_extent_block_id = l_LastUsedExtBlockId
);
p( 'Free Blocks', l_free_blocks);
p( 'Total Blocks', l_total_blocks);
p( 'Total Bytes', l_total_bytes);
p( 'Unused Blocks', l_unused_blocks);
p( 'Unused Bytes', l_unused_bytes);
p( 'Last Used Ext FileId', l_LastusedExtFileId);
p( 'Last Used Ext BlockId', l_LastUsedExtBlockId);
p( 'Last Used Block', l_last_used_block);
end;
/
show error procedure show_space
Ruth Gramolini [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/18/2002 07:04 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Capacity Planning -- Expecting the DB growth !!!
Jared,
Can you send me the script you use. I can't even figure out the syntax
for
DBMS_SPACE from the docs. I would be very grateful
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 17, 2002 3:58 PM
I use DBMS_SPACE to calculate the actual size of all data objects
in our SAP databases. The data is collected once a week.
Once a month I use the collected data to create an aggregate
table via Oracle's linear regression and partitioning SQL operators.
Run the projections for the current month, end of year, the 2 following
6 month periods, put the data in excel and chart it.
Earlier this year my projection for SAP running out of space was 6/28/02.
There were some delays in getting the new storage hardware installed.
Guess which day we ran out of space? ;)
That was just dumb luck that it happened the same day, but now people
believe my projections. :)
I opted for the use of DBMS_SPACE, as that is the best way to find out
how much space is actually being used for data. I didn't care about
allocated empty blocks, or how big the tablespaces were.
There's now about 14 months of data for this, and though growth is not
alwasy linear, it's still better than a SWAG.
Jared
Reddy, Madhusudana [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/17/2002 11:25 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Capacity Planning -- Expecting the DB growth
!!!
Hello All,
It should include all as you said , but since I do not belong to a
capacity
planning group in my shop , I mostly concentrate on the DB growth . I have
taken Sales as business object to correlate with the DB size . I think in
our case both of them are directly
Re: Methods to get DDL
Small amounts: sqlplus and the data dictionary. Lot's o' DDL: Perl, DBI, DBD::Oracle and DDL::Oracle. If that's unavailable, I use exp, then grep, sed and maybe vi to extract and cleanup the exp DDL. If unix bin utilities are unavailable, I install cygwin on a Windoze machine to make them available. If not allowed to do that, well, just go home. Jared Bob Metelsky [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/18/2002 07:15 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Methods to get DDL I finally have a bit of time and was wondering what are different methods to get DDL other than Export rows=n Using Quest SQL navigator Using The Databee tool Ideally Id like to get it from a sql plus command but Im pretty sure that's not available. DDL dosnt seem to be available from DBA studio either... Im wondering what methods people are using? I'd like a quick way to get the ddl for say... One index Thanks in advance bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Oracle shadow processes run amok after system clock changed
No, this was the middle of the afternoon. Each of those runaway processes were at one time associated with various users in the database doing various tasks, mostly selects. No user complained, so I assume they got detached from their shadow and maybe thought they were logged out? I was surprised that the majority still had inactive database connections. At 04:08 PM 12/17/2002 -0800, Stephane Faroult wrote: Out of the top of my mind, and in the middle of the night : Oracle jobs? RECO trying to fix things? -- Deborah Lorraine wrote: For those of you DBA's with a UNIX/SYSADMIN background, what do you think of this problem: For a yet-to-be-explained reason, the system clock on our sun database server suddenly changed back 1 hour and 16 minutes sometime around 4 p.m. yesterday afternoon. The initial symptoms were that users could not log in to the database (we use kerberos for authenticating most user accounts which requires an accurate time), and we had an unusually high load average of 77! Once we finally figured out the clock was off and the sysadmin reset it, the load average did not change even though users could log in again. We then noticed 72 (of ~500) oracle processes in the run state, all evenly collecting CPU time, although database performance was good. Some of these 72 processes were orphans and had no database process. Most had been doing simple selects, but not a single one was actually active in the database. Not all were kerberos-autenticated sessions. The only thing these processes had in common is that their process time stamps were in the hour period of that questionable time: oracle 11971 1 2 16:02:28 ? 18:05 oracleprod (LOCAL=NO) oracle 13335 1 2 16:19:40 ? 18:19 oracleprod (LOCAL=NO) oracle 9911 1 1 15:47:23 ? 18:18 oracleprod (LOCAL=NO) ... After the clock was reset to the correct time, these processes did not clear out but when killed, the load returned to normal. For the most part, Oracle is oblivious to the system clock setting so what could have caused the shadow processes to run amok? What could they be doing to generate CPU yet doing nothing in the database? Any ideas? Thanks, Debi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deborah Lorraine INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:
wow, that was unusual... ôÙ ÉÄÉÏÔ? :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 11:59 AM ðÏÍÏÝØ! -Original Message- Sent: Wednesday, December 18, 2002 10:30 AM To: Multiple recipients of list ORACLE-L I thought, it was: ARE YOU AN IDIOT? :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:04 AM Ok, I'll ask the obligatory 'Are you stupid?' Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 9:19 AM EDOUARD, EDOUARD, EDOUARD HELP! -Original Message- Sent: Wednesday, December 18, 2002 7:24 AM To: Multiple recipients of list ORACLE-L SET ORACLE-L DIGEST EDOUARD DORMIDONTOV -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: iAS 1.0.2.2.2a vs 9iR2 db
You need to set O7_DICTIONARY_ACCESSIBILITY=TRUE in the database. -- Paul -Original Message- Patrice J Sent: Wednesday, December 18, 2002 11:40 AM To: Multiple recipients of list ORACLE-L I know this is probably hopeless, but has anyone managed to let the Oracle Portal Configuration Assistant bundled with iAS 1.0.2.2.2a for win32 connect to a 9i database? It wants to connect as SYS, and of course 9i only wants sys to connect as sysdba. This if for my home sandbox PC, I don't have enough RAM on it to install ias 9iR2, so I am trying to jam iAS 1.0.2.2.2a in there. If connections to 9i are not possible I suppose I will have to use 8.1.7.4.6. for that machine. Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Methods to get DDL
Simon, thanks for the plug, although it helps if you tell them the name of the book :) caveat: the scripts were written for 7.3.4, and should work mostly on 8i but have NOT been updated for 9i so if you are using any of the 8i or 9i new features they may not work. Rachel --- [EMAIL PROTECTED] wrote: There are scripts out there that will do the job, though most of them start to fall down if the indexes are at all unusual. I bought a book a couple of years ago with a whole selection of scripts to create ddl for database objects - It should still be available on Amazon. Cheers Simon Anderson Please respond to [EMAIL PROTECTED] I finally have a bit of time and was wondering what are different methods to get DDL other than Export rows=n Using Quest SQL navigator Using The Databee tool Ideally Id like to get it from a sql plus command but Im pretty sure that's not available. DDL dosnt seem to be available from DBA studio either... Im wondering what methods people are using? I'd like a quick way to get the ddl for say... One index Thanks in advance bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle bug 2316137
On Wed, 2002-12-18 at 11:49, Jamadagni, Rajendra wrote: If you have cursor_sharing=force ... can you use cursor_sharing=exact and see if the error reproduces? I think (and I could be wrong) that this setting will at-least buy you some time. I'll have to try that idea. Search for 'kksscl-inf-inl-loop' including bug database, you'll find many references. Basically it means the process has gone into an infinite loop scanning shared cursors. I can't access the bug database for some reason; I should contact them about that. Something that hasn't come up before. Glenn Have you talked to OWS ... time to call them. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Glenn Stauffer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:20 AM To: Multiple recipients of list ORACLE-L Subject: Oracle bug 2316137 We've just started experiencing a problem where a client-server Forms 4.5 application hangs and then produces this error: ORA-00600: internal error code, arguments: [kksscl-inf-inl-loop], [1500], [0], [1], [41], [41], [], [] Our database is version 9.2 and we found reference to a bug on metalink, 2316137, though we can't see the details. We are planning an off-hours upgrade to 9.2.0.2 which is said to fix this problem; in the meantime, we can clear up the condition causing this error by bouncing the instance. Then things work for a while until the error starts to occur again (last time it cleared up for about a week). Since it is several weeks before I can get the downtime to apply the upgrade, I'm wondering if anyone has had experience with this problem and whether there is a temporary fix short of updating the Oracle software. Thanks -- Glenn Stauffer [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Glenn Stauffer [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Capacity Planning -- Expecting the DB growth !!!
Thanks a million! Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 18, 2002 12:50 PM
I can forward a script that shows how to use DBMS_SPACE.
The other stuff I mentioned is not exactly in packagable form.
Just use:
exec show_space('SCOTT','EMP')
Jared
create or replace procedure show_space (
p_segname in varchar2
, p_owner in varchar2 default user
, p_type in varchar2 default 'TABLE'
, p_partition in varchar2 default null
)
as
l_free_blocks number;
l_total_blocks number;
l_total_bytes number;
l_unused_bytes number;
l_unused_blocks number;
l_LastusedExtFileId number;
l_LastUsedExtBlockIdnumber;
l_last_used_block number;
l_segname varchar2(30);
l_owner varchar2(30);
l_type varchar2(20);
l_partition varchar2(30);
procedure p( p_label in varchar2, p_num in number )
is
begin
dbms_output.put_line(rpad(p_label,40,'.')||p_num);
end;
begin
l_segname := upper(p_segname);
l_owner := upper(p_owner);
l_type := upper(p_type);
l_partition := upper(p_partition);
dbms_space.free_blocks (
segment_owner = l_owner
, segment_name = l_segname
, segment_type = l_type
, partition_name= l_partition
, freelist_group_id = 0
, free_blks = l_free_blocks
);
dbms_space.unused_space (
segment_owner = l_owner
, segment_name = l_segname
, segment_type = l_type
, partition_name= l_partition
, total_blocks = l_total_blocks
, total_bytes = l_total_bytes
, unused_blocks = l_unused_blocks
, unused_bytes = l_unused_bytes
, last_used_block = l_last_used_block
, last_used_extent_file_id = l_LastusedExtFileId
, last_used_extent_block_id = l_LastUsedExtBlockId
);
p( 'Free Blocks', l_free_blocks);
p( 'Total Blocks', l_total_blocks);
p( 'Total Bytes', l_total_bytes);
p( 'Unused Blocks', l_unused_blocks);
p( 'Unused Bytes', l_unused_bytes);
p( 'Last Used Ext FileId', l_LastusedExtFileId);
p( 'Last Used Ext BlockId', l_LastUsedExtBlockId);
p( 'Last Used Block', l_last_used_block);
end;
/
show error procedure show_space
Ruth Gramolini [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/18/2002 07:04 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Capacity Planning -- Expecting the DB growth !!!
Jared,
Can you send me the script you use. I can't even figure out the syntax
for
DBMS_SPACE from the docs. I would be very grateful
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 17, 2002 3:58 PM
I use DBMS_SPACE to calculate the actual size of all data objects
in our SAP databases. The data is collected once a week.
Once a month I use the collected data to create an aggregate
table via Oracle's linear regression and partitioning SQL operators.
Run the projections for the current month, end of year, the 2 following
6 month periods, put the data in excel and chart it.
Earlier this year my projection for SAP running out of space was 6/28/02.
There were some delays in getting the new storage hardware installed.
Guess which day we ran out of space? ;)
That was just dumb luck that it happened the same day, but now people
believe my projections. :)
I opted for the use of DBMS_SPACE, as that is the best way to find out
how much space is actually being used for data. I didn't care about
allocated empty blocks, or how big the tablespaces were.
There's now about 14 months of data for this, and though growth is not
alwasy linear, it's still better than a SWAG.
Jared
Reddy, Madhusudana [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/17/2002 11:25 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Capacity Planning -- Expecting the DB growth
!!!
Hello All,
It should include all as you said , but since I do not belong to a
capacity
planning group in my shop , I mostly
RE: Win2K Mount Points
Yay! Finally! A question I can actually answer. http://support.microsoft.com/default.aspx?scid=KB;en-us;205524; describes the tools you can use to manipulate mount points in W2K, while http://support.microsoft.com/support/kb/articles/323/4/24.asp is the equivalent for Windows .NET Server. Cheers, -Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 1:04 PM To: Multiple recipients of list ORACLE-L Subject: Re: Win2K Mount Points Nigel, Finally, as this is my first post to the list, perhaps I should introduce myself as a lurker(!): Congratulations on your change in status! RE the mount points: I'm still fairly OS illiterate with many features of NT/Win2k. Do you have a good URL that would explain the use of mount points? Sorry for not being much help on this topic, but thanks for sharing your experiences. Jared Nigel Cemm [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2002 03:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Win2K Mount Points Hello, I have been tasked to upgrade an existing Openserver 5 / 7.3.4 installation to a Win2K / 8.1.7 installation. The hardware is an IBM 8500R 8-way with 4GB main memory and 32 mirrored pairs. Under Unix it is simple to mount each filesystem at an appropriate mount point. However, the traditional method of using drive letters in Windows is somewhat limited by the number of available letters. The obvious solution with NTFS5 is to use mount points - which is what I have done. I have a directory located in $ORACLE_BASE under which I have mounted 25 of the mirrored pairs, i.e. all of the filesystems that will be used exclusively by Oracle Currently, the Openserver installation is still live and I am configuring the Win2K installation on identical h/w for a period of testing. Whilst I have had not had any issues with using NTFS5 mount points, I have been scratting around trying to find real-world experience of such a configuration. The official Oracle line (via an iTAR that I filed) is that as the base OS is fully supported, i.e. supported without certain features being excluded, the use of mount points is okay. However, should I observe any issues with such a configuration then any queries should be directed to Microsoft. The response is fair enough, I guess, but it didn't provide what I was asking for. Therefore, I would like to ask the wider audience if they have any experience of such a configuration, i.e. any known issues with NTFS5 mount points in general, the number that is safe to use beneath a base directory, recovery issues etc. I should point out that the application data that is stored in the database is roughly 80% static and 20% hot and in the ideal world the static data could be stored on a smaller number of larger arrays to allow the h/w to do most of the load balancing. However, I have no say in h/w matters so this isn't really an option for me. Finally, as this is my first post to the list, perhaps I should introduce myself as a lurker(!): I have enjoyed following the various discussion threads on a daily basis. The collaboration of people helping each other with common issues and the willingness to share expertise etc makes ORACLE-L a powerful resource. Many thanks. --- nigel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nigel Cemm INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --
Re: Backup DB files to the Tape
I do not get it. If you put the tablespace in backup mode and then use the os utilities to copy the datafiles to tape why you can not use then for recover. Just restore the datafiles and the archive logs and do recover? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 7:04 PM I was thinking of simply copying the datafiles using the OS facilities. If you are putting hot backups to tape directly I am not sure that they will be usable for recovery. RMAN requires a third party media manager to handle backups to tape. If rman can't do it, I am not sure that homegrown scripts can either. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:24 AM Ruth, Does this mean hot backups don't work for UnixWare 7.1? Otherwise, cp, cpio, ufsdump or any other method of copying the disk file from location a to location b should be ok, shouldn't it? John -Original Message- Sent: Wednesday, December 18, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Just remember, I you don't have the database shutdown while you back them up the backups will be unusable. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:29 AM Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . Regards Dilmohan Ashraf Salaymeh wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an
RE:
Damn. Can't get the Russian-to-English translator working with any browser on Babelfish... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Igor Neyman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: wow, that was unusual... ôÙ ÉÄÉÏÔ? :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 11:59 AM ðÏÍÏÝØ! -- 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).
Regular Expressions in SQL
What's the easiest way to do regular expressions in an SQL query? If the answer is creating a function, does anyone have one they wouldn't mind sharing? Thanks, Chris Christopher Beckley OCPDBA, MCDBA, MCSD, EIEIO ThirdParadigm LLC [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).
Easy one: how to start EM OID?
I want to have the services necessary for Enterprise Manager and Oracle Internet Directory to start when I boot my machine. I understand where to put the scripts that start the processes; I just don't know which processes to start, apart from dbsnmp (which doesn't seem sufficient by itself). Any pointers to where I can find this kind of stuff would be most welcome. Cheers, -Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul E. Robichaux INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:
Rich, do you need a translation? ðÏÍÏÝØ! - HELP! ôÙ ÉÄÉÏÔ? - Are you an idiot? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:55 PM Damn. Can't get the Russian-to-English translator working with any browser on Babelfish... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Igor Neyman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: wow, that was unusual... ôÙ ÉÄÉÏÔ? :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 11:59 AM ðÏÍÏÝØ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Backup DB files to the Tape
I am using home grown scripts and they work. I have Legato use savepnpc (pre/post proc) command call this script: //begin snippet comment section #!/bin/ksh ### # $ORABIN/db_hot_backup.ksh ### # # Common script used to alter one database or all databases # on this server for hot backup mode (begin/end). # This script does NOT actually copy database files to disk # or to tape. # # Hot Backup Algorithm listed below: # 1) Alter system archive log current ; # 2) Check backup status. # 3) Generate datafile listing. # 4) Alter tablespace tablespace_name begin backup ; # 5) Some other process,script,legato,etc. will copy database files # to disk or to tape. # 6) Alter tablespace tablespace_name end backup ; # 7) Alter system archive log current ; # 8) Backup controlfile. # 9) Alter system archive log current ; # # Date Author Note # -- # 04/26/02 Gene Sais Original Creation # 08/02/02 Gene Sais Copied trace file to Hot Backup Location ### # Parameter Description # - --- sid=$1 # Database sid or all begend=$2 # Begin or End Hot Backup //end snippet comment section hth, Gene PS. I have tested recoveries and they worked, but soon my scripts will succumb to RMAN :). [EMAIL PROTECTED] 12/18/02 12:04PM I was thinking of simply copying the datafiles using the OS facilities. If you are putting hot backups to tape directly I am not sure that they will be usable for recovery. RMAN requires a third party media manager to handle backups to tape. If rman can't do it, I am not sure that homegrown scripts can either. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:24 AM Ruth, Does this mean hot backups don't work for UnixWare 7.1? Otherwise, cp, cpio, ufsdump or any other method of copying the disk file from location a to location b should be ok, shouldn't it? John -Original Message- Sent: Wednesday, December 18, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Just remember, I you don't have the database shutdown while you back them up the backups will be unusable. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:29 AM Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . Regards Dilmohan Ashraf Salaymeh wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
SQL tuning question.
Hello DBAs,
I am currently involved in improving the search performance for a tool
which queries a table having a million records (and the table is growing at
a rate of 3000 records per day).
Thought of introducing Intermedia search for 4 columns in the search table.
Created CONTEXT indexes to three varchar (4000) columns as well as a
varchar(500) column and used the CONTAINS keyword.
This has really improved the performance speed (5 times improvement) than
the previous LIKE clause query if the number of records returned are less
than 2000.
How ever, for those search criteria which returns more than 10,000
records, the query with CONTAINS clause is slower than the query with LIKE
clause :(
I thought it can never go worse :)
Here are the two queries:
1. using index
---
SELECT id FROM search_table WHERE contains (product, '{product_name}') 0
and (contains (VERSION1, '{ 11.0(1) }') 0 OR contains (VERSION2, '{
11.0(1) }') 0 OR contains (VERSION3, '{ 11.0(1) }') 0)
2. Without using index
SELECT /*+ PARALLEL(SEARCH_TABLE, 10) */ id FROM search_table WHERE
PRODUCT like '%product_name%' and (VERSION1 like '% 11.0(1) %' OR VERSION2
like '% 11.0(1) %' OR VERSION3 like '% 11.0(1) %')
Few facts
-
* VERSION is only one of the search criteria, for which I am currently
trying to improve the performance. By including the above 4 indexes, there
is going to be a total of 7 context indexes for this table!
* The query looks for the same version string in the 3 columns
version1, version2 and version3, which are populated from 3 different sources.
( We didn't want to mix them up and put into a single CLOB field). Each
version filed has multiple version strings separated by a space.
* The clause on the 'product' column is default for all the search
criteria, which has multiple product names separated by a space. So, I
thought of introducing Intermedia search for that column as well.
I am a new-comer in the field of sql tuning and I presume I am really
missing some thing here.
Is there any restriction that I cannot use Intermedia search for too many
columns in a table?
Is the order in which the query formed makes any difference?
Oracle version is Oracle8i Enterprise Edition Release 8.1.7.4.0.
Any help regarding this is highly appreciated.
Thank you,
-Jibo
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jibo John
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Backup DB files to the Tape
The key is putting the tablespace in backup mode. It then doesn't matter whether you write the file to disk or tape. Homegrown scripts will work just fine in writing directly to tape, although it should be quite a bit slower than writing to disk and then letting the system backup process simply sweep the directory to tape (preferred method). Regards, Bill Burke The Kinder and Gentler DBA www.OracleGuru.com www.KBMotorsports.biz -Original Message- Sent: Wednesday, December 18, 2002 12:56 PM To: Multiple recipients of list ORACLE-L I do not get it. If you put the tablespace in backup mode and then use the os utilities to copy the datafiles to tape why you can not use then for recover. Just restore the datafiles and the archive logs and do recover? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 7:04 PM I was thinking of simply copying the datafiles using the OS facilities. If you are putting hot backups to tape directly I am not sure that they will be usable for recovery. RMAN requires a third party media manager to handle backups to tape. If rman can't do it, I am not sure that homegrown scripts can either. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:24 AM Ruth, Does this mean hot backups don't work for UnixWare 7.1? Otherwise, cp, cpio, ufsdump or any other method of copying the disk file from location a to location b should be ok, shouldn't it? John -Original Message- Sent: Wednesday, December 18, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Just remember, I you don't have the database shutdown while you back them up the backups will be unusable. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:29 AM Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . Regards Dilmohan Ashraf Salaymeh wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing:
RE: career questions
Having been independent for over 20 years, and now a permanent employee (if anything is permanent) for the past three years, one idea might be to broker your services through placement or consulting firms where you have a better idea of the companies background and what you are getting in to. For the most part, I have never tried to go direct to the company/employer but rather have let placement/consulting firms do the leg work for me which allowed me to pick and choose which projects were best suited to my skills and objectives. Consulting always bring with it the problem of delivering exactly what they asked for, but not what they wanted... or in a worse case compromising your professional integrity by having to deliver lower quality which will ultimately come back to haunt you. I loved every minute of independent, but mainly because I was brokering my services and had the luxury of picking and choosing which project I wanted to work on. Times are a lot tougher right now for independents so choose carefully. Brokering is safer and someone else is doing the leg work. If you build a good relationship with a couple of placement/consulting firms you should be able to stay busy once the market picks up. My .02 Regards, Bill Burke The Kinder and Gentler DBA www.OracleGuru.com www.KBMotorsports.biz -Original Message- Sent: Wednesday, December 18, 2002 9:45 AM To: Multiple recipients of list ORACLE-L I have gone the consulting route three times in my career. Here are some observations in no particular order of importance. Solo is a tough way to go. You have to find the business and do the work. Either, done right is a full time job. In spite of the fact that as professionals we place a lot of weight on technical expertise, the people that hire you frequently do not know how to evaluate your skills. Being able to fit into their comfort zone is frequently more important than abilities. If you can consistently make your deadlines you are going to build a solid reputation. People who hire you like on time, on budget performance. Do not be too intimidated by a specific set of required skills. My first Oracle gig resulted from a conflict between a director and an IT manager. The Director knew exactly what she wanted and the IT manager was sending her project to the back of the bus. After the project was successfully implemented, 18 months later, I asked her why she had hired me over all of the people with Oracle experience. Her answer was simple, You listened to me. She knew what she wanted and she felt I could deliver it for her. That lucky assignment opened a whole new career for me. Integrity matters. Your word does need to be your bond as a consultant. If you work for a consulting firm, make sure that they can deliver the kind of assignments that are good for your career. I worked at one for about six months in a variety of different assignments. Some Oracle, some not. When I complained about the lack of consistent Oracle work, one of my coworkers laid it all out for me, This is a good place to work if you are a money whore. I wanted my life defined by more than money so I left. My two cents worth and you get what you pay for. --- Maria Aurora VT de la Vega [EMAIL PROTECTED] wrote: Gurus, I have been an Oracle DBA for almost 5 years and would like very much to venture into independent Oracle consulting (part-time). As i have spent most of these 5 years as a sole DBA for different companies, studying and learning the ropes of Oracle Administration through books, magazines, test machines and this list, I feel confident enough to handle most Oracle issues. At the same time, I still have that feeling of inadequacy. I am not sure if I am good enough to offer my services to local companies. That said, I'd like to ask every one who are into consulting (on their own or as a part-time gig) what are the technical and soft skills necessary before I even think about consulting. How would you know that you're technically ready for it. And how do I get started. Tips are welcome too! Thanks everyone. =) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!?
RE: Regular Expressions in SQL
Try: http://asktom.oracle.com/pls/ask/f?p=4950:8:1745425::NO::F4950_P8_DISPLAYID, F4950_P8_CRITERIA:2200894550208,%7Bregular%7D%20and%20%7Bexpressions%7D Ask Tom has whole write up on it. Greg -Original Message- Sent: Wednesday, December 18, 2002 2:04 PM To: Multiple recipients of list ORACLE-L What's the easiest way to do regular expressions in an SQL query? If the answer is creating a function, does anyone have one they wouldn't mind sharing? Thanks, Chris Christopher Beckley OCPDBA, MCDBA, MCSD, EIEIO ThirdParadigm LLC [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: Mirsky, Greg INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Regular Expressions in SQL
What do you mean by regular expressions is SQL... inquiring minds want to know Regards, Bill Burke The Kinder and Gentler DBA www.OracleGuru.com www.KBMotorsports.biz -Original Message- Sent: Wednesday, December 18, 2002 1:04 PM To: Multiple recipients of list ORACLE-L What's the easiest way to do regular expressions in an SQL query? If the answer is creating a function, does anyone have one they wouldn't mind sharing? Thanks, Chris Christopher Beckley OCPDBA, MCDBA, MCSD, EIEIO ThirdParadigm LLC [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: Burke, William F (Bill) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
