Re: Hit Ratio
Easy, A new formula for the hit ratio Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, December 21, 2003 1:19 AM Actually, it isn't SAP. I was simply creating a set of MV's based on SAP tables in another database. The script I was running is used to keep track of how much IO is going on, just to ensure that everything is still working during the build. Once the physical IO exceeds the logical IO, the HR goes negative. I wonder what I need to tune to fix this? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Hit Ratio
- Original Message - Actually, it isn't SAP. I was simply creating a set of MV's based on SAP tables in another database. Fair enough. I wonder what I need to tune to fix this? stop creating those tables? D Seriously: aren't you getting the I/O as mostly writes during the create? Therefore it should be very little off the buffers, no? Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 10g new features question for beta testers
It's the Best of Breed versus One Vendor debate, and there are pros and cons galore. The perfect scenario, of course, is when they combine, so one vendor delivers the best of everything. That's what we have with Microsoft, isn't it? ;-) : Office stuff, OS, Database, ERP, CRM, video player, what have you... Then on the Support side of things, it's indeed good to be able to call One Vendor Only... if that vendor is good at Support. If he isn't, you might be better off if you have more than one option for calling. Mogens Pete Sharman wrote: Just a couple of comments on this which hopefully won't go down the Marketing track too far. :) 1. I'm pretty sure Steve Adams agrees with you, since he co-presented on ASM at OracleWorld in San Fran. Not sure if he monitors this group actively or not, but I believe the presentation he did is loaded with all the other OracleWorld 2003 presentations so you can see what he said. 2. One point which makes a lot of sense to me, and it happens in a variety of places in 10g such as ASM and the RAC clusterware. If you have one vendor to raise an issue with (not that you'd need to do that with Oracle of course!), it's a lot easier to get an answer without the finger pointing that can go on between vendors. Take the clusterware example - if you run into a problem running RAC on Sun with the Sun Cluster technology and Veritas owning the disk side, who you gonna call? GhostBusters, maybe! But if you're running RAC on Sun with Oracle's clusterware and ASM, it's a lot easier to determine who to call. Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Connor McDonald Sent: Saturday, December 20, 2003 2:34 AM To: Multiple recipients of list ORACLE-L As with anything I suppose, if a single vendor can be in control of more of the stack between application and physical server structure then there is a greater opportunity for benefits. For example, ASM offers the ability to add disks to a stripe without needing to redistribute(reload) the entire stripeset. A (bug-free) ASM product looks very very impressive to me. Time will tell how close Oracle are to achieving it. hth connor --- [EMAIL PROTECTED] wrote: no ASMs are considerably different. Its supposed to manage everything. You dont give it a file, you give it entire disks and oracle does everything. Sets up files, manages, I/O, everything. you only look at the tablespace level. you dont even install any software on it. If your on SAN, you dont install SAN software on it. From: Goulet, Dick [EMAIL PROTECTED] Date: 2003/12/19 Fri AM 09:14:27 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 10g new features question for beta testers That is not exactly a new feature. Oracle 9i has Oracle Managed Files where you give it a directory and then just build tablespaces. The database picks the filenames for you. Now mind you it does work, but I'll be damned if I use it in anything other than a development environment. For some reason Oracle has never gotten over that DUMB SAME (Stripe And Mirror Everything) idea. The concept is great in theory, but in practice it's absolutely abysmal at best. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, December 19, 2003 8:24 AM To: Multiple recipients of list ORACLE-L I saw a presentation from Oracle on 10g new features last night in Reston,VA. I know atleast one other person from the list was there. Since Oracle is releasing details and its going to be released(in theory) in the next 2 weeks, I was wondering if you guys could talk about it. 1. does ASMs work as well as Oracle claims? I always wonder about first generation features... takes most software vendors a couple of generations to get it right(takes any project Im on just as long). This is a radical departure. for those of you who dont know. Oracle claims that they will manage your disks for you. All you do is give Oracle some Raw Disks and Oracle will set up, and handle all your datafiles. All you do is look at logical tablespaces. It will also handle I/O balancing. How well does this work? Anyone test it with a SAN? 2. RAC Load Balancing. Oracle claims that you only need Oracle software from now on. They also claim that you can load balance multiple applications. Lets say you have One application that runs batch loads over night and a transactional application during the day oracle will automatically steal resources from the other when its not busy... anyone test this? 3. Flashback database. Kyte was the presenter and he said that you can keep massive undo areas, so that if you have a failure or delete data you shouldnt have you can have oracle automatically write the DML necessary to bring it
Re: Hit Ratio
Ah yes, you could introduce heuristically (spelling?!) skewed hit ratios. As Dave Ensor explained at UKOUG, the word heuristic in Oracle's optimizer code can be translated directly into constant. So add a number here or there until it fits. Mogens Jonathan Lewis wrote: Easy, A new formula for the hit ratio Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, December 21, 2003 1:19 AM Actually, it isn't SAP. I was simply creating a set of MV's based on SAP tables in another database. The script I was running is used to keep track of how much IO is going on, just to ensure that everything is still working during the build. Once the physical IO exceeds the logical IO, the HR goes negative. I wonder what I need to tune to fix this? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?UTF-8?B?TW9nZW5zIE7DuHJnYWFyZA==?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: FGRD Vs ARCH
When you use alter system archive log current, then your (foreground) session will do the archiving, thus leaving a FGRD record in your v$archived_log view. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 12, 2003 7:49 PM Dear Gurus, What is the difference FGRD and ARCH in v$archived_log.creator column. I understand FGRD is foreground process. Exactly in what scenario the value will be populated as FGRD? I see something like below in my db. select recid,creator from v$archived_log RECID CREATOR - --- 1 FGRD 2 ARCH 3 ARCH 4 ARCH 5 ARCH 6 ARCH 7 ARCH 8 FGRD 8 rows selected -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
messages
Hello list, I am using 9.2.0.1.0 enterprise edition on windows. Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release 1 I would get the following messages in French c: sqlplus Entrez le nom utilisateur : But now when I specify nls_lang=French_France.US7ASCII , sqlplus sticks to english c: sqlplus Enter user-name: Any ideas ? I tried out the following but to no avail : 1. I specified ora_nls33 to point to D:\OracleXP\Ora92\ocommon\nls\ADMIN\DATA where D:\OracleXP\Ora92\ is my %oracle_home% 2. I set nls_lang=French_France.US7ASCII , log in as a user, checked NLS_SESSION_PARAMETERS. It shows that NLS_LANGUAGE is FRENCH and NLS_TERRITORY is FRANCE. When I select from a column containing dates , the months are in French. sysdate also gives the month in french 3. Same behaviour with nls_lang=French_France.WE8MSWIN1252 and nls_lang=nls_lang=French_France.UTF8 (although this is an incorrect specification since there are no utf8 windows clients ) 4. Similarly when I specify nls_lang=ENGLISH_INDIA.WE8MSWIN1252 my queries pick up the correct local currency symbol. and nls_language and nls_territory values in nls_session_parameters are correct. 5. Alert log doesn't show any errors. My database character set is AL32UTF8 , did not specify an nchar characterset while creating the database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ANSI join syntax and Oracle 8i
Does anyone know if the ANSI join syntax (LEFT OUTER JOIN, RIGHT OUTER JOIN, instead of (+) =, etc.) was backported to 8i? Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ANSI join syntax and Oracle 8i
Sunday, December 21, 2003, 7:14:27 PM, Grant Allen ([EMAIL PROTECTED]) wrote: GA Does anyone know if the ANSI join syntax (LEFT OUTER JOIN, RIGHT OUTER JOIN, instead of (+) =, GA etc.) was backported to 8i? No, it was not. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ANSI join syntax and Oracle 8i
-Original Message- From: Jonathan Gennick [mailto:[EMAIL PROTECTED] Sent: Monday, 22 December 2003 11:59 To: Multiple recipients of list ORACLE-L Subject: Re: ANSI join syntax and Oracle 8i Sunday, December 21, 2003, 7:14:27 PM, Grant Allen ([EMAIL PROTECTED]) wrote: GA Does anyone know if the ANSI join syntax (LEFT OUTER JOIN, RIGHT OUTER JOIN, instead of (+) =, GA etc.) was backported to 8i? No, it was not. Best regards, Thanks Jonathan - I had a feeling that was the case, just making sure. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Upgrading to Oracle 9.2.0.4 - Any pitfalls?
I have said it on this list before, and I will say it again. With Oracle, quality ends with in 4. 7.3.4 8.1.7.4 9.2.0.4 Oracle v9.2.0.4 is fairly stable. I have had to apply only 1, one-off patch related to having 1000's of partitions. You may also want to add the following to your init.ora to prevent a few known bug's serial_reuse = disable event = 10235 trace name context forever, level 2 Jones, Richard O. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] richard.jones.1@cc: aramco.com Subject: Upgrading to Oracle 9.2.0.4 - Any pitfalls? Sent by: [EMAIL PROTECTED] .com 12/21/2003 09:29 PM Please respond to ORACLE-L Hi, Our main production database was upgraded to Oracle 9.2.0.3 (64 bit) at the end of September 2003. Platform Solaris 64bit 5.8. Since then the database has hanged and had to be manually shutdown by killing processes and re-started: - (1) The first one involved the production of numerous: ORA-04031: unable to allocate 26168 bytes of shared memory (shared pool,unknown object,sga heap(1,0),session param values) , errors when users were logging and was linked by Oracle Support with bug number 2921201 (2) Secondly, the database raised an ORA-600 to the alert file: ORA-00600: internal error code, arguments: [510], [0x380068B30], [shared pool], [], [], [], [], [] , followed by numerous messages: PMON failed to acquire latch, see PMON dump ? (3) Thirdly, an: ORA-04031: unable to allocate 16384 bytes of shared memory (shared pool,unknown object,sga heap(1,0),trace buffer) was raised apparently caused by an Oracle background processes dieing unexpectedly. Should I upgrade to 9.2.0.4? None of the above problems seem to be fixed in 9.2.0.4!!! Our database is a hybrid between OLTP and Decision-Support with a relatively light load. Anyone out there with an unstable 9i database (we were more stable under 8.1.7)? Am I alone?? Many Thanks Richard Jones, DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Upgrading to Oracle 9.2.0.4 - Any pitfalls?
At lease 9.2.0.5 will be released by oracle. I have seen some note talking about 9.2.0.5 patchset. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 22, 2003 12:49 PM I have said it on this list before, and I will say it again. With Oracle, quality ends with in 4. 7.3.4 8.1.7.4 9.2.0.4 Oracle v9.2.0.4 is fairly stable. I have had to apply only 1, one-off patch related to having 1000's of partitions. You may also want to add the following to your init.ora to prevent a few known bug's serial_reuse = disable event = 10235 trace name context forever, level 2 Jones, Richard O. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] richard.jones.1@cc: aramco.com Subject: Upgrading to Oracle 9.2.0.4 - Any pitfalls? Sent by: [EMAIL PROTECTED] .com 12/21/2003 09:29 PM Please respond to ORACLE-L Hi, Our main production database was upgraded to Oracle 9.2.0.3 (64 bit) at the end of September 2003. Platform Solaris 64bit 5.8. Since then the database has hanged and had to be manually shutdown by killing processes and re-started: - (1) The first one involved the production of numerous: ORA-04031: unable to allocate 26168 bytes of shared memory (shared pool,unknown object,sga heap(1,0),session param values) , errors when users were logging and was linked by Oracle Support with bug number 2921201 (2) Secondly, the database raised an ORA-600 to the alert file: ORA-00600: internal error code, arguments: [510], [0x380068B30], [shared pool], [], [], [], [], [] , followed by numerous messages: PMON failed to acquire latch, see PMON dump ? (3) Thirdly, an: ORA-04031: unable to allocate 16384 bytes of shared memory (shared pool,unknown object,sga heap(1,0),trace buffer) was raised apparently caused by an Oracle background processes dieing unexpectedly. Should I upgrade to 9.2.0.4? None of the above problems seem to be fixed in 9.2.0.4!!! Our database is a hybrid between OLTP and Decision-Support with a relatively light load. Anyone out there with an unstable 9i database (we were more stable under 8.1.7)? Am I alone?? Many Thanks Richard Jones, DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San
Re: ANSI join syntax and Oracle 8i
I don't, but perhaps Lex does? He's crazy about that Join stuff and even has a whole one-day class on mathematical methods in SQL. Also, he has written a book on SQL, that still sells well - but it's in Dutch, so you'd have to learn that language first :). Lex - welcome to the Oracle-L list :). I hope you can help Grant with his question? Best regards, Mogens Grant Allen wrote: Does anyone know if the ANSI join syntax (LEFT OUTER JOIN, RIGHT OUTER JOIN, instead of (+) =, etc.) was backported to 8i? Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).