RE: OT RE: Oracle being scalable

2001-04-05 Thread Gogala, Mladen
You mean, the infamous "Atlanta" database which was showing runners 30ft tall and 99 yrs. old? That one was worth remembering it. -Original Message- Sent: Thursday, April 05, 2001 3:35 PM To: Multiple recipients of list ORACLE-L LoL! The "Winter Corporation"? Which databases were

RE: 8.1.6 vs 8.1.7

2001-04-05 Thread Tom Pall (E-mail)
We're in the process of migrating all of our 8.0.5 to 8.1.6 databases over to 8.1.7.1. We'll be done in a few weeks. We used 8.1.7.0 on our reporting and other non-money making databases since it was released. The few cosmetic issues we had with 8.1.7.0, like v$buffer_pool_statistics being

RE: OT why is there dinosaur statues and evolution of human conciousness

2001-04-05 Thread Eric D. Pierce
call me a prematurely cantankerous curmudgeon, but aren't "making money" and "best ...business strategy" completely intertwined with all the unsavory product related stuff you mention (and more, eg "anti-trust") hopelessly, relentlessly unrepentantly holistic, ep ps, what

RE: OT why is there dinosaur statues and evolution of human conciousness

2001-04-05 Thread David Messer
Sure they're intertwined, that doesn't mean I criticize all of it. I don't blame Gates for (apparently) wanting to control the world or monopolize large portions of it. I believe that's fairly common among CEO's. I criticize his endorsement of a policy - upgrades out the wazoo - that has led

RE: Recovery from noarchive db corrected

2001-04-05 Thread Sinardy Xing
Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001 8:54 PM To: LazyDBA mailing list Turn archiving on. -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 AM

Re: Recovery from noarchive db corrected

2001-04-05 Thread Joseph S. Testa
assuming you're the dba, since when does the developer dictate recoverability to a DBA about a database. sounds like a role problem there. joe Sinardy Xing wrote: Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001

Common Subquery Elimination in 8.1.7 causes incorrect results -

2001-04-05 Thread Reardon, Bruce (CALBBAY)
Hi, There is a note on Metalink (137430.1 reproduced below) describing a generic 817 optimiser problem that will result in incorrect results when using certain query types. We are currently running 81511 on NT but testing an upgrade to 81711 on NT at the moment. The note suggests 2

please ignore: test message

2001-04-05 Thread Viraj Luthra
test message Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Re: Common Subquery Elimination in 8.1.7 causes incorrect

2001-04-05 Thread Larry Strickland
I would strongly suggest the: optimizer_features_enable = 8.1.6 because it also cures another problem with 8.1.7 wherein a complex query with multiple OR and AND conditions will return the wrong number of rows if you are using CBO (and/or any statistics are on the resultant table). larry At

RE: Recovery from noarchive db corrected

2001-04-05 Thread Sinardy Xing
The developer application running huge batch inserting data into database, that is what they told me, if you are me what you will do? -Original Message- Testa Sent: Friday, 6 April 2001 11:55 AM To: Multiple recipients of list ORACLE-L assuming you're the dba, since when does the

RE: Recovery from noarchive db corrected

2001-04-05 Thread Suhen Pather
Sinardy, Who will recover the database in case of a failure? Turing on archiving would not hinder performance so much. Proper planning of your backup strategy and db setup will have little overhead on performance of your database. You cannot sacrifice backups for a marginal increase in

RE: Recovery from noarchive db corrected

2001-04-05 Thread Arn Klammer
The actual archiving of log files itself should not impact the performance of the insert jobs, unless the archiving process is slow enough to cause the database to pause while a log is archived so it can be reused. The only other reason why the developers wouldn't want it is if the space

Re: Histogram Helper

2001-04-05 Thread Binley Lim
The documentation has under-sold this feature. Even for columns that do not look very skewed at all, histograms helps to turn ugly explain-plans to very fast ones. Somewhere inside the optimizer, histograms help it decide on sensible join-orders amongst other things. You didn't say, but I

Urgent !!! - Database Installation

2001-04-05 Thread Wendy Y
Dear DBAs: There might have some one post before, but I can't recall the answer now. We have completely gone through oracle 8.1.6 installation on window 2000 server. When we run net8 configure assistant, The computer frozen. Then we have to cancel it but listener.ora has been configured. When we

RE: (Fwd) RE: MS-DOS commands - list of ??? / Re: WINNT-L Di

2001-04-05 Thread Abdul Aleem
I have noticed that information passed on by Mr. Pierce is useful, direct, my question is: WHICH SEARCH ENGINE DO YOU USE, MR. PIERCE? Regards, Aleem -Original Message- Sent: Wednesday, April 04, 2001 5:06 AM To: Multiple recipients of list ORACLE-L Subject:(Fwd) RE:

RE: Common Subquery Elimination in 8.1.7 causes incorrect

2001-04-05 Thread Reardon, Bruce (CALBBAY)
Larry, Thanks for the information. Do you have a bug number reference for the other problem you mention? Thanks, Bruce -Original Message- Sent: Friday, 6 April 2001 14:45 I would strongly suggest the: optimizer_features_enable = 8.1.6 because it also cures another problem with 8.1.7

<    1   2