RE: Record breaking query
Title: RE: Record breaking query I have seen the time for wait_events in 8.1 do funny things when the system date was changed by ntp. Oracle assumes that end time is after start time for each wait event, if this is not the case due to the system clock being changed, you get a BIG number. Every time this happened to us, our firewall (which is the ntp server for all of our other machines) had been rebooted and we saw an ntp event in the system log file. However, we were never able to reproduce this manually. --Michael Brown Glen Raven, Inc./Info ServicesSenior Oracle DBA 1831 N. Park AvePhone: (336)586-1146 Glen Raven, NC 27217Fax: (336)586-1382 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni, RajendraSent: Friday, August 08, 2003 5:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Record breaking query Thanks Wolfgang, our retention time is 21600 seconds ... and this one bailed out in half the time ... Oh well ... we need to fix few more things .. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Wolfgang Breitling [mailto:[EMAIL PROTECTED]] Sent: Friday, August 08, 2003 5:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: Record breaking query I know what the message says. Do you believe everything you see printed? Or expressing is differently: how many error/diagnostics messages have you seen that are more misleading than helpful. At 01:24 PM 8/8/2003 -0800, you wrote: >but message says it is in seconds ... anf yes it is 92 ... > >Thanks >Raj > > >Rajendra dot Jamadagni at nospamespn dot com >All Views expressed in this email are strictly personal. >QOTD: Any clod can have facts, having an opinion is an art ! > >-Original Message- >From: Wolfgang Breitling >[<mailto:[EMAIL PROTECTED]>mailto:[EMAIL PROTECTED]] >Sent: Friday, August 08, 2003 4:04 PM >To: Multiple recipients of list ORACLE-L >Subject: RE: Record breaking query > >Is that an Oracle 9 system and the time is in microseconds rather than >seconds? > >At 10:39 AM 8/8/2003 -0800, you wrote: > >Yeah, but think of the uptime! One helluva MTBF on that server... > > > >Rich > > > >Rich Jesse System/Database Administrator > >[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > > > >-Original Message- > >Sent: Friday, August 08, 2003 12:49 PM > >To: Multiple recipients of list ORACLE-L > > > > > >TICK : Fri Aug 8 09:06:03 2003 > >SEARCH in kdisti: tsn = 5, objd = 83525, rdba = 33588489 > >ORA-01555 caused by SQL statement below (Query Duration=1060347963 sec, > SCN: > >0x0011.05e003c2): > >TICK : Fri Aug 8 09:06:03 2003 > >SELECT VOBJID, VNAME, VTEXT, VLEN, VOWNER, VOWNERID, VAUDIT, VCOMMENT, > >VCNAME, PROPERTY, DEFER, FLAGS, OIDLEN, OIDCLAUSE, TYPEOWNER, > >TYPENAME, UNDERLEN, > UNDERCLAUSE FROM SYS.EXU8VEW WHERE VOWNERID > >!= :"SYS_B_0" ORDER BY VLEVEL, VOWNER, VOBJID > >according to this error message this query has been running for close to 33 > >years. appears to be a export running for 33 years. > >I am clusless > >Raj > >-- > >Please see the official ORACLE-L FAQ: > <http://www.orafaq.net>http://www.orafaq.net > >-- > >Author: Jesse, Rich > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services -- 858-538-5051 > <http://www.fatcity.com>http://www.fatcity.com > >San Diego, California -- Mailing list and web hosting services > >- > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). > >Wolfgang Breitling >Oracle7, 8, 8i, 9i OCP DBA >Centrex Consulting Corporation ><http://www.centrexcc.co
OT: OAUG Database SIG Elections
The Oracle Applications Users Group Database SIG will be holding elections for Vice Chairman and Secretary on September 14 at the OAUG conference in San Diego. If anyone is interested in being an officer, please go to our website for more information (http://datasig.oaug.org). -- Michael Brown Glen Raven, Inc./Info Services Chairman, OAUG DB SIG 1831 N. Park Ave Phone: (336)586-1146Glen Raven, NC 27217 Fax: (336)586-1382 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Brown 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: Hotsos Clinic 101 Feedback
I've taken it twice (one of the first public classes and again the when they started offering the reduced alumni rate), and stand by my quote on Hotsos's website. "If you have the time to take a class, take the Hotsos Clinic. It was the absolute best performance tuning resource that I have ever invested time in." Of course, I would change "tuning" to "optimization" since we are making tuning a dirty word. For those of you who were not at the Hotsos Symposium in Dallas, you missed a fantastic conference. You should make your plans to be in Las Vegas next year. I am not affiliated in any way with Hotsos, just am impressed by both the knowledge Cary and Jeff have and their ability to convey it to others. -- Michael Brown Glen Raven, Inc./Info Services Senior Oracle DBA 1831 N. Park Ave Phone: (336)586-1146Glen Raven, NC 27217 Fax: (336)586-1382 [EMAIL PROTECTED] -Original Message- Stefick Sent: Wednesday, March 26, 2003 2:09 PM To: Multiple recipients of list ORACLE-L I haven't taken it yet, but I am signed up for the Chicago Clinic on April 8-10Can't Wait! I've heard really good things about it. At 08:04 AM 3/26/03 -0800, you wrote: >Anybody take this course before. Any comments, good or bad. Thanks > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Tracy Rahmlow > 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). ** Scott Stefick Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick 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). BEGIN:VCARD VERSION:2.1 N:Brown;Michael FN:Michael L Brown (E-mail) ORG:Glen Raven;Information Services TITLE:Sr. Database Administrator TEL;WORK;VOICE:336-586-1146 TEL;PAGER;VOICE:336-222-3912 TEL;WORK;FAX:336-586-1172 ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;Information Services=0D=0A1831 N. Park Ave;Glen Raven;NC;27217;USA LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Information Services=0D=0A1831 N. Park Ave=0D=0AGlen Raven, NC 27217=0D=0AUS= A EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20011016T192723Z END:VCARD
RE: Oracle Licences Req on Intel Xeon CPU
2000 only shows 2 CPUs because it cannot take advantage hyperthreading. >From what I have read (Intel's website, some others), hyperthreading requires both BIOS and OS support to be utilized. Currently, XP and the newer Linux releases are all that I have seen that will take advantage of it. My research on this was fairly light since I was just after can Redhat Advanced Server support it, but I do remember seeing that W2K would not. -- Michael Brown Glen Raven, Inc./Info Services Senior Oracle DBA 1831 N. Park Ave Phone: (336)586-1146Glen Raven, NC 27217 Fax: (336)586-1382 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 26, 2003 3:44 AM To: Multiple recipients of list ORACLE-L Depending on the OS, Microsoft has different CPU counts. The Windows 2000 family counts each hyper thread as 1 CPU. In contrast, Windows XP and Windows 2003 Server count each CPU instead of each hyper thread. Thus, the task manager in Windows XP Professional show 4 CPU's (on a dual XEON CPU computer with hyper threading enabled) while Windows 2000 Professional only shows 2 CPU's in the task manager. Have Fun :) [EMAIL PROTECTED] wrote: >Hi all > >For those that are running or intending on running Oracle on >Intel's Xeon CPU, the following information may be of interest to you. > >The Xeon CPU has a feature called Hyper Threading with double the number >of registers. This feature when turned will present to the Operating >Systems an additional virtual CPU. As far as the O/S is concern, it >looks like there are _two_ CPUs. What does this mean to your software >licensing? > >Microsoft says that it is one CPU. What does Oracle say? > >Well, it depends on who you speak to and what day of the week it is. >Seriously, you will need to get some confirmation in writing from your >account manager the next time you purchase Oracle S/w for Intel's Xeon > >ta >tony > > _ / |Tony Jambu, Database&Web Consultant > /_ _/_ __ / |Wizard Consulting Pty Ltd > /(_)/ )(_/ \_/(///(/_)/_( |IOUG's Select Asia-Pacific Tech. Editor > \___/ |EMAIL: TJambu @ wizard.cx (REMOVE Spaces from email ) >|PHONE: +61-419-TJAMBU(852628) > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip 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). BEGIN:VCARD VERSION:2.1 N:Brown;Michael FN:Michael L Brown (E-mail) ORG:Glen Raven;Information Services TITLE:Sr. Database Administrator TEL;WORK;VOICE:336-586-1146 TEL;PAGER;VOICE:336-222-3912 TEL;WORK;FAX:336-586-1172 ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;Information Services=0D=0A1831 N. Park Ave;Glen Raven;NC;27217;USA LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Information Services=0D=0A1831 N. Park Ave=0D=0AGlen Raven, NC 27217=0D=0AUS= A EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20011016T192723Z END:VCARD
RE: HIT RATIO
What problem? Seriously, the buffer cache hit ratio is a pretty meaningless value (for details on why, see Cary Millsap's papers on www.hotsos.com). Are your users complaining? Are you seeing behavior on the system (disk contention, etc.) that makes you expect that your users will be complaining soon? -- Michael Brown Glen Raven, Inc./Info Services Senior Oracle DBA 1831 N. Park Ave Phone: (336)586-1146Glen Raven, NC 27217 Fax: (336)586-1382 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 19, 2002 2:05 PM To: Multiple recipients of list ORACLE-L Hi One of my database showing hit ratio low (=75% approx).I increased the parameters.After last reboot hit ratio was looking great.Last reboot was last week.I am wondering again this ratio is 73% approx. How to fix this problem except Init.ora prameter change? Thx -Seema _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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). BEGIN:VCARD VERSION:2.1 N:Brown;Michael FN:Michael L Brown (E-mail) ORG:Glen Raven;Information Services TITLE:Sr. Database Administrator TEL;WORK;VOICE:336-586-1146 TEL;PAGER;VOICE:336-222-3912 TEL;WORK;FAX:336-586-1172 ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;Information Services=0D=0A1831 N. Park Ave;Glen Raven;NC;27217;USA LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Information Services=0D=0A1831 N. Park Ave=0D=0AGlen Raven, NC 27217=0D=0AUS= A EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20011016T192723Z END:VCARD