Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle is crap how to switch to ms-sql

Re: oracle is crap how to switch to ms-sql

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: 12 May 2002 10:42:22 -0700
Message-ID: <abm9hu02b5c@drn.newsguy.com>


In article <2687bb95.0205120918.5660fd7e_at_posting.google.com>, Mark.Powell_at_eds.com says...
>
>"Fred Nurk" <frnurk_at_yahoo.com.au> wrote in message
>news:<44rD8.8700$b5.28915_at_newsfeeds.bigpond.com>...
>> What about "master-bates" ?
>>
>> koert54 wrote in message ...
>> >maybe you should rename your nick from 'master-dba' to 'crap-dba'
>> >
>> >"master-dba" <master-dba_at_aol.com> wrote in message
>> >news:abl9o6$ocm$01$1_at_news.t-online.com...
>> >> hi,
>> >>
>> >> oracle is so old-fashioned how easily can one switch to
>> >> foxpro or access ?
>> >>
>> >> or should I use sqlserver ?
>> >>
>> >> can i operate it with a windows-gui ?
>> >>
>> >> we have a large database with 300mb which is very slow,
>> >> can such a huge database be loaded in sql-server ??
>> >>
>> >> what hardware do i need ?
>> >>
>> >> we work with oracle 7.0.1.3.4.5 on novell
>> >>
>> >>
>
>The release of Oracle you are complaining about is at least 7 years
>old. The never releases come with several GUI tools. Perhaps you
>should consider upgrading to a supported version, and then you would
>be making a fairer comparison.

Actually they must have something wrong here. There never was a release 7.0.1 that would have been available for public consumption. FIrst production release was 7.0.13.

>
>Also 300MB is a very small database; Out main OLTP has tables whose PK
>size exceeds 300MB. Performance of any database is at least partially
>dependent on the hardware configuration upon which you run it, and on
>the tuning effort put into the application SQL/objects. When was the
>last time any of the indexes in your problem system were rebuilt?
>Statistics updated? Tables re-organized?
>
>HTH -- Mark D Powell --

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Sun May 12 2002 - 12:42:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US