RE: Virtual drive on Solaris

2002-08-28 Thread VIVEK_SHARMA
Hi Tim Wrote Buying an NVRAM unit would probably be more sensible, since at least then you have some probability of the file-system on such a unit surviving node failure or restart. Qs Such Units are available on which machines , Operating Systems ? Any Model Numbers , Links , Other Info

Re: Virtual drive on Solaris

2002-06-27 Thread Tim Gorman
Ferenc, What a small world! That class in Dallas was the very first teach of the excellent Oracle Server Internals seminars anywhere, ever. Originally, Scott Gossett was supposed to teach all of them, but he was booked at the time so Oracle Education hired me as a replacement contractor to

RE: Virtual drive on Solaris

2002-06-25 Thread Ferenc Mantfeld
Used it for large application upgrades, works a charm, cut down the time by about a third. But it does not work on every platform, because when I set it and then perform a transaction, upon dumping the redo log, I find my transaction in there. But thanks Tim. BTW, I was in that class, you ran it

Re: Virtual drive on Solaris

2002-06-25 Thread Connor McDonald
For the previous poster, my understanding of _disable_logging is that all of the normal operations take place EXCEPT the actual physical write. Hence you will get log switches, check points etc etc. If you were *really* needing to use it (say for a large load on a non-production system) then

RE: Virtual drive on Solaris

2002-06-25 Thread Aponte, Tony
Title: RE: Virtual drive on Solaris Thanks. -Original Message-From: Ferenc Mantfeld [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 25, 2002 12:08 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Virtual drive on Solaris Tony Ever since I first worked with you

RE: Virtual drive on Solaris

2002-06-24 Thread Aponte, Tony
Title: RE: Virtual drive on Solaris Here is the command sample: mount -f tmpfs -o size=800m swap /ramdisk We use it to run a small database totally in memory. We decided that staying within the Oracle product suite was better for us vs. using a real memory-only rdbms. The mounting

RE: Virtual drive on Solaris

2002-06-24 Thread Ferenc Mantfeld
Hi Tim Yes, I have tried the _disable_logging, does not work on all platforms. DB starts up fine, but redo log is generated, evidenced by log switching going on. Also if I do a normal DML (large-ish one to verify), then dump the redo log, I see my transaction there, so for a 420R, running

Re: Virtual drive on Solaris

2002-06-24 Thread Tim Gorman
I hesitated mentioning that parameter in this forum, but I figured what the heck? Could be fun, in a sick way... :-) Once I was teaching a DBA class and mentioned _DISABLE_LOGGING. Immediately, I saw every head in the class look down, scribbling furiously! I had to backtrack very quickly and

RE: Virtual drive on Solaris

2002-06-24 Thread Ferenc Mantfeld
Title: RE: Virtual drive on Solaris Tony Ever since I first worked with you, I've always regarded you as best amongst the best (and I don't give that title lightly), and you have substantiated it once again. Thanks for the info, this is great ! Can't wait to freak out some minds

Re: Virtual drive on Solaris

2002-06-23 Thread tim
Have you considered setting _DISABLE_LOGGING = TRUE instead? It could be just as disastrous... ;-) Buying an NVRAM unit would probably be more sensible, since at least then you have some probability of the file-system on such a unit surviving node failure or restart. I don't use Informatica,