Re: ROW CACHE HIGH - Priority 1
') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sam Roberts 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: RMAN NETBACKUP recovering from say 6 MONTHS ago
Title: RE: RMAN NETBACKUP recovering from say 6 MONTHS ago Thanks Tony This is how I imagined it would work, yet the SYS ADMins are saying that there is no request for tape in the logs. Im in a different location so I guess I will have to travel to the other side of town and look myself. You dont know the directory of the logs do u by chance. I dont actually have access to the netbackup server so I am not familiar with its file locations Thanks again Sam - Original Message - From: Aponte, Tony To: Multiple recipients of list ORACLE-L Sent: Monday, June 10, 2002 9:03 PM Subject: RE: RMAN NETBACKUP recovering from say 6 MONTHS ago Netbackup has a repository that keeps track of what files are on which tapes, dates, sizes, volumes, serial number, etc. Depending on how you are restoring the files, Netbackup gets a request to get a file name (as it is know on tape) and checks it's catalog for the entry. The bprestore process (or whatever it's called on your platform) sends a request in a proprietary format to the media manager host. You (or your SA) can look at the Netbackup logs or use bpmon to view the details for the request, including the tape label. The hang you are seeing is actually controlled by a timeout setting. Once the request is made for loading of a tape, the restore process is at the mercy of whatever mounter is used on the media manager host (robot, tape jockey, etc.) The timer expires, signals the bprestore and lets it exit gracefully returning an exit code in the process. Use this exit code to determine what the caused timeout; it's in the Veritas Netbackup manual. I bet the error code is for "media not found and timer expired" or something like that since the request isn't failing right away (which would mean that the tape was explicitly expired and the catalog entries updated to reflect the changes.) HTH Tony Aponte -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 4:18 AM To: Multiple recipients of list ORACLE-L Subject: RMAN NETBACKUP recovering from say 6 MONTHS ago I want to alternate host my database to 6 months ago: The media manager only keeps 2 months of data online and when i recover until etc.. the job hangs and then finally gives up, obviously as the tape is not inside: My question is how does Netbackup know which tape to load, or how do I know which tape to put in the media manager or which range of tapes: Anybody an help with this Thanks Sam -- 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: Do you use RMAN?
I use RMAN with veritas Netbackup and it is sweet. Recovery is ridiculously easy: Even recovering to an alternative host (not as fast as cloning) is a doddle and u can apply redo logs to the recovery to bring it up to current time: All in all well worth the learning curve to set up - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 9:03 PM hmmm, the question of the day, a good one! I don't use it now but plan on using it. The question is when :) [EMAIL PROTECTED] 03/06/02 10:48AM Hi, I'm in the process of upgrading my database to 9i and I was trying to decide whether I wanted to change my backup strategy to use RMAN. Do most of you use it? If you use it, what is your opinion of it? If you don't use it, why did you decide not to? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALINF 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: Gene Sais 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: Sam Roberts INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-01000: maximum open cursors exceeded
no performance impact whatsoever . I have various Java applications that require huge number of cursors and i have limit set to 7500 without any issues Sam - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 08, 2002 5:03 PM We had this error show up the other day. I am wondering if there is a performance limit on how big you should set your OPEN_CURSORS parameter in the SID.init file? Mine currently is set at 300. Are there any guidelines on this setting? Just wondering. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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: Sam Roberts 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: OUTLN
and your point igor ! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 04, 2002 8:16 PM Interesting observation: Listers are much less objecting to answer some really 'simple' questions (which could be RTFMed), if those questions touch upon relatively new oracle features (like OUTLN). Should have to do with people's curiosity? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 04, 2002 10:35 AM Ron, The OUTLN user is for administering a new 8i feature called stored outlines. Stored outlines allow you to save away current execution paths as they exist today, if you want to. Then, if things get hosed up in the future and your execution path mysteriously changes and you can't get it back to the way it was, you can load up your stored outline and force the optimizer to use the old execution path. This feature does not get implemented automatically. It requires some configuration and administration to actually use stored outlines. Cherie Machler Oracle DBA Gelco Information Network Smith, Ron L. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: om Subject: OUTLN Sent by: [EMAIL PROTECTED] om 02/04/02 08:50 AM Please respond to ORACLE-L Can anyone tell me what the OUTLN user is for? 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). -- 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: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Roberts 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: Number_of_rows
rtfm - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 25, 2002 10:20 PM Hallo all you gurus, How can I write in the pl/sql code if I want to insert in a table the number of rows that are inserted in the select statement in the procedure? Give me a good example, please. Thanks in advance Roland S -- 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: Sam Roberts 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)
://www.orafaq.com 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: Thomas, Kevin 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: Sam Roberts 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: JoJo Al-Zawawi 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: Sam Roberts 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: Sending mail using pl/sql
U can e-mail me @ [EMAIL PROTECTED] to remind me: I have real life examples I can send u: Today is holiday in middle east where I work: I will be at work tomorrow and I will send them Sam - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 25, 2002 4:40 PM Hi All, I know it has been asked many times but I have changed jobs and no longer have old e-mail. Anyway I need to know how to send e-mail using pl/sql with attachments. Any real examples,links,references would be very helpful. My environment is Oracle NT 8.1.6 SE, NT 4.0, client is Win 2000 Thanks Rick -- 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: Sam Roberts 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: Solaris 8 Question
This happened to me today: Solaris 5.8 we have a large data load exercise going on and the archive log directory filled - database stopped of course. but after I had moved all the archive logs to another location the system still hung - I tried manual switching of log file ,still hung. I had to stop and start instance - I was surprised. did I miss something ? sam - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 20, 2001 2:15 PM If it's / or /tmp, then yes, your machine could well become unusable until it gets some free space. If your archive log disk fills, Oracle will refuse transactions until there is free space. Read the man page for 'quota' to help you limit the possibility of this. And think about switching autoextend off. Cheers, g -Original Message- Sent: Thursday, July 19, 2001 4:10 PM To: Multiple recipients of list ORACLE-L Hi all, A friend of mine is having a problem so I thought I would ask all of you experts a quick question. On a Solaris 8 box running 8.1.7, if a partition fills up, will it crash the box? I know that on NT this is very possible depending on pagefile and what file is filling up the partition. But I don't know anything about Sun. Thanks alot:) Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: Guy Hammond 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: Sam Roberts 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).
stopping applications connecting to a database
is there any way (apart from running a reoccuring scripts ) to stop users from accessing the database with software such as msaccess.exe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Roberts 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: how to find highest process useing more CPU
/usr/ucb/ps -uax This will give u the /son of a b***'s' taking the most CPU Sam - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 9:13 PM On Tue, Jun 19, 2001 at 08:46:04AM -0800, Seema Singh wrote: Hi Is there any way to find which process is taking much cpu except top command on Solaris Unix. If some one have any script let me know. With regards -Seema Try looking up the documentation for ps for example... ps -e -o pcpu,pid,user,args | sort -nr | head -- Tommy Wareing Software Engineer Oxford English Dictionary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tommy Wareing 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: Sam Roberts 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).
Semaphores
Oracle Financials 11i asks for 14000 semaphores: When I do the calculation as per the Oracle Guide I come to about 1000. Anybody know why the disparate nature of these numbers. Can semaphores be set to such high levels. I can RTFM, but wonder what lists comments are before Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Roberts 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: OFA Question
No reason - Sam - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 12:50 PM Hi All Running Oracle 817 on Red Hat Linux. File layout is as follows. oradata3/prod: control01.ctl indx01.dbf redo01.log system01.dbf tools01.dbf oradata4/prod: control02.ctl redo02.log temp01.dbf oradata6/prod: control03.ctl rbs01.dbf redo03.log oradata7/prod: redo01b.log users01.dbf oradata8/prod: archives redo02b.log oradata9/prod: archives redo03b.log Where archives is a dir containing online dbf backups and archived redo logs. Is there ANY reason at all not to use spare space on oradata 3,4,6,7 to store other files ? They won't be read or written during times when the database is under load. Cheers GS -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Solomon 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: Sam Roberts 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: Which SQL is executing
SELECT T.SQL_TEXT FROM V$SQLTEXT T,V$SESSION S WHERE S.SQL_ADDRESS=T.ADDRESS ORDER BY T.PIECE; Sam - Original Message - From: Chuan Zhang To: Multiple recipients of list ORACLE-L Sent: Monday, June 04, 2001 9:30 AM Subject: Which SQL is executing Hi All, From v$open_cursor, I know every SQL opened and parsed in one session. Is there any way to know which SQL is running. Or put another way, canall the SQLs in one session be sorted in timing order dynamically? Any clue would be much appreciated. Chuan
Re: OFA New Installation
I'm setting up an 8i solaris installation on ha-cluster with disk array and veritas vol manger. I've only got 10 18gb disks (mirrored) for my prod/test/dev environments. I will OFA the Prod only. Data + Index Approx 30GB I'll use RAID 1 for disks 1-5 RAID 1+0 for Disks 6-10. my disk config - any comments greatly appreciated Disk1 - Control01.ctl system01 temp01 rbs01 /prodbinaries DIsk2 - Control02.ctl Redo01a Redo02a Redo03a Disk3 - Control03.ctl Redo01b Redo02b Redo03b Disk4 - /devRedo01c Redo02c Redo03c tools Disk5 - /arch /test1 Disk6 - data Disk7 - data Disk8 - data Disk9 - index Disk10 - index issues - temp and rbs on same - ive guess its okay if sorts mainly in memory - redo01 02 03 on same drive - I know contention when arching but .. - I have to find room for at least 1 clone of production pref 2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Roberts 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).
Fw: OFA New Installation
I'm setting up an 8i solaris installation on ha-cluster with disk array and veritas vol manger. I've only got 10 18gb disks (mirrored) for my prod/test/dev environments. I will OFA the Prod only. Data + Index Approx 30GB I'll use RAID 1 for disks 1-5 RAID 1+0 for Disks 6-10. my disk config - any comments greatly appreciated Disk1 - Control01.ctl system01 temp01 rbs01 /prodbinaries DIsk2 - Control02.ctl Redo01a Redo02a Redo03a Disk3 - Control03.ctl Redo01b Redo02b Redo03b Disk4 - /devRedo01c Redo02c Redo03c tools Disk5 - /arch /test1 Disk6 - data Disk7 - data Disk8 - data Disk9 - index Disk10 - index issues - temp and rbs on same - ive guess its okay if sorts mainly in memory - redo01 02 03 on same drive - I know contention when arching but .. - I have to find room for at least 1 clone of production pref 2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Roberts 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: 4 join methods?
I did have to RTFM - A cluster join is nothing more than a nested loops join involving two tables that are stored together in a cluster. Because each row from the dept table is stored in the same data blocks as the matching rows in the emp table, Oracle can access matching rows most efficiently Sam - Original Message - From: Vadim Gorbounov To: Multiple recipients of list ORACLE-L Sent: Friday, June 01, 2001 6:25 PM Subject: RE: 4 join methods? Hi, DBAs, RTFM is so boring, but... There is cutpaste from "Oracle8i Designing and Tuning for Performance" The Optimizer Optimizing joins Join Operations To join each pair of row sources, Oracle must perform one of these operations: Nested Loops (NL) Join Sort-Merge Join Hash Join (not available with the RBO) Cluster Join Cheers, Vadim Gorbounov Oracle DBA
2 batch jobs kill performance
There is a site www.hotsos.com and a paper about why 2 batch jobs kill system performance. The paper is protected so is there anybody on the list who can explain this, Im very curious thanks Sam - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, June 03, 2001 6:15 AM Jared Still wrote: Same old FUD. Try to associate your competition with a scary word and make them a pariah. McCarthyism in the 50's, Balmerism in the 00's. Jared On Friday 01 June 2001 14:17, Jamadagni, Rajendra wrote: Read the story here (urlhttp://www.suntimes.com/output/tech/cst-fin-micro01.html/url) and have a good laugh. LOL! TGIF Raj This is not an email that I would normally post to the list - but since its the weekend - why not? Jared, The GPL has been referred to as a virus previously, due to inclusion of GPL code causing the entire piece of code (at the execution unit) to be required to be released under the same license. I have a problem with this section of the article: snip Q: Do you view Linux and the open-source movement as a threat to Microsoft? A: Yeah. It's good competition. It will force us to be innovative. It will force us to justify the prices and value that we deliver. And that's only healthy. The only thing we have a problem with is when the government funds open-source work. Government funding should be for work that is available to everybody. Open source is not available to commercial companies. The way the license is written, if you use any open-source software, you have to make the rest of your software open source. If the government wants to put something in the public domain, it should. Linux is not in the public domain. Linux is a cancer that attaches itself in an intellectual property sense to everything it touches. That's the way that the license works. snip Open Source != GPL. The GPL is one license - there are many like it, many unlike it. http://www.fsf.org/philosophy/license-list.html#GPLCompatibleLicenses Here is an article by Stallman http://www.cnn.com/TECH/computing/9911/08/freedom.GNU.idg/ Linus Torvalds chose the GPL so that no one could own Linux. There are other licenses that can be used for Free Software or Open Source Software, such as the LGPL, Apache and BSD Artistic License. I've heard rumors that much of the TCP/IP stack in Windows 2000 has its origins in FreeBSD code - licensed under the BSD license. To Balmer - if Microsoft cannot own it - it is evil - and should not be funded. As not all Open Source work is licensed under the GPL, his statement is overly broad and therefore false. Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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: Sam Roberts 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: 4 join methods?
They are basically the same I agree but for clarification an inner join is a join where rows from one table are joined to rows from another table based on some common values, an equi join is one in which the equals operator is used to directly relate two values. I can see the difference in business terms - if you disagree take the argument up with the likes of guy harrison et al. cause to quote rhett, frankly my dear, I don't give a (damn('flying duck')) Sam - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 01, 2001 5:40 PM inner join and equijoin are the same Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, June 01, 2001 1:26 AM To: Multiple recipients of list ORACLE-L There are 5 join operations inner join equi-join outer-join anti-join self-join and 3 join methods neted loop sort merge join hash join sam - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 10:55 AM 1. Equi-join 2. Self-join 3. Outer-join 4. Hash-join rukmini - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 11:20 AM i feel the fourth one is self join. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 8:10 AM Hi, I just read there are four join methods. I know three: Nested loops Sort merge Hash join What's the fourth? - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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: Saurabh Sharma 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: Rukmini Devi 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: Sam Roberts 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: Christopher Spence 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
Re: Re[2]: 4 join methods?
Star join or STAR SCHEMA is used for DSS Systems. It actually uses Cartesian product in its methodology but still employs Oracle join methods to actually do the joins between the tables. So there are still 3 join methods.Cartesian (as somebody mentioned earlier is product rather than a join) Sam p.s. not sure what 9i will has - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 01, 2001 12:09 AM On Thursday 31 May 2001 06:41, [EMAIL PROTECTED] wrote: I wonder if their thinking of the star join?? Dick Goulet Isn't that actually just a sort merge? Just guessing here, didn't RTFM. No flames please! :) Jared -- 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: Sam Roberts 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: Help on query
That was too funny - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 22, 2001 12:46 PM SELECT DISTINCT std_no FROM exam WHERE POINT IN ('A','B'); At 12:00 AM 5/22/2001 -0800, you wrote: Dear gurus, I have a table : Tabel Exam STD_NO SUBJECT POINT == === = 001CHEM A 001PHYSIC A 001BIOLOGY A 002CHEM A 002PHYSIC B 002BIOLOGY A 003CHEM A 003PHYSIC A 003BIOLOGY B What is the SQL query to retrieve STD_NO which have CHEM = A and PHYSIC = A? The output should be : STD_NO == 001 003 TIA, Ahmadsyah Alghozi Nugroho Database Engineering Specialist PT Infoglobal AutOptima Jl. Baruk Tengah I/49 Surabaya - Jawa Timur INDONESIA phone : +62 (31) 8708456 ext.113 visit [ORAID!] http://oraid.iwarp.comhttp://oraid.iwarp.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex B. Cheng 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: Sam Roberts 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).
Multiple schema's or multiple databases
Oracle 8.1.6 and Solaris I'm going to inherit production databases when I start my new job next week. I gather that the production database consists of 8 schema's (8 companies) that are all in one database. Its an ERP package called Maximo and it interfaces to Financials 11i databases (don't know if this is multiple databases or schema's yet). Apparently there is some data passing between companies and multiple schema's perform better than using database links with multiple databases, and this is the reason for multiple schema's. Does anyone have an opinion on this. If I'd have done it I would have done multiple databases as they are separate companies, but I'm open to comments as not quite got my head round it yet, plus I've been vacationing (partying) for 3 weeks. Thanx Sam
Re: Free Java dba monitoring tool and Java source code
Title: Free Java dba monitoring tool and Java source code lisa I posted about a java SQL monitoring tool that I developed. The source code is also available - please e-mail me offline for details Sam - Original Message - From: Yttri, Lisa To: Multiple recipients of list ORACLE-L Sent: Tuesday, May 22, 2001 11:55 PM Subject: Free Java dba monitoring tool and Java source code Hi - There was a post a couple of months ago from someone who had written this java tool and you could e-mail him to get a copy. Does anyone have his e-mail or a web site where the software can be found? Thanks - Lisa
Re: Multiple schema's or multiple databases
Off the top of my head I can see this problem also. Is there anyone who is expert at recovery has a view. Dick - how can you consolidate 8 companies into one schema - they probably all have different inventories,equipmet etc.. + all have their own interface to Oracle Financials. Sam - Original Message - From: John Lewis To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 23, 2001 3:36 AM Subject: RE: Multiple schema's or multiple databases Something to ponder. The archive logs are tied to the system. Thus, if you want torecover to a point in time for a multi-schema /one instance system, if one schema gets rolled back - everything gets rolled back. We had this same issue. Perhaps someone knows a way around this. -Original Message-From: Christopher Spence [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 22, 2001 2:26 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Multiple schema's or multiple databases 1. Is that performance gain absolutely necessary? What happens if one company goes down and takes down them all. On another note, I tend to agree on lesser instances against more instances. Easier to tune, better perforamance due to what I call instance wastage and much easier to maintain. But if one system changes alot, has significiantly different access methods, or goes up and down more than anyone, I would evaluate seperate instances. -Original Message-From: Sam Roberts [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 22, 2001 1:41 PMTo: Multiple recipients of list ORACLE-LSubject: Multiple schema's or multiple databases Oracle 8.1.6 and Solaris I'm going to inherit production databases when I start my new job next week. I gather that the production database consists of 8 schema's (8 companies) that are all in one database. Its an ERP package called Maximo and it interfaces to Financials 11i databases (don't know if this is multiple databases or schema's yet). Apparently there is some data passing between companies and multiple schema's perform better than using database links with multiple databases, and this is the reason for multiple schema's. Does anyone have an opinion on this. If I'd have done it I would have done multiple databases as they are separate companies, but I'm open to comments as not quite got my head round it yet, plus I've been vacationing (partying) for 3 weeks. Thanx Sam
Re: DB Link Between Prod and Test?
My concern with that would be the performance aspect. Giving someone access to run un optimized queries in Production could affect the overall response time. I would not allow it personally, plus if you allow it for one ,you've set a precedent Sam - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 11:00 PM If all he needs is select he cannot corrupt the DB if the DBA does not grant unnecessary privileges. Folks use dblinks all the time. Rick -Original Message- Sent: Tuesday, May 15, 2001 2:26 PM To: Multiple recipients of list ORACLE-L One of our development DBAs suggested today to build a private database link between production and test database so that he can run some queries against both at the same time. I am a little concerned because he might make a mistake and accidentally corrupt the prod database. Anybody out there who is doing the same thing? Are there any other potential ramifications? TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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: Cale, Rick T (Richard) 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: Sam Roberts 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: consistency in cost?
If the system is Rule based and you code Hints, the CBO will be automatically invoked Sam - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 10:12 PM Forgive my ignorance but I thought hints were only for cost based optimizer. Have you checked in case anybody has changed any parameters while the system is running as I know that changing the hash_area_size can change the execution plan?. Are you using parallelism as if a table had to be recreated for any reason and its degree changed it might do a FTS? Cheers Iain Nicoll -Original Message- Sent: 08 May 2001 17:31 To: Multiple recipients of list ORACLE-L Jared, The only difference is about a weeks worth of extra data. Well, the hardware is also different (Ultra450 vs. Ultra 5000. Also 1 vs 4 CPU). But regardless, shouldn't init.ora optimizer_mode=choose be identical to optimizer_mode=rule with hint=choose? If I have the time, I'll try to set up a couple of systems and examine by moving stats and taking some 10053 dumps. (one of the ones giving me a problem is in production so I have limited play time there). Henry -Original Message- Sent: Tuesday, May 08, 2001 12:56 AM To: [EMAIL PROTECTED]; Henry Poras Henry, You say 'nearly identical'. What are the differences? Are the 2 databases on the same platform? If not, what are the differences, hardware and OS? Jared On Monday 07 May 2001 21:55, Henry Poras wrote: I am working with an 8.1.6 database on Solaris 2.6 and I am wondering if there is any consistency in the optimizer. We have two nearly identical databases (one a clone from two weeks ago). A five table join has nearly the identical execution plan on the two databases. The difference is in the access method of the fourth table in the join; in one case it is accessed by a FTS and in the other, by Index. This difference has a large effect on performance. Statistics are nearly identical for this table in both databases (I looked at dba_tables, dba_indexes, dba_col_tables). Also, the init.ora is the same. When I changed the optimizer_mode to rule and added a 'choose' hint to the query, the execution plan was different again. I will look into this a bit further and post my results. Just wondering about other's experiences. Thanks. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras 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: Nicoll, Iain (Calanais) 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: Sam Roberts 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).