Re: Help - trouble using Oracle under Windows

ckr_at_ocsbrg.no (Carsten Kristensen) writes:

>holowcza_at_pegasus.rutgers.edu (Richard Holowczak) writes:
 

>>ghollid_at_relay.nswc.navy.mil (Glen Holliday) writes:
 

>> [More stuff deleted]
>[ .. stuff deleted .. ]
 

>> Other hints are to get rid of EMM386.EXE and SMARTDRV.EXE
>> if you are using them. SMARTDRV can be used but unless
>> you know what you're doing, you can corrupt the database.
 

>We had a problem running v 6.0.36 standalone on a PC - corrupt database.
>According to Oracle Support, the problem was SMARTDRV. They told us not
>to use it. Which of course increases response time. Are you saying that
>we CAN use it ?? If so, I would be very interested to hear what kind of
>setup - smartdrv params etc.

     The big problem with Smartdrive is that by default it
     caches read and Writes.  If you turn off the write caching
     portion, you MAY be able to still use it but I would not
     bet my life on it.   Make a FULL back up of everything,
     then make another backup then try:

       SMARTDRV.EXE  C  2048  1024

    Where the plain old C means to just read cache the C drive     If you have Oracle on another drive, substitute this     drive letter instead.

    This is still not proven to be A -OK by Oracle or anyone     else I know of so use at your own risk.

    Again, Oracle was designed to be the only thing running on the     PC so its caching (via the SGA) is pretty good as far as your     data is concerned.

    If you really need to cache an application on the same PC,     you can buy another hard disk or partition your current     hard disk. Then you can leave the Oracle disk alone (say     drive C) and read/write cache your D drive or whatever.    

Rich Holowczak
Rutgers University
holowcza_at_andromeda.rutgers.edu

>--
>* Carsten Kristensen E-mail: ckr_at_ocsbrg.no *
>* Offshore Computer Services AS Tel : +47 55 99 88 70 *
>* Bergen, Norway Fax : +47 55 99 88 84 *
>* select std_disclaimer from opinions_not_shared_by_employer; *
Received on Thu Feb 17 1994 - 02:55:01 CET