Re: ora-918
Title: RE: ora-918 Thank Jerry, but month represents field named ia_validity_month. The sql in my message is just to give you an idea what the problematic sql looks like. Yechiel AdarMehish - Original Message - From: Whittle Jerome Contr NCI To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 29, 2002 5:18 PM Subject: RE: ora-918 Yechiel, "MONTH" is a reserved word in PL SQL and you have a field name "month". Could that be the problem? Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Yechiel Adar [SMTP:[EMAIL PROTECTED]] Hello list I need help in solving ORA-918: Ambiguous field reference. All the fields are schema.tablename.fieldname. The SQL has 3 inline queries that are the same but with different months in the where clause. Simplified version: select acct . from tab1, tab2, where ... and acct in (select acct from tab1 where balance 7000 and month = 2) and acct in (select acct from tab1 where balance 7000 and month = 3) and acct in (select acct from tab1 where balance 7000 and month = 4) group by acct; Now the query runs OK with only one sub query. Oracle 8.1.6.3.4 on NT. I already replaced the three IN with 3 = select count() where month in (2,3,4) and it works, but I would like to know why the original didn't. Yechiel Adar Mehish
Urgent: Prodution database recovery
Env: 8.1.7.3 Compaq Alpha Tru64 5.1a An apparent hardware problem caused corrupt blocks ora-600 [12700] to be detected. Analyze table validate structure confirmed this error. We started a PITR to a time before the errors were detected. All datafiles were restored (file copy took ~7.5hrs [614Gb]), current control files redo logs (10 groups / 2 members). But when the alter database recover database until time 'xxx' is issued, a corrupt header is detected in one of the datafiles (ora1122/1251). Now this is a disk mirror split backup. We've used this process to create a reporting database copy for years and the reporting copy was build cleanly from the same source several hours after the backup copy. DBverify against the split backup copy and against the restored file (with the corrupt header) detect no errors but return diffent results for used/free/other blocks. Now, this first attempt at recovery opened about 1/3 of the datafiles. My thought was to restore these ~100 datafile again and retry the recovery. Right now I'm a little bleary-eyed so any suggestions would be welcome. Thanks, Mike Hand Polaroid Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
For real Gurus only
Hello Gurus I got this link through SAG-L. Have a try. www.quest-pipelines.com/newsletter-v3/Crossword_Puzzles/puzzle0502.html Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL Question
I'm sure you're already aware of this, but the substr/instr is not as complicated as it looks since instr takes 4 parms, the 4th of which makes cycling through fields 1=8 easy. hth connor --- Deshpande, Kirti [EMAIL PROTECTED] wrote: Stephane, Thanks. Nice idea :) I will pass on this idea to them... Hope it flies.. Looks like either a function or a view around the 'ugly' code is the only choice. - Kirti -Original Message- Sent: Wednesday, May 29, 2002 3:32 PM To: Multiple recipients of list ORACLE-L Snip Kirti, I had a vague remembrance of something which might have been helpful in dbms_utility but the closer you get to is a comma_to_table() procedure. Even without your reluctance to REPLACE(), you would be lucky if your data could bear this kind of transformation. Well, its a bit like sweeping dirt under the carpet, but I think that a function getfield(string in varchar2, pos in number, separator in char) return varchar2; full of substr and instr should make the upper level query more legible ... Regards, Stephane Faroult Oriole Software -- -- 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Urgent: Prodution database recovery
Don't know whether this is of any use, but could it be that you still have a hardware fault that is causing your restore to become corrupted? Regards David Lord -Original Message- From: Hand, Michael T [mailto:[EMAIL PROTECTED]] Sent: 30 May 2002 10:23 To: Multiple recipients of list ORACLE-L Subject: Urgent: Prodution database recovery Env: 8.1.7.3 Compaq Alpha Tru64 5.1a An apparent hardware problem caused corrupt blocks ora-600 [12700] to be detected. Analyze table validate structure confirmed this error. We started a PITR to a time before the errors were detected. All datafiles were restored (file copy took ~7.5hrs [614Gb]), current control files redo logs (10 groups / 2 members). But when the alter database recover database until time 'xxx' is issued, a corrupt header is detected in one of the datafiles (ora1122/1251). Now this is a disk mirror split backup. We've used this process to create a reporting database copy for years and the reporting copy was build cleanly from the same source several hours after the backup copy. DBverify against the split backup copy and against the restored file (with the corrupt header) detect no errors but return diffent results for used/free/other blocks. Now, this first attempt at recovery opened about 1/3 of the datafiles. My thought was to restore these ~100 datafile again and retry the recovery. Right now I'm a little bleary-eyed so any suggestions would be welcome. Thanks, Mike Hand Polaroid Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This message (including any attachments) is confidential and may be legally privileged. If you are not the intended recipient, you should not disclose, copy or use any part of it - please delete all copies immediately and notify the Hays Group Email Helpdesk at [EMAIL PROTECTED] Any information, statements or opinions contained in this message (including any attachments) are given by the author. They are not given on behalf of Hays unless subsequently confirmed by an individual other than the author who is duly authorised to represent Hays. A member of the Hays plc group of companies. Hays plc is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Question
THANK YOU IT'S TRUE, I WAS USING A 8.0 ORACLE DOCS REGARDS K.Benlatreche -Message d'origine- De : GL2Z/ INF DBA BENLATRECHE [mailto:[EMAIL PROTECTED]] Envoyé : mercredi 29 mai 2002 15:24 À : Multiple recipients of list ORACLE-L Objet : RMAN Question Hi ALL, I want to use RMAN (Oracle 8.1.7 under NT). Following Oracle docs (Server Backup and Recovery Guide), at one step (2) there is a reference to a script '@?/rdbms/admin/catrman', to create the recovery catalog, but I didn't find it ! Is there any missing on my Oracle installation ? Regards Kamel Benlatreche -- 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). -- 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).
Undocumented Parameters
Someone posted a bit of SQL to list out the undocumented parameters and guess what ... I deleted it. Could someone repost please ?? TIA Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
RE: Undocumented Parameters
set echo on spool parm1 select a.ksppinm Parameter, a.ksppdesc Description, b.ksppstvl Session Value, c.ksppstvl Instance Value from x$ksppi a, x$ksppcv b, x$ksppsv c where a.indx = b.indx and a.indx = c.indx and a.ksppinm like '/_%' escape '/' / spool off -Original Message- lerobe Sent: 30 May 2002 11:43 To: Multiple recipients of list ORACLE-L Someone posted a bit of SQL to list out the undocumented parameters and guess what ... I deleted it. Could someone repost please ?? TIA Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Advice needed please
Oracle 8.0.5 Tru64 4.0f One of our developers here is writing a utility to provide fast unloads of tables (to replace fastunloader as it happens) His problem is as follows. Start from the bottom and work your way up. I would be really grateful if anyone can offer up some alternatives for us. Regards Lee -Original Message- From: Dudley Dave - ddudle Sent: 29 May 2002 16:04 To: Robertson Lee - lerobe Subject:RE: Do you still have that SQL Expert? No, you miss the point. I'm explicitly NOT using PQ (or at least not explicitly using it). Using a parallel hint on huge table unloads - with the single-threaded version of the code (i.e. pipdynsql.v2.0.0) didn't seem to make much difference at all. I didn't do the tests directly though, poeple on the account did. So it may be that the tables already had a degree of parallelism built in, in which case I'd guess the hint would be redundant. What I mean is that even if you use PQ for the server to extract the data in parallel you still have the bottle neck of a single client to send it all back to. That's what I was trying to get around. Assuming that we're not generally using the full network bandwidth, I'd assume that multiple clients ought to be able to dump out separate sections of a table at the same time, at roughly the same speed at a single client would unload a single table - i.e double the throughput. But I can't find anything on the web to tell me the best / most efficient way to actually do this. (By the way, I've tried the NO_PARALLEL hint too, to stop the server setting off too many conflicting slaves on its side. Again no better as far as I could tell.) N.B. Not sure if you'd suggest it, but before you do: most of the tables we'd really want to use this for are massive, and so are already partitioned. So where I say table I mean either that or a partition thereof. Besides, need a generic solution that doesn't rely on having to partition your table to unload it quickly. By the way, I'm specifically testing speed of my original code (e.g. pipdynsql.v2.0.0 user/pass select * from table) against the new multithreaded development code - i.e. regardless of the machine load at the time, I want to see if multiple simultaneous unloads can be quicker than a single unload client (at the expense of using more machine / Oracle resource obviously). Is this making sense? Dave -Original Message- From: Robertson Lee - lerobe Sent: 29 May 2002 15:14 To: Dudley Dave - ddudle Subject:RE: Do you still have that SQL Expert? How are you using PQ, is it just a hint ??. Which tables are you testing against. -Original Message- From: Dudley Dave - ddudle Sent: 29 May 2002 14:27 To: Robertson Lee - lerobe Subject:RE: Do you still have that SQL Expert? OK Clever-Trousers, As you're so hot on table/index disk striping... I've written the program pipdynsql, which as you may have heard (this lunchtime if not before), people want to use to replace FastUnloader. I've been playing about with a new multithreaded version to try to download a table in sections to multiple client threads which then write back out to a single file (either ordered, or for max speed in random/undefined order). Can you think of any quick ways to do this, or tricks to try? I've tried ranges of rowids (as I'm told that's hold parrallel query works) but the ROWID (tab) hint does not seem to go through the table in rowid order. And it's a massive overhead to order by rowid to work out non-overlapping ranges. And even if you do, you have to say WHERE rowid = xxx AND rowid = xxx (as I say, can't force it to go in ROWID sort order) so this tends to be slower than nect opt... tried assuming there's a unique index and giving start points to each slave thread, which then selects a set number of rows. This is prety quick, but even this seems slower than a simple SELECT * FROM table (for the same number of records). tried loading temp rowid tables with sets of rowids and each slave does a full table scan of its rowid set table, with where clause connection to the data table. Can't find anything better than my original method which selects a unique key from an index with a master thread, for every x'th rownum. Then hands these out to the slave threads to select * from table where unique key = given key for specified number of records. e.g. master pulls out every 100,000th key with a modulus and each slave dumps out 100,000 rows at a time, starting at the key its given. The above uses a temp
Bind Variable values
Hi All, I want to get the individual sql_trace from my applicaion as they use loads of bind variables, how to get those values so that I can run explain plan and see them individually? for examploe like event 10046? Thanks for your help. Ravi. __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Undocumented Parameters
Got this one from somebody, don't remember who, though... select rpad (a.indx ,10) "number" ,rpad (b.KSPPINM ,50) "name" , rpad (a.KSPPSTVL,50) "value" , rpad (a.KSPPSTDF,10) "default" from x$KSPPCV a , X$KSPPI b where a.indx = b.indx; HTH, Mandar. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Robertson Lee - lerobeSent: Thursday, May 30, 2002 4:13 PMTo: Multiple recipients of list ORACLE-LSubject: Undocumented Parameters Someone posted a bit of SQL to list out the undocumented parameters and guess what ... I deleted it. Could someone repost please ?? TIA Lee The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.
RE: Undocumented Parameters
Someone posted a bit of SQL to list out the undocumented parameters and guess what ... I deleted it. Could someone repost please ?? TIA Lee You know this Chinese proverb, about giving a man a fish and feeding him once vs teaching him how to fish, and feeding him for all his life? The place where you should angle is V$FIXED_VIEW_DEFINITION, it will tell you how GV$PARAMETERS is built, which is the X$ table it accesses - and how it filters undocumented parameters out. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Wait time for SQL*Net message
The following statistics is for a server-side application ( pro*c ). The connection is established between proc*c to server as LOCAl=yes and PROTOCOL=BEQ(sqlplus usr/pass) i.e bypassing the tnsnames.ora and listener.ora EventWait(cs) %wait --- SQL*Net message from client 463790 61.85186173 CPU used by this session 229327 30.5834578 SQL*Net more data to client 32388 4.319321455 db file sequential read 21698 2.893683986 log file sync1788 0.23845087 SQL*Net message to client5300.070681745 log file switch completion 1880.025072015 Can anyone tell me about how to reduce the wait time for SQL*Net message TIA Bhulu __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: S B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Undocumented Parameters
Thanks to everyone. Got it now. Regards Lee -Original Message- Sent: 30 May 2002 13:28 To: Multiple recipients of list ORACLE-L Someone posted a bit of SQL to list out the undocumented parameters and guess what ... I deleted it. Could someone repost please ?? TIA Lee You know this Chinese proverb, about giving a man a fish and feeding him once vs teaching him how to fish, and feeding him for all his life? The place where you should angle is V$FIXED_VIEW_DEFINITION, it will tell you how GV$PARAMETERS is built, which is the X$ table it accesses - and how it filters undocumented parameters out. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Senior DBA position - Dublin, Ireland
Roy Keane is free at the moment. -Original Message- Sent: Tuesday, May 28, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Before any public outcry I checked in with, and got permission, from list moderator to make this posting!!! Acknowledging we're geographically remote for most members of this list. (but maybe some other Irish based folk are here too!) My company, location North County Dublin, Ireland, has a vacancy for a full time permanent position for a Senior DBA. If anyone is interested check out Recruitment section of www.organon.ie No applications to me please, use directions from web site! - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Solomon, Saul M. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Senior DBA position - Dublin, Ireland
Rachel, if his Mother is Irish, all he needs to do is ask for the passport - once he has it - you can apply for one as long as you've been married for over three years i think , again try the government sit http://www.irlgov.ie -it'll give you all you need to know Brian. Brian Mc Quillan Database Development Manager Gelco Information Network 10700 Prairie Lakes Drive Eden Prairie, MN 55344 Voice : (952) 947 1598 Fax: (952) 995 8581 e-mail : [EMAIL PROTECTED] www.gelcotrade.com Rachel Carmichael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wisernet100@y cc: ahoo.comSubject: Re: Senior DBA position - Dublin, Ireland Sent by: [EMAIL PROTECTED] om 05/29/2002 22:23 Please respond to ORACLE-L does it help any that I married someone who was half Irish? (his mom is/was first generation American and pure Irish ancestry) --- Tim Gorman [EMAIL PROTECTED] wrote: I've been told that if you can produce an ancestor's Irish birth certificate you can get an Irish passport? Could be a myth, but gentleman seemed quite reliable. This passport would then be an entree to work in the EU, if I'm not mistaken, perhaps? I'm going to check, certainly... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 10:18 AM Rachel, The quarantine laws are the same as the UK - put your pet in quarantine for 6 months to see if it has rabies - a bit cruel these days when you figure that they can probably tell you within a week or so if your pet is ill. If you've never thought about Dublin - you should - I worked there as a DBA for 6 months back in '98 (how I ended up in Minnesota is a long story) and have often thought about going back there. I liked it a lot it's a fun city, lots to do and reasonably good night life. unless, like me you're Irish (or have a European passport of some kind ) you'd need a work permit. Brian Mc Quillan Database Development Manager Gelco Information Network 10700 Prairie Lakes Drive Eden Prairie, MN 55344 Voice : (952) 947 1598 Fax: (952) 995 8581 e-mail : [EMAIL PROTECTED] www.gelcotrade.com Rachel Carmichael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wisernet100@y cc: ahoo.comSubject: Re: Senior DBA position - Dublin, Ireland Sent by: [EMAIL PROTECTED] om 05/28/2002 10:28 Please respond to ORACLE-L oh so tempting but I know England's restrictions on bringing in pets, what are Ireland's? --- O'Neill, Sean [EMAIL PROTECTED] wrote: Before any public outcry I checked in with, and got permission, from list moderator to make this posting!!! Acknowledging we're geographically remote for most members of this list. (but maybe some other Irish based folk are here too!) My company, location North County Dublin, Ireland, has a vacancy for a full time permanent position for a Senior DBA. If anyone is interested check out Recruitment section of www.organon.ie No applications to me please, use directions from web site! - Seán O' Neill Organon (Ireland) Ltd.
Re: So, What is a 'Production DBA'?
Rachel, I agree with your short list of the areas of responsibilities but I would change the word application to development. An application DBA, from the people I have talked to, is quite busy performing the upgrades and patches that accompany the Oracle Applications. The applications database generally has many, many tables, triggers and constraints and is constantly the target for upgrades and patches from Oracle. It is a time consuming task as the majority of the different applications (financial, HR, Purchase Order, etc) have hooks into each different package and are so intertwined that any small fix in one involves patches for the others. There are only a few user defined tables as each package has their own named tables that are partially shared between packages. There is very little if any work you can do on the application code because it is so intertwined and customized when it is installed. Any upgrades require that the customization be reworked to make it fit into the new version of the application package. It takes a longer time to install than a standard database, on the magnitude of days, and requires a dedicated and investigative mind set to maintain. To the list you created I would add: Help desk call recipient, network support, client support, software and hardware evaluation, whipping post, IT team member (possibly team leader), self driven, office coffee maker, consumer of various liquids. Ron ROR mª¿ªm [EMAIL PROTECTED] 05/29/02 04:50PM that's not a bad definition :) seriously, everyone will have their own definition, mine is: production dba -- responsible for all databases that are considered production. this includes but is not limited to: backups recovery testing contingency testing production performance tuning (should mostly be database tuning as SQL really should be tuned at the development stage, with information passed back from the production DBA) documentation of all procedures space management on production systems, including capacity planning and projection of growth change management monitoring external data loads into production database health checks on production database application dba -- responsible for all databases in which developers have access. responsibilities: SQL tuning (not SQL coding!) database design, in conjunction with the developers any and all changes to the application schema working with the production DBA to ensure production performance (see SQL tuning!) backups (these might be weekly offline backups, as development is usually less critical but then again maybe not) as deadlines creep closer, the weekends off may not be this is just the short list I've usually been both the production and application dba where I've worked. Rachel --- Peter Barnett [EMAIL PROTECTED] wrote: We are having this debate. What is a 'Production DBA'? Right now all of the DBAs do some of everything. In an effort to focus more DBA time on infrastructure, damagement is floating the idea of Production and Applications DBAs. The DBA group has loosely translated this into the group that is always on-call and the group that gets their weekends off. I would appreciate some input from those of you who are Production DBAs. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mail ing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official
Re: Wait time for SQL*Net message
Make your PRO*C program faster. The wait-event SQL*Net message from client on the server-side is indicating that 61% of time is spent waiting for the client-side to say something, anything... Seeing the SQL*Net more data to client wait-event indicates that you're probably using array-fetching already, no? Spend some time with a profiler utility (i.e. standard UNIX prof utility?) to understand where your client-side C program is spending all that time... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 5:58 AM The following statistics is for a server-side application ( pro*c ). The connection is established between proc*c to server as LOCAl=yes and PROTOCOL=BEQ(sqlplus usr/pass) i.e bypassing the tnsnames.ora and listener.ora EventWait(cs) %wait --- SQL*Net message from client 463790 61.85186173 CPU used by this session 229327 30.5834578 SQL*Net more data to client 32388 4.319321455 db file sequential read 21698 2.893683986 log file sync1788 0.23845087 SQL*Net message to client530 0.070681745 log file switch completion 188 0.025072015 Can anyone tell me about how to reduce the wait time for SQL*Net message TIA Bhulu __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: S B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Wait time for SQL*Net message
10 Gigabit Ethernet ;) On Thu, May 30, 2002 at 03:58:31AM -0800, S B wrote: The following statistics is for a server-side application ( pro*c ). The connection is established between proc*c to server as LOCAl=yes and PROTOCOL=BEQ(sqlplus usr/pass) i.e bypassing the tnsnames.ora and listener.ora EventWait(cs) %wait --- SQL*Net message from client 463790 61.85186173 CPU used by this session 229327 30.5834578 SQL*Net more data to client 323884.319321455 db file sequential read 216982.893683986 log file sync1788 0.23845087 SQL*Net message to client530 0.070681745 log file switch completion 188 0.025072015 Can anyone tell me about how to reduce the wait time for SQL*Net message TIA Bhulu __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: S B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === 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: Undocumented Parameters
Here is a script I got from the honorable Mark Leith. Run this as SYS. set echo on spool parm1 select a.ksppinm Parameter, a.ksppdesc Description, b.ksppstvl Session Value, c.ksppstvl Instance Value from x$ksppi a, x$ksppcv b, x$ksppsv c where a.indx = b.indx and a.indx = c.indx and a.ksppinm like '/_%' escape '/' / spool off Dave -Original Message- Sent: Thursday, May 30, 2002 7:28 AM To: Multiple recipients of list ORACLE-L Someone posted a bit of SQL to list out the undocumented parameters and guess what ... I deleted it. Could someone repost please ?? TIA Lee You know this Chinese proverb, about giving a man a fish and feeding him once vs teaching him how to fish, and feeding him for all his life? The place where you should angle is V$FIXED_VIEW_DEFINITION, it will tell you how GV$PARAMETERS is built, which is the X$ table it accesses - and how it filters undocumented parameters out. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Wait time for SQL*Net message
Hi Type more and a lot faster and hit more enters while sending querries to the database. :-) I would not worry about SQL*Net message from client, it simply means that your client has received the data from the last request and now the server is waiting for the next. If you have a sql*plus session open it useually just sits there doing nothing (generating SQL*Net message from client events) There are some exceptions as somebody on the list recently pointed out (forgot who but would guess mr.Wilton) Jack S B bhulubhuli@yahooTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .comcc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Wait time for SQL*Net message [EMAIL PROTECTED] 30-05-2002 13:58 Please respond to ORACLE-L The following statistics is for a server-side application ( pro*c ). The connection is established between proc*c to server as LOCAl=yes and PROTOCOL=BEQ(sqlplus usr/pass) i.e bypassing the tnsnames.ora and listener.ora EventWait(cs) %wait --- SQL*Net message from client 463790 61.85186173 CPU used by this session 229327 30.5834578 SQL*Net more data to client 32388 4.319321455 db file sequential read 21698 2.893683986 log file sync17880.23845087 SQL*Net message to client530 0.070681745 log file switch completion 188 0.025072015 Can anyone tell me about how to reduce the wait time for SQL*Net message TIA Bhulu __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: S B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
RE: So, What is a 'Production DBA'?
Now see... as one new to the world of Apps DBA, I looked at her list, and realized that it was the other kind of applications... not Oracle Applications although from my experience network support, client support, whipping post, IT team member (possibly team leader), self driven, office coffee maker (mostly because you WANT coffee, and are there before and/or after everyone else), consumer of various liquids... apply across the board. I also think... Ron... that being an apps dba requires not only a dedicated and investigative mind set... but a warped mindset... one in need of serious analysis... is required of apps dba. There is no other animal QUITE like Oracle Applications... it kind of reminds me of the dragon from Homer... the one that grew extra heads when you cut one off... but this one seems to know when you are thinking of cutting off a head, and it grows 10 more just to SHOW you who is boss, and teach you for thinking about doing anything to it! ajw -Original Message- Sent: Thursday, May 30, 2002 7:48 AM To: Multiple recipients of list ORACLE-L Rachel, I agree with your short list of the areas of responsibilities but I would change the word application to development. An application DBA, from the people I have talked to, is quite busy performing the upgrades and patches that accompany the Oracle Applications. The applications database generally has many, many tables, triggers and constraints and is constantly the target for upgrades and patches from Oracle. It is a time consuming task as the majority of the different applications (financial, HR, Purchase Order, etc) have hooks into each different package and are so intertwined that any small fix in one involves patches for the others. There are only a few user defined tables as each package has their own named tables that are partially shared between packages. There is very little if any work you can do on the application code because it is so intertwined and customized when it is installed. Any upgrades require that the customization be reworked to make it fit into the new version of the application package. It takes a longer time to install than a standard database, on the magnitude of days, and requires a dedicated and investigative mind set to maintain. To the list you created I would add: Help desk call recipient, network support, client support, software and hardware evaluation, whipping post, IT team member (possibly team leader), self driven, office coffee maker, consumer of various liquids. Ron ROR mª¿ªm [EMAIL PROTECTED] 05/29/02 04:50PM that's not a bad definition :) seriously, everyone will have their own definition, mine is: production dba -- responsible for all databases that are considered production. this includes but is not limited to: backups recovery testing contingency testing production performance tuning (should mostly be database tuning as SQL really should be tuned at the development stage, with information passed back from the production DBA) documentation of all procedures space management on production systems, including capacity planning and projection of growth change management monitoring external data loads into production database health checks on production database application dba -- responsible for all databases in which developers have access. responsibilities: SQL tuning (not SQL coding!) database design, in conjunction with the developers any and all changes to the application schema working with the production DBA to ensure production performance (see SQL tuning!) backups (these might be weekly offline backups, as development is usually less critical but then again maybe not) as deadlines creep closer, the weekends off may not be this is just the short list I've usually been both the production and application dba where I've worked. Rachel --- Peter Barnett [EMAIL PROTECTED] wrote: We are having this debate. What is a 'Production DBA'? Right now all of the DBAs do some of everything. In an effort to focus more DBA time on infrastructure, damagement is floating the idea of Production and Applications DBAs. The DBA group has loosely translated this into the group that is always on-call and the group that gets their weekends off. I would appreciate some input from those of you who are Production DBAs. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mail ing list, send an E-Mail message to: [EMAIL
Re: Bind Variable values
Hi If you just want to see the explain plan of a querry with bind variables you don't need the values. just type explain plan for statement and you can read the explain from the plan table(should have been created beforehand) HTH jack Nalla Ravi vvnrk2001@yahoo.To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] co.uk cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Bind Variable values [EMAIL PROTECTED] 30-05-2002 13:53 Please respond to ORACLE-L Hi All, I want to get the individual sql_trace from my applicaion as they use loads of bind variables, how to get those values so that I can run explain plan and see them individually? for examploe like event 10046? Thanks for your help. Ravi. __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the
tkprof analysis
Hi, Can any one point me or kindly send me the analysis of TKProf outout please. Thanks you so much for your help. Ravi. __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
updated rows count
Hi All! My client run big update 20,000 statements. I need to know how many rows was updated (it's could be any number). I thinking about triggers , but this table can be updated not only with this big update. Other users can update rows too. I need to know updated rows number just for this big update. Thanks. update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty=850, atcapun=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 change a foreign key back to a primary key
Trang, Could you be a little bit more specific about what you are trying to do? Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Meomeo Nguyen To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 29, 2002 7:05 PM Subject: how to change a foreign key back to a primary key Hi, I need to change aforeign key back to a primary key in a table. How do I do that. Please help. Thanks in advance. Trang Do You Yahoo!?Yahoo! - Official partner of 2002 FIFA World Cup
Re: how can listener list on two ports for the same db?
Hi Helmut , I will try to clarify using an example. Tnsnames.ora ghi100 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = your IP address of the server where database resides ) (Port = 1526) ) ) (CONNECT_DATA = (SID = ghi100) ) ) ghi101 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host =your IP address of the server where database resides ) (Port = 1521) ) ) (CONNECT_DATA = (SID = ghi100) ) ) In this example i have 2 connection strings (ghi100,ghi101) connecting through 2 different ports (1521,1526) to the same database . Also ensure that you add the ports(1521,1526) in /etc/services on the server (Unix based) . Listener.ora LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL= TCP)(Host=your server ip address )(Port= 1526)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= hildb1.%domain_name%) (ORACLE_HOME= /opt/oracle/app/oracle/product/7.3.3) (SID_NAME = ghi100) ) ) LISTENER0 = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= TCP)(Host=your server ip address )(Port= 1521)) ) SID_LIST_LISTENER0 = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= hildb1.%domain_name%) (ORACLE_HOME= /opt/oracle/app/oracle/product/7.3.3) (SID_NAME = ghi100) ) ) There are two listener's LISTENER and LISTENER0 . You would have to start the listener's seperately. Especially check /etc/services for the entries and check if you have seperate listener names in listener.ora Hope this helps . shreepad -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how can listener list on two ports for the same db?
Hi Helmut , I will try to clarify using an example. Tnsnames.ora ghi100 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = your IP address of the server where database resides ) (Port = 1526) ) ) (CONNECT_DATA = (SID = ghi100) ) ) ghi101 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host =your IP address of the server where database resides ) (Port = 1521) ) ) (CONNECT_DATA = (SID = ghi100) ) ) In this example i have 2 connection strings (ghi100,ghi101) connecting through 2 different ports (1521,1526) to the same database . Also ensure that you add the ports(1521,1526) in /etc/services on the server (Unix based) . Listener.ora LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL= TCP)(Host=your server ip address )(Port= 1526)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= hildb1.%domain_name%) (ORACLE_HOME= /opt/oracle/app/oracle/product/7.3.3) (SID_NAME = ghi100) ) ) LISTENER0 = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= TCP)(Host=your server ip address )(Port= 1521)) ) SID_LIST_LISTENER0 = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= hildb1.%domain_name%) (ORACLE_HOME= /opt/oracle/app/oracle/product/7.3.3) (SID_NAME = ghi100) ) ) There are two listener's LISTENER and LISTENER0 . You would have to start the listener's seperately. Especially check /etc/services for the entries and check if you have seperate listener names in listener.ora Hope this helps . shreepad -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Bind Variable values
Ravi - According to Metalink Note:171647.1, There are four levels available when setting up trace with Event 10046 - · Level 1 is the default. This level traces all activities until the trace session is stopped. · Level 4 provides level 1 tracing and displays the entered value for all bind variables. Bind variables are the values that the user enters. The code displays these bind variables as: b1, etc. When level 4 is activated, the substituted value for the bind variable is displayed in the trace file. · Level 8 provides level 1 tracing and displays a list of all database wait events. Database wait events list the reasons if the elapsed time is greater than the CPU time in the tkprof report. · Level 12 provides level 1 tracing in addition to both bind variable substitution and database wait events. All trace modes will include timed statistics information in the trace file. Be warned that the increasing levels cause increasing trace file sizes. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 30, 2002 6:53 AM To: Multiple recipients of list ORACLE-L Hi All, I want to get the individual sql_trace from my applicaion as they use loads of bind variables, how to get those values so that I can run explain plan and see them individually? for examploe like event 10046? Thanks for your help. Ravi. __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: So, What is a 'Production DBA'?
Not sure I agree with prior statements. The Production DBA is the single person(s) responsible for the livelihood and availability of production database environments. He/She/It is the first line of contact should a database-centric application either not perform to expectations or crash. The Production DBA is responsible for environment tuning/performance/optimization, disaster recovery, backup/recovery, security, generic administration, etc. They are also responsible for enforcing production standards for all application development teams and ensuring that all is smooth. In many cases the Production DBA has the same responsibilities for the development environment to ensure that all guidelines are followed as software is transitioned from Development to test to validation and finally production. The Application DBA is responsible for the overall integrity of a specific application. They are responsible for the physical implementation of the logical data model for that application, application-specific performance issues, application-specific security issues, etc. Note the theme: application specific. This could include any application, even Oracle eBusiness Suite. Application DBAs are DBAs!!! However, many are just starting out in the field so this position was created by many organizations to let them get their feet wet. The primary difference between the two. One absolutely needs a pager and doesn't sleep. The other does. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, May 29, 2002 5:41 PM To: Multiple recipients of list ORACLE-L Subject:Re: Re[2]: So, What is a 'Production DBA'? well application dba tunes sql as well and makes sure that the ddl operations the developers want don't send the production dba on a rampage --- Robert Eskridge [EMAIL PROTECTED] wrote: Rachel, So we could distill your definitions down to: Production DBA: deals with real issues Application DBA: babysits developers :-) R that's not a bad definition :) R seriously, everyone will have their own definition, mine is: R production dba -- responsible for all databases that are considered R production. this includes but is not limited to: R backups R recovery testing R contingency testing R production performance tuning (should mostly be database tuning as SQL R really should be tuned at the development stage, with information R passed back from the production DBA) R documentation of all procedures R space management on production systems, including capacity planning and R projection of growth R change management R monitoring external data loads into production database R health checks on production database R application dba -- responsible for all databases in which developers R have access. responsibilities: R SQL tuning (not SQL coding!) R database design, in conjunction with the developers R any and all changes to the application schema R working with the production DBA to ensure production performance (see R SQL tuning!) R backups (these might be weekly offline backups, as development is R usually less critical but then again maybe not) R as deadlines creep closer, the weekends off may not be R this is just the short list R I've usually been both the production and application dba where I've R worked. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: updated rows count
The SQL%ROWCOUNT and SQL%FOUND can be used to test for the status after an update operation. If SQL%FOUND is true then SQL%ROECOUNT will hold the number of rows updated. If the transaction has failed then %FOUND will be FALSE (and %NOTFOUND will be true) and %ROWCOUNT will be 0 HTH John -Original Message- Sent: 30 May 2002 14:49 To: Multiple recipients of list ORACLE-L Hi All! My client run big update 20,000 statements. I need to know how many rows was updated (it's could be any number). I thinking about triggers , but this table can be updated not only with this big update. Other users can update rows too. I need to know updated rows number just for this big update. Thanks. update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty=850, atcapun=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Adding processor to Oracle server
I have a Windoze server that has an instance of 8.0.5 Oracle running on it. I just got an email from the network badmins that they are adding a processor to this server today. Glad to be in the loop!! This is a new experience for me. Is this something that may cause problems when Oracle starts up with this new processor?? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Bind Variable values
Set the SQL trace event (10046) to level 4 to dump the values of the bind variables. If you can enable SQL trace from within the session, you can use... alter session set events '10046 trace name context forever, level 4'; If you cannot alter the source code or otherwise enable SQL trace from within the session, you can do it from a SYSDBA session: SQL*Plus ORADEBUG SQL oradebug setospid OS-pid-of-server-process SQL oradebug event 10046 trace name context forever, level 4 DBMS_SYSTEM package exec dbms_system.set_ev(sid,serial#, 10046,4,''); I have a PL/SQL procedure named TRCLVL12 posted on my website (http://www.EvDBT.com/tools.htm) which demonstrates the use of the SET_EV procedure. I also have UNIX korn-shell scripts named traceon.sh and traceoff.sh at the same website which demonstrate the use of ORADEBUG. However, be aware that both utilities are setting SQL trace level 12, which is a combination of level 4 (bind variables) and level 8 (display wait event info) and produces huge trace files... Hope this helps... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 7:08 AM Hi If you just want to see the explain plan of a querry with bind variables you don't need the values. just type explain plan for statement and you can read the explain from the plan table(should have been created beforehand) HTH jack Nalla Ravi vvnrk2001@yahoo.To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] co.uk cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Bind Variable values [EMAIL PROTECTED] 30-05-2002 13:53 Please respond to ORACLE-L Hi All, I want to get the individual sql_trace from my applicaion as they use loads of bind variables, how to get those values so that I can run explain plan and see them individually? for examploe like event 10046? Thanks for your help. Ravi. __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements,
Re: updated rows count
select SQL%ROWCOUNT after update... Igor Neyman, OCP DBA [EMAIL PROTECTED] The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 9:48 AM Hi All! My client run big update 20,000 statements. I need to know how many rows was updated (it's could be any number). I thinking about triggers , but this table can be updated not only with this big update. Other users can update rows too. I need to know updated rows number just for this big update. Thanks. update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty=850, atcapun=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Advice needed please
Lee - Just some reactions, few answers. - Generally a process like this will be disk-bound, not CPU-bound, so idle CPU time is to be expected unless your disk is REALLY fast. - Multiple simultaneous full-table scans may not be any faster because the disk heads may need to flit to and fro in order to satisfy each process' request. Sometimes a single full table scan is as fast is it gets for a mechanical device like a disk. RAID will be faster, of course, but ultimately the RAID is composed of disks. - Trying for something faster than select * is a real challenge. To perform a full table scan, Oracle must read each data block. The alternative is index scanning, but this means reading an index block, fetching a data block, etc. Not faster if you're going to eventually read all data blocks anyway. - If select * isn't fast enough, you should consider using table partitioning. That way each process can separately scan a separate partition and separately write to your output files. Hopefully someone else will think of a bright idea I've missed. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 30, 2002 6:48 AM To: Multiple recipients of list ORACLE-L Oracle 8.0.5 Tru64 4.0f One of our developers here is writing a utility to provide fast unloads of tables (to replace fastunloader as it happens) His problem is as follows. Start from the bottom and work your way up. I would be really grateful if anyone can offer up some alternatives for us. Regards Lee -Original Message- From: Dudley Dave - ddudle Sent: 29 May 2002 16:04 To: Robertson Lee - lerobe Subject:RE: Do you still have that SQL Expert? No, you miss the point. I'm explicitly NOT using PQ (or at least not explicitly using it). Using a parallel hint on huge table unloads - with the single-threaded version of the code (i.e. pipdynsql.v2.0.0) didn't seem to make much difference at all. I didn't do the tests directly though, poeple on the account did. So it may be that the tables already had a degree of parallelism built in, in which case I'd guess the hint would be redundant. What I mean is that even if you use PQ for the server to extract the data in parallel you still have the bottle neck of a single client to send it all back to. That's what I was trying to get around. Assuming that we're not generally using the full network bandwidth, I'd assume that multiple clients ought to be able to dump out separate sections of a table at the same time, at roughly the same speed at a single client would unload a single table - i.e double the throughput. But I can't find anything on the web to tell me the best / most efficient way to actually do this. (By the way, I've tried the NO_PARALLEL hint too, to stop the server setting off too many conflicting slaves on its side. Again no better as far as I could tell.) N.B. Not sure if you'd suggest it, but before you do: most of the tables we'd really want to use this for are massive, and so are already partitioned. So where I say table I mean either that or a partition thereof. Besides, need a generic solution that doesn't rely on having to partition your table to unload it quickly. By the way, I'm specifically testing speed of my original code (e.g. pipdynsql.v2.0.0 user/pass select * from table) against the new multithreaded development code - i.e. regardless of the machine load at the time, I want to see if multiple simultaneous unloads can be quicker than a single unload client (at the expense of using more machine / Oracle resource obviously). Is this making sense? Dave -Original Message- From: Robertson Lee - lerobe Sent: 29 May 2002 15:14 To: Dudley Dave - ddudle Subject:RE: Do you still have that SQL Expert? How are you using PQ, is it just a hint ??. Which tables are you testing against. -Original Message- From: Dudley Dave - ddudle Sent: 29 May 2002 14:27 To: Robertson Lee - lerobe Subject:RE: Do you still have that SQL Expert? OK Clever-Trousers, As you're so hot on table/index disk striping... I've written the program pipdynsql, which as you may have heard (this lunchtime if not before), people want to use to replace FastUnloader. I've been playing about with a new multithreaded version to try to download a table in sections to multiple client threads which then write back out to a single file (either ordered, or for max speed in random/undefined order). Can you think of any quick ways to do this, or tricks to try? I've tried ranges of rowids (as I'm told that's hold parrallel query works) but the ROWID
Re: tkprof analysis
Oracle8i Server Tuning guide (part #A76992, available for free download from http://docs.oracle.com), pages 6-22 through 6-30 for TKPROF output example - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 7:38 AM Hi, Can any one point me or kindly send me the analysis of TKProf outout please. Thanks you so much for your help. Ravi. __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: updated rows count
Do this in PL/SQL, so you can use PL/SQL variables instead of data values embedded in the text of the SQL statement (much nicer on the Shared Pool). From PL/SQL, after each statement you can reference SQL%ROWCOUNT to get the number of rows actually updated... If you prefer Precompilers, you can get the same value from sqlca.sqlerrd[2] (I think)... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 7:48 AM Hi All! My client run big update 20,000 statements. I need to know how many rows was updated (it's could be any number). I thinking about triggers , but this table can be updated not only with this big update. Other users can update rows too. I need to know updated rows number just for this big update. Thanks. update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty=850, atcapun=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Bind Variable values
Hi Jack, thanks for the response however what I was looking is in a sql query they substitue around 100 bind variables (through application) I can't just substitue them one by one in where condition and run the query rather what I wanted to see like puting sql_trace on if we put set events 10046 name context forever, leve4 , can we also get the values for bind variables? Thanks, ravi --- Jack van Zanen [EMAIL PROTECTED] wrote: Hi If you just want to see the explain plan of a querry with bind variables you don't need the values. just type explain plan for statement and you can read the explain from the plan table(should have been created beforehand) HTH jack Nalla Ravi vvnrk2001@yahoo.To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] co.uk cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Bind Variable values [EMAIL PROTECTED] 30-05-2002 13:53 Please respond to ORACLE-L Hi All, I want to get the individual sql_trace from my applicaion as they use loads of bind variables, how to get those values so that I can run explain plan and see them individually? for examploe like event 10046? Thanks for your help. Ravi. __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for
Re: Wait time for SQL*Net message
depends on what is causing the wait time. if it's because this is an interactive application and you are waiting for the person to enter data into the screen, teaching them to type faster would do it. :) it could be your network lag time or the processor speed on the machine that is the client. You have to find out what is causing it before you can speed it up. There may actually be nothing you can do, or as Cary Millsap pointed out in another post to this list, this idle wait might actually be something you can speed up --- S B [EMAIL PROTECTED] wrote: The following statistics is for a server-side application ( pro*c ). The connection is established between proc*c to server as LOCAl=yes and PROTOCOL=BEQ(sqlplus usr/pass) i.e bypassing the tnsnames.ora and listener.ora EventWait(cs) %wait --- SQL*Net message from client 463790 61.85186173 CPU used by this session 229327 30.5834578 SQL*Net more data to client 323884.319321455 db file sequential read 216982.893683986 log file sync1788 0.23845087 SQL*Net message to client530 0.070681745 log file switch completion 188 0.025072015 Can anyone tell me about how to reduce the wait time for SQL*Net message TIA Bhulu __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: S B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Advice needed please
Thanks Dennis. Anything whether it be a reaction or an answer, is welcome. Regards Lee -Original Message- Sent: 30 May 2002 15:08 To: Multiple recipients of list ORACLE-L Lee - Just some reactions, few answers. - Generally a process like this will be disk-bound, not CPU-bound, so idle CPU time is to be expected unless your disk is REALLY fast. - Multiple simultaneous full-table scans may not be any faster because the disk heads may need to flit to and fro in order to satisfy each process' request. Sometimes a single full table scan is as fast is it gets for a mechanical device like a disk. RAID will be faster, of course, but ultimately the RAID is composed of disks. - Trying for something faster than select * is a real challenge. To perform a full table scan, Oracle must read each data block. The alternative is index scanning, but this means reading an index block, fetching a data block, etc. Not faster if you're going to eventually read all data blocks anyway. - If select * isn't fast enough, you should consider using table partitioning. That way each process can separately scan a separate partition and separately write to your output files. Hopefully someone else will think of a bright idea I've missed. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 30, 2002 6:48 AM To: Multiple recipients of list ORACLE-L Oracle 8.0.5 Tru64 4.0f One of our developers here is writing a utility to provide fast unloads of tables (to replace fastunloader as it happens) His problem is as follows. Start from the bottom and work your way up. I would be really grateful if anyone can offer up some alternatives for us. Regards Lee -Original Message- From: Dudley Dave - ddudle Sent: 29 May 2002 16:04 To: Robertson Lee - lerobe Subject:RE: Do you still have that SQL Expert? No, you miss the point. I'm explicitly NOT using PQ (or at least not explicitly using it). Using a parallel hint on huge table unloads - with the single-threaded version of the code (i.e. pipdynsql.v2.0.0) didn't seem to make much difference at all. I didn't do the tests directly though, poeple on the account did. So it may be that the tables already had a degree of parallelism built in, in which case I'd guess the hint would be redundant. What I mean is that even if you use PQ for the server to extract the data in parallel you still have the bottle neck of a single client to send it all back to. That's what I was trying to get around. Assuming that we're not generally using the full network bandwidth, I'd assume that multiple clients ought to be able to dump out separate sections of a table at the same time, at roughly the same speed at a single client would unload a single table - i.e double the throughput. But I can't find anything on the web to tell me the best / most efficient way to actually do this. (By the way, I've tried the NO_PARALLEL hint too, to stop the server setting off too many conflicting slaves on its side. Again no better as far as I could tell.) N.B. Not sure if you'd suggest it, but before you do: most of the tables we'd really want to use this for are massive, and so are already partitioned. So where I say table I mean either that or a partition thereof. Besides, need a generic solution that doesn't rely on having to partition your table to unload it quickly. By the way, I'm specifically testing speed of my original code (e.g. pipdynsql.v2.0.0 user/pass select * from table) against the new multithreaded development code - i.e. regardless of the machine load at the time, I want to see if multiple simultaneous unloads can be quicker than a single unload client (at the expense of using more machine / Oracle resource obviously). Is this making sense? Dave -Original Message- From: Robertson Lee - lerobe Sent: 29 May 2002 15:14 To: Dudley Dave - ddudle Subject:RE: Do you still have that SQL Expert? How are you using PQ, is it just a hint ??. Which tables are you testing against. -Original Message- From: Dudley Dave - ddudle Sent: 29 May 2002 14:27 To: Robertson Lee - lerobe Subject:RE: Do you still have that SQL Expert? OK Clever-Trousers, As you're so hot on table/index disk striping... I've written the program pipdynsql, which as you may have heard (this lunchtime if not before), people want to use to replace FastUnloader. I've been playing about with a new multithreaded version to try to download a table in sections to multiple client threads which then write back out to a single file (either ordered, or for max speed in random/undefined order).
RE: updated rows count
Greg - How is your client executing this SQL update statement? If it is executed from SQL*Plus, you are provided the number of rows updated as a reply. If it is a one-time update, that might be the simplest. With other tools, it depends a lot on the tool. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 30, 2002 8:49 AM To: Multiple recipients of list ORACLE-L Hi All! My client run big update 20,000 statements. I need to know how many rows was updated (it's could be any number). I thinking about triggers , but this table can be updated not only with this big update. Other users can update rows too. I need to know updated rows number just for this big update. Thanks. update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty=850, atcapun=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Undocumented Parameters
Lee, Here ya go. Remember, be *careful* with those hidden params, cowboy. Oracle does not support changing them, and you can really hose the system with em, perhaps beyond the normal capacity to repair it. As they say, this script is unsupported and for educational purposes only, but can come in handy on occasion. Did I say be careful? Might want to buff up the resume before you start acting like the Mad Hidden Parameter Scientist. ;) jack silvey -- -- -- author: jack silvey -- about: shows hidden and non-hidden parameters -- usually must connect as sys -- usage: @params -- -- -- column name format a45 column description format a70 column value format a20 set lines 145 set pages select nam.ksppinm name, val.KSPPSTVL value fromx$ksppi nam, x$ksppsvval where nam.indx = val.indx order by 1 / --- Robertson Lee - lerobe [EMAIL PROTECTED] wrote: Someone posted a bit of SQL to list out the undocumented parameters and guess what ... I deleted it. Could someone repost please ?? TIA Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: updated rows count
After each of 20,000 update statements? Alexandre select SQL%ROWCOUNT after update... Igor Neyman, OCP DBA [EMAIL PROTECTED] The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 9:48 AM Hi All! My client run big update 20,000 statements. I need to know how many rows was updated (it's could be any number). I thinking about triggers , but this table can be updated not only with this big update. Other users can update rows too. I need to know updated rows number just for this big update. Thanks. update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty=850, atcapun=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: For real Gurus only
great! thanks -Original Message- Sent: Thursday, May 30, 2002 5:23 AM To: Multiple recipients of list ORACLE-L Hello Gurus I got this link through SAG-L. Have a try. www.quest-pipelines.com/newsletter-v3/Crossword_Puzzles/puzzle0502.html Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Adding processor to Oracle server
You shouldn't have any problems with Oracle, as long as Windoze will behave... Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 9:54 AM I have a Windoze server that has an instance of 8.0.5 Oracle running on it. I just got an email from the network badmins that they are adding a processor to this server today. Glad to be in the loop!! This is a new experience for me. Is this something that may cause problems when Oracle starts up with this new processor?? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: updated rows count
One approach: create a new user for this update, create a trigger to log only updates from that user, run the script as newly created user. Alexandre Hi All! My client run big update 20,000 statements. I need to know how many rows was updated (it's could be any number). I thinking about triggers , but this table can be updated not only with this big update. Other users can update rows too. I need to know updated rows number just for this big update. Thanks. update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty=850, atcapun=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Bind Variable values
Hi Dennis, Thanks for the answer, I just put event leve4, I could not get the bind variables values, rather gave me :b1,:b2 How do I get those values? And another thing is in tkprof values can please explain me about the query and current rows and cpu and elapsed times? my understanding is:query is in consistent mode i.e rollback is that right? if that is the case if there are not active entries in rollback segments, query should give zero right? and current is blocks in current state? am i right? Thank you so much for the clarification. Thanks you Ravi --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Ravi - According to Metalink Note:171647.1, There are four levels available when setting up trace with Event 10046 - · Level 1 is the default. This level traces all activities until the trace session is stopped. · Level 4 provides level 1 tracing and displays the entered value for all bind variables. Bind variables are the values that the user enters. The code displays these bind variables as: b1, etc. When level 4 is activated, the substituted value for the bind variable is displayed in the trace file. · Level 8 provides level 1 tracing and displays a list of all database wait events. Database wait events list the reasons if the elapsed time is greater than the CPU time in the tkprof report. · Level 12 provides level 1 tracing in addition to both bind variable substitution and database wait events. All trace modes will include timed statistics information in the trace file. Be warned that the increasing levels cause increasing trace file sizes. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 30, 2002 6:53 AM To: Multiple recipients of list ORACLE-L Hi All, I want to get the individual sql_trace from my applicaion as they use loads of bind variables, how to get those values so that I can run explain plan and see them individually? for examploe like event 10046? Thanks for your help. Ravi. __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Adding processor to Oracle server
Dave: This is automatically taken care by the RDBMS kernel and sometimes relfected in the CPU_COUNT in the V$parameter. Otherwise you can query the X$view X$KVII select kviidsc,kviival from X$kvii where kviitag='ksbcpu'; Best Regards, K Gopalakrishnan Bangalore, INDIA - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 7:24 PM I have a Windoze server that has an instance of 8.0.5 Oracle running on it. I just got an email from the network badmins that they are adding a processor to this server today. Glad to be in the loop!! This is a new experience for me. Is this something that may cause problems when Oracle starts up with this new processor?? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Adding processor to Oracle server
This should not cause a database problem, however, you may want to check your Oracle license. It will cost you more!!! Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, May 30, 2002 9:54 AM To: Multiple recipients of list ORACLE-L Subject:Adding processor to Oracle server I have a Windoze server that has an instance of 8.0.5 Oracle running on it. I just got an email from the network badmins that they are adding a processor to this server today. Glad to be in the loop!! This is a new experience for me. Is this something that may cause problems when Oracle starts up with this new processor?? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: So, What is a 'Production DBA'?
I feel that it is hard to draw the lines between Application and Production DBA's. For example where would you place the DBA that maintains SAP? Without the application knowledge he/she/it wouldn't get very far. Also I have been wondering something and this thread seems a good place to ask. Is there a historical feud between DBA's and Developers? Coming from a consulting/software house I find some of the comments funny but can't believe that there is that quantity of bad developers. Most of the DBA's we deal with have come up through the ranks and started as developers. From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: So, What is a 'Production DBA'? Date: Thu, 30 May 2002 04:48:29 -0800 Rachel, I agree with your short list of the areas of responsibilities but I would change the word application to development. An application DBA, from the people I have talked to, is quite busy performing the upgrades and patches that accompany the Oracle Applications. The applications database generally has many, many tables, triggers and constraints and is constantly the target for upgrades and patches from Oracle. It is a time consuming task as the majority of the different applications (financial, HR, Purchase Order, etc) have hooks into each different package and are so intertwined that any small fix in one involves patches for the others. There are only a few user defined tables as each package has their own named tables that are partially shared between packages. There is very little if any work you can do on the application code because it is so intertwined and customized when it is installed. Any upgrades require that the customization be reworked to make it fit into the new version of the application package. It takes a longer time to install than a standard database, on the magnitude of days, and requires a dedicated and investigative mind set to maintain. To the list you created I would add: Help desk call recipient, network support, client support, software and hardware evaluation, whipping post, IT team member (possibly team leader), self driven, office coffee maker, consumer of various liquids. Ron ROR mª¿ªm [EMAIL PROTECTED] 05/29/02 04:50PM that's not a bad definition :) seriously, everyone will have their own definition, mine is: production dba -- responsible for all databases that are considered production. this includes but is not limited to: backups recovery testing contingency testing production performance tuning (should mostly be database tuning as SQL really should be tuned at the development stage, with information passed back from the production DBA) documentation of all procedures space management on production systems, including capacity planning and projection of growth change management monitoring external data loads into production database health checks on production database application dba -- responsible for all databases in which developers have access. responsibilities: SQL tuning (not SQL coding!) database design, in conjunction with the developers any and all changes to the application schema working with the production DBA to ensure production performance (see SQL tuning!) backups (these might be weekly offline backups, as development is usually less critical but then again maybe not) as deadlines creep closer, the weekends off may not be this is just the short list I've usually been both the production and application dba where I've worked. Rachel --- Peter Barnett [EMAIL PROTECTED] wrote: We are having this debate. What is a 'Production DBA'? Right now all of the DBAs do some of everything. In an effort to focus more DBA time on infrastructure, damagement is floating the idea of Production and Applications DBAs. The DBA group has loosely translated this into the group that is always on-call and the group that gets their weekends off. I would appreciate some input from those of you who are Production DBAs. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mail ing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: updated rows count
usecat file_name | grep -C update JP On Thursday 30 May 2002 15:48, you wrote: Hi All! My client run big update 20,000 statements. I need to know how many rows was updated (it's could be any number). I thinking about triggers , but this table can be updated not only with this big update. Other users can update rows too. I need to know updated rows number just for this big update. Thanks. update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty=850, atcapun=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: So, What is a 'Production DBA'?
ron, I've usually seen the term Apps DBA for the DBA who deals with Oracle Applications. As for using development dba vs application dba I was using the terminology of the original poster. My feeling is, separating these functions just adds to overhead and disconnect in solving problems... more places to point fingers and say it wasn't me, it was fill in the name's problem Rachel --- Ron Rogers [EMAIL PROTECTED] wrote: Rachel, I agree with your short list of the areas of responsibilities but I would change the word application to development. An application DBA, from the people I have talked to, is quite busy performing the upgrades and patches that accompany the Oracle Applications. The applications database generally has many, many tables, triggers and constraints and is constantly the target for upgrades and patches from Oracle. It is a time consuming task as the majority of the different applications (financial, HR, Purchase Order, etc) have hooks into each different package and are so intertwined that any small fix in one involves patches for the others. There are only a few user defined tables as each package has their own named tables that are partially shared between packages. There is very little if any work you can do on the application code because it is so intertwined and customized when it is installed. Any upgrades require that the customization be reworked to make it fit into the new version of the application package. It takes a longer time to install than a standard database, on the magnitude of days, and requires a dedicated and investigative mind set to maintain. To the list you created I would add: Help desk call recipient, network support, client support, software and hardware evaluation, whipping post, IT team member (possibly team leader), self driven, office coffee maker, consumer of various liquids. Ron ROR mª¿ªm [EMAIL PROTECTED] 05/29/02 04:50PM that's not a bad definition :) seriously, everyone will have their own definition, mine is: production dba -- responsible for all databases that are considered production. this includes but is not limited to: backups recovery testing contingency testing production performance tuning (should mostly be database tuning as SQL really should be tuned at the development stage, with information passed back from the production DBA) documentation of all procedures space management on production systems, including capacity planning and projection of growth change management monitoring external data loads into production database health checks on production database application dba -- responsible for all databases in which developers have access. responsibilities: SQL tuning (not SQL coding!) database design, in conjunction with the developers any and all changes to the application schema working with the production DBA to ensure production performance (see SQL tuning!) backups (these might be weekly offline backups, as development is usually less critical but then again maybe not) as deadlines creep closer, the weekends off may not be this is just the short list I've usually been both the production and application dba where I've worked. Rachel --- Peter Barnett [EMAIL PROTECTED] wrote: We are having this debate. What is a 'Production DBA'? Right now all of the DBAs do some of everything. In an effort to focus more DBA time on infrastructure, damagement is floating the idea of Production and Applications DBAs. The DBA group has loosely translated this into the group that is always on-call and the group that gets their weekends off. I would appreciate some input from those of you who are Production DBAs. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mail ing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED]
Re: _tru64_directio_disabled param Value on Digital Tru64 Unix
So you got a performance improvement by *disabling* DirectIO (ie, by setting _tru64_directio_disabled=TRUE) ? Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, 30 May, 2002 3:48 AM I joined in on this thread a little bit late. I just did a little experimentation with this parameter, and all that I can say is WOW! This is the equivalent of the mythical _make_sql_run_faster! My quick tests on 8.1.7.2 on both Tru64 5.1 pk3 and 5.1a pk1: Query1 : Avg. of 1.13 sec improved to .11 sec. Query2 : Avg. of 11.78 sec improved to 2.12 sec. Query3 : Avg. of .75 sec improved to .08 sec. This included multiple runs of each query, with a database bounce in between of course. So, what is the catch? [EMAIL PROTECTED] 05/29/02 02:26PM Quote from a person who has had researched this thoroughly at our site - Oracle 8.1.6 and later releases check to see if they are running on Tru64 5.0a or later operating system revision.If so, the RDBMS automatically uses the directio mode to open the database files. Directio bypasses the operating system (ADVFS file system) caching and is more efficient; however, ADVFS does not cache any data or pre-fetch read data.For single block random reads directio is a performance improvement--there is less O/S overhead and Oracle does a good job of managing the buffer cache. However, Oracle does not hold multiple block reads in its cache, so if your workload involves a large number of multi-block reads directio is a performance detriment.The blocks are not cached, so re-reads require physical I/O for each read, and Oracle does not pre-fetch data as ADVFS does, so the application incurs more I/O wait. Also, any subsequent access after a file is opened in directio mode inherits the directio mode. This may impact other applications reading the files outside of the database activity--for example backup. In our experience using the Oracle Applications (ERP) suite, overall performance was better with directio disabled. By default directio is enabled if running 8.1.6 or later and Tru64 5.0a or later.The flag to disable was introduced in 8.1.7.2, I believe. We were told not to run 8.1.7.2 on Tru64 (buggy), so we have implemented 8.1.7.3. The default operating mode is: _tru64_directio_disabled = FALSE This enables directio. If you set it TRUE, then the RDBMS I/O will function as it did before--using normal I/O. There is not a lot of risk in changing this option, and directio may prove to be advantageous for a heavy OLTP environment. I would recommend testing outside of Production if at all possible. Bill HTH Srini Chavali Oracle DBA Cummins Inc -- 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). **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
Re: Adding processor to Oracle server
Dave, Your Oracle instance won't have a problem with it. Your Oracle Sales Rep. will be absolutely delighted, because you will owe them more $$$ for the extra CPU license! Better check with your CIO (or equivalent) to see if your organization really wants to add that CPU. Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 [EMAIL PROTECTED] Farnsworth, Dave DFarnsworth@Ashleyfurn To: Multiple recipients of list ORACLE-L iture.com [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Adding processor to Oracle server 05/30/2002 08:54 AM Please respond to ORACLE-L I have a Windoze server that has an instance of 8.0.5 Oracle running on it. I just got an email from the network badmins that they are adding a processor to this server today. Glad to be in the loop!! This is a new experience for me. Is this something that may cause problems when Oracle starts up with this new processor?? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: _tru64_directio_disabled param Value on Digital Tru64 Unix
Yes, I changed it from the default. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA Hemant K Chitale [EMAIL PROTECTED] 05/30/02 09:32AM So you got a performance improvement by *disabling* DirectIO (ie, by setting _tru64_directio_disabled=TRUE) ? Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, 30 May, 2002 3:48 AM I joined in on this thread a little bit late. I just did a little experimentation with this parameter, and all that I can say is WOW! This is the equivalent of the mythical _make_sql_run_faster! My quick tests on 8.1.7.2 on both Tru64 5.1 pk3 and 5.1a pk1: Query1 : Avg. of 1.13 sec improved to .11 sec. Query2 : Avg. of 11.78 sec improved to 2.12 sec. Query3 : Avg. of .75 sec improved to .08 sec. This included multiple runs of each query, with a database bounce in between of course. So, what is the catch? [EMAIL PROTECTED] 05/29/02 02:26PM Quote from a person who has had researched this thoroughly at our site - Oracle 8.1.6 and later releases check to see if they are running on Tru64 5.0a or later operating system revision.If so, the RDBMS automatically uses the directio mode to open the database files. Directio bypasses the operating system (ADVFS file system) caching and is more efficient; however, ADVFS does not cache any data or pre-fetch read data.For single block random reads directio is a performance improvement--there is less O/S overhead and Oracle does a good job of managing the buffer cache. However, Oracle does not hold multiple block reads in its cache, so if your workload involves a large number of multi-block reads directio is a performance detriment.The blocks are not cached, so re-reads require physical I/O for each read, and Oracle does not pre-fetch data as ADVFS does, so the application incurs more I/O wait. Also, any subsequent access after a file is opened in directio mode inherits the directio mode. This may impact other applications reading the files outside of the database activity--for example backup. In our experience using the Oracle Applications (ERP) suite, overall performance was better with directio disabled. By default directio is enabled if running 8.1.6 or later and Tru64 5.0a or later.The flag to disable was introduced in 8.1.7.2, I believe. We were told not to run 8.1.7.2 on Tru64 (buggy), so we have implemented 8.1.7.3. The default operating mode is: _tru64_directio_disabled = FALSE This enables directio. If you set it TRUE, then the RDBMS I/O will function as it did before--using normal I/O. There is not a lot of risk in changing this option, and directio may prove to be advantageous for a heavy OLTP environment. I would recommend testing outside of Production if at all possible. Bill HTH Srini Chavali Oracle DBA Cummins Inc -- 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). **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- 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). **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are
RE: SQL Question
Hi Conner, Yes, I agree. But its the 'green bean' developers that I am dealing with :) Regards, - Kirti PS : Your BCHR enhancer code is coming extremely handy :) Great Job, you did !! -Original Message- Sent: Thursday, May 30, 2002 4:23 AM To: Multiple recipients of list ORACLE-L I'm sure you're already aware of this, but the substr/instr is not as complicated as it looks since instr takes 4 parms, the 4th of which makes cycling through fields 1=8 easy. hth connor --- Deshpande, Kirti [EMAIL PROTECTED] wrote: Stephane, Thanks. Nice idea :) I will pass on this idea to them... Hope it flies.. Looks like either a function or a view around the 'ugly' code is the only choice. - Kirti - -- 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: updated rows count
before the update: Select count(*) from table where ... Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 3:48 PM Hi All! My client run big update 20,000 statements. I need to know how many rows was updated (it's could be any number). I thinking about triggers , but this table can be updated not only with this big update. Other users can update rows too. I need to know updated rows number just for this big update. Thanks. update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty=850, atcapun=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
undeliverable email - Yo Jared
Jared, I have been getting these for a few weeks now on all of my posts. It is only for the name listed below. If anyone else is getting these could this name be removed from this list. These undeliverable emails clutter up my Off-Topic emails. ;o) Thanks, Dave -Original Message- From: System Administrator Sent: Thursday, May 30, 2002 8:36 AM To: [EMAIL PROTECTED] Subject: Undeliverable: Adding processor to Oracle server Your message did not reach some or all of the intended recipients. Subject:Adding processor to Oracle server Sent: 5/30/2002 8:54 AM The following recipient(s) could not be reached: [EMAIL PROTECTED] on 5/30/2002 9:36 AM The e-mail account does not exist at the organization this message was sent to. Check the e-mail address, or contact the recipient directly to find out the correct address. mx1.xnet.com #5.1.1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Senior DBA position - Dublin, Ireland
Brian, first, his grandparents were Irish, his mom was born here. second, we were married for about 7 and a half years so that would qualify me however, it's the he has to ask part that kills the whole deal... he died july 9, 1993 Rachel --- [EMAIL PROTECTED] wrote: Rachel, if his Mother is Irish, all he needs to do is ask for the passport - once he has it - you can apply for one as long as you've been married for over three years i think , again try the government sit http://www.irlgov.ie -it'll give you all you need to know Brian. Brian Mc Quillan Database Development Manager Gelco Information Network 10700 Prairie Lakes Drive Eden Prairie, MN 55344 Voice : (952) 947 1598 Fax: (952) 995 8581 e-mail : [EMAIL PROTECTED] www.gelcotrade.com Rachel Carmichael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wisernet100@y cc: ahoo.comSubject: Re: Senior DBA position - Dublin, Ireland Sent by: [EMAIL PROTECTED] om 05/29/2002 22:23 Please respond to ORACLE-L does it help any that I married someone who was half Irish? (his mom is/was first generation American and pure Irish ancestry) --- Tim Gorman [EMAIL PROTECTED] wrote: I've been told that if you can produce an ancestor's Irish birth certificate you can get an Irish passport? Could be a myth, but gentleman seemed quite reliable. This passport would then be an entree to work in the EU, if I'm not mistaken, perhaps? I'm going to check, certainly... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 10:18 AM Rachel, The quarantine laws are the same as the UK - put your pet in quarantine for 6 months to see if it has rabies - a bit cruel these days when you figure that they can probably tell you within a week or so if your pet is ill. If you've never thought about Dublin - you should - I worked there as a DBA for 6 months back in '98 (how I ended up in Minnesota is a long story) and have often thought about going back there. I liked it a lot it's a fun city, lots to do and reasonably good night life. unless, like me you're Irish (or have a European passport of some kind ) you'd need a work permit. Brian Mc Quillan Database Development Manager Gelco Information Network 10700 Prairie Lakes Drive Eden Prairie, MN 55344 Voice : (952) 947 1598 Fax: (952) 995 8581 e-mail : [EMAIL PROTECTED] www.gelcotrade.com Rachel Carmichael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wisernet100@y cc: ahoo.comSubject: Re: Senior DBA position - Dublin, Ireland Sent by: [EMAIL PROTECTED] om 05/28/2002 10:28 Please respond to ORACLE-L oh so tempting but I know England's restrictions on bringing in pets, what are Ireland's? --- O'Neill, Sean [EMAIL PROTECTED] wrote: Before any public outcry I checked in with, and got permission, from list moderator to make this posting!!! Acknowledging we're geographically remote for most members of
RE: how to change a foreign key back to a primary key
Trang, How about: alter tableTABLE_NAME drop constraint CONSTRAINT_NAME; alter table TABLE_NAME add constraint pk_TABLE_NAME primary key (COLUMN) using index tablespace indexes; -Original Message-From: Meomeo Nguyen [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 29, 2002 7:06 PMTo: Multiple recipients of list ORACLE-LSubject: how to change a foreign key back to a primary key Hi, I need to change aforeign key back to a primary key in a table. How do I do that. Please help. Thanks in advance. Trang Do You Yahoo!?Yahoo! - Official partner of 2002 FIFA World Cup
Re: how can listener list on two ports for the same db?
Title: how can listener list on two ports for the same db? Hello Helmut You need to configure the listener to listen on ONE host with 2 ports. The machine name is the same. You separate the connections via tnsnames.ora on the client side. I got a call today that one of our application server can not connect to a database after tech people movean applicationserver to another place. Connected to the database from my PC - OK. I activated tnsping from the server itself and could not get response. I changed the tnsnames, on the application server, to access a second network card and all is well. I accessed the database via another NIC without any change to the database server. Yechiel AdarMehish - Original Message - From: Daiminger, Helmut To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 29, 2002 11:28 AM Subject: how can listener list on two ports for the same db? Hi! We have a db server (in a cluster) with two NICs and two IP-Adresses (i.e. logical names in the cluster). How do I configure the listener so that it listenes for both logical names of the machine? LISTCMDB = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = kfplcmdb)(PORT = 1522)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = kfalcmdb)(PORT = 1522)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_CMDB)) ) ) ) SID_LIST_LISTCMDB = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc_CMDB) (ORACLE_HOME = /cmdb/u0x/u01/app/oracle/product/8.1.7) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = CMDB) (ORACLE_HOME = /cmdb/u0x/u01/app/oracle/product/8.1.7) (SID_NAME = CMDB) ) ) Sitting on our RMAN database machine, pinging kfplcmdb does not work but pinging kfalcmdb works fine. On th emachine to be backed up: why can't I use kfalcmdb in the listener.ora file? The listener works fine when using kfplcmdb. This is 8.1.7 on Solaris 8. Thanks, Helmut
RE: updated rows count
Hi All!=0D My client run big update 20,000 statements. I need to know how many rows wa= s updated (it's could be any number). =0D I thinking about triggers , but this table can be updated not only with thi= s big update. Other users can update rows too.=0D I need to know updated rows number just for this big update.=0D Thanks.=0D =0D update assethdr set atopsys=3D 'MS Windows 95 4.00',atdept=3D'256MB', atcap= cty=3D850, atcapun=3D1, atglcode=3D'19.99GB', atus1=3D'05/20/2002' wher= e ataltnbr=3D'000';=0D update assethdr set atopsys=3D 'MS Windows 95 4.00',atdept=3D'256MB', atcap= cty=3D 850, atcapun=3D1, atglcode=3D'19.99GB', atus1=3D'05/17/2002' whe= re ataltnbr=3D'';=0D update assethdr set atopsys=3D 'MS Windows 2000 Pro 5.00',atdept=3D'128MB',= atcapcty=3D 400, atcapun=3D1, atglcode=3D'6.43GB', atus1=3D'05/20/2002= ' where ataltnbr=3D'0296';=0D =0D =0D =0D Several solutions. SELECT COUNT(*) with the same WHERE clause is an obvious solution. Checking ROWS_PROCESSED before and after the run in V$SQLAREA for the relevant line may be another option. Tracing the process is possible too. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to change a foreign key back to a primary key
Hi Igor, I just wanted to set a concatenated keys for my table. By mistake, I assigned only one primary key instead of two combined together. Here is my table structure: organization_id (primary key) address_id (foreign key) It should have been a primary key as well. I wanted to set this attribute as primary key. How do I do that? address_type Thanks for your help. I do appreciate it. Trang Igor Neyman [EMAIL PROTECTED] wrote: Trang, Could you be a little bit more specific about what you are trying to do? Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Meomeo Nguyen To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 29, 2002 7:05 PM Subject: how to change a foreign key back to a primary key Hi, I need to change aforeign key back to a primary key in a table. How do I do that. Please help. Thanks in advance. Trang Do You Yahoo!?Yahoo! - Official partner of 2002 FIFA World CupDo You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup
rman duplicate dbid?
I'm just starting to set up RMAN (8.1.7+) . . . I'm registering all of my databases one by one from the command line. I have two db's on the same solaris box and when I run the rman command they both show up with the same DB_ID, thus preventing me from registering both of them . . . I get an error when registering the second that it's already registered. they are distinct db's . . . I tried unregistering one and then retrying, and again I get the same DBID for both. any ideas? thanks, y'all -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: move the production database from one machine to another
On Wed, May 29, 2002 at 09:13:25PM -0800, Jeremiah Wilton wrote: On Wed, 29 May 2002, Ray Stell wrote: It is not supported as an upgrade process. Oracle does not support prod at 8.1.7.0 and standby at 8.1.7.2. I think this is a real crime, since it would be a great feature to lower downtime. Why? Because of some local operational issues. I am required to have multiple servers for redundancy and I can schedule query only time which is not equal to sla downtime. This window could be used to rebuild the dictionary on an activated standby. The fact that it works fine and Oracle doesn't support it makes me whine, sometimes in plubic. I guess I wouldn't suggest that Li Zhang upgrade both server and oracle at the same time, anyway. It takes almost no time to shut down an 8.1.7.0 instance and start it up on an 8.1.7.2 ORACLE_HOME on the same server. The part that takes a long time is re-running catalog, catproc, etc., which I've never understood why you have to do, and which you have to do with the database open and only you logged in. You shouldn't need a standby to perform a fast upgrade even in a supported manner. Rerunning catalog and catproc takes much too long. Oracle should figure out the small number of objects that need to be recompiled under a new binary and provide a script with just those in it. Rerunning everything is a waste of time, and resources, and is disruptive as well. Anyway, since the log format of 8.1.7.0 is the same as 8.1.7.2, there should be no real problem running the standby in this mode, which I'll take you word for it is unsupported. The question is, why would someone do it? Disk space for ORACLE_HOME? An extra disk is probably cheaper than a whone second server for a standby. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, May 29, 2002 at 03:53:32PM -0800, Li Zhang wrote: The company I am working for is planning to move the whole production server to a new faster box. As DBA, I will move the database and planning to use hot backup files in order to minimize the production server down time. Are there any issues or drawbacks I need to be aware of if the hot backup files are used to replicate the database? This is 8.1.7 on Solaris 2.7 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === 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: So, What is a 'Production DBA'?
Thanks to all who responded. The debate on the list is just as lively as the one around the water cooler. I did like the response about a 50% pay differential for production DBAs. That will make the bosses hair stand on end! --- Peter Barnett [EMAIL PROTECTED] wrote: We are having this debate. What is a 'Production DBA'? Right now all of the DBAs do some of everything. In an effort to focus more DBA time on infrastructure, damagement is floating the idea of Production and Applications DBAs. The DBA group has loosely translated this into the group that is always on-call and the group that gets their weekends off. I would appreciate some input from those of you who are Production DBAs. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: So, What is a 'Production DBA'?
all it takes is one bad developer (commonly referred to as a duhveloper) to spark the flames remember, dilbert makes its money on the BAD side of software development, there is no humor (and in our cases, no angst) when the people do the jobs they are supposed, on time and properly. In my own case, I would say that 95% of the developers I have worked with have been really good at what they do, involved and interested enough to learn something about how Oracle works under the covers and not just how to code SQL. And yes, I started as a developer, although I've never been an Oracle developer. But that 5% makes for some REALLY good war stories :) --- Jay Wade [EMAIL PROTECTED] wrote: I feel that it is hard to draw the lines between Application and Production DBA's. For example where would you place the DBA that maintains SAP? Without the application knowledge he/she/it wouldn't get very far. Also I have been wondering something and this thread seems a good place to ask. Is there a historical feud between DBA's and Developers? Coming from a consulting/software house I find some of the comments funny but can't believe that there is that quantity of bad developers. Most of the DBA's we deal with have come up through the ranks and started as developers. From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: So, What is a 'Production DBA'? Date: Thu, 30 May 2002 04:48:29 -0800 Rachel, I agree with your short list of the areas of responsibilities but I would change the word application to development. An application DBA, from the people I have talked to, is quite busy performing the upgrades and patches that accompany the Oracle Applications. The applications database generally has many, many tables, triggers and constraints and is constantly the target for upgrades and patches from Oracle. It is a time consuming task as the majority of the different applications (financial, HR, Purchase Order, etc) have hooks into each different package and are so intertwined that any small fix in one involves patches for the others. There are only a few user defined tables as each package has their own named tables that are partially shared between packages. There is very little if any work you can do on the application code because it is so intertwined and customized when it is installed. Any upgrades require that the customization be reworked to make it fit into the new version of the application package. It takes a longer time to install than a standard database, on the magnitude of days, and requires a dedicated and investigative mind set to maintain. To the list you created I would add: Help desk call recipient, network support, client support, software and hardware evaluation, whipping post, IT team member (possibly team leader), self driven, office coffee maker, consumer of various liquids. Ron ROR mª¿ªm [EMAIL PROTECTED] 05/29/02 04:50PM that's not a bad definition :) seriously, everyone will have their own definition, mine is: production dba -- responsible for all databases that are considered production. this includes but is not limited to: backups recovery testing contingency testing production performance tuning (should mostly be database tuning as SQL really should be tuned at the development stage, with information passed back from the production DBA) documentation of all procedures space management on production systems, including capacity planning and projection of growth change management monitoring external data loads into production database health checks on production database application dba -- responsible for all databases in which developers have access. responsibilities: SQL tuning (not SQL coding!) database design, in conjunction with the developers any and all changes to the application schema working with the production DBA to ensure production performance (see SQL tuning!) backups (these might be weekly offline backups, as development is usually less critical but then again maybe not) as deadlines creep closer, the weekends off may not be this is just the short list I've usually been both the production and application dba where I've worked. Rachel --- Peter Barnett [EMAIL PROTECTED] wrote: We are having this debate. What is a 'Production DBA'? Right now all of the DBAs do some of everything. In an effort to focus more DBA time on infrastructure, damagement is floating the idea of Production and Applications DBAs. The DBA group has loosely translated this into the group that is always on-call and the group that gets their weekends off. I would appreciate some input from those of you who are Production DBAs. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED]
RE: So, What is a 'Production DBA'?
Jay Yes, many of us were developers and for awhile you have the illusion that they should accept you because you are one of them. Eventually you realize the relationship isn't that simple at all. The problems usually come from perspective, interests, and priorities. Many senior developers have an interest in learning about the database and I trust them to perform many tasks. Other developers have little interest in the database and I am constantly worried about ensuring they can't damage the database. As a production DBA, you must have a system-wide perspective, and many developers just think about their program as if it ran on a single-user PC. Some of their tuning may affect the system performance adversely, like not using bind variables. And lastly, their priority is getting their program completed and running as quickly as possible while your priority is keeping the database running. Therefore you should respond to their request as quickly as possible to meet their deadline. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 30, 2002 10:09 AM To: Multiple recipients of list ORACLE-L I feel that it is hard to draw the lines between Application and Production DBA's. For example where would you place the DBA that maintains SAP? Without the application knowledge he/she/it wouldn't get very far. Also I have been wondering something and this thread seems a good place to ask. Is there a historical feud between DBA's and Developers? Coming from a consulting/software house I find some of the comments funny but can't believe that there is that quantity of bad developers. Most of the DBA's we deal with have come up through the ranks and started as developers. From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: So, What is a 'Production DBA'? Date: Thu, 30 May 2002 04:48:29 -0800 Rachel, I agree with your short list of the areas of responsibilities but I would change the word application to development. An application DBA, from the people I have talked to, is quite busy performing the upgrades and patches that accompany the Oracle Applications. The applications database generally has many, many tables, triggers and constraints and is constantly the target for upgrades and patches from Oracle. It is a time consuming task as the majority of the different applications (financial, HR, Purchase Order, etc) have hooks into each different package and are so intertwined that any small fix in one involves patches for the others. There are only a few user defined tables as each package has their own named tables that are partially shared between packages. There is very little if any work you can do on the application code because it is so intertwined and customized when it is installed. Any upgrades require that the customization be reworked to make it fit into the new version of the application package. It takes a longer time to install than a standard database, on the magnitude of days, and requires a dedicated and investigative mind set to maintain. To the list you created I would add: Help desk call recipient, network support, client support, software and hardware evaluation, whipping post, IT team member (possibly team leader), self driven, office coffee maker, consumer of various liquids. Ron ROR mª¿ªm [EMAIL PROTECTED] 05/29/02 04:50PM that's not a bad definition :) seriously, everyone will have their own definition, mine is: production dba -- responsible for all databases that are considered production. this includes but is not limited to: backups recovery testing contingency testing production performance tuning (should mostly be database tuning as SQL really should be tuned at the development stage, with information passed back from the production DBA) documentation of all procedures space management on production systems, including capacity planning and projection of growth change management monitoring external data loads into production database health checks on production database application dba -- responsible for all databases in which developers have access. responsibilities: SQL tuning (not SQL coding!) database design, in conjunction with the developers any and all changes to the application schema working with the production DBA to ensure production performance (see SQL tuning!) backups (these might be weekly offline backups, as development is usually less critical but then again maybe not) as deadlines creep closer, the weekends off may not be this is just the short list I've usually been both the production and application dba where I've worked. Rachel --- Peter Barnett [EMAIL PROTECTED] wrote: We are having this debate. What is a 'Production DBA'? Right now all of the DBAs do some of everything. In an effort to focus more DBA time on infrastructure, damagement is floating the idea of Production and
RE: rman duplicate dbid?
Bill Perhaps you created one by cloning it from the other one. This can change the SID, but won't change the DB_ID. RMAN can't deal with multiple instances with the same DB_ID. The simplest way around this is to create a separate RMAN catalog for one of them (just create a separate username). Actually, I'm becoming convinced that maybe the way to go is to create a separate catalog for each production database. This gives you more flexibility, and I haven't seem any disadvantages to this. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 30, 2002 9:59 AM To: Multiple recipients of list ORACLE-L I'm just starting to set up RMAN (8.1.7+) . . . I'm registering all of my databases one by one from the command line. I have two db's on the same solaris box and when I run the rman command they both show up with the same DB_ID, thus preventing me from registering both of them . . . I get an error when registering the second that it's already registered. they are distinct db's . . . I tried unregistering one and then retrying, and again I get the same DBID for both. any ideas? thanks, y'all -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: So, What is a 'Production DBA'?
Actually some of the worst DBA's come from the development track. IMHO, the best DBAs are from the systems world :). Of course this doesn't mean all systems ppl make good dba's or all developers make bad dba's. This is only from my experience. Gene *Let the Wars begin, NOT* [EMAIL PROTECTED] 05/30/02 11:08AM I feel that it is hard to draw the lines between Application and Production DBA's. For example where would you place the DBA that maintains SAP? Without the application knowledge he/she/it wouldn't get very far. Also I have been wondering something and this thread seems a good place to ask. Is there a historical feud between DBA's and Developers? Coming from a consulting/software house I find some of the comments funny but can't believe that there is that quantity of bad developers. Most of the DBA's we deal with have come up through the ranks and started as developers. From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: So, What is a 'Production DBA'? Date: Thu, 30 May 2002 04:48:29 -0800 Rachel, I agree with your short list of the areas of responsibilities but I would change the word application to development. An application DBA, from the people I have talked to, is quite busy performing the upgrades and patches that accompany the Oracle Applications. The applications database generally has many, many tables, triggers and constraints and is constantly the target for upgrades and patches from Oracle. It is a time consuming task as the majority of the different applications (financial, HR, Purchase Order, etc) have hooks into each different package and are so intertwined that any small fix in one involves patches for the others. There are only a few user defined tables as each package has their own named tables that are partially shared between packages. There is very little if any work you can do on the application code because it is so intertwined and customized when it is installed. Any upgrades require that the customization be reworked to make it fit into the new version of the application package. It takes a longer time to install than a standard database, on the magnitude of days, and requires a dedicated and investigative mind set to maintain. To the list you created I would add: Help desk call recipient, network support, client support, software and hardware evaluation, whipping post, IT team member (possibly team leader), self driven, office coffee maker, consumer of various liquids. Ron ROR mª¿ªm [EMAIL PROTECTED] 05/29/02 04:50PM that's not a bad definition :) seriously, everyone will have their own definition, mine is: production dba -- responsible for all databases that are considered production. this includes but is not limited to: backups recovery testing contingency testing production performance tuning (should mostly be database tuning as SQL really should be tuned at the development stage, with information passed back from the production DBA) documentation of all procedures space management on production systems, including capacity planning and projection of growth change management monitoring external data loads into production database health checks on production database application dba -- responsible for all databases in which developers have access. responsibilities: SQL tuning (not SQL coding!) database design, in conjunction with the developers any and all changes to the application schema working with the production DBA to ensure production performance (see SQL tuning!) backups (these might be weekly offline backups, as development is usually less critical but then again maybe not) as deadlines creep closer, the weekends off may not be this is just the short list I've usually been both the production and application dba where I've worked. Rachel --- Peter Barnett [EMAIL PROTECTED] wrote: We are having this debate. What is a 'Production DBA'? Right now all of the DBAs do some of everything. In an effort to focus more DBA time on infrastructure, damagement is floating the idea of Production and Applications DBAs. The DBA group has loosely translated this into the group that is always on-call and the group that gets their weekends off. I would appreciate some input from those of you who are Production DBAs. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from
Using DUAL
The developers here have a fondness for usingDUALfor simple operations (select count(*) from dual is executed 1+ times per day). I recall a passing comment somewhere/sometime that there are performance issues with accessingDUAL. Of course, now that I need to provide some information to the developers, I can't recall the comment or find documentation. Any assistance is greatly appreciated. Daniel W. Fink
Re: So, What is a 'Production DBA'?
I guess it's that old Russian proverb To a hammer, all the world looks like a nail. Developers have experience as hammers and everything revolves around the code. As an ex-developer, now DBA, I know that sometimes you need a screwdriver (or a Harvey Wall Banger). Jay Wade fish_dbaTo: Multiple recipients of list ORACLE-L @hotmail.com[EMAIL PROTECTED] Sent by: rootcc: Subject: Re: So, What is a 'Production DBA'? 05/30/2002 11:08 AM Please respond to ORACLE-L I feel that it is hard to draw the lines between Application and Production DBA's. For example where would you place the DBA that maintains SAP? Without the application knowledge he/she/it wouldn't get very far. Also I have been wondering something and this thread seems a good place to ask. Is there a historical feud between DBA's and Developers? Coming from a consulting/software house I find some of the comments funny but can't believe that there is that quantity of bad developers. Most of the DBA's we deal with have come up through the ranks and started as developers. From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: So, What is a 'Production DBA'? Date: Thu, 30 May 2002 04:48:29 -0800 Rachel, I agree with your short list of the areas of responsibilities but I would change the word application to development. An application DBA, from the people I have talked to, is quite busy performing the upgrades and patches that accompany the Oracle Applications. The applications database generally has many, many tables, triggers and constraints and is constantly the target for upgrades and patches from Oracle. It is a time consuming task as the majority of the different applications (financial, HR, Purchase Order, etc) have hooks into each different package and are so intertwined that any small fix in one involves patches for the others. There are only a few user defined tables as each package has their own named tables that are partially shared between packages. There is very little if any work you can do on the application code because it is so intertwined and customized when it is installed. Any upgrades require that the customization be reworked to make it fit into the new version of the application package. It takes a longer time to install than a standard database, on the magnitude of days, and requires a dedicated and investigative mind set to maintain. To the list you created I would add: Help desk call recipient, network support, client support, software and hardware evaluation, whipping post, IT team member (possibly team leader), self driven, office coffee maker, consumer of various liquids. Ron ROR mª¿ªm [EMAIL PROTECTED] 05/29/02 04:50PM that's not a bad definition :) seriously, everyone will have their own definition, mine is: production dba -- responsible for all databases that are considered production. this includes but is not limited to: backups recovery testing contingency testing production performance tuning (should mostly be database tuning as SQL really should be tuned at the development stage, with information passed back from the production DBA) documentation of all procedures space management on production systems, including capacity planning and projection of growth change management monitoring external data loads into production database health checks on production database application dba -- responsible for all databases in which developers have access. responsibilities: SQL tuning (not SQL coding!) database design, in conjunction with the developers any and all changes to the application schema working with the production DBA to ensure production performance (see SQL tuning!) backups (these might be weekly offline backups, as development is usually less critical but then again maybe not) as deadlines creep closer, the weekends off may not
RE: Bind Variable values
Dennis (or anyone else) I remember these values of 1,4,8,12 but the SQLab tuner from quest insists on doing the 10046 trace at level 15, are there any more hidden levels that we don't know of? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
Re: So, What is a 'Production DBA'?
Beware of developers that carry screwdrivers. Its a hardware problem, not software. -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 5/30/02, Thomas Day [EMAIL PROTECTED] wrote: I guess it's that old Russian proverb To a hammer, all the world looks like a nail. Developers have experience as hammers and everything revolves around the code. As an ex-developer, now DBA, I know that sometimes you need a screwdriver (or a Harvey Wall Banger). Jay Wade fish_dbaTo: Multiple recipients of list ORACLE-L @hotmail.com[EMAIL PROTECTED] Sent by: rootcc: Subject: Re: So, What is a 'Production DBA'? 05/30/2002 11:08 AM Please respond to ORACLE-L I feel that it is hard to draw the lines between Application and Production DBA's. For example where would you place the DBA that maintains SAP? Without the application knowledge he/she/it wouldn't get very far. Also I have been wondering something and this thread seems a good place to ask. Is there a historical feud between DBA's and Developers? Coming from a consulting/software house I find some of the comments funny but can't believe that there is that quantity of bad developers. Most of the DBA's we deal with have come up through the ranks and started as developers. From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: So, What is a 'Production DBA'? Date: Thu, 30 May 2002 04:48:29 -0800 Rachel, I agree with your short list of the areas of responsibilities but I would change the word application to development. An application DBA, from the people I have talked to, is quite busy performing the upgrades and patches that accompany the Oracle Applications. The applications database generally has many, many tables, triggers and constraints and is constantly the target for upgrades and patches from Oracle. It is a time consuming task as the majority of the different applications (financial, HR, Purchase Order, etc) have hooks into each different package and are so intertwined that any small fix in one involves patches for the others. There are only a few user defined tables as each package has their own named tables that are partially shared between packages. There is very little if any work you can do on the application code because it is so intertwined and customized when it is installed. Any upgrades require that the customization be reworked to make it fit into the new version of the application package. It takes a longer time to install than a standard database, on the magnitude of days, and requires a dedicated and investigative mind set to maintain. To the list you created I would add: Help desk call recipient, network support, client support, software and hardware evaluation, whipping post, IT team member (possibly team leader), self driven, office coffee maker, consumer of various liquids. Ron ROR mª¿ªm [EMAIL PROTECTED] 05/29/02 04:50PM that's not a bad definition :) seriously, everyone will have their own definition, mine is: production dba -- responsible for all databases that are considered production. this includes but is not limited to: backups recovery testing contingency testing production performance tuning (should mostly be database tuning as SQL really should be tuned at the development stage, with information passed back from the production DBA) documentation of all procedures space management on production systems, including capacity planning and projection of growth change management monitoring external data loads into production database health checks on production database application dba -- responsible for all databases in which developers have access. responsibilities: SQL tuning (not SQL coding!) database design, in conjunction with the developers any and all changes to the application schema working with the production DBA to ensure
RE: So, What is a 'Production DBA'?
I'd take that pay differential thing with a grain of salt. The definitions for Production DBA's, Apps, DBA's, and Development DBA's are merely organizational interpretations. Each organization custom creates these titles so PHB's can put labels on people. In many cases a production DBA is merely a database babysitter and a Development/Apps DBA requires higher skills for the overall architecture. In other cases an apps DBA may just be someone who knows how to maintain a particular 3rd party application but their knowledge of the database engine is suspect. I once knew an HR Database Administrator, AKA Apps DBA, who knew nothing about databases but lots about some weird, off the wall, non-mainstream, proprietary HR application. This person's skills were not marketable but their title was. ;-) Aspiring chief cook and bottle washer, Steve Orr -Original Message- Sent: Thursday, May 30, 2002 10:06 AM To: Multiple recipients of list ORACLE-L Thanks to all who responded. The debate on the list is just as lively as the one around the water cooler. I did like the response about a 50% pay differential for production DBAs. That will make the bosses hair stand on end! --- Peter Barnett [EMAIL PROTECTED] wrote: We are having this debate. What is a 'Production DBA'? Right now all of the DBAs do some of everything. In an effort to focus more DBA time on infrastructure, damagement is floating the idea of Production and Applications DBAs. The DBA group has loosely translated this into the group that is always on-call and the group that gets their weekends off. I would appreciate some input from those of you who are Production DBAs. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Using DUAL
Dual is often used for tasks that can easily be done without making a full roundtrip to the database, not to mention network traffic. Such as getting the system date, the user name, determining basic logic that can be done without going to the database. Regards Melanie -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 30, 2002 11:23 AMTo: Multiple recipients of list ORACLE-LSubject: Using DUAL The developers here have a fondness for usingDUALfor simple operations (select count(*) from dual is executed 1+ times per day). I recall a passing comment somewhere/sometime that there are performance issues with accessingDUAL. Of course, now that I need to provide some information to the developers, I can't recall the comment or find documentation. Any assistance is greatly appreciated. Daniel W. Fink
RE: rman duplicate dbid?
found a note on metalink about how to change the dbid by recreating the controlfile (note 174625.1) . . . one of those notes with the lovely disclaimer about how the script is not supported by Oracle support, done at your own risk, don't try this on a production db, etc. . . . anyway, it worked just fine and I was able to register the second db in the catalog. why would it give me more flexibility to use a separate catalog for each prod database? (also, we're a dev shop - only db's in use here are for app dev and qa) any and all thoughts are appreciated tx -Original Message- Sent: Thursday, May 30, 2002 12:11 PM To: Multiple recipients of list ORACLE-L Bill Perhaps you created one by cloning it from the other one. This can change the SID, but won't change the DB_ID. RMAN can't deal with multiple instances with the same DB_ID. The simplest way around this is to create a separate RMAN catalog for one of them (just create a separate username). Actually, I'm becoming convinced that maybe the way to go is to create a separate catalog for each production database. This gives you more flexibility, and I haven't seem any disadvantages to this. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 30, 2002 9:59 AM To: Multiple recipients of list ORACLE-L I'm just starting to set up RMAN (8.1.7+) . . . I'm registering all of my databases one by one from the command line. I have two db's on the same solaris box and when I run the rman command they both show up with the same DB_ID, thus preventing me from registering both of them . . . I get an error when registering the second that it's already registered. they are distinct db's . . . I tried unregistering one and then retrying, and again I get the same DBID for both. any ideas? thanks, y'all -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: So, What is a 'Production DBA'?
Gene - C'mon ya gotta give us more details. I have heard that most DBAs either come from developers or sys admins, but I can't recall a former sys admin, or maybe they just didn't mention it. I am curious about your observations on the best and worst qualities of each variety. I feel that a former developer might make a better development DBA because he/she might understand things from the developer's perspective. I could see where it might take a developer turned production DBA awhile to understand a systems perspective. If the developer only created code on a PC, it might take awhile to really get a system-wide perspective (or never). Maybe you'll give me a better appreciation for my sys admin. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 30, 2002 11:11 AM To: Multiple recipients of list ORACLE-L Actually some of the worst DBA's come from the development track. IMHO, the best DBAs are from the systems world :). Of course this doesn't mean all systems ppl make good dba's or all developers make bad dba's. This is only from my experience. Gene *Let the Wars begin, NOT* [EMAIL PROTECTED] 05/30/02 11:08AM I feel that it is hard to draw the lines between Application and Production DBA's. For example where would you place the DBA that maintains SAP? Without the application knowledge he/she/it wouldn't get very far. Also I have been wondering something and this thread seems a good place to ask. Is there a historical feud between DBA's and Developers? Coming from a consulting/software house I find some of the comments funny but can't believe that there is that quantity of bad developers. Most of the DBA's we deal with have come up through the ranks and started as developers. From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: So, What is a 'Production DBA'? Date: Thu, 30 May 2002 04:48:29 -0800 Rachel, I agree with your short list of the areas of responsibilities but I would change the word application to development. An application DBA, from the people I have talked to, is quite busy performing the upgrades and patches that accompany the Oracle Applications. The applications database generally has many, many tables, triggers and constraints and is constantly the target for upgrades and patches from Oracle. It is a time consuming task as the majority of the different applications (financial, HR, Purchase Order, etc) have hooks into each different package and are so intertwined that any small fix in one involves patches for the others. There are only a few user defined tables as each package has their own named tables that are partially shared between packages. There is very little if any work you can do on the application code because it is so intertwined and customized when it is installed. Any upgrades require that the customization be reworked to make it fit into the new version of the application package. It takes a longer time to install than a standard database, on the magnitude of days, and requires a dedicated and investigative mind set to maintain. To the list you created I would add: Help desk call recipient, network support, client support, software and hardware evaluation, whipping post, IT team member (possibly team leader), self driven, office coffee maker, consumer of various liquids. Ron ROR mª¿ªm [EMAIL PROTECTED] 05/29/02 04:50PM that's not a bad definition :) seriously, everyone will have their own definition, mine is: production dba -- responsible for all databases that are considered production. this includes but is not limited to: backups recovery testing contingency testing production performance tuning (should mostly be database tuning as SQL really should be tuned at the development stage, with information passed back from the production DBA) documentation of all procedures space management on production systems, including capacity planning and projection of growth change management monitoring external data loads into production database health checks on production database application dba -- responsible for all databases in which developers have access. responsibilities: SQL tuning (not SQL coding!) database design, in conjunction with the developers any and all changes to the application schema working with the production DBA to ensure production performance (see SQL tuning!) backups (these might be weekly offline backups, as development is usually less critical but then again maybe not) as deadlines creep closer, the weekends off may not be this is just the short list I've usually been both the production and application dba where I've worked. Rachel --- Peter Barnett [EMAIL PROTECTED] wrote: We are having this debate. What is a 'Production DBA'? Right now all of the DBAs do some of everything. In an effort to focus more DBA time on infrastructure, damagement is floating the idea of
RE: Using DUAL
Oracle Perf Tuning by O'Reilly mentions it, but without explanation: http://www.oreilly.com/catalog/oracle2/chapter/ch10.html There's more, too. Try searching for dual performance iterative OR loop oracle on google.com HTH! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, May 30, 2002 11:23 AM To: Multiple recipients of list ORACLE-L The developers here have a fondness for using DUAL for simple operations (select count(*) from dual is executed 1+ times per day). I recall a passing comment somewhere/sometime that there are performance issues with accessing DUAL. Of course, now that I need to provide some information to the developers, I can't recall the comment or find documentation. Any assistance is greatly appreciated. Daniel W. Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Bind Variable values
Raj: Level 15 (or level 100 or 200!!) is level 12 only. Anything above level 12 is considered as level 12/ Best Regards, K Gopalakrishnan - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 10:13 PM Dennis (or anyone else) I remember these values of 1,4,8,12 but the SQLab tuner from quest insists on doing the 10046 trace at level 15, are there any more hidden levels that we don't know of? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 changes the sequence no for the redologs
Dennis, I beg to differ with you on this issue. To keep the naming convention simple for the logs and to be able to differentiate between different instances logs, you may have to use 4 characters plus the sequence number for the log name. as an example PRDA+seq.log and PRDB+seq.log. If the OS does NOT allow long names the logger will halt after the sequence . It would be nice to just reset the logs to 0001 and move along its merry way. I learned this fact this weekend when the logs reached on a Novell os (admin stated that the long names was enabled). I had to change the log naming convention to PRA+seq.log and the problem was corrected. Now I monitor the log sequence closely and will rename again if needed. Ron ROR mô¿ôm [EMAIL PROTECTED] 05/29/02 06:28PM Sarath - Only an incomplete recovery resets the logs, whether you are on Oracle 7 or Oracle 8i. Essentially you pay the big license fees to Oracle to prevent that from occurring any more than it possibly needs to. I'm not sure why you want the sequence reset. Just for neatness? You have many years before the sequence is exhausted. Be patient, your life as a DBA isn't likely to always be this boring. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 29, 2002 5:10 PM To: Multiple recipients of list ORACLE-L dear list, i have log sequence no like log%t_1_%s ie logTTM_1_001158967 logTTM_1_001158968 logTTM_1_001158969 logTTM_1_001158970 logTTM_1_001158971 logTTM_1_001158972. i can i reset the logs to logTTM_1_1 logTTM_1_2 and so on. i am on 7.3.4 when i give alter database open resetlogs it is not working. Sarath __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sarath kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rman duplicate dbid?
Bill - Glad that method of changing the db_id worked for you. The advantages I see for separate RMAN catalogs are: - If you need to upgrade the target database, you can do that without affecting the other databases. For example, if the upgrade requires a change to the catalog schema, you can just change it for that database without worrying about it affecting the other databases. - If you bollix up the catalog, in the worst case you clear it out and start fresh. You probably limit the damage to a single schema/target database. - In the development scenario, databases come and go. I can't recall an RMAN command like delete all traces of a database. But you can export and drop the schema. - You may decide to relocate the catalog for a database to another instance and/or host. Separate catalogs give you this flexibility. - My systems people like the philosophy of a backup tape(s) containing everything you need to recreate the system. I can run the backup to disk, export the RMAN catalog schema and FTP it over to the target system before tape backup starts, so everything winds up on a single tape. Now I just need to prove that I can mount that tape on another system and get the database going again. - As a novice, it may be easier to review the schema tables, and if you decide to clean out some records, it is simpler. I haven't seen any downsides to having multiple catalogs, but would appreciate if anybody knows of any. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 30, 2002 11:51 AM To: Multiple recipients of list ORACLE-L found a note on metalink about how to change the dbid by recreating the controlfile (note 174625.1) . . . one of those notes with the lovely disclaimer about how the script is not supported by Oracle support, done at your own risk, don't try this on a production db, etc. . . . anyway, it worked just fine and I was able to register the second db in the catalog. why would it give me more flexibility to use a separate catalog for each prod database? (also, we're a dev shop - only db's in use here are for app dev and qa) any and all thoughts are appreciated tx -Original Message- Sent: Thursday, May 30, 2002 12:11 PM To: Multiple recipients of list ORACLE-L Bill Perhaps you created one by cloning it from the other one. This can change the SID, but won't change the DB_ID. RMAN can't deal with multiple instances with the same DB_ID. The simplest way around this is to create a separate RMAN catalog for one of them (just create a separate username). Actually, I'm becoming convinced that maybe the way to go is to create a separate catalog for each production database. This gives you more flexibility, and I haven't seem any disadvantages to this. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 30, 2002 9:59 AM To: Multiple recipients of list ORACLE-L I'm just starting to set up RMAN (8.1.7+) . . . I'm registering all of my databases one by one from the command line. I have two db's on the same solaris box and when I run the rman command they both show up with the same DB_ID, thus preventing me from registering both of them . . . I get an error when registering the second that it's already registered. they are distinct db's . . . I tried unregistering one and then retrying, and again I get the same DBID for both. any ideas? thanks, y'all -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--
How do I parse information from a Column
Hi, I am capturing data from v$sqlarea to a table to find out all the query activities on a database. Now I would like to parse sql_text column from a table to get only DML commands(SELECT, INSERT, UPDATE and DELETE) and also FROM clause to get table names. The example is: SELECT cuid,usid,cufirstname,culastname,cushipfirstname,cushiplastname,cushipaddress1,cushipaddress2,cushiphomephone,cuemail,cushipcareof,cushipcity,cushipstate,cushippostalcode,cuadcode,cubilltiid,cuaddress1,cuaddress2,cucity,custate,cupostalcode FROM tblCustinfo WHERE UsID=234563245 Muqthar Ahmed Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: So, What is a 'Production DBA'?
So true! Its different in each organization. Titles change but jobs do not :). [EMAIL PROTECTED] 05/30/02 12:51PM I'd take that pay differential thing with a grain of salt. The definitions for Production DBA's, Apps, DBA's, and Development DBA's are merely organizational interpretations. Each organization custom creates these titles so PHB's can put labels on people. In many cases a production DBA is merely a database babysitter and a Development/Apps DBA requires higher skills for the overall architecture. In other cases an apps DBA may just be someone who knows how to maintain a particular 3rd party application but their knowledge of the database engine is suspect. I once knew an HR Database Administrator, AKA Apps DBA, who knew nothing about databases but lots about some weird, off the wall, non-mainstream, proprietary HR application. This person's skills were not marketable but their title was. ;-) Aspiring chief cook and bottle washer, Steve Orr -Original Message- Sent: Thursday, May 30, 2002 10:06 AM To: Multiple recipients of list ORACLE-L Thanks to all who responded. The debate on the list is just as lively as the one around the water cooler. I did like the response about a 50% pay differential for production DBAs. That will make the bosses hair stand on end! --- Peter Barnett [EMAIL PROTECTED] wrote: We are having this debate. What is a 'Production DBA'? Right now all of the DBAs do some of everything. In an effort to focus more DBA time on infrastructure, damagement is floating the idea of Production and Applications DBAs. The DBA group has loosely translated this into the group that is always on-call and the group that gets their weekends off. I would appreciate some input from those of you who are Production DBAs. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Dblink - How to connect two databases
Title: RE: Dblink - How to connect two databases Not sure what you're trying to accomplish, that is, remote query or remote update OR are you just trying to connect to another DB? If you're trying to perform a remote query and you've created a dblink from DB1 pointing to DB2, then you just do the following (from DB1): select column_name from table_name@dblink_name; -Original Message- From: Zsolt Csillag [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 11:48 AM To: Multiple recipients of list ORACLE-L Subject: Dblink - How to connect two databases Hi, I'd like to connect from one database to another.(both are 9i) One has a fix Ip address. In this database I made a dblink object. How can I connect to it from the other database? Do I have to make a connection from Net Manager? Please help me! Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Zsolt Csillag INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: So, What is a 'Production DBA'?
A Harvey Wall Banger? I've never heard of that type of hammer before :) -Original Message- Sent: Thursday, May 30, 2002 12:36 PM To: Multiple recipients of list ORACLE-L I guess it's that old Russian proverb To a hammer, all the world looks like a nail. Developers have experience as hammers and everything revolves around the code. As an ex-developer, now DBA, I know that sometimes you need a screwdriver (or a Harvey Wall Banger). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
CAPACITY planning
Hi Is any additional benefit in terms of performance in Oracle9i? Does any one have documents on capacity planning? Thx -Seema _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- 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: move the production database from one machine to another
We decided not to upgrade Oracle in order to reduce the variables at this time. We are only licensed to Standard Edition so standby is not an option. -Li -Original Message- Sent: Thursday, May 30, 2002 8:59 AM To: Multiple recipients of list ORACLE-L On Wed, May 29, 2002 at 09:13:25PM -0800, Jeremiah Wilton wrote: On Wed, 29 May 2002, Ray Stell wrote: It is not supported as an upgrade process. Oracle does not support prod at 8.1.7.0 and standby at 8.1.7.2. I think this is a real crime, since it would be a great feature to lower downtime. Why? Because of some local operational issues. I am required to have multiple servers for redundancy and I can schedule query only time which is not equal to sla downtime. This window could be used to rebuild the dictionary on an activated standby. The fact that it works fine and Oracle doesn't support it makes me whine, sometimes in plubic. I guess I wouldn't suggest that Li Zhang upgrade both server and oracle at the same time, anyway. It takes almost no time to shut down an 8.1.7.0 instance and start it up on an 8.1.7.2 ORACLE_HOME on the same server. The part that takes a long time is re-running catalog, catproc, etc., which I've never understood why you have to do, and which you have to do with the database open and only you logged in. You shouldn't need a standby to perform a fast upgrade even in a supported manner. Rerunning catalog and catproc takes much too long. Oracle should figure out the small number of objects that need to be recompiled under a new binary and provide a script with just those in it. Rerunning everything is a waste of time, and resources, and is disruptive as well. Anyway, since the log format of 8.1.7.0 is the same as 8.1.7.2, there should be no real problem running the standby in this mode, which I'll take you word for it is unsupported. The question is, why would someone do it? Disk space for ORACLE_HOME? An extra disk is probably cheaper than a whone second server for a standby. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, May 29, 2002 at 03:53:32PM -0800, Li Zhang wrote: The company I am working for is planning to move the whole production server to a new faster box. As DBA, I will move the database and planning to use hot backup files in order to minimize the production server down time. Are there any issues or drawbacks I need to be aware of if the hot backup files are used to replicate the database? This is 8.1.7 on Solaris 2.7 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Li Zhang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: So, What is a 'Production DBA'?
I know I'm probably going to regret replying to this thread. I'm one of those people who spent years as a programmer...and wound up somewhere in between applications and tech support because I couldn't get the tech support I needed. When we got SAP'd in '93, I finally gave in to becoming a so-called DBA to keep the legacy systems running (not Oracle based) AND keep the SAP project afloat. So I'm probably one of those SAP babysitters. I would love to be able to hire a development or applications DBA (we also have non-SAP Oracle databases) but the skill set I need in an individual to actually reduce my work load is much broader than the typical Oracle development or applications person. I know there can be exceptions, of course, but I haven't found development or applications people to be too concerned about the context in which a database lives let alone know what IT auditors would be looking for. I mean, the role I play doesn't seem to have any technical boundaries because, again, anything that can impact the application (be it SAN, OS, network, presentation layer, security, hardware, maybe even Sun spots...) is of concern to me. On the other hand, a DBA without an understanding of the demands put on developer/applications people is a problem, too. Or maybe I needed to whine a bit because I've been up at 2am and 5am a couple of days in a row. Sleepless in California, Kip Bryant |I'd take that pay differential thing with a grain of salt. |The definitions for Production DBA's, Apps, DBA's, and Development DBA's are |merely organizational interpretations. Each organization custom creates |these titles so PHB's can put labels on people. |In many cases a production DBA is merely a database babysitter and a |Development/Apps DBA requires higher skills for the overall architecture. In |other cases an apps DBA may just be someone who knows how to maintain a |particular 3rd party application but their knowledge of the database engine |is suspect. I once knew an HR Database Administrator, AKA Apps DBA, who |knew nothing about databases but lots about some weird, off the wall, |non-mainstream, proprietary HR application. This person's skills were not |marketable but their title was. ;-) |Aspiring chief cook and bottle washer, |Steve Orr |-Original Message- |Sent: Thursday, May 30, 2002 10:06 AM |To: Multiple recipients of list ORACLE-L |Thanks to all who responded. The debate on the list |is just as lively as the one around the water cooler. |I did like the response about a 50% pay differential |for production DBAs. That will make the bosses hair |stand on end! |--- Peter Barnett [EMAIL PROTECTED] wrote: | We are having this debate. What is a 'Production | DBA'? Right now all of the DBAs do some of | everything. In an effort to focus more DBA time on | infrastructure, damagement is floating the idea of | Production and Applications DBAs. The DBA group has | loosely translated this into the group that is | always | on-call and the group that gets their weekends off. | | I would appreciate some input from those of you who | are Production DBAs. | | | | = | Pete Barnett | Lead Database Administrator | The Regence Group | [EMAIL PROTECTED] |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.com |-- |Author: Orr, Steve | INET: [EMAIL PROTECTED] |Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 |San Diego, California-- Public Internet access / Mailing Lists | |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(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: so when did you switch from NT to unix for oracle
Hi Rafiq, I'll let him know :). From the great, great hospitality shown by Steve to Jonathan, Cary, Anjo, Howard, me and others this week here at the Database Forum I think it's safe to say that Steve is fine - but busy. Steve is a very impressive guy in many ways. But I guess he has to prioritise in order to make ends meet. He's also extremely helpful, so I don't think he's quitting lists like this one without being forced to :). Maybe - maybe - Steve will attend the Database Forum in Denmark in September. But he certainly will run the 3-day Miracle Master Class 2003 in January 2003 in Denmark. That should rock! Best regards, Mogens Mohammad Rafiq wrote: Mogens How is Steve Adam himself? Like other listers I am feeling his absence very much from this list. You may request on my behalf(or on behalf of other listers like myself) that he must participate in this list... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Mon, 27 May 2002 09:18:20 -0800 Maybe it's time to provoke a bit :-). Situation: I'm sitting here in Steve Adams' house (about 7 meters away from the IxOra server, which is SO small - just like the LITTLE mermaid in Copenhagen - very disappointing), and Anjo, Cary, Jonathan and the rest have gone to bed. Whiskies available on the oak table: Bowmore and Ardbeg. Provocative Thoughts (aimed at generating discussion, please): Basically a P4 processor can run circles round a Unix processor today (in other words: Unix processors are loosing the battle). A customer today would get most bang for the buck by bying Intel instead of Unix processors. The problem, of course, is that you can only choose between Windows and Linux on the Intel platform. If - this is no longer a choice - you could choose Solaris on Intel, you would get so much bang for the buck that nothing could compete with it. If Intel could handle many processors that would be interesting, too. I think Unix processors are dying. I didn't like it when VMS died (because it's the best operating system that was ever built). But it died. Now what? Mogens Hemant K Chitale wrote: Aah ! You _are_ looking at moving out of NT. Why I don't think it is an enterprise class platform 1. Much poorer memory management [2GB, memory leaks etc] than Unix. 2. Cannot scale beyond 4 CPUs. I AM surprised that you run a 450 users SAP application on 4CPU, 2GB on NT. Try that with Oracle Applications ! 3. Any patch (e.g. the security patches that come out from Microsoft) requires a reboot of the server. I can understand OS patches requiring a Unix reboot but a patch to MSIE/Outlook/IIS on the same NT-box as the database requiring a reboot of the server ? Unacceptable. 4. I don't know how good Online Backups are on NT. Hemant K Chitale http://hkchital.tripod.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, 25 May, 2002 4:33 AM 1) Not pulling any legs. That's what we run. 2) We have a few reasons to switch to another platform. I'm lobbying for Solaris with Veritas Database Edition. Many good reasons for doing so, but I'm beginning to have my doubts about financing it. One of our current projects is to put in place an enterprise class backup and recovery system. The current one is lacking in several respects. One of damagement's questions: What happens if we do nothing? Another was What's the ROI? PHB's abound. Jared On Friday 24 May 2002 08:03, Hemant K Chitale wrote: No way ! You're pulling a lot of legs [and hurting a lot of egos who take pride in pointing out that NT is _not_ an enterprise-class platform, me included]. Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, 24 May, 2002 8:00 AM How about 250 Gig, 450 users on SAP 4.0B? 4 Cpu's 2 Gig Ram. Stop making me defend NT!! Jared Disser, Arno [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/23/2002 10:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: so when did you switch from NT to unix for oracle Here are my 0.02EUR Turn this reasoning around: Why would anyone use NT for a serious Oracle DB-server? Okay, for some minor development perhaps, but for an production environment? b.t.w., ever considered a switch to VMS? Arno Disser -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Disser, Arno INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of
Re: SAN Implementation
I personally love James Morle's Sane SAN paper available on for instance www.OraPerf.com. James is cool and knows what he's talking about. I used to say with pride that James is the guy who wrote the book which is placed in my bathroom. Turns out that while we've been away for the Database Forum here in Sydney, Bjorn Engsig has replaced it with Jonathan's book. I should add that there's been a lot of protest over that from the OakTable members. They want both of the books there... possibly along with Tom Kyte's book, of course... But seriously: Get James' paper. If you have questions about it, email him. He responds. Nikunj Gupta wrote: Hello Group / Guru's Anyone has White Paper on SAN, it Implementation especially with ORACLE ?? Any thought, personal experience with pros and cons will be highly appreciated. TIA Enlighten Me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?ISO-8859-1?Q?N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Jr.DBA, Mid level DBA, Sr.DBA
Hello: Out of curiosity how would you classify a Jr. DBA, a Mid Level DBA, and a Sr. DBA? I know how our HR department makes the division but would be interested in knowing how other people might classify the differences. Regards, Jay _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TUNE DB
Hi The following are top5 wiat events in my database? Total TotalTime Avg WaitsTimeouts Waited% of Wait Event Name (in 1000s) (in 1000s) (in Hours) Concern (Secs) -- --- --- --- --- virtual circuit status8,248.75 282.512,552.01 54.95 dispatcher timer 30,900.42 15,714.381,825.41 39.30 single-task message 26,299.17 50.72 156.763.38 log file sync 3,757.66 15.98 72.021.55 control file parallel writ 702.020.00 10.860.23 I increase shared server also.Let me know group view what to do please? Thx -Seema _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- 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: Bind Variable values
That explains it ... I thought quest guys knew something that we didn't know about. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Thursday, May 30, 2002 1:09 PM To: Multiple recipients of list ORACLE-L Raj: Level 15 (or level 100 or 200!!) is level 12 only. Anything above level 12 is considered as level 12/ Best Regards, K Gopalakrishnan *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: So, What is a 'Production DBA'?
There is a definite need for people with detailed knowledge of mission critical apps and it's optimal when DBA's and System Admins are wired in! the role I play doesn't seem to have any technical boundaries Boundaries are things that aggressive DBA's want to break through. They intrusively stick their noses into development, systems admin, networks, and applications. Why? Because it affects database performance. Since the database touches so much it only stands to reason that DBA's stretch and challenge the boundaries. Here's a link from Oracle Magazine that addresses this at some length. http://www.oracle.com/oramag/oracle/99-Mar/index.html?29cov.html Steve Orr Former Californian well rested in Montana -Original Message- Sent: Thursday, May 30, 2002 11:57 AM To: Multiple recipients of list ORACLE-L I know I'm probably going to regret replying to this thread. I'm one of those people who spent years as a programmer...and wound up somewhere in between applications and tech support because I couldn't get the tech support I needed. When we got SAP'd in '93, I finally gave in to becoming a so-called DBA to keep the legacy systems running (not Oracle based) AND keep the SAP project afloat. So I'm probably one of those SAP babysitters. I would love to be able to hire a development or applications DBA (we also have non-SAP Oracle databases) but the skill set I need in an individual to actually reduce my work load is much broader than the typical Oracle development or applications person. I know there can be exceptions, of course, but I haven't found development or applications people to be too concerned about the context in which a database lives let alone know what IT auditors would be looking for. I mean, the role I play doesn't seem to have any technical boundaries because, again, anything that can impact the application (be it SAN, OS, network, presentation layer, security, hardware, maybe even Sun spots...) is of concern to me. On the other hand, a DBA without an understanding of the demands put on developer/applications people is a problem, too. Or maybe I needed to whine a bit because I've been up at 2am and 5am a couple of days in a row. Sleepless in California, Kip Bryant |I'd take that pay differential thing with a grain of salt. |The definitions for Production DBA's, Apps, DBA's, and Development DBA's are |merely organizational interpretations. Each organization custom creates |these titles so PHB's can put labels on people. |In many cases a production DBA is merely a database babysitter and a |Development/Apps DBA requires higher skills for the overall architecture. In |other cases an apps DBA may just be someone who knows how to maintain a |particular 3rd party application but their knowledge of the database engine |is suspect. I once knew an HR Database Administrator, AKA Apps DBA, who |knew nothing about databases but lots about some weird, off the wall, |non-mainstream, proprietary HR application. This person's skills were not |marketable but their title was. ;-) |Aspiring chief cook and bottle washer, |Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: updated rows count
Create After update trigger on table assethdr. And let the trigger insert ROWID of changed rows in other table. And you can always do SELECT DISTINCT ROW_ID FROM my_spy_table_with_rowids :-] JP - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 3:48 PM Hi All! My client run big update 20,000 statements. I need to know how many rows was updated (it's could be any number). I thinking about triggers , but this table can be updated not only with this big update. Other users can update rows too. I need to know updated rows number just for this big update. Thanks. update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty=850, atcapun=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.43GB', atus1='05/20/2002' where ataltnbr='0296'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Urgent: Prodution database recovery
Thanks David, You hit the nail on the head. Hardware problems are preventing the backup files from restoring normally. We've got several hardware experts on site this morning going over the disk/filesystem with a fine-tooth comb. File header dump shows file_id mismatch which disappeared in 2 instances when the files were re-restored. Mike -Original Message- To: Multiple recipients of list ORACLE-L Sent: 5/30/02 6:03 AM Don't know whether this is of any use, but could it be that you still have a hardware fault that is causing your restore to become corrupted? Regards David Lord -Original Message- From: Hand, Michael T [mailto:[EMAIL PROTECTED]] Sent: 30 May 2002 10:23 To: Multiple recipients of list ORACLE-L Subject: Urgent: Prodution database recovery Env: 8.1.7.3 Compaq Alpha Tru64 5.1a An apparent hardware problem caused corrupt blocks ora-600 [12700] to be detected. Analyze table validate structure confirmed this error. We started a PITR to a time before the errors were detected. All datafiles were restored (file copy took ~7.5hrs [614Gb]), current control files redo logs (10 groups / 2 members). But when the alter database recover database until time 'xxx' is issued, a corrupt header is detected in one of the datafiles (ora1122/1251). Now this is a disk mirror split backup. We've used this process to create a reporting database copy for years and the reporting copy was build cleanly from the same source several hours after the backup copy. DBverify against the split backup copy and against the restored file (with the corrupt header) detect no errors but return diffent results for used/free/other blocks. Now, this first attempt at recovery opened about 1/3 of the datafiles. My thought was to restore these ~100 datafile again and retry the recovery. Right now I'm a little bleary-eyed so any suggestions would be welcome. Thanks, Mike Hand Polaroid Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This message (including any attachments) is confidential and may be legally privileged. If you are not the intended recipient, you should not disclose, copy or use any part of it - please delete all copies immediately and notify the Hays Group Email Helpdesk at [EMAIL PROTECTED] Any information, statements or opinions contained in this message (including any attachments) are given by the author. They are not given on behalf of Hays unless subsequently confirmed by an individual other than the author who is duly authorised to represent Hays. A member of the Hays plc group of companies. Hays plc is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help with SQL Aggregate Functions
You probably hit the following bug!!! Doc ID: Note:71232.1 Subject: OERR: ORA-24347 Warning of a NULL column in an aggregate function Bug:1149002 SQLPLUS treated this warning as an ERROR Lisa R. Clary To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: edu Subject: RE: Help with SQL Aggregate Functions Sent by: [EMAIL PROTECTED] om 05/30/2002 01:57 PM Please respond to ORACLE-L Here is the query re-write that works--basically just moved the group by to its own select. The only thing that would prevent the error message was to remove the count(). REWRITTEN code below that works--still don't have an answer for the original question. select s.study_id, s.strat_code, s.short_name, nvl(o.total,0) TOTAL from (select count (*) total, study_id, stratum from on_study group by study_id, stratum) o, regdba.reg_stratum s, regdba.study y where y.stat_center_code in (1,7) and s.study_id = o.study_id(+) and s.study_id = y.study_id and s.strat_code = o.stratum (+) order by s.study_id desc, s.strat_code; -Original Message- Clary Sent: Thursday, May 30, 2002 1:24 PM To: Multiple recipients of list ORACLE-L I am having a hard time understanding why removing the line
RE: how to change a foreign key back to a primary key.Thank You.
Richard and Igor, Thank you both for your quick answers. I do appreciate it very much.The statements work well. Again, thanks for your help. Trang Richard Huntley [EMAIL PROTECTED] wrote: Trang, How about: alter tableTABLE_NAME drop constraint CONSTRAINT_NAME; alter table TABLE_NAME add constraint pk_TABLE_NAME primary key (COLUMN) using index tablespace indexes; -Original Message-From: Meomeo Nguyen [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 29, 2002 7:06 PMTo: Multiple recipients of list ORACLE-LSubject: how to change a foreign key back to a primary key Hi, I need to change aforeign key back to a primary key in a table. How do I do that. Please help. Thanks in advance. Trang Do You Yahoo!?Yahoo! - Official partner of 2002 FIFA World Cup Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup
Re: So, What is a 'Production DBA'?
Hello Dennis My path: Computer operator, duveloper, system programmer, DBA. About developers: they do not see the whole picture, do not understand limitations etc.. I had a call from the guy who is charge of a project. The database creates about 10 MB of archive logs every 3-4 minutes, and is on remote site. He come over to discuss the possibility of implementing a stand by database at our main site. When I asked him the bank width to the remote site he told me: fast, 256KBps. A simple calculation was enough to explain to him that he creates much more data then the pipe line can carry. Boy was he suprised. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 6:51 PM Gene - C'mon ya gotta give us more details. I have heard that most DBAs either come from developers or sys admins, but I can't recall a former sys admin, or maybe they just didn't mention it. I am curious about your observations on the best and worst qualities of each variety. I feel that a former developer might make a better development DBA because he/she might understand things from the developer's perspective. I could see where it might take a developer turned production DBA awhile to understand a systems perspective. If the developer only created code on a PC, it might take awhile to really get a system-wide perspective (or never). Maybe you'll give me a better appreciation for my sys admin. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 30, 2002 11:11 AM To: Multiple recipients of list ORACLE-L Actually some of the worst DBA's come from the development track. IMHO, the best DBAs are from the systems world :). Of course this doesn't mean all systems ppl make good dba's or all developers make bad dba's. This is only from my experience. Gene *Let the Wars begin, NOT* [EMAIL PROTECTED] 05/30/02 11:08AM I feel that it is hard to draw the lines between Application and Production DBA's. For example where would you place the DBA that maintains SAP? Without the application knowledge he/she/it wouldn't get very far. Also I have been wondering something and this thread seems a good place to ask. Is there a historical feud between DBA's and Developers? Coming from a consulting/software house I find some of the comments funny but can't believe that there is that quantity of bad developers. Most of the DBA's we deal with have come up through the ranks and started as developers. From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: So, What is a 'Production DBA'? Date: Thu, 30 May 2002 04:48:29 -0800 Rachel, I agree with your short list of the areas of responsibilities but I would change the word application to development. An application DBA, from the people I have talked to, is quite busy performing the upgrades and patches that accompany the Oracle Applications. The applications database generally has many, many tables, triggers and constraints and is constantly the target for upgrades and patches from Oracle. It is a time consuming task as the majority of the different applications (financial, HR, Purchase Order, etc) have hooks into each different package and are so intertwined that any small fix in one involves patches for the others. There are only a few user defined tables as each package has their own named tables that are partially shared between packages. There is very little if any work you can do on the application code because it is so intertwined and customized when it is installed. Any upgrades require that the customization be reworked to make it fit into the new version of the application package. It takes a longer time to install than a standard database, on the magnitude of days, and requires a dedicated and investigative mind set to maintain. To the list you created I would add: Help desk call recipient, network support, client support, software and hardware evaluation, whipping post, IT team member (possibly team leader), self driven, office coffee maker, consumer of various liquids. Ron ROR mª¿ªm [EMAIL PROTECTED] 05/29/02 04:50PM that's not a bad definition :) seriously, everyone will have their own definition, mine is: production dba -- responsible for all databases that are considered production. this includes but is not limited to: backups recovery testing contingency testing production performance tuning (should mostly be database tuning as SQL really should be tuned at the development stage, with information passed back from the production DBA) documentation of all procedures space management on production systems, including capacity planning and projection of growth change management monitoring external data loads into production database health checks on production database application dba -- responsible for all databases in which developers have access.