RE: !!Please Read - Oracle-L is moving!!
Title: Message Thanks guys! From: Kevin Toepke [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:30 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Its easy to disable this "feature": Navigate to the Tools->Options menu Click the "Email Options" Button Uncheck the "Remove extra line breaks in plain text messages" checkbox Click Okay about 30 times and your're done! Kevin -Original Message-From: Lord David [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Bill The line breaks get removed from *incoming* mail, so I don't think it matters what your default new mail format is. I think its a new 'feature' in Outlook 2003 - I found this quote in the 'Whats new in Microsoft Office' in online help: - Extra line breaks automatically removed in messages Sometimes plain text messages that travel over the Internet acquire extra line breaks that make the message difficult to read. Outlook automatically removes the extra line breaks so it's easier to read the message. Ouch David LordSenior DBAIron Mountain (UK) LtdTelephone: 029 2054 4000Direct: 029 2054 4013Fax: 029 2069 2464Email: [EMAIL PROTECTED] -Original Message-From: Thater, William [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 13:24To: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! -Original Message-From: Lord David [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 3:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Tim Its something to do with outlook removing line breaks and thereby mangling the formatting of the command. In my Outlook, there is a message in the header of the mail saying something like 'Extra line breaks in this message were removed. To restore click here.' When I did click there and replied the subscription went through okay. What on earth lookout is doing removing line breaks I'm not sure. How does it decide which line breaks to remove? I couldn't find any way of stopping it doing this. well, it looks to me as if you're using HTML and/or Word for your email, and Outlook in it's infinite wisdom replaces line brakes with or whatever the hell Word uses. as to stopping it, i have no idea. -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] Yes, we have to divide up our time like that, between our politics and our equations. But to me our equations are far more important, for politics are only a matter of present concern. A mathematical equation stands forever. - Albert Einstein This email and its attachments are confidential under applicable law and are intended for use of the sender's addressee only, unless the sender expressly agrees otherwise, or unless a separate written agreement exists between Iron Mountain and a recipient company governing communications between the parties and any data that may be so transmitted. Transmission of email over the Internet is not a secure communications medium. If you are requesting or have requested the transmittal of personal data, as defined in applicable privacy laws, by means of email or in an attachment to email, you may wish to select a more secure alternate means of transmittal that better supports your obligations to protect such personal data.If the recipient of this message is not the recipient named above, and/or you have received this email in error, you must take no action based on the information in this email. You are hereby notified that any dissemination, misuse or copying or disclosure of this communication by a recipient who has received this message in error is strictly prohibited. If this message is received in error, please return this email to the sender and immediately highlight any error in transmittal. Thank you.*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** This e-mail and its attachments are intended for theauthor's addressee only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this e-mail and highlight the error. Please note that this e-mail has been created in theknowledge that Internet e-mail is n
RE: !!Please Read - Oracle-L is moving!!
I was trying to sign up this morning... The response was fast but I keep getting booted on the final confirmation email... The message I get is... Invalid number of parameters. Not sure why... Figured I'd wait and see if anyone else is having the same problem... Anyone else experience this? FYI... I've tried replying to the email... Copying the message text and sending a new email... And, even when you sign up through the web site, you still need to perform a final confirmation via email... Argh! I'm guessing it may be Outlook since I'm using a beta version of Outlook 2003... Tim From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 2:39 PMTo: Multiple recipients of list ORACLE-LSubject: Re: !!Please Read - Oracle-L is moving!! Well, I did check with them first to ensure the volume would be OK. It is running a bit slow. I'm not sure if it is just freelists.org, or a general internet slowdown. Sending mail from work to home it seems that it is taking much too long. Jared "Ron Thomas" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/22/2004 10:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: !!Please Read - Oracle-L is moving!!The list members must be really hammering their servers now. I've tried to sign up using both theweb and email methods and have yet to receive a conformation/response.I can see the headlines now, "oracle-l slashdots freelists.org";-)Ron ThomasHypercom, Inc[EMAIL PROTECTED]"The box said I needed to have windows 98 or better...So I installed linux." [EMAIL PROTECTED] m To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: !!Please Read - Oracle-L is moving!! .com 01/21/2004 11:49 PM Please respond to ORACLE-L Dear Oracle-L subscriber,Due to changing circumstances, the Oracle-L mailing list hasfound a new home.Fatcity.com has graciously hosted Oracle-L for several years, and Ithank Bruce Bergman for his hard work on our behalf, but the time hascome to move to a new host.Oracle-L will be hosted by freelists.org, effective immediately.In the past when this list has moved, I used a list of subscribers toautomatically subscribe people to the new address, thinking I wasproviding a service. To avoid dealing with irate users that forgot theyhad subscribed (where does their mail go?) and their attorneys (don'tcare to hear from them again ) this new list will be 100% opt in.What this means is that you will need to subscribe to the new address ifyou wish to remain on the Oracle-L mailing list.This email is being sent to you once individually, and will also appearin the regular Oracle-L traffic.After a period of time (2 weeks or so) [EMAIL PROTECTED] willbe shut down.At this time, I don't know for how long the Oracle-L archives atfatcity.com will be avail
RE: HOTSOS Conference
I'll be there... A get together would be great... Tim -Original Message- Sent: Monday, January 05, 2004 8:59 PM To: Multiple recipients of list ORACLE-L While perusing the HOTSOS site, I noticed that the deadline for the discounted registration for the HOTSOS conferences ends after tomorrow. If you're thinking of going, you may want to check it out. Along those same lines, how many listers will be there? We could get together on Tuesday evening for dinner/drinks if any are interested. Possibly some of you with Dallas connection can recommend a suitable location. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: Johnston, Tim 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: Looking for help.
tatement in the stored procedures? > > 3. The error ORA-04031 in this case, is it due to shared memory > > fragmentation? I suspect that the culprint is invalidations. How do > > invalidations cause shared memory fragmentation? > > > > I would appreciate if you can send me some pointers or suggestions. > > > > Thanks, > > KamYee > > > > -- > > 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). > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Stefan Jahnke > > 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: Yechiel Adar > 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). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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: Johnston, Tim 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: Opinions sought on possible TOAD replacement
Title: Message FYI... Golden is a query tool (and a damn good one)... In my opinion, it's what SQL Worksheet should be... Simple to use and fast... The PL/SQL editor from Benthic is separate tool called PLEdit... It's ok but not great... Like Golden it is quick and simple... But, if you are looking for advanced functionality then I would definitely go with another solution... I took a peek at PL/SQL Developer a few months ago and thought it was a nice tool... Especially for the price... That being said, I use PLEdit for my own use... I buy my own tools and don't do enough to justify the cost... Tim -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, October 16, 2003 3:29 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Opinions sought on possible TOAD replacement We do something similar here. Developers gets Golden (from Benthic). Which has a nice little PL/SQL Editor and SQL spreadsheet. DBAs get TOAD. Babette Turner-Underwood work: [EMAIL PROTECTED] home: [EMAIL PROTECTED] 954-3752 (Mon - Fri 7am - 3pm) -Original Message-From: Rich Gesler [mailto:[EMAIL PROTECTED] Sent: 2003-10-15 1:24 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Opinions sought on possible TOAD replacement You are correct in that it is very developer centric. As far, as hidden charms...I'd have to say the Reports capabilities. You can easily incorporate your DBA scripts into this little tool. Still not as good as TOAD (or even TORA) for a DBA but a nice, cheap addition to the arsenal. Download it and give it a try, Rich -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul VincentSent: Wednesday, October 15, 2003 11:59 AMTo: Multiple recipients of list ORACLE-LSubject: Opinions sought on possible TOAD replacement Management have been grumbling about the cost of TOAD Professional licenses, and have been "recommended" a cheaper product called PL/SQL Developer by Allround Automations (available from Inthink Corporation at $150 a pop). Now, I've been to the product website, and read up on all its features, and it basically looks like a nice enough product, but aimed squarely at PL/SQL developers, rather than including all the DBA-oriented goodies we find in TOAD. My first reaction is to respond by saying "fine, give it to the developers to replace their copies of TOAD, if they find it adequate for development, but it's not a DBA tool, so I'll keep my TOAD Xpert with DBA module, thanks very much!". But if anyone on the list has tried both products, I'd be interested to know what you think. Is it as usable as TOAD Professional for developers? Does it have hidden charms which would make it a suitable replacement for DBA use? How responsive are the product developers to requests for enhancements? Any input is very welcome! Paul Vincent DBA University of Central England
RE: Passed Net8 OCP Exam
Congrats! Now... What will you do with your sig line -Original Message- Sent: Thursday, October 16, 2003 3:24 PM To: Multiple recipients of list ORACLE-L I just passed the Net8 Administration OCP exam. This was my last exam, so I suppose I am now an OCP for Oracle8i. Thanks to everyone for their helpful tips. Some people said (or implied) that this is a very easy exam. I would dispute that. I found it just like the other exams, in that if you have quite a bit of on-the-job experience in the area, then it is easy. If not, you'll have to study more. In my case, - I don't like networking, and hate to drop everything to configure or debug someone's tnsnames.ora file. - Never had an Oracle networking class. - Our site has only needed local naming, so that is pretty much all my networking experience. Found all the questions related to local naming pretty easy. Never used Oracle Names, Connection Manager, MTS, Advanced Security. With the trend toward application servers with their connection pooling feature, I don't foresee us using any of those Oracle tools. I may need to use LDAP in the future, but that wasn't covered in the Oracle8i Net8 exam My goal was just to study and practice enough to practice the exam, and I accomplished the goal. Not a very lofty goal, but sometimes you do what you gotta do. Thanks everyone for the helpful suggestions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: Johnston, Tim 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 on Sun vs Tru64
According to the 9.2 admin guide for Solaris the limits on db block size are... Parameter Default Value Range of Values DB_BLOCK_SIZE 20482048 to 16384 (Linux, Solaris 32-bit) 2048 to 32768 (AIX, HP, Tru64, Solaris 64-bit) Page 1-22 @ http://download-east.oracle.com/docs/pdf/A97297_01.pdf But, the 8.1.7 admin guide for Solaris says... Parameter Default Value Range of Values DB_BLOCK_SIZE 20482KB - 16KB Page 1-24 @ http://download-east.oracle.com/docs/pdf/A85349_01.pdf Dennis, what version are you running? Tim -Original Message- Sent: Wednesday, October 15, 2003 5:44 PM To: Multiple recipients of list ORACLE-L Babu - I created a 32K block size database on Solaris. What is the issue? Jake - We are doing the same. Nothing big to report. In our case we saw this coming so we hadn't put any resources in the T64 in several years. The new Solaris system has newer technology, so it really screams. I had asked list members for suggestions on rapid data movement to reduce downtime. It turns out the new box can actually import much faster than the old box can export. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 15, 2003 11:39 AM To: Multiple recipients of list ORACLE-L We moved from a T64 (ES40 4 CPU) to a Sun (6800 2 blades 8 CPU) recently. There were no problems with the export/import of the 1/2 TB database. One big thing was that the max block size on Sun for 8174 is 16K. We had used 32K on T64. So we had to rethink our multi_block_read_counts, etc. FTS became kind of slower but I cant say it was due to this move. We were undertaking a big change that time anyway and we tuned the SQL to get a better performance. One another thing to keep in mind is are you going to change the underlying filesystem also - meaning are you planning to move from Compaq Storage Works to some other ? We did that (moved from StorageWorks to Hitachi) and took a performance beating initially. The problem was due to a misconfiguration on the Hitachi side and once the rectified it it has become acceptable. Still I dont see the IO rates the StorageWorks used to deliver.. :-( Babu - Original Message - To: Multiple <mailto:[EMAIL PROTECTED]> recipients of list ORACLE-L Sent: Wednesday, October 15, 2003 10:54 AM Our CIO is pushing a platform change from Tru64 to Sun. We are currently running a VLDB (~1.5 TB) on Tru64. Does anyone have feedback on the following: 1) Experiences with either/both, preferred platform? 2) Experiences with platform changes? (Time required for migration?) 3) Any other thoughts? Thanks for your feedback. I am just starting to research the issue so I am interested in any input. _ Do you Yahoo!? The <http://shopping.yahoo.com/?__yltc=s%3A15443%2Cd%3A22708228%2Cslk%3Atext %2Csec%3Amail> New Yahoo! Shopping - with improved product search -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: Johnston, Tim 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 Support Extension?
FYI... The support is only extended for "strategic platforms"... Microsoft Windows XP Microsoft Windows 2000 Linux x86 HP-UX PA-RISC IBM OS/390 (z/OS) Microsoft Windows 98 HP Tru64 UNIX HP Alpha OpenVMS Solaris Operating System (x86) IBM AIX-Based Systems 5L Fujitsu-Siemens BS2000/OSD Solaris Operating System (SPARC) Microsoft Windows NT for Intel -Original Message- Sent: Wednesday, October 15, 2003 11:15 AM To: Multiple recipients of list ORACLE-L Hi Brad, This one caught me off guard too. You are right in that it was *originally* 12/31/2003. However, check out Metalink Note 148054.1, dated 10/09/2003. The extension is noted there. Regards, Melanie -Original Message- Odland, Brad Sent: Wednesday, October 15, 2003 10:14 AM To: Multiple recipients of list ORACLE-L When did they annouce that? Wasn't the end of error correction 12/31/2003? Brad -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad 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: Melanie Caffrey 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: Johnston, Tim 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 Hi Ron... You need to poke it and find out what's it's doing... I'd start with the following Metalink notes... Note 175006.1 Note 215858.1 Note 61552.1 They cover diagnosing database hanging issues... SYSTEMSTATE AND HANGANALYZE DUMPS OH MY! Good luck... Tim -Original Message-From: Smith, Ron L. [mailto:[EMAIL PROTECTED]Sent: Tuesday, October 14, 2003 4:14 PMTo: 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: A quick note
So Lee... As an experienced Oracle guy, what are your thoughts about DB2? -Original Message- Sent: Wednesday, October 08, 2003 12:40 PM To: Multiple recipients of list ORACLE-L I suggest you buy your mushrooms from the supermarket like the rest of us instead of picking them in those strange fields my friend -Original Message- Sent: 08 October 2003 17:25 To: Multiple recipients of list ORACLE-L Hey good to see you back again Lee. The big change here is that all Oracle knowledge has been cyber-engineered into an automoton called Tanel Poder. Any query to the list is routed by a big fast connection into a huge server with hundreds of CPU's and unlimited memory An almost instantaneous reply is automatically generated , often complete with complex examples and code cuts to demonstrate the point. The best part is that is that the machine is programmed to exibit almost humanistic type responses (occasionally) John -Original Message- Robertson Lee - lerobe Sent: 08 October 2003 11:34 To: Multiple recipients of list ORACLE-L Hi everyone, I'm back in the land of the living after spending a year on a DB2 EEE project. I've just started working on a 9i RAC solution so the questions will soon be flooding in. I will be lucky if I can even remember to spell spqlusl , I mean sqlplus :-) Cheers Lee ** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe 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: Hallas, John, Tech Dev 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: Robertson Lee - lerobe 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: Johnston, Tim 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: Strange Request
Type oracle at the unix prompt... You should see the following in the alert log... Tue Oct 7 20:21:54 2003 Errors in file /opt/oracle/admin/PV418/bdump/pv418_ora_6629.trc: ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], [] See Note:33174.1 for more info... Tim -Original Message- Sent: Tuesday, October 07, 2003 9:14 PM To: Multiple recipients of list ORACLE-L Ok...strange request time. I want to test a script that I found on the DBA Village web site. It's supposed to capture some information whenever there's a DB error. Does anybody know how to trigger a 'benign' ORA-600 so I can test this functionality? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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: Johnston, Tim 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: Storage Frust....
S... People are listening... Someone will hear our plans... -Original Message- Sent: Friday, September 26, 2003 12:10 PM To: Multiple recipients of list ORACLE-L Tim, what are we going to do tomorrow night? Not the same thing as every night, try to take over the world? -- Mladen Gogala Oracle DBA > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Johnston, Tim > Sent: Friday, September 26, 2003 11:35 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Storage Frust > > > Thank you... The honor is gratefully accepted... Soon the > hordes of BAARF party member shall rule the world! Um... > Ok, maybe not rule the world... But at least we'll be loud! > > Tim > BAARF Party Member #44 > > -Original Message- > Sent: Wednesday, September 24, 2003 10:40 PM > To: Multiple recipients of list ORACLE-L > > > Well, Sir Tim - congratulations with your BAARF party > membership # 44. > The BAARF.zip file will be shipped in a second. > > Mogens > > Johnston, Tim wrote: > > >Hey... I'm jealous!!! BAARF! BAARF! BAARF! > > > >Tim > > > >-Original Message- > >Sent: Wednesday, September 24, 2003 7:30 PM > >To: Multiple recipients of list ORACLE-L > > > > > >Sir Visser, > > > >It would be my honour to enroll you in the BAARF party as > party member > ># > >43 if you like. > > > >Also, if you enroll, I'll send you the whole BAARF.zip file (33 K) > >which > >contains the story, the dialogues, and the song texts of the BAARF > >musical which we'll do at the Database Forum Gala Dinner on > Friday night. > > > >But only if you promise me to give me harsh critique in return! > > > >And that goes for all you other members (or possible members) of the > >BAARF Party, too. Except, of course, the ones going to the Database > >Forum. They'll have to wait. > > > >Mogens > > > >Piet de Visser wrote: > > > > > > > >>Group, > >> > >>After another run-in with Storage, > >>need to Vent Some frustrations: > >> > >>BAARF > >> > >>Thank you. > >> > >>While I'm at it, > >>let me add some other RAD ideas: > >> > >>Frustrated by vendors and manuals, > >>we were about to turn BAARF into: > >>battle against any Raw Filesystems > >>(Yes, Yes, I know, a raw-dev is not a FS). > >> > >>But, not wanting to thread on other ppls turf, we thought > >> > >>CCCP: > >>for Compulsory use of a Clustered Computing Platform, > >>whose mission should be to elimiate all usage of > >>Mulitple, In-duh-vidual, ORACLE_BASE/HOMEs > >>and to enforce the use of single-installed Oracle software > >>on Clustered file systems. > >> > >>And to stay in the same retro-atmosphere, we looked at: > >> > >>USSR: > >>for Usage of Single System Rollout: > >>to proclaim the use of sinle-installed ORACLE_BASE/HOMEs, > >>partly inspired by OpenSSI.org > >> > >>More ideas anyone ? > >> > >>Don't start me on: > >>the RAC party : Ridiculous Acronym Creators > >>followed by > >>the RAW devices: Ridiculous Acronym Worshippers > >>or just plain: > >>FAD : Funny Acronym Department ? > >> > >>No harm, no offence intended anywhere > >>(except for some storage ppl, maybe) > >> > >>Getting Late... > >>Tomorrow is 10G lanch-Europe, > >>and all these ideas will be legacy. > >> > >>Regards, > >> > >>PdV > >> > >> > >> > >> > >> > > > > > > > > -- > 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). > -- > Please see the off
RE: Storage Frust....
Thank you... The honor is gratefully accepted... Soon the hordes of BAARF party member shall rule the world! Um... Ok, maybe not rule the world... But at least we'll be loud! Tim BAARF Party Member #44 -Original Message- Sent: Wednesday, September 24, 2003 10:40 PM To: Multiple recipients of list ORACLE-L Well, Sir Tim - congratulations with your BAARF party membership # 44. The BAARF.zip file will be shipped in a second. Mogens Johnston, Tim wrote: >Hey... I'm jealous!!! BAARF! BAARF! BAARF! > >Tim > >-Original Message- >Sent: Wednesday, September 24, 2003 7:30 PM >To: Multiple recipients of list ORACLE-L > > >Sir Visser, > >It would be my honour to enroll you in the BAARF party as party member # >43 if you like. > >Also, if you enroll, I'll send you the whole BAARF.zip file (33 K) which >contains the story, the dialogues, and the song texts of the BAARF >musical which we'll do at the Database Forum Gala Dinner on Friday night. > >But only if you promise me to give me harsh critique in return! > >And that goes for all you other members (or possible members) of the >BAARF Party, too. Except, of course, the ones going to the Database >Forum. They'll have to wait. > >Mogens > >Piet de Visser wrote: > > > >>Group, >> >>After another run-in with Storage, >>need to Vent Some frustrations: >> >>BAARF >> >>Thank you. >> >>While I'm at it, >>let me add some other RAD ideas: >> >>Frustrated by vendors and manuals, >>we were about to turn BAARF into: >>battle against any Raw Filesystems >>(Yes, Yes, I know, a raw-dev is not a FS). >> >>But, not wanting to thread on other ppls turf, we thought >> >>CCCP: >>for Compulsory use of a Clustered Computing Platform, >>whose mission should be to elimiate all usage of >>Mulitple, In-duh-vidual, ORACLE_BASE/HOMEs >>and to enforce the use of single-installed Oracle software >>on Clustered file systems. >> >>And to stay in the same retro-atmosphere, we looked at: >> >>USSR: >>for Usage of Single System Rollout: >>to proclaim the use of sinle-installed ORACLE_BASE/HOMEs, >>partly inspired by OpenSSI.org >> >>More ideas anyone ? >> >>Don't start me on: >>the RAC party : Ridiculous Acronym Creators >>followed by >>the RAW devices: Ridiculous Acronym Worshippers >>or just plain: >>FAD : Funny Acronym Department ? >> >>No harm, no offence intended anywhere >>(except for some storage ppl, maybe) >> >>Getting Late... >>Tomorrow is 10G lanch-Europe, >>and all these ideas will be legacy. >> >>Regards, >> >>PdV >> >> >> >> >> > > > -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnston, Tim 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: Storage Frust....
Hey... I'm jealous!!! BAARF! BAARF! BAARF! Tim -Original Message- Sent: Wednesday, September 24, 2003 7:30 PM To: Multiple recipients of list ORACLE-L Sir Visser, It would be my honour to enroll you in the BAARF party as party member # 43 if you like. Also, if you enroll, I'll send you the whole BAARF.zip file (33 K) which contains the story, the dialogues, and the song texts of the BAARF musical which we'll do at the Database Forum Gala Dinner on Friday night. But only if you promise me to give me harsh critique in return! And that goes for all you other members (or possible members) of the BAARF Party, too. Except, of course, the ones going to the Database Forum. They'll have to wait. Mogens Piet de Visser wrote: >Group, > >After another run-in with Storage, >need to Vent Some frustrations: > >BAARF > >Thank you. > >While I'm at it, >let me add some other RAD ideas: > >Frustrated by vendors and manuals, >we were about to turn BAARF into: >battle against any Raw Filesystems >(Yes, Yes, I know, a raw-dev is not a FS). > >But, not wanting to thread on other ppls turf, we thought > >CCCP: >for Compulsory use of a Clustered Computing Platform, >whose mission should be to elimiate all usage of >Mulitple, In-duh-vidual, ORACLE_BASE/HOMEs >and to enforce the use of single-installed Oracle software >on Clustered file systems. > >And to stay in the same retro-atmosphere, we looked at: > >USSR: >for Usage of Single System Rollout: >to proclaim the use of sinle-installed ORACLE_BASE/HOMEs, >partly inspired by OpenSSI.org > >More ideas anyone ? > >Don't start me on: >the RAC party : Ridiculous Acronym Creators >followed by >the RAW devices: Ridiculous Acronym Worshippers >or just plain: >FAD : Funny Acronym Department ? > >No harm, no offence intended anywhere >(except for some storage ppl, maybe) > >Getting Late... >Tomorrow is 10G lanch-Europe, >and all these ideas will be legacy. > >Regards, > >PdV > > > -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnston, Tim 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: RAC for download
d 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: =?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). > 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. Wang Trading LLC 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Johnston, Tim 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: URGENT REPORTS
Title: RE: URGENT REPORTS Check out Xvfb... It the virtual frame buffer... I think it will accomplish what you are looking for... HTH Tim -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 3:55 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT REPORTS Never mind. Was a bad rep_mdmdmd.conf file. However, does anyone know if there is a way to run reports services without have a DISPLAY variable set? We don't have a dedicated machine for this one purpose. -Original Message- From: Stankus, Paula G Sent: Wednesday, September 24, 2003 1:56 PM To: '[EMAIL PROTECTED]' Subject: RE: URGENT REPORTS REP-110: Unable to open file 'alc4.rep'. REP-1070: Error while opening or saving a document. REP-0110: Unable to open file 'alc4.rep'.
RE: Re: max parallel query
> > Hrrrmmthe on-topic-ness of this has strayed far from Oracle. My > apologies. Not sure I agree with the last statement... I think it is on topic... Many of us DBA types are often involved in these kinds of discussions internally and the more informed we are the better off we are... It gives more credibility to our arguments and allows us to make more informed decisions... Thanks for the information! Tim > > Thanks, > Matt > > -- > Matthew Zito > GridApp Systems > Email: [EMAIL PROTECTED] > Cell: 646-220-3551 > Phone: 212-358-8211 x 359 > http://www.gridapp.com > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnston, Tim 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: OT: Tempfile weirdness
ver grabbed any space. > > > > -- > > > > ______ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: Johnston, Tim 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?
Mine shipped from Bookpool yesterday... It's currently listed as "In Stock" there if you're in a hurry... http://www.bookpool.com/.x/t9mrg8o9b1/ss/1?qs=059600527X Tim -Original Message- Sent: Wednesday, September 17, 2003 2:15 PM To: Multiple recipients of list ORACLE-L Tom has a NEW, different book out, from Oracle Press. That is the one Cary is referring to. Which means you'll have to buy a new book. As for Cary's book, I have it on order at Amazon as well, but according to the site today, it's still not released. :( --- Dwayne Cox <[EMAIL PROTECTED]> wrote: > Why oh why did I not wait? I tracked down and purchased Tom's > previous > Expert One-on-One Oracle a couple months ago. I even checked to make > sure > a new edition was not forthcoming. *sigh* Did not check enough I > guess. > > I'll have to compare the two to see if I want to 'upgrade'. > > I am waiting, impatiently, for Cary's book (preordered on Amazon). I > just > attended the Oracle9i Performance Tuning Class and am quite pumped > about > tuning. Especially since we have recently experienced some > performance issues. > > > Dwayne > -- > Dwayne Cox > Info Tech, Inc. > Gainesville, FL > > > Cary Millsap wrote: > > Tom's book, by the way, is spectacular. > > > > > > > > Cary Millsap > > Hotsos Enterprises, Ltd. > > http://www.hotsos.com > > > > Upcoming events: > > - Hotsos Clinic <http://www.hotsos.com/training/clinic101> 101 in > > Sydney > > - Hotsos Symposium 2004 > <http://www.hotsos.com/events/symposium/2004> > > March 7-10 Dallas > > - Visit www.hotsos.com for schedule details... > > > > -Original Message- > > Jamadagni, Rajendra > > Sent: Tuesday, September 16, 2003 11:40 AM > > To: Multiple recipients of list ORACLE-L > > > > > > > > Thanks Cary I have your new book and Tom's new book on order .. > > > > > > > > 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- > > Sent: Tuesday, September 16, 2003 12:05 PM > > To: Multiple recipients of list ORACLE-L > > > > Raj, > > > > > > > > The book will be in the O'Reilly warehouses tomorrow (9/17), > presumably > > outbound to stores on the same or next day. I'd expect preorders to > > arrive at customers' homes on or near this weekend. > > > > > > Cary Millsap > > > > > > > > > > -- > Dwayne Cox > Corporate DBA > Info Tech, Inc. > 5700 SW 34th Street, Suite 1235 > Gainesville, FL 32608 > > email: [EMAIL PROTECTED] > phone: 352.381.4521 fax: 352.381. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Dwayne Cox > 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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: Johnston, Tim 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).
OT: Bomb scare at OpenWorld
http://news.com.com/2100-1012_3-5074383.html?tag=fd_top Regards, Tim Johnston Tel: 978-322-4226 Fax: 978-322-4100 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnston, Tim 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: 64bit or 32 Bit
isainfo -v -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 1:14 PM To: Multiple recipients of list ORACLE-L How can I find if my SunOs is 64 or 32 bit? -- 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: Johnston, Tim 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: Microsoft VS Oracle (again)
Title: RE: Microsoft VS Oracle (again) "Also, yes they are the "fastest growing" database on the market, take a look at that copy of Windows 2000 Advanced Server you've got." And, I think all the exchange servers now have Sql*Server as a back end... Considering they almost own that corner of the market, I bet that adds up to a license or two... Tim -Original Message-From: Goulet, Dick [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 4:11 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Microsoft VS Oracle (again) Well, I'll be a little more forgiving than Raj has been. Basically MicroSoft is just the "pot calling the kettle black". On the issue of price, well yes MicroSoft does have an edge, but that's just how they've eliminated all of their other competition over the years. The product does not cost less than Oracle or DB2, it's just that MicroSoft can leverage the tremendous amounts of cash they have to offset the giveaway they're into. I believe that was one of the points of the Antitrust suit they were embroiled in. On RAC they really have a long way to go. If you want to do a federated database setup like MicroSoft states, just buy standard edition Oracle licenses & toss in a pile of database links. Works the same way & you don't have to pay extra for it. The whole idea of RAC is that when one node dies, for whatever reason, the data that node was hosting is not offline till you get it repaired. And actually you really do not need to do anything to your application to take advantage of RAC, except adjust your error handling to understand that a transaction needed to be resubmitted. Overall I think MicroSoft's Achilles heel is Windows. Their a one OS horse. Oracle is a multi OS horse that runs the same whatever the platform. And BTW, Oracle runs RAC on Red Hat without any additional software, never mind that it runs on Linux in the first place. Similar things can also be said for DB2, Sybase, and Informix. When, if ever, Microsoft has a version of Sql*Server that runs as multiple independent processes on Linux then I'll give them a second look. As long as their a single multi-threaded Windows only process they can stay in Redmond. Also, yes they are the "fastest growing" database on the market, take a look at that copy of Windows 2000 Advanced Server you've got. There's a copy of Sql*Server 2000 in there, and you can't uninstall it. Billy G is still up to his old tricks. The only solution to MicroSoft is forced divestiture. Too bad that judge could not stand up to King George. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 1:40 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Microsoft VS Oracle (again) Aargh ... you must be very brave telling a Oracle cult to move to SQL Server ... How do we know you are not Billy G using an alias ... 8>) 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: Gabriel Aragon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 01, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Subject: Microsoft VS Oracle (again) FYI One of my friends at Microsoft, (yes I must to confess, I have friends at MS) gave me a "present", it's a 4 cd's kit called "SQL Server 2000 for the Oracle Customer", the kit consist in 4 cd's with demos, docs, presentations, videos and a lot of stuff showing why sql server is a better option as a DB instead oracle, contains price lists, performance evaluation and many other "information", maybe you'd like to spend some of your time giving Billy a chance to defend his product. The 4 cd's are available (almost completely) as links in: http://www.microsoft.com/sql/oraclekit Any comments? Gabriel
RE: Tech meetings
We had these at the last place I was at... The senior folks from the various teams would get together... One person or group was designated to present a topic for the next meeting... Neat idea but it failed at that location... The reason? The VP of App Dev decided he wanted to attend the meetings... Which meant we spent every meeting teaching him the basics and never really getting to the good stuff... It ended up being a huge waste of time for the majority of the people in the room... Tim -Original Message-From: M.Godlewski [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 12:30 PMTo: Multiple recipients of list ORACLE-LSubject: Tech meetings List, Just wondering if your organization has tech meetings, and what is discussed and what the goals of the meetings are? I've been asked about this, and was wondering if there is a quick list out there any where. TIA Do you Yahoo!?The New Yahoo! Search - Faster. Easier. Bingo.
RE: Partitions of table read only
Ah... That's why the example helps... The text above the example is unclear but the example is a little bit better... "If you find it is taking a long time for the tablespace to quiesce, it is possible to identify the transactions which are preventing the read-only state from taking effect. The owners of these transactions can be notified and a decision can be made to terminate the transactions, if necessary. The following example illustrates how you might identify the blocking transactions. Identify the transaction entry for the ALTER TABLESPACE...READ ONLY statement. SELECT sql_text, saddr FROM v$sqlarea,v$session WHERE v$sqlarea.address = v$session.sql_address AND sql_text like 'alter tablespace%'; SQL_TEXT SADDR alter tablespace tbs1 read only 80034AF0 The start SCN of each active transaction is stored in the V$TRANSACTION view. Displaying this view sorted by ascending start SCN lists the transactions in execution order. Knowing the transaction entry for the read-only statement, it can be located in the V$TRANSACTION view. All transactions with lesser or equal start SCN can potentially hold up the quiesce and subsequent read-only state of the tablespace. SELECT ses_addr, start_scnb FROM v$transaction ORDER BY start_scnb; SES_ADDR START_SCNB -- 800352A0 3621 --> waiting on this txn 80035A50 3623 --> waiting on this txn 80034AF0 3628 --> this is the ALTER TABLESPACE statement 80037910 3629 --> don't care about this txn After making the tablespace read-only, it is advisable to back it up immediately. As long as the tablespace remains read-only, no further backups of the tablespace are necessary since no changes can be made to it." Notice it says "All transactions with lesser or equal start SCN can potentially hold up the quiesce and subsequent read-only state of the tablespace"... Not just the transactions against that tablespace... And, they are checking all entries in v$transaction... On the other hand, you can still alter tablespaces to read only even though your system is busy... The point is that the command will hang until all transactions that started before your alter command finish... Maybe this is a better way... 1) tx1 starts at time t1 2) You alter tablespace tbsp1 to read only at t2 (it hangs) 3) tx2 starts at time t3 and does not go against tbsp1 4) tx3 starts at time t4 and does go against tbsp1 (it fails since tbsp1 is in transitional read only) 5) tx1 completes 6) The alter to read only can not complete since tx1 was the only transaction that started before it Better? Tim -Original Message- Sent: Wednesday, June 18, 2003 9:50 PM To: Multiple recipients of list ORACLE-L The admin guide doesn't say "no transactions in the database". In fact, it specifically says in the tablespace: " You do not have to wait for transactions to complete before issuing the ALTER TABLESPACE...READ ONLY statement. When the statement is issued, the target tablespace goes into a transitional read-only mode in which no further DML statements are allowed, though existing transactions that modified the tablespace will be allowed to commit or rollback. Once this occurs, the tablespace is quiesced, with respect to active transactions." There were other transactions in the database, but none affecting that tablespace. The concepts guide is somewhat ambiguous and could be read either as "in the database" or "against the tablespace" since it isn't specified. Have I mentioned lately that I hate the docs? :) --- "Johnston, Tim" <[EMAIL PROTECTED]> wrote: > In order to complete an alter to read only, ALL transactions against > the > database that were started before you issued that alter command must > complete before the alter will continue... From the concepts > guide... > > > The ALTER TABLESPACE ... READ ONLY statement places the tablespace in > a > transitional read-only mode and waits for existing transactions to > complete > (commit or roll back). This transitional state does not allow any > further > write operations to the tablespace except for the rollback of > existing > transactions that previously modified blocks in the tablespace. > Hence, in > transition the tablespace behaves like a read-only tablespace for all > user > statements except ROLLBACK. After all of the existing transactions > have > either committed or rolled back, the ALTER TABLESPACE ... READ ONLY > statement completes and the tablespace is placed in read-only mode. > > > And there is a good example in the admin guide... > > http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/tspa > ces.htm
RE: Partitions of table read only
entered and read and never altered, so I would > like to > > > > move > > > > older partitions to read only tablespaces and possible read > only > > > > devices so > > > > the backup will be made quicker. > > > > > > > > Is it possible to have parttions of the same table spread > across > > > read > > > > only > > > > and read/write tablespaces? > > > > Am I correct in assuming that once you backup a read only > > > tablespace > > > > there > > > > is no need to backup the same again. (provided you don't make > it > > > > read/write > > > > add data and make it read only again).? > > > > Does anybody have a procedure already that automatically > creates > > > the > > > > new > > > > partitions let say every month? > > > > > > > > > > > > TIA > > > > > > > > Jacob A. van Zanen > > > > Oracle DBA > > > > Quant Systems Europe b.v. > > > > Tel : +31 (0) 251 - 268 268 > > > > Mobile: +31 (0) 6 51308813 > > > > Fax: +31 (0) 251 - 268 269 > > > > E-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > > Visit our web site at http://www.quantsystems.nl/ > > > > <http://www.quantsystems.nl/> > > > > > > > > > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > > -- > > > > Author: Darrell Landrum > > > > 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). > > > > > > > > > __ > > > Do you Yahoo!? > > > SBC Yahoo! DSL - Now only $29.95 per month! > > > http://sbc.yahoo.com > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Rachel Carmichael > > > 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). > > > > > > __ > > Do you Yahoo!? > > SBC Yahoo! DSL - Now only $29.95 per month! > > http://sbc.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Rachel Carmichael > > 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). > > > -- > === message truncated === __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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: Johnston, Tim 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: ORA600 [2103] [0] [0] [1] [900]
Title: ORA600 [2103] [0] [0] [1] [900] Check metalink Note:28045.1 -Original Message-From: Hatzistavrou John [mailto:[EMAIL PROTECTED]Sent: Thursday, June 12, 2003 6:45 AMTo: Multiple recipients of list ORACLE-LSubject: ORA600 [2103] [0] [0] [1] [900] Dear All, I have encountered the following message during 'alter database backup controlfile to '..' reuse after a hot backup. We have opened a tar but still waiting. The strange think is that our Oracle
RE: * Oracle DBA with Lawson exp. Needed in Memphis, TN...
Wow... It's been awhile since we've seen Mr Law on the list... I wonder if this means the market is picking up? -Original Message- Sent: Thursday, June 05, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Position: Lawson Oracle DBA Location: Memphis, Tennessee Salary Range: 78K range -depends on experience. Relocation assistance is provided. Please do not send your resume unless you have a stable work history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. *Description: Lawson ORACLE DBA needed for ground floor Lawson project. Critical, high profile position. Senior level position requiring skills in both logical and physical database design. Will be the "go-to" DBA. The Sr. DBA will be responsible for enterprise-wide database planning, modeling, design and development, monitoring and administration. Will ensure that database designs are developed in keeping with departmental standards and designs, provide standards for ensuring database security, and instruct and supervise others in database administration, concepts and tasks. *Requirements: -BS degree required and will be verified. -Sr. Oracle DBA experience. -MUST Have Lawson experience...though not expert level. -Logical and physical database design experience. -Multiple RDBMS experience. -Will need strong interpersonal skills. -Must be a U.S. citizen or permanent resident. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Memphis/Oracle Lawson DBA/MS ph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraStaff 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: Johnston, Tim 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: Tablespaces - datafiles
Title: RE: Tablespaces - datafiles Not on that machine... Although we do have VxFS here and the behavior is the same as UFS... As others have pointed out, it is using sparse files for temporary tablespaces and these can "bite you" if you are not careful... Out of curiosity, why did you ask? Tim -Original Message-From: Nick Wagner [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 11, 2003 3:57 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Tablespaces - datafiles are you using VxFS? -Original Message- From: Johnston, Tim [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 11, 2003 12:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: Tablespaces - datafiles Create the tablespace and look at it with ls and du... $ ls -lrt /export/home0/oradata/PV408/temp3.dbf -rw-r- 1 oracle dba 524304384 Mar 11 15:05 /export/home0/oradata/PV408/temp3.dbf $ du -sk /export/home0/oradata/PV408/temp3.dbf 104 /export/home0/oradata/PV408/temp3.dbf This is Solaris 8 Tim -Original Message- Sent: Tuesday, March 11, 2003 2:43 PM To: Multiple recipients of list ORACLE-L Tom, Do you have that doc ref handy? Using this SQL: create temporary tablespace temp3 tempfile '/u01/oradata/dv03/temp3.dbf' size 500m extent management local uniform size 1m / On both 8.1.7.0 and 9.2.0.1 on RH 7.2 I found that the file was immediately created full size. Platform dependencies maybe? Jared "Mercadante, Thomas F" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/11/2003 06:19 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Tablespaces - datafiles LeRoy, I just struggled with this last week. You can't move Temporary Data files. You need to drop and recreate the TEMP tablespace - creating the data files in the correct directories. On a side note - here is an interesting feature. When Oracle creates files for the TEMP tablespace, it does not create the files full sized like it does for normal data files. It creates them smaller for speed purposes (it creates the TEMP tablespace very fast) and will allow the TEMP data files to grow as needed. Now here is the kicker. Let's say you have a disk that is 9 gig is size. You can create 10-1 Gig Temp data files on that disk. Since Oracle does not create the files full-sized, there is nothing to stop this from happening. Sometime later, as the TEMP tablespace gets used, the files grow until eventually the disk fills up, and a sql query crashes with an obscure disk io error. Oracle is trying to expand the TEMP datafiles to the size it's been told they should be. But there is no physical space left on disk. Documentation in 817 does not mention this. But 92 doc's are up to date. nice surprise, eh? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, March 11, 2003 8:39 AM To: Multiple recipients of list ORACLE-L All - I am having a problem with the datafiles in a temporary tablespace. I need to move and rename three different datafiles in the tablespace. I am able to take them offline - no problem. I cna make the changes at the OS level. I am running on Unix. But I can't get the changes to show up in the OEM inorder to bring them back on-line. Do I need to remove all users from this tablespace before making these changes? The tablespace is temporary so does that make a difference? Any suggestions? LeRoy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: LeRoy Kemnitz 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: Mercadante, Thomas F 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
RE: Tablespaces - datafiles
Create the tablespace and look at it with ls and du... $ ls -lrt /export/home0/oradata/PV408/temp3.dbf -rw-r- 1 oracle dba 524304384 Mar 11 15:05 /export/home0/oradata/PV408/temp3.dbf $ du -sk /export/home0/oradata/PV408/temp3.dbf 104 /export/home0/oradata/PV408/temp3.dbf This is Solaris 8 Tim -Original Message- Sent: Tuesday, March 11, 2003 2:43 PM To: Multiple recipients of list ORACLE-L Tom, Do you have that doc ref handy? Using this SQL: create temporary tablespace temp3 tempfile '/u01/oradata/dv03/temp3.dbf' size 500m extent management local uniform size 1m / On both 8.1.7.0 and 9.2.0.1 on RH 7.2 I found that the file was immediately created full size. Platform dependencies maybe? Jared "Mercadante, Thomas F" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/11/2003 06:19 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Tablespaces - datafiles LeRoy, I just struggled with this last week. You can't move Temporary Data files. You need to drop and recreate the TEMP tablespace - creating the data files in the correct directories. On a side note - here is an interesting feature. When Oracle creates files for the TEMP tablespace, it does not create the files full sized like it does for normal data files. It creates them smaller for speed purposes (it creates the TEMP tablespace very fast) and will allow the TEMP data files to grow as needed. Now here is the kicker. Let's say you have a disk that is 9 gig is size. You can create 10-1 Gig Temp data files on that disk. Since Oracle does not create the files full-sized, there is nothing to stop this from happening. Sometime later, as the TEMP tablespace gets used, the files grow until eventually the disk fills up, and a sql query crashes with an obscure disk io error. Oracle is trying to expand the TEMP datafiles to the size it's been told they should be. But there is no physical space left on disk. Documentation in 817 does not mention this. But 92 doc's are up to date. nice surprise, eh? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, March 11, 2003 8:39 AM To: Multiple recipients of list ORACLE-L All - I am having a problem with the datafiles in a temporary tablespace. I need to move and rename three different datafiles in the tablespace. I am able to take them offline - no problem. I cna make the changes at the OS level. I am running on Unix. But I can't get the changes to show up in the OEM inorder to bring them back on-line. Do I need to remove all users from this tablespace before making these changes? The tablespace is temporary so does that make a difference? Any suggestions? LeRoy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: LeRoy Kemnitz 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: Mercadante, Thomas F 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: 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: Johnston, Tim INET: [EMAIL PROTECTED] Fat City Network Services-- 8
RE: DBMS_STATS
To expand on this, the action level is controlled by the granularity parameter... Granularity of statistics to collect (only pertinent if the table is partitioned). DEFAULT: Gather global- and partition-level statistics. SUBPARTITION: Gather subpartition-level statistics. PARTITION: Gather partition-level statistics. GLOBAL: Gather global statistics. So, in you case, run the following... execute dbms_stats.gather_table_stats(ownname => 'LDGADMIN', - tabname => 'LOG_TRANS', - partname => 'LOG_TRANS_20030102', estimate_percent => 5, granularity => 'PARTITION'); See the supplied package reference for more details... Tim -Original Message- Sent: Tuesday, February 25, 2003 4:50 PM To: Multiple recipients of list ORACLE-L The default action of dbms_stats against a single partition of a partitioned table is much more aggressive than a simple analyze of the partition. At the least, it does a similar analyze of the whole table in order to maintain the global table statistics - you need to set the granularity of the analyze to stop this happening. On a quick test, with sql_trace turned on and using 9.2.0.2, your choice of parameters gave me: Two 5% analyzes of the specified partition, with a small difference relating to one longish varchar() column. One 5% analyze of the whole table. One 50% analyze of the whole table - restricted to a much smaller process of a subset of the columns that omitted the one longish varchar() column. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August 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: 25 February 2003 18:12 > I have never had good luck with DBMS_STATS. It seems that the old analyze runs > much faster. > > Runs in 45 seconds: > analyze table log_trans partition (log_trans_20030104) estimate statistics > sample 5 percent; > > Takes over 2 hours: > execute dbms_stats.gather_table_stats(ownname => 'LDGADMIN', - > tabname => 'LOG_TRANS', - > partname => 'LOG_TRANS_20030102', - > estimate_percent => 5); > > Am I missing something? Aren't both commands the same? > > Thanks, > Tom > -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnston, Tim 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: Partition recovery question
//www.orafaq.net -- Author: Darrell Landrum 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: DENNIS WILLIAMS 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: Johnston, Tim 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: Veritas Agent for Oracle / incremental backups vs. hot
FYI... I think BLIB is the tool you're thinking of... It stands for Block Level Incremental Backup... Tim -Original Message- Sent: Friday, February 21, 2003 1:34 AM To: Multiple recipients of list ORACLE-L Not necessarily. If you're backing up vxfs with Veritas Netbackup and also have someother component from Veritas that I can't recall at the moment, filesystem incrementals are made at the FS block level. You only backup new blocks, or blocks that have been touched. Jared On Wednesday 19 February 2003 12:09, Nelson, Allan wrote: > Actually assuming you checkpoint or commit at least once between backups it > would not make any difference at all. An incremental backup catches > changed files since the last backup which will typically be all your data > files. SCN's get updated in all headers if any thing changes. > > Allan > > -Original Message- > Sent: Wednesday, February 19, 2003 1:25 PM > To: Multiple recipients of list ORACLE-L > > > My manager asked me to assess how much smaller our backups would be if we > were doing incremental backups of our database files, instead of the usual > hot backups. > > We are running 8i on UNIX. > > I know that the answer is "it depends" and "you can't really know 'till you > try", but we are just looking for a ballpark figure, perhaps in > percentages. > > Our databases are between OLTP and DSS, closer to DSS environment, this > being a scientific site. > > Thanks. > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: Johnston, Tim 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: [new info] Redhat Advanced Server Dev Edition - RAC
Now you've done it... I'll never be able to listen to that song again without thinking... "We will, we will, RAC you" :-) -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 12, 2003 11:19 PMTo: Multiple recipients of list ORACLE-LSubject: Re: [new info] Redhat Advanced Server Dev Edition - RACThanks, Mark. Any email helps. Wherever I've taught a class around the world while I was still with Oracle, or later after doing the Miracle thing, I've always given out my email address and phone numbers to everybody in the room - and on average have received two emails even when I was presenting for 100 people. But the Unix SIG meeting in London changed that. I've gotten about 7 or 8 mails from the 110 attendees there, so I'm feeling like a rock star right now...RAC is on sale (at least in the US) currently, which means it only costs 25% on top of EE instead of the normal 50%.But if you're paying $60K (or perhaps only $50K :) ) per CPU for Oracle, why is it important to have extremely cheap hardware to run it? Why would you want to run very expensive software on very cheap hardware? Yes, the total price will go down, but just like when we're looking at databases and try to find where the time goes, we might here want to look at where the money goes and then try to cut the cost by looking at, say, the most expensive part of the configuration first :).One important thing to realise is that Oracle is selling this and managers and directors are buying it, while many DBA's and system admins are asking the right questions (to absolutely no avail), namely: Why? Are there cheaper and/or simpler and/or better alternatives to our real needs here? The dream of having all those wonderful things (HA, scaling, workload partitioning, happier marriages, more uniforms, faster cars, and such) is easily sold to the political levels but not to the twisted and bitter old men and women in the technical world. The result is of course that RAC will pop up here and there and perhaps one day everywhere.But RAC, clusters, CFS, what have you, all make the environments even more complex. Which is good for me, since I run a high-end consulting outfit. Should be good for all of us. But then we all have to stop questioning the wisdom of buying and implementing RAC and instead endorse it every time we get the chance.The only downside I can think of is that if all the techies start shouting "We will, we will, RAC you" and "RAC over Bethoven" everywhere and at all times, managers and directors might think that RAC is some kind of nerdy thing that they'd better stay away from. Action and reaction.Best regards,MogensMark Leith wrote: I heard Mogens talk about this at the UKOUG Unix SIG in London at the end of last month ("You Probably Don't Need RAC, or: pRos And Cons"). It was truly an eye opener! The upshot was, if you don't have a requirement to be up from a failure within 5 minutes, then you don't need RAC. As has already been pointed out, in the case of a SAN failure, then even this may not count. Mogens also mentioned some pretty interesting up time statistics. A single Unix box can have an availability of 99.9%. A two node Unix cluster has an availability of 98% (due to software patching/upgrades). There is also still a "brown out" period with RAC when a node fails, whilst the other node or nodes play "catch up" to re-assign the resources and recover any work that the failed node was doing at the point of failure. Of course, there are also pros to having RAC, workload partitioning (running batch on one node, OLTP type work on another), you can scale your CPUs as and when the increase is needed. There seemed to be far more cons than pros imo though. Mogens goes through a lot more in his talk, it is certainly worth your time! It certainly helps to widen your perspective from the constant marketing jargon ;) I really must remember to send Mogens an email, he loves email, send it to him directly, I'm sure he'll be ecstatic! :D Mark -Original Message- Sent: 11 February 2003 23:34 To: Multiple recipients of list ORACLE-L FYI, I am headed to Mogens RAC or Not to RAC presentation at the hotsos symposium, let you know what I learn! -Original Message- Sent: Tuesday, February 11, 2003 10:30 AM To: Multiple recipients of list ORACLE-L This is all cool technology, and fun stuff to play with. It all begs the questions, "How many of us work for a business that actually need this?" "Are they willing to pay $400/user $20k/CPU above the cost of Oracle 9i EE to use it?" "Are they willing to pay the extra overhead required to maintain it?" I'm not sure the ROI is there for many of us. Though downtime at our business is somewhat expensive, I think that a failover system or even standby database will provide adequate coverage for us, which is indeed a hot topic he
RE: RMAN or SQLBacktrack?
I don't have any SQLBacktrack experience but one thing you said hit me... RMAN will not work on your v7 databases... Tim -Original Message- Sent: Tuesday, January 28, 2003 5:17 PM To: Multiple recipients of list ORACLE-L We have been using SQLBacktrack to backup our databases on Unix and NT for several years. We have been VERY please with the product. We have a mixture of Oracle 8.1.7 and 7.3.4 databases. We are being pushed to use RMAN because it is free. Does anyone have any experience with both and be willing to share their experiences? Thanks! R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. 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: Johnston, Tim 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: Slow SQL*Plus connect.
Is otrace enabled? Note: 1020763.6 Note: 45482.1 Tim -Original Message- Sent: Wednesday, January 22, 2003 5:09 AM To: Multiple recipients of list ORACLE-L Hi All, We have experienced a *very* slow connect time to a 9.0.1 database via SQL*Plus (and other apps as well) on a Win2K machine, and I was wondering if anybody else had experienced these slow connection times as well? We have also been asked lately by a number of customers about slow connection times, and to this point haven't found a solution for either ourselves or our contacts.. It's not a network issue as connection times take just as long "locally". Connections can take up to around a minute (and the odd occasion a couple of minutes). No MTS is in use. OS's that I've heard about this on are Win2K, XP and NT so I'm also wondering if it may be a Win32 issue. Help! Cheers :) Mark === Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput & performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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: Johnston, Tim 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: Help with procedure
What is the exact error? What oracle version? Just guessing, are the privs granted directly to the user or through a role? If they are via a role, grant them directly to the user... HTH Tim -Original Message- Sent: Monday, January 20, 2003 4:16 PM To: Multiple recipients of list ORACLE-L Hi List, I'm hoping someone can help me. I'm trying to compile a procedure, which calls another procedure and I keep getting an error on the first end; can't figure out what's wrong. Perhaps someone that hasn't seen this procedure for hours can tell me what's wrong. The user has all the right privileges. Here's the code: CREATE OR REPLACE PROCEDURE EMPLOYEE_ACTIVITY.convert_AA_admin AS -- -- -- Purpose: Convert Agent_Activity.Admin table to Employee_Activity -- User_Info and User_Security_Group. -- -- MODIFICATION HISTORY -- Person Date Comments -- - -- --- -- psurring 1/20/03 Initial implementation -- err_num NUMBER; err_msg VARCHAR2 (100); V_SECURITY_GROUPUSER_SECURITY_GROUP.SECURITY_GROUP_ID%TYPE; V_BRANCHUSER_INFO.BRANCH%TYPE; CURSOR get_admin IS Select username, password, level_, center, first_name, last_name From AGENT_ACTIVITY.ADMIN Where upper(level_) in ('CENTER','TEAM','GROUP','PAYROLL'); BEGIN FOR x IN get_workgroups LOOP begin if upper(x.level_) in ('CENTER','TEAM','GROUP') then v_security_group := 4; else if upper(x.level_) in ('PAYROLL') then v_security_group := 2; end if; if x.center = 'TX' then v_branch := '7'; else v_branch := 'G'; end if; EMPLOYEE_ACTIVITY.ADD_USER(x.username, x.first_name, x.last_name, x.password, v_branch, null, 'SYSTEM', v_security_group); EXCEPTION WHEN OTHERS THEN err_num := SQLCODE; err_msg := SUBSTR (SQLERRM, 1, 100); ROLLBACK; insert into Application_error (USER_NAME, ERROR_DATE, PROCEDURE_NAME, SQL_ERROR_NUM, SQL_ERR_MSG, PARAMETER) values (v_LAST_UPDATED_BY,sysdate,'EMPLOYEE_ACTIVITY.ADD_USER',v_err_num,v_err_msg, 'v_USER_NAME='||v_USER_NAME|| 'v_FIRST_NAME='||v_FIRST_NAME|| 'v_LAST_NAME='||v_LAST_NAME|| 'v_PASSWORD='||v_PASSWORD|| 'v_DEFAULT_BRANCH='||v_DEFAULT_BRANCH|| 'v_DEFAULT_WORKGROUP_ID='||v_DEFAULT_WORKGROUP_ID|| 'v_LAST_UPDATED_BY='||v_LAST_UPDATED_BY|| 'v_SECURITY_GROUP_ID='||v_SECURITY_GROUP_ID); COMMIT; RAISE; END; END LOOP; end; / TIA, M. Bryan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bryan, Miriam 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: Johnston, Tim 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: RE : RMAN Repository
Title: RE: RE : RMAN Repository I do have one scenario where you really have to use a recovery catalog... When attempting to backup a VLDB that uses read only tablespaces and extremely infrequent backups for most of the data (i.e. a large datawarehouse), a recovery catalog is very important... You just may not have the time to perform full backups of your multi terabyte database... In this case, you better hope that the backup of your read only tablespace from 15 months ago is still around... Since the CONTROL_FILE_RECORD_KEEP parameter only goes to 1 year, you may be stuck unless you have that data in a recovery catalog... Tim -Original Message-From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 09, 2003 12:35 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RE : RMAN Repository The only things you can't do with controlfile RMAN/database metadata is: 1) use previous "incarnations" of the database for recovery; Actually, you can, it's just a manual process. This is documented in the RMAN book. Also, in 9i you can do automated backup/restore of control files of your database in RMAN without the recovery catalog, and you can manually recover a control file if that is required using dbms_backup_restore. Robert Robert G. FreemanTechnical Management ConsultantTUSC - The Oracle Experts www.tusc.com904.708.5076 Cell (it's everywhere that I am!)Author of several books you can find on Amazon.com! -Original Message-From: Orr, Steve [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 09, 2003 10:46 AMTo: Multiple recipients of list ORACLE-LSubject: RE: RE : RMAN Repository If you aren't using a repository all you have to do is make sure control file backups are part of the routine. There are 2 ways to backup the backup metadata: 1) the RMAN repository database; 2) backup controlfiles. Functionally and operationally they're pretty much the same. The only things you can't do with controlfile RMAN/database metadata is: 1) use previous "incarnations" of the database for recovery; 2) use database stored scripts. No big deal as far as I'm concerned. When RMAN first came out a separate repository database was a requirement. Subsequent releases added some functionality for using controlfiles. The vulnerability of losing the repository or losing the backup controlfile is about equivalent. The overhead of the repository database is more. With the initial releases of RMAN (EBU) Oracle was rightly criticized for the fact that you had to backup the database that holds information about the database you want to backup. Getting rid of this silliness seems reasonable to me. Steve Orr-man for RMAN, Bozeman, Montana -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Subject: RE : RMAN Repository Importance: High And how does one go about restoring a database when all control files are lost, and the only recovery data is stored in the control file? This doesn't sound very reasonable. Jared "Deshpande, Kirti" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/08/2003 11:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE : RMAN Repository Joe, That's what I have heard (from 2 Oracle University Professors/Lecturers/Demonstrators). But no one would tell me when it may happen. We do not use RMAN (yet) so I did not pursue it further. - Kirti -Original Message- Sent: Wednesday, January 08, 2003 1:08 PM To: Multiple recipients of list ORACLE-L Obilgatory oracle statement/question: rumor has it by some instructors that RMAN repository is going away and only control file recoveries will be possible, truth or fiction? joe
RE: test this email ad
Um... This looks like a sales critter post... So, let's test it... Tell me Paul... Exactly why is this tool so wonderful??? And, a simple cut and paste of marketing material won't do... What exactly does it do for you that is so wonderful??? How does it free up your time??? FYI, if you are a sales critter, you shouldn't post this kind of stuff unless you have some idea of what you're are talking about... We do have a couple sales critters around but they maintain a fairly low profile and actually contribute to the list... And whatever you do don't get get on Dick's bad side... Right Dick? :-) Tim -Original Message-From: Dessources Paul [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 3:07 PMTo: Multiple recipients of list ORACLE-LSubject: FW: test this email ad Guys and Gays I just started working for this company and they have a really cool DBA appliance. It for up my time to do other DBA stuff. Paul OCP Monitors database health, performance, host, space, audit, response, stand-by and security events including BSTAT/ESTAT and STATSPACK. For a FREE TRIAL: Contact's Name Email Address This information will only be used for contacting you about this product by Pinnacle Data. DBA-in-a-Box warns you of hundreds of database issues before they become a problem; protecting your assets. Customized filtering of events and threshold settings. No Software is installed on your system. Free Hardware, setup and upgrades. You and your DBA's can focus more on other critical business operations. DBA-in-a-Box sends alerts to your e-mail, PDA, cell phone, and pager. DBA-in-a-Box costs $1.75 per hour, User defines times of operation. For more information:Click here for our product brochure (pdf)or Visit our website _ > > -- > 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). > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- *. http://join.msn.com/?page=features/featuredemail
RE: Pinned packages with multiple reloads
What about invalidations? If something invalidates the packages does it reload? Just guessing... I remember this thread and was hoping you would have an answer by now... Damn... :-) -Original Message- Sent: Tuesday, January 07, 2003 1:18 PM To: Multiple recipients of list ORACLE-L Hey all, I have a trigger that pins various packages on the startup of our 8.1.7.2.0 DB on HP/UX 11.0. I check V$DB_OBJECT_CACHE every so often to see that it's working and to make any necessary additions/deletions from the list of pinned packages. However, the SYS.DBMS_APPLICATION_INFO package currently has 836 loads off of 97706 execs despite being successfully pinned on startup (we've only been up for a few days due a 7445 cascade crash). How is this possible? Furthermore, does it do any good to pin this package? And why? This is sort of a repost from months ago, but I can't find it on fatcity. TIA! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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: Johnston, Tim 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: Re: Full table scan error
And people get so pissed when you take the time to do this while they are standing over your shoulder... I take a perverse pleasure in making them wait... While we are on the subject... I also get annoyed by mixed case... I hate the queries that look like... SELECT * from MY_table_NAME a, my_other_table B Where b.COLUMN_ONE = a.column_one One of my many things that annoy me... :-) Tim -Original Message- Sent: Friday, January 03, 2003 12:14 PM To: Multiple recipients of list ORACLE-L Yea same here, column names, table names all on separate lines :) joe > >Personally, I always format queries before working > >with > >them, otherwise it is too difficult to determine > >what is > >being done in the query. > > > >Jared > > > > Glad to see a fellow maniac :-). > > Regards, > > Stephane Faroult > Oriole > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephane Faroul > 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). > > Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa 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: Johnston, Tim 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: Faking an ORA-600
Type "oracle" at the command line and hit enter... It should come right back to the command prompt but you'll see the following in the alert log... ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], [] -Original Message- Sent: Thursday, December 19, 2002 3:52 PM To: Multiple recipients of list ORACLE-L We are trying to test out monitoring software (on a test database at 8.1.6.3). We have been able to generate most of the errors that we want to monitor for, but have been unable to generate an ORA-600. Does anyone have a way of doing this? TIA. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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: Johnston, Tim 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: IOT Issues?
"The first one (seen in 8.1.6 and 8.1.7) was deadlocks caused by simultaneous SELECTs and the addition of a new partition (even though the queries were not querying the partition). Those deadlocks were occurring at the dictionary level - because even if an IOT is physically a single index, logically it's still a table and a PK index. Quite obviously, a SELECT puts a SHARE dictionary lock on both - and so does the ALTER. The snag is that one locks the table first and the index second, while the other does the opposite. Ouch. It may or may not be fixed by now." They FINALLY fixed it... The fix is in the 8.1.7.3 patchset... The bug also exists in 9.2.0.1 but is fixed in the 9.2.0.2 patchset... Bug number is 1367114 in case you're interested... Tim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnston, Tim 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: Recipe for application design to run on RAC
> > > > Obstetrician #1: Yes, it cost over three > > quarters of a million pounds! > > > > Obstetrician #2 (slowly and condescendingly): > > AREN'T YOU LUCKY? > > > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" > > <[EMAIL PROTECTED]> > > Sent: Wednesday, November 27, 2002 8:49 AM > > > > > > > Thanks for taking time to reply, Cary. Much > > > appreciated. > > > > > > Did I understand it correctly that in > > active/active > > > setup it would be beneficial to give each node > > "it's > > > own virtual empire" so to speak. > > > Like one node to service say marketing and sales, > > > while the other to deal with say inventory and > > > automation and minimize interdependencies between > > the > > > two? > > > I was thinking more along the lines of equally > > > === message truncated === > > __ > Post your free ad now! http://personals.yahoo.ca > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Boris Dali > 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.com -- Author: Tim Gorman 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.com -- Author: Johnston, Tim 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 10i features
I'm not sure I'd go that far... Old habits (and prejudices) die hard... :-) -Original Message- Sent: Saturday, November 23, 2002 9:24 PM To: Multiple recipients of list ORACLE-L Look for it to improve dramatically. I might even try to use it. Jared On Sunday 17 November 2002 06:13, J. Laurindo Chiappa wrote: > Jared, just a thought : ** WHY ** Oracle experts charged in OEM > developmentcan´t do anything close - fast, sweet & simple , just to the > point ?? Until now, OEM is just a pile of *hit, plain & simple. > > Regards, > > Chiappa > > *** REPLY SEPARATOR *** > > On 13/11/02 at 05:23 Jared Still wrote: > >Check out OraC, written in Perl of course. :) > > > >http://www.tux.org/orac-dba/ > > > >Jared > > > >On Tuesday 12 November 2002 11:13, Jesse, Rich wrote: > >> Good grief. Like I'm going to go through all of that overhead and > >> hassle? And isn't 9iAS a separately licensable (read: "cost") option, > >> even if you're already licensed for EE? > >> > >> I think I'm reading the same PDF you were, Raj: > >> > >> "The Console interacts with the Oracle Management Service, which, as a > >> J2EE Web Application hosted by an Oracle9i application Server, leverages > >> all of the reliability, scalability, and robustness of the Oracle9iAS > >> instance." > >> > >> I wish I has time to work on the KISS-method OEM replacement I > >> started... > >> > >> Rich > >> > >> -- > >> Rich Jesse System/Database Administrator > >> [EMAIL PROTECTED] Quad/Tech International, Sussex, WI > >> USA > >> > >> -Original Message- > >> Sent: Tuesday, November 12, 2002 10:40 AM > >> To: Multiple recipients of list ORACLE-L > >> > >> > >> New EM4.0 (announced today) has a bunch of new features ... was just > >> reading the PDF ... but it needs 9iAS ... that is a bummer ... more info > >> on oracle website ... > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Jared Still > > 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.com -- Author: Jared Still 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.com -- Author: Johnston, Tim 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).
OCI hang until TCP timeout on an established connection
Hi Guys... I have an application with a remote client... The client is written in Smalltalk and connects to the database via OCI... It establishes a connection to the database and keeps it open... If the network link between the remote client and the server fails, the remote client does not realize it until the next attempt to communicate with the database... This is fine... The problem is that once it does try to communicate with the database it waits 8 minutes after the attempt before returning the ORA-3113... I have done a little search and so far come up empty... I am hesitate to muck with the tcp parameters due to side effects (i.e. tcp_ip_abort_interval)... Does anyone have an idea how I can reduce the timeout delay without changing tcp parms? Has anyone experienced a similar issue and solved it some other way? Solaris 9 Oracle 9.2.0.2 Thanks in advance... Regards, Tim Johnston Tel: 978-322-4226 Fax: 978-322-4100 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnston, Tim 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 10i new releases
Oh... I'm sure they are many other who back farther then that... But, I do remember 6.0.36... As a matter of fact it was 6.0.36.1.53 on IBM VM... Ah the memories... Tim -Original Message- Sent: Friday, November 08, 2002 4:04 PM To: Multiple recipients of list ORACLE-L anyone remember the 6 days, 6.0.36 on sunos :) joe Mercadante, Thomas F wrote: >Robert, > >I guess what you say makes sense. But why the need to move the release >level from 8, to 8i, to 9i to 10i all within 5 years? Granted, there were >huge improvements from 8 to 9i. I guess what I'm arguing for is - lets stay >at 9i for awhile. There is nothing wrong with 9i release 1 thru 15. Are >the new features that will be available in 10i really that radical that >justifies a major release? Give the rest of us a chance to catch up to 9i. > > >My feeling is that Oracle will get hurt sooner or later - people will just >plain not move to the newer release, just to face migrating again in just a >few months. Makes no sense to me. > >Tom Mercadante >Oracle Certified Professional > > >-Original Message- >Sent: Friday, November 08, 2002 2:09 PM >To: Multiple recipients of list ORACLE-L > > >Is it that Oracle's business model is pushing these releases or is it the >rapid pace of technology change and the demand of the user for features? The >push to the web, XML, Java, and new feature requests (rename column, fk's , >drop column, etc...). Then there is competition too that has to be >considered. If Oracle doesn't "keep up with the Joneses" as it were, what >kind of market share will it have 5 and 10 years down the line. > >So, in my opinion, Oracle really has no choice but to pursue the course that >it is. I think they have learned some lessons down the road, and I'm willing >to bet that 10.0.1 (or whatever) will be far more stable than 9.0.1 was. > >RF > >Robert G. Freeman - Oracle OCP >Oracle Database Architect >CSX Midtier Database Administration >Author of several Oracle books you can find on Amazon.com! > >Londo Mollari: Ah, arrogance and stupidity all in the same package. How >efficient of you. > > > > > >-Original Message- >Sent: Friday, November 08, 2002 12:54 PM >To: Multiple recipients of list ORACLE-L > > >does this bother anybody else as much as it bothers me? just what is >Oracle's business model for pushing these release's out this fast? are >there that many new features, or a market to capture, that justifies this? > >makes no sense to me. the shelf life of an oracle release is now about a >year and a half. > >Tom Mercadante >Oracle Certified Professional > > >-Original Message- >Sent: Friday, November 08, 2002 11:44 AM >To: Multiple recipients of list ORACLE-L > > >Heard from Tom Kyte that 10i should be out by Dec'03. He also said that the >code is already frozen and beta testing is going on. > >Prakash > >-Original Message- >Sent: Thursday, November 07, 2002 14:09 >To: Multiple recipients of list ORACLE-L > > >The day we all finish upgrading our databases to 9i. > >Sunil Nookala >DBA >Dell Corp. > > > >-Original Message- >Sent: Thursday, November 07, 2002 12:09 PM >To: Multiple recipients of list ORACLE-L > > >Has anyone heard when Oracle will be releasing version 10i? > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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.com -- Author: Johnston, Tim 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 Store?
Um... Where do you see the message? I'm able to get there... I even put some stuff in my cart... But, I didn't log in and try to purchase... My credit card doesn't have a high enough limit to do a sample purchase... :-) -Original Message- Sent: Thursday, October 31, 2002 4:40 PM To: Multiple recipients of list ORACLE-L Not really. They are testing their "Unbreakable" message. Something didn't work. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, October 31, 2002 4:05 PM To: Multiple recipients of list ORACLE-L Subject:Re: Oracle Store? I've hearded Oracle is going back as a brick and mortar shop ... ;-) --- [EMAIL PROTECTED] a écrit : > Does anyone here have the scoop on the Oracle Store? > > It's been down for at least a week. The web page > says > down for maintenance, but given the amount of time, > I > don't believe it. > > Thanks, > > Jared > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > 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). > = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen 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.com -- Author: Johnston, Tim 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: CA's AutoSys
Title: RE: CA's AutoSys I too had issues with this product... But, it was several years ago... Back then it was owned by Platinum and the product ran on NT 3.51... We were using it to schedule all our Unix batch jobs for the Sales Force Automation project I was working on... Unfortunately, I was the first project using it at the company and had to suffer through many of the issues detailed below... If I remember correctly, it eventually got to a "workable" state after a couple months of patches and workarounds... I remember one job in particular... PSFUNX35... Every Friday night/Saturday morning about 3:00 AM I would get a call from the operations center in Parkersburg, WV... "Hello Tim... This is Jack in Parkersburg... Sorry to bother you... But, PS - FUN - X35 failed again..." He used to pronounce the job as... PS [break] FUN [break] X35... Needless to say it was not very fun... :-) Tim -Original Message-From: Adams, Matthew (GECP, MABG, 088130) [mailto:[EMAIL PROTECTED]]Sent: Friday, October 18, 2002 12:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: CA's AutoSys Run Screaming in the opposite direction. Product was a semi-disaster at two previous job sites. Failed to run jobs when scheduled, failed to detected when dependent jobs failed. Just plain didn't work well. Of course this was when Platinum owned the product, who knows, maybe CA improved it. (although I would doubt it). Matt Adams - GE Appliances - [EMAIL PROTECTED] Write a poem about a haircut! But lofty, noble, tragic, full of love, treachery, retribution, quiet heroism in the face of certain doom! Six lines, cleverly rhymed, and every word beginning with the letter s! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, October 18, 2002 11:50 AM To: Multiple recipients of list ORACLE-L Subject: CA's AutoSys To All, I'll admit this is somewhat off-topic, but since the project is going to handle all scheduled batch jobs that bang on our PeopleSoft Oracle database, I figured I'd ask if anyone has an opinion preferably from experience using the product. The Complete A^^holes are here today to do a demo install so any input you all have would be appreciated. Thanks in advance Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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: Urgent problem with query in CBO Vs RBO
Title: RE: Urgent problem with query in CBO Vs RBO "Looks like the lid on the "jar of bugs" is leaking ... and it made it into 920 code as well." I think this a pretty common occurrence at Oracle... I think it has to do with the way they branch their code streams... Subsequent patches are often not integrated into the latest stream I've run into this kind of thing several times... Tim -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Friday, October 18, 2002 9:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Urgent problem with query in CBO Vs RBO I don't think the reply I sent last night made it to the list. We eventually traced it to the behavior of _unnest_subquery parameter. Setting it to false solved the problem. This was first reported in 817 and supposed to be fixed in 8173 and 901 code base. Looks like the lid on the "jar of bugs" is leaking ... and it made it into 920 code as well. The biggest problem we found that the explain plan shows that it doesn't even look at a major portion of the sql statement when it fails. 10053 trace shows that the optimizer looking at all tables involved and checking for different paths, but the explain plan is not reporting all the tables involved. Here is an example ... -- this doesn't work - select SUM(a.csed_dollars) FROM client_supplied_ep_dollars a WHERE a.csed_pob_id = 213841 AND a.csed_date = (SELECT MAX(b.csed_date) FROM client_supplied_ep_dollars b WHERE b.csed_ep_number = a.csed_ep_number AND b.csed_pob_id = a.csed_pob_id) AND EXISTS (SELECT 'x' FROM v_log_master l, episode_airings e, units u WHERE u.ut_ea_ep_number = a.csed_ep_number AND u.ut_pob_id = a.csed_pob_id AND u.ut_disposition_ind IS NULL AND e.life_cycle_status > 2 AND e.ep_number = u.ut_ea_ep_number AND e.est_dt BETWEEN to_date('03/01/2002','mm/dd/') and to_date('03/31/2002','mm/dd/') -- AND e.est_dt BETWEEN m_start_date AND m_end_date AND l.log_date = e.est_dt AND l.log_network = NVL(e.act_log_network, e.log_network) AND l.log_no = NVL(e.act_log_number,e.log_number) AND (NVL(e.did_not_air_ind,'N') = 'N' OR e.life_cycle_status = 9 OR (NVL(e.did_not_air_ind,'N') = 'Y' AND l.master_log_date IS NULL))) SQL> / SUM(A.CSED_DOLLARS) --- 123 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=13 Card=1 Bytes=41) 1 0 SORT (AGGREGATE) 2 1 VIEW (Cost=13 Card=1 Bytes=41) 3 2 FILTER 4 3 SORT (GROUP BY) (Cost=13 Card=1 Bytes=42) 5 4 HASH JOIN (Cost=11 Card=1 Bytes=42) 6 5 INDEX (RANGE SCAN) OF 'CSED_PRIM' (UNIQUE) (Cost=2 Card=12 Bytes=192) 7 5 TABLE ACCESS (BY INDEX ROWID) OF 'CLIENT_SUPPLIED_EP_DOLLARS' (Cost=8 Card=12 Bytes=312) 8 7 INDEX (RANGE SCAN) OF 'CSED_PRIM' (UNIQUE) (Cost=2 Card=1) SQL> spool off end And --- this works -- select SUM(a.csed_dollars) FROM client_supplied_ep_dollars a WHERE a.csed_pob_id = 213841 AND a.csed_date = (SELECT MAX(b.csed_date) FROM client_supplied_ep_dollars b WHERE b.csed_ep_number = a.csed_ep_number AND b.csed_pob_id = a.csed_pob_id group by 1) -- this group by fixes the query ... AND EXISTS (SELECT 'x' FROM v_log_master l, episode_airings e, units u WHERE u.ut_ea_ep_number = a.csed_ep_number AND u.ut_pob_id = a.csed_
RE: SNP acronym?
Title: SNP acronym? It's the oracle job queue processes... The following is an educated guess... If I'm wrong I'm sure someone will correct me... :-) I think SNP originally stood for snapshot job... When Oracle introduced snapshots, they needed a mechanism to schedule and run snapshot refreshes... Hence the SNP background processes... Then someone at Oracle decided they could externalize this mechanism and DBMS_JOB was born... Can anyone confirm (or crush) the theory? Tim -Original Message-From: Markham, Richard [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 17, 2002 5:29 PMTo: Multiple recipients of list ORACLE-LSubject: SNP acronym? What does the background job queue acronym SNP stand for ?
RE: CodeNotes for Oracle9i... Destress on the way home!...OT
t > >decade... > > > >So far, I have only talked about the tech side of things here - > there > >are many dangers and negative side effects to the personal and > societal > > >aspects. More of that later! > > > >Slightly crazy today, aren't I? > >John > ><< WINMAIL.DAT >> > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Kanagaraj > 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.com > -- > Author: DENNIS WILLIAMS > 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.com > -- > Author: Grabowy, Chris > 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.com > -- > Author: Fink, Dan > 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 > === message truncated === __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.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 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.com -- Author: Fink, Dan 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.com -- Author: Johnston, Tim 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: How to fix ORA-03113 error
Did you read Note:1069812.6 on Metalink yet? Tim -Original Message- Sent: Tuesday, October 15, 2002 11:54 AM To: Multiple recipients of list ORACLE-L I have oracle8.0.5 running on Solaris8. Here's trace file. I don't think there is problem with I/O. How do I recover this error? $more ssdb_lgwr_272.trc Dump file /export/home/oracle/product/8.0.5/rdbms/log/ssdb_lgwr_272.trc Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production PL/SQL Release 8.0.5.2.0 - Production ORACLE_HOME = /export/home/oracle/product/8.0.5 System name:SunOS Node name: plab1 Release:5.8 Version:Generic_108528-03 Machine:sun4u Instance name: SSDB Redo thread mounted by this instance: 1 Oracle process number: 4 Unix process pid: 272, image: ora_lgwr_SSDB *** SESSION ID:(3.1) 2002.10.13.02.19.02.000 error 204 detected in background process -Original Message- Sent: Monday, October 14, 2002 7:58 PM To: Multiple recipients of list ORACLE-L Your instance crashed because the lgwr died... There should be a trace file for lgwr in the bdump directory... What does it say in the trace file? Are you having any filesystem issues? The "LGWR: terminating instance due to error 204" means that there is an I/O error when accessing the controlfile... What version is your database... What O/S are you on... etc... There seems to be some known bugs in this area... Check Note:1069812.6 on Metalink... Tim -Original Message- Sent: Monday, October 14, 2002 8:19 PM To: Multiple recipients of list ORACLE-L I could not start database due to ORA-03113 error, someone please advise what it means and how to fix it ASAP. I really appreciate your help. Thanks, David SVRMGR> startup ORACLE instance started. Total System Global Area285236752 bytes Fixed Size 48656 bytes Variable Size75390976 bytes Database Buffers209715200 bytes Redo Buffers81920 bytes Database mounted. ORA-03113: end-of-file on communication channel ***Alert.log: Mon Oct 14 17:57:27 2002 Database mounted in Exclusive Mode. Completed: alter database mount Mon Oct 14 17:57:27 2002 alter database open Picked broadcast on commit scheme to generate SCNs Mon Oct 14 17:57:27 2002 Rolling back half complete log switch of thread 1 LGWR: terminating instance due to error 204 Instance terminated by LGWR, pid = 483 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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.com -- Author: Johnston, Tim 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.com -- Author: Nguyen, David M 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 of
RE: to_char(sysdate) problem on 8.1.7.
17182 is a heap corruption issue... Is this only occurring on one box? Are you having any OS memory issues? I'd open an iTar and work through it with support... -Original Message- Sent: Tuesday, October 15, 2002 5:03 AM To: Multiple recipients of list ORACLE-L hi! 8.1.7. on WIN: due to a bug - it seems - the following query returns an error: SQL> SELECT TO_CHAR(SYSDATE, 'dd.mm.') from dual; SELECT TO_CHAR(SYSDATE, 'dd.mm.') from dual * ERROR at line 1: ORA-00600: internal error code, arguments: [17182], [538241312], [], [], [], [], [], [] while it works fine on 8.0.5. and 8.1.6.! does anyone know a way to change the query, so it will work on all version and there is no need for a patch? tia & regards daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser 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.com -- Author: Johnston, Tim 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: How to fix ORA-03113 error
Your instance crashed because the lgwr died... There should be a trace file for lgwr in the bdump directory... What does it say in the trace file? Are you having any filesystem issues? The "LGWR: terminating instance due to error 204" means that there is an I/O error when accessing the controlfile... What version is your database... What O/S are you on... etc... There seems to be some known bugs in this area... Check Note:1069812.6 on Metalink... Tim -Original Message- Sent: Monday, October 14, 2002 8:19 PM To: Multiple recipients of list ORACLE-L I could not start database due to ORA-03113 error, someone please advise what it means and how to fix it ASAP. I really appreciate your help. Thanks, David SVRMGR> startup ORACLE instance started. Total System Global Area285236752 bytes Fixed Size 48656 bytes Variable Size75390976 bytes Database Buffers209715200 bytes Redo Buffers81920 bytes Database mounted. ORA-03113: end-of-file on communication channel ***Alert.log: Mon Oct 14 17:57:27 2002 Database mounted in Exclusive Mode. Completed: alter database mount Mon Oct 14 17:57:27 2002 alter database open Picked broadcast on commit scheme to generate SCNs Mon Oct 14 17:57:27 2002 Rolling back half complete log switch of thread 1 LGWR: terminating instance due to error 204 Instance terminated by LGWR, pid = 483 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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.com -- Author: Johnston, Tim 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: interview question ???
Seems in line to me... There is a big difference between "Help me with this problem at my current job" and "Help get this job that I'm not qualified for"... Tim -Original Message- Sent: Monday, October 14, 2002 6:29 PM To: Multiple recipients of list ORACLE-L Is this for a job interview? I for one, am not going to help proliferate the number of DBA's that don't know what they're doing, when there are many available that do. If I'm way out of line here, then let me know, but this sure looks like a good opportunity to recommend some RTFM. Jared Leslie Lu <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/14/2002 02:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:interview question ??? Hi, My agent asked me these couple of questions through email, can any one give me some idea? Thank you! Leslie --- What are a couple ways to detect block corruption within an oracle database? What is the wait interface? What v$view would you query to get a list of database files that need to be backed up? __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu 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.com -- 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.com -- Author: Johnston, Tim 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: How to see it?
You're right... How can I see it? -Original Message-From: hukangang [mailto:[EMAIL PROTECTED]]Sent: Friday, October 11, 2002 3:38 AMTo: Multiple recipients of list ORACLE-LSubject: How to see it?
RE: Thanks - Oracle list for developers ??
"Thanks to all who responded helpfully. SY." ^^ Hey Scott, I think he was excluding you... :-) -Original Message- Sent: Friday, October 11, 2002 8:34 AM To: Multiple recipients of list ORACLE-L Thanks to all who responded helpfully. SY. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 7:08 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject:Re: Oracle list for developers ?? Importance: High Harry, Check into ODTUG. http://www.odtug.com/web_members/mbrsonly_signup.asp Jared "Droogendyk, Harry" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/10/2002 03:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Oracle list for developers ?? Listers: While I certainly appreciate the great range of experience and knowledge by the subscribers on this list, if my rudimentary knowledge is to be trusted, I think 95% of the postings are DBA type stuff. Since I'm interested in developer questions / answers I'm asking, again!!, if an Oracle list exists that is developer oriented rather than DBA oriented. TIA for your answers. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Droogendyk, Harry 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.com -- Author: Droogendyk, Harry 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.com -- Author: Johnston, Tim 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: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB
Title: Message Looks like your stuck... Maybe someone else can help... Good luck... Doc ID: Note:148894.1 Subject: ALERT: Problems with Datafile AUTOEXTEND/RESIZE on Oracle8i on NT/2000 Platforms Type: ALERT Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 07-JUN-2001 Last Revision Date: 25-JUL-2002Problems with Datafile AUTOEXTEND/RESIZE on Oracle8i on NT/2000 Platforms ~ Change Record ~~ 27-Dec-01: The fix release in the Patches section of this alert was modified from 8.1.7.2 to 8.1.7.3. Versions Affected ~ The problems described here can affect releases 8.1.6 and 8.1.7. Platforms Affected ~~ The problems affect Oracle8i releases on Windows NT and Windows 2000. Description ~~~ Releases of Oracle8i on Windows NT and Windows 2000 platforms can exhibitserious problems when a datafile autoextends or is resized onto a 4GBboundary (e.g. 4GB, 8GB).When a datafile has been configured such that it will autoextend onto a 4GB boundary, any attempt to autoextend: a. when in noarchive log mode it causes the database to crash b. when in archive log mode the file is marked offline in V$RECOVER_FILEWhen not in archive log mode, it is safe to restart the database andcontinue, altering datafiles to autoextend onto different boundaries asap.NOTE: It may be necessary to stop and restart the OracleService itself.The only way to recover this file when in archive log mode is to restorethe whole database and roll forward to a point before the file autoextended.Likelihood of Occurrence It is highly likely that problems will be encountered if an attempt is made to autoextend or resize a datafile onto a 4Gb boundary. Possible Symptoms ~ The possible symptoms from this problem are:a. The database crashes (when in noarchive log mode) and the alert fileand database writer (DBW0) trace file report: KCF: write/open error block=0xX online=Yfile=N '..'error=27069 txt: 'OSD-4026: Invalid parameter passed. (OS-204802)'b. The file is marked offline in V$RECOVER_FILE and access to the databasecontinues. The following error appears in the alert.log: KCF: write/open error block=0xX online=Yfile=N '..'error=27069 txt: 'OSD-4026: Invalid parameter passed. (OS-204802)' Automatic datafile offline due to write error on file N: '..' Workaround ~~ The only safe workaround at present is to ensure that no file is resized orcreated to autoextend onto a 4Gb boundary. This is best achieved by makingsure all datafiles have AUTOEXTEND disabled.It is advisable to read the article below which describes potentialissues using files of 2Gb or larger in size as this may influence the maximum datafile size you choose to use. Patches ~~~A fix is now available in 8.1.7.1.4 and will be included in8.1.7.3 References ~~ 2Gb or not 2Gb - File limits in Oracle[NOTE:62427.1] Base bug reporting this problem [BUG:1668488] -Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 10, 2002 11:08 AMTo: Multiple recipients of list ORACLE-LSubject: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB Hello all HELP - and I am not an idiot. Oracle 8.1.6.3.4 on NT. We have a problem that the datafile for the application tables autoextended from 3.9 GB to 4.1 GB. We are getting ora-01115 errors and the datafile is offline. We tried export but it gets the same error. The status now is that the datafile is offline. Alter datafile online needs recovery. Recovery gets I/O error and aborts. Anybody knows how to get the data out? As per Murphy's law, the last full backup of the database ran about 2 weeks ago and nobody noticed that the backup job ended ok but without backing up the files. So recovery means restoring from 2 weeks ago and applying archive logs for some hours. Oracle support are sending someone with a utility that MAY save the day. Any ideas ??? HELP Yechiel AdarMehish
FW: Oracle Security Alerts #42, 43 and 44 Issued October 4, 2002
I just had to laugh... Look at the bottom... -Original Message- Sent: Saturday, October 05, 2002 1:55 PM To: [EMAIL PROTECTED] THIS E-MAIL IS A CRITICAL TECHNICAL ALERT WHICH IS BEING SENT AS A SERVICE TO ALL METALINK USERS! The Oracle Security Product Management team has published the following alerts on MetaLink: Oracle Security Alert #42 Dated: 04 October 2002 Security vulnerability in Oracle Net Services (Document ID number 213411.1) Oracle Security Alert #43 Dated: 04 October 2002 Severity: 3 Oracle9i Application Server - Web Cache Administration Tool Crash on malformed request (Document ID number 213413.1) Oracle Security Alert #44 Dated: 04 October 2002 Severity: 1 Unauthorized Access Vulnerability in the Oracle E-Business Suite, Release 11i (Document ID number 213415.1) To view the alerts, log on MetaLink at http://metalink.oracle.com and refer to the My Headlines page. A News & Notes document containing the alerts has been published on the My Headlines page entitled "Oracle Security Alerts #42, 43 and 44 Issued October 4, 2002". Thank you! The Oracle Support Tea -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnston, Tim 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: Changing the Staus of a Database to Read Only
Exactly... I had to face this at my current job... I have a separate alter to read only job... Basically, it is a script that calls a stored procedure... I put the script in cron to run every 12 hours... The stored procedure alters eligible tablespaces to read only (eligible as defined by the product)... If an alter to read only hangs for more then 12 hours then the next alter to read only sends a messages (i.e. email or trap) to let you know the condition exists... If there are no tablespaces to alter then the procedure simply exits... And, since it is async then it really doesn't matter if it hangs since it won't hold anything else up... The only problem is that is the database crashes while the file is pending read only, the file needs media recovery on restart... Tim -Original Message- Sent: Friday, September 27, 2002 3:24 PM To: Multiple recipients of list ORACLE-L Thanks. I believe that's how it works on 8.1.6 as well. Of course if someone has walked away without committing a transaction then one is still stuck. There is also the problem of distributed queries. If on database A, one selects from @B. An entry is made into the transaction table on database A. That transaction entry will stay until the session on A which issued the distributed query commits. I can almost guarantee that at least one user will have failed to commit when it comes to changing a tablespace to read only, and that user will be unreachable. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, September 27, 2002 11:03 AM To: Multiple recipients of list ORACLE-L Hi Ian... I can tell you how it works in 8.1.7... You can alter a tablespace to read only with transactions in the database and the steps are as follows: You issue the alter to read only command and it will wait for EVERY transaction in the database that started BEFORE you issued the command to finish before the alter is completed. Any transaction that starts after you issue the command is cleanly handled. If it is on the tablespace you are attempting to alter it will fail. If it is on another tablespace it will not have impact on your alter command. i.e. Trans 1 on Tablespace X Trans 2 on Tablespace Y Alter Tablespace Y to read only ( it waits ) End Trans 2 Notice Alter is still waiting Attempt to start Trans 3 on Tablespace Y ( You will get an error ) Start Trans 4 on Tablespace X End Trans 1 Notice Alter completes HTH Tim -Original Message- Sent: Friday, September 27, 2002 1:09 PM To: Multiple recipients of list ORACLE-L I tried to post this in response to the "Best Practices" thread, but for unkown reasons it didn't seem to make it. My apologies if this is a repeat. It had been stated that placing each partition in a separate tablespace allowed one to make a tablespace read only once that partition would no longer be used for insert/update/delete operations. I have not tried to switch a database from online to read only after 8.1.6, but as of that release doing so was difficult in an active database. Oracle required not only that there be no active transactions against the tablspace to be converted but no such transactions against the entire database. If this has changed, when did it happen? We have a system where the ability to make a tablespace read only while the database is actively processing transactions bound for other tablespaces would be extremely useful. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- 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 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.com -- Author: Johnston, Tim 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.com --
RE: Changing the Staus of a Database to Read Only
Hi Ian... I can tell you how it works in 8.1.7... You can alter a tablespace to read only with transactions in the database and the steps are as follows: You issue the alter to read only command and it will wait for EVERY transaction in the database that started BEFORE you issued the command to finish before the alter is completed. Any transaction that starts after you issue the command is cleanly handled. If it is on the tablespace you are attempting to alter it will fail. If it is on another tablespace it will not have impact on your alter command. i.e. Trans 1 on Tablespace X Trans 2 on Tablespace Y Alter Tablespace Y to read only ( it waits ) End Trans 2 Notice Alter is still waiting Attempt to start Trans 3 on Tablespace Y ( You will get an error ) Start Trans 4 on Tablespace X End Trans 1 Notice Alter completes HTH Tim -Original Message- Sent: Friday, September 27, 2002 1:09 PM To: Multiple recipients of list ORACLE-L I tried to post this in response to the "Best Practices" thread, but for unkown reasons it didn't seem to make it. My apologies if this is a repeat. It had been stated that placing each partition in a separate tablespace allowed one to make a tablespace read only once that partition would no longer be used for insert/update/delete operations. I have not tried to switch a database from online to read only after 8.1.6, but as of that release doing so was difficult in an active database. Oracle required not only that there be no active transactions against the tablspace to be converted but no such transactions against the entire database. If this has changed, when did it happen? We have a system where the ability to make a tablespace read only while the database is actively processing transactions bound for other tablespaces would be extremely useful. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- 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 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.com -- Author: Johnston, Tim 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: Another datafile sizing question
Is there a reason you can't just resize the existing file? -Original Message- Sent: Wednesday, September 25, 2002 7:43 PM To: Multiple recipients of list ORACLE-L I am in the process of upgrading our databases from 8.0.5 to 8.1.7, possibly 9i depending on application certifications. I currently have a tablespace that is made up of 4 - 200mb datafiles, my first thought would be to create a 800mb datafile and move all the data into it, The growth of this tablespace is maybe 100 to 150Mb a year, and from what I understand all datafiles should be the same size. So at that point when I need another datafile, I will have to create another 800Mb datafile. Would that be a good practise, or should I stay with multiple 200/300/400/500 etc datafiles ? Thanks Darren -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren 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.com -- Author: Johnston, Tim 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: Why does my insert creates so many logs?
What version? What is the definition of table A? Have you enabled parallel DML? What about the append hint? According to the docs it is supposed to be automatic with the parallel hint but... Tim -Original Message- Sent: Wednesday, September 18, 2002 3:39 PM To: Multiple recipients of list ORACLE-L Hi. A developer of mine is running a large insert as select: insert /* parallel hint */ into table A nologging (select * from table b where ...); There are no indices on table A and a PK disabled. Still that insert generates a large amount of logs. What could be the reason for that? Any ideas? Table A is not partitioned and has NOLOGGING attribute on the dba_tables set to Yes. thanks Gene __ Do you Yahoo!? Yahoo! News - Today's headlines http://news.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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.com -- Author: Johnston, Tim 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: Unable to Drop Package
Looks like it's data dictionary issue... I think that there are entries in dependency$ that will need to be cleaned up... Talk to support and mention Notes 47424.1 and 1015751.102 (there are references to this on metalink but I can't find the notes)... They should be able to help you clean it up... Tim -Original Message- Sent: Wednesday, September 18, 2002 6:13 AM To: Multiple recipients of list ORACLE-L Hi Everybody, I have created two Package Pkg1 and Pkg2 Inside Pkg1, I have defined PL/SQL Table Data Type Type Pkg1_DataType IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER; Inside Pkg2, I have defined Type Type Pkg2_DataType IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER; Now I am referring Pkg2_DataType in Pkg1 and Pkg1_DataType in Pkg2 Some how both of package got Invalid. Now I am unable to compile or drop either of Packages. Drop Package Pkg1 Error at line 1: Ora-00600: Internal Error Code, arguments:[4882],[154632684],[167717428],[154509328],[],[],[],[] At least I want to drop the package, So that I can rewrite everything from scratch. Can anybody help to resolve this problem. Thanks Suman DISCLAIMER: Information contained and transmitted by this E-MAIL is proprietary to Mascot Systems Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail & notify us immediately at [EMAIL PROTECTED] Before opening attachments, please scan for viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suman S K 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.com -- Author: Johnston, Tim 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: ALTER TABLE MOVE command causes table to grow
What is the DEGREE setting on the table? -Original Message- Sent: Monday, September 09, 2002 4:48 PM To: Multiple recipients of list ORACLE-L alter table email_request_queue move tablespace ts_email_request storage (initial 25m next 25m pctincrease 0); -Original Message- Sent: Monday, September 09, 2002 1:54 PM To: Multiple recipients of list ORACLE-L How did you perform the move? Was the operation done in parallel? -Original Message- Sent: Friday, September 06, 2002 4:13 PM To: Multiple recipients of list ORACLE-L No LOBS. Here's the definition: REQUEST_IDNOT NULL NUMBER PROFILE_IDNOT NULL NUMBER ACCOUNT_IDNOT NULL NUMBER TEMPLATE_ID NOT NULL NUMBER GENERIC_DIFFERENTIATORNOT NULL NUMBER REQUEST_TYPE NOT NULL CHAR(1) ACCOUNT_NONOT NULL CHAR(8) EFFECTIVE_DATENOT NULL DATE EMAIL_ADDRESS NOT NULL VARCHAR2(100) EMAIL_SUBJECT NOT NULL VARCHAR2(100) EMAIL_BODYNOT NULL VARCHAR2(4000) STATUSNOT NULL CHAR(1) STATUS_CHANGE_DATENOT NULL DATE TWEED_SERVER_IDNUMBER TWEED_PACKAGE_PRIORITY NUMBER TWEED_SENDER_ACCOUNT NOT NULL VARCHAR2(50) TWEED_SCHEDULED_DELIVERY_DATE NOT NULL DATE TWEED_CUSTOMER_URLNOT NULL VARCHAR2(255) SENDER_SERVER_ID NUMBER SENDER_INSTANCE_ID NUMBER CREATE_DATE NOT NULL DATE CREATE_USER NOT NULL VARCHAR2(35) UPDATE_DATEDATE UPDATE_USERVARCHAR2(35) -Original Message- Sent: Thursday, September 05, 2002 5:23 PM To: Multiple recipients of list ORACLE-L What the table definition? Are there any LOB's on it? -Original Message- Sent: Thursday, September 05, 2002 2:43 PM To: Multiple recipients of list ORACLE-L pct increase is 0 (uniform sizing) -Original Message- Sent: Thursday, September 05, 2002 2:00 PM To: Multiple recipients of list ORACLE-L you didn't mention the PCT_INCREASE of this segment. -Original Message- <mailto:[EMAIL PROTECTED]> ] Sent: Thursday, September 05, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Had an annoying surprise last week. A table had grown unexpectedly large and I scheduled a time over the weekend to move it to its own tablespace from my "medium" tablespace. The table ended up growing 50%. I had anticipated it might grow somewhat given the PCTFREE of 10% but freeing up that space in the blocks should, at most, have caused it to grow by 10% (assuming that 10% was completely full). Does anyone have ideas as to why it would have grown by so much? Indexes are in a different tablespace and the only other change was from an extent size of 4 meg to one of 25 meg. Both are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: Miller, Jay 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: Miller, Jay 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: Johnston, Tim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Ca
RE: ALTER TABLE MOVE command causes table to grow
How did you perform the move? Was the operation done in parallel? -Original Message- Sent: Friday, September 06, 2002 4:13 PM To: Multiple recipients of list ORACLE-L No LOBS. Here's the definition: REQUEST_IDNOT NULL NUMBER PROFILE_IDNOT NULL NUMBER ACCOUNT_IDNOT NULL NUMBER TEMPLATE_ID NOT NULL NUMBER GENERIC_DIFFERENTIATORNOT NULL NUMBER REQUEST_TYPE NOT NULL CHAR(1) ACCOUNT_NONOT NULL CHAR(8) EFFECTIVE_DATENOT NULL DATE EMAIL_ADDRESS NOT NULL VARCHAR2(100) EMAIL_SUBJECT NOT NULL VARCHAR2(100) EMAIL_BODYNOT NULL VARCHAR2(4000) STATUSNOT NULL CHAR(1) STATUS_CHANGE_DATENOT NULL DATE TWEED_SERVER_IDNUMBER TWEED_PACKAGE_PRIORITY NUMBER TWEED_SENDER_ACCOUNT NOT NULL VARCHAR2(50) TWEED_SCHEDULED_DELIVERY_DATE NOT NULL DATE TWEED_CUSTOMER_URLNOT NULL VARCHAR2(255) SENDER_SERVER_ID NUMBER SENDER_INSTANCE_ID NUMBER CREATE_DATE NOT NULL DATE CREATE_USER NOT NULL VARCHAR2(35) UPDATE_DATEDATE UPDATE_USERVARCHAR2(35) -Original Message- Sent: Thursday, September 05, 2002 5:23 PM To: Multiple recipients of list ORACLE-L What the table definition? Are there any LOB's on it? -Original Message- Sent: Thursday, September 05, 2002 2:43 PM To: Multiple recipients of list ORACLE-L pct increase is 0 (uniform sizing) -Original Message- Sent: Thursday, September 05, 2002 2:00 PM To: Multiple recipients of list ORACLE-L you didn't mention the PCT_INCREASE of this segment. -Original Message- <mailto:[EMAIL PROTECTED]> ] Sent: Thursday, September 05, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Had an annoying surprise last week. A table had grown unexpectedly large and I scheduled a time over the weekend to move it to its own tablespace from my "medium" tablespace. The table ended up growing 50%. I had anticipated it might grow somewhat given the PCTFREE of 10% but freeing up that space in the blocks should, at most, have caused it to grow by 10% (assuming that 10% was completely full). Does anyone have ideas as to why it would have grown by so much? Indexes are in a different tablespace and the only other change was from an extent size of 4 meg to one of 25 meg. Both are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: Miller, Jay 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: Miller, Jay 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: Johnston, Tim 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
RE: ALTER TABLE MOVE command causes table to grow
What the table definition? Are there any LOB's on it? -Original Message- Sent: Thursday, September 05, 2002 2:43 PM To: Multiple recipients of list ORACLE-L pct increase is 0 (uniform sizing) -Original Message- Sent: Thursday, September 05, 2002 2:00 PM To: Multiple recipients of list ORACLE-L you didn't mention the PCT_INCREASE of this segment. -Original Message- <mailto:[EMAIL PROTECTED]> ] Sent: Thursday, September 05, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Had an annoying surprise last week. A table had grown unexpectedly large and I scheduled a time over the weekend to move it to its own tablespace from my "medium" tablespace. The table ended up growing 50%. I had anticipated it might grow somewhat given the PCTFREE of 10% but freeing up that space in the blocks should, at most, have caused it to grow by 10% (assuming that 10% was completely full). Does anyone have ideas as to why it would have grown by so much? Indexes are in a different tablespace and the only other change was from an extent size of 4 meg to one of 25 meg. Both are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: Miller, Jay 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: Miller, Jay 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: Johnston, Tim 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: PL/SQL Editor
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 no longer need to punish, deceive, or compromise myself, unless I want to stay employed. _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade 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: Philip Douglass 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: 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: Johnston, Tim 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: creating raw devices on AIX
For the Admin Reference, check... http://docs.oracle.com/a87054/0/unixdoc/product_0/index.htm Tim -Original Message- Sent: Wednesday, July 03, 2002 11:22 AM To: Multiple recipients of list ORACLE-L Where can I find info on this? The documentation refers me to the "Oracle 8i Administrators refence for AIX" but I cannot find it on-line -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: Johnston, Tim 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 DBA Needed in Minnesota..
Hey look... It's the Mayo Clinic job again... I never knew Bill was into recycling... Oracle Data Base Administer Job Posting Number: 01-0004509 Openings: 1 Section: MIS/Managed Care Job Class: 6115 Job Summary: This position includes support of all aspects of the Oracle relational database product (ASE) on primarily SUN Unix platforms. Tasks will include, but are not limited to: capacity planning, installation, upgrading, monitoring, performance and tuning, responding to trouble calls, writing administrative scripts in Unix shell languages and SQL/PL-SQL, backup and recovery, and maintaining security in the institution`s Oracle environments. Sharing a 24x7 on-call rotation with the other members of the team is also expected. Qualifications: Bachelor`s degree in computer science, or related field. Three or more years of supporting a multi-server Oracle environment. Strong analytical and problem solving skills. Demonstrated proficiency with the HP or SUN Unix operating system. Benefit Eligibility: Benefit Eligible Posting Begin Date: 10/31/2001 Posting End Date: Until Filled Employment Type: Exempt Hours/2-Weeks: 80 Percent Full Time Employment: 100% Schedule: Mon-Fri Shift: Day Weekends: 0 Out of 0 Location: Ozmun Center Floor: 1 Approx Min Hourly Salary: Salaried * Staffing Contact: Wilson, Cheryl A *Education, experience, and tenure are considered along with internal equity when job offers are extended. -Original Message- Sent: Wednesday, June 05, 2002 10:59 AM To: Multiple recipients of list ORACLE-L Position: Oracle DBA Location: Rochester, Minnesota Salary Range: 65-75K- maybe more Description: This client company-a leader in its' field, needs an Oracle DBA to provide database support. This position includes support of all aspects of the Oracle relational database product (ASE) on primarily SUN Unix platforms. The key is depth of production database experience (as opposed to development), knowledge of core Oracle infrastructure and the pieces that make up the instances. Tasks will include, but are not limited to: capacity planning, installation, upgrading, monitoring, performance and tuning, responding to trouble calls, writing administrative scripts in Unix shell languages and SQL/PL-SQL, backup and recovery, and maintaining security in the institution's Oracle environments. Sharing a 24x7 on-call rotation with the other members of the team is also expected. This is an interesting position with a solid organization with terrific benefits. *They need a Production DBA not an Development side DBA. This is a full time staff position so no sub-contractors or third parties please. Please do not call or send a resume if you are not in the U.S. and/or need sponsorship. * Please DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes cannot be considered. If you are employed by a consulting company you must have a long term project history. Requirements: *Bachelor's degree in computer science, related field or equivalent experience. *Three or more years of supporting a multi-server Oracle environment. *Strong analytical and problem solving skills. *Demonstrated proficiency with the HP or SUN Unix operating system. *Advanced Replication experience is a plus. * Must be a U.S. citizen or perm. resident with excellent English. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Phone: 1-800-549-8502. (*Please do not call if you need sponsorship) Please Use Job Code: One/DBA/Rochester/Diane I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: Johnston, Tim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051
RE: ORA-32255
Hi Stephane... I looked on metalink and saw some references to this error... And almost all of them are on DEC Unix... http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=BUG&p_id=765763 Is a decent start... But, there are several bugs about this... The above bug seems to suggest that the error is on the client side in how the first row was handled... HTH Tim -Original Message- Sent: Thursday, April 25, 2002 5:20 PM To: Multiple recipients of list ORACLE-L Has anybody any clue about this, encountered on Tru64 5.x with Oracle 8.1.7 (I believe). I searched Google for it, and found Perl:DBI threads about it, but no answer (in my case, it's caused by an OCI program). Doesn't seem to be in message files (oerr returns nothing, neither with 8.1.7 nor 9i). Baffled. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Johnston, Tim 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: Production Oracle DBA Needed in Rochester, Minnesota
LP 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: Johnston, Tim 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: Intersystems Cache database
I've heard of them... Some guys at the last place I was at had used it as the back end for a lab results viewer at a hospital in the Boston area... They loved it... They kept telling me how great it was but I never saw it in action... I took most of it with a grain of salt since they were developers... As far as the 4 million users go... If you consider each hospital employee a "user"... Of better yet, each patient a "user"... :-) -Original Message- Sent: Thursday, March 21, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Anyone else ever hear about them? According to the web site that have '4 million users'. Seems that would have left a mark somewhere at that level. Dick Goulet Reply Separator Author: "Jesse; Rich" <[EMAIL PROTECTED]> Date: 3/21/2002 1:58 PM Yeah, like that ain't a plug from someone acting like an Oracle DBA. 1) No signature. 2) Generic e-mail account from a generic mail domain. 3) No recent posts to this list. Probably just a Cache salesman... Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, March 21, 2002 3:23 PM To: Multiple recipients of list ORACLE-L Hi, Does anyone know about the Cache database? Is it REALLY that robust as they claim to be? http://cache.intersys.com/cache/fb/fb_03.html Thanks. -- 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: 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: Johnston, Tim 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: Rebuilding Index Organised Tables (IOTs)
You can do a "ALTER TABLE MOVE" if you have 8i or >... Check the docs for more details... http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a85397/statem2a. htm#2055687 HTH Tim -Original Message- Sent: Wednesday, March 20, 2002 4:15 PM To: Multiple recipients of list ORACLE-L Kumanan, If you mean via the "alter index rebuild" command, NO. Via other methods, YES. Exp/Imp works. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 3/20/2002 12:50 PM Is that possible? Thanks Kumanan -- 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: 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: Johnston, Tim 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 Hungry for Money
n the world were mistaken on this. The height of this > misunderstanding was a two to three years ago. I expect there were > hundreds perhaps thousands of sites who have installed partitioning > without a license because they believed it to be free. > > Ian MacGregor > Stanford Linear Accelerator Center > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Conboy, Jim > 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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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: Johnston, Tim 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 Hungry for Money
Nope... But, you need Enterprise in order to buy the partitioning option... i.e. You can't buy the partitioning option for standard edition... The partitioning option is an extra cost item (list price is an extra $10,000 a CPU)... Just because it's on the Enterprise Edition CD doesn't mean that's it's legal for you to use it... Tim -Original Message- Sent: Wednesday, March 13, 2002 3:12 PM To: Multiple recipients of list ORACLE-L Scott, We also have a higher ed site liscense, isn't partitioning included in the "Enterprise Edition"??? ...JIM... >>> [EMAIL PROTECTED] 3/13/02 1:02:33 PM >>> Watch out! I just got off the phone with our Oracle "sales rep". He was asking me if I needed information on Partitioning or OLAP for our data warehouse project. I told him that we are on 8.1.7, so the OLAP option isn't available. To keep him from going into a long speil on Partitioning, I told him that I have already implemented that, which is true. He jumped on that and told me that we aren't licensed for it. He followed up with sending me a quote for $23,800 to cover the fact that we are using the option, which we didn't pay for. I was always told that we have a "site" license (higher ed), and he said that our license was purchased prior to Partioning being available, so that doesn't count. I'm telling everyone about this as a heads-up. It appears that Oracle is digging for money, and I feel that the approach that was used was done to trick me into admitting that I had implemented the feature. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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 Howerton 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: Johnston, Tim 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: Fav. Urban Legend...
Here's one I got from a customer a few months ago... "Hints are an unacceptable hack... As long as there are statistics, The CBO will pick the best execution plan" -Original Message- Sent: Tuesday, March 12, 2002 3:43 PM To: Multiple recipients of list ORACLE-L I'm putting the final touches on my IOUG-A presentation (I got an extension for those who realize that I'm late on it!)... I'm doing Oracle Urban Legends. I've got several in my presentation but I thought I'd ask here, before I put the presentation to bed, what your favorite (or the one you find the most irritating) Oracle Urban legend was 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. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnston, Tim 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: Tangetially ON Topic... ANSI SQL and Reusing SQL to avoid har
Hi Steve, I think Stephen might be referring to the stuff mentioned in the eweek comparison that was posted earlier today... http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp "MySQL 4.0.1's new, extremely fast query cache is also quite notable, as no other database we tested had this feature. If the text of an incoming query has a byte-for-byte match with a cached query, MySQL can retrieve the results directly from the cache without compiling the query, getting locks or doing index accesses. This query caching will be effective only for tables with few updates because any table updates that clear the cache to guarantee correct results are always returned. " I found the following info on the MySQL site... http://www.mysql.com/doc/Q/u/Query_Cache.html Not really what you are looking for but it is kinda of interesting stuff... Tim -Original Message- Sent: Monday, February 25, 2002 2:37 PM To: Multiple recipients of list ORACLE-L har > MySQL uses something like a memory cache to eliminate re-parsing. I don't believe this is true... you'll have to prove it to me. :-) After a brief review of the manuals and 3rd party books I find no such mechanism in MySQL. Thanks anyway, Steve Orr -Original Message- Sent: Monday, February 25, 2002 11:33 AM To: Multiple recipients of list ORACLE-L har Steve: To my knowledge the usage of bind variables is ansi 92 compliant. DB2 (my past life) it was a requirement for proper application development. MySQL uses something like a memory cache to eliminate re-parsing. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Monday, February 25, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Subject:Tangetially ON Topic... ANSI SQL and Reusing SQL to avoid hard pa Since V7 Oracle has improved performance by limiting hard parses and implementing shareable, reuseable SQL via the shared pool. I'm curious what other database engines do to limit hard parses. Does DB2, Informix, Sybase, SQLServer, or Postgres implement shareable SQL via a "shared pool?" Of course we know that in Oracle, shareable SQL is dependent on the use of bind variables or cursor_sharing=FORCE. In that context, isn't the syntax for bind variables part of the ANSI SQL92 standard? I really need to find this out as I'm building the case for using bind variables in an ANSI SQL, multi-database development effort. TIA!!! Steve Orr Bozeman, MT -- 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: Karniotis, Stephen 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: Johnston, Tim 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
RE: Unidata DB
Ah... It looks like it related to the IBM takeover of Informix... UniData UniData is an extended-relational, ODBC-compliant database that supports repeating groups, hierarchies, and arrays. UniData offers both best-of-breed native interfaces with ActiveX, Java and C interfaces as well as industry standard interfaces such as ODBC, OLEDB, and HTTP. UniData 6.0, targeted for 2H of 2002, will include enhancements to openness, security, robustness and scalability. This release will provide a native JDBC driver as well as support for XML input and output from the database engine. Security improvements come from the added support of Secure Socket Layer (SSL) for the HTTP and Socket interfaces as well as encryption options for the U2 clients. UniData 6.0 will include real-time replication functionality as part of the core database features as well as SQL optimization and additional data type support for Microsoft tool access to UniVerse. Finally, an updated Java applet-based administration tool will allow administration of multiple U2 systems either through the included client or any Java-enabled web browser. IBM intends to continue to enhance, sell and support UniData and to fulfill Informix's intention to deliver UniData 6.0 and beyond. -Original Message- Sent: Thursday, February 14, 2002 10:34 AM To: Multiple recipients of list ORACLE-L I have not heard of it but for info you can start at http://www-4.ibm.com/software/data/u2/unidata/ Rick "KENNETH JANUSZ" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Unidata DB Sent by: root@fatcity. com 02/14/2002 08:43 AM Please respond to ORACLE-L Has anyone heard of Unidata DB. It's relational and from IBM. Thanks, Ken Janusz, CPIM -- 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: Johnston, Tim 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: Unidata DB
Um... Are you sure it's not Universal DB? AFAIK, that's really just DB2... More a marketing thing... Tim -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 14, 2002 8:44 AMTo: Multiple recipients of list ORACLE-LSubject: Unidata DB Has anyone heard of Unidata DB. It's relational and from IBM. Thanks, Ken Janusz, CPIM
RE: URGENT: need help by point in time recovery
Title: URGENT: need help by point in time recovery Hi Volker... You should be able to do this... Just make sure you use a "using backup controlfile" on your recover command... Alternatively, you could mount the database and rename the datafiles instead of recreating the controlfile... Either way, use the "using backup controlfile" in your recover command... Tim -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 13, 2002 3:32 PMTo: Multiple recipients of list ORACLE-LSubject: URGENT: need help by point in time recovery Hi list, I have a urgent problem. One of our developers has deleted all rows of a table on production database (database of a customer from us). We have a nightly cold backup and database is running in archivelog mode. On same server we have a test instance which has same structure as prod instance, only the folders are others. What I like to do is: 1. go to production and backup controlfile to trace 2. copy the cold backup (production) from last night into this test instance folders (datafiles, controlfiles...) 3. copy archive logs of production to archive log folders from test 4. startup testinstance nomaount 5. create new controlfile with backuped controlfile from trace 6. recover database until '-dd-mm hh: 7. export deleted table and import it in production database My question is, if I make a clone of a database from a nightly cold backup, can I recover the database with newer archivelogs. Or is there any other method to get my data back (I don't have a actual export of database)? TIA Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de
RE: URGENT Help on tracking unauthorized login to Oracle Database
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database The SQL reference has some information... http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a85397/state10b.htm#2059074 HTH Tim -Original Message-From: Behar, Rivaldi [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 12, 2002 12:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT Help on tracking unauthorized login to Oracle Database To track users who tried and logged into the database : SQL > audit session; I don't know in which section you can find that in the Administrator Guide. Rivaldi -Original Message-From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]]Sent: Monday, February 11, 2002 11:18 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT Help on tracking unauthorized login to Oracle Database Hi Revaldi and Joe (Testa), I went through the following Administrator's guide. Oracle8i Administrator's GuideRelease 2 (8.1.6)Part Number A76956-01 I could only see chapter 24 on 'Auditing database Use' and under that the following sub-sections. I went through these secition and could not find anything on unsuccessful login to oracle database. Could you please help me in ponting to the right chapter/section. Guidelines for Auditing Creating and Deleting the Database Audit Trail Views Managing Audit Trail Information Viewing Database Audit Trail Information Auditing Through Database Triggers Thanks, Ashoke -Original Message-From: Behar, Rivaldi [mailto:[EMAIL PROTECTED]]Sent: Friday, February 08, 2002 1:29 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT Help on tracking unauthorized login to Oracle Database Administrators guide. Chapter on auditing. Audit session. Rivaldi -Original Message- From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Joe, We referred the auditing option. My understanding is that you can track the oracle users using database auditing feature once the users are logged into the database. But my requirement is to track the users who tried to login to the database but could not login due to wrong password. For example, somebody may know the connect string for an oracle database and trying to login to the database as system user and with various combination of password. We like to know who are these users. Thanks, Ashoke -Original Message- Sent: Friday, February 08, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Database Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: >>Greetings, >> >>We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. >> >>Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. >> >>If there is no options under oracle then is there any 3rd party software for this purpose. >> >>Any help is appreciated >> >>Thanks, >>Ashoke >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa 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: Mandal, Ashoke 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 spelli
RE: Ora
select name from sys.ts$ where ts# = 3; -Original Message- Sent: Wednesday, February 06, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Hello All I got the following error: ORA-03232: unable to allocate an extent of 127 blocks from tablespace 3 How can I know what tablespace is '3'? ora816 on nt. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnston, Tim 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: Formatting of listserv messages
Um... Something must be messed up... Mine came through ok... Work email using Outlook/Exchange... I just looked at the fatcity history page for this messages and there is a bunch of tags in the message... But, it is formatted... Using IE5.5 at least... Tim -Original Message- Sent: Saturday, February 02, 2002 11:50 AM To: Multiple recipients of list ORACLE-L Naveen and others, Does this email appear to be completely unformatted to anyone else? Just wondering if it was formatted when sent, or if this happened along the way, or is it just me? I'm not likely to respond to something this difficult to read, and I'm just wondering if there's a remedy to this. I've noticed at times that I may send a carefully formatted post only to have it appear rather messy on the list. This most often happens to email I send from work using Lotus Notes. Here at home I use KDE Kmail, which is much easier to configure than Lotus. Sorry for the intrusion, but this appeared to be an interesting topic, and it's rather tedious to format these so I can read them. I can't be the only one that recieves mail looking like this. Thanks, Jared On Saturday 02 February 2002 02:50, Naveen Nahata wrote: > Type - - CDL_CDL_ID > NOT NULL NUMBER(10) DESCRIPTION NOT NULL > VARCHAR2(50) DOCUMENT_LINE NOT NULL NUMBER(2) DATE_RECEIVED > NOT NULL DATE DATE_RETURNED DATE > INSERTED_BY NOT NULL VARCHAR2(30) INSERT_DATE > NOT NULL DATE LAST_CHANGED_BY NOT NULL VARCHAR2(30) > LAST_CHANGE_DATE NOT NULL DATEDESCRIPTION column will have > relatively few distinct values compared to the number of rows so a Bitmap > Index will be considered.Following are the 3 queries which immediately come > to my mind ...Query 1:SELECT DISTINCT cdl.description FROM cdl_documents > cdl WHERE description NOT IN (SELECT description FROM > cdl_documents WHERE cdl_cdl_id = 5);Query 2:SELECT DISTINCT > cdl.description FROM cdl_documents cdl WHERE NOT EXISTS (SELECT 1 > FROM cdl_documentsWHERE cdl_cdl_id = 5 AND cdl.description = > description);Query 3:SELECT DISTINCT description FROM > cdl_documentsMINUSSELECT DISTINCT description FROM cdl_documents WHERE > cdl_cdl_id = 5;One more thing -It is generally not advisable to use a NOT > IN or NOT EQUAL TO clause for an indexed column bcoz the optimizer will go > for FULL TABLE SCAN rather than INDEX SCAN. But what if i have a Bitmap > Index? Will an INDEX SCAN still be avoided? If yes, why?Regards, Naveen > > > - > Do You Yahoo!? > Yahoo! Auctions Great stuff seeking new owners! Bid now! Content-Type: text/html; charset="us-ascii"; name="Attachment: 1" Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Johnston, Tim 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: ALTER ROLLBACK SEGMENT rbs SHRINK
You are completely correct... I read his original questions as "Can a shrink cause a ORA-1555"... Not "Will a shrink cause a ORA-1555"... A shrink CAN cause a ORA-1555 in the correct set of circumstances... A shrink WILL NOT always cause a ORA-1555... Sorry Tim -Original Message- Sent: Friday, February 01, 2002 8:00 AM To: Multiple recipients of list ORACLE-L but the rollback segment could be shrunk to optimal in the course of Oracle going about its business in the database (say another user is assigned to that rollback segment and needs to extend, Oracle will first shrink it before extending). and if no one is accessing the data in the rollback segment that is being shrunk then it won't cause an ora-1555 at all. so you can't really say that a shrink will cause an ora-1555. There's more to the cause of the ora-1555 than just shrinking the rollback segment --- "Johnston, Tim" <[EMAIL PROTECTED]> wrote: > Can what cause a ORA-1555? A shrink? If that is the question... > The > answer is yes... > > Tim > > -Original Message- > Sent: Thursday, January 31, 2002 11:00 PM > To: Multiple recipients of list ORACLE-L > > > Will this cause ora 1555 ? > > -Original Message- > Tim > Sent: 31 January 2002 03:31 > To: Multiple recipients of list ORACLE-L > > > Um... Must be version differences... Here is a test case I ran on > my > 8.1.7.3 machine... > > SQL> create public rollback segment tim tablespace rbs storage ( > initial 1M > next 1M minextents 20 maxextents 100 optimal 20M ); > > Rollback segment created. > > SQL> alter rollback segment tim online; > > Rollback segment altered. > > SQL> select segment_name, min_extents, initial_extent, next_extent > 2from dba_segments > 3 where segment_name = 'TIM'; > > SEGMENT_NAME MIN_EXTENTS INITIAL_EXTENT NEXT_EXTENT > -- --- -- --- > TIM 201048576 1048576 > > SQL> select rs.extents, rs.rssize/1048576 , rs.optsize/1048576 > 2from dba_rollback_segs drs, > 3 v$rollstat rs > 4 where drs.segment_name = 'TIM' > 5 and drs.segment_id = rs.usn; > >EXTENTS RS.RSSIZE/1048576 RS.OPTSIZE/1048576 > -- - -- > 20 20.296875 20 > > SQL> alter rollback segment TIM shrink to 10M; > > Rollback segment altered. > > SQL> select segment_name, min_extents, initial_extent, next_extent > 2from dba_segments > 3 where segment_name = 'TIM'; > > SEGMENT_NAME MIN_EXTENTS INITIAL_EXTENT NEXT_EXTENT > -- --- -- --- > TIM 201048576 1048576 > > SQL> select rs.extents, rs.rssize, rs.optsize > 2from dba_rollback_segs drs, > 3 v$rollstat rs > 4 where drs.segment_name = 'TIM' > 5 and drs.segment_id = rs.usn; > >EXTENTS RSSIZEOPTSIZE > -- -- -- > 10 10633216 20971520 > > SQL> alter rollback segment tim offline; > > Rollback segment altered. > > SQL> drop rollback segment tim; > > Rollback segment dropped. > > SQL> > > What version is your test running on? > > Tim > > PS - Here is my test case if you want to run it... > > column segment_name format a30 > create public rollback segment tim tablespace rbs storage ( initial > 1M next > 1M minextents 20 maxextents 100 optimal 20M ); > alter rollback segment tim online; > select segment_name, min_extents, initial_extent, next_extent > from dba_segments > where segment_name = 'TIM'; > select rs.extents, rs.rssize/1048576 , rs.optsize/1048576 > from dba_rollback_segs drs, >v$rollstat rs > where drs.segment_name = 'TIM' >and drs.segment_id = rs.usn; > alter rollback segment TIM shrink to 10M; > select segment_name, min_extents, initial_extent, next_extent > from dba_segments > where segment_name = 'TIM'; > select rs.extents, rs.rssize, rs.optsize > from dba_rollback_segs drs, >v$rollstat rs > where drs.segment_name = 'TIM' >and drs.segment_id = rs.usn; > alter rollback segment tim offline; > drop rollback segment tim; > > -Original Message- > Sent: Wednesday, January 30, 2002 2:17 PM > To: Multiple recipients of list ORACLE-L > > > testing > > if the initial extent*min_extents is less than the opti
RE: ALTER ROLLBACK SEGMENT rbs SHRINK
Can what cause a ORA-1555? A shrink? If that is the question... The answer is yes... Tim -Original Message- Sent: Thursday, January 31, 2002 11:00 PM To: Multiple recipients of list ORACLE-L Will this cause ora 1555 ? -Original Message- Tim Sent: 31 January 2002 03:31 To: Multiple recipients of list ORACLE-L Um... Must be version differences... Here is a test case I ran on my 8.1.7.3 machine... SQL> create public rollback segment tim tablespace rbs storage ( initial 1M next 1M minextents 20 maxextents 100 optimal 20M ); Rollback segment created. SQL> alter rollback segment tim online; Rollback segment altered. SQL> select segment_name, min_extents, initial_extent, next_extent 2from dba_segments 3 where segment_name = 'TIM'; SEGMENT_NAME MIN_EXTENTS INITIAL_EXTENT NEXT_EXTENT -- --- -- --- TIM 201048576 1048576 SQL> select rs.extents, rs.rssize/1048576 , rs.optsize/1048576 2from dba_rollback_segs drs, 3 v$rollstat rs 4 where drs.segment_name = 'TIM' 5 and drs.segment_id = rs.usn; EXTENTS RS.RSSIZE/1048576 RS.OPTSIZE/1048576 -- - -- 20 20.296875 20 SQL> alter rollback segment TIM shrink to 10M; Rollback segment altered. SQL> select segment_name, min_extents, initial_extent, next_extent 2from dba_segments 3 where segment_name = 'TIM'; SEGMENT_NAME MIN_EXTENTS INITIAL_EXTENT NEXT_EXTENT -- --- -- --- TIM 201048576 1048576 SQL> select rs.extents, rs.rssize, rs.optsize 2from dba_rollback_segs drs, 3 v$rollstat rs 4 where drs.segment_name = 'TIM' 5 and drs.segment_id = rs.usn; EXTENTS RSSIZEOPTSIZE -- -- -- 10 10633216 20971520 SQL> alter rollback segment tim offline; Rollback segment altered. SQL> drop rollback segment tim; Rollback segment dropped. SQL> What version is your test running on? Tim PS - Here is my test case if you want to run it... column segment_name format a30 create public rollback segment tim tablespace rbs storage ( initial 1M next 1M minextents 20 maxextents 100 optimal 20M ); alter rollback segment tim online; select segment_name, min_extents, initial_extent, next_extent from dba_segments where segment_name = 'TIM'; select rs.extents, rs.rssize/1048576 , rs.optsize/1048576 from dba_rollback_segs drs, v$rollstat rs where drs.segment_name = 'TIM' and drs.segment_id = rs.usn; alter rollback segment TIM shrink to 10M; select segment_name, min_extents, initial_extent, next_extent from dba_segments where segment_name = 'TIM'; select rs.extents, rs.rssize, rs.optsize from dba_rollback_segs drs, v$rollstat rs where drs.segment_name = 'TIM' and drs.segment_id = rs.usn; alter rollback segment tim offline; drop rollback segment tim; -Original Message- Sent: Wednesday, January 30, 2002 2:17 PM To: Multiple recipients of list ORACLE-L testing if the initial extent*min_extents is less than the optimal, yes you can shrink below optimal. if initial*minextents = optimal, you can execute an alter rollback segment statement that lists a shrink size that is less than optimal AND less than initial*minextents and it will not fail. But if you LOOK at the size it shrinks to, it's initial*minextents. so you can "kinda" shrink below optimal, the statement won't fail, but Oracle will ignore the number you give it. --- "Johnston, Tim" <[EMAIL PROTECTED]> wrote: > You know what? I thought the same thing... But, the curious side of > me > decided to give it a try to be sure... And guess what... It works? > Learn > something new everyday... > > SQL> select segment_name,sum(bytes) from dba_segments where > tablespace_name > = 'RBS' and segment_name > = 'RBS17' group by segment_name; > > SEGMENT_NAME SUM(BYTES) > -- > RBS17 22364160 > > > SQL> select rs.optsize, rs.extents > 2from dba_rollback_segs drs, > 3 v$rollstat rs > 4 where drs.segment_name = 'RBS17' > 5 and drs.segment_id = rs.usn; > >OPTSIZEEXTENTS > -- -- > 22020096 21 > > SQL> alter rollback segment RBS17 shrink to 10M; > > Rollback segment altered. > > SQL> select segment_name,sum(bytes) from dba_segments where > tablespace_name > = 'RBS' and segment_name > = 'RBS17' group by s
RE: [Q] sql/plus "cancel" window gone on 8i?
Control C or Pulldown Menu... File / Cancel -Original Message- Sent: Thursday, January 31, 2002 3:08 PM To: Multiple recipients of list ORACLE-L we just migrate our ORACLE client on PC side from version 7.3 to 8i. some programmers complain on 7.3 Sql/Plus when they run SQL statement, a small window box will pop up and they can "cancel" the long running job. This feature does NOT show up on 8i Sql/Plus. I checked "option" on sql/plus and can NOT found anything relate to it. Does anyone know how to put it back? Thanks. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash 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: Johnston, Tim 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 shadow process
The problem is that top reports the ENTIRE shared memory segment in EVERY process... For example... If your shared memory segment is 300M and top reports memory usage of 320-340M per process... You are in reality using about 20-40M of private memory in each process and 300M of shared memory... But, shared memory is only allocated once... i.e. Shared memory segment of 300M top reportsshared memory private usage by process process1 320M 300M20M process2 330M 300M30M process3 320M 300M20M process4 340M 300M40M So... Your total memory usage is... 20M + 30M + 20M + 40M + 300M = 410M Not... 320M + 330M + 320M + 340M = 1310M Does that help explain it? Tim -Original Message- Sent: Wednesday, January 30, 2002 4:45 PM To: Multiple recipients of list ORACLE-L I am sorry I did not specify the os. We are using solaris 2.8 and We are using top utility to look at the oracle user process. As far as I know, ipcs -ma will give me the size of the entire memory segment. I am trying to find the values for each user connection.. Thanks Sonia P. Unix I assume? How are you determining the memory usage? Many unix utilities can be misleading (i.e top) and report the shared memory segment in each process... Check ipcs -ma to see the size of the shared memory segment... HTH Tim __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sonia pajerowski 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: Johnston, Tim 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: ALTER ROLLBACK SEGMENT rbs SHRINK
ptimal AND less than initial*minextents and it will not fail. But if you LOOK at the size it shrinks to, it's initial*minextents. so you can "kinda" shrink below optimal, the statement won't fail, but Oracle will ignore the number you give it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnston, Tim 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 shadow process
Hi Sonia... Unix I assume? How are you determining the memory usage? Many unix utilities can be misleading (i.e top) and report the shared memory segment in each process... Check ipcs -ma to see the size of the shared memory segment... HTH Tim -Original Message- Sent: Wednesday, January 30, 2002 2:01 PM To: Multiple recipients of list ORACLE-L Hello All, How does oracle allocate memory to oracle shadow process (client). eg. oracleORCL (DESCRIPTION=(LOCAL=no )(ADDRESS=(PROTOCOL=BEQ))). I have dedicated connections to the databases and the processes are using 320M-340M of memory. Is there any parameter I can change to reduce the memory allocation to about 30M or less. Current value for Sort area size value is 65536. Thanks Sonia P. __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sonia pajerowski 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: Johnston, Tim 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: ALTER ROLLBACK SEGMENT rbs SHRINK
Um... Must be version differences... Here is a test case I ran on my 8.1.7.3 machine... SQL> create public rollback segment tim tablespace rbs storage ( initial 1M next 1M minextents 20 maxextents 100 optimal 20M ); Rollback segment created. SQL> alter rollback segment tim online; Rollback segment altered. SQL> select segment_name, min_extents, initial_extent, next_extent 2from dba_segments 3 where segment_name = 'TIM'; SEGMENT_NAME MIN_EXTENTS INITIAL_EXTENT NEXT_EXTENT -- --- -- --- TIM 201048576 1048576 SQL> select rs.extents, rs.rssize/1048576 , rs.optsize/1048576 2from dba_rollback_segs drs, 3 v$rollstat rs 4 where drs.segment_name = 'TIM' 5 and drs.segment_id = rs.usn; EXTENTS RS.RSSIZE/1048576 RS.OPTSIZE/1048576 -- - -- 20 20.296875 20 SQL> alter rollback segment TIM shrink to 10M; Rollback segment altered. SQL> select segment_name, min_extents, initial_extent, next_extent 2from dba_segments 3 where segment_name = 'TIM'; SEGMENT_NAME MIN_EXTENTS INITIAL_EXTENT NEXT_EXTENT -- --- -- --- TIM 201048576 1048576 SQL> select rs.extents, rs.rssize, rs.optsize 2from dba_rollback_segs drs, 3 v$rollstat rs 4 where drs.segment_name = 'TIM' 5 and drs.segment_id = rs.usn; EXTENTS RSSIZEOPTSIZE -- -- -- 10 10633216 20971520 SQL> alter rollback segment tim offline; Rollback segment altered. SQL> drop rollback segment tim; Rollback segment dropped. SQL> What version is your test running on? Tim PS - Here is my test case if you want to run it... column segment_name format a30 create public rollback segment tim tablespace rbs storage ( initial 1M next 1M minextents 20 maxextents 100 optimal 20M ); alter rollback segment tim online; select segment_name, min_extents, initial_extent, next_extent from dba_segments where segment_name = 'TIM'; select rs.extents, rs.rssize/1048576 , rs.optsize/1048576 from dba_rollback_segs drs, v$rollstat rs where drs.segment_name = 'TIM' and drs.segment_id = rs.usn; alter rollback segment TIM shrink to 10M; select segment_name, min_extents, initial_extent, next_extent from dba_segments where segment_name = 'TIM'; select rs.extents, rs.rssize, rs.optsize from dba_rollback_segs drs, v$rollstat rs where drs.segment_name = 'TIM' and drs.segment_id = rs.usn; alter rollback segment tim offline; drop rollback segment tim; -Original Message- Sent: Wednesday, January 30, 2002 2:17 PM To: Multiple recipients of list ORACLE-L testing if the initial extent*min_extents is less than the optimal, yes you can shrink below optimal. if initial*minextents = optimal, you can execute an alter rollback segment statement that lists a shrink size that is less than optimal AND less than initial*minextents and it will not fail. But if you LOOK at the size it shrinks to, it's initial*minextents. so you can "kinda" shrink below optimal, the statement won't fail, but Oracle will ignore the number you give it. --- "Johnston, Tim" <[EMAIL PROTECTED]> wrote: > You know what? I thought the same thing... But, the curious side of > me > decided to give it a try to be sure... And guess what... It works? > Learn > something new everyday... > > SQL> select segment_name,sum(bytes) from dba_segments where > tablespace_name > = 'RBS' and segment_name > = 'RBS17' group by segment_name; > > SEGMENT_NAME SUM(BYTES) > -- > RBS17 22364160 > > > SQL> select rs.optsize, rs.extents > 2from dba_rollback_segs drs, > 3 v$rollstat rs > 4 where drs.segment_name = 'RBS17' > 5 and drs.segment_id = rs.usn; > >OPTSIZEEXTENTS > -- -- > 22020096 21 > > SQL> alter rollback segment RBS17 shrink to 10M; > > Rollback segment altered. > > SQL> select segment_name,sum(bytes) from dba_segments where > tablespace_name > = 'RBS' and segment_name > = 'RBS17' group by segment_name; > > SEGMENT_NAME SUM(BYTES) > - -- > RBS17 10649600 > > > SQL> select rs.optsize, rs.extents > 2from dba_rollback_segs drs, > 3 v$rollstat rs > 4 where drs.segment_name = 'RBS17' > 5 and
RE: ALTER ROLLBACK SEGMENT rbs SHRINK
; > 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!? > Great stuff seeking new owners in Yahoo! Auctions! > http://auctions.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). > > > > > MOHAMMAD RAFIQ > > > _ > Join the world's largest e-mail service with MSN Hotmail. > http://www.hotmail.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mohammad Rafiq > 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!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.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: Johnston, Tim 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: ALTER ROLLBACK SEGMENT rbs SHRINK
You know what? I thought the same thing... But, the curious side of me decided to give it a try to be sure... And guess what... It works? Learn something new everyday... SQL> select segment_name,sum(bytes) from dba_segments where tablespace_name = 'RBS' and segment_name = 'RBS17' group by segment_name; SEGMENT_NAME SUM(BYTES) -- RBS17 22364160 SQL> select rs.optsize, rs.extents 2from dba_rollback_segs drs, 3 v$rollstat rs 4 where drs.segment_name = 'RBS17' 5 and drs.segment_id = rs.usn; OPTSIZEEXTENTS -- -- 22020096 21 SQL> alter rollback segment RBS17 shrink to 10M; Rollback segment altered. SQL> select segment_name,sum(bytes) from dba_segments where tablespace_name = 'RBS' and segment_name = 'RBS17' group by segment_name; SEGMENT_NAME SUM(BYTES) - -- RBS17 10649600 SQL> select rs.optsize, rs.extents 2from dba_rollback_segs drs, 3 v$rollstat rs 4 where drs.segment_name = 'RBS17' 5 and drs.segment_id = rs.usn; OPTSIZEEXTENTS -- -- 22020096 10 SQL> 8.1.7.3 on Solaris 2.8 Tim -Original Message- Sent: Wednesday, January 30, 2002 10:26 AM To: Multiple recipients of list ORACLE-L no, you can't shrink a rollback segment below the optimal value --- Sinard Xing <[EMAIL PROTECTED]> wrote: > Hi, > > > Assume > INITIAL * MINEXTENT = 2M and also = OPTIMAL > > Do you think > ALTER ROLLBACK SEGMENT rbs SHRINK TO 1M; > > will work ? > > > > Thanks, > > Sinardy > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinard Xing > 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!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.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: Johnston, Tim 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: e: deleting a datafile on OPS
But, "offline" and "removed from the system" are two different things... You are correct that your datafile is offline... That just means that it is unavailable for use... But, it is still part of your database... The DROP keyword does not mean that the datafile is removed from the system... It is a special keyword that allows you to offline a datafile while running in NOARCHIVELOG... If you check v$datafile you should see that the file is in a status of offline or recover.. I'm not 100% sure what happens when you offline drop but I think you may have to recover the datafile ( you have the archive logs right? ) before you can bring it online... If it was offlined normal, you should be able to bring it online without recovery... But, you should be able to figure that out by the status in v$datafile... v$recover_file is also handy... So, once you know you can bring it online, you can rename it to what you wish and bring it online... Good Luck Tim -Original Message- Sent: Tuesday, January 29, 2002 9:31 PM To: Multiple recipients of list ORACLE-L Hello Jared et al, The Oracle Reference Manual for 8i, "schematic diagram" has alter database '' offline drop, so that's what I tried (as system). The system came back, 'database altered', but a check of dba_data_files shows that the datafile (#115) is still there. The dba_extents lists no rows selected if I query on bytes where file# = 115, so taking the datafile offline as soon as I realized my error was successful in keepin any user data written to the datafile. Paul -Original Message- Sent: Tuesday, January 29, 2002 7:11 PM To: Multiple recipients of list ORACLE-L You can't safely drop a datafile from the database. When you say 'According to Oracle, I should be able to drop a datafile at has no data written to it', do you have a reference where we can see that. It does not sound familiar to me. Per your situation, since you have the datafile offline, just rename it via 'alter database rename file..', then put it back online. Jared On Tuesday 29 January 2002 15:08, Sherman, Paul R. wrote: > Hello list, > > Oracle 8.1.6.3.0, on HP-UX 11.0, using Oracle Parallel Server (OPS) > > According to Oracle, I should be able to drop a datafile that has no data > but I can not. Neither DBA studio (the garbage can stays > 'grayed'), nor the command line (alter tablespace, with the DROP clause) > works. I had immediately taken the datafile offline (I had typed > sbplus_x18.dbf instead of sbplus_x16.dbf for the datafile name to use in > case you are wondering how this turn of events happened in the first > place), and checked all of the books, and Meta-Link. I tried a test on a > non-production machine, no go; even taking the tablespace off-line first > makes no difference. And of course I get errors as one node can not see the > other nodes sbplus_x18.dbf datafile. I tried an 'alter system check > datafiles' to see if this would make the other node happy (as the datafile > is now off-line, this may work), but I need a solution other than exporting > the data, rebuilding the tablespace, then importing the export. > > Anyone ever come across this issue ? > > Thank you, > > Paul Sherman > DBA > voice - 781-501-4143 (office) > fax- 781-278-8341 (office) > email - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Sherman, Paul R. 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: Johnston, Tim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5
RE: RMAN problem
Had you performed a resetlogs between the cold backup and your recovery? What does "list incarnation of database" produce... It sounds to me like you changed the database incarnation between your cold backup and now... If that is the case, I think you can use the "reset database to incarnation "... Check out the Recovery Manager User's Guide and Reference for more info... http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a76990/toc.htm HTH Tim -Original Message- Sent: Tuesday, January 29, 2002 7:50 PM To: Multiple recipients of list ORACLE-L Hi I restored a a prevous cold backup of my database and am trying to take an incremental level 0 backup with RMAN. But the backup fails with the following error RMAN-06004: ORACLE error from recovery catalog database: RMAN-20011: target database incarnation is not current in recovery catalog Whe i tried to issue the reset database command then i got the error RMAN-03022: compiling command: reset RMAN-03023: executing command: reset RMAN-03026: error recovery releasing channel resources RMAN-03006: non-retryable error occurred during execution of command: reset RMAN-07004: unhandled exception during command execution on channel default RMAN-20009: database incarnation already registered How do we successfilly restore a prevous cold backup and use the RMAN to take backups on that database? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sona 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: Johnston, Tim 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: Top parent in START WITH...CONNECT BY
Would... select emp, level from table_name connect by prior mgr=emp start with emp = 'Jesse'; work for you? It would look like... Jesse 3 Urman 2 Sciarra 1 HTH Tim -Original Message- Sent: Tuesday, January 29, 2002 12:20 PM To: Multiple recipients of list ORACLE-L Hi, On 8.1.7.2 (soon to be .3) on HP/UX 11.0, a developer needs to get the top parent associated with a lower level row. Expanding on Oracle's EMP example: EMP MGR LEVEL King1 Greenberg King2 Faviet Greenberg 3 ChenGreenberg 3 Sciarra 1 Urman Sciarra 2 PoppUrman 3 Jesse Urman 3 ...I need to know that the top-level manager for "Jesse" is "Sciarra". In our live data, however, we currently have 9 levels (engineering bill-of-materials) and there is no set maximum for levels. Anyone have an idea how to return: Jesse Urman Sciarra 3 ...for this? The START WITH...CONNECT BY can only give the PRIOR manager and not the top level. TIA! 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: Johnston, Tim 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: RTFM questions (formally RE: PL/SQL)
Title: RTFM questions (formally RE: PL/SQL) Hi Ken... Do they have an internet connection? http://docs.oracle.com or http://tahiti.oracle.com It goes a long way... And, as I mentioned in my other email... This person has been pointed at the exact manual on numerous occasions but chooses not to do any reading... He needs to post more questions along the lines of "Where do I look to find the answer to..." and "I looked in the xxx manual but I don't understand ..." This is not a random whack at a poster who asks the occasional question... This rant is directed at a list abuser... Tim -Original Message-From: Sunrise DBA [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 29, 2002 11:36 AMTo: Multiple recipients of list ORACLE-LSubject: Re: RTFM questions (formally RE: PL/SQL) Often, it isn't all that easy to find what you need in "the manual". I have a enough Oracle books to make the springs in my car sag, and sometimes, the answer just isn't there. Mostly yes, but sometimes no. Usually, I have to go through 3 or 4 books before I find an answer I can use. So, if the poor listee only has one or two books, perhaps he doesn't have one that has the answer. Maybe you senior, high income guys can send him your spare books :-) Or better yet, put a faq together with a book list. Ken Hitchcox - Original Message - From: JoJo Al-Zawawi To: Multiple recipients of list ORACLE-L Sent: Tuesday, January 29, 2002 7:40 AM Subject: RE: RTFM questions (formally RE: PL/SQL) No offense to anybody, but I think this is rather arrogant. The list is for anybody (unless the list owner decides it's just for experienced dba's). I am brand new to Oracle, having just started learning it this week. I can easily foresee having what some might consider stupid or RTFM questions, and being possibly unable to find the answer or having problems deciphering the manual. I myself am somewhat of a Word pro (and my vba code samples page is the #1 ranked site of its kind on most major search engines) and I help all kinds of newbies out on a Word list of which I am a member, as do all the other members of the list. Everybody on that list is extremely gracious and nobody complains -- and the people with questions get the help they need, with nobody sitting back going "boy are you stupid / lazy". I am hoping that I can get the same kind of help here, when I am ready for it, that I and others give on other lists. --JoJo -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Craig MundaySent: Monday, January 28, 2002 10:20 PMTo: Multiple recipients of list ORACLE-LSubject: RTFM questions (formally RE: PL/SQL) The problem is that if you always ask the group for help, you never learn where the information is within the manuals or other reference documentation and the group also gets cluttered with trivia. I agree with you that the list is here to help people and I personally do not mind the odd naive question from a new DBA, but it is the "...can't be bothered to look up the manual.." attitude that is most frustrating. When you ask the format of a command (for example) to the list, you are potentionally asking 1000's of people the same question who will all have to spend the time to filter these questions - we are all busy people and I personally do not want to use my time in this way. I'm sure you can see that this is a much more expensive option than asking the person next to you. Cheers, Craig. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 29 January 2002 2:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: PL/SQL Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- 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
RE: Public Privileges on system tables?
Hi Ron... I found some info in the reference guide... PSTUBTBL This table contains information on stubs generated by the PSTUB utility so that an Oracle Forms 3.0 client can call stored procedures in an Oracle database. Note: The contents of this table are intended only for use by the PSTUB utility. I only found a couple references to user_privs... Looks like it was eliminated... I found it mentioned on a couple web pages... I also found out that there appears to be a view named user_privs created by older pupbld.sql... It was based on the user_profile table... HTH Tim -Original Message- Sent: Tuesday, January 29, 2002 8:10 AM To: Multiple recipients of list ORACLE-L Hello Ron I checked our 7.3.4 DB (on NT) and did not find these tables. I think that they may belong to a product that use these tables and so everyone who uses this product need them. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] > Sent: Mon, January 28, 2002 6:56 PM > To: Multiple recipients of list ORACLE-L > Subject: Public Privileges on system tables? > > I have two tables, sys.pstubtbl and sys.user_privs that have grants to > public for insert, update, and delete. Our auditors are wondering why. > I don't really want to remove the privs without knowing why. This is an > old > 7.3.4 instance. Any ideas? > > Ron Smith > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Smith, Ron L. > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > This e-mail was scanned by the eSafe Mail Gateway > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnston, Tim 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: RTFM questions (formally RE: PL/SQL)
Title: RTFM questions (formally RE: PL/SQL) JoJo... You're missing the point... Most people have no issue with helping another list member... But, some members abuse this help and consistent ask questions that could be found in the manual without even attempting to find it... The list member in question has consistently asked questions of this nature for the last few MONTHS... Many times other list members have given the answer and then pointed at the manual where the information is found... Instead of looking at the manual before asking the next question, the abuser will immediately ask another question... And so on... And so on... And so on... After awhile, this gets frustrating... Personally, I do not reply to this list member due to his behavior... And I won't until he starts saying things like... "I looked in this manual and read this part but I don't understand it" or "What manual should I look in to get this answer"... I guess what I am trying to say is that there is a history established with a list member such as this that you are probably not aware of... People are frustrated and it is showing... Tim -Original Message-From: JoJo Al-Zawawi [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 29, 2002 10:41 AMTo: Multiple recipients of list ORACLE-LSubject: RE: RTFM questions (formally RE: PL/SQL) No offense to anybody, but I think this is rather arrogant. The list is for anybody (unless the list owner decides it's just for experienced dba's). I am brand new to Oracle, having just started learning it this week. I can easily foresee having what some might consider stupid or RTFM questions, and being possibly unable to find the answer or having problems deciphering the manual. I myself am somewhat of a Word pro (and my vba code samples page is the #1 ranked site of its kind on most major search engines) and I help all kinds of newbies out on a Word list of which I am a member, as do all the other members of the list. Everybody on that list is extremely gracious and nobody complains -- and the people with questions get the help they need, with nobody sitting back going "boy are you stupid / lazy". I am hoping that I can get the same kind of help here, when I am ready for it, that I and others give on other lists. --JoJo -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Craig MundaySent: Monday, January 28, 2002 10:20 PMTo: Multiple recipients of list ORACLE-LSubject: RTFM questions (formally RE: PL/SQL) The problem is that if you always ask the group for help, you never learn where the information is within the manuals or other reference documentation and the group also gets cluttered with trivia. I agree with you that the list is here to help people and I personally do not mind the odd naive question from a new DBA, but it is the "...can't be bothered to look up the manual.." attitude that is most frustrating. When you ask the format of a command (for example) to the list, you are potentionally asking 1000's of people the same question who will all have to spend the time to filter these questions - we are all busy people and I personally do not want to use my time in this way. I'm sure you can see that this is a much more expensive option than asking the person next to you. Cheers, Craig. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 29 January 2002 2:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: PL/SQL Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- 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: FW: ORA-01555 - Delayed Block Cleanout
ease see the official ORACLE-L FAQ: > > http://www.orafaq.com > > > -- > > > Author: Walter K > > > 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!? > Great stuff seeking new owners in Yahoo! Auctions! > http://auctions.yahoo.com > -- 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: Johnston, Tim 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).