Re: [perf-discuss] Oracle 10g R1 performs extremely BAD

2008-08-28 Thread Tanel Poder
Oracle records exactly on what the waiting time was spent). There are few options for tuning the imp speed, set recordlength=65535 and buffer=1048576 for example in imp command line. The above options don't help (they probably wont help much) then look into expdp/impdp... -- Regards, Tanel Po

Re: [perf-discuss] Oracle 10g R1 performs extremely BAD

2008-08-28 Thread Tanel Poder
/06/oracle-session-snapper-v106-released/ You should run it with let say 1-minute interval on the individual loading session or all sessions in db. You can post the result so I (or other Oracle people here) can advise... -- Regards, Tanel Poder http://blog.tanelpoder.com http://n.otepad.com -

RE: [perf-discuss] Re: Re: maxphys and sd_max_xfer_size

2006-06-10 Thread Tanel Poder
So what's the problem you're trying to solve? If you simulate any database operation with OS utilities like dd you have to be sure you're simulating it the same way as database does. For example, Oracle opens its filesystem datafiles always with O_SYNC option and with O_DIRECT dependent on whe