Re: ORACLE Configuration

chswrvg9_at_ibmmail.com wrote:

: Hello
 

: I am evaluating HW/SW for setting up an ORACLE unix server with Windows and
: OS/2 clients.
 

: Some questions still confuse me:
 

: - Should we run forms/reports/graphics from a file server or from the
: workstations disk ? Clients run WinOS2 and Windows 3.11.

Local would be faster as you're not passing so much network traffic. But you must have the disk capacity to install it. Also, if local. maintenance is a little harder as you'll have to duplicate your efforts.

: - Recommended configuration CPU/disk/RAM for above clients ?

Installation Guide has minimum requirements. You should always throw in as much as possible. eg: 32 MG RAM, 500MB hard disk , Pentium 90.

: - Shall developpers start designer/2000 from a file server or locally ?

Above applies here as well. Designer requires more RAM/CPU/DISK

: - Any experience in accessing Oracle on UNIX from a client running Smalltalk
: either on OS/2 Warp or Win95 ? Which SW is required ?

No. But if they're ODBC compliant you can use ODBC and SQL*Net to get them talking. Or Oracle objects for OLE and SQL*Net. There are other ways of connecting them as well. But these are the only approaches that I've tried for VB and ACCESS.

: - Is there a way to access Oracle DBs without SQL which should be considrable
: faster than SQL ?

ACCESS, VB and the likes allows you to manipulate databases without any knowledge of SQL. You can also do it without any code. So yes you can do it without SQL. But what do you mean faster than SQL? Do you mean without writing code? If so, then it's another yes.

HTH,
Leng.

--
Leng Kaing - Software Consultant/DBA      Tel: +61-3-9688-4368
Dept of IT&S, VUT - Footscray Campus      Fax: +61-3-9688-4800
PO Box 14428, MCMC                        Email: Leng=Kaing_at_vut.edu.au 
Melbourne 8001, Australia                 WWW: http://www.vut.edu.au/~leng