Cache Sizes (end)
~~~~~~~~~~~~~~~~~
Buffer Cache: 512MStd Block Size: 4K
Shared Pool Size: 1,024M
Log Buffer: 800K
shared_pool_size : 200M
db_cache_size : 1000m
The standard block size is too small,u should move the index or data to the tablespace which block size is 8k or higher.
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~
% Total
Event
WaitsTime (s) Ela Time
-------------------------------------------- ------------ ----------- --------
db file scattered read
496,443 3,00336.95
db file parallel read
93,909 1,55719.16
CPU time
1,35416.66
db file sequential read
184,719 1,25215.41
SQL*Net message from dblink
8,081 364 4.47
-------------------------------------------------------------
在表上建立合适的索引消除不必要的全表扫描。
|