Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Virtual drive on Solaris
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, but I believe it mainly does single-row inserts, so not using the APPEND hint is a blessing anyway. After all, who likes one row in each database block? However, I could be wrong about that and it may actually be performing multi-row/array insertions...
I don't know what your loads are like, but how about something like this instead?
Just an idea (better you than me to try it!)...
> Hi All
>
> does anyone have any white paper or info on how to
configure a dedicated
> portion of real memory as a virtual drive on Solaris ? I
want to move my
> online redo logs (4 X 128 M single threaded) for a 300 GB
DW onto it, to
> speed up Informatica ETL, since Informatica does not allow
me to specify /*+
> APPEND */ mode of insert. I know I will not bypass the SQL
layer this way,
> but at least, the LGWR will be writing to memory instead
of disk. Thanks in
> advance.
>
> Regards:
> Ferenc Mantfeld
> Senior Performance Engineer
> Siebel Performance Engineering
> Melbourne, 3000, VIC, Australia
> Only Robinson Crusoe had all his work done by Friday
>
>
> -----Original Message-----
> Sent: Saturday, 22 June 2002 9:03 PM
> To: Multiple recipients of list ORACLE-L
>
>
> On Solaris
>
> ps -ef -opid,ppid,vsz=VIRTMEM -orss=PHYSMEM
-opmem,pcpu,user,args
>
> use:
>
> psrinfo -v
> prtconf | grep Mem
> format
> uname -a
>
> HTH
>
> Richard
>
> -----Original Message-----
> Sent: Saturday, June 22, 2002 1:38 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Good day to everyone...
>
> I have two questions related to Linux and Solaris...
>
> * I need do find memory usage (physical, virtual...) of a
particular
> proccess. PID is given by by "ps", but what aditional
parameters I have to
> provide? At a first glance, output of "man ps" vas
confusing...
>
> * How do I find computer's configuration - what CPU,
numbers of CPUs, clock,
> amount of memory, number of harddrives, what version of
OS, what OS patches
> are applied...?
>
> No, I can't ask sysadmin about that (hard to explain),
and, no, I don't have
> any kind of advanced manuals...
>
> Thanks in advance,
> Vladimir
>
> --
> Please see the official ORACLE-L FAQ:
http://www.orafaq.com
> --
> Author: Vladimir Barac - posao
> INET: vladob_at_aster.si
>
> Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
> San Diego, California -- Public Internet access /
Mailing Lists
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: tim_at_sagelogix.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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 Sun Jun 23 2002 - 23:03:18 CDT
![]() |
![]() |