Did you get a trace of the sessions on both machines (event 10046, level
8')? Hard to tell what isd going on w/o this data.
hfv wrote:
> Its using veritas file system. Increasing the SGA size does help but
> still it is 10 times slower than the pc. (see previous post for times)
>
>>I'd start looking at the raw interaction with the file system first,
>>then look for the obvious things like SGA size and swapping/paging.
>>
>>You describe a 'new database'. Has it been configured or just 'built'?
>>
>>What (whose) file system? Using FastIO or QuickIO?
>>
>>etc.
>
>
--
Ron Reidy
Oracle DBA
Received on Tue Nov 25 2003 - 20:18:56 CST
