I am running a set of reports that join three tables for an organization. The reports run well on the organization's server but on my notebook they take about 50 times as much time. I do realize that the server's disks are better at performing I/O but my notebook's processor and memory are comparable. In any case I don't believe that the significant difference in speed is solely attributable to hardware differences.
It was suggested that I run the query 'select * from V$SYSTEM_EVENT '. The results are shown below:
Null event 1 1 0 0
latch free 348 343 0 0
pmon timer 4147 4147 0 0
process startup 8 0 0 0
rdbms ipc reply 8 0 0 0
rdbms ipc message 15457 14986 0 0
control file sequential read 74 0 0 0
control file parallel write 4167 0 0 0
refresh controlfile command 1 0 0 0
buffer busy waits 5 0 0 0
log file sequential read 9 0 0 0
log file single write 8 0 0 0
log file parallel write 37 0 0 0
log file sync 1 0 0 0
db file sequential read 162207 0 0 0
db file scattered read 543 0 0 0
db file single write 5 0 0 0
db file parallel write 1 0 0 0
direct path read 20 0 0 0
direct path write 10 0 0 0
instance state change 2 0 0 0
smon timer 46 42 0 0
library cache pin 7 2 0 0
file identify 21 0 0 0
file open 51 0 0 0
SQL*Net message to client 52 0 0 0
SQL*Net message from client 52 0 0 0
I feel very unqualified in interpreting these results therefore I am seeking some assistance in doing so and in determining what parmaters I may tweak to improve the very long time it takes to run my reports.
And please.it has been made abundantly clear to me on more than one occasion that the product is old and is no longer supported. But I am doing some work for another organization that has to make its own decision on upgrading.
Start Free Trial
