Running AWR Report

The AWR (Automatic Workload Repository) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This data is both in memory and stored in the database. The gathered data can be displayed in both reports and views.

> Please run your required process an hour before running the AWR report.

1. Login into the SQL Plus.

2. Run the following command to generate the report.
SQL > @$ORACLE_HOME/rdbms/admin/awrrpt.sql

3. You will be prompted to enter the report type. Enter report TYPE as HTML.

4. Next, you will be prompted for the number of days you want to see the snapshots. Enter a value of "1" to see snapshots created in today.
NOTE: By default, the Oracle Database generates snapshots once every hour and retains the statistics in the workload repository for 7 days.

5. After the list displays, you are prompted for the beginning and ending snapshot ID for
the workload repository report. Enter a starting ID that corresponds with the approximate time that your concurrent process was started. Enter the ending ID that corresponds with the approximate time that your process finished.

6. Next, accept the default report name or enter a the name as required.

7. Report will be created in the same directory :- $ORACLE_HOME/rdbms/admin




Ref: Metalink Doc ID 748642.1

Not able to view employee type supplier from supplier form

A few setup steps required:

1) Get the  menu attached to the problematic responsibility
    > System Administrator > Security >  Responsibility > Define

2) Navigate to System Administrator > Application > Menu
Query the menu attached to the responsibility

3) Include the function:
Create/Update Employee Supplier Details (POS_HT_SP_EMP_SUPPLIER) with the grant flag checked in the menu of the responsibility for full access to employee suppliers.
OR
View Employee Supplier Details (POS_HT_SP_RO_EMP_SUPPLIER) with the grant flag checked in the menu of the responsibility for read only/inquiry access to employee suppliers.

Alternatively check the grant flag for the function POS_HT_SP_EMP_SUPPLIER in the menu POS_HT_SP_FULL_ACCESS_MENU.
> However then all users that can create standard supplier will also be able to create employee supplier.

4) Bounce the Apache server OR 'Clear All Cache' from Functional Administrator responsibility, so that the Function Security related caches will be cleared and the above changes can take effect.

Ref: Metalink Doc ID 1371295.1