Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: COBOL TO ORACLE
Eeep! Reminds me of my CICS programming in school on a 4MB (MEGA bytes) IBM
4341 with the student partition on the lowest priority. For some reason,
the operator got really mad at me when I forgot to put an unexecutable EXIT
statement in my code...
Barring any OS stats, have you tried a 10046 trace on any of the slow processes to see where the holdup is? It's been about 15 years since my mainframe days in school, but I'd still question 2.4GB worth of SGA on a 2GB machine, and that's without server processes, OS, etc... What is "virtual" memory? DISK!
Rich
Rich Jesse System/Database Administrator rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA
> -----Original Message-----
> From: babette.turnerunderwood_at_hrdc-drhc.gc.ca
> [mailto:babette.turnerunderwood_at_hrdc-drhc.gc.ca]
> Sent: Wednesday, October 01, 2003 2:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: COBOL TO ORACLE
>
>
> Then perhaps you can help me . . .
>
> We are suffering through a Pro*Cobol / Oracle on the
> mainframe implementation for a newly developed in house application.
>
> We have a mainframe with 1.7GB - 2GB REAL memory.
> 4 CPU machine - we have two logical CPUs in our LPAR
> We have 8 instances running (each with at least 300MB SGA)
> We are having major performance problems when people start
> doing a lot of work on these instances.
>
> The Mainframe SYSADMIN insists that there is NO swapping, NO
> paging occuring. There is no problem because each instance
> can have 2GB VIRTUAL memory and this is fine and dandy
> because this is how the mainframe works.
>
> Did you ever use Oracle on a mainframe?
> Did you come up with guidelines for minimum requirements?
> (like in the UNIX install guides / NT install guides, you
> need X RAM, etc)
>
> Thanks
> Babette
>
> -----Original Message-----
> Sent: 2003-09-30 5:15 PM
> To: Multiple recipients of list ORACLE-L
>
>
> On Tue, 2003-09-30 at 16:19, Stephane Paquette wrote:
> > Like Thomas Day said, Oracle is an rdbms and COBOL a
> programming language.
> >
>
> COBOL *** WAS *** a programming language. Horse *** WAS *** basis of
> transport. You should have used past tense, Stephane. I'm not really
> that partial when it comes to horses, but having suffered
> COBOL, I would
> really leave it in the ancient past, together with Spanish Inquisition
> and crucifiction as a viable capital punishment.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: Rich.Jesse_at_qtiworld.com 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: ListGuru_at_fatcity.com (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).Received on Wed Oct 01 2003 - 14:29:32 CDT