Re: Oracle7 under OS/2 v2.11

Richard Ashton <richard_at_corixia.demon.co.uk> writes:

>Please forgive me if this is a FAQ. I have been lurking for a week and
>I have seen very few posts about Oracle7 running under the OS/2
>operating system.
 

>I conclude that few people are using it or it is a dog or perfect :)
 

>I am an OS/2 comms specialist and know very little about Oracle, a
>situation that is changing :(
 

>We are running 7.0.16.1 with 7.0.16.3 imminent. The box is a 100Mhz
>Pentium, 64Mb RAM 256k L2 Cache ( I have already said this is silly)
>and a mirrored 1GB drive. IBM LAN Server HPFS386 is installed.
 

>The box is running a lot of tasks, including Oracle but it is the
>relationship between Oracle 7 and OS/2(HPFS386) about which I could
>use some insight.
 

>It seems to me, as an illiterate in these matters, that Oracle and OS/2
>were made to be kept far away from each other. As soon as an Oracle
>task starts the number of dispatchs made by the operating system goes
>through the roof. I am seeing 100% CPU Utilization 30% to 40% of this
>seems to be in the OS/2 kernel.
 

>Does anybody use oracle7 on OS/2 (with Advanced LAN Server) ?
 

>Is it my imagination or is Oracle7 severly suboptimal under OS/2
 

>Is Oracle7 for OS/2 a real port or a quick hack? It certainly does not
>look as if it is multi threaded.
 

>Any assistance or guidance, even of the "poor sod" variety would be
>very welcome.

>Regards {} {} Richard {} {}
>--
>{R} richard_at_corixia.demon.co.uk TEAM OS/2
>This opinion belongs to the Company and is probably not my own.

Hi Richard --

I use OS/2 2.1 and Oracle v7 on my system and aside from Oracle not supporting the OS/2 version with a GUI frontend ala their CDE2 tools for the Windows (Gaacckkk!) platform, it seems to work just fine. I do all my database architecture design work on my home system and then use those same designs for the company(ies) I consult for. Works OK.

I only have a 486 DX2-66 with 16meg-o-ram and while not dealing with multi-gigabyte database, it works fine with maybe the 1000's of records that I would use for testing. Oracle always works best when it has a system dedicated just to itself with multiple disks available to handle all the I/O.

If you are using the Pulse applet that comes with OS/2 to do system monitoring - THROW IT AWAY! Get a commercial OS/2-based monitoring application (they are not very expensive) that will give you real-time data. Examples would be CPU Monitor Plus by Bon Ami, or SPMS from IBM (this is the best if you are networking).

Hope this helps
Mike

--
Michael D. Stiler   Sysdate Consulting Services   ::internet stiler_at_netcom.com
 NRA LifeMember  AMA LifeMember  AOPA  DAN  Retreads  HOG  TeamOS/2  Bagpiper
   Master Mason     32nd degree Scottish Rite     Knight Templar     Shriner