Re: internal date value
Igor Sorry but Oracle uses 7 bytes for a date century (1 byte) year (1 byte) month (1 byte) day (1 byte) hour (1 byte) minute (1 byte) second (1 byte) SQL> desc d Name Null?Type - D DATE SQL> col dump format a40 SQL> select to_char(d, 'dd mon hh24:mi:ss'), dump(d) dump from d; TO_CHAR(D,'DDMON DUMP 05 may 0001 15:30:45 Typ=12 Len=7: 100,101,5,5,16,31,46 05 may 0100 15:30:45 Typ=12 Len=7: 101,100,5,5,16,31,46 05 may 0500 15:30:45 Typ=12 Len=7: 105,100,5,5,16,31,46 05 may 1000 15:30:45 Typ=12 Len=7: 110,100,5,5,16,31,46 05 may 1500 15:30:45 Typ=12 Len=7: 115,100,5,5,16,31,46 05 may 1999 15:30:45 Typ=12 Len=7: 119,199,5,5,16,31,46 05 may 2000 15:30:45 Typ=12 Len=7: 120,100,5,5,16,31,46 05 may 2100 15:30:45 Typ=12 Len=7: 121,100,5,5,16,31,46 05 may 2500 15:30:45 Typ=12 Len=7: 125,100,5,5,16,31,46 05 may 2600 15:30:45 Typ=12 Len=7: 126,100,5,5,16,31,46 05 may 2900 15:30:45 Typ=12 Len=7: 129,100,5,5,16,31,46 05 may 3000 15:30:45 Typ=12 Len=7: 130,100,5,5,16,31,46 12 rows selected. /peter Igor Neyman wrote: You gather it wrong :) Oracle stores date in 8 bytes, one for each: year, month, day, hour, min, ... etc. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Droogendyk, Harry Sent: Friday, January 23, 2004 12:40 PM To: Multiple recipients of list ORACLE-L Folks: From what I gather, Oracle stores dates as the number of elapsed days since Jan 1, 1968. When I query a column of type 'DATE', it returns me the default format, dd-mon-yy. I know I can use to_char(date_col,'MMDD') etc... to define many output formats. What can I do to get the raw internal value of the date? i.e. today is 13172. Thanks. -- Best regards/Venlig hilsen /*Peter Gram*/ <mailto:[EMAIL PROTECTED]> Miracle A/S <http://www.miracleas.dk/> Kratvej 2 DK - 2760 Måløv Cell: (+45) 2527 7107 Phone: (+45) 4466 8855 Fax: (+45) 4466 8856 Home: (+45) 3874 5696 Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> SQL Server Master Class 8-10 Marts, Database Forum 28-30 October Master Class 17-19 Januar 2005. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Renumber a set of grupped rows?
Maryann The select workes on 8i, but the update part I have to think som time over :-) [EMAIL PROTECTED] oracle]$ sqlplus scott/tiger SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jan 21 01:43:33 2004 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production SQL> select deptno, row_number() over (PARTITION BY DEPTNO order by deptno) x from emp 2 ; DEPTNO X -- -- 10 1 10 2 10 3 20 1 20 2 20 3 20 4 20 5 30 1 30 2 30 3 30 4 30 5 30 6 14 rows selected. Maryann Atkinson wrote: > select deptno, row_number() over (PARTITION BY DEPTNO order by deptno) > from emp > / Hm... but thats not available in 8i, is it? and besides, I want to update the table, not just select from it... ... thx maa At 06:19 PM 1/20/2004, you wrote: Maryann You can use the new windowing function, here is test select working on emp :-) select deptno, row_number() over (PARTITION BY DEPTNO order by deptno) from emp / DEPTNO ROW_NUMBER()OVER(PARTITIONBYDEPTNOORDERBYDEPTNO) -- 101 102 103 201 202 203 204 205 301 302 303 304 305 306 Maryann Atkinson wrote: I have a 1-rows table with 2 columns, Emp_ID and Req_ID. There are about 150 different emp_ids in these 1+ records. What I want to do is the following: For every different Emp_id, I need the Rec_ids that corresponds to it to be updated/renumbered starting from 1 and keep going up by 1. So I want it to look something like this: Emp_ID Req_ID 10001 001 10001 002 10001 003 10001 004 10001 005 10001 006 10001 007 10001 008 10002 001 10002 002 10002 003 10002 004 10002 005 10003 001 10004 001 10004 002 10004 003 10004 004 10004 005 10004 006 etc Any ideas? Thanks, maa -- Best regards/Venlig hilsen /*Peter Gram*/ <mailto:[EMAIL PROTECTED]> Miracle A/S <http://www.miracleas.dk/> Kratvej 2 DK - 2760 Måløv Cell: (+45) 2527 7107 Phone: (+45) 4466 8855 Fax: (+45) 4466 8856 Home: (+45) 3874 5696 Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> SQL Server Master Class 8-10 Marts, Database Forum 28-30 October Master Class 17-19 Januar 2005. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Best regards/Venlig hilsen /*Peter Gram*/ <mailto:[EMAIL PROTECTED]> Miracle A/S <http://www.miracleas.dk/> Kratvej 2 DK - 2760 Måløv Cell: (+45) 2527 7107 Phone: (+45) 4466 8855 Fax: (+45) 4466 8856 Home: (+45) 3874 5696 Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> SQL Server Master Class 8-10 Marts, Database Forum 28-30 October Master Class 17-19 Januar 2005. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name
Re: Renumber a set of grupped rows?
Maryann You can use the new windowing function, here is test select working on emp :-) select deptno, row_number() over (PARTITION BY DEPTNO order by deptno) from emp / DEPTNO ROW_NUMBER()OVER(PARTITIONBYDEPTNOORDERBYDEPTNO) -- 101 102 103 201 202 203 204 205 301 302 303 304 305 306 Maryann Atkinson wrote: I have a 1-rows table with 2 columns, Emp_ID and Req_ID. There are about 150 different emp_ids in these 1+ records. What I want to do is the following: For every different Emp_id, I need the Rec_ids that corresponds to it to be updated/renumbered starting from 1 and keep going up by 1. So I want it to look something like this: Emp_ID Req_ID 10001 001 10001 002 10001 003 10001 004 10001 005 10001 006 10001 007 10001 008 10002 001 10002 002 10002 003 10002 004 10002 005 10003 001 10004 001 10004 002 10004 003 10004 004 10004 005 10004 006 etc Any ideas? Thanks, maa -- Best regards/Venlig hilsen /*Peter Gram*/ <mailto:[EMAIL PROTECTED]> Miracle A/S <http://www.miracleas.dk/> Kratvej 2 DK - 2760 Måløv Cell: (+45) 2527 7107 Phone: (+45) 4466 8855 Fax: (+45) 4466 8856 Home: (+45) 3874 5696 Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> SQL Server Master Class 8-10 Marts, Database Forum 28-30 October Master Class 17-19 Januar 2005. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: encrypt back-up data
Hi The data in the database is not changed, the data is encrypted in the sql*net layer. Ehresmann, David wrote: I realize that. Is the data in the table left in its "normal format"? Then when it is used it is encrypted by one of the algorithms? thanks, David. -Original Message- Sent: Friday, January 02, 2004 2:19 PM To: Multiple recipients of list ORACLE-L Hi It is only the data that is passed via sqlnet. /peter Ehresmann, David wrote: Thanks, I will pass it along. Next question: If you are using Oracle's Advanced Encryption standard with one of the following standards: encryption algorithms supported are RC4_40, RC4_56, RC4_128, RC4_256, DES_40, 2-Key 3DES and 3-Key 3DES. Does the data in the table get encrypted or only when it is being communicated across a network? thanks, David Ehresmann. -Original Message- *From:* David Wagoner [mailto:[EMAIL PROTECTED] *Sent:* Friday, January 02, 2004 1:50 PM *To:* '[EMAIL PROTECTED]' *Cc:* '[EMAIL PROTECTED]' *Subject:* RE: encrypt back-up data Veritas NetBackup can do thissearch the Veritas site for NetBackup Encryption 4.5. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com "the most trusted source for STORAGE MANAGEMENT SERVICES" The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. -Original Message- From: Ehresmann, David [mailto:[EMAIL PROTECTED] Sent: Friday, January 02, 2004 10:54 AM To: Multiple recipients of list ORACLE-L Subject: encrypt back-up data Has anybody ever heard of encrypting backup data through Oracle? I have never heard of Oracle being able to do this. I am being asked this question by the account manager: Do you know if Oracle has the capability to encrypt back-up data, and then use a reverse encryption process when restoring the data? thanks, David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Best regards/Venlig hilsen /*Peter Gram*/ <mailto:[EMAIL PROTECTED]> Miracle A/S <http://www.miracleas.dk/> Kratvej 2 DK - 2760 Måløv Cell: (+45) 2527 7107 Phone: (+45) 4466 8855 Fax: (+45) 4466 8856 Home: (+45) 3874 5696 Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: encrypt back-up data
Hi It is only the data that is passed via sqlnet. /peter Ehresmann, David wrote: Thanks, I will pass it along. Next question: If you are using Oracle's Advanced Encryption standard with one of the following standards: encryption algorithms supported are RC4_40, RC4_56, RC4_128, RC4_256, DES_40, 2-Key 3DES and 3-Key 3DES. Does the data in the table get encrypted or only when it is being communicated across a network? thanks, David Ehresmann. -Original Message- *From:* David Wagoner [mailto:[EMAIL PROTECTED] *Sent:* Friday, January 02, 2004 1:50 PM *To:* '[EMAIL PROTECTED]' *Cc:* '[EMAIL PROTECTED]' *Subject:* RE: encrypt back-up data Veritas NetBackup can do thissearch the Veritas site for NetBackup Encryption 4.5. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com "the most trusted source for STORAGE MANAGEMENT SERVICES" The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. -Original Message- From: Ehresmann, David [mailto:[EMAIL PROTECTED] Sent: Friday, January 02, 2004 10:54 AM To: Multiple recipients of list ORACLE-L Subject: encrypt back-up data Has anybody ever heard of encrypting backup data through Oracle? I have never heard of Oracle being able to do this. I am being asked this question by the account manager: Do you know if Oracle has the capability to encrypt back-up data, and then use a reverse encryption process when restoring the data? thanks, David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Best regards/Venlig hilsen /*Peter Gram*/ <mailto:[EMAIL PROTECTED]> Miracle A/S <http://www.miracleas.dk/> Kratvej 2 DK - 2760 Måløv Cell: (+45) 2527 7107 Phone: (+45) 4466 8855 Fax: (+45) 4466 8856 Home: (+45) 3874 5696 Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: pl/sql open cursor question
Hi if we assume it is implements this way (see below) there will only be one cursor since c_gid is a bind variable and there for the cursor will be sharded from call to call of the function. create or replace function XYZ (gid in number) return varchar2 is cursor cur1(c_gid number) is select C1 from tab1 where id = c_gid; begin for x in cur1(gid) loop return x.c1; end loop; return null; exception when others then return null; end; It will only be one coursor Guang Mei wrote: I have a function like below (psudo code). If cursor cur1 have multiple rows, would the code leave the cursor open when this function is called? So if this function is called 1000 times, I would have 1000 open cursors? function XYZ(gid in number) return varchar2 is cursor cur1 is select C1 from tab1 where ID = gid; begin for x in cur1 loop return x.c1; end loop; return null; exception when others then return null; end; -- Best regards/Venlig hilsen Peter Gram Miracle A/S Kratvej 2 DK - 2760 Måløv Cell: (+45) 2527 7107 Phone: (+45) 4466 8855 Fax: (+45) 4466 8856 Home: (+45) 3874 5696 Email: [EMAIL PROTECTED]
Re: Writing a delay in PL/SQL?
Hi try DBMS_LOCK.SLEEP (seconds IN NUMBER); /peter Jonathan Gennick wrote: I know this is going to sound rather crazy, but I want to write an INSERT trigger that imposes an arbitrary delay, say a half second, or maybe a full second, on each and every insert operation. Does anyone know offhand whether there's a built-in PL/SQL procedure to just wait for a specified period of time? Any suggestions on how I can go about implementing this trigger? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word "subscribe" in either the subject or body. -- Peter Gram comp : Miracle A/S Addr : Kratvej 2, 2760 Maaloev Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://www.miracleas.dk Upcoming events: Miracle Master Class with Tom Kyte, 12-14 January 2004 Visit http://miracleas.dk/en/events.html#MasterClass Visit http://www.miracleas.dk fore news ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sql trace - XCTEND rlbk=1, rd_only=1
Boris It look like the app's is doing rollback :-( Have a look in Note 39817.1 Interpreting Raw SQL_TRACE ... for more info. XCTEND rlbk=(0 or 1) rd_only= (0 or 1) rlbk : 1 = rollback 0 = commit rd_only : 1 = read only transaction 0 = none read only /peter Boris Dali wrote: I've got a third party package that connects to Oracle via OCI and works in HTTP-like (stateless) fashion. Reviewing raw SQL trace output I don't see a single commit or rollback there, but there are plenty of XCTEND tx markers with rlbk=1 (after about every SELECT statement). Is this normal? Does this mean that this app rollbacks (implicitly?) after each of those selects? Thanks, Boris Dali. __ Post your free ad now! http://personals.yahoo.ca -- Peter Gram comp : Miracle A/S Addr : Kratvej 2, 2760 Maaloev Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://www.miracleas.dk Upcoming events: Miracle Master Class with Tom Kyte, 12-14 January 2004 Visit http://miracleas.dk/en/events.html#MasterClass Visit http://www.miracleas.dk fore news ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Stop using SYS, SYSTEM?
David You can remove the "create session" priv from the RMAN user and this will make a little harder for most users to connect, but RMAN will work fine :-) David Wagoner wrote: Jared, I followed Robert Freeman's advice and created an RMAN user in all my DBs called backup_admin with SYSDBA privilege so that RMAN doesn't use SYS or SYSTEM. This allows you to change system passwords at will and not interfere with backups. Works just fine. Is this what you were talking about? Perhaps I misunderstood. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com "the most trusted source for STORAGE MANAGEMENT SERVICES" The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. -Original Message- From: Smith, Ron L. [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Subject: Stop using SYS, SYSTEM? We are being asked by Auditing to stop using the SYS, and SYSTEM accounts. They would like for us to create an Oracle Role with the same permissions a SYS and SYSTEM, then grant the role to each of the DBA's. Don't ask me why. Nothing is being audited in 99% of the databases. They just say it in a paper some where so they said we shouldn't use it. This seems like it would cause lots of problems with exports, imports, installs, etc... Has anyone had to deal with this type of request? Any potential problems with making the change? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: Miracle Master Class with Tom Kyte, 12-14 January 2004 Visit http://miracleas.dk/en/events.html#MasterClass Visit http://www.miracleas.dk fore news ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL Plus
Hi No this is not true sqlplusw.exe on w2*k is stil there in the beta kit and I can not find anything about desupport in the manuals :-) Tanel Poder wrote: Hi! Sqlplusw is gone, the windows gui version. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, September 22, 2003 7:19 PM Hello: Was watching Larry Ellison's key note and he mentioned that they still have SQL Plus in 10g. I heard rumor that it was removed. Since it seems as though some from this list have seen it does it still have SQL Plus or has it been removed? Thanks In Advance, Jay _ High-speed Internet access as low as $29.95/month (depending on the local service providers in your area). Click here. https://broadband.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 10g: SQL Plus
Hej Jay Yes it stil there :-) Jay Wade wrote: Hello: Was watching Larry Ellison's key note and he mentioned that they still have SQL Plus in 10g. I heard rumor that it was removed. Since it seems as though some from this list have seen it does it still have SQL Plus or has it been removed? Thanks In Advance, Jay _ High-speed Internet access as low as $29.95/month (depending on the local service providers in your area). Click here. https://broadband.msn.com -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: wrapping packages
Hi Did a "nm -D wrap" this gave heaps of symbols, so wrap is loading shared libs. This means revers engineering a lot of Oracle code :-( Govindan K wrote: Coming to think of it, is the 3Mb size is for stripped or unstripped executable?. I know 3Mb if stripped is not likely to come to 40K. Nevertheless the memory addressing for UNIX is diff. from Windoz. May be someone else in the list has a better knowledge of it. GovindanK <-Original Message-> *From: Tanel Poder* Sent: 9/20/2003 2:44:48 PM To: [EMAIL PROTECTED] Subject: Re: wrapping packages I checked, the wrap executable in 8.0.6 dist for solaris is about 3MB, but for 9.2 in Windows it's only about 40k. It shouldn't be that hard to reverse engineer it. Probably the ones who already have cracked the algorithm aren't spreading the knowledge - why should they anyway?! Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" Sent: Sunday, September 21, 2003 12:29 AM > Hi Pete > > I must point out that there must be a unwrap, since the Oracle database > can run the wrapped pl/sql code :-) > > It is based on trust in Oracle coopera! tion / development. > > Some times it would make since to write the code in c/c++ since it > harder to revers. > > Pete Finnigan wrote: > > >Hi > > > >Very true, but if there was the wrap process wouldn't be much use as > >anyone could un wrap your code. But you are right the main reason to be > >cautious is to not delete your source code locally. > > > >kind regards > > > >Pete > > > >In article , bhabani s pradhan > > writes > > > > > >>one caution: > >> > >>there is no unwrap cmd/exe > >> > >>Regards > >> ___ Get Your 10MB account for FREE at http://mail.arabia.com ! Access MILLIONS of JOBS *NOW*! <http://ads.arabia.com/?SHT=text_email_english> -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: wrapping packages
Hi Pete I must point out that there must be a unwrap, since the Oracle database can run the wrapped pl/sql code :-) It is based on trust in Oracle cooperation / development. Some times it would make since to write the code in c/c++ since it harder to revers. Pete Finnigan wrote: Hi Very true, but if there was the wrap process wouldn't be much use as anyone could un wrap your code. But you are right the main reason to be cautious is to not delete your source code locally. kind regards Pete In article <[EMAIL PROTECTED]>, bhabani s pradhan <[EMAIL PROTECTED]> writes one caution: there is no unwrap cmd/exe Regards -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: FAO: Peter Gram
Sorry Undskyld Förlåt Entschuldigen Excuser Excusa Desculpa Giustificazione Jamadagni, Rajendra wrote: Sorry list ... Pete, your email has again gone secure Raj This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1 -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Anyone have a copy of DUL ??
Hi Pete I have used Dul many times at customer sites when I was employed by Oracle Denmark. Every time the customer management had to verify by phone and fax that they understood the full impact of using Dul. Oracle have disclaimer that explains the problems with missing transaction consistency of the data saved by Dul and the security issues. The customer has to sign and fax the disclaimer back to Oracle before we came on site .-) After I left Oracle several people ask me if would write a Dul and I declined. I'm of the opinion that Dul should stay behind the Oracle firewall. /peter Pete Finnigan wrote: Hi Mark I agree with you Mark, even if its supplied by Oracle technicians - it is as you say possible to by-pass security completely. Does anyone in Oracle check that the field support personnel dispatched to a site ( in urgency ) are dumping data for the owner of it? - I covered the issue of DUL with regards to security is the SANS Oracle security step-by-step book - action 6.5.1 kind regards Pete In article <[EMAIL PROTECTED]>, Mark Leith <[EMAIL PROTECTED]> writes One problem I see with giving this away "free" is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG "no no". I suppose that also applies to this kind of tool even under a paid license structure. -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 smime.p7s Description: S/MIME cryptographic signature
Re: Move SQL Server Tables to Oracle
Hi Gunner You can push data from the sql server via DTS (Data transformation services) or pull the data from the Oracale database via (Heterogeneous services) Gunnar Berglund wrote: Hi all, I need to move some sql server tables to oracle. Do you have some ideas how to do it. I have no idea ... rgds G Want to chat instantly with your online friends? *Get the FREE Yahoo! Messenger* <http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.com/> -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 smime.p7s Description: S/MIME cryptographic signature
Re: question on spfile and pfile
Jin *CREATE PFILE* [= 'pfile_name'] *FROM* SPFILE [= 'spfile_name']; Will create a pfile from the current content of thr spfile :-) CHEN,JIN wrote: Hi there, I found my SPFILE and PFILE are pointing to the same one that is spfile.ora. Now, I want to multiplex control file and books tell me to change in init.ora. I wonder how can create a init.ora from SPFILE. I knew there is one in $ORACLE_BASE/admin//pfile when I created database. But I might change some parameters by "alter database ..." or "alter system ...", like changing to ARCHIVELOG and multiplexing redo log. I am not sure if current spfile is different from that init.ora. Please help! thanks, Jin -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 smime.p7s Description: S/MIME cryptographic signature
Re: Forms 3 and 9i
Hi Yes it is posible to use Forms 3.x agenst a version 9.x database. My friend and coworker have implanted it at site on a sun box. The way to do this is to install Forms 3.x ( 7.2.x dist ?) in a new $OH and apliey a Forms 4 patch (xxx) to the forms $OH. Set the unix environment var. TWO_TASK to point to a IPC alias to the listener that can connect to the 9.x database. The hard part is to find the Forms 4 patch (xx) it is not possible to order it from Oracle support but I think it as distributed with the 7.3.x Oracle database kit ! Senthil Kumar wrote: Hi All, Will forms 3 works with 9i. Any known issues in this. TIA, Senthil. -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Event 10235
Daniel >From $ORACLE_HOME/rdbms/mesg/oraus.msg (10235, 0, "check memory manager internal structures") you can see that this a event to checkthe db memory structures. The level specifices how much to check. You vil get the full explanation in note 21208.1 EVENT: 10235 "check memory manager internal structures Daniel Fink wrote: One of our databases has the 10235 (level 2) event set. Unfortunately, the Metalink doc is very sparse (barely more than oerr). It mentions that it protects internal memory management structures. What I am needing are reasons why this event would be set. Anyone have experience with this event and what some of the motivations were? Dan -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004
Re: what is BAARF?
Hi Have a look at http://www.baarf.com/ [EMAIL PROTECTED] wrote: I see it here all the time. Any articles on it? Im assuming its some kind of storage system right? -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i-OCP Question
Hi I don't want to create a fight, but in a configuration with 2 groups and 4 members you need 8 disks : 1 disk for every member. When the db is writing to one group the archiver will be reading from the other group, by the why since there are multibe members in the group the db (archiver) will read 64 Kb chunks from the each member and there by distribute the IO That's my 2 cent's of knowledge, comment and correction are welcome :-) Mladen Gogala wrote: There are two reasons: 1) Redo log groups are never used simultaneously, so they can reside on the same disk. Log members should not be on the same disks for increased survivability. That gives us 2 groups with 4 members, each two members sharing the same device - 4 disks alltogether. 2) It's because I say so and I'm an 8i OCP. On 2003.07.30 13:44, KENNETH JANUSZ wrote: Why? What is the logic? Ken Janusz, CPIM - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 30, 2003 12:29 PM > The answer is 4. Of course, no one in the right mind would have > 2 groups with 4 members each. > > On 2003.07.30 13:19, Senthil Kumar wrote: > > Hi all, > > > > What is the correct answer for this? > > > > Q> If you have 2 redo log groups with 4 members each, how many disks does > > Oracle recommend > >to keep the redo log files? > > > > 1. 8 > > 2. 2 > > 3. 1 > > 4. 4 > > > > Which is the correct answer. > > > > TIA > > Senthil > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Senthil Kumar > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-01041: internal error. hostdef extension doesn't exist
Sami You have to set ORACLE_SID to your instance name, The oracle software can not gues the name of the instance. You can set the ORACLE_SID in the registey, the global -, the local - or the the local session enviroment. [EMAIL PROTECTED] wrote: Hi Murray I'm running Win 2000. 1)OracleService is running. 2)But why do i need listener? I'm not going to use connect string. Thanks Sami "Murray, Margaret" <[EMAIL PROTECTED] To eating.com> Multiple recipients of list Sent by: ORACLE-L <[EMAIL PROTECTED]> [EMAIL PROTECTED] cc .com Subject RE: ORA-01041: internal error. 06/25/2003 10:09 hostdef extension doesn't exist PM Please respond to [EMAIL PROTECTED] com Are you running on NT or Windows 2000? If so, make sure both the TNSListener service and the OracleService are running. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Subject: ORA-01041: internal error. hostdef extension doesn't exist Hi All, I have the following environment variable set ORACLE_HOME ORACLE_SID TNS_ADMIN init.ora file = REMOTE_LOGIN_PASSWORDFILE=NONE sqlnet.ora file SQLNET.AUTHENTICATION_SERVICES= (NTS) I'm getting the following error. What could be wrong? SQL> connect / as sysdba ERROR: ORA-01041: internal error. hostdef extension doesn't exist Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 8i OCP Question
Hi And answer D is not correct since Rman works fine without a tape subsystem, by writing to Disk :-) Gary W. Parker wrote: The answer is D; RMAN does not require a recovery catalog RMAN only supports multi-level incremental backups when DB is in Archivelog mode RMAN is NOT compatible with EBU -Original Message- Jay Wade Sent: Tuesday, June 17, 2003 2:45 PM To: Multiple recipients of list ORACLE-L Hello: I'm taking a 8i Backup & Recovery Practice test and believe the answer key might be off. Question Which statement regarding Recovery Manager with a database operating in NOARCHIVELOG mode is true? A) Recovery Manager requires a recovery catelog B) Recovery Manager syooirts multi-level incremental backups C) Recovery Manager is compatible with Enterpise Backup utility D) Recovery Manager only works in conjunction with a tap subsystem Anwser key says that D is the correct answer. I would say that C is the correct answer since only a full offline backup can be performed. Thanks in Advance, Jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856 mailto:[EMAIL PROTECTED] - http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Rule Based Optimizer
number of folks on the list who have some insight into the next version of the database. I'd like to ask those folks a simple question. What is the future of the Rule Based Optimizer looking like? Does it die in 10i?? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856 mailto:[EMAIL PROTECTED] - http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Standby errors
Hi I would recommend that to use the 'alter system archive log current;' since this command don't return until the database has finished to archive the redo logfile. Hemant K Chitale wrote: Rather than doing an ALTER SYSTEM SWITCH LOGFILE only, issue an ALTER SYSTEM ARCHIVE LOG NEXT I actually do an ARCHIVE LOG NEXT, SWITCH LOGFILE and also have a sleep in the backup-script, which then proceeds to copy all but the *last* archivelog out to tape ! Hematn At 06:19 AM 14-03-03 -0800, you wrote: Oracle 8.1.6 on Solaris 5.8. We have a read-only standby database for one of our production databases. Each night, the standby is shutdown and the previous days archive logs from production are applied. Then the database is brought backup in read-only mode. To get the archive logs, a hot backup is done on the production database. As the last step is the hot backup, a log switch is done and then the archive logs are ftp'd to the server where the standby is. After the hot backup completed yesterday, the log switch occurred, and the logs sent, but when an attempt was made to apply the archive logs we got an error: ORA-00332: archived log is too small - may be incompletely archived ORA-00334: archived log: '/orabackup/archive/TBSPRD/arch1352.arc' ORA-332 signalled during: ALTER DATABASE RECOVER In looking at the archive log, both on the production and standby servers, they are the same size - 16k (the block size for the db is 8k). The next log is 8k in size and then there is another that is 16k before we see any that are normal sized. These would have been the first logs _after_ the hot backup the night before. In the alert log for the production db, it appears the log 1353 was archived _before_ 1352. Has anyone seen this behavior before? Does anybody have any idea why it happened in the first place? Is there something we can do to make sure it never happens again? P.S. We are upgrading to 9.2 this weekend, if that makes any difference. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My personal web site is : http://hkchital.tripod.com -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856 mailto:[EMAIL PROTECTED] - http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: First version with multiple archiver processes?
Kirti From version 7.x you can manually start multiple archive processes by using the "archieve log start to " and the added processes wil die when there is no more redofiles to archive, but for permanent having multiple processes the answer is 8.1.3 :-) Deshpande, Kirti wrote: I can think of 8.1.3. - Kirti -Original Message- Sent: Wednesday, February 05, 2003 6:04 PM To: Multiple recipients of list ORACLE-L What was the first version of Oracle with the ability to start multiple archiver processes? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856 mailto:[EMAIL PROTECTED] - http://MiracleAS.dk smime.p7s Description: application/pkcs7-signature
Re: tim column in trace output
't think we've been able to prove that the value resets when you do an instance restart. Perhaps the value is a modulus of a gettimeofday() value.) 4. Item #3 has never really bothered us, because all we generally care about is *relative* tim values, not absolute ones. You can establish a mapping of tim values to wall clock values by comparing the timestamp in a '***' line to the nearest tim value to it. 5. Oracle9i makes life a little more fun, because tim values become microsecond (0.01s) values, and they appear to be unadulterated gettimeofday() values, with an Epoch of 00:00:00 UTC, 1 January 1970 (we *think* this is true on all platforms). Hence, it becomes easy to convert from tim values to wall clock values and back with a simple Perl script that uses str2time and time2str function calls. 6. Finally, a minor detail correction: the tim of a given line in the trace file tells you the time at which the given cursor action *completed*. You certainly aren't incorrect by saying it's the time that something "ran," but saying "completed" is a little more precise. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - 2003 Hotsos Symposium, Feb 9-12 Dallas - RMOUG Training Days 2003, Mar 5-6 Denver - Hotsos Clinic 101, Mar 26-28 London -Original Message- Jankovic Sent: Friday, January 24, 2003 6:55 AM To: Multiple recipients of list ORACLE-L Anybody knows what is the reference point for the timing used in the "tim" column in the trace output, like in: PARSE #3:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=832261739 EXEC #3:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=832261739 Apparently the scale is 100 per second for 8i and 976,562.5 (1,000,000,000/1024) for 9, but I am not quite clear what could be the reference time (the time when counting of tim starts). In different databases I tried it, it is usually few months to a year back. BTW, this column can be used if one needs to find out the exact time when a query from the trace was run. Thanks. Djordje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Djordje Jankovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856 mailto:[EMAIL PROTECTED] - http://MiracleAS.dk smime.p7s Description: application/pkcs7-signature
RMAN error when deleting archivefiles on tape
Dear RMAN Wizards I have this problem with a script for deleting archive file on tape. The story is that this script has worked perfect for more than a 2 year until the database and there by rman was upgraded to 8.1.7.4 from 8.1.6..x. The media manager is TSM (IBM Tivoli) and everything is running on a Win NT 4 sp 6a. The odd thing is that backup and restore works OK, this was tested. The NT box is using TSM to send the the backup to a MVS that has the tape robot attached. I have looked at Metalink / Google and IBM Web support without getting a sensible clue. -- Start Fri 03/01/2003 10:29 Recovery Manager: Release 8.1.7.4.1 - Production RMAN-06005: connected to target database: TMSPRD8 (DBID=4183866567) RMAN-06008: connected to recovery catalog database RMAN> allocate channel for delete type 'SBT_TAPE'; 2> change backuppiece '/archivefiles/af_TMSPRD8_480164575_21631_1' delete; 3> change backuppiece '/archivefiles/af_TMSPRD8_480197119_21669_1' delete; 4> change backuppiece '/archivefiles/af_TMSPRD8_480197446_21670_1' delete; 5> change backuppiece '/archivefiles/af_TMSPRD8_480197663_21671_1' delete; 6> change backuppiece '/archivefiles/af_TMSPRD8_480197810_21672_1' delete; 7> change backuppiece '/archivefiles/af_TMSPRD8_480250980_21673_1' delete; 8> change backuppiece '/archivefiles/af_TMSPRD8_480251087_21674_1' delete; 9> change backuppiece '/archivefiles/af_TMSPRD8_480251194_21675_1' delete; 10> change backuppiece '/archivefiles/af_TMSPRD8_480251313_21676_1' delete; 11> change backuppiece '/archivefiles/af_TMSPRD8_480251421_21677_1' delete; 12> change backuppiece '/archivefiles/af_TMSPRD8_480251531_21678_1' delete; 13> change backuppiece '/archivefiles/af_TMSPRD8_480251648_21679_1' delete; 14> change backuppiece '/archivefiles/af_TMSPRD8_480284960_21717_1' delete; 15> change backuppiece '/archivefiles/af_TMSPRD8_480285117_21718_1' delete; 16> change backuppiece '/archivefiles/af_TMSPRD8_480285323_21719_1' delete; 17> change backuppiece '/archivefiles/af_TMSPRD8_480285480_21720_1' delete; 18> release channel; 19> exit; RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: delete RMAN-08500: channel delete: sid=71 devtype=SBT_TAPE RMAN-08526: channel delete: Tivoli Data Protection for Oracle: version 2.2.0.0 RMAN-03022: compiling command: change RMAN-03023: executing command: DELETE RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03006: non-retryable error occurred during execution of command: change RMAN-07004: unhandled exception during command execution on channel delete RMAN-10035: exception raised in RPC: ORA-19509: failed to delete sequential file, handle="/archivefiles/af_TMSPRD8_480164575_21631_1", parms="" ORA-27027: sbtremove2 returned error ORA-19511: ANS0238E (RC2041) The sequence of calls is invalid. RMAN-10031: ORA-19509 occurred during call to DBMS_BACKUP_RESTORE.CHANGEBACKUPPIECE Recovery Manager complete. -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856 mailto:[EMAIL PROTECTED] - http://MiracleAS.dk smime.p7s Description: application/pkcs7-signature
Re: ORA-00600: [2662]
Mogens I do agree that this ora-600 [2662] is in the code that handle SCN numbers, since SCN handling is used many places in the code the stack trace that show which path throw the code you took is necessary if there is no hits on metalink fits the problem ;-) Mogens Nørgaard wrote: This response from Oracle is not a good one. Kirti is on the right track regarding the SCN stuff as far as I remember. Other than that, I know that Peter Gram and Bjorn Engsig (among a lot of other guys) might be able to suggest something, so I've CC'ed them. I have my own law on ora-600s: If you supply all the required information (tracefiles, alertlogs, repro-case, etc.) chances are Support is not gonna need them. If you miss out just one of those things, chances are Support will tell you they cannot proceed without that vital piece of information. In other words: There's no hope :-))) Could also be related to db-links between v7 and v8... But back to the good questions from Kirti: Have you set the funny _-parameters he mentions? Mogens PS: I do beleive there are ways around this with an alter system or alter session command where you bump the SCN some , but Peter/Bjorn/someone can confirm this. Sinardy Xing wrote: Hi guys, This is what I get from Oracle == Hi Sinardy, I've check several bug looking for the cause of this problem. However, what I've found is that Development could not diagnosis the problem other than the possibily hat there was some memory corruption that gave a bad SCN. Although, they could "sometimes" determine the root cause prior to the problem occurring by using certain parameters were set in the database. Those parameters are: a)_db_block_cache_protect. b)_db_block_checking c)DB_BLOCK_CHECKSUM They also recommended running dbverify on all datafiles tomake sure all files are clean on disk. IMPORTANT == These parameter may help later determine what cause the ORA-600 [2662] (and it's not for certain that a cause can be found). They parameters does have some performance overhead, but unfortunately this is the only way that can help in catching and we have to wait until the problem happens again. So, the bottomline is there is no list of reason for why this error occuring other than the error occurs when a data block SCN is ahead of the current SCN. Sorry Sinardy, we don't have more information. Thanks! Wonda = What can I do, help me please... Sinardy -Original Message- Sent: 07 January 2003 13:09 To: Multiple recipients of list ORACLE-L Sinardy ORA-0600 is really an encoded message from Oracle that reads : 'Thank you for helping find yet another bug in our software. You can now release your sphincter (some herbal tea might help), especially if this has cropped up in production. We suggest you do not try to solve this one by yourself, which is why the arguments are supplied. Kindly call OWWS with your CSI number, tell them exactly which version and platform you ran this on, and if we have encountered this previously, there is a small chance that we could have a patch. If not, please do not hold your breath waiting, while we assign this to an experienced software engineer, or perhaps a recent college grad, in which case, you're toast !' However, we will ask you to ftp up to our ftp site loads of dumps and traces which might prove useful. Seriously though, ORA-0600 are mysteries. Your best chance is to get Tim Gorman to look at it, he has an amazing knowledge of these. And of course, Tim should not work for free either. (Tim, it was 10% commission we agreed on, right ? ) :-) Ferenc Mantfeld -Original Message- From:Sinardy Xing [SMTP:[EMAIL PROTECTED]] Sent:Tuesday, January 07, 2003 2:34 PM To:Multiple recipients of list ORACLE-L Subject:ORA-00600: [2662] Hi all, I hit by this error ORA-00600: internal error code, arguments: [2662], [0], [54151123], [0], [54173017], [16781180], [], [] Can you help me where to find info about this error Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856 mailto:[EMAIL PROTECTED] - http://MiracleAS.dk smime.p7s Description: application/pkcs7-signature
Re: year 2059 problem
Hi I have just tested with 2037 on a linux (2.4.18) with rdbms 9.2.0.2 and this works. Lyndon Tiu wrote: Hmmm, anyone tried Linux Oracle with year 2059? -- Lyndon Tiu On Sunday 29 December 2002 08:28 pm, Amit Nargotra wrote: This strange problem we are facing while implemting Oracle Based ERP at Nepal for asian paints. Nepal follows Hindu calender, as per the hindu calender the current year is 2059. as we try to install oracle 9i keeping year as 2059. oracle gets installed, but it is unable to create database.(OS is windows - 2000 server) even D2K is not running on 2059. we have tried different years and we found that till 2035 oracle is able to create database after 2035 it fails to create database. we have contacted oracle india also. they have said this is windows related problem. can any body help us out. Thanks in advance. -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856 mailto:[EMAIL PROTECTED] - http://MiracleAS.dk
Re: Win2k/8.1.7.3/Optimizer Weirdness
Same thing in 9.2.0.2 on linux Clark, Tommy R wrote: I was able to duplicate this on my 9.0.1.1.1 database running on Win2K. -Original Message- Sent: Tuesday, November 19, 2002 1:17 PM To: Multiple recipients of list ORACLE-L Hi Listers: Has anyone ever seen something like this before? Can somebody explain it to me? Thanks, Mike SQL> SQL> select file_name from dba_temp_files; File Name - E:\ORANT\ORADATA\ECRMP\TEMP01.DBF 1 row selected. SQL> select /*+ RULE */ file_name from dba_temp_files; no rows selected SQL> --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856 mailto:[EMAIL PROTECTED] - http://MiracleAS.dk smime.p7s Description: application/pkcs7-signature
Re: Port usage?
Don Oracle is doing the normal ting : it is using port 1521 for calls to find the listener and then calling back on another port to spread the load over multiple port's. This is done a port has a limited queue to hold in- and out- coming messages. If you what to use Oracle listener and database behind a firewall by a sql*net proxy for the firewall and the firewall is then able to handle sql*net without problems. Don wrote: Environment: Oracle 8.1.6 AIX server behind a firewall db is accessed by a Windows application running on a IIS web server sitting outside the firewall db uses port 1521 After a flurry of email between the Unix admin and the 4 software vendors concerned, all the fingers are now pointing at "that damn oracle database". The Unix admin is asking two questions: 1) what Oracle is doing with the four ports 20,000 - 20,003 2) can he shut them down? Any ideas are appreciated. -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856 mailto:peter.gram@;MiracleAS.dk - http://MiracleAS.dk smime.p7s Description: application/pkcs7-signature
Re: will the Return Order of rows change with time ?
Hi Without a order claus on the statement there is no granti of the order the rowes are rurned. This is not specific to Oracle but part of the sql standard. Ratnesh Kumar Singh wrote: Hi I have a very large DW table in which there are only inserts and NO updates/deletes. The table grows by around 2-5 % every week due to new inserts. I need to return the rows for each customer in the same order as inserted to table. Due to design/delivery constraints , i cannot modify the table. ques 1 : if i do a 'select * from table' with where clause but no order by clause, will the Order of rows returned be the same whenever this query is executed ? Is this gauranteed by Oracle ? ques 2 : if i export/import this table , then execute the same query, will the Order of rows returned be the same as before the export/import ? ques 3 : if i use the 'move' cmd to rebuild this table , then execute my query, will the Order of rows returned be the same as before the rebuild ? any explanations are most welcome many thanks ratnesh singh - Ratnesh Kumar Singh Sr. Software Engineer Patni Computer Systems Ltd TTC Mahape , Navi Mumbai Work : (91 22) 7611090/110/128/350 Ext. 2107/2106 Home : (91 22) 8662162 http://www.patni.com World-Wide Partnerships. World-Class Solutions. ----- -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856 mailto:peter.gram@;MiracleAS.dk - http://MiracleAS.dk smime.p7s Description: application/pkcs7-signature
[Fwd: [Fwd: RE: Forms 3.0 ; Oracle 8i/9i ; Patch 380665 ; HP-UX 11]]
Hi Kurth This is from Johannes that is not on the oracle-l mailing list. I have no knowlegde about patch 380665 but I have a happy customer running Forms 3.0 (version Version 3.0.16.12 from the Oracle 7.2.3 installation CD) in an Oracle 7.2.3 home on Sun Solaris (SunOS 5.7), with TWO_TASK set to point at an Oracle 9i instance on another server. So it can work for sure! I would imagine that there could be problems with the installation and execution of Forms 3.0 on some newer operating systems. I tried for years to find a patch that would allow Forms 3.0 to work with Oracle8.x.x. I think there is a path for NT, but none for Unix. Time to bite the bullet and upgrade to Forms 4.5 or higher. -Original Message- Sent: Wednesday, September 25, 2002 2:59 PM To: Multiple recipients of list ORACLE-L Hello guys, I am trying to figure out the mystery of Patch 380665, which allows Forms 3.0 to be used with Oracle 8.1.7 I have a few questions 1. Does this patch exist or is it just a myth? 2. Is this a Database patch or Forms patch? 3. How to get this patch? I would really appreciate if any of ull have travelled this path of trying to make Forms 3.0 work with Oracle 8i. Thanks Mandar -Original Message- Sent: Wednesday, September 25, 2002 11:34 AM To: Mandar A. Ghosalkar -- >>>> SEARCH ORACLE-L 380655 The archive for this mailing list exists, but cannot be accessed. This may be due to the server being down or some other network problem. Please contact [EMAIL PROTECTED] for further assistance. Sorry for the inconvenience. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter. The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance. If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail. Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kurth, Michael J. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk smime.p7s Description: application/pkcs7-signature
Re: log_file_sync io wait question
Hi Pat There is not a lot you can do since every commit will force a write to the disk ! You are hitting that limit of the disk that normally is app. 100 - 120 I/O per sek. The only real fix is change the application to do less commit's. It will not help to change the size of the redo log buffer or the redo log files if you have multiple redo log members on the same disk it will help to separate the members to different disk's but it will not fix the design problem of committing for every insert. Somebody might suggest you to put a chach on the redo log file system but don't this very dangerous since Oracle assumes that writes to disk's are true writes and if you ever had a loss of the chach there is a big chance that your database would loose transactions :-( Pat Howe wrote: >We have a canned package that we use to insert approx 100 records/second >into one table (oltp environment). >Each record is just under 1K (datatypes = number and varchar). >There are several indexes that are build on the table as the records are >inserted. >Each and every record is committed. >Therefore we are flushing the 'redo log buffer' to disk (online redo >logfiles) 100 times per second (once per commit). > >Not surprisingly we have noticed IO waits which we believe are associated >with our 'Redo Log buffer'. Namely ; > log_file_sync = 180 waits/sec > log_file_parallel_write = 180 waits/sec > >We tried resizing the 'redo log buffer' from 16K to 256K - but we did not >notice any improvements. >Neither Log switching or archiving seem to be excessive. >100 records per second seems to be our maximum speed without the application >queuing up and Oracle showing very high waits on log_file_sync and >log_file_parallel_writes. > >Does anyone know how we might be able to minimize the IO waits? > >Thanks in advance. > >ENVIRONMENT >oracle : Oracle 8.1.7.4 >os : Sun Sparc Solaris 8 >box: 8x8 E10K >IO : Hitachi SANS unit through fiber and Brocade switch > > >_ > Patrick J. Howe > > > > > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk smime.p7s Description: application/pkcs7-signature
Re: Recover an unrecoverable database
Hi Dan It should be possible to open that database ! 1) You should restore the databse from tape once more to make sure we start on somthing clean. 2) Add the _allow_resetlogs_corruption=true to the parameter file (init.ora) 3) Mount the database and create new controlfiles 4) Do a fake recovery via 4.1) recover database; 4.2) when it asks for a archive file type 'mogens' 4.3) cancel the recovery session 5) Open the database with resetlogs You migth need to corrupt the Rollback as well with _corrupted_rollback_segments=(xx, xx, xx) where 'xx' are the names of the rollback segments in the database. If the database makes a fuzz abut not being in Archive log mode that can be fixed when you create the control file. There are alwas the the real brut force way : create a database with the same name and that same datafiles, redologfiles, and controlfile and then copy the header blocks from the datafile's to the old database with dd. -Original Message- Sent: Wednesday, September 11, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Here's the scenario - A backup was done of a database that had been shutdown with the abort option. The redo logs (no archiving) are also backed up. The controlfiles have since been lost. Business request - Retrieve a schema that has since been dropped from the database. Attempted solution - restore the backups, open the db without performing recovery (resetlogs and readonly corruption allowed). Unfortunately, this resulted in an ORA-00600 when it attempted to read the SYSTEM datafile. Does anyone have any ideas of how to open this db so we can get the data out of the schema? We don't care if it is not consistent. All assistance is appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk smime.p7s Description: application/pkcs7-signature
Re: truss/trace/strace equivalent on Windows
Hi Danisment Long time no see There is free version of truss for nt called strace (http://razor.bindview.com/tools/desc/strace_readme.html) this migth help you Have fun ;-) Danisment Gazi Unal (ubTools) wrote: > Hi to all, > > I need a utility to debug Oracle's thread on Windows2000. do you know > a utility which can trace windows system calls in thread level ? > > thanks in advance... > > -- > Danisment Gazi Unal > > http://www.ubTools.com > Web-based Oracle Database Products > > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk smime.p7s Description: application/pkcs7-signature
Re: normal user obtaining program info?
Hi Eva Have a look at VPD (Virtual Privet Database) and FGA Fine Grained Access) in the manual Denham Eva wrote: > Hello Gurus, > > I would like to try and build in some security onto a certain schemas > tables, using for instance from system, I can do a select from > v$session to obtain program name etc. ie, > > SELECT PROGRAM FROM V$SESSION; > > An extention of this a user "with the rights" can do :- > SELECT PROGRAM FROM V$SESSION > WHERE SID IN (SELECT SID FROM V$MYSTAT); > > I really don't want to give all the users these rights. > > Is there any query that a normal user can run which returns the same > information as the above? ie program name. > Using auditing is a rather impractical option, as the growth would be > huge, the idea is to capture only the changes and users that > update/insert/delete using undesignated software ie MS Access. > > Regards > Denham Eva > Oracle DBA > In UNIX Land > On a quiet Night, you can hear the Windows machines reboot. > > > > DISCLAIMER > > This message is for the named person's use only. It may contain > confidential, proprietary or legally privileged information. No > confidentiality or privilege is waived or lost by any mistransmission. > If you receive this message in error, please immediately delete it and > all copies of it from your system, destroy any hard copies of it and > notify the sender. You must not, directly or indirectly, use, > disclose, distribute, print, or copy any part of this message if you > are not the intended recipient. TFMC, its holding company, and any of > its subsidiaries each reserve the right to monitor and manage all > e-mail communications through its networks. > > Any views expressed in this message are those of the individual > sender, except where the message states otherwise and the sender is > authorized to state them to be views of any such entity. > > > > This e-mail message has been scanned for Viruses and Content and > cleared by MailMarshal - For more information please visit > www.marshalsoftware.com <http://www.marshalsoftware.com> > > > > DISCLAIMER > > This message is for the named person's use only. It may contain > confidential, proprietary or legally privileged information. No > confidentiality or privilege is waived or lost by any mistransmission. > If you receive this message in error, please immediately delete it and > all copies of it from your system, destroy any hard copies of it and > notify the sender. You must not, directly or indirectly, use, > disclose, distribute, print, or copy any part of this message if you > are not the intended recipient. Contract Forwarding, its holding > company, and any of its subsidiaries each reserve the right to monitor > and manage all e-mail communications through its networks. > > Any views expressed in this message are those of the individual > sender, except where the message states otherwise and the sender is > authorized to state them to be views of any such entity. > > > > This e-mail message has been scanned for Viruses and Content and > cleared by MailMarshal - For more information please visit > www.marshalsoftware.com <http://www.marshalsoftware.com> > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Home : +45 3874 5696 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk /* The process of preparing programs for a digital computer is especially attractive, not only because it can be economically and scientifically rewarding, but also because it can be an aesthetic experience much like composing poetry or music Donald Knuth */ smime.p7s Description: application/pkcs7-signature
Re: Deleting a Datafile
Hi You can use the "alter database datafile '/path/file_name' resize M;" to make a bigger file ;-) no need to remove the file from the tablespace ! Sathish Tatikonda wrote: >Hi All, > >Is it possible to delete a datafile from a tablespace? What I want to do it to move >the data from one data file to a bigger data file and delete the old file. > >If will be of great help to me if any pointers are provided for the same. > >thanks in advance, >Sathish. > > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Home : +45 3874 5696 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk /* The process of preparing programs for a digital computer is especially attractive, not only because it can be economically and scientifically rewarding, but also because it can be an aesthetic experience much like composing poetry or music Donald Knuth */ smime.p7s Description: application/pkcs7-signature
Re: C++ classes
Waleed In version 9i there is very neat C++ classes for OCI to be able to access Oracle. Have a look at Oracle C++ Call Interface Programmer's Guide ( http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/appdev.901/a89860/toc.htm ). If you Khedr, Waleed wrote: >Check this: http://www.roguewave.com/products/sourcepro/db/ > >Waleed > >-Original Message- >To: Multiple recipients of list ORACLE-L >Sent: 7/7/02 10:28 AM > >Hi, > > Is there any reliable C++ class library to access >Oracle DB > >Vishal >_ >There is always a better job for you at Monsterindia.com. >Go now http://monsterindia.rediff.com/jobs > > > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Home : +45 3874 5696 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk /* The process of preparing programs for a digital computer is especially attractive, not only because it can be economically and scientifically rewarding, but also because it can be an aesthetic experience much like composing poetry or music Donald Knuth */ smime.p7s Description: application/pkcs7-signature
Re: Import PUBLIC
Hi Kamel Please explain why you want to import the PUBLIC user ! GL2Z/ INF DBA BENLATRECHE wrote: >Hi All > > > How to import PUBLIC from a Full export ? > Can we do FROMUSER=PUBLIC TOUSER=PUBLIC ? > > Thanks > >Regards >Kamel Benlatreche > > > > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk /* The process of preparing programs for a digital computer is especially attractive, not only because it can be economically and scientifically rewarding, but also because it can be an aesthetic experience much like composing poetry or music Donald Knuth */ smime.p7s Description: application/pkcs7-signature
Re: Online vs offline backups
All backupers If doing a "off-line backup" some call it a "cold backup" you should backup All datafiles, All control files, All Redolog files and All Parameter files this vil produce a self-contained package that will be able ti start assuming no media recovery is needed. I know that Rman vill not backup redolog file the reason for rman not doing this is that Rman knows if it is safe to omit the redolog files (The database has to bee in mount mode for Rman to backup's ) Ferenc Mantfeld wrote: >-Original Message- >Sent: Wednesday, 19 June 2002 5:38 AM >To: Multiple recipients of list ORACLE-L > > >Ferenc Mantfeld£¬ > > > >>The same person that advocated a cold backup >>did not back up the online redo logs, so what use was it anyway, since the >>only way they would force open their DB is with a resetlogs option anyway. >> >> > For cold backup, oracle does not recommend backup the online redo >log. And if you restore the whole cold backup, why need the online redo log? >I am sure people doing cold backup will do shutdown normal/immediate, not >shutdown abort.So there is no need to backup the online redo log at all! >Backup the online redo log also take the risk of damage the current online >redo log when you want to do full recovery. > So, never backup the online redo log when doing cold backup. > >FM : and hopefully in time you will come to the realization that not all >that Oracle recommends is good, or has passed a decent degree of sanity >checking. But I can see that the PR and hype machine still works well. > >Apologies for starting this pissing contest, I have my convictions based on >true life experiences, rather than from attending a course. I suggest >reading Rama Velpuri's book on backup and recovery first. Then if you want >to simply open the database as it was at the time of cold backup, if your >online redo logs have not been restored, you will need to perform recovery. >An you cannot restore what has not been backed up. Amen ! Chapter closed ! > >redo log corruptions are another deal altogether. > >Ö >Àñ£¡ > >chal_ping >[EMAIL PROTECTED] > > > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Ma*l?v http://miracleas.dk /* The process of preparing programs for a digital computer is especially attractive, not only because it can be economically and scientifically rewarding, but also because it can be an aesthetic experience much like composing poetry or music Donald Knuth */ smime.p7s Description: application/pkcs7-signature
Re: ORA-00604 and ORA-01578
Hi BigP Create a tablespace corrupt.dbf fill it with a table. Use dd to write junk in the middle of the datafile and you have a ora-1578 BigP wrote: >Just to learn this thing , ..how can I corrupt a block in my test >environment . >o . but be ready to help me if I am not able to repair it . >Thanks , >Bp >- Original Message - >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Thursday, June 13, 2002 4:23 AM > > > >Is there any PERFORMANCE Overhead on Setting DB_BLOCK_CHECKING = TRUE >in the init.ora . >Any Best practice on this parameter Setting ? > >Thanks > > >-Original Message- >Sent: Wednesday, June 12, 2002 12:34 AM >To: Multiple recipients of list ORACLE-L > > >Resend. > >-Original Message- >Sent: Tuesday, June 11, 2002 12:45 PM >To: '[EMAIL PROTECTED]' >Cc: '[EMAIL PROTECTED]' > > >Peter - You can use the DBMS_REPAIR package included with Oracle to locate >the corrupt blocks. If the data in the corrupted blocks is extremely >important, you can use this to dump the block contents. Then you can change >the blocks so Oracle will skip the corrupted blocks. Then you can export the >table or copy the contents to another table. >Dropping the tables and recreating it from your export is also an >option. >Don't forget to rebuild indexes afterward. >Run ANALYZE TABLE VALIDATE CASCADE to find any other corrupt blocks >in other tables. >And turn on the init.ora parameter DB_BLOCK_CHECKING to detect any >further corruptions before they occur. >Good luck. > >-Original Message- >Sent: Tuesday, June 11, 2002 12:29 PM >To: Multiple recipients of list ORACLE-L > > >I have a system when I issued a select statement, I get the following error. > >ORA-00604 Error Occur at recursive level 1 > >ORA-01578 Oracle Datablock corrupted. File 6 Block 2853 > >ORA-01110 Datafile 6 E:\ORANT\DATABASE\RBS1.DBS > >We have an export that we may be able to restore. The database is running >in non-archive mode. Any idea on how to resolve this problem? > >Thank you in advance >-- >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: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: VIVEK_SHARMA > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > > > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk /* The process of preparing programs for a digital computer is especially attractive, not only because it can be economically and scientifically rewarding, but also because it can be an aesthetic experience much like composing poetry or music Donald Knuth */ smime.p7s Description: application/pkcs7-signature
Re: SunOS 5.8 I/O buffer size?
;> >>>Kevin Loney's Oracle8i DBA Handbook says you need to know the >>>"operating system's I/O buffer size" in order to set the init param >>>DB_FILE_MULTIBLOCK_READ_COUNT correctly. >>> >>>What is the definition of "operating system's I/O buffer size Loney is >>>talking about? >>> >>>What is the value of " I/O buffer size" for SunOS 5.8? >>> >>>Went to Sun's web site and got lost...I just want two straight answers >>>to my two questions. >>> >>> >>> >>> >>>Thanks, >>> >>>Carmen Rusu >>>Sr Oracle DBA >>>512-463-3657 (office) >>>512-606-5012 (pager) >>> >>>-- >>>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>>-- >>>Author: Carmen Rusu >>> INET: [EMAIL PROTECTED] >>> >>>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >>>San Diego, California-- Public Internet access / Mailing Lists >>> >>>To REMOVE yourself from this mailing list, send an E-Mail message >>>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >>>the message BODY, include a line containing: UNSUB ORACLE-L >>>(or the name of mailing list you want to be removed from). You may >>>also send the HELP command for other information (like subscribing). >>> >>> >>> >>-- >>Mladen Gogala >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: Mladen Gogala >> INET: [EMAIL PROTECTED] >> >>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >>San Diego, California-- Public Internet access / Mailing Lists >> >>To REMOVE yourself from this mailing list, send an E-Mail message >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >>the message BODY, include a line containing: UNSUB ORACLE-L >>(or the name of mailing list you want to be removed from). You may >>also send the HELP command for other information (like subscribing). >> >> > > > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk /* The process of preparing programs for a digital computer is especially attractive, not only because it can be economically and scientifically rewarding, but also because it can be an aesthetic experience much like composing poetry or music Donald Knuth */ smime.p7s Description: application/pkcs7-signature
Re: Troubleshooting ORA-01410
Hi Sean I would make a database trigger on servererror that could call a dump of the session and that way get a error stack and a system state dump tahe inclueds the sql that is executing O'Neill, Sean wrote: >So this application running on an 8.1.7 database, NT4, has a utility >supplied by vendor which when run by one of our apps people is reporting an >ORA-01410 (invalid ROWID). Given our "history" with the vendor in question >I have some doubts about the application =:-0 > >In relation to same I have a few queries: > >[1] Would an Export of the database report problems if above issue existed >in database?. A full export is currently taken each night and completing >without any warnings. > >[2] Is dbverify any good to troubleshoot this type of error?. I currently >run a dbverify on Offline backups of the data files in question and no >errors are being reported. Granted this is on a "copy" of the datafiles but >I ran a test before where I corrupted a datafile, took a copy, and the >dbverify reported problem with copy so I assume my logic is good here?. > >[3] If I run ANALYZE TABLE xxx VALIDATE STRUCTURE CASCADE on offending table >is output reported to screen? >I have not run it yet as the DB itself is "busy" a lot of the time and above >is rcommended for quite time due to prevention of Selects, Inserts, Updates >and Deletes on object. > >[4] What other methods could be used to troubleshoot this problem?. As I >mentioned I have doubts about the vendor supplied application and would like >to prove one way or the other if some data corruption exists or not! > >Any help with above would be much appreciated :) > >- >Seán O' Neill >Organon (Ireland) Ltd. >[subscribed: digest mode] > >This message, including attached files, may contain confidential >information and is intended only for the use by the individual >and/or the entity to which it is addressed. Any unauthorized use, >dissemination of, or copying of the information contained herein is >not allowed and may lead to irreparable harm and damage for which >you may be held liable. If you receive this message in error or if >it is intended for someone else please notify the sender by >returning this e-mail immediately and delete the message. > > > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk /* The process of preparing programs for a digital computer is especially attractive, not only because it can be economically and scientifically rewarding, but also because it can be an aesthetic experience much like composing poetry or music Donald Knuth */ smime.p7s Description: application/pkcs7-signature
Re: Oracle one-off Patch Install util
Hi Rich Could you please inform me where you downloaded the RDA from ? Metalink or OTN Jesse, Rich wrote: >I've d/ld new versions of RDA and it is much better than it used to be. I >got a clean run on Solaris the 1st try! > >Now to beat them up over the invalid HTML that it creates. There can't be >any tags in a block! Of course every browser but Opera overlooks >this... > >Rich Jesse System/Database Administrator >[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > > > >>-Original Message- >>From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] >>Sent: Friday, June 07, 2002 9:28 PM >>To: Multiple recipients of list ORACLE-L >>Subject: RE: Oracle one-off Patch Install util >> >> >>RDA was written (or at least managed) by Anita Bardeen who used to >>spend a good deal of time on this list...she'll be happy to know you >>like it! >> >>Rachel >> >> -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk /* The process of preparing programs for a digital computer is especially attractive, not only because it can be economically and scientifically rewarding, but also because it can be an aesthetic experience much like composing poetry or music Donald Knuth */ smime.p7s Description: application/pkcs7-signature
Re: explain plan question
Gurelei Are the parameter's the same ? sort* hash* *pool* db* Gurelei wrote: >Hi. > >I have executed an explain plan on a dev and prod >databases. Both databases have the same data, use the >same version of ORacle (8.1.7.0) and the same OS (AIX >4.3.3). All the tables are analyzed. The plans however >are somewhat different (below). What could explan the >differences? For example, index usage (one plan uses >an index to get to all the data, another - access the >index and then the table). All the indices are the >same on both databases. when I tried to force ORacle >to use the indices with hints, the cost grew from 322 >to 566. MY concernt is that I may not be able to tune >a query if I can't replicate the explain plan exactly >in dev as it is in production. > >Thanks for any input > >Gene > >0-0-3211.321 SELECT STATEMENTSQL1 Cost = 321 >1-0-1 2.1 SORT GROUP BY >2-1-1 3.1 NESTED LOOPS >3-2-1 4.1 HASH JOIN OUTER >4-3-15.1 HASH JOIN OUTER >5-4-1 6.1 HASH JOIN >6-5-1 7.1 TABLE ACCESS FULL TELESLS_EMPL >7-5-2 7.2 INDEX RANGE SCAN TS_EMP_HST_ALT1 UNIQUE >8-4-2 6.2 INDEX FAST FULL SCAN PERF_STATS_ALT1 >UNIQUE >9-3-25.2 INDEX FAST FULL SCAN PRDCT_STAT_ALT1 >UNIQUE >10-2-2 4.2 INDEX UNIQUE SCAN ORG_UNT_HST_PK UNIQUE > >vs > >0-0-3231.323 SELECT STATEMENTSQL1 Cost = 323 >1-0-1 2.1 SORT GROUP BY >2-1-1 3.1 NESTED LOOPS OUTER >3-2-1 4.1 NESTED LOOPS OUTER >4-3-15.1 NESTED LOOPS >5-4-1 6.1 HASH JOIN >6-5-1 7.1 TABLE ACCESS FULL TELESLS_EMPL >7-5-2 7.2 INDEX RANGE SCAN TS_EMP_HST_ALT1 UNIQUE >8-4-2 6.2 INDEX UNIQUE SCAN ORG_UNT_HST_PK UNIQUE >9-3-25.2 TABLE ACCESS BY INDEX ROWID PERF_STATS >10-9-1 6.1 INDEX RANGE SCAN PERF_STATS_FK2_X >NON-UNIQUE >11-2-2 4.2 TABLE ACCESS BY INDEX ROWID PRDCT_STATS >12-11-15.1 INDEX RANGE SCAN PRDCT_STAT_FK1_X >NON-UNIQUE > > >______ >Do You Yahoo!? >Yahoo! - Official partner of 2002 FIFA World Cup >http://fifaworldcup.yahoo.com > > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk /* The process of preparing programs for a digital computer is especially attractive, not only because it can be economically and scientifically rewarding, but also because it can be an aesthetic experience much like composing poetry or music Donald Knuth */ smime.p7s Description: application/pkcs7-signature
Re: dbsnmp/intelligent agent for linux
Hi Gabriel The agent configuration is very version dependent so please inform the version of Oracle you are trying to use. Here is how to start the Agent with 9.2, 9i and properly 8.1.7 [oracle@mirpgr bin]$ agentctl Usage: agentctl start|stop|status|restart [agent] agentctl start|stop|status blackout [] [-d/uration ] [-s/ubsystem ] The following are valid options for blackouts name of the target. Defaults to node target. is specified as [days] hh:mm is specified as [jobs events collections] defaults to all subsystems [oracle@mirpgr bin]$ agentctl start DBSNMP for Linux: Version 9.2.0.1.0 - Production on 04-JUN-2002 08:59:54 Copyright (c) 2002 Oracle Corporation. All rights reserved. Starting Oracle Intelligent Agent Agent started [oracle@mirpgr bin]$ agentctl status DBSNMP for Linux: Version 9.2.0.1.0 - Production on 04-JUN-2002 09:00:04 Copyright (c) 2002 Oracle Corporation. All rights reserved. Version : DBSNMP for Linux: Version 9.2.0.1.0 - Production Oracle Home : /home2/oracle/product/9.2.0 Started by user : oracle Agent is running since 06/04/02 08:59:56 Gabriel C Millerd wrote: >i have read and read about this beast but most of the documentation is >very confusing (more reference than howto) and the 'tips' seems to be >folkloreish or guesses. > >i gather there are some things that need to be done to these files: > >$ORACLE_HOME/network/admin/snmp_rw.ora >$ORACLE_HOME/network/admin/listener.ora > >and that the 'lsnrctl' should have the dbsnmp_(start|stop) options. mine >doesnt but i assume that is because it isnt configured properly or i >mooked something else up. > >any help you can give me would be great ... thanks > >--- >Gabriel C. Millerd > > > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk /* The process of preparing programs for a digital computer is especially attractive, not only because it can be economically and scientifically rewarding, but also because it can be an aesthetic experience much like composing poetry or music Donald Knuth */ smime.p7s Description: application/pkcs7-signature
Re: TUNE DB
Hi Seema The radical thing to do is to turn off MTS for a start ! Why are you using MTS ? You are not giving a lot of information on the db ? To be able to give a proper answer we need to know how many days this db have been up running. Is there a problem ? As fare as I remember is "Dispatcher Timer" a Idle event and Virtual Circuit Status can be a Idle event as well depending on the arguments. But to be frank this looks like a db that has nothing to do or a db on a machine with lots cpu's ? (2552 + 1825 = 4377 hours ~ 182 day's) Seema Singh wrote: > Hi > The following are top5 wiat events in my database? > > Total Total Time Avg > Waits Timeouts Waited % of Wait > Event Name (in 1000s) (in 1000s) (in Hours) Concern (Secs) > -- --- --- --- --- > virtual circuit status 8,248.75 282.51 2,552.01 54.95 > dispatcher timer 30,900.42 15,714.38 1,825.41 39.30 > single-task message 26,299.17 50.72 156.76 3.38 > log file sync 3,757.66 15.98 72.02 1.55 > control file parallel writ 702.02 0.00 10.86 0.23 > > I increase shared server also.Let me know group view what to do please? > Thx > -Seema > > _ > Join the world's largest e-mail service with MSN Hotmail. > http://www.hotmail.com > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk /* The process of preparing programs for a digital computer is especially attractive, not only because it can be economically and scientifically rewarding, but also because it can be an aesthetic experience much like composing poetry or music Donald Knuth */ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: grant sysdba rights
Yes I'm assuming that you have not changed anything in the sqlnet.ora file ;-) that is the parameter sqlnet.authentication_service = (NTS) "use Windows NT native authentication" [EMAIL PROTECTED] wrote: we have W2K platformso if i understand correctly i put my NT account in the ORA_DBA group, thenconnect / as sysdba and grant the rights. -Oorspronkelijk bericht-Van: Peter Gram [SMTP:[EMAIL PROTECTED]]Verzonden: woensdag 15 mei 2002 12:49Aan: Multiple recipients of list ORACLE-LOnderwerp: Re: grant sysdba rightsThe answer depends on what O/S you are on.Unix :When the oracle software was installed you where asked about a Unix group (normally called dba) that has privilegesthis group is then compiled and linked into the Oracle executable.When member of this group you can connect with "/ as sysdba" and from there grant sysdba to the userNT :Since it is not possible to relink the code on NT the group is hard coded to "ORA_DBA" on NT/W2KWhen member of this group you can connect with "/ as sysdba" and from there grant sysdba to the userVMS :Here it is a system logical that i don't remember the name off ( Michael / Mogens pleas help )When having this logical set you can connect with "/ as sysdba" and from there grant sysdba to the userMVS :Help ???[EMAIL PROTECTED] wrote: Hi listWhen the system account needs the SYSDBA role granted , i simply connect as internal and grant that role to system. But the connect internal is obsolete in oracle 9i, so how do i grant thesysdba role to other accounts ??thanksvr. gr.g.g. korrdw ict groningen -- /regardsPeter GramMobil : +45 2527 7107Fax : +45 4466 8856Miracle A/SKratvej 22760 Måløvhttp://miracleas.dk-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Peter Gram INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: grant sysdba rights
The answer depends on what O/S you are on. Unix : When the oracle software was installed you where asked about a Unix group (normally called dba) that has privileges this group is then compiled and linked into the Oracle executable. When member of this group you can connect with "/ as sysdba" and from there grant sysdba to the user NT : Since it is not possible to relink the code on NT the group is hard coded to "ORA_DBA" on NT/W2K When member of this group you can connect with "/ as sysdba" and from there grant sysdba to the user VMS : Here it is a system logical that i don't remember the name off ( Michael / Mogens pleas help ) When having this logical set you can connect with "/ as sysdba" and from there grant sysdba to the user MVS : Help ??? [EMAIL PROTECTED] wrote: >Hi list > >When the system account needs the SYSDBA role granted , i simply connect as >internal and grant that role to system. >But the connect internal is obsolete in oracle 9i, so how do i grant the >sysdba role to other accounts ?? > >thanks > > >vr. gr. >g.g. kor >rdw ict groningen > > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: A trigger vs. "default value" in a table
Hello Andrey The correct answer depends on what you want ! if you can live with null values in the column then a default for the column is OK, but if you want to handle a insert with a null then you need a trigger. Se the little example : SQL> create table t (a number, b number default 10); Table created. SQL> insert into t (a) values (10); 1 row created. SQL> commit; Commit complete. SQL> select * from t; A B -- -- 10 10 SQL> insert into t (a,b) values (10, null); 1 row created. SQL> commit; Commit complete. SQL> select * from t; A B -- -- 10 10 10 Yechiel Adar wrote: >Hello Andrey > >KISS - Why write code to do what oracle does for you? > >Yechiel Adar >Mehish >- Original Message - >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Sent: Monday, May 13, 2002 6:23 PM > > >>Dear list ! >>I need a very simple thing : each time a certain field is null during an >>insert, to substitiute a string "AAA" instead. >>What is better : to write a trigger to do so or to define a default value >>for that column in the table ? >>Thanks ! >> >> >>DBAndrey >> >>* 03-9254520 >>* 058-548133 >>* mailto:[EMAIL PROTECTED] >> >> >> >> >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: Andrey Bronfin >> INET: [EMAIL PROTECTED] >> >>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >>San Diego, California-- Public Internet access / Mailing Lists >> >>To REMOVE yourself from this mailing list, send an E-Mail message >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >>the message BODY, include a line containing: UNSUB ORACLE-L >>(or the name of mailing list you want to be removed from). You may >>also send the HELP command for other information (like subscribing). >> -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Ma*l?v http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to simulate Block Corruption?
Hi If you are on a unix platform use dd to write to a datafile, this is what oracle uses in there Backup & Recovery Class. On NT find a freeware hex editor and edit the datafile ! I know that there are multible event in Oracle to write corrupt block's, but forget them and use brut force ! Sandeep Kurliye wrote: >Hello Gurus, > >I am in the process of testing recovery options from block corruptions. So, >my setup requires a db which is having block corruption problem. > >How to simulate block corruption in db? > >Any help? > >TIA, >Sandeep. > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Begin backup fails sporadically
Hi Kip When you next time have this problem check the v$backup table to verify that the file is not in backup mode, if this is tha case you proberly have to log a iTAR with support. [EMAIL PROTECTED] wrote: >Version is 8.0.6.3.0 > >I have several databases using the exact same set of generic backup scripts. >The script that puts all tablespaces into backup mode is generated >automatically and done correctly. Same is true for the script which takes all >the tablespaces out of backup mode. The problem I am facing is that when this >script is invoked, one (and only one) of these databases occasionally has >problems. Some tablespaces are successfully put into backup mode and some say > >ORA-01146: cannot start online backup - file 15 is already in backup >ORA-01110: data file 15: '< datafile name >' > >The only things that would make sense to me is if two of these scripts were >running in parallel or if the prior day had some weird problem. Neither of >these seem to be the case. The only thing that seems to straighten things out >is to runs these scripts manually. > >Ideas? > >Regards, >Kip Bryant > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 compiled this proc
Bp There is no way to find the ceator or the ip-addres of a procedure when it is created if the the creator is different from the owner :-( Big Planet wrote: How to find which database user and ip-address compiled this stored proc ? -Bp -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Ticket tracking system
David Don't use delete use a update to mark the row deleted. This has the advantaged that it is possible to track what happened to a ticket (call it journal or history) Nguyen, David M wrote: >I develope a ticket database for people to open, close, re-open ticket to >update using oracle database. My question is how do I use SQL command to >let people re-open a close ticket for updates? When someone close a ticket, >delete command is executed and data is gone. Please advise. > >Thanks, >David > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database shut itself down
Dave Oracle had a problem with written to the file J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF this was happened because Oracle did not have proper permission in NT to write to the file. There are many reasons that could give this problem 1) the file was in shear 2) the acl was changed 3) oracle was started as a another user Farnsworth, Dave wrote: >I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut >itself down. In the Alert.log I have the following error. > >Tue Apr 02 10:47:40 2002 >KCF: write/open error block=0x21de online=1 > file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF > error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file >O/S-Error: (OS 5) Access is denied.' >DBW0: terminating instance due to error 1242 >Instance terminated by DBW0, pid = 287 > > >This is a new for me. Any ideas what I am dealing with? > >Thanks, > >Dave > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Customize my SQLPlus login
Hi There is glogin.sql that is places in $ORACLE_HOME/sqlplus/admin where you can place commands that sqlplus will execute on startup Bernard, Gilbert wrote: >Login.sql > > -Message d'origine- > De: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] > Date: mardi 26 mars 2002 14:38 > À: Multiple recipients of list ORACLE-L > Objet: Customize my SQLPlus login > > What is the file that I need to edit on my client PC to set >personalized settings for SQLPlus so that I do not have to set these at the >command prompt every time I start a new session? > > Thanks, > > Dave > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Farnsworth, Dave > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing >Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- /regards Peter Gram Phone : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Målev http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to duplicate production database onto development box
Title: How to duplicate production database onto development box Hi There are several ways to move a database : 1 : Shutdown the db and copy all the data files, redologfiles, control file and the parameter file to the dev box then open the db. 2 : Take a online backup of the database and then copy the control file, data files and the archiverfiles and do a incomplete recovery 3 : user RMAN duplicate command to make a copy of the database to the dev box 1 - 3 are fast and easy to do. 4: use transportable table spaces to move part of the database to the dev box is a possibility that work but requires more skills. Daiminger, Helmut wrote: Hi! We want to put an exact copy of our production database (approx. 200 GB) onto a development box. What would be the best way to achieve this? Export/import would take kinda long... ;) Would transportable tablespaces be the way to go? This is 8.1.7 on Sun Solaris. Thanks, Helmut -- /regards Peter Gram Phone : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Målev http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN Configuration Question
Pat There are several reasons to have multiple catalog, but the most importen one is that gives the possibility to upgrade the catalog without interfering with other database backup's. There is as well the benefit if you at some time is going to query the catalog using Sql you will not have to join all the time with the db key Pat Howe wrote: >I have just completed Oracle Education's "Enterprise DBA Part 1B: Backup and >Recover" course. >Page 11-5 states : It is recommended that you have a separate catalog for >each database. > >My question is : >Why? Does this help you cleanup the RMAN catalog if you ever drop a >database (you can drop the schema owner)? >Is this how others have configured their RMAN database ? > >Thus I am seeing 2 Configuration Models ; >Have one schema owner per database that you are backing up. >If you had two databases "PROD and DEV" then setup a RMAN-PROD and an >RMAN-DEV schema owner (different RMAN Catalogs) in the same RMAN tablespace >to manage each database's recovery info. >VERSES >Have one schema owner (catalog) for all the databases that you are backing >up. >If you had two databases "PROD and DEV" then setup one schema owner RMAN >(one RMAN Catalog) in the RMAN tablespace to manage all database recovery >info. > >What are the pro's and con's? > >Thanks in Advance >_ > Patrick J. Howe > Oracle DBA > Illuminet Inc. (Carrier Division of Verisign) > 4501 Intelco Loop SE > Email : [EMAIL PROTECTED] > > -- /regards Peter Gram Phone : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Målev http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Parallelizing RMAN Backup
Hi Pat I don't know where you got the information on the Rman will not parallel the backup without using the filesperset parameter. I only use the filesperset parameter when backing up archive files. It is the allocation of multiple channels that determinate if it is possible to do backup's in parallel. Pat Howe wrote: >>I am researching RMAN and I am trying to understand how to parallelize the >>backup. >>I have come across the following statement in various papers and in the 8i >>Backup and Recovery Course Material : >> >>It is important to set FILESPERSET in the backup. >>This will ensure that each allocated channel only processes the specified >>number of files. >>If you DO NOT specify FILESPERSET then the backup would only be undertaken >>by "1 channel" and "all other allocated channels would sit idle". >> >>Yet in the "8.1.6 RMAN User's Guide and Reference" it contradicts this (pg >>1-31) : >> >>The number of channels that you allocate affects the degree of parallelism >>within the command. >>RMAN internally handles parallelization. You only need to specify : >> > 1 'allocate channel' command >> The objects that you want to backup >>Parallelism is exploited only within the context of a single command. >> >>So it does not mention that you HAVE TO specify the FILESPERSET statement. >> >>On digging further into the FILESPERSET statement the manual states (pg >>1-36) : >>The default value of this parm is calculated by RMAN as follows ; >>RMAN takes the lower of the following 2 values ; 64 or >>number-of-files/number-of-channels. >> >>Page 1-37 gives an example of using the Default FILESPERSET - and how RMAN >>would parallelize the backup. >> >>Which is right ? >>Do you have to specifically specify the FILESPERSET parm in the BACKUP >>command for RMAN to parallelize the backup operation? >>or >>Can you leave it out of the BACKUP command and use the default value ? >> >> >>Thanks in advance >> >>_ >> Patrick J. Howe >> Oracle DBA >> Illuminet Inc. (Carrier Division of Verisign) >> 4501 Intelco Loop SE >> Olympia, WA 98507 >> Email : [EMAIL PROTECTED] >> >> -- /regards Peter Gram Phone : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Målev http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Blobs and Extents
Darren a 1 : === I would use both thprof to make sure that the SQL is efficient and statpack to monitor the full database a 2 : === I would never recommend to make the data files bigger than 2 Gb on unix, so anything up to 2 GB will be fine. How small you what to make the files depends on the number of disk's or if you use raid to strip ? a 3 : === You would use locally managed table spaces and make the extend size 1, 4, 10 or 512 Mb in this case it does not matter. a 4 : === Yes, if the table space is read only you only need one backup but on the other hand who gives a dam on 4 - 6 GB tape per today Browett, Darren wrote: >We are in the process of installing a GIS package (Arc/info) which has an >oracle component (SDE) > >I have to setup tablespaces to handle various types of data, one of the >tablespaces will be holding >Tiff images. These images range are on average 25 Megs and there will be >upto 200 images. > >It is Oracle 8.1.7.2 on Tru64 Unix > >>From this I have a couple of questions. > >1. I want to test different extent sizes for performance, what tool should I >use, tkprof or statspack > >2. How big should the datafiles be, 500m, 1Gb etc. > >3. As for the extents, I am leaning towards a locally managed tablespace, >what kind of extent >size would work best, 1m, 4m, 10 m etc. As mentioned in 1 I plan on testing >this, just looking >for feedback. > >4. And, once these are loaded, is there any advantage to having the >tablespace set to readonly ? > >Thank You > >Darren > > > > > >-- >Darren Browett P.Eng This message >was transmitted >Data Administrator using 100% >recycled electrons >Information and Communication Technology >City of Coquitlam >P:(604)927 - 3614 >E:[EMAIL PROTECTED] >-------- >--- > > -- /regards Peter Gram Phone : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Målev http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RAMAN Question
Greetings That is possible as well with RMAN, You can backup as many times you like. The delete of the archive files can be done in connection with the backup or as a separate command /greetings Mandal, Ashoke wrote: >Greetings, > >We are at Oracle 8.1.7 on Sun Solaris 7. > >Can we backup all the archive logs at any point of time but not deleting all these >archive logs as we like to keep the archive logs for 2 days(SYSDATE-1) in the disk so >that we don't need to restore the archive logs from rman backup in case of some >recovery up to point within last 2 days. > >Thanks, >Ashoke > -- /regards Peter Gram Phone : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Målev http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Lost a redo disk
Beth Just for the record I hope that you understand that you have to do a full export and recreate the database and a full import into the newly created database to have a supported database. The parameter _allow_resetlogs_corruption grants you right's to open the database even it it needed recover from the missing redo log file. The other thing to have in mind it that there is a possibility that you have lost committed transaction there was residing in the lost redo log :-( /regards Seefelt, Beth wrote: >Never mind. I was able to open the database. > >I renamed the redo file to a disk that is working, and then set the >_allow_resetlogs_corruption parameter to true. Then I was able to do an open >resetlogs. > >But thanks anyway to anyone who's going to respond when my question hits the list. > >Beth > >>-Original Message- >>From: Seefelt, Beth >>Sent: Wednesday, February 20, 2002 8:28 AM >>To: '[EMAIL PROTECTED]' >>Subject: Lost a redo disk >> >> >>Hi everybody, >> >>This all started with the halon firing in our data center last night around 10pm so >you can imagine my condition. >> >>I lost a disk that contained only redo logs. >> >>When I try to open the database I get >> >>ORA-00313: open failed for members of log group 1 of thread 1 >>ORA-00312: online log 1 thread 1: 'F:\ORACLE\ORADATA\OWBREPOS\REDO01.LOG' >>ORA-27041: unable to open file >>OSD-04002: unable to open file >> >>I thought what I needed to do was switch the log files, drop the members that are on >the bad disk, and then I'd be able to open the database. >> >>So I mounted the database and did >> >> alter system switch logfile; >> >>and its telling me ORA-01109: database not open >> >>I thought I could swicth logfile with the database mounted? >> >>Could someone suggest the right steps I should take to recover? >> >>Many TIA, >> >>Beth >> -- /regards Peter Gram Phone : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Målev http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: V_$SESSION question
Hi If you whant the information in the session you can use the function SYS_CONTEXT ('USERENV', attribute) attribute := 'host' or 'ip_address' or some other of the 25 options look in the Oracle8i SQL Reference chapter 4 Ghadge,Sameer wrote: Hi, my problem is as follows:I want do determine the machine name (and other info) from pl/sql,of theclient from which i have logged ine.g. suppose i have logged from machine 'power_machine' as user 'puser'my pl/sql has info. that the current user 'puser'How do i retrive my sid for this session,which is in V_$SESSION.so basically i want the SID of the current sessionThxSameer -- /regards Peter Gram Phone : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Målev http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Retrieval Tool
Dennis Move the tables into Oracle and let the users use Access via odbc ;-) [EMAIL PROTECTED] wrote: >Good day all, >I have been asked the following question a couple of time by our database >users - >They have a bunch of small Access databases that they want to port into >Oracle. Since most of these databases have just a few tables in them I >figure I can use sql loader to load the access tables into Oracle. But the >tough part is, how do we have the users access the data once it is in >Oracle? Since these are pretty static databases and we don't have the >resources in house to develop front end tools to retrieve the data, I am >wondering if there is a slick, user friendly tool out there can help us >with this. Toad partially satisfies this need but I think it is an overkill >for data access only. Also, it would be nice to have a web browser >interface and some data insert and update capabilities without using sql. >Alright I know now I am really push it... > >TIA > >Dennis Meng >Database Administrator >Focal Communications Corp > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Checkpoint & Redo ratio(High)
Seema First remember the old rule : If it's not broken don't fix it. There is a rule of thumb that redo log switches should happened app. every 30 minutes, but if you se redo log switches happening more often at some times and nobody is complaining then just ignore the it. If you have a performance problem and you se redo log switches then create bigger redo logs so that switches happen app. every 30 minute. Seema Singh wrote: > Hi > I checked my database and see redo ratio is high. > I ran the folling query > select (req.value * 5000) / entries.value "Redo Ratio" > from v$sysstat req, v$sysstat entries > where req.name = 'redo log space requests' > and entries.name = 'redo entries'; > But the > background checkpoints completed and background checkpoints started > are having diffrence 1. > When I do large insert and delete I receive message in alert log > "Checkpoint not completed." but not regulary. > My redo log file size is 20m. > oracle is running on 8.1.6 on unix. > LEt me know group suggestion. > Thanks > -Seema > > > > _____ > Get your FREE download of MSN Explorer at > http://explorer.msn.com/intl.asp. > -- Best regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: NT questions
Hi Joan A1) ? A2) You are right about that the last digit is OS patches, you can get the patches from Metalink (http://metalink.oracle.com). Joan Hsieh wrote: >Hi dear Listers, > >I have 2 NT questions like to ask; > >1.On unix, I use the following script to change the name of alert file. >How to change it in the same way on NT? > >for log_file in $(find $ORACLE_BASE/admin -name "alert_FMRPT.log" | grep >-v alert_FMRPT_.*.log) >do > newfile=$(echo $log_file | sed "s/\.log$/_$dt.log/") > echo "moving alert logs: $log_file $newfile" > mv $log_file $newfile > >2. I remember read somewhere about oracle version, for example, >8.1.7.2.x , the last digit is OS related informantion. Is that true? Our >nt boxes, some instance show it is 8.1.7.2.1, some shows 8.1.7.2.6. I'd >like to make all the same version. Where I can get those patch >information? (On unix, all our instances are 8.1.7.2.0, we installed and >patched. Not on NT. kind of out of control at beginning) > >Thanks in advance, > >Joan > -- Best regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Is Same instance name possible on same server?
Hi Q) Can I have same instance name on same unix server?If yes then how? A) No Q) Can I restore the database with diffrent name. A) Yes but this is hard by hand but easy if you use Rman Q) Suppose I have backup of prod instance on one server. can I create prod1 instance name on diffrent server by having same hotbackup data files,archived log files and control files.? A) Yes By the way read the manules : Oracle8i Backup and Recovery Guide Oracle8i Recovery Manager User's Guide and Reference * Oracle8i Standby Database Concepts and Administration Seema Singh wrote: Hi Can I have same instance name on same unix server?If yes then how? Can I restore the database with diffrent name.Suppose I have backup of prod instance on one server.can I create prod1 instance name on diffrent server by having same hotbackup data files,archived log files and control files.? Thx -Seema _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Virus Warning
Hi David Do you know what kind of virus we are talking about ? David Wagoner wrote: Do not open messages with a “Hi” subject and a screensaver attachment. It’s a virus circling around our company now. David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -- Regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Temporary table
Hi I don't understand why you need to create the table and drop the table ? If you don't create/drop the table it sounds to me that Global Temporary Tables is the thing for you to use. If you have to waste resources on creating/droping tables in Oracle there is know easy way to do this, beware that in Oracle DDL statements (create, drop .. ) do a implicit commit; Harvinder Singh wrote: >Hi, > >In our application we need to create temporary table for life of a session >and drop it after the session. >we need this table to be session specific ...2 sessions connected as same >schema user should be able to create >table with the same name.. >for example user1. connected as scott create table with name tab1..then >user2 connected as scott should also be >able to create table with name tab1...and we want table tab1 to be dropped >as soon as user1 and user2 will discconnect >We need to populate this temporary table in particular session and use it to >join with other tables and then drop after the session. >How can we implement this... >global temporary table does not allow to be created twice in 1 schema..they >r schema specific... > >Thanks >-Harvinder > -- Regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Code to Validate email addresses
Hi The definition is found in RFC 2822 Internet Message Format (ftp://ftp.isi.edu/in-notes/rfc2822.txt) Oweson Flynn wrote: >Hi, > >We have implemented a form that emails reports. The user has to enter his >email address. > >However, we are finding that a lot of users are entering incorrect and >invalid email addresses. > >Obviously, we can do nothing if they enter an incorrect (but syntactically >correct) email address. > >What I am looking for is: > >1) A definition of the syntactically correct format of an email address >(from some sort of authoritative source) > >2) Hopefully some pl/sql code that will validate a sting to see if it is a >valid email address. > >If anyone can assist, I would appreciate it! > >Regards >Oweson Flynn >_ >"Tell me what you think, Captain, I'm all ears" - Spock > >Certified Oracle DBA >The Flynn Consultancy >Tel: 082-600-7-006 >Fax: (011) 782-9313 >EMail: [EMAIL PROTECTED] > > > >*** > >This message may contain information which is confidential and subject to legal >privilege. If you are not the intended recipient, you may not peruse, use, >disseminate, distribute or copy this message. If you have received this message in >error, please notify the sender immediately by email, facsimile or telephone and >return and/or destroy the original message. > >*** > -- Regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Meaning of V$WAITSTAT statistics
Hi all Sorry for interrupting this thread ! I'm sorry to say that it is not possible to answer since time_statistics = false and there for the time column is zero. So we know that this db has waited on (data block 335274, segment header 52,undo header 322 and undo block 419) these different thing but we don't know for how long time and therefor we don't know if it is a problem ! Turn on time_statistics on the db and see what the wait time is then you might find that you have a problem or not if it's not broken don't fix it Raghu Kota wrote: > Hi Friends > > My v$waitstat shows like this..I think there is no time waited..Its > okay, Or any thing Iam missing here?? > > SQL> select * from v$waitstat; > > CLASS COUNT TIME > -- -- -- > data block 335274 0 > sort block 0 0 > save undo block 0 0 > segment header 52 0 > save undo header0 0 > free list 0 0 > system undo header 0 0 > system undo block 0 0 > undo header 322 0 > undo block419 0 > > Thanks > Raghu. > > > > > >> From: "Mohan, Ross" <[EMAIL PROTECTED]> >> Reply-To: [EMAIL PROTECTED] >> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >> Subject: RE: RE: Meaning of V$WAITSTAT statistics >> Date: Wed, 03 Oct 2001 07:05:20 -0800 >> >> > > _ > Get your FREE download of MSN Explorer at > http://explorer.msn.com/intl.asp > -- Regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: What is in archive log...
Hi Aldi You can use Logminer ! Aldi Barco wrote: > Hi Lister, > > Can we read what activities are in archive log files ? > (utility like 'tkprof' to read trace file). > Tia. > > Aldi > > > _ > Get your FREE download of MSN Explorer at > http://explorer.msn.com/intl.asp > -- Regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Recovery Question
Title: RE: Recovery Question Hi Kamel No, when using backup control file you are telling oracle that it should not trust the control file to know when to end the recovery. The recovery will keep on asking for archive log files until there are now more archivelogs and since it dos not know where to stop you vill have to manule give the destination of the last redologfile. After the database is up to date and you can open it with resetlogs, I think you should try it with a test db and see that that it just works ! Koivu, Lisa wrote: But don't you end up with an incomplete recovery then? AJ -Original Message- From: Peter Gram [SMTP:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 5:56 PM To: Multiple recipients of list ORACLE-L Subject: Re: Recovery Question Hi Kamel You have to tell oracle that the controlfile is not originale one by using "recover database using backup controlefile" GL2Z/ INF DBA BENLATRECHE wrote: >Hi List, > > I am testing one situation where : > > - The database is in archive log mode, > - I have a cold backup of all the datafiles, control files, redo logs, >init file > > >The case is if I would to rebuild my database from the cold backup files and >archived redo log files but I haven't the last updated control file (before >the crash for example). > >If I recreate a new control file and execute the recover command then i get > > ORA- 00264 no recovery required > >Is there any solution to resolve this situation ? > >Thanks > >Best Regards >Kamel Benlatreche > > > > > > > -- Regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Recovery Question
Hi Kamel You have to tell oracle that the controlfile is not originale one by using "recover database using backup controlefile" GL2Z/ INF DBA BENLATRECHE wrote: >Hi List, > > I am testing one situation where : > >- The database is in archive log mode, >- I have a cold backup of all the datafiles, control files, redo logs, >init file > > >The case is if I would to rebuild my database from the cold backup files and >archived redo log files but I haven't the last updated control file (before >the crash for example). > >If I recreate a new control file and execute the recover command then i get > > ORA- 00264 no recovery required > >Is there any solution to resolve this situation ? > >Thanks > >Best Regards >Kamel Benlatreche > > > > > > > -- Regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Datafile Migration Tool
Hi Babette On a unix box the BBED is not linked by default, you have to modify the ins_rdbms.mk file and then you can link the bbed utility ! Babette Turner-Underwood wrote: At which version of Oracle did they remove this?It is NOT in any my directories. I checked:- 8.0.3 ORACLE_HOME/bin- 8.1.5 ORACLE_HOME/bin - 8.1.6 ORACLE_HOME/bin- 7.3.4 ORACLE_HOME/bin Thanks,Babette-Original Message-GopalakrishnanSent: Wednesday, August 15, 2001 10:16 AMTo: Multiple recipients of list ORACLE-LHi,Oracle'e block editor is called BBED and it will be in your$ORACLE_HOME/bin. DUL will not be in standard oracle instalations andit is a support tool.--- Babette Turner-Underwood <[EMAIL PROTECTED]> wrote: Like the block editor Oracle used to make available ?BDE or something like that?DUL tool would be cool, too.Especially, if it handled the odd-ball cases like LMTs and IOTs.I would only use DUL on production if it was total S.O.L.and there was nothing left (besides READING won't make the muckworse).However, I would love to play with something like these on my sandboxarea. =Have a nice day !!Best Regards,K Gopalakrishnan,Bangalore, INDIA.__Do You Yahoo!?Make international calls for as low as $.04/minute with Yahoo! Messengerhttp://phonecard.yahoo.com/ -- Regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Hot Backup
Hi Veronica There is no technical problem with nesting begin backup's, but it is not generally recommended since when a teblespace is put in backup mode it will generate more redo and if the full database is in backup mode you could get a performance problem. Regaring scriprt to do the online backup you can finde som nice scripts on http://www.osborne.com/oracle/index.html under "free code online" and "Oracle 8i Backup & Recovery" Veronica Levin wrote: Hi listers, I'm plannig to test hot backups and I am wondering if I can place several tablespaces on backup mode, copy the datafiles and then end the backup mode for all datafiles at once. Would that be ok? (of course backing up controlfie, and logs generated during backup) Any of you have a unix script for hot backups and want to share it? thanks in advance! Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 smime.p7s
Re: huge datafiles/need help
Hi Lyuda This is not a nice situation to bee in, but the god new is that oracle can help you since you are using version 8.1.6 ! You can use the "ALTER INDEX REBUILD TABLESPACE ;" to move the index to a new tablespace and this can even be don online with "ALTER INDEX REBUILD ONLINE TABLESPACE ;" BUT then you have to look out for bug 1475310 that should be fixed in 8.1.7. [EMAIL PROTECTED] wrote: > Hi List, > I have a monster tablespace 36 G with two datafiles 32 G and 4 G. Don't ask > me who created such a file because I don't know. I am trying to rescue the > database that has multiple problems. Something you've never seen before. > Bye the way, did anyone ever run a test how much stuff you can put on your > disc before it dyes? Well, yesterday I found a disc which was 99.07 % full. > Anyway... > The tablespace is ~ 50 % free. The bad news is it doesn't let me to reduce > the size of the datafiles by using 'alter database datafile ... resize...';. > That tablespace contains 32 indexes. Some of them are as large as 600 -800 > M. I need to develop a plan of attack. > My options are: > 1) drop and recreate the indexes; > 2) rebuild the indexes in different tablespace/tablespaces; > 3) export/import indexes or may be even tablespace all at once. > > Is there anyone who has done something similar before? > All suggestions are greatly appreciated. That database is screaming for > help!! > It running Oracle 8.1.6 on NT. > > Lyuda Hoska > > -- > 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). -- Regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 smime.p7s
Re: moving tables to a different tablespace
Hi Rusnak I will not comment on that the tales is OUTLN's, but since you are using 8.1.7 then you can use "alter table OL$ move tablespace x" "Rusnak, George A." wrote: > Hi Group, > Please explain what I am doing wrong. > 1) exp outln/outln@webprod <mailto:outln/outln@webprod> file=exp_file > tables = 'OL$' 'OL$HINTS' > 2) Dropped the tables: 'OL$' and 'OL$HINTS' on webprod > 3) Created tablespace outln_ts on webprod > 4) Altered user outln default tablespace outln_ts > 5) imp outln/outln@webprod <mailto:outln/outln@webprod> file=exp_file > tables = 'OL$' 'OL$HINTS' > 6) SQL> select table_name, tablespace_name >from dba_tables >where owner = 'OUTLN'; > > TABLE_NAME TABLESPACE_NAME > -- > -- > OL$SYSTEM > OL$HINTS SYSTEM > XX > OUTLN_TS > > WHY are the tables being re-imported back into SYSTEM tablespace > > Oracle 8.1.7 on Sun Solaris 5.7 > > TIA > > Al Rusnak > 804-734-8453 > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rusnak, George A. > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Best regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 smime.p7s
Re: NULL Foreign Key Value
Hi George This is not something that Oracle have defined, this behaviour is part of the SQL ANSI standard. George Hofilena wrote: > Can somebody explain why Oracle would allow a foreign key to be null and > still enforce the referential integrity constraint. > > Thanks, > > George Hofilena > DBA > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: George Hofilena > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Best regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 smime.p7s
Re: Can we capture all errors through SQLERRM ?
Hi Krishna Try FORMAT_ERROR_STACK Function This function formats the current error stack. This can be used in exception handlers to look at the full error stack. Syntax DBMS_UTILITY.FORMAT_ERROR_STACK RETURN VARCHAR2; Parameters None. Returns This returns the error stack, up to 2000 bytes. Krishna Kakatur wrote: Hi, How can I capture the second error message (ORA-06512: at line 4) in Exception handler? I want to capture all the messages and insert them into Error Log table. -- SQL> declare 2 n number; 3 begin 4 n := 'Not a Number'; 5 end; 6 / declare * ERROR at line 1: ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 4 -- SQL> declare 2 n number; 3 begin 4 n := 'Not a Number'; 5 exception 6 when others then 7 dbms_output.put_line (SQLCODE ||' >>> '|| SQLERRM); 8 end; 9 / -6502 >>> ORA-06502: PL/SQL: numeric or value error PL/SQL procedure successfully completed. -- TIA, Krishna _ 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: Krishna Kakatur INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 smime.p7s
Re: find allocated and used space for a table
Hi Soman Use one of thies selects SELECT SEGMENT_NAME, TABLESPACE_NAME, FILE_ID, BYTES FROM DBA_EXTENTS WHERE OWNER = '' AND SEGMENT_NAME = ''; SELECT SEGMENT_NAME, SUM(BYTES) FROM DBA_EXTENTS WHERE OWNER = '' AND SEGMENT_NAME = ''; Soman Manoj wrote: > Hi, > > How to find allocated and used space for a table? > > I required it urgently > > Regds > > __ > Do You Yahoo!? > Get personalized email addresses from Yahoo! Mail - only $35 > a year! http://personal.mail.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Soman Manoj > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Best regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 smime.p7s
Re: how can fire a procedure when database is going to shutdown
Hi In 8i us can create a shutdown trigger, see the Oracle sql referense "Shahid Malik(IT)" wrote: > Hi , > > How can I fire a procedure when database is going to shutdown . > TIA. > > Shahid Latif > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Shahid Malik(IT) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Best regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 smime.p7s