Sql Question
Hi List, Can someone give a SQL query to retuen all values in paricular column in comma separed format. e.g. suppose I fire "select deptno from dept" the output would be like Deptno 10 20 30 40 I want the output like 10,20,30,40. I am just wondering can it be done in a single query. TIA Kranti
RE: Size of segment
Heh, never claimed it was a good idea, just that it's possible =) Mike -Original Message- Sent: Monday, April 29, 2002 7:33 PM To: Multiple recipients of list ORACLE-L On Mon, Apr 29, 2002 at 09:29:31AM -0800, Hately Mike wrote: create tablespace disks_and index datafile '/disk1/disks_and index01.dbf' size 51m, '/disk2/disks_and index01.dbf' size 51m; create table mike01 ( x varchar(10) ) storage (initial 50m) tablespace disks_and index; create table mike01_ix on mike01(x) storage (initial 50m) tablespace disks_and index; I'm speachless, I am without speach. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sql Question
It cannot. You have to write a PL/SQL function which returns a VARCHAR for that. - Original Message - From: kranti pushkarna [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Mon, 29 Apr 2002 23:48:20 Hi List, Can someone give a SQL query to retuen all values in paricular column in comma separed format. e.g. suppose I fire select deptno from dept the output would be like Deptno 10 20 30 40 I want the output like 10,20,30,40. I am just wondering can it be done in a single query. TIA Kranti Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Financials Sys Admin. Needed in South Carolina
I think Oracle9i went into GA, on a limited set of platforms, in June 2001. The 9i beta program hadn't even started two years ago. Anyone with two years experience with it was likely on the Oracle development team. The requirement probably came from some HR person who simply adds requires two years experience to anything mentioned in the posting. The recruiters, with their astounding knowledge of the IT industry, simply typed it up and submitted it to the web sites. (That is what those big commissions are for isn't it? ;-) Don Granaman [OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, April 29, 2002 7:18 PM i rather suspect you are right Don considering that Oracle 9i was released when ? summer of 2001 ? how can one have 2 years of experience on 9i ? they probably meant to say 2 years of Oracle DBA experience or something to that effect , but have no idea what the hell that means anyway. also , the 9i certification program just started a last fall so unless you are upgrading from a previous certification i doubt anyone has completly finished this process. oh well , were just dba's , what the hell do we know anyway ? Peace ! Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: pl/sql is INTERPRETED?
Saw some basic demo's at a BMC/Simulus seminar revealed that compiled units were certainly faster than their interpreted counterparts - I can't remember off hand but it was in the order of 20-30% maybe? Of course, typically the main performance problems with PL/SQL are: a) poor SQL within the code b) inefficient (ie row at a time) handling of the results neither of which I believe native compilation will help with greatly. hth connor --- [EMAIL PROTECTED] wrote: Waleed, have you actually tried this? Or anyone else for that matter? Jared Khedr, Waleed [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/29/2002 04:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: pl/sql is INTERPRETED? See this note: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOTp_id=151224.1 Regards, Waleed -Original Message- Sent: Monday, April 29, 2002 6:53 PM To: Multiple recipients of list ORACLE-L Can this be true? How can this be? If it's optimized to manipulate data within the database, how can it be fast if it's interpreted (like that slow poke, Java)? I see this on Connor's website www.oracledba.co.uk under explicit/implicit cursors, under pl/sql. What on earth? Can someone elaborate, namely, Connor?? Please help me understand this... My green may be showing, but my gosh. Lisa Koivu Oracle Database Baby Oven Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Some days you're the pigeon, some days you're the statue __ 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: export to tape!!
$ cp dumpfile /dev/rmt0 -- From: Raghu Kota[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Monday, April 29, 2002 11:48 PM To: Multiple recipients of list ORACLE-L Subject: export to tape!! Hi Friends, I need to export some 40 tables on to tape, my system is AIX415 with oracle7.3, some body could give steps. Thanks Raghu. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: pl/sql is INTERPRETED?
Yup - its compiled into (if I recall correctly) p-code which is a tokenized and optimized version of the source. You can see a number of IDL prefixed tables under SYS which contain the compiled code. You'll see the term DIANA floating about which is related to this as well. hth connor --- Koivu, Lisa [EMAIL PROTECTED] wrote: Can this be true? How can this be? If it's optimized to manipulate data within the database, how can it be fast if it's interpreted (like that slow poke, Java)? I see this on Connor's website www.oracledba.co.uk under explicit/implicit cursors, under pl/sql. What on earth? Can someone elaborate, namely, Connor?? Please help me understand this... My green may be showing, but my gosh. Lisa Koivu Oracle Database Baby Oven Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Some days you're the pigeon, some days you're the statue __ 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: pl/sql is INTERPRETED?
Saw some basic demo's at a BMC/Simulus seminar revealed that compiled units were certainly faster than their interpreted counterparts - I can't remember off hand but it was in the order of 20-30% maybe? Of course, typically the main performance problems with PL/SQL are: a) poor SQL within the code b) inefficient (ie row at a time) handling of the results c) Confucean respect for specs (eg SELECT COUNT(*) to test for existence) d) Confucean respect for specs (eg reprogramming nested loops) e) Confusion (if you thought I was going to start with the same word you're wrong :-)) between 'relational table' and 'sequential file' f) Love for complexity g) ... neither of which I believe native compilation will help with greatly. I second that ! Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
VIRUS!!! VIRUS!!! VIRUS!!!!! BE CAREFUL!!!
virus info.html Sandeep Kurliye Certified Oracle DBA Almoayyed International Group Almoayyed Computers, PO Box 26259, Manama, Bahrain. Ph. 973-700777 Fax.973-701211 Email. [EMAIL PROTECTED] Title: McAfee - AVERT Buy Products Try Products Download Updates Products Downloads Support Services AVERT Partners About McAfee Virus Alerts Anti-Virus Updates Virus Information Library - Overview - Newly Discovered Viruses - Recently Updated Viruses - Hoaxes - Virus Calendar - White Papers AVERT Research Center AVERT WebImmune Virus Name Risk Assessment W32/Klez.h@MM Medium Virus Information Discovery Date: 04/17/2002 Origin: Unknown Length: approx 90kB Type: Internet Worm SubType: Win32 Minimum Dat: 4182 Minimum Engine: 4.0.70 DAT Release Date: 01/23/2002 Description Added: 04/17/2002 Description Modified: 04/26/2002 8:38 AM (PT) Description Menu Virus Characteristics Symptoms Method Of Infection Removal Instructions Variants / Aliases Rate this page Print This Page Virus Characteristics --- Update 4/18/2002 ---AVERT has raised the risk assessment of this threat to Medium after seeing an increase in prevalence over the past 24 hours. Home users are at a greater risk of infection, as they tend to update their DATs less frequently then corporations. As such, the risk of becoming infected in a corporate environment is lower. This latest W32/Klez variant is already detected as W32/Klez.gen@MM by McAfee products using the 4182 DATs (23 January 2002) or greater. W32/Klez.h@MM has a number of similarities to previous W32/Klez variants, for example: W32/Klez.h@MM makes use of Incorrect MIME Header Can Cause IE to Execute E-mail Attachment vulnerability in Microsoft Internet Explorer (ver 5.01 or 5.5 without SP2). the worm has the ability to spoof the From: field (often set to an address found on the victim machine). the worm attempts to unload several processes (antivirus programs) from memory. Including those containing the following strings: _AVP32 _AVPCC NOD32 NPSSVC NRESQ32 NSCHED32 NSCHEDNT NSPLUGIN NAV NAVAPSVC NAVAPW32 NAVLU32 NAVRUNR NAVW32 _AVPM ALERTSVC AMON AVP32 AVPCC AVPM N32SCANW NAVWNT ANTIVIR AVPUPD AVGCTRL AVWIN95 SCAN32 VSHWIN32 F-STOPW F-PROT95 ACKWIN32 VETTRAY VET95 SWEEP95 PCCWIN98 IOMON98 AVPTC AVE32 AVCONSOL FP-WIN DVP95 F-AGNT95 CLAW95 NVC95 SCAN VIRUS LOCKDOWN2000 Norton Mcafee Antivir The worm is able to propagate over the network by copying itself to network shares (assuming sufficient permissions exist). Target filenames are chosen randomly, and can have single or double file extensions. For example: 350.bak.scr bootlog.jpg user.xls.exe The worm may also copy itself into RAR archives, for example: HREF.mpeg.rar HREF.txt.rar lmbtt.pas.rar The worm mails itself to email addresses in the Windows Address Book, plus addresses extracted from files on the victim machine. It arrives in an email message whose subject and body is composed from a pool of strings carried within the virus (the virus can also add other strings obtained from the local machine). For example:Subject: A very funny website or Subject: 1996 Microsoft Corporation or Subject: Hello,honey or Subject: Initing esdi or Subject: Editor of PC Magazine. or Subject: Some questions or Subject: Telephone number The file attachment name is again generated randomly, and ends with a .exe, .scr, .pif, or .bat extension, for example: ALIGN.pif User.bat line.bat Thanks to the use of the exploit described above, simply opening or previewing the message in a vulnerable mail client can result in infection of the victim machine. W32/Klez.h@MM masquerades as a free immunity tool in at least one of the messages used. Below is the message sent by the virus itself.Subject: Worm Klez.E Immunity Body: Klez.E is the most common world-wide spreading worm. It's very dangerous by corrupting your files. Because of its very smart stealth and anti-anti-virus technic,most common AV software can't detect or clean it.We developed this free immunity tool to defeat the malicious virus. You only need to run this tool once,and then Klez will never come into your PC. NOTE: Because this tool acts as a fake Klez to fool the real worm,some AV monitor maybe cry when you run it. If so,Ignore the warning,and select 'continue'. If you have any question,please mail to me. The worm may send a clean document in
RE: PATCH?
Don't forget ALTER MOTHER SET BREAST_FEED_MODE=TRUE Dave -Original Message- Sent: Monday, April 29, 2002 7:33 PM To: Multiple recipients of list ORACLE-L Alter Mother Set Morhpine_Level = 10; Alter Mother Have_Baby_Now = TRUE; Alter Father Learn_To_Change_Diapers = TRUE; Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, Lisa Sent: Monday, April 29, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Subject: PATCH? How to give birth? Please advise. Thx. --Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Size of segment
Hi, Thanks to all those who replied. Just clearing the structure. I have Hp LVM and the tables and indexes are on different tablespaces and different disks . Since the growth pattern has changed drastically , the no of extents have increased tremendously . Hence the need to rebuild the indexes . We plan to rebuild them into contiguous extents (only question being 1 extent or say 4-5 extents to take care of growth:--- 1 extent every 2 months ) Will the performance differ if they are on 1 extent or 5 extents ( both being contiguous) ? thanks shreepad -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Compare Schemas
Are you working with toad version 7.2? I compared 2 schemas and got a complete list of differences. Right click on the difference and you get the SQL to implement it. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, April 29, 2002 10:23 PM I need to compare the schemas for two databases. I tried Toad, which will tell me there are differences but it won't say what the differences are. Does anyone have a script that will show the differences in detail? Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: VIRUS!!! VIRUS!!! VIRUS!!!!! BE CAREFUL!!!
HELP -Original Message- Sent: Tuesday, April 30, 2002 5:48 AM To: Multiple recipients of list ORACLE-L virus info.html Sandeep Kurliye Certified Oracle DBA Almoayyed International Group Almoayyed Computers, PO Box 26259, Manama, Bahrain. Ph. 973-700777 Fax.973-701211 Email. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: export to tape!!
Thank you so much mike!! I find it the same from asktom web site!! But If I want to restore different tables from the same export,should I able to do that?? From: Hately Mike [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: export to tape!! Date: Tue, 30 Apr 2002 02:28:27 -0800 Raghu, You can just specify the tape device as the target file. One important difference is the optional volsize parameter which allows you to specify the capacity of the tape drive. Export/import will then prompt for the next tape when required. i.e. exp username/password file=/dev/rmt0 volsize=100M other options imp username/password file=/dev/rmt0 volsize=100M other options regards, Mike Hately -- From: Raghu Kota[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Monday, April 29, 2002 11:48 PM To: Multiple recipients of list ORACLE-L Subject:export to tape!! Hi Friends, I need to export some 40 tables on to tape, my system is AIX415 with oracle7.3, some body could give steps. Thanks Raghu. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Raghu Kota OCP DBA. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Size of segment
Oh Shreepad, you've opened another can of worms there. =) You shouldn't see any performance difference between 1 extent and 5 extents or more. The best option for extent sizing in my opinion is to keep all extents within a tablespace the same size. This increases the manageability of the objects within it and eliminates honeycomb fragmentation. Regards, Mike Hately -Original Message- Sent: Tuesday, April 30, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Hi, Thanks to all those who replied. Just clearing the structure. I have Hp LVM and the tables and indexes are on different tablespaces and different disks . Since the growth pattern has changed drastically , the no of extents have increased tremendously . Hence the need to rebuild the indexes . We plan to rebuild them into contiguous extents (only question being 1 extent or say 4-5 extents to take care of growth:--- 1 extent every 2 months ) Will the performance differ if they are on 1 extent or 5 extents ( both being contiguous) ? thanks shreepad This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Is sqlplus too slow to unload data?
Tim, Thank you for your reply. There are two issues that I cannot use pipe. One is two databases are in two different isolated network. Second is we need the flat files for archives. BTW, whenever we can use PIPE, we can use database link. Is it right? I understand that SQLPlus is just a command line interface to interactively query Oracle databases. It's also a report writer widely used by DBA. It isn't a proper tool for data extraction. However, it has been treated as unload tool in some places. It is introduced as unload tool in your book -- Essential Oracle8i Data Warehousing. Using unload, sqlplus, Thomas Kyte to search in groups.google.com, I also find that he uses it as a suggestion several times. Anyway, what is a proper tool for data extraction in Oracle? exp/imp isn't. Although there are quite a few third party tools, wouldn't it be nice if Oracle offically issues one? Kind Regards, Bin Original message from: Tim Gorman [EMAIL PROTECTED] It's SQL*Plus. Love it to pieces, but it just dawdles when used as an unloader. It must spend a tremendous amount of processing just formatting or something... Never bother blaming the network or Net8 unless you are just trying to get someone off your back to delay for time. DBAs will say it must be the network to cause users to go hounding off after the network administrator or systems administrator. While they're baying at that poor person, you should have at least an hour to find out what's really going on... If you are working on UNIX, one thing you can do to speed up unloading/loading is put a UNIX pipe or FIFO between the unloader process (i.e. SQL*Plus or other) and SQL*Loader, instead of a flat file. Saves disk space but most importantly saves time -- you don't have to wait for unloading to complete before loading. In fact, loading must start with the unloading, so you can't help but save both time and space... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 10:53 PM Hi, Our application uses sqlplus + sqlloader to transfer data between databases. It takes nearly four hours to unload to data to flat files(1G), which is far too slow. In the application, the query looks like the following. All those 3,4,5 are for sqlldr format. select ' ' || '4' || replace( replace ( ltrim(dealerid), '4', '4' || '4' ), CHR(10), CHR(10) || '5' ) ||'4'||'3' || ... from table_name f where eventdate = to_date(1) and eventdate = to_date(2); Firstly, there is nothing wrong with the query, since if I insert into a table it only takes less than 15 minutes. Therefore, there must be problem with either sqlplus or Networking. With sqlplus, I increase arraysize from 1 to 2000. With Networking, I put tcp.nodelay=yes on protocol.ora. Both doesn't work. I try thrid party software which is writen by Pro*C to download tables to flat file. Its speed is more than 60M/minute. I monitor v$session_event while it's running.The only different is event SQL*Net message from client. In AVERAGE_WAIT and MAX_WAIT, the different is huge. sqlplus: TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT MAX_WAIT 49 0 5998 122.4 1004 Pro*C: TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT MAX_WAIT 351 0 677 1.92 42 What's the problem sqlplus or net8? BTW, dblink doesn't work since the two databases on isolated network. emp/imp is an option. However, I just try to find out what is wrong with sqlplus one. I test 8.0.5 and 8.1.7 on solaris 2.6-2.8. Thanks in advance, Bin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bin Wang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). . __ Get your free Australian email
OT: VIRUS!!! VIRUS!!! VIRUS!!!!! BE CAREFUL!!!
Hmm - this seems to be a particularly powerful and dangerous infection, three times more powerful than the 'standard'. Luckily, the 'V-word' virus causes no damage other than slightly clogging up mailboxes. The fact that this example uses the word 3 times would make it particularly bad, but multiple exclamation marks are a dead giveaway, and most of us can delete the message manually. Although this 'V-Word' virus is one of the most common email problems (along with other spam), anti-virus programs *still* refuse to recognise it and delete any message that uses the 'V-Word' with multiple exclamation marks. Don't panic - just follow these simple steps: 1) Trust no-one 2) Prevent this insidious virus from spreading any further by not posting any replies containing the 'V-Word' virus. Simon Anderson (Note to the humour impaired - just ignore me, it's been a slow week ;-) Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Simon Anderson/SSplc) HELP -Original Message- Sent: Tuesday, April 30, 2002 5:48 AM To: Multiple recipients of list ORACLE-L virus info.html Sandeep Kurliye Certified Oracle DBA Almoayyed International Group Almoayyed Computers, PO Box 26259, Manama, Bahrain. Ph. 973-700777 Fax.973-701211 Email. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Size of segment
Shreepad, There is no problem with a segment having more than 1 extent. It is a common misconception (another of those Myths, if you please) that all tables and indexes should reside in 1 extent, or less than 10 extents even. There is a paper available from the web - that many say is the definitive word on fragmentation of extents, called How to stop defragmenting and start living, written by Juan Loaiza (sp?) which a google search should easily find.. The basics of this paper are thus: You should have a set of three tablespaces (for data and indexes) that each deal with a UNIFORM extent size, ranging through 160k, 5120k and 160M at the tablespace level. When creating a new object (table or index), you should determine how large the table/index is going to be, and create it in the appropriate tablespace, without defining specific storage clauses at the table level - therefore inheriting the Tablespace storage clauses as a default (gaining the uniform extent size for all objects within the tablespace). Of course, if you are already using LMTs (Locally Managed Tablespaces) with uniform extent allocation, then the need to do this has gone away. Once a table/index reaches 1024 extents (much more than the myth of 1-10 extents), then the object should be considered for a move up to a larger extent sized tablespace (and will still, by all accounts, take up 32 extents from the start of it's life in the new tablespace anyway - if moved straight away). I would again recommend reading the paper above - it's been a while since I had the chance to read it, and I'm not sure if it's been updated at all (anybody?), but it has an absolute wealth of information! HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- [EMAIL PROTECTED] Sent: 30 April 2002 12:04 To: Multiple recipients of list ORACLE-L Hi, Thanks to all those who replied. Just clearing the structure. I have Hp LVM and the tables and indexes are on different tablespaces and different disks . Since the growth pattern has changed drastically , the no of extents have increased tremendously . Hence the need to rebuild the indexes . We plan to rebuild them into contiguous extents (only question being 1 extent or say 4-5 extents to take care of growth:--- 1 extent every 2 months ) Will the performance differ if they are on 1 extent or 5 extents ( both being contiguous) ? thanks shreepad -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Slow select distinct
This may be my favorite Oracle 8i bugs (and no, I don't have the bug#s.) Performing a sort sometimes causes wildly inefficient execution plans. I'm guessing that if you run the explain plans for the query without the DISTINCT and with the DISTINCT you will get completely different results. If this is my favorite bugs, then you will get SORT/MERGE joins when you add the DISTINCT where the joins were either NESTED LOOPS or HASH joins before. My typical solution is to use an inline view and the NO_MERGE hint as in: SELECT /*+ NO_MERGE(data) */ DISTINCT wrecks FROM (SELECT LTRIM(L.STREET_ADDRESS_BEGIN||' '||L.STREET_NAME_PREFIX|| ''||L.STREET_NAME||' '||L.STREET_NAME_SUFFIX) WRECKS FROM LOCATION L, STREET_REQS SR WHERE L.ID = SR.ID AND L.STREET_NAME IS NOT NULL AND SR.TYPE IN ('KED','KAD') AND SR.CODE LIKE 'O%' AND SR.ORIG_STREET_REQ_ID IS NULL) data Caver -Original Message- Sent: Monday, April 29, 2002 5:44 PM To: Multiple recipients of list ORACLE-L I got a query that selects a list of addresses based an occurence at that location. this query comes back in less than 2 seconds without a distinct clause on the concatenated name. When I add the distict clause it takes over 40 seconds. I've tried adjusting various sort area sizes and buffer sizes to see if I can speed this up. Anybody have a clue if there is something in particular that I can check. 8.1.6 on NT rules based. wtihout the distinct clause it brings back about 10,000 records. select DISTINCT LTRIM(L.STREET_ADDRESS_BEGIN||' '||L.STREET_NAME_PREFIX||' '||L.STREET_NAME||' '||L.STREET_NAME_SUFFIX) WRECKS FROM LOCATION L, STREET_REQS SR WHERE L.ID = SR.ID AND L.STREET_NAME IS NOT NULL AND SR.TYPE IN ('KED','KAD') AND SR.CODE LIKE 'O%' AND SR.ORIG_STREET_REQ_ID IS NULL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Is sqlplus too slow to unload data?]
Stephane, pdqout does give me a real good impression, not only the speed but also the interface. I can see it uses parallel query. However, I, as a production DBA, intend to change the application which come from a third party as a package as small as possible. It takes 4hours to extract data at 5M/minute. If the speed of sqlplus can be increased to 20M/minute, I achieve the goal. Just one thing about pdqout confuses me. I have to use DBA account, otherwise I get the following error. ' Oracle oexfet() failure (-907) ORA-00907: missing right parenthesis ' Kind Regards, Bin Original Message To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] As somebody who has insider's knowledge of pdqout and a decent understanding of exp and SQL*Plus, I think that you must have a good number of numbers and dates in your data. Both types (as opposed to strings) require conversion. Which is why exp, which dumps bytes 'as is', can be so fast - there is hardly any conversion from the internal Oracle format (same thing with SELECT ... INSERT ..., which is also lighter on the I/O side). However, the conversion does occur with both SQL*Plus and Pdqout. My interpretation in the difference in waits is that, with your SQL*Plus query, there is a good deal of formatting done on the kernel side - with Pdqout, conversion is let to Oracle but there is formatting on the application side too. This may explain why Pdqout gets its results faster than SQL*Plus. SORRY IF IT LOOKS LIKE A SALES PLUG There are two other factors which probably explain the difference in speed : - Pdqout is multithreaded. While one thread waits for Oracle to return batch n, a second one is busy formatting batch n-1 (this is the thread which is heavier on CPU) while a third one is writing formatted batch n-2 to disk. Although SQL*Plus is fairly efficient and uses arrays as much as Pdqout does (even if default buffer sizes are probably different, you could try to play on this too), it does fetch and writing in sequence, and doesn't get the next batch before having written to disk - vs memory copy with Pdqout, in which threads just wait on mutexes. - Pdqout is very byte-conscious. We had benched it a long long time ago against a competitive product, it generated a 1.2G file against a 2G file with the same data - and the loading speed with SQL*Loader was in the same ratio. It doesn't put separators where they are not strictly required, uses a very compact date format, and by saving a few bytes per row it can make a huge difference on many rows. So, the writing time for SQL*Plus is probably significantly higher than with Pdqout too. /SORRY IF IT LOOKS LIKE A SALES PLUG If you regularly make at wider intervals calls which take longer to answer, a significant time difference is not too surprising. Does it make sense ? -Original Message- Sent: Wednesday, 24 April 2002 14:53 Hi, Our application uses sqlplus + sqlloader to transfer data between databases. It takes nearly four hours to unload to data to flat files(1G), which is far too slow. In the application, the query looks like the following. All those 3,4,5 are for sqlldr format. select ' ' || '4' || replace( replace ( ltrim(dealerid), '4', '4' || '4' ), CHR(10), CHR(10) || '5' ) ||'4'||'3' || ... from table_name f where eventdate = to_date(1) and eventdate = to_date(2); Firstly, there is nothing wrong with the query, since if I insert into a table it only takes less than 15 minutes. Therefore, there must be problem with either sqlplus or Networking. With sqlplus, I increase arraysize from 1 to 2000. With Networking, I put tcp.nodelay=yes on protocol.ora. Both doesn't work. I try thrid party software which is writen by Pro*C to download tables to flat file. Its speed is more than 60M/minute. I monitor v$session_event while it's running.The only different is event SQL*Net message from client. In AVERAGE_WAIT and MAX_WAIT, the different is huge. sqlplus: TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT MAX_WAIT 49 0 5998 122.4 1004 Pro*C: TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT MAX_WAIT 351 0 677 1.92 42 What's the problem sqlplus or net8? BTW, dblink doesn't work since the two databases on isolated network. emp/imp is an option. However, I just try to find out what is wrong with sqlplus one. I test 8.0.5 and 8.1.7 on solaris 2.6-2.8. Thanks in advance, Bin -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list
Re: Database Metrics
Title: Database Metrics Hello Yuval Arnon I will use three graphs: 1) Number of SQL statements executed per day. 2) Mean response time. 2) CPU usage per day. In both cases add a reference point that is the mean of the last 30-40 days so they can see any abnormal behavior. The space statistics are for you and use them only quarterly for management. If you can add a graph for important applications. Yechiel Adar Mehish - Original Message - From: Yuval Arnon To: Multiple recipients of list ORACLE-L Sent: Monday, April 29, 2002 7:23 PM Subject: Database Metrics Hi, I am looking for ideas on what kind of metrics the DBA group should provide the management on a weekly basis so they can understand how the databases are evolving over time. These metrics should be simple enough as the management is not Oracle savvy. Thanks in advance! Yuval. Sr. DBA - WWF
Re: CPU Pegged at 100%
Do you know how to see the threads in NT? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, April 29, 2002 8:24 PM oracle.exe spawns out threads, which you will not see running in the task manager. Each DBWR process then will be a thread of oracle.exe. RF -Original Message- Sent: Monday, April 29, 2002 1:40 PM To: Multiple recipients of list ORACLE-L I have 5 DBWR processes according to INIT.ORA on NT .. I see them on V$SESSION but There is only one process ORACLE.EXE in the processes list of NT still. I do not understand the behaviour of ORacle on NT neither the Oracle I think. Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, April 29, 2002 5:53 PM On Mon, Apr 29, 2002 at 05:59:18AM -0800, Thomas Day wrote: I don't think that increasing the db_writer_processes will help. NT is, as noted elsewhere, multi-threaded. Increasing the db_writer_processes will not start a new process. My experience with Oracle on NT is that when the CPU is pegged at 100% it is because the OS is constantly writing and fetching the contents of RAM to the swapfile. -- If this is the case for this problem, we have found that changing the location of the os paging file onto another disk and controller can help performance. See your windows clicking friends to find out where to click. It is somewhere under my computer...read the man page on it ;) === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: VIRUS!!! VIRUS!!! VIRUS!!!!! BE CAREFUL!!!
Use non-Windoze workstation! JP On Tue 30. April 2002 13:33, you wrote: HELP -Original Message- Sent: Tuesday, April 30, 2002 5:48 AM To: Multiple recipients of list ORACLE-L virus info.html Sandeep Kurliye Certified Oracle DBA Almoayyed International Group Almoayyed Computers, PO Box 26259, Manama, Bahrain. Ph. 973-700777 Fax.973-701211 Email. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ERD generation tool
Can anyone please recommend/advise on NT/W2K compliant solutions which can generate ERD's by interogating the DB. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: VIRUS!!! VIRUS!!! VIRUS!!!!! BE CAREFUL!!!
Are you an idiot? :-) On Tue 30. April 2002 13:33, you wrote: HELP -Original Message- Sent: Tuesday, April 30, 2002 5:48 AM To: Multiple recipients of list ORACLE-L virus info.html Sandeep Kurliye Certified Oracle DBA Almoayyed International Group Almoayyed Computers, PO Box 26259, Manama, Bahrain. Ph. 973-700777 Fax.973-701211 Email. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ERD generation tool
Title: RE: ERD generation tool When I was in an NT shop, we used Visio (I know...I know), but given that I was not architecting at the time, I can't compare with the Erwin that I am using now. I remember at the time though, the ERDs created using Visio were accurate for what we were doing (just documenting DBs). Its CHEAP compared to the *real* tools, like ERWin and will generate ERDs from several sources. Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of O'Neill, Sean [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 8:24 AM To: Multiple recipients of list ORACLE-L Subject: ERD generation tool Can anyone please recommend/advise on NT/W2K compliant solutions which can generate ERD's by interogating the DB. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[no subject]
I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. How can I just remove all of Oracle 9i without touching Oracle 8i? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-27101 Shared Memory Realm Does Not Exist
Dave, Thanks for the good article. I am trying for two separate instances on the same box, 8i and 9i. I am not installing anything just adding 9i. Thanks Rick [EMAIL PROTECTED] .tenet.edu To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: ORA-27101 Shared Memory Realm Does Not Exist 04/29/2002 05:31 PM Please respond to ORACLE-L Rick, Are you trying for two seperate versions of Oracle on the box, or did you remove the 8.1.6 to install 9i? If you did the latter, I'm afraid your uninstall did not go properly and your service isn't pointing to the right place. Oradim is the supported method for removing (renaming?) an Oracle instance, but here's some tips I got when I was new to the NT/2000 world from Novice DBA. I've sent this before, but you should take a look at your registry settings, they're probably the key to your problem and this document will help you know what to look for: Database Installation involves a set of procedures which need to be followed in order to have a proper working installation. If we follow these procedures the Installation will be fine and usually problems related to improper installation do not arise. But it is not always possible to get a proper installation for the first time. This document is a troubleshooting guide which would help to clear off the mess created by an improper installation in a WindowsNT system. First we need to know that During installation Oracle writes into certain directories (which we would have specified during installation) and also into the WindowsNT registry. WindowsNT registry is a repository of information about all the installed products and configurations on that system. When we are installing Oracle a directory is created in the registry which is name oracle which is present in the HKEY_LOCAL_MACHINE/SOFTWARE/ In the case of an improper installation the problems faced are · We may not be able to uninstall the incomplete installation · We may succeed in uninstalling the incomplete installation but yet face problems with WindowsNT Services. · Every time we log into WindowsNT we may get an error 'at least one system service failed to start' which may be an Oracle service from the earlier installation. · We may get an error while creating a database 'the database with the name you specified already exists please chose another name' which again may be attributed to an improper un-installation.(I am not pretty comfortable with the Oracle's Un-installation utility because I feel it does not uninstall everything) Keeping the above points in mind it would be better if we know where exactly to look in case we are faced with such problems. When oracle is installed it makes entries in the following places 1. The first and the foremost- the directory in which we install the Oracle database (say D:\Ora8i) 2. The second is the inventory it maintains in the directory c:\program files\oracle 3. The third HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE in the registry 4. The other place is HKEY_LOCAL_MACHINE/SYSTEM . Inside this entry there are three nodes controlset1,controlset2 and currentcontrolset. These nodes in turn have 4 nodes out of which 2 are important to us. They are Enum and Services. The Enum node has got two nodes out of which the 'root' node is of great interest to us because it stores details about all the services that are running on a WindowsNT system. The other node of interest from the controlsets is Services. The services node has got a list of services running on a WindowsNT system. In case we need to clean up the system after an incomplete installation we can follow the following steps Delete the home directory where Oracle is installed Delete the folder
Re: ERD generation tool
Both Designer and ERwin can reverse engineer enough information from an existing database to generate an ERD. Cherie Machler Oracle DBA Gelco Information Network O'Neill, SeanTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sean.ONeill@o cc: rganon.ie Subject: ERD generation tool Sent by: [EMAIL PROTECTED] om 04/30/02 07:24 AM Please respond to ORACLE-L Can anyone please recommend/advise on NT/W2K compliant solutions which can generate ERD's by interogating the DB. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [oracle-l-OT] Re: Re: ANTI-VIRUS SPAM - YOUR EMAIL ADMIN IS A
I'd say Tim is stuck in Buddhist nondoing-ness while simultaneously missing the point (It's the SageLogix server, STOOPID) and calling the kettle black (don't call me names from your playbook; instead denigrate via condecension and superciliousness) Brown? Maybe this guy needs a good, relaxing BM. And yea, virus scanning that works by blind, utter deletion is frustrating. But Eric, what about this guy's fucking humanity? Back into my cage, etc. -Original Message- To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: 4/29/2002 7:47 PM DIKHEAD You silly! I was talking about the email admin at the guy's company, not fatcity. It has subsequently been explained to me that damagement is at fault (surprise) and ought to be blamed for all evil, not the email admin. http://www.dogdoo.com Ross can explain how brown fits into the metaphysical context of your astral plane. ORACLE-L Digest -- Volume 2002, Number 118 -- From: Tim Gorman [EMAIL PROTECTED] Date: Sat, 27 Apr 2002 10:34:46 -0600 Subject: Re: ANTI-VIRUS SPAM - YOUR EMAIL ADMIN IS A DIKHEAD / (Fwd) Antigen found =*.*.txt file Eric, A 5th-grade teacher once admonished me on cursing by pointing out that the English language has 100,000 words in frequent usage and how unimaginative it was to constrain myself to the same dozen or so words to describe my feelings... Bruce, the guy who runs FATCITY as a sideline business (because this business doesn't generate enough money to support the typical family), restricts all attachments not only out of concern for viruses, but for the more practical reason of limiting message size and therefore storage and network capacity. It's a good policy -- if you'd like to send attachments, please address people directly... ...and please grow up. -Tim I don't know if this guy (Evans, David) is subscribed to this list, but if so, please tell your email admin that this stuff sucks. A text file attachment is not automatically equivalent to a virus attachment. If their system wasn't set up by such dikheads, they would know that they can implement packet scanning at the email gateway in a non-intrusive manner that is far more effective than this spam cr*pola. http://www.antivirus.com/products/isvw/ regards, ep Yahoo! Groups Sponsor -~-- Tied to your PC? Cut Loose and Stay connected with Yahoo! Mobile http://us.click.yahoo.com/QBCcSD/o1CEAA/yigFAA/o7folB/TM -~- To talk about oracle database issues: subscribe to [EMAIL PROTECTED] To do the offtopic(OT) thing. post here :) To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ERD generation tool
Yes, there is ERWin. You load the sql*plus scripts into it and it will then re-engineer the diagrams. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 7:24 AM Can anyone please recommend/advise on NT/W2K compliant solutions which can generate ERD's by interogating the DB. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to deinstall oracle 9i and leave 8i intact
Reposting as I forgot to include a subject line on previous post. I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. How can I just remove all of Oracle 9i without touching Oracle 8i? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [oracle-l-OT] Re: Re: ANTI-VIRUS SPAM - YOUR EMAIL ADMIN IS A
BM? Bone massage? ROTFL -Original Message- Sent: 30 April 2002 14:13 To: Multiple recipients of list ORACLE-L A I'd say Tim is stuck in Buddhist nondoing-ness while simultaneously missing the point (It's the SageLogix server, STOOPID) and calling the kettle black (don't call me names from your playbook; instead denigrate via condecension and superciliousness) Brown? Maybe this guy needs a good, relaxing BM. And yea, virus scanning that works by blind, utter deletion is frustrating. But Eric, what about this guy's fucking humanity? Back into my cage, etc. -Original Message- To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: 4/29/2002 7:47 PM DIKHEAD You silly! I was talking about the email admin at the guy's company, not fatcity. It has subsequently been explained to me that damagement is at fault (surprise) and ought to be blamed for all evil, not the email admin. http://www.dogdoo.com Ross can explain how brown fits into the metaphysical context of your astral plane. ORACLE-L Digest -- Volume 2002, Number 118 -- From: Tim Gorman [EMAIL PROTECTED] Date: Sat, 27 Apr 2002 10:34:46 -0600 Subject: Re: ANTI-VIRUS SPAM - YOUR EMAIL ADMIN IS A DIKHEAD / (Fwd) Antigen found =*.*.txt file Eric, A 5th-grade teacher once admonished me on cursing by pointing out that the English language has 100,000 words in frequent usage and how unimaginative it was to constrain myself to the same dozen or so words to describe my feelings... Bruce, the guy who runs FATCITY as a sideline business (because this business doesn't generate enough money to support the typical family), restricts all attachments not only out of concern for viruses, but for the more practical reason of limiting message size and therefore storage and network capacity. It's a good policy -- if you'd like to send attachments, please address people directly... ...and please grow up. -Tim I don't know if this guy (Evans, David) is subscribed to this list, but if so, please tell your email admin that this stuff sucks. A text file attachment is not automatically equivalent to a virus attachment. If their system wasn't set up by such dikheads, they would know that they can implement packet scanning at the email gateway in a non-intrusive manner that is far more effective than this spam cr*pola. http://www.antivirus.com/products/isvw/ regards, ep Yahoo! Groups Sponsor -~-- Tied to your PC? Cut Loose and Stay connected with Yahoo! Mobile http://us.click.yahoo.com/QBCcSD/o1CEAA/yigFAA/o7folB/TM -~- To talk about oracle database issues: subscribe to [EMAIL PROTECTED] To do the offtopic(OT) thing. post here :) To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to deinstall oracle 9i and leave 8i intact
There Should Be No Problems in this. Run the Universal Installer and Go to nstalled Products and Remove 9i. That should do the trick. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Tuesday, April 30, 2002 4:26 PM To: LazyDBA.com Discussion Reposting as I forgot to include a subject line on previous post. I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. How can I just remove all of Oracle 9i without touching Oracle 8i? Thanks Rick Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:
[EMAIL PROTECTED] wrote: I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. How can I just remove all of Oracle 9i without touching Oracle 8i? Thanks Rick how about reading the documentation that came with the damn software? -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. A computer scientist is someone who fixes things that aren't broken. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PATCH?
Jeremiah, Thanks for the informative description of the spawning process. The operational manual is not to be found and the instructions are written in an unknown language. Ron ROR mô¿ôm [EMAIL PROTECTED] 04/29/02 05:53PM RTFM. http://www.bcpl.net/~rgarriqu/babyman.html -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 29 Apr 2002, [EMAIL PROTECTED] wrote: EPIDURAL.. advice from the recently hatched (eight month old little girl:) -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Koivu, Lisa [EMAIL PROTECTED] Sent: Monday, April 29, 2002 4:54 PM To: Multiple recipients of list ORACLE-L Subject:PATCH? How to give birth? Please advise. Thx. --Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Financials Sys Admin. Needed in South Carolina
Lisa, What you said about Atlanta and the New York of the south is correct in my opinion. 12 years ago it was different when I moved here from Conn. The cost of housing has doubled and the cost of the produce has caught the Conn. prices for food staples. Granted the cost of gasoline is cheaper in GA but the cost of utilities far surpasses that of utilities in Conn. $200 a month is normal for gas and electric and you have to look had to find fuel oil being used anyplace. And I only have a 2000 sq ft home on a slab. Next month the electric cost will almost double because of the demand created by the usage of A.C. allows the utilities to raise their rates and we are now deregulated on gas prices for the winter needs. Windows work great in our home but the pollen turns everything a funny yellowish/green hue. In our county the town fathers/bubba have approved 42 housing developments for this year and the infrastructure is not built to handle the extra load. The average size lot is 5/8 of an acre. The school construction is almost matching the housing construction and the taxes are keeping pace too. People are moving out of the Atlanta proper the get away from the traffic and crime. I live 38 miles door to door and it takes 1 1/4 hours to get to and from work. The northern area of Atlanta is nicknamed the silicon valley of the east and you can find a lot of housing in that area that compares with New York in city prices. Million dollar loft townhouses are being built all over the place. Good luck with the increase in your family and the relaxing time off from work. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/29/02 04:48PM I have been told that Atlanta is the New York of the south. The cost of living in Atlanta is NOT cheap due to the cost of utilities (mostly power) and housing. And don't let anyone tell you that about Florida, either. They will tell you that not paying state tax is like getting a 8% pay raise. Bull. Dade and Broward county are so built up that the cost of housing is skyrocketing, even with yards the size of a half postage stamp. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DB Config. Assistant
9i on XP Prof. on DELL PC (no network) I tried to use DBCA to create a DB on my PC.I have never used this tool before. It appeared to run OK with no errors. However, when I query the V$ views I don't see it and I cannot connect to it. I ran DBCA twice to create the DB and the second time I didn't get any error message saying the DB already existed. I don't know that I should since I have never used DBCA before. If there is anyone out there that have used this tool before please give me some insight into it. Thanks and have a good day, Ken Janusz, CPIM
RE: How to deinstall oracle 9i and leave 8i intact
Rick, how about using the installer? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, April 30, 2002 9:23 AM To: Multiple recipients of list ORACLE-L Reposting as I forgot to include a subject line on previous post. I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. How can I just remove all of Oracle 9i without touching Oracle 8i? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle wants your job
http://www.infoworld.com/articles/se/xml/02/04/29/020429seoracle.xml Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to deinstall oracle 9i and leave 8i intact
What platform are you working on? Windows or Unix? -Joe --- [EMAIL PROTECTED] wrote: Reposting as I forgot to include a subject line on previous post. I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. How can I just remove all of Oracle 9i without touching Oracle 8i? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ERD generation tool
ERWin www.ca.com ERStudio www.embarcadero.com Active Designer http://www.iraje.com/ad_fsmain.htm HTH Mark -Original Message- Sean Sent: 30 April 2002 13:24 To: Multiple recipients of list ORACLE-L Can anyone please recommend/advise on NT/W2K compliant solutions which can generate ERD's by interogating the DB. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 8i installation help
Greetings, If I remember correctly after the install of Oracle 8i, we can delete some of the files(*O and *o) from some directory under $ORACLE_HOME. Probably from $ORACLE_HOME/bin or $ORACLE_HOME/lib or some directory. Could you please confirm this and is there any white paper or any document from Oracle, where it specifies about this. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:
On Tue 30. April 2002 15:33, you wrote: [EMAIL PROTECTED] wrote: I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. How can I just remove all of Oracle 9i without touching Oracle 8i? Thanks Rick how about reading the documentation that came with the damn software? But he surely want to do it now, not in 15 years. :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:pl/sql is INTERPRETED?
Lisa, It is both true false at the same time. Obviously any anonymous blocks you submit to the database are fully interpreted. PL/SQL that you store in the database as procedures, functions, and packages get partially compiled into a p-code. This makes the code ready for execution, but retains a modular design so that if your DBA reloads catproc your code is not totally destroyed. Where I think PL/SQL buys us a lot of performance is in reducing the communications outside of the database that is otherwise needed. There's no JDBC driver or other miscellaneous mess (like SQL*Net) required. It's all handled inside the kernel. Now the bad part about PL/SQL that Java handles better is platform independence. You can run Java on your client, the apps server or database without a problem. PL/SQL on the other hand must be run in the database. Dick Goulet Reply Separator Author: Koivu; Lisa [EMAIL PROTECTED] Date: 4/29/2002 2:52 PM Can this be true? How can this be? If it's optimized to manipulate data within the database, how can it be fast if it's interpreted (like that slow poke, Java)? I see this on Connor's website www.oracledba.co.uk under explicit/implicit cursors, under pl/sql. What on earth? Can someone elaborate, namely, Connor?? Please help me understand this... My green may be showing, but my gosh. Lisa Koivu Oracle Database Baby Oven Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to deinstall oracle 9i and leave 8i intact
Nt 4.0 Rick Joe Raube jraube@yahooTo: [EMAIL PROTECTED] .comcc: [EMAIL PROTECTED] Subject: Re: How to deinstall oracle 9i and leave 8i intact 04/30/2002 08:54 AM What platform are you working on? Windows or Unix? -Joe --- [EMAIL PROTECTED] wrote: Reposting as I forgot to include a subject line on previous post. I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. How can I just remove all of Oracle 9i without touching Oracle 8i? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Slow select distinct
Unfortunately there are duplicates so they do need the distinct clause. I have tried several permutations of the query and distinct clauses including the most popular alternative: select distinct wrecks from (select DISTINCT LTRIM(L.STREET_ADDRESS_BEGIN||' '||L.STREET_NAME_PREFIX||' '||L.STREET_NAME||' '||L.STREET_NAME_SUFFIX) WRECKS FROM LOCATION L, STREET_REQS SR WHERE L.ID = SR.ID AND L.STREET_NAME IS NOT NULL AND SR.TYPE IN ('KED','KAD') AND SR.CODE LIKE 'O%' AND SR.ORIG_STREET_REQ_ID IS NULL); However it all seems to go back to the sort on the 9500 rows being returned. -Original Message- Sent: Monday, April 29, 2002 5:53 PM To: Multiple recipients of list ORACLE-L Shaw John-P55297 wrote: I got a query that selects a list of addresses based an occurence at that location. this query comes back in less than 2 seconds without a distinct clause on the concatenated name. When I add the distict clause it takes over 40 seconds. I've tried adjusting various sort area sizes and buffer sizes to see if I can speed this up. Anybody have a clue if there is something in particular that I can check. 8.1.6 on NT rules based. wtihout the distinct clause it brings back about 10,000 records. select DISTINCT LTRIM(L.STREET_ADDRESS_BEGIN||' '||L.STREET_NAME_PREFIX||' '||L.STREET_NAME||' '||L.STREET_NAME_SUFFIX) WRECKS FROM LOCATION L, STREET_REQS SR WHERE L.ID = SR.ID AND L.STREET_NAME IS NOT NULL AND SR.TYPE IN ('KED','KAD') AND SR.CODE LIKE 'O%' AND SR.ORIG_STREET_REQ_ID IS NULL Checking the execution plan in both case could have been interesting. In any case, DISTINCT is rarely necessary with a join. Look at your query. Everything comes from the LOCATION table, STREET_REQS just happens to be here to provide a filter. Unless LOCATION holds duplicates for the columns you want to bring back, you can avoid the DISTINCT. Both 'IS NULL' and 'IS NOT NULL' (less sure about the later with latest versions) usually translate as 'full scan', so forget them if you wish to get quickly to the data. Hopefully (and your DISTINCT-less result seems to indicate this) the TYPE and/or CODE conditions are very selective. If scanning LOCATION is not too painful, this can give good results : select LTRIM(L.STREET_ADDRESS_BEGIN||' '||L.STREET_NAME_PREFIX||' '||L.STREET_NAME||' '||L.STREET_NAME_SUFFIX) WRECKS FROM LOCATION L WHERE L.STREET_NAME IS NOT NULL AND EXISTS (SELECT NULL FROM STREET_REQS SR WHERE SR.TYPE IN ('KED','KAD') AND SR.CODE LIKE 'O%' AND SR.ORIG_STREET_REQ_ID IS NULL AND SR.ID = L.ID) Another solution could be: select LTRIM(L.STREET_ADDRESS_BEGIN||' '||L.STREET_NAME_PREFIX||' '||L.STREET_NAME||' '||L.STREET_NAME_SUFFIX) WRECKS FROM LOCATION L WHERE L.STREET_NAME IS NOT NULL AND L.ID IN (SELECT SR.ID FROM STREET_REQS SR WHERE SR.TYPE IN ('KED','KAD') AND SR.CODE LIKE 'O%' AND SR.ORIG_STREET_REQ_ID IS NULL) However, this is unlikely to be efficient if the inner query returns 10,000 rows. Do not play with parameters before having tried everything else. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: DB Config. Assistant
Hi I don't use dbca, but did it even create the data dictionary ? Run catalog.sql and catproc.sql (and whatever you need) to create it manually. Regards, Stefan -Ursprüngliche Nachricht-Von: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]Gesendet: Dienstag, 30. April 2002 15:38An: Multiple recipients of list ORACLE-LBetreff: DB Config. Assistant 9i on XP Prof. on DELL PC (no network) I tried to use DBCA to create a DB on my PC.I have never used this tool before. It appeared to run OK with no errors. However, when I query the V$ views I don't see it and I cannot connect to it. I ran DBCA twice to create the DB and the second time I didn't get any error message saying the DB already existed. I don't know that I should since I have never used DBCA before. If there is anyone out there that have used this tool before please give me some insight into it. Thanks and have a good day, Ken Janusz, CPIM
Re: DB Config. Assistant
I assume you're talking about the dbassist tool. If it's working as on unix, you should find the log files in $ORACLE_BASE/admin/$ORACLE_SID/create. I prefer the old way, using scripts, this way I can rerun the scripts for all the different environnements. HTH --- KENNETH JANUSZ [EMAIL PROTECTED] a écrit : 9i on XP Prof. on DELL PC (no network) I tried to use DBCA to create a DB on my PC. I have never used this tool before. It appeared to run OK with no errors. However, when I query the V$ views I don't see it and I cannot connect to it. I ran DBCA twice to create the DB and the second time I didn't get any error message saying the DB already existed. I don't know that I should since I have never used DBCA before. If there is anyone out there that have used this tool before please give me some insight into it. Thanks and have a good day, Ken Janusz, CPIM = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to deinstall oracle 9i and leave 8i intact
Tom, I started with using the installer. It appears it installed Oracle software. Of course this does nothing with the registry,services,etc. When I go back into installer it still shows some 9i installed. When I try to uninstall it insist on un-installing some oracle 8i software. I have been working in Oracle since the end of Oracle 5 and one thing is constant Oracle install/uninstall procedures SUCKS. Ok I feel a little better now,back to the problem. I found a Oracle document detailing removal or oracle software and a oracle home, followed it to the letter. Everything appears to work fine except the installer still shows some 9i software installed when I know there is not. It mus be stored elsewhere but do not know how to correct. This may cause problems if I attempt to re-install 9i. Any ideas? Thanks Rick Mercadante, Thomas F To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] [EMAIL PROTECTED]cc: '[EMAIL PROTECTED]' [EMAIL PROTECTED] ate.ny.us Subject: RE: How to deinstall oracle 9i and leave 8i intact 04/30/2002 09:01 AM Rick, how about using the installer? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, April 30, 2002 9:23 AM To: Multiple recipients of list ORACLE-L Reposting as I forgot to include a subject line on previous post. I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. How can I just remove all of Oracle 9i without touching Oracle 8i? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Deinstall 9i without touching 8i
Universal Installer can do this for you. Click the deinstall software button. I've done this a million times(over exaggeration) on both Unix and NT. ltiu On Tuesday 30 April 2002 07:13, you wrote: On Tue 30. April 2002 15:33, you wrote: [EMAIL PROTECTED] wrote: I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. How can I just remove all of Oracle 9i without touching Oracle 8i? Thanks Rick how about reading the documentation that came with the damn software? But he surely want to do it now, not in 15 years. :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ERD generation tool
Sean - Does your schema have all relationships like foreign keys defined? Otherwise you just end up with a bunch of disconnected boxes. Hardly worth the trouble. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 30, 2002 9:04 AM To: Multiple recipients of list ORACLE-L ERWin www.ca.com ERStudio www.embarcadero.com Active Designer http://www.iraje.com/ad_fsmain.htm HTH Mark -Original Message- Sean Sent: 30 April 2002 13:24 To: Multiple recipients of list ORACLE-L Can anyone please recommend/advise on NT/W2K compliant solutions which can generate ERD's by interogating the DB. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 8i installation help
Having seen a number of people come to grief because they tried to delete unnecessary files, I have a bad feeling about this one. I can't imagine that space on a server where you've installed Oracle is so tight that this is necessary. Disk is so cheap today. Good grief, what happens if you need to expand an Oracle datafile? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 30, 2002 8:59 AM To: Multiple recipients of list ORACLE-L Greetings, If I remember correctly after the install of Oracle 8i, we can delete some of the files(*O and *o) from some directory under $ORACLE_HOME. Probably from $ORACLE_HOME/bin or $ORACLE_HOME/lib or some directory. Could you please confirm this and is there any white paper or any document from Oracle, where it specifies about this. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:
I have been reading/searching the DAMN documentation like I always do before posting a question. It is frustrating enough to get this to work correctly. I do not need this type of reply so keep it to yourself. All it does is add to the frustration. I greatly appreciate the constructive help I have gotten from the others. bill thater bthater2@netTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] scape.net cc: Sent by: Subject: Re: root@fatcity. com 04/30/2002 09:33 AM Please respond to ORACLE-L [EMAIL PROTECTED] wrote: I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. How can I just remove all of Oracle 9i without touching Oracle 8i? Thanks Rick how about reading the documentation that came with the damn software? -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. A computer scientist is someone who fixes things that aren't broken. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Re: Is sqlplus too slow to unload data?]
Stephane, pdqout does give me a real good impression, not only the speed but also the interface. I can see it uses parallel query. However, I, as a production DBA, intend to change the application which come from a third party as a package as small as possible. It takes 4hours to extract data at 5M/minute. If the speed of sqlplus can be increased to 20M/minute, I achieve the goal. Just one thing about pdqout confuses me. I have to use DBA account, otherwise I get the following error. ' Oracle oexfet() failure (-907) ORA-00907: missing right parenthesis ' Kind Regards, Bin AFAIK it's a bug who has stayed in some versions, due to an innate tendency to make a distinction between the DBA elite and the scum of the earth ;-). Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [oracle-l-OT] Re: Re: ANTI-VIRUS SPAM - YOUR EMAIL ADMIN IS A
Ross, Please pay more attention to which list you are sending posts to. Jared On Tuesday 30 April 2002 06:13, Mohan, Ross wrote: I'd say Tim is stuck in Buddhist nondoing-ness while simultaneously missing the point (It's the SageLogix server, STOOPID) and calling the kettle black (don't call me names from your playbook; instead denigrate via condecension and superciliousness) Brown? Maybe this guy needs a good, relaxing BM. And yea, virus scanning that works by blind, utter deletion is frustrating. But Eric, what about this guy's ... humanity? Back into my cage, etc. -Original Message- To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: 4/29/2002 7:47 PM DIKHEAD You silly! I was talking about the email admin at the guy's company, not fatcity. It has subsequently been explained to me that damagement is at fault (surprise) and ought to be blamed for all evil, not the email admin. http://www.dogdoo.com Ross can explain how brown fits into the metaphysical context of your astral plane. ORACLE-L Digest -- Volume 2002, Number 118 -- From: Tim Gorman [EMAIL PROTECTED] Date: Sat, 27 Apr 2002 10:34:46 -0600 Subject: Re: ANTI-VIRUS SPAM - YOUR EMAIL ADMIN IS A DIKHEAD / (Fwd) Antigen found =*.*.txt file Eric, A 5th-grade teacher once admonished me on cursing by pointing out that the English language has 100,000 words in frequent usage and how unimaginative it was to constrain myself to the same dozen or so words to describe my feelings... Bruce, the guy who runs FATCITY as a sideline business (because this business doesn't generate enough money to support the typical family), restricts all attachments not only out of concern for viruses, but for the more practical reason of limiting message size and therefore storage and network capacity. It's a good policy -- if you'd like to send attachments, please address people directly... ...and please grow up. -Tim I don't know if this guy (Evans, David) is subscribed to this list, but if so, please tell your email admin that this stuff sucks. A text file attachment is not automatically equivalent to a virus attachment. If their system wasn't set up by such dikheads, they would know that they can implement packet scanning at the email gateway in a non-intrusive manner that is far more effective than this spam cr*pola. http://www.antivirus.com/products/isvw/ regards, ep Yahoo! Groups Sponsor -~-- Tied to your PC? Cut Loose and Stay connected with Yahoo! Mobile http://us.click.yahoo.com/QBCcSD/o1CEAA/yigFAA/o7folB/TM -~- To talk about oracle database issues: subscribe to [EMAIL PROTECTED] To do the offtopic(OT) thing. post here :) To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to insert new lines through SQLLDR
Hi all, I need to insert special charecter into the database through sql loader. i.e., I have a table with LONG datatype field and data should read: [Cancellation] IF ServiceDate = sysdate THEN Chargepercent(100) ELSEIF ServiceDate sydate THEN chargepercent(50) ELSE chargepercent(25) ENDIF My flat file: '[Cancellation' ||chr(13)||chr(10)|| 'IF ServiceDate = sydate THEN ' ||chr(13)||chr(10)|| 'Chargeperce(100)' ||chr(13)||chr(10)|| 'ELSEIF ServiceDate sysdate THEN ' ||chr(13)||chr(10)|| 'chargepercent(50)' ||chr(13)||chr(10)|| 'ELSE ' ||chr(13)||chr(10)|| 'chargepercent(25)' ||chr(13)||chr(10)|| 'ENDIF' When I use the above flat file to load the table with sqlldr the table is not getting populated the way I expected. How can I insert the new lines? Thanks, Suhasini. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kanchanakuntla, Suhasini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Financials Sys Admin. Needed in South Carolina
Lisa - Its all relative, FL may not be as cheap as MN, but it sure is cheaper than NY :-). Never again, would I live in NY, but don't ask my wife (she misses her roots). [EMAIL PROTECTED] 04/29/02 04:48PM I have been told that Atlanta is the New York of the south. The cost of living in Atlanta is NOT cheap due to the cost of utilities (mostly power) and housing. And don't let anyone tell you that about Florida, either. They will tell you that not paying state tax is like getting a 8% pay raise. Bull. Dade and Broward county are so built up that the cost of housing is skyrocketing, even with yards the size of a half postage stamp. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Jenkins, Michael - EDS [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 3:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Financials Sys Admin. Needed in South Carolina Yeah, pass me a sweet tea and a piece of straw to pick my teeth with! There's just as much stress here in the Atlanta area as anywhere else I've ever lived. And, NO, the cost of living is not any lower than anywhere else contrary to what recruiters and hiring managers will tell you. Since the profit margin on groceries is about 2% I suspect we all pay about the same amount unless you shop in a Kwikie Mart. The only bright spot is gasoline costs $1.109 at Kroger! Money is as money does. -Original Message- Sent: Monday, April 29, 2002 3:04 PM To: Multiple recipients of list ORACLE-L Oh come on! Things are so much more relaxed in the deep south. -Original Message- Sent: Monday, April 29, 2002 1:38 PM To: Multiple recipients of list ORACLE-L This job sounds like a nightmare! A one-person show. I can't think of a situation that could possibly be more stressful. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle Financials Sys Admin. Needed in South Carolina Geographic region affects pay scale just as much as years of experience, I think.Especially on the extreme ends of the scale such as a small town in a rural region or say Manhattan or San Fransisco. I think it's very difficult to judge pay scales in areas where you haven't been monitoring the job market for a while. It's like comparing apples and oranges because there are too many variables. My two cents. Cherie Machler Oracle DBA Gelco Information Network Minneapolis, Minnesota Freeman, Robert To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Robert_Freema cc: [EMAIL PROTECTED] Subject: RE: Oracle Financials Sys Admin. Needed in South Carolina Sent by: [EMAIL PROTECTED] om 04/29/02 12:58 PM Please respond to ORACLE-L Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. I'm wondering what frequent means...? Am I the only one that thinks the pay scale is a bit low, with this caveat? To me, the paradigm seems to be the new guys out there change jobs frequently, for better money and experience and then, a bit later on, they find a place that appreciates them for who they are, pays them what they are worth and doesn't want to let them go. Granted, the current economic downturn may have changed that picture a bit... With what they are offering in pay, I'm not sure they will find anyone with any long term experience. What does anyone else think? RF -Original Message- Sent: Monday, April 29, 2002 12:34 PM To: Multiple recipients of list ORACLE-L Company located in Spartanburg, South Carolina with a small IT shop needs an Oracle Financials System Adminsitrator to join its IT team. Relocation Assistance is provided. PLEASE Do Not send your resume for this position UNLESS you have the qualifications for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: The Systems Administrator will be responsible for
Re:
Bill, It isn't necessary to resort to this. Just press DELETE if you don't like it. Jared On Tuesday 30 April 2002 06:33, bill thater wrote: [EMAIL PROTECTED] wrote: I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. How can I just remove all of Oracle 9i without touching Oracle 8i? Thanks Rick how about reading the documentation that came with the damn software? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: pl/sql is INTERPRETED?
Hi how about Java within Oracle. What do you think about it ? When does it make sense to use Java instead of PL/SQL ? The problem is that I dislike a mix of different languages within an application. It messes things up. But maybe it makes sense to use PL/SQL for most stuff and Java for some specific things (perhaps accessing a file or using a network resource ?). As far as I know, there is an option to compile the Java into platform dependend code, which would make it execute much faster then bytecode (and PL/SQL?), since the later has to be interpreted at run-time. Any opinions ? Regards, -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 30. April 2002 16:09 An: Multiple recipients of list ORACLE-L Betreff: Re:pl/sql is INTERPRETED? Lisa, It is both true false at the same time. Obviously any anonymous blocks you submit to the database are fully interpreted. PL/SQL that you store in the database as procedures, functions, and packages get partially compiled into a p-code. This makes the code ready for execution, but retains a modular design so that if your DBA reloads catproc your code is not totally destroyed. Where I think PL/SQL buys us a lot of performance is in reducing the communications outside of the database that is otherwise needed. There's no JDBC driver or other miscellaneous mess (like SQL*Net) required. It's all handled inside the kernel. Now the bad part about PL/SQL that Java handles better is platform independence. You can run Java on your client, the apps server or database without a problem. PL/SQL on the other hand must be run in the database. Dick Goulet Reply Separator Author: Koivu; Lisa [EMAIL PROTECTED] Date: 4/29/2002 2:52 PM Can this be true? How can this be? If it's optimized to manipulate data within the database, how can it be fast if it's interpreted (like that slow poke, Java)? I see this on Connor's website www.oracledba.co.uk under explicit/implicit cursors, under pl/sql. What on earth? Can someone elaborate, namely, Connor?? Please help me understand this... My green may be showing, but my gosh. Lisa Koivu Oracle Database Baby Oven Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to deinstall oracle 9i and leave 8i intact
The destination address you specified for your message could not be reached because of a locking problem. Your message is being returned to you so that you can resend it if you desire. The locking problem should be resolved within a few minutes. Sorry for the inconvenience. geez... have a bad morning and look what happens.;-) - Original Message -- [EMAIL PROTECTED] wrote: document detailing removal or oracle software and a oracle home, followed it to the letter. Everything appears to work fine except the installer still shows some 9i software installed when I know there is not. It mus be stored elsewhere but do not know how to correct. This may cause problems if I attempt to re-install 9i. Any ideas? any chance it's just in the oraInventory file and not really on the disk? i don't know if that screws things up, but usually it just asks if you want to reinstall it. -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. A computer scientist is someone who fixes things that aren't broken. -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. A computer scientist is someone who fixes things that aren't broken. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to deinstall oracle 9i and leave 8i intact
Hi Rick, I would first shut down the 9i versions of the services for any database, listeners, intelligent agents, etc. Then using the installer I would deinstall all 9i software. Then using regedt32 I would remove the home key for the Oracle9i home. That should just about do it. John [EMAIL PROTECTED] wrote: What platform are you working on? Windows or Unix?-Joe--- [EMAIL PROTECTED] wrote: Reposting as I forgot to include a subject line on previous post.I have Oracle 8i with 4 instances and Oracle 9i with 1 instance.How can I just remove all of Oracle 9i without touching Oracle 8i?ThanksRick-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / MailingLists To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).__Do You Yahoo!?Yahoo! Health - your guide to health and wellnesshttp://health.yahoo.com
Re: Oracle Windows
Thanks Thomas. Jared On Monday 29 April 2002 14:53, Thomas Day wrote: This message bounced back to me as undeliverable. Just in case it got through, the 3rd link was bad and I have replaced it with the correct URL. I had copies still on my hard drive so I uploaded them. I emphasize that these are not my work but the work of the authors whose names appear on the papers. I had three papers that pertain to Oracle and NT. They are at: This is about Oracle 9 on NT/2000 http://www.msnusers.com/torac/Documents/SQL-Ora/Maximizing%20Productivity%2 0.doc This is about Oracle 8 on NT http://www.msnusers.com/torac/Documents/SQL%2DOra/Oracle8%20on%20NT%2Edoc This is a pdf about configuration standards for Oracle on NT http://www.msnusers.com/torac/Documents/SQL%2DOra%2FORACLE%5FNT%5FCONFIG.pd f If you don't have hotmail userids I have also uploaded them to http://www.geocities.com/tomdaytwo/MaximizingProductivity.htm http://www.geocities.com/tomdaytwo/Oracle8onNT.htm http://www.geocities.com/tomdaytwo/ORACLE_NT_CONFIG.pdf You should be able to find them at one place or the other. HTH -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Slow select distinct
- Original Message - From: Shaw John-P55297 [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tue, 30 Apr 2002 06:13:42 Unfortunately there are duplicates so they do need the distinct clause. I have tried several permutations of the query and distinct clauses including the most popular alternative: select distinct wrecks from (select DISTINCT LTRIM(L.STREET_ADDRESS_BEGIN||' '||L.STREET_NAME_PREFIX||' '||L.STREET_NAME||' '||L.STREET_NAME_SUFFIX) WRECKS FROM LOCATION L, STREET_REQS SR WHERE L.ID = SR.ID AND L.STREET_NAME IS NOT NULL AND SR.TYPE IN ('KED','KAD') AND SR.CODE LIKE 'O%' AND SR.ORIG_STREET_REQ_ID IS NULL); However it all seems to go back to the sort on the 9500 rows being returned. Try a 'divide and conquer' approach then, eliminating duplicates first as they might occur from several rows in STREET_REQS matching the same row in LOCATION, then by eliminating the remaining duplicates. Should lighten the burden of sorting. What about : select DISTINCT LTRIM(L.STREET_ADDRESS_BEGIN||' '||L.STREET_NAME_PREFIX||' '||L.STREET_NAME||' '||L.STREET_NAME_SUFFIX) WRECKS FROM LOCATION L, (select DISTINCT ID FROM STREET_REQS WHERE TYPE IN ('KED','KAD') AND CODE LIKE 'O%' AND ORIG_STREET_REQ_ID IS NULL) SR WHERE L.ID = SR.ID AND L.STREET_NAME IS NOT NULL; Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Partitioning Quandry
here's one for the partitioning gurus out there I have an INVOICE table that I want to partition for performance and purging. The way I want to partition it is to do range partitioning on the INVOICE_STATE column, then sub-partition some of the partitions by UPDATE_DATE. The logic behind this is: 1) An invoice may be in sent, but unpaid (A) state for several months. 2) We never want to purge off unpaid invoices 3) After an invoice has been in paid (P) state for 6 months, we want to purge the invoice My basic idea was to have partition-movement enabled and to use a partitioning scheme like the following: TABLE invoice ( invoice_id, invoice_state, update_date, ... ) partition by range (invoice_state) ( partition inv_act values less than 'B' ,partition inv_hist values less than 'R' subpartition by range (update_date) ); Alas, you can only subpartition by HASH (or LIST in 9iR2) The only solution I can come up with is a 2 table solution -- keeping the unpaid invoices in one table and the paid invoices in another table that is range partitioned on UPDATE_DATE. The difficulties with this solution are coding the row movements (bi-directional) and having to code a partition-view. Any suggestions would be helpful. Kevin Toepke [EMAIL PROTECTED] The information in this electronic mail message is Trilegiant Confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Trilegiant Corporation is not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:
How about sending it just ONCE ??? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 3:33 PM [EMAIL PROTECTED] wrote: I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. How can I just remove all of Oracle 9i without touching Oracle 8i? Thanks Rick how about reading the documentation that came with the damn software? -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. A computer scientist is someone who fixes things that aren't broken. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DB Config. Assistant
Stefen: I have to apologize, I goofed. In dbca the final wizard window has an OK button at the bottom. It was below my lower screen edge and I didn't see it. So, I didn't press it and of course didn't create the DB. On my third time through the process I noticed this button, pressed it and 45 min. later had my DB. I went out on TOAD and there it is. It sure helps if you know what the heck you are doing. Ah Duh! Thanks for the help and have a good day, Ken Janusz, CPIM - Original Message - From: Stefan Jahnke To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 30, 2002 9:20 AM Subject: AW: DB Config. Assistant Hi I don't use dbca, but did it even create the data dictionary ? Run catalog.sql and catproc.sql (and whatever you need) to create it manually. Regards, Stefan -Ursprüngliche Nachricht-Von: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]Gesendet: Dienstag, 30. April 2002 15:38An: Multiple recipients of list ORACLE-LBetreff: DB Config. Assistant 9i on XP Prof. on DELL PC (no network) I tried to use DBCA to create a DB on my PC.I have never used this tool before. It appeared to run OK with no errors. However, when I query the V$ views I don't see it and I cannot connect to it. I ran DBCA twice to create the DB and the second time I didn't get any error message saying the DB already existed. I don't know that I should since I have never used DBCA before. If there is anyone out there that have used this tool before please give me some insight into it. Thanks and have a good day, Ken Janusz, CPIM
Re: Oracle wants your job
RANT This has all been tried before, and the predictions are the same: financial nirvana, big savings in technology costs, no pesky holier-than-thou DBA's baffling poor damagers with stuff they can't possibly understand. /RANT Very few executive, managers or DBA's are going to want to place their corporate data on Oracle's site, or even provide access to it from outside for non-employees. There's also the whipping boy factor. Who's butt you going to kick when the database is screwed up? ;) Heard a good quote on a documentary the other night: A corporation has no soul to save nor an ass to kick. Someone local must be accountable for the data. The whole outsourcing thing is kind of baffling to me at times. Why not carry it out its fullest measure? Outsource mfg, sales, IT, design and executives. No need for any employees. Guess I turned of the rant too soon. Jared On Tuesday 30 April 2002 06:44, Farnsworth, Dave wrote: http://www.infoworld.com/articles/se/xml/02/04/29/020429seoracle.xml Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DB Config. Assistant
Hi Ken, When you run the database configuration assistant (DBCA) it asks you to provide the sid for the database. You should be able to see the service associated with this database by looking at the "services". Don't know ANY XP but the service should be named "OracleServiceSID". Check to make sure that this service is started. If not you will have to start this service before you can connect. Assuming that it is started you can connect from a dos window by typing set oracle_sid="yoursid" sqlplus system/manager from here you should be able to query the dd tables. John [EMAIL PROTECTED] wrote: 9i on XP Prof. on DELL PC (no network) I tried to use DBCA to create a DB on my PC.I have never used this tool before. It appeared to run OK with no errors. However, when I query the V$ views I don't see it and I cannot connect to it. I ran DBCA twice to create the DB and the second time I didn't get any error message saying the DB already existed. I don't know that I should since I have never used DBCA before. If there is anyone out there that have used this tool before please give me some insight into it. Thanks and have a good day, Ken Janusz, CPIM
RE: pl/sql is INTERPRETED?
This is something that's been debated on the list in the past. The general consensus was: For manipulating data in the database, nothing beats pl/sql. It is well suited for this purpose. For everything else, java could beat it. I am sure fellow list members will post links describing studies. I remember seeing these last year. Stefan, have you tried running your own test? There's a sure fire way to convince yourself. Even a small test (no fancy code) would suffice. Wish I had more time to play... Lisa Koivu Oracle Database Monkey Mama Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Stefan Jahnke [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Subject: AW: pl/sql is INTERPRETED? Hi how about Java within Oracle. What do you think about it ? When does it make sense to use Java instead of PL/SQL ? The problem is that I dislike a mix of different languages within an application. It messes things up. But maybe it makes sense to use PL/SQL for most stuff and Java for some specific things (perhaps accessing a file or using a network resource ?). As far as I know, there is an option to compile the Java into platform dependend code, which would make it execute much faster then bytecode (and PL/SQL?), since the later has to be interpreted at run-time. Any opinions ? Regards, -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 30. April 2002 16:09 An: Multiple recipients of list ORACLE-L Betreff: Re:pl/sql is INTERPRETED? Lisa, It is both true false at the same time. Obviously any anonymous blocks you submit to the database are fully interpreted. PL/SQL that you store in the database as procedures, functions, and packages get partially compiled into a p-code. This makes the code ready for execution, but retains a modular design so that if your DBA reloads catproc your code is not totally destroyed. Where I think PL/SQL buys us a lot of performance is in reducing the communications outside of the database that is otherwise needed. There's no JDBC driver or other miscellaneous mess (like SQL*Net) required. It's all handled inside the kernel. Now the bad part about PL/SQL that Java handles better is platform independence. You can run Java on your client, the apps server or database without a problem. PL/SQL on the other hand must be run in the database. Dick Goulet Reply Separator Author: Koivu; Lisa [EMAIL PROTECTED] Date: 4/29/2002 2:52 PM Can this be true? How can this be? If it's optimized to manipulate data within the database, how can it be fast if it's interpreted (like that slow poke, Java)? I see this on Connor's website www.oracledba.co.uk under explicit/implicit cursors, under pl/sql. What on earth? Can someone elaborate, namely, Connor?? Please help me understand this... My green may be showing, but my gosh. Lisa Koivu Oracle Database Baby Oven Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
Re: Oracle wants your job
My daughter works for a large retailer here in Minneapolis, MN. They got one of these big outfits that promised them the moon, etc. The companies initials are IBwhatever. Guess who the call when they can't figure out something? The IS staff. Big deal! Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 10:08 AM RANT This has all been tried before, and the predictions are the same: financial nirvana, big savings in technology costs, no pesky holier-than-thou DBA's baffling poor damagers with stuff they can't possibly understand. /RANT Very few executive, managers or DBA's are going to want to place their corporate data on Oracle's site, or even provide access to it from outside for non-employees. There's also the whipping boy factor. Who's butt you going to kick when the database is screwed up? ;) Heard a good quote on a documentary the other night: A corporation has no soul to save nor an ass to kick. Someone local must be accountable for the data. The whole outsourcing thing is kind of baffling to me at times. Why not carry it out its fullest measure? Outsource mfg, sales, IT, design and executives. No need for any employees. Guess I turned of the rant too soon. Jared On Tuesday 30 April 2002 06:44, Farnsworth, Dave wrote: http://www.infoworld.com/articles/se/xml/02/04/29/020429seoracle.xml Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: Oracle wants your job
Jared, The other problem with outsourcing, which we've run head on into, is that an ASP wants you to run the application plain vanilla. Customization of an application to fit your business/needs is one area they really do not like to handle. Makes upgrading a pain in the *^, which means some of your clients are running PeopleSoft 7 while the remainder are on Peoplesoft 8. Also your patch levels will vary, due to the customization. Hence, if you need to customize you can't outsource. Dick Goulet Reply Separator Author: Jared Still [EMAIL PROTECTED] Date: 4/30/2002 7:08 AM RANT This has all been tried before, and the predictions are the same: financial nirvana, big savings in technology costs, no pesky holier-than-thou DBA's baffling poor damagers with stuff they can't possibly understand. /RANT Very few executive, managers or DBA's are going to want to place their corporate data on Oracle's site, or even provide access to it from outside for non-employees. There's also the whipping boy factor. Who's butt you going to kick when the database is screwed up? ;) Heard a good quote on a documentary the other night: A corporation has no soul to save nor an ass to kick. Someone local must be accountable for the data. The whole outsourcing thing is kind of baffling to me at times. Why not carry it out its fullest measure? Outsource mfg, sales, IT, design and executives. No need for any employees. Guess I turned of the rant too soon. Jared On Tuesday 30 April 2002 06:44, Farnsworth, Dave wrote: http://www.infoworld.com/articles/se/xml/02/04/29/020429seoracle.xml Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: ANTI-VIRUS SPAM - YOUR EMAIL...
Jared, Sorryjust did a reply all to what I thought was a private conversation. Guess we all have to pay attention to who/what is in the address list! Cheers, -- Ross -Original Message- Sent: Tuesday, April 30, 2002 9:55 AM To: [EMAIL PROTECTED]; Mohan, Ross A Ross, Please pay more attention to which list you are sending posts to. Jared ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORACLE FORMS
Hi Oracle forms is time delay sensitive? Delay sensitive traffic is stuff like video or voice traffic. Thanks -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Root Cause Analysis White Papers
We have been having some heavy discussions about system failures, root cause analysis and developing some proactive metrics. Generally, our problems revolve around frequently late nights for the On Call DBA because something out of our control goes wrong. The damagement folks want to fix the immediate problem and consider the job done. The DBAs are asking for an approach that will allow us to identify potential problems before something breaks at 3:00 a.m. Does anyone know of a source of white papers or other data that has been generated for systems, storage or databases? We can always roll out own, but why recreate someone else's work. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to insert new lines through SQLLDR
Several things. One, you can indicate (RTFM, don't remember the details) that your physical record is terminated by something else than a carriage return. Second, if what you want to store is PL/SQL code, then carriage returns are useless - they are 'for your eyes only' (which is why you have a hardly readable but Oracle-usable V$SQLTEXT and a V$SQLTEXT_WITH_NEW_LINES when having an indiscreet peek into the SGA). Third, if I were you I would use either CLOBs or even VARCHAR2 rather than LONGs. Fourth, you look on your way to build the application of death and reinventing the stored procedure. There are times when flexibility is not THAT desirable. I am not sure that EXECUTE IMMEDIATE of dynamically built PL/SQL blocks (if I read correctly between the lines) is a good solution. - Original Message - From: Kanchanakuntla, Suhasini [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tue, 30 Apr 2002 07:08:51 Hi all, I need to insert special charecter into the database through sql loader. i.e., I have a table with LONG datatype field and data should read: [Cancellation] IF ServiceDate = sysdate THEN Chargepercent(100) ELSEIF ServiceDate sydate THEN chargepercent(50) ELSE chargepercent(25) ENDIF My flat file: '[Cancellation' ||chr(13)||chr(10)|| 'IF ServiceDate = sydate THEN ' ||chr(13)||chr(10)|| 'Chargeperce(100)' ||chr(13)||chr(10)|| 'ELSEIF ServiceDate sysdate THEN ' ||chr(13)||chr(10)|| 'chargepercent(50)' ||chr(13)||chr(10)|| 'ELSE ' ||chr(13)||chr(10)|| 'chargepercent(25)' ||chr(13)||chr(10)|| 'ENDIF' When I use the above flat file to load the table with sqlldr the table is not getting populated the way I expected. How can I insert the new lines? Thanks, Suhasini. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kanchanakuntla, Suhasini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- - Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: pl/sql is INTERPRETED?
Lisa, You are right about the debate between PL/SQL Java (or anything else outside of the db). In my mind, the deciding factor (and something that is *never* mentioned) is what programming langauage the organization is satisfied with/settled upon. In my little opinion, *any* programmer can learn PL/SQL in a very short period of time. This means that development and maintenance costs are relatively low. If an IT shop is stronger in Java, then they should probably program in Java, or Cobol, or Ada, or whatever the flavor of the decade happens to be (lets bring back APL!). IT tool selection/standards should be the deciding factor. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, April 30, 2002 11:34 AM To: Multiple recipients of list ORACLE-L This is something that's been debated on the list in the past. The general consensus was: For manipulating data in the database, nothing beats pl/sql. It is well suited for this purpose. For everything else, java could beat it. I am sure fellow list members will post links describing studies. I remember seeing these last year. Stefan, have you tried running your own test? There's a sure fire way to convince yourself. Even a small test (no fancy code) would suffice. Wish I had more time to play... Lisa Koivu Oracle Database Monkey Mama Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Stefan Jahnke [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Subject: AW: pl/sql is INTERPRETED? Hi how about Java within Oracle. What do you think about it ? When does it make sense to use Java instead of PL/SQL ? The problem is that I dislike a mix of different languages within an application. It messes things up. But maybe it makes sense to use PL/SQL for most stuff and Java for some specific things (perhaps accessing a file or using a network resource ?). As far as I know, there is an option to compile the Java into platform dependend code, which would make it execute much faster then bytecode (and PL/SQL?), since the later has to be interpreted at run-time. Any opinions ? Regards, -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 30. April 2002 16:09 An: Multiple recipients of list ORACLE-L Betreff: Re:pl/sql is INTERPRETED? Lisa, It is both true false at the same time. Obviously any anonymous blocks you submit to the database are fully interpreted. PL/SQL that you store in the database as procedures, functions, and packages get partially compiled into a p-code. This makes the code ready for execution, but retains a modular design so that if your DBA reloads catproc your code is not totally destroyed. Where I think PL/SQL buys us a lot of performance is in reducing the communications outside of the database that is otherwise needed. There's no JDBC driver or other miscellaneous mess (like SQL*Net) required. It's all handled inside the kernel. Now the bad part about PL/SQL that Java handles better is platform independence. You can run Java on your client, the apps server or database without a problem. PL/SQL on the other hand must be run in the database. Dick Goulet Reply Separator Author: Koivu; Lisa [EMAIL PROTECTED] Date: 4/29/2002 2:52 PM Can this be true? How can this be? If it's optimized to manipulate data within the database, how can it be fast if it's interpreted (like that slow poke, Java)? I see this on Connor's website www.oracledba.co.uk under explicit/implicit cursors, under pl/sql. What on earth? Can someone elaborate, namely, Connor?? Please help me understand this... My green may be showing, but my gosh. Lisa Koivu Oracle Database Baby Oven Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Oracle Windows
FYI, Oracle Canada is supposedly putting instructions together for me on how to secure iAS on NT, that should be interesting. Waiting patiently. 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- Sent: Monday, April 29, 2002 6:54 PM To: Multiple recipients of list ORACLE-L This message bounced back to me as undeliverable. Just in case it got through, the 3rd link was bad and I have replaced it with the correct URL. I had copies still on my hard drive so I uploaded them. I emphasize that these are not my work but the work of the authors whose names appear on the papers. I had three papers that pertain to Oracle and NT. They are at: This is about Oracle 9 on NT/2000 http://www.msnusers.com/torac/Documents/SQL-Ora/Maximizing%20Productivity%20 .doc This is about Oracle 8 on NT http://www.msnusers.com/torac/Documents/SQL%2DOra/Oracle8%20on%20NT%2Edoc This is a pdf about configuration standards for Oracle on NT http://www.msnusers.com/torac/Documents/SQL%2DOra%2FORACLE%5FNT%5FCONFIG.pdf If you don't have hotmail userids I have also uploaded them to http://www.geocities.com/tomdaytwo/MaximizingProductivity.htm http://www.geocities.com/tomdaytwo/Oracle8onNT.htm http://www.geocities.com/tomdaytwo/ORACLE_NT_CONFIG.pdf You should be able to find them at one place or the other. HTH -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-27101 Shared Memory Realm Does Not Exist
Check memory on your server, you need to have enough physical RAM to hold your SGA and the Oracle processes. The services applet lies, sometimes it will say that a database NT service is running when in fact it is in a half-opened state. An easy way to test is to connect from the command line using sqlplus or (gasp!) svrmgrl. connect as internal or as sysdba. 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- Sent: Monday, April 29, 2002 5:43 PM To: Multiple recipients of list ORACLE-L I just installed Oracle 9i on a WinNT 4 server. It already had 8.1.6. I installed Oracle 9 into a different home. The service/instance starts. When I try to connect via sqlplus / to create a database I get ORA-27101 Shared Memory Realm Does Not Exist . I have the oracle_sid set correctly. Any ideas as I have tried all I know but still get the same error. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle wants your job
My browser says page not found. 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- Sent: Tuesday, April 30, 2002 10:44 AM To: Multiple recipients of list ORACLE-L http://www.infoworld.com/articles/se/xml/02/04/29/020429seoracle.xml Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Root Cause Analysis White Papers
Peter - I can see your desires going in two directions: 1. Operational procedures - Things like how do I know I'm running out of disk space before I've run out. 2. Change management. Most failures come from changes to the software. Like somebody adds some programs and that affects other programs. Or somebody changes a table and that affects another program. For both of these, I wouldn't limit myself to sources specific to Oracle. Good standard I.S. procedures. I haven't read it, but Oracle 24x7 Tips and Techniques by Venkat S. Devraj and Ravi Balwada looks as if it has some chapters that may be pertinent. Here is a link that might work, but will probably get chopped. http://shop.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA1J; mscssid=DDX7X88RWH4S9NNU2QH8344EP6QJ4VX7isbn=0072119993 Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 30, 2002 11:11 AM To: Multiple recipients of list ORACLE-L We have been having some heavy discussions about system failures, root cause analysis and developing some proactive metrics. Generally, our problems revolve around frequently late nights for the On Call DBA because something out of our control goes wrong. The damagement folks want to fix the immediate problem and consider the job done. The DBAs are asking for an approach that will allow us to identify potential problems before something breaks at 3:00 a.m. Does anyone know of a source of white papers or other data that has been generated for systems, storage or databases? We can always roll out own, but why recreate someone else's work. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Windows
Thanks for the links. We are now in the process of tuning a database, on NT, without any option to change the application code (3rd party). I downloaded the docs and hope they will help me. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, April 29, 2002 11:53 PM This message bounced back to me as undeliverable. Just in case it got through, the 3rd link was bad and I have replaced it with the correct URL. I had copies still on my hard drive so I uploaded them. I emphasize that these are not my work but the work of the authors whose names appear on the papers. I had three papers that pertain to Oracle and NT. They are at: This is about Oracle 9 on NT/2000 http://www.msnusers.com/torac/Documents/SQL-Ora/Maximizing%20Productivity%20 .doc This is about Oracle 8 on NT http://www.msnusers.com/torac/Documents/SQL%2DOra/Oracle8%20on%20NT%2Edoc This is a pdf about configuration standards for Oracle on NT http://www.msnusers.com/torac/Documents/SQL%2DOra%2FORACLE%5FNT%5FCONFIG.pdf If you don't have hotmail userids I have also uploaded them to http://www.geocities.com/tomdaytwo/MaximizingProductivity.htm http://www.geocities.com/tomdaytwo/Oracle8onNT.htm http://www.geocities.com/tomdaytwo/ORACLE_NT_CONFIG.pdf You should be able to find them at one place or the other. HTH -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: persistent connections vs. login/logout white papers anyone?
Hi Robert, When I signed on at cybersurf the webserver (apache/perl/DBI) was handling 500 - 900 clients at any one time and the listener process took the most CPU as defined by top. The database server was pinned and everything was failing. By adding mod-perl to the mix (for caching database connections only, all the code was still running as a normal cgi) the listener dropped to usual CPU levels and the machine went to about a 30% CPU utilization. The one caveat is ensure that the webserver has a is fairly aggressive about shutting down idle connections or the database server will swap out the server side process causing shorter but still annoying delays. Also use dedicated servers as the MTS has problems dealing with long winded connections. HTH Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: Oracle wants your job
Good points all. Reminds me of Larry E's statement last year that businesses should be run the way the software works: no customizations. Can you see why he said that? :) Oracle corp knows best. Jared On Tuesday 30 April 2002 07:58, [EMAIL PROTECTED] wrote: Jared, The other problem with outsourcing, which we've run head on into, is that an ASP wants you to run the application plain vanilla. Customization of an application to fit your business/needs is one area they really do not like to handle. Makes upgrading a pain in the *^, which means some of your clients are running PeopleSoft 7 while the remainder are on Peoplesoft 8. Also your patch levels will vary, due to the customization. Hence, if you need to customize you can't outsource. Dick Goulet Reply Separator Subject:Re: Oracle wants your job Author: Jared Still [EMAIL PROTECTED] Date: 4/30/2002 7:08 AM RANT This has all been tried before, and the predictions are the same: financial nirvana, big savings in technology costs, no pesky holier-than-thou DBA's baffling poor damagers with stuff they can't possibly understand. /RANT Very few executive, managers or DBA's are going to want to place their corporate data on Oracle's site, or even provide access to it from outside for non-employees. There's also the whipping boy factor. Who's butt you going to kick when the database is screwed up? ;) Heard a good quote on a documentary the other night: A corporation has no soul to save nor an ass to kick. Someone local must be accountable for the data. The whole outsourcing thing is kind of baffling to me at times. Why not carry it out its fullest measure? Outsource mfg, sales, IT, design and executives. No need for any employees. Guess I turned of the rant too soon. Jared On Tuesday 30 April 2002 06:44, Farnsworth, Dave wrote: http://www.infoworld.com/articles/se/xml/02/04/29/020429seoracle.xml Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to deinstall oracle 9i and leave 8i intact
Hello Rick I think that you should start with DBCA and remove your 9i DB and then follow the steps in John letter. Yechiel Adar Mehish - Original Message - From: Ora NT DBA To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 30, 2002 4:59 PM Subject: Re: How to deinstall oracle 9i and leave 8i intact Hi Rick,I would first shut down the 9i versions of the services for any database, listeners, intelligent agents, etc.Then using the installer I would deinstall all 9i software.Then using regedt32 I would remove the home key for the Oracle9i home.That should just about do it.John [EMAIL PROTECTED] wrote: What platform are you working on? Windows or Unix?-Joe--- [EMAIL PROTECTED] wrote: Reposting as I forgot to include a subject line on previous post.I have Oracle 8i with 4 instances and Oracle 9i with 1 instance.How can I just remove all of Oracle 9i without touching Oracle 8i?ThanksRick-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / MailingLists To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (likesubscribing).__Do You Yahoo!?Yahoo! Health - your guide to health and wellnesshttp://health.yahoo.com
oiconnect fails
Hi. I'm running oracle 817 on Numa-Q Dynix 4.5.2. Everything seems to be OK - the database is up, listener is up, connectivity is OK. But when I run oiconnect /@instance it coredumps. No Oracle errors or anything is on the screen. What could be the problem? thanks Gene __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Slow select distinct
Thanks for the idea - however the alternative you suggested actually ran slower. It's seems to be the size of the distinct sort. -Original Message- Sent: Tuesday, April 30, 2002 9:59 AM To: Multiple recipients of list ORACLE-L - Original Message - From: Shaw John-P55297 [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tue, 30 Apr 2002 06:13:42 Unfortunately there are duplicates so they do need the distinct clause. I have tried several permutations of the query and distinct clauses including the most popular alternative: select distinct wrecks from (select DISTINCT LTRIM(L.STREET_ADDRESS_BEGIN||' '||L.STREET_NAME_PREFIX||' '||L.STREET_NAME||' '||L.STREET_NAME_SUFFIX) WRECKS FROM LOCATION L, STREET_REQS SR WHERE L.ID = SR.ID AND L.STREET_NAME IS NOT NULL AND SR.TYPE IN ('KED','KAD') AND SR.CODE LIKE 'O%' AND SR.ORIG_STREET_REQ_ID IS NULL); However it all seems to go back to the sort on the 9500 rows being returned. Try a 'divide and conquer' approach then, eliminating duplicates first as they might occur from several rows in STREET_REQS matching the same row in LOCATION, then by eliminating the remaining duplicates. Should lighten the burden of sorting. What about : select DISTINCT LTRIM(L.STREET_ADDRESS_BEGIN||' '||L.STREET_NAME_PREFIX||' '||L.STREET_NAME||' '||L.STREET_NAME_SUFFIX) WRECKS FROM LOCATION L, (select DISTINCT ID FROM STREET_REQS WHERE TYPE IN ('KED','KAD') AND CODE LIKE 'O%' AND ORIG_STREET_REQ_ID IS NULL) SR WHERE L.ID = SR.ID AND L.STREET_NAME IS NOT NULL; Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Partitioning Quandry
Kevin - This sounds similar to a partitioning issue that I was able to resolve. My suggestion is to consider partitioning on a concatenated key, INVOICE_STATE, UPDATE_DATE. You'll have to play with it, the partitions don't work the way you think they do. As I recall, if you say less than 'AL', '01-DEC-02' it will actually partition on values that equal 'AL', but less than '01-DEC-02'. I haven't done dates myself, so I probably have the syntax wrong. The part about sub-partitioning some partitions, should work as well, since your syntax is less than. If this isn't making sense, email me directly. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 30, 2002 10:04 AM To: Multiple recipients of list ORACLE-L here's one for the partitioning gurus out there I have an INVOICE table that I want to partition for performance and purging. The way I want to partition it is to do range partitioning on the INVOICE_STATE column, then sub-partition some of the partitions by UPDATE_DATE. The logic behind this is: 1) An invoice may be in sent, but unpaid (A) state for several months. 2) We never want to purge off unpaid invoices 3) After an invoice has been in paid (P) state for 6 months, we want to purge the invoice My basic idea was to have partition-movement enabled and to use a partitioning scheme like the following: TABLE invoice ( invoice_id, invoice_state, update_date, ... ) partition by range (invoice_state) ( partition inv_act values less than 'B' ,partition inv_hist values less than 'R' subpartition by range (update_date) ); Alas, you can only subpartition by HASH (or LIST in 9iR2) The only solution I can come up with is a 2 table solution -- keeping the unpaid invoices in one table and the paid invoices in another table that is range partitioned on UPDATE_DATE. The difficulties with this solution are coding the row movements (bi-directional) and having to code a partition-view. Any suggestions would be helpful. Kevin Toepke [EMAIL PROTECTED] The information in this electronic mail message is Trilegiant Confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Trilegiant Corporation is not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Messaging Gateway
I have installed it. I got the code and the documentation via a tar. They then placed it all on their ftp site. I also had to upgrade to 9.0.1.2. -Original Message- Sent: Monday, April 29, 2002 5:38 AM To: Multiple recipients of list ORACLE-L Hi All, Is there anybody among you who has installed and configured Oracle Messaging Gateway and if so, could you please tell me where I can get the guidelines for the same ?? Any help would b greatly appreciated. Thanks and Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FILE IDENTIFY wait event
Oracle8.1.7 on Solaris8 I am trying to create a tablespace on a raw device and the SQL*Plus session that performs the tablespace creation is waiting on a 'file identify'. A quick search on metalink and other docs did not indicate the root cause of the wait event. I have used the raw device previously and the create tablespace uses the 'REUSE' option. Okay gurus...any clues as to exactly what conditions cause the event? Dan Fink
Re: pl/sql is INTERPRETED?
And if you want to see the Diana-code (it's an Ada-term as I recall) all you have to do is take some wrap'ed code and "Dec" it, since wrap'ed code is nothing but Diana-code that has been Hex'ed. Guess who told me that... Mogens Connor McDonald wrote: Yup - its "compiled" into (if I recall correctly)p-code which is a tokenized and optimized version ofthe source. You can see a number of IDL prefixedtables under SYS which contain the "compiled" code. You'll see the term DIANA floating about which isrelated to this as well.hthconnor --- "Koivu, Lisa" [EMAIL PROTECTED] wrote: Can this be true? How can this be? If it'soptimized to manipulate datawithin the database, how can it be fast if it'sinterpreted (like that slowpoke, Java)? I see this on Connor's website www.oracledba.co.ukunder explicit/implicitcursors, under pl/sql. What on earth? Can someone elaborate, namely, Connor?? Please helpme understand this...My "green" may be showing, but my gosh. Lisa KoivuOracle Database Baby OvenFairfield Resorts, Inc.5259 Coconut Creek ParkwayFt. Lauderdale, FL, USA 33063-- Please see the official ORACLE-L FAQ:http://www.orafaq.com-- Author: Koivu, Lisa INET: [EMAIL PROTECTED]Fat City Network Service s-- (858) 538-5051 FAX:(858) 538-5051San Diego, California-- Public Internetaccess / Mailing Lists To REMOVE yourself from this mailing list, send anE-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of'ListGuru') and inthe message BODY, include a line containing: UNSUBORACLE-L(or the name of mailing list you want to be removedfrom). You mayalso send the HELP command for other information(like subscribing). =Connor McDonaldhttp://www.oracledba.co.ukhttp://www.oaktable.net"Some days you're the pigeon, some days you're the statue"__Do You Yahoo!?Everything you'll ever need on one web pagefrom News and Sport to Email and Music Chartshttp://uk.my.yahoo.com
Iraje.
Hi All, I was wondering if any of you out there are using the tools that are provided by Iraje (i.e the Active tools)? If so, what are you thoughts, and comments on these tools (good or bad)? Thanks Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle wants your job
Me thinks this is related to all the other hot topics out there... Centralize the computers, then another CIO comes in, decentralize all the computers...every division gets there own...a genius. IT is outsourced, problems, slow response, a new CIO comes in, let's bring everything in house under our control...a genius. One big computer that runs everything, now the apps are being spread out among a bunch of computers... Meanwhile, all the peons get kicked around, while dgmt gets bonuses and perks...for being a genius. History repeats itself... -Original Message- Sent: Tuesday, April 30, 2002 11:09 AM To: Multiple recipients of list ORACLE-L RANT This has all been tried before, and the predictions are the same: financial nirvana, big savings in technology costs, no pesky holier-than-thou DBA's baffling poor damagers with stuff they can't possibly understand. /RANT Very few executive, managers or DBA's are going to want to place their corporate data on Oracle's site, or even provide access to it from outside for non-employees. There's also the whipping boy factor. Who's butt you going to kick when the database is screwed up? ;) Heard a good quote on a documentary the other night: A corporation has no soul to save nor an ass to kick. Someone local must be accountable for the data. The whole outsourcing thing is kind of baffling to me at times. Why not carry it out its fullest measure? Outsource mfg, sales, IT, design and executives. No need for any employees. Guess I turned of the rant too soon. Jared On Tuesday 30 April 2002 06:44, Farnsworth, Dave wrote: http://www.infoworld.com/articles/se/xml/02/04/29/020429seoracle.xml Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL Loader has generated errors and will be closed by windows
Im running sql loader with the following parameters sqlldr userid=user/password@instance control=C:\filename.ctl Run this from a command window and in about 10 seconds a window pops up to the effect SQL Loader has generated errors and will be closed by windows and error log is being created The problem is the log file is empty! How can I debug my control file? fwiw Im using a script that creates a ctl file (I havent used it an a year or so... a little rusty) see in line apparetly sql loader needs to have columns which have a - totally enclosed in here is a sample of my ctl file ## LOAD DATA INFILE 'src.txt' BADFILE 'C:\bad.txt' INTO TABLE SRCTABLE FIELDS TERMINATED BY ' ' TRAILING NULLCOLS ( V-FLAG CHAR NULLIF(V-FLAG=BLANKS) , NAMEID CHAR NULLIF(NAMEID=BLANKS) , PRIMARY-ID CHAR NULLIF(PRIMARY-ID=BLANKS) , SEQ-NO CHAR NULLIF(SEQ-NO=BLANKS) , LAST-NAMECHAR NULLIF(LAST-NAME=BLANKS) , FIRST-NAME CHAR NULLIF(FIRST-NAME=BLANKS) , MIDDLE-INITIAL CHAR NULLIF(MIDDLE-INITIAL=BLANKS) ## thanks bob # REM control.sql script SET ECHO off REMREQUIREMENTS REMSELECT privileges on the table REM -- REM PURPOSE: REMPrepares a SQL*Loader control file for a table already existing in the REMdatabase. The script accepts the table name and automatically creates REMa file with the table name and extension 'ctl'. REMThis is especially useful if you have the DDL statement to create a REMparticular table and have a free-format ASCII-delimited file but have REMnot yet created a SQL*Loader control file for the loading operation. REM REMDefault choices for the file are as follows (alter to your needs): REM Delimiter: comma (',') REM INFILE file extension: .dat REM DATE format:'MM/DD/YY' REM REMYou may define the Loader Data Types of the other Data Types by REMrevising the decode function pertaining to them. REM REM --- REM EXAMPLE: REMSQL start control.sql emp REM REMLOAD DATA REMINFILE 'EMP.dat' REMINTO TABLE EMP REMFIELDS TERMINATED BY ',' REM( REM REM EMPNO REM , ENAME REM , JOB REM , MGR REM , HIREDATE DATE MM/DD/YY REM , SAL REM , COMM REM , DEPTNO REM REM) REM REM --- REM DISCLAIMER: REMThis script is provided for educational purposes only. It is NOT REMsupported by Oracle World Wide Technical Support. REMThe script has been tested and appears to work as intended. REMYou should always run new scripts on a test instance initially. REM -- REM Main text of script follows: set heading off set verify off set feedback off set show off set trim off set pages 0 set concat on spool 1..ctl SELECT 'LOAD DATA'||chr(10) ||'INFILE '''||lower(table_name)||'.dat'' '||chr(10) ||'INTO TABLE '||table_name||chr(10) ||'FIELDS TERMINATED BY '','' '||chr(10) ||'TRAILING NULLCOLS'||chr(10) ||'(' FROM user_tables WHERE TABLE_NAME = UPPER('1'); SELECT decode(rownum,1,' ',' , ')||rpad(column_name,33,' ') || decode(data_type, 'VARCHAR2','CHAR NULLIF('|| column_name ||'=BLANKS)', 'FLOAT', 'DECIMAL EXTERNAL NULLIF('||column_name||'=BLANKS)', 'NUMBER', decode(data_precision, 0, 'INTEGER EXTERNAL NULLIF ('||column_name ||'=BLANKS)', decode(data_scale,0, 'INTEGER EXTERNAL NULLIF ('||column_name ||'=BLANKS)', 'DECIMAL EXTERNAL NULLIF ('||column_name ||'=BLANKS)' ) ), 'DATE','DATE MM/DD/YY NULLIF ('||column_name ||'=BLANKS)',NULL) FROM user_tab_columns WHERE TABLE_NAME = UPPER('1') ORDER BY COLUMN_ID; SELECT ')'
Re: Root Cause Analysis White Papers
-- Peter Barnett [EMAIL PROTECTED] We have been having some heavy discussions about system failures, root cause analysis and developing some proactive metrics. Generally, our problems revolve around frequently late nights for the On Call DBA because something out of our control goes wrong. The damagement folks want to fix the immediate problem and consider the job done. The DBAs are asking for an approach that will allow us to identify potential problems before something breaks at 3:00 a.m. Does anyone know of a source of white papers or other data that has been generated for systems, storage or databases? We can always roll out own, but why recreate someone else's work. See the Usenix doc's on Auditing, sys-admin skills for examples. LISA papers also have covered audit procedures. What you are really asking for is a system audit. The results from a full audit would be a good place to start looking at what is done on the systems, what goes wrong with them and where to look further for root causes. Audit results also give you the facts you'll need in convincing the manglement that something really is wrong and it needs fixing. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: FILE IDENTIFY wait event
Make sure that the volume group underlying the logical volume is ONLINE? To test, I like to do something quick like "dd if=raw-device of=/dev/null count=100" to test the readability of the raw device. If this fails, you can go to the SysAdmin with something that is pure UNIX... - Original Message - From: Daniel W. Fink To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 30, 2002 10:41 AM Subject: FILE IDENTIFY wait event Oracle8.1.7 on Solaris8 I am trying to create a tablespace on a raw device and the SQL*Plus session that performs the tablespace creation is waiting on a 'file identify'. A quick search on metalink and other docs did not indicate the root cause of the wait event. I have used the raw device previously and the create tablespace uses the 'REUSE' option. Okay gurus...any clues as to exactly what conditions cause the event? Dan Fink
RE: pl/sql is INTERPRETED?
IMHO, I don't believe that you can properly learn PL/SQL in a very short period of time, or for that matter, any other language. I attended Steve Feuerstein's presentation at MAOP-AOTC conference, and he tore into many real-life examples of PL/SQL. Supposedly, these were written by developers that knew what they were doing. Granted, if a smart developer sits down and reads Feuerstein's Learning PL/SQL and Best Practices books, then perhaps they will be good. But who the hell has free time? There is no free time on any project or effort that I know of!! I'm struggling with trying to improve my Oracle DBA skills, plus some developers skills so I can speak their language when they blow out OPEN_CURSORS or something. My head is swimming in the stupid technical alphabet soup, XML, XDK, XSQL, XSLT, XPath, SOAP, ASP, ADO, EJB, BC4J, JDBC, SQLJ, PSP, JVM, JSP, J2EE, EAD, RMI, CORBA, IIOP...and don't ask me what all those mean, because I can't keep them straight. But I do keep hearing that XML is going to put me out of a job, so I guess I should learn that...whatever that is. Isn't XML an add-on, or extension, or something to DML??? Now where the heck did I hide that bottle... -Original Message- Sent: Tuesday, April 30, 2002 12:15 PM To: Multiple recipients of list ORACLE-L Lisa, You are right about the debate between PL/SQL Java (or anything else outside of the db). In my mind, the deciding factor (and something that is *never* mentioned) is what programming langauage the organization is satisfied with/settled upon. In my little opinion, *any* programmer can learn PL/SQL in a very short period of time. This means that development and maintenance costs are relatively low. If an IT shop is stronger in Java, then they should probably program in Java, or Cobol, or Ada, or whatever the flavor of the decade happens to be (lets bring back APL!). IT tool selection/standards should be the deciding factor. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, April 30, 2002 11:34 AM To: Multiple recipients of list ORACLE-L This is something that's been debated on the list in the past. The general consensus was: For manipulating data in the database, nothing beats pl/sql. It is well suited for this purpose. For everything else, java could beat it. I am sure fellow list members will post links describing studies. I remember seeing these last year. Stefan, have you tried running your own test? There's a sure fire way to convince yourself. Even a small test (no fancy code) would suffice. Wish I had more time to play... Lisa Koivu Oracle Database Monkey Mama Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Stefan Jahnke [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Subject: AW: pl/sql is INTERPRETED? Hi how about Java within Oracle. What do you think about it ? When does it make sense to use Java instead of PL/SQL ? The problem is that I dislike a mix of different languages within an application. It messes things up. But maybe it makes sense to use PL/SQL for most stuff and Java for some specific things (perhaps accessing a file or using a network resource ?). As far as I know, there is an option to compile the Java into platform dependend code, which would make it execute much faster then bytecode (and PL/SQL?), since the later has to be interpreted at run-time. Any opinions ? Regards, -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 30. April 2002 16:09 An: Multiple recipients of list ORACLE-L Betreff: Re:pl/sql is INTERPRETED? Lisa, It is both true false at the same time. Obviously any anonymous blocks you submit to the database are fully interpreted. PL/SQL that you store in the database as procedures, functions, and packages get partially compiled into a p-code. This makes the code ready for execution, but retains a modular design so that if your DBA reloads catproc your code is not totally destroyed. Where I think PL/SQL buys us a lot of performance is in reducing the communications outside of the database that is otherwise needed. There's no JDBC driver or other miscellaneous mess (like SQL*Net) required. It's all handled inside the kernel. Now the bad part about PL/SQL that Java handles better is platform independence. You can run Java on your client, the apps server or database without a problem. PL/SQL on the other hand must be run in the database. Dick Goulet Reply Separator Author: Koivu; Lisa [EMAIL PROTECTED] Date: 4/29/2002 2:52 PM Can this be true? How can this be? If it's optimized to manipulate data within the database, how can it be fast if it's interpreted (like that slow poke, Java)? I see
bad execution plan
AIX, oracle 8.1.7.2, all 3 tables compute statistics, first_rows optimizer_mode a simple 3 table join, joined on the appropriate columns, works fine. add a fixed constant to the mix and poof, 2 merge-join cartesian. Here is first query w/o the fixed value: select T1.EVENT# c1, count(distinct T1.CONCO#) c2, T2.EVDESC c3, T3.CATTYP c4 , count(distinct T3.CATCO#) c5from STAGING.BECONS T1, STAGING.EVMAST T2, STAGING.BECATD T3where T1.EVENT# = T2.EVMBRN and T1.EVENT# = T3.EVENT#group by T1.EVENT#, T2.EVDESC, T3.CATTYPorder by 1 asc, 3 asc, 4 asc; Plan: | SELECT STATEMENT || SORT GROUP BY || HASH JOIN || HASH JOIN || TABLE ACCESS FULL |EVMAST| TABLE ACCESS FULL |BECONS| TABLE ACCESS FULL |BECATD Now add one line with a hardcoded value and it appears that oracle is totally ignoring the rest of the where clause(proven later): select T1.EVENT# c1, count(distinct T1.CONCO#) c2, T2.EVDESC c3, T3.CATTYP c4 , count(distinct T3.CATCO#) c5from STAGING.BECONS T1, STAGING.EVMAST T2, STAGING.BECATD T3where T1.EVENT# = T2.EVMBRN and T1.EVENT# = T3.EVENT#and T1.EVENT#='EV000154'group by T1.EVENT#, T2.EVDESC, T3.CATTYPorder by 1 asc, 3 asc, 4 asc; plan: | SELECT STATEMENT || SORT GROUP BY || MERGE JOIN CARTESIAN || MERGE JOIN CARTESIAN || TABLE ACCESS FULL |EVMAST| SORT JOIN || TABLE ACCESS BY INDEX ROWID |BECONS| INDEX RANGE SCAN |IDX01_BECONS| SORT JOIN || TABLE ACCESS BY INDEX ROWID |BECATD| INDEX RANGE SCAN |INDX01_BECATD Now proven here is if i leave out the joins altogether, i get the close the the same execution plan as above : select T1.EVENT# c1, count(distinct T1.CONCO#) c2, T2.EVDESC c3, T3.CATTYP c4 , count(distinct T3.CATCO#) c5from STAGING.BECONS T1, STAGING.EVMAST T2, STAGING.BECATD T3whereT1.EVENT#='EV000154'group by T1.EVENT#, T2.EVDESC, T3.CATTYPorder by 1 asc, 3 asc, 4 asc; Plan: | SELECT STATEMENT || SORT GROUP BY || MERGE JOIN CARTESIAN || MERGE JOIN CARTESIAN || TABLE ACCESS BY INDEX ROWID |BECONS| INDEX RANGE SCAN |IDX01_BECONS| SORT JOIN || TABLE ACCESS FULL |EVMAST| SORT JOIN || TABLE ACCESS FULL |BECATD I'm looking for any ideas what the heck the CBO is doing or is this some bug of some sorts? thanks, joe
RE: Oracle Windows
For NT tuning check out www.arstechnica.com, they have an NT tuning guide buried on their site. 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- Sent: Tuesday, April 30, 2002 1:41 PM To: Multiple recipients of list ORACLE-L Thanks for the links. We are now in the process of tuning a database, on NT, without any option to change the application code (3rd party). I downloaded the docs and hope they will help me. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, April 29, 2002 11:53 PM This message bounced back to me as undeliverable. Just in case it got through, the 3rd link was bad and I have replaced it with the correct URL. I had copies still on my hard drive so I uploaded them. I emphasize that these are not my work but the work of the authors whose names appear on the papers. I had three papers that pertain to Oracle and NT. They are at: This is about Oracle 9 on NT/2000 http://www.msnusers.com/torac/Documents/SQL-Ora/Maximizing%20Productivity%20 .doc This is about Oracle 8 on NT http://www.msnusers.com/torac/Documents/SQL%2DOra/Oracle8%20on%20NT%2Edoc This is a pdf about configuration standards for Oracle on NT http://www.msnusers.com/torac/Documents/SQL%2DOra%2FORACLE%5FNT%5FCONFIG.pdf If you don't have hotmail userids I have also uploaded them to http://www.geocities.com/tomdaytwo/MaximizingProductivity.htm http://www.geocities.com/tomdaytwo/Oracle8onNT.htm http://www.geocities.com/tomdaytwo/ORACLE_NT_CONFIG.pdf You should be able to find them at one place or the other. HTH -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ANTI-VIRUS SPAM - YOUR EMAIL ADMIN IS A DIKHEAD
Sigh. I wish I understood half the words used in this exchange. Or maybe not. But I still think Tim is a cool guy and I'm looking forward to drinking beer with him next time we meet. The first time I met with Tim was in Denver where he tricked me into eating something he called Rocky Mountain Oysters. If he ever makes it to Denmark I'll trick him into eating our world-famous blood sausage. Actually I'd like to drink beer with all you guys next time we meet. Maybe it's time for an Oracle-L Conference... Mogens Eric D. Pierce wrote: You silly!I was talking about the email admin at the guy's company, not fatcity.It has subsequently been explained to me that damagement is at fault (surprise) and ought to be blamed for all evil, not the email admin.http://www.dogdoo.comRoss can explain how brown fits into the metaphysical context of your astral plane.ORACLE-L Digest -- Volume 2002, Number 118 -- From: "Tim Gorman" [EMAIL PROTECTED] Date: Sat, 27 Apr 2002 10:34:46 -0600 Subject: Re: ANTI-VIRUS SPAM - YOUR EMAIL ADMIN IS A DIKHEAD / (Fwd) Antigen found =*.*.txt fileEric,A 5th-grade teacher once admonished me on cursing bypointing out that the English language has 100,000 words infrequent usage and how unimaginative it was to constrainmyself to the same dozen or so words to describe myfeelings...Bruce, the guy who runs FATCITY as a sideline business(because this business doesn't generate enough money tosupport the typical family), restricts all attachments notonly out of concern for viruses, but for the more practicalreason of limiting message size and therefore storage andnetwork capacity. It's a good policy -- if you'd like tosend attachments, please address people directly..and please grow up.-Tim I don't know if this guy (Evans, David) is subscribed tothis list, but if so, please tell your email admin thatthis stuff sucks. A text file attachment is not automatically equivalent toa virus attachment.If their system wasn't set up by such dikheads, they wouldknow that they can implement packet scanning at the emailgateway in a non-intrusive manner that is far moreeffective than this spam cr*pola. http://www.antivirus.com/products/isvw/regards,ep