RE: Hotsos' Classes
Venu, I've taken both PD101 and OP101 and I can thoroughly recommend both of them. The sequence of those two is irrelevant in my opinion. If you're looking to improve your tuning skills and your understanding of Oracle performance issues I would suggest the OP101. It has a very good balance of lectures and hands-on, brain-heating exercises. You will probably scratch your head when it comes to the exercises but they really drive home what the lecturer has been talking about. The exercises take at least 50% of the time but of course I don't know of the course will develop since the first beta class. (The correct URL for the OP101 is http://www.hotsos.com/courses/OP101.php). Gudmundur > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Potluri, Venu (CT Appl Suppt) > Sent: 6. janúar 2004 19:24 > To: Multiple recipients of list ORACLE-L > Subject: Hotsos' Classes > > > Is there a proper sequence of classes to take, among those > offered by Hotsos? While I do use Wait events to monitor & > "tune" my Oracle Financials databases, I need more training > in Performance tuning. I am just dipping my toes into the > world of Oracle Performance Tuning. I am reading Cary's book > and I have used Ixora's treasure of information, quite a bit > in the past. > > I see there are a number of classes now as opposed to a > clinic in the past. > > Performance Diagnosis 101 > SQL Optimization 101 > Hotsos Symposium 2004 > Steve Adams Seminar > > While I would love to take all of them, time & work schedule > permitting, I wouldn't want to waste time either if any of > the subject matter goes above my head and I spend time > scratching my head. God knows I might even find SQL Tuning > class useful to brush up little that I know. Would the Hotsos > Symposium be not suitable for poeple like myself who haven't > taken the Performance Diagnostics 101 class and aren't well > versed with Performance Tuning? What is expected of the > audience in terms of prior knowledge? Mind you, I am not an > expert like most of you guys. Haven't written a book or even a paper! > > Venu Potluri > Oracle Financials DBA > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Potluri, Venu (CT Appl Suppt) > 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: Gudmundur Bjarni Josepsson 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: Plan stability
rom). You > may also send > >> the HELP command for other information (like subscribing). > >> > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Wartiak Rastislav > 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: Gudmundur Bjarni Josepsson 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: Plan stability
What is complicated about stored outlines? If you don't like those you can always go back to the RBO. Gudmundur > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Wartiak Rastislav > Sent: 2. desember 2003 08:44 > To: Multiple recipients of list ORACLE-L > Subject: Plan stability > > > Hi, > > my question is about the same, but more general. How can i > force Oracle to use my prefered way of explain plan and not > use CBO's. I mean, apart from stored outlines, it somehow > seems to complicated. I would like to say what order and join > types it should use. But, try as I might, I many times cannot > force Oracle to use my way, even though I know it is > possible, for I saw this kind of explain plan for that > specific query.. > > I tried to use hints like ordered and use_hj etc. Can someone > give some examples of full set of hints for some simple queries? > > Thx, > rw > > > Hi, list friends: > > We are using partition to archive history data in our > production > > OLTP database. We get great performance gains(Far less disk > io), but > > we also hit performance trouble sometimes. So I am here ask > for your > > experience. > > > > We used local index on all partitioned tables.We add/drop > > partition monthly to archive the history data. > > > > But the trouble is, when add/drop partition is being > done on the > > partitioned table, CBO sometimes changed SQL execution path.We > > implemented partition 2 monthes ago, and in the first time, > add/drop > > partition went on quite smoothly, but in the second time we > add/drop > > partition, two SQL (just TWO SQL) get bad execution path and server > > load rushed to 10 times(from 2 to 20 in uptime), all > waiting for latch > > free event. It severely affected our application. We are an online > > system and we do not have scheduled time every month so we have to > > add/drop partition while db is still running. > > > > So, with system still up and running, how do you add/drop > > partition without changing the SQL execution path? We do > not have the > > time to reanalyze/dbms_stats the tables ,analyze takes hours and if > > SQL execution path changed, during these time, system is nearly > > unusable. > > > > I tried to import old > statistics(dbms_stats.import_table_stats), > > but did not fix the problem. > > So, can you share your experience on managing partitioned table? > > > > Regards > > > > Zhu Chao > > www.cnoug.org > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Wartiak Rastislav > 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: Gudmundur Bjarni Josepsson 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: Database just stops
Title: Message This probably sounds like Oracle Support but I'd start by patching to 8.1.7.4.1. Regards, Gudmundur -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Smith, Ron L.Sent: 14. október 2003 20:14To: Multiple recipients of list ORACLE-LSubject: Database just stops I have an Oracle 8.1.7.0 database running on an MS2000 server. A few times a day the database just stops running for no reason. There are no messages in the alert or trace logs. Nothing in the Event logs. It just stops. When I restart the database it goes through crash recovery but comes up fine. Anyone have any ideas? Thanks! Ron Smith
RE: Upgrade from 8.1.7.3 to 8.1.7.4
Patchset 2376472 Regards, Gudmundur > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Oracle DBA > Sent: 25. september 2003 21:00 > To: Multiple recipients of list ORACLE-L > Subject: Upgrade from 8.1.7.3 to 8.1.7.4 > > > Hi List, > > We have 8.1.7.3 database and neede to upgrade to > 8.1.7.4 > > I couldn't find out the patch to upgrade from 8.1.7.3 > to 8.1.7.4? Any help would be really appreciated. > > TIA > > Thanks > Sami > > > __ > Do you Yahoo!? > The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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: Gudmundur Bjarni Josepsson 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: any else try trace analyzer?
It's an improvement over tkprof but still I think it doesn't come close to the Hotsos Profiler. Gudmundur > Looks to be pretty new. I think it came from the Apps team. > Its not even in Kytes new book. > > you can get it off of metalink. It gives you alot more info > than tkprof when teamed with a 10046 trace. > > any articles on this yet? There is some data in it, I cant > quite follow? > > -- > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: Is Cary's new book shipping now?
So have I and to me it sounded pretty much like "The hills are alive with the sound of music" which is pretty much what I imagine Cary likes to sing. Gudmundur > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Mogens Nørgaard > Sent: 17. september 2003 08:50 > To: Multiple recipients of list ORACLE-L > Subject: Re: Is Cary's new book shipping now? > > > Lies, all lies. I've heard myself snoring. > > Pete Sharman wrote: > > >I can guarantee that won't happen, since Cary's singing is > pretty much akin > >to Mogens's snoring! :) > > > >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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: Online Document for Windows XP Home edition Severity 3
Title: Message Try copying the contents of the CD to a directory on your hard drive. Search for all instances of symcjit.dll in that directory and below and rename them to symcjit.dll.old. Then run setup from the directory on your hard drive. Gudmundur -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sinardy XingSent: 21. ágúst 2003 15:01To: Multiple recipients of list ORACLE-LSubject: Online Document for Windows XP Home edition Severity 3 Hi all, I have new notebook, I want to install Oracle Doc 8.1.7, but Oracle fail to run when I click Install/Deinstall button Some said XP home edition cannot install Oracle, is this because Sun demand Ms to remove the JVM? Can someone help me please.. Thanks Sinardy
RE: cursor_sharing in 8.1.7.4 - good or bad
Title: Message I know of a site that has been using cursor_sharing=force on 8.1.7 for over two years now with no noticeable side-effects (except that many of the programmers still think it's okay to use literals). Gudmundur Does anyone have any experience using cursor_sharing in 8.1.7.4? I feel I need to use it due to literal SQL statements being used. We have had misc 4031 errors off and on and I feel this is my last hope. I have a very busy OPFS server (HP-UX). I did try using cursor_sharing in 8.1.7.2, and I remember incorrect sorting and other unexpected results happening. Thanks for any input. John John Fedock "K" Line America, Inc. www.kline.com * [EMAIL PROTECTED]
RE: 9i-OCP Question
Title: Message The silliest questions I remember seeing in an OCP exam were the questions in the Oracle8 Networking exam which asked about the sequence of dialog boxes in the Network Configuration Assistant! I took the 8i OCP upgrade exam this weekend. I was amazed at one question. It was asking about the OUI and installing third party software. Now I've been an Oracle DBA for many years, and I would have thought Oracle would be more concerned about the Oracle database and the way it works rather then third party software, but apparently that is an important enough piece of information to Oracle Education to make it into a 45 question exam.
RE: 9i then 8i Installs
FWIW, I installed 9.2.0 then 8.1.7 and then 8.0.5 on Windows without a problem. Gudmundur > I got an odd request today to install 8.1.7 on an existing > server which is running 9.2 (Windows 2000). Has anyone > successfully been able to install Oracle 8.1.7 on the same > Windows Server that already has 9.2 running? I know that if > you install 8.1.7 then 9.2 both in different homes it will > work, but I have never seen it work where 9.2 was installed > first. I have not been able to locate a test box yet and was > wondering if it is possible and if so if there are any > pitfalls I should watchout for, other then the standard > Windows stuff > > Thanks In advance, > Jay > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jay > 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: Gudmundur Bjarni Josepsson 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: Oracle to MSSQL conversion?
Yep, and they use the same definition of an hour as Oracle did with the Oracle Applications One-Hour Install :) > Hmm, must be a one hour course then ;-) > > On Thursday 31 July 2003 12:34, you wrote: > > I know Microsoft is offering a new course called 'Microsoft > SQL Server > > 2000 for Experienced Database Professionals'. It is aimed at DBAs > > with experience with Oracle, DB2, Sybase etc. who want to know more > > about SQL Server. > > > > You can read more about this course at > > http://www.microsoft.com/traincert/syllabi/2723afinal.asp. > > > > Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: Oracle to MSSQL conversion?
I know Microsoft is offering a new course called 'Microsoft SQL Server 2000 for Experienced Database Professionals'. It is aimed at DBAs with experience with Oracle, DB2, Sybase etc. who want to know more about SQL Server. You can read more about this course at http://www.microsoft.com/traincert/syllabi/2723afinal.asp. Gudmundur > Hello, > > There is alot of talk about multi-skilling/reskilling going > on here at my company. We use Oracle and MSSQL dbs. > I have been wondering if anyone is aware of a resource that > shows the oracle programming technique and what the > corresponding MSSQL programming technique is. ie > Oracle defines variable : MSSQL defines variable > Oracle cursor looks like this : MSSQL cursor looks like this. > Oracle uses rollbacks: MSSQL uses "MSSQL rollbacks" > etc > Hope you all understand what I mean. > > TIA > Denham Eva > Oracle DBA > Linux like TeePee... No Windows, No Gates and Apache inside! > > > __ > ___ > This e-mail message has been scanned for Viruses and Content > and cleared > by MailMarshal > > For more information please visit www.marshalsoftware.com > __ > ___ > > ## > ### > Note: > This message is for the named person's use only. It may > contain confidential, proprietary or legally privileged > information. No confidentiality or privilege is waived or > lost by any mistransmission. If you receive this message in > error, please immediately delete it and all copies of it from > your system, destroy any hard copies of it and notify the > sender. You must not, directly or indirectly, use, disclose, > distribute, print, or copy any part of this message if you > are not the intended recipient. TFMC and any of its > subsidiaries each reserve the right to monitor all e-mail > communications through its networks. > > Any views expressed in this message are those of the > individual sender, except where the message states otherwise > and the sender is authorized to state them to be the views of > any such entity. > > Thank You. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Denham Eva > 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: Gudmundur Bjarni Josepsson 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: Any German here ? Character set
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Tanel Poder > Sent: 30. júlí 2003 18:05 > To: Multiple recipients of list ORACLE-L > Subject: Re: Any German here ? Character set > > > Any German here ? Character set> I'd recommend WE8ISO8859P15 > (I think that's > it) ... the difference is Euro support! > > Yeah, and it has the Õ letter, which I believe is only used > by Estonians ;) > > Tanel. > > > -- > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: 9i-OCP Question
Roy, I think you've got this backwards. To preserve the groups you need to preserve the members and thus you would multiplex the members. If you multiplex the 4 members of the 2 groups over 4 disks you will minimize the risk of failure. If you lose one disk you still have three members left in each group so you can have up to 3 disks fail without the instance stopping. With 2 groups, if you put all the members of a group on a single disk and you lose that disk you have lost the whole group and the instance will fail instantly or at the next log switch (depending on whether it was the current group or not). Gudmundur > I thought you need to preserve the groups, not (necessarily) > the members. > > If you have each group on its own disk then if one disk goes, > you've got a complete set of logs on the other. Or am I not > thinking about this correctly? > > Cheers, > > -Roy > > Roy Pardee > Programmer/Analyst/DBA > SWFPAC Lockheed Martin IT > Extension 8487 > > -Original Message- > Sent: Wednesday, July 30, 2003 11:10 AM > To: Multiple recipients of list ORACLE-L > > > Answe is 4 disks . to keep each member on different disks . > > -ak > > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, July 30, 2003 10:19 AM > > > > Hi all, > > > > What is the correct answer for this? > > > > Q> If you have 2 redo log groups with 4 members each, how > many disks > > Q> does > > Oracle recommend > >to keep the redo log files? > > > > 1. 8 > > 2. 2 > > 3. 1 > > 4. 4 > > > > Which is the correct answer. > > > > TIA > > Senthil > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Senthil Kumar > > 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: AK > 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: Pardee, Roy E > 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: Gudmundur Bjarni Josepsson 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: 8.1.7 instance on Solaris periodically goes sluggish, then hangs...
Paul, Make sure you're on the lastest 8.1.7.4 patch level. Learn about 10046 extended SQL tracing. Then, arrange for one or two of those users who have been complaining to call you as soon as they notice something fishy and turn on the tracing. This will show you in more detail than you might care about what is causing the wait. TOAD and Spotlight are useless in these circumstances. Gudmundur > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Paul Vincent > Sent: 28. júlí 2003 13:40 > To: Multiple recipients of list ORACLE-L > Subject: 8.1.7 instance on Solaris periodically goes > sluggish, then hangs... > > > Hi, > > rather vague, this one, I'm afraid, but we're stumped for ideas. > > We have an Oracle 8.1.7 instance on a Sun Solaris setup, > which we're currently testing prior to going live. Every so > often - 2 or 3 times a week - the users phone to say the > application has stopped responding. They're waiting several > minutes with no response. We find we can usually fire up one > or two tuning apps, such as TOAD or Quest's Spotlight, but > within a few minutes, these also stop responding. By this > time, even trying to fire up a SQL*Plus session from my PC > just hangs and hangs, without the login ever completing. We > always end up having to get the sysadmin to abort-shutdown > Oracle and then restart it. After which everything's fine - > until the next time. > > I've checked the PROCESSES parameter, and this is set to 150 > - way above the maximum number of connections we've seen > (around 40 or so). Likewise SESSIONS and TRANSACTIONS > parameters seem generously adequate. The sysadmin says the > server itself doesn't seem to be having any problems. He can > log in and run UNIX commands with no apparent performance problems. > > Any ideas at all would be very welcome! > > Paul Vincent > Oracle DBA > University of Central England > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Paul Vincent > 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: Gudmundur Bjarni Josepsson 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: Timestamps in trace files
Daniel, Perhaps someone else can explain this better but the documentation I've got on this says that the Oracle kernel emits timestamps when a long time has elapsed since the last line was emitted to the trace file. Long time is defined as tens of seconds. Gudmundur > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Daniel Fink > Sent: 22. júlí 2003 21:19 > To: Multiple recipients of list ORACLE-L > Subject: Timestamps in trace files > > > I was perusing a 10046 trace file and I noticed that > timestamps are written to the trace file. Sometimes they were > very regular (3 minutes apart give or take 30 seconds) while > other times they were hours apart. I have noticed that two > timestamps are never written without any intervening > activity. Anyone have any idea on the reasoning behind the > timestamps and the 'triggering event'? > > Daniel > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: SHOW ERRORS not working
Have you tried 'show errors procedure blabla'? Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: tuning : file number translation table
This may sound like one of those scratched old 12" LPs, but have you done your 10046 trace on the sessions that take a long time? Gudmundur Þessi póstur var sendur með vefpósti mi, http://www.mi.is -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: enterprise manager
Check (in Control Panel) if your OMS service is running. Gudmundur > hi > i run ora8 on w2000 server. > my problem is i can ping my database mydb without problems > i can login with sqlplus as sys and it works fine > but if i start the enterprise manager console and try to login as sys > a error occours and means please check the management server status and > settings. > as managementserver i select mydb. > what ican be the problem? > thx > martin Þessi póstur var sendur með vefpósti mi, http://www.mi.is -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: should you seperate indexes from tables in seperate datafiles?
> It's hot here. I wish I was at the beach and I feel like an ant. Hmmm. > During an indexed query on a single table the index will be > accessed, then the table, then the index,then the table, > then the index,then the table then the index,then the table. Assuming you get 4 rows returned :) > If the index and the table are on the same disk then a lot of > time will be taken up by head seek movement. > If they are on the different disks then the "index" heads can > locate their data and stay there - and the "data" heads can > locate their data and stay there. Less head movement, less wasted time. I would understand this if I had one index and one table. On a busy system with many users wouldn't the heads move, anyway, to serve queries that used other indexes and tables? Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: Sparky auth file
This was solved offline by examining the setup at one of my customers' site which has the same configuration of VMS, Oracle and Perl as Barb listed. Barb changed the setting of user_dump_dest to point to the actual directory that was defined in the hotsos.auth file. For some reason the logical was not resolved correctly. I am not proficient enough in VMS to explain that behaviour further. To save any future users of Sparky and VMS a few minutes of frustration I'd like to point out that you must remember to quit your session before Sparky can pull the trace file over to your PC. VMS does not release the file lock on the trace file even if you stop tracing. Gudmundur > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Barbara Baker > Sent: 11. júlí 2003 23:35 > To: Multiple recipients of list ORACLE-L > Subject: Sparky auth file > > > Ok, this is a REAL reach. > But does anyone out there know how to specify the dump > directory in the auth file for sparky > ... wait > ... I'm not there yet > on an OpenVMS system? > > OpenVMS 7.2-1 > Oracle 8.1.7.4 > Perl 5.6.1 > > The background dump desitnation from v$parameter is > ORA_DUMP. The system logical ORA_DUMP equates to > disk$dbtest11:[db_amdev.trace]. Sparky wants to append the > trace name file to the end of this. I've tried both > ORA_DUMP: and disk$dbtest11:[db_amdev.trace] in the aut file. > They don't work. > > if I use diskname: > > Authorized directory 'disk$dbtest11:[DB_AMDEV.TRACE]': > 16 of 16 '*.trc' files are readable > Fri Jul 11 16:20:48 2003 REQ 10.39.8.253 > version > Fri Jul 11 16:20:48 2003 ACK 10.39.8.253 > 0 3.04 > Fri Jul 11 16:21:30 2003 REQ 10.39.8.253 > trcname 'ORA_DUMP', '20c02d0a', 'AMDEV', '16' > Fri Jul 11 16:21:30 2003 ACK 10.39.8.253 > 1 not authorized to > read 'ORA_DUMP' (trcfiled.pl v3.04 line 536) > > if I use ORA_DUMP > > Fri Jul 11 16:18:34 2003 INFO > spid('[.ORA_DUMP]drax11_amdev_fg_oracle_016.trc')='-1' > Fri Jul 11 16:18:34 2003 WSVR > can't read '[.ORA_DUMP]drax11_amdev_fg_oracle_017.trc' > (no such file or directory) > > I get the error message "trace file server daemon has > denied your request. Check the trcfiled logfile on > 'DRAX11' (ip) at port 2297 for details. > > I'd be most grateful for any ideas. > > Thanks!! > Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: any script to parse alert log ?!
> I need a parse alert log and mail me if there is any error. I know Mogens (pronounced moans) and the guys at Miracle are working on GAPALPART (Generic All-Powerful Alert Log Parser And Reporting Tool). That could be something that you could use. I also know of a tool called MONO which is written in Perl and is pretty cool. Gudmundur Þessi póstur var sendur með vefpósti mi, http://www.mi.is -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: Oracle DBA 9i Books ever needed.
> in the Hogwarts school of Oracle Wizardry > Cary Dumbledore is probably the headmaster Yes, and only because he looks very much like him. > who will have the role of Lord Voldemort? There really is only one possible answer to this but I won't say it public :-) Regards, Harry Þessi póstur var sendur með vefpósti mi, http://www.mi.is -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: Raid 0+1 vs. mirrored pairs
Separating tables from indexes is one of those mythical things. I agree. It is not given that separating those two will have much impact on performance. However, as you point out yourself it is dependent on the amount of IO. I did say it was nice to be able to separate different database objects, not that you should :) Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: Redo Copy Latch contention ??
Question : How can I determine if this redo copy latch is causing the performance issues , guess that is my main question before altering some hidden parameter in init.ora. Do a 10046 trace and see if you have any waits on this latch. I'll run the risk of being sued for copyright infringement and say that you can't extrapolate detail from an aggregate and aggregates are what you get from the V$ views. Redo copy latch contention might not be a problem for 99% of your users but it might be a huge problem for the other 1% of your users. However, you have no way of figuring out which users are suffering from this by looking at V$ views. And you can't even tell if redo latch contention is a problem even if your ratio is screwed. I'm willing to bet you my autographed Steve Adams' book that you will not fix your redo latch contention by tweaking an init.ora parameter (unless it's set _redo_latch_ratio=0). Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: Raid 0+1 vs. mirrored pairs
RAID 0+1 and RAID 1+0 provide similar performance but RAID 1+0 has the advantage of offering more redundancy/availability. If you take your sys admin's advice and go with 2 x 3 disks in a 0+1 config and you lose one disk then you lose the other two spindles in that stripe as well. That's half of your I/O capacity gone. With RAID 1+0 the other two spindles will still be available when one disk fails in a stripe. I think it is useful to be able to split your data between different physical disks. Apart from the fact that redo and archive logs should never reside on the same volume then it can make a big difference being able to keep your data tablespaces from your indexes from your rollback from your redo. And now I have stated the bleeding obvious. BAARF. Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: Oracle DBA 9i Books ever needed.
> what would happen if Hogwarts taught Oracle Tuning using > wands & spells ;) Isn't that how Oracle Education does it? Alomahorabuffercachehitratio! Gudmundur Þessi póstur var sendur með vefpósti mi, http://www.mi.is -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: fine grained access
> What our security officer wants is that he can see > who changed something in those tables Sounds more like auditing than FGAC. Gudmundur Þessi póstur var sendur með vefpósti mi, http://www.mi.is -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: Automate an update
Joshua, To update existing rows you could do something like: update x set window_open = 'Y' where to_char (time_field, 'hh24:mi:ss') between '08:00:00' and '16:00:00'; Similar for window_open = 'N'. Create a trigger to deal with future inserts. Gudmundur Þessi póstur var sendur með vefpósti mi, http://www.mi.is -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: 9i OCP Details
> If you want real advanced courses go with [...] what Jonathan Lewis > or guys at his level provide. I have to agree on this. I've had the good fortune to sit in on Lewis's 'Optimising Oracle' and Cary Millsap's 'Hotsos Clinic 101' and no course I ever took from Oracle Education comes close to what these guys offer (and I've taken quite a few). Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: Compare Schema with data
Is any body know any tools for comparing two schema for only data comparison & create script for the result Isn't Change Mangement Pack in OEM able to do this? Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: Query Tuning Question
What could be the cause of this wait? At the risk of asking the bleeding obvious, have you tried doing a 10046 trace on the query? Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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: Information out of the Explain Plan?
--NextPartbf015f676fdbdf85872906f35cec485d Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable Mogens N=F8rgaar wrote: > Martin Berg's method of "Throw-away of rows" Where can this be found? Gudmundur =DEessi p=F3stur var sendur me=F0 vefp=F3sti mi, http://www.mi.is --NextPartbf015f676fdbdf85872906f35cec485d Content-Type: text/PLAIN; name="[unknown].txt" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="[unknown].txt" Q2hlY2sgb3V0IHRoZSBkb2N1bWVudGF0aW9uIG9uIHRoaXMuIEFub3RoZXIgdGhpbmcgeW91IG1p Z2h0IHdhbnQgdG8gDQpzdHVkeSBhZnRlcndhcmRzIGlzIE1hcnRpbiBCZXJnJ3MgbWV0aG9kIG9m ICJUaHJvdy1hd2F5IG9mIHJvd3MiIHRoYXQgaGUgDQppbnZlbnRlZCB3aGlsZSB3b3JraW5nIGZv ciBtZSBpbiBQcmVtaXVtIFNlcnZpY2VzIGluIE9yYWNsZS4NCg0KTW9nZW5zDQoNCldhbGVlZCBI YWdnYWd5IHdyb3RlOg0KDQo+SGVsbG8gQWxsLA0KPg0KPkNhbiBhbnlvbmUgaGVscCBtZSB0byBn ZXQgZGV0YWlscyBpbmZvcm1hdGlvbiB0byB1bmRlcnN0YW5kIHdoYXQgaXMgbWVhbiBvZg0KPiJj b3N0L2NhcmQvYnl0ZXMiIGluZm9ybWF0aW9uIG91dCBvZiB0aGUgRXhwbGFpbiBQbGFuPw0KPg0K PlJlZ2FyZHMsDQo+V2FsZWVkIEhhZ2dhZ3kNCj4NCj4NCj4gIA0KPg0KDQoNCi0tIA0KUGxlYXNl IHNlZSB0aGUgb2ZmaWNpYWwgT1JBQ0xFLUwgRkFROiBodHRwOi8vd3d3Lm9yYWZhcS5uZXQNCi0t IA0KQXV0aG9yOiA9P0lTTy04ODU5LTE/UT9Nb2dlbnNfTj1GOHJnYWFyZD89DQogIElORVQ6IG1s bkBtaXJhY2xlYXMuZGsNCg0KRmF0IENpdHkgTmV0d29yayBTZXJ2aWNlcyAgICAtLSA4NTgtNTM4 LTUwNTEgaHR0cDovL3d3dy5mYXRjaXR5LmNvbQ0KU2FuIERpZWdvLCBDYWxpZm9ybmlhICAgICAg ICAtLSBNYWlsaW5nIGxpc3QgYW5kIHdlYiBob3N0aW5nIHNlcnZpY2VzDQotLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0N ClRvIFJFTU9WRSB5b3Vyc2VsZiBmcm9tIHRoaXMgbWFpbGluZyBsaXN0LCBzZW5kIGFuIEUtTWFp bCBtZXNzYWdlDQp0bzogTGlzdEd1cnVAZmF0Y2l0eS5jb20gKG5vdGUgRVhBQ1Qgc3BlbGxpbmcg b2YgJ0xpc3RHdXJ1JykgYW5kIGluDQp0aGUgbWVzc2FnZSBCT0RZLCBpbmNsdWRlIGEgbGluZSBj b250YWluaW5nOiBVTlNVQiBPUkFDTEUtTA0KKG9yIHRoZSBuYW1lIG9mIG1haWxpbmcgbGlzdCB5 b3Ugd2FudCB0byBiZSByZW1vdmVkIGZyb20pLiAgWW91IG1heQ0KYWxzbyBzZW5kIHRoZSBIRUxQ IGNvbW1hbmQgZm9yIG90aGVyIGluZm9ybWF0aW9uIChsaWtlIHN1YnNjcmliaW5nKS4NCg0KDQo= --NextPartbf015f676fdbdf85872906f35cec485d-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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).