Re: Re: LINUX and Oracle Corp.

ltiu£¬ hi, i have the same experience with Jread, Dell does outperform sun, i have Dell 2550 with 2 1.4G P3CPU/2G memory, with Sun 220 2Gmemory/2CPU, Dell is better than sun with regard to oracle responce time and os cpu idle time. My application is cpu entensive and memory intensive,

Re: Execute oexec(): ORA-01467: sort key too long

If I recall correctly this restriction is removed in later versions of Oracle or the limit has been raised. Don't know anymore specifics though. Anjo. Kris Austin-Murray wrote: disregard the first SELECT sent. was given the wrong query. *this* uglyquery is the one that fails both in the

VB doubt

can any one send me the code for getting the server name to which the current working machine is connected to... this code i want in VB guys... help me very urgent... Regards, Prakash. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: guess who INET: [EMAIL

Re: soft parse

Rewriting is one option. commercial Another option is using this product that I have build. That will take care of this without changing your application. The benefits are huge, as the contention in the database will dissapear, response times will improve ! /commercial Anjo. BigP wrote:

Re: UNIX Q: How do I delete files beginning with #

I have files like: #Column #This # How do I get rid of these 3? rm \#Column or rm #Column or rm '#Column' If yopu want to get rid of files beginning with - ( -file.txt ) you should run: rm -- -file.txt -- /Nils Höglund, Naqua KB E-mail: [EMAIL PROTECTED] Web:

Migrating Advanced Queue from 8i (8.1.6.3.0) to 9i (9.0.1.3.0)

Hello all, We have here some advanced queues running under Oracle 8.1.6.3.0. There is no problem with production. Now, we're trying Oracle9i (9.0.1.3.0), so we'd installed the Oracle software and we'd migrated this instance to new version. Then, this problem arise, because we could not

Re: Migrating Advanced Queue from 8i (8.1.6.3.0) to 9i (9.0.1.3.0)

Take a look at line 3121 and line 237 of SYS.DBMS_AQADM. This will definitely give you some clues. ltiu On Saturday 03 August 2002 08:38, you wrote: Hello all, We have here some advanced queues running under Oracle 8.1.6.3.0. There is no problem with production. Now, we're trying Oracle9i

Re: 20 Instances 1 Machine

Twenty Instances? At 500M per SGA, you're talking a minimum of 12+ G of RAM. How many users per instance? More RAM. Are these OLTP or Datawarehousing type DBs? Disk and I/O and RAM. 24 x 7? If one has to be, then you're going to need some type of failover/standby capability. What vendor

Re: LINUX and Oracle Corp.

On Friday 02 August 2002 20:38, ltiu wrote: RH 2.7 with Oracle 8 and 9 wow!!! where did you get these beasts to work together? 8.1.7 required a bit of work... 9iR1 never did work 9iR2 was fairly simple The Dell is a fast machine with some nice ultra wide SCSI ports. The Sun is a low end

Re: LINUX and Oracle Corp.

OK. I should try Linux with Oracle then. Cheap(er) alternative. Cheapest would be Linux with Postgresql/MySQL but functionality is not there yet. Price-wise, is the performace of Dell better than Sun? Dollar/performance ? How much (cost) is the Dell and how much is the Sun? ltiu On Saturday

IOUG call for papers

IOUG has announced call for papers for IOUG Live 2003 in Orlando FL. http://www.ioug.org/call Check it out, i've submitted my 2 proposals already :) Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services

Re: Live Webcast: The death of the buffer cache hit ratio

Thanks Jared, Drinks are on me ;-) [EMAIL PROTECTED] wrote: Ok, everybody, let's show up in support of Anjo.This should be a great presentation. Sorry if someone has already posted this to the list today, I just haven'thad time to read it yet today.Jared-SearchEBusiness

Re: Re: LINUX and Oracle Corp.

Dunno what you got for 4k, mine was 12k. Still significantly less than the Sun, which is why I asked for it. Jared On Saturday 03 August 2002 01:23, chaos wrote: ltiu£¬ hi, i have the same experience with Jread, Dell does outperform sun, i have Dell 2550 with 2 1.4G P3CPU/2G memory,

Data Type in A View

We do a fair bit of development using the Remedy tools. One of those developers is using what is known as a view form. This device does not allow one to specify the data type, but gets it from the database. However if a field is declared thus, num1 number, the view form will treat it as

RE: Monitoring occurence of snaphot too old

Even not setting optimal (or leaving optimal at null) does not prevent the RBS blocks being overwritten if they represent a commited transaction. Hemant At 07:18 PM 03-08-02 -0800, you wrote: Why do you have to do this if you can easily unset the optimal settings for the RBS (optimal=null)?