Re: bash: ./genclntsh: bad interpreter: Permission denied
ltiu wrote: Hello, Could someone help me decipher the following: sh: ./genclntsh: bad interpreter: Permission denied Thanks. ltiu Comes from #!/bin/sh on the first line. You must run some kind of extraterrestrial Unix where sh is not located under /bin (perhaps /usr/bin ?). You can insert a line with : _before_ the first one (and nothing else than : in first column) but if I were you I would simply create a symbolic link to the true location of sh under /bin. I would rather guess your script (./genclntsh) don't have right UNIX-persmissions. Try set it executable: chmod +x ./genclntsh -- /Nils Höglund, Naqua KB E-mail: [EMAIL PROTECTED] Web:http://www.naqua.se/ Home Phone: +46 (0)18 30 09 19 Cellular Phone: +46 (0)709 91 97 65 Address:Nya Valsätrav. 26 B SE-756 46 Uppsala, Sweden -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?Q?Nils_H=F6glund?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: the ora certified masters cert, yet again
I absolutely am NOT saying that anyone with an OCP is incompetant, a bad person, or any other such thing. Some of the best DBAs I've known were OCP. Some weren't. Some of the very worst DBAs I've known were OCP. Some weren't. I simply think that its main value (other than the totally artifical value of being a common checklist item for hiring authorities now) is to get people to study, learn, and try things out. However, those things don't really require a certificate, ILT classes, or checks made out to Oracle. I agree that this thread is worn out. Don Granaman [OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 10:48 AM Good morning Don, I know that you are not suggesting that those with the OCP are bad persons. Listers, I suggest that we drop this topic now, since it might start to offend if it goes further. We all have much more in common that we have that divides us, and this topic is a downright silly thing to risk hurting each other over. It is worth far less than the harmony of this community. Jack OCPx4 --- Don Granaman [EMAIL PROTECTED] wrote: From my experience with a few DBAs that waved their OCP around like it was a Nobel prize, some probably should have malpractice insurance. Lots of it. Don Granaman [Certifiable OraSaurus - NOCP] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 1:08 AM But doctors have malpractice insurance and OCP does not or do/should OCP have one too. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: the ora certified masters cert
Rodd, that comment wasn't intended to imply that cheating doesn't happen. But if Oracle aren't watching for this sort of thing then anyone who's contacted with this kind of offer should be forwarding the mail to them. Cheers, Mike -Original Message- Sent: 28 June 2002 06:04 To: Multiple recipients of list ORACLE-L Mike, I am moderator on a yahoo group. Just last month we had one of these scam purveyors trying to peddle their stolen exams to list members. She was quickly banned from the list for such postings. I get at least a post or two like that sent to me every 2 -3 months. Most of the thieves I've seen are not posting from US domains. Rodd On Thu, 2002-06-27 at 07:18, Hately Mike wrote: snip I've no respect for the OCP. I saw MANY people bought the exams from many sources. I'm sure that Oracle Corp would love to hear some details about that last quote. /snip Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Tuning NON-network client-server communication
Yes, Because, in short, you still use Net8 or SQLNet or what ever they call it now. Sure the protocol adapter is different but every thing else is the same. I have seen big improvements by changing SDU/TDU with pipes on Net8. Beaware that most pipe have a max TDU limit of 5K (HP is 8K). Anjo. Tim Bunce wrote: Is there any scope for tuning NON-network client-server communication? Where the client and Oracle server are on the same machine and don't communicate via the network? Are Net8 tuning parameters like SDU size still relevant? Tim. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Bunce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: the ora certified masters cert - finally bloody sick
*** I swear this will be my last post on the issue. If I've offended anyone, they have my most sincere appology. However, I think you have interpreted this wrong. I have never said or implied, nor do I remember seeing anyone else say, that anyone with an OCP is trying to cover up for some deficiency. In the post that you replied to, I said a few... that waved their OCP around like it was a Nobel prize. These (two) people were - quite obviously. The vast majority of OCPs I've known, including many on this list, are not like that at all. Many got it because it is now a market necessity. Some got it to get an entry-level DBA position. A few that I know got it just to see if they could pass all the exams without any preparation. My problem is not with people who have it, it is with the marketing and hype that has made it mandatory - regardless of level of exerience or anything else. And also with Oracle's most recent greedy exploitation of the situation they created. Will I get it? Probably. (I don't want to be the only one left without it and it looks like Kirti's gonna go for it now. ;-) I've been lucky that my last two jobs I got because someone I had worked with previously called me (a VP and a CTO). However, when and if I have to go looking again, I'll likely need it just to clear the HR checklist hurdle and land an interview. (Unless I get lucky again). Lets see... What do I need to do in the next few months... Finish building and testing a Linux 9i RAC system, set up new software for the MML on every server and migrate all the backups it and a new tape library, diagnose and redesign | tune significant parts of a custom in-house application, move two other internal Oracle systems to bigger servers, spend a couple of weeks reviewing and hardening a client's nine exclusive Oracle8i systems in Chicago and one 8i OPS system in Texas (all but one using literally every option Oracle offers in 8i, including iFS - which I haven't yet had time/motivation to learn), do a security and architectural assessment of a prototype 8i system that another client wants to install in *thousands* of retail locations around the world, do the standard only DBA in a shop full of developers development support and production thing, work with the CTO and VP on developing a disaster recovery plan, *perhaps* write a white paper (or two) and a presentation (or two) for OOW 2002, and, oh yeah, ... study for and take about six essentially entry-level DBA exams before Oracle ups the ante again. Sorry, but if I had a choice, I'd rather sleep occassionally instead. I don't really need any more flaming hoops to jump through. I imagine there are a lot of people like me out there who feel the same way. Don Granaman [OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 4:33 AM I've been pretty quiet while you all said that the OCP program was pretty worthless because I can see your point. I don't believe that it proves that the holder is technically better than someone has isn't certified. From my point of view, though, I'm convinced that in a tight market it's helped to get me into interviews and that justifies the cost to me. Now, however, you're straying towards calling OCP DBAs liars and cheats and implying that we're dangerous to have on site and I'm sorry but I'm not going to have that. What merit is there in saying doctors have malpractice insurance and OCP ... should have one too.. Where's the evidence for that kind of witless comment? I originally took my OCP after amassing 10 years of DBA experience. I don't want to get into a pissing contest over this but it grates on me to have it constantly implied that OCP is just there to make up for lack of ability. I'm aware that many of you (Don for instance) have qualified their statements by saying that applies to a few or some but the implication is still that the majority of OCPs are trying to make up for some sort of technical deficiency. If you don't want to spend the money or the time then that's fine by me. I certainly won't it necessary to criticise you for it. Regards, Mike Hately No, really; I usually have a sense of humour. -Original Message- Sent: 27 June 2002 08:13 To: Multiple recipients of list ORACLE-L From my experience with a few DBAs that waved their OCP around like it was a Nobel prize, some probably should have malpractice insurance. Lots of it. Don Granaman [Certifiable OraSaurus - NOCP] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 1:08 AM But doctors have malpractice insurance and OCP does not or do/should OCP have one too. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Oracle Performance Tuning steps
Thanks , I looked into the database. There r some waits happening on the undo blocks (non-system) but could not figure out whether this could possibly cause such a slowdown of the system. Also there were some indexes newly created on some of the tables which are causing problems. What's the best approch anyways to hunt down the problem in a situation like this ? - Chetan BigP <[EMAIL PROTECTED]>wrote: cheten , find processid of the application , look into database waits , that will give u some hint .Also look into db buffers to find if there are full table scans flushing db buffer . btw Did u ran statistics ? -Bigp - Original Message - From: Chetan To: Multiple recipients of list ORACLE-L Sent: Wednesday, June 26, 2002 3:38 AM Subject: Oracle Performance Tuning steps Hi guys , Need some help. Actually we are looking here at a Oracle 8.1.7 db on HP-UNIX. The application was running fine uptil yesterday. Suddenly a part of the appln is running extremely slow. I can not figure what might be the problem. Wanted to track this down asap. Here is some information about the db. Database size- 20GB Optimizer - CHOOSE Disk Structure - RAID 1+0 No. of processors - 4 Block Size - 8K Archivelog mode : ARCHIVELOG Please tell me what should be the ideal way I should try to trace the problem. I thought of running UTLBSTAT/UTLESTAT or STATSPACK and asked the user to run that part of the appln. Has anybody workedwith STATSPACK before ? Can anybody tell me what shouldaccurate and fastest way to hunt down the problem ? I think its something to do with indexes or changes in the queries. Also can someone tell me the ideal backup strategy for this databaseconsidering the fact thatit's a 24x7 system. Thanks in advance . Chetan Chindarkar Do You Yahoo!?Sign-up for Video Highlights of 2002 FIFA World CupDo You Yahoo!? Sign-up for Video Highlights of 2002 FIFA World Cup
AQ and Enterprise Edition
Hi all I like to know whether to use Advanced Queue you need the ORacle Enterprise edition 8i or above or does it come with standard edition also ? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alroy Mascranghe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: the ora certified masters cert - finally bloody sick
I kind of regret perpetuating this thread now. It should have died gracefully on Wednesday really. You seem to have a quiet year ahead of you Don. Plenty of time left for hoop-jumping =) Unfortunately it now seems to be an even heavier financial undertaking than it used to be. It brings it home to you when people are talking about blowing their 'boat budgets' and suchlike. Rather than imposing mandatory course attendance it may have been an idea for Oracle to actually make the exams harder to encourage people to attend courses voluntarily and to increase the number of failures/retakes. Also it would have helped the image of the OCP program. They've just strengthened the evidence (if that were needed) of OCP being simply a useful revenue stream. Never mind, I'll call it; this thread has gone. Time is now 12:16GMT. Mike -Original Message- Sent: 28 June 2002 12:08 To: Multiple recipients of list ORACLE-L *** I swear this will be my last post on the issue. If I've offended anyone, they have my most sincere appology. However, I think you have interpreted this wrong. I have never said or implied, nor do I remember seeing anyone else say, that anyone with an OCP is trying to cover up for some deficiency. In the post that you replied to, I said a few... that waved their OCP around like it was a Nobel prize. These (two) people were - quite obviously. The vast majority of OCPs I've known, including many on this list, are not like that at all. Many got it because it is now a market necessity. Some got it to get an entry-level DBA position. A few that I know got it just to see if they could pass all the exams without any preparation. My problem is not with people who have it, it is with the marketing and hype that has made it mandatory - regardless of level of exerience or anything else. And also with Oracle's most recent greedy exploitation of the situation they created. Will I get it? Probably. (I don't want to be the only one left without it and it looks like Kirti's gonna go for it now. ;-) I've been lucky that my last two jobs I got because someone I had worked with previously called me (a VP and a CTO). However, when and if I have to go looking again, I'll likely need it just to clear the HR checklist hurdle and land an interview. (Unless I get lucky again). Lets see... What do I need to do in the next few months... Finish building and testing a Linux 9i RAC system, set up new software for the MML on every server and migrate all the backups it and a new tape library, diagnose and redesign | tune significant parts of a custom in-house application, move two other internal Oracle systems to bigger servers, spend a couple of weeks reviewing and hardening a client's nine exclusive Oracle8i systems in Chicago and one 8i OPS system in Texas (all but one using literally every option Oracle offers in 8i, including iFS - which I haven't yet had time/motivation to learn), do a security and architectural assessment of a prototype 8i system that another client wants to install in *thousands* of retail locations around the world, do the standard only DBA in a shop full of developers development support and production thing, work with the CTO and VP on developing a disaster recovery plan, *perhaps* write a white paper (or two) and a presentation (or two) for OOW 2002, and, oh yeah, ... study for and take about six essentially entry-level DBA exams before Oracle ups the ante again. Sorry, but if I had a choice, I'd rather sleep occassionally instead. I don't really need any more flaming hoops to jump through. I imagine there are a lot of people like me out there who feel the same way. Don Granaman [OraSaurus] This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
RE: the ora certified masters cert, yet again
My favourite question - because you need pretty much only this one to occupy the entire interview: Over there on the far wall is a 6x6m white board. Assuming the space is an 'Oracle database', start filling the blanks in terms of memory, disks, files, caches, buffer etc with all the connecting lines. Start broadly and continue generating more and more levels of detail until you want to stop or we want you to stop. We want to know your favourite and least favourite bits At the end you have a remarkable insight into: - their knowledge on oracle database + instance - their ability to convey information. We had one guy who drew a great level of detail but literally spent 50 mins with his back to us drawing with not a single word, after which he sat back down. - their ability to do it in front of a small audience (which I think is critical for a DBA - we don't want sit-in-the-corner-saying-nothing-zombies) - their pet peeves, for example, they'll be describing temp tspace and might throw in a man, i hate it when smon takes forever to clear up space or something to that effect - their priorities (if they spend half an hour on the spin_count parameter then maybe their barking up the wrong tree) - their honesty (one key element I look for is some point where they say I *DONT KNOW* how this bit relates to this bit) It is also very controllable - you can gently nudge them from one section of oracle to another - they might be describing redo logs and you can throw in so how would they get from here to a standby? etc etc. It normally works very well - although on one occasion we asked this of a candidate and he burst into tears and ran from the room :-( I went home feeling guilty...which eventually transformed itself into a sadistic and maniacal grin :-) Cheers Connor --- Rachel Carmichael [EMAIL PROTECTED] wrote: you should come out of lurk mode more often -- those are GOOD questions and I'm going to add them to the standard list :) --- Grant Allen [EMAIL PROTECTED] wrote: Rachel Carmichael[SMTP:[EMAIL PROTECTED]] wrote: this goes back to a thread from maybe a year ago... what sort of questions do you ask on interviews. I may ask other questions based on what we are specifically looking for or building off something the interviewee says but I always include the following questions: 1) what was your worst nightmare as a DBA and how did you resolve it 2) what are you most proud of doing 3) how do you learn new things about Oracle gee, not ONE multiple choice question among them! [stops lurking for a change] I always throw in What do you like most about Oracle? and What do you hate/find-frustrating about Oracle?. Most can answer the first, but you can often get a good idea of what people have (or haven't!) experienced with their answer to the second. Ciao Fuzzy :-) [goes back to lurking] -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Re: Re:MTS performance is too bad.
FINALLY , Everything is good now. Thank you for your replies. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 28, 2002 12:33 AM I suspect that if you are getting 4030s with 50 concurrent users that you will get NO benefit from MTS, in fact it will likely cause just the problems you are seeing and you will start to get 4030s sooner than you would have before. MTS is not appropriate as a tool to address your 4030 errors if the sessions are not inactive for more than a few seconds. If the concurrent sessions are very active (check v$session's last_call_et field) and you are still running into 4030s than MTS will not help you, and can actually cause a performance hit (CPU) that is scary. The key thing to remember is that MTS provides SCALABILITY, performance is indirectly affected if at all. If you are running into 4030s there are a number of other approaches you can take as well. Application tuning is the best place to start, but more often then not, not possible. Then go to the obvious (that others have mentioned) like using statspack to get a look at the usage of your buffer cache. In your case you may have to reduce the size of your SGA to allow for more user space. Don't fall for the buffer cache hit ratio needs to be x%. If you are in an application env where most blocks are rarely seen in more than one query then you need a different approach to buffer cache tuning than hit %. This is a book in and of itself, but fairly intuitive. Given that you are stuck with your current application, the very first thing you also will want to look at is the Orastack utility to reduce the memory usage of each server process' stack. I have seen DBAs in your situation have their 4030s resolved with this alone. The other is upgrading your OS (or properly setting it) to NT EE or Win2k AS. This will allow you to use a 3gb process size. If you haven't done this it will surely fix your memory shortage (at least until you get another 50 users :)). You can also scale out by adding more nodes with OPS, although I'd strongly suggest that you move to 9i before doing this! Finally, you can use OPS/RAC on a single box, a bit of a fancy trick, but it allows you to have multiple instances if you have the system memory available. Ramble, ramble, ramble, for more info you can come to my presenation at OpenWorld (or just send more info/questions!) Regards, Michael Sale Author: Oracle9i for Windows(R) 2000 Tips Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626 -Original Message- Karadeniz Sent: Thursday, June 27, 2002 8:33 AM To: Multiple recipients of list ORACLE-L Michael , I have tried all of them , but still performance is very bad. When switch to dedicated mode I get ora:04030.. Have you ever switched to MTS and seen the same performance , I wonder if you are sure about MTS performance is good. What ever I did did not give the same performance as dedicated connections even not approached. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 4:53 PM You really don't need MTS with no more than 50 concurrent users unless you are running into ora-4030s or other memory problems. When you say performance is a problem, have you check OS swapping of memory to disk? Your SGA might be too big (with AS and the 3GB switch no bigger than 3GIG, without the 3GB switch only 2GB) and end up swapping out to disk. You also need to make sure that only OLTP users (users with short txns, NOT long running batch jobs, big updates, etc) are connecting via MTS. All batch/DSS type users should be connecting via dedicated server. You can have them specify this in their tnsnames.ora. That said, your MTS config is WAY out of whack given the number of concurrent users: You only need ONE dispatcher to start with. Change dispatchers to 1 unless you have multiple NICs you are working off of for a particular segmentation of users. (50 dispatchers would be appropriate for about 12,000 Concurrent users) If your total number of concurrent OLTP users is truly 50 set your min servers to 60. Max servers is fine. You should also set your large pool instead of a massive shared pool, all kinds of reason for doing this!! If you have a chance go to borders or barnes and noble, sit down and read chapter 7 (Oracle Connectivity) of my book Oracle9i for Windows 2000 Tips Techniques. It covers the setup, monitoring and basic tuning of MTS. I hope this helps, Mike Sale mts_max_servers=750 mts_min_servers=100 dispatchers=50 users total 750 users concurrent at most 50 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 9:58 PM Bunyamin,
Re: Oracle Performance Tuning steps
Please run STATSPACK - which will give systemwide database performance diagnostics - you could check the hitratios, top wait events and resource consuming queries once report taken - upload it to www.oraperf.com - for suggestions check metalink article NOTE.149121.1 Gathering a StatsPack snapshot - if you can log into metalink Thanks, Kavi Chetan wrote: Thanks , I looked into the database. There r some waits happening on the undo blocks (non-system) but could not figure out whether this could possibly cause such a slowdown of the system. Also there were some indexes newly created on some of the tables which are causing problems. What's the best approch anyways to hunt down the problem in a situation like this ? - Chetan BigP<[EMAIL PROTECTED]>wrote: cheten ,find processid of the application , look into database waits , that will give u some hint .Also look into db buffers to find if there are full table scans flushing db buffer . btw Did u ran statistics ?-Bigp - Original Message - From: Chetan To: Multiple recipients of list ORACLE-L Sent: Wednesday, June 26, 2002 3:38 AM Subject: Oracle Performance Tuning steps Hi guys , Need some help. Actually we are looking here at a Oracle 8.1.7 db on HP-UNIX. The application was running fine uptil yesterday. Suddenly a part of the appln is running extremely slow. I can not figure what might be the problem. Wanted to track this down asap. Here is some information about the db. Database size - 20GB Optimizer - CHOOSE Disk Structure - RAID 1+0 No. of processors - 4 Block Size - 8K Archivelog mode : ARCHIVELOG Please tell me what should be the ideal way I should try to trace the problem. I thought of running UTLBSTAT/UTLESTAT or STATSPACK and asked the user to run that part of the appln. Has anybody worked with STATSPACK before ? Can anybody tell me what should accurate and fastest way to hunt down the problem ? I think its something to do with indexes or changes in the queries. Also can someone tell me the ideal backup strategy for this database considering the fact that it's a 24x7 system. Thanks in advance . Chetan Chindarkar Do You Yahoo!? Sign-up for Video Highlights of 2002 FIFA World Cup Do You Yahoo!? Sign-up for Video Highlights of 2002 FIFA World Cup begin:vcard n:;Kavitha x-mozilla-html:FALSE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] fn:Kavitha Muthukumaren end:vcard
Hints being ignored
All Oracle 8.0.5.0.0 Tru64 4.0f Select statement as follows. The hint is being totally ignored. Any ideas ?? Regards Lee SELECT /*+ INDEX(CONSUMER_COMM_D2C CONSUMER_COMM_D2C_PK) */ i.household_id || '|' || 'd' || '|' || d.promotion_item_id || '|' || xp.campaign_id || '|' || xp.document_id || '|' || xp.segment || '|' || xd.contact_type_code || '|' FROM genex_individual i , consumer_comm_d2c d , x_promotion_item xp , x_document xd WHERE i.brief_name = '$brief_name' AND i.individual_id = d.consumer_id AND d.promotion_item_id = xp.promotion_item_id AND xp.document_id = xd.document_id ORDER BY i.household_id ; Table CONSUMER_COMM_D2C is as follows Name Null? Type--- CONSUMER_ID NOT NULL NUMBER(9)PROMOTION_ITEM_ID NOT NULL NUMBER(9)COMMUNICATION_DATE NOT NULL DATECOMMUNICATION_STATUS_CODE VARCHAR2(2)COMMUNICATION_DETAIL VARCHAR2(500)BLOCK_LDT NOT NULL DATEROW_CHANGE_SOURCE NOT NULL NUMBER(9)ROW_CHANGE_TIME DATEROW_CHANGE_USERID VARCHAR2(50) Index CONSUMER_COMM_D2C_PK is built as follows consumer_id promotion_item_id communication_date. The table is partitioned on promotion_item_id and the indexes on the partitions are local Explain plan is as follows Operation Object Name Rows Bytes Cost TQ In/Out PStart PStop SELECT STATEMENT 1440 G 106 G SORT ORDER BY 1440 G 171770G 106 G MERGE JOIN 1440 G 171770G 17 M SORT JOIN 13 M 1G 300284 HASH JOIN 13 M 1G 10271 TABLE ACCESS FULL X_PROMOTION_ITEM 7 K 409 K 10 MERGE JOIN CARTESIAN 2 M 90 M 3206 TABLE ACCESS FULL X_DOCUMENT 1 K 25 K 6 SORT JOIN 1 K 31 K 3200 TABLE ACCESS FULL GENEX_INDIVIDUAL 1 K 31 K 2 SORT JOIN 1 G 39G 17 M PARTITION CONCATENATED 1 26 TABLE ACCESS FULL CONSUMER_COMM_D2C 1 G 39G 1352283 1 26 * The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You.
oracle installation problem
when we install oracle 8.1.6 on Windows NT following error occoured. ora-01503 : create control file failed after instalation following message desplayed - global db name :ghytwo database system identifier(sid);orcl internal account password:oracle sys acc pas. :change_on_install system account password :manager Also listener.ora file not genereted(empty) Please suggest solution. It is urgent. Atul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Atul Kumar Srivastav INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).