Running sql script from stored procedure
Dear DBA Gurus, I have a .sql file which contains a series of insert statements. I want to call this .sql file and run it from a stored procedure. Is it possible? If so, how? Please post your answers to me directly as I am not receiving messages directly from the list rather I am able to send messages to the list. Thanks and Regards, Ranganath DISCLAIMER: This correspondence is confidential and intended for the named recipient(s) only. If you are not the named recipient and receive this correspondence in error, you must not copy, distribute or take any action in reliance on it and you should delete it from your system and notify the sender immediately. Unless otherwise stated, any views or opinions expressed are solely those of the author and do not represent those of Subex Systems Limited. www.subexgroup.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K 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 C compiler a must for oracle UNIX installations ?
but doesnt make utility uses C compiler ? (or it's a bare bones installation of a C compiler?) i guess i;m wrong on this one... -- From: Rao, UmaSankara S (CAP)[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Thursday, August 16, 2001 1:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: is C compiler a must for oracle UNIX installations ? Oracle installation document says the make utility must be present for relinking the oracle S/W once it is installed.(Incase of SUN it is at the location /usr/ccs/bin.).I Installed oracle 8 and 8i on sun machine without installing C compiler.Could be same as the case with AIX i guess. -Original Message- Sent: Thursday, August 16, 2001 12:35 AM To: Multiple recipients of list ORACLE-L some of my friends are telling me that they have succesfuly installed oracle 7.3.1 on AIX 4 WITHOUT the C compiler present.. !! and i was the one telling them how oralce requires to relink the executables after the installation. Regards -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, UmaSankara S (CAP) 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: An SQL question , not easy ;-)
No - if you draw a diagram showing the 4 calls given in the original test data, you can see clearly that at no time are there more than 3 calls in progress simultaneously. Unless you're using some strange definition of the word simultaneous of which I'd previously been unaware... Paul Vincent Database Administrator, University of Central England -Original Message- From: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Sent: 15 August 2001 16:11 To: Multiple recipients of list ORACLE-L Subject: RE: An SQL question , not easy ;-) Is this not flawed in that given these results: eventtimeevent - 01-AUG-2001 12:10:00 start add 1- 1 01-AUG-2001 12:15:00 start add 1- 2 01-AUG-2001 12:25:00 start add 1- total 3 01-AUG-2001 12:30:00 end subtract 1 - 2 01-AUG-2001 12:40:00 end subtract 1 - 1 01-AUG-2001 12:45:00 start add 1- 2 01-AUG-2001 12:47:00 end subtract 1 - 1 01-AUG-2001 12:55:00 end subtract 1 - 0 The highest total is 3 this is incorrect by 1. There have been a total of 4 simultaneous calls 3 of which were simultaneous and 1 which ran simultaneously with the one of the three calls! IMHO Kev. still working on a solutionhere's what I have so far...lot's of dbms outputs so it may look very confusing. Based on the data that Andrey first provided. based on the table; create table phone ( call_start date ,call_end date ) / -Original Message- Sent: 15 August 2001 15:22 To: Multiple recipients of list ORACLE-L Note that whenever a call starts, this increases the current number of calls by 1, and whenever a call ends, this decreases the current number of calls by 1. Hence you can uncouple the start and end times - you don't need to know that a given start time and a given end time belong to the same call! (Think about it - it's a bit counterintuitive, but it's true!). So: SELECT CALL_START_DATE eventtime, 'start' eventtype FROM calltable UNION ALL SELECT CALL_END_DATE eventtime, 'end' eventtype FROM calltable ORDER BY 1 Then you set a current number of calls variable to zero, and move the cursor through the results, adding 1 to the variable for each 'start' and subtracting 1 for each 'end'. Whenever you add 1, if the current number of calls is higher than its highest value so far, store the new highest value so far. When you've finished, this latter variable will contain the maximum number of simultaneous conversations. Hope this helps. Paul Paul Vincent Database Administrator, University of Central England -Original Message- From: Andrey Bronfin [mailto:[EMAIL PROTECTED]] Sent: 15 August 2001 11:21 To: Multiple recipients of list ORACLE-L Subject: An SQL question , not easy ;-) Dear gurus ! I have a table of phone calls , 2 fields : CALL_START DATE , CALL_END DATE . I need an SQL statement or a PL/SQL block to calculate the maximum number of SIMULTANIOUS phone conversations. Please help !!! Thanks a lot in advance ! Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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: Paul Vincent 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: Paul Vincent INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet
Q about Oracle Optimizer
Hi list, a quick question about oracle optimizer. a customer has database migrated from 7.3.4 to 8.1.6 on AIX. Data was transfered via full exp/imp. After migration the performance of the new database is very poor. I looked at the parameters and saw that no object is analyzed. So now me question: What does oracle optimizer do, if there are no statistics on all objects. Optimizer level is choose. Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker 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: An SQL question , not easy ;-)
I agree with you on that one, but what I was saying, (and I posted this in an earlier message) was that I interpreted the intial email wrongly. I was looking at: - over all the time periods how many simultaneous calls were there (not at any particular moment in time) therefore I was getting the answer, ok, there are 3 calls simultaneously 12:10, 12:15 and 12:25 but then there is also a simultaneous call going on between 12:25 and 12:45 (because the 12:25 call didn't end until 12:55), so I'm not totally mad! What I didn't pick up from the original email was that Andrey was purely looking for the MAX number of simultaneous calls which as you rightly point out was 3...! Damn this lag!! Kev. -Original Message- Sent: 16 August 2001 08:55 To: Multiple recipients of list ORACLE-L No - if you draw a diagram showing the 4 calls given in the original test data, you can see clearly that at no time are there more than 3 calls in progress simultaneously. Unless you're using some strange definition of the word simultaneous of which I'd previously been unaware... Paul Vincent Database Administrator, University of Central England -Original Message- From: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Sent: 15 August 2001 16:11 To: Multiple recipients of list ORACLE-L Subject: RE: An SQL question , not easy ;-) Is this not flawed in that given these results: eventtimeevent - 01-AUG-2001 12:10:00 start add 1- 1 01-AUG-2001 12:15:00 start add 1- 2 01-AUG-2001 12:25:00 start add 1- total 3 01-AUG-2001 12:30:00 end subtract 1 - 2 01-AUG-2001 12:40:00 end subtract 1 - 1 01-AUG-2001 12:45:00 start add 1- 2 01-AUG-2001 12:47:00 end subtract 1 - 1 01-AUG-2001 12:55:00 end subtract 1 - 0 The highest total is 3 this is incorrect by 1. There have been a total of 4 simultaneous calls 3 of which were simultaneous and 1 which ran simultaneously with the one of the three calls! IMHO Kev. still working on a solutionhere's what I have so far...lot's of dbms outputs so it may look very confusing. Based on the data that Andrey first provided. based on the table; create table phone ( call_start date ,call_end date ) / -Original Message- Sent: 15 August 2001 15:22 To: Multiple recipients of list ORACLE-L Note that whenever a call starts, this increases the current number of calls by 1, and whenever a call ends, this decreases the current number of calls by 1. Hence you can uncouple the start and end times - you don't need to know that a given start time and a given end time belong to the same call! (Think about it - it's a bit counterintuitive, but it's true!). So: SELECT CALL_START_DATE eventtime, 'start' eventtype FROM calltable UNION ALL SELECT CALL_END_DATE eventtime, 'end' eventtype FROM calltable ORDER BY 1 Then you set a current number of calls variable to zero, and move the cursor through the results, adding 1 to the variable for each 'start' and subtracting 1 for each 'end'. Whenever you add 1, if the current number of calls is higher than its highest value so far, store the new highest value so far. When you've finished, this latter variable will contain the maximum number of simultaneous conversations. Hope this helps. Paul Paul Vincent Database Administrator, University of Central England -Original Message- From: Andrey Bronfin [mailto:[EMAIL PROTECTED]] Sent: 15 August 2001 11:21 To: Multiple recipients of list ORACLE-L Subject: An SQL question , not easy ;-) Dear gurus ! I have a table of phone calls , 2 fields : CALL_START DATE , CALL_END DATE . I need an SQL statement or a PL/SQL block to calculate the maximum number of SIMULTANIOUS phone conversations. Please help !!! Thanks a lot in advance ! Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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: Paul Vincent INET:
RE: An SQL question , not easy ;-)
Sorry to resurrect this thread and pick holes, but I was thinking about this query on the way home last night (sad, I know) and came across a problem with it. It works fine with the example we have been using, but only because none of the calls has more than one *non-overlapping* call start during it. If I understand the query correctly, it's selecting the number of calls started, including itself, during each call. But, say you have two telephones. One person makes one long call on the first. Meanwhile, someone else makes three short calls on the other. The query would show four call starts during the first call (itself plus the three on the other phone), but only two are ever in progress at any one time. Nice problem David Lord -Original Message- From: Greg Solomon [mailto:[EMAIL PROTECTED]] Sent: 15 August 2001 16:46 To: Multiple recipients of list ORACLE-L Subject: RE: An SQL question , not easy ;-) Or use a self-join select a.call_start, count(b.call_start) interruptions from phone_call a, phone_call b where a.call_start = b.call_start and a.call_end b.call_start group by a.call_start -Original Message- Sent: 15 August 2001 16:02 To: Multiple recipients of list ORACLE-L Yes, so the maximum is 3, between 12:25 and 12:30. To explicitly show the maximum (and a little histogram) you could amend it as follows: - declare l_count pls_integer := 0; l_max_count pls_integer := 0; begin for rec in ( select call_start time, 1 incr from table union all select call_end time, -1 incr from table order by 1 ) loop l_count := l_count + rec.incr; if( l_count l_max_count ) then l_max_count := l_count; end if; dbms_output.put_line( to_char(rec.time) || ' - ' || l_count || ' ' || lpad('*',l_count) ) end loop; dbms_output.put_line( 'Maximum concurrent calls = ' || to_char(l_max_count) ); end; Regards David Lord -Original Message- From: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Sent: 15 August 2001 15:07 To: Multiple recipients of list ORACLE-L Subject: RE: An SQL question , not easy ;-) David, Here's the output from your suggestion based on a table with the following rows; CALL_STARTCALL_END - - 01-AUG-2001 12:10 01-AUG-2001 12:40 01-AUG-2001 12:15 01-AUG-2001 12:30 01-AUG-2001 12:25 01-AUG-2001 12:55 01-AUG-2001 12:45 01-AUG-2001 12:47 - 01-AUG-2001 12:10 - 1 01-AUG-2001 12:15 - 2 01-AUG-2001 12:25 - 3 01-AUG-2001 12:30 - 2 01-AUG-2001 12:40 - 1 01-AUG-2001 12:45 - 2 01-AUG-2001 12:47 - 1 01-AUG-2001 12:55 - 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CS 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: Greg Solomon 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: Lord, David - CS 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: An SQL question , not easy ;-)
Damn this lag!! I see Andrey has already posted a note saying thanks and yet my emails are just filtering through to the list now...my apologies for taking up the bandwidth!!! Kev (off to prime the Carrier Pidgeon which seems quicker than email!) -Original Message- Sent: 15 August 2001 16:31 To: Multiple recipients of list ORACLE-L My apologies David, I was reading Andreys initial email as give me the number of concurrent calls being made of which there are 4. Kev (eating humble pie by the spadeful!) ;-) -Original Message- Sent: 15 August 2001 16:02 To: Multiple recipients of list ORACLE-L Yes, so the maximum is 3, between 12:25 and 12:30. To explicitly show the maximum (and a little histogram) you could amend it as follows: - declare l_count pls_integer := 0; l_max_count pls_integer := 0; begin for rec in ( select call_start time, 1 incr from table union all select call_end time, -1 incr from table order by 1 ) loop l_count := l_count + rec.incr; if( l_count l_max_count ) then l_max_count := l_count; end if; dbms_output.put_line( to_char(rec.time) || ' - ' || l_count || ' ' || lpad('*',l_count) ) end loop; dbms_output.put_line( 'Maximum concurrent calls = ' || to_char(l_max_count) ); end; Regards David Lord -Original Message- From: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Sent: 15 August 2001 15:07 To: Multiple recipients of list ORACLE-L Subject: RE: An SQL question , not easy ;-) David, Here's the output from your suggestion based on a table with the following rows; CALL_STARTCALL_END - - 01-AUG-2001 12:10 01-AUG-2001 12:40 01-AUG-2001 12:15 01-AUG-2001 12:30 01-AUG-2001 12:25 01-AUG-2001 12:55 01-AUG-2001 12:45 01-AUG-2001 12:47 - 01-AUG-2001 12:10 - 1 01-AUG-2001 12:15 - 2 01-AUG-2001 12:25 - 3 01-AUG-2001 12:30 - 2 01-AUG-2001 12:40 - 1 01-AUG-2001 12:45 - 2 01-AUG-2001 12:47 - 1 01-AUG-2001 12:55 - 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CS 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). -- 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: An SQL question , not easy ;-)
Yes, and this morning my manager just asked me for something similar too. How fortunate :0) g -Original Message- Sent: Wednesday, August 15, 2001 7:26 PM To: Multiple recipients of list ORACLE-L Hi All: There's one really neat thing about this thread...it's helped me solve an on-going problem. I've got managers who want to see graphs of their system's usage. Using this mechanism applied against the DBA_AUDIT_TRAIL view works perfectly. Thanks! Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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: Slow sql
Hi Roland, look at the execution plan of your subselect. Start sqlplus then set autotrace on; SELECT PBK.VARUKORGEANREL.varukorgid, rik2.vare.ean_nr, 'rsm' , PBK.VARUKORGEANREL.lagstapris, 0, rik2.vare.varenavn, rik2.vare.str, rik2.lev.navn, rik2.vare.hylletxt2, rik2.vare.sortiment,rik2.art_hierarki.vgrp, pbk.varukorgeanrel.vare_snr,pbk.varukorgeanrel.varenr,pbk.varukorgeanrel.lev nr FROM PBK.VARUKORGEANREL,rik2.vare,rik2.lev,rik2.art_hierarki WHERE PBK.VARUKORGEANREL.varukorgid= 39 AND PBK.VARUKORGEANREL.ean=rik2.vare.ean_nr AND RIK2.VARE.ARTNR=RIK2.ART_HIERARKI.ARTNR AND rik2.vare.levnr=rik2.lev.levnr AND rik2.vare.selskap='11' AND rik2.vare.vare_snr=pbk.varukorgeanrel.vare_snr AND pbk.varukorgeanrel.varenr=rik2.vare.varenr AND pbk.varukorgeanrel.levnr=rik2.vare.levnr AND rik2.art_hierarki.sett_id=2; Look at the results. If there are FULL table scans on large tables you have to create indexes. If you use Optimizer CHOOSE, look if the tables and indexes are analyzed. Hope this will help. Regards Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 16. August 2001 11:46 An: Multiple recipients of list ORACLE-L Betreff: Slow sql Hallo you DBA'¨s Can anyonetell me why this insert statement takes 30-40 minutes to run? What can I do to make it go faster? insert into varukorgtemp ( varukorgid, ean, anvandarid, lagstapris, varutyp, varunamn, strl, leverantor, varumarke, sortiment,vgrp,vare_snr,varenr,levnr ) SELECT PBK.VARUKORGEANREL.varukorgid, rik2.vare.ean_nr, 'rsm' , PBK.VARUKORGEANREL.lagstapris, 0, rik2.vare.varenavn, rik2.vare.str, rik2.lev.navn, rik2.vare.hylletxt2, rik2.vare.sortiment,rik2.art_hierarki.vgrp, pbk.varukorgeanrel.vare_snr,pbk.varukorgeanrel.varenr,pbk.varukorgeanrel.lev nr FROM PBK.VARUKORGEANREL,rik2.vare,rik2.lev,rik2.art_hierarki WHERE PBK.VARUKORGEANREL.varukorgid= 39 AND PBK.VARUKORGEANREL.ean=rik2.vare.ean_nr AND RIK2.VARE.ARTNR=RIK2.ART_HIERARKI.ARTNR AND rik2.vare.levnr=rik2.lev.levnr AND rik2.vare.selskap='11' AND rik2.vare.vare_snr=pbk.varukorgeanrel.vare_snr AND pbk.varukorgeanrel.varenr=rik2.vare.varenr AND pbk.varukorgeanrel.levnr=rik2.vare.levnr AND rik2.art_hierarki.sett_id=2 Sincerely Roland Sköldblom -- 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: Schoen Volker 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 sql
Hi Roland, I would suggest that it pretty much depends on the number of rows that are being returned from your select statement as well as the way the select statement has been put together. Try cutting the select statement from the insert and running it against an explain plan to determine whether the select is optimised fully. Check to see whether the select statement is making use of available indices (if there are any) and consider trying various hint options to try and squeeze some more speed out of it. Regards, Kev. -Original Message- Sent: 16 August 2001 10:46 To: Multiple recipients of list ORACLE-L Hallo you DBA'¨s Can anyonetell me why this insert statement takes 30-40 minutes to run? What can I do to make it go faster? insert into varukorgtemp ( varukorgid, ean, anvandarid, lagstapris, varutyp, varunamn, strl, leverantor, varumarke, sortiment,vgrp,vare_snr,varenr,levnr ) SELECT PBK.VARUKORGEANREL.varukorgid, rik2.vare.ean_nr, 'rsm' , PBK.VARUKORGEANREL.lagstapris, 0, rik2.vare.varenavn, rik2.vare.str, rik2.lev.navn, rik2.vare.hylletxt2, rik2.vare.sortiment,rik2.art_hierarki.vgrp, pbk.varukorgeanrel.vare_snr,pbk.varukorgeanrel.varenr,pbk.varukorgeanrel.lev nr FROM PBK.VARUKORGEANREL,rik2.vare,rik2.lev,rik2.art_hierarki WHERE PBK.VARUKORGEANREL.varukorgid= 39 AND PBK.VARUKORGEANREL.ean=rik2.vare.ean_nr AND RIK2.VARE.ARTNR=RIK2.ART_HIERARKI.ARTNR AND rik2.vare.levnr=rik2.lev.levnr AND rik2.vare.selskap='11' AND rik2.vare.vare_snr=pbk.varukorgeanrel.vare_snr AND pbk.varukorgeanrel.varenr=rik2.vare.varenr AND pbk.varukorgeanrel.levnr=rik2.vare.levnr AND rik2.art_hierarki.sett_id=2 Sincerely Roland Sköldblom -- 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: 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: An SQL question , not easy ;-)
Hi David ! It's perfectly fine : four calls started during the period of the first call , but the maximum of 2 were carried out simultaneously . Your PL/SQL block addresses this , since U subtract 1 from the current number of concurrent calls each time the second person hangs up. So , the l_max_count is never more than 2. Anyway , your query perfectly suited my needs. (My actual problem was slightly more complicated then the one i posted , but U gave me a bright idea on how to deal with it). Thanks a lot to all the oracle DBAs brotherhood. -Original Message- Sent: Thursday, August 16, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Sorry to resurrect this thread and pick holes, but I was thinking about this query on the way home last night (sad, I know) and came across a problem with it. It works fine with the example we have been using, but only because none of the calls has more than one *non-overlapping* call start during it. If I understand the query correctly, it's selecting the number of calls started, including itself, during each call. But, say you have two telephones. One person makes one long call on the first. Meanwhile, someone else makes three short calls on the other. The query would show four call starts during the first call (itself plus the three on the other phone), but only two are ever in progress at any one time. Nice problem David Lord -Original Message- From: Greg Solomon [mailto:[EMAIL PROTECTED]] Sent: 15 August 2001 16:46 To: Multiple recipients of list ORACLE-L Subject: RE: An SQL question , not easy ;-) Or use a self-join select a.call_start, count(b.call_start) interruptions from phone_call a, phone_call b where a.call_start = b.call_start and a.call_end b.call_start group by a.call_start -Original Message- Sent: 15 August 2001 16:02 To: Multiple recipients of list ORACLE-L Yes, so the maximum is 3, between 12:25 and 12:30. To explicitly show the maximum (and a little histogram) you could amend it as follows: - declare l_count pls_integer := 0; l_max_count pls_integer := 0; begin for rec in ( select call_start time, 1 incr from table union all select call_end time, -1 incr from table order by 1 ) loop l_count := l_count + rec.incr; if( l_count l_max_count ) then l_max_count := l_count; end if; dbms_output.put_line( to_char(rec.time) || ' - ' || l_count || ' ' || lpad('*',l_count) ) end loop; dbms_output.put_line( 'Maximum concurrent calls = ' || to_char(l_max_count) ); end; Regards David Lord -Original Message- From: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Sent: 15 August 2001 15:07 To: Multiple recipients of list ORACLE-L Subject: RE: An SQL question , not easy ;-) David, Here's the output from your suggestion based on a table with the following rows; CALL_STARTCALL_END - - 01-AUG-2001 12:10 01-AUG-2001 12:40 01-AUG-2001 12:15 01-AUG-2001 12:30 01-AUG-2001 12:25 01-AUG-2001 12:55 01-AUG-2001 12:45 01-AUG-2001 12:47 - 01-AUG-2001 12:10 - 1 01-AUG-2001 12:15 - 2 01-AUG-2001 12:25 - 3 01-AUG-2001 12:30 - 2 01-AUG-2001 12:40 - 1 01-AUG-2001 12:45 - 2 01-AUG-2001 12:47 - 1 01-AUG-2001 12:55 - 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CS 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: Greg Solomon 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: Lord, David - CS INET: [EMAIL PROTECTED] Fat City Network Services-- (858)
A modification time question
Dear gurus ! Is there a way to know the time of insert/update for each row in a table ? Or , which rows in a table were inserted/updated since a certain time. ( Sort of find ... -mtime ... for UNIX files) . I CAN NOT modify the structure of the table , i.e. i CAN NOT add a timestamp or other column , just need to deal with what is present. Thanks a lot for your help !!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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 sql
Hi, it must be doing full table scan.check your column positions of the indexes in table user_ind_columns and change your where condition according to the column positions. rukmini - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 16, 2001 3:15 PM Hallo you DBA'¨s Can anyonetell me why this insert statement takes 30-40 minutes to run? What can I do to make it go faster? insert into varukorgtemp ( varukorgid, ean, anvandarid, lagstapris, varutyp, varunamn, strl, leverantor, varumarke, sortiment,vgrp,vare_snr,varenr,levnr ) SELECT PBK.VARUKORGEANREL.varukorgid, rik2.vare.ean_nr, 'rsm' , PBK.VARUKORGEANREL.lagstapris, 0, rik2.vare.varenavn, rik2.vare.str, rik2.lev.navn, rik2.vare.hylletxt2, rik2.vare.sortiment,rik2.art_hierarki.vgrp, pbk.varukorgeanrel.vare_snr,pbk.varukorgeanrel.varenr,pbk.varukorgeanrel.lev nr FROM PBK.VARUKORGEANREL,rik2.vare,rik2.lev,rik2.art_hierarki WHERE PBK.VARUKORGEANREL.varukorgid= 39 AND PBK.VARUKORGEANREL.ean=rik2.vare.ean_nr AND RIK2.VARE.ARTNR=RIK2.ART_HIERARKI.ARTNR AND rik2.vare.levnr=rik2.lev.levnr AND rik2.vare.selskap='11' AND rik2.vare.vare_snr=pbk.varukorgeanrel.vare_snr AND pbk.varukorgeanrel.varenr=rik2.vare.varenr AND pbk.varukorgeanrel.levnr=rik2.vare.levnr AND rik2.art_hierarki.sett_id=2 Sincerely Roland Sköldblom -- 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: Rukmini Devi 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 C compiler a must for oracle UNIX installations ?
All make does is track dependencies on things. The general format of an entry in a makefile is: label: dependent on actions to execute So if you wanted to make label, then you would first have to have made dependent on. Once you gave it, you can then execute actions to execute. dependent on points to another label. At the end of your Makefile, there will be the things that aren't dependent on anything else, which are just label: actions to execute actions to execute are just lines of shell script. They are often used to invoke a C compiler, sure, but you could be doing anything there. One those actions are done, make considers that dependency satisfied, and any label that refers to a satisfied dependency can then have its associated actions executed. This persists from invocation to invocation of make using timestamps. The reason you do this is that you only want to execute actions for anything that has changed, and for anything else that would be affected by it. Otherwise every time a developer changed a single line of code, the entire application would have to be completely rebuilt, which could take hours, rather than just recompiling the object files that are affected and relinking. Makefiles for non-trivial projects are complex pieces of software in their own right, and a software engineering team will often have a dedicated build manager whose job is to maintain the Makefile and administer the source code control system (for example, CVS). See the manpage for make for more details. g -Original Message- Sent: Thursday, August 16, 2001 7:56 AM To: Multiple recipients of list ORACLE-L but doesnt make utility uses C compiler ? (or it's a bare bones installation of a C compiler?) i guess i;m wrong on this one... -- From: Rao, UmaSankara S (CAP)[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Thursday, August 16, 2001 1:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: is C compiler a must for oracle UNIX installations ? Oracle installation document says the make utility must be present for relinking the oracle S/W once it is installed.(Incase of SUN it is at the location /usr/ccs/bin.).I Installed oracle 8 and 8i on sun machine without installing C compiler.Could be same as the case with AIX i guess. -Original Message- Sent: Thursday, August 16, 2001 12:35 AM To: Multiple recipients of list ORACLE-L some of my friends are telling me that they have succesfuly installed oracle 7.3.1 on AIX 4 WITHOUT the C compiler present.. !! and i was the one telling them how oralce requires to relink the executables after the installation. Regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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: A modification time question
the answer is it depends. since you can't modify the table, why not put a trigger to put a last updated, etc time into another table. joe Andrey Bronfin wrote: Dear gurus ! Is there a way to know the time of insert/update for each row in a table ? Or , which rows in a table were inserted/updated since a certain time. ( Sort of find ... -mtime ... for UNIX files) . I CAN NOT modify the structure of the table , i.e. i CAN NOT add a timestamp or other column , just need to deal with what is present. Thanks a lot for your help !!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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) -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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: A modification time question
Hi Aviv ! Thanks for your reply ! Yes , i thought of this snapshot log option . 2 problems : 1) performance overhead - for each DML on my table , i have a DML on the MLOG$_ (snapshot log) table , carried out by a trigger. 2) For each access to the rows in my original table , i need to join with the MLOG$_ table (in order to filter out the neccessary timestamps) - another performance overhead. 3) I'm wondering whether this modification time is stored somewhere in the data dictionary. Thanks a lot ! -Original Message- Sent: Thursday, August 16, 2001 1:17 PM To: 'Andrey Bronfin' create snapshot log Aviv Cohen DBA mailto:[EMAIL PROTECTED] 972-97761395 -Original Message- Sent: Thursday, August 16, 2001 12:14 PM To: LazyDBA.com Discussion Dear gurus ! Is there a way to know the time of insert/update for each row in a table ? Or , which rows in a table were inserted/updated since a certain time. ( Sort of find ... -mtime ... for UNIX files) . I CAN NOT modify the structure of the table , i.e. i CAN NOT add a timestamp or other column , just need to deal with what is present. Thanks a lot for your help !!! 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: Andrey Bronfin 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: A modification time question
If you can't modify the structure to add a timestamp column or add a trigger to insert a timestamp into another table, there's no way I know of to track it. Oracle doesn't track this sort of thing on its own; you need some sort of timestamp field. Jon Walthour -Original Message- Bronfin Sent: Thursday, August 16, 2001 7:16 AM To: Multiple recipients of list ORACLE-L Dear gurus ! Is there a way to know the time of insert/update for each row in a table ? Or , which rows in a table were inserted/updated since a certain time. ( Sort of find ... -mtime ... for UNIX files) . I CAN NOT modify the structure of the table , i.e. i CAN NOT add a timestamp or other column , just need to deal with what is present. Thanks a lot for your help !!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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: Jon Walthour 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: Q about Oracle Optimizer
It simply uses RBO instead. g -Original Message- Sent: Thursday, August 16, 2001 9:46 AM To: Multiple recipients of list ORACLE-L Hi list, a quick question about oracle optimizer. a customer has database migrated from 7.3.4 to 8.1.6 on AIX. Data was transfered via full exp/imp. After migration the performance of the new database is very poor. I looked at the parameters and saw that no object is analyzed. So now me question: What does oracle optimizer do, if there are no statistics on all objects. Optimizer level is choose. Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker 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: Guy Hammond 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: A modification time question
Create a trigger on insert/update of zour table and let the trigger write tuple in other table with datetime of modification of ROWID of your table. Jan Pruner Dne èt 16. srpen 2001 13:15 jste napsal(a): Dear gurus ! Is there a way to know the time of insert/update for each row in a table ? Or , which rows in a table were inserted/updated since a certain time. ( Sort of find ... -mtime ... for UNIX files) . I CAN NOT modify the structure of the table , i.e. i CAN NOT add a timestamp or other column , just need to deal with what is present. Thanks a lot for your help !!! -- 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: Q about Oracle Optimizer
Volker: If optimizer_mode = 'choose', then the optimizer chooses between cost-based optimization and rule-based optimization based on whether or not statistics are present. In your case, since they aren't it's using rule-based. -Original Message- Volker Sent: Thursday, August 16, 2001 4:46 AM To: Multiple recipients of list ORACLE-L Hi list, a quick question about oracle optimizer. a customer has database migrated from 7.3.4 to 8.1.6 on AIX. Data was transfered via full exp/imp. After migration the performance of the new database is very poor. I looked at the parameters and saw that no object is analyzed. So now me question: What does oracle optimizer do, if there are no statistics on all objects. Optimizer level is choose. Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker 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: Jon Walthour 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: computer history stories - Now: IQ, etc.
My perception of intelligent people is that they know a lot of trivia, can repeat many theories, and can talk a lot when you ask them regarding something on which they collected many associations. Intelligent people don't make fortunes all that often, because theories and knowledge do not constitute wisdom. They may provide a context for experiences, however, provided the theories reflect reality. If your theory is wrong, you can go around in circles for a long time without learning anything. Your professor's frame of reference seems to be about adding more information to existing bodies of knowledge, he didn't mention life experiences. Sounds academic, where they publish paper after paper, but people rarely read them. One of my profs said that there are so many papers published now that it has become impossible to keep up. Strange idea, that publishing papers would add to understanding, and perhaps lead to wisdom. My wife is a teacher, she says there are 8 or more types of intelligence that they have to consider now when teaching. I found it interesting that one of these Intelligences is the equivalent of street smarts - i.e. how to get things done in the real world, not based on theoretical frameworks. Street smarts is based on real life experiences. 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] mailto:[EMAIL PROTECTED] -Original Message- From: Guy Hammond [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 6:36 AM To: Multiple recipients of list ORACLE-L Subject:RE: computer history stories - Now: IQ, etc. A professor of mine defined things like this: Data: raw numbers and text Information: data filtered and summarized to extract the relevant pieces Knowledge: new information fitted into existing knowledge in such a way as to be meaningful in a wider context Wisdom: Extrapolating trends in knowledge to synthesize new knowledge Interesting that he didn't seem to consider intelligence to be particularly relevant to his model of learning. I would day that intelligence is a measure of how fast data can be transformed all the way into wisdom. Technology at present is very good at dealing with data and information, and is just starting to address knowledge, altho' it's far from commercially useful yet. g -Original Message- Sent: Wednesday, August 15, 2001 6:52 PM To: Multiple recipients of list ORACLE-L I have a simplistic view of things: Knowledge = ideas linked by associations, purely intellectual in nature. You can do the word association game re. these, quite fun. Understanding = experience involving the whole person, including movement, emotions and intellect. So to understand, you must go through the experience. P.S. Are Orasoruses herbivores, or carnivores? : ) 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] mailto:[EMAIL PROTECTED] -Original Message- From: Don Granaman [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 1:37 PM To: Multiple recipients of list ORACLE-L Subject:Re: computer history stories - Now: IQ, etc. Apologies for reviving a dead thread, but I was incommunicado for a week and just now saw this rather interesting thread. One of my pet rants is about the difference between knowledge and understanding. I am not sure of the clinical definitions of the words used in this discussion, but will offer this postulation, in IT terms. Knowledge is essentially accumulated data. Understanding is more like the ability to process data. Of the two, understanding is far more valuable - and far more rare. I once had a physics professor/mentor who invented the mathematical field of product calculus to support his doctoral research in physics. (Note: product calculus - multiplying infinitesimal bits of stuff, not adding. I
Re: is C compiler a must for oracle UNIX installations ?
Relinking only requires 'make' and 'ld'. The components which make up the Oracle binaries are provided as compiled object code, so no C compiler is necessary for relinking. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 16, 2001 1:35 AM some of my friends are telling me that they have succesfuly installed oracle 7.3.1 on AIX 4 WITHOUT the C compiler present.. !! and i was the one telling them how oralce requires to relink the executables after the installation. Regards -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charles Wolfe 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: OT -- training
Sounds like in the U.S. you have the same tax-shelter... Find yourself a horse-breeding farm that makes profit only 2 years out of 7, hopefully it will make multi-million losses 5 years out of 7. ; ) I wish they would get rid of all these loopholes. Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Post, Ethan [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 5:48 PM To: Multiple recipients of list ORACLE-L Subject:RE: OT -- training Well your exactly right about the .coms and many other businesses. There must be some more legal wrangling elsewhere in the tax code or some existing legal precedents that would suggest that you can infact not make a profit and still be considered a biz, even outside the lines of the ref below. - E -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 1:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: OT -- training You're absolutely correct. I had a momentary brain-burp and applied what I knew of tax-exempt to not-for-profit. From the IRS's FAQ at http://www.irs.gov/prod/bus_info/eo/eo-faqs.html#11 Non-profit and not-for-profit are state law concepts. Most states have laws whereby an entity can be incorporated as a non-profit or not-for-profit organization. However, the mere fact that an entity is organized as a non-profit or not-for-profit organization does not indicate that it is exempt from federal income tax. So the IRS (Federal law) doesn't recognize non-profit or not-for-profit. However, the discussion was really about whether you had to make a profit to be a legitimate business. Check http://www.irs.gov/plain/forms_pubs/pubs/p5350104.htm Quote: Presumption of Profit An activity is presumed carried on for profit if it produced a profit in at least 3 of the last 5 tax years, including the current year. Activities that consist primarily of breeding, training, showing, or racing horses are presumed carried on for profit if they produced a profit in at least 2 of the last 7 tax years, including the current year. You have a profit when the gross income from an activity is more than the deductions for it. If a taxpayer dies before the end of the 5-year (or 7-year) period, the period ends on the date of the taxpayer's death. If your business or investment activity passes this 3- (or 2-) years-of-profit test, presume it is carried on for profit. This means it will not come under these limits. You can take all your business deductions from the activity, even for the years that you have a loss. You can rely on this presumption in every case, unless the IRS shows it is not valid. Using the presumption later. If you are starting an activity and do not have 3 (or 2) years showing a profit, you may want to take advantage of this presumption later, after you have the 5 (or 7) years of experience allowed by the test. You can choose to do this by filing Form 5213. Filing this form postpones any determination that your activity is not carried on for profit until 5 (or 7) years have passed since you started the activity. The benefit gained by making this choice is that the IRS will not immediately question whether your activity is engaged in for profit. Accordingly, it will not restrict your deductions. Rather, you will gain time to earn a profit in 3 (or 2) out of the first 5 (or 7) years you carry on the activity. If you show 3 (or 2) years of profit at the end of this period, your deductions are not limited under these rules. If you do not have 3 (or 2) years of profit, the limit can be applied retroactively to any year in the 5-year (or 7-year) period with a loss. Filing Form 5213 automatically extends the period of limitations on any year in the 5-year (or 7-year) period to 2 years after the due date of the return for the last year of the period. The period is extended only for deductions of the activity and any related deductions that might be affected. They've changed the rules since I last was interested. I'm pretty sure that it used to be just 1 year out of the last 4 or 5. Now it's 3 years out of the last 5. I
Deferred constraints (?)
Do we have the concept of deferred CHECK constraints? For a constraint of this nature, I don't Oracle to check the whole table as I have done the fixes to ensure there is no occurrence of invalid condition. I only want the future ones to be checked. ALTER TABLE KB.table ADD CONSTRAINT CHECK_DATES CHECK (ENDTIME = STARTTIME AND STOPTIME = NENDTIME); Thanks Kumanan ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper and Nortons Anti-Virus, for the presence of computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kumanan Balasundaram 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: Q about Oracle Optimizer
If the objects in a query have not been analyze, then rule mode is defaulted. If there are objects in the database which are analyze, yet the tables you are using are not analyzed, rule mode will still be used. If one table is analyzed, and it is joined with 5 others which are not analyzed, then cost base will be used. There are a few parameters that need tweaking when you first go from rule to cost base. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, August 16, 2001 4:46 AM To: Multiple recipients of list ORACLE-L Hi list, a quick question about oracle optimizer. a customer has database migrated from 7.3.4 to 8.1.6 on AIX. Data was transfered via full exp/imp. After migration the performance of the new database is very poor. I looked at the parameters and saw that no object is analyzed. So now me question: What does oracle optimizer do, if there are no statistics on all objects. Optimizer level is choose. Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker 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: Christopher Spence 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 C compiler a must for oracle UNIX installations ?
Rahul, I installed different versions of Oracle (804,816,817) on Sun boxes without c compiler. Oracle installation went through. By this, I could say that on Sun Solaris machines we do not require c compiler for Oracle installation. Perhaps, on HP boxes the story might be the same or different. Rao [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 16, 2001 1:35 AM To: Multiple recipients of list ORACLE-L some of my friends are telling me that they have succesfuly installed oracle 7.3.1 on AIX 4 WITHOUT the C compiler present.. !! and i was the one telling them how oralce requires to relink the executables after the installation. Regards -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara 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: Rollback after truncate?? + 2 more questions :-)
Zsolt, The correct call for the function if the function exists within the package would be: Insert into A ( Select Col1 ,PackageName.MyFunction(Col1) from B ); Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, August 15, 2001 6:44 PM To: Multiple recipients of list ORACLE-L 1. No. 2. I do not think its a function of the number of words. DDL needs the Execute Immediate. 3. Don't Know. Need to see the function. -Original Message- Sent: Wednesday, August 15, 2001 5:08 PM To: Multiple recipients of list ORACLE-L Hi, 1.Can I rollback after doing a truncate table (it seems to me that I can' t) e.g. Execute Immediate 'Truncate Table '|| TablaNevTomb(i); Execute Immediate 'Begin '|| 'Insert into '|| TablaNevTomb(i) ||' (Select * From X$_'||TablaNevTomb(i)||');'|| 'End;'; Exception When others Then RollBack 2. Is there a way to use a command with more than one word in Pl/Sql without using it dynamically? For example I can use Truncate table only with Execute immediate within a Pl/Sql block. 3. I have a statement in a package: Insert into A ( Select Col1 ,MyFunction(Col1) from B ); If the MyFunction function is made with create or replace function everything works perfectly, but if the same function is declared within the package, I get the error message: PLS-00231 function 'string' may not be used in SQL Thank you for your help Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: Kevin Lange 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).
RE: VB vs. JAVA
Well whoever you are talking to probably is vaugely familiar with java. Java's execution speed is fairly close but not quite to C++. Although there is a large delay in the initial interperation as well as graphical interfaces. Java also uses more resources. So basically, on a client workstation, java appears to be slow. In this case is very well can be considered as such. But on a server, where the startup time taking 2 minutes to compile and start all the code isn't a big deal when it is left running for days and week after. This is where the performance problem is moot. Java offers a lot, for example persistence in which you can make an application perform quite well, and avoid the need to constantly hit the database. Properly used, in the proper place, java is quite fast. Used for things which it is not suitable for, java can be unbearable. Although 1.3 and 1.4 JDK have made noticable improvements on the swing library (which is the reason java is slow on gui) which helps a lot when dealing with graphical programs, but still is not what most people are used to seeing in terms of performance. But I have seen very complicated such as jbuilder and such written completely in java perform satisfactory using completely java. I have also seen very small swing programs perform very poorly. Swing programming is an art, and although performance is not what c++ is for gui, the way you code it can make it look good or poor. In short, java is not slow. But it does have a slow load time, graphical interface coding is slow, and it does require more resources in terms of memory. But you gain many things, a very nicely written language, persistence, true object oriented programming, rad, and true cross platform development. Not everything has to be written in assembly. When performance is the utmost concern, then there is c/c+ to fall back to. But Orion, which is one of the fastest webservers/app servers out there, is complete Java coded. Granted it takes 10 seconds for it to load, but after that, zip zip. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 2:15 AM To: Multiple recipients of list ORACLE-L I hear a lot of bad things about Java, mostly in regards to speed. I'm wondering if there's anybody out there with experience in numerous programming langauges (including Java) that wouldn't mind giving their opinion about wether or not java is the best option for the job? ta michael -Original Message- fatcity] [mailto:X] Sent: Thursday, 16 August 2001 7:20 AM To: X Basked on my limited knowledge, you'd go a long way with java and oracle, that's where Oracle is pushing everyone anyway. I doubt how cold it will be on his each when Oracle will recommend to drop java and start using VB. If you use VB, you have to use ODBC, with java client JDBC. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra 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
RE: Re[2]: Datafile Migration Tool
Alex, It's tough to guess how long an import will take. It all depends on how many indexes and constraints you have - these are what take the most time at import time. The data gets sucked in real fast. Using Direct Load really speeds the import up but, again, rebuilding the indexes takes forever. Gene is correct in that export is extremely fast. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, August 15, 2001 7:01 PM To: Multiple recipients of list ORACLE-L Alex - you must be joking, 60hrs? i get ~1gb/3mins for export. i haven't done an import lately, but its not that bad. exp/imp are great tools to move data around. gene [EMAIL PROTECTED] 08/15/01 06:08PM exp/imp does not work(takes too much time)for large databases. How long do you think import will take for 200G database? - about 60 hours? Alex Hillman -Original Message- Sent: Tuesday, August 14, 2001 5:03 PM To: Multiple recipients of list ORACLE-L Rachel, I can see what he is proposing, but I'm not sure anyone would care. I know I can't take the datafiles from one of our HP-UX servers and use them to create a database on NT for instance. Wish I could for our Support Magic junk. In that case they do a bunch of things (like create objects) as SYS which never get included in an export. The problem that I see is that there is a toolset that currently exists, namely export import, that work cross platform with no problems. Just not at the datafile level. And although that type of tool would be interesting to me it would not be of much value since I've only the one problem. Dick Goulet Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 8/14/2001 12:41 PM it doesn't sound like an ftp type tool. If I am reading this correctly, he is proposing to provide a tool that copies datafiles directly from one OS to another. While this is an interesting trick, I'm not sure there's a large market for it. From: Scott Shafer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Datafile Migration Tool Date: Tue, 14 Aug 2001 12:00:53 -0800 Not to be a smartass, but don't most OS's already have ftp built in? What kind of value-added are you proposing? Just curious... Scott Shafer San Antonio, TX K Gopalakrishnan wrote: Hi , Will there be a market if I give a tool which migrates Oracle database from One OS to another OS. (Data file migration at Operating System Level.) i.e it will convert from Oracle data files on NT to Oracle Datafiles on Solaris and vice versa. In the target database you need to recreate the control files and you are done. You can startup the database. You don't need to export/import or CTAS over dblink.. Send your replies directly to me.. Thanks Yong..for bringing the cat out of the basket ;) = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer 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 download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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
Question about Oracle Portal Reports
Hello! I'm using Oracle Portal (3.0.6) and there (creating reports) you can select max. 3 break columns, but I need 5 or so. So far I've found that SQL*Plus have similarly acting command break on column_name. So I tried to find where or/and how Portal calls those commands but haven't found yet. Thank You! Madis - Meeldetuletused kalendrist sms-lühisõnumina. Uuri järgi! http://www.hot.ee
RE: VB vs. JAVA
One interesting note to this. When I was benchmarking my quicksite application, which is completely java jdbc. Using this query: select 100 - (sum(getmisses) / sum(gets) * 100) from sys.v_$rowcache; I was able to get 786.3 queries in per second against the database. 10,000 in 12.8 seconds. This is using ParsedStatement and OCI. Granted, this is just an E450 with an A1000 quering from my laptop nothing special. That is pretty quick for slow old java. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, August 16, 2001 7:51 AM To: Multiple recipients of list ORACLE-L Well, what you mean by speed depends on what it is you're trying to do. Big numerical computations are certainly quite slow in Java... but they are even slower in PL/SQL. Remember that a Java Virtual Machine does execute native code for many operations, such as networking. But, what is your application doing? Is it spending most of its time executing transactions? Because Java is certainly capable of starting transactions faster than Oracle can commit them, on similar hardware. Use a profiler to work out where the Java is spending most of its time, and use the OCI8 driver instead of the Thin Client. g -Original Message- Sent: Thursday, August 16, 2001 7:15 AM To: Multiple recipients of list ORACLE-L I hear a lot of bad things about Java, mostly in regards to speed. I'm wondering if there's anybody out there with experience in numerous programming langauges (including Java) that wouldn't mind giving their opinion about wether or not java is the best option for the job? ta michael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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: Christopher Spence 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: OT: cryptography speech
I am NOT the guy who beats up calculators. I might slip stick them a bit. Interesting concept. Almost like the NorthStar from american car monitoring and trying to control what you do. ROR mô¿ôm [EMAIL PROTECTED] 08/15/01 06:43PM Well, if the subject didn't cause you to delete this message out of hand, you're in for a treat. This is very funny, in a geeky sort of fashion. If you know anything at all about cryptography, you'll appreciate this. http://www.conceptlabs.co.uk/alicebob.html Jared -- 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: 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: VB vs. JAVA
There is no application, just wondering. I'm a ASP/ColdFusion developer atm, and have been wondering for some time if Java was worth learning, and it appears now, based on your answers, it might just be worth it. Thanks Guy. anybody else have any input on this topic ? cheers, michael -Original Message- [mailto:X] Sent: Thursday, 16 August 2001 9:51 PM To: X Well, what you mean by speed depends on what it is you're trying to do. Big numerical computations are certainly quite slow in Java... but they are even slower in PL/SQL. Remember that a Java Virtual Machine does execute native code for many operations, such as networking. But, what is your application doing? Is it spending most of its time executing transactions? Because Java is certainly capable of starting transactions faster than Oracle can commit them, on similar hardware. Use a profiler to work out where the Java is spending most of its time, and use the OCI8 driver instead of the Thin Client. g -Original Message- Sent: Thursday, August 16, 2001 7:15 AM To: Multiple recipients of list ORACLE-L I hear a lot of bad things about Java, mostly in regards to speed. I'm wondering if there's anybody out there with experience in numerous programming langauges (including Java) that wouldn't mind giving their opinion about wether or not java is the best option for the job? ta michael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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: VB vs. JAVA
someones gloating :) thanks again chris. -Original Message- [mailto:X] Sent: Thursday, 16 August 2001 11:23 PM To: X One interesting note to this. When I was benchmarking my quicksite application, which is completely java jdbc. Using this query: select 100 - (sum(getmisses) / sum(gets) * 100) from sys.v_$rowcache; I was able to get 786.3 queries in per second against the database. 10,000 in 12.8 seconds. This is using ParsedStatement and OCI. Granted, this is just an E450 with an A1000 quering from my laptop nothing special. That is pretty quick for slow old java. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, August 16, 2001 7:51 AM To: Multiple recipients of list ORACLE-L Well, what you mean by speed depends on what it is you're trying to do. Big numerical computations are certainly quite slow in Java... but they are even slower in PL/SQL. Remember that a Java Virtual Machine does execute native code for many operations, such as networking. But, what is your application doing? Is it spending most of its time executing transactions? Because Java is certainly capable of starting transactions faster than Oracle can commit them, on similar hardware. Use a profiler to work out where the Java is spending most of its time, and use the OCI8 driver instead of the Thin Client. g -Original Message- Sent: Thursday, August 16, 2001 7:15 AM To: Multiple recipients of list ORACLE-L I hear a lot of bad things about Java, mostly in regards to speed. I'm wondering if there's anybody out there with experience in numerous programming langauges (including Java) that wouldn't mind giving their opinion about wether or not java is the best option for the job? ta michael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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: Christopher Spence 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[2]: Datafile Migration Tool
DOH! mixing up my tools again! thanks Joe! "Last i checked there was no direct=y on imp only on exp (ok and sqlldr) :)" Tom Mercadante Oracle Certified Professional -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001 8:48 AMTo: [EMAIL PROTECTED]; [EMAIL PROTECTED]Subject: RE: Re[2]: Datafile Migration Tool Last i checked there was no direct=y on imp only on exp (ok and sqlldr) :) joe [EMAIL PROTECTED] 08/16/01 09:18AM Alex,It's tough to guess how long an import will take. It all depends on howmany indexes and constraints you have - these are what take the most time atimport time. The data gets sucked in real fast. Using Direct Load reallyspeeds the import up but, again, rebuilding the indexes takes forever.Gene is correct in that export is extremely fast.Tom MercadanteOracle Certified Professional-Original Message-Sent: Wednesday, August 15, 2001 7:01 PMTo: Multiple recipients of list ORACLE-LAlex - you must be joking, 60hrs? i get ~1gb/3mins for export. i haven'tdone an import lately, but its not that bad. exp/imp are great tools tomove data around.gene [EMAIL PROTECTED] 08/15/01 06:08PM exp/imp does not work(takes too much time)for large databases. How long doyou think import will take for 200G database? - about 60 hours?Alex Hillman-Original Message-Sent: Tuesday, August 14, 2001 5:03 PMTo: Multiple recipients of list ORACLE-LRachel, I can see what he is proposing, but I'm not sure anyone would care. IknowI can't take the datafiles from one of our HP-UX servers and use them tocreatea database on NT for instance. Wish I could for our Support Magic junk. Inthat case they do a bunch of things (like create objects) as SYS which nevergetincluded in an export. The problem that I see is that there is a toolsetthatcurrently exists, namely export import, that work cross platform with noproblems. Just not at the datafile level. And although that type of toolwouldbe interesting to me it would not be of much value since I've only the oneproblem.Dick GouletReply SeparatorAuthor: "Rachel Carmichael" [EMAIL PROTECTED]Date: 8/14/2001 12:41 PMit doesn't sound like an ftp type tool. If I am reading this correctly, he is proposing to provide a tool that copies datafiles directly from one OS toanother.While this is an interesting trick, I'm not sure there's a large market for it.From: Scott Shafer [EMAIL PROTECTED]Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]Subject: Re: Datafile Migration ToolDate: Tue, 14 Aug 2001 12:00:53 -0800Not to be a smartass, but don't most OS's already have ftp built in?What kind of value-added are you proposing? Just curious...Scott ShaferSan Antonio, TXK Gopalakrishnan wrote: Hi , Will there be a market if I give a tool which migrates Oracle database from One OS to another OS. (Data file migration at Operating System Level.) i.e it will convert from Oracle data files on NT to Oracle Datafiles on Solaris and vice versa. In the target database you need to recreate the control files and you are done. You can startup the database. You don't need to export/import or CTAS over dblink.. Send your replies directly to me.. Thanks Yong..for bringing the cat out of the basket ;) = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA._Do You Yahoo!?Get your free @yahoo.com address at http://mail.yahoo.com --Please see the official ORACLE-L FAQ: http://www.orafaq.com --Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo 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)._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: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL
Re: Running sql script from stored procedure
Use UTL_FILE to read your .sql file, and then execute your sql-statements using dynamic sql (DBMS_SQL or 'EXECUTE IMMEDIATE'). Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 16, 2001 2:50 AM Dear DBA Gurus, I have a .sql file which contains a series of insert statements. I want to call this .sql file and run it from a stored procedure. Is it possible? If so, how? Please post your answers to me directly as I am not receiving messages directly from the list rather I am able to send messages to the list. Thanks and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman 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: CLOB field question
On Thu, Aug 16, 2001 at 02:15:55AM -0800, Guy Hammond wrote: I have another CLOB question, what is the best way to do a search-and-replace? Something like a c/oldvalue/newvvalue/ on the SQL*Plus command line, or $variable =~ s/oldvalue/newvalue/; in Perl. The only thing I can think of right now would be using INSTR to locate the value I want, SUBSTR to extract the parts of the document either side of it, then APPEND to create a new CLOB with first part, new value, last part... but this seems a bit inelegant. My Oracle::OCI perl modules is close to being able to let you stream a LOB into client memory and stream it back to the server, possibly applying perl regular expressions along the way. Tim. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Bunce 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: VB vs. JAVA
Thanks Chris, your input is appreciated. Can anybody recommend any good java programming books, specficially something designed at working with Oracle 8i ? Thanks, Michael. -Original Message- [mailto:X] Sent: Thursday, 16 August 2001 11:18 PM To: X Well whoever you are talking to probably is vaugely familiar with java. Java's execution speed is fairly close but not quite to C++. Although there is a large delay in the initial interperation as well as graphical interfaces. Java also uses more resources. So basically, on a client workstation, java appears to be slow. In this case is very well can be considered as such. But on a server, where the startup time taking 2 minutes to compile and start all the code isn't a big deal when it is left running for days and week after. This is where the performance problem is moot. Java offers a lot, for example persistence in which you can make an application perform quite well, and avoid the need to constantly hit the database. Properly used, in the proper place, java is quite fast. Used for things which it is not suitable for, java can be unbearable. Although 1.3 and 1.4 JDK have made noticable improvements on the swing library (which is the reason java is slow on gui) which helps a lot when dealing with graphical programs, but still is not what most people are used to seeing in terms of performance. But I have seen very complicated such as jbuilder and such written completely in java perform satisfactory using completely java. I have also seen very small swing programs perform very poorly. Swing programming is an art, and although performance is not what c++ is for gui, the way you code it can make it look good or poor. In short, java is not slow. But it does have a slow load time, graphical interface coding is slow, and it does require more resources in terms of memory. But you gain many things, a very nicely written language, persistence, true object oriented programming, rad, and true cross platform development. Not everything has to be written in assembly. When performance is the utmost concern, then there is c/c+ to fall back to. But Orion, which is one of the fastest webservers/app servers out there, is complete Java coded. Granted it takes 10 seconds for it to load, but after that, zip zip. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 2:15 AM To: Multiple recipients of list ORACLE-L I hear a lot of bad things about Java, mostly in regards to speed. I'm wondering if there's anybody out there with experience in numerous programming langauges (including Java) that wouldn't mind giving their opinion about wether or not java is the best option for the job? ta michael -Original Message- fatcity] [mailto:X] Sent: Thursday, 16 August 2001 7:20 AM To: X Basked on my limited knowledge, you'd go a long way with java and oracle, that's where Oracle is pushing everyone anyway. I doubt how cold it will be on his each when Oracle will recommend to drop java and start using VB. If you use VB, you have to use ODBC, with java client JDBC. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra 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
Migrating IMS to Oracle
I may be starting a project in the near future to migrate an IMS database to 8.1.? on Windows 2000. I would like to know if Oracle provides a tool to do this? Data profiling, mapping, etc.? I could not find anything for IMS on OTN or the Oracle site. I know there are some non-Oracle tools to do this. Any suggestions would be helpful. Thanks, Ken Janusz, CPIM -- 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: A modification time question
Okay, can you add a trigger? At a prior job, management wanted us not only to track last update/insert but WHAT was done. so I created a second table, duplicate of the first with addition fields of trans_date,user and action then I added a trigger (insert/update/delete) on the original table. if the action was an insert, I inserted a row into the second table, trans_date=sysdate, user=user and action=I if a delete, I inserted a row into the second table, trans_date=sysdate, user=user and action=D if an update, I inserted two roww into the second table, the first had the original row, trans_date=sysdate, user=user and action=O (old values) the second had the new row, trans_date=sysdate, user=user and action=N(new values) the secondary table could be archived/purged as necessary From: Andrey Bronfin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: A modification time question Date: Thu, 16 Aug 2001 03:15:49 -0800 Dear gurus ! Is there a way to know the time of insert/update for each row in a table ? Or , which rows in a table were inserted/updated since a certain time. ( Sort of find ... -mtime ... for UNIX files) . I CAN NOT modify the structure of the table , i.e. i CAN NOT add a timestamp or other column , just need to deal with what is present. Thanks a lot for your help !!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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 download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: VB vs. JAVA
Not at all, Just showing that java is not in fact slow, especially when it comes to database drives. JDBC drivers are quite fast. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 9:48 AM To: Multiple recipients of list ORACLE-L someones gloating :) thanks again chris. -Original Message- [mailto:X] Sent: Thursday, 16 August 2001 11:23 PM To: X One interesting note to this. When I was benchmarking my quicksite application, which is completely java jdbc. Using this query: select 100 - (sum(getmisses) / sum(gets) * 100) from sys.v_$rowcache; I was able to get 786.3 queries in per second against the database. 10,000 in 12.8 seconds. This is using ParsedStatement and OCI. Granted, this is just an E450 with an A1000 quering from my laptop nothing special. That is pretty quick for slow old java. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, August 16, 2001 7:51 AM To: Multiple recipients of list ORACLE-L Well, what you mean by speed depends on what it is you're trying to do. Big numerical computations are certainly quite slow in Java... but they are even slower in PL/SQL. Remember that a Java Virtual Machine does execute native code for many operations, such as networking. But, what is your application doing? Is it spending most of its time executing transactions? Because Java is certainly capable of starting transactions faster than Oracle can commit them, on similar hardware. Use a profiler to work out where the Java is spending most of its time, and use the OCI8 driver instead of the Thin Client. g -Original Message- Sent: Thursday, August 16, 2001 7:15 AM To: Multiple recipients of list ORACLE-L I hear a lot of bad things about Java, mostly in regards to speed. I'm wondering if there's anybody out there with experience in numerous programming langauges (including Java) that wouldn't mind giving their opinion about wether or not java is the best option for the job? ta michael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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: Christopher Spence 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: Christopher Spence 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
RE: Re[2]: Datafile Migration Tool
Last i checked there was no direct=y on imp only on exp (ok and sqlldr) :) joe [EMAIL PROTECTED] 08/16/01 09:18AM Alex,It's tough to guess how long an import will take. It all depends on howmany indexes and constraints you have - these are what take the most time atimport time. The data gets sucked in real fast. Using Direct Load reallyspeeds the import up but, again, rebuilding the indexes takes forever.Gene is correct in that export is extremely fast.Tom MercadanteOracle Certified Professional-Original Message-Sent: Wednesday, August 15, 2001 7:01 PMTo: Multiple recipients of list ORACLE-LAlex - you must be joking, 60hrs? i get ~1gb/3mins for export. i haven'tdone an import lately, but its not that bad. exp/imp are great tools tomove data around.gene [EMAIL PROTECTED] 08/15/01 06:08PM exp/imp does not work(takes too much time)for large databases. How long doyou think import will take for 200G database? - about 60 hours?Alex Hillman-Original Message-Sent: Tuesday, August 14, 2001 5:03 PMTo: Multiple recipients of list ORACLE-LRachel, I can see what he is proposing, but I'm not sure anyone would care. IknowI can't take the datafiles from one of our HP-UX servers and use them tocreatea database on NT for instance. Wish I could for our Support Magic junk. Inthat case they do a bunch of things (like create objects) as SYS which nevergetincluded in an export. The problem that I see is that there is a toolsetthatcurrently exists, namely export import, that work cross platform with noproblems. Just not at the datafile level. And although that type of toolwouldbe interesting to me it would not be of much value since I've only the oneproblem.Dick GouletReply SeparatorAuthor: "Rachel Carmichael" [EMAIL PROTECTED]Date: 8/14/2001 12:41 PMit doesn't sound like an ftp type tool. If I am reading this correctly, he is proposing to provide a tool that copies datafiles directly from one OS toanother.While this is an interesting trick, I'm not sure there's a large market for it.From: Scott Shafer [EMAIL PROTECTED]Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]Subject: Re: Datafile Migration ToolDate: Tue, 14 Aug 2001 12:00:53 -0800Not to be a smartass, but don't most OS's already have ftp built in?What kind of value-added are you proposing? Just curious...Scott ShaferSan Antonio, TXK Gopalakrishnan wrote: Hi , Will there be a market if I give a tool which migrates Oracle database from One OS to another OS. (Data file migration at Operating System Level.) i.e it will convert from Oracle data files on NT to Oracle Datafiles on Solaris and vice versa. In the target database you need to recreate the control files and you are done. You can startup the database. You don't need to export/import or CTAS over dblink.. Send your replies directly to me.. Thanks Yong..for bringing the cat out of the basket ;) = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA._Do You Yahoo!?Get your free @yahoo.com address at http://mail.yahoo.com --Please see the official ORACLE-L FAQ: http://www.orafaq.com --Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo 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)._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: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo 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).-- 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 / Mailing ListsTo
RE: OT: cryptography speech
Jared, I would have liked to have been the room when the speech was given, to hear the reactions to the inside references. Pretty clever! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 16, 2001 9:35 AM To: Multiple recipients of list ORACLE-L I am NOT the guy who beats up calculators. I might slip stick them a bit. Interesting concept. Almost like the NorthStar from american car monitoring and trying to control what you do. ROR mô¿ôm [EMAIL PROTECTED] 08/15/01 06:43PM Well, if the subject didn't cause you to delete this message out of hand, you're in for a treat. This is very funny, in a geeky sort of fashion. If you know anything at all about cryptography, you'll appreciate this. http://www.conceptlabs.co.uk/alicebob.html Jared -- 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: 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). -- 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).
RE: VB vs. JAVA
Hint: There may be a good java book coming out in december. Just a guess. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 9:42 AM To: Multiple recipients of list ORACLE-L Thanks Chris, your input is appreciated. Can anybody recommend any good java programming books, specficially something designed at working with Oracle 8i ? Thanks, Michael. -Original Message- [mailto:X] Sent: Thursday, 16 August 2001 11:18 PM To: X Well whoever you are talking to probably is vaugely familiar with java. Java's execution speed is fairly close but not quite to C++. Although there is a large delay in the initial interperation as well as graphical interfaces. Java also uses more resources. So basically, on a client workstation, java appears to be slow. In this case is very well can be considered as such. But on a server, where the startup time taking 2 minutes to compile and start all the code isn't a big deal when it is left running for days and week after. This is where the performance problem is moot. Java offers a lot, for example persistence in which you can make an application perform quite well, and avoid the need to constantly hit the database. Properly used, in the proper place, java is quite fast. Used for things which it is not suitable for, java can be unbearable. Although 1.3 and 1.4 JDK have made noticable improvements on the swing library (which is the reason java is slow on gui) which helps a lot when dealing with graphical programs, but still is not what most people are used to seeing in terms of performance. But I have seen very complicated such as jbuilder and such written completely in java perform satisfactory using completely java. I have also seen very small swing programs perform very poorly. Swing programming is an art, and although performance is not what c++ is for gui, the way you code it can make it look good or poor. In short, java is not slow. But it does have a slow load time, graphical interface coding is slow, and it does require more resources in terms of memory. But you gain many things, a very nicely written language, persistence, true object oriented programming, rad, and true cross platform development. Not everything has to be written in assembly. When performance is the utmost concern, then there is c/c+ to fall back to. But Orion, which is one of the fastest webservers/app servers out there, is complete Java coded. Granted it takes 10 seconds for it to load, but after that, zip zip. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 2:15 AM To: Multiple recipients of list ORACLE-L I hear a lot of bad things about Java, mostly in regards to speed. I'm wondering if there's anybody out there with experience in numerous programming langauges (including Java) that wouldn't mind giving their opinion about wether or not java is the best option for the job? ta michael -Original Message- fatcity] [mailto:X] Sent: Thursday, 16 August 2001 7:20 AM To: X Basked on my limited knowledge, you'd go a long way with java and oracle, that's where Oracle is pushing everyone anyway. I doubt how cold it will be on his each when Oracle will recommend to drop java and start using VB. If you use VB, you have to use ODBC, with java client JDBC. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San
RE: VB vs. JAVA
Well, I'd have to recommend Professional Oracle 8i Application Programming 'cos I wrote some of it :0) If you're completely new to Java, there are tutorials available for free on http://java.sun.com/ - learn the language first, then maybe start on JDBC (which is very simple) and then advanced things like EJB. For fun, there's Java3D. Good luck! g -Original Message- Sent: Thursday, August 16, 2001 2:42 PM To: Multiple recipients of list ORACLE-L Thanks Chris, your input is appreciated. Can anybody recommend any good java programming books, specficially something designed at working with Oracle 8i ? Thanks, Michael. -Original Message- [mailto:X] Sent: Thursday, 16 August 2001 11:18 PM To: X Well whoever you are talking to probably is vaugely familiar with java. Java's execution speed is fairly close but not quite to C++. Although there is a large delay in the initial interperation as well as graphical interfaces. Java also uses more resources. So basically, on a client workstation, java appears to be slow. In this case is very well can be considered as such. But on a server, where the startup time taking 2 minutes to compile and start all the code isn't a big deal when it is left running for days and week after. This is where the performance problem is moot. Java offers a lot, for example persistence in which you can make an application perform quite well, and avoid the need to constantly hit the database. Properly used, in the proper place, java is quite fast. Used for things which it is not suitable for, java can be unbearable. Although 1.3 and 1.4 JDK have made noticable improvements on the swing library (which is the reason java is slow on gui) which helps a lot when dealing with graphical programs, but still is not what most people are used to seeing in terms of performance. But I have seen very complicated such as jbuilder and such written completely in java perform satisfactory using completely java. I have also seen very small swing programs perform very poorly. Swing programming is an art, and although performance is not what c++ is for gui, the way you code it can make it look good or poor. In short, java is not slow. But it does have a slow load time, graphical interface coding is slow, and it does require more resources in terms of memory. But you gain many things, a very nicely written language, persistence, true object oriented programming, rad, and true cross platform development. Not everything has to be written in assembly. When performance is the utmost concern, then there is c/c+ to fall back to. But Orion, which is one of the fastest webservers/app servers out there, is complete Java coded. Granted it takes 10 seconds for it to load, but after that, zip zip. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 2:15 AM To: Multiple recipients of list ORACLE-L I hear a lot of bad things about Java, mostly in regards to speed. I'm wondering if there's anybody out there with experience in numerous programming langauges (including Java) that wouldn't mind giving their opinion about wether or not java is the best option for the job? ta michael -Original Message- fatcity] [mailto:X] Sent: Thursday, 16 August 2001 7:20 AM To: X Basked on my limited knowledge, you'd go a long way with java and oracle, that's where Oracle is pushing everyone anyway. I doubt how cold it will be on his each when Oracle will recommend to drop java and start using VB. If you use VB, you have to use ODBC, with java client JDBC. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--
Oracle/SAP DBA Needed in Clifton, New Jersey..
If you're interested in a great opportunity, then consider this position in Clifton, New Jersey that needs an Oracle/SAP DBA to join its' I.T. staff. This is a full time staff position so no sub-contractors or third parties please. Please do not call or send a resume if you are not in the U.S. and/or need sponsorship. * Requirements: - A degree in C.S. or equivalent - Solid Oracle/SAP DBA experience with 4.6B or higher is needed - Unix..HP preferred - Experience with: Security, BW, or IPO-Openview is desired - Must have good communication skills - U.S. citizenship or permanent residency required This position is with a company that offers : * Quality Work Environment * Base salary up to 90K * Financial Stability * Relocation Assistance NO sub contracting positions available. PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume to: Email: [EMAIL PROTECTED] Phone: 1-800-549-8502. * Please use job code: One/Clifton/DBA/Tolino We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law OraStaff, Inc-The Proven Connection To Oracle Opportunity -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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 C compiler a must for oracle UNIX installations ?
Rahul, All UNIX OS's come with a rudimentary C compiler and linker, mainly for the purpose of rebuilding the kernel. What Oracle needs is the make utility and the linker. The compiler is only needed if your building a program from source code and since Oracle ships object code it needs to relink. But that rudimentary linker will work just fine. Dick Goulet Reply Separator Author: Rahul [EMAIL PROTECTED] Date: 8/15/2001 9:35 PM some of my friends are telling me that they have succesfuly installed oracle 7.3.1 on AIX 4 WITHOUT the C compiler present.. !! and i was the one telling them how oralce requires to relink the executables after the installation. Regards -- 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). -- 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).
An icon of the Geek world retires
** Egghead Files For Chapter 11 Egghead.com Inc. has filed for Chapter 11 bankruptcy protection and laid off 200 employees. The online computer and electronics retailer was felled by weak consumer computer sales and wary Wall Street investors. The Menlo Park, Calif., retailer will sell its domain name and other unspecified assets to traditional retailer Fry's Electronics Inc., according to a company statement. Fry's will continue to operate the E-commerce Web site under the Egghead name. Egghead.com CEO Jeff Sheahan, in a written statement, said he regretted the move, which he blamed on a dramatic and unexpected decline in sales. Jupiter Research analyst Ken Cassar says that at one time, Egghead was the leader of distressed computers and electronics, as failing companies liquidated their computer assets at its site. But over the past year or so, Overstock.com has emerged as a real competitor, says Cassar. Egghead stock Wednesday fell from 33 cents to 3 cents a share, before trading was halted at mid-day. - Elisabeth Goodridge For background on this story, read Internet Death Rate Levels Off http://update.informationweek.com/cgi-bin4/flo?y=eEEq0BdFGA0V20PeI0AK A Supercomputing Star--And Why It Fell http://update.informationweek.com/cgi-bin4/flo?y=eEEq0BdFGA0V20RHu0Ab Webby Awards Celebrate Best Sites http://update.informationweek.com/cgi-bin4/flo?y=eEEq0BdFGA0V20RHv0Ac -- 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).
8.1.6 support cut off?
Hi list, Does anyone have the word on when Oracle plans to discontinue support for Oracle 8.1.6? Cheers 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).
Oracle DBA Needed in Greensboro, North Carolina..
This Textiles Client in Greensboro, North Carolina needs an Oracle DBA to join its' I.T. staff. This is a Jr/Mid level position. * Candidates local to the Greensboro-Burlington area only will be considered. This is a full time staff position so no sub-contractors or third parties please. Please do not call or send a resume if you are not in the U.S. and/or need sponsorship. * Required Skills: -Oracle 8i DBA experience on Unix -Degree Required -U.S. citizenship These positions offer: * Stability * The opportunity to become a key member of the team. * Base salary of 70K-D.O.E...maybe more PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] ph: 1-800 -549-8502 Please use job code:One/Greensboro/DBA/Hall Candidates who we are interested in will be contacted immediately. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: OT: cryptography speech
[EMAIL PROTECTED] wrote: what's missing!! Is it doing this to embarrass and annoy me or am I just being paranoid (and if I'm going to be nuts I'd rather be paranoid than a single-noid). just because you're paranoid doesn't mean they're not out to get you.;-) -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] One ping to rule them all, One ping to find them, One ping to bring them all, And in the MUTX bind them. Any given program will expand to fill available memory. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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 sql
Statistics can in fact hurt. If your queries are tuned for rule based optimizer, it is very possible that cost base will perform suboptimal, perhaps a little, perhaps a lot. You may need to tune the database to be more efficient for CBO by changing parameters. Although adding statistics and removing them if it doesn't work won't hurt a thing, is a good thing to try. Just noting that statistics can degrade performance of a queries/query. Just something to keep in mind. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, August 16, 2001 10:54 AM To: Multiple recipients of list ORACLE-L Yesterday I had a developer complain about a SQL select statment with subquery that was taking 10 minutes to run. I fixed it by generating new statistics: ANALYZE TABLE table_name COMPUTE STATISTICS; It took about an hour and a half to run on this particular table but now the query takes 30 seconds. Give it a try on all the tables in your SQL if you're using cost-based optimizer. It can't hurt. HTH Ed -Original Message- Sent: Thursday, August 16, 2001 5:46 AM To: Multiple recipients of list ORACLE-L Hallo you DBA'¨s Can anyonetell me why this insert statement takes 30-40 minutes to run? What can I do to make it go faster? insert into varukorgtemp ( varukorgid, ean, anvandarid, lagstapris, varutyp, varunamn, strl, leverantor, varumarke, sortiment,vgrp,vare_snr,varenr,levnr ) SELECT PBK.VARUKORGEANREL.varukorgid, rik2.vare.ean_nr, 'rsm' , PBK.VARUKORGEANREL.lagstapris, 0, rik2.vare.varenavn, rik2.vare.str, rik2.lev.navn, rik2.vare.hylletxt2, rik2.vare.sortiment,rik2.art_hierarki.vgrp, pbk.varukorgeanrel.vare_snr,pbk.varukorgeanrel.varenr,pbk.varukorgeanrel.lev nr FROM PBK.VARUKORGEANREL,rik2.vare,rik2.lev,rik2.art_hierarki WHERE PBK.VARUKORGEANREL.varukorgid= 39 AND PBK.VARUKORGEANREL.ean=rik2.vare.ean_nr AND RIK2.VARE.ARTNR=RIK2.ART_HIERARKI.ARTNR AND rik2.vare.levnr=rik2.lev.levnr AND rik2.vare.selskap='11' AND rik2.vare.vare_snr=pbk.varukorgeanrel.vare_snr AND pbk.varukorgeanrel.varenr=rik2.vare.varenr AND pbk.varukorgeanrel.levnr=rik2.vare.levnr AND rik2.art_hierarki.sett_id=2 Sincerely Roland Sköldblom -- 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward 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: Christopher Spence 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: Lost of all Control Files
-Mensaje original-De: Ramon Estevez [mailto:[EMAIL PROTECTED]]Enviado el: Thursday, 16 August, 2001 9:23 AMPara: '[EMAIL PROTECTED]'Asunto: RE: Lost of all Control Files Friends Thanks to all of you helped me with the problem. The create controlfile worked fine, but the system tablespace needed recovery and unfortunately the archives were corrupted too. I just paid my price. Gracias, Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -Mensaje original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Vergara, Michael (TEM)Enviado el: Wednesday, 15 August, 2001 4:42 PMPara: Multiple recipients of list ORACLE-LAsunto: RE: Lost of all Control Files Ramon: Here's a copy of the script generated by the 'alter database backup controlfile to trace' command on my sandbox machine. Basically, you trim off everything above the 'STARTUP MOUNT' command, start svrmgrl, and execute the script. Remember, you need to put in your own database name, path names, and file names. If you don't know your database's file locations you'll have to go hunting. This is for an 8.1.6 database - I forget what version you're using. The only significant difference will be the 'ADD TEMPFILE' command at the end - that is for 8iR2 and higher. I recommend that since you're unfamiliar with this technique, that you create a test database, delete the control files, and practice running this script there until you're confident that you can run it against production. Good Luck! Mike rhc117:oracle8 cat ora_5472_dba2.trcDump file /ofa/u02/app/oracle/admin/DBA2/udump/ora_5472_dba2.trcOracle8i Enterprise Edition Release 8.1.6.0.0 - ProductionWith the Partitioning optionJServer Release 8.1.6.0.0 - ProductionORACLE_HOME = /ofa/u02/app/oracle/product/8.1.6System name: HP-UXNode name: rhc117Release: B.11.00Version: AMachine: 9000/777Instance name: DBA2Redo thread mounted by this instance: 1Oracle process number: 11Unix process pid: 5472, image: oracle@rhc117 *** SESSION ID:(10.1) 2001-05-16 16:36:43.683*** 2001-05-16 16:36:43.683# The following commands will create a new control file and use it# to open the database.# Data used by the recovery manager will be lost. Additional logs may# be required for media recovery of offline data files. Use this# only if the current version of all online logs are available.STARTUP NOMOUNTCREATE CONTROLFILE REUSE DATABASE "DBA2" NORESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 255 MAXINSTANCES 8 MAXLOGHISTORY 907LOGFILE GROUP 1 ( '/ofa/u01/oradata/oralog1a/DBA2/redo01a.log', '/ofa/u01/oradata/oralog1b/DBA2/redo01b.log' ) SIZE 5M, GROUP 2 ( '/ofa/u01/oradata/oralog2a/DBA2/redo02a.log', '/ofa/u01/oradata/oralog2b/DBA2/redo02b.log' ) SIZE 5M, GROUP 3 ( '/ofa/u01/oradata/oralog1a/DBA2/redo03a.log', '/ofa/u01/oradata/oralog1b/DBA2/redo03b.log' ) SIZE 5M, GROUP 4 ( '/ofa/u01/oradata/oralog2a/DBA2/redo04a.log', '/ofa/u01/oradata/oralog2b/DBA2/redo04b.log' ) SIZE 5MDATAFILE '/ofa/u01/oradata/DBA2/system01.dbf', '/ofa/u01/oradata/DBA2/rbs01.dbf', '/ofa/u02/oradata/DBA2/users01.dbf'CHARACTER SET US7ASCII;# Recovery is required if any of the datafiles are restored backups,# or if the last shutdown was not normal or immediate.RECOVER DATABASE# All logs need archiving and a log switch is needed.ALTER SYSTEM ARCHIVE LOG ALL;# Database can now be opened normally.ALTER DATABASE OPEN;# Commands to add tempfiles to temporary tablespaces.# Online tempfiles have complete space information.# Other tempfiles may require adjustment.ALTER TABLESPACE TEMP ADD TEMPFILE '/ofa/u01/oradata/DBA2/temp01.dbf' REUSE;# End of tempfile additions.#rhc117:oracle8 --- === Michael P. Vergara Oracle DBA Guidant Corporation (909) 914-2304
OT Slam for the day: Re: Oracle DBA Needed in Greensboro,
why bother sending these things to the list, when there are SO MANY RESTRICTIONS, its a waste of bandwidth more than anything else. NO aliens(foreigners or the outer space kind), NO one unless you live there, NO subcontractors, NO one with green eyes, NO one who has ever known anyone who lives outside NC, NO one who has ever thought about living outside NC and they have to be 9i OCP with 2 years of using 9i. joe [EMAIL PROTECTED] 08/16/01 11:00AM This Textiles Client in Greensboro, North Carolina needs an Oracle DBAto join its' I.T. staff. This is a Jr/Mid level position.* Candidates local to the Greensboro-Burlington area only will be considered.This is a full time staff position so no sub-contractors or third partiesplease.Please do not call or send a resume if you are not in the U.S. and/or need sponsorship.* Required Skills:-Oracle 8i DBA experience on Unix-Degree Required-U.S. citizenshipThese positions offer: * Stability * The opportunity to become a key member of the team. * Base salary of 70K-D.O.E...maybe more PLEASE do not send your resume if you are not in the United States.For immediate consideration, please send your resume as a Word attachment to:OraStaff, Inc.Email: [EMAIL PROTECTED]ph: 1-800 -549-8502Please use job code:One/Greensboro/DBA/HallCandidates who we are interested in will be contacted immediately.*We pay referral fees.So please contact me if you know of anyone who would be qualified/interestedin the posiitiondescribed above- if it is not a match for your skills.Thanks,Bill Law--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: OraStaff INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: 8.1.6 support cut off?
They did already, they just still take phone calls. Oracle drops support the day the release the product. ;) Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, August 16, 2001 11:01 AM To: Multiple recipients of list ORACLE-L Hi list, Does anyone have the word on when Oracle plans to discontinue support for Oracle 8.1.6? Cheers 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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]: Datafile Migration Tool
Imports/exports only use about 1/10 of your available sustained io generally. Although direct exports are noticably faster and less stress on the database. Locking, rollback generation, constraints, triggers can affect the performance of the import/export process as well. Also network io if it isn't a local export/import. Direct path exports do not effect the speed of imports. Unless your using SQLLDR direct. Direct path exports only effect the speed in which the export is created and the resources it uses. Conventional exports are cpu bound, where direct path exports are io bound. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, August 16, 2001 9:18 AM To: Multiple recipients of list ORACLE-L Alex, It's tough to guess how long an import will take. It all depends on how many indexes and constraints you have - these are what take the most time at import time. The data gets sucked in real fast. Using Direct Load really speeds the import up but, again, rebuilding the indexes takes forever. Gene is correct in that export is extremely fast. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, August 15, 2001 7:01 PM To: Multiple recipients of list ORACLE-L Alex - you must be joking, 60hrs? i get ~1gb/3mins for export. i haven't done an import lately, but its not that bad. exp/imp are great tools to move data around. gene [EMAIL PROTECTED] 08/15/01 06:08PM exp/imp does not work(takes too much time)for large databases. How long do you think import will take for 200G database? - about 60 hours? Alex Hillman -Original Message- Sent: Tuesday, August 14, 2001 5:03 PM To: Multiple recipients of list ORACLE-L Rachel, I can see what he is proposing, but I'm not sure anyone would care. I know I can't take the datafiles from one of our HP-UX servers and use them to create a database on NT for instance. Wish I could for our Support Magic junk. In that case they do a bunch of things (like create objects) as SYS which never get included in an export. The problem that I see is that there is a toolset that currently exists, namely export import, that work cross platform with no problems. Just not at the datafile level. And although that type of tool would be interesting to me it would not be of much value since I've only the one problem. Dick Goulet Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 8/14/2001 12:41 PM it doesn't sound like an ftp type tool. If I am reading this correctly, he is proposing to provide a tool that copies datafiles directly from one OS to another. While this is an interesting trick, I'm not sure there's a large market for it. From: Scott Shafer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Datafile Migration Tool Date: Tue, 14 Aug 2001 12:00:53 -0800 Not to be a smartass, but don't most OS's already have ftp built in? What kind of value-added are you proposing? Just curious... Scott Shafer San Antonio, TX K Gopalakrishnan wrote: Hi , Will there be a market if I give a tool which migrates Oracle database from One OS to another OS. (Data file migration at Operating System Level.) i.e it will convert from Oracle data files on NT to Oracle Datafiles on Solaris and vice versa. In the target database you need to recreate the control files and you are done. You can startup the database. You don't need to export/import or CTAS over dblink.. Send your replies directly to me.. Thanks Yong..for bringing the cat out of the basket ;) = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer 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 download of MSN Explorer at
RE: OT: cryptography speech
One good reason for this is: What happens if it did put from there? Now your going to write scripts, make that same mistake, the database is going to fix it for you. Your going to port/share your scripts, and someone else's database won't be so helpful, they are not going to want to dig through the problem. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, August 16, 2001 10:46 AM To: Multiple recipients of list ORACLE-L Funny. I liked the self-referential acronym bit. I don't like computers (or computer languages or OSs) that know what I want to do but refuse to do it. An example from our own wonderful SQLPlus: SQL select table_name sys.dba_tables; select table_name sys.dba_tables * ERROR at line 1: ORA-00923: FROM keyword not found where expected Now why doesn't it just put the FROM in and get on with it? It knows what's missing!! Is it doing this to embarrass and annoy me or am I just being paranoid (and if I'm going to be nuts I'd rather be paranoid than a single-noid). Ron Rogers RROGERS@galoTo: Multiple recipients of list ORACLE-L ttery.org [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Re: OT: cryptography speech com 08/16/2001 09:35 AM Please respond to ORACLE-L I am NOT the guy who beats up calculators. I might slip stick them a bit. Interesting concept. Almost like the NorthStar from american car monitoring and trying to control what you do. ROR mô¿ôm [EMAIL PROTECTED] 08/15/01 06:43PM Well, if the subject didn't cause you to delete this message out of hand, you're in for a treat. This is very funny, in a geeky sort of fashion. If you know anything at all about cryptography, you'll appreciate this. http://www.conceptlabs.co.uk/alicebob.html Jared -- 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: 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). -- 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: Christopher Spence 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).
changing long col to varchar and vice versa
Hi list, I want to change col-types in one table. I have table T1 with two columns COL1 LONG and COL2 VARCHAR2(2000). Now I want to change the col-types vice versa, that means COL1 should be VARCHAR2(2000) and COL2 should be LONG. I have a lot of data in that cols, but all data is smaller than 2000 characters. Could someone tell how to convert these columns? TIA Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker 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: OT: cryptography speech
Very dangerous. Like, Captain Kirk might say, Mr. Spock, cancel the self destruct sequence so Mr. Spock goes to his SQL*Plus terminal and types: SQL ALTER STARSHIP SET AUTODESTRUCT But at that moment, Dr McCoy walks in, slips in a puddle of Romulan Ale and grabs Mr. Spock for support, whose finger slips on to the ENTER key. The Enterprise replies: ERROR at line 1: ORA-435334: keyword not found where expected, substituting ON to continue... :0) g -Original Message- Sent: Thursday, August 16, 2001 3:46 PM To: Multiple recipients of list ORACLE-L Funny. I liked the self-referential acronym bit. I don't like computers (or computer languages or OSs) that know what I want to do but refuse to do it. An example from our own wonderful SQLPlus: SQL select table_name sys.dba_tables; select table_name sys.dba_tables * ERROR at line 1: ORA-00923: FROM keyword not found where expected Now why doesn't it just put the FROM in and get on with it? It knows what's missing!! Is it doing this to embarrass and annoy me or am I just being paranoid (and if I'm going to be nuts I'd rather be paranoid than a single-noid). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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: 8.1.6 support cut off?
Oracle Support ServicesProduct Obsolescence andDesupport NoticeOctober 2000Product / Platform: Oracle8i, Release 2 (8.1.6) Error Correction Support ends on: 31 October 2001Extended Assistance Support ends on: 31 October 2004 Product Obsolescence / Desupport Summary:Oracle Corporation announces the end of Error Correction Support for Oracle8i, Release 2 (8.1.6) on all platforms, effective 31 October 2001. Oracle recommends that customers upgrade to Oracle8i, Release 3, (Oracle 8.1.7), as soon as possible to maintain the highest level of support for their products and systems. [EMAIL PROTECTED] 08/16/01 11:00AM Hi list,Does anyone have the "word" on when Oracle plans to "discontinue" supportfor Oracle 8.1.6?CheersMark===Mark Leith | T: +44 (0)1905 330 281Sales Marketing | F: +44 (0)870 127 5283Cool 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: OT Slam for the day: Re: Oracle DBA Needed in Greensboro,
-This Textiles Client in Greensboro, North Carolina needs an Oracle DBA Working for a textiles client in the US sounds like good job security!! Maybe the next job they have will be for a steel mill client in Bethlehem PA. ;-) Dave -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001 10:23 AMTo: Multiple recipients of list ORACLE-LSubject: OT Slam for the day: Re: Oracle DBA Needed in Greensboro, why bother sending these things to the list, when there are SO MANY RESTRICTIONS, its a waste of bandwidth more than anything else. NO aliens(foreigners or the outer space kind), NO one unless you live there, NO subcontractors, NO one with green eyes, NO one who has ever known anyone who lives outside NC, NO one who has ever thought about living outside NC and they have to be 9i OCP with 2 years of using 9i. joe [EMAIL PROTECTED] 08/16/01 11:00AM This Textiles Client in Greensboro, North Carolina needs an Oracle DBAto join its' I.T. staff. This is a Jr/Mid level position.* Candidates local to the Greensboro-Burlington area only will be considered.This is a full time staff position so no sub-contractors or third partiesplease.Please do not call or send a resume if you are not in the U.S. and/or need sponsorship.* Required Skills:-Oracle 8i DBA experience on Unix-Degree Required-U.S. citizenshipThese positions offer: * Stability * The opportunity to become a key member of the team. * Base salary of 70K-D.O.E...maybe more PLEASE do not send your resume if you are not in the United States.For immediate consideration, please send your resume as a Word attachment to:OraStaff, Inc.Email: [EMAIL PROTECTED]ph: 1-800 -549-8502Please use job code:One/Greensboro/DBA/HallCandidates who we are interested in will be contacted immediately.*We pay referral fees.So please contact me if you know of anyone who would be qualified/interestedin the posiitiondescribed above- if it is not a match for your skills.Thanks,Bill Law--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: OraStaff INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: OT Slam for the day: Re: Oracle DBA Needed in Greensboro,
Title: Message Why, I think that is good being up front so you know not to waste time if it doesn't fit you. Too many jobs don't say anything, you apply and go through an interview and then they tell you, well we are looking for this or that. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 11:23 AMTo: Multiple recipients of list ORACLE-LSubject: OT Slam for the day: Re: Oracle DBA Needed in Greensboro, why bother sending these things to the list, when there are SO MANY RESTRICTIONS, its a waste of bandwidth more than anything else. NO aliens(foreigners or the outer space kind), NO one unless you live there, NO subcontractors, NO one with green eyes, NO one who has ever known anyone who lives outside NC, NO one who has ever thought about living outside NC and they have to be 9i OCP with 2 years of using 9i. joe [EMAIL PROTECTED] 08/16/01 11:00AM This Textiles Client in Greensboro, North Carolina needs an Oracle DBAto join its' I.T. staff. This is a Jr/Mid level position.* Candidates local to the Greensboro-Burlington area only will be considered.This is a full time staff position so no sub-contractors or third partiesplease.Please do not call or send a resume if you are not in the U.S. and/or need sponsorship.* Required Skills:-Oracle 8i DBA experience on Unix-Degree Required-U.S. citizenshipThese positions offer: * Stability * The opportunity to become a key member of the team. * Base salary of 70K-D.O.E...maybe more PLEASE do not send your resume if you are not in the United States.For immediate consideration, please send your resume as a Word attachment to:OraStaff, Inc.Email: [EMAIL PROTECTED]ph: 1-800 -549-8502Please use job code:One/Greensboro/DBA/HallCandidates who we are interested in will be contacted immediately.*We pay referral fees.So please contact me if you know of anyone who would be qualified/interestedin the posiitiondescribed above- if it is not a match for your skills.Thanks,Bill Law--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: OraStaff INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: 8.1.6 support cut off?
Doc id: Note:123178.1 Subject: Oracle8i, Release 2 (8.1.6.) Desupport Notice Type: DESUPPORT Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 26-OCT-2000 Last Revision Date: 21-NOV-2000 Oracle Support Services Product Obsolescence and Desupport Notice October 2000 Product / Platform: Oracle8i, Release 2 (8.1.6) Error Correction Support ends on: 31 October 2001 Extended Assistance Support ends on:31 October 2004 -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 11:01 AM To: Multiple recipients of list ORACLE-L Subject: 8.1.6 support cut off? Hi list, Does anyone have the word on when Oracle plans to discontinue support for Oracle 8.1.6? Cheers 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce 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: OT: cryptography speech
Title: RE: OT: cryptography speech Even paranoids have enemies Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 11:08 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT: cryptography speech [EMAIL PROTECTED] wrote: what's missing!! Is it doing this to embarrass and annoy me or am I just being paranoid (and if I'm going to be nuts I'd rather be paranoid than a single-noid). just because you're paranoid doesn't mean they're not out to get you.;-) -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] -- -- One ping to rule them all, One ping to find them, One ping to bring them all, And in the MUTX bind them. -- -- Any given program will expand to fill available memory. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: 8.1.6 support cut off?
Title: RE: 8.1.6 support cut off? According to docs I saw on metalink about 6 months ago Error Correction support ends Oct 31, 2001, Extended support ends Oct 31, 2004 Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 11:01 AM To: Multiple recipients of list ORACLE-L Subject: 8.1.6 support cut off? Hi list, Does anyone have the word on when Oracle plans to discontinue support for Oracle 8.1.6? Cheers 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: Lost of all Control Files
"I just paid my price." We all feel your pain. Tom Mercadante Oracle Certified Professional -Original Message-From: Ramon Estevez [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001 11:23 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Lost of all Control Files -Mensaje original-De: Ramon Estevez [mailto:[EMAIL PROTECTED]]Enviado el: Thursday, 16 August, 2001 9:23 AMPara: '[EMAIL PROTECTED]'Asunto: RE: Lost of all Control Files Friends Thanks to all of you helped me with the problem. The create controlfile worked fine, but the system tablespace needed recovery and unfortunately the archives were corrupted too. I just paid my price. Gracias, Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -Mensaje original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Vergara, Michael (TEM)Enviado el: Wednesday, 15 August, 2001 4:42 PMPara: Multiple recipients of list ORACLE-LAsunto: RE: Lost of all Control Files Ramon: Here's a copy of the script generated by the 'alter database backup controlfile to trace' command on my sandbox machine. Basically, you trim off everything above the 'STARTUP MOUNT' command, start svrmgrl, and execute the script. Remember, you need to put in your own database name, path names, and file names. If you don't know your database's file locations you'll have to go hunting. This is for an 8.1.6 database - I forget what version you're using. The only significant difference will be the 'ADD TEMPFILE' command at the end - that is for 8iR2 and higher. I recommend that since you're unfamiliar with this technique, that you create a test database, delete the control files, and practice running this script there until you're confident that you can run it against production. Good Luck! Mike rhc117:oracle8 cat ora_5472_dba2.trcDump file /ofa/u02/app/oracle/admin/DBA2/udump/ora_5472_dba2.trcOracle8i Enterprise Edition Release 8.1.6.0.0 - ProductionWith the Partitioning optionJServer Release 8.1.6.0.0 - ProductionORACLE_HOME = /ofa/u02/app/oracle/product/8.1.6System name: HP-UXNode name: rhc117Release: B.11.00Version: AMachine: 9000/777Instance name: DBA2Redo thread mounted by this instance: 1Oracle process number: 11Unix process pid: 5472, image: oracle@rhc117 *** SESSION ID:(10.1) 2001-05-16 16:36:43.683*** 2001-05-16 16:36:43.683# The following commands will create a new control file and use it# to open the database.# Data used by the recovery manager will be lost. Additional logs may# be required for media recovery of offline data files. Use this# only if the current version of all online logs are available.STARTUP NOMOUNTCREATE CONTROLFILE REUSE DATABASE "DBA2" NORESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 255 MAXINSTANCES 8 MAXLOGHISTORY 907LOGFILE GROUP 1 ( '/ofa/u01/oradata/oralog1a/DBA2/redo01a.log', '/ofa/u01/oradata/oralog1b/DBA2/redo01b.log' ) SIZE 5M, GROUP 2 ( '/ofa/u01/oradata/oralog2a/DBA2/redo02a.log', '/ofa/u01/oradata/oralog2b/DBA2/redo02b.log' ) SIZE 5M, GROUP 3 ( '/ofa/u01/oradata/oralog1a/DBA2/redo03a.log', '/ofa/u01/oradata/oralog1b/DBA2/redo03b.log' ) SIZE 5M, GROUP 4 ( '/ofa/u01/oradata/oralog2a/DBA2/redo04a.log', '/ofa/u01/oradata/oralog2b/DBA2/redo04b.log' ) SIZE 5MDATAFILE '/ofa/u01/oradata/DBA2/system01.dbf', '/ofa/u01/oradata/DBA2/rbs01.dbf', '/ofa/u02/oradata/DBA2/users01.dbf'CHARACTER SET US7ASCII;# Recovery is required if any of the datafiles are restored backups,# or if the last shutdown was not normal or immediate.RECOVER DATABASE# All logs need archiving and a log switch is needed.ALTER SYSTEM ARCHIVE LOG ALL;# Database can now be opened normally.ALTER DATABASE OPEN;# Commands to add tempfiles to temporary tablespaces.# Online tempfiles have complete space information.# Other tempfiles may require adjustment.ALTER TABLESPACE TEMP ADD TEMPFILE '/ofa/u01/oradata/DBA2/temp01.dbf' REUSE;# End of tempfile additions.#rhc117:oracle8 --- === Michael P. Vergara Oracle DBA Guidant Corporation (909) 914-2304
RE: Re[2]: Datafile Migration Tool
Imports/exports only use about 1/10 of your available sustained io generally. Although direct exports are noticably faster and less stress on the database. And why do we need to read this? Locking, rollback generation, constraints, triggers can affect the performance of the import/export process as well. Also network io if it isn't a local export/import. Again - why do we need to read this? Any person even little knowlegeble in Oracle DBA knows this Direct path exports do not effect the speed of imports. Unless your using SQLLDR direct. Direct path exports only effect the speed in which the export is created and the resources it uses. SQLLDR cannot use sxport dump file as a source Conventional exports are cpu bound, where direct path exports are io bound. Who told you so? Alex Hillman -Original Message- Sent: Thursday, August 16, 2001 11:28 AM To: Multiple recipients of list ORACLE-L Imports/exports only use about 1/10 of your available sustained io generally. Although direct exports are noticably faster and less stress on the database. Locking, rollback generation, constraints, triggers can affect the performance of the import/export process as well. Also network io if it isn't a local export/import. Direct path exports do not effect the speed of imports. Unless your using SQLLDR direct. Direct path exports only effect the speed in which the export is created and the resources it uses. Conventional exports are cpu bound, where direct path exports are io bound. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, August 16, 2001 9:18 AM To: Multiple recipients of list ORACLE-L Alex, It's tough to guess how long an import will take. It all depends on how many indexes and constraints you have - these are what take the most time at import time. The data gets sucked in real fast. Using Direct Load really speeds the import up but, again, rebuilding the indexes takes forever. Gene is correct in that export is extremely fast. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, August 15, 2001 7:01 PM To: Multiple recipients of list ORACLE-L Alex - you must be joking, 60hrs? i get ~1gb/3mins for export. i haven't done an import lately, but its not that bad. exp/imp are great tools to move data around. gene [EMAIL PROTECTED] 08/15/01 06:08PM exp/imp does not work(takes too much time)for large databases. How long do you think import will take for 200G database? - about 60 hours? Alex Hillman -Original Message- Sent: Tuesday, August 14, 2001 5:03 PM To: Multiple recipients of list ORACLE-L Rachel, I can see what he is proposing, but I'm not sure anyone would care. I know I can't take the datafiles from one of our HP-UX servers and use them to create a database on NT for instance. Wish I could for our Support Magic junk. In that case they do a bunch of things (like create objects) as SYS which never get included in an export. The problem that I see is that there is a toolset that currently exists, namely export import, that work cross platform with no problems. Just not at the datafile level. And although that type of tool would be interesting to me it would not be of much value since I've only the one problem. Dick Goulet Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 8/14/2001 12:41 PM it doesn't sound like an ftp type tool. If I am reading this correctly, he is proposing to provide a tool that copies datafiles directly from one OS to another. While this is an interesting trick, I'm not sure there's a large market for it. From: Scott Shafer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Datafile Migration Tool Date: Tue, 14 Aug 2001 12:00:53 -0800 Not to be a smartass, but don't most OS's already have ftp built in? What kind of value-added are you proposing? Just curious... Scott Shafer San Antonio, TX K Gopalakrishnan wrote: Hi , Will there be a market if I give a tool which migrates Oracle database from One OS to another OS. (Data file migration at Operating System Level.) i.e it will convert from Oracle data files on NT to Oracle Datafiles on Solaris and vice versa. In the target database you need to recreate the control files and you are done. You can startup the database. You don't need to export/import or CTAS over dblink.. Send your replies directly to me.. Thanks Yong..for bringing the cat out of the basket ;) = Have a nice day !! Best Regards, K Gopalakrishnan,
Re: Migrating IMS to Oracle
IMS is a hierarchical database, not relational. It is also quite old technology. I doubt Oracle will have any conversion tools for that. I started my career working with IMS DB/DC in the late 70's. You will really need to design a new database from scratch and then convert and import data. I did several conversions from IMS to Oracle in the late 80's. You will have all the traditional challenges of going from a non-relational database with repeating fields, etc. What's the front-end? I assume that will need to be rewritten as well. The most common front-end for IMS was COBOL programs running under IMS/DC or CICS. If you have access to DB2, I know IBM had tools to convert from IMS to DB2. And I believe Oracle has tools to convert from DB2 to Oracle. So that's a potential option. But with any conversion tools, you will have to compromise with a good database design. Marc Perkowitz Senior Consultant TWJ Consulting, LLP 847-256-8866 x15 www.twjconsulting.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 16, 2001 8:48 AM I may be starting a project in the near future to migrate an IMS database to 8.1.? on Windows 2000. I would like to know if Oracle provides a tool to do this? Data profiling, mapping, etc.? I could not find anything for IMS on OTN or the Oracle site. I know there are some non-Oracle tools to do this. Any suggestions would be helpful. Thanks, Ken Janusz, CPIM -- 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: Marc Perkowitz 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: 8.1.6 support cut off?
The desupport notice states 10/31/2001, with extended support until 10/31/2004. It's on metallink. If you are an Oracle Applications customer, then support is extended until 3/1/2002. Mark Leith wrote: Hi list, Does anyone have the word on when Oracle plans to discontinue support for Oracle 8.1.6? Cheers 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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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: 8.1.6 support cut off?
Cheers Joe! Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: Thursday, August 16, 2001 16:16To: Multiple recipients of list ORACLE-LSubject: Re: 8.1.6 support cut off?Oracle Support ServicesProduct Obsolescence andDesupport NoticeOctober 2000Product / Platform: Oracle8i, Release 2 (8.1.6) Error Correction Support ends on: 31 October 2001Extended Assistance Support ends on: 31 October 2004Product Obsolescence / Desupport Summary:Oracle Corporation announces the end of Error Correction Support for Oracle8i, Release 2 (8.1.6) on all platforms, effective 31 October 2001. Oracle recommends that customers upgrade to Oracle8i, Release 3, (Oracle 8.1.7), as soon as possible to maintain the highest level of support for their products and systems. [EMAIL PROTECTED] 08/16/01 11:00AM Hi list,Does anyone have the "word" on when Oracle plans to "discontinue" supportfor Oracle 8.1.6?CheersMark===Mark Leith | T: +44 (0)1905 330 281Sales Marketing | F: +44 (0)870 127 5283Cool 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: OT: cryptography speech
Title: RE: OT: cryptography speech Think yourselves lucky, we're paranoid schizophrenics. They are all out to get us !! -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: 16 August 2001 16:36To: Multiple recipients of list ORACLE-LSubject: RE: OT: cryptography speech Even paranoids have enemies Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 11:08 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT: cryptography speech [EMAIL PROTECTED] wrote: what's missing!! Is it doing this to embarrass and annoy me or am I just being paranoid (and if I'm going to be "nuts" I'd rather be paranoid than a single-noid). just because you're paranoid doesn't mean they're not out to get you.;-) -- Bill "Shrek" Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] -- -- One ping to rule them all, One ping to find them, One ping to bring them all, And in the MUTX bind them. -- -- Any given program will expand to fill available memory. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
RE: Comment on 'Practical Oracle 8i'
-Original Message- From: Christopher Spence [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 1:16 AM To: Multiple recipients of list ORACLE-L Subject: Comment on 'Practical Oracle 8i' Well, I just got this book, and just started reading through it. Looks good so far. Just would like to comment on something I saw. Must say BookPool.com is so awesome. 40% off most books (which I bought three this time) and paid $4 for 5 day shipping yet I get it the next day on my doorstep. Got to love that. Page 28: I will quote: A greater number of slower CPU's is often better than a fewer number of faster ones. To some extent I believe this is true especially with the efficient use of caching in most OS's. But with the larger caches on unix cpu's, 4Mb, 8Mb. There is a loss of performance when a process runs on a cpu, then context switches and then placed on another cpu. All the cached tlb's are then sitting on another cpu and need to be reloaded. Although the os will try to reschedule recently run processes on the same cpu, that doesn't always happen on a busy system. Also the fact that faster cpu's return the processes back faster. Although on the other hand, with more cpu's, more can get done simultaneously but at a slower rate. And there would be fewer context switches with many more cpu's. You, of course are right. SMP is an overhead. The additional problem with the slower CPUs is that the bus on the machine is usually slower then on newer machines with the screamingly fast CPUs. Slower bus and oracle means that large scatter/gather ISO and memory requests will compete for the bus resources slowing the machine down. Interrupt arbitration (the time spent by the system bus (a.k.a. chipset) to decide which CPU should be honored by the pending interrupt) is also a huge drain on the slower buses. That can bring systems with the slower buses to the grinding halt. One needs buses and OSes which support memory mapped access (IntelliIO,NgenIO) and large quantities of IO per second all while featuring advanced CPU cache interconnects which will diminish the impact of cache synchronization on the system. It is worth noting that oracle, nd the same applies to all huge software systems, does not make very good or efficient use of CPU caches. With oracle, cache flushes and invalidations will happen frequently, as well as TLB invalidations and flushes. In order to behave well on virtual memory systems, it is necessary that the programs obey the locality of reference principle, which is very hard to do if you are using a huge software system written thousands of programmers and using thousands of subroutines. With oracle, modern super pipelined, super scalar chips with several execution streams will not do much. The thing that counts is the raw chip frequency and the speed of memory access (DDRAM,EDO,Rambus). To make a long story short, I do prefer a system with more fast CPUs over the system with fewer fast CPUs because the architecture improvements on the modern buses are amazing and must be used. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen 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: OT Slam for the day: Re: Oracle DBA Needed in Greensboro,
I agree with Joe. -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001 11:23 AMTo: Multiple recipients of list ORACLE-LSubject: OT Slam for the day: Re: Oracle DBA Needed in Greensboro, why bother sending these things to the list, when there are SO MANY RESTRICTIONS, its a waste of bandwidth more than anything else. NO aliens(foreigners or the outer space kind), NO one unless you live there, NO subcontractors, NO one with green eyes, NO one who has ever known anyone who lives outside NC, NO one who has ever thought about living outside NC and they have to be 9i OCP with 2 years of using 9i. joe [EMAIL PROTECTED] 08/16/01 11:00AM This Textiles Client in Greensboro, North Carolina needs an Oracle DBAto join its' I.T. staff. This is a Jr/Mid level position.* Candidates local to the Greensboro-Burlington area only will be considered.This is a full time staff position so no sub-contractors or third partiesplease.Please do not call or send a resume if you are not in the U.S. and/or need sponsorship.* Required Skills:-Oracle 8i DBA experience on Unix-Degree Required-U.S. citizenshipThese positions offer: * Stability * The opportunity to become a key member of the team. * Base salary of 70K-D.O.E...maybe more PLEASE do not send your resume if you are not in the United States.For immediate consideration, please send your resume as a Word attachment to:OraStaff, Inc.Email: [EMAIL PROTECTED]ph: 1-800 -549-8502Please use job code:One/Greensboro/DBA/HallCandidates who we are interested in will be contacted immediately.*We pay referral fees.So please contact me if you know of anyone who would be qualified/interestedin the posiitiondescribed above- if it is not a match for your skills.Thanks,Bill Law--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: OraStaff INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo 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).
A high-availability question (standby , replication or ....)
Dear gurus ! A customer wants to have a backup database on a remote in case of disaster site. That database needs to be as much in sync with the primary DB as possible, and a sort of failover must be implemented , i.e. if the primary site fails , the users will be AUTOMATICALLY routed to the secondary one . I thought of 2 possible approaches : multimaster asynchronous replication and a standby database. The problem is that AFAIK , there is no automatic failover in case of standby DB , i.e.. U need to issue ALTER DATABASE ACTIVATE STANDBY DATABASE; or something like that on a backup site. From the other hand multimaster replication sounds like a big headache . So , gurus , what would U suggest ? How do U implement HA on your sites ? Thanks a lot in advance for your time. Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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 sql
analyze the select statement that extracts the rows to be inserted. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 8/16/2001 1:45 AM Hallo you DBA's Can anyonetell me why this insert statement takes 30-40 minutes to run? What can I do to make it go faster? insert into varukorgtemp ( varukorgid, ean, anvandarid, lagstapris, varutyp, varunamn, strl, leverantor, varumarke, sortiment,vgrp,vare_snr,varenr,levnr ) SELECT PBK.VARUKORGEANREL.varukorgid, rik2.vare.ean_nr, 'rsm' , PBK.VARUKORGEANREL.lagstapris, 0, rik2.vare.varenavn, rik2.vare.str, rik2.lev.navn, rik2.vare.hylletxt2, rik2.vare.sortiment,rik2.art_hierarki.vgrp, pbk.varukorgeanrel.vare_snr,pbk.varukorgeanrel.varenr,pbk.varukorgean rel.levnr FROM PBK.VARUKORGEANREL,rik2.vare,rik2.lev,rik2.art_hierarki WHERE PBK.VARUKORGEANREL.varukorgid= 39 AND PBK.VARUKORGEANREL.ean=rik2.vare.ean_nr AND RIK2.VARE.ARTNR=RIK2.ART_HIERARKI.ARTNR AND rik2.vare.levnr=rik2.lev.levnr AND rik2.vare.selskap='11' AND rik2.vare.vare_snr=pbk.varukorgeanrel.vare_snr AND pbk.varukorgeanrel.varenr=rik2.vare.varenr AND pbk.varukorgeanrel.levnr=rik2.vare.levnr AND rik2.art_hierarki.sett_id=2 Sincerely Roland Sköldblom -- 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: OT Slam for the day: Re: Oracle DBA Needed in Greensboro,
But there's an opportunity to become a key member of the team! Surely you wouldn't pass that up? *snicker* g -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001 4:23 PMTo: Multiple recipients of list ORACLE-LSubject: OT Slam for the day: Re: Oracle DBA Needed in Greensboro, why bother sending these things to the list, when there are SO MANY RESTRICTIONS, its a waste of bandwidth more than anything else. NO aliens(foreigners or the outer space kind), NO one unless you live there, NO subcontractors, NO one with green eyes, NO one who has ever known anyone who lives outside NC, NO one who has ever thought about living outside NC and they have to be 9i OCP with 2 years of using 9i. joe [EMAIL PROTECTED] 08/16/01 11:00AM This Textiles Client in Greensboro, North Carolina needs an Oracle DBAto join its' I.T. staff. This is a Jr/Mid level position.* Candidates local to the Greensboro-Burlington area only will be considered.This is a full time staff position so no sub-contractors or third partiesplease.Please do not call or send a resume if you are not in the U.S. and/or need sponsorship.* Required Skills:-Oracle 8i DBA experience on Unix-Degree Required-U.S. citizenshipThese positions offer: * Stability * The opportunity to become a key member of the team. * Base salary of 70K-D.O.E...maybe more PLEASE do not send your resume if you are not in the United States.For immediate consideration, please send your resume as a Word attachment to:OraStaff, Inc.Email: [EMAIL PROTECTED]ph: 1-800 -549-8502Please use job code:One/Greensboro/DBA/HallCandidates who we are interested in will be contacted immediately.*We pay referral fees.So please contact me if you know of anyone who would be qualified/interestedin the posiitiondescribed above- if it is not a match for your skills.Thanks,Bill Law--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: OraStaff INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Migrating IMS to Oracle
I do not think that the Oracle Migration Workbench does, but here is something that might be useful. http://otn.oracle.com/tech/migration/mti/listing.htm -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 9:48 AM To: Multiple recipients of list ORACLE-L Subject: Migrating IMS to Oracle I may be starting a project in the near future to migrate an IMS database to 8.1.? on Windows 2000. I would like to know if Oracle provides a tool to do this? Data profiling, mapping, etc.? I could not find anything for IMS on OTN or the Oracle site. I know there are some non-Oracle tools to do this. Any suggestions would be helpful. Thanks, Ken Janusz, CPIM -- 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: Page, Bruce 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: OT: cryptography speech
Title: RE: OT: cryptography speech paranoid schizophrenics with multiple personalities think they are out to get themselves. :-) -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001 12:11 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT: cryptography speech Think yourselves lucky, we're paranoid schizophrenics. They are all out to get us !! -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: 16 August 2001 16:36To: Multiple recipients of list ORACLE-LSubject: RE: OT: cryptography speech Even paranoids have enemies Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 11:08 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT: cryptography speech [EMAIL PROTECTED] wrote: what's missing!! Is it doing this to embarrass and annoy me or am I just being paranoid (and if I'm going to be "nuts" I'd rather be paranoid than a single-noid). just because you're paranoid doesn't mean they're not out to get you.;-) -- Bill "Shrek" Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] -- -- One ping to rule them all, One ping to find them, One ping to bring them all, And in the MUTX bind them. -- -- Any given program will expand to fill available memory. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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). The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.
RE: OT: RE: UNCUT ORACLE-L The Motion Picture
Neither! It simply does not exist. There IS no number right next to zero. Amazing stuff. -Original Message- Sent: Wednesday, August 15, 2001 10:26 AM To: Multiple recipients of list ORACLE-L So, would that be irrational or imaginary? BTW - I once made a mistake on a blackboard demonstration and ended up presenting Newton's Macroscope instead of Newton's Microscope. Turns out the math works as well for infinitudes as for infinitesimals. (g) Mohan, Ross MohanR@STARSTo: Multiple recipients of list ORACLE-L -SMI.com[EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: RE: OT: RE: UNCUT ORACLE-L The com Motion Picture 08/14/2001 06:31 PM Please respond to ORACLE-L remove a Dedekind cut? It's like finding out there *is* no such thing as the number next to zero -Original Message- Sent: Tuesday, August 14, 2001 2:08 PM To: Multiple recipients of list ORACLE-L Momento - No. Not likely to see it. I might go to the movies once a year and the next three years are already reserved. Dedekind - Yes. Many years. All brain cells no longer functional. If you uncut a Dedekind cut, what would happen? Does it matter since it's irrational or imaginary anyway? Mohan, Ross MohanR@STARSTo: Multiple recipients of list ORACLE-L -SMI.com[EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: RE: OT: RE: UNCUT ORACLE-L The com Motion Picture 08/14/2001 11:50 AM Please respond to ORACLE-L ROFL But, reallywhy do I have to be Joe Pesci? I really must cut down on my delivery speed...sigh. Oh well...reminds me of my first shamanic journey to the middle worldturns out my power animal was a squirrel. A friggin' squirrel. LoL Ah well, I am an oracle dba...I *do* have to compensate Ross p.s. It's Dedekind Cut. He was brilliantwow. -Original Message- Sent: Tuesday, August 14, 2001 11:10 AM To: Multiple recipients of list ORACLE-L The unkindest uncut of all - the Dedican uncut. LOL Bowes, Chris To: Multiple recipients of list ORACLE-L Chris.Bowes@[EMAIL PROTECTED] kosa.comcc: Sent by: Subject: OT: RE: UNCUT ORACLE-L The Motion root@fatcity.Picture com 08/14/2001 10:47 AM Please respond to ORACLE-L UNCUT ORACLE-L Coming to theaters near you. Oracle-L, the UNCUT version is rated NC-17. Directed by Bruce. Produced by Jared Still. Starring: Lisa Koivu. Watch as she machetes a user who left his userid and password on a post-it on his PC allowing a rouge college intern to hack the system and destroy data. /Clip Lisa: YOU'VE USED THAT PASSWORD FOR THE LAST TIME MISTER, User: NOo! Hack hack slice slice Lisa: Now where's that intern... /Clip Ross Mohan as her feisty sidekick. (envision Joe Pesci) /Clip Nice Cutting Lisa. So l-user, is it funny now? Does she make you laugh? Like a clown? Looks like we'll have to rewrite that song. 'The ankle bone's connected to the spinal cord...' /Clip Rachel Carmichel, as the goddess of manager destruction. Watch as she stuffs a chair down the throat of a manager for his really stupid ideas. /Clip Manager: But Rachel, don't you think that we could eliminate that 450g worth of data and save a lot of money in training, dba costs and license fees if we converted everything to Excel Spreadsheets? Why are you looking at me like that? No, now put down that chair that could be an OHSA recordable. Open Wide? Oh, you silly. I've already had brunch with the steering committee. That's where this excellent excel idea came from. We can do this right? I figure 450 g isn't that much is it? All we have to do is get some PC's and a couple secretaries and... No, back away. N. Stuff, cram, cram. /Clip Eric Pierce as Master Po giver of infinite knowledge. /Clip Grasshopper. You will find all you need at these links. /Clip Director Jared Still, in a special appearance. He dispatches another developer for bad locking practices: /Clip Six table locks? For a three
RE: Speed up Truncate tables - rebuild index
Title: RE: Speed up Truncate tables - rebuild index Actually Chris if you truncate a table, the indexes on the table are truncated right along with it. You don't end up with a sparse index, like when you delete many rows. Try it. I did (8.1.6) and was very happy to see this behavior. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 5:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Speed up Truncate tables Don't forget to rebuild your indexes... -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 4:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Speed up Truncate tables Cool! I just tried it - works like a charm! Tom Mercadante Oracle Certified Professional -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 4:02 PM To: Multiple recipients of list ORACLE-L Subject: RE: Speed up Truncate tables Not true, at least in 8i. Using 'alter table move ' you could change the initial extent size.. SQLalter table test move storage (initial 2M); Table altered. Only catch here is that 'move' command doesn't apply to tables having long ,long raw, LOB etc..Initial extent can be changed for the remaining tables.. Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com Christopher Spence [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/15/01 02:22 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: Speed up Truncate tables You are correct, unless your using 9i, you cannot alter the initial extent without dropping the table. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, August 15, 2001 3:07 PM To: Multiple recipients of list ORACLE-L Thomas, are your sure you can change the initial extent? My senior dba told me once it is not possible; you have to drop and recreate table if there is a need to change Initial extent. I am going to play with it today. -Original Message- Sent: Wednesday, August 15, 2001 1:27 PM To: Multiple recipients of list ORACLE-L Chuan, Kevin is correct. If your truncate table is taking a *long* time (and the table is not locked by another process), it's because your storage params are incorrect for the amount of data you are holding. Look at initial and next in comparison with the number of extents (DBA_EXTENTS view) for the table in question, and modify them before you load the data. You can modify the INITIAL extent by issuing an 'alter table allocate extent(size x)' command to grow the INITIAL extent. You can also modify the NEXT extent by issuing an 'alter table storage (next x)' command to change the NEXT extent. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, August 15, 2001 11:02 AM To: Multiple recipients of list ORACLE-L I had the same problem when truncating a huge table (24 Mill rows). It turned out that the reason my table was taking so long was the amount of extents I had on it. I could look at what was actually happening during a truncate and it had to go and take each individual block and put them back in the available lists. Well, after changing the settings on the table to make larger extents (and therefore fewer) the truncates on that table went hundreds of times faster (we had real bad settings on that table before). You might investigate your storage parms and see just how many extents you do have on that table. -Original Message- Sent: Wednesday, August 15, 2001 3:10 AM To: Multiple recipients of list ORACLE-L Hi All, Is there any way to speed up the truncating a big table with 12 million rows? Basically, I implemented truncating that big table on Production, but it affected the performance much, so I had to stop it in the middle of way. All the rows were truncated but the HWM was not shrunk at all. I want to do it again to get the space back. Is there any way to speed up this process? Platform: Oracle EE8.0.6 and Solaris 2.7 Thanks a lot in advance. Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang 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: JRE link question
Hi Listers, I repost here again. Here is our install log. Calling query areasQueries1.7.1.6.0 getProductHome name = oracle.swd.jre startVersion = 1.0 endVersion = 1.2 acceptCompatible = null Query returned : /u01/app/oracle/jre/1.1.8 Does anyone know how the jre home set to this directory? This is a very old oracle_base, now we intend to unmount this drive? But how to reset this jre_home? Thanks, Joan Joan Hsieh wrote: We installed 8.17 on the production machine. We have 2 different oracle_home, 8.1.6 and 8.1.7. After runinstaller, it comes the error message, cannot find file on /oracle/jre. I checked the whole jre bin directory is created on /tmp dir. I set all the environment variable, (except JRE_HOME) but in the middle of installation. The JRE always pointed to one obsolete directory. Do you know how this link created? HRPROD:/oracle/product/8.1.7 ls -ltr total 328 drwxrwx--- 2 root system 512 Aug 09 12:20 lost+found drwxrwsr-x 5 oracle dba 512 Aug 13 15:33 jdbc drwxrwsr-x 3 oracle dba 512 Aug 13 15:33 slax drwxrwsr-x 8 oracle dba 512 Aug 13 15:34 precomp drwxrwsr-x 3 oracle dba 512 Aug 13 15:34 ocommon drwxrwsr-x 7 oracle dba 512 Aug 13 15:35 otrace drwxrwsr-x 4 oracle dba 512 Aug 13 15:35 svrmgr drwxrwsr-x 4 oracle dba 512 Aug 13 16:02 owm drwxrwsr-x 7 oracle dba 512 Aug 13 16:04 sqlplus drwxrwsr-x 12 oracle dba 512 Aug 13 16:09 ldap drwxrwsr-x 2 oracle dba 512 Aug 13 16:10 jlib drwxrwsr-x 5 oracle dba 512 Aug 13 16:13 classes drwxrwsr-x 10 oracle dba 512 Aug 13 16:14 sysman -rwxr-xr-x 1 oracle dba 10 Aug 14 12:47 root.sh.old lrwxrwxrwx 1 oracle dba 25 Aug 14 13:03 JRE - /u01/app/oracle/jre/1.1.8 drwxrwsr-x 2 oracle dba 512 Aug 14 13:08 jar Thanks, Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh 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]: Datafile Migration Tool
Imports/exports only use about 1/10 of your available sustained io generally. Although direct exports are noticably faster and less stress on the database. And why do we need to read this? Use the delete key, personally you can read what you like, judging by some of the posts, it is better read than some other posts on paranoid schizophrenics. Locking, rollback generation, constraints, triggers can affect the performance of the import/export process as well. Also network io if it isn't a local export/import. Again - why do we need to read this? Any person even little knowlegeble in Oracle DBA knows this Use the delete key, again, I don't care what you read and what you don't read. That is your choice, the delete key is your choice. Direct path exports do not effect the speed of imports. Unless your using SQLLDR direct. Direct path exports only effect the speed in which the export is created and the resources it uses. SQLLDR cannot use sxport dump file as a source Agreed. Merely stating import speed is not effected by direct exports. Only direct sql loads using sqlldr is it's import speed effected. There is a lot of confusion that direct exports effect the speed of the import as well. This is false. Conventional exports are cpu bound, where direct path exports are io bound. Who told you so? A little bird, and Oracle, as well as testing and experimenting. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, August 16, 2001 11:52 AM To: Multiple recipients of list ORACLE-L Imports/exports only use about 1/10 of your available sustained io generally. Although direct exports are noticably faster and less stress on the database. And why do we need to read this? Locking, rollback generation, constraints, triggers can affect the performance of the import/export process as well. Also network io if it isn't a local export/import. Again - why do we need to read this? Any person even little knowlegeble in Oracle DBA knows this Direct path exports do not effect the speed of imports. Unless your using SQLLDR direct. Direct path exports only effect the speed in which the export is created and the resources it uses. SQLLDR cannot use sxport dump file as a source Conventional exports are cpu bound, where direct path exports are io bound. Who told you so? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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 TNSListner service after intall 8.1.7 on Win 2k
Hi All, I did a typical installation of Oracle 8.1.7 on Win 2k. It appears to have installed Ok. I can use srvmgrl - create database - etc. However when I try to use worksheet I get no listner. I should not need one from the server. Anyway the install did not create service to start the listener. All other installs I have done on NT always created a tnslistner service. This in my first install on Win 2k. Anyone have any ideas on why service did not get created and how to correct? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) 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).
Can a SYSTEM tablespace be locally managed.
Hi DBAs, I have ready many conflicting notes on MetaLink whether or not a SYSTEM tablespace can be locally managed. Most of the article state definitely not in 8.1.6 and less. While others say Yes and No in 8.1.7 Anyone know for sure thru actual use. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) 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: Speed up Truncate tables - rebuild index
Title: RE: Speed up Truncate tables - rebuild index Lisa, I think Chris referred to 'alter table ... move', in which case you need to rebuild indexes (ROWIDs changed). Igor Neyman, OCP DBAPerceptron, Inc.(734)414-4627[EMAIL PROTECTED] - Original Message - From: Koivu, Lisa To: Multiple recipients of list ORACLE-L Sent: Thursday, August 16, 2001 12:20 PM Subject: RE: Speed up Truncate tables - rebuild index Actually Chris if you truncate a table, the indexes on the table are truncated right along with it. You don't end up with a sparse index, like when you delete many rows. Try it. I did (8.1.6) and was very happy to see this behavior. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 5:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Speed up Truncate tables Don't forget to rebuild your indexes... -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 15, 2001 4:35 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Speed up Truncate tablesCool! I just tried it - works like a charm! Tom MercadanteOracle Certified Professional -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 15, 2001 4:02 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Speed up Truncate tables Not true, at least in 8i. Using 'alter table move ' you could change the initial extent size..SQLalter table test move storage (initial 2M);Table altered.Only catch here is that 'move' command doesn't apply to tables having long ,long raw, LOB etc..Initial extent can be changed for the remaining tables..ThanksRiyaj "Re-yas" ShamsudeenCertified Oracle DBAi2 technologies www.i2.com Christopher Spence [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED] 08/15/01 02:22 PMPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]cc: Subject:RE: Speed up Truncate tables You are correct, unless your using 9i, you cannot alter the initial extentwithout dropping the table."Do not criticize someone until you walked a mile in their shoes, that waywhen you criticize them, you are a mile a way and have their shoes."Christopher R. SpenceOracle DBAPhone: (978) 322-5744Fax: (707) 885-2275Fuelspot73 Princeton StreetNorth, Chelmsford 01863-Original Message-Sent: Wednesday, August 15, 2001 3:07 PMTo: Multiple recipients of list ORACLE-LThomas,are your sure you can change the initial extent? My senior dba told me onceit is not possible; you have to drop and recreate table if there is a needto change Initial extent. I am going to play with it today.-Original Message-Sent: Wednesday, August 15, 2001 1:27 PMTo: Multiple recipients of list ORACLE-LChuan,Kevin is correct. If your truncate table is taking a *long* time (and thetable is not locked by another process), it's because your storage paramsare incorrect for the amount of data you are holding.Look at initial and next in comparison with the number of extents(DBA_EXTENTS view) for the table in question, and modify them before youload the data. You can modify the INITIAL extent by issuing an 'alter tableallocate extent(size x)' command to grow the INITIAL extent. You can also modify the NEXT extent by issuing an 'alter table storage (nextx)' command to change the NEXT extent.hope this helps.Tom MercadanteOracle Certified Professional-Original Message-Sent: Wednesday, August 15, 2001 11:02 AMTo: Multiple recipients of list ORACLE-LI had the same problem when truncating a huge table (24 Mill rows). Itturned out that the reason my table was taking so long was the amount ofextents I had on it. I could look at what was actually happening during atruncate and it had to go and take each individual block and put them backin the available lists. Well, after changing the settings on the table to make larger extents (andtherefore fewer) the truncates on that table went hundreds of times faster(we had real bad settings on that table before).You might investigate your storage parms and see just how many extents youdo have on that table.-Original Message-Sent: Wednesday, August 15, 2001 3:10 AMTo: Multiple recipients of list ORACLE-LHi All, Is
RE: rman/standby
Hi Ravindra, I guess you can set"log_archive_dest_n" parameter dynamically by using "alter system" ,at least in 8.1.6. Also, you need to add it also in the init.ora not to loose the parameter value in case of a restart. HTH, Jyoti From: "Ravindra Basavaraja" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: rman/standby Date: Wed, 15 Aug 2001 14:43:53 -0800 Larry, The parameter that you have mentioned should be added in the initialization file of the primary database and I need to restart the database for the new parameter to take affect.But I cannot do that as this is a production database and hence I had to configure the standby database in manual mode.. thanks ravindra -Original Message- Sent: Wednesday, August 15, 2001 4:36 AM To: [EMAIL PROTECTED] Assuming your standby database exists and is on-line (i.e. mounted but not open), you should be able to set up archive_log_dest2="service=your_SID_for_standby mandatory reopen=60" in the param file and Oracle will automatically copy the archive logs to the archive directory of the standby database. You can apply them later by putting the standby database into manual or automatic standby recovery mode. Then you can let RMAN delete them as usual (but you have to find some way to delete the archive logs where the standby is after you apply them). If your standby cannot be active, then you'll have to do some trickier work. larry At 05:41 PM 8/14/2001 -0800, you wrote: I have configured a standby database operating in "manual mode" for our production database. I will have to apply the archive logs manually for the standby database. The Archive logs that are genarated on the production server is backed up by RMAN/netbackup and deleted after the backup.I have the stopped the deletion of archive files from the RMAN script. I want to find the best way of getting both RMAN/netbackup to happen and also delete the archive logs.But before they are deleted they need to be copied to a seperate directory so that I can apply those backed up files to the standby database.I want to make sure that I don't loose any of the archive files that the standby database needs to be in sync with the production database inclucing the current archive logs that may be backed up on the production database. The rman script is like this run { allocate channel t1 type 'SBT_TAPE'; backup incremental level 1 tag Dialy_Incremental_Backup_Level1 filesperset 5 format 'Data_%d_%s_%p_%t' (database); sql 'alter system archive log current'; backup filesperset 20 format 'Arch_%d_%s_%p_%t' # (archivelog all delete input); (archivelog all); } How do I do it.? Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja 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: Ravindra Basavaraja 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 download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jyoti N 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).
What file(s) does Oracle read in deciding what has been installed.
Hi All, I am having great difficulty in getting Oracle 8.1.7 installed on Win 2k. I have completely removed Oracle, i.e., directory,registry entries, program groups and services. When I try to re-install it again Installer says 167 products installed when in fact there are none. Where is Oracle reading this from so I can delete this d__n file. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) 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: A high-availability question (standby , replication or ....)
Standby... even if I have to be paged in the middle of the night to bring it up and live. replication is a nightmare to implement unless you plan for it. Standby is a breeze to implement and maintain. From: Andrey Bronfin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: A high-availability question (standby , replication or ) Date: Thu, 16 Aug 2001 08:11:09 -0800 Dear gurus ! A customer wants to have a backup database on a remote in case of disaster site. That database needs to be as much in sync with the primary DB as possible, and a sort of failover must be implemented , i.e. if the primary site fails , the users will be AUTOMATICALLY routed to the secondary one . I thought of 2 possible approaches : multimaster asynchronous replication and a standby database. The problem is that AFAIK , there is no automatic failover in case of standby DB , i.e.. U need to issue ALTER DATABASE ACTIVATE STANDBY DATABASE; or something like that on a backup site. From the other hand multimaster replication sounds like a big headache . So , gurus , what would U suggest ? How do U implement HA on your sites ? Thanks a lot in advance for your time. Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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 download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Can a SYSTEM tablespace be locally managed.
Since you are likely to get conflicting answers from the list, how are you going to decide ? At present there is no syntax line in CREATE DATABASE for making the system tablespace locally managed, which is a hint. The other hint is that the Oracle 9 Concepts manual (Ch 4 page 10) states something like: A future release will allow SYSTEM to be locally managed ... At present I wouldn't do it, even if it were supposed to be possible. Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: Can a SYSTEM tablespace be locally managed.
it can't From: Cale, Rick T (Richard) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Can a SYSTEM tablespace be locally managed. Date: Thu, 16 Aug 2001 08:28:22 -0800 Hi DBAs, I have ready many conflicting notes on MetaLink whether or not a SYSTEM tablespace can be locally managed. Most of the article state definitely not in 8.1.6 and less. While others say Yes and No in 8.1.7 Anyone know for sure thru actual use. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) 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 download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
characterset problem
Hi there , We have UTF-8 database. We are using OAS with UTF-8 setting and java at front end connects to OAS socket to send data to be inserted into oracle .Is it required to convert data send by Java to be converted to UTF8 ? OAS (OAS NLS_LANG=AMERICAN_AMERICA.UTF8)When we send some particuler chinese characters into database I get weired results .As shown below . Does it mean 4+2 =5 ?? or I am doing something wrong here . select lengthb(casename), lengthb(caseName||'XX') , lengthb('XX') from case where casepin=736; LENGTHB(CASENAME) LENGTHB(CASENAME||'XX') LENGTHB('XX') --- - - 4 5 2 Thanks , AJ
Re: Comment on 'Practical Oracle 8i'
I don't know how bookpool does it - it's been at deep discounts since publication, whereas Amazon managed to cut it by 10% for about two weeks in 9 months. A comment like yours came up on the comp.databases.oracle.server newsgroup very soon after the book came out. The convenient weasel word is of course the 'often'. I had forgotten when I wrote it that Steve had made exactly the opposite comment; however, there is room for both of us to be correct. The effect is application-dependent. Cary Millsap has an article on his website www.hotsos.com which describes a case where upgrading the CPUs to a higher speed (same number) resulted in the OLTP users complaining about a drop in performance. The bottom line is that queuing theory always kicks in when you have a small number of resources and a large number of users. The effect can be exaggerated when the unit of resource offered is significantly larger than the amount of resource that many of the users can take advantage of. This, of course is the argument in the second part of your note. Of course, it would be rather nice to be able to set up an entire environment with a high-stress application, and then run a test which kept the total available MHz constant but changed the number of chips. But even then you'd have to be very careful about what it was you were actually measuring. Any volunteers with a couple of megabuck's of hardware and a few weeks of HR to spare ? (Preferably in an interesting part of the world, and I'd supervise the tests). Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 16 August 2001 06:04 |Must say BookPool.com is so awesome. 40% off most books (which I bought |three this time) and paid $4 for 5 day shipping yet I get it the next day on |my doorstep. Got to love that. | |Page 28: | |I will quote: | |A greater number of slower CPU's is often better than a fewer number of |faster ones. | | |To some extent I believe this is true especially with the efficient use of |caching in most OS's. But with the larger caches on unix cpu's, 4Mb, 8Mb. |There is a loss of performance when a process runs on a cpu, then context |switches and then placed on another cpu. All the cached tlb's are then |sitting on another cpu and need to be reloaded. Although the os will try to |reschedule recently run processes on the same cpu, that doesn't always |happen on a busy system. Also the fact that faster cpu's return the |processes back faster. | |Although on the other hand, with more cpu's, more can get done |simultaneously but at a slower rate. And there would be fewer context |switches with many more cpu's. | |Just something to think about. |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.com |-- |Author: Christopher Spence | 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: Jonathan Lewis 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: Index space not freed when rows deleted?
Thanks to you and Kevin! You'd think I'd have noticed this behavior sometime before, but obviously not. Hmm, I'm also thinking now about my partioned tables in the datawarehouse, some of which have a global index on them. After exporting and dropping an older partition, I assume all that space is still claimed. That would explain why when I rebuilt the indexes recently I regained a huge amount of space. Always glad to learn something new :). Jay Miller -Original Message- Sent: Wednesday, August 15, 2001 5:42 PM To: Multiple recipients of list ORACLE-L Index blocks remain when all the leaves are gone. It's late and I'm late for going home but basically, you deleted rows from the table. The index removes those pointers but does not otherwise reorganize itself. After you do a major DML on a table, rebuild the index. Miller, Jay JayMiller@TDWaterTo: Multiple recipients of list ORACLE-L house.com[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Index space not freed when rows deleted? 08/15/2001 04:48 PM Please respond to ORACLE-L I'm puzzled. We had a table that hit maximum extents on our QA server (unlike production it isn't cleaned out on a daily basis). I deleted most of the rows, leaving only a few thousand. The next day, when inserting more rows I hit the maxextents exceeded error on an index on that table (of course the number of extents hadn't been reduced but I would have thought there'd be plenty of room in 121 existing extents after most of the rows were deleted). I rebuilt the index and it went from 121 extents to 1 extent, resolving the problem, but leaving some curiosity. It's a primary key sequence based index. Any ideas? Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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: Miller, Jay 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]: Datafile Migration Tool
Oh my, we were right, they are picking on us, I told you didn't I. No, I told you No you didn't. Use the delete key, personally you can read what you like, judging by some of the posts, it is better read than some other posts on paranoid schizophrenics. The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: 8.1.6 support cut off?
I can't actually get to metastink - so I thought I would ask you guys that can :) oO(Don't know whether not being able to get at it really hurts me anyway :) ) Cheers anyway Mark -Original Message- Canaan Sent: Thursday, August 16, 2001 16:43 To: Multiple recipients of list ORACLE-L The desupport notice states 10/31/2001, with extended support until 10/31/2004. It's on metallink. If you are an Oracle Applications customer, then support is extended until 3/1/2002. Mark Leith wrote: Hi list, Does anyone have the word on when Oracle plans to discontinue support for Oracle 8.1.6? Cheers 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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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: Speed up Truncate tables - rebuild index
Title: RE: Speed up Truncate tables - rebuild index Ahhh... Thank you. Pre-coffee over here. LK -Original Message- From: Igor Neyman [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 12:58 PM To: Multiple recipients of list ORACLE-L Subject: Re: Speed up Truncate tables - rebuild index Lisa, I think Chris referred to 'alter table ... move', in which case you need to rebuild indexes (ROWIDs changed). Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] - Original Message - From: Koivu, Lisa mailto:[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Thursday, August 16, 2001 12:20 PM Subject: RE: Speed up Truncate tables - rebuild index Actually Chris if you truncate a table, the indexes on the table are truncated right along with it. You don't end up with a sparse index, like when you delete many rows. Try it. I did (8.1.6) and was very happy to see this behavior. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 5:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Speed up Truncate tables Don't forget to rebuild your indexes... -Original Message- From: Mercadante, Thomas F [ mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 4:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Speed up Truncate tables Cool! I just tried it - works like a charm! Tom Mercadante Oracle Certified Professional -Original Message- From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 4:02 PM To: Multiple recipients of list ORACLE-L Subject: RE: Speed up Truncate tables Not true, at least in 8i. Using 'alter table move ' you could change the initial extent size.. SQLalter table test move storage (initial 2M); Table altered. Only catch here is that 'move' command doesn't apply to tables having long ,long raw, LOB etc..Initial extent can be changed for the remaining tables.. Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com Christopher Spence [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/15/01 02:22 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: Speed up Truncate tables You are correct, unless your using 9i, you cannot alter the initial extent without dropping the table. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, August 15, 2001 3:07 PM To: Multiple recipients of list ORACLE-L Thomas, are your sure you can change the initial extent? My senior dba told me once it is not possible; you have to drop and recreate table if there is a need to change Initial extent. I am going to play with it today. -Original Message- Sent: Wednesday, August 15, 2001 1:27 PM To: Multiple recipients of list ORACLE-L Chuan, Kevin is correct. If your truncate table is taking a *long* time (and the table is not locked by another process), it's because your storage params are incorrect for the amount of data you are holding. Look at initial and next in comparison with the number of extents (DBA_EXTENTS view) for the table in question, and modify them before you load the data. You can modify the INITIAL extent by issuing an 'alter table allocate extent(size x)' command to grow the INITIAL extent. You can also modify the NEXT extent by issuing an 'alter table storage (next x)' command to change the NEXT extent. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, August 15, 2001 11:02 AM To: Multiple recipients of list ORACLE-L I had the same problem when truncating a huge table (24 Mill rows). It turned out that the reason my table was taking so long was the amount of extents I had on it. I could look at what was actually happening during a truncate and it had to go and take each individual block and put them back in the available lists. Well, after changing the settings on the table to make larger extents (and therefore fewer) the truncates on that table went hundreds of times faster (we had real bad settings on that table before). You might investigate your storage parms and see just how many extents you do have on that table. -Original Message- Sent: Wednesday, August 15, 2001 3:10 AM To: Multiple recipients of list ORACLE-L Hi All, Is there any way to speed up the truncating a big table with 12 million rows? Basically, I implemented
RE: No TNSListner service after intall 8.1.7 on Win 2k
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k Hi Rick, I ran into this as well. I figured I didn't need a listener on my w2k box because everything was going to be local. However I couldn't connect via sqlplus gui without a listener (no listener error - maybe because I am specifying the sid). I guess it's just another difference between Oracle on windows and Oracle on Unix. If I remember right (it's been s long) when you connect in Unix with the $ORACLE_SID as part of your env, you can do so without @. If you do it with the @, it looks for a listener. When connecting via a windows gui, you are specifying the sid. I'm guessing it's doing something similar to the @ in the background. The cmd window connects without the @ because it's in the environment. By the way, how do you display an environment variable in Windows? I thought it was echo %ORACLE_SID%, but that doesn't work. Anyone? Again I may be pre-coffee. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Cale, Rick T (Richard) [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 12:36 PM To: Multiple recipients of list ORACLE-L Subject: No TNSListner service after intall 8.1.7 on Win 2k Hi All, I did a typical installation of Oracle 8.1.7 on Win 2k. It appears to have installed Ok. I can use srvmgrl - create database - etc. However when I try to use worksheet I get no listner. I should not need one from the server. Anyway the install did not create service to start the listener. All other installs I have done on NT always created a tnslistner service. This in my first install on Win 2k. Anyone have any ideas on why service did not get created and how to correct? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) 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]: Datafile Migration Tool
Exactly ;) Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, August 16, 2001 1:13 PM To: Multiple recipients of list ORACLE-L Oh my, we were right, they are picking on us, I told you didn't I. No, I told you No you didn't. Use the delete key, personally you can read what you like, judging by some of the posts, it is better read than some other posts on paranoid schizophrenics. The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Christopher Spence 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: Comment on 'Practical Oracle 8i'
Before I reply, so far at page 100 I think the book is great. I plan on finishing it this weekend. Anyway, I agree entirely. I think it really depends. But there are strong reasons in both directions. One thing that would make that test very difficult is MHz to MHz isn't the same. For example. 100MHz Pentium is no where near 1/15 the speed of the 1.5GHz AMD. So it remains a very difficult test to make. I figured since I am so slow to actually buy your book, (which I am now regreting as it is so far very fun read), I assumed it may have already been discussed. Wondering if I am going to get a Why would we care to read this reply message for this too. Peers down to his sig quote Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, August 16, 2001 1:13 PM To: Multiple recipients of list ORACLE-L I don't know how bookpool does it - it's been at deep discounts since publication, whereas Amazon managed to cut it by 10% for about two weeks in 9 months. A comment like yours came up on the comp.databases.oracle.server newsgroup very soon after the book came out. The convenient weasel word is of course the 'often'. I had forgotten when I wrote it that Steve had made exactly the opposite comment; however, there is room for both of us to be correct. The effect is application-dependent. Cary Millsap has an article on his website www.hotsos.com which describes a case where upgrading the CPUs to a higher speed (same number) resulted in the OLTP users complaining about a drop in performance. The bottom line is that queuing theory always kicks in when you have a small number of resources and a large number of users. The effect can be exaggerated when the unit of resource offered is significantly larger than the amount of resource that many of the users can take advantage of. This, of course is the argument in the second part of your note. Of course, it would be rather nice to be able to set up an entire environment with a high-stress application, and then run a test which kept the total available MHz constant but changed the number of chips. But even then you'd have to be very careful about what it was you were actually measuring. Any volunteers with a couple of megabuck's of hardware and a few weeks of HR to spare ? (Preferably in an interesting part of the world, and I'd supervise the tests). Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 16 August 2001 06:04 |Must say BookPool.com is so awesome. 40% off most books (which I bought |three this time) and paid $4 for 5 day shipping yet I get it the next day on |my doorstep. Got to love that. | |Page 28: | |I will quote: | |A greater number of slower CPU's is often better than a fewer number of |faster ones. | | |To some extent I believe this is true especially with the efficient use of |caching in most OS's. But with the larger caches on unix cpu's, 4Mb, 8Mb. |There is a loss of performance when a process runs on a cpu, then context |switches and then placed on another cpu. All the cached tlb's are then |sitting on another cpu and need to be reloaded. Although the os will try to |reschedule recently run processes on the same cpu, that doesn't always |happen on a busy system. Also the fact that faster cpu's return the |processes back faster. | |Although on the other hand, with more cpu's, more can get done |simultaneously but at a slower rate. And there would be fewer context |switches with many more cpu's. | |Just something to think about. |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.com |-- |Author: Christopher Spence | 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: Jonathan Lewis 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
RE: What file(s) does Oracle read in deciding what has been insta
Didja look in 'Program Files'? On my system (8.1.6) there's an Oracle directory with 'Inventory' underneath that. HTH, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation (909) 914-2304 -Original Message- Sent: Thursday, August 16, 2001 9:47 AM To: Multiple recipients of list ORACLE-L installed. Hi All, I am having great difficulty in getting Oracle 8.1.7 installed on Win 2k. I have completely removed Oracle, i.e., directory,registry entries, program groups and services. When I try to re-install it again Installer says 167 products installed when in fact there are none. Where is Oracle reading this from so I can delete this d__n file. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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).