Why the 11g (11.1.0.6.0) database is running slowly on Windows XP system? This database was installed using DBCA and with the default configuration values.
The resource is enough. No any applications are running on the system. EM control is not started. Normally, only 5% of CPU is used more than 50% of memory is free. All the top 10 SQLs have alrady been tuned using SQL Tuning Advisor. It seems resource bottleneck any more.
SQL> select name,class,value from V$SYSSTAT;
......
469 rows selected.
Elapsed: 00:02:10.68
SQL> select*from hr.employees;
107 rows selected.
Elapsed: 00:00:26.32