Oracle Portal Performance Reporting October 20, 2008
Posted by Manpreet Johal in Oracle Application Server, Portal.Tags: Oracle Portal, Portal Performance
add a comment
Oracle Portal provides performance reporting scripts tool, with help of which administrators can generate performance statistic reports for portal page access, web cache hits, portlet response time, etc.
Performance reporting scripts tool is a collection of scripts which create a schema named OWA_PERF in the database to store performance data captured from OracleAS log files. OWA_PERF schema can be created in Metadata Repository database for test environment. Since the performance data loading and access consumes significant database resources, it is recommended that this schema should be created in separate database, other than the database used by OracleAS i.e. neither Metadata Repository database nor a customer database (used for application data).
Administrators can upload performance data from OracleAS log files, into the database using set of scripts provided. Performance reporting scripts set provides set of SQL scripts, which can be executed against OWA_PERF schema to access performance statistics for various Portal components in simple tabular format reports.
Portal Page Access by Day Report
Performance reporting scripts provide a HTML file which contains links to performance reports generated via these set of scripts.
Portal Performance Reports
References:
