RE: Windows clustering???
Oh yeah? Just this week we had a Windows box that had been up for 29 days straight!!! Yep. You read it right. I'm not giving out our secrets though. -Original Message- Sent: Wednesday, December 10, 2003 10:55 PM To: Multiple recipients of list ORACLE-L This is a small, static, but fiercely loyal group of VMS users for HP to milk. OpenVMS is money in the bank for HP, as it was for Compaq and DEC. Even the bean-counters understand the insanity of shutting off a guaranteed, endless, and highly-profitable revenue stream upon which they do not have to expend any marketing or sales resources... Officially, they currently promise OpenVMS support through 2012 or thereabouts, I believe. In Colorado Springs (at the DEC-then-Compaq-then-HP hosting center), there is a VMS cluster hosting an Rdb-based application that has been continuously available for the past 11-12 years. Zero downtime for the application. Absolutely stunning. on 12/10/03 2:14 PM, Tanel Poder at [EMAIL PROTECTED] wrote: Maybe you all already know that, but HP is planning to support OpenVMS on their Itanium servers :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:14 PM I'm guessing they're not running Oracle on this VMS cluster. I really liked the part about the most difficult part was explaining to managers why it was unnecessary to shut systems down, even during the physical relocation. http://www.theinquirer.net/?article=13002 Imagine if DEC had any marketing... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, 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: 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.net -- Author: Cunningham, Gerald 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: Outsourcing's dirty secret - Bigger Picture
clod can have facts, having an opinion is an art ! -Original Message- Sent: Thursday, October 30, 2003 11:59 AM To: Multiple recipients of list ORACLE-L List - If a manager seems to be contemplating outsourcing, you might want to post this. Unless you work for an outsourcer. ;-) http://techupdate.zdnet.com/techupdate/stories/main/Hidden_Costs_of_IT_O utso urcing.html Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra 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). Mladen Gogala Oracle DBA 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: Bellow, Bambi 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: Cunningham, Gerald 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: anyone have opinions on the future of the 'grid'?
I don't know... It's definitely an interesting concept though, isn't it? Check this out: http://www.informationweek.com/story/showArticle.jhtml?articleID=1560024 2 -Original Message- Sent: Tuesday, October 28, 2003 10:34 AM To: Multiple recipients of list ORACLE-L S Does it mean that a network with 100 computers of 1 cpu each is almost equivalent to 100 cpu giant computer ?? -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 27, 2003 4:39 PM Rich, That really isn't 'grid', but I think you know that. GC essentially makes a network look like one great big box, with the cross platform functionality included. In the immortal words of Scott McNeally: The network is the computer. :) Don't know if he said if first. John Brunner was likely the first to get the concept in print. Jared On Mon, 2003-10-27 at 10:09, Jesse, Rich wrote: Some of us here at work have been using grid computing to compile programs... http://www.gentoo.org/doc/en/distcc.xml Standard disclaimers apply (e.g. all machines must have same versions of copmiler, same architecture, etc. to avoid problems). Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 11:19 AM To: Multiple recipients of list ORACLE-L Subject: RE: anyone have opinions on the future of the 'grid'? Dick, Jared If you look at the big picture, 20 years ago the idea of a PC with the throughput of a mainframe was laughable. Not so laughable today. Large systems use many of the same components as PCs. Whether this means the grid is more than hype remains to be seen. But I suspect Larry would prefer you spent your money on Oracle licensing instead of hardware. And this may be an area where Oracle can keep ahead of the open-source folks. Dennis Williams -- 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: 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: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cunningham, Gerald 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: anyone have opinions on the future of the 'grid'?
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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: Cunningham, Gerald 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: Cannot reach server - bookpool.com
Title: Message it's working for me... tried clearing your cache? can you ping it? -Original Message-From: Martin, Alan (Contractor) (DLIS) [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 9:49 AMTo: Multiple recipients of list ORACLE-LSubject: Cannot reach server - bookpool.com Can someone try reaching this site. I keep getting "cannot reach server" for almost a week. I hope they are still in business. Perhaps the popularity of Cary's book killed their server:) Has anyone found lower prices than bookpool? Thanx, Alan Martin Defense Logistics Info Service
RE: Desupport of RBO
The way I read it is that you can still use it, it's just not officially supported. i.e. If you call up Oracle Support and say my query (SELECT /*+RULE */ blah blah blah...) crashes the database, they will say Sorry, you're out of luck or Switch to cost-based. Some apps (e.g. Siebel) still rely on RULE or they go down the terlit... -Original Message- Sent: Tuesday, October 07, 2003 2:05 PM To: Multiple recipients of list ORACLE-L OK, dumb question. Does this mean the rule hint won't be possible? Application I support mostly uses CBO but there have been cases where we had to resort to RBO hint. 'course it'll be some time before we can consider v10... Kip |Hi Jared, |haven't seen it, too. But the fact |was spreaded over the newsgroups. |We still have some 3rd party apps that don't use |*any* feature above Oracle 7 (well, almost). Queries with |the RULE hint where it's not necessary. |But if we change a thing, support will be lost. |So we decided to rewrite the whole app. |Lucky me: enough work for the next years. |Greetings, |Guido | [EMAIL PROTECTED] 07.10.2003 01.34 Uhr |First time I've seen this note: 189702.1 |Jared |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Guido Konsolke | 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: Cunningham, Gerald 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: STUPID LD_LIBRARY_PATHING!!@@@!@!@!@!
Title: Message I haven't used or thought about these scripts since version 7.0, until one day last year. Another DBA at our shop had written a script called "startdb",which starts up your current ORACLE_SID. So, thinking I'd be efficient and save maybe 10 -15 keystokes in starting a database, I type "dbstart". D'oh!! :P That script shutdown every instance on the box (6-8 of em'). Luckily it was dev... - Anonymous -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 4:24 PMTo: Multiple recipients of list ORACLE-LSubject: RE: STUPID LD_LIBRARY_PATHING!!@@@[EMAIL PROTECTED]@[EMAIL PROTECTED] You have listed the reasons why many folks don't use the supplied oraenv scripts. It has long been necessary to modify the dbshut and dbstart scripts as well, if you use them, as they have in the past not worked so well. Been awhile since I've even used them, so they may have improved while I wasn't looking. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/06/2003 10:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: STUPID LD_LIBRARY_PATHING!!@@@[EMAIL PROTECTED]@[EMAIL PROTECTED]Guys,I setup lsnrstartstop scripts for root that does the su -c to oracle and runs them. I could run as oracle successfully but using the su - c command brought me this error:"Oracle ld.so.1: /opt/oracle/product/9.2.0/bin/lsnrctl: fatal: libclntsh.so.9.0: open failed: No such file or directory/usr/oracle/tools/bin/lsnrstart[12]: 398 Killed"I quickly verified that the file libclntsh.so.0.0 existed. Therefore, I felt that it might have something to do with relinking. I tried relinking after shutting everything down and got the same type of ld.so.1 error. Then with my experience I realized that this usually related to LD_LIBRARY_PATH. I looked up relinking and found a note that states this:Doc ID: Note:131321.1 The note says:Oracle 9.X.X (64Bit) on Solaris (64Bit) OS - Set LD_LIBRARY_PATH=$ORACLE_HOME/lib32 - Set LD_LIBRARY_PATH_64=$ORACLE_HOME/lib I did this and it worked.I then verified that Oracle's environmental scripts (out-of-the-box) set LD_LIBRARY_PATH as I have always used these environment scripts. However, they do not set the path as listed above. In fact, the environment variable will overwrite LD_LIBRARY_PATH to the wrong setting.So, do I set LD_LIBRARY_PATH as above, I am a little confused since the environment script and this note do not match as to which setting is correct. For relinking I definitely know only the one above will work!! GAny opinions?-- 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.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
OT: SQLServer resources
Title: Message Hi all, Can anybody point me to a mailing list such as this for SQLServer? (I would be suprised if there's something of ORACLE-L's quality, but you never know!). Or, any other resources on the web? I'm particularly interested in production support (performance tuning, security, backup/recovery, etc.) Thank you very much! - Jerry
RE: SQLServer resources
Title: Message Thanks, everybody, for the SQL Server info... -Original Message-From: Farnsworth, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 2:40 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SQLServer resources Try this site; http://ls.sswug.org/cgi-bin/lyris.pl?site=sswugpage=topictopic=sql_servertext_mode=0lang=english And pick which listserver you want. The sql2k is a very good list to use as a resource. Dave -Original Message-From: Cunningham, Gerald [mailto:[EMAIL PROTECTED]Sent: Thursday, October 02, 2003 1:10 PMTo: Multiple recipients of list ORACLE-LSubject: OT: SQLServer resources Hi all, Can anybody point me to a mailing list such as this for SQLServer? (I would be suprised if there's something of ORACLE-L's quality, but you never know!). Or, any other resources on the web? I'm particularly interested in production support (performance tuning, security, backup/recovery, etc.) Thank you very much! - Jerry
RE: Solaris /etc/system values for Oracle8i
Check out doc ID 15566.1 at Metashlink. -Original Message- [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 7:55 PM To: Multiple recipients of list ORACLE-L Mario: If you are using Solaris with 2GB of memory, it will be awfully difficult, if not impossible, to run 6 instances of Oracle8i simultaneously. Basically, because of the use of semaphores and the way Solaris manages memory, I would say you could run 3 or 4 instances , depending on their size. But to have all six up and running, especially if you have to create them, will not work. Oracle usually needs 1 GB per instance while you are creating a database. While running it, you would not necessarily need that much. I advice you to upgrade the memory on the server to 8 GB. I suggest you budget 1 GB per Oracle instance. RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] .xerox.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Solaris /etc/system values for Oracle8i m 09/26/2003 06:19 PM Please respond to ORACLE-L Hi managers. I need modify /etc/systems parameters in my e450 box, it allow 6 instances for oracle 8i Box have 2 GB in RAM Next values are valid??? SHMMAX 0.5*(physical memory present in machine) SHMMIN 1 SHMMNI 100 SHMSEG 10 SEMMNI 100 SEMMSL Set to 10 plus the largestinitsid.ora PROCESSES parameter of an Oracle database on the system. SEMMNS Set to the sum of the PROCESSESparameter for each Oracle database except the largest one, plus 2 timesthe largest PROCESSES value, plus 10 times the number of Oracle databases. SEMOPM 100 SEMVMX 32767 Mario Henley Becerril Geldis * (52) +55 5326 3200 ext. 1588 * [EMAIL PROTECTED] System Administrator ___ sunmanagers mailing list [EMAIL PROTECTED] http://www.sunmanagers.org/mailman/listinfo/sunmanagers -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Becerril, Mario Henley 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: Cunningham, Gerald 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: Offshore protests
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: Cunningham, Gerald 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).
just curious - any Isabel outages
Title: Message Just curious if anybody experienced any significant outages due to Isabel?
RE: upgrade to 9i
Mladen you're crackin me up, dude! That looks good except for the reading part... -Original Message- Sent: Wednesday, July 30, 2003 12:19 PM To: Multiple recipients of list ORACLE-L No, that's the wrong way. The right way is to read first 3 pages, then try it out, using your production database, naturally, and when it fails, ask the questions on this list. Do not forget to put something like *** NEED URGENT HELP *** in the message subject, because that gives me an adrenaline rush. On 2003.07.30 11:14, Freeman Robert - IL wrote: I'd also suggest that you read the migration guide before you do any upgrade. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/30/2003 8:09 AM See doc ID 214887.1 -Original Message- Sent: Tuesday, July 29, 2003 5:54 PM To: Multiple recipients of list ORACLE-L Hi where can I find steps ( procedure ) for upgrading from 8.1.7 to 9i . Thanks, -ak Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter. The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance. If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail. Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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). -- Mladen Gogala Oracle DBA -- 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: Cunningham, Gerald INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: enterprise manager
the problem is you're trying to use enterprise mangler :P -Original Message- Sent: Wednesday, July 16, 2003 10:50 AM To: Multiple recipients of list ORACLE-L Check: drive:\ORACLE_HOME\sysman\log review the oms.log file... and send the details... HTH JL --- Ruth Gramolini [EMAIL PROTECTED] wrote: Is it an 8.0.x or 8i database? What version of OEM are you running? We need more info to be able to help you. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 6:19 AM hi i run ora8 on w2000 server. my problem is i can ping my database mydb without problems i can login with sqlplus as sys and it works fine but if i start the enterprise manager console and try to login as sys a error occours and means please check the management server status and settings. as managementserver i select mydb. what ican be the problem? thx martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: pfeffer 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: Ruth Gramolini 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: Jose Luis Delgado 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: Cunningham, Gerald 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).
Windohs - monthly at job
Title: Message Hi all, Does anybody know the syntax to schedule a monthly "at" job on Windows (2000)? I need to schedule a job for the 1st and 15th every month, and would like to avoid the Task Scheduler GUI. A virtual pint o' Guiness (mm...) for anybody who can help! Thanks! - Jerry
RE: Windohs - monthly at job
Title: Message Hi again... Well, go it to work. I was leaving out the time! Do'h!!! at 02:00 /every:15 "filename" worked... Thanks! I may need a few (virtual?) pints for myself after attempting Google searches on "at job scheduler" -Original Message-From: Cunningham, Gerald Sent: Tuesday, July 08, 2003 11:43 AMTo: [EMAIL PROTECTED]Subject: Windohs - monthly at job Hi all, Does anybody know the syntax to schedule a monthly "at" job on Windows (2000)? I need to schedule a job for the 1st and 15th every month, and would like to avoid the Task Scheduler GUI. A virtual pint o' Guiness (mm...) for anybody who can help! Thanks! - Jerry
RE: Windohs - monthly at job
Title: Message OK, that's a pint for Branimir, Rick, and Dave... aw, what the heck I'll buy a round for everybody! Make sure to let the foam settle... Thanks again! - Jerry -Original Message-From: Branimir Petrovic [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 1:45 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Windohs - monthly at job Jerry, to schedule "something" onlocal orremote Win2K computer: Simple (preferred), non-GUIway: - Make sure "Task Scheduler" service is running on the target system, - Open MSDOS "box" then: C:at \\%ComputerName% 23:00 /every:1 C:\myJob.bat C:at \\%ComputerName% 23:00 /every:15 C:\myJob.bat To see what's been scheduled: C:\atStatus ID Day Time Command Line--- 1 Each 1 11:00 PM C:\myJob.bat 2 Each 15 11:00 PM C:\myJob.bat Do not specify \\%ComputerName% - and the job is scheduled locally. The above is also visible from GUI Task Scheduler. Other way (to do the same): == By leveraging WMI (hideously complex ugly COM object hierarchy) that Win2K comes equipped with and by using "scripting for 21st century"the VB Script. For how to it (use M$ scripting) do - seethe TechNet Script Centerr http://www.microsoft.com/technet/treeview/default.asp?url=""> Section on "Task Scheduling": http://www.microsoft.com/technet/treeview/default.asp?url=""> Now, let'stalk abt.virtual pint... ;-) Branimir -Original Message-From: Cunningham, Gerald [mailto:[EMAIL PROTECTED]Sent: July 8, 2003 12:39 PMTo: Multiple recipients of list ORACLE-LSubject: Windohs - monthly at job Hi all, Does anybody know the syntax to schedule a monthly "at" job on Windows (2000)? I need to schedule a job for the 1st and 15th every month, and would like to avoid the Task Scheduler GUI. A virtual pint o' Guiness (mm...) for anybody who can help! Thanks! - Jerry
RE: Function Based Index - Not Used ???
Wow, there sure are a lot of Scott's in India...
-Original Message-
Sent: Thursday, May 29, 2003 9:30 AM
To: Multiple recipients of list ORACLE-L
JP,
In the EXPLAIN PLAN, it says Card=262146, indicating that the query
expects to retrieve over a quarter-million rows. Is that in fact
correct?
If so, the CBO is making the correct decision to perform a FULL table
scan. What was the comparison of elapsed times between the two plans,
the one being the FULL table scan and the other being the indexed scan?
I bet the FULL table scan query finished much more quickly...
You've got everything configured correctly -- simply a lousy index. The
CBO has to be coerced into using the index because it is not the best
plan to use.
Hope this helps...
-Tim
on 5/28/03 11:54 PM, Prem Khanna J at [EMAIL PROTECTED] wrote:
Guys,
create table Tab1 ( name varchar2(100),age int,state
varchar2(100),country varchar2(100));
insert into tab1 values ('SCOTT',25,'TN','India');
I have 20,00,000 records like above.
create index idx1 on tab1 (upper(name));
analyze table tab1 compute statistics;
analyze index idx1 compute statistics;
select age from tab1 where upper(name)='SCOTT'; --- this will return
around 50 records.
-
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2458 Card=262146
Bytes=2097168)
10 TABLE ACCESS (FULL) OF 'TAB1' (Cost=2458 Card=262146
Bytes=2097168)
--- INIT.ORA --
optimizer_mode=choose
compatible=8.1.0
query_rewrite_enabled=true
query_rewrite_integrity=trusted
---
It's Oracle 8.1.6/Win2K.
When i add a HINT, IDX1 is used.Why is it so ?
Why this SELECT does not use index IDX1 w/o a hint ?
TIA.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
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.net
--
Author: Cunningham, Gerald
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).
maxextents unlimited - value in dba_tables, dba_indexes
Title: Message Hi all, I have a database where all tables and indexes have maxextents set to unlimited. Why, in dba_tables, do some tables have a null value for maxetents and some have a value of2147483645? An index I just modified (previous value of maxextents was 249) now has a null value for maxextents: SQL alter indexapp_owner.index1 storage (maxextents unlimited); Index altered. SQL select owner, index_name, max_extents from dba_indexes 2 where owner = 'APP_OWNER' and index_name = 'INDEX1'; OWNER INDEX_NAME MAX_EXTENTS-- -- ---APP_OWNERINDEX1 It seems that some of the objects that have maxextents = null are partitioned, but not all. Anybody have an explanation?? Thanks! - Jerry Jerry Cunningham Principal Database Engineer Enterprise Applications USi [EMAIL PROTECTED] Office 410.897.3084 Cell 443.994.7359 SMS[EMAIL PROTECTED] AIM cunninghamjerryc
RE: sqlplus connect errors 1034/27101/svr4...
Hi Les, Check to see if you have enough semaphores available (/etc/system) for the cumulative number of PROCESSES for all your db's on the server. - Jerry -Original Message- Sent: Sunday, February 23, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Looked over some websites and still couldn't figure out why I was getting these errors. I made sure my variables were set and still could not connect. Any ideas? I'm running oracle 8.1.7 on solaris 9 (USparc10). Let me know if you need more info. error 1034: Oracle not avail. error 27101: shared memory realm does not exit svr4 error :2: No such file of directory -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Les Ayudo 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: Cunningham, Gerald 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: Trolling for ideas
Hi Dennis, Does anyone know how to turn on client-side SQL*Net tracing? Did anybody get back to you on this? Set these paramters in your sqlnet.ora file on the client you want to trace: TRACE_LEVEL_CLIENT = support trace_file_client=abfp_trace.txt trace_directory_client=c:\orant\net80\admin - Jerry -Original Message- Sent: Monday, February 10, 2003 9:54 AM To: Multiple recipients of list ORACLE-L Does anyone know how to turn on client-side SQL*Net tracing? Jeff - Thanks for your idea. We were able to find the sqlnet.log file, which I was unable to find previously. It does have the TNS-12560 error you predicted. The network guys think they have the switch port hard-coded to 100Mb/s full duplex, but are checking further. However, in the sqlnet.log, it says PROTOCOL=BEQ. Does anyone have any idea where that is coming from? In the tnsnames.ora file we have TCP. In the documentation it looks like BEQ is used when the listener and server are on the same node. It is true that both the listener and server are on the same Alpha server, so is this message normal? Thanks to everyone for the great ideas that you have provided on this issue. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 06, 2003 6:24 PM To: Multiple recipients of list ORACLE-L Dennis Is there an sqlnet.log file tossed up on the VB client that has a TNS-12203 (unable to connect to destination) error? If so, make sure that the switch port the Alpha is plugged into has been hard-coded to 100Mb/s full duplex. Friends don't let friends auto-negotiate Known problem with Alpha/Cisco gear... Just a shot in the dark...but this solved a lot of Maximo crash issues for us. Cheers Jeff Herrick On Thu, 6 Feb 2003, DENNIS WILLIAMS wrote: I have a developer that wrote a VB program using ADO, connecting to Oracle 8.1.6 on a Compaq Tru64 server. One program of his runs for hours each night, and sometimes receives an ORA-03113 end-of-file on communication channel. Not consistently, just sporadically, and at varying amounts of time. I have been unable to find anything in the server logs. We have traced the program and the error occurs during different SQL statements. Followed most of the tips I've located on solving ORA-03113 errors. I am coming to the conclusion that maybe the only solution will be to upgrade Oracle and hope that solves the problem. Unfortunately we can only upgrade to Oracle 8.1.7.4. Does anyone have any other ideas? Thanks. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -- 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: Jeff Herrick 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: Cunningham, Gerald 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
index hint ignored?
Title: Message
Hi
there.
I have a non-unique
index on a table, and I'm trying to force Oracle to usethe index - but it
always does a FTS. Why? (I've tried it with and withoutthe
alias)
SQL set
autotrace traceonlySQL SELECT /*+ INDEX(A,vehicle_veh_year_indx) */
DISTINCT veh_year 2 FROM TIREADVISOR.vehicle A 3
ORDER BY veh_year DESC;
20 rows
selected.
Execution
Plan--
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=118
Card=20 Bytes=80)
1
0 SORT (ORDER BY) (Cost=118 Card=20 Bytes=80)
2 1 SORT (UNIQUE) (Cost=67 Card=20
Bytes=80) 3
2 TABLE ACCESS (FULL) OF 'VEHICLE' (Cost=16
Card=19607 Bytes=78428)
===
select TABLE_NAME, INDEX_NAME, COLUMN_NAME,
COLUMN_POSITIONfrom dba_ind_columnswhere INDEX_OWNER =
'TIREADVISOR'and TABLE_NAME = ('VEHICLE') order by
1,2,4,3TABLE_NAME
INDEX_NAME--
--COLUMN_NAME
COLUMN_POSITION
---VEHICLE
VEHICLE_PKVEH_ID
1
VEHICLE
VEHICLE_VEH_YEAR_INDXVEH_YEAR
1
Thanks for any
help!
-
Jerry
RE: index hint ignored?
Title: Message
Thanks, Lisa.
This
particular table is rather small (~20,000 rows, 1.3 Mb in size, 20 distinct
values for VEH_YEAR) - so it may be faster doing a FTS scan, not sure. I was
mainly wondering why my hint was ignored. It's a WebSphere app (The person who
wrote it is long gone!) where this statement gets executed thousands of times a
day, so if I could shave some time off the query it may
help...
Thanks
again!
-
Jerry
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003
1:56 PMTo: [EMAIL PROTECTED]; Cunningham,
GeraldSubject: RE: index hint ignored?
Hi
Jerry,
Methinks it's because this is a small table. 20
records? Peanuts. Why bother with the index.
On
the same token you should probably not spend a lot of time worrying about
this... unless this is just a learning exercise :)
hth
Lisa Koivu
OracleDiaper
Administrator Fairfield Resorts,
Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063
-Original Message-From: Cunningham, Gerald
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003
1:31 PMTo: Multiple recipients of list
ORACLE-LSubject: index hint ignored?
Hi
there.
I have a
non-unique index on a table, and I'm trying to force Oracle to usethe
index - but it always does a FTS. Why? (I've tried it with and
withoutthe alias)
SQL
set autotrace traceonlySQL SELECT /*+ INDEX(A,vehicle_veh_year_indx)
*/ DISTINCT veh_year 2 FROM TIREADVISOR.vehicle A
3 ORDER BY veh_year DESC;
20 rows
selected.
Execution
Plan--
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=118
Card=20 Bytes=80)
1
0 SORT (ORDER BY) (Cost=118 Card=20 Bytes=80)
2 1 SORT (UNIQUE) (Cost=67 Card=20
Bytes=80) 3
2 TABLE ACCESS (FULL) OF 'VEHICLE'
(Cost=16 Card=19607 Bytes=78428)
===
select TABLE_NAME, INDEX_NAME,
COLUMN_NAME, COLUMN_POSITIONfrom dba_ind_columnswhere INDEX_OWNER =
'TIREADVISOR'and TABLE_NAME = ('VEHICLE') order by
1,2,4,3TABLE_NAME
INDEX_NAME--
--COLUMN_NAME
COLUMN_POSITION
---VEHICLE
VEHICLE_PKVEH_ID
1
VEHICLE
VEHICLE_VEH_YEAR_INDXVEH_YEAR
1
Thanks for any
help!
-
Jerry
RE: index hint ignored?
Title: Message
I've
tried it both ways, with the comma and without - same result.
-Original Message-From: K
Gopalakrishnan [mailto:[EMAIL PROTECTED]] Sent: Friday, January 31,
2003 2:13 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: index hint ignored?
Hi,
THe
syntax is incorrect. Incorrect HINTs are treated as
comments.
replace the comma with blank space and your hint will
work
as
expected.
Best Regards,K Gopalakrishnan
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Cunningham,
GeraldSent: Friday, January 31, 2003 10:31 AMTo:
Multiple recipients of list ORACLE-LSubject: index hint
ignored?
Hi
there.
I have a
non-unique index on a table, and I'm trying to force Oracle to usethe
index - but it always does a FTS. Why? (I've tried it with and
withoutthe alias)
SQL
set autotrace traceonlySQL SELECT /*+ INDEX(A,vehicle_veh_year_indx)
*/ DISTINCT veh_year 2 FROM TIREADVISOR.vehicle A
3 ORDER BY veh_year DESC;
20 rows
selected.
Execution
Plan--
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=118
Card=20 Bytes=80)
1
0 SORT (ORDER BY) (Cost=118 Card=20 Bytes=80)
2 1 SORT (UNIQUE) (Cost=67 Card=20
Bytes=80) 3
2 TABLE ACCESS (FULL) OF 'VEHICLE'
(Cost=16 Card=19607 Bytes=78428)
===
select TABLE_NAME, INDEX_NAME,
COLUMN_NAME, COLUMN_POSITIONfrom dba_ind_columnswhere INDEX_OWNER =
'TIREADVISOR'and TABLE_NAME = ('VEHICLE') order by
1,2,4,3TABLE_NAME
INDEX_NAME--
--COLUMN_NAME
COLUMN_POSITION
---VEHICLE
VEHICLE_PKVEH_ID
1
VEHICLE
VEHICLE_VEH_YEAR_INDXVEH_YEAR
1
Thanks for any
help!
-
Jerry
RE: index hint ignored?
Title: Message
Hi
Dan,
H.
That's interesting. Yes, the column does allow nulls. Not sure if there actually
are any null values, I'll have to check...
Thanks!
-
Jerry
-Original Message-From: Fink, Dan
[mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003 2:31
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
index hint ignored?
Gerald,
Is veh_year a nullable column? If so, an index lookup may
give you incorrect results (nulls are not indexed), so a full table scan will
be used.
Of course, is a full table scan a bad choice? Don't worry
about the access path, find the plan that incurs the fewest I/Os and returns
the quickest.
Dan
Fink
-Original Message-From: Cunningham, Gerald
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003
11:31 AMTo: Multiple recipients of list
ORACLE-LSubject: index hint ignored?
Hi
there.
I have a
non-unique index on a table, and I'm trying to force Oracle to usethe
index - but it always does a FTS. Why? (I've tried it with and
withoutthe alias)
SQL
set autotrace traceonlySQL SELECT /*+ INDEX(A,vehicle_veh_year_indx)
*/ DISTINCT veh_year 2 FROM TIREADVISOR.vehicle A
3 ORDER BY veh_year DESC;
20 rows
selected.
Execution
Plan--
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=118
Card=20 Bytes=80)
1
0 SORT (ORDER BY) (Cost=118 Card=20 Bytes=80)
2 1 SORT (UNIQUE) (Cost=67 Card=20
Bytes=80) 3
2 TABLE ACCESS (FULL) OF 'VEHICLE'
(Cost=16 Card=19607 Bytes=78428)
===
select TABLE_NAME, INDEX_NAME,
COLUMN_NAME, COLUMN_POSITIONfrom dba_ind_columnswhere INDEX_OWNER =
'TIREADVISOR'and TABLE_NAME = ('VEHICLE') order by
1,2,4,3TABLE_NAME
INDEX_NAME--
--COLUMN_NAME
COLUMN_POSITION
---VEHICLE
VEHICLE_PKVEH_ID
1
VEHICLE
VEHICLE_VEH_YEAR_INDXVEH_YEAR
1
Thanks for any
help!
-
Jerry
RE: Slow database, too MANY buffers???
$ and sys.user$ rather than dba_extents. Thomas Day [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/24/2003 10:39 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Slow database, too MANY buffers??? So this is what you're looking for? col segment_name format a30 col segment_type format a10 select segment_name, segment_type, count(*) from dba_extents, x$bh where file_id = file# and dbablk between block_id and block_id + blocks - 1 group by segment_name, segment_type HAVING count(*) 5 ORDER BY 3 / Jared.Still @radisys.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: rootcc: Subject: Re: Slow database, too MANY buffers??? 01/24/2003 12:34 PM Please respond to ORACLE-L I just use this script that I originally used for finding which object corrupt blocks are in. Serves well for this as well. Note that file_id is the incorrect column to use on a database with 1022 data files. I think you need to use relative_fno in that case. Jared -- ora_1578.sql -- use args from ORA-1578 errors to find -- file and segment generating the error col cfileid new_value ufileid noprint col cblockid new_value ublockid noprint prompt File ID: set term off feed off select '1' cfileid from dual; set feed on term on prompt Block ID: set term off feed off select '2' cblockid from dual; set feed on term on --define ufileid=8 --define ublockid=129601 select file_name FILE WITH CORRUPT BLOCK from dba_data_files where file_id = ufileid / col segment_name format a30 col segment_type format a15 select segment_name, segment_type from dba_extents where file_id = ufileid and ublockid between block_id and block_id + blocks - 1 / undef 1 2 Thomas Day [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/24/2003 07:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Slow database, too MANY buffers??? We'll I don't want to show my ignorance but I'll never learn if I don't ask. How do you get from DBABLK to PK_MATERIAL_ORDER_POOL? Jared.Still @radisys.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: rootcc: Subject: Re: Slow database, too MANY buffers??? 01/23/2003 04:09 PM Please respond to ORACLE-L Well, I'm close. I just ran this on the DEV database for an app that is in the 'upgrade' process. FILE# DBABLK COUNT(*) -- -- -- 10 38968 6 11 22753 6 11 40180 6 11 74893 6 16 104388 6 16 104511 66 6 rows selected. Which resolves to index PK_MATERIAL_ORDER_POOL. Looks like further investigation is in order. 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: Cunningham, Gerald 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, Siebel and rule-based optimization
Title: Message
Hi
there,
We run
quite a bit of Siebel here, against everything from 7.3.4 to 8.1.7. They all run
rule-based. We have set optimizer mode to CHOOSE and analyzed tables in the past
- performance got dramatically worse!
You
can probably get some individual statements to run better cost-based, but the
app as a whole does run betterrule based.
One
thing to watch out for - Siebel creates all objects using default storage
clauses ("to save space" I was told by a Siebel consultant, since there are
typically hundreds of unused tables). Go with LMT to be safe. I learned the hard
way, with a database that contained more than 2 MILLION extents. Had to rebuild
with LMT... even coalescing a TS took days... (learned some internal stuff
tho')
-
Jerry
-Original Message-From:
Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Thursday,
January 30, 2003 12:51 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Oracle, Siebel and rule-based
optimization
Michael:
Would you please post a summary of findings here on the list?
I
too have a Siebel implementation going on, and we are
experiencing performance issues, and have set all
the
Siebel-specified initSID.ora parameters.
I am in California, and the database is 'across the pond'
in
Europe, so I am doing this remotely, and about
8 hours out of
phase with my
users. Any knowledge transfer will be appreciated.
Thanks
Mike
-Original Message-From: Michael Fontana
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 30, 2003 7:41
AMTo: Multiple recipients of list ORACLE-LSubject:
Oracle, Siebel and rule-based optimizationI
would like to ask a question of this esteemed and knowledgeable audience
about runningSIEBEL applications on Oracle. Siebel insists
that their CRM application will only run withacceptable performance if
rule-based optimization is chosen, yet, as we all know, there
aredocumented examples of poor performance, and strong recommendations
to the contrary from Oracle.At one point, I recall reading an
article from a knowledgeable consultant describing what must be doneto
get Siebel to run with optimizer_mode=choose. Any assistance in
reaching this goal, or comments, would be more than appreciated.
We're still in the implementation phase, and are already receiving poor
performance on certain processes, even using the recommended rule based
optimization. I predict it will only get
worse!
RE: Free Shared pool memory
Title: Message did somebody say free beer?! -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 9:44 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Free Shared pool memory Sorry for being so vague, but sometimes I can't help it... It was my understanding in the Oracle7 days that the name of thestatistic "free memory"was actuallya verb and a noun (i.e. as in "free Nelson Mandela"or "free Willy"), and the number shown alongside this statistic was the cumulative number of bytes freed in the Shared Pool. In other words, every time"N" bytes were freed from the Shared Pool, then the statistic was incremented by "N". At least, this explanation would haveaccounted for the absurdly huge numbers seen in the V$SGASTAT view for this statistic in those versions and the unreliability in attempting to add the numbers seen in V$SGASTAT to sum to SHARED_POOL_SIZE... Then, sometime in the Oracle8 or Oracle8i timeframe, the meaning of the statistic was changed so that the term "free memory" became what everyone had thought it was, an adjective and a noun (i.e. as in "free beer" or "free time"). A much more useful statistic, certainly... Is this true? If not, is it close? The sum of the information in V$SGASTAT still does not add to SHARED_POOL_SIZE, though (query from v8.1.7.4.0 shown below): SQL select name, bytes from v$sgastat 2 where pool = 'shared pool'; NAME BYTES-- --free memory 18208352miscellaneous 2378964DML locks 12PLS non-lib hp 2096trigger inform 944PL/SQL MPCODE 1146204PL/SQL DIANA 1223360PX subheap 123476db_block_hash_buckets 1411080sessions 377300KGK heap 48124State objects 267420message pool freequeue 124552Checkpoint queue 885168enqueue_resources 222912db_files 370988KGFF heap 649844KQLS heap 1709904dictionary cache 12670280table definiti 3228transactions 171264ksfv subheap 4248fixed allocation callback 1280library cache 89490788simulator trace entries 24sql area 187432036table columns 19520processes 123380partitioning d 152976db_block_buffers 1088event statistics per sess 607600 --sum 331067288 SQL show parameter shared_pool_size NAME TYPE VALUE--- --- -shared_pool_size string 314572800 I'm curious about the 16,494,488 bytes difference. Is it possible that V$SGASTAT is another "unlatched" data structure in memory, allowing errors in the interest of eliminating contention? There are other similar structures in the SGA (i.e. the data structure underlying table MONITORING statistics later flushed to SYS.TABMOD$)... Thanks for any and all insight! - Original Message - From: "Jonathan Lewis" [EMAIL PROTECTED] To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, January 02, 2003 3:28 AM Subject: Re: Free Shared pool memory I think it's safe to say that if the free memory is always very large then you can reinterpret it as 'wasted memory'. If the free memory is alway very small, I don't think it is possible to make any decision without know the application. It is possible that you need to increase the shared pool slightly (good app), it is also possible that your shared pool is just about the right size (great app) , but it is possible that your application design has a flaw in it. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 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] Date: 02 January 2003 05:39Is it Correct to Look at FREE Memory in the Shared Pool ? Memory when used once thereafter when NO Longer in use does the FREE Memory again Come up ? Are there any ideal Values for percentage of Free memory for the Shared Pool The Respective Hybrid Application mostly uses Bind Variables Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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
RE: shareplex core dumps - help
Sounds like a bug. If SharePlex gets an error applying SQL to the target, the table should get marked out-of-sync and Shareplex should go on it's merry way. Call Shareplex Support - they are usually very responsive. - Jerry -Original Message- Sent: Thursday, November 07, 2002 11:35 AM To: Multiple recipients of list ORACLE-L Hi all, We are having a shareplex issue and I am hoping someone here with shareplex knowledge can help me out. I don't know much about shareplex. Basically we are replicating to a target table which is partitioned by date. And partitions that are 3 days old will be set to read-only because there are not suppose to be anything new. But occasionally, some record with timestamp older than 3 days creep up, so of course shareplex couldn't put the record into the target partition because it's read-only. Now the problem is shareplex core dumps when this happens. I am very surprised that we couldn't have a rule that tells shareplex if you can't replicate then either discard the record or put it elsewhere. Core dump seems to be a extreme reaction to this. unfortunately this is hosted and ran by a hosting company and I have no shareplex here to test or verify. Any help is appreciated. Thanks Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard 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: Cunningham, Gerald 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: Rant
Has anybody ever come across a virus that affects Oracle db's via sqlnet? Just curious how such a thing would work (have some ideas). There have to be thousands of vulnerable db's out there (sys/change_on_install, system/manager, etc.) (I've been reading Tom Clancy lately... Getting even more paranoid!) - Jerry -Original Message- Sent: Tuesday, July 23, 2002 7:39 AM To: Multiple recipients of list ORACLE-L Security is like insurance, people don't want to think about it. Like people in battle, everyone tells themselves that the person next to them will be the one to get shot. And they advance over the ridge, facing the sun... Regards, 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.com -- Author: Boivin, Patrice J 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 email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the intended recipient(s). Any review, reliance, or distribution by others or forwarding without permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cunningham, Gerald 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: Rant
PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the intended recipient(s). Any review, reliance, or distribution by others or forwarding without permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cunningham, Gerald 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).
partitioning
Title: Message Hi all, Does anybody know with what version of Oracle partitioning was included at no extra cost? Thanks! - Jerry
RE: partitioning
Damn! -Original Message- Sent: Wednesday, May 22, 2002 1:19 PM To: Multiple recipients of list ORACLE-L Absolutely true! Even worse, it is an option on top of Enterprise Edition, so you can't license Standard Edition and buy the partitioning option. -Original Message- Sent: Wednesday, May 22, 2002 12:06 PM To: Multiple recipients of list ORACLE-L None It is an option (Means you pay). Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Wednesday, May 22, 2002 6:38 PM Hi all, Does anybody know with what version of Oracle partitioning was included at no extra cost? Thanks! - Jerry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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: Cunningham, Gerald 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).
DB2
Title: Message Hi there, Does anybody know if there's a list such as this one for DB2? Or, a link to DB2 documentation (maybe something like the Oracle Concepts Guide)? Thanks! - Jerry
RE: Do you use RMAN?
I use it, I think it's great. Runs faster (if you multi-thread it), doesn't put the tablespaces in hotbackup mode (doesn't freeze file header blocks), and checks for corruption. Tim Gorman has a good paper on his website (http://www.evdbt.com/) : http://www.evdbt.com/TD_Rman.pdf - Jerry -Original Message- Sent: Wednesday, March 06, 2002 10:48 AM To: Multiple recipients of list ORACLE-L 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: Cunningham, Gerald 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: Does anybody really know what time it is?
does anybody really caare? Who woo woo :) -Original Message- Sent: Thursday, February 28, 2002 5:56 PM To: Multiple recipients of list ORACLE-L I want to get the UTC (Coordinated Universal Time) from the database without having to escape to the O/S or write a stored proc. I want to get this time in GMT epoch seconds without needing to know what timezone the server is in. Can't find any Oracle supplied package for this and I'm appalled. My current medulla oblongata init.ora setting is clues = 0. Suggestions? 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: Cunningham, Gerald 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 FM???
Title: Message http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76961/ch3.htm -Original Message-From: Rodd Holman [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 1:53 PMTo: Multiple recipients of list ORACLE-LSubject: Which FM???I'm looking for descriptions of the more cryptic columns in some of the V$'s. Anyone know which FM those are in? TIA Rodd
RE: FW: Expiration of your subscription to the ORACLE-L list
Title: Message I (vaguely) remember SUNYSB from the early/mid nineties. Definitely pre-Jared. May the guy is caught in a time warp or something? spooky -Original Message-From: Bellows, Bambi [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 3:53 PMTo: Multiple recipients of list ORACLE-LSubject: RE: FW: Expiration of your subscription to the ORACLE-L list Wasn't SUNYSB the server when Sanjay ran the list? Bambi. -Original Message-From: Rodd Holman [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 1:58 PMTo: Multiple recipients of list ORACLE-LSubject: Re: FW: Expiration of your subscription to the ORACLE-L list That's obviously a different ORACLE-L. This list is on fatcity.com and admin commands (subscribe, unsubcribe, etc.) are run through [EMAIL PROTECTED] Rodd On Fri, 2002-03-01 at 12:48, Hamid Alavi wrote: List,I want to know if any of you received a message like this forre-subscribe???-Original Message-[mailto:[EMAIL PROTECTED]]Sent: Friday, March 01, 2002 3:00 AMTo: Hamid AlaviFri, 1 Mar 2002 06:00:01Your subscription to the ORACLE-L list has expired and you have failed toconfirm it in the 7 day delay that you had been granted. You havetherefore been automatically removed from the list. You can re-subscribeto the list, if you want to, by sending the following command to[EMAIL PROTECTED]: SUBscribe ORACLE-LThe information contained in this message and any attachments is intendedonly for the use of the individual or entity to which it is addressed, andmay contain information that is PRIVILEGED, CONFIDENTIAL and exempt fromdisclosure under applicable law. If you have received this message in error,you are prohibited from copying, distributing, or using the information.Please contact the sender immediately by return e-mail and delete theoriginal message from your system.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Hamid Alavi INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: RE: RE: RE: Manager decrees his data warehouse design.
Actually, they're different. SAN = faster, more $$$ (e.g. EMC) NAS = slower, less $$$ (e.g. Network Appliance) -JC -Original Message- Sent: Thursday, February 28, 2002 9:38 AM To: Multiple recipients of list ORACLE-L Patrice, They are synonyms for each other as far as I understand. Dick Goulet Reply Separator Author: Boivin; Patrice J [EMAIL PROTECTED] Date: 2/28/2002 3:38 AM I guess the reverse of SAME is EMAS, where Everything Makes Absolute Sense. : ) NAS, is that the same thing as a SAN? Network - Attached Storage Storage Area Network Here we have a couple of SANs, but I think they also fit the description you gave of an NAS. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Wednesday, February 27, 2002 6:53 PM To: Multiple recipients of list ORACLE-L S.A.M.E, Stripe And Mirror Everything. It's a concept that came from an individual at Oracle with a significant pile of alphabet soup after his name who has lost most of his credibility anywhere. He was speaking though of Network Attached Storage (NAS) stuff where you really don't have to worry about the mount point/drive letter where you put the datafile(s). These neato devices do make some of the DBA's tasks of IO balancing meaningless since they do stripe data across multiple disks and run hardware mirroring in the background. In turn they retrieve your data from the most efficient place possible buffer your writes in cache memory that 'guarantees' that it will absolutely make it to disk. What I think has happen is that some of his idea was taken out of context, though not out of quote, and made meaningless. You should still have logical database design and multiple tablespaces/datafiles. It's just that you really don't care is everything is on drive H. Dick Goulet PS: I've not implemented such an idea have no intention thereof in the near future. Reason, NAS storage is not here. Reply Separator Author: Michael Cupp [EMAIL PROTECTED] Date: 2/27/2002 1:20 PM S.A.M.E.? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: Cunningham, Gerald 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).
looking for a DBA
Title: Message At the risk of revealing myself as Damagement... we are looking for an Oracle DBA: http://www.usi.net/careers/listopenings.html?D139 I am the direct hiring damager, but you should apply through our website. I will be happy to answer questions, though. Thanks! - Jerry
RE: Upgrade directly to 8.1.7.3?
Hi Barabara, The wording is a bit clumsy, isn't it? I would think you'd be fine since you're not really applying a patch, you've already got the binaries in place. The 4th digit is just bug fixes, the upgrade scripts (catalog.sql, catproc.sql, catrep.sql, etc. should be the same across all 8.1.7.x installs. Right? Of course I could be completely wrong! - Jerry -Original Message- Sent: Wednesday, February 27, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Solaris 2.6 Oracle 8.0.5 -- Oracle 8.1 -- Oracle 8.1.7.3 I have a Solaris box with a test and a production database. I have 2 code trees: 8.0.5, and 8.1.7 patched up to level 8.1.7.2. With Oracle's blessing (really, I opened a tar), I upgraded the test database directly from 8.0.5 to the 8.1.7.2 patch level. Did not pass go. Did not collect $200. OK, here's a surprise. I still have not had an opportunity to upgrade production, which is still at 8.0.5, and now I'd like to upgrade it to patch level 8.1.7.3. However, the 8.1.7.3 patch documentation states that When migrating a database from an earlier release, you must complete the database migration to the 8.1.7 release prior to applying this patch set. If I believe this note, then I believe I must install a new code tree with a vanilla 8.17, then upgrade production from 8.0.5 to 8.1.7, then immediately upgrade again to 8.1.7.3My problem: I don't have an extra gig of space to devote to another code tree. (And obviously I want to thoroughly test the test database with exactly the same version I'll be running in production, i.e., 8.1.7.3.) I don't see a good reason not to go immediately to 8.1.7.3, especially since I was able to go directly to 8.1.7.2 with the test database, which worked nicely. However, this is a critical database, and I'd just as soon not screw it up. Any words of widsom? Thanks for any help. Barb q (Jesse: I'm currently taking classes for the q-impaired. I'm feeling much better now.) -- 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: Cunningham, Gerald 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: Database Performance Question
of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cunningham, Gerald 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 extents are OK, dagnabbit!
Title: Message Hi there - I'm trying to convince a client that multiple extents for a table will not hurt their performance. It's a PeopleSoft app, and PeopleSoft is telling them that they need to reorg any object with greater than 10 extents (even indexes). This Oracle 8.1.6. I've referenced the "How to Stop Defragmenting and Start Living: The Definitive Word on Fragmentation" white paper by Bhaskar Himatsingka and Juan Loaiza of Oracle. That didn't convince them. I tried to explain that Oracle reads BUFFERS and not extents, etc., but that didn't work. I'm about to open a vein. Does anybody have any references that they can point me to? (Something from PeopleSoft would be ideal, though I would be suprised if it existed.) I read a rant on somebody's web site a while back that was really good, but alas I cannot remember his name or URL. (I blame my kids for my failing memory). Thanks! - Jerry
