RE: Problems Killing Sessions
I supposed you have already solved. However, I didn't advise you look if the serial# number was increasing. Also to look at which event it was waiting with v$session_wait. Probably sql*net message from client. That why I said those things about the ways of killing. Regards. -Mensaje original- De: Eriovaldo do Carmo Andrietta [SMTP:[EMAIL PROTECTED]] Enviado el: viernes 9 de marzo de 2001 12:16 Para: Multiple recipients of list ORACLE-L Asunto: Re: Problems Killing Sessions Friend Christian : Our session is up yet, and ACTIVE. We have already seen this situation but status was KILLED, for us it is strange. In v$transaction this sessions doesnt exist. About the sequence of commands you said, it actualy happened We applyed several commands in several sequences ... but the session is ACTIVE yet Are there anyway ? Eriovaldo do Carmo Andrietta - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 09, 2001 7:30 AM Maybe two things have happened. First, you probably kill it when it was busy. Or second, you kill it through Oracle first and then when you've seen that it hasn't died, you insisted issuing a kill stmt. Sometimes killing through OS, gets you the same result. So now, you must wait for PMON finishing its tasks. Or if you can do it, bounce the database. Sometimes it helps an oradebug wakeup: oradebug wakeup 2 ---the orapid of PMON to post PMON and help it to its labour. Regards. -Mensaje original- De: Eriovaldo do Carmo Andrietta [SMTP:[EMAIL PROTECTED]] Enviado el: jueves 8 de marzo de 2001 18:36 Para: Multiple recipients of list ORACLE-L Asunto: Re: Problems Killing Sessions Friends : We have a problem for kill a session : We did : select * from v$session and got the result bellow : USERNAME SIDSERIAL# STATUS SERVER -- -- -- - 1 1 ACTIVE DEDICATED 2 1 ACTIVE DEDICATED 3 1 ACTIVE DEDICATED 4 1 ACTIVE DEDICATED 5 1 ACTIVE DEDICATED USER0135 55317 ACTIVE DEDICATED We applyed the command : alter system kill session '35,55317'; alter system kill session '35,55317' * ERROR at line 1: ORA-00030: user session ID does not exist and also, by Instance Manager we finished with kill immediate but the session is showed in the Instance Manager and v$session .. Why ? Eriovaldo do Carmo Andrietta [EMAIL PROTECTED] Limeira/SP - Brasil -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo do Carmo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Trassens, Christian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Eriovaldo do Carmo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
RE: wrong tablespace used
I think that you don't have such archive. Although, check it with this queries: select min(first_change#) from v$log; and select min(first_change#) from v$archived_log ( 8.X ) or select min(first_change#) from v$archive ( for 7 ) If the first query includes the change 199725, then put the path and redo name of the redo logIf your database is NOARCHIVELOG, cross your fingers and pray for the change is in redo logs. If the database is a ARCHIVELOG one, then probably you have problems with the path of archives log_archive_dest and log_archive_format. Check the init.ora or include one by one when it asks you. Regards. -Mensaje original- De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Enviado el: lunes 12 de marzo de 2001 2:00 Para: Multiple recipients of list ORACLE-L Asunto: RE: wrong tablespace used Hi Gunawan, unfortunetly I do shutdown normal, and when I try to SVRMGRL startup mount (startup only it give me error because can not found ts1.dbf) ALTER DATABASE CREATE DATAFILE '/appl/OraHome/oradata/MYDB/ts1.dbf' AS '/appl/OraHome/oradata/MYDB/ts1.dbf'; It gave me Statement processed and when I do ( RECOVER DATAFILE '/appl/OraHome/oradata/MYDB/ts1.dbf'; ORA-00279: change 199725 generated at 03/01/2001 15:24:10 needed for thread 1 ORA-00289: suggestion : /appl/OraHome/dbs/arch1_7472.dbf ORA-00280: change 199725 for thread 1 is in sequence #7472 Specify log: {RET=suggested | filename | AUTO | CANCEL} I just press enter for the RET It gave me ORA-00308: cannot open archived log '/appl/OraHome/dbs/arch1_7472.dbf' ORA-27037: unale to obtain file status SVR4 Error: 2: No such file or directory Additional informatoin: 3 Thank you for your help -Original Message- Sent: Friday, 9 March 2001 10:12 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; 'lzDBA' First of all, to recover the ts1 tablespace, do something like: ALTER DATABASE CREATE DATAFILE '/appl/OraHome/oradata/MYDB/ts1.dbf' AS '/appl/OraHome/oradata/MYDB/ts1.dbf'; RECOVER DATAFILE '/appl/OraHome/oradata/MYDB/ts1.dbf'; Now, on the other question, are you sure there's not another table called EMP owned by another USER like SCOTT? Query dba_segments view: SELECT owner, segment_name, tablespace_name FROM dba_segments WHERE segment_name = 'EMP'; My $0.02. HTP. Gunawan Yuwono Oracle DBA Kansas City, USA --- [EMAIL PROTECTED] wrote: Hi guys, I have some understanding problem. 1. I create a new tablespace create tablespace ts1 datafile '/appl/OraHome/oradata/MYDB/ts1.dbf' size 15M autoextend on default storage initial 128K next 128K minextents 1 maxextents 8192 pctincrease 0 ); 2. I create a new user CREATE USER teddy IDENTIFIED BY bear DEFAULT TABLESPACE ts1 TEMPORARY TABLESPACE temp1 (created too) QUOTA UNLIMITED ON ts1 ; 3. teddy create a table: CREATE TABLE emp ( empno NUMBER(3)CONSTRAINT emp_pk PRIMARY KEY, fname VARCHAR2(20) CONSTRAINT emp_fname_nn NOT NULL, lname VARCHAR2(20) CONSTRAINT emp_lname_nn NOT NULL, bdate DATE CONSTRAINT emp_dbate_nn NOT NULL, CONSTRAINT check_empno CHECK (empno BETWEEN 0 AND 999) ); why this table is not store inside ts1 ? as teddy was created with the default tablespace = ts1 do I have to specify tablespace name in the create table emp script ? this table is store inside SYSTEM tablespace 3. Now I made a stupid move "rm .../MYDB/ts1.dbf my solaris 2.7 login profile don't have the trash can (undelete) so I can not undelete I try to recreate my tbs1 by using above script (step 1) but oracle said tbs1 is allready exists. what should I do now. can I recover my tbs1.dbf and move teddy object into tablespace tbs1 from system tablespace ? Thank You guys, sinardy Think you know someone who can answer the above question? Forward it to them! 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 __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ Think you know someone who can answer the above question? Forward it to them! 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051
RE:compare date
backup_date like '%01/01/2001%' that may work OK Cheers Ganti --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- 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[2]: Re-claiming the space from Table after deletion
Do you mean that PCTUSED-100 PCTFREE-5 will help utilise the next extents more efficiently. Will PCTUSED affect only future blocks or existing ones too. Also, will increasing PCTUSED affect system speed? Kind regards, Rafi [EMAIL PROTECTED] wrote You are right. In this case my last point of increasing PCTUSED applies to hole table Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Raghu Kota Sent: Friday, March 09, 2001 1:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re-claiming the space from Table after deleteion Mr Alex You overlooked imp point that is oracle 7.3 From: "Alex Hillman" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Re-claiming the space from Table after deleteion Date: Fri, 09 Mar 2001 08:45:57 -0800 First of all, as Joe Testa said - if you partitioned this table by date - let say one partition per month - you can truncate partitions that you don't need anymore. Second - if this option is not available - let say that you need delete most but not all records from specific partition - you can create temporary table, select into this table all records that should not be deleted, truncate partition and then select into partition all records from temporary table. And last case - if you need to delete let say 30-50% of the recors and this table does not have a lot of deletes in everyday activity and most deletes are batch in the end of month or some other period - you can increase value of PCTUSED to 100-PCTFREE-5. Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Friday, March 09, 2001 4:56 AM To: Multiple recipients of list ORACLE-L Subject: Re-claiming the space from Table after deleteion Dear All, Platform: Solaris 2.6, Oracle: 7.3.4.0 We have a few tables which are growing very fast due to large no of insertions. But the data gets obselete after a month and we use a procedure to delete the obselete data from the tables. The problem is that the table does not free the space even after the deletion of 40% of the data. How can we re-claim the unused space which got created due to deletion? How do we ensure that future inserts are done in this unused space? [We can not try exp/imp or truncate option due to the huge size high activity and online use of the tables]. Kind Regards and thanks to all there, Rafi Ahmad -- 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: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:
RE: Standby db license for 8.1.6
Hi, on the subject of licensing, has anyone used something like HPs Resource Manager on HPUX to restrict the amount of CPU usage for Oracle on a multi-CPU system, and therefore saved on licensing costs. It does seems unfair if you need a large server for all your application processes which only uses Oracle as a back-end database, that you have to pay as though Oracle is using all the CPU power !! Cheers Steve Parker E Mail: [EMAIL PROTECTED] -- Dennis Taylor [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: Sent by: Subject: RE: Standby db license for 8.1.6 root@fatcity. com 09/03/2001 23:31 Please respond to ORACLE-L At 01:55 PM 3/9/01 -0800, you wrote: Hi Dennis, In my previous job as a dba in a dot com, it was found db2 to be more attractive in terms of price/features. are u including database clients software, hardware for the database server and backup infrastructure for the concerned databases would be glad to receive ur summary. FYI this is basically what I'm asking: I've specified the server as an intel box with 2x750 Mhz cpu, running either linux or NT. I've specified 3 scenarios in terms of number of servers and number of users, and a fourth as an internet-based database server for a web page. I've asked for the price for each dbms *only*. This should give me an idea of the relative costs for the databases under a number of conditions. If the salescritter attempts to bob and weave, that's relevant information as well. Dennis Taylor ILLEGITIMUS NON CARBORUNDUM. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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).
OEM - Tunning Pack, Diagnostic Pack....
List Hi! Oracle gave as these tolls on evaluation and testing and IT managerment wants our opinion. As you know, these products are licenced acording to the number of users (which we have several hundreds). Since we didn' have enough time to test this properly, I was wondering can you give me some info on this? Is this really worth the cost? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Funny Error... Any Ideas what the hell is happening here? Trace F
Hi All Funny Error... Any Ideas what the hell is happening here... Kind Regards Johan Locke http://www.JohanLocke.co.za Certified Oracle 8 8i DBA Certified Oracle Developer Dimension Data i-Commerce Internet Services Direct Line: +27 11 516 5343 mailto:[EMAIL PROTECTED] http://www.didata.com *** The information in this e-mail is confidential and is legally privileged. It is intended solely for the addressee. If this email is not intended for you, you cannot copy, distribute, or disclose the included information to any-one If you are not the intended recipient please delete the mail. Whilst all reasonable steps have been taken to ensure the accuracy and integrity of all data transmitted electronically, no liability is accepted if the data, for whatever reason, is corrupt or does not reach it's intended destination. All business is undertaken, subject to our standard trading conditions which are available on request. *** comdev_ora_29325.zip
Re: Problems Killing Sessions
Friend Christian : We are thankfull for your help. We checked the view v$session_wait as you said. The session is there with the informations bellow : SID=35 SEQ#=24845 EVENT=SQL*Net message from client P1TEXT=driver id P1=1413697536 P1RAW=54435000 P2TEXT=#bytes P2=1 P2RAW=0001 P3TEXT= P3=0 P3RAW=00 WAIT_TIME=-2 SECONDS_IN_WAIT=954539 STATE=WAITED UNKNOWN TIME We would like to turn off this session, because we are afraid that it disturbs us when we will need to put the database down ... We dont know if it is using resources ... Are there any clue ? Regards Eriovaldo do Carmo Andrietta [EMAIL PROTECTED] Widesoft Sistemas Ltda. Limeira/SP - Brasil ICQ #102604225 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 12, 2001 5:30 AM I supposed you have already solved. However, I didn't advise you look if the serial# number was increasing. Also to look at which event it was waiting with v$session_wait. Probably sql*net message from client. That why I said those things about the ways of killing. Regards. -Mensaje original- De: Eriovaldo do Carmo Andrietta [SMTP:[EMAIL PROTECTED]] Enviado el: viernes 9 de marzo de 2001 12:16 Para: Multiple recipients of list ORACLE-L Asunto: Re: Problems Killing Sessions Friend Christian : Our session is up yet, and ACTIVE. We have already seen this situation but status was KILLED, for us it is strange. In v$transaction this sessions doesnt exist. About the sequence of commands you said, it actualy happened We applyed several commands in several sequences ... but the session is ACTIVE yet Are there anyway ? Eriovaldo do Carmo Andrietta - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 09, 2001 7:30 AM Maybe two things have happened. First, you probably kill it when it was busy. Or second, you kill it through Oracle first and then when you've seen that it hasn't died, you insisted issuing a kill stmt. Sometimes killing through OS, gets you the same result. So now, you must wait for PMON finishing its tasks. Or if you can do it, bounce the database. Sometimes it helps an oradebug wakeup: oradebug wakeup 2 ---the orapid of PMON to post PMON and help it to its labour. Regards. -Mensaje original- De: Eriovaldo do Carmo Andrietta [SMTP:[EMAIL PROTECTED]] Enviado el: jueves 8 de marzo de 2001 18:36 Para: Multiple recipients of list ORACLE-L Asunto: Re: Problems Killing Sessions Friends : We have a problem for kill a session : We did : select * from v$session and got the result bellow : USERNAME SIDSERIAL# STATUS SERVER -- -- -- - 1 1 ACTIVE DEDICATED 2 1 ACTIVE DEDICATED 3 1 ACTIVE DEDICATED 4 1 ACTIVE DEDICATED 5 1 ACTIVE DEDICATED USER0135 55317 ACTIVE DEDICATED We applyed the command : alter system kill session '35,55317'; alter system kill session '35,55317' * ERROR at line 1: ORA-00030: user session ID does not exist and also, by Instance Manager we finished with kill immediate but the session is showed in the Instance Manager and v$session .. Why ? Eriovaldo do Carmo Andrietta [EMAIL PROTECTED] Limeira/SP - Brasil -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo do Carmo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Trassens, Christian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing:
RE: Does NT write to random locations on disk?
This just goes to show how little I know, good grief it never ends. Thanks for the responses. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Dennis Taylor [SMTP:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 7:26 PM To: Multiple recipients of list ORACLE-L Subject:RE: Does NT write to random locations on disk? At 01:55 PM 3/9/01 -0800, you wrote: Oracle datafiles are formatted into blocks. Data is read either physically by block or an indexed block number. If you compress using zip and then uncompress, the blocks have not changed. If you reorg the file the blocks will probably change and the data wont be where Oracle thinks it is. I'm working from logic rather than specific knowledge of Oracle here, so I could be way off base. But if you are set up to use a cooked rather than raw file system, then the block number that Oracle uses should be file-relative rather than disk-relative, i.e. the block labelled '34' would be the 34th or 35th block *in the file* rather than *on the disk*. No matter how much you defrag, zip, unzip, copy, mash, spit on, or otherwise vilify the file, it still ends up with the same data in that block. Theoretically. Dennis Taylor ILLEGITIMUS NON CARBORUNDUM. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Translation Re: Stefan Barth/GrundOrg/Fraspa ist
Jared, I guess that now you have to start screening your mail for the word vac*tion in other languages as well. ; ) Cherie Machler [EMAIL PROTECTED] on 03/10/2001 05:20:20 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Cherie Machler/GELCO) Ich werde auer Haus sein von 10.03.2001 bis 25.03.2001. Ich werde Ihre Nachrichten nach meiner Rckkehr beantworten. -- 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).
Oracle Lite and Palm Synchronization
Has anyone got this to work? I'm using the latest oracle Lite I could find (4.0.1.2). When I follow the instructions to setup Iconnect for Palm sync, the step that says to runregset cnshscnd.dll results in the error: C:\ORACLE\OLITE\BINregset cnshscnd.dll Error : HotSync is not installed! Any ideas? Thanks Dave Miller DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Record Length ...
Hi, I have a table containing CHAR, VARCHAR2, NUMBER and DATE fields. Is there any way or command to find out the record length in bytes. This can be useful while defining a Buffer in Pro*C to handle a record. Thanks in Advance. = Harsh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harsh Agrawal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Lite and Palm Synchronization
I don't know the answer to this, but I was wondering what it does? Does this allow your Palm to see the db or something like that? I am currently testing out PocketDBA on my Palm, it's pretty sweet. Kev -Original Message- Dave Sent: Monday, March 12, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Has anyone got this to work? I'm using the latest oracle Lite I could find (4.0.1.2). When I follow the instructions to setup Iconnect for Palm sync, the step that says to runregset cnshscnd.dll results in the error: C:\ORACLE\OLITE\BINregset cnshscnd.dll Error : HotSync is not installed! Any ideas? Thanks Dave Miller DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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]: Re-claiming the space from Table after deletion
Rafi Never cross PCTUSED + PCTFREE = 100%(Imporatant Rule), Ideally it should be below 75%. PCTUSED helps How your data is inseted?? If Insert oriented database, If your database is insert and Update oriendted You have to strike a balance between both of these parameters!! Raghu. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE[2]: Re-claiming the space from Table after deletion Date: Mon, 12 Mar 2001 02:30:20 -0800 Do you mean that PCTUSED-100 PCTFREE-5 will help utilise the next extents more efficiently. Will PCTUSED affect only future blocks or existing ones too. Also, will increasing PCTUSED affect system speed? Kind regards, Rafi [EMAIL PROTECTED] wrote You are right. In this case my last point of increasing PCTUSED applies to hole table Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Raghu Kota Sent: Friday, March 09, 2001 1:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re-claiming the space from Table after deleteion Mr Alex You overlooked imp point that is oracle 7.3 From: "Alex Hillman" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Re-claiming the space from Table after deleteion Date: Fri, 09 Mar 2001 08:45:57 -0800 First of all, as Joe Testa said - if you partitioned this table by date - let say one partition per month - you can truncate partitions that you don't need anymore. Second - if this option is not available - let say that you need delete most but not all records from specific partition - you can create temporary table, select into this table all records that should not be deleted, truncate partition and then select into partition all records from temporary table. And last case - if you need to delete let say 30-50% of the recors and this table does not have a lot of deletes in everyday activity and most deletes are batch in the end of month or some other period - you can increase value of PCTUSED to 100-PCTFREE-5. Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Friday, March 09, 2001 4:56 AM To: Multiple recipients of list ORACLE-L Subject: Re-claiming the space from Table after deleteion Dear All, Platform: Solaris 2.6, Oracle: 7.3.4.0 We have a few tables which are growing very fast due to large no of insertions. But the data gets obselete after a month and we use a procedure to delete the obselete data from the tables. The problem is that the table does not free the space even after the deletion of 40% of the data. How can we re-claim the unused space which got created due to deletion? How do we ensure that future inserts are done in this unused space? [We can not try exp/imp or truncate option due to the huge size high activity and online use of the tables]. Kind Regards and thanks to all there, Rafi Ahmad -- 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: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)
RE: Record Length ...
vsize( name of the field ). You can use it through PL/SQL or SQL. Regards. -Mensaje original- De: Harsh Agrawal [SMTP:[EMAIL PROTECTED]] Enviado el: lunes 12 de marzo de 2001 14:31 Para: Multiple recipients of list ORACLE-L Asunto: Record Length ... Hi, I have a table containing CHAR, VARCHAR2, NUMBER and DATE fields. Is there any way or command to find out the record length in bytes. This can be useful while defining a Buffer in Pro*C to handle a record. Thanks in Advance. = Harsh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harsh Agrawal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Trassens, Christian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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]: Re-claiming the space from Table after deletion
I think, perhaps, he meant: PCTUSED = (100 - PCTFREE - 5) Ron Morton -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 8:50 AM To: Multiple recipients of list ORACLE-L Subject: Re: RE[2]: Re-claiming the space from Table after deletion Rafi Never cross PCTUSED + PCTFREE = 100%(Imporatant Rule), Ideally it should be below 75%. PCTUSED helps How your data is inseted?? If Insert oriented database, If your database is insert and Update oriendted You have to strike a balance between both of these parameters!! Raghu. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE[2]: Re-claiming the space from Table after deletion Date: Mon, 12 Mar 2001 02:30:20 -0800 Do you mean that PCTUSED-100 PCTFREE-5 will help utilise the next extents more efficiently. Will PCTUSED affect only future blocks or existing ones too. Also, will increasing PCTUSED affect system speed? Kind regards, Rafi [EMAIL PROTECTED] wrote You are right. In this case my last point of increasing PCTUSED applies to hole table Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Raghu Kota Sent: Friday, March 09, 2001 1:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re-claiming the space from Table after deleteion Mr Alex You overlooked imp point that is oracle 7.3 From: "Alex Hillman" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Re-claiming the space from Table after deleteion Date: Fri, 09 Mar 2001 08:45:57 -0800 First of all, as Joe Testa said - if you partitioned this table by date - let say one partition per month - you can truncate partitions that you don't need anymore. Second - if this option is not available - let say that you need delete most but not all records from specific partition - you can create temporary table, select into this table all records that should not be deleted, truncate partition and then select into partition all records from temporary table. And last case - if you need to delete let say 30-50% of the recors and this table does not have a lot of deletes in everyday activity and most deletes are batch in the end of month or some other period - you can increase value of PCTUSED to 100-PCTFREE-5. Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Friday, March 09, 2001 4:56 AM To: Multiple recipients of list ORACLE-L Subject: Re-claiming the space from Table after deleteion Dear All, Platform: Solaris 2.6, Oracle: 7.3.4.0 We have a few tables which are growing very fast due to large no of insertions. But the data gets obselete after a month and we use a procedure to delete the obselete data from the tables. The problem is that the table does not free the space even after the deletion of 40% of the data. How can we re-claim the unused space which got created due to deletion? How do we ensure that future inserts are done in this unused space? [We can not try exp/imp or truncate option due to the huge size high activity and online use of the tables]. Kind Regards and thanks to all there, Rafi Ahmad -- 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: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to
RE: Oracle Lite and Palm Synchronization
It allows you to sync Oracle Lite tables or portions thereof from an ODBC connection on you client to the PDA. PDA has an msql program (mobile sql) with limited query,update,insert,delete. -Original Message- Sent: Monday, March 12, 2001 8:40 AM To: Multiple recipients of list ORACLE-L I don't know the answer to this, but I was wondering what it does? Does this allow your Palm to see the db or something like that? I am currently testing out PocketDBA on my Palm, it's pretty sweet. Kev -Original Message- Dave Sent: Monday, March 12, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Has anyone got this to work? I'm using the latest oracle Lite I could find (4.0.1.2). When I follow the instructions to setup Iconnect for Palm sync, the step that says to runregset cnshscnd.dll results in the error: C:\ORACLE\OLITE\BINregset cnshscnd.dll Error : HotSync is not installed! Any ideas? Thanks Dave Miller DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: (Fwd) RE: (Fwd/Oracle) Does NT write to random locations on d
I have to agree with Ross on this one, OO Defrag is "The Man" when it comes to defrag tools for NT/2000. i think the site is more : www.oosoft.de and the link to the product: http://www.oosoft.de/english/loader.html?/english/products/ood2000pro/ood200 0pro.html (god I feel like Ep now:) I've been using it for some time with no problems. On the other side of this thread - There are NO problems with defragging your drives if Oracle is shut down. All that a defrag will do is just rearrange the blocks of a file (whether it be database file, system file, a pornographic jpeg :) so that they are contiguous on the disk, they will in no way whatsoever rearrange the content of those blocks.. I do this as regular as clockwork on my desktop (Win2K 8.1.6 R2), sometimes even with the database open! Never had a problem with Oracle due to a defrag. Patrice - It WILL speed up Oracle operations if you do a defrag, think about it - your trying to load a large chunk of data in to memory from disk, and the blocks of this table are splattered all over the disk. So the disk head has to hit one block from the disk, spin, move, hit again, spin, move, hit again.. Where as if they are contiguous the disk head has a hell of a lot less to do.. HTH Mark -Original Message- Sent: Saturday, March 10, 2001 01:40 To: Multiple recipients of list ORACLE-L IMHO, the disk toolsuite that is unbeatable is by OO Defrag. something like oodefrag.com i have been using this to great effect for years. and they have some truly and really neat optimization utilities NT users will like this site. hth! -- 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).
insertion into CLOB
Title: insertion into CLOB Hi gurus, Oracle 8.1.6.2 Solaris 2.6 I'm doing some tests with a CLOB field. I created a stored procedure, which inserts text into a CLOB. Here is my table : create table relance (nom varchar2(50), texte CLOB); Here is my code : create or replace procedure insert_clob is buffer varchar2(32767); Lob_loc CLOB; Amount BINARY_INTEGER; Position INTEGER := 1; begin buffer := 'test de clob, insertion dans le clob pour par le suite le lire'; INSERT INTO relance(nom,texte) VALUES('luc',EMPTY_CLOB()); SELECT LENGTH(buffer) INTO Amount FROM dual; SELECT texte INTO Lob_loc FROM relance WHERE nom = 'luc' FOR UPDATE; DBMS_LOB.WRITE (Lob_loc, Amount, Position, Buffer); end insert_clob; My procedure has been running for 30 minutes. Is this normal ? TIA - Luc Demanche CETELEM Tél.: 01-46-39-14-49 Fax : 01-46-39-59-88
OIP-04109: Error creating temporary file
Anyone know what this means...or even what product OIP is? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT Re-claiming the space from Table after deletion
Title: OT Re-claiming the space from Table after deletion Sure it wasn't F = 9/5*C + 32 ? Formulas are s comforting, aren't they? ;-) -Original Message- From: Morton, Ronald D [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 9:41 AM To: Multiple recipients of list ORACLE-L Subject: RE: RE[2]: Re-claiming the space from Table after deletion I think, perhaps, he meant: PCTUSED = (100 - PCTFREE - 5) Ron Morton -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 8:50 AM To: Multiple recipients of list ORACLE-L Subject: Re: RE[2]: Re-claiming the space from Table after deletion Rafi Never cross PCTUSED + PCTFREE = 100%(Imporatant Rule), Ideally it should be below 75%. PCTUSED helps How your data is inseted?? If Insert oriented database, If your database is insert and Update oriendted You have to strike a balance between both of these parameters!! Raghu. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE[2]: Re-claiming the space from Table after deletion Date: Mon, 12 Mar 2001 02:30:20 -0800 Do you mean that PCTUSED-100 PCTFREE-5 will help utilise the next extents more efficiently. Will PCTUSED affect only future blocks or existing ones too. Also, will increasing PCTUSED affect system speed? Kind regards, Rafi [EMAIL PROTECTED] wrote You are right. In this case my last point of increasing PCTUSED applies to hole table Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Raghu Kota Sent: Friday, March 09, 2001 1:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re-claiming the space from Table after deleteion Mr Alex You overlooked imp point that is oracle 7.3 From: Alex Hillman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Re-claiming the space from Table after deleteion Date: Fri, 09 Mar 2001 08:45:57 -0800 First of all, as Joe Testa said - if you partitioned this table by date - let say one partition per month - you can truncate partitions that you don't need anymore. Second - if this option is not available - let say that you need delete most but not all records from specific partition - you can create temporary table, select into this table all records that should not be deleted, truncate partition and then select into partition all records from temporary table. And last case - if you need to delete let say 30-50% of the recors and this table does not have a lot of deletes in everyday activity and most deletes are batch in the end of month or some other period - you can increase value of PCTUSED to 100-PCTFREE-5. Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Friday, March 09, 2001 4:56 AM To: Multiple recipients of list ORACLE-L Subject: Re-claiming the space from Table after deleteion Dear All, Platform: Solaris 2.6, Oracle: 7.3.4.0 We have a few tables which are growing very fast due to large no of insertions. But the data gets obselete after a month and we use a procedure to delete the obselete data from the tables. The problem is that the table does not free the space even after the deletion of 40% of the data. How can we re-claim the unused space which got created due to deletion? How do we ensure that future inserts are done in this unused space? [We can not try exp/imp or truncate option due to the huge size high activity and online use of the tables]. Kind Regards and thanks to all there, Rafi Ahmad -- 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: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists
RE: Oracle Lite and Palm Synchronization
Dave, we played around w/ this setup for a while here at my client, but they ultimately decided to go in a different direction (complexity, cost issues). We were trying to push sales and pricing data out to the field. I would have liked to have implemented this just for the hell of it. Anyway, it was my experience w/ Metalink and several other sources that the documentation for Oracle Lite is incorrect and they are no longer supporting HotSync methods of replication in the latest version of Oracle Lite. However, I'd check more if I were you; even Oracle seemed confused about this (not a good sign IMHO as I got conflicting answers).I think you will have to setup a RAS server and use the HTTP transport method w/ Oracle Application Server or Web-to-Go. When the client made the decision I didn't explore further due to time restraints. Since I am by no means an expert on this, perhaps someone else can shed some more light on the subject. HTH and HAND! John Dailey Consultant Concept Solutions, LLC -Original Message- Dave Sent: Monday, March 12, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Has anyone got this to work? I'm using the latest oracle Lite I could find (4.0.1.2). When I follow the instructions to setup Iconnect for Palm sync, the step that says to runregset cnshscnd.dll results in the error: C:\ORACLE\OLITE\BINregset cnshscnd.dll Error : HotSync is not installed! Any ideas? Thanks Dave Miller DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dailey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Record Length ...
Thanks, But it gives bytes for "current status of field". i.e. if field is empty or filled it will be different. This makes the assumption that at least one record must be having all fields filled except CHAR, to know the maxm recd length. Right ? -Original Message- Sent: Monday, March 12, 2001 3:56 PM To: Multiple recipients of list ORACLE-L vsize( name of the field ). You can use it through PL/SQL or SQL. Regards. -Mensaje original- De: Harsh Agrawal [SMTP:[EMAIL PROTECTED]] Enviado el: lunes 12 de marzo de 2001 14:31 Para: Multiple recipients of list ORACLE-L Asunto: Record Length ... Hi, I have a table containing CHAR, VARCHAR2, NUMBER and DATE fields. Is there any way or command to find out the record length in bytes. This can be useful while defining a Buffer in Pro*C to handle a record. Thanks in Advance. = Harsh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harsh Agrawal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Trassens, Christian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Harsh Agrawal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Export from 11i
Hello, we have issues with the export functionality in 11i Applications. It says it would export something, but i cannot find anything on my HDD. Is it still in out-format and where is it sent to? Or is the export functionality OUT OF ORDER as some other promised things also?? Thanks in advance for your help Andre Kuerten Imation Germany [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: function index concepts - urgh
At 11:25 AM 3/10/01 -0800, you wrote: This should do it. select * from holder where last_name = upper('Taylor') and first_name = upper('Dennis'); Hm. Intuitively then, I should change my index creation script from (UPPER(LAST_NAME||' '||FIRST_NAME)) to (UPPER(LAST_NAME)||' '||UPPER(FIRST_NAME)) Or is the optimizer intelligent enough to pull it out of the first example? And no it's not Friday, it is now Saturday. ;) Go home! Uh, no, wait. It's Monday now. Dennis Taylor The light at the end of the tunnel is the headlamp of an oncoming train. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OIP-04109: Error creating temporary file
Oops - I meant of course Oracle Objects for OLE (OO4O) -Original Message- Sent: 12 March 2001 15:46 To: Multiple recipients of list ORACLE-L I think (stress think) OIP messages are Oracle Objects for NT. -Original Message- Sent: 12 March 2001 15:20 To: Multiple recipients of list ORACLE-L Anyone know what this means...or even what product OIP is? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Onions INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Onions INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: One Database, Multiple Apps
Lisa, One of the biggest advantages that jumps right out is the user administration at the OS level. One login can get the user to more than one application/instance. At the Oracle level you have all of your scripts on one server and that makes it easier to manage the database. It's not the question "what server/instance am I on? " when you name your scripts accordingly. The main draw back to the multiple instance on one server is as you pointed out. A failure can effect everything on the server. But a disk failure can only effect the instance the disk was part of and recovery can be performed while the rest of the instances are up. ROR mm [EMAIL PROTECTED] 03/12/01 11:26AM Hello all - I have one medium-large production database here. Our system is hybrid but more similar to OLTP. As far as I know quick inserts are not a problem. I need to implement tracking software, where all I'd have to do from the database side is just collect records very quickly without impacting the speed of page views. This tracking software connects via JDBC and really does not care about dbms versions. I am thinking of just implementing a schema in my current database for this purpose and making the table as quick for inserts as possible (no primary key, minimal indexing, PCTUSED set appropriately, etc.) Honestly I can't think of a good reason for creating a separate database other than I'd be creating a bunch of configuration work for myself as well as modifying our backup and recovery strategy (which I am comfortable with doing). Any reporting off this raw data will be done in a "reporting" database, or off Cognos cubes.I thought about any advantages to having one database available when the other is down, and really there are none (if one is down, the entire application will not be available). Has anyone had to configure databases in this manner and if so, what other ideas came into play when deciding whether or not to have one database serve more than one application? Thanks for any comments you may have. Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." -- 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).
number of Mb to add?
if I get this message, IMP-00058: ORACLE error 1654 encountered ORA-01654: unable to extend index TOTSAPPL.PK_DAILY_OPERATOR_ACTIVITIES by 15006 in tablespace USERS the 15006, is it bytes or rows or what? I just want to know how many bytes to enter as the size of the new ADDFILE. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Discount for register the exam
You have to mention at the time of registring your exam the code "S36" and ask for concession, Then they will charge you instead of 125 usd, 100 usd. Raghu. From: "Gupta, Brijesh" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Discount for register the exam Date: Mon, 12 Mar 2001 07:40:25 -0800 At the time of registration just mentioned that you are OTN member, thus eligible of discount. They will give it. But you will have to mention it. Thanks -Original Message- Sent: Sunday, March 11, 2001 4:35 PM To: Multiple recipients of list ORACLE-L I'd like to know the same thing as well. By the way, how do you get get the 20% OTN discount you mentioned? Thanks --- WENDY YUE [EMAIL PROTECTED] wrote: Hi, Gangs: I'm planning to take DBA Exam soon. Does anyone know how to get extra discount (besides 20% OTN discount) when register an exam? Thanks - Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices! __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: function index concepts - urgh
Remember that you need the parameter query_rewrite_enabled=TRUE for those indexes. Regards. -Mensaje original- De: Diana Duncan [SMTP:[EMAIL PROTECTED]] Enviado el: lunes 12 de marzo de 2001 16:55 Para: Multiple recipients of list ORACLE-L Asunto: RE: function index concepts - urgh In no way would I ever disagree with Jared ;-), but wouldn't it be better to create two indices rather than the one? create index HOLDER_LASTNAME_IDX on HOLDER (UPPER(LAST_NAME)); create index HOLDER_FIRSTNAME_IDX on HOLDER (UPPER(FIRST_NAME)); The select statement Jared wrote would definitely work, and you'd also have the ability to select only on first names, which having the concatenated last||first wouldn't give you. My $0.02, Diana -Original Message- Sent: Saturday, March 10, 2001 2:25 PM To: Multiple recipients of list ORACLE-L Dennis, This should do it. select * from holder where last_name = upper('Taylor') and first_name = upper('Dennis'); And no it's not Friday, it is now Saturday. ;) Jared On Fri, 9 Mar 2001, Dennis Taylor wrote: create index HOLDER_NAME_IDX on HOLDER (UPPER(LAST_NAME||' '||FIRST_NAME)); insert into holder (last_name,first_name) values ('taylor','dennis'); select * from holder where last_name = 'Taylor' and first_name = 'Dennis'; is that going to use the index? Or do I have to torque the select statement a little more? Or is there a better way to set up the index? Or is the problem just that it's friday? or maybe Friday? -- 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: Diana Duncan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Trassens, Christian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: function index concepts - urgh
if you change your script, you will be able to make a rowid match (assuming the last/first name combinations are unique). If you don't change the script, you will get an index range scan. Oracle will match the upper(last_name) and will then have to read every row with that last name and do an upper on the first name. From: Dennis Taylor [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: function index concepts - urgh Date: Mon, 12 Mar 2001 07:31:20 -0800 At 11:25 AM 3/10/01 -0800, you wrote: This should do it. select * from holder where last_name = upper('Taylor') and first_name = upper('Dennis'); Hm. Intuitively then, I should change my index creation script from (UPPER(LAST_NAME||' '||FIRST_NAME)) to (UPPER(LAST_NAME)||' '||UPPER(FIRST_NAME)) Or is the optimizer intelligent enough to pull it out of the first example? And no it's not Friday, it is now Saturday. ;) Go home! Uh, no, wait. It's Monday now. Dennis Taylor The light at the end of the tunnel is the headlamp of an oncoming train. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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: date format
Yes it is, but only with the time series cartridge. -Original Message- Sent: Monday, March 12, 2001 9:20 AM To: Multiple recipients of list ORACLE-L List hi! When we want to format data, we can do: select to_char(sysdate,'dd.mm. hh24:mi:ss') from dual; Is it possible to format it even further (like miliseconds)? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: 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: number of Mb to add?
It's Oracle blocks. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message- Sent: Monday, March 12, 2001 11:20 AM To: Multiple recipients of list ORACLE-L if I get this message, IMP-00058: ORACLE error 1654 encountered ORA-01654: unable to extend index TOTSAPPL.PK_DAILY_OPERATOR_ACTIVITIES by 15006 in tablespace USERS the 15006, is it bytes or rows or what? I just want to know how many bytes to enter as the size of the new ADDFILE. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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 Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle and America
No it's not true -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bunyamin K.KaradenizSent: Monday, March 12, 2001 11:50 AMTo: Multiple recipients of list ORACLE-LSubject: oracle and America one of my friends returning from America told that ORACLE is not much used in America. Is it True?? Bunyamin TIA
Anyone Using Oracle Enterprise Manager on 8.1.6
Hi All, Is anyone out there using OEM against an 8.1.6.0 database on Solaris 2.7 , if so, are there issues? Such as security and the like. Please let me know,I'm planning on using it on my database. TIA Larry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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]: Re-claiming the space from Table after deletion
This is exactly what meant - this is a quote from my message - "you can increase value of PCTUSED to 100-PCTFREE-5" Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Morton, Ronald D Sent: Monday, March 12, 2001 9:41 AM To: Multiple recipients of list ORACLE-L Subject: RE: RE[2]: Re-claiming the space from Table after deletion I think, perhaps, he meant: PCTUSED = (100 - PCTFREE - 5) Ron Morton -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 8:50 AM To: Multiple recipients of list ORACLE-L Subject:Re: RE[2]: Re-claiming the space from Table after deletion Rafi Never cross PCTUSED + PCTFREE = 100%(Imporatant Rule), Ideally it should be below 75%. PCTUSED helps How your data is inseted?? If Insert oriented database, If your database is insert and Update oriendted You have to strike a balance between both of these parameters!! Raghu. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE[2]: Re-claiming the space from Table after deletion Date: Mon, 12 Mar 2001 02:30:20 -0800 Do you mean that PCTUSED-100 PCTFREE-5 will help utilise the next extents more efficiently. Will PCTUSED affect only future blocks or existing ones too. Also, will increasing PCTUSED affect system speed? Kind regards, Rafi [EMAIL PROTECTED] wrote You are right. In this case my last point of increasing PCTUSED applies to hole table Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Raghu Kota Sent: Friday, March 09, 2001 1:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re-claiming the space from Table after deleteion Mr Alex You overlooked imp point that is oracle 7.3 From: "Alex Hillman" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Re-claiming the space from Table after deleteion Date: Fri, 09 Mar 2001 08:45:57 -0800 First of all, as Joe Testa said - if you partitioned this table by date - let say one partition per month - you can truncate partitions that you don't need anymore. Second - if this option is not available - let say that you need delete most but not all records from specific partition - you can create temporary table, select into this table all records that should not be deleted, truncate partition and then select into partition all records from temporary table. And last case - if you need to delete let say 30-50% of the recors and this table does not have a lot of deletes in everyday activity and most deletes are batch in the end of month or some other period - you can increase value of PCTUSED to 100-PCTFREE-5. Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Friday, March 09, 2001 4:56 AM To: Multiple recipients of list ORACLE-L Subject: Re-claiming the space from Table after deleteion Dear All, Platform: Solaris 2.6, Oracle: 7.3.4.0 We have a few tables which are growing very fast due to large no of insertions. But the data gets obselete after a month and we use a procedure to delete the obselete data from the tables. The problem is that the table does not free the space even after the deletion of 40% of the data. How can we re-claim the unused space which got created due to deletion? How do we ensure that future inserts are done in this unused space? [We can not try exp/imp or truncate option due to the huge size high activity and online use of the tables]. Kind Regards and thanks to all there, Rafi Ahmad -- 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:
RE: number of Mb to add?
Title: RE: number of Mb to add? Joseph, Well, do you really want to deal with a datafile that small, whether that's KB or bytes? What about when it extends beyond that extent? Usually datafiles less than 100MB are not worth the hassle, and the size should be much larger in a production database. Of course, this is just my opinion... HTH Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com. -Original Message- From: Leyden, Joseph [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 11:20 AM To: Multiple recipients of list ORACLE-L Subject: number of Mb to add? if I get this message, IMP-00058: ORACLE error 1654 encountered ORA-01654: unable to extend index TOTSAPPL.PK_DAILY_OPERATOR_ACTIVITIES by 15006 in tablespace USERS the 15006, is it bytes or rows or what? I just want to know how many bytes to enter as the size of the new ADDFILE. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle and America
I think your friend, well, to put it nicely, was misinformed From: "Bunyamin K.Karadeniz" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: oracle and America Date: Mon, 12 Mar 2001 08:50:26 -0800 one of my friends returning from America told that ORACLE is not much used in America. Is it True?? Bunyamin TIA _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
quotes
Just got my oracle quote back. I had asked about backup servers and failover. To quote the salescritter, "In most cases where an environment requires a standby failover server, a license will be required..." Dennis Taylor The light at the end of the tunnel is the headlamp of an oncoming train. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:oracle and America
Humm, If Oracle is "not used" much in America then why is there such a demand for Oracle talent? The statement is very false. Dick Goulet Reply Separator Author: "Bunyamin K.Karadeniz" [EMAIL PROTECTED] Date: 3/12/2001 8:50 AM one of my friends returning from America told that ORACLE is not much used in America. Is it True?? Bunyamin TIA !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content="text/html; charset=iso-8859-9" http-equiv=Content-Type META content="MSHTML 5.00.2014.210" name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT face=Arial size=2one of my friends returning from America told that ORACLE is not much used in America. /FONT/DIV DIVFONT face=Arial size=2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; nbsp;nbsp;nbsp; Is it True??/FONT/DIV DIVFONT face=Arial size=2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; Bunyaminnbsp;/FONT/DIV DIVFONT face=Arial size=2nbsp; TIA/FONT/DIV/BODY/HTML -- 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: ScanMail Message: To Sender, (OT)
Joe, Cohorts, Look at it from the other side. If I worked in a Corporate legal office and was aware of filtering technology, I would insist it be used. The current legal climate in the US where employers are sued at the drop of a hat over sexism, racism, ageism and any other -ism you can think of would require nothing less. And I don't have to get into who really owns the e-mail do I? I'd be harder on the sender (sorry Dick) than on the employer who rejects on content. Mike -Original Message- Sent: Thursday, March 08, 2001 5:16 PM To: Multiple recipients of list ORACLE-L I don't know but i vote for them to be removed from the list, when i work for a compnay that starts screening my email for me, i'll quit thats for sure. the place i work for, i know the admins and they dont do that kind of garbage. joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Discount for register the exam
Does my company need to know that I am quoting this info. about the OTN membership? Will they get my test results? rgds, raja -- On Mon, 12 Mar 2001 07:40:25 Gupta, Brijesh wrote: At the time of registration just mentioned that you are OTN member, thus eligible of discount. They will give it. But you will have to mention it. Thanks -Original Message- Sent: Sunday, March 11, 2001 4:35 PM To: Multiple recipients of list ORACLE-L I'd like to know the same thing as well. By the way, how do you get get the 20% OTN discount you mentioned? Thanks --- WENDY YUE [EMAIL PROTECTED] wrote: Hi, Gangs: I'm planning to take DBA Exam soon. Does anyone know how to get extra discount (besides 20% OTN discount) when register an exam? Thanks - Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices! __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle and America
LOL... LMAO.. ROFLMAO.. ROFLMGDAO.. Slap your friend around the head with a great big sweaty old fish.. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bunyamin K.KaradenizSent: Monday, March 12, 2001 04:50To: Multiple recipients of list ORACLE-LSubject: oracle and America one of my friends returning from America told that ORACLE is not much used in America. Is it True?? Bunyamin TIA
Deployment of Oracle Client
How do most organizations deploy sqlnet client to a large user base? We've currently got hundreds, maybe thousands of users with various versions of the client installed on their desktop. We're also about to roll out Windows 2000 to a large percentage of these users. In testing we've determined that earlier desupported client versions (7.3.4 and such) seem to work on W2K with the apps currently deployed. I'm not happy with a "cross your fingers and hope" approach and have been pushing to get most users up to 8i as a client. Ideally I'd like to have something the users can download and install from the intranet. In searching technet downloads all I find is the entire bloated 200MB Oracle Client as a download - much too big for our remote users to download and install. All I want is the Net8 pieces I'd need for sqlworksheet, or TOAD, or an ODBC connection, so that the download and install time would be within reason. Anybody have suggestions? How are people on this list deploying Oracle apps to many users? Thanks. Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Conboy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Vanilla BD size on Oracle Apps?
List, We are looking into the Oracle Applications Package as a means to house our old application. I know that the database size depends on the option selected that are available in the financial suite. Does anyone on the list have the URL/info on a white paper or propaganda that would give me a direction to start looking for the minimum database size requirements for each option in the suite? Financials, purchase order, journal entry, balance Y-T-D, monthly , etc: Thanks, Ron Rogers ROR mm -- 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).
oracle and America and Microslop
When I ran the original "Oracle and America" e-mail, Windows tried to force a download of an additional package from Microsoft to view it. I don't know what it wants (I wouldn't let it proceed). Microslop is so weak in security, I would NEVER allow a automatic download from anyone without knowing what it was. The other interesting thing is that I was not given an option to exit the download. I had to do the three finger salute and do an end task on the email viewer. I hate Microslop. [EMAIL PROTECTED] 03/12/01 12:35PM I think your friend, well, to put it nicely, was misinformed From: "Bunyamin K.Karadeniz" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: oracle and America Date: Mon, 12 Mar 2001 08:50:26 -0800 one of my friends returning from America told that ORACLE is not much used in America. Is it True?? Bunyamin TIA _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OEM - Tunning Pack, Diagnostic Pack....
Oracle has prices for this product based not on users (at least server part - OMS) but on power units. Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Clinton Naude Sent: Monday, March 12, 2001 6:30 AM To: Multiple recipients of list ORACLE-L Subject: RE: OEM - Tunning Pack, Diagnostic Pack Yes, its a great set of products every DBA should use. You would however not want to give each user on the floor a copy, it would be a total waste of money. Clint * Clinton S. Naud * Head systems administration * Tel: 011 685 4304 * Fax: 011 685 4303 * Cell: 082 377 1726 * E-mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, March 12, 2001 1:05 PM To: Multiple recipients of list ORACLE-L List Hi! Oracle gave as these tolls on evaluation and testing and IT managerment wants our opinion. As you know, these products are licenced acording to the number of users (which we have several hundreds). Since we didn' have enough time to test this properly, I was wondering can you give me some info on this? Is this really worth the cost? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Clinton Naude INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
inserting, updating, selecting millions of rows in a table
Our customer one of the large wireless co. needs to accomplish 3000 transactions per second. Each transaction has one insert, one select and 3 updates. All of them are on the same table. There are 172 processes performing these transactions in a random fashion so bulk binding is out of question. Right now we have only one table but we are planning to partition the table into 172 partitions on some processid key. We have 6500 Sun Sparc machines (HA veritas) and the client does not mind upgrading to 1. Is there anyone out there who has experience with this type of high volume transaction based databases. Any help will be appreciated. Also, is there a tool availbale which can spawn multiple proceses and insert, update and select data from one table. Thanks Sonia P. __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sonia pajerowski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: number of Mb to add?
Also, expanding the available space on a datafile to handle only the next extent is just not being a proactive DBA. Give it enought room to expand. Also don't forget that the datafile it self can be expanded in size (7.3 and above) up to the available space on the volume or the file size limit of the OS. Unless you have to, you don't have to make another datafile. [EMAIL PROTECTED] 03/12/01 12:20PM Joseph, Well, do you really want to deal with a datafile that small, whether that's KB or bytes? What about when it extends beyond that extent? Usually datafiles less than 100MB are not worth the hassle, and the size should be much larger in a production database. Of course, this is just my opinion... HTH Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." -Original Message- Sent: Monday, March 12, 2001 11:20 AM To: Multiple recipients of list ORACLE-L if I get this message, IMP-00058: ORACLE error 1654 encountered ORA-01654: unable to extend index TOTSAPPL.PK_DAILY_OPERATOR_ACTIVITIES by 15006 in tablespace USERS the 15006, is it bytes or rows or what? I just want to know how many bytes to enter as the size of the new ADDFILE. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle and America
Just check the jobs board on technet, or www.dice.com http://www.dice.com among other sites. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject:Re:oracle and America Humm, If Oracle is "not used" much in America then why is there such a demand for Oracle talent? The statement is very false. Dick Goulet Reply Separator Author: "Bunyamin K.Karadeniz" [EMAIL PROTECTED] Date: 3/12/2001 8:50 AM one of my friends returning from America told that ORACLE is not much used in America. Is it True?? Bunyamin TIA !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content="text/html; charset=iso-8859-9" http-equiv=Content-Type META content="MSHTML 5.00.2014.210" name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT face=Arial size=2one of my friends returning from America told that ORACLE is not much used in America. /FONT/DIV DIVFONT face=Arial size=2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nb sp; nbsp;nbsp;nbsp; Is it True??/FONT/DIV DIVFONT face=Arial size=2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; Bunyaminnbsp;/FONT/DIV DIVFONT face=Arial size=2nbsp; TIA/FONT/DIV/BODY/HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle and America
As a DBA working in the US, I can only confirm that Oracle, strangely enough, is not much used in the parts of the US within the polar circle. I also doubt that there are any Oracle DBAs on the decks of the US nuclear subs. To appease to world, there aren't any SQL Server DBAs either. Having Microsoft controlling the ICBMs would definitely be too close to disaster for my taste. -Original Message- Sent: Monday, March 12, 2001 11:50 AM To: Multiple recipients of list ORACLE-L one of my friends returning from America told that ORACLE is not much used in America. Is it True?? Bunyamin TIA -- 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).
fast_start_io_target and log_checkpoint_interval
Hi! is there any difference in the way oracle processes FAST_START_IO_TARGET and LOG_CHECKPOINT_INTERVAL apart from the fact that fast_start_io_target gives us a measure of no:of i/os required for instance recovery and log_checkpoint_interval gives us the number of o/s blocks required for instance recovery. My question is, if both r 'MORE OR LESS' doing the same thing, why the 'redundancy'??? surely am I missing something here... Kindly correct me.. Thanks _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: One Database, Multiple Apps
Lisa Koivu asked about: I am thinking of just implementing a schema in my current database for this purpose and making the table as quick for inserts as possible (no primary key, minimal indexing, PCTUSED set appropriately, etc.) Lisa, I recently did the exact same thing: created a schema for the Tracking App. As the tracking app does not use Public Synonyms, there aren't any conflicts with the other app running on the same database. One word of caution: bind variables. Canned apps frequently have never heard of such creatures. 1. Hike up your shared pool - and pay attention to free memory 2. enable cursor_sharing 3. enable query_rewrite any thoughts on this, Rachel? Paul Paul Drake DBA/SysAdmin Professional Software Systems -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ScanMail Message: To Sender, (OT)
Well, You al might find this interesting too: E-mail filters are great for stemming the flow of unwanted pornography and ads, but are they too good? We here at the InformationWeek Daily last week got a peek at one possible filter future when hundreds of our newsletters were bounced back because of a story we wrote. Software at Nortel Networks, Motorola, and Citicorp scanned our March 7 Daily and said "no, thanks." And while we'd love to tell you about the offending content, we really want loyal readers at those companies to get this edition, too. Let's just say that one of the words rhymes with "fire us." The story also mentioned, shall we say, the L*ve B*g. John Pescatore, a Gartner analyst, says even individual characters and character strings are spooking the watchdogs. The problem is that filters--increasingly common components in our lives--are too unsophisticated, Pescatore says. Most see no difference between a newsletter story about "uncouth coding" and real, live "unrequested malicious programming," if you get our drift. The solution is behavioral filters, or software that doesn't just scan E-mail; it watches what it does or what its attachments do once activated and (presumably) before any damage is done. "It's almost like we are becoming Web psychologists," says Pete Lindstrom, a Hurwitz Group analyst. The good news is that behavioral software is already out from companies such as Finjan Software, Pelican Security, Aladdin Knowledge Systems, and Okena, he says. The bad news is that IS departments literally don't know what they're missing when using more dogmatic filters, says Tom Bartel, Web-design director of E-mail-distribution house MessageMedia Inc. In the meantime, bear with us when you read sometimes-cryptic stories about "criminal cracker products" like the most recent "rhymes-with-rude wife" outbreak. - Jim Nash -- 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: oracle and America
Mladen, Well, hold onto your b^t because about a year ago I read about a certain Navy Aircraft carrier that was headed back to port because their MicroSlop SQL*Server DB had irreparably crashed. I understand it was replaced by "another vendor's DB". Wonder who that could have been? Dick Goulet BTW: The USAF declared Oracle the RDBMS of choice back in 1989. Reply Separator Author: "Gogala; Mladen" [EMAIL PROTECTED] Date: 3/12/2001 11:07 AM As a DBA working in the US, I can only confirm that Oracle, strangely enough, is not much used in the parts of the US within the polar circle. I also doubt that there are any Oracle DBAs on the decks of the US nuclear subs. To appease to world, there aren't any SQL Server DBAs either. Having Microsoft controlling the ICBMs would definitely be too close to disaster for my taste. -Original Message- Sent: Monday, March 12, 2001 11:50 AM To: Multiple recipients of list ORACLE-L one of my friends returning from America told that ORACLE is not much used in America. Is it True?? Bunyamin TIA -- 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). -- 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).
(Fwd) TAR# 1280667.996:Can NT/Win2k server OS defrag utilities
Does anyone else get the impression that Oracle tech support isn't really answering the question about OS fragmentation below?? I thought it was obvious that moving db files when the db is open is likely to be a bad idea, but can't imagine why defragging at the OS level when the db is closed would be a problem. eg, I read an Oracle tech support note that describes how to move db files from one NT machine to another. If one can move the files from one machine to another, why can't the db files be reorganized (at the OS level) on the *same* machine? This seems like an obvious question (and probably a straightforward issue), I don't understand why Oracle tech support is so ambiguous and lacking in explanation/justification for their statements. If they are so enthusiastic about exp/imp, why wouldn't they be as interested in gaining performance by additionally optimizing disk access at the OS level? Or maybe I'm wrong and NT/Win2k actually does a really efficient job of laying out large files (Oracle's pre-allocated db file storage) just like Oracle tech support is hinting? regards, ep bcc: campus SysAdmn gurus --- Forwarded message follows --- Date sent: Mon, 12 Mar 2001 10:55:11 -0500 (EST) To: [EMAIL PROTECTED] Oracle Worldwide Support Incident Tracking System -- TAR#: 1280667.996 Reported: 10-MAR-2001 (CUS-3027991) Assigned: DATASRVW (CHFREEMA.US)Updated: 12-MAR-2001 (CHFREEMA.US) Severity: Severe Loss of Service (2) Status: Soft Close (SCL) Platform: MS Windows 2000 Product: Oracle Server - Enterprise Edition (8.1.7) RDBMS: 8.1.7 Customer: TRUSTEES CALIFORNIA STATE UNIV Contact: Eric Pierce Phone: 916 278-7586 -- Can NT/Win2k server OS defrag utilities be *safely* used on the db files? -- *** METALINK.US 10-MAR-2001 00:00:18 GMT *** ... ### Platform and O/S version, including patchset orservice pack level? ### Oracle 8.1.x Micsosoft NT4 server or Windows 2000server. ### What version and patchset level of the database are you running?### 8.1.7.?.? ### Please describe your problem: ### This is a generic question about behavior of Oracle8i on NT4 server (or Windows2000 server): It is ok to use disk defragmentation utilities (eg, Norton speedisk for NT) on the Oracle 8i db files? An individual on the Oracle-L listserv says that NT defrag utilities will corrupt the db files (he is claiming that the physical placement of the db files at the OS block level is "fragile" from Oracle's perspective). This seems to contradict my experience working with Oracle7.3 on Netware, where it is quite possible to move db files around, and then have Oracle see them in a new location and go on operating normally. We are trying to set up a plan for dbserver tuning/maintenance, and need to know if disk defragging is required and/or advisable for performance and recovery reasons on NT/Windows2000 servers. Thanks, Eric D. Pierce Student Services CSU, Sacramento reply by email:[EMAIL PROTECTED] or phone (916) 278-7586 ... ### What is the impact to your business because of thisproblem? ### could potentially be high, but it is not a current operationalissue Contact me via : E-mail - [EMAIL PROTECTED] *** METALINK.US 10-MAR-2001 00:00:18 GMT *** Automatically assigned via METALINK. *** CHFREEMA.US 10-MAR-2001 00:12:49 GMT, 09-MAR-01 Local *** You should never really defrag your database files. Your datafiles should never need to be defragged assuming that you sized them appropriately. If your database is open when you are doing the defrag it will corrupt your data every time. With a 3rd party utility when the database is closed would have to be tested to see if it would even work. Make sure that you take a backup before you try this though. *** METALINK.US 10-MAR-2001 00:58:03 GMT *** New info : Friday March 9, 2001 4:56pm california time That really doesn't help much, and seems to possibly contradict the conventional wisdom of NT SysAdmns, which is to defrag a file system constantly. Please comment on the Oracle-l listserv post that started the discussion: (thanks!!! ep) -excerpt |Using a little utility called contig I noticed that the Oracle | 8.1.6 datafileson my test NT server are quite fragmented, an | average of 177 fragments perfile, 118 fragments for the OEM | repository datafile. The poor utilitycouldn't do anything with | the database files, they are too large perhaps. | |These were created on an empty server, 8i release 2 went on it | after a defrag,then the OEM. This is on a hard disk with 1.2G of | free space, none of thedatafiles come close to that. | | Why so many fragments? Oracle
RE: oracle and America
GRAANN! -Original Message- From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 2:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: oracle and America yes, but perhaps if they were within a polar circle, it would be ok for them to have control of a few Icy B.M.s? On 12 Mar 2001, at 11:07, Gogala, Mladen scribbled with alacrity and cogency: Date sent:Mon, 12 Mar 2001 11:07:02 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ... Having Microsoft controlling the ICBMs would definitely be too close to disaster for my taste. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Morton, Ronald D INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: (Fwd) TAR# 1280667.996:Can NT/Win2k server OS defrag
If I read oracle correctly when you say defrag, you mean the blocks making up the physical datafiles. Oracle means the internal structure of the database and tables. When you use a Oracle defrag utility from a third party, it reorgs the tables and rows. You are just talking defraging the harddrive without touching the internal structure. I am with you and can't see why this would cause a problem if the database is down. If it did, you would never be able to move a datafile to another volume or server with (of course) you can. [EMAIL PROTECTED] 03/12/01 02:27PM Does anyone else get the impression that Oracle tech support isn't really answering the question about OS fragmentation below?? I thought it was obvious that moving db files when the db is open is likely to be a bad idea, but can't imagine why defragging at the OS level when the db is closed would be a problem. eg, I read an Oracle tech support note that describes how to move db files from one NT machine to another. If one can move the files from one machine to another, why can't the db files be reorganized (at the OS level) on the *same* machine? This seems like an obvious question (and probably a straightforward issue), I don't understand why Oracle tech support is so ambiguous and lacking in explanation/justification for their statements. If they are so enthusiastic about exp/imp, why wouldn't they be as interested in gaining performance by additionally optimizing disk access at the OS level? Or maybe I'm wrong and NT/Win2k actually does a really efficient job of laying out large files (Oracle's pre-allocated db file storage) just like Oracle tech support is hinting? regards, ep bcc: campus SysAdmn gurus --- Forwarded message follows --- Date sent: Mon, 12 Mar 2001 10:55:11 -0500 (EST) To: [EMAIL PROTECTED] Oracle Worldwide Support Incident Tracking System -- TAR#: 1280667.996 Reported: 10-MAR-2001 (CUS-3027991) Assigned: DATASRVW (CHFREEMA.US)Updated: 12-MAR-2001 (CHFREEMA.US) Severity: Severe Loss of Service (2) Status: Soft Close (SCL) Platform: MS Windows 2000 Product: Oracle Server - Enterprise Edition (8.1.7) RDBMS: 8.1.7 Customer: TRUSTEES CALIFORNIA STATE UNIV Contact: Eric Pierce Phone: 916 278-7586 -- Can NT/Win2k server OS defrag utilities be *safely* used on the db files? -- *** METALINK.US 10-MAR-2001 00:00:18 GMT *** ... ### Platform and O/S version, including patchset orservice pack level? ### Oracle 8.1.x Micsosoft NT4 server or Windows 2000server. ### What version and patchset level of the database are you running?### 8.1.7.?.? ### Please describe your problem: ### This is a generic question about behavior of Oracle8i on NT4 server (or Windows2000 server): It is ok to use disk defragmentation utilities (eg, Norton speedisk for NT) on the Oracle 8i db files? An individual on the Oracle-L listserv says that NT defrag utilities will corrupt the db files (he is claiming that the physical placement of the db files at the OS block level is "fragile" from Oracle's perspective). This seems to contradict my experience working with Oracle7.3 on Netware, where it is quite possible to move db files around, and then have Oracle see them in a new location and go on operating normally. We are trying to set up a plan for dbserver tuning/maintenance, and need to know if disk defragging is required and/or advisable for performance and recovery reasons on NT/Windows2000 servers. Thanks, Eric D. Pierce Student Services CSU, Sacramento reply by email:[EMAIL PROTECTED] or phone (916) 278-7586 ... ### What is the impact to your business because of thisproblem? ### could potentially be high, but it is not a current operationalissue Contact me via : E-mail - [EMAIL PROTECTED] *** METALINK.US 10-MAR-2001 00:00:18 GMT *** Automatically assigned via METALINK. *** CHFREEMA.US 10-MAR-2001 00:12:49 GMT, 09-MAR-01 Local *** You should never really defrag your database files. Your datafiles should never need to be defragged assuming that you sized them appropriately. If your database is open when you are doing the defrag it will corrupt your data every time. With a 3rd party utility when the database is closed would have to be tested to see if it would even work. Make sure that you take a backup before you try this though. *** METALINK.US 10-MAR-2001 00:58:03 GMT *** New info : Friday March 9, 2001 4:56pm california time That really doesn't help much, and seems to possibly contradict the conventional wisdom of NT SysAdmns, which is to defrag a file system constantly. Please comment on the Oracle-l listserv post that started
Re:(Fwd) TAR# 1280667.996:Can NT/Win2k server OS defrag util
Eric, That's a very interesting tap dance that OTS did for you. As usual they seem very reluctant to take a position with regards to a third party tool. At anyrate, assuming that you did "correctly" size your DB during initial creation good old MicroSlop did not do anything strange they are correct there should be no need to use a defrag utility. But on the other hand I don't want to try and count the number of hard drives I've seen that aren't fragmented, especially if MicroSlop has control of your swap file. Also I've seen a very significant increase in performance after defragmenting a hard drive both from the OS and Oracle's perspective. I would agree that a cold backup before after the utility is used would be a most prudent action I would not use the utility while the DB is up and running. Dick Goulet Reply Separator Author: "Eric D. Pierce" [EMAIL PROTECTED] Date: 3/12/2001 11:27 AM Does anyone else get the impression that Oracle tech support isn't really answering the question about OS fragmentation below?? I thought it was obvious that moving db files when the db is open is likely to be a bad idea, but can't imagine why defragging at the OS level when the db is closed would be a problem. eg, I read an Oracle tech support note that describes how to move db files from one NT machine to another. If one can move the files from one machine to another, why can't the db files be reorganized (at the OS level) on the *same* machine? This seems like an obvious question (and probably a straightforward issue), I don't understand why Oracle tech support is so ambiguous and lacking in explanation/justification for their statements. If they are so enthusiastic about exp/imp, why wouldn't they be as interested in gaining performance by additionally optimizing disk access at the OS level? Or maybe I'm wrong and NT/Win2k actually does a really efficient job of laying out large files (Oracle's pre-allocated db file storage) just like Oracle tech support is hinting? regards, ep bcc: campus SysAdmn gurus --- Forwarded message follows --- Date sent: Mon, 12 Mar 2001 10:55:11 -0500 (EST) To: [EMAIL PROTECTED] Oracle Worldwide Support Incident Tracking System -- TAR#: 1280667.996 Reported: 10-MAR-2001 (CUS-3027991) Assigned: DATASRVW (CHFREEMA.US)Updated: 12-MAR-2001 (CHFREEMA.US) Severity: Severe Loss of Service (2) Status: Soft Close (SCL) Platform: MS Windows 2000 Product: Oracle Server - Enterprise Edition (8.1.7) RDBMS: 8.1.7 Customer: TRUSTEES CALIFORNIA STATE UNIV Contact: Eric Pierce Phone: 916 278-7586 -- Can NT/Win2k server OS defrag utilities be *safely* used on the db files? -- *** METALINK.US 10-MAR-2001 00:00:18 GMT *** ... ### Platform and O/S version, including patchset orservice pack level? ### Oracle 8.1.x Micsosoft NT4 server or Windows 2000server. ### What version and patchset level of the database are you running?### 8.1.7.?.? ### Please describe your problem: ### This is a generic question about behavior of Oracle8i on NT4 server (or Windows2000 server): It is ok to use disk defragmentation utilities (eg, Norton speedisk for NT) on the Oracle 8i db files? An individual on the Oracle-L listserv says that NT defrag utilities will corrupt the db files (he is claiming that the physical placement of the db files at the OS block level is "fragile" from Oracle's perspective). This seems to contradict my experience working with Oracle7.3 on Netware, where it is quite possible to move db files around, and then have Oracle see them in a new location and go on operating normally. We are trying to set up a plan for dbserver tuning/maintenance, and need to know if disk defragging is required and/or advisable for performance and recovery reasons on NT/Windows2000 servers. Thanks, Eric D. Pierce Student Services CSU, Sacramento reply by email:[EMAIL PROTECTED] or phone (916) 278-7586 ... ### What is the impact to your business because of thisproblem? ### could potentially be high, but it is not a current operationalissue Contact me via : E-mail - [EMAIL PROTECTED] *** METALINK.US 10-MAR-2001 00:00:18 GMT *** Automatically assigned via METALINK. *** CHFREEMA.US 10-MAR-2001 00:12:49 GMT, 09-MAR-01 Local *** You should never really defrag your database files. Your datafiles should never need to be defragged assuming that you sized them appropriately. If your database is open when you are doing the defrag it will corrupt your data every time. With a 3rd party utility when the database is closed would have to be tested to see if it would
RE: (Fwd) TAR# 1280667.996:Can NT/Win2k server OS defrag utilitie
Title: RE: (Fwd) TAR# 1280667.996:Can NT/Win2k server OS defrag utilities EP, You are making a rather large assumption. You are assuming they put the people who KNOW the answer on tech support. Anymore, that is a fading proposition. Now for the most part I think the iTar gives you recent-hire college grads, using MetaLink and internal forums scanning for opportunities to cut and paste an answer. I ask you this: what do YOU think is the average keep time of an employee in Oracle support? 2 years... 1 year6 months? I'd guess after a faceful of training, they work in support for an average of 18 months (*maybe*) and quit or move on. The (very very) few people who know the answers to internals questions are likely (a) not working on tech support, (b) not working for oracle anymore. just my jaded $0.02 - Ross -Original Message- From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 2:27 PM To: Multiple recipients of list ORACLE-L Subject: (Fwd) TAR# 1280667.996:Can NT/Win2k server OS defrag utilities Does anyone else get the impression that Oracle tech support isn't really answering the question about OS fragmentation below?? I thought it was obvious that moving db files when the db is open is likely to be a bad idea, but can't imagine why defragging at the OS level when the db is closed would be a problem. eg, I read an Oracle tech support note that describes how to move db files from one NT machine to another. If one can move the files from one machine to another, why can't the db files be reorganized (at the OS level) on the *same* machine? This seems like an obvious question (and probably a straightforward issue), I don't understand why Oracle tech support is so ambiguous and lacking in explanation/justification for their statements. If they are so enthusiastic about exp/imp, why wouldn't they be as interested in gaining performance by additionally optimizing disk access at the OS level? Or maybe I'm wrong and NT/Win2k actually does a really efficient job of laying out large files (Oracle's pre-allocated db file storage) just like Oracle tech support is hinting? regards, ep bcc: campus SysAdmn gurus --- Forwarded message follows --- Date sent: Mon, 12 Mar 2001 10:55:11 -0500 (EST) To: [EMAIL PROTECTED] Oracle Worldwide Support Incident Tracking System -- TAR#: 1280667.996 Reported: 10-MAR-2001 (CUS-3027991) Assigned: DATASRVW (CHFREEMA.US) Updated: 12-MAR-2001 (CHFREEMA.US) Severity: Severe Loss of Service (2) Status: Soft Close (SCL) Platform: MS Windows 2000 Product: Oracle Server - Enterprise Edition (8.1.7) RDBMS: 8.1.7 Customer: TRUSTEES CALIFORNIA STATE UNIV Contact: Eric Pierce Phone: 916 278-7586 -- Can NT/Win2k server OS defrag utilities be *safely* used on the db files? -- *** METALINK.US 10-MAR-2001 00:00:18 GMT *** ... ### Platform and O/S version, including patchset orservice pack level? ### Oracle 8.1.x Micsosoft NT4 server or Windows 2000server. ### What version and patchset level of the database are you running?### 8.1.7.?.? ### Please describe your problem: ### This is a generic question about behavior of Oracle8i on NT4 server (or Windows2000 server): It is ok to use disk defragmentation utilities (eg, Norton speedisk for NT) on the Oracle 8i db files? An individual on the Oracle-L listserv says that NT defrag utilities will corrupt the db files (he is claiming that the physical placement of the db files at the OS block level is fragile from Oracle's perspective). This seems to contradict my experience working with Oracle7.3 on Netware, where it is quite possible to move db files around, and then have Oracle see them in a new location and go on operating normally. We are trying to set up a plan for dbserver tuning/maintenance, and need to know if disk defragging is required and/or advisable for performance and recovery reasons on NT/Windows2000 servers. Thanks, Eric D. Pierce Student Services CSU, Sacramento reply by email:[EMAIL PROTECTED] or phone (916) 278-7586 ... ### What is the impact to your business because of thisproblem? ### could potentially be high, but it is not a current operationalissue Contact me via : E-mail - [EMAIL PROTECTED] *** METALINK.US 10-MAR-2001 00:00:18 GMT *** Automatically assigned via METALINK. *** CHFREEMA.US 10-MAR-2001 00:12:49 GMT, 09-MAR-01 Local *** You should never really defrag your database files. Your datafiles should never need to be defragged assuming that you sized them appropriately. If your database is open when you are doing the defrag it will corrupt your data every time. With a 3rd party utility when the database is closed would have to be tested to see if it would
RE: oracle and America
Not ICBM's - but they do control Patriot's. -Original Message- Sent: Monday, March 12, 2001 2:06 PM To: Multiple recipients of list ORACLE-L GRAANN! -Original Message- From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 2:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: oracle and America yes, but perhaps if they were within a polar circle, it would be ok for them to have control of a few Icy B.M.s? On 12 Mar 2001, at 11:07, Gogala, Mladen scribbled with alacrity and cogency: Date sent:Mon, 12 Mar 2001 11:07:02 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ... Having Microsoft controlling the ICBMs would definitely be too close to disaster for my taste. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Morton, Ronald D INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
(Fwd) Re: (Fwd/Oracle) Does NT write to random locations on di
Dick folks, "the plot thickens" (or something) see below for comments from some of the NT listserv folks... side note: clearly Oracle's internal NT development groups(s) have considerable knowledge of NT's file system, and they would presumably have a good idea of how to approach this issue. Why that knowledge isn't easily propagated out to/through Oracle Tech Support seems mysterious/weird. regards, ep --- Forwarded message follows --- Date sent: Fri, 9 Mar 2001 13:35:33 -0800 [via Date sent: Fri, 9 Mar 2001 18:26:32 -0500 Send reply to: Windows NT/2000 Discussion List [EMAIL PROTECTED] To: Recipients of WINNT-L digests [EMAIL PROTECTED] ] The OS does decide where to put files based on its own algorythms. This is a big secret with NT (it is part of their "Intelligence") All OSes have some form of system for writing data optimally to a disk or drive array. They may give you bits and pieces of how it works, but the details will remain MS confidential. There are a couple of industry wide accepted examples with no heuristics or intelligence built in. Generally there is a big tradeoff in optimizing writes and reads on a hard disk. The more time which is spent in figuring out where something goes, the slower disk access is. Do you want a fast hard disk array with lots of fragments, or a slow disk array with minimal fragments? The choice is yours, you can't have both fast and best. Eric -Original Message- Sent: Friday, March 09, 2001 1:19 PM To: Levinson, Eric Until a few days ago I would have agreed entirely with what you've said. However, about a week or so back, I ran into a problem with a disk that was so badly fragmented that Drive Image couldn't create an image of it. I ran Diskkeeper on the drive, in fact several passes. At least 3 of them were after I removed ~ half of the files, so that I had around 4Gb free on this 8Gb drive. The fragmentation improved only very slightly. Several files had in excess of 100 fragments. Since I was preparing for a machine upgrade anyway, I copied all the files off to another location, formatted the drive, then restored the files via xcopy. Much to my surprise, while the fragmentation was much less, I had several large files that still were badly fragmented. In fact the worst offender was a 100Mb file which still consisted of 123 fragments. I'm not attempting to disprove your thinking here, but I'm curious if you have any thoughts on possible reasons for this anomaly? At 12:16 PM 3/9/2001 -0800, you wrote: Yes, file fragmentation is a big issue for products that run out of the OS. Oracle is kind of an exception, meaning the files it creates it manages. Yes, your database files may be fragmented, but it probably doesn't affect your database speed as much as tablespace fragmentation would, so I would just ignore it. Oracle manages how the database files are used pretty efficiently, even if they are fragmented. If you REALLY wanted to defragment your database files, there is a really easy way. Most online defrag utilities (like diskkeeper) simply copies the file to another location on the disk, hoping it will reduce the number of fragments. On a nearly full disk it will _increase_ the number of fragments, so this won't work. Best thing would be to back up all your database files to tape a few times. Delete all the database files from your disks. Also REMOVE all non essential files like the contents of your temp directory, IE cache, etc. Defrag your hard disk (if the option is available in your defragger, choose "Free Space Defragmentation") Restore your database files to your hard disk. These files should be written to your hard disk in a contiguous fashion by default, if you have a hunk of open space on your drives. Another option would be to use a Raw file system for Oracle. I am not sure if they support this on NT, I know Oracle supports this on Sun, basically you don't put a file system on the drive. You give to Oracle partitions, and it manages everything. Hope this helps! Eric -Original Message- From: Mike Soultanian [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 12:01 PM To: [EMAIL PROTECTED] Subject: Re: (Fwd/Oracle) Does NT write to random locations on disk? I don't know the answer to your question, but if you didn't already know, there is diskeeper for NT. Plus, they have a frag guard thing that will defrag on the fly, or something like that. I haven't tried it, I just get their newsletter all the time :) Later, mike "Eric D. Pierce" wrote: --- Forwarded message follows --- Date sent: Fri, 09 Mar 2001 11:00:31 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From: "Boivin, Patrice J" [EMAIL PROTECTED] Subject:Does NT write to random locations on disk? Using a little utility called contig I noticed that the Oracle 8.1.6
RE: oracle and America
some how I find it very hard to believe that the tracking system for any military weapon is a Windows 98 2nd edition, Pentium III 700mhz with 256 mb of RAM. "FIRE!!!..oh crap..it locked up again..gotta stop playin solitaire." -Original Message- B Sent: Monday, March 12, 2001 3:31 PM To: Multiple recipients of list ORACLE-L Not ICBM's - but they do control Patriot's. -Original Message- Sent: Monday, March 12, 2001 2:06 PM To: Multiple recipients of list ORACLE-L GRAANN! -Original Message- From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 2:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: oracle and America yes, but perhaps if they were within a polar circle, it would be ok for them to have control of a few Icy B.M.s? On 12 Mar 2001, at 11:07, Gogala, Mladen scribbled with alacrity and cogency: Date sent:Mon, 12 Mar 2001 11:07:02 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ... Having Microsoft controlling the ICBMs would definitely be too close to disaster for my taste. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Morton, Ronald D INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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 Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: (Fwd) Re: (Fwd/Oracle) Does NT write to random locations on d
Title: RE: (Fwd) Re: (Fwd/Oracle) Does NT write to random locations on di EP, I don't see the logic in the last post: You can't have fast and best. First, he doesn't define terms. Fast? Is that peak I/O? Streaming I/O? Single block read? Seek time? Write time? Come on, trying to reduce this to an undifferentiated fast or slow verges on the useless unless one takes the effort to provide an EXPLICITLY CITED METRIC for speed. And this fellow didn't. Second, it's confusing: why is fast set against best as though the one is somehow the enemy of the other? Huh? Third, it leaves out any discussion of the effect of on-disk and on-controller cache. (Not to mention system-level cache.) As far as the application is concerned, it does not see the disk aloneit sees controller and disk cache and disk as an amalgam, performance-wise) Fourth, since WHEN did the choice become forced into Do you want a fast hard disk array with lots of fragments, or a slow disk array with minimal fragments? Geez, can I have a slow disk array with lots of fragments? The only statement I agree with, either logically or from experience is the bit about OS vendors keeping a bit secret from the world on their...well, secret sauce. Sure, you can keep a little bit secret, but come on, folks, it's not like MS has any other/better/special MoJo than any other vendor. What? when the aliens landed on the Redmond campus and revealed their special VASTLY SUPERIOR alien OS technology, no one else noticed? The fact is, data access through a system is.data access through a system. The *whole* system -- including caches -- counts. And, logic will tell you that long-stride streaming I/O ( think Oracle Video Server, e.g. ) will work FASTER and therefore BETTER on a DEFRAGMENTED disk. (geez) I guess this one needs someone who really cares enough to actually test it. - Ross -Original Message- From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 3:37 PM To: Multiple recipients of list ORACLE-L Subject: (Fwd) Re: (Fwd/Oracle) Does NT write to random locations on di Dick folks, the plot thickens (or something) see below for comments from some of the NT listserv folks... side note: clearly Oracle's internal NT development groups(s) have considerable knowledge of NT's file system, and they would presumably have a good idea of how to approach this issue. Why that knowledge isn't easily propagated out to/through Oracle Tech Support seems mysterious/weird. regards, ep --- Forwarded message follows --- Date sent: Fri, 9 Mar 2001 13:35:33 -0800 [via Date sent: Fri, 9 Mar 2001 18:26:32 -0500 Send reply to: Windows NT/2000 Discussion List [EMAIL PROTECTED] To: Recipients of WINNT-L digests [EMAIL PROTECTED] ] The OS does decide where to put files based on its own algorythms. This is a big secret with NT (it is part of their Intelligence) All OSes have some form of system for writing data optimally to a disk or drive array. They may give you bits and pieces of how it works, but the details will remain MS confidential. There are a couple of industry wide accepted examples with no heuristics or intelligence built in. Generally there is a big tradeoff in optimizing writes and reads on a hard disk. The more time which is spent in figuring out where something goes, the slower disk access is. Do you want a fast hard disk array with lots of fragments, or a slow disk array with minimal fragments? The choice is yours, you can't have both fast and best. Eric -Original Message- Sent: Friday, March 09, 2001 1:19 PM To: Levinson, Eric Until a few days ago I would have agreed entirely with what you've said. However, about a week or so back, I ran into a problem with a disk that was so badly fragmented that Drive Image couldn't create an image of it. I ran Diskkeeper on the drive, in fact several passes. At least 3 of them were after I removed ~ half of the files, so that I had around 4Gb free on this 8Gb drive. The fragmentation improved only very slightly. Several files had in excess of 100 fragments. Since I was preparing for a machine upgrade anyway, I copied all the files off to another location, formatted the drive, then restored the files via xcopy. Much to my surprise, while the fragmentation was much less, I had several large files that still were badly fragmented. In fact the worst offender was a 100Mb file which still consisted of 123 fragments. I'm not attempting to disprove your thinking here, but I'm curious if you have any thoughts on possible reasons for this anomaly? At 12:16 PM 3/9/2001 -0800, you wrote: Yes, file fragmentation is a big issue for products that run out of the OS. Oracle is kind of an exception, meaning the files it creates it manages. Yes, your database files may be fragmented, but it probably doesn't affect your database speed as much as tablespace fragmentation would, so I would just
Re: Does NT write to random locations on disk?
If you created it using the Database Assistant, it created a bunch of strangely small data files with autoextend turned on. When the file autoextends, it grabs the next free hunk of disk, of whatever size you set it to grab. Whether something else is creating ephemeral files that cause these fragments to be separated or what, I can't say -- but all you need to do to defrag is: 1) shutdown the database, so that all file locks are cleared 2) back up :-) 3) run your defrag utility, or format the disk and restore from backup :-) 4) startup the database Voila, the files are defragged -- for now. If you want to keep them that way you probably want to turn autoextend off and resize the files prudently before taking the time for this procedure, and create new files as needed at a set size, rather than use autoextend. But it probably doesn't matter -- NT likes files to be defragged, but if you are actually reading random disk-blocks anyway contiguous files won't do a lot of good. If you do a lot of full table scans it will help a bit, if you also defrag your tablespaces. It will also help if you have a lot of free space between the fragments (you won't have to fly over it afterwards), but not much if your disk is mostly full (you didn't say if 1.2G is 80% or 8% :-). "Boivin, Patrice J" wrote: Using a little utility called contig I noticed that the Oracle 8.1.6 datafiles on my test NT server are quite fragmented, an average of 177 fragments per file, 118 fragments for the OEM repository datafile. The poor utility couldn't do anything with the database files, they are too large perhaps. These were created on an empty server, 8i release 2 went on it after a defrag, then the OEM. This is on a hard disk with 1.2G of free space, none of the datafiles come close to that. Why so many fragments? Oracle created those files in one pass, does NT write randomly to disk or what? Won't this have an impact on my NT database's performance? Oracle says tablespace fragmentation is not a big deal, but fragmentation at the OS level matters. Supposedly that's why NT and WndowsXX came with defragmentation tools. ??? Is there a registry setting somewhere to tell NT to write contiguously to disk? TIA Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
RE: (Fwd) Re: (Fwd/Oracle) Does NT write to random locations on d
Title: RE: (Fwd) Re: (Fwd/Oracle) Does NT write to random locations on di I don't know Ross, I didn't want to dig to deep into it. The way I see it is as follows, "hey, that computer is a dual 550 with 10k rpm scsi drives and a gig of ram. I betcha it would be faster than that piii600 with ide drives" I know it's simple minded, but it's kind of true:) Kev -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: Monday, March 12, 2001 4:17 PMTo: Multiple recipients of list ORACLE-LSubject: RE: (Fwd) Re: (Fwd/Oracle) Does NT write to random locations on d EP, I don't see the logic in the last post: "You can't have fast and best." First, he doesn't define terms. "Fast"? Is that peak I/O? Streaming I/O? Single block read? Seek time? Write time? Come on, trying to reduce this to an undifferentiated "fast" or "slow" verges on the useless unless one takes the effort to provide an EXPLICITLY CITED METRIC for speed. And this fellow didn't. Second, it's confusing: why is "fast" set against "best" as though the one is somehow the enemy of the other? Huh? Third, it leaves out any discussion of the effect of on-disk and on-controller cache. (Not to mention system-level cache.) As far as the application is concerned, it does not see the "disk" aloneit sees controller and disk cache and disk as an amalgam, performance-wise) Fourth, since WHEN did the choice become forced into "Do you want a fast hard disk array with lots of fragments, or a slow disk array with minimal fragments?" Geez, can I have a slow disk array with lots of fragments? The only statement I agree with, either logically or from experience is the bit about OS vendors keeping a bit secret from the world on their...well, "secret sauce". Sure, you can keep a little bit secret, but come on, folks, it's not like MS has any other/better/special MoJo than any other vendor. What? when the aliens landed on the Redmond campus and revealed their special VASTLY SUPERIOR alien OS technology, no one else noticed? The fact is, data access through a system is.data access through a system. The *whole* system -- including caches -- counts. And, logic will tell you that long-stride streaming I/O ( think Oracle Video Server, e.g. ) will work FASTER and therefore BETTER on a DEFRAGMENTED disk. (geez) I guess this one needs someone who really cares enough to actually test it. - Ross -Original Message- From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 3:37 PM To: Multiple recipients of list ORACLE-L Subject: (Fwd) Re: (Fwd/Oracle) Does NT write to random locations on di Dick folks, "the plot thickens" (or something) see below for comments from some of the NT listserv folks... side note: clearly Oracle's internal NT development groups(s) have considerable knowledge of NT's file system, and they would presumably have a good idea of how to approach this issue. Why that knowledge isn't easily propagated out to/through Oracle Tech Support seems mysterious/weird. regards, ep --- Forwarded message follows --- Date sent: Fri, 9 Mar 2001 13:35:33 -0800 [via Date sent: Fri, 9 Mar 2001 18:26:32 -0500 Send reply to: Windows NT/2000 Discussion List [EMAIL PROTECTED] To: Recipients of WINNT-L digests [EMAIL PROTECTED] ] The OS does decide where to put files based on its own algorythms. This is a big secret with NT (it is part of their "Intelligence") All OSes have some form of system for writing data optimally to a disk or drive array. They may give you bits and pieces of how it works, but the details will remain MS confidential. There are a couple of industry wide accepted examples with no heuristics or intelligence built in. Generally there is a big tradeoff in optimizing writes and reads on a hard disk. The more time which is spent in figuring out where something goes, the slower disk access is. Do you want a fast hard disk array with lots of fragments, or a slow disk array with minimal fragments? The choice is yours, you can't have both fast and best. Eric -Original Message- Sent: Friday, March 09, 2001 1:19 PM To: Levinson, Eric Until a few days ago I would have agreed entirely with what you've said. However, about a week or so back, I ran into a problem with a disk that was so badly fragmented that Drive Image couldn't create an image of it. I ran Diskkeeper on the drive, in fact several passes. At least 3 of them were after I removed ~ half of the files, so that I had around 4Gb free on this 8Gb drive. The fragmentation improved only very slightly. Several files had in excess of 100 fragments. Since I was preparing for a machine upgrade anyway, I copied all the files off to another
RE: RE: (Fwd) TAR# 1280667.996:Can NT/Win2k server OS defrag uti
Okay - before this one dies ... this incorporates my usual NT bias. So you have a new box - with newly created NTFS volume - lets assume JBOD and no hardware RAID. They're empty. Completely. You create new tablespaces with multple datafiles, each equal to 1 GB so that your backup job can compress them without puking. I believe that its a safe assumption that these datafiles are on continguous tracks and blocks on the physical hard drives - with the actual layout varying depending upon the RAID configuration. You can even drop the datafiles from the database - just keep the file system files around for use later. (That REUSE switch in the datafile creation is quite handy). Oh - you mean that you only created the datafiles as 256 MB each, and set them to autoextend? How large was the autoextend size? 640 KB? Now you're complaining that you datafile is fragmented? Of course its fragmented - you added 640 KB chunks to it. If the logical volume was using RAW partitions, it would have been sliced up BY SECTOR, with a starting sector and the number of sectors - guaranteed to be contiguous (sounds like a vector). This is one of the things that I like most about Oracle on Linux - CONTROL of the filesystem creation. So how would you best defragment a drive? I would say by making it brand new. Forget the defragmentation tools. Use fdisk. I'll assume that the datafiles that you are attempting to defragment are on separate logical drives from other files. If not - move them, or plan on moving the datafiles. BEGIN alter database backup controlfile to trace; Perform a cold database backup to local disk and tape. With the database still shutdown, format the logical volumes - bringing them back to their pristine state, before you selected a sub-optimal datafile configuration/layout. Copy the datafile from the backup staging area to the newly formatted volume. As there is no garbage in the File Allocation Table of the newly formatted logical drive - it should be simply grabbing contiguous tracks/sectors. After opening the database - resize the datafile to its mature size, and turn off autoextend. alter database backup controlfile to trace; END I'll agree that autoextend is convenient if you don't know the storage requirements. You can't really blame the OS for grabbing sectors that aren't contiguous, it its trying to (re)use vacated sections of the logical drive. just my opinion. Paul Original Message utilities Date: Mon, 12 Mar 2001 13:05:46 -0800 Reply-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] That is a pretty pathetic answer. "Datafiles, if they are sized correctly, will never need to be defraged". Yeah right, and if I install software the way it says to on the box, it will always work and I'll never have any problems. -Original Message- Pierce Sent: Monday, March 12, 2001 2:27 PM To: Multiple recipients of list ORACLE-L Does anyone else get the impression that Oracle tech support isn't really answering the question about OS fragmentation below?? I thought it was obvious that moving db files when the db is open is likely to be a bad idea, but can't imagine why defragging at the OS level when the db is closed would be a problem. eg, I read an Oracle tech support note that describes how to move db files from one NT machine to another. If one can move the files from one machine to another, why can't the db files be reorganized (at the OS level) on the *same* machine? This seems like an obvious question (and probably a straightforward issue), I don't understand why Oracle tech support is so ambiguous and lacking in explanation/justification for their statements. If they are so enthusiastic about exp/imp, why wouldn't they be as interested in gaining performance by additionally optimizing disk access at the OS level? Or maybe I'm wrong and NT/Win2k actually does a really efficient job of laying out large files (Oracle's pre-allocated db file storage) just like Oracle tech support is hinting? regards, ep bcc: campus SysAdmn gurus --- Forwarded message follows --- Date sent: Mon, 12 Mar 2001 10:55:11 -0500 (EST) To: [EMAIL PROTECTED] Oracle Worldwide Support Incident Tracking System -- TAR#: 1280667.996 Reported: 10-MAR-2001 (CUS-3027991) Assigned: DATASRVW (CHFREEMA.US)Updated: 12-MAR-2001 (CHFREEMA.US) Severity: Severe Loss of Service (2) Status: Soft Close (SCL) Platform: MS Windows 2000 Product: Oracle Server - Enterprise Edition (8.1.7) RDBMS: 8.1.7 Customer: TRUSTEES CALIFORNIA STATE UNIV Contact: Eric Pierce Phone: 916 278-7586 -- Can NT/Win2k server OS
Re: ScanMail Message: To Sender, (OT)
Where do you let corporate draw the line, before long you'll see no email, cause you can take damn near anything out of context. joe "Hand, Michael T" wrote: Joe, Cohorts, Look at it from the other side. If I worked in a Corporate legal office and was aware of filtering technology, I would insist it be used. The current legal climate in the US where employers are sued at the drop of a hat over sexism, racism, ageism and any other -ism you can think of would require nothing less. And I don't have to get into who really owns the e-mail do I? I'd be harder on the sender (sorry Dick) than on the employer who rejects on content. Mike -Original Message- Sent: Thursday, March 08, 2001 5:16 PM To: Multiple recipients of list ORACLE-L I don't know but i vote for them to be removed from the list, when i work for a compnay that starts screening my email for me, i'll quit thats for sure. -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. 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).
AW: Script for reversing a string?
Hi! Here's the function: -- snip - create or replace function reverse_string(iText in varchar2) return varchar2 is oText varchar2(2000); begin for i in 1 .. least(2000,length(iText)) loop oText := oText || substr(iText,-i,1); end loop; return oText; end; / -- snip - -- Test: select reverse_string('Hope this helps') from dual; Andreas -- Von: Miller, Jay[SMTP:[EMAIL PROTECTED]] Gesendet: Montag, 12. Mrz 2001 22:17 An: Multiple recipients of list ORACLE-L Betreff: Script for reversing a string? Before I reinvent the wheel, I was wondering if anyone has written a function that will reverse a string? Our auditors are requiring that Oracle passwords not contain the reverse of the user name and I was about to start writing this function when I decided to check here first. Thanks! Jay Miller -Original Message- Sent: Friday, March 09, 2001 3:26 PM To: Multiple recipients of list ORACLE-L It hasn't caused me any problems - have only tried it on this test server so far, and on my workstation. The workstation has Oracle 7.3. and 8.0.4 on it they have been running for over a year. I wouldn't try this on a production system! These are test databases only. I am just curious why the files are so fragmented. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 3:36 PM To: Multiple recipients of list ORACLE-L Subject:RE: Does NT write to random locations on disk? I wouldn't think you would want to reorg an Oracle tablespace with an NT defrag utility. You would corrupt the data. Ron Smith Database Administration [EMAIL PROTECTED] -Original Message- Sent: Friday, March 09, 2001 1:01 PM To: Multiple recipients of list ORACLE-L Using a little utility called contig I noticed that the Oracle 8.1.6 datafiles on my test NT server are quite fragmented, an average of 177 fragments per file, 118 fragments for the OEM repository datafile. The poor utility couldn't do anything with the database files, they are too large perhaps. These were created on an empty server, 8i release 2 went on it after a defrag, then the OEM. This is on a hard disk with 1.2G of free space, none of the datafiles come close to that. Why so many fragments? Oracle created those files in one pass, does NT write randomly to disk or what? Won't this have an impact on my NT database's performance? Oracle says tablespace fragmentation is not a big deal, but fragmentation at the OS level matters. Supposedly that's why NT and WndowsXX came with defragmentation tools. ??? Is there a registry setting somewhere to tell NT to write contiguously to disk? TIA Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Listener consolidation
Hi all: Our listeners have evolved over time, whereby when we moved from 8.0 to 8.1, a new listener was created to support this instead of having one listener listening to all databases of different versions. We are trying to consolidate so that we only are running one listener (8.1) and it is listening for 8.1 and 8.0 databases. I also just found out we may need to also include a 7.3 database. Our initial test today gave us all kinds of problems where when we moved an 8.0.4 database out of the 8.0 listener into the 8.1 listener, it wouldn't allow sqlnet connections. However TNSPING worked just fine. Does anyone have any hints for doing this? FWIW, consolidating to a single listener is only the first step. Once we are comfortable that this process is working well, we are going to begin moving all db's that will support it to LDAP. Help? Thoughts? Guidance? All would be appreciated greatly. Stephen Andert -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: (Fwd) Re: (Fwd/Oracle) Does NT write to random locations on di
Folks, here is the maze of amazing info from Andrew Baker's NT support web site: URLs: http://www.ultratech-llc.com/Personal/Files/?File=Defragger.TXT "If you're looking for some proof of how fragmentation can negatively affect your system, see the following:" http://support.microsoft.com/support/kb/articles/Q228/7/34.ASP ---excerpts--- Windows NT Does Not Boot with Highly Fragmented MFT ... SYMPTOMS The Windows NT Start menu does not respond when you start your x86-based computer. A blinking cursor may appear in the upper-left corner of the screen, or an error message may be displayed. This issue only affects computers whose system partition (the partition containing NTLDR and Boot.ini) is formatted with the Windows NT File System (NTFS) file system. CAUSE This issue occurs because the low-level bootstrap code contained in the first few sectors of an NTFS volume can not cope with a situation where the volume's master file table (MFT) is highly fragmented. The role of the bootstrap code is to locate and load the NTLDR file into memory. To perform this function, the bootstrap code must understand NTFS data structures well enough to locate NTLDR on the disk. This task involves reading the volume's MFT in order to obtain the root directory, which in turn contains information necessary to locate the entry in MFT for the NTLDR file itself. The initial bootstrap code is very small and simple and runs in the processor's "real mode". Therefore, it cannot address large amounts of memory. When MFT is highly fragmented, the Windows NT 4.0 bootstrap code may run out of memory to store all the necessary records that describe MFT. This causes the system to stop responding (hang) and thus, the boot process does not proceed. RESOLUTION Windows NT Server or Workstation 4.0 To resolve this problem, obtain the latest service pack for Windows NT 4.0 or the individual software update. ... WORKAROUND To work around this issue, a discussion of MFT fragmentation, together with one method of preventing excessive MFT fragmentation, is presented in the following Microsoft Knowledge Base article: Q174619 How NTFS Reserves Space for its Master File Table (MFT) ( http://support.microsoft.com/support/kb/articles/Q174/6/19.ASP ) After the system drive is sufficiently fragmented such that the system cannot start directly from the hard disk drive, it is still possible to start through a Windows NT startup floppy disk. This is possible because the floppy disk contains its own copy of NTLDR. For additional information, click the article number below to view the article in the Microsoft Knowledge Base: Q119467 Creating a Boot Disk for an NTFS or FAT Partition ( http://support.microsoft.com/support/kb/articles/Q119/4/67.ASP ) ... MORE INFORMATION The Bcupdate.exe program updates the low-level bootstrap code stored on NTFS volumes. All NTFS volumes contain bootstrap code, but the code is used only on system volumes. Because the bootstrap code is a part of the file system and not a part of any "user" file that can be replaced, it is not affected by the application or removal of hotfixes or service packs. Once updated, the boot code remains fixed until the volume is reformatted or the boot code is replaced by some other process (such as that performed by Emergency Repair when it repairs the boot environment). Microsoft has no plans to incorporate automatic bootstrap code updates as part of a future Windows NT 4.0 service pack installation. To update the bootstrap code and resolve a boot issue of this kind, it is necessary to run Bcupdate.exe. ... ---end--- EXCELLENT explanation of other components of NTFS, and how fragmentation in those areas can effect performance: http://www.microsoft.com/TechNet/winnt/optntfs.asp ---excerpt--- .. NTFS Performance Factors You determine many of the factors that affect an NTFS volumes' performance. You choose important elements such as an NTFS volume's type (e.g., SCSI, or IDE), speed (e.g., the disks' rpm speed), and the number of disks the volume contains. In addition to these important components, the following factors significantly influence an NTFS volume's performance: - The cluster and allocation unit size - The location and fragmentation level of frequently accessed files, such as the Master File Table (MFT), directories, special files containing NTFS metadata, the paging file, and commonly used user data files - Whether you create the NTFS volume from scratch or convert it from an existing FAT volume - Whether the volume uses NTFS compression - Whether you disable unnecessary NTFS behaviors Using faster disks and more drives in multidisk volumes is an obvious way to improve performance. The other performance improvement methods are [***]more obscure[***] and relate to the details of an NTFS volume's configuration. ---end---
Who are they ?
Lists, In Oracle Security Manager I found 3 users other than SYS and SYSTEM . what is task of these users ? DBSNMP MDSYS ORDSYS TIA, =bambang= Bambang Setiawan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bambang Setiawan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: (Fwd) Use of third-party tools in Oracle environments [Note:47292.1]
(fyi, from Metalink) ---begin--- Doc ID: Note:47292.1 Subject: Official Backup Policy -- Certification, RMAN, EBU, Third-Party Software Type:FAQ Status: PUBLISHED Content Type:TEXT/PLAIN Creation Date: 16-OCT-1997 Last Revision Date: 04-MAY-2000 Language:USAENG Oracle *DOES NOT* certify media management software with Recovery Manager (RMAN) or the Enterprise Backup Utility (OBACKUP, EBU). Source: Bernard Vincent, Director, Operations and Services Planning, Worldwide Customer Support. September 2, 1997 Use of third-party tools in Oracle environments To: Worldwide Oracle Support Customers To protect customer data against loss or damage and ensure Oracle's ability to provide timely service and support, Oracle Worldwide Customer Support and Oracle Server Technologies have developed the following policy: Oracle cannot guarantee customers data integrity and product functionality where third-party products alter the internal contents of the Oracle database files, data blocks, log files or control files. Third-party products or customer-developed programs which alter the internal contents of these files may introduce inconsistencies that render the data to be unusable. In such situations, customers may be required to restore from the last backup prior to the first use of the third-party product in order for Oracle to provide effective assistance. Examples of such products include data reorganization tools, data loaders, [***]defragmentation tools[***], products that conduct incremental backups of only changed portions of data, or any product that attempts to alter the contents of the Oracle data files, blocks, logs or control files. This [***]excludes[***] simple copying utilities such as operating system utilities or any other product that reproduces an exact image of the data as it was originally written by Oracle. Oracle customers are encouraged to work with third-party software vendors to determine how that vendors' product interacts with Oracle technology, and if the above information is pertinent to their environment or may compromise their data retention and recovery capabilities. . Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use. ---end--- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Who are they ?
Hi, These are users for oracle intelligent agent and two of the oracle enterprise options. They're used to separate the additional objects from the common catalogue. You should change the passwords or at least lock their accounts to protect against security attacks. oli [EMAIL PROTECTED] wrote Lists, In Oracle Security Manager I found 3 users other than SYS and SYSTEM . what is task of these users ? DBSNMP MDSYS ORDSYS TIA, =bambang= Bambang Setiawan -- Oliver Artelt Oracle DBA OCP cubeoffice GmbH Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Deployment of Oracle Client
The way we did it to 2000 users without a hitch. You dont need to install full client, only sqlnet or net8 (approx 28meg). We use Novell launcher. Take a snapshot on one machine, then novell automatically launches it to all clients.There should be similar products to this.(I think SMS by Microsoft). We have a constantly changing environment whereby the applications are updated,we use this method to update all local machines,and it works a dream. This is for now as we have a mixture of fat client and browser based. Sam -Original Message- Sent: Monday, March 12, 2001 10:27 PM To: Multiple recipients of list ORACLE-L How do most organizations deploy sqlnet client to a large user base? We've currently got hundreds, maybe thousands of users with various versions of the client installed on their desktop. We're also about to roll out Windows 2000 to a large percentage of these users. In testing we've determined that earlier desupported client versions (7.3.4 and such) seem to work on W2K with the apps currently deployed. I'm not happy with a "cross your fingers and hope" approach and have been pushing to get most users up to 8i as a client. Ideally I'd like to have something the users can download and install from the intranet. In searching technet downloads all I find is the entire bloated 200MB Oracle Client as a download - much too big for our remote users to download and install. All I want is the Net8 pieces I'd need for sqlworksheet, or TOAD, or an ODBC connection, so that the download and install time would be within reason. Anybody have suggestions? How are people on this list deploying Oracle apps to many users? Thanks. Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Conboy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Sam P. Roberts (ZADCO ITIS) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
how does CBO compute cardinality
Hello List, could someone please tell me how does cost based optimizer compute cardinality for each step in the explain plan? Is there a general formula which is independed on a particular version (I mean 8.0 and upward) ? Thanks in advance, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Deployment of Oracle Client
CAUTION - only theory and heuristical speculation If you're not using only Win32, another method is to separate the registry part from the file system part. Various 3rd party tools take a "diff" of the registry before and after the install of a piece of software. This more or less allows for a tar of the installed files to be deployed on the next victim, with a re-run of the registry changes to install the application as far as windows in concerned. Here's 2 example utilities: http://www2.winsite.com/bin/Info?1373 http://www.softseek.com/Utilities/Registry_Editors_and_Utilities/Review_31462_index.html Ideally, the utility should prepare the registry script to regenerate the diff, from prior to post install. Any more thoughts about using response files? hth, Paul "Sam P. Roberts (ZADCO ITIS)" wrote: The way we did it to 2000 users without a hitch. You dont need to install full client, only sqlnet or net8 (approx 28meg). We use Novell launcher. Take a snapshot on one machine, then novell automatically launches it to all clients.There should be similar products to this.(I think SMS by Microsoft). We have a constantly changing environment whereby the applications are updated,we use this method to update all local machines,and it works a dream. This is for now as we have a mixture of fat client and browser based. Sam -Original Message- Sent: Monday, March 12, 2001 10:27 PM To: Multiple recipients of list ORACLE-L How do most organizations deploy sqlnet client to a large user base? We've currently got hundreds, maybe thousands of users with various versions of the client installed on their desktop. We're also about to roll out Windows 2000 to a large percentage of these users. In testing we've determined that earlier desupported client versions (7.3.4 and such) seem to work on W2K with the apps currently deployed. I'm not happy with a "cross your fingers and hope" approach and have been pushing to get most users up to 8i as a client. Ideally I'd like to have something the users can download and install from the intranet. In searching technet downloads all I find is the entire bloated 200MB Oracle Client as a download - much too big for our remote users to download and install. All I want is the Net8 pieces I'd need for sqlworksheet, or TOAD, or an ODBC connection, so that the download and install time would be within reason. Anybody have suggestions? How are people on this list deploying Oracle apps to many users? Thanks. Jim -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).