Re: Instance down
.or are you trying to put it offline ?. Issue an dbv of each datafile. In any case you should open a tar with Support. It is probably an bug. Tell me whether or not you solve it and the bug number. Regards. --- Seema Singh [EMAIL PROTECTED] wrote: no From: Christian Trassens [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Instance down Date: Mon, 23 Jul 2001 00:15:25 -0800 I know it maybe a little latebut: are you trying to put tablespace read only ?. Regards. --- Seema Singh [EMAIL PROTECTED] wrote: Hi My instance is down and I found the following error message in alert log file CKPT:terminating instance due to error 1110 Let me know what could be reason. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Temp problem
Increase the ulimit of oracle or the user running the query or transaction that received the error. Regards. --- Raghu Kota [EMAIL PROTECTED] wrote: Hi friends I had following error in my alert log file, Any ideas why its happening?? Mine is AIX ,oracle7. Mon Jul 23 08:53:43 2001 Errors in file /software/app/oracle/admin/baanIV/udump/ora_96526.trc: ORA-00600: internal error code, arguments: [3509], [2], [], [], [], [], [], [] ORA-01114: IO error writing block to file 166 (block # 134552) ORA-07376: sfwfb: write error, unable to write database block. IBM AIX RISC System/6000 Error: 27: File too large Additional information: 134552 TIA Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Lock
If I am not wrong you can use a SELECT FOR UPDATE -Message d'origine- De : Hamid Alavi [mailto:[EMAIL PROTECTED]] Envoyé : mardi 24 juillet 2001 03:45 À : Multiple recipients of list ORACLE-L Objet : Lock hi all, Aay body know, how you can control the lock during the sql code. eg select a,b,c from tablea with NO LOCK. how you can control the locking. thanks in advance all of you The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Lawson and Staffware running on Oracle?
Hi all. Does anyone out there know of any issues running on Oracle 8.1.7, which in turn runs on a Unix box (Solaris version 8)? The box will probably be a 3800 or a 4800 (still to be purchased) Info on issues such as sizing, security, tuning etc would be of great help or even any known problems. Thanks Clint
RE: The number of used cursors?
Thank you for the anwers. If I try Jon's version I get a big number that does not seem to be related to the number of maximum open cursors ( it's much higher). If I query the V$SQL_CURSOR view, then I get a number the could be the value I look for. Could some one shed some light on this? Regards Tamas Szecsy -Original Message- Sent: Monday, July 23, 2001 5:29 PM To: Multiple recipients of list ORACLE-L Try this: select sum(value) as open_cursors from sys.v_$sesstat s , sys.v_$statname n where s.statistic# = n.statistic# and n.name = 'opened cursors current'; Jon Walthour --- Original Message --- From: Szecsy Tamas [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/23/01 9:55:24 AM Hi, I would like to know the the number of used cursors at any given time. Is there a select statement that does this for me? I would like to decide if the growing number of concurent users for a given database has reached the point where the maximum open cursor init ora parameter got to be increased. Thank you in advance. Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
constraint naming
O Wise and Powerful Oracle: Is there a way to change thy system-generated names for foreign key constraints to something sensible without invoking Deep Magic? g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL PROTECTED] Office: +44 (0) 207 454 1224 Mobile: +44 (0) 7966 164687 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Lock
I think the only way to not acquire a row level lock, is to use one of the fabled Undocumented Parameters (if this is what you mean of course). I do have to say that using this kind of parameter without the backing of OWS, is not advisable, and therefore, will refrain from telling you which one it is :) If you mean table locking, then the simple select you have shown below also will hold no locks, as this is simply a select statement. List correct me if I'm wrong.. HTH Mark -Original Message- Sent: Tuesday, July 24, 2001 04:45 To: Multiple recipients of list ORACLE-L hi all, Aay body know, how you can control the lock during the sql code. eg select a,b,c from tablea with NO LOCK. how you can control the locking. thanks in advance all of you The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: weird recursive sql
That recursive stmt hasn't to be involved with the stmt beneath. However, are you using private synonyms or do you have a lot of tables and objects ?. Why don't you look at gets and misses in the v$rowcache ?. Are you suffering of row cache lock wait ?. Are you on 8.1.X ?, do you know the thing about setting _sqlexec_progression_cost=0 ?. If you don't, read the note 68955.1. Regards. --- George Schlossnagle [EMAIL PROTECTED] wrote: I'm expereinceing a weird problem. I have a tabl whihcis basically a collection of counters (NAME VARCHAR2, COUNTER NUMBER). For various reasons that are unimportant in this context the tables work by atempting an insert on (NAME, 1) and if that fails they do an update COUNTER = COUNTER +!; This has been running fine for 3 years. Suddenly in the past 3 weeks I have been seeing performance problems and the sudden appearance of some (apprently) constraint checking recursive sql whihc is in direct proportionto the inserts. This recursive sql was never in the sqlarea previously. The lines look like: select executions, sqltext from v$sqlarea; 166092573 INSERT INTO HITCOUNTER ( ALIAS,USEHITCOUNTER,HITS ) VALUES ( :b1,1,0 ) 165799528 select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user# Further if I do: desc v$session; select sql_text from v$sqlarea sq, v$session se where prev_sql_addr = 'AA46049C' and prev_hash_value = '1318728909' and sql_address = sq.address and sql_hash_value = sq.hash_value; (that sql_address and hsah_value are for the insert statement above) I frequently (though not exclusively the recursive sql) I am always returned either no rows or that recursive sql statement (and these are not the most executed statements in the db either (they are 10th and 11th respectively, and any session is equally likely to run any of the the top 20 executed queries, in any pairings), so I would expect to see others if this was just a coincidence. I've searched Metalink and Google for this sql with basically no luck, and I have an open Tar which is getting no response. has anyone seen anything similair? Any clues, thoughts, etc? --George Schlossnagle 1024D/1100A5A0 1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0 = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
No Subject
SET ORACLE-L DIGEST Raymond fall asleep in waiting for the Q. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: constraint naming
Guy, Per bug 15148 this is scheduled for 9.0.2. I don't know of any supported method of doing this, other than dropping and recreating the constraint. HTH, -- Anita --- Guy Hammond [EMAIL PROTECTED] wrote: O Wise and Powerful Oracle: Is there a way to change thy system-generated names for foreign key constraints to something sensible without invoking Deep Magic? g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL PROTECTED] Office: +44 (0) 207 454 1224 Mobile: +44 (0) 7966 164687 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Starting Oracle services remotely (Win2K).
Hi all, Has anybody come across a way of starting the Oracle services (or indeed any service) on a Win2K box remotely from another Win2K machine? I would be interested in your insight if you have.. Cheers Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: The number of used cursors?
Tamas: I've done some looking into this issue and I think it depends on what you want when you say want to know the number of used cursors. If you mean those that have been opened AND parsed, then a count from v$open_cursor will give you that (for the most part). If, however, you want to know the number of dynamic cursors that have been opened (parsed or not), then the statistic 'opened cursors current' will give you that number. Keep in mind, too, that a row in v$open_cursor does not necessarily mean that the cursor is open and in use. For performance reasons, cursors are not closed, but cancelled. This allows most system resources to be released while still allowing the cursor to be reused if need be. There is currently no view that ill provide this information as to how many cursors are really open and in use (i.e., open and not cancelled). Hope this helps. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 24, 2001 5:55 AM Thank you for the anwers. If I try Jon's version I get a big number that does not seem to be related to the number of maximum open cursors ( it's much higher). If I query the V$SQL_CURSOR view, then I get a number the could be the value I look for. Could some one shed some light on this? Regards Tamas Szecsy -Original Message- Sent: Monday, July 23, 2001 5:29 PM To: Multiple recipients of list ORACLE-L Try this: select sum(value) as open_cursors from sys.v_$sesstat s , sys.v_$statname n where s.statistic# = n.statistic# and n.name = 'opened cursors current'; Jon Walthour --- Original Message --- From: Szecsy Tamas [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/23/01 9:55:24 AM Hi, I would like to know the the number of used cursors at any given time. Is there a select statement that does this for me? I would like to decide if the growing number of concurent users for a given database has reached the point where the maximum open cursor init ora parameter got to be increased. Thank you in advance. Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Question on on delete cascade functionality
Dear DBA Gurus, How to add the functionality of on delete cascade to an existing foreign key constraint without dropping the constraint and recreating it using Alter command? Thanks and Regards, Ranganath DISCLAIMER: This correspondence is confidential and intended for the named recipient(s) only. If you are not the named recipient and receive this correspondence in error, you must not copy, distribute or take any action in reliance on it and you should delete it from your system and notify the sender immediately. Unless otherwise stated, any views or opinions expressed are solely those of the author and do not represent those of Subex Systems Limited. www.subexgroup.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Starting Oracle services remotely (Win2K).
Hi rexec servername -l username -- net start oracle should do it. Or you can use graphical tools through the admin tools and install the snapins = rexec computer [-l username] [-n] command Net start Starts a service, or displays a list of started services. Service names of two or more words, such as Net Logon or Computer Browser, must be enclosed in quotation marks (). net start [service] Parameters none Type net start without parameters to display a list of running services. At 09:05 PM 24/07/2001, you wrote: Hi all, Has anybody come across a way of starting the Oracle services (or indeed any service) on a Win2K box remotely from another Win2K machine? I would be interested in your insight if you have.. Cheers Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter McLarty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: constraint naming
Guy Hammond wrote: O Wise and Powerful Oracle: Is there a way to change thy system-generated names for foreign key constraints to something sensible without invoking Deep Magic? g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL PROTECTED] Office: +44 (0) 207 454 1224 Mobile: +44 (0) 7966 164687 Foreign key you say? I think that for them updating sys.con$ should be relatively safe, I don't believe that there is any other place (contrarily to PK and UQ constraints) where the name appears and is used. If I where you I would export with ROWS=N, reimport into a test database, fiddle in the dictionary, export the result with ROWS=N again, check with imp SHOW=Y that it looks like what you want, drop all FKs on the prod database, and reimport on the prod with IGNORE=Y. Should keep the risk of screwing up something to a minimum. -- Regards, Stephane Faroult Oriole Corporation -- http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Starting Oracle services remotely (Win2K).
Hi, Mark Why not to use a Terminal Services (which comes on Win2k's Installation CD) for this purpose? Install TS on a needed box, then install client software on your own machine and go on... Igor -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 3:05 PM To: Multiple recipients of list ORACLE-L Subject: Starting Oracle services remotely (Win2K). Hi all, Has anybody come across a way of starting the Oracle services (or indeed any service) on a Win2K box remotely from another Win2K machine? I would be interested in your insight if you have.. Cheers Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BELOV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Starting Oracle services remotely (Win2K).
Add the computer in the MMC (Microsoft Management Console) and then you can control whatever you want (if you're an Administrator). Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 24, 2001 7:05 AM Hi all, Has anybody come across a way of starting the Oracle services (or indeed any service) on a Win2K box remotely from another Win2K machine? I would be interested in your insight if you have.. Cheers Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Question on on delete cascade functionality
sounds like a trigger is needed. joe Ranganath K wrote: Dear DBA Gurus, How to add the functionality of on delete cascade to an existing foreign key constraint without dropping the constraint and recreating it using Alter command? Thanks and Regards, Ranganath DISCLAIMER: This correspondence is confidential and intended for the named recipient(s) only. If you are not the named recipient and receive this correspondence in error, you must not copy, distribute or take any action in reliance on it and you should delete it from your system and notify the sender immediately. Unless otherwise stated, any views or opinions expressed are solely those of the author and do not represent those of Subex Systems Limited. www.subexgroup.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing) -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: The number of used cursors?
Hi Tamas, V$SQL_CURSOR is providing the number of cursors for the querying session, but Jon's query, give the current opened cursors for all session. If you restrict v$sesstat to the sid of your session and v$sql_cursor to status not 'CURNULL', you will get the same number. That's: select value as open_cursors from sys.v_$sesstat s , sys.v_$statname n where s.statistic# = n.statistic and n.name = 'opened cursors current' and s.sid=your_sid; is the same that querying select count(*) from v$sql_cursor where status != 'CURNULL'; HTH Àngel At 03.15 24/7/01 -0800, you wrote: Tamas: I've done some looking into this issue and I think it depends on what you want when you say want to know the number of used cursors. If you mean those that have been opened AND parsed, then a count from v$open_cursor will give you that (for the most part). If, however, you want to know the number of dynamic cursors that have been opened (parsed or not), then the statistic 'opened cursors current' will give you that number. Keep in mind, too, that a row in v$open_cursor does not necessarily mean that the cursor is open and in use. For performance reasons, cursors are not closed, but cancelled. This allows most system resources to be released while still allowing the cursor to be reused if need be. There is currently no view that ill provide this information as to how many cursors are really open and in use (i.e., open and not cancelled). Hope this helps. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 24, 2001 5:55 AM Thank you for the anwers. If I try Jon's version I get a big number that does not seem to be related to the number of maximum open cursors ( it's much higher). If I query the V$SQL_CURSOR view, then I get a number the could be the value I look for. Could some one shed some light on this? Regards Tamas Szecsy -Original Message- Sent: Monday, July 23, 2001 5:29 PM To: Multiple recipients of list ORACLE-L Try this: select sum(value) as open_cursors from sys.v_$sesstat s , sys.v_$statname n where s.statistic# = n.statistic# and n.name = 'opened cursors current'; Jon Walthour --- Original Message --- From: Szecsy Tamas [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/23/01 9:55:24 AM Hi, I would like to know the the number of used cursors at any given time. Is there a select statement that does this for me? I would like to decide if the growing number of concurent users for a given database has reached the point where the maximum open cursor init ora parameter got to be increased. Thank you in advance. Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network
IAS-Apache and PHP
Title: IAS-Apache and PHP Hi gurus, Has anyone tried to include a PHP module to Apache in IAS ? Does Oracle support it? We have some PL/SQL applications (drive by OAS) that we need to migrate to IAS. We have some other new applications in PHP. Do we have to maintain two Apaches (one in IAS plus one for the PHP application) ? TIA Luc - Luc Demanche CETELEM Tél.: 01-46-39-14-49 Fax : 01-46-39-59-88
RE: How to download website
Use wget. You can get it, along with a bunch of other good stuff, here: http://www.weihenstephan.de/~syring/win32/UnxUtils.html g -Original Message- Sent: Monday, July 23, 2001 3:46 PM To: Multiple recipients of list ORACLE-L hi dba's is there anyway to download complete website including links in a single shot. i got this problem, when i need to copy many html pages, that are linked to a single site. if i need to copy them, i hv to open every file and have to say save from windows. so can anybody tell me easy way of finishing my task. i need to copy 500 pages from that site. thanx in advance prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sun cluster vs Veritas cluster
List, Just wondering if anyone on the list who had experience on both Sun clustering and Veritas clustering software share their experience on both products, strength and weakness or any comparison?? KC
Re: Question on on delete cascade functionality
While a ON DELETE trigger would do what you want, why don't you want to rebuild the constraint? [EMAIL PROTECTED] 07/24/01 08:05AM sounds like a trigger is needed. joe Ranganath K wrote: Dear DBA Gurus, How to add the functionality of on delete cascade to an existing foreign key constraint without dropping the constraint and recreating it using Alter command? Thanks and Regards, Ranganath DISCLAIMER: This correspondence is confidential and intended for the named recipient(s) only. If you are not the named recipient and receive this correspondence in error, you must not copy, distribute or take any action in reliance on it and you should delete it from your system and notify the sender immediately. Unless otherwise stated, any views or opinions expressed are solely those of the author and do not represent those of Subex Systems Limited. www.subexgroup.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing) -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
retrieving BLOB column..
hi all, do any one tell me how can i retrieve from a blob column. these will be displayed in browser through asp page. r there any functions used to retrieved records(jpg files, gif) from a blob. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
Re: IAS-Apache and PHP
I'm not an expert in this area but I do know that we haven't two apaches ie. our administrator installed Oracle and IAS and then added PHP module and this WASN'T very painful process ;) How? I don't know :( Oracle 8.1.7 on red hat linux 6.2 Gints Plivna DEMANCHE Luc (Cetelem) To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Luc.Demanche@ccc: etelem.fr Subject: IAS-Apache and PHP Sent by: [EMAIL PROTECTED] m 2001.07.24 14:35 Please respond to ORACLE-L Hi gurus, Has anyone tried to include a PHP module to Apache in IAS ? Does Oracle support it? We have some PL/SQL applications (drive by OAS) that we need to migrate to IAS. We have some other new applications in PHP. Do we have to maintain two Apaches (one in IAS plus one for the PHP application) ? TIA Luc - Luc Demanche CETELEM Tél.: 01-46-39-14-49 Fax : 01-46-39-59-88 -- 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).
Solaris 8 and 9i
List, Just wondering if anyone on the list has the combination of Solaris 8 and 9i loaded. Strength and weakness on both products or any comparison?? Currently running Solaris 5.7 and Oracle 8.1.7. My SA wants to go to Solaris 8 and I was thinking about going to 9i on our development box when we upgrade. TIA Al Rusnak -- 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).
Re: constraint naming
g, Why use system generated FK names. does SYS12345 maen any thing to you? We always generate our FK with an ALTER TABLE command and name the FK with something that can be recognized. Very usefull when you have to drop the FK to accomplish an import of data. ROR mª¿ªm [EMAIL PROTECTED] 07/24/01 05:21AM O Wise and Powerful Oracle: Is there a way to change thy system-generated names for foreign key constraints to something sensible without invoking Deep Magic? g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL PROTECTED] Office: +44 (0) 207 454 1224 Mobile: +44 (0) 7966 164687 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
urgent synthax of DBV
i need in urgence DBV synthax thanks !!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
template for description of Oracle installation
I'am searching for a template of a good looking description of an Oracle installation. Can anybody help me ? Regards, sh476622 --== Sent via Deja.com ==-- http://www.deja.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sh.476622 sh476622 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: urgent synthax of DBV
Try dbv help=y Or click here : http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76955/ch09.htm#1936 (found by searching for 'dbv' at http://tahiti.oracle.com/pls/tahiti/tahiti.homepage :) HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Djaroud Salim [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 8:25 AM To: Multiple recipients of list ORACLE-L Subject: urgent synthax of DBV i need in urgence DBV synthax thanks !!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
waits on sequential scans - how did i solve it
list, based on the recommendation of posters (Jack) , i re-created the index with all the columns of a table ! (all 8 of them) analyzed the table/index and now all the queries are satisfied off an indexed range scan.. i also put the indexes on raw devices. regards -- From: Jack C. Applewhite[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, July 17, 2001 8:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: how to improve sequential scans ? Rahul, Could this table be partitioned and the partitions spread across multiple disks? Could the index be partitioned as well? The concept here is, of course, divide and conquer. Could a column or two (or three) be added to the index to satisfy the query without having to hit the table? How frequently are these literal queries being issued? Are they shredding your shared pool and chewing up CPU by making Oracle do extra work in shared pool memory management? Are there aggregation (vs aggravation g) functions or order bys in the queries that might be causing sorts to disk? If aggregation, could you use materialized views to satisfy the queries? ...just a few ideas. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Tuesday, July 17, 2001 7:36 AM To: Multiple recipients of list ORACLE-L list (AIX, 7.3.2) 5 clients are shooting the same sql to read data from an 18 million rows table. each time the sql uses a different literal value in the where clause... no bind variables. I CANNOT TOUCH THE APPLICATION, and have been given the task to re-configure the DB to increase performance. i have moved the table and it;s associated index to separate disks. and iostat show that only that only those two disks are being read. the session wait show that all the times the sessions are waiting on db file sequential read the db file being sequentially read in the above sessiion is the TABLE from which all the sid's are reading the table is analyzed and the sql's issued use the index. how can i further tune this config. ? TIA Rahul PS: my next step is to put the files on raw disks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Solaris 8 and 9i
I have solaris 8 and oracle 9i on my home development box. 9i is awesome, but it is also very immature. Solaris 8 has many new features and definitely worth the upgrade. Make sure you get 04/01 or newer. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, July 24, 2001 9:25 AM To: Multiple recipients of list ORACLE-L List, Just wondering if anyone on the list has the combination of Solaris 8 and 9i loaded. Strength and weakness on both products or any comparison?? Currently running Solaris 5.7 and Oracle 8.1.7. My SA wants to go to Solaris 8 and I was thinking about going to 9i on our development box when we upgrade. TIA Al Rusnak -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Solaris 8 and 9i
but it is also very immature. For example - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 8:46 AM To: Multiple recipients of list ORACLE-L Subject: RE: Solaris 8 and 9i I have solaris 8 and oracle 9i on my home development box. 9i is awesome, but it is also very immature. Solaris 8 has many new features and definitely worth the upgrade. Make sure you get 04/01 or newer. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, July 24, 2001 9:25 AM To: Multiple recipients of list ORACLE-L List, Just wondering if anyone on the list has the combination of Solaris 8 and 9i loaded. Strength and weakness on both products or any comparison?? Currently running Solaris 5.7 and Oracle 8.1.7. My SA wants to go to Solaris 8 and I was thinking about going to 9i on our development box when we upgrade. TIA Al Rusnak -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Starting Oracle services remotely (Win2K). - Thanks
Thanks to Peter, Igor and of course Jon. It's easy when you know how huh - I used Computer Management in the Admin tools, and simply used the Action of connecting to another computer.. Cheers for your help. Mark -Original Message- Walthour Sent: Tuesday, July 24, 2001 12:46 To: Multiple recipients of list ORACLE-L Add the computer in the MMC (Microsoft Management Console) and then you can control whatever you want (if you're an Administrator). Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 24, 2001 7:05 AM Hi all, Has anybody come across a way of starting the Oracle services (or indeed any service) on a Win2K box remotely from another Win2K machine? I would be interested in your insight if you have.. Cheers Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Input truncated
Just do a carriage return at the end of the last line. The last line will be 35 characters long. Iain -Original Message- Sent: 24 July 2001 15:01 To: Multiple recipients of list ORACLE-L I don't know why when I try to load error_p1 procedure it's printed Input truncated to 35 characters. SQL @error_p1 Procedure created. Input truncated to 35 characters No errors. Can anybody help me ? Thanks, Andrea -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nicoll, Iain (Calanais) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Input truncated
I don't know why when I try to load error_p1 procedure it's printed Input truncated to 35 characters. SQL @error_p1 Procedure created. Input truncated to 35 characters No errors. Can anybody help me ? Thanks, Andrea -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Off Topic: For Sale Sparc 5 170MHz capable of running 9i
Thanks Guy! Mark -Original Message- Sent: Tuesday, July 24, 2001 01:11 To: Multiple recipients of list ORACLE-L Mark, you can get cheap Sun kit in the UK from here: http://213.48.204.69/main/sun.htm g -Original Message- Sent: Monday, July 23, 2001 3:06 PM To: Multiple recipients of list ORACLE-L Christopher, What would the total cost be for an upgrade to 256Mb RAM, and a 10 gig disk? Same for 512Mb RAM. Then of course there would be the cost of shipping it to the UK.. We are looking for a low range test box at the moment.. Cheers Mark -Original Message- Spence Sent: Sunday, July 22, 2001 02:35 To: Multiple recipients of list ORACLE-L If anyone is interested in a cheap machine to start playing with 9i with. I just got a lot of 100 Sparc 5's. Standard configuration is: HyperSparc 170MHz 64Mb Ram Internal CDROM and Floppy Turbo GX Video (13W Connector) 2Gb SCSI Hard Drive I am putting them on ebay at $225 each. Which is less than they normally go for, but I just want to get rid of this shipment so I can get this lot of Blade 1000's. To run Oracle 9i, I would recommend increasing the ram and disk. Which we have both. Sorry about the off topic, I know a few people mentioned they were looking for some machines. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Reproduce ORA-0600
I had a production database become corrupt after an ORA-07445 and an ORA-0600 occurred. The instance would not come back up and had to be recovered. I can reproduce and correct the ORA-07445 (bad block) but it doesn't create the ORA-0600 or corrupt the database. I have tried adding rows, deleting rows, reading by the index by requesting all columns in the index, updating all columns in the index. Nothing seems to work. Any ideas on how I can reproduce the error? Ron Smith [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: retrieving BLOB column..
Saurabh, Check out the DBMS_LOB package. There are lots of procedures and functions for manipulating BLOBs and CLOBs. Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Saurabh SharmaSent: Tuesday, July 24, 2001 8:10 AMTo: Multiple recipients of list ORACLE-LSubject: retrieving BLOB column.. hi all, do any one tell me how can i retrieve from a blob column. these will be displayed in browser through asp page. r there any functions used to retrieved records(jpg files, gif) from a blob. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
RE: waits on sequential scans - how did i solve it
Rahul, If I'd known that there were only 8 columns in the table, I'd have included the recommendation to investigate an Index-Organized Table. That is where the table IS the index and the index IS the table. This saves disc space and cuts I/O in half for DML on the table, since a separate index is not maintained. Check out the docs on IOTs. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Tuesday, July 24, 2001 8:53 AM To: Multiple recipients of list ORACLE-L list, based on the recommendation of posters (Jack) , i re-created the index with all the columns of a table ! (all 8 of them) analyzed the table/index and now all the queries are satisfied off an indexed range scan.. i also put the indexes on raw devices. regards -- From: Jack C. Applewhite[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, July 17, 2001 8:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: how to improve sequential scans ? Rahul, Could this table be partitioned and the partitions spread across multiple disks? Could the index be partitioned as well? The concept here is, of course, divide and conquer. Could a column or two (or three) be added to the index to satisfy the query without having to hit the table? How frequently are these literal queries being issued? Are they shredding your shared pool and chewing up CPU by making Oracle do extra work in shared pool memory management? Are there aggregation (vs aggravation g) functions or order bys in the queries that might be causing sorts to disk? If aggregation, could you use materialized views to satisfy the queries? ...just a few ideas. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Tuesday, July 17, 2001 7:36 AM To: Multiple recipients of list ORACLE-L list (AIX, 7.3.2) 5 clients are shooting the same sql to read data from an 18 million rows table. each time the sql uses a different literal value in the where clause... no bind variables. I CANNOT TOUCH THE APPLICATION, and have been given the task to re-configure the DB to increase performance. i have moved the table and it;s associated index to separate disks. and iostat show that only that only those two disks are being read. the session wait show that all the times the sessions are waiting on db file sequential read the db file being sequentially read in the above sessiion is the TABLE from which all the sid's are reading the table is analyzed and the sql's issued use the index. how can i further tune this config. ? TIA Rahul PS: my next step is to put the files on raw disks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RMAN duplicate database query
Title: RMAN duplicate database query Hello listers, We have a instance on server A, a RMAN recovery catalogue on server B and a 3rd server C where we want to create a copy of the live database with a new sid. This is on Oracle 8.1.7 The RMAN duplicate command seems to be the one to use but there is one hing I cannot understand. All the documentation (and I have RTFM until my head hurts) suggests that the run script needs to make 3 connections (target - server A, rcat - server B and new instance server C). I do not know why we need to connect to the target sid (server A) at all. We don't want a synchronised duplicate at all but from midnight last night (or 3 days ago is fine). Therefore the rcat should all the information it requires. Furthermore we don't have remote_login_passwordfile created on server A and we don't really want to . As part of the testing we tried setting the dbid to the name of the instance we want but it still seems to expect the connection to server A. Anyone have any experience in this area that could help me. John Oracle DBA BTcellnet * [EMAIL PROTECTED] ( 0113 388 6062 ) 07710 472498 ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
Re: Solaris 8 and 9i
On Tue, Jul 24, 2001 at 05:25:29AM -0800, Rusnak, George A. wrote: List, Just wondering if anyone on the list has the combination of Solaris 8 and 9i loaded. Strength and weakness on both products or any comparison?? Currently running Solaris 5.7 and Oracle 8.1.7. My SA wants to go to Solaris 8 and I was thinking about going to 9i on our development box when we upgrade. -- This would be a good idea if it works or there is no liability. If there is liability and there are problems, will the spotlight be on you or the sa? I suppose if you can point at the sa faster than he can point at you then, no prob. Kinda like the ol' wild West. On the other hand, you might get a medal for bringing some duhvelopers to a standstill. ;) === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: HELP
Norrell, Brian wrote: No one will be watching us, Why don't we do it in the code? i think we can code now... -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Input truncated
Andrea: Open up your .sql file in notepad or the like and put a carriage return after the last line so you, in effect, have a final blank line. Jon Walthour --- Original Message --- From: Quaglio Andrea [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/24/01 10:00:47 AM I don't know why when I try to load error_p1 procedure it's printed Input truncated to 35 characters. SQL @error_p1 Procedure created. Input truncated to 35 characters No errors. Can anybody help me ? Thanks, Andrea -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Input truncated
Title: RE: Input truncated Andrea, put a carriage return after your last slash and this will go away. It's harmless. Lisa Koivu Ft. Lauderdale, FL, USA -Original Message- From: Quaglio Andrea [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 10:01 AM To: Multiple recipients of list ORACLE-L Subject: Input truncated I don't know why when I try to load error_p1 procedure it's printed Input truncated to 35 characters. SQL @error_p1 Procedure created. Input truncated to 35 characters No errors. Can anybody help me ? Thanks, Andrea -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Input truncated
In your pl/sql script add a carriage return after / Rick -Original Message- Sent: Tuesday, July 24, 2001 10:01 AM To: Multiple recipients of list ORACLE-L I don't know why when I try to load error_p1 procedure it's printed Input truncated to 35 characters. SQL @error_p1 Procedure created. Input truncated to 35 characters No errors. Can anybody help me ? Thanks, Andrea -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Input truncated
Hi, Andrea , Nothing to worry about. If you want to get rid of this message, remove blank lines after procedure code. HTH Vadim Gorbounov Brainbench Master Oracle DBA www.brainbench.com -Original Message- Sent: Tuesday, July 24, 2001 10:01 AM To: Multiple recipients of list ORACLE-L I don't know why when I try to load error_p1 procedure it's printed Input truncated to 35 characters. SQL @error_p1 Procedure created. Input truncated to 35 characters No errors. Can anybody help me ? Thanks, Andrea -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: waits on sequential scans - how did i solve it
Title: RE: waits on sequential scans - how did i solve it Is this table/index now suitable to be a IOT, it will certainly save some space on an 18M row table John -Original Message- From: Rahul [mailto:[EMAIL PROTECTED]] Sent: 24 July 01 14:53 To: Multiple recipients of list ORACLE-L Subject: waits on sequential scans - how did i solve it list, based on the recommendation of posters (Jack) , i re-created the index with all the columns of a table ! (all 8 of them) analyzed the table/index and now all the queries are satisfied off an indexed range scan.. i also put the indexes on raw devices. regards -- From: Jack C. Applewhite[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, July 17, 2001 8:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: how to improve sequential scans ? Rahul, Could this table be partitioned and the partitions spread across multiple disks? Could the index be partitioned as well? The concept here is, of course, divide and conquer. Could a column or two (or three) be added to the index to satisfy the query without having to hit the table? How frequently are these literal queries being issued? Are they shredding your shared pool and chewing up CPU by making Oracle do extra work in shared pool memory management? Are there aggregation (vs aggravation g) functions or order bys in the queries that might be causing sorts to disk? If aggregation, could you use materialized views to satisfy the queries? ...just a few ideas. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Tuesday, July 17, 2001 7:36 AM To: Multiple recipients of list ORACLE-L list (AIX, 7.3.2) 5 clients are shooting the same sql to read data from an 18 million rows table. each time the sql uses a different literal value in the where clause... no bind variables. I CANNOT TOUCH THE APPLICATION, and have been given the task to re-configure the DB to increase performance. i have moved the table and it;s associated index to separate disks. and iostat show that only that only those two disks are being read. the session wait show that all the times the sessions are waiting on db file sequential read the db file being sequentially read in the above sessiion is the TABLE from which all the sid's are reading the table is analyzed and the sql's issued use the index. how can i further tune this config. ? TIA Rahul PS: my next step is to put the files on raw disks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
Re: Input truncated
Andrea, Make sure that at the end of your script you don't have additional returns and one hard return after the last command. (i.e. SET OFF SET OFF SELECT * FROM table / SET ON SET ON one return here and no other lines after Hope this helps. Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Solaris 8 Question
This happened to me today: Solaris 5.8 we have a large data load exercise going on and the archive log directory filled - database stopped of course. but after I had moved all the archive logs to another location the system still hung - I tried manual switching of log file ,still hung. I had to stop and start instance - I was surprised. did I miss something ? sam - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 20, 2001 2:15 PM If it's / or /tmp, then yes, your machine could well become unusable until it gets some free space. If your archive log disk fills, Oracle will refuse transactions until there is free space. Read the man page for 'quota' to help you limit the possibility of this. And think about switching autoextend off. Cheers, g -Original Message- Sent: Thursday, July 19, 2001 4:10 PM To: Multiple recipients of list ORACLE-L Hi all, A friend of mine is having a problem so I thought I would ask all of you experts a quick question. On a Solaris 8 box running 8.1.7, if a partition fills up, will it crash the box? I know that on NT this is very possible depending on pagefile and what file is filling up the partition. But I don't know anything about Sun. Thanks alot:) Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Roberts INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 deal with special character like in ' '
You could do select 'string1 '|| chr(38) ||' string2' from dual Baskar -Original Message- Sent: 23 July 2001 18:51 To: Multiple recipients of list ORACLE-L Hi, I want to insert a string like 'AM University' but has problem with '' I want the database exact AM University. But it always ask me new or old value because of symbol '' how could I deal with that. Thanks. HL _ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ http://phonecard.yahoo.com/?.refer=mailtagline -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramasamy, Baskar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: tnsnames.ora in clients
Thanks to who responded and responding. Suren -Original Message- Sent: Monday, July 23, 2001 2:13 PM To: Multiple recipients of list ORACLE-L except that ONS is going away in favor of ldap. joe [EMAIL PROTECTED] 07/23/01 12:58PM We switched to ONS 3 years ago have never regretted it. Getting rid of the tnsnames.ora file was the berries. Dick Goulet Reply Separator Author: Page; Bruce [EMAIL PROTECTED] Date: 7/23/2001 7:52 AM One method I have seen used a lot is to set the TNS_ADMIN variable to point to the centralized file. Another is to have the LAN guys add a check to their login script to check to see if the TNSNAMES.ORA has been updated and if it has, have it pushed down when the user logs into the LAN. -Original Message- From: Tirumala, Surendra [ mailto:[EMAIL PROTECTED]] mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Subject: tnsnames.ora in clients Hello All, Good morning! I would like to know how the 'tnsnames.ora' file on all client(windows) machines can be updated automatically whenever something changed on central 'tnsnames.ora' file. Is this the process still being used extensively or else advanced features like ONS. Your suggestions are highly appreciated. Thanks, Suren Consultant DBA Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 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: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 duplicate database query
I am testing the duplicate command now. I don't think you need password file on server A, but you do need a password file on server C. To my understand, you do need 3 connections to make it work. Even you want duplicate days old copy. I think rman somehow needs info from control file on server A. For example, once I reset the database on target. I can't duplicate it with any backupset any more. Anyway, I am still learning and testing it. probably not know better than you do. Joan Hallas John wrote: Hello listers, We have a instance on server A, a RMAN recovery catalogue on server B and a 3rd server C where we want to create a copy of the live database with a new sid. This is on Oracle 8.1.7 The RMAN duplicate command seems to be the one to use but there is one hing I cannot understand. All the documentation (and I have RTFM until my head hurts) suggests that the run script needs to make 3 connections (target - server A, rcat - server B and new instance server C). I do not know why we need to connect to the target sid (server A) at all. We don't want a synchronised duplicate at all but from midnight last night (or 3 days ago is fine). Therefore the rcat should all the information it requires. Furthermore we don't have remote_login_passwordfile created on server A and we don't really want to . As part of the testing we tried setting the dbid to the name of the instance we want but it still seems to expect the connection to server A. Anyone have any experience in this area that could help me. John Oracle DBA BTcellnet * [EMAIL PROTECTED] ( 0113 388 6062 ) 07710 472498 ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: waits on sequential scans - how did i solve it
I don't think, 7.3.2 supports Index-Organized tables. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 24, 2001 10:36 AM Rahul, If I'd known that there were only 8 columns in the table, I'd have included the recommendation to investigate an Index-Organized Table. That is where the table IS the index and the index IS the table. This saves disc space and cuts I/O in half for DML on the table, since a separate index is not maintained. Check out the docs on IOTs. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Tuesday, July 24, 2001 8:53 AM To: Multiple recipients of list ORACLE-L list, based on the recommendation of posters (Jack) , i re-created the index with all the columns of a table ! (all 8 of them) analyzed the table/index and now all the queries are satisfied off an indexed range scan.. i also put the indexes on raw devices. regards -- From: Jack C. Applewhite[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, July 17, 2001 8:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: how to improve sequential scans ? Rahul, Could this table be partitioned and the partitions spread across multiple disks? Could the index be partitioned as well? The concept here is, of course, divide and conquer. Could a column or two (or three) be added to the index to satisfy the query without having to hit the table? How frequently are these literal queries being issued? Are they shredding your shared pool and chewing up CPU by making Oracle do extra work in shared pool memory management? Are there aggregation (vs aggravation g) functions or order bys in the queries that might be causing sorts to disk? If aggregation, could you use materialized views to satisfy the queries? ...just a few ideas. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Tuesday, July 17, 2001 7:36 AM To: Multiple recipients of list ORACLE-L list (AIX, 7.3.2) 5 clients are shooting the same sql to read data from an 18 million rows table. each time the sql uses a different literal value in the where clause... no bind variables. I CANNOT TOUCH THE APPLICATION, and have been given the task to re-configure the DB to increase performance. i have moved the table and it;s associated index to separate disks. and iostat show that only that only those two disks are being read. the session wait show that all the times the sessions are waiting on db file sequential read the db file being sequentially read in the above sessiion is the TABLE from which all the sid's are reading the table is analyzed and the sql's issued use the index. how can i further tune this config. ? TIA Rahul PS: my next step is to put the files on raw disks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Temp tablespace issue
Y'day I got this errors, I tried to resize the file, But I could't succeed! Later I did wakeup SMON and tried with alter tablespace temp ..(pctincrease 0)..But still I getting ora-600 with ora-01114/ora-07376 errors..Then I put that particular temp file in offline!!..I problems increased!! Then I try to put online..It asked recovery .I applied the recovery..Problem is gone!! My space is okay. But I find for simple temp space insuffcient, just wake up SMON!! Its works well. But any ora-600 problems..STILL PUZZLE?? Mon Jul 23 08:26:13 2001 Errors in file /software/app/oracle/admin/baanIV/udump/ora_65640.trc: ORA-00600: internal error code, arguments: [3509], [2], [], [], [], [], [], [] ORA-01114: IO error writing block to file 166 (block # 134552) ORA-07376: sfwfb: write error, unable to write database block. IBM AIX RISC System/6000 Error: 27: File too large Additional information: 134552 Thanks Raghu. From: Deshpande, Kirti [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Subject: RE: Temp tablespace issue Date: Tue, 24 Jul 2001 08:52:53 -0500 If your are getting ORA-600 error for seemingly simple operations, I think it is time to get Oracle Support involved as soon as possible. Good Luck. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Pankaj Behl [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 8:37 AM To: LazyDBA.com Discussion Subject:Temp tablespace issue Hi Guru's Today seems to be the day for awakenings! Our temp tablespace is about 10GB and the application uses up to about 3.5 GB. We had a space issue on the development box and i tried to reclaim some space by resizing the temp tablespace. But..when i tried to resize the TEMP tablespace i had ORA-600 errors reported in the log files and i had to kill the sql session that was performing the resize. I have not noticed any problems since. I also tried to drop the temp tablespace with similar problems. What all am i missing? Would appreciate any help in this regard as we are still up and running and still need to tackle the space issue. Thanks and Regards, Pankaj Behl __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Solaris 8 Question
Sam, you may find that you need to issue archive log stop and archive log start to force the database to start archiving again. Once it's failed to archive a log it seems to lose heart and give up until you nudge it. Ironically the ARCHIVER will keep writing to the alert log to say that it's still trying. But it isn't. No doubt it's a feature. I've seen this on AIX, HP, Solaris, you name it. Regards, Mike Hately |+ || Sam Roberts | || rabbit@emirat| || es.net.ae| ||| || 07/24/01 04:05| || PM| || Please respond| || to ORACLE-L | ||| |+ | || | To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] | | cc: (bcc: Mike Hately/ETECH) | | Subject: Re: Solaris 8 Question | | This happened to me today: Solaris 5.8 we have a large data load exercise going on and the archive log directory filled - database stopped of course. but after I had moved all the archive logs to another location the system still hung - I tried manual switching of log file ,still hung. I had to stop and start instance - I was surprised. did I miss something ? sam -- 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).
Alert Logs Trashed after Archive Directory Fill
Evening; Over the past year we have had our Archive directory fill up a couple times. During that time, some of our instances have had corrupted archive logs. We found this out by applying them to our Standby Databases and getting errors. There appears to be no set pattern to this corruption. One time it was on instance A, while another time it was on instance B. Has anyone else on the list ran into an occurance such as this ?? If so , is there anything that can be done about it ? I get tired of rebuilding our Standby Databases. We are using Oracle 8.0.5 on SunOS 5.7. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Urgent: ORA-03113
Red Hat 6.2 Oracle 8.1.6.1 192MB of RAM While running dbassist, ORA-03113 EOF on communication channel appears (progress bar shows between 65% and 75%). What might be possible reason? Software installation went without problems. Please help -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sadzakovic Slavica INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Data Modeling opinion? Help?
I am currently on a project where I have pretty much completed the logical/physical models. Since the client has there own data modelers, they have reviewed the models and wanted specific changes. I have agreed with all there changes except for one. I have tried to explain why this change would not be prudent, but they have insisted. To ensure that there change is enforced they went to there management and have now placed there change into the project requirements. Thereby, forcing us, the contractor, to implement this change into the model. I have run this change by several different people and they agree that it should not be implemented. I am now looking for feedback from the list. If you are willing to provide feedback then please read on... This is a claims system. A mailed package was not delivered or is damaged, so the customer files a claim. Every claim consists of the mailer's name and address, and the addressee's name and address, plus some other information. Aside from the average consumer, a Business Mailer(BM) can also file a claim. The BM has a special agreement with the client and gets special treatment when filing claims, and therefore a Business Mailer profile is created. Originally, I was going to describe the two versions of the model, but decided to post PDF files of the model on the web. The ERDs are accessible by clicking on the links below. One way --- http://www.geocities.com/christophergrabowy/oneway.pdf Two way --- http://www.geocities.com/christophergrabowy/twoway.pdf Both models have a claim table, which contains all the miscellaneous claim information. Both models have an address table. Oneway.pdf separates the BM addresses out, because they are not related to a claim. Twoway.pdf puts all the addresses(claim addresses and BM profile addresses) into the address table, and also includes the customer name fields. Both models have a customer table. This is were the majority of the dispute revolves around. In oneway.pdf, the customer table contains the customer names(mailer and addressee) that were submitted with the claim, it's PK is the claim_id. The Business Mailer profile is not directly related to a specific claim, so it is put into it's own table(a BM profile table), it's PK is the BM agreement number. In twoway.pdf, the customer table contains the name of the customer that filed the claim, and the Business Mailer profiles. Since these types of data use different fields, then the top part of the customer table contains the customer name fields, and bottom part of the table contains the Business Mailer profile fields. And since either part of the table could be filled out, all the fields are null. Finally, since there is no natural PK for the combination of these two records types, a synthetic PK is generated. If anyone has any questions then please don't hesitate to ask. Again, any feedback would be greatly appreciated. MANY THANKS Chris May Oracle be with you...always -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RMAN problem after Duplicate
I duplicated a production database using RMAN. I have done this many times. EXCEPT, this time I forgot to issue a RESET DATABASE for the duplicated database. My backups ran last night for both production and the duplicated database. The backup for the duplicated database failed with this error: RMAN-20003: target database incarnation not found in recovery catalog So, I connected via RMAN, issued the RESET DATABASE command and ran the backup. Now, when I try to reference my duplicate database in RMAN, I get the following: RMAN-20005 target database name is ambiguous If I try to reference my production database in RMAN, I get the following: RMAN-20003: target database incarnation not found in recovery catalog Oracle support is recommending that I used SET DBID to duplicate production again. I am worried that my production backups may be useless, or worse - that when I duplicate the database I'll trash my production db. Anybody ever been here before? Thanks, Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: waits on sequential scans - how did i solve it
I was going to say the same thing until I saw what version of Oracle he was running. Its a Oracle8 and up feature so Rahul is SOL. -Original Message- Sent: Tuesday, July 24, 2001 7:36 AM To: Multiple recipients of list ORACLE-L Rahul, If I'd known that there were only 8 columns in the table, I'd have included the recommendation to investigate an Index-Organized Table. That is where the table IS the index and the index IS the table. This saves disc space and cuts I/O in half for DML on the table, since a separate index is not maintained. Check out the docs on IOTs. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Tuesday, July 24, 2001 8:53 AM To: Multiple recipients of list ORACLE-L list, based on the recommendation of posters (Jack) , i re-created the index with all the columns of a table ! (all 8 of them) analyzed the table/index and now all the queries are satisfied off an indexed range scan.. i also put the indexes on raw devices. regards -- From: Jack C. Applewhite[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, July 17, 2001 8:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: how to improve sequential scans ? Rahul, Could this table be partitioned and the partitions spread across multiple disks? Could the index be partitioned as well? The concept here is, of course, divide and conquer. Could a column or two (or three) be added to the index to satisfy the query without having to hit the table? How frequently are these literal queries being issued? Are they shredding your shared pool and chewing up CPU by making Oracle do extra work in shared pool memory management? Are there aggregation (vs aggravation g) functions or order bys in the queries that might be causing sorts to disk? If aggregation, could you use materialized views to satisfy the queries? ...just a few ideas. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Tuesday, July 17, 2001 7:36 AM To: Multiple recipients of list ORACLE-L list (AIX, 7.3.2) 5 clients are shooting the same sql to read data from an 18 million rows table. each time the sql uses a different literal value in the where clause... no bind variables. I CANNOT TOUCH THE APPLICATION, and have been given the task to re-configure the DB to increase performance. i have moved the table and it;s associated index to separate disks. and iostat show that only that only those two disks are being read. the session wait show that all the times the sessions are waiting on db file sequential read the db file being sequentially read in the above sessiion is the TABLE from which all the sid's are reading the table is analyzed and the sql's issued use the index. how can i further tune this config. ? TIA Rahul PS: my next step is to put the files on raw disks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Modeling opinion? Help?
Chris, I do not see a description of the change the modelers have specified in your message, so I will assume the oneway.pdf file is your design and the twoway.pdf is theirs. Their model does have a much simpler layout (fewer table joins), but a much greater likelihood of data duplication and consequently error. I can easily see the same customer having multiple records therein with different rules on how their claim is handled. That may in the end run cause a nightmare for your client not to mention a lot of egg on the face. Of course you'll be gone then, so you won't have to live with it. This is one of those cases where I would document your concerns and the potential consequences thereof and submit that to damagement, also keep a copy for yourself in the 'Pearl Harbor File'. Then do as they ask. Yeah, I know it's dumb, but what are you as a consultant/contractor going to do? Dick Goulet Reply Separator Author: Grabowy; Chris [EMAIL PROTECTED] Date: 7/24/2001 7:51 AM I am currently on a project where I have pretty much completed the logical/physical models. Since the client has there own data modelers, they have reviewed the models and wanted specific changes. I have agreed with all there changes except for one. I have tried to explain why this change would not be prudent, but they have insisted. To ensure that there change is enforced they went to there management and have now placed there change into the project requirements. Thereby, forcing us, the contractor, to implement this change into the model. I have run this change by several different people and they agree that it should not be implemented. I am now looking for feedback from the list. If you are willing to provide feedback then please read on... This is a claims system. A mailed package was not delivered or is damaged, so the customer files a claim. Every claim consists of the mailer's name and address, and the addressee's name and address, plus some other information. Aside from the average consumer, a Business Mailer(BM) can also file a claim. The BM has a special agreement with the client and gets special treatment when filing claims, and therefore a Business Mailer profile is created. Originally, I was going to describe the two versions of the model, but decided to post PDF files of the model on the web. The ERDs are accessible by clicking on the links below. One way --- http://www.geocities.com/christophergrabowy/oneway.pdf Two way --- http://www.geocities.com/christophergrabowy/twoway.pdf Both models have a claim table, which contains all the miscellaneous claim information. Both models have an address table. Oneway.pdf separates the BM addresses out, because they are not related to a claim. Twoway.pdf puts all the addresses(claim addresses and BM profile addresses) into the address table, and also includes the customer name fields. Both models have a customer table. This is were the majority of the dispute revolves around. In oneway.pdf, the customer table contains the customer names(mailer and addressee) that were submitted with the claim, it's PK is the claim_id. The Business Mailer profile is not directly related to a specific claim, so it is put into it's own table(a BM profile table), it's PK is the BM agreement number. In twoway.pdf, the customer table contains the name of the customer that filed the claim, and the Business Mailer profiles. Since these types of data use different fields, then the top part of the customer table contains the customer name fields, and bottom part of the table contains the Business Mailer profile fields. And since either part of the table could be filled out, all the fields are null. Finally, since there is no natural PK for the combination of these two records types, a synthetic PK is generated. If anyone has any questions then please don't hesitate to ask. Again, any feedback would be greatly appreciated. MANY THANKS Chris May Oracle be with you...always -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Solaris 8 Question
You should try to query the archive destination select * from v$archive_dest see if it says ERROR And do alter system archive log stop followed by alter system archive log start This will fix the broken archive process. Richard Ji [EMAIL PROTECTED] 07/24/01 11:05AM This happened to me today: Solaris 5.8 we have a large data load exercise going on and the archive log directory filled - database stopped of course. but after I had moved all the archive logs to another location the system still hung - I tried manual switching of log file ,still hung. I had to stop and start instance - I was surprised. did I miss something ? sam - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 20, 2001 2:15 PM If it's / or /tmp, then yes, your machine could well become unusable until it gets some free space. If your archive log disk fills, Oracle will refuse transactions until there is free space. Read the man page for 'quota' to help you limit the possibility of this. And think about switching autoextend off. Cheers, g -Original Message- Sent: Thursday, July 19, 2001 4:10 PM To: Multiple recipients of list ORACLE-L Hi all, A friend of mine is having a problem so I thought I would ask all of you experts a quick question. On a Solaris 8 box running 8.1.7, if a partition fills up, will it crash the box? I know that on NT this is very possible depending on pagefile and what file is filling up the partition. But I don't know anything about Sun. Thanks alot:) Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Roberts INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: unrecoverable
Title: RE: unrecoverable Prasad, Select logging from dba_tables / user_tables John -Original Message- From: prasad maganti [mailto:[EMAIL PROTECTED]] Sent: 24 July 01 16:17 To: Multiple recipients of list ORACLE-L Subject: unrecoverable hi dba's how to find out whether a table is in unrecoverable state. (Hope it is changed to Logginig/Nologging.) prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
what do I tune?
Hi all: I am trying to tune some queries. I ran them all in one stream (in sequence) and then ran them in several (up to 64) parallel streams. I got a snapshot of the system for each run. I see some of the waits went up significantly when I switched from 2 parallel streams to 64: buffer busy wait, db file seq read, enqueue waits, latch free waits and many more. Now some of this increases may be OK, some may be not. My question is how do I decide which of these waits are a problem and should be looked into and which are normal and can be safely ignored. Are there any quantative rules that I could use? thank you for any insight Gene = __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Snapshot shows as INVALID in DBA_OBJECTs
Dave, There are several issues with MV's/snapshots not displaying info correctly in various DBA/ALL/USER views. So far all that I've found are annoying, but don't interfere with refreshes or any other operations, and are fixed in 9.0.1. This is probably due to the fact that they really are two different beasts behind the scenes although they're used synonymously and share much of the same code base. I have a tendency to think of snapshots for distributed operations (the queries involve a dblink) and MV's for data warehousing operations (everything goes against local tables). When a snapshot is being refreshed, as part of the set-up phase the refresh date is set to 1/1/1950 (in a sense, the beginning of time). This way if the refresh is unsuccessful, Oracle knows that a complete refresh needs to be done the next time. Since 8.x, the date shown under LAST_REFRESH in DBA_SNAPSHOTS has incorrectly shown 1/1/1950 (bug 557451, fixed in 8.1.7.2, 9i; note 1036859.6). Instead query DBA_SNAPSHOT_REFRESH_TIMES. HTH, -- Anita --- Dave Morgan [EMAIL PROTECTED] wrote: Thanks Anita, I filed a TAR, altered my catalog.sql, recompiled 360 invalid objects, and now: It shows up in DBA_OBJECTS as a MATERIALIZED VIEW, but the status is still INVALID, and the last refresh data is shown as 1950 I don't think this morning is 1950 but I've been wrong before :) Sigh .. And metaStink is basically down this morning so . I'm still confused :) Dave A. Bardeen wrote: Dave, As someone else pointed out, this is a known bug (1188948). The issue is not with the dd, but that the view for DBA_OBJECTS did not get updated to handle the new object type value for materialized views. If you check the view definition (should be in catalog.sql) you'll see a decode statement that determines the object type. It doesn't have an entry for type 42, the new type for materialized views/snapshots, so that's why they're listed as undefined. You can manually change the view definition, just keep in mind that you'll need to change it again after applying a patchset if the patchset replaces catalog.sql. It doesn't interfere with the way the snapshot/MV works, so it's considered annoying, but harmless. The script is fixed in 9i. HTH, -- Anita --- Dave Morgan [EMAIL PROTECTED] wrote: Hi All, The subject says it all, 8.1.7 on Solaris 2.8 The snapshot is accessable and correct. Anyone know a (supported) way to clean up the data dictionary? TIA Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Reproduce ORA-0600
Hello, What was the first parameter of ora-600 ? We should unserstand if your ora-600 are cause or consequence. if it's consequence( I guess it's in your case), ignore it. 24/7/01 06:10:53, Lord, David - CS [EMAIL PROTECTED] wrote: Try upgrading to 8.1.6, its great at throwing 600's ;-) -Original Message- Sent: 24 July 2001 15:31 To: Multiple recipients of list ORACLE-L I had a production database become corrupt after an ORA-07445 and an ORA-0600 occurred. The instance would not come back up and had to be recovered. I can reproduce and correct the ORA-07445 (bad block) but it doesn't create the ORA-0600 or corrupt the database. I have tried adding rows, deleting rows, reading by the index by requesting all columns in the index, updating all columns in the index. Nothing seems to work. Any ideas on how I can reproduce the error? Ron Smith [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: system switch off
Depends. Is your server an NT box or UNIX? Your sessions are dead (you cannot reconnect to them), but in an NT box there are no separate processes. On a UNIX box the processes associated with your sessions will remain. Our developers used to go home at the end of the day and just turn off their client boxes without logging out of Oracle. In a 24x7 UNIX environment, eventually these ghost processes will cause problems with semaphores (something about cannot fork). It was a long time ago (in a galaxy far away) but I'll bet someone here can tell you how to use PIDs and SPIDs to track down the offending processes and kill them. prasad maganti To: Multiple recipients of list ORACLE-L prasadm_g@ya[EMAIL PROTECTED] hoo.com cc: Sent by: Subject: system switch off root@fatcity. com 07/24/2001 11:16 AM Please respond to ORACLE-L hi dba's my pc was connected to a remote oracle server. i logged into sql*plus as scott/tiger. suddently the power has gone. can anybody tell me what happens to my sessions, will they still exist in the server, or killed by any process, or pmon cleans everything concern to session. thanx in adv. prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: what do I tune?
What do you want to achieve? The more parallel you run the more some of your waits will go up, but the elapsed time may drop a little or a lot. Also you need to balance it with the total load on your server. If it is a query that is run a lot when there are a lot of users on the system you could max out your server. If it is during a down time for batch, that may not be a problem. Also keep track of your explain plan as you bump up parallelism, it can change. -Original Message- From: Gene Gurevich [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Subject: what do I tune? Hi all: I am trying to tune some queries. I ran them all in one stream (in sequence) and then ran them in several (up to 64) parallel streams. I got a snapshot of the system for each run. I see some of the waits went up significantly when I switched from 2 parallel streams to 64: buffer busy wait, db file seq read, enqueue waits, latch free waits and many more. Now some of this increases may be OK, some may be not. My question is how do I decide which of these waits are a problem and should be looked into and which are normal and can be safely ignored. Are there any quantative rules that I could use? thank you for any insight Gene = __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
What privileges are required for Shareplex?
List, We are installing Shareplex. Could any of you tell what privileges are required for a shareplex user? The customer support person from QUEST says that shareplex user requires DBA privileges. Is it correct? Thanks Rao [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
books on data modelling
Hello All, I have been in the lookout for a good and comprehensive book on data modelling so that I can enhance my knowledge in this area. I am not finding anything related in online Oracle documentation. Please suggest me.. Thanks in Advance, Suren -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Reproduce ORA-0600
Here are the error messages: ORA-07445: exception encountered: core dump [11] [0] [0] [0] [] [] Mon Jul 2 08:03:19 2001 Thread 1 advanced to log sequence 304 Current log# 8 seq# 304 mem# 0: /u035/oradata/prod/redo08.log Mon Jul 2 13:55:26 2001 Thread 1 advanced to log sequence 305 Current log# 5 seq# 305 mem# 0: /u032/oradata/prod/redo05.log Mon Jul 2 14:02:27 2001 Errors in file /u002/app/oracle/admin/prod/udump/ora_11586.trc: ORA-07445: exception encountered: core dump [11] [0] [0] [0] [] [] Mon Jul 2 14:06:20 2001 Errors in file /u002/app/oracle/admin/prod/bdump/dbwr_21336.trc: ORA-00600: internal error code, arguments: [3374], [11206682], [825371952], [875376697], [11824], [], [], [] Mon Jul 2 14:06:22 2001 Errors in file /u002/app/oracle/admin/prod/bdump/dbwr_21336.trc: ORA-00600: internal error code, arguments: [3374], [2617431000], [960050989], [32], [0], [32], [], [] ORA-00600: internal error code, arguments: [3374], [11206682], [825371952], [875376697], [11824], [], [], [] Mon Jul 2 14:20:22 2001 -Original Message- Sent: Tuesday, July 24, 2001 11:11 AM To: Multiple recipients of list ORACLE-L Hello, What was the first parameter of ora-600 ? We should unserstand if your ora-600 are cause or consequence. if it's consequence( I guess it's in your case), ignore it. 24/7/01 06:10:53, Lord, David - CS [EMAIL PROTECTED] wrote: Try upgrading to 8.1.6, its great at throwing 600's ;-) -Original Message- Sent: 24 July 2001 15:31 To: Multiple recipients of list ORACLE-L I had a production database become corrupt after an ORA-07445 and an ORA-0600 occurred. The instance would not come back up and had to be recovered. I can reproduce and correct the ORA-07445 (bad block) but it doesn't create the ORA-0600 or corrupt the database. I have tried adding rows, deleting rows, reading by the index by requesting all columns in the index, updating all columns in the index. Nothing seems to work. Any ideas on how I can reproduce the error? Ron Smith [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: tnsnames.ora in clients
We use a shared tnsnames.ora from a NT server. -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 2:33 PM To: Multiple recipients of list ORACLE-L Subject: Re: tnsnames.ora in clients Does this method of sharing the tnsnames work for you? What operating system are you using? I use Novell and when I tried this method of sharing the tnsnames it wouls not work. We had to resolve to downloading the latest copy to the users when they logged in. ROR mª¿ªm [EMAIL PROTECTED] 07/23/01 11:41AM You can write a script and each time when a user logs into a domain it will check and copy the latest tnsnames.ora file. Or you can just place the tnsnames.ora file on the network drive and point everyone to it. [EMAIL PROTECTED] 07/23/01 10:55AM Hello All, Good morning! I would like to know how the 'tnsnames.ora' file on all client(windows) machines can be updated automatically whenever something changed on central 'tnsnames.ora' file. Is this the process still being used extensively or else advanced features like ONS. Your suggestions are highly appreciated. Thanks, Suren Consultant DBA Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: books on data modelling
Take a look at Data MOdeling Essentials by Simsion Coriolis -Original Message- Sent: Tuesday, July 24, 2001 11:57 AM To: Multiple recipients of list ORACLE-L Hello All, I have been in the lookout for a good and comprehensive book on data modelling so that I can enhance my knowledge in this area. I am not finding anything related in online Oracle documentation. Please suggest me.. Thanks in Advance, Suren -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bond Mike A Contr OC-ALC/TILC INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Modeling opinion? Help?
Keep in mind that they pay you to advise them and to do what they want done. They do not pay you to beat them over the head to do what is right. Document to cya This is one of those cases where I would document your concerns and the potential consequences thereof and submit that to damagement, also keep a copy for yourself in the 'Pearl Harbor File'. Then do as they ask. Yeah, I know it's dumb, but what are you as a consultant/contractor going to do? Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: what do I tune?
Gene: It all depends on a couple of factors: (1) what are the average wait times for each of the wait events, (2) which one(s) have the highest wait times. I would ignore any waits less than 1 centisecond for the most part. Buffer Busy Waits occur when a session is waiting for a buffer to become available. This is because a buffer is either being read into the buffer cache by another session (and the session is waiting for that read to complete) or the buffer is in the buffer cache, but in an incompatible mode(that is, some other session is changing the buffer). There are several courses of action here, depending on what type of block it is: -- If it is a data block, change the pctfree and pctused or, in the case of an index, check for right-hand indexing or increase initrans. The key is to reduce the number of rows/leaves per block to reduce contention. -- If it is a segment header, increase the number of freelists or use freelist groups. -- If it is a freelist block, increase the number of freelists. -- If it is an undo header block, add more rollback segments when in exclusive mode and consider setting transactions per rbs = 1. -- If it is an undo block, add more rollback segments when in exclusive mode or make the segments you have larger. DB file sequential read waits indicate that either (a) an index lookup is being performed or (b) a controlfile is being rebuilt or (c) datafile headers are being dumped or retrieved. In your case, it's probably the first one. Enqueue waits are waits for locks to be released. Taking care of those can be quite complex depending on the types of locks being held and those being requested and on what structures, etc. Latch free waits are waits for another to release a latch on a given resource. The presence of latch free waits of any significant magnitude may indicate a bottleneck within the SGA. It seems obvious that when you turned up the degree of parallelism on the query, the database as you currently have it set up could not handle the load. All these wait events would be consistent with that. Hope this helps. Jon Walthour --- Original Message --- From: Gene Gurevich [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/24/01 11:56:29 AM Hi all: I am trying to tune some queries. I ran them all in one stream (in sequence) and then ran them in several (up to 64) parallel streams. I got a snapshot of the system for each run. I see some of the waits went up significantly when I switched from 2 parallel streams to 64: buffer busy wait, db file seq read, enqueue waits, latch free waits and many more. Now some of this increases may be OK, some may be not. My question is how do I decide which of these waits are a problem and should be looked into and which are normal and can be safely ignored. Are there any quantative rules that I could use? thank you for any insight Gene = __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
dbw and lgwr issue
Hi The dbw0 process is taking much CPU since yesterday but I couldn't found any waits.Let me know what could be reason and how ca I came out from this issue.Some time lgwr is also taking some more time. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Modeling opinion? Help?
Yes, but ironically enough, its the consultant they ram to the ground after it goes south, no matter how well you document that you recommended against it. -Original Message- Sent: Tuesday, July 24, 2001 10:02 AM To: Multiple recipients of list ORACLE-L Keep in mind that they pay you to advise them and to do what they want done. They do not pay you to beat them over the head to do what is right. Document to cya This is one of those cases where I would document your concerns and the potential consequences thereof and submit that to damagement, also keep a copy for yourself in the 'Pearl Harbor File'. Then do as they ask. Yeah, I know it's dumb, but what are you as a consultant/contractor going to do? Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SHARED SQLNET.ora? RE: tnsnames.ora in clients
Has anyone been successful with putting the SQLNET.ora file in the same shared location as the TNSNAMES.ora file? I know it's supposed to be used solely on the user workstation in /network/admin (Net80/admin), but some people are trying to place it on the shared drive as well. We're actually implementing ONAMES, so we're replacing the SQLNET.ora file to specify ONAMES, and some Regions are thinking they only need to place this on the shared drive where TNS_ADMIN points to. I don't think this is supported or works in all situations. Any experiences or comments?? Ed -Original Message- Sent: Tuesday, July 24, 2001 1:02 PM To: Multiple recipients of list ORACLE-L We use a shared tnsnames.ora from a NT server. -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 2:33 PM To: Multiple recipients of list ORACLE-L Subject: Re: tnsnames.ora in clients Does this method of sharing the tnsnames work for you? What operating system are you using? I use Novell and when I tried this method of sharing the tnsnames it wouls not work. We had to resolve to downloading the latest copy to the users when they logged in. ROR mª¿ªm [EMAIL PROTECTED] 07/23/01 11:41AM You can write a script and each time when a user logs into a domain it will check and copy the latest tnsnames.ora file. Or you can just place the tnsnames.ora file on the network drive and point everyone to it. [EMAIL PROTECTED] 07/23/01 10:55AM Hello All, Good morning! I would like to know how the 'tnsnames.ora' file on all client(windows) machines can be updated automatically whenever something changed on central 'tnsnames.ora' file. Is this the process still being used extensively or else advanced features like ONS. Your suggestions are highly appreciated. Thanks, Suren Consultant DBA Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
Need SQL Example
Anyone got a good example of flipping a range of values into columner buckets. I have done this in the past but my solutions always seem so convoluted, it seems I have seen more elegant examples in the past. I want to use decode so it will run on older versions of Oracle. Pseudo Example: select sum(decode(if value between 0 and 64 then return 1 else 0)) count_of_this_bucket, sum(decode(if value between 65 and 128 then return 1 else 0)) count_of_this_bucket,... from table Thanks, Ethan -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Data Modeling opinion? Help?
Bruce, You are correct, but I've been on both sides of that equation. If the contractor does not keep a good file of their objections I the customer will beat them over the head when I have performance issues. One reason I don't want to be a consultant/contractor any more, your never right. Dick Goulet Reply Separator Author: Page; Bruce [EMAIL PROTECTED] Date: 7/24/2001 9:01 AM Keep in mind that they pay you to advise them and to do what they want done. They do not pay you to beat them over the head to do what is right. Document to cya This is one of those cases where I would document your concerns and the potential consequences thereof and submit that to damagement, also keep a copy for yourself in the 'Pearl Harbor File'. Then do as they ask. Yeah, I know it's dumb, but what are you as a consultant/contractor going to do? Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Modeling opinion? Help?
Exactly. Which is why I am trying to change this now. As for the previous comment, they do not pay me to beat them over the head, BUT they do pay me to do what is right. -Original Message- Sent: Tuesday, July 24, 2001 1:29 PM To: Multiple recipients of list ORACLE-L Yes, but ironically enough, its the consultant they ram to the ground after it goes south, no matter how well you document that you recommended against it. -Original Message- Sent: Tuesday, July 24, 2001 10:02 AM To: Multiple recipients of list ORACLE-L Keep in mind that they pay you to advise them and to do what they want done. They do not pay you to beat them over the head to do what is right. Document to cya This is one of those cases where I would document your concerns and the potential consequences thereof and submit that to damagement, also keep a copy for yourself in the 'Pearl Harbor File'. Then do as they ask. Yeah, I know it's dumb, but what are you as a consultant/contractor going to do? Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: what do I tune?
Hi, itrprof SQL Analyzer can do what you asked. itrprof: http://www.unal-bilisim.com/products/itrprof/itrprof.html 24/7/01 06:56:29, Gene Gurevich [EMAIL PROTECTED] wrote: Hi all: I am trying to tune some queries. I ran them all in one stream (in sequence) and then ran them in several (up to 64) parallel streams. I got a snapshot of the system for each run. I see some of the waits went up significantly when I switched from 2 parallel streams to 64: buffer busy wait, db file seq read, enqueue waits, latch free waits and many more. Now some of this increases may be OK, some may be not. My question is how do I decide which of these waits are a problem and should be looked into and which are normal and can be safely ignored. Are there any quantative rules that I could use? thank you for any insight Gene = __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need SQL Example
I think you use sign eg the above will work for integers at least and just requires the the lower and upper values of the ranges plugged in. I'm sure it could be adapted for real numbers but hopefully this will do select sum(decode(sign(:value - (0-1)),1,decode(sign(:value - (64+1)),-1,1,0), 0)), sum(decode(sign(:value - (65-1)),1,decode(sign(:value - (128+1)),-1,1,0), 0)), sum(decode(sign(:value - (129-1)),1,decode(sign(:value - (192+1)),-1,1,0), 0)) from dual Cheers Iain Nicoll -Original Message- Sent: 24 July 2001 18:29 To: Multiple recipients of list ORACLE-L Anyone got a good example of flipping a range of values into columner buckets. I have done this in the past but my solutions always seem so convoluted, it seems I have seen more elegant examples in the past. I want to use decode so it will run on older versions of Oracle. Pseudo Example: select sum(decode(if value between 0 and 64 then return 1 else 0)) count_of_this_bucket, sum(decode(if value between 65 and 128 then return 1 else 0)) count_of_this_bucket,... from table Thanks, Ethan -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nicoll, Iain (Calanais) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Data Modeling opinion? Help?
Chris, True, except when I as the customer change the specs. Then what is right is what I say. Or as a Program Management instructor told the class As it is written, so let it be done. Dick Goulet Reply Separator Author: Grabowy; Chris [EMAIL PROTECTED] Date: 7/24/2001 9:48 AM Exactly. Which is why I am trying to change this now. As for the previous comment, they do not pay me to beat them over the head, BUT they do pay me to do what is right. -Original Message- Sent: Tuesday, July 24, 2001 1:29 PM To: Multiple recipients of list ORACLE-L Yes, but ironically enough, its the consultant they ram to the ground after it goes south, no matter how well you document that you recommended against it. -Original Message- Sent: Tuesday, July 24, 2001 10:02 AM To: Multiple recipients of list ORACLE-L Keep in mind that they pay you to advise them and to do what they want done. They do not pay you to beat them over the head to do what is right. Document to cya This is one of those cases where I would document your concerns and the potential consequences thereof and submit that to damagement, also keep a copy for yourself in the 'Pearl Harbor File'. Then do as they ask. Yeah, I know it's dumb, but what are you as a consultant/contractor going to do? Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Data Modeling opinion? Help?
Hmmm...when the spec is changed because of some business requirement then that's fine. But when it's changed because your own designers cant argue the design on technical merit then what? A spec should quote all the business rules, and some high level details about the overall architecture of the system. But the spec shouldn't tell you that you will have these two specific tables in the database, with these specific fields, etc. In the end the contractor is ultimately responsible for the validity and performance of the system that they deliver. The contractor will never be able to point back to some disclaimer and say We told you so. It will be next to impossible to point to the disclaimer when you start slipping the schedule or when the performance is not quite there. -Original Message- Sent: Tuesday, July 24, 2001 1:09 PM To: Grabowy; Chris; Multiple recipients of list ORACLE-L Chris, True, except when I as the customer change the specs. Then what is right is what I say. Or as a Program Management instructor told the class As it is written, so let it be done. Dick Goulet Reply Separator Author: Grabowy; Chris [EMAIL PROTECTED] Date: 7/24/2001 9:48 AM Exactly. Which is why I am trying to change this now. As for the previous comment, they do not pay me to beat them over the head, BUT they do pay me to do what is right. -Original Message- Sent: Tuesday, July 24, 2001 1:29 PM To: Multiple recipients of list ORACLE-L Yes, but ironically enough, its the consultant they ram to the ground after it goes south, no matter how well you document that you recommended against it. -Original Message- Sent: Tuesday, July 24, 2001 10:02 AM To: Multiple recipients of list ORACLE-L Keep in mind that they pay you to advise them and to do what they want done. They do not pay you to beat them over the head to do what is right. Document to cya This is one of those cases where I would document your concerns and the potential consequences thereof and submit that to damagement, also keep a copy for yourself in the 'Pearl Harbor File'. Then do as they ask. Yeah, I know it's dumb, but what are you as a consultant/contractor going to do? Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Modeling opinion? Help?
Over the past 17 years, I have been on both sides of this fence. Right is defined by the gods that be. I know, because I have fought the fights. I have been the person having to live with the system left by consultants that designed the system right and they were backed by my manager against my position. Then I had to explain to the manager later why we could not do certain things. I have also won the fight and lived with the consequences. I have also been the consultant that came in and said this is stupid and it needs to be done this way. I have won and lost those fights too. They pay consultants to make recommendations and then do what they tell you to do. You have the choice to stay and do it or to leave. As for the previous comment, they do not pay me to beat them over the head, BUT they do pay me to do what is right. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: system switch off
Just add something, I am using following script to track SPID of such processes and kill them using kill -9 SPID. Sometime it releases oracle session immediately or take a while for rollback. Any how to make sure at sql level , same may be killed at sql level using relevant sid, serial set linesize 120 select substr(vs.username,1,10)username, vs.osuser, vs.sid, vs.serial#, vs.LOGON_TIME, substr(vs.machine,1,15)machine, vs.process, vp.spid, vs.last_call_et from v$session vs, v$process vp where vs.paddr = vp.addr and vs.username is not null and vs.status = 'ACTIVE'; May help someone Regards MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 24 Jul 2001 08:30:59 -0800 Depends. Is your server an NT box or UNIX? Your sessions are dead (you cannot reconnect to them), but in an NT box there are no separate processes. On a UNIX box the processes associated with your sessions will remain. Our developers used to go home at the end of the day and just turn off their client boxes without logging out of Oracle. In a 24x7 UNIX environment, eventually these ghost processes will cause problems with semaphores (something about cannot fork). It was a long time ago (in a galaxy far away) but I'll bet someone here can tell you how to use PIDs and SPIDs to track down the offending processes and kill them. prasad maganti To: Multiple recipients of list ORACLE-L prasadm_g@ya[EMAIL PROTECTED] hoo.com cc: Sent by: Subject: system switch off root@fatcity. com 07/24/2001 11:16 AM Please respond to ORACLE-L hi dba's my pc was connected to a remote oracle server. i logged into sql*plus as scott/tiger. suddently the power has gone. can anybody tell me what happens to my sessions, will they still exist in the server, or killed by any process, or pmon cleans everything concern to session. thanx in adv. prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
how to run explain plan on SP???
Hi, Can anyone show me how to run explain plan on a whole stored procedure? 815 on Sun 5.6. Thanks a lot. Leslie __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Modeling opinion? Help?
It goes with the territory. Yes, but ironically enough, its the consultant they ram to the ground after it goes south, no matter how well you document that you recommended against it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Modeling opinion? Help?
Chris: You have to remember that you are there as a consultant, as a value add to the client's business, not to argue with them. If they choose to do something different than what you recommend, that's their choice. I agree with what others have said: document, document, document. That way if things don't turn out as expected or when project deadlines start to slip because of scope creep, you can go back and point to what decisions and activities brought about these changes. And would you want a project deadline to be missed because you spent a week arguing a point with them ro because you did it the way they asked and it didn't work as they thought it would. I always try to remember as a consultant that, when it gets right down to it, I'm not part of their team--that's not my role. I'm a hired gun in the case of project work or an augmentation to their team. In either case, I am there to add something, not to detract from it. Just my two cents. Jon Walthour --- Original Message --- From: Grabowy, Chris [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/24/01 2:40:24 PM Hmmm...when the spec is changed because of some business requirement then that's fine. But when it's changed because your own designers cant argue the design on technical merit then what? A spec should quote all the business rules, and some high level details about the overall architecture of the system. But the spec shouldn't tell you that you will have these two specific tables in the database, with these specific fields, etc. In the end the contractor is ultimately responsible for the validity and performance of the system that they deliver. The contractor will never be able to point back to some disclaimer and say We told you so. It will be next to impossible to point to the disclaimer when you start slipping the schedule or when the performance is not quite there. -Original Message- Sent: Tuesday, July 24, 2001 1:09 PM To: Grabowy; Chris; Multiple recipients of list ORACLE-L Chris, True, except when I as the customer change the specs. Then what is right is what I say. Or as a Program Management instructor told the class As it is written, so let it be done. Dick Goulet Reply Separator Author: Grabowy; Chris [EMAIL PROTECTED] Date: 7/24/2001 9:48 AM Exactly. Which is why I am trying to change this now. As for the previous comment, they do not pay me to beat them over the head, BUT they do pay me to do what is right. -Original Message- Sent: Tuesday, July 24, 2001 1:29 PM To: Multiple recipients of list ORACLE-L Yes, but ironically enough, its the consultant they ram to the ground after it goes south, no matter how well you document that you recommended against it. -Original Message- Sent: Tuesday, July 24, 2001 10:02 AM To: Multiple recipients of list ORACLE-L Keep in mind that they pay you to advise them and to do what they want done. They do not pay you to beat them over the head to do what is right. Document to cya This is one of those cases where I would document your concerns and the potential consequences thereof and submit that to damagement, also keep a copy for yourself in the 'Pearl Harbor File'. Then do as they ask. Yeah, I know it's dumb, but what are you as a consultant/contractor going to do? Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Oracle/AIX 64 bit
Guys/Dolls - Are you using 64bit oracle on AIX? Was it a reasonable install? Any gotchas? Notice anything about performance.? ANY comments at all most welcome. Thanks! - Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Update ALL colums without knowing their name??-correction
Hi, Thank you for your answer. Unfortunatelly I can't truncate, then insert into ... select ( I myself thought about it before )because the tables are always used ( there are always a few users connecting to database). Thank you Zsolt Csillag Hungary At 13:52 2001.07.23. -0800, you wrote: Are you just trying to totally refresh table1 from table 2? how about: 1. TRUNCATE table1; 2. INSERT INTO table1 SELECT * FROM table2; (assuming structures of the two tables are compatible) Or am I just totally missing the mark in what you are looking to do? Jon [EMAIL PROTECTED] -Original Message- From: Csillag Zsolt [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 5:33 PM To: Multiple recipients of list ORACLE-L Subject: Update ALL colums without knowing their name?? Hi, I need an universal update procedure in which I don' t know the colums name. How can I make an update like this: Update Table1 set Every_columns = ( Select * from Table2) I tried set Table1.* wiht no result. How can I work around this? Csillag Zsolt www.star-soft.hu
Re: Urgent: ORA-03113
You missed some of the parameter or environmental settings. --- Sadzakovic Slavica [EMAIL PROTECTED] wrote: Red Hat 6.2 Oracle 8.1.6.1 192MB of RAM While running dbassist, ORA-03113 EOF on communication channel appears (progress bar shows between 65% and 75%). What might be possible reason? Software installation went without problems. Please help -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sadzakovic Slavica INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: k johnson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sun cluster vs Veritas cluster
I have used both and somewhat prefer VCS. In both systems, we've had problems where the cluster was in an unknown state and any action to change the state was risky to all the services in the cluster. This is rare for both products. Our Sun support required for us to pay them to certify our stuff before they'd support the implementation. Don't know if you're subject to this too, but VCS has no such rule. The tests were interesting, but we could conduct the tests without their involvement. Command-line jocks may at first prefer Sun, but I think Veritas is a better bet since it's not as tied to the hardware vendor, and is more likely to be common across Unixes, if you're in a site where you've got more than one Unix vendor's stuff to support, like I am. We are in the process of migrating from Sun cluster to VCS, fyi. my 2¢ Steve -Original Message-From: KC [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 24, 2001 7:51 AMTo: Multiple recipients of list ORACLE-LSubject: Sun cluster vs Veritas cluster List, Just wondering if anyone on the list who had experience on both Sun clustering and Veritas clustering software share their experience on both products, strength and weakness or any comparison?? KC
OEM Data Gatherer question???
Hi, I installed both OEM 204 Tuning Pack and Diagnostic Pack, TP runs very fine. But when I tried to connect to DP's Performance Mananger, I got message VTM 0005 and Data Gatherer is not running. What is this Data Gatherer? and how to run it? Thanks a lot! Andrea __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 lazy connection!
Thank you friends, But we finally figured out. Actually the OUT parameter is procedure is useless as Shailesh pointed out , there is no variable to put the OUT value in auto-execute. So this is what we did. Kept the OUT parameter ( we could took it out but developer insisted to keep it as they might use that procedure in Pro*C) in the procedure and rewrote the submit job script like this. declare jobno number; begin dbms_job.submit(jobno,'declare errno number; begin l_load_weekly_aps.p_load_ocn(errno); end;',sysdate,'sysdate+1'); end; Now it submits and while auto-executing through dbms_job.run also finds the variable to put the OUT parameter valus, but we still can not see this value. But hey, it solves the problems job executes fine without any of those errors I was getting before. Thanks everybody for the input and replies. Sandesh -Original Message- Sent: Tuesday, July 24, 2001 6:50 AM To: '[EMAIL PROTECTED]' I may be missing something but do you need the : in front of errno. -Original Message- Sent: 23 July 2001 19:13 To: Multiple recipients of list ORACLE-L Dear List, I have a package which I want to execute using dba_jobs. Within that package I run procedure which has one OUT parameter ( errno) When I submit the job declare jobno number; errno number; begin dbms_job.submit(jobno,'l_load_weekly_aps.p_load_ocn(:errno);',sysda te,'sysdate'); end; It submits fine but when I try to run that job using exec dbms_job.run(52), it gives me following error. * ERROR at line 1: ORA-12011: execution of 1 jobs failed ORA-06512: at SYS.DBMS_IJOB, line 394 ORA-06512: at SYS.DBMS_JOB, line 267 ORA-06512: at line 1 ORA-12012: error on auto execute of job 52 ORA-01008: not all variables bound Anybody has any answers ? thanks for your help. Sandesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naik, Sandesh S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Naik, Sandesh S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Modeling opinion? Help?
Don't get me wrong. I understand that completely. I have spent my whole career as a consultant. There are good things and bad things. I have, in the past, refused to go back to one particular client, but then again so did the whole staff that was done there at one point in time. For the most part I deal with my management when there are issues, let them do what they want and then do what I need to do to get the job done, whether its the way they want it done or my way. I must say though, its the exception rather then the rule, that I actually have issues with the client. I work hard to have my clients trust me and I have always been successful (knock on wood). I truly believe that its all in how you treat them. I do disagree with a comment someone else made about how you are not part of their team. While I am here I am part of their team. I work within their framework and my goals are the same as their goals. The only difference is, I have a whole corporation behind me to help if needed. -Original Message- Sent: Tuesday, July 24, 2001 12:06 PM To: Multiple recipients of list ORACLE-L It goes with the territory. Yes, but ironically enough, its the consultant they ram to the ground after it goes south, no matter how well you document that you recommended against it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle on Hitachi 9900 series
Hi List, I am looking for some suggestions about tuning hitachi storage systems for Oracle databases. We are using Hitachi 9960 with Veritas volume manager and UFS file system. I am particularly looking for this information - What type of configuration are you using ie RAID1 / RAID5. What is the setting on maxcontig parameter at the fs level. As i was told, The stripe size and number of disks in RAID groups are fixed in Hitachi storage system and is not configurable. thanks. MJ. ___ Send a cool gift with your E-Card http://www.bluemountain.com/giftcenter/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anubha Jalsingh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
rollback and free list contension
Hi let me know if some one have script to monitor rollback segment contension and free list contension then can u please send it. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
