Re: Perf Advice Needed: cache buffers chains, high waits, _db_block_hash_buckets
Really, The only thing to do is fix the SQL. Each logical I/O or buffer get results in a cache buffer chain latch get. So by doing less LIO, you will get fewer latch gets and as a result fewer sleeps on latches. This is how you fix the *problem*. You can also fix the *symptom*: bump up _spin_count (assuming that you run on a SMP) or set _db_ block_hash_latches to a higher value. Fixing the SQL is the right way to go. Are you shooting for a 99.9 percent buffer cache hit ratio ? If you are than that could also be a reason for the problem. Oh and there is a bug in Oracle 8.1.6/8.1.7 I believe that causes an additional buffer get for the index root block (assuming that the hash latches with the high sleeps cover index root blocks). Anjo Kolk http://www.oraperf.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 7:53 AM _db_block_hash_buckets db_block_buffers = 360448 db_block_lru_latches = 4 db_block_size = 8192 _db_block_hash_buckets = 720896 Ok, what I have so far is: - using itrprof, I saw that 35% of my elapsed time was based on waits of cache buffers chains latches. - checking v$latch_children (latch#=66), there are a good number (8-10 I'd guess) of the 4096 children that have a very high (10k+) number of sleeps - the rest of the children (of this type latch) have sleep counts are 10-12, so we have a ton of contention on a low # of cache buffers chains latches. - joining with x$bh (v$latch_children.addr=x$bh.hladdr), I see that the most contentioned-for of these latches (51,240 sleeps!) has 66 blocks on the chain. Checking with all_objects, I'm noticing that these blocks are scattered in some of the more important (and most-accessed) tables and indexes - The other latch children that have high sleep counts also have 30-50 buffers in their chains Questions: - to me, 66 seems awfully high - is it? - the sleep count is obviously high from what I can tell - is it definitely tied to the buffer chain this latch is protecting being so long and just happening to be 66 buffers that are mostly important tables and indexes? - I haven't set it by hand, but _db_block_hash_buckets = 720896 and this is 11 * 2^16. Everything I've read says it should be a prime number (and that jives with my comp sci background) - why is it not prime, why is it exactly twice db_block_buffers? - the number of children for cache buffers chains is 4096. Now, increasing that could have a positive effect on distributing the contention, but since the sleps are so heavily skewed to only a few of the children as it stands, I don't get the feeling that's the right fix. Anyone have any advice to offer? Pages/URL's that can help give some advice? It's worth noting that these latches are basically non-existant as wait events at low load - log file sync is about the only wait event I see at low loads, and I'm working on reducing my commit counts much further to help tackle that. Thanks!! James -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Manager decrees his data warehouse design. Help!
Hello Don In a more serious mood: DO IT. I also had some arguments with my boss over the years and except for 2-3 cases (in 20 years) that I told my boss that I will not do something and if he wants it he can do it himself, my motto was if he wants to waste resources for something that is obviously an error let him waste it. He wants you to waste time and disk space on a system that the users will not use: waste your time and the resources. He is management and he is the one who calls the shots. Just document everything to cover yourself later. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Don [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 27, 2002 8:48 AM To: Multiple recipients of list ORACLE-L Subject: Manager decrees his data warehouse design. Help! I've lost patience, my temper, and I'm about to quit a job because the IT manager has decreed that we will have his data warehouse running within 24 hours, and we will use his design. 1 - We are NOT to use any kind of views, not even materailzed views. 2 - we are not to do any computations, summaries or rollups 3 - we are to have everything in one table 4 - the table name and column names will be meaningful to any clerk 5 - we are not to start or snowflake designs. That's just a bunch of high power talk. 6 - all users will be trained to use MS Access to get at their data. (These are users that were just converted off from green screen teminals within the last 45-days, to Windows 98 with 64k RAM.) 7 - We are not to just copy the legacy transactions. 8 - We are to load into an Oracle table, all legacy transction data because we don't want to limit how or what a user will look at 9 - It is not necessary to talk with the users to see what data they want to look at, or the atomic level. They are smart enough to fighure this out on their own. We just need to provide them the data. 10 - There shall be no long term maintenance required by the dw. Any ideas on how to deal with this situation? For tomorrow, I've done a CTAS from a materialized view that we created to support one departments known requirements. Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
max open cursors exceeded
Title: max open cursors exceeded Hi! We are having problems with Oracle interMedia text and open cursors used: our instance has open_cursors et to 1000. We check the number of open cursors regularly using: break on report comp sum of curs on report select User_Name, SID, count(*) Curs from v$open_cursor group by User_Name, SID order by User_Name, SID; the corresponding sql text is extracted from the dd using: select SID, User_Name, SQL_Text from v$open_cursor order by User_Name, SID, SQL_Text; ususally, the number of open cursors used is about 300. if we are using interMedia text option, it usually rises and rises every day. after bouncing the instance, we are back to slightly below 300. Questions: a) MAX_OPEN_CURSORS is set to 1000 - when exceeding that threshold, we're experiencing problems; how can we monitor which users uses up all the cursors (and how many). b) What exactly is displayed when querying v$open_cursor? - I know htat there are parsed statements of the user/session - but this should be more than just a PL/SQL declare cursor... open...fetch...close cursor, right? What about statements issued in SQL*Plus or through JDBC etc.? c) The results from v$open_cursor is equivalent to the currently running transaction, right? So when are those entries removed again? When the transaction commits or when the sessions ends? Or when issuing a PL/SQL close cursor. Or are those entries overwritten? by whom? when? d) what does querying select * from v$sql_cursor return? Any ideas? This is 8.1.7 on Sun Solaris. Thanks, Helmut
RE: Upgrade directly to 8.1.7.3?
Hello Barbara I did not worked with 8.1.7 but I installed patches in 8.1.6. I think (please check this) that maybe 8.1.7.3 is just a binary and external files replacement and no scripts are run. In this case you need to run the scripts that convert the DB from 8.0.5 to 8.1.7 because they are not part of 8.1.7.3. Anyway, I would suggest that you convert the DB to 8.1.7.2 and if everything is OK upgrade later to 8.1.7.3. Upgrade like this does not need a new home and 1GB on disk. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 27, 2002 6:08 PM To: Multiple recipients of list ORACLE-L Subject: Upgrade directly to 8.1.7.3? Solaris 2.6 Oracle 8.0.5 -- Oracle 8.1 -- Oracle 8.1.7.3 I have a Solaris box with a test and a production database. I have 2 code trees: 8.0.5, and 8.1.7 patched up to level 8.1.7.2. With Oracle's blessing (really, I opened a tar), I upgraded the test database directly from 8.0.5 to the 8.1.7.2 patch level. Did not pass go. Did not collect $200. OK, here's a surprise. I still have not had an opportunity to upgrade production, which is still at 8.0.5, and now I'd like to upgrade it to patch level 8.1.7.3. However, the 8.1.7.3 patch documentation states that When migrating a database from an earlier release, you must complete the database migration to the 8.1.7 release prior to applying this patch set. If I believe this note, then I believe I must install a new code tree with a vanilla 8.17, then upgrade production from 8.0.5 to 8.1.7, then immediately upgrade again to 8.1.7.3My problem: I don't have an extra gig of space to devote to another code tree. (And obviously I want to thoroughly test the test database with exactly the same version I'll be running in production, i.e., 8.1.7.3.) I don't see a good reason not to go immediately to 8.1.7.3, especially since I was able to go directly to 8.1.7.2 with the test database, which worked nicely. However, this is a critical database, and I'd just as soon not screw it up. Any words of widsom? Thanks for any help. Barb q (Jesse: I'm currently taking classes for the q-impaired. I'm feeling much better now.) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: IMPORTING a dump from a different system
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 08:58 Hi All, I just got a dump file from Oracle 8i on an AIX system and was trying to import it in Oracle 8i on a Suse Linux System, but got the error 'IMP-00016: required character set conversion (type 46 to 871) not supported'. Can you help me out ? I know it has to do with the NLS_LANG environment variable, but if I change the character set to the one used by the AIX system i get an error while logging in to 'imp'. Can anyone help me out as to what value should NLS_lang contain ? what are the source and database character sets? 871 seems to be some of the UTF charsets, but which one is 46? note that changing NLS_LANG may not solve your problems - you can avoid unnecessary conversions by properly setting NLS_LANG but if u have incompatible character set on the two servers, it won't help you Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: moving from unix to NT
Jared It would be useful if you could point me in the right direction. I guess the real question for me is will UTL_FILE work properly when I move to NT, including on Network drives?. There seems to be some doubt amongst the listers as to whether it does. John. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: 27 February 2002 18:35 To: Multiple recipients of list ORACLE-L Subject: RE: moving from unix to NT Perl is *much* more flexible than UTL_FILE for flat file operations. There is simply no basis for comparison. The question in your case is this: Can you easily replace the PL/SQL procedures that are using UTL_FILE with a process that runs outside of the database? If so, myself and others on this list can point you in the right direction, as basics in Perl/Oracle/DBI are really not too hard. If your PL/SQL is part of a larger application and not easily removed, you may just have to deal with modifying the PL/SQL. Of course, if you had made this stuff data driven ( meta data, if you will ), this would be a non-issue. :) Jared John Dunn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/27/02 01:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: moving from unix to NT Thanks to everyone for their input into this. The only real issue seems to be UTL_FILE on network drives. 1. I was interested in the many references to Perl as an alternative to using UTL_FILE. Could any of you provide more detail. I know nothing about Perl so would be interested in how to replace the use of UTL_FILE in PL/SQL with Perl. We use UTL_FILE quite a lot for reading and writing flat files. 2. With regard to external procedures, On Unix we currently use this to call a C routine that calls the system command to run Unix commands and scripts(Korn Shell). I presume we will need to amend these commands to their NT equivalents(or can I call Windows API directly from PL/SQL? on NT) and re-write the scripts...presumably in Perl? It will probbably be Oracle 9i on NT. John -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: 26 February 2002 21:37 To:Multiple recipients of list ORACLE-L Subject: Re: moving from unix to NT I haven't tried to do this with Oracle, I just knew that you could. My use has been to change the account that is used for some of my monitors that need to see network drives. I've never had a need to make Oracle run as other than System. As for UTL_FILE, I avoid it like the plague. Perl is much cleaner and easier to use. Jared Igor Neyman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/26/02 10:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: moving from unix to NT Well, I was having all kinds of problems, when I was playing with this option, trying to make oracle service on nt to run under other then SYSTEM account. And yes, I granted this account any possible NT privilege (like ability to run/logon as a service), still didn't work. Jared, Could you share some details on this issue, if you still remember how you managed to make this working? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 1:14 PM Because Oracle on NT runs (hence executes UTL_FILE) under SYSTEM account, which does not have privileges to access network drives. You can change that if you're so inclined. ( I can't believe I'm defending Windoze. shudder ) Jared Igor Neyman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/26/02 06:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: moving from unix to NT Well, you shouldn't:) Because Oracle on NT runs (hence executes UTL_FILE) under SYSTEM account, which does not have privileges to access network drives. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 25, 2002 9:38 PM On UTL_FILE, I've never had much luck using network mounted files. Igor Neyman ineyman To: Multiple recipients of list ORACLE-L @perceptron.c[EMAIL PROTECTED] om cc: Sent by: rootSubject:
RE: Manager decrees his data warehouse design. Help!
Cable-hoarding boss? Magic! We had a completely non-technical manager a while ago. Our main billing system developed silent memory errors that were corrupting the data until one day the system wouldn't come back (Ingres, don't ask). In a high-powered emergency meeting this manager, all red-faced and full of hell asks what the problem was. Memory corruption someone replies. Right! Then why are we using memory! Get the database out of memory. I want it running off disk! Classic! Cheers, Harry Lowes Database Administrator, npower Northern Limited mailto:[EMAIL PROTECTED] -Original Message- Sent: 27 February 2002 18:29 To: Multiple recipients of list ORACLE-L Both. I was a consultant to this pharmaceutical company at the time and I honestly liked the job that I was doing, so I stuck it out. After I got over the initial shock of having an insane boss, I found the whole thing amusing. Seems he didn't trust the data center with cables for some weird reason, and after the company relieved him of his post (OH so gently), his garage had something like $30K worth of cables in it. They didn't press charges. But, MAN, there were some stories. -Original Message- Sent: Wednesday, February 27, 2002 12:14 PM To: Multiple recipients of list ORACLE-L Hi Bambi, I once had a manager who was a paranoid schizophrenic. BEEN THERE! A former boss from hell got very angry (there's a reason they call it mad) because he tried to fire me and found out he couldn't. Even so, he liked having me around because he needed me. I hung in there because the company was paying for my masters degree at the time. Later, after I got the degree, I left for greener pastures within the company. In the exit interview my former boss accused me of abandonning him, congratulated me on my move, and literally wept at my departure. He confessed he had been trying to get my goat because he was a 20 year military man who managed by intimidation. But he respected me because I was never intimidated, always stood my ground, behaved as a gentleman, and served him faithfully (his words). Two years later I saw my former boss from hell on the 6 o'clock news being put into a police squad car and with yellow crime scene ribbons around his house. Turns out that while he was being laid off he said things which were interpreted as threats on the lives of certain managers. This was taken seriously and the police confiscated all his guns. I guess the lesson is that eventually the truth will come out. The decision remains with us as to whether to put up with the insanity or move on. Do you have a high insanity tolerance level or are you just a masochist? Steve Orr -Original Message- Sent: Wednesday, February 27, 2002 9:23 AM To: Multiple recipients of list ORACLE-L I once had a manager who was a paranoid schizophrenic. Very exciting, let me tell you. But, one thing he told me in a rather roundabout paranoid way is that the way you deal with crazy bosses who were out to get you is to make friends with other people at your boss' level in the organization, hopefully who report to the same person your boss does, and let them know in a laughing kind of way what your boss wants you to do. Never be confrontational or speak ill of your boss, because, of course, that will wind up biting you in the ass, too. But, that way, when your boss starts badmouthing you and blaming you for everything that goes wrong that was his fault, you'll be insulated from having anything bad happen to you as your friends will close ranks around you and stop your boss from making your life a living hell. And then he threw his coffee cup across the room, turned bright red and started shrieking about how the VP of RD had always hated him. God, I loved that job. Many, *MANY* wonderful stories came out of that place. Anyway, I never thought to follow this advice, let alone share it, but, it sounds like, in this case, you have a crazy boss, and if you stick around, you're going to need a little safety. Of course, posting your resume isn't a bad approach either. HTH, Bambi. -Original Message- Sent: Tuesday, February 26, 2002 11:48 PM To: Multiple recipients of list ORACLE-L I've lost patience, my temper, and I'm about to quit a job because the IT manager has decreed that we will have his data warehouse running within 24 hours, and we will use his design. 1 - We are NOT to use any kind of views, not even materailzed views. 2 - we are not to do any computations, summaries or rollups 3 - we are to have everything in one table 4 - the table name and column names will be meaningful to any clerk 5 - we are not to start or snowflake designs. That's just a bunch of high power talk. 6 - all users will be trained to use MS Access to get at their data. (These are users that were just converted off from green screen teminals within the last 45-days, to Windows 98 with 64k RAM.) 7 - We are not to just copy the legacy transactions. 8 - We are to
Re: itrprof broken?
Cary's Sparky profiler is probably the most advanced around at the moment. We (ie. Torben Holm) have made a fun, little gadget called TFR (Trace File Repository) which will load any trace file (level 1, 4, 8 or 12) into a dozen tables or so, from which it can be retrieved either in traditional tkprof format or other, much nicer, formats. It's cool to have your trace information in a database, I think. Allows you to summarize across trace files, too. It's on www.MiracleAS.dk if you'd like to play around with it. Absolutely free, of course - and as well supported as we can :). Torbens email is [EMAIL PROTECTED] if you'd like to talk to him. Mogens K Gopalakrishnan wrote: James, Cary Millsap's Hotsos also does the same profiling. But that is a paid service. Have a look at http://www.hotsos.com for more details. I have just sent a mail to Dan about the broken links in his site. Will let you know once I get some more info from him. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Manning Sent: Wednesday, February 27, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Does itrprof seem broken for anyone else? trace files I analyzed with it yesterday are failing now, and even tiny files aren't working: 500 Servlet Exception java.lang.OutOfMemoryError no stack trace available Their link for asking questions is 404'd right now: http://www.unal-bilisim.com/qa/discus/ Is there another site that's running that same code or something else that can analyzer Event 10046 trace logs? Daniþment Gazi Ünal: Any ideas? itrprof's been such a wonderful tool, I'd really miss not being able to use it any more :( Thanks!! James -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?ISO-8859-1?Q?N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Perf Advice Needed: cache buffers chains, high waits, _db_block_hash_buckets
Amen. Contention for cache buffers chains means too much logical IO, ie. find and exterminate heavy SQL. Anjo Kolk wrote: Really,The only thing to do is fix the SQL. Each logical I/O or buffer get resultsin a cache buffer chain latch get. So by doing less LIO, you will get fewerlatch gets and as a result fewer sleeps on latches. This is how you fix the*problem*. You can also fix the *symptom*: bump up _spin_count (assumingthat you run on a SMP) or set _db_ block_hash_latches to a higher value.Fixing the SQL is the right way to go. Are you shooting for a 99.9percent buffer cache hit ratio ? If you are than that could also be a reasonfor the problem. Oh and there is a bug in Oracle 8.1.6/8.1.7 I believe thatcauses an additional buffer get for the index root block (assuming that thehash latches with the high sleeps cover index root blocks).Anjo Kolkhttp://www.oraperf.com- Original Message -To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Thursday, February 28, 2002 7:53 AM_db_block_hash_buckets db_block_buffers = 360448db_block_lru_latches = 4db_block_size = 8192_db_block_hash_buckets = 720896Ok, what I have so far is:- using itrprof, I saw that 35% of my elapsed time was based on waits of "cache buffers chains" latches.- checking v$latch_children (latch#=66), there are a good number (8-10 I'd guess) of the 4096 children that have a very high (10k+) number of sleeps - the rest of the children (of this type latch) have sleep counts are 10-12, so we have a ton of contention on a low # of "cache buffers chains" latches.- joining with x$bh (v$latch_children.addr=x$bh.hladdr), I see that the most contentioned-for of these latches (51,240 sleeps!) has 66 blocks on the chain. Checking with all_objects, I'm noticing that these blocks are scattered in some of the more important (and most-accessed) tables and indexes- The other latch children that have high sleep counts also have 30-50 buffers in their chainsQuestions:- to me, 66 seems awfully high - is it?- the sleep count is obviously high from what I can tell - is it definitely tied to the buffer chain this latch is protecting being so long and just happening to be 66 buffers that are mostly important tables and indexes?- I haven't set it by hand, but _db_block_hash_buckets = 720896 and this is 11 * 2^16. Everything I've read says it should be a prime number (and that jives with my comp sci background) - why is it not prime, why is it exactly twice db_block_buffers?- the number of children for "cache buffers chains" is 4096. Now, increasing that could have a positive effect on distributing the contention, but since the sleps are so heavily skewed to only a few of the children as it stands, I don't get the feeling that's the right fix.Anyone have any advice to offer? Pages/URL's that can help giv e someadvice?It's worth noting that these latches are basically non-existant aswait events at low load - "log file sync" is about the only waitevent I see at low loads, and I'm working on reducing my commitcounts much further to help tackle that.Thanks!!James--James Manning [EMAIL PROTECTED]GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: James Manning INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / Mailing ListsTo 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).
Tracing sequences (was re: freelist tesing)
Anjo has convinced me that I was indeed barking up the wrong tree (and even if I was the tree didn't care) He lead me into tests that shows my problem exhibits exactly the same characteristics of trying to insert the same value into a unique index simultaneously. That somehow, one user does an insert with one value, and before he commits, another session (usually different user -- not always) tries to insert the same value. Previously I had examined the developers code and convinced myself that this could not be the case as he selects a sequence nextval into a variable, then immediately uses that variable to create a the value list for the insert. I haven't found anything that makes me want to mistrust a sequence nextval. (If anyone knows of one in 8.0.5 on Solars 2.7 please let me know.) So I've got to mistrust something going on in the developers VB based COM object running under MTX serving up ASP pages for IIS. (Notice the long string of MS products there and you can guess how that influences my suspicions.) Since I've come to this realization, the event has not recurred, so I don't have any statistics. But we do know that when it starts, we see incidents from all 8 webservers simultaneously. Past evidence collected for a blocker and a blocked session shows that they were on the same webserver, but that's just 1 data point and we don't have any other to confirm or deny that relationship. Also when it starts, it happens at a furious rate, dozens of sessions at once. Then it suddenly stops. Curiously, the same applications on the same webservers are handling 30 other databases which experience no problems. This points me back to the database. sigh One of the things I would like to do, is to record what the database thought it answered for the select of the sequence nextval, and have that for comparison when the application tries to do its insert. My dream would be to have a trace/log/journal/something that recorded the nextval returned,user,session,serial#,and sysdate for every time the sequence was read. This would allow me to see discrepancies in the select/insert and sessions that were trying to insert without actually making the select. Has anyone tried this level of tracing/logging before? -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Old Chestnut: Tablespace Fragmentation
If you have only 1 Table in that Tablespace and only 1 File on that disk, even if you had multiple extents, you might expect them to be contiguous. Then, the only issue would be that the extent size should be a proper multiple of db_block_size*db_file_multiblock_read_count (or max_io_size). Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Bill Buchan [EMAIL PROTECTED] 27/02/2002 08:43 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Old Chestnut: Tablespace Fragmentation I know this one has been done to death: use uniform extents to avoid fragmentation; multiple extents don't hurt (within limits). But what if: Data Warehouse, one big table on a single disk, full table (batch) scan, no concurrent transactions on the database (so no contention for the disk), no fragmentation at the file system level, initially empty buffer cache (startup), read-only operation so DBWR isn't doing anything on this disk. Basically I want to read one data file from end to end. Surely it would make sense to have the disk read moving smoothly from one end of the disk to the other rather than bouncing about all over the place as it may do with multiple extents randomly allocated. Any thoughts? Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: RE: Manager decrees his data warehouse design. Hel
I guess the reverse of SAME is EMAS, where Everything Makes Absolute Sense. : ) NAS, is that the same thing as a SAN? Network - Attached Storage Storage Area Network Here we have a couple of SANs, but I think they also fit the description you gave of an NAS. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Wednesday, February 27, 2002 6:53 PM To: Multiple recipients of list ORACLE-L Subject:Re:RE: RE: Manager decrees his data warehouse design. Hel S.A.M.E, Stripe And Mirror Everything. It's a concept that came from an individual at Oracle with a significant pile of alphabet soup after his name who has lost most of his credibility anywhere. He was speaking though of Network Attached Storage (NAS) stuff where you really don't have to worry about the mount point/drive letter where you put the datafile(s). These neato devices do make some of the DBA's tasks of IO balancing meaningless since they do stripe data across multiple disks and run hardware mirroring in the background. In turn they retrieve your data from the most efficient place possible buffer your writes in cache memory that 'guarantees' that it will absolutely make it to disk. What I think has happen is that some of his idea was taken out of context, though not out of quote, and made meaningless. You should still have logical database design and multiple tablespaces/datafiles. It's just that you really don't care is everything is on drive H. Dick Goulet PS: I've not implemented such an idea have no intention thereof in the near future. Reason, NAS storage is not here. Reply Separator Author: Michael Cupp [EMAIL PROTECTED] Date: 2/27/2002 1:20 PM S.A.M.E.? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
i need ur help
Hi List ! I have one problem SELECT DISTINCTL.LINE_ID,L.DSCR ,L.DSCR_LONG ,QL.QUOTE_LINE_ID FROM LINE L,MKT_LINE ML,QUOTE_LINE QL WHEREML.LINE_ID=L.LINE_IDAND QL.MKT_LINE_ID=ML.MKT_LINE_IDAND QL.INV_ID =10134 it result is LINE_ID DSCRDSCR_LONG QUOTE_LINE_ID1000225 Commercial Property 105281000225 Commercial Property 105291000952 Workers Comp 10530 i want to get those line where line id is unique but i can not ditch the Quote_line_id colum .Diffrent quote_line id can refer to same line . So i want to ask is there any way to row wise comparison in SQL itself. in above example i want to ditjch second record as it has same LINE_ID as first one. Plz help me.. thanx in advance.. Shishir Kumar MishraAgni Software (P) Ltd.,Bangalore-560055, Indiawww.agnisoft.com
Re: IMPORTING a dump from a different system
Thanks for the reply Marin, however after a while i managed to import the database into Oracle after setting nls_lang=AMERICAN a more generic character set i think . it worked fine Regards, Gavin Dmello - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 3:18 PM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 08:58 Hi All, I just got a dump file from Oracle 8i on an AIX system and was trying to import it in Oracle 8i on a Suse Linux System, but got the error 'IMP-00016: required character set conversion (type 46 to 871) not supported'. Can you help me out ? I know it has to do with the NLS_LANG environment variable, but if I change the character set to the one used by the AIX system i get an error while logging in to 'imp'. Can anyone help me out as to what value should NLS_lang contain ? what are the source and database character sets? 871 seems to be some of the UTF charsets, but which one is 46? note that changing NLS_LANG may not solve your problems - you can avoid unnecessary conversions by properly setting NLS_LANG but if u have incompatible character set on the two servers, it won't help you Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gavin D'mello INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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]:RE: Manager decrees his data warehouse design. Help
Sanity? A requirement? SINCE WHEN? -Original Message- Sent: Wednesday, February 27, 2002 4:33 PM To: Multiple recipients of list ORACLE-L I don't know about questioning the design, it's more like questioning the sanity of the duhveloper. It's one of those more basic requirements. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 2/27/2002 11:31 AM I think the column limit is now closer to 1000, but like you, I can't imagine willingly designing a table with a column count exceeding 2 digits. More than 15 or 20 and I start to question the design. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/27/02 10:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re:RE: Manager decrees his data warehouse design. Help! I seem to remember reading somewhere that there can be a maximum of 255 columns in a table. Never created a table with half that many before. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 2/27/2002 10:28 AM April, I sincerely hope you're being facetious with the statement that queries run so much faster if you take all the joins out 1000 columns!? How many rows like that will fit in a block? Your system has to wade through a lot of extraneous data to get a few columns for a query. How do you index it? You can't. It would be most interesting if you share your benchmarks with us. Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/27/02 03:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Manager decrees his data warehouse design. Help! I agree, but at all costs... DOCUMENT EVERYTHING so it proves you made your suggestions and then went by the book on following what he decreed. We are facing similar problems (although not quite to your degree) and we are going to do two proof of concepts... on that denormalizes EVERYTHING into big GIANT tables (very nearly 1000 columns each)... because queries run so much faster if you take all the joins out... and one using a star-flake kind of model because it follows the standard (to the Nth degree)... we will ADOPT something about halfway in between... but we need to waste the time now following protocol to prove what we already know. Good Luck! ajw -Original Message- Sent: Wednesday, February 27, 2002 3:18 AM To: Multiple recipients of list ORACLE-L Don, if as you are saying this guy is v headstrong then use the Chinese approach. 1. Ensure that you have backed up your argument with a design or at least a doc outlining your approach showing that views and associated tables will ensure performance . 2. Send your emails to him and to others so that there is a trace. 3. Then wait and let it blow up. This should not take too long as the spec never included any indexes either. This way you have followed his design to the letter. 4. Let the users kill him when they have to wait 2 hours for the statement to return a value. 4. This means that you will have time to perfect a design using a CASE tool. 5. In the end his table could be used as a staging area Just wait don't get annoyed, smile. Just think you can have his job soon. Kind Regards Peter Lomax (Oracle DBA) Expertise Oracle ORANGE/DSI/SIMBAD/ATP OrangeFrance Bureau: email: [EMAIL PROTECTED] tel:(+33) (0)1 55 22 59 13 fax:(+33) (0)1 55 22 39 69 Simbad sailing through UMTS. -Message d'origine- De : Don [mailto:[EMAIL PROTECTED]] Envoyé : mercredi 27 février 2002 07:48 A : Multiple recipients of list ORACLE-L Objet : Manager decrees his data warehouse design. Help! I've lost patience, my temper, and I'm about to quit a job because the IT manager has decreed that we will have his data warehouse running within 24 hours, and we will use his design. 1 - We are NOT to use any kind of views, not even materailzed views. 2 - we are not to do any computations, summaries or rollups 3 - we are to have everything in one table 4 - the table name and column names will be meaningful to any clerk 5 - we are not to start or snowflake designs. That's just a bunch of high power talk. 6 - all users will be trained to use MS Access to get at their data. (These are users that were just converted off from green screen teminals within the last 45-days, to Windows 98 with 64k RAM.) 7 - We are not to just copy the legacy transactions. 8 - We are to load into an Oracle table, all legacy transction data because we don't want to limit how or what a user will look at 9 - It is not necessary to talk with the users to see what data they want to look at, or the atomic level. They are smart enough to fighure this out on their own. We just need to provide them the data. 10 - There shall be no long term
RE: RE: RE: Manager decrees his data warehouse design. Hel
details... details... statistics NEVER lie! -Original Message- Sent: Wednesday, February 27, 2002 4:37 PM To: April Wells; Multiple recipients of list ORACLE-L Any query against an empty table always FLIES!! Dick Goulet Reply Separator Author: April Wells [EMAIL PROTECTED] Date: 2/27/2002 11:43 AM How much do you charge an hour? They want to build a table with 980 columns, because the queries fly if you index it heavily. It won't load... the indexes won't build from load to load if you drop them... but the QUERIES... they JUST F*L*Y! -Original Message- Sent: Wednesday, February 27, 2002 1:28 PM To: Multiple recipients of list ORACLE-L I think the column limit is now closer to 1000, but like you, I can't imagine willingly designing a table with a column count exceeding 2 digits. More than 15 or 20 and I start to question the design. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/27/02 10:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re:RE: Manager decrees his data warehouse design. Help! I seem to remember reading somewhere that there can be a maximum of 255 columns in a table. Never created a table with half that many before. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 2/27/2002 10:28 AM April, I sincerely hope you're being facetious with the statement that queries run so much faster if you take all the joins out 1000 columns!? How many rows like that will fit in a block? Your system has to wade through a lot of extraneous data to get a few columns for a query. How do you index it? You can't. It would be most interesting if you share your benchmarks with us. Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/27/02 03:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Manager decrees his data warehouse design. Help! I agree, but at all costs... DOCUMENT EVERYTHING so it proves you made your suggestions and then went by the book on following what he decreed. We are facing similar problems (although not quite to your degree) and we are going to do two proof of concepts... on that denormalizes EVERYTHING into big GIANT tables (very nearly 1000 columns each)... because queries run so much faster if you take all the joins out... and one using a star-flake kind of model because it follows the standard (to the Nth degree)... we will ADOPT something about halfway in between... but we need to waste the time now following protocol to prove what we already know. Good Luck! ajw -Original Message- Sent: Wednesday, February 27, 2002 3:18 AM To: Multiple recipients of list ORACLE-L Don, if as you are saying this guy is v headstrong then use the Chinese approach. 1. Ensure that you have backed up your argument with a design or at least a doc outlining your approach showing that views and associated tables will ensure performance . 2. Send your emails to him and to others so that there is a trace. 3. Then wait and let it blow up. This should not take too long as the spec never included any indexes either. This way you have followed his design to the letter. 4. Let the users kill him when they have to wait 2 hours for the statement to return a value. 4. This means that you will have time to perfect a design using a CASE tool. 5. In the end his table could be used as a staging area Just wait don't get annoyed, smile. Just think you can have his job soon. Kind Regards Peter Lomax (Oracle DBA) Expertise Oracle ORANGE/DSI/SIMBAD/ATP OrangeFrance Bureau: email: [EMAIL PROTECTED] tel:(+33) (0)1 55 22 59 13 fax:(+33) (0)1 55 22 39 69 Simbad sailing through UMTS. -Message d'origine- De : Don [mailto:[EMAIL PROTECTED]] Envoyé : mercredi 27 février 2002 07:48 A : Multiple recipients of list ORACLE-L Objet : Manager decrees his data warehouse design. Help! I've lost patience, my temper, and I'm about to quit a job because the IT manager has decreed that we will have his data warehouse running within 24 hours, and we will use his design. 1 - We are NOT to use any kind of views, not even materailzed views. 2 - we are not to do any computations, summaries or rollups 3 - we are to have everything in one table 4 - the table name and column names will be meaningful to any clerk 5 - we are not to start or snowflake designs. That's just a bunch of high power talk. 6 - all users will be trained to use MS Access to get at their data. (These are users that were just converted off from green screen teminals within the last 45-days, to Windows 98 with 64k RAM.) 7 - We are not to just copy the legacy transactions. 8 - We are to load into an Oracle table, all legacy transction data because we don't
Re: i need ur help
How 'Bout SELECT DISTINCT L.LINE_ID, L.DSCR , L.DSCR_LONG , min(QL.QUOTE_LINE_ID) FROM LINE L,MKT_LINE ML,QUOTE_LINE QL WHERE ML.LINE_ID=L.LINE_ID AND QL.MKT_LINE_ID=ML.MKT_LINE_ID AND QL.INV_ID =10134 GROUP BY L.LINE_ID, L.DSCR,L.DSCR_LONG Jack Shishir [EMAIL PROTECTED]@fatcity.com on 28-02-2002 12:43:20 Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hi List ! I have one problem SELECT DISTINCT L.LINE_ID, L.DSCR , L.DSCR_LONG , QL.QUOTE_LINE_ID FROM LINE L,MKT_LINE ML,QUOTE_LINE QL WHERE ML.LINE_ID=L.LINE_ID AND QL.MKT_LINE_ID=ML.MKT_LINE_ID AND QL.INV_ID =10134 it result is LINE_IDDSCR DSCR_LONGQUOTE_LINE_ID 10002 25 Commercial Property 10528 10002 25Commercial Property10529 10009 52Workers Comp 10530 i want to get those line where line id is unique but i can not ditch the Quote_line_id colum . Diffrent quote_line id can refer to same line . So i want to ask is there any way to row wise comparison in SQL itself. in above example i want to ditjch second record as it has same LINE_ID as first one. Plz help me.. thanx in advance.. Shishir Kumar Mishra Agni Software (P) Ltd., Bangalore-560055, India www.agnisoft.com == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PROC ????
Hi All I have some problems with proc. the most important is that when PROC config file exceeds 100 lines the proc precompiler stops with a "Segmentation Fault". It seems that they have used a static array !!! What is your opinion. Also the I receive many errors from standard include files in /usr/include/ when I run precompiler. Do you think that I took mistake or the precompiler is such weak? what is your opinion? Do you suggest switching to OCI? Thanks EhsanDo You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion!
RE: ORA-00600 errors
From: John Dunn [EMAIL PROTECTED] Date: Mon, 25 Feb 2002 16:01:54 - Subject: ORA-00600 errors can anyone tell me waht these errors might mean? Errors in file /u01/app/oracle/admin/vaddev/udump/vaddev_ora_6942.trc: ORA-00600: internal error code, arguments: [17172], [0], [], [], [], [], [], [] Thu Feb 21 03:10:56 2002 Errors in file /u01/app/oracle/admin/vaddev/bdump/vaddev_snp2_10163.trc: ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [] John, There is info for the 17090 error on MetaLink. Navigate as follows: Top Tech Docs Data Server Database Administration ORacle Internal Errors. Which will point you to Note 153788.1 ORA-600 Argument Lookup HTH, - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: RE: Manager decrees his data warehouse design. Hel
Especially management decisions like the one that started this thread. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 28, 2002 1:38 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: RE: Manager decrees his data warehouse design. Hel I guess the reverse of SAME is EMAS, where Everything Makes Absolute Sense. : ) NAS, is that the same thing as a SAN? Network - Attached Storage Storage Area Network Here we have a couple of SANs, but I think they also fit the description you gave of an NAS. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Wednesday, February 27, 2002 6:53 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: RE: Manager decrees his data warehouse design. Hel S.A.M.E, Stripe And Mirror Everything. It's a concept that came from an individual at Oracle with a significant pile of alphabet soup after his name who has lost most of his credibility anywhere. He was speaking though of Network Attached Storage (NAS) stuff where you really don't have to worry about the mount point/drive letter where you put the datafile(s). These neato devices do make some of the DBA's tasks of IO balancing meaningless since they do stripe data across multiple disks and run hardware mirroring in the background. In turn they retrieve your data from the most efficient place possible buffer your writes in cache memory that 'guarantees' that it will absolutely make it to disk. What I think has happen is that some of his idea was taken out of context, though not out of quote, and made meaningless. You should still have logical database design and multiple tablespaces/datafiles. It's just that you really don't care is everything is on drive H. Dick Goulet PS: I've not implemented such an idea have no intention thereof in the near future. Reason, NAS storage is not here. Reply Separator Author: Michael Cupp [EMAIL PROTECTED] Date: 2/27/2002 1:20 PM S.A.M.E.? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Manager decrees his data warehouse design. Help!
No, I'm not being facetious, I'm being honest (welcome to my world)... that is the exact statement that was given in the meeting... that I was not invited to, but my boss was. And the statement came with preening and posturing, because it was the model that the author of the statement came up with. My input... I just have to make it work, my input is usually irrelevant, I'm JUST the DBA. The phrase April, Sit down and shut up usually crops up when I try to make a point in our brainstorming meetings. BENCHMARKS? Yeah... okay. This POC was done on the AIX-RS6000 equivalent of a 486. ONE cpu, and I had to get REAL creative just to get the DASD to give them room to make it RUN. Benchmarks come later... when I finally can get them on a test box. I will get benchmarks in the big real POC that starts in April... probably. We were not to keep statistics on the load time, that was irrelevant... just get data in it. The only important statistics were on query times. The way I have it figured it was probably closer to blocks per row in this DB Instance than rows to blocks (4k blocks, on average 15(bytes)*650(columns per row average containing data)). Most queries that we believe will run will bring back, at most, 50 of those columns... most not that many. I gave them statistics on IF we could get it to ever load we would end up with a table with 560 gig per year growth and indexes on that table of roughly a terabyte growth per year if they indexed it the way they wanted to... AND it would ever load or the indexes would ever build... but I didn't have FACTS to support it, only extrapolations on existing data. Until I could prove it wouldn't work, we would go on the premise that it would. The TEAM knows reality... but the LEADER doesn't seem to feel that reality should play a part. Sorry... yesterday was a bad day and this project is becoming very... intense... but I really agree that there are times when I don't know what I am even here for... other than to smile and nod and TRY to make what they design run. ajw -Original Message- Sent: Wednesday, February 27, 2002 12:29 PM To: Multiple recipients of list ORACLE-L April, I sincerely hope you're being facetious with the statement that queries run so much faster if you take all the joins out 1000 columns!? How many rows like that will fit in a block? Your system has to wade through a lot of extraneous data to get a few columns for a query. How do you index it? You can't. It would be most interesting if you share your benchmarks with us. Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/27/02 03:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Manager decrees his data warehouse design. Help! I agree, but at all costs... DOCUMENT EVERYTHING so it proves you made your suggestions and then went by the book on following what he decreed. We are facing similar problems (although not quite to your degree) and we are going to do two proof of concepts... on that denormalizes EVERYTHING into big GIANT tables (very nearly 1000 columns each)... because queries run so much faster if you take all the joins out... and one using a star-flake kind of model because it follows the standard (to the Nth degree)... we will ADOPT something about halfway in between... but we need to waste the time now following protocol to prove what we already know. Good Luck! ajw -Original Message- Sent: Wednesday, February 27, 2002 3:18 AM To: Multiple recipients of list ORACLE-L Don, if as you are saying this guy is v headstrong then use the Chinese approach. 1. Ensure that you have backed up your argument with a design or at least a doc outlining your approach showing that views and associated tables will ensure performance . 2. Send your emails to him and to others so that there is a trace. 3. Then wait and let it blow up. This should not take too long as the spec never included any indexes either. This way you have followed his design to the letter. 4. Let the users kill him when they have to wait 2 hours for the statement to return a value. 4. This means that you will have time to perfect a design using a CASE tool. 5. In the end his table could be used as a staging area Just wait don't get annoyed, smile. Just think you can have his job soon. Kind Regards Peter Lomax (Oracle DBA) Expertise Oracle ORANGE/DSI/SIMBAD/ATP OrangeFrance Bureau: email: [EMAIL PROTECTED] tel:(+33) (0)1 55 22 59 13 fax:(+33) (0)1 55 22 39 69 Simbad sailing through UMTS. -Message d'origine- De : Don [mailto:[EMAIL PROTECTED]] Envoyé : mercredi 27 février 2002 07:48 À : Multiple recipients of list ORACLE-L Objet : Manager decrees his data warehouse design. Help! I've lost patience, my temper, and I'm about to quit a job because the IT manager has decreed that we will have his data warehouse running within 24
MS Access migration to oracle
I've been told to migrate one MS-Access 97 database to oracle. Oracle Migration Workbench did the trick in an extremely clean, quick and complete way. Tables are created, populated with data and it is now when the problem starts. The people that were using this Access database were doing so by means of an ancient VB piece of ... code and they don't want or they don't know to adjust it. They expect the program to somehow find the new Oracle 8.1.7.3 instance and continue to work as it did before. I created a new access database containing ODBC links to the Oracle tables, but the program is complaining that the links are read only. Is there any way in this world or beyond to make these tables writable? I'm inclined to tell them that they should do some coding, which is very likely to make them go back to Access. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Manager decrees his data warehouse design. Help!
Don, I agree with Yechiel. You do, after all, work for this guy, and by extension, the company. You need to learn to pick your fights. In the larger picture, does it really matter that much? Are your kids at home going to be disappointed in you if you build this POC? Take the advice of most of the members of this list. Build this thing as quickly as possible, and deliver it to the users. It sounds like they : 1). will not use it, so you will get to throw it away in a year 2). will use it, and will be disappointed with it and stop using it - in which case you get to throw it away in a year 3). once it is built, re-design it the way you want (in a new schema) and, when the original fails, announce that you have been studying the matter and have a better version waiting to implement. You will become the hero all the way around. Your boss will be glad that he delivered the first warehouse. He will be happy that, when problems arise from the first version, that you are on the spot with version #2 to solve his problems and make him look good again. In the meantime, go home, kiss your wife, hug your kids, pet the dog, read a good book, go for a walk, throw a baseball with your kids, go to the movies with your wife, and realize that, like food poisoning, this too will pass. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, February 28, 2002 3:23 AM To: Multiple recipients of list ORACLE-L Hello Don In a more serious mood: DO IT. I also had some arguments with my boss over the years and except for 2-3 cases (in 20 years) that I told my boss that I will not do something and if he wants it he can do it himself, my motto was if he wants to waste resources for something that is obviously an error let him waste it. He wants you to waste time and disk space on a system that the users will not use: waste your time and the resources. He is management and he is the one who calls the shots. Just document everything to cover yourself later. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Don [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 27, 2002 8:48 AM To: Multiple recipients of list ORACLE-L Subject: Manager decrees his data warehouse design. Help! I've lost patience, my temper, and I'm about to quit a job because the IT manager has decreed that we will have his data warehouse running within 24 hours, and we will use his design. 1 - We are NOT to use any kind of views, not even materailzed views. 2 - we are not to do any computations, summaries or rollups 3 - we are to have everything in one table 4 - the table name and column names will be meaningful to any clerk 5 - we are not to start or snowflake designs. That's just a bunch of high power talk. 6 - all users will be trained to use MS Access to get at their data. (These are users that were just converted off from green screen teminals within the last 45-days, to Windows 98 with 64k RAM.) 7 - We are not to just copy the legacy transactions. 8 - We are to load into an Oracle table, all legacy transction data because we don't want to limit how or what a user will look at 9 - It is not necessary to talk with the users to see what data they want to look at, or the atomic level. They are smart enough to fighure this out on their own. We just need to provide them the data. 10 - There shall be no long term maintenance required by the dw. Any ideas on how to deal with this situation? For tomorrow, I've done a CTAS from a materialized view that we created to support one departments known requirements. Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
RE: max open cursors exceeded
Title: max open cursors exceeded -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 28, 2002 3:28 AMTo: Multiple recipients of list ORACLE-LSubject: max open cursors exceeded a) MAX_OPEN_CURSORS is set to 1000 - when exceeding that threshold, we're experiencing problems; how can we monitor which users uses up all the cursors (and how many). By monitoring v$open_cursor b) What exactly is displayed when querying v$open_cursor? - I know htat there are parsed statements of the user/session - but this should be more than just a PL/SQL "declare cursor... open...fetch...close cursor", right? What about statements issued in SQL*Plus or through JDBC etc.? v$open_cursor displays ALL the cursors for a given session, not justthe explicite PL/SQL or PRO*C stuff.A cursor is needed for EVERY SQL STATEMENT. The only cursor not displayed by v$open_cursor is the DBA himself/herself, especially if he has to support tools that do their own multiplexing, like Forte. c) The results from v$open_cursor is equivalent to the currently running transaction, right? So when are those entries removed again? When the transaction commits or when the sessions ends? Or when issuing a PL/SQL "close cursor". Or are those entries overwritten? by whom? when? An implicit cursor is closed when another statement is opened and re-parsed. If you take a look at v$session, you'll find that iscontainsthe "current SQL" address. That is, basically, the open cursor that the session is currently executing. When the next SQL comes in, this cursor will be closed, SQL put in the library cache and a new cursor will be allocated. d) what does querying "select * from v$sql_cursor" return? That query will usually return enough information for your screen to join it's ancestors and will leave you wandering why is that SQL*Plus does not have "clear" or "cls" command. Any ideas? Yes. I want to win a lottery jackpot and start my own business in close proximity to the Waikiki beach.
RE: Tracing sequences (was re: freelist tesing)
if you return the seq nextval by a function you can track it. So, let your developers avoid 'select seq.nextval into ... from dual;' syntax. Then use autonomous transactions to log the next value that is being returned to another table, which you can monitor. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! ***1 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 ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you ***1
Re:PROC ????
Ehsan, I've been using Pro*C for the last 18 years have compiled some really large programs without a problem. Actually I've had the precompiler find errors in my code that the compiler missed, so I really don't see a problem. On the other hand I do have OCI programs running around, which I've been in the habit of converting to Pro*C. If you want to forward the config file, source (if your boss will let you) and the version/os your using I may be able to help. Dick Goulet Reply Separator Author: ehsan sinavalda [EMAIL PROTECTED] Date: 2/28/2002 4:23 AM Hi All I have some problems with proc. the most important is that when PROC config file exceeds 100 lines the proc precompiler stops with a Segmentation Fault. It seems that they have used a static array !!! What is your opinion. Also the I receive many errors from standard include files in /usr/include/ when I run precompiler. Do you think that I took mistake or the precompiler is such weak? what is your opinion? Do you suggest switching to OCI? Thanks Ehsan - Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! PHi All/P PI have some problems with proc. the most important is that when PROC config file exceeds 100 lines the proc precompiler stops with a Segmentation Fault. It seems that they have used a static array !!!nbsp; What is your opinion./P PAlso the I receive many errors from standard include files in /usr/include/ when I run precompiler./P PDo you think that I took mistake or the precompiler is such weak? what is your opinion? Do you suggest switching to OCI?/P PThanks/P PEhsan/Ppbrhr size=1bDo You Yahoo!?/bbr a href=http://greetings.yahoo.com;Yahoo! Greetings/a - Send FREE e-cards for every occasion! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]:RE: Manager decrees his data warehouse design. Help
Not sanity. The basic requirement is: Questioning the sanity!! Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: April Wells [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 28, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re[2]:RE: Manager decrees his data warehouse design. Help Sanity? A requirement? SINCE WHEN? -Original Message- Sent: Wednesday, February 27, 2002 4:33 PM To: Multiple recipients of list ORACLE-L I don't know about questioning the design, it's more like questioning the sanity of the duhveloper. It's one of those more basic requirements. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 2/27/2002 11:31 AM I think the column limit is now closer to 1000, but like you, I can't imagine willingly designing a table with a column count exceeding 2 digits. More than 15 or 20 and I start to question the design. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/27/02 10:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re:RE: Manager decrees his data warehouse design. Help! I seem to remember reading somewhere that there can be a maximum of 255 columns in a table. Never created a table with half that many before. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 2/27/2002 10:28 AM April, I sincerely hope you're being facetious with the statement that queries run so much faster if you take all the joins out 1000 columns!? How many rows like that will fit in a block? Your system has to wade through a lot of extraneous data to get a few columns for a query. How do you index it? You can't. It would be most interesting if you share your benchmarks with us. Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/27/02 03:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Manager decrees his data warehouse design. Help! I agree, but at all costs... DOCUMENT EVERYTHING so it proves you made your suggestions and then went by the book on following what he decreed. We are facing similar problems (although not quite to your degree) and we are going to do two proof of concepts... on that denormalizes EVERYTHING into big GIANT tables (very nearly 1000 columns each)... because queries run so much faster if you take all the joins out... and one using a star-flake kind of model because it follows the standard (to the Nth degree)... we will ADOPT something about halfway in between... but we need to waste the time now following protocol to prove what we already know. Good Luck! ajw -Original Message- Sent: Wednesday, February 27, 2002 3:18 AM To: Multiple recipients of list ORACLE-L Don, if as you are saying this guy is v headstrong then use the Chinese approach. 1. Ensure that you have backed up your argument with a design or at least a doc outlining your approach showing that views and associated tables will ensure performance . 2. Send your emails to him and to others so that there is a trace. 3. Then wait and let it blow up. This should not take too long as the spec never included any indexes either. This way you have followed his design to the letter. 4. Let the users kill him when they have to wait 2 hours for the statement to return a value. 4. This means that you will have time to perfect a design using a CASE tool. 5. In the end his table could be used as a staging area Just wait don't get annoyed, smile. Just think you can have his job soon. Kind Regards Peter Lomax (Oracle DBA) Expertise Oracle ORANGE/DSI/SIMBAD/ATP OrangeFrance Bureau: email: [EMAIL PROTECTED] tel:(+33) (0)1 55 22 59 13 fax:(+33) (0)1 55 22 39 69 Simbad sailing through UMTS. -Message d'origine- De : Don [mailto:[EMAIL PROTECTED]] Envoye : mercredi 27 fevrier 2002 07:48 A : Multiple recipients of list ORACLE-L Objet : Manager decrees his data warehouse design. Help! I've lost patience, my temper, and I'm about to quit a job because the IT manager has decreed that we will have his data warehouse running within 24 hours, and we will use his design. 1 - We are NOT to use any kind of views, not even materailzed views. 2 - we are not to do any computations, summaries or rollups 3 - we are to have everything in one table 4 - the table name and column names will be meaningful to any clerk 5 - we are not to start or snowflake designs. That's just a bunch of high power talk. 6 - all users will be trained to use MS Access to get at their data. (These are users that were just
RE: itrprof broken?
James, Here is the reply from Danisment : Hello list, First if all, thank you for using itrprof. Problem occurs if big trace file is uploaded. I've contacted my service provider. They are upgrading the server and This problem will go away next week. regards... __ Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Manning Sent: Wednesday, February 27, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Does itrprof seem broken for anyone else? trace files I analyzed with it yesterday are failing now, and even tiny files aren't working: 500 Servlet Exception java.lang.OutOfMemoryError no stack trace available Their link for asking questions is 404'd right now: http://www.unal-bilisim.com/qa/discus/ Is there another site that's running that same code or something else that can analyzer Event 10046 trace logs? Daniþment Gazi Ünal: Any ideas? itrprof's been such a wonderful tool, I'd really miss not being able to use it any more :( Thanks!! James -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: RE: RE: Manager decrees his data warehouse design.
Patrice, They are synonyms for each other as far as I understand. Dick Goulet Reply Separator Author: Boivin; Patrice J [EMAIL PROTECTED] Date: 2/28/2002 3:38 AM I guess the reverse of SAME is EMAS, where Everything Makes Absolute Sense. : ) NAS, is that the same thing as a SAN? Network - Attached Storage Storage Area Network Here we have a couple of SANs, but I think they also fit the description you gave of an NAS. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Wednesday, February 27, 2002 6:53 PM To: Multiple recipients of list ORACLE-L S.A.M.E, Stripe And Mirror Everything. It's a concept that came from an individual at Oracle with a significant pile of alphabet soup after his name who has lost most of his credibility anywhere. He was speaking though of Network Attached Storage (NAS) stuff where you really don't have to worry about the mount point/drive letter where you put the datafile(s). These neato devices do make some of the DBA's tasks of IO balancing meaningless since they do stripe data across multiple disks and run hardware mirroring in the background. In turn they retrieve your data from the most efficient place possible buffer your writes in cache memory that 'guarantees' that it will absolutely make it to disk. What I think has happen is that some of his idea was taken out of context, though not out of quote, and made meaningless. You should still have logical database design and multiple tablespaces/datafiles. It's just that you really don't care is everything is on drive H. Dick Goulet PS: I've not implemented such an idea have no intention thereof in the near future. Reason, NAS storage is not here. Reply Separator Author: Michael Cupp [EMAIL PROTECTED] Date: 2/27/2002 1:20 PM S.A.M.E.? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Total Extents
That's what I thought too, but it will skip extents from any LMTs in use. And getting extents info when LMTs are is use will be slower as compared to DMTs due the way this info is stored in the bitmap in each datafile for the LMT. - Kirti -Original Message- Sent: Wednesday, February 27, 2002 4:47 PM To: Multiple recipients of list ORACLE-L How about counting rows from uet$? I have not tried it. Raj Post, Ethan Ethan.Post@pTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] s.net cc: Sent by: Subject: Total Extents root@fatcity. com February 27, 2002 05:13 PM Please respond to ORACLE-L Anyone recommend a faster access path for getting the total number of extents in the database? select sum(extents) from dba_segments is too slow for my purposes. Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Manager decrees his data warehouse design. Help!
Just make sure it's documented that the original idea is NOT yours :) --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: Don, I agree with Yechiel. You do, after all, work for this guy, and by extension, the company. You need to learn to pick your fights. In the larger picture, does it really matter that much? Are your kids at home going to be disappointed in you if you build this POC? Take the advice of most of the members of this list. Build this thing as quickly as possible, and deliver it to the users. It sounds like they : 1). will not use it, so you will get to throw it away in a year 2). will use it, and will be disappointed with it and stop using it - in which case you get to throw it away in a year 3). once it is built, re-design it the way you want (in a new schema) and, when the original fails, announce that you have been studying the matter and have a better version waiting to implement. You will become the hero all the way around. Your boss will be glad that he delivered the first warehouse. He will be happy that, when problems arise from the first version, that you are on the spot with version #2 to solve his problems and make him look good again. In the meantime, go home, kiss your wife, hug your kids, pet the dog, read a good book, go for a walk, throw a baseball with your kids, go to the movies with your wife, and realize that, like food poisoning, this too will pass. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, February 28, 2002 3:23 AM To: Multiple recipients of list ORACLE-L Hello Don In a more serious mood: DO IT. I also had some arguments with my boss over the years and except for 2-3 cases (in 20 years) that I told my boss that I will not do something and if he wants it he can do it himself, my motto was if he wants to waste resources for something that is obviously an error let him waste it. He wants you to waste time and disk space on a system that the users will not use: waste your time and the resources. He is management and he is the one who calls the shots. Just document everything to cover yourself later. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Don [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 27, 2002 8:48 AM To: Multiple recipients of list ORACLE-L Subject:Manager decrees his data warehouse design. Help! I've lost patience, my temper, and I'm about to quit a job because the IT manager has decreed that we will have his data warehouse running within 24 hours, and we will use his design. 1 - We are NOT to use any kind of views, not even materailzed views. 2 - we are not to do any computations, summaries or rollups 3 - we are to have everything in one table 4 - the table name and column names will be meaningful to any clerk 5 - we are not to start or snowflake designs. That's just a bunch of high power talk. 6 - all users will be trained to use MS Access to get at their data. (These are users that were just converted off from green screen teminals within the last 45-days, to Windows 98 with 64k RAM.) 7 - We are not to just copy the legacy transactions. 8 - We are to load into an Oracle table, all legacy transction data because we don't want to limit how or what a user will look at 9 - It is not necessary to talk with the users to see what data they want to look at, or the atomic level. They are smart enough to fighure this out on their own. We just need to provide them the data. 10 - There shall be no long term maintenance required by the dw. Any ideas on how to deal with this situation? For tomorrow, I've done a CTAS from a materialized view that we created to support one departments known requirements. Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this
RE: Manager decrees his data warehouse design. Help!
Tom - You da man! -Original Message- Sent: Thursday, February 28, 2002 7:34 AM To: Multiple recipients of list ORACLE-L Don, I agree with Yechiel. You do, after all, work for this guy, and by extension, the company. You need to learn to pick your fights. In the larger picture, does it really matter that much? Are your kids at home going to be disappointed in you if you build this POC? Take the advice of most of the members of this list. Build this thing as quickly as possible, and deliver it to the users. It sounds like they : 1). will not use it, so you will get to throw it away in a year 2). will use it, and will be disappointed with it and stop using it - in which case you get to throw it away in a year 3). once it is built, re-design it the way you want (in a new schema) and, when the original fails, announce that you have been studying the matter and have a better version waiting to implement. You will become the hero all the way around. Your boss will be glad that he delivered the first warehouse. He will be happy that, when problems arise from the first version, that you are on the spot with version #2 to solve his problems and make him look good again. In the meantime, go home, kiss your wife, hug your kids, pet the dog, read a good book, go for a walk, throw a baseball with your kids, go to the movies with your wife, and realize that, like food poisoning, this too will pass. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, February 28, 2002 3:23 AM To: Multiple recipients of list ORACLE-L Hello Don In a more serious mood: DO IT. I also had some arguments with my boss over the years and except for 2-3 cases (in 20 years) that I told my boss that I will not do something and if he wants it he can do it himself, my motto was if he wants to waste resources for something that is obviously an error let him waste it. He wants you to waste time and disk space on a system that the users will not use: waste your time and the resources. He is management and he is the one who calls the shots. Just document everything to cover yourself later. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Don [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 27, 2002 8:48 AM To: Multiple recipients of list ORACLE-L Subject: Manager decrees his data warehouse design. Help! I've lost patience, my temper, and I'm about to quit a job because the IT manager has decreed that we will have his data warehouse running within 24 hours, and we will use his design. 1 - We are NOT to use any kind of views, not even materailzed views. 2 - we are not to do any computations, summaries or rollups 3 - we are to have everything in one table 4 - the table name and column names will be meaningful to any clerk 5 - we are not to start or snowflake designs. That's just a bunch of high power talk. 6 - all users will be trained to use MS Access to get at their data. (These are users that were just converted off from green screen teminals within the last 45-days, to Windows 98 with 64k RAM.) 7 - We are not to just copy the legacy transactions. 8 - We are to load into an Oracle table, all legacy transction data because we don't want to limit how or what a user will look at 9 - It is not necessary to talk with the users to see what data they want to look at, or the atomic level. They are smart enough to fighure this out on their own. We just need to provide them the data. 10 - There shall be no long term maintenance required by the dw. Any ideas on how to deal with this situation? For tomorrow, I've done a CTAS from a materialized view that we created to support one departments known requirements. Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
IMPORT QUESTION
Hi I want to switch database from one server to another server.I want do data migration thru export/import.How can I run incremental import.Is it necessary to have incremental export? I want to migrate data thru export/import.What ever the tables updated during import on old server I want to do reimport on new serevr.There is one parameter INCTYPE is available in export/import both.Is it necessary to have incremental export to take incremental import? Please suggest. Thx -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
oracle 8.1.7 patch 2 or 3?
Hi, I am managing a software that uses a set of 8 oracle databases. I am preparing to upgrade all my databases from 8.1.6.3.0 to 8.1.7.0.0 then apply a patch to the oracle software installation after the upgrade. The software that uses these databases are only certified on patch 2 level at the time of release. Since now the patchset 3 for 817 is available, I would like to get advice in whether to apply patch 3 instead of patch 2. Same amount of work, more benefits. The only thing is that the application vendor does not officially support the patch3. platform: Sun Solaris 2.8 Oracle EE server 8.1.6.3.0 Any input is appreciated. Xiaohong Yang (Sharon) Center for Bioinfomatics UNC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xiaohong Yang (Sharon) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle on OS/390
Hi List, a colleague of mine asked me how to setup a listener on OS/390. I've never seen this platform (very rare in Russia). I supose this is kind of a mainframe system. So I have 2 questions to ask: 1. I'm not sure Oracle support listener on mainframes. Does it exist on OS/390? 2. If so, where can I view its settings? TIA Regards, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle on Sun StorEdge T3 Disk Array
Title: max open cursors exceeded We havejust gotten in a Sun StorEdge T3 Disk Array for the database and future data warehouse. This T3 disk array has 18 hard drives with 36 gigs of space each. Has anyone had any experiences, problems or comments while setting up or using it. Kevin Bass Senior Manager, DBA Americal Corporation Phone: (252) 762-2144 E-mail: [EMAIL PROTECTED]
Non-partitioned table to Hash Partitioned table
Hello! I am trying to figure out the best way to convert a non-partitioned table with approx 20 million rows into a hash-partitioned table. This should be done with minimal down-time. This will be in an Oracle 9i environment done at a time when only SELECTs are occuring on the table. The best way I can figure is to create a second table and copy the data over; create the indexes; and rename the tables. I would appreciate any hints on what section of TFM to read. Kevin Toepke [EMAIL PROTECTED] The information in this electronic mail message is Trilegiant Confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Trilegiant Corporation is not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SNP0...SNPx Memory Hogs
At least in 8.0.x the oracle intelligent agent process are dbsnmp processes. Are you sure that these are oracle processes and not OS related. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 4:20 PM 8.1.7.2.5 under Win2k Server I just discovered that my four SNP processes were sitting around, doing no work, taking up about 500MB of RAM. Is this normal? In Task Manager, the Oracle process was showing to be using about 1.4GB. After I issued Alter System Set Job_Queue_Processes=0 it shrank to about 900MB. I then issued Alter System Set Job_Queue_Processes=4, but the Mem Usage stayed the same. None of those SNP processes had done any work (i.e., run any jobs) for about 10 hours. I would have expected the SNP processes to release memory when their jobs finish. I've been trying to figure out what processes were chewing up RAM, ramping up over the course of 3 or 4 days. Some Java processes that we run were found to be hogs, but after I got the developers to disconnect/reconnect occasionally, those sessions were OK. I finally found the culprits when I was checking sessions' session pga memory. A couple of sessions were using about 200MB each. I checked to see what SQL they'd been running and found it to be dbms_ijob calls, which lead me to suspect the SNP processes - alas, Win2k doesn't let you look at individual Oracle processes like UNIX does. Anyway, I can't find any mention anywhere that dormant SNP processes can be memory hogs. Am I missing something? For now I'll set Job_Queue_Processes to 0 and back to 4 right after the heavy work each night. Any init parameters I'm missing? ...other suggestions? Thanks. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TCP and IPC
Hi Listers, Oracle 816, Linux RedHat 26. I have two questions about listener. 1. When I do 'lsnrctl status', I got the following output. The protocol is IPC. Should I changed it to TCP ? What is the difference between IPC and TCP ? Admin lsnrctl status LSNRCTL for Linux: Version 8.1.6.0.0 - Production on 28-FEB-2002 09:42:49 (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) 2. There is a parameter : SERVER = DEDICATED in the listener.ora. I'm running the database in MTS mode. Any idea what is the impact of using this parameter ? Thanks in advance. Aldi _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TCP and IPC
Hi Listers, Oracle 816, Linux RedHat 62. I have two questions about listener. 1. When I do 'lsnrctl status', I got the following output. The protocol is IPC. Should I changed it to TCP ? What is the difference between IPC and TCP ? Admin lsnrctl status LSNRCTL for Linux: Version 8.1.6.0.0 - Production on 28-FEB-2002 09:42:49 (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) 2. There is a parameter : SERVER = DEDICATED in the listener.ora. I'm running the database in MTS mode. Any idea what is the impact of using this parameter ? Thanks in advance. Aldi _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Manager decrees his data warehouse design. Help!
Rachel, That's what step #3 is for. Everyone will forget how bad the first warehouse was once the true properly designed warehouse is in place and delivering the goods. It sounds like there is pressure to deliver something right away - as usual, no time to design it properly. A manager I used to work for had the best philosophy: Lets hurry up and do it wrong so that we can fix it later. Sounds strange, but that's the business we choose to be in (ala The Godfather). *Nobody* wants to spend time and resources doing research to desig n a system. In a way, it's our (the IT industry's) fault. We have promised for years that we can develop programs faster and faster. Now, the managers expect it. But most of them realize that it's a mistake, but easier to fix after the fact. my little 2 cents. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, February 28, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Just make sure it's documented that the original idea is NOT yours :) --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: Don, I agree with Yechiel. You do, after all, work for this guy, and by extension, the company. You need to learn to pick your fights. In the larger picture, does it really matter that much? Are your kids at home going to be disappointed in you if you build this POC? Take the advice of most of the members of this list. Build this thing as quickly as possible, and deliver it to the users. It sounds like they : 1). will not use it, so you will get to throw it away in a year 2). will use it, and will be disappointed with it and stop using it - in which case you get to throw it away in a year 3). once it is built, re-design it the way you want (in a new schema) and, when the original fails, announce that you have been studying the matter and have a better version waiting to implement. You will become the hero all the way around. Your boss will be glad that he delivered the first warehouse. He will be happy that, when problems arise from the first version, that you are on the spot with version #2 to solve his problems and make him look good again. In the meantime, go home, kiss your wife, hug your kids, pet the dog, read a good book, go for a walk, throw a baseball with your kids, go to the movies with your wife, and realize that, like food poisoning, this too will pass. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, February 28, 2002 3:23 AM To: Multiple recipients of list ORACLE-L Hello Don In a more serious mood: DO IT. I also had some arguments with my boss over the years and except for 2-3 cases (in 20 years) that I told my boss that I will not do something and if he wants it he can do it himself, my motto was if he wants to waste resources for something that is obviously an error let him waste it. He wants you to waste time and disk space on a system that the users will not use: waste your time and the resources. He is management and he is the one who calls the shots. Just document everything to cover yourself later. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Don [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 27, 2002 8:48 AM To: Multiple recipients of list ORACLE-L Subject:Manager decrees his data warehouse design. Help! I've lost patience, my temper, and I'm about to quit a job because the IT manager has decreed that we will have his data warehouse running within 24 hours, and we will use his design. 1 - We are NOT to use any kind of views, not even materailzed views. 2 - we are not to do any computations, summaries or rollups 3 - we are to have everything in one table 4 - the table name and column names will be meaningful to any clerk 5 - we are not to start or snowflake designs. That's just a bunch of high power talk. 6 - all users will be trained to use MS Access to get at their data. (These are users that were just converted off from green screen teminals within the last 45-days, to Windows 98 with 64k RAM.) 7 - We are not to just copy the legacy transactions. 8 - We are to load into an Oracle table, all legacy transction data because we don't want to limit how or what a user will look at 9 - It is not necessary to talk with the users to see what data they want to look at, or the atomic level. They are smart enough to fighure this out on their own. We just need to provide them the data. 10 - There shall be no long term maintenance required by the dw. Any ideas on how to deal with this situation? For tomorrow, I've done a CTAS from a materialized view that we created to support one departments known requirements. Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don INET:
Clash of the DBs in eWeek
Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled Database Clash? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the Online Exclusive: Download our configuration and tuning scripts. According to the Oracle setup docs in there, they're NOT using MTS and processes in init.ora is 150. So then how did they test for 1000 concurrent Web clients? Anyone have a thought? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle 8.1.7 patch 2 or 3?
What vendor, what product? -Original Message- Sent: Thursday, February 28, 2002 9:38 AM To: Multiple recipients of list ORACLE-L Hi, I am managing a software that uses a set of 8 oracle databases. I am preparing to upgrade all my databases from 8.1.6.3.0 to 8.1.7.0.0 then apply a patch to the oracle software installation after the upgrade. The software that uses these databases are only certified on patch 2 level at the time of release. Since now the patchset 3 for 817 is available, I would like to get advice in whether to apply patch 3 instead of patch 2. Same amount of work, more benefits. The only thing is that the application vendor does not officially support the patch3. platform: Sun Solaris 2.8 Oracle EE server 8.1.6.3.0 Any input is appreciated. Xiaohong Yang (Sharon) Center for Bioinfomatics UNC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xiaohong Yang (Sharon) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Manager decrees his data warehouse design. Help!
A very true set of statements on all sides. I've done as much am in the process once again. I just wish that once in my life as a DBA I did not have to cleanup someone else's mess. Now if you all don't mind, I'm off to the hardware store for a new shovel!! :-) Dick Goulet Reply Separator Author: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2/28/2002 6:13 AM Tom - You da man! -Original Message- Sent: Thursday, February 28, 2002 7:34 AM To: Multiple recipients of list ORACLE-L Don, I agree with Yechiel. You do, after all, work for this guy, and by extension, the company. You need to learn to pick your fights. In the larger picture, does it really matter that much? Are your kids at home going to be disappointed in you if you build this POC? Take the advice of most of the members of this list. Build this thing as quickly as possible, and deliver it to the users. It sounds like they : 1). will not use it, so you will get to throw it away in a year 2). will use it, and will be disappointed with it and stop using it - in which case you get to throw it away in a year 3). once it is built, re-design it the way you want (in a new schema) and, when the original fails, announce that you have been studying the matter and have a better version waiting to implement. You will become the hero all the way around. Your boss will be glad that he delivered the first warehouse. He will be happy that, when problems arise from the first version, that you are on the spot with version #2 to solve his problems and make him look good again. In the meantime, go home, kiss your wife, hug your kids, pet the dog, read a good book, go for a walk, throw a baseball with your kids, go to the movies with your wife, and realize that, like food poisoning, this too will pass. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, February 28, 2002 3:23 AM To: Multiple recipients of list ORACLE-L Hello Don In a more serious mood: DO IT. I also had some arguments with my boss over the years and except for 2-3 cases (in 20 years) that I told my boss that I will not do something and if he wants it he can do it himself, my motto was if he wants to waste resources for something that is obviously an error let him waste it. He wants you to waste time and disk space on a system that the users will not use: waste your time and the resources. He is management and he is the one who calls the shots. Just document everything to cover yourself later. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Don [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 27, 2002 8:48 AM To: Multiple recipients of list ORACLE-L Subject: Manager decrees his data warehouse design. Help! I've lost patience, my temper, and I'm about to quit a job because the IT manager has decreed that we will have his data warehouse running within 24 hours, and we will use his design. 1 - We are NOT to use any kind of views, not even materailzed views. 2 - we are not to do any computations, summaries or rollups 3 - we are to have everything in one table 4 - the table name and column names will be meaningful to any clerk 5 - we are not to start or snowflake designs. That's just a bunch of high power talk. 6 - all users will be trained to use MS Access to get at their data. (These are users that were just converted off from green screen teminals within the last 45-days, to Windows 98 with 64k RAM.) 7 - We are not to just copy the legacy transactions. 8 - We are to load into an Oracle table, all legacy transction data because we don't want to limit how or what a user will look at 9 - It is not necessary to talk with the users to see what data they want to look at, or the atomic level. They are smart enough to fighure this out on their own. We just need to provide them the data. 10 - There shall be no long term maintenance required by the dw. Any ideas on how to deal with this situation? For tomorrow, I've done a CTAS from a materialized view that we created to support one departments known requirements. Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
RE: max open cursors exceeded
Title: max open cursors exceeded There is a bug(well, it's a feature actually) that if you uses JDBC even if you close all of your resultsets and statements, the cursors remain open by Oracle unless you close the Connection. -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 28, 2002 8:34 AMTo: Multiple recipients of list ORACLE-LSubject: RE: max open cursors exceeded -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 28, 2002 3:28 AMTo: Multiple recipients of list ORACLE-LSubject: max open cursors exceeded a) MAX_OPEN_CURSORS is set to 1000 - when exceeding that threshold, we're experiencing problems; how can we monitor which users uses up all the cursors (and how many). By monitoring v$open_cursor b) What exactly is displayed when querying v$open_cursor? - I know htat there are parsed statements of the user/session - but this should be more than just a PL/SQL "declare cursor... open...fetch...close cursor", right? What about statements issued in SQL*Plus or through JDBC etc.? v$open_cursor displays ALL the cursors for a given session, not justthe explicite PL/SQL or PRO*C stuff.A cursor is needed for EVERY SQL STATEMENT. The only cursor not displayed by v$open_cursor is the DBA himself/herself, especially if he has to support tools that do their own multiplexing, like Forte. c) The results from v$open_cursor is equivalent to the currently running transaction, right? So when are those entries removed again? When the transaction commits or when the sessions ends? Or when issuing a PL/SQL "close cursor". Or are those entries overwritten? by whom? when? An implicit cursor is closed when another statement is opened and re-parsed. If you take a look at v$session, you'll find that iscontainsthe "current SQL" address. That is, basically, the open cursor that the session is currently executing. When the next SQL comes in, this cursor will be closed, SQL put in the library cache and a new cursor will be allocated. d) what does querying "select * from v$sql_cursor" return? That query will usually return enough information for your screen to join it's ancestors and will leave you wandering why is that SQL*Plus does not have "clear" or "cls" command. Any ideas? Yes. I want to win a lottery jackpot and start my own business in close proximity to the Waikiki beach.
replication gui
I have oracle ent. edition on my machine (NT) but do not havethe link of adv. replication manager in start panel . What is the name of exe starting the Replication manager ? thank you bunyamin
iSQLPlus Problem
I have a DELL 8200 with XP Prof. and I have installed 9i (9.0.1). When I look at installed products with the Universal Installer it says that iSQL Plus is installed at: c:\oracle\ora90\oracle_prod\ However, when I look at my C: drive I only have: c:\oracle\ora90\ "oracle_prod" is not there and neitherare any apps for iSQL Plus. What is wrong? Thanks, Ken Janusz, CPIM
Re: MS Access migration to oracle
If VB code was connecting to Access db through ODBC datasource, just modify this this datasource (or delete/create new one with the same name) to use Oracle ODBC driver (instead of ACCESS ODBC driver) and point them to the entry in tnsnames, which you create for them to use. Still, probably they will have to make some modifications in their code, when connecting to the db, to provide logon/password information. I don't think it's possible to specify password, when configuring ODBC datasource. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 8:13 AM I've been told to migrate one MS-Access 97 database to oracle. Oracle Migration Workbench did the trick in an extremely clean, quick and complete way. Tables are created, populated with data and it is now when the problem starts. The people that were using this Access database were doing so by means of an ancient VB piece of ... code and they don't want or they don't know to adjust it. They expect the program to somehow find the new Oracle 8.1.7.3 instance and continue to work as it did before. I created a new access database containing ODBC links to the Oracle tables, but the program is complaining that the links are read only. Is there any way in this world or beyond to make these tables writable? I'm inclined to tell them that they should do some coding, which is very likely to make them go back to Access. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Manager decrees his data warehouse design. Help!
[EMAIL PROTECTED] wrote: A very true set of statements on all sides. I've done as much am in the process once again. I just wish that once in my life as a DBA I did not have to cleanup someone else's mess. Now if you all don't mind, I'm off to the hardware store for a new shovel!! :-) you mean they would actually consult you when the application was being designed, so you could help provide a design that was efficient and easy to maintain? yea, right. not even in my dreams.;-) -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. [Unix] is not necessarily evil, like OS/2. - Peter Norton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RE: RE: Manager decrees his data warehouse design.
Actually, they're different. SAN = faster, more $$$ (e.g. EMC) NAS = slower, less $$$ (e.g. Network Appliance) -JC -Original Message- Sent: Thursday, February 28, 2002 9:38 AM To: Multiple recipients of list ORACLE-L Patrice, They are synonyms for each other as far as I understand. Dick Goulet Reply Separator Author: Boivin; Patrice J [EMAIL PROTECTED] Date: 2/28/2002 3:38 AM I guess the reverse of SAME is EMAS, where Everything Makes Absolute Sense. : ) NAS, is that the same thing as a SAN? Network - Attached Storage Storage Area Network Here we have a couple of SANs, but I think they also fit the description you gave of an NAS. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Wednesday, February 27, 2002 6:53 PM To: Multiple recipients of list ORACLE-L S.A.M.E, Stripe And Mirror Everything. It's a concept that came from an individual at Oracle with a significant pile of alphabet soup after his name who has lost most of his credibility anywhere. He was speaking though of Network Attached Storage (NAS) stuff where you really don't have to worry about the mount point/drive letter where you put the datafile(s). These neato devices do make some of the DBA's tasks of IO balancing meaningless since they do stripe data across multiple disks and run hardware mirroring in the background. In turn they retrieve your data from the most efficient place possible buffer your writes in cache memory that 'guarantees' that it will absolutely make it to disk. What I think has happen is that some of his idea was taken out of context, though not out of quote, and made meaningless. You should still have logical database design and multiple tablespaces/datafiles. It's just that you really don't care is everything is on drive H. Dick Goulet PS: I've not implemented such an idea have no intention thereof in the near future. Reason, NAS storage is not here. Reply Separator Author: Michael Cupp [EMAIL PROTECTED] Date: 2/27/2002 1:20 PM S.A.M.E.? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cunningham, Gerald INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Import placing data into wrong tablespace
I seem to recall something like this from the past. I believe that I ended up having to grant quota of 0 on the other tablespaces to force Oracle to populate the correct tablespace. Systems Admin Operations | Admin. et Exploit. des systèms Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO (506) 529 5911 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 27, 2002 4:18 PM To: Multiple recipients of list ORACLE-L Subject:RE: Import placing data into wrong tablespace ENVTST doesn't need unlimited tablespace, because SYSTEM has unlimited tablespace --- Deshpande, Kirti [EMAIL PROTECTED] wrote: ENVTST with unlimited tablespace, quota on DATA ??? - Kirti -Original Message- Sent: Wednesday, February 27, 2002 12:20 PM To: Multiple recipients of list ORACLE-L I have a user ENVTST with a default tablespace ENVTST_DATA. I have a user ENVTPA with a default tablespace DATA. I export user ENVTPA as SYSTEM, and then try to import into ENVTST schema, also as SYSTEM. Data is going into DATA tablespace, not ENVTST_DATA tablespace. Any ideas? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Taylor, Shirley INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Perf Advice Needed: cache buffers chains, high waits, _db_block_hash_buckets
[Mogens Nørgaard] Amen. Contention for cache buffers chains means too much logical IO, ie. find and exterminate heavy SQL. I don't see why the heavy SQL would result in the chain having 66 buffer heads in it, though, or why the sleep count would be so skewed. And my core question is still whether the number of buckets being non-prime is normal or not - it seems awfully wrong to me. That there's a lot of contention *is* a factor of the SQL, but the fact that it's so skewed to only a few chains is what worries me more. Once I have the contention down to a particular latch, but that latch protects a buffer chain with 66 buffer heads in it, how can I find out which ones of the 66 are generating the most attempts at that latch? Tell ya what - can I get a few ppl to run this query? It tells the min/max/avg for the number of buffers associated with each chain and if my numbers are high I can at least have a chance of spreading out the buffers over more chains (by upping the number of latches from 4k to 16k, 32, whatever) - it won't drop the actual IO any, of course, but since I don't have a hard fix on which buffers of the 66 are really the source of my contention, I'm not sure where to go from here. SELECT min(buffers_per), max(buffers_per), avg(buffers_per), sum(buffers_per) FROM ( SELECT count(*) buffers_per, hladdr FROM x$bh b, all_objects o, v$latch_children v WHERE b.HLADDR=v.addr AND b.obj=o.object_id AND v.name LIKE '%cache buffers %' GROUP BY hladdr ) My results: min = 39 max = 119 avg = 55.06 sum = 22 If this shows to be about the same in other (well-tuned) Oracle DB's, then I won't worry as much about the number of buffers in each chain and would then focus on trying to isolate the specific buffers, then the source SQL causing the problem, etc. Given my previous sql trace analyses, I have a good idea what the problem SQL statement is, but it's a bit of a necessary evil right now (a join of a table (260k rows) and a materialized view (2k rows), 6 conditions in there where, and it gets executed a ton, probably on the order of 10x a second at peak) - all indexes that helped performance are created and around already. :( But, ideally I'd like to be able to prove this is the cause of the hot buffers before fixing anything. Thanks, guys!! James -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Total Extents
dba_segments is a view on sys_dba_segs which is: all normal segments union all all temp segs union all all rollback segs the last two of which we rarely care about when it comes to checking space etc. You can get (some) gains by creating your own view on just the normal segs hth connor --- Deshpande, Kirti [EMAIL PROTECTED] wrote: That's what I thought too, but it will skip extents from any LMTs in use. And getting extents info when LMTs are is use will be slower as compared to DMTs due the way this info is stored in the bitmap in each datafile for the LMT. - Kirti -Original Message- Sent: Wednesday, February 27, 2002 4:47 PM To: Multiple recipients of list ORACLE-L How about counting rows from uet$? I have not tried it. Raj Post, Ethan Ethan.Post@pTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] s.net cc: Sent by: Subject: Total Extents root@fatcity. com February 27, 2002 05:13 PM Please respond to ORACLE-L Anyone recommend a faster access path for getting the total number of extents in the database? select sum(extents) from dba_segments is too slow for my purposes. Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
show prompt and accept variable in NT/2000 bat file???
Hi, How to show prompt and accept variable in NT/2000 bat file? I'd like to do something like: Inside bat file -- prompt The SID is: set ORACLE_SID=Input_Variable Thank you! Janet __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
vxfs File System full - it's not, and it's not Oracle (I don't think)
My sysadmin is complaining about an Oracle(?) error on our HP9000, HP_UX v11.0, running three Oracle 8.1.7.0 instances. His error message is as follows: vxfs: mesg 001: vx_nospace - /dev/vgt001/lvol1 file system full (1 block extent) This file system has my /u001/app/oracle.. OFA compliant stuff on it. A df -k shows me the following: qe2l1:oracle /u001/app/oracle/admin/sasidist/bdumpdf -k . /u001 (/dev/vgt001/lvol1 ) : 7096543 total allocated Kb 1729572 free allocated Kb 5366971 used allocated Kb 75 % allocation used Nothing in any of the alert logs, the databases are up and functioning with several hundred users logged in and working away. The sysadmin has told damagement that it's Oracle's fault the backups aren't working (I don't trust the tape setup, and let them think they're backing up the DBs, but backups are run to disk and they get the compressed TAR'd result on tape - I hope). I have my doubts, but am thinking the error might have something to do with OmniBack, absent Oracle. Metalink doesn't have anything on this, and there are some questions I've found on Google, but no answers yet. Any input (well...almost any input) would be appreciated David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: iSQLPlus Problem
Title: Message Are you sure you can see hidden dirs? -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 10:03 AMTo: Multiple recipients of list ORACLE-LSubject: iSQLPlus Problem I have a DELL 8200 with XP Prof. and I have installed 9i (9.0.1). When I look at installed products with the Universal Installer it says that iSQL Plus is installed at: c:\oracle\ora90\oracle_prod\ However, when I look at my C: drive I only have: c:\oracle\ora90\ "oracle_prod" is not there and neitherare any apps for iSQL Plus. What is wrong? Thanks, Ken Janusz, CPIM
Re:PROC ????
Ehsan, We had a similar problem recently. The program would core dump when the size of a static array of structures was increased. Static variables get allocated from the stack and not the heap. If the same variables are declared globally (outside of main) or declared as pointers and memory allocated using malloc, then the memory is allocated from the data segment. Regards, Denny --- [EMAIL PROTECTED] wrote: Ehsan, I've been using Pro*C for the last 18 years have compiled some really large programs without a problem. Actually I've had the precompiler find errors in my code that the compiler missed, so I really don't see a problem. On the other hand I do have OCI programs running around, which I've been in the habit of converting to Pro*C. If you want to forward the config file, source (if your boss will let you) and the version/os your using I may be able to help. Dick Goulet Reply Separator Author: ehsan sinavalda [EMAIL PROTECTED] Date: 2/28/2002 4:23 AM Hi All I have some problems with proc. the most important is that when PROC config file exceeds 100 lines the proc precompiler stops with a Segmentation Fault. It seems that they have used a static array !!! What is your opinion. Also the I receive many errors from standard include files in /usr/include/ when I run precompiler. Do you think that I took mistake or the precompiler is such weak? what is your opinion? Do you suggest switching to OCI? Thanks Ehsan = -- Denny Koovakattu [EMAIL PROTECTED] http://oneco.net/ __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denny Koovakattu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 on Sun StorEdge T3 Disk Array
Kevin - Not to smash your day, but we have had a horrible time with an older version of this array. The main drawback is that the arrays support a grand total of 2 LUNS each. We are actually looking a SAN solution now to replace our 2 T3 arrays. If you have a newer model of the T3s that support more LUNS, you should have much better luck. Part of our problem may be the fact that damagement was promised fantastic throughput on these devices, yet everything was configured as RAID-5 - for my database. When we went back and split up the arrays with 2 mirrored drives and the rest on RAID-5, we got a significant improvement. However, our SA was forced to destroy everything to do the re-configuration. We've also been hampered by the fact we are not running Veritas File System - just Volume Manager. YMMV - I hope. Brian Kevin Bass wrote: We have just gotten in a Sun StorEdge T3 Disk Array for the database and future data warehouse. This T3 disk array has 18 hard drives with 36 gigs of space each. Has anyone had any experiences, problems or comments while setting up or using it.Kevin Bass Senior Manager, DBA Americal Corporation Phone: (252) 762-2144 E-mail: [EMAIL PROTECTED] -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | || | mailto:[EMAIL PROTECTED] | | http://bmcgraw.home.mindspring.com | --
RE: RE: RE: Manager decrees his data warehouse design. Hel
They're different. As I understand it, in a nutshell: NAS) A bunch of disks connected to the network SAN) A bunch of disks connected to the network, but with management that allows dedication of storage to a server/application. It doesn't have to be just disk: any storage device. Here's a 'Quick Study' link: http://computerworld.com/cwi/story/0,1199,NAV47-68-85-1950-1974_STO43527,00.html Jared Boivin, Patrice J [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/28/02 03:38 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RE: RE: Manager decrees his data warehouse design. Hel I guess the reverse of SAME is EMAS, where Everything Makes Absolute Sense. : ) NAS, is that the same thing as a SAN? Network - Attached Storage Storage Area Network Here we have a couple of SANs, but I think they also fit the description you gave of an NAS. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent:Wednesday, February 27, 2002 6:53 PM To: Multiple recipients of list ORACLE-L design. Hel S.A.M.E, Stripe And Mirror Everything. It's a concept that came from an individual at Oracle with a significant pile of alphabet soup after his name who has lost most of his credibility anywhere. He was speaking though of Network Attached Storage (NAS) stuff where you really don't have to worry about the mount point/drive letter where you put the datafile(s). These neato devices do make some of the DBA's tasks of IO balancing meaningless since they do stripe data across multiple disks and run hardware mirroring in the background. In turn they retrieve your data from the most efficient place possible buffer your writes in cache memory that 'guarantees' that it will absolutely make it to disk. What I think has happen is that some of his idea was taken out of context, though not out of quote, and made meaningless. You should still have logical database design and multiple tablespaces/datafiles. It's just that you really don't care is everything is on drive H. Dick Goulet PS: I've not implemented such an idea have no intention thereof in the near future. Reason, NAS storage is not here. Reply Separator Author: Michael Cupp [EMAIL PROTECTED] Date: 2/27/2002 1:20 PM S.A.M.E.? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MS Access migration to oracle
Check the ODBC configuration in Control Panel and make sure the connection is not set to read only. If you have primary keys on the tables access should be capable of seeing these and thus will allow updates to the table. If not you should be prompted to supply the key columns from a list of columns when you attach to the table. Other than that I would suggest you update the ODBC drivers. - Ethan -Original Message- Sent: Thursday, February 28, 2002 7:13 AM To: Multiple recipients of list ORACLE-L I've been told to migrate one MS-Access 97 database to oracle. Oracle Migration Workbench did the trick in an extremely clean, quick and complete way. Tables are created, populated with data and it is now when the problem starts. The people that were using this Access database were doing so by means of an ancient VB piece of ... code and they don't want or they don't know to adjust it. They expect the program to somehow find the new Oracle 8.1.7.3 instance and continue to work as it did before. I created a new access database containing ODBC links to the Oracle tables, but the program is complaining that the links are read only. Is there any way in this world or beyond to make these tables writable? I'm inclined to tell them that they should do some coding, which is very likely to make them go back to Access. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Total Extents
Kirti, In LMT you can query the X$KTFBUE which is roughly equivalent to UET$ in DMTs. select v.name FILE NAME,count(x.KTFBUEFNO) TOTAL # of EXTENTS from V$datafile v, X$KTFBUE x where v.file#=X.ktfbuefno group by v.name; Ethan, Is this what you are looking for or something else? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Kirti Sent: Thursday, February 28, 2002 7:13 AM To: Multiple recipients of list ORACLE-L That's what I thought too, but it will skip extents from any LMTs in use. And getting extents info when LMTs are is use will be slower as compared to DMTs due the way this info is stored in the bitmap in each datafile for the LMT. - Kirti -Original Message- Sent: Wednesday, February 27, 2002 4:47 PM To: Multiple recipients of list ORACLE-L How about counting rows from uet$? I have not tried it. Raj Post, Ethan Ethan.Post@pTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] s.net cc: Sent by: Subject: Total Extents root@fatcity. com February 27, 2002 05:13 PM Please respond to ORACLE-L Anyone recommend a faster access path for getting the total number of extents in the database? select sum(extents) from dba_segments is too slow for my purposes. Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle 8.1.7 patch 2 or 3?
[EMAIL PROTECTED] wrote: Hi, I am managing a software that uses a set of 8 oracle databases. I am preparing to upgrade all my databases from 8.1.6.3.0 to 8.1.7.0.0 then apply a patch to the oracle software installation after the upgrade. The software that uses these databases are only certified on patch 2 level at the time of release. Since now the patchset 3 for 817 is available, I would like to get advice in whether to apply patch 3 instead of patch 2. Same amount of work, more benefits. The only thing is that the application vendor does not officially support the patch3. this can lead to problems getting support for the third party applications. i have had support withdrawn when i was at anon supported patch level. before doing this i'd check with the support of the application. -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. [Unix] is not necessarily evil, like OS/2. - Peter Norton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 8.1.7 patch 2 or 3?
Thanks Bill. I will keep that in mind. Sometimes the vendor doesn't want to spend time to help out and find this as the reason to do so. Sharon --On Thursday, February 28, 2002 11:32 AM -0500 bill thater [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: Hi, I am managing a software that uses a set of 8 oracle databases. I am preparing to upgrade all my databases from 8.1.6.3.0 to 8.1.7.0.0 then apply a patch to the oracle software installation after the upgrade. The software that uses these databases are only certified on patch 2 level at the time of release. Since now the patchset 3 for 817 is available, I would like to get advice in whether to apply patch 3 instead of patch 2. Same amount of work, more benefits. The only thing is that the application vendor does not officially support the patch3. this can lead to problems getting support for the third party applications. i have had support withdrawn when i was at anon supported patch level. before doing this i'd check with the support of the application. -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. [Unix] is not necessarily evil, like OS/2. - Peter Norton -- Xiaohong Yang (Sharon) certified Oracle DBA Center for Bioinfomatics, CB#7100 School of Medicine UNC-CH 919-843-6016 (o) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xiaohong Yang (Sharon) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Perf Advice Needed: cache buffers chains, high waits, _db_block_hash_buckets
From my biggest problem child. No bind variables, tends to get busy at times. Mission critical of course. MIN(BUFFERS_PER) MAX(BUFFERS_PER) AVG(BUFFERS_PER) SUM(BUFFERS_PER) 1 17 5.45231072 5545 1 row selected. From our production SAP system: MIN(BUFFERS_PER) MAX(BUFFERS_PER) AVG(BUFFERS_PER) SUM(BUFFERS_PER) 1 13 4.0584075941899 1 row selected. Jared James Manning [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/28/02 09:13 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Perf Advice Needed: cache buffers chains, high waits, _db_block_hash_buckets [Mogens Nørgaard] Amen. Contention for cache buffers chains means too much logical IO, ie. find and exterminate heavy SQL. I don't see why the heavy SQL would result in the chain having 66 buffer heads in it, though, or why the sleep count would be so skewed. And my core question is still whether the number of buckets being non-prime is normal or not - it seems awfully wrong to me. That there's a lot of contention *is* a factor of the SQL, but the fact that it's so skewed to only a few chains is what worries me more. Once I have the contention down to a particular latch, but that latch protects a buffer chain with 66 buffer heads in it, how can I find out which ones of the 66 are generating the most attempts at that latch? Tell ya what - can I get a few ppl to run this query? It tells the min/max/avg for the number of buffers associated with each chain and if my numbers are high I can at least have a chance of spreading out the buffers over more chains (by upping the number of latches from 4k to 16k, 32, whatever) - it won't drop the actual IO any, of course, but since I don't have a hard fix on which buffers of the 66 are really the source of my contention, I'm not sure where to go from here. SELECT min(buffers_per), max(buffers_per), avg(buffers_per), sum(buffers_per) FROM ( SELECT count(*) buffers_per, hladdr FROM x$bh b, all_objects o, v$latch_children v WHERE b.HLADDR=v.addr AND b.obj=o.object_id AND v.name LIKE '%cache buffers %' GROUP BY hladdr ) My results: min = 39 max = 119 avg = 55.06 sum = 22 If this shows to be about the same in other (well-tuned) Oracle DB's, then I won't worry as much about the number of buffers in each chain and would then focus on trying to isolate the specific buffers, then the source SQL causing the problem, etc. Given my previous sql trace analyses, I have a good idea what the problem SQL statement is, but it's a bit of a necessary evil right now (a join of a table (260k rows) and a materialized view (2k rows), 6 conditions in there where, and it gets executed a ton, probably on the order of 10x a second at peak) - all indexes that helped performance are created and around already. :( But, ideally I'd like to be able to prove this is the cause of the hot buffers before fixing anything. Thanks, guys!! James -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Clash of the DBs in eWeek
At first glance it looks like they could have done more to tune Oracle. Certain tables could have been cached (or buffer pools could have been used). They're only using a 4K db block so it would have been nice to see tests with 8K and 16K db blocks. Sort area size may need tuning. I'd like to see some tkprof on the queries and see what the most expensive queries are in terms of CPU, I/O, and number of executions. It would be nice to see database results on Linux... It would be cool to see what some focused tuning efforts could do but who has time for that? Anyone have any other tuning suggestions for eWeek? Time for the tuning DBA guru's to shine. :-) -Original Message- Sent: Thursday, February 28, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled Database Clash? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the Online Exclusive: Download our configuration and tuning scripts. According to the Oracle setup docs in there, they're NOT using MTS and processes in init.ora is 150. So then how did they test for 1000 concurrent Web clients? Anyone have a thought? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: moving from unix to NT
I don't have any experience with UTL_FILE on NT. I've used it a little on unix. Don't know why it wouldn't work on NT. As stated by others, it might be a problem if writing to network drives, as the SYSTEM user does not have access to those when run as a service. This doesn't seem reasonable though, as the instance itself does not run as a service. The VOS runs as a service, but not the instance. Best bet is to try it. The biggest problem will likely be your code. If you have paths hard coded in it, you will have to rewrite. If they are stored in a table, just change the data. If you're interested in Perl, I can send you the same email I sent Dave Farnsworth. I can do that tonight from home if you like. Jared John Dunn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/28/02 02:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: moving from unix to NT Jared It would be useful if you could point me in the right direction. I guess the real question for me is will UTL_FILE work properly when I move to NT, including on Network drives?. There seems to be some doubt amongst the listers as to whether it does. John. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: 27 February 2002 18:35 To:Multiple recipients of list ORACLE-L Subject: RE: moving from unix to NT Perl is *much* more flexible than UTL_FILE for flat file operations. There is simply no basis for comparison. The question in your case is this: Can you easily replace the PL/SQL procedures that are using UTL_FILE with a process that runs outside of the database? If so, myself and others on this list can point you in the right direction, as basics in Perl/Oracle/DBI are really not too hard. If your PL/SQL is part of a larger application and not easily removed, you may just have to deal with modifying the PL/SQL. Of course, if you had made this stuff data driven ( meta data, if you will ), this would be a non-issue. :) Jared John Dunn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/27/02 01:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: moving from unix to NT Thanks to everyone for their input into this. The only real issue seems to be UTL_FILE on network drives. 1. I was interested in the many references to Perl as an alternative to using UTL_FILE. Could any of you provide more detail. I know nothing about Perl so would be interested in how to replace the use of UTL_FILE in PL/SQL with Perl. We use UTL_FILE quite a lot for reading and writing flat files. 2. With regard to external procedures, On Unix we currently use this to call a C routine that calls the system command to run Unix commands and scripts(Korn Shell). I presume we will need to amend these commands to their NT equivalents(or can I call Windows API directly from PL/SQL? on NT) and re-write the scripts...presumably in Perl? It will probbably be Oracle 9i on NT. John -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: 26 February 2002 21:37 To:Multiple recipients of list ORACLE-L Subject: Re: moving from unix to NT I haven't tried to do this with Oracle, I just knew that you could. My use has been to change the account that is used for some of my monitors that need to see network drives. I've never had a need to make Oracle run as other than System. As for UTL_FILE, I avoid it like the plague. Perl is much cleaner and easier to use. Jared Igor Neyman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/26/02 10:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: moving from unix to NT Well, I was having all kinds of problems, when I was playing with this option, trying to make oracle service on nt to run under other then SYSTEM account. And yes, I granted this account any possible NT privilege (like ability to run/logon as a service), still didn't work. Jared, Could you share some details on this issue, if you still remember how you managed to make this working? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 1:14 PM Because Oracle on NT runs (hence executes UTL_FILE) under SYSTEM account, which does not have privileges to access network drives. You can change that if you're so inclined. ( I can't believe I'm defending Windoze. shudder ) Jared
exp/imp question
List, Source database 7.3.4 OS Novell 4.2 Target database 8.1.7 OS Linux RedHat 7.2 Table is 5 columns ,indexes on columns 1,2PK, 1,3 , 3 for application usage Export of a table is 750K rows and takes about 2 minutes with a DMP file the size of 20 Meg. Import command in the V$SQLAREA shows INSERT /*NESTED_TABLE_SET_REFS*/ INTO DRITV (COL1,COL2,COL3,COL4,COL5) VALUES(:1,:2,:3,:4,:5) and takes 1.5+ hours. The table is truncated because this is a copy of data from production to a test database. Question is why could it be taking such a long time to load and I have not been able to find the hint info in my of my doc's. The table is not a nested table and the hint confuses me. What does it mean. I am going to truncate the table again and do a copy across the network to get the time for that action. Thanks, Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
32 or 64 bit
Title: Message Hi, How to check the database and sun unix system is 32 bit or 64 bit. Thanks --Harvinder
RE: moving from Unix to NT
As long as you use drive letter (instead of \\machine\share) format and your drive permissions are all set, you should be okay. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you *2
RE: RE: RE: RE: Manager decrees his data warehouse design.
What is the avg rate for a NAS? Where is a good place to buy? -Original Message- Sent: Thursday, February 28, 2002 12:03 PM To: Multiple recipients of list ORACLE-L Actually, they're different. SAN = faster, more $$$ (e.g. EMC) NAS = slower, less $$$ (e.g. Network Appliance) -JC -Original Message- Sent: Thursday, February 28, 2002 9:38 AM To: Multiple recipients of list ORACLE-L Patrice, They are synonyms for each other as far as I understand. Dick Goulet Reply Separator Author: Boivin; Patrice J [EMAIL PROTECTED] Date: 2/28/2002 3:38 AM I guess the reverse of SAME is EMAS, where Everything Makes Absolute Sense. : ) NAS, is that the same thing as a SAN? Network - Attached Storage Storage Area Network Here we have a couple of SANs, but I think they also fit the description you gave of an NAS. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Wednesday, February 27, 2002 6:53 PM To: Multiple recipients of list ORACLE-L S.A.M.E, Stripe And Mirror Everything. It's a concept that came from an individual at Oracle with a significant pile of alphabet soup after his name who has lost most of his credibility anywhere. He was speaking though of Network Attached Storage (NAS) stuff where you really don't have to worry about the mount point/drive letter where you put the datafile(s). These neato devices do make some of the DBA's tasks of IO balancing meaningless since they do stripe data across multiple disks and run hardware mirroring in the background. In turn they retrieve your data from the most efficient place possible buffer your writes in cache memory that 'guarantees' that it will absolutely make it to disk. What I think has happen is that some of his idea was taken out of context, though not out of quote, and made meaningless. You should still have logical database design and multiple tablespaces/datafiles. It's just that you really don't care is everything is on drive H. Dick Goulet PS: I've not implemented such an idea have no intention thereof in the near future. Reason, NAS storage is not here. Reply Separator Author: Michael Cupp [EMAIL PROTECTED] Date: 2/27/2002 1:20 PM S.A.M.E.? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cunningham, Gerald INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Michael Cupp INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 32 or 64 bit
Hrvinder Plese reach to $ORACLE_HOME/bin directory and run file oracle U will see which bit ur oracle is? Thx -Seema From: Harvinder Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: 32 or 64 bit Date: Thu, 28 Feb 2002 10:18:35 -0800 Hi, How to check the database and sun unix system is 32 bit or 64 bit. Thanks --Harvinder _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
looking for a DBA
Title: Message At the risk of revealing myself as Damagement... we are looking for an Oracle DBA: http://www.usi.net/careers/listopenings.html?D139 I am the direct hiring damager, but you should apply through our website. I will be happy to answer questions, though. Thanks! - Jerry
OPEN_CURSORS and SHARED_POOL_SIZE
SysAdmin of production system has increased shared_pool_size from 20MByte to 110Mbyte to correct a shared pool size error. Shortly after, he began seeing too many open cursors while trying to login via the front-end (Silverstream). RTFM says To take advantage of additional memory available for shared SQL areas, you may also need to increase the number of cursors permitted for a session. You can do this by increasing the value of the initialization parameter OPEN_CURSORS. But there's no causal relationship between increasing shared_pool_size and the open_cursors error, is there? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kirsch, Walter J (Northrop Grumman) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Non-partitioned table to Hash Partitioned table
Kevin, how about using the ALTER TABLE EXCHANGE command to move the info from a non-partitioned to a partitioned table. ROR mª¿ªm [EMAIL PROTECTED] 02/28/02 11:28AM Hello! I am trying to figure out the best way to convert a non-partitioned table with approx 20 million rows into a hash-partitioned table. This should be done with minimal down-time. This will be in an Oracle 9i environment done at a time when only SELECTs are occuring on the table. The best way I can figure is to create a second table and copy the data over; create the indexes; and rename the tables. I would appreciate any hints on what section of TFM to read. Kevin Toepke [EMAIL PROTECTED] The information in this electronic mail message is Trilegiant Confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Trilegiant Corporation is not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Unused users for the last 30 and 60 days.
Hi All, I want to have report of all the users who has not used their Oracle username for the last 30 and 60 days. Any views how can I get the report. Thanks, Deepender -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Upgrade to 64bit HP-UX 11.0
We're running 4 instances of Oracle 8.1.6/7 on a 2Gig, 32 bit HP-UX 11.0 To move up to 9i, will a simple doubling of RAM be underkill? overkill? Will disk requirements stay roughly the same for Oracle? for the OS? Any experiences you share will be gratefully accepted. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kirsch, Walter J (Northrop Grumman) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Clash of the DBs in eWeek
Which docs? I looked at the init.ora file, and it had: processes=530 and MTS enabled. Brian -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | -- Rachel Carmichael wrote: they lie? --- Jesse, Rich [EMAIL PROTECTED] wrote: Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled Database Clash? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the Online Exclusive: Download our configuration and tuning scripts. According to the Oracle setup docs in there, they're NOT using MTS and processes in init.ora is 150. So then how did they test for 1000 concurrent Web clients? Anyone have a thought? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Total Extents
Gopal, Thanks for the info.. - Kirti -Original Message- Sent: Thursday, February 28, 2002 11:53 AM To: Multiple recipients of list ORACLE-L Kirti, In LMT you can query the X$KTFBUE which is roughly equivalent to UET$ in DMTs. select v.name FILE NAME,count(x.KTFBUEFNO) TOTAL # of EXTENTS from V$datafile v, X$KTFBUE x where v.file#=X.ktfbuefno group by v.name; Ethan, Is this what you are looking for or something else? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Kirti Sent: Thursday, February 28, 2002 7:13 AM To: Multiple recipients of list ORACLE-L That's what I thought too, but it will skip extents from any LMTs in use. And getting extents info when LMTs are is use will be slower as compared to DMTs due the way this info is stored in the bitmap in each datafile for the LMT. - Kirti -Original Message- Sent: Wednesday, February 27, 2002 4:47 PM To: Multiple recipients of list ORACLE-L How about counting rows from uet$? I have not tried it. Raj Post, Ethan Ethan.Post@pTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] s.net cc: Sent by: Subject: Total Extents root@fatcity. com February 27, 2002 05:13 PM Please respond to ORACLE-L Anyone recommend a faster access path for getting the total number of extents in the database? select sum(extents) from dba_segments is too slow for my purposes. Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Clash of the DBs in eWeek
I'm guessing JDBC connection pooling within WebLogic. Jesse, Rich wrote: Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled Database Clash? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the Online Exclusive: Download our configuration and tuning scripts. According to the Oracle setup docs in there, they're NOT using MTS and processes in init.ora is 150. So then how did they test for 1000 concurrent Web clients? Anyone have a thought? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 8.1.7 patch 2 or 3?
Be careful with the 8.1.7.3 patchset if you use the dbms_describe or odbsidescribe functions as the output format has changed in them between 8.1.7.2 and 8.1.7.3 and 9.0.1.1 and 9.0.1.2... If you are not using this functionality, then there is not problem. If you are using it, make sure you exercise any code using it for any potential problems. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Thursday, February 28, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Thanks Bill. I will keep that in mind. Sometimes the vendor doesn't want to spend time to help out and find this as the reason to do so. Sharon --On Thursday, February 28, 2002 11:32 AM -0500 bill thater [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: Hi, I am managing a software that uses a set of 8 oracle databases. I am preparing to upgrade all my databases from 8.1.6.3.0 to 8.1.7.0.0 then apply a patch to the oracle software installation after the upgrade. The software that uses these databases are only certified on patch 2 level at the time of release. Since now the patchset 3 for 817 is available, I would like to get advice in whether to apply patch 3 instead of patch 2. Same amount of work, more benefits. The only thing is that the application vendor does not officially support the patch3. this can lead to problems getting support for the third party applications. i have had support withdrawn when i was at anon supported patch level. before doing this i'd check with the support of the application. -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. [Unix] is not necessarily evil, like OS/2. - Peter Norton -- Xiaohong Yang (Sharon) certified Oracle DBA Center for Bioinfomatics, CB#7100 School of Medicine UNC-CH 919-843-6016 (o) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xiaohong Yang (Sharon) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Clash of the DBs in eWeek
Interesting, I went to the web page and clicked on the link Putting database performance to the test and got the following message Could not Connect to DB: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. Oh well, maybe they were mad because they lost! John [EMAIL PROTECTED] wrote: At first glance it looks like they could have done more to tune Oracle. Certain tables could have been cached (or buffer pools could have been used). They're only using a 4K db block so it would have been nice to see tests with 8K and 16K db blocks. Sort area size may need tuning. I'd like to see some tkprof on the queries and see what the most expensive queries are in terms of CPU, I/O, and number of executions. It would be nice to see database results on Linux... It would be cool to see what some focused tuning efforts could do but who has time for that? Anyone have any other tuning suggestions for eWeek? Time for the tuning DBA guru's to shine. :-) -Original Message- Sent: Thursday, February 28, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled Database Clash? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the Online Exclusive: Download our configuration and tuning scripts. According to the Oracle setup docs in there, they're NOT using MTS and processes in init.ora is 150. So then how did they test for 1000 concurrent Web clients? Anyone have a thought? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 32 or 64 bit
http://www.vampired.net/forums/viewtopic.php?topic=32forum=150 Harvinder Singh wrote: Hi, How to check the database and sun unix system is 32 bit or 64 bit. Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Manager decrees his data warehouse design. Help!
Rach, good point. boy, do we live in a tough world :) -Original Message- Sent: Thursday, February 28, 2002 1:49 PM To: Multiple recipients of list ORACLE-L But Tom, there will be a short time period where people are asking who designed this piece of crap? and the manager who designed it will be pointing to the DBA... so you need the paper trail --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: Rachel, That's what step #3 is for. Everyone will forget how bad the first warehouse was once the true properly designed warehouse is in place and delivering the goods. It sounds like there is pressure to deliver something right away - as usual, no time to design it properly. A manager I used to work for had the best philosophy: Lets hurry up and do it wrong so that we can fix it later. Sounds strange, but that's the business we choose to be in (ala The Godfather). *Nobody* wants to spend time and resources doing research to desig n a system. In a way, it's our (the IT industry's) fault. We have promised for years that we can develop programs faster and faster. Now, the managers expect it. But most of them realize that it's a mistake, but easier to fix after the fact. my little 2 cents. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, February 28, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Just make sure it's documented that the original idea is NOT yours :) --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: Don, I agree with Yechiel. You do, after all, work for this guy, and by extension, the company. You need to learn to pick your fights. In the larger picture, does it really matter that much? Are your kids at home going to be disappointed in you if you build this POC? Take the advice of most of the members of this list. Build this thing as quickly as possible, and deliver it to the users. It sounds like they : 1). will not use it, so you will get to throw it away in a year 2). will use it, and will be disappointed with it and stop using it - in which case you get to throw it away in a year 3). once it is built, re-design it the way you want (in a new schema) and, when the original fails, announce that you have been studying the matter and have a better version waiting to implement. You will become the hero all the way around. Your boss will be glad that he delivered the first warehouse. He will be happy that, when problems arise from the first version, that you are on the spot with version #2 to solve his problems and make him look good again. In the meantime, go home, kiss your wife, hug your kids, pet the dog, read a good book, go for a walk, throw a baseball with your kids, go to the movies with your wife, and realize that, like food poisoning, this too will pass. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, February 28, 2002 3:23 AM To: Multiple recipients of list ORACLE-L Hello Don In a more serious mood: DO IT. I also had some arguments with my boss over the years and except for 2-3 cases (in 20 years) that I told my boss that I will not do something and if he wants it he can do it himself, my motto was if he wants to waste resources for something that is obviously an error let him waste it. He wants you to waste time and disk space on a system that the users will not use: waste your time and the resources. He is management and he is the one who calls the shots. Just document everything to cover yourself later. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Don [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 27, 2002 8:48 AM To: Multiple recipients of list ORACLE-L Subject: Manager decrees his data warehouse design. Help! I've lost patience, my temper, and I'm about to quit a job because the IT manager has decreed that we will have his data warehouse running within 24 hours, and we will use his design. 1 - We are NOT to use any kind of views, not even materailzed views. 2 - we are not to do any computations, summaries or rollups 3 - we are to have everything in one table 4 - the table name and column names will be meaningful to any clerk 5 - we are not to start or snowflake designs. That's just a bunch of high power talk. 6 - all users will be trained to use MS Access to get at their data. (These are users that were just converted off from green screen teminals within the last 45-days, to Windows 98 with 64k RAM.) 7 - We are not to just copy the legacy transactions. 8 - We are to load into an Oracle table, all legacy transction data because we don't want to limit how or what a user will look at 9 - It is not
RE: MS Access migration to oracle
Waleed, you saved my life! I don't know why was I expecting Access97 application designers to define minor details like the primary keys. I most certainly owe you one. -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 9:48 AM To: Multiple recipients of list ORACLE-L Subject: RE: MS Access migration to oracle Either it's the privileges on the tables or the tables do not have primary keys or unique keys. Access will put the table in read only mode if it does not have PK or Unique key. Waleed -Original Message- Sent: Thursday, February 28, 2002 8:13 AM To: Multiple recipients of list ORACLE-L I've been told to migrate one MS-Access 97 database to oracle. Oracle Migration Workbench did the trick in an extremely clean, quick and complete way. Tables are created, populated with data and it is now when the problem starts. The people that were using this Access database were doing so by means of an ancient VB piece of ... code and they don't want or they don't know to adjust it. They expect the program to somehow find the new Oracle 8.1.7.3 instance and continue to work as it did before. I created a new access database containing ODBC links to the Oracle tables, but the program is complaining that the links are read only. Is there any way in this world or beyond to make these tables writable? I'm inclined to tell them that they should do some coding, which is very likely to make them go back to Access. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Install hanging issue
Hi, We are applying patch 9.0.1.1.0 on sun solaris and it looks like when we run ./runInstaller it hangs while analyzing dependencies.. I check the cpu usage and jre is using 98% of cpu. What can be the possible cause of hanging ans so high cpu usage Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Total Extents
Thanks Connor, that is a lot faster. I think I will go with the idea of just watching for any dramatic drops in DBA_FREE_SPACE. I have everything tied down pretty tight but if a single object on a near empty tablespace started to grow uncontrollably I wouldn't pick it up till tablespace hit 75% or so or the next time I review my daily reports. This way I will get notified a bit sooner. - Ethan -Original Message- Sent: Thursday, February 28, 2002 11:23 AM To: Multiple recipients of list ORACLE-L dba_segments is a view on sys_dba_segs which is: all normal segments union all all temp segs union all all rollback segs the last two of which we rarely care about when it comes to checking space etc. You can get (some) gains by creating your own view on just the normal segs hth connor -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-00600 errors
The itar creation process now includes a utility where you can either lookup Ora-600 messages or have it examine the stack trace from an ORA-7445 dump. I had it analyze a stack trace this morning. The result of using the utility is a list of links to articles Metalink considers germane to the problem. None, however, seem to match my particular problem. I also found that I had to use another web window to actually bring up the listed documents via Metalink's advanced search facility using the document id, or through the bug query screen. Simply clicking on the link did nothing. Perhaps the Ora-600 portion of the facility works a bit better? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- From: O'Neill, Sean [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 4:28 AM To: Multiple recipients of list ORACLE-L From: John Dunn [EMAIL PROTECTED] Date: Mon, 25 Feb 2002 16:01:54 - Subject: ORA-00600 errors can anyone tell me waht these errors might mean? Errors in file /u01/app/oracle/admin/vaddev/udump/vaddev_ora_6942.trc: ORA-00600: internal error code, arguments: [17172], [0], [], [], [], [], [], [] Thu Feb 21 03:10:56 2002 Errors in file /u01/app/oracle/admin/vaddev/bdump/vaddev_snp2_10163.trc: ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [] John, There is info for the 17090 error on MetaLink. Navigate as follows: Top Tech Docs Data Server Database Administration ORacle Internal Errors. Which will point you to Note 153788.1 ORA-600 Argument Lookup HTH, - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: replication gui
On Unix it's part of DBAStudio, maybe the same on NT. Bunyamin K. Karadeniz wrote: I have oracle ent. edition on my machine (NT) but do not have the link of adv. replication manager in start panel . What is the name of exe starting the Replication manager ? thank you bunyamin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Clash of the DBs in eWeek
Do you mean it was SQL Server DBAs tuning Oracle in this test, because that's what they are using for their web-site? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 1:58 PM Interesting, I went to the web page and clicked on the link Putting database performance to the test and got the following message Could not Connect to DB: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. Oh well, maybe they were mad because they lost! John [EMAIL PROTECTED] wrote: At first glance it looks like they could have done more to tune Oracle. Certain tables could have been cached (or buffer pools could have been used). They're only using a 4K db block so it would have been nice to see tests with 8K and 16K db blocks. Sort area size may need tuning. I'd like to see some tkprof on the queries and see what the most expensive queries are in terms of CPU, I/O, and number of executions. It would be nice to see database results on Linux... It would be cool to see what some focused tuning efforts could do but who has time for that? Anyone have any other tuning suggestions for eWeek? Time for the tuning DBA guru's to shine. :-) -Original Message- Sent: Thursday, February 28, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled Database Clash? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the Online Exclusive: Download our configuration and tuning scripts. According to the Oracle setup docs in there, they're NOT using MTS and processes in init.ora is 150. So then how did they test for 1000 concurrent Web clients? Anyone have a thought? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Clash of the DBs in eWeek
They used weblogic for the webserver. Typically it will keep several connections open, pooling them in essence. The article indicated that *they* did all the Oracle tuning, and that Oracle did not send anyone to help with the tuning process (unlike MySQL), so it's probably amazing that they got the results they did. I don't think they lied, but I don't think they probably realized that they could have possible eeked out some additional performance had they worked it a bit harder with a knowledgeable web DBA. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Thursday, February 28, 2002 1:49 PM To: Multiple recipients of list ORACLE-L they lie? --- Jesse, Rich [EMAIL PROTECTED] wrote: Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled Database Clash? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the Online Exclusive: Download our configuration and tuning scripts. According to the Oracle setup docs in there, they're NOT using MTS and processes in init.ora is 150. So then how did they test for 1000 concurrent Web clients? Anyone have a thought? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Unused users for the last 30 and 60 days.
Hi Deepender, I know of know builtin oracle view that will tell you this infomation. At a former job we were required to disable accounts that had not been used in the last 60 days. It has been a little while since I worked there (7 years to be exact) but basically this is what we did 1. created a tablecalled dbs_user_info with the fields (username, create_date, last_login_date) 2. copied the username and create field from dba_users into the fields, initially we set last_login_date to be = create; 3. Turned on auditing in the init.ora and audited successful logins 4. at night we went through the sys.aud$ table and for each user that existed updated the last_login_date truncating sys.aud$ when done 5. weekly ran a batch job that found all users that last_login_date was 30 days Beginning in 8i it might be easier to do this with an after login trigger rather than auditing Hope this helps, John that contained the username, [EMAIL PROTECTED] wrote: Hi All, I want to have report of all the users who has not used their Oracle username for the last 30 and 60 days. Any views how can I get the report. Thanks, Deepender -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PocketDBA
Anyone on the list ever use this software? Any feedback? Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: moving from unix to NT
Jared, On NT oracle.exe runs as OracleServiceSID service. Hence UTL_FILE will be executed under whatever OS account OracleServiceSID service runs. And I was not able to make it running properly under any other than SYSTEM account. Remember, on NT Oracle is one big (though multithreaded) process, unlike it is on UNIX. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 1:03 PM I don't have any experience with UTL_FILE on NT. I've used it a little on unix. Don't know why it wouldn't work on NT. As stated by others, it might be a problem if writing to network drives, as the SYSTEM user does not have access to those when run as a service. This doesn't seem reasonable though, as the instance itself does not run as a service. The VOS runs as a service, but not the instance. Best bet is to try it. The biggest problem will likely be your code. If you have paths hard coded in it, you will have to rewrite. If they are stored in a table, just change the data. If you're interested in Perl, I can send you the same email I sent Dave Farnsworth. I can do that tonight from home if you like. Jared John Dunn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/28/02 02:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: moving from unix to NT Jared It would be useful if you could point me in the right direction. I guess the real question for me is will UTL_FILE work properly when I move to NT, including on Network drives?. There seems to be some doubt amongst the listers as to whether it does. John. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: 27 February 2002 18:35 To:Multiple recipients of list ORACLE-L Subject: RE: moving from unix to NT Perl is *much* more flexible than UTL_FILE for flat file operations. There is simply no basis for comparison. The question in your case is this: Can you easily replace the PL/SQL procedures that are using UTL_FILE with a process that runs outside of the database? If so, myself and others on this list can point you in the right direction, as basics in Perl/Oracle/DBI are really not too hard. If your PL/SQL is part of a larger application and not easily removed, you may just have to deal with modifying the PL/SQL. Of course, if you had made this stuff data driven ( meta data, if you will ), this would be a non-issue. :) Jared John Dunn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/27/02 01:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: moving from unix to NT Thanks to everyone for their input into this. The only real issue seems to be UTL_FILE on network drives. 1. I was interested in the many references to Perl as an alternative to using UTL_FILE. Could any of you provide more detail. I know nothing about Perl so would be interested in how to replace the use of UTL_FILE in PL/SQL with Perl. We use UTL_FILE quite a lot for reading and writing flat files. 2. With regard to external procedures, On Unix we currently use this to call a C routine that calls the system command to run Unix commands and scripts(Korn Shell). I presume we will need to amend these commands to their NT equivalents(or can I call Windows API directly from PL/SQL? on NT) and re-write the scripts...presumably in Perl? It will probbably be Oracle 9i on NT. John -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: 26 February 2002 21:37 To:Multiple recipients of list ORACLE-L Subject: Re: moving from unix to NT I haven't tried to do this with Oracle, I just knew that you could. My use has been to change the account that is used for some of my monitors that need to see network drives. I've never had a need to make Oracle run as other than System. As for UTL_FILE, I avoid it like the plague. Perl is much cleaner and easier to use. Jared Igor Neyman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/26/02 10:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: moving from unix to NT Well, I was having all kinds of problems, when I was playing with this option, trying to make oracle service on nt to run under other then SYSTEM account. And yes, I granted this account any possible NT privilege (like ability to run/logon as a service), still didn't work. Jared,
Re: iSQLPlus Problem
Title: Message Yes. - Original Message - From: Michael Cupp To: Multiple recipients of list ORACLE-L Sent: Thursday, February 28, 2002 11:33 AM Subject: RE: iSQLPlus Problem Are you sure you can see hidden dirs? -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 10:03 AMTo: Multiple recipients of list ORACLE-LSubject: iSQLPlus Problem I have a DELL 8200 with XP Prof. and I have installed 9i (9.0.1). When I look at installed products with the Universal Installer it says that iSQL Plus is installed at: c:\oracle\ora90\oracle_prod\ However, when I look at my C: drive I only have: c:\oracle\ora90\ "oracle_prod" is not there and neitherare any apps for iSQL Plus. What is wrong? Thanks, Ken Janusz, CPIM
RE: Clash of the DBs in eWeek
I was involved in a similar thing a while ago, with a couple of different databases including a new in memory database, which is meant to be 10 times faster than Oracle. And it was, until Oracle was tuned. It was a different story then! Jim -Original Message- Sent: 28 February 2002 19:43 To: Multiple recipients of list ORACLE-L Do you mean it was SQL Server DBAs tuning Oracle in this test, because that's what they are using for their web-site? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 1:58 PM Interesting, I went to the web page and clicked on the link Putting database performance to the test and got the following message Could not Connect to DB: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. Oh well, maybe they were mad because they lost! John [EMAIL PROTECTED] wrote: At first glance it looks like they could have done more to tune Oracle. Certain tables could have been cached (or buffer pools could have been used). They're only using a 4K db block so it would have been nice to see tests with 8K and 16K db blocks. Sort area size may need tuning. I'd like to see some tkprof on the queries and see what the most expensive queries are in terms of CPU, I/O, and number of executions. It would be nice to see database results on Linux... It would be cool to see what some focused tuning efforts could do but who has time for that? Anyone have any other tuning suggestions for eWeek? Time for the tuning DBA guru's to shine. :-) -Original Message- Sent: Thursday, February 28, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled Database Clash? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the Online Exclusive: Download our configuration and tuning scripts. According to the Oracle setup docs in there, they're NOT using MTS and processes in init.ora is 150. So then how did they test for 1000 concurrent Web clients? Anyone have a thought? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TRANSPORTABLE TABLESPACE
Hi If i can use transporable tablespace export and import mode then is this elimintae the fragmentation? Thx -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Clash of the DBs in eWeek
In additon.. here's a quote from the article: Microsoft and Oracle both declined to be involved in the test-with their database servers, we did all tuning ourselves with no vendor input. Not at all bad for Oracle to score high without any 'expert' tuning advice. But was this test worth ignoring for Larry?? The on-line poll on the web site was interesiting, though.. (Which server database is most critical to you organization?). Oracle 33.26% MySQL 19.99% SQLServer 15.91% when I voted.. - Kirti -Original Message- Sent: Thursday, February 28, 2002 12:08 PM To: Multiple recipients of list ORACLE-L At first glance it looks like they could have done more to tune Oracle. Certain tables could have been cached (or buffer pools could have been used). They're only using a 4K db block so it would have been nice to see tests with 8K and 16K db blocks. Sort area size may need tuning. I'd like to see some tkprof on the queries and see what the most expensive queries are in terms of CPU, I/O, and number of executions. It would be nice to see database results on Linux... It would be cool to see what some focused tuning efforts could do but who has time for that? Anyone have any other tuning suggestions for eWeek? Time for the tuning DBA guru's to shine. :-) -Original Message- Sent: Thursday, February 28, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled Database Clash? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the Online Exclusive: Download our configuration and tuning scripts. According to the Oracle setup docs in there, they're NOT using MTS and processes in init.ora is 150. So then how did they test for 1000 concurrent Web clients? Anyone have a thought? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PocketDBA
I have. It is pretty cool. I believe the creator, Ari Kaplan, lurks on this list. I bet they'll send you a demo device if you ask. Try out Pocket SA too. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 28 Feb 2002, [EMAIL PROTECTED] wrote: Anyone on the list ever use this software? Any feedback? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unused users for the last 30 and 60 days.
You could audit connects and use that to determine which accounts have not connected to the database in the last 30-60 days. Connect auditing will have 0 performance impacts, but you will need to manage the audit table and write a good SQL script to give you the info you need. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Thursday, February 28, 2002 1:54 PM To: Multiple recipients of list ORACLE-L Hi All, I want to have report of all the users who has not used their Oracle username for the last 30 and 60 days. Any views how can I get the report. Thanks, Deepender -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Clash of the DBs in eWeek
On the MTS part, my faux pas. I saw the first dispatchers commented out along with the other mts% params. Also, on closer inspection, I was looking at create_nile2_database_details.htm in the C - Create Benchmark Database folder in the .zip file when I saw that processes was set to 150. Perhaps they made changes to the init.ora (from the B - Configure Database Server folder) after an initial GUI DB create? Thanks, Brian, and thanks all else that pointed out the JDBC connection pooling. I've been trying to take a look at that stuff, but I've got no time here at work and I can't run Oracle at home on my Linux/Alpha box. sigh Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, February 28, 2002 1:14 PM To: Multiple recipients of list ORACLE-L Which docs? I looked at the init.ora file, and it had: processes=530 and MTS enabled. Brian -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | -- Rachel Carmichael wrote: they lie? --- Jesse, Rich [EMAIL PROTECTED] wrote: Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled Database Clash? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the Online Exclusive: Download our configuration and tuning scripts. According to the Oracle setup docs in there, they're NOT using MTS and processes in init.ora is 150. So then how did they test for 1000 concurrent Web clients? Anyone have a thought? Rich Jesse System/Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).