Quest....
Hey Any thoughts on that quest material? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 630.819.9077 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: **BLOCKED-BY-IHATESPAM** Upgrade
Alavi, It amazes me Please read the Oracle8i Upgrade manual and you will know all you need to know. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 1/5/2004 11:24 AM Dear List, I want to upgrade from 8.1.5 to 8.1.7 on windows 2000 what's the safest way to do this upgrade. If any body knows any url or have any kind of document it would be very helpful. Thanks happy new year to all of you. Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ** can two processes use the same rollback extent
1)rollback segment will not shrink. Correct, assuming you do not shrink it manually. 2)It will keep growing till tablespace fills up. Correct assuming that you have a SQL statement that causes the rollback segment to grow in such a way and that you have no constraints on the rollback segments to prevent unconstrained growth (e.g. maxextents). Note that this may not be a good thing... if you have one transaction that causes one rbs to grow really large, that may prevent growth of other rbs's. Unless you are manually assigning rollback segments to every transaction, that could have negative consequences. It is, IMHO, best to have use automated undo, if possible, then you don't need to worry about these things. If you can't use automated undo, then create a nice big tablespace, but also use optimal, setting it to a reasonable size. 3)And there will be no 'snapshot too old' errors? Wrong. Even with large rollback segments, 1555's are possible depending on a number of things. Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 630.819.9077 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -Original Message-From: A Joshi [mailto:[EMAIL PROTECTED]Sent: Sunday, December 28, 2003 12:39 AMTo: Multiple recipients of list ORACLE-LSubject: Re: ** can two processes use the same rollback extent Hi, A simple rollback segment question. If I do not set a optimal thencan I assume following 1)rollback segment will not shrink. 2)It will keep growing till tablespace fills up. 3)And there will be no 'snapshot too old' errors? ThanksA Joshi [EMAIL PROTECTED] wrote: Hi, One rollback segment can be used by multiple transactions/processes but what about the extents? Is it safe to assume that only one transaction/process can use one extent? What is a good way to size the extent for warehousing tasks? Or guess the rollback generated and size needed. Thank You Do you Yahoo!?Protect your identity with Yahoo! Mail AddressGuard Do you Yahoo!?Protect your identity with Yahoo! Mail AddressGuard
RE: RMAN - the time has come
We have talked about a 10g version of the book, which I'm sure will happen at some point in time :-) Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/22/2003 2:39 PM Try Robert Freeman's book. I have only heard good things about it. Ruth -Original Message- Jamadagni, Rajendra Sent: Monday, December 22, 2003 10:35 AM To: Multiple recipients of list ORACLE-L Okay, its time to bite the bullet ... time to learn RMAN. Outside of TFM (which I just started reading), are there any good books/articles on RMAN? I know there is one by RFreeman, and it is for 9i (Robert, will there be a 10g version?) Yeah, I am also google'ing, taeoma'ing and in general stfw'ing whenever time permits. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! ** 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. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Who are certified Oracle Masters?
spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Who are certified Oracle Masters?
As I recall Rich talking about it, he did indeed take the exam. It was not just handed to him. Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/11/2003 3:59 PM you mean niemic didnt actually have to take the test? It was just handed to him? who is jeremiah wilton? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 4:09 PM IIRC, Tanel did the OCM as well, but I suspect most of the others on your list aren't prepared to waste their time attending OCP exams and courses just so they can get the OCM. :) There were some honorary OCM's announced when the program first started (OOW2002?). From memory, Rich Niemic and Jeremiah Wilton are the only names that spring to mind from that group. Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Mladen Gogala Sent: Friday, December 12, 2003 7:54 AM To: Multiple recipients of list ORACLE-L I know only of Pete Sharman. Who are other Oracle Certified Masters on this group? I suspect Tanel to be one, as well as Steve Adams, Cary Millsap, Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti Deshpande. Am I correct? Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 10g new features (was: dc_used_extents ,dc_free_extents and d
Excellent slide show Tanel! Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/10/2003 3:34 PM dc_histogram_defs) Pete, I'd like to clarify my position first: I don't have any burning problem that would compel me to start testing 10g. I want only to learn the new features. Btw, if you want to learn some of the 10g database engine new features (not the marketing buzzwords), then check out one of my presentations from: http://integrid.info/Poder_10g_New_Features.ppt Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 10g new features (was: dc_used_extents ,dc_free_extents and d
Doesn't matter if there's 30 or 300, you don't usually mess with them other than at database create time. Shh Oracle thinks this is a marketing coup They want to make the database look easy to manage... Parameters? Ha, you only need configure a few basic parameters and the database will take care of itself. WHEN PIGS FLY This just speaks to the general management desire to push costs down stream Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/10/2003 5:24 PM dc_histogram_defs) Much seems to be made of this 'less than 30 init parameter to tune'. Who really spends much time doing that anyway? If you do, you're probably going after the wrong end of a problem. Doesn't matter if there's 30 or 300, you don't usually mess with them other than at database create time. Jared Tanel Poder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/10/2003 01:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: 10g new features (was: dc_used_extents ,dc_free_extents and dc_histogram_defs) Pete, I'd like to clarify my position first: I don't have any burning problem that would compel me to start testing 10g. I want only to learn the new features. Btw, if you want to learn some of the 10g database engine new features (not the marketing buzzwords), then check out one of my presentations from: http://integrid.info/Poder_10g_New_Features.ppt Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Your new book
Well I got the honor of being the first to publish a review on Amazon for Cary's book it is a good read! Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 10/21/2003 2:24 PM I'll try to correct spelling errors before I post it to the Amazon, but I will do it, despite the fact that I'm not very fond of Amazon. On 10/21/2003 03:09:32 PM, Michael Milligan wrote: MLaden, Thank you very, very much for a great review. I hope you'll post that to Amazon. As a matter of fact, I enjoy queuing theory. I remember almost buying a book called Practical Queuing Analysis by Mike Tanner. I was a biology major in college, so I may muddle through the math, but it'll be good for me anyway. Thanks again for taking the time to write that great review, Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Your new book
I think so! :-) RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 10/21/2003 3:04 PM Is it (review) as good as Mladen's? -:) Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Freeman Robert - IL Sent: Tuesday, October 21, 2003 2:54 PM To: Multiple recipients of list ORACLE-L Well I got the honor of being the first to publish a review on Amazon for Cary's book it is a good read! Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 10/21/2003 2:24 PM I'll try to correct spelling errors before I post it to the Amazon, but I will do it, despite the fact that I'm not very fond of Amazon. On 10/21/2003 03:09:32 PM, Michael Milligan wrote: MLaden, Thank you very, very much for a great review. I hope you'll post that to Amazon. As a matter of fact, I enjoy queuing theory. I remember almost buying a book called Practical Queuing Analysis by Mike Tanner. I was a biology major in college, so I may muddle through the math, but it'll be good for me anyway. Thanks again for taking the time to write that great review, Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT California
Of course, you all do realize that Arnold can't be president... right? I've actually heard the talking heads talking about it like it's possible LOL Ignoramouses! RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 10/16/2003 1:29 PM Check your Latin...that's Gubernator... |How, in the world, did a man with such a poor taste in movies |build such a huge company like Oracle Corp? No wonder that Arnie |has become a guvernator of CA. BTW, has anyone here seen the |Demolition Man? It's not an Arnie movie, but the scene with the |Schwartzenegger presidential library got completely new meaning. |On 10/16/2003 01:09:32 PM, Boivin, Patrice J wrote: | I found this quote in Sillicon Valley News: | | Q U O T E D | | I'd just like to say for the record, 'Commando' is one of my | favorite | movies. | -- Oracle Chairman and Chief Executive Larry Ellison offers some | thoughts on | Arnold Schwarzenegger, California's governor-elect. | (ref. | http://www.siliconvalley.com/mld/siliconvalley/business/columnists/gmsv/ 7011 | 848.htm ) | | I wonder what's happening in California for Oracle Corp, HP's CEO is | part of | Arnold's transition team, but not much comment about Oracle in that | state. | I know about the contract controversy, maybe that's why we didn't | hear | much. | | Patrice. | | -- | Please see the official ORACLE-L FAQ: http://www.orafaq.net | -- | Author: Boivin, Patrice J | INET: [EMAIL PROTECTED] | | Fat City Network Services-- 858-538-5051 http://www.fatcity.com | San Diego, California-- Mailing list and web hosting services | - | To REMOVE yourself from this mailing list, send an E-Mail message | to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in | the message BODY, include a line containing: UNSUB ORACLE-L | (or the name of mailing list you want to be removed from). You may | also send the HELP command for other information (like subscribing). | |Mladen Gogala |Oracle DBA |Note: |This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. |Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Mladen Gogala | INET: [EMAIL PROTECTED] |Fat City Network Services-- 858-538-5051 http://www.fatcity.com |San Diego, California-- Mailing list and web hosting services |- |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cary's Book - new topic
ROTFLMAO RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 10/7/2003 4:24 PM I'm using Method R to post. On Tue, 2003-10-07 at 15:04, Wolfgang Breitling wrote: A totally different point: How come I see your response before I see my own post? At 12:39 PM 10/7/2003, you wrote: Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Unintentional Humor
or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Cary's Book - new topic
And Jared yells at ME for going Off topic!!! :-D RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 10/7/2003 4:54 PM Unfortunately it's not my ability to see into the future, but an inability to see all of the past. Now what was that I was looking for? At 03:34 PM 10/7/2003, you wrote: Wolfgang, Tuesday, October 7, 2003, 2:04:24 PM, you wrote: W A totally different point: How come I see your response before I W see my own post? Sounds like you can see into the future. Would you mind reading the Wall Street journal and reporting back to us? -rje Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Desupport of RBO
Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cary's book - Rapidly moving OT....
Mine are all from 1.5 to 2 years apart. 10 to 18 woo hoo! Of course, about 1/2 of the available women in the world run yelling when I tell them I have custody of 5 kids. Since the other 1/2 are married, that leaves me high and dry! ;-) RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 10/6/2003 12:39 PM We have 5 also. All teens now. Very scary. Braces, learning to drive, starting college. I hope yours were more spred out. Why? How? Three little girls, that's about right, then Surprise, twin boys. Uh oh. Wouldn't trade them for anything but wouldn't have planned it this way either. -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Friday, October 03, 2003 12:09 PM To: Multiple recipients of list ORACLE-L Yes, unfortunately those of us who have had the courage and accepted the responsibility of bringing children to the world have to sometimes take the bad with the good. Well I've brought my share of children into the world, thats for sure I'd wager I have more than just about anyone else here on Oracle-L in fact... Anyone have more than 5?? Also, I'm rapidly becomming a single parent, as my wife and I are divorcing after 15 years of mariage and I'm taking custody of the kids. However, I can assure you that those facts will not change my voice or it's use one jot. :-) (any single DBA ladies out there??!!) LOL. At any rate, I do choose my battles that is a lesson I learned long ago. You choose what is important to battle and what to leave behind. I used to take up every gauntlet thrown at my feet, problem was that I'd have so many battles going on that I'd loose them all Now, I pick and choose the important ones. Our future is unknown, and always born in pain, Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 10/3/2003 11:49 AM - Original Message - education and my life in general. No, until there aren't more jobs, I'll keep on the safe side. That's the part where crisis and CYA methodology jump in. I have no solution, but, unfortunately, I don't have Christ-like qualities that are asked from me in every new performance tuning book. And the blonde down the isle is so attractive. Well, at least she'll never accuse you of having an on-going issue... :) Yes, unfortunately those of us who have had the courage and accepted the responsibility of bringing children to the world have to sometimes take the bad with the good. For the sake of getting those kids out the door with a good education. Worse yet if we also have to support mums and dads way past the age where they can take care of themselves. Much worse yet if they are on the other side of the world. It's all part of that thing they call responsibility. Doesn't mean we cannot speak up. But it has to be done in a slightly different way. The art is in learning how far you can push. And where. And when. It's hard, but a few hard knocks are the best lesson. Has the role of DBA changed? Hell yeah! I've been claiming that for years, and why. But few have listened to the warning signs. Now, it's hit with a thud. Wake up call time. I agree with Robert: move to a place where you can be effective. Or change the world. Now, those of us with kids cannot afford to change the world. And even without kids, at 50 is not my idea of fun to form a union. Way past that. So, moving is the option. And all that comes with it like you pointed out: learning the ropes in the new organization. It ain't easy. Been there done that for the last 3 years. Much better now, but it was a shock. One hint: pick the organization very carefully. Last thing you want is to be outsourced... Then of course, there are those of us that were allowed to keep all their Oracle shares when they left. Real estate is the way to go. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Cary's book
-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cary's book
Marketing is as much as how you present yourself as it is anything else. I've seen uncertified and unexperienced guys who could write a resume that would make you think they could walk on water, reorg, defrag, code in C#, asp and java all while designing the newest, latest, greatest hybrid automobile. Of course, when you pin them down to facts you find out they they haven't a clue what SQL*Plus is, they have never done a hot backup, they can only write a hello world C program, they thought java was something you picked up at Starbucks and they think hybrids are flowers that are cross polinated. Marketing yourself is about learning what people want to hear Of course, one would hope that you would tell the TRUTH when you market yourself, but it's become clear to me over the years that there is a certain percentage of the population that hansn't figured out the truth angle yet. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 10/3/2003 11:39 AM That only works up to the point where they are willing to pay. It's sad, but you can STILL get a job with the OCP letters after your name, regardless of what you can or can't do. The idea is that they are paying you bottom line because you have no experience... but being able to pass a test means that you are trainable. If you can't get through the screeners that say... oh, you have X amount of qualifications... that prices you out of our range in these hard times, how can you market? Honestly, this is more than just rhetoric... HOW can you market yourself when you look bad to the bottom line? April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cary's book - Rapidly moving OT....
Yes, unfortunately those of us who have had the courage and accepted the responsibility of bringing children to the world have to sometimes take the bad with the good. Well I've brought my share of children into the world, thats for sure I'd wager I have more than just about anyone else here on Oracle-L in fact... Anyone have more than 5?? Also, I'm rapidly becomming a single parent, as my wife and I are divorcing after 15 years of mariage and I'm taking custody of the kids. However, I can assure you that those facts will not change my voice or it's use one jot. :-) (any single DBA ladies out there??!!) LOL. At any rate, I do choose my battles that is a lesson I learned long ago. You choose what is important to battle and what to leave behind. I used to take up every gauntlet thrown at my feet, problem was that I'd have so many battles going on that I'd loose them all Now, I pick and choose the important ones. Our future is unknown, and always born in pain, Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 10/3/2003 11:49 AM - Original Message - education and my life in general. No, until there aren't more jobs, I'll keep on the safe side. That's the part where crisis and CYA methodology jump in. I have no solution, but, unfortunately, I don't have Christ-like qualities that are asked from me in every new performance tuning book. And the blonde down the isle is so attractive. Well, at least she'll never accuse you of having an on-going issue... :) Yes, unfortunately those of us who have had the courage and accepted the responsibility of bringing children to the world have to sometimes take the bad with the good. For the sake of getting those kids out the door with a good education. Worse yet if we also have to support mums and dads way past the age where they can take care of themselves. Much worse yet if they are on the other side of the world. It's all part of that thing they call responsibility. Doesn't mean we cannot speak up. But it has to be done in a slightly different way. The art is in learning how far you can push. And where. And when. It's hard, but a few hard knocks are the best lesson. Has the role of DBA changed? Hell yeah! I've been claiming that for years, and why. But few have listened to the warning signs. Now, it's hit with a thud. Wake up call time. I agree with Robert: move to a place where you can be effective. Or change the world. Now, those of us with kids cannot afford to change the world. And even without kids, at 50 is not my idea of fun to form a union. Way past that. So, moving is the option. And all that comes with it like you pointed out: learning the ropes in the new organization. It ain't easy. Been there done that for the last 3 years. Much better now, but it was a shock. One hint: pick the organization very carefully. Last thing you want is to be outsourced... Then of course, there are those of us that were allowed to keep all their Oracle shares when they left. Real estate is the way to go. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cary's book
checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cary's book
Daniel, I agree 100% with what you said Somehow we must find a way to come out of our shell. I am among those coming out of my shell is HARD standing up at IOUG-A, or UKOUG or wherever and speaking to that room full of people is one of the hardest things I do. I just make myself... every year I force myself to submit those abstracts, because I know it helps me grow as a person. So, THOSE OF YOU WHO HAVE NEVER DONE IT BEFORE, SIGN UP AND DO IT SO I DON'T HAVE TO :-D Even writing is hard, because you put it all out there for the critics to trounce on. However, it's wonderful when you get the positive feedback and someone says, Wow your book was great! one of those makes up for about 100 bad comments to me. Like so many others here, I see the DBA life changing Like so many others, I've been doing it so long, that I'm starting to see that it's time for a change. maybe 5 years, maybe longer we will see. Am I the only one that this job tires and stresses out? :-) Best part of it, though, is I've made some great friends even if I only see them once or twice a year! Cheers, Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 10/3/2003 11:54 AM Robert, Well said. I think the problem goes farther back than just us sitting in our cubes. I hate to stereotype, but there is some truth in saying that 'geeks' tend to be somewhat introverted, where many in management are somewhat extroverted. This year's IOUG-A Live was a great example. Here we all are, the best and brightest in the world of Oracle, walking the halls, having intense conversations. In the midst of it all, a pharmecutical sales convention starts sharing our hallways. Talk about polar opposites! It reminded me of high school with the 'serious' students and the popular crowd. Is this any different than work? Especially those people who work in non-IT companies. We all focus on training, OCPs/OCMs, etc, but how many of us have taken a corporate communication class or engaged a business/personal coach? As for management, I've had great ones and god-awful ones. One manager tore me a new one because I explained that one of our systems was 5 minutes behind the others (in explaining the entries in a log file). I've also had ones that would step up to bat for you, even when they could easily justify the opposite. You have to figure out the political landscape, find the mines in the battlefield and step carefully. We can no longer sit in our cubes, writing complex C programs, laughing at the foibles of 'damagement' and 'lusers'. We have to find a way to integrate ourselves into the business. It's not that you have to agree 100% with what is done. If you are going to disagree, do so respectfully and with proper reasoning and documentation. Communication is composed of two pieces, what you say and what the other person hears. As for the geek work, there will always be places for those who excel at something. More appropriately, they will have a place if they can make their skills relevant. This requires understanding the bits and bytes, AND being able to put that into the context of the business need. I've enjoyed the past few years really exploring UNDO, but it is really irrelevant in the business world I live in. What is relevant here? Well, that's my next big project. I'll still be hacking away at Oracle, learning how it REALLY works, doing things that they say should/could not be done. But my goal is to make myself more proficient in a skill that will benefit the organization. My $0.03 (I'm a little long winded today...) Daniel Fink Freeman Robert - IL wrote: Mladen, this is not directed specifically at you, but you have raised something in my mind that often just irritates the heck out of me. I often hear the term Damagement, damagers, etc... and I understand it, and have had more than a few occasions where a damager has killed me Management is far from perfect, and I've met a number of managers who deserve to be kicked in the back side and sent out on the street. Yet, I often also wonder how much of this is OUR OWN FAULT. How many IT guys have I met that are way to passive, more than content to sit in there cubes and blame management, when the fault, at least in part, lies squarely with them. More than I can count. Lack of communication, lack of passion for ones own work, lack of vision, contentment in not understanding the big picture, the I'm not paid to do this syndrome or the It's not my job POV all in my eyes lead to as much failure as management. The guys who will not get their lazy behinds out of their chairs and go TALK to someone (other than the really good looking blonde down the isle) deserve to have their head chopped off as much as the manager they can't stand. I've met so many who will sit in meetings and let managers say STUPID things, never correct, never interject and so the cycle of stupidity is perpetuated. Sure, there may be cultures
RE: Cary's book - Rapidly moving OT....
OH NO!!! 7 cats, 3 dogs and kittens on the way! reminds me of Ghostbusters: Dr. Peter Venkman: This city is headed for a disaster of biblical proportion. Mayor: What do you mean, biblical? Dr. Raymond Stantz: What he means is Old Testament, Mr. Mayor, real wrath-of-God type stuff. Fires and brimstone coming down from the sky, rivers and seas boiling-- Dr. Egon Spengler: Forty years of darkness! Earthquakes, volcanoes-- Winston Zeddemore: The dead rising from the graves! Dr. Peter Venkman: Human sacrifice, dogs and cats living together, mass hysteria! -Original Message- To: Multiple recipients of list ORACLE-L Sent: 10/3/2003 12:54 PM 7 cats, 3 dogs and kittens on the way! -Original Message- Sent: Friday, October 03, 2003 12:40 PM To: Multiple recipients of list ORACLE-L Ah, yes... No kids here, but I do have pet potbellied pigs to support. Anyone have more than 2? ;) Dan Brian Dunbar wrote: Freeman Robert - IL [mailto:[EMAIL PROTECTED] on Friday, October 03, 2003 12:09 PM Well I've brought my share of children into the world, thats for sure I'd wager I have more than just about anyone else here on Oracle-L in fact... Anyone have more than 5?? I've six here. ~brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Dunbar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cary's book
to pay for a competent DBA but frequently hire a shaman or a witch doctor who improves on the system based on snake oil type techniques. If I cannot get more money then some bozo after a If you know you're better than the bozo and that you can give people more value for their money then I think this is a marketing problem more than anything else. It's up to you to prove to the buyer (or your boss) that you can do the work better. Quantify your expected results. Chapter 4 has an excellent discussion on this. Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN error while registering the target database
/dev/vx/rdsk/dbdg13/Rcatctrl.ctl Does this directory exist, does Oracle have priv's on it? Does the file already exist, and of so who owns it and what are the privs? RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/25/2003 12:39 PM Hi List, Does anyone come across this issue? What should i do to resolve this? Any help would be really appreciated. TIA RMAN register database; RMAN-03022: compiling command: register RMAN-03023: executing command: register RMAN-08006: database registered in recovery catalog RMAN-03023: executing command: full resync RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03008: error while performing automatic resync of recovery catalog RMAN-07004: unhandled exception during command execution on channel default RMAN-10035: exception raised in RPC: ORA-01580: error creating control backup file /dev/vx/rdsk/dbdg13/Rcatctrl.ctl ORA-27040: skgfrcre: create error, unable to create file SVR4 Error: 2: No such file or directory RMAN-10031: ORA-1580 occurred during call to DBMS_BACKUP_RESTORE.CFILEMAKEANDUSESNAPSHOT __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Cary's book -- Out of stock !
I GOT it... in my hot little hand is Cary's book, from Amazon no less. EXCELLENT READ SO FAR. Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/23/2003 8:54 AM B***ards! They killed Kenny! -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel Poder Sent: Tuesday, September 23, 2003 6:05 AM To: Multiple recipients of list ORACLE-L Subject: Re: Re[2]: Cary's book -- Out of stock ! swear not to order anything from Amazon again, so help me Codd. This was a good one ;) Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: YEAAAAAAAAAAAAAAAAAAA!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!, drop in
Naa We need to use all the offshore oil we can... save ours for a rainy day. If it's cheap, I don't mind. Use of offshore non-renewable resources is a different issue than use of renewable, manufactured, resources in my mind. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/23/2003 3:49 PM number I'll be happier when I see hi-tech workers arguing for a ban on Nike footwear unless made in the US and a pledge to avoid oil from the mid-east and an utmost commitment not to work for companies using foreign imports - no SAP consultants for example. :( Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cary's book -- Out of stock !
') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cary's book -- Out of stock !
://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Cary's book -- Out of stock !
I got my book... I got my book! From Amazon, delivered today! Woo Hoo looks good Cary!! RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/22/2003 7:10 PM Amazon didn't have any, so I cancelled that order and ordered directly from O'Reilly. Jared Jonathan Gennick [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/22/2003 04:45 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re[2]: Cary's book -- Out of stock ! Monday, September 22, 2003, 7:25:50 PM, Robert wrote: FRI In Fact... it looks like I just might have Cary's book at home. USPS says FRI it's delivered!!! WOO HOO! Perhaps I should offer it up to the highest FRI bidder! Start an Ebay auction for it! I just today got my own copy. You'd think I'd be able to do better than that, given that I'm the editor and all. I've already read it thoughgrin. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
9.2.0.4 anyone
Anyone have any negative experiences with 9.2.0.4 yet? Robert -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Masters exam
With respect to all of you out there... I hear so many complaints about greedy Oracle, and about having to take a class to get certified and the dollar cost of that. I remind you folks that Oracle is a for profit venture. It's not Oracle's responsibility to make anything affordable. It's the responsibility of Oracle to generate revenue, it is the expectation of Oracle shareholders (of which I am one) that Oracle will do such a thing. I don't care if Larry is the 6th richest guy in the universe, so what? Why does that compel him to give you anything? It's all pure market driven. If people stop signing up for classes or OCP exams, Oracle will in quick fashion figure out why and change things. If people keep signing up for classes and taking the OCP, then viola, they have hit the sweet spot and will generate some revenue too. Socialism doesn't work folks, let's face it. If the OCP Masters credentials are worth the money, then spend it. If they are not, don't spend it. If enough people don't spend the money, then something will happen. Thats how a market driven economy works. RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN backup and recovery scenarios
My Oracle9i RMAN Backup and Recovery book from Oracle Press has a chapter devoted to case studies and RMAN. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/4/2003 11:44 AM Look at the Backup and Recovery Doc's. And there are sample scripts in OH/rdbms/demo/case1.rcv thru case4.rcv. The backup and recovery manual is a great resource! HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Prem Khanna J Sent: Thursday, September 04, 2003 2:44 AM To: Multiple recipients of list ORACLE-L Subject: RMAN backup and recovery scenarios Hi all, Is there any doc./URL which lists out RMAN backup and recovery scenarios ? did not find one in metalink. Thanks Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Oracle Masters exam
want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Urgent INFO needed.
Actually, I've seen the reverse be true. I've seen the work offshore be so poor that more folks are brought in locally to correct the problems, yet the offshore remain too because of contractual issues. Happened to me on at least two different occations. You get what you pay for. There are some great Indian DBA's out there (KG for one is awsome), but just as in America, for every great one there are probably 5 that should take up some other profession. This will come and go like everything else. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/3/2003 3:44 PM That is call mondialisation... Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Tony Johnson Sent: Wednesday, September 03, 2003 3:05 PM To: Multiple recipients of list ORACLE-L All I know about it is that for every new job in India one more DBA is out of work here in the United States. -Original Message- Sent: Wednesday, September 03, 2003 5:30 AM To: Multiple recipients of list ORACLE-L Dear Friends, One of my friends has got the offer from CSC india ltd. Please respond this mail if any one from CSC india ltd? just to know some info , thats it. Any info regarding this is appreciated. Please give me your mail id and contacts.. Thanks a lot. Regards Oracle DBA _ Do you Yahoo!? Yahoo! http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com SiteBuilder - Free, easy-to-use web site design software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Future demand for DBAs
They estimate that by 2010, a quarter of the IT workforce will be over 55 years old. Heck, thats true now in the mainframe world I think. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/3/2003 8:54 AM The META Group has released a study that forecasts increased demand for DBAs in the future. They quote the U.S. Department of Labor's Bureau of Labor Statistics that forecasts a 66% increase in DBAs by 2010. The two factors that META feels will increase demand are: 1. Increased use of DW 2. Aging workforce They estimate that by 2010, a quarter of the IT workforce will be over 55 years old. The new features to make databases self-managing will only help with lower value labor intensive tasks such as schema changes and performance tuning, not with higher value skills such as design and troubleshooting. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to log into a 9.2.0 database that has a hung archiver
sqlplus / as sysdba or sqlplus sys as sysdba both will let you in even if the archiver is stuck. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/28/2003 6:29 PM no, the file system was only 43% full the reason log files weren't being written is being the stupid compress archive script turns archiving off before compressing archived log files, then turns it on afterwards. unfortunately, in this one 9;2 instance, it doesn't always want to reenable auto archiving -- in which case the database will eventually hang cause redo logs aren;t being archived. my question is: how do I log into a 9.2 instance to restart auto archiving? [EMAIL PROTECTED] 08/28/03 04:19pm Hi! Was your file system full? If yes, then additional audit files couldn't be written under ?/rdbms/audit and that's why you could'nt log on anymore. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 12:24 AM sorry after checking logs again, the connect / as sysdba command and sqlplus '/ as sysdba' hung after issuing the command. a password was never requested. thanks shannon === Situation: Oracle EE 9.2.0 database on AIX v5.1 tail alert_TOOLS.log: Thu Aug 28 13:46:31 2003 ARC0: Evaluating archive log 1 thread 1 sequence 69800 ARC0: Beginning to archive log 1 thread 1 sequence 69800 Creating archive destination LOG_ARCHIVE_DEST_1: '/u00/oracle/archives/tools_698 00.dbf' ARC0: Completed archiving log 1 thread 1 sequence 69800 Thu Aug 28 13:46:33 2003 Archive Log Stop Archiving is disabled Shutting down archive processes Archiving is disabled Thu Aug 28 13:46:34 2003 ARCH shutting down Thu Aug 28 13:46:34 2003 ARC0: Archival stopped Thu Aug 28 13:46:34 2003 ARCH shutting down Thu Aug 28 13:46:34 2003 ARC1: Archival stopped Thu Aug 28 13:46:39 2003 Thread 1 advanced to log sequence 69802 Current log# 2 seq# 69802 mem# 0: /u09/oracle/TOOLS/redo02.log Thread 1 advanced to log sequence 69803 Current log# 1 seq# 69803 mem# 0: /u09/oracle/TOOLS/redo01.log Thu Aug 28 13:46:48 2003 ORACLE Instance TOOLS - Can not allocate log, archival required ARCH: Connecting to console port... Thread 1 cannot allocate new log, sequence 69804 All online logs needed archiving Current log# 1 seq# 69803 mem# 0: /u09/oracle/TOOLS/redo01.log so the archive hung. on our older 7x and 8x systems, I would do a svrmgrl and connect internal then I would do an archive log all to archive the logs on this 9.2.0 system, I tried sqlplus 'sys as sysdba' --- it hung after asking for the password ok... tried sqlplus /nolog --- then connect sys as sysdba -- hung after asking for password ok... tried sqlplus '/ as sysdba' -- hung after asking for password ok... tried sqlplus /nolog -- then connect / as sysdba -- hung after asking for password Killed smon to cause database to crash. sqlplus 'sys as sysdba' -- asked for password -- got the sql prompt - startup everything worked. I'm glad this is a test database so I could kill it and restart but what is the correct method to get a sql prompt on a hung database when svrmgrl and connect internal aren't supported? Thanks Shannon Shannon St. Dennis Database Administrator City of Regina (306) 777-7415 (phone) (306) 777-6804 (fax) [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The degree of normality in a database is inversely proportional to that of its DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to keep root out?
LOL ROTFLMAO. That is something to try!! RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/28/2003 12:04 PM Put the following code snippet if [ $LOGNAME = root ]; then init 0 fi; in your oraenv. I guarantee you that the SA will no longer be connecting as SYSDBA. -- Mladen Gogala Oracle DBA -Original Message- Walter K Sent: Thursday, August 28, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Just for grins, I'll ask this question... Is there any way to keep the Unix root user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to help by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via connect internal. This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious, is there any way to prevent access via connect internal or / as sysdba? Thanks in advance. W Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to keep root out?
Read the code again. It checks that the person running .oraenv is root, and if so, it does the init. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/28/2003 12:14 PM but this assumes that oracle owner has privs to run init ... am not sure any root worth hir salt would let this happen. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Thursday, August 28, 2003 1:04 PM To: Multiple recipients of list ORACLE-L Put the following code snippet if [ $LOGNAME = root ]; then init 0 fi; in your oraenv. I guarantee you that the SA will no longer be connecting as SYSDBA. -- Mladen Gogala Oracle DBA -Original Message- Walter K Sent: Thursday, August 28, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Just for grins, I'll ask this question... Is there any way to keep the Unix root user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to help by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via connect internal. This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious, is there any way to prevent access via connect internal or / as sysdba? Thanks in advance. W Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. ESPN_Disclaimer.txt -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: one question on backup and restore
Jin, Look into Oracle standby database features and see if that works for you. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/28/2003 5:34 PM Hi Greetings, I have such a plan but not sure if it is feasible. Please help! I install oracle server on two different machine (say A and B). In general, we run on one instance on server A. If we met any problem on server A, we copy all data files, control files and redo files plus spfileSID.ora to server B. Can server B startup that instance? Is there any restriction on this plan? or it is totally impossible? Would you please advise why? Thanks alot! Jin btw, they both are Solaris. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: CHEN,JIN INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: International Language Support Experiences?
The main problem I ran into was the fact that we were already supporting a non-supported set of language characters, and nobody told us of the requirement! Made the conversion interesting. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/27/2003 1:34 PM We have a new requirement to support multiple languages in at least one of our databases. I'm reading the Oracle 9iR2 Globalization Support Guide (450 pages), but wonder if any of you can share real-life experiences regarding: 1. the conversion of existing DBs to broader character sets 2. using Unicode 3. implementing this with 9iAS Our databases currently use US7ASCII with the American character set, but we will likely need to support European, Southeast Asian, and South American languages. Thanks. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Nature of Oracle-l has changed
-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Hey Jared!!
Not being sexist in any way, but it's my experience that Women are much better generalists than men, but that men are much better specialists. Thats why I think women do better in school early on, but once we men get into the University level and pick our speciality, we kick butt. My soon to be ex-wife was frequently much better remembering overall things than I was RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/27/2003 6:44 AM c'mon... any virus named SoBig has to have been written by a man :) (yes, sexist, I know) --- Tanel Poder [EMAIL PROTECTED] wrote: I've seen only one female in my life who would be capable of writing such virus. But that is not the issue (no offence, really). Women just don't waste their time on stuff like this. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 4:54 AM Guy? You've eliminated 50% of all possible suspects... on 8/26/03 1:44 PM, Tanel Poder at [EMAIL PROTECTED] wrote: I doubt they will ever find the real guy behind this. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 10:19 PM For all you virus/worm lovers out there, justice do come: FBI Subpoenas Arizona ISP In Sobig Probe Easynews says it's cooperating with the bureau to find the person who uploaded the virus to a Usenet group it hosts. informationweek.com/story/showArticle.jhtml?articleID=13800091 Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY
Veritas and disks
Anyone have any experience with Veritas CFS (running RAC) and disk IO? We are seeing some interesting things here with regards to available memory and disk throughput. We get great throughput when there is sufficient memory. But, as we load up DD processes, we find available memory decreasing rapidly, like the copies are being cached to free memory by veritas first. Then, after the copies appear to be done from the OS, we see consistant disk activity afterwards. I suspect that veritas is caching these cp's into memory and then writing to disk. This works great until I run out of memory, at which time the cp starts to perform terribly. Is this how Veritas works and is there any way to configure this behavor? RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RAC - lms process
Running RAC on 9.2.0.3 the lms processes seem to be very busy. Anyone have any thoughts on that? Robert -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle World anyone?
- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Is Pete Sharman Missing?
Anyone hear anything out of Pete Sharman in the last two weeks? If you see or hear from him, please have him contact me. Robert Robert G. Freeman Author Oracle9i New Features Oracle9i RMAN Backup and Recovery Mastering Oracle8i blah...blah...blah... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN Backup piece being placed in wrong directory
channel ORA_DISK_3: specifying datafile(s) in backupset input datafile fno=1 name=D:\ORACLE\EWFMS\SYSTEM01.DBF input datafile fno=4 name=D:\ORACLE\EWFMS\DRSYS01.DBF input datafile fno=5 name=D:\ORACLE\EWFMS\INDX01.DBF input datafile fno=7 name=D:\ORACLE\EWFMS\USERS01.DBF channel ORA_DISK_3: starting piece 1 at 07-AUG-03 channel ORA_DISK_2: finished piece 1 at 07-AUG-03 piece handle=D:\BACKUP\ORACLE\HOTBACKUP\RMAN_DEWFMS_T501408013_U1FEU5O8D_1 _1.BAK comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:46 channel ORA_DISK_1: finished piece 1 at 07-AUG-03 piece handle=D:\BACKUP\ORACLE\HOTBACKUP\RMAN_DEWFMS_T501408013_U1EEU5O8D_1 _1.BAK comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:41 channel ORA_DISK_3: finished piece 1 at 07-AUG-03 piece handle=D:\BACKUP\ORACLE\HOTBACKUP\RMAN_DEWFMS_T501408013_U1GEU5O8D_1 _1.BAK comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:01:41 Finished backup at 07-AUG-03 Starting backup at 07-AUG-03 current log archived using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=20 recid=17 stamp=501408115 channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_1: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1HEU5OBJ_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 Finished backup at 07-AUG-03 Starting Control File and SPFILE Autobackup at 07-AUG-03 piece handle=D:\BACKUP\ORACLE\HOTBACKUP\CF_C-1770609602-20030807-02.BAK co mment=NONE Finished Control File and SPFILE Autobackup at 07-AUG-03 RMAN Thanks in Advance, Scott Stefick MILPDS OCP Oracle DBA [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT: Trying to duplicate database from cold backup - auxi
We have top men working on that right now Mr. Jones. Who? Top Men. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/5/2003 5:29 PM Jared Okay, I'll bite. What do you mean about a separate project for verifying backups. It reminds me of the ending to the movie Indiana Jones - we have a team of top experts working on that, you know, the scene where they're packing the ark away in an enormous warehouse. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, August 05, 2003 5:19 PM To: Multiple recipients of list ORACLE-L auxi I would be interested how other sites that rely on RMAN handle this issue. I for one, don't use RMAN for that. It's too much work. There's a separate project for verifying backups. The databases I'm called on to duplicate have lately been 400-500 gigs, more than I want to pull from tape unless absolutely necesssary. It's much faster to plug two servers into a gigabit switch and copy the files across a private network at approx 100 gigabytes per hour. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/05/2003 02:59 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: URGENT: Trying to duplicate database from cold backup - auxi Robert - What I've done over the years is tie the creation of test databases to backup verification. The old issue of how can you trust your backups unless you've done a recovery. It has seemed that I get a request to build a test database at about the right interval to periodically verify the backup. It is nice to say that I would just periodically verify the backups, but like most DBAs, there is always a more pressing task. With RMAN, I assumed that I would continue this practice. It has been a pain, but I ended up with a method that works. The biggest problem is that when the test database is recovered, it initially has the same name as the production database, then I change the name. I would be interested how other sites that rely on RMAN handle this issue. also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN Backup piece being placed in wrong directory
\RMAN_DEWFMS_T501408013_U1FEU5O8D_1 _1.BAK comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:46 channel ORA_DISK_1: finished piece 1 at 07-AUG-03 piece handle=D:\BACKUP\ORACLE\HOTBACKUP\RMAN_DEWFMS_T501408013_U1EEU5O8D_1 _1.BAK comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:41 channel ORA_DISK_3: finished piece 1 at 07-AUG-03 piece handle=D:\BACKUP\ORACLE\HOTBACKUP\RMAN_DEWFMS_T501408013_U1GEU5O8D_1 _1.BAK comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:01:41 Finished backup at 07-AUG-03 Starting backup at 07-AUG-03 current log archived using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=20 recid=17 stamp=501408115 channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_1: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1HEU5OBJ_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 Finished backup at 07-AUG-03 Starting Control File and SPFILE Autobackup at 07-AUG-03 piece handle=D:\BACKUP\ORACLE\HOTBACKUP\CF_C-1770609602-20030807-02.BAK co mment=NONE Finished Control File and SPFILE Autobackup at 07-AUG-03 RMAN Thanks in Advance, Scott Stefick MILPDS OCP Oracle DBA [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Raid 1 vs Raid 5 for tablespaces
Is this perhaps a T-3 Disk Storage Array? -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/12/2003 2:24 PM Our hardware people tell me that our disk array will not support Raid 10. Given a choice between Raid 1 or 5 for my tablespaces, which one is best? This is Oracle 8.1.7 on AIX 4.3.3. The application will have a mix of read and write activity. Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: possible Bug in Oracle 9.2.0.2
Did you open an iTar with Oracle? If so, what severity was it logged at? How you answer certain questions on the iTAR form will impact the severity of the tar, and as a result the time for responses from Oracle. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/7/2003 1:49 PM That fixed it, thank you. I still haven't heard from oracle support yet. -Original Message- Sent: Thursday, August 07, 2003 4:44 AM To: Multiple recipients of list ORACLE-L You it is a bug alter session|system set _unnest_subquery=false / Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, August 06, 2003 7:34 PM To: Multiple recipients of list ORACLE-L While I am waiting for oracle support to respond to my tar update (2nd callback) I am just wondering if anybody has found this problem. We have the following select query (from a peoplesoft implementation) SELECT a.emplid, a.effdt FROM PS_JOB A WHERE A.EFFDT = (SELECT MAX(A1.EFFDT) FROM PS_JOB A1 WHERE A.EMPLID = A1.EMPLID AND A.EMPL_RCD = A1.EMPL_RCD AND A1.EFFDT = SYSDATE) AND A.EFFSEQ = (SELECT MAX(A2.EFFSEQ) FROM PS_JOB A2 WHERE A.EMPLID = A2.EMPLID AND A.EMPL_RCD = A2.EMPL_RCD AND A.EFFDT = A2.EFFDT) AND A.EMPL_STATUS = 'A' and a.emplid='3442' when we run the query we get one row back, but when we replace the field names with count(*), the resulting answer back is 2. We have tested it in 8.0.5.1.1 and we get the correct results, 1 row, and a count of 1. Darren -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT: Trying to duplicate database from cold backup - auxi
BTW, I just waited till afterhours brought the database down, copied the file and cloned the easy way. I love RMAN, but truth be told, I still find the old manual method of cloning a database to be easier somehow. Must be an old fogie. RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT: Trying to duplicate database from cold backup - auxi
Yep, if I can just move the datafiles over gigabit link, thats what I will do. Otherwise I just do a restore and rename... RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/5/2003 5:19 PM I would be interested how other sites that rely on RMAN handle this issue. I for one, don't use RMAN for that. It's too much work. There's a separate project for verifying backups. The databases I'm called on to duplicate have lately been 400-500 gigs, more than I want to pull from tape unless absolutely necesssary. It's much faster to plug two servers into a gigabit switch and copy the files across a private network at approx 100 gigabytes per hour. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/05/2003 02:59 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: URGENT: Trying to duplicate database from cold backup - auxi Robert - What I've done over the years is tie the creation of test databases to backup verification. The old issue of how can you trust your backups unless you've done a recovery. It has seemed that I get a request to build a test database at about the right interval to periodically verify the backup. It is nice to say that I would just periodically verify the backups, but like most DBAs, there is always a more pressing task. With RMAN, I assumed that I would continue this practice. It has been a pain, but I ended up with a method that works. The biggest problem is that when the test database is recovered, it initially has the same name as the production database, then I change the name. I would be interested how other sites that rely on RMAN handle this issue. also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT: Trying to duplicate database from cold backup - auxi
Paula, Try to mount the auxillary database manually, and see what error you get. That might help point you in the right direction in solving the problem. probably 70% of the time it's an issue with the configuration of the aux database (e.g. parameter set wrong, etc...). Manual startup will show you if that is the case most of the time. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/4/2003 5:14 PM Hmmm. Got Robert's book on 9i This database and clone is in 8.1.7 hmmm. -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Monday, August 04, 2003 5:49 PM To: Multiple recipients of list ORACLE-L auxi Paula - I was never able to get this working, but then I didn't have Robert Freeman's book at that time. Do you have his book as a resource? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, August 04, 2003 4:39 PM To: Multiple recipients of list ORACLE-L I did. -Original Message- Sent: Monday, August 04, 2003 5:24 PM To: Multiple recipients of list ORACLE-L you need to : startup nomount pfile=xxx.ora -Original Message- Sent: Monday, August 04, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Guys, When trying to duplicate database with this script I have my auxiliary setup as new database, target setup as old database and am using duplicate database command along with logfile command to create new logfiles. Get error: RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounte d -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: upgrade to 9i
I'd also suggest that you read the migration guide before you do any upgrade. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/30/2003 8:09 AM See doc ID 214887.1 -Original Message- Sent: Tuesday, July 29, 2003 5:54 PM To: Multiple recipients of list ORACLE-L Hi where can I find steps ( procedure ) for upgrading from 8.1.7 to 9i . Thanks, -ak Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter. The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance. If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail. Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Recall: Datafile sizing
Recall request denied. Resubmit in 30 days for further disapproval. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/24/2003 5:29 PM Biddell, Ian would like to recall the message, Datafile sizing. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Timestamps in trace files (and other trace file oddities)
am still learning a great deal about wait events and trace files. Cary, Mogens, Anjo, Tim, Jonathan, Wolfgang, et.al. are better authorities, so any corrections are very welcome. The time between waits is the elapsed time. If we equate elapsed time to response time, we must look at the two components of RT, wait time and service time. If the time differential is 7 minutes, x minutes is service time and y minutes is wait time. It is possible that only .01 seconds was wait time, while the remaining 6:59:99 was service time (i.e. cpu) I can't explain the scattered read issue. However, it is interesting to note that the # of blocks to be read is offset by 1 in the second wait event. Perhaps, the read request was issued, but the 65.6041 block was already in memory, so the read request was reissued minus that block. I'm not sure how the latch free enters into the picture, but I have a feeling that this wait is integral in the sequence of events. Dan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dba age
Well I *AM* 37, and I don't feel old. I'm actually the youngest DBA in my group, and it seems like I'm always the youngest wherever I go... Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/23/2003 12:14 PM King Arthur: Old woman! Dennis: Man. KA: Sorry. Old man! Whose castle is that? D: I'm 37! KA: What? D: I'm 37, I'm not old! KA: Well, I can't just call you 'man'. D: Well, you could say 'Dennis'. KA: I didn't know you were called Dennis. D: You never bothered to find out, did you? At least I'm only on the cusp of 35. And I have 6 years experience with Oracle. I've lost whole databases, even, thanks to WindohsNoT running Oracle7. My experience tells me not to put Oracle on Windohs. YMMV. I've experienced upgrades, patches, and migrations -- oh my! I've experienced the joy that isn't OiD 9.0.2. I've experienced a developer who could have sworn he was in the test DB. I've experienced successful recovery with zero data loss and no downtime during core business hours. I've experienced AutoRAID. I've experienced BAARF. I've experienced Intel, Alpha, SPARC, and PA-RISC. Duhvelopers have experienced my wrath. I have experienced my own wrath during moments of Duh. I've experienced this list, with it's many helpful and some not so helpful members. And yet, there's so much I haven't experienced. Like lunch today. Standing in for Paul Harvey, I'm Rich Jesse. Good Day! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, July 23, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Now this one is difficult folks . what is average age of an experienced oracle dba ? -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN
Given what you describe, RMAN should work fine. It dosen't seem like a best practice, why would you want to keep the name the same? -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/23/2003 4:49 PM Has anybody tried using the same backup filename on RMAN? So if you use xxx.dmp on Monday,move this file to tape then reuse the same filename for the Tuesday dump. I think as long as the file is not on disk then RMAN accepts the filename. Does anyone know if there are complications when it comes to doing restores? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jerome Roa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Recent reports on outages caused by DB2 and 9iRAC issues
If anyone has any inside info on the Orbitz problem, I'd like to hear it. Email me private if you like, I'll take what you tell me to the grave. Robert Robert G. Freeman TUSC www.tusc.com Author books, books and more books! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
Request denied, please re-submitt in 60 days for further dis-approval. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/18/2003 2:39 PM SET ORACLE-L NOMAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James PEARSON INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: urgent Help!! FYI
In OH/network/log is there a listener.log file? Who owns it? Who are you starting the listener as and does that ID have rights to write to the listener.log? -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/18/2003 3:09 PM Hi, I need somebody here to help me to start my Oracle listener for my Oracle server was power off this morning. Here, when I run the lsncrtl start, I get an error message. Please see the following message: # ./lsnrctl start LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 18-JUL-2003 15:20:10 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Starting /u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr: please wait... TNSLSNR for Solaris: Version 9.2.0.1.0 - Production NL-00280: error creating log stream /u01/app/oracle/product/9.2.0.1.0/network/log/listener.log NL-00278: cannot open log file SNL-00016: snlfohd: error opening file Solaris Error: 13: Permission denied Listener failed to start. See the error message(s) above... Can somebody tell me how to start my Oracle listener? Any suggestion are highly appreciated! Many thanks! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: urgent Help!! FYI
Issue a ps -ef|grep tns Command. Who owns the process? Root? RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/18/2003 4:09 PM Dick, It works now after I change the $ORACLE_HOME/network/log/listener.ora to like following: $ls -al listener.log -rw-rw-rw- 1 oracle oinstall 1732613 Jul 18 16:02 listener.log But before the parameter is like following: $ls -al listener.log -rw-rw-r-- 1 oracle oinstall 1732613 Jul 18 16:02 listener.log I just don't know is this file property changed or not? If changed, who changed it. But before power off, it works fine. Thank you very much again! Don Goulet, Dick wrote: In your listener.ora file add the line logging_listener=off. Otherwise make sure $ORACLE_HOME/network/log exists and is writable by the Oracle user. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, July 18, 2003 4:10 PM To: Multiple recipients of list ORACLE-L Hi, I need somebody here to help me to start my Oracle listener for my Oracle server was power off this morning. Here, when I run the lsncrtl start, I get an error message. Please see the following message: # ./lsnrctl start LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 18-JUL-2003 15:20:10 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Starting /u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr: please wait... TNSLSNR for Solaris: Version 9.2.0.1.0 - Production NL-00280: error creating log stream /u01/app/oracle/product/9.2.0.1.0/network/log/listener.log NL-00278: cannot open log file SNL-00016: snlfohd: error opening file Solaris Error: 13: Permission denied Listener failed to start. See the error message(s) above... Can somebody tell me how to start my Oracle listener? Any suggestion are highly appreciated! Many thanks! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: should you seperate indexes from tables in seperate dataf
For a given statements execution, running in serial, you will not find an index and a table being accessed in parallel. Thus, there is no contention, for a given statement, between the tables and indexes accessed by that statement. Thus, one could argue the merits of not needing to seperate indexes and data in a low concurrency environment. OTOH, high concurrency leads to hot blocks, which often leads to a requirement of distributing IO. In this case, seperating indexes and data may be one step in that direction. RAID technologies, if properly configured, can eliminate some of the risk from co-location of data of course but in the end there is no substitute for carefully laid out data. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/15/2003 10:29 AM datafiles does anyoen disagree? Didnt this get started with the 'DBA Handbook' or was it a different text? From: Mercadante, Thomas F [EMAIL PROTECTED] Date: 2003/07/15 Tue AM 11:10:05 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: should you seperate indexes from tables in seperate datafiles R, Some of it depends on the disk storage. I have always followed the time-proven method of organizing disks and placing indexes away from the tables they belong to. Our warehouse is using EMC external disk. What the warehouse architect did was to stripe the EMC disks in such a way that all mount points (Sun system) are spread across all the EMC disks. What this does is to spread all files in the database across all the EMC drives. And with 4 Gig of EMC cache available, it further disproves the theory that separing indexes from data are required. The end result, in my case, is almost like one big RAM disk - where all disk IO is spread across all disk. If you do not have this arrangement, then I would still try and keep indexes and data away from each other. But let's face it, we *never* have enough disk mount points, so we end up merging things together somewhat anyway. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, July 15, 2003 10:49 AM To: Multiple recipients of list ORACLE-L There has been alot of literature stating that you will recieve performance improvements by seperating indexes and tables across multiple I/O points. Ie... you have a tables tablespace and an index tablespace. If you put them on seperate hard drives, you will have less I/O contention. Now Im seeing some articles stating that this is not true. That oracle actually accesses indexes and tables serially. Now it might be useful seperate indexes from tables for maintenance purposes but this wont lower I/O contention. Can anyone chime in on this? Curious to see where the evidence is leading? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services
RE: O R A C L E 9i References
Pradeep, I think if you contact Oracle directly they could certainly provide you with some reference RAC customers that you could talk to. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/9/2003 5:34 AM Hello everyone, We are looking for high availabilty database solution for a product which is under initial development. We have suggested Oracle RAC as the database option. Can we go for IBM DB2 ESE as another database option ? Can anybody give good references of organisations having production databases running in Oracle9i RAC ? Informations on the same would be truely appreciated. Thanks Regards, Pradeep -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pradeep Kumar G INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ROWNUM is driving me nuts - queries suggested produced no res
Only less and = queries with regards to rownum are supported. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/9/2003 11:19 AM I definitely dont fully understand ROWNUM yet, and you guys so far provided more info than a couple of books by Oracle, that I have here. For a second I thought I'm beginning to get it, but the queries suggested produced no results... SQL SELECT ROWNUM, GENDER 2 FROM (SELECT ROWNUM, GENDER 3 FROM EMP2 4 WHERE ROWNUM = 20) 5 WHERE ROWNUM 10; no rows selected SQL SELECT r, GENDER 2 FROM (SELECT ROWNUM r, GENDER 3 FROM EMP2 4 WHERE ROWNUM = 20) 5 WHERE ROWNUM 10; no rows selected SQL SELECT r ROWNUM, GENDER 2 FROM (SELECT ROWNUM r, GENDER 3 FROM EMP2 4 WHERE ROWNUM = 20) 5 WHERE ROWNUM 10; no rows selected SQL .. so, any help is appreciated - rownum is driving me nuts... thx maa __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MaryAnn Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ROWNUM is driving me nuts - queries suggested produced no res
To add on to my previous comments, change your code a bit: SQL SELECT RN, GENDER 2 FROM (SELECT ROWNUM RN, GENDER 3 FROM EMP2 4 WHERE ROWNUM = 20) 5 WHERE RN 10; -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/9/2003 11:19 AM I definitely dont fully understand ROWNUM yet, and you guys so far provided more info than a couple of books by Oracle, that I have here. For a second I thought I'm beginning to get it, but the queries suggested produced no results... SQL SELECT ROWNUM, GENDER 2 FROM (SELECT ROWNUM, GENDER 3 FROM EMP2 4 WHERE ROWNUM = 20) 5 WHERE ROWNUM 10; no rows selected SQL SELECT r, GENDER 2 FROM (SELECT ROWNUM r, GENDER 3 FROM EMP2 4 WHERE ROWNUM = 20) 5 WHERE ROWNUM 10; no rows selected SQL SELECT r ROWNUM, GENDER 2 FROM (SELECT ROWNUM r, GENDER 3 FROM EMP2 4 WHERE ROWNUM = 20) 5 WHERE ROWNUM 10; no rows selected SQL .. so, any help is appreciated - rownum is driving me nuts... thx maa __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MaryAnn Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: salary question - Slipping off topic
') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Failure to compress archive logs over 100M
Agree though earlier versions of Gzip have 2GB problems... RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/7/2003 2:19 PM use gzip and see. Much better than compress. I never observed any problem. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Mon, 07 Jul 2003 05:49:26 -0800 I just started getting hundreds of the following messages: /ora_archive/ptxor01/arch_log/ptxor01_1_17484.arc: -- file unchanged It appears to only come from a failed attempt to compress an archive log which is -rw-r- 1 oracle dba 104858112 Jul 3 04:07 ptxor01_1_17484.arc over 100M in size -rw-r- 1 oracle dba 71110623 Jul 6 07:11 ptxor01_1_17544.arc.Z logs under 100M compress just fine. Using a -f switch with the compress will compress the log, but the compressed file is larger than the original file. I have not seen this behavior before from compress. Any ideas or thoughts would be appreciated. Regards, Bill Burke The Kinder and Gentler DBA International Oracle Users Group www.ioug.org Executive Vice President, Director of Marketing Email: [EMAIL PROTECTED], [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Burke, William F (Bill) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Online tech books
Must say that I approve of your set of books :-)) Robert Freeman Author of at least two books on your bookshelves! -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/2/2003 1:26 PM Bless you Bob ! I will use your pictures to settle the argument of too many books with my wife! I told her I reduce my number of books as long as she reduces the number of shoes. She got a bit offensive. Luis -Original Message- Sent: Wednesday, July 02, 2003 10:11 AM To: Multiple recipients of list ORACLE-L Monday, June 30, 2003, 10:39:40 AM, you wrote: BM I just returned frm vacation, but I wanted to respond to Jonathan BM Gennick regarding my collection of books.( I managed to delete that BM message) But, Ive taken some pictures of my collection.. Ive actually BM purchaced all the books you see! BM http://162.42.213.232/books/index.html Wow! Bob, I think you have me beat, and I'm no slouch when it comes to ordering books. Hey, you know what else, as I look very closely at your bookcases, I think you use the same cheap, partical-board-covered-with-paper, bendable-shelf brand that I usegrin. I better get on the stick and order more booksgrin. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luis deUrioste INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Online tech books
Like that tag line April... Robert G. Freeman Consultant - TUSC www.tusc.com Silence is consent... -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/2/2003 1:49 PM Good Lord, you can NEVER have too many books! April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: WHY IT DOES NOT WORK == rman target / as sysdba THANKS
(Wow! I answered an RMAN question ... and I knew nothing about it 12 months ago) That is awsome, isn't it!! Congrats! BTW, if you are using 9i and RMAN there is no need for the nocatalog command. RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to find folder size in unix
The true magic is in my ability to actually use the folders and the contents therin in Win XP. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/26/2003 9:49 AM versus the magic number which in no way is reflected in size. Gogala, Mladen wrote: Didn't they tell you that the size doesn't matter, it's the magic in the folder? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 7:00 AM To: Multiple recipients of list ORACLE-L how to find folder size in unix -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: 9i OCP Details
/*+ DISCLAIMER */ I have no association with Cary or hotsos (did I get it right this time Cary?) and I've never been to one of his classes... but knowing Cary, having talked to him, having had his help on a few issues and questions and having been to his presentations, I'd say if you can go, GO GO GO. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/26/2003 10:29 AM Totally agree. Make the pitch that this class alone could push your skills up to the next level. It is a real eye-opener. I'll bet it is much less than an Oracle Education class. As a bonus I think they usually let you use their tools for a month. Use your negotiating skills. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 26, 2003 9:19 AM To: Multiple recipients of list ORACLE-L It's well worth the begging. I went in April and it was a GREAT class. I suggest you do what you can to get there. -Scott -Original Message- Sent: Thursday, June 26, 2003 7:15 AM To: Multiple recipients of list ORACLE-L hotsos is going to be in town next week and im 'trying' get my boss to send me. slow economy. people dont want to spend money on training. :( hope it doesnt fill up before he makes up his mind. From: Gudmundur Bjarni Josepsson [EMAIL PROTECTED] Date: 2003/06/26 Thu AM 05:49:43 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: 9i OCP Details If you want real advanced courses go with [...] what Jonathan Lewis or guys at his level provide. I have to agree on this. I've had the good fortune to sit in on Lewis's 'Optimising Oracle' and Cary Millsap's 'Hotsos Clinic 101' and no course I ever took from Oracle Education comes close to what these guys offer (and I've taken quite a few). Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: explain plan
If you all are in 9i and you have not used dbms_xplan.display, give it a
try... you will throw scripts like this one away forever!
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/26/2003 11:19 AM
David - Here is the one I use. In my environment I just have one
developer
at a time using EXPLAIN, so I just have it truncate the table afterward.
select lpad(' ',2*(level-1))||operation||' '||options||' '||object_name
||' '||decode(id,0,'Cost = '||position) Query Plan
from plan_table
start with id=0
connect by prior id = parent_id
/
truncate table plan_table
/
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, June 26, 2003 11:00 AM
To: Multiple recipients of list ORACLE-L
List ,
does anybody have or know where I can get a script that will explain
all of
the columns from the plan_table? Does anybody have any suggestions for
using ultxpls.sql?
thanks,
David Ehresmann
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ehresmann, David
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Freeman Robert - IL
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Dynamic SQL: where do you draw the line?
San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Dynamic SQL: where do you draw the line?
Really... wow, and how do you propose to build reusable code given those conditions? RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/25/2003 2:19 PM USING clause could be used for column values in dynamic sql, but for table names and column names you'd still have to concatenate strings. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Freeman Robert - IL Sent: Wednesday, June 25, 2003 12:40 PM To: Multiple recipients of list ORACLE-L I'm not sure why it's that much harder to use the USING clause of execute immediate and use bind variables. Seems much easier to read, first of all, and the impact it might have on the library cache would be most positive. Sure, we are talking perhaps the difference between .02 and 1 seconds, but that can add up over multipule executions. See if you can determine the number of executions for this code, and the average parse time. Then rewrite it to use bind variables and run some tests to get a good average parse time for that bit of code, multipuly by executions and you have quantified the overall performance impact on that bit of code. Of course, that dosen't begin to quantify the impact of reducing the hash chaining that is probably happening in your shared pool that would occur as a result of using bind variables. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/25/2003 10:04 AM I've been fighting an ongoing war with our ecommerce developers, who are inordinately fond of writing dynamic SQL code that neglects to incorporate bind variables. Researching AskTom I've found and utilized different techniques to force bind variables into these dynamic SQL queries, including the use of application contexts, object types, etc. However, I'm wondering if I'm making things worse, essentially providing them with band-aids, when I should be forcing them to change the way they code. Consider the sample code below (which is a relatively simple example), which is a generic DELETE statement generator. In this situation, the programmers claim the following code is good programming practice, promotes ease of maintenance, less buggy, and promotes code reusability (their definition of reusability is a bit different from mine). I disagreed with them -- not only is this code not reusable at all, with the parsing overhead consequences, it's also harder to debug and tune for performance, due to all the permutations that needs to be tested. My take was that they be far better off writing a simple static DELETE statement for each table. Their rejoinder -- it's not worth writing lots of redundant code at the expense of 'minimal' gains in performance.Now, this code *could* be rewritten to use the SYS_CONTEXT function on the p_object_id and p_site_guid to force a bind variable on those two conditions, but the IN condition with respect to the p_asset_guid would be more problematic. However, I don't feel we should have to be resorting to such measures to get this code to using bind variables. So, I'm at the point of denying such code to be migrated to production. I recognize that there are situations where there is a legitimate need for dynamic SQL, but the SQL has to be written w/o catenating literal SQL -- and if it can't -- they need to go back to square one. Opinions? I'm curious -- do you have policies/standards with respect to dynamic SQL? CREATE OR REPLACE PROCEDURE test ( p_Asset_GuidIN VARCHAR2, p_Object_Id IN VARCHAR2, p_Object_Definition IN VARCHAR2, p_Site_Guid IN VARCHAR2, p_resultIN OUT VARCHAR2 ) AS strTableName VARCHAR2(100); strWhere VARCHAR2(100); strQuery LONG; BEGIN IF p_Object_Definition = 'PRODUCT' THEN strTableName := ' TNE.GPD_PRODUCT_ASSET '; strWhere := ' MODEL_NO '; ELSIF p_Object_Definition = 'CARACTERISTIC' OR p_Object_Definition = 'CHARACTERISTIC' THEN strTableName := ' TNE.GPD_CARACTERISTIC_ASSET '; strWhere := ' CARACTERISTIC_ID '; ELSIF p_Object_Definition = 'CATEGORY' THEN strTableName := ' TNE.GPD_CATEGORY_ASSET '; strWhere := ' CATEGORY_GUID '; ELSIF p_Object_Definition = 'VALUE' THEN strTableName := ' TNE.GPD_VALUE_ASSET '; strWhere := ' VALUE_ID '; ELSIF p_Object_Definition = 'PRODUCT_NODE' THEN strTableName := ' TNE.GPD_PRODUCT_NODE_ASSET '; strWhere := ' PRODUCT_NODE_GUID '; ELSIF p_Object_Definition = 'CARAC_GROUP' THEN strTableName := ' TNE.GPD_CARAC_GROUP_ASSET '; strWhere := ' CARAC_GROUP_GUID '; END IF; strQuery := ' DELETE FROM ' || strTableName || ' WHERE ASSET_GUID IN ( ''' || REPLACE(p_Asset_Guid,' ', ''',''') || ''' ) AND '; strQuery := strQuery || strWhere || ' = ''' || p_Object_Id || ; strQuery := strQuery || ' AND SITE_GUID = ''' || p_Site_Guid || ; execute
RE: Dynamic SQL: where do you draw the line?
Understand. Would be cool, wouldn't it! RF -Original Message- To: Freeman Robert - IL; 'Multiple recipients of list ORACLE-L ' Sent: 6/25/2003 1:53 PM I was merely pointing to limitations of USING clause. My message had nothing to do with building reusable code. Though, I'd love if dynamic sql would allow USING clause to be used for tables/columns names. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 25, 2003 1:44 PM To: 'Igor Neyman '; 'Multiple recipients of list ORACLE-L ' Really... wow, and how do you propose to build reusable code given those conditions? RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/25/2003 2:19 PM USING clause could be used for column values in dynamic sql, but for table names and column names you'd still have to concatenate strings. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Freeman Robert - IL Sent: Wednesday, June 25, 2003 12:40 PM To: Multiple recipients of list ORACLE-L I'm not sure why it's that much harder to use the USING clause of execute immediate and use bind variables. Seems much easier to read, first of all, and the impact it might have on the library cache would be most positive. Sure, we are talking perhaps the difference between .02 and 1 seconds, but that can add up over multipule executions. See if you can determine the number of executions for this code, and the average parse time. Then rewrite it to use bind variables and run some tests to get a good average parse time for that bit of code, multipuly by executions and you have quantified the overall performance impact on that bit of code. Of course, that dosen't begin to quantify the impact of reducing the hash chaining that is probably happening in your shared pool that would occur as a result of using bind variables. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/25/2003 10:04 AM I've been fighting an ongoing war with our ecommerce developers, who are inordinately fond of writing dynamic SQL code that neglects to incorporate bind variables. Researching AskTom I've found and utilized different techniques to force bind variables into these dynamic SQL queries, including the use of application contexts, object types, etc. However, I'm wondering if I'm making things worse, essentially providing them with band-aids, when I should be forcing them to change the way they code. Consider the sample code below (which is a relatively simple example), which is a generic DELETE statement generator. In this situation, the programmers claim the following code is good programming practice, promotes ease of maintenance, less buggy, and promotes code reusability (their definition of reusability is a bit different from mine). I disagreed with them -- not only is this code not reusable at all, with the parsing overhead consequences, it's also harder to debug and tune for performance, due to all the permutations that needs to be tested. My take was that they be far better off writing a simple static DELETE statement for each table. Their rejoinder -- it's not worth writing lots of redundant code at the expense of 'minimal' gains in performance.Now, this code *could* be rewritten to use the SYS_CONTEXT function on the p_object_id and p_site_guid to force a bind variable on those two conditions, but the IN condition with respect to the p_asset_guid would be more problematic. However, I don't feel we should have to be resorting to such measures to get this code to using bind variables. So, I'm at the point of denying such code to be migrated to production. I recognize that there are situations where there is a legitimate need for dynamic SQL, but the SQL has to be written w/o catenating literal SQL -- and if it can't -- they need to go back to square one. Opinions? I'm curious -- do you have policies/standards with respect to dynamic SQL? CREATE OR REPLACE PROCEDURE test ( p_Asset_GuidIN VARCHAR2, p_Object_Id IN VARCHAR2, p_Object_Definition IN VARCHAR2, p_Site_Guid IN VARCHAR2, p_resultIN OUT VARCHAR2 ) AS strTableName VARCHAR2(100); strWhere VARCHAR2(100); strQuery LONG; BEGIN IF p_Object_Definition = 'PRODUCT' THEN strTableName := ' TNE.GPD_PRODUCT_ASSET '; strWhere := ' MODEL_NO '; ELSIF p_Object_Definition = 'CARACTERISTIC' OR p_Object_Definition = 'CHARACTERISTIC' THEN strTableName := ' TNE.GPD_CARACTERISTIC_ASSET '; strWhere := ' CARACTERISTIC_ID '; ELSIF p_Object_Definition = 'CATEGORY' THEN strTableName := ' TNE.GPD_CATEGORY_ASSET '; strWhere := ' CATEGORY_GUID '; ELSIF p_Object_Definition = 'VALUE' THEN strTableName := ' TNE.GPD_VALUE_ASSET '; strWhere := ' VALUE_ID '; ELSIF p_Object_Definition = 'PRODUCT_NODE' THEN strTableName
RE: Migrating 8i OPS to RAC 9.2
I'm gonna start callin' ya Pete Mr. Company Line Sharman. Must say I'm rather upset right now... someone on ORACLE-L is making nasty suggestions to Oracle that I am revealing 10i stuff there one case where I just happened to mention that I was on the beta (which I should have thought better of granted) and one where I mentioned a feature in 10i, but didn't mention that it was a feature... in fact, I didn't even think of it in those terms when I wrote the article (it was about default user tablespaces). Oracle and I have had some words about that, and I probably irritated them with my words just a bit. I'm just about to give up on this whole Oracle thing I think. :-) RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: IO Topology Anyone???
Veritas does appear to have this available... now I just have to figure out if I have it in house! RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/23/2003 9:30 AM Ah, thank you. I do remember reading about that feature now. I need to find out if this works with Clariion, and how to acccess the data without Oracle Enterprise Mangler. Jared On Sunday 22 June 2003 22:29, Tanel Poder wrote: Hi! It just adds one more tab storage layout to your OEM console. If you are running on EMC you can drill down physical storage information to see on which disks your datafiles actually reside. I haven't heard that they have it for Veritas yet... but I've not worked with it either, EMC has its own tool for same kind of thing anyway. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 23, 2003 6:39 AM Robert, Have any URL's to explain this? Anything to do with Oracle Managed Files? Jared On Thursday 19 June 2003 10:55, Freeman Robert - IL wrote: Anyone use the IO Topology features with Oracle9iR2 and Veritas? Does Veritas have a mapping file that you can use with this feature? (I've posed the same question with Veritas, so it's a race to the answer!) Any experiences you can share about this feature? Robert -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What can cause boost in LIO/PIO?
What was this 5am job? It wasn't an analyze was it? RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/20/2003 11:29 AM Hey all, I'm testing out the max I/O thruput of an IBM FastT900 using a dual 2.4GHz w/1GB RAM on Win2K server (not my choice but it's just for testing) running Oracle 8.1.7. For one of my tests, I created the following heirarchical query: SELECT * FROM MYBIGTABLE GL1 START WITH GL1.TIME_STAMP LIKE '%40%' CONNECT BY PRIOR REFERENCENO = WORKORDERNO; Here's the explain plan as TOAD sees it (mangled by e-mail): Operation Object Name RowsBytes Cost SELECT STATEMENT Optimizer Mode=CHOOSE 95 K36477 CONNECT BY INDEX FAST FULL SCANMBT_TRANSTYPE 477 K 8 M 13165 TABLE ACCESS BY USER ROWID MYBIGTABLE ROWID ROW L PARTITION RANGE ALL 1 8 TABLE ACCESS FULL MYBIGTABLE 95 K9 M 36477 1 8 The CONNECT BY was purposely done against non-indexed columns so as to have the query consume more IO. Also, the instance was detuned to only have less than 8MB of buffer cache. And I had started a full direct export of the DB in an attempt to flush the SAN's 2GB shared cache. I want to see how much real physical IO this puppy can produce. I know, I know, there are several other factors involved. I don't have the SAN available to me for long for testing, so it's the best I could think of on short notice. Anyway... I ran several of these concurrently, staggering the start of each randomly by up to a minute. After introducing other loads in order to max out the SAN and after the full export of the 30GB DB completed, I started killing of the queries one-by-one, noticing the change in activity on the DB for each kill. I left four queries running when I left last night to see how long they'd take (no real purpose, just for kicks). One of the tools I'm using to monitor is Quest's Spotlight on Oracle. When I got in this AM, I noticed in SoO that the four queries were still running. I think I maxed out the SAN. System-wide event waits were over 3000ms/s. OK, to my question (finally!): The wierd thing is that after a 5:00ish AM DBMS_JOB completed, the LIOs and PIOs for the same four queries jumped dramatically. Why would this happen? CPU usage was fairly constant and there were no other processes active. I'm guessing this is an Oracle thing and not a SAN issue since the LIOs also jumped dramatically, but I could be wrong. Since I can't describe this very well, I've put an annotated screenshot of the Spotlight screen at http://society.servebeer.com/SANTA_19.png The image is about 130K. Be kind to my li'l server, I've only got a 128Kb pipe up (768Kb down). :) Any ideas? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What can cause boost in LIO/PIO?
makes sence to me... I've seen an analyze, if it takes a long time to run, cause odd things to happen to SQL that starts running in the middle of the analyze process. The SAN rebuild certainly sounds like a likley suspect. RF -Original Message- To: Jesse, Rich; Freeman Robert - IL; 'Multiple recipients of list ORACLE-L ' Sent: 6/20/2003 12:52 PM [deft backpedaling] OK, now I think it IS the SAN. The S/A handling the SAN is helping us with our backup scenario so he's reorganizing some drives on the SAN. At about the same time he started the reorg (highly drive-intensive), my aggregate PIO rate dropped from almost 10K/s to less than 2K/s. And the LIOs dropped similarly, while the event waits increased. I'm thinking that the impact of the reorg on the SAN caused the wait events for the PIOs to grow (from 3.5K/s to 4.7K/s). This longer wait in turn caused a decrease in LIOs because the processes are too busy waiting to generate the IO requests. This explains everything except that the lack of contention to cause the IOs to boost in the first place happened at the same time as the first run of the DBMS_JOB at 5:00 AM. Coincidence? How's that sound? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Jesse, Rich Sent: Friday, June 20, 2003 12:32 PM To: 'Freeman Robert - IL'; 'Multiple recipients of list ORACLE-L ' Subject: RE: What can cause boost in LIO/PIO? Only in part. It's an hourly complete rebuild of a mini-warehouse table (don't ask -- not my idea). It does do a few index creates and accompanying analyzes of those indexes and their table at the end of the procedure. I think this accounts for the very high PIO spikes at the end of every DBMS_JOB cycle, but I'm still not sure how it affected the other queries. Thx! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Freeman Robert - IL [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 11:06 AM To: Jesse, Rich; 'Multiple recipients of list ORACLE-L ' Subject: RE: What can cause boost in LIO/PIO? What was this 5am job? It wasn't an analyze was it? RF -Original Message- From: Jesse, Rich To: Multiple recipients of list ORACLE-L Sent: 6/20/2003 11:29 AM Subject: What can cause boost in LIO/PIO? Hey all, I'm testing out the max I/O thruput of an IBM FastT900 using a dual 2.4GHz w/1GB RAM on Win2K server (not my choice but it's just for testing) running Oracle 8.1.7. For one of my tests, I created the following heirarchical query: [yadda yadda yadda] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Look's like Larry's at it again...
to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
IO Topology Anyone???
Anyone use the IO Topology features with Oracle9iR2 and Veritas? Does Veritas have a mapping file that you can use with this feature? (I've posed the same question with Veritas, so it's a race to the answer!) Any experiences you can share about this feature? Robert -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-01555 with Automatic Undo Management mode
My guess is that this has to do with being able to get a read consistent image of the underlying tables of the mview. can you provide us with: 1. The version of Oracle 2. The statement being used to create the mview 3. Is anyone doing anything to the underlying tables while you are creating the mview? 4. Does this table have any LOB columns in it? -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/18/2003 9:59 AM I'm trying to create a materialized view on a 7G table. I'm using UNDO and undo_retention=108000, which if I understand correctly is 30 hours. I have 7G in UNDOTBS1 --- I shouldn't need that much. After 7 hrs I get ORA-01555: snapshot too old: rollback segment number with name too small The FM says: ORA-01555 snapshot too old: rollback segment number string with name string too small Cause: Rollback records needed by a reader for consistent read are overwritten by other writers. Action: If in Automatic Undo Management mode, increase the setting of UNDO_RETENTION. Otherwise, use larger rollback segments. UNDOTBS1 still had 3G of space free with about 88 active undo extents, the largest was 4,154,458,112 bytes. Was it trying to create another 4G extent? Is there something I am missing? This Automatic stuff doesn't seem to be so automatic. I can create this using rollback segments but I wanted to use UNDO because it allows past point in time queries. Oracle 9.2.0.1.0 Win2K. Any thoughts (besides get a real operating system and use rollback segments) would be greatly appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
10046 madness
Ok, I'm a bit perplexed and I need some ideas. I have two systems. From a hardware/software POV they are exactly alike. However, one performs consistently better than the other. I'm sure this is an IO related issue. I have a shell script that does a bit of work on 10046 trace files. On both systems I have a database. Each is configured like the other. In each I loaded data into the same table the same way on each database, so the cache should be primed in each (I didn't check x$bh to be sure, I should have but they should be the same), I then ran a benchmark stored procedure in both the same way. Both systems were static at the time, so no concurrency. Data was loaded onto the same RAC node that the procedure ran on. When I processes the 10046 with a shell script I have for such things I see more wait event numbers (see below for 10046 summary wait events) from one system than the other. The average wait event time is smaller but the numbers are higher. I'm trying to figure out what the devil might cause this? Is it an issue of physical placement of data on the disks? Any ideas or thoughts or suggestions are most welcome. Here are the summary results of the 10046 traces. These traces were all manually run, and are only for the execution of the SP which has one select cursor in it and a single delete statement, here is pseudo code: cursor = select xyz from b where c=d; cursor loop get x into a delete from y where z=a; end loop Here are the summary results of the 10046 trace: Test db: Wait Event Name # times in trace total wait avg wait sec secs db file scattered read1144 19.077857 .016676448 db file sequential read 2592 19.947032 .007695614 global cache cr request 176961.640369 .92697 global cache s to x 17694 11.375243 .000642887 ** --- sum 52.040501 ELAPSED_TIME 383.715441 Here is the production run... db file scattered read 4222.010246 .004763616 db file sequential read 19671 48.628433 .002472087 global cache cr request 10144 12.256521 .001208253 global cache open x 18341.039376 .000566726 global cache s to x 101685.374963 .000528616 log buffer space46 25.039965 .544347065 ** --- sum 94.349504 ELAPSED_TIME 412.876579 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Bewildered by RMAN
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: asking your opinion
See comments below RF Robert G. Freeman Consultant - TUSC www.tusc.com One browser to rule them all, one browser to find them, One browser to bring them all and into the darkness bind them In the land of Redmond where the shadows lie. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/16/2003 11:14 PM Hi Dear listers, I'd like to ask your opinion about our possible new project. overview; install fatwire for the whole community for web application. no single point of failure, sun servers, oracle. We have more than 10 divisions currently( different department, like arts, dental, enginerring..etc), but we want the flexibility to add more unit as the environment changes and grows. Question 1: database option; what is the pros and cons about physical standby database, logical staandby or RAC? I think the answer should be RAC, right? You are asking the question without yet really providing the requirements. The standby database (logical or physical) is there to meet disaster recovery requirements, *NOT* HA requirements. It's need is defined by your SLA's with regards to how much down time can I have, do I need a remote site, do I need to be able to revert to a previous image of my database, etc...etc... For some environments, offsite backups are perfectly satisfactory in this regard, at other sites, you have a hot offsite location, where you run dataguard (standby). So, you need to define your needs before you ask the question. Specifically regarding logical standby databases, they are a great idea but in my mind they are still new enough (and I've seen a bugs enough) that I don't trust them yet for mission critical application failover. I might consent to using one in combination with at least one physical standby if needs and resources allowed. Still, for right now, if my requirements dictated a standby database, I'd go physical. RAC, OTOH, is there to meet HA requirements, not DR requirements (unless you can configure a long distance RAC cluster which I have yet to see work really well yet). RAC is an added cost option to Oracle, with it's own set of headaches that may or may not be worth your time and money. Again, it depends on your needs, budget and SLA's. If you need four 9's uptime, then RAC may well be the way to go. If you have a rather stable system, and your users can stand an outage, then perhaps you do not need RAC. Again, you must define the requirements first, then look for the solutions. question 2: Among the questions is whether this is a series of databases for each unit or a central database that is shared by all? My personal rule about this is that if a given application is going to largely share data with another existing application, and there are no good reasons to separate them into their own databases (for example wildly different SLA's with regards to HA or DR), then I will simply use the same database. This avoids problems with disparate data issues (and saves a bit of memory and CPU). However if the application is self-contained, or if it uses data feeds from several systems (which is much more frequent in my experience) then it goes into it's own database and we have to decide how we are going to feed it data. HTH!!! Robert -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8i OCP Question
B is the correct answer. Incremental backups are supported in archivelog and noarchivelog mode. Rman does not require a recovery catalog. RMAN is not compatible with EBU RMAN works just fine to disk. Robert Oracle9i RMAN Backup and Recovery Freeman -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/17/2003 3:25 PM The answer is D; RMAN does not require a recovery catalog RMAN only supports multi-level incremental backups when DB is in Archivelog mode RMAN is NOT compatible with EBU -Original Message- Jay Wade Sent: Tuesday, June 17, 2003 2:45 PM To: Multiple recipients of list ORACLE-L Hello: I'm taking a 8i Backup Recovery Practice test and believe the answer key might be off. Question Which statement regarding Recovery Manager with a database operating in NOARCHIVELOG mode is true? A) Recovery Manager requires a recovery catelog B) Recovery Manager syooirts multi-level incremental backups C) Recovery Manager is compatible with Enterpise Backup utility D) Recovery Manager only works in conjunction with a tap subsystem Anwser key says that D is the correct answer. I would say that C is the correct answer since only a full offline backup can be performed. Thanks in Advance, Jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary W. Parker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Inverse 9i Question
The correct answer is C. No points for Joe's answer since it's not supported. Oracle9i supports renaming of column names, constraint names, and you can drop columns (note I didn't say new features as drop column was in 8i too as I recall). Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/13/2003 6:49 PM Ramon, I think you are right, Frankly speaking I missed 'c'. What our judge(Robert) says? Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 13 Jun 2003 15:19:39 -0800 I would go with A and C Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- CP Sent: Friday, June 13, 2003 6:15 PM To: Multiple recipients of list ORACLE-L I think, it should c: (The ability to rename a tablespace). Thanks CP [EMAIL PROTECTED] wrote: Robert If I am not wrong..without looking at your book or any 9i doc...The answer is a. The ability to Rename a Column Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 13 Jun 2003 12:09:54 -0800 Just in the mood to do one of these Which of the following is *not* a feature of Oracle 9i? a. The ability to Rename a Column b. The ability to Rename a Constraint c. The ability to rename a tablespace d. The ability to drop a column e. The utl_xplan function to format execution plans from the SQL prompt. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with [EMAIL PROTECTED] http://shopnow.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: CP INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from
RE: SYS not able to GRANT -- Strange !
Yep, 9i allows sys to grant privs on objects in other schemas. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/12/2003 11:34 PM its always been that way, its not strange, sys has NEVER been able to grant privs on other owner's objects. i think that has changed in 9i but its late and my brain is fuzzy. joe Prem Khanna J wrote: Guys, CONNECT SYS AS SYSDBA; create user testuser1 identified by testuser1 ; grant connect, resource to testuser1; create user testuser2 identified by testuser2 ; grant create session to testuser2; create table testuser1.table1 ( a int ) ; grant select on testuser1.table1 to testuser2; error at line 1: ora-01031: insufficient privileges WHERE AS : connect testuser1/testuser1; grant select on testuser1.table1 to testuser2; grant succeeded. why is it so ? why sys is not able to GRANT ? seems to be strange ! the env. is 8.1.6.0./win2k. Jp. -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the CACHE -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Inverse 9i Question
Just in the mood to do one of these Which of the following is *not* a feature of Oracle 9i? a. The ability to Rename a Column b. The ability to Rename a Constraint c. The ability to rename a tablespace d. The ability to drop a column e. The utl_xplan function to format execution plans from the SQL prompt. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 91 questions...
tahiti.oracle.com for the docs, yes 9i is there. RBS or AUM are mutually exclusive. plug I'd like to suggest my book, Oracle9i New Features (Oracle Press) to get a good overview of 9i's biggest new features. /plug RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/12/2003 2:34 PM we're looking to upgrade to 91 later this year, so the boss wants me to do some research.;-) leads me to two questions: 1) are the docs online at technet? [i can't get to technet right now, needs a little tuning on our security policies.;-)] 2) how does AUM work? instead of RBS? in conjunction with RBS? [we have several duhvelopers who manage to run out of RBS no matter how much they're given.;-)] thanks, -- Bill Shrek Thater Oracle DBA [EMAIL PROTECTED] -- Zaphod Beeblebrox: Computer, if you don't open that exit hatch pretty damn pronto, I shall go straight to your major data banks with a very large axe and give you a reprogramming you will never forget, capisco? [Pause] Okay. Get the axe. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rule Based Optimizer
I remember CBO in 7.1.6 on AIX... RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/10/2003 6:45 PM I first saw the CBO in 1994 if IIRC. Seems to me it was introduced in 7.2. I'm sure Mogens knows for sure. :) Jared Ryan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/10/2003 04:19 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Rule Based Optimizer there not really quitting cold turkey its been phased out. wasnt the CBO introduced in 1997? Or was it earlier than that. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 6:44 PM RWB, I'll tell you, if KG says it about Oracle, I pretty much would go to the bank with it. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/10/2003 4:24 PM Mr. Gopalakrishnan: How do you know this? Can anyone confirm (or deny) this? I hope it is true! Oracle should just quit cold turkey and not support the RULE optimizer at all in any future releases. RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] .com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Rule Based Optimizer ity.com 06/10/2003 12:59 PM Please respond to ORACLE-L RULE optimizer will not be supported in next version. But you can still use the RULE optimizer and it is just a matter of official support from Oracle. Best Regards, K Gopalakrishnan -Original Message- Goulet, Dick Sent: Tuesday, June 10, 2003 10:16 AM To: Multiple recipients of list ORACLE-L There appears to be a number of folks on the list who have some insight into the next version of the database. I'd like to ask those folks a simple question. What is the future of the Rule Based Optimizer looking like? Does it die in 10i?? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message
RE: Rule Based Optimizer
RWB, I'll tell you, if KG says it about Oracle, I pretty much would go to the bank with it. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/10/2003 4:24 PM Mr. Gopalakrishnan: How do you know this? Can anyone confirm (or deny) this? I hope it is true! Oracle should just quit cold turkey and not support the RULE optimizer at all in any future releases. RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] .com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Rule Based Optimizer ity.com 06/10/2003 12:59 PM Please respond to ORACLE-L RULE optimizer will not be supported in next version. But you can still use the RULE optimizer and it is just a matter of official support from Oracle. Best Regards, K Gopalakrishnan -Original Message- Goulet, Dick Sent: Tuesday, June 10, 2003 10:16 AM To: Multiple recipients of list ORACLE-L There appears to be a number of folks on the list who have some insight into the next version of the database. I'd like to ask those folks a simple question. What is the future of the Rule Based Optimizer looking like? Does it die in 10i?? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone installed Oracle 9.2 RAC on solaris 9
Veritas only certifies Storage arrays that support SCSI-III persistent reservations so that leaves XIOtech out as the storage array using Veritas DBE/AC 3.5. Well, you just killed her budget! RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/5/2003 4:40 PM Lizz, Here are a couple of things you will need if you want to implement RAC on Solaris 9 with Veritas DBE/AC 3.5. Veritas only certifies Storage arrays that support SCSI-III persistent reservations so that leaves XIOtech out as the storage array using Veritas DBE/AC 3.5. If you use Solaris 9 and Veritas DBE/AC 3.5 you will have to use update 3 or apply a patch (which I am not sure of at this time) to fix a problem with the /dev/sd driver and SCSI-III persistent reservations. Hope this helps, Scott --- laura pena [EMAIL PROTECTED] wrote: We have been given the funding to install a production Oracle RAC environment. I am wondering if Solaris 9 has any bugs we should know about. Looks like we will be installing the following: Oracle 9.2 (64-bit)RAC Solaris 9 (64-bit) Veritas DBE/AC version 3.5 - Veritas has a advanced cluster for Oracle9i Real Application software. Our storag media is on a SAN solution using XIOtech and we will need to order an HBA. Any information on bad ideas/gotchas would be most welcomed. Many Thanks, -Lizz - Do you Yahoo!? Free online calendar with sync to Outlook(TM). __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
10i
Got my first look at the 10i beta last night. I can't tell you much about it except to say that looking at some of the new stuff h ;-) While I'm certain many of the new features will not work perfectly for several releases afterwards, they look very cool! RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: skip scan index
on skip scan indexes before but I can't find the specific reference at the moment. Rachel __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unbreakable, my buns. Upgrade to 9.2/w2k
and THAT is the reason NOT, repeat, NOT to use the OUI to do upgrades. Do 'em manually, I've had a very good success rate that way. Never trust the GUI's. Never. Robert (self-proclaimed GUI biggot) -Original Message- To: Multiple recipients of list ORACLE-L Sent: 5/28/2003 11:56 AM I was not able to upgrade an 8.1.7.0 database to 9.2.0.1.0 on Win2K. I had to create a new Oracle home, install 9.2, and clone the database in 9.2. OUI did not upgrade successfully. Koivu, Lisa Lisa.Koivu To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @Fairfieldresort cc: s.com Subject: Unbreakable, my buns. Upgrade to 9.2/w2k Sent by: root 05/28/2003 12:25 PM Please respond to ORACLE-L For those of you who have upgraded to 9.2 on w2k: How many of you have ended up with such a hosed server that you had to completely wipe Oracle off of it and start with a fresh install (9.2)? It was spectacular! I ended up in this situation and I sure hope it's something I did or didn't do. I sure don't have time for this when I upgrade my production databases. How I long for those days wading through problems in unix... it was so much easier and more enjoyable... I will say this was definately a learning experience. And Tom Mercadante, your document worked like a charm, and saved my a$$... Muchas Gracias! Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: skip scan index
I've had a couple kick in where full scans were happening before (badly tuned SQL with out a proper index) and in one case I saw a three index and-equal become a skip scan. I'm about 70/30 against skip scans on performance improvements with hints. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 5/28/2003 11:35 AM I've done a little bit research and testing on this and one thing that I've found is that the optimizer will only choose a skip-scan route if the leading column of the index is relatively non-selective. I haven't been able to pin down how non-selective it has to be, but I've never had one kick in with a unique leading column, and it always seems to choose one if the leading column of the index has only a few distinct values in it. --Brian -Original Message- Sent: Wednesday, May 28, 2003 5:00 AM To: Multiple recipients of list ORACLE-L Okay, I have a developer here who has been reading the docs (this can be dangerous!) we are adding functionality to one of our applications, this will involve using multiple fulfillment houses, so we'll be adding the fulfillment vendor id to the order table. Easy, this is not a problem. We want to be able to search by order date and by fulfillment vendor id/order date Traditional design would be to add two indexes: one on order date, and a concatenated one on fulfillment vendor id/order date. The developer is telling me to create a skip scan index instead of two different ones. MY reading in the FM tells me that skip scan index is not a type of index, but rather a way Oracle uses to use an index even if the leftmost column is not in the query. Is there any benefit in my building only the one index? Our order volume is not so high (and never will be) that there is a visible performance impact if I have the two indices. This is 9i, 9.2.0.1, will be upgrading to 9.2.0.2 in the near future. Solaris Any suggestions/comments/war stories would be appreciated. I know I've seen Jonathan post on skip scan indexes before but I can't find the specific reference at the moment. Rachel __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hengen, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
