Solution : https://service.sap.com/sap/support/notes/717484 (SAP Service marketplace login required)
Key words :
sysdbasql>define default_tablespace='perfstat'sql>define temporary_tablespace='psaptemp'sql>define perfstat_password=perfstatsql>@, 20m maxsize 2000m extent management local segment space management auto, sql>show parameter statisticsstatistics_level=typicaltimed_os_statistics=0timed_statistics=trueto automate, sql>connect perfstat/<pwd>sql>select job, $sqlplussql>connect perfstat/perfstatsql>execute statspack, removesql>connect perfstat/<pwd>execute, sql>alter user perfstat identified, sqlthe performance report calculates differences, sqlplussql>connect perfstat/perfstatsql>@, $sqlplussql>connect perfstat/perfstatsql>@
Related Notes :
| 853576 | Oracle 10g: Performance analysis w/ ASH and Oracle Advisors |
| 644479 | BRCONNECT messages concerning STATS$ tables |
| 618868 | FAQ: Oracle performance |
| 105047 | Support for Oracle functions in the SAP environment |