Rem Rem $Header: webapp_views.sql 31-may-2006.01:21:52 pkmohapa Exp $ Rem Rem webapp_views.sql Rem Rem Copyright (c) 2006, Oracle. All rights reserved. Rem Rem NAME Rem webapp_views.sql - Rem Rem DESCRIPTION Rem Rem Rem NOTES Rem Rem Rem MODIFIED (MM/DD/YY) Rem pkmohapa 05/31/06 - bug 5027443 changed the assoc_def of depends_on Rem to supports_e2e_on Rem pkmohapa 05/31/06 - Created Rem SET ECHO ON SET FEEDBACK 1 SET NUMWIDTH 10 SET LINESIZE 80 SET TRIMSPOOL ON SET TAB OFF SET PAGESIZE 100 --Purpose: View for Reporting E2E data for rollup time from 7 days till 31 days create or replace view SYSMAN.MGMT$E2E_1Day AS SELECT * FROM ( SELECT uri, hit_count, total_time, servlet_count, servlet_time, jsp_count, jsp_time, ejb_count, ejb_time, jdbc_time, mt.target_guid,rollup_timestamp FROM mgmt_e2e_summary_1day e2e,mgmt_target_assocs mta, mgmt_target_assoc_defs mdef, mgmt_targets mt WHERE e2e.target_guid = mta.assoc_target_guid AND source_target_guid = mt.target_guid AND mta.assoc_guid = mdef.assoc_guid AND mdef.assoc_def_name = 'supports_e2e_on' AND mdef.scope_target_type = ' '); CREATE OR REPLACE PUBLIC SYNONYM MGMT$E2E_1Day FOR SYSMAN.MGMT$E2E_1Day; GRANT SELECT ON SYSMAN.MGMT$E2E_1Day TO MGMT_USER; --Purpose: View for Reporting E2E data for rollup time from 24 hours to last 7 days create or replace view SYSMAN.MGMT$E2E_hourly AS SELECT * FROM ( SELECT uri, hit_count, total_time, servlet_count, servlet_time, jsp_count, jsp_time, ejb_count, ejb_time, jdbc_time, mt.target_guid,rollup_timestamp FROM mgmt_e2e_summary_1hour e2e,mgmt_target_assocs mta, mgmt_target_assoc_defs mdef, mgmt_targets mt WHERE e2e.target_guid = mta.assoc_target_guid AND source_target_guid = mt.target_guid AND mta.assoc_guid = mdef.assoc_guid AND mdef.assoc_def_name = 'supports_e2e_on' AND mdef.scope_target_type = ' '); CREATE OR REPLACE PUBLIC SYNONYM MGMT$E2E_hourly FOR SYSMAN.MGMT$E2E_hourly; GRANT SELECT ON SYSMAN.MGMT$E2E_hourly TO MGMT_USER; --Purpose: View for Reporting E2E data for rollup time less than 24 hours create or replace view SYSMAN.MGMT$E2E_Raw AS SELECT * FROM ( SELECT uri, hit_count, total_time, servlet_count, servlet_time, jsp_count, jsp_time, ejb_count, ejb_time, jdbc_time, mt.target_guid,collection_timestamp as rollup_timestamp FROM mgmt_e2e_summary e2e,mgmt_target_assocs mta, mgmt_target_assoc_defs mdef, mgmt_targets mt WHERE e2e.target_guid = mta.assoc_target_guid AND source_target_guid = mt.target_guid AND mta.assoc_guid = mdef.assoc_guid AND mdef.assoc_def_name = 'supports_e2e_on' AND mdef.scope_target_type = ' '); CREATE OR REPLACE PUBLIC SYNONYM MGMT$E2E_Raw FOR SYSMAN.MGMT$E2E_Raw; GRANT SELECT ON SYSMAN.MGMT$E2E_Raw TO MGMT_USER; COMMIT;