RE: ADMIN PLZ REPLY - FW: !!Please Read - Oracle-L moving!!
Bruce, Thanks for all your work, support, and honesty. It's appreciated. Henry -Original Message- Bruce A. Bergman Sent: Thursday, January 22, 2004 11:14 AM To: Multiple recipients of list ORACLE-L Yes, this is legitimate. Jared and I have been talking recently about this. This list has just outgrown what Fat City can handle. While I'd like to think that I've always provided adequate-to-good service for the list, it's never been "great", and with the list growing, and traffic growing, my concern is that I just won't be able to continue to give the list good service. It makes me sick to think that, because I really have enjoyed giving back to the Oracle-L community, and because y'all have supported ME so well in the past, but I just don't want to see anything deteriorate simply because the volume exceeds what we can handle here. The list archives here will be available as long as Fat City continues to be in existence, so those of you who are searching for old topics are quite welcome to use the facilities here. It won't be going away. Jared has always been an awesome list owner, and I know he'll continue to make sure the list is successful. This move is just an indication of the relevancy and successful growth of the Oracle-L list, and I know it will continue. I wish you all the best in your new home, and I'll see you over there in a minute. :-) thanks, bruce bergman ListMaster, Fat City Hosting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman 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: Poras, Henry R. 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: List problems (duplicate?)
For the record, I've been having the same problem at two email addresses. Iguess one question is whether it is consistently the same email that no onegets. If it's my mail gateway seeing it as spam, will everyone see it as spam?For example I got Dan's "Partioning question (duplicate?)" email from lateyesterday afternoon, but I never got the original post (even though I see it onthe fatcity.com website). Obviously Dan never got the original post either. Didanyone? This might help to narrow down the source of the problem. Henry -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Thursday, January 15, 2004 1:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: List problems> Is this still being worked on? I'm not seeing a lot of volume nor> anything I've sent recently. Funny you should ask.If you go to fatcity.com you will see that all email is arriving there unmolested. Several emails I sent did not appear in my inbox at 2 different addresses, yet they are on the server at fatcity.com. The most likely problem is that something is happening to them after they leave fatcity. The question is what. fatcity is on an ISP (RoadRunner ) that happens to allow dynamic IP addresses, a favorite tactic of spammers. RoadRunner therefore frequently is seen on blacklists, though fatcity is not responsible for any of the spam.That's one possibility. There are others. * your mail gateway is intercepting it as spam * your company's spam filter is deleting it. * ... ? Fatcity ( aka Bruce Bergman ) provides this service to oracle-l free. As such, there's a limit to how much time he can spend on this. Bruce has become an IS director and finds that his time is rather limited. Imagine that? ;) The number of subscribers experiencing this problem, or at least reporting it, is very small. Options are to ride it out, or find a new venue for this list. As moving this list is a fair amount of work, I'm for riding it out for awhile. Jared "Stephen Andert" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/15/2004 08:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: List problemsJared/Bruce:Is this still being worked on? I'm not seeing a lot of volume noranything I've sent recently.Stephen>>> [EMAIL PROTECTED] 01/14/04 07:54AM >>>Folks,It seems that a fair number of emails are notbeing retransmitted to the list. Some of mineand a few others have not appeared in list trafficsent out to subscribers.Searching by author at fatcity.com reveals that the posts made it there, but either are not beingsent out, or getting shanghaied along the way.I'll let you know when I find out.I am of course, assuming that some of you willget this one...Jared-- 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 messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Stephen Andert INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Trigger Question
You can do some funky stuff with Autonomous Transactions (trigger independent from initiating transaction), but I need lots more coffee before even attempting more detail on this. Henry -Original Message- Mladen Gogala Sent: Thursday, January 08, 2004 2:45 PM To: Multiple recipients of list ORACLE-L Row has not been commited yet. The AFTER INSER trigger fires after the row has been inserted. Rollback can still undo all the changes performed by both insert and trigger. And no, trigger cannot select from the table it is defined on, not even through a procedure. On 01/08/2004 02:24:25 PM, Nuala Cullen wrote: > > Hi All, > > Firstly my apologies if this seems like a very *stupid* question but I'm a > tad confused (and it's late in the evening) > > When an AFTER INSERT trigger is fired (row level) has the row been committed > to the database at this stage? > > If so is it ok to call a package in the trigger that selects that row and > changes some values in the row? > > Thanks, > > N. > > -- 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: Poras, Henry R. 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]: another OCP question -- help me guys
what you lose in worth you gain in self-worth. Henry -Original Message- Ryan Sent: Wednesday, January 07, 2004 10:55 AM To: Multiple recipients of list ORACLE-L degrees and ocps often do alot more than get you past the HR department. most jobs these days are short term temp jobs. temp companies offer you salary based mainly on your resume. most technical interviews are a joke. I can make more money if I double my experience level and have a computer science degree from harvard, while at the same time halving my skillset and performance. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 07, 2004 10:29 AM > Rachel Carmichael scribbled on the wall in glitter crayon: > > > Oh yeah -- how does having a college degree in art history make a > > person a better DBA? how does my degree, which is in computer science > > but which is 28 years old, have anything to do with current > > programming and database work? > > it gets you past the HR department so you actually get to talk to someone. > trust me, i know all about this one having neither a degree or an OCP. and > having lost jobs to those art history degree holders. [and yes i have been > asked to go back to those same places as a consultant to fix the mess. and > no i didn't.] > > -- > Bill "Shrek" Thater ORACLE DBA > "I'm going to work my ticket if I can..." -- Gilwell song > [EMAIL PROTECTED] > > You see, wire telegraph is a kind of a very, very long cat. You pull his > tail in New York and his head is meowing in Los Angeles. Do you understand > this? And radio operates exactly the same way: you send signals here, they > receive them there. The only difference is that there is no cat. - Albert > Einstein, when asked to describe radio > -- > 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: 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: Poras, Henry R. 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[1]: OCP question from Boson practice tests
or from the other side: the right one, and the one pig-headed students are convinced is right (even if you can incontrovertably demonstrate they are wrong). Does that make three answers? or two answers with three labels? Henry -Original Message- Carel-Jan Engel Sent: Wednesday, January 07, 2004 12:05 PM To: Multiple recipients of list ORACLE-L Wasn't it you, Cary, who got tought by his parents that every question has two answers: The right one and the one the teacher wants to hear? And you had to learn them both? That's merely what OCP is about, I think. Get a certificate to get hired, and get the proper knowledge to remain hired ;-) Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === At 07:59 7-1-04 -0800, you wrote: >My question, Richard, is can a person pass the exam just by studying >what is correct? Or is it necessary to work harder to acquire some >"veneer of false knowledge" specifically in order to pass the exam? > > >Cary Millsap >Hotsos Enterprises, Ltd. >http://www.hotsos.com > >Upcoming events: >- Performance Diagnosis 101: 1/27 Atlanta >- SQL Optimization 101: 2/16 Dallas >- Hotsos Symposium 2004: March 7-10 Dallas >- Visit www.hotsos.com for schedule details... > > >-Original Message- >Prem Khanna J >Sent: Wednesday, January 07, 2004 8:39 AM >To: Multiple recipients of list ORACLE-L > >Hi Richard , > >Many a thanx for both of your replies . >All my worry is : do such questions appear in the real exams also ? > >And your reply has increased my self-confidence. >particularly the line : >Trust what you *see*, not what you *read*. > >You actually proven this yourself and yet you still have doubts? > >yes Richard : ( >hope i will not repeat this as time goes and my experience grows. >i.e., i will be more confident with my answers . > >okay , coming back to the sizing of temp tablespace question . >if suppose , such a question appears in the exam too ( my bad luck ) , >what will be your two best answers ? > >Thanks and Regards, >Prem. >-- >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: 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). Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel 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: Poras, Henry R. 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: stress testing
Good catch on the array. I never noticed that. Henry -Original Message- Jared Still Sent: Monday, January 05, 2004 10:59 AM To: Multiple recipients of list ORACLE-L The patch I refer to is one I made that didn't make it into the most recent version of yapppack. YP uses an array as internal storage, and walks through it with a for i in 1..n loop. Since arrays are sparsely populated there is a fair chance of hitting an array element that does not exist. The patch consists of rewriting the loop with array.first/next/last in a while loop to avoid the problem. Yes, it is high level, but it can pinpoint time periods that you may want to investigate. Jared On Mon, 2004-01-05 at 06:19, Poras, Henry R. wrote: > Jared, > > Are you talking about yapppack? I've been using that for a while (nice display. > Though like statspack it is system wide so I usually just look for high level > stuff and changes). Not aware of a patch though. > > With most peoplesoft applications I have seen, the bottlenecks aren't database > related, though I still need to get all appropriate data. That means application > server, OS (NT for app server, Sun for Oracle), web server, ... stuff too. I'm > still trying to find what numbers the tool itself gathers, and if/how it > analyzes the stuff. In the meantime, I've been reviewing some of the papers on > orapub (i.e. Ratio Modeling, Predicting Computing System Capacity and > Throughput). > > Thanks. > > Henry > > > -Original Message- > [EMAIL PROTECTED] > Sent: Friday, January 02, 2004 2:19 PM > To: Multiple recipients of list ORACLE-L > > > > As the ultimate indicator of performance is response time, you might like to > investigate YAPP > at http://www.miracleas.dk/. The data generated gives a good indicator of > response time from > a database perspective. > > If you use it, ask me for the patch. > > Jared > > > > > > "Poras, Henry R." <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > > > 01/02/2004 10:54 AM > Please respond to ORACLE-L > > > > To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:stress testing > > > > We are planning on running some stress tests on a PeopleSoft/Oracle/Solaris > system starting next week (using LoadRunner). I have never gone through a > formalized stress test before (most of my stress is brought about informally). > So far I am planning to gather statspack information, and periodically get > vmstat from the OS. Is there anything else that I should collect? Thanks for the > help. > > Henry > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Poras, Henry R. > 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: 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: Poras, Henry R. 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: stress testing
John, Thanks for the tip. I've used sar and vmstat, but not in enough depth to have any preferences. So far I don't have permissions for sar at this site, but I should be able to get that. Henry -Original Message- John Kanagaraj Sent: Friday, January 02, 2004 2:29 PM To: Multiple recipients of list ORACLE-L Henry, Sar is a better tool than vmstat/iostat as it collects a broad range of information. Specifically, sar -q should show up CPU queueing and swapping, and sar -v will show up file/process table overflow issues that may occur during stress testing. IMHO, sar is quite underutilized ( had a paper on this last IOUG, but couldn't go and present it :( John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** >-Original Message- >From: Poras, Henry R. [mailto:[EMAIL PROTECTED] >Sent: Friday, January 02, 2004 10:54 AM >To: Multiple recipients of list ORACLE-L >Subject: stress testing > > >We are planning on running some stress tests on a >PeopleSoft/Oracle/Solaris >system starting next week (using LoadRunner). I have never >gone through a >formalized stress test before (most of my stress is brought >about informally). >So far I am planning to gather statspack information, and >periodically get >vmstat from the OS. Is there anything else that I should >collect? Thanks for the >help. > >Henry > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Poras, Henry R. > 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: John Kanagaraj 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: Poras, Henry R. 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: stress testing
Jared, Are you talking about yapppack? I've been using that for a while (nice display. Though like statspack it is system wide so I usually just look for high level stuff and changes). Not aware of a patch though. With most peoplesoft applications I have seen, the bottlenecks aren't database related, though I still need to get all appropriate data. That means application server, OS (NT for app server, Sun for Oracle), web server, ... stuff too. I'm still trying to find what numbers the tool itself gathers, and if/how it analyzes the stuff. In the meantime, I've been reviewing some of the papers on orapub (i.e. Ratio Modeling, Predicting Computing System Capacity and Throughput). Thanks. Henry -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Friday, January 02, 2004 2:19 PMTo: Multiple recipients of list ORACLE-LSubject: Re: stress testingAs the ultimate indicator of performance is response time, you might like to investigate YAPP at http://www.miracleas.dk/. The data generated gives a good indicator of response time from a database perspective. If you use it, ask me for the patch. Jared "Poras, Henry R." <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/02/2004 10:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: stress testingWe are planning on running some stress tests on a PeopleSoft/Oracle/Solarissystem starting next week (using LoadRunner). I have never gone through aformalized stress test before (most of my stress is brought about informally).So far I am planning to gather statspack information, and periodically getvmstat from the OS. Is there anything else that I should collect? Thanks for thehelp.Henry-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Poras, Henry R. INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
stress testing
We are planning on running some stress tests on a PeopleSoft/Oracle/Solaris system starting next week (using LoadRunner). I have never gone through a formalized stress test before (most of my stress is brought about informally). So far I am planning to gather statspack information, and periodically get vmstat from the OS. Is there anything else that I should collect? Thanks for the help. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Poras, Henry R. 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: Should we stop analyzing?
o: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Poras, Henry R. 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: Should we stop analyzing?
Wolfgang, I don't have 9i available at the moment so I can't test this. Just wondering if a 10053 trace shows you if the statistics it is using are gathered from dynamic sampling. Henry -Original Message- Wolfgang Breitling Sent: Tuesday, December 30, 2003 6:24 PM To: Multiple recipients of list ORACLE-L The CBO will do dynamic sampling automatically provided the conditions are met. The conditions that need to be met depend on the dynamic_sampling initialization parameter in effect for the session. The default is 1 which practically disables dynamic sampling. 0 will totally disable it but IMHO the conditions for dynamic_sampling=1 are so rare (in practice) that one can regard it as off. BTW, even if the CBO goes to dynamic sampling that does not guarantee that it will use the statistics it did gather this way. At 03:24 PM 12/30/2003, you wrote: >Tanel, > >I know the values, you are missing my question ... let me re-phrase it ... > >1. To have CBO use dynamic sampling do you have to specify the hint? >or >2. CBO will do that automatically? > >Just to let you know, Oracle 9ir2 docs main page is my home page on >Mozilla firebird browser and Metalink is my homepage on IE. >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: Tuesday, December 30, 2003 2:44 PM >To: Multiple recipients of list ORACLE-L > > >Go to tahiti.oracle.com and search for the optimizer_dynamic_sampling >parameter, you'll see descriptions for it's different values there. > >Tanel. >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Jamadagni, Rajendra > 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: Poras, Henry R. 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: Should we stop analyzing?
Makes sense, BUT... "If the data changes A LOT you should of course re-analyze." is assuming you know when that happens. You are assuming communication between users, developers, and DBAs. Communication is my New Year's Resolution. I would at least suggest exporting stats before changing them. Then there are all the extra problems such as retaining histograms with 8i, applications which constantly insert/delete from temporary tables (not Oracle temp tables), ... Henry -Original Message- >>But then I listened to Dave Ensor at the UKOUG conference, and he said roughly this: * Stop analyzing after the first analyze. It's the new stats that cause the optimizer to change execution plans. * "I know that big tables tend to stay big. Small tables stay small. Unique indexes stay unique and non-unique indexes stay non-unique..." * If the data changes A LOT you should of course re-analyze. Mogens << -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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: Poras, Henry R. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL CASE Statement
You forgot to squeeze the lemon juice on your monitor. Henry -Original Message- Jared Still Sent: Tuesday, December 30, 2003 1:35 AM To: Multiple recipients of list ORACLE-L Is is just me, or is the code missing? On Mon, 2003-12-29 at 16:24, Pillai, Rajesh wrote: > Hi Jared, > Here is an example - > The following part of unix script does not work- > -- 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: Poras, Henry R. 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 - LHC
t; 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: Bobak, Mark > 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: 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: Poras, Henry R. 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: select via dblink does not use index
Yechial, It's been a couple of years since I worked on tuning queries with db links, but a couple of issues come to mind:is the correct table being used for the inner table of the join, is too much data being sent over the network. -is the correct table being used for the inner table: I remember in earlier versions of Oracle, the local table was always the driving table. I don't know if that is stll the case, but it would be clear from the explain plan. The smaller table (local_table) should be the inner table of your hash join. Of course if this is the case, the full 1M records of the remote_table are being pulled across and compared to the hash table. ( a 10046 trace should help show if this is where the time is going) -is too much data being sent over the network: Assuming your result set is much smaller than the number of records in your remote table, you can run the query on the remote side and then bring back the result set. On the Target database create a view (create view my_remote_view as select * from target_table, [EMAIL PROTECTED] where ...). Kick off the query from your source database using (select * from [EMAIL PROTECTED]). The query is run on the remote side with only the result set passed back. Of course you now have to check if the correct table is being used as the inner table for the hash join (see the first point). If not, a different execution plan might be necessary. There also might be some newer features provided for distributed queries which I haven't had the chance to use yet. Henry -Original Message- Adar Sent: Thursday, December 04, 2003 8:29 AM To: Multiple recipients of list ORACLE-L Here are all the details: Source database 9.2.0.4 (upgrade from 8.1.6.3.4). Target database 8.1.6.3.4. View definition: create view my_view as select * from [EMAIL PROTECTED] Sql: select * from local_table , my_view where local_table.branch = 1 and my_view.customer = 200 + local_table.branch * 1 + local_table.customer; All tables are analyzed. There are about 300 records in local_table and 1M records in remote_table. My_view.customer is primary key of target_table. Where branch =1 is a set of 65 records. Optimizer_mode=choose in both databases. Explain plan: Hash join between FTS on local table and remote (in/out = serial). Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar 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: Poras, Henry R. 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: View definition oddities
Jared, Thanks, but what I was wondering is how the views got created in the first place. If the field name needs an alias (i.e. substr(x,i,j)) and you include this alias in the CREATE VIEW ddl, it will also appear in dba_views.text. If you don't include the alias in the DDL, the view won't be created. Yet we have views with no aliases in dba_views.text, yet these aliased (column names) are in column_name.dba_tab_columns. Also, if I just run the script from dba_views.text I get the error saying I need the alias. How did these views get into the database? Henry -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Wednesday, December 03, 2003 4:54 PMTo: Multiple recipients of list ORACLE-LSubject: Re: View definition odditiesThe DBA_VIEWS view does not include the column names in the view. If you are really diligent, you could probably tear apart a trace file and learn how oracle is reassembling the view from the DD. A hard parse on a view can produce 250k of trace file. It is easier to recreate by generating the ddl from a combination of all_tab_columns and all_views. Been there, done that. :)Jared "Poras, Henry R." <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/03/2003 11:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: View definition odditiesI found something strange when trying to copy a view from one database toanother. I spooled the text from dba_views and ran the CREATE VIEW AS ...statement. There was an error because one of the fields needed an alias (it wasSUBSTR(xxx)). I went back to the source database and poked around a bit. Theview definition from dba_views had no field aliases, but dba_tab_columns did. For example, dba _views would show something like:View_name: testText: SELECT SUBSTR(name1,3) FROM empWhile dba_tab_columns would have:Table_name: empColumn_id: 1Column_name: enameas if the view_text was SELECT SUBSTR(name1,3) ename FROM empWhat's up here?Henry-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Poras, Henry R. INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
View definition oddities
I found something strange when trying to copy a view from one database to another. I spooled the text from dba_views and ran the CREATE VIEW AS ... statement. There was an error because one of the fields needed an alias (it was SUBSTR(xxx)). I went back to the source database and poked around a bit. The view definition from dba_views had no field aliases, but dba_tab_columns did. For example, dba _views would show something like: View_name: test Text: SELECT SUBSTR(name1,3) FROM emp While dba_tab_columns would have: Table_name: emp Column_id: 1 Column_name: ename as if the view_text was SELECT SUBSTR(name1,3) ename FROM emp What's up here? Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Poras, Henry R. 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).