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:
OracleAS 10g Patch Set 3 (10.1.2.3.0) May 18, 2008
Posted by Manpreet Johal in Oracle Application Server, Portal.Tags: Oracle Application Server, Oracle Portal
add a comment
Oracle has released OracleAS 10g Patch Set 3 (10.1.2.3.) – ML Patch#5983622 in April ‘08.
This patch set can be applied to following releases of OracleAS 10g:
- OracleAS 10g Release 2 (10.1.2.0.0, 10.1.2.0.2, 10.1.2.1.0, 10.1.2.2.0)
- OracleAS 10g Release 2 Standard Edition One (10.1.2.0.1)
- OracleAS Forms and Reports Services (10.1.2.0.2)
- OracleAS Portal 10g Release 2 (10.1.4, 10.1.4.1)
- Oracle Developer Suite 10g (10.1.2.0.2)
- Oracle BI 10g Release 2 (10.1.2, 10.1.2.0.2)
- Oracle BI Tools 10g Release 2 (10.1.2, 10.1.2.0.2)
This patch set will also upgrade Portal version from 10.1.4.1 to 10.1.4.2.
Oracle Applications 11i or R12 customer must check the certification matrix before upgrading standalone OracleAS 10g instances which are integrated with Oracle Applications environment.
References:
Search in Oracle Portal May 10, 2008
Posted by Manpreet Johal in Oracle Application Server, Portal.Tags: Oracle Portal, Portal Search
add a comment
Oracle Portal provides a deployment framework for applications based on industry standards e.g. J2EE, JSR168, WSRP etc. Oracle Portal is also used as a document management or content management solution, as a centralized store for corporate documents. This feature offers more enhancements than storing documents in network share e.g. at NTFS drive located in Windows environment. I will dedicate a separate post for comparison between Oracle Portal based document management solution and network share based document storage. One of the major enhancements is the option to search the documents or content uploaded to Oracle Portal based document repository.
In this post, I would like to highlight the options available to search the content in Oracle Portal. Following are the options to search content in Oracle Portal:
- Basic Search – Item and Portlet: This is available as a built-in item type and portlet for Page Designer/Developers. It does not provide an option to provide search operators while performing search.
- Advanced Search – Portlet: It provides additional search operators for search. It also provides an option to search based on item/document attributes e.g. search based on Author of the item/document.
- Custom Search – Portlet: In addition to features available in Advanced Search portlet, it provides an option to define the layout of Search Form and Results Page. It also allows Portlet Publishers to use separate Search Results page for each of the Custom Search portlet. Another useful feature of Custom Search is that it provides an option to automate the search action based on search term specified i.e. whenever user will access the page, Custom Search portlet will perform the search and will display the results in portlet region. For example, end user can create Custom Search portlet to show list of documents uploaded to Oracle Portal in last 7 days.
Oracle Portal search options mentioned above, provide an interface to perform search on item/document uploaded to repository. Oracle Portal Search crawls and index the content/document in Portal repository at regular interval. Oracle Portal Search uses Oracle Text for indexing of items/documents uploaded by default. Administrators can enable/disable the option to use Oracle Text for Oracle Portal search. However, if Oracle Text is disabled in Oracle Portal, search will only return results based on terms found in item/document metadata only. In order to search the content of the documents uploaded e.g. Word, Excel, Powerpoint, PDF etc. Oracle Text must be enabled.
Oracle Portal Search perform the search based on permissions available to end user i.e. users will be able to search the content/document for which he/she is authorized. Thus, it will not violate the security policy by searching the un-authorized content and returning results to users.
References:
Oracle Portal Release 11 March 17, 2008
Posted by Manpreet Johal in Oracle Application Server, Portal.Tags: Oracle Portal, Portal Export/Import
add a comment
While reading Portal Statement of Direction, I found a glimpse of new features that Oracle has planned to introduce in next major release of Portal i.e. Portal Release 11.
For those who are curious, like me, to find out what Oracle is introducing in next release of Portal, I have summarised few of the new features in this post that I found useful:
- A two-step portal export/import model based on database links configured between source and target portal instances. It will really improve the code deployment process among Portal deployments.
- OmniPortlet will provide an advanced parameter form that allows you to populate a LOV dynamically based on a SQL query/database column. This feature is available in Portal 10g as well. However, it was not out of the box, it was required to tweak portlet configuration files, which was quite error prone. Another option is that develop your own custom parameter form based on PL/SQL. So, this new feature will definitely reduce the complexity and time involved in custom parameter form development.
- BPEL-based Process Content Routing and Approval – a useful feature for customers who are using Portal as a document/content management framework, whether they want to leverage simple workflow included in Portal or more complex approval chain based on Oracle BPEL Workflow.
- New list of portlets:
- Oracle Oracle Secure Enterprise Search (search submission and search results)
- Oracle BPEL (notifications, task analysis, reporting),
- Oracle Business Intelligence Enterprise Edition (Siebel BI Tools)
- Hyperion System 9 BPM (Business Performance Management)
- Support for incorporation of portlets from Peoplesoft Applications, including PeopleSoft Version 9These features will allow customers to leverage Portal interface to publish dispersed content from various enterprise applications in personalized interface.
So next release of Oracle Portal will also enhance customers’ application integration experience where they want to extend Oracle Portal by building new presence-aware and context-aware applications on top of Portal layer, using Oracle WebCenter. Thus, adding Web 2.0 capabilities to Oracle Portal.
This is a glimpse based on Statement of Direction document, final product release will give us a real insight into what new features Portal Release 11 holds. Let us wait and watch.
References:
