1 PACKAGE asg_perf AUTHID CURRENT_USER AS
2 /*$Header: asgperfs.pls 120.1 2005/08/12 02:51:31 saradhak noship $*/
3
4 -- DESCRIPTION
5 -- Contains functions to report synch performance
6 --
7 --
8 -- HISTORY
9 -- 07-Nov-2002 rsripada Created
10
11 g_num_rows NUMBER := 0;
12 g_total_rows NUMBER := 0;
13 g_elapsed_time_in_days NUMBER := 0;
14 g_elapsed_time PLS_INTEGER := 0;
15 g_total_elapsed_query_time PLS_INTEGER := 0;
16 g_download_init_time PLS_INTEGER := 0;
17 g_total_elapsed_time PLS_INTEGER :=0;
18
19 -- Procedure to report the download init and query time statistics
20 -- for the specified user's first synch
21 PROCEDURE get_first_synch_report(p_user_name IN VARCHAR2);
22
23 -- Procedure to report the download init and query time statistics
24 -- for the specified user's incremental synch
25 PROCEDURE get_incremental_synch_report(p_user_name IN VARCHAR2);
26
27 -- Procedure to report the download init and query time statistics
28 -- for the specified user and publication-item's first synch
29 PROCEDURE get_first_synch_report(p_user_name IN VARCHAR2,
30 p_pub_item IN VARCHAR2);
31
32 -- Procedure to report the download init and query time statistics
33 -- for the specified user and publication item's incremental synch
34 PROCEDURE get_incremental_synch_report(p_user_name IN VARCHAR2,
35 p_pub_item IN VARCHAR2);
36
37 -- Use this procedure to setup the data for download
38 -- Should call cleanup_setup afterwards to reset
39 PROCEDURE setup_download(p_user_name IN VARCHAR2,
40 p_first_synch IN VARCHAR2);
41
42
43 -- Use this procedure to setup the data for download
44 -- Should call cleanup_setup afterwards to reset
45 PROCEDURE setup_pub_item_download(p_user_name IN VARCHAR2,
46 p_pub_item IN VARCHAR2,
47 p_first_synch IN VARCHAR2);
48
49 -- This procedure reports the download time for specified pub item
50 -- The specified pub item should have been setup for download
51 -- using setup_pub_item_download
52 PROCEDURE compute_pub_item_time(p_pub_item IN VARCHAR2);
53
54 -- This procedure reports the download time for all publication items
55 -- It should be called after call to setup_download
56 PROCEDURE compute_download_time;
57
58 -- This procedure is used to clean up the setup done for download.
59 PROCEDURE cleanup_setup;
60
61 PROCEDURE log(p_mesg IN VARCHAR2);
62
63 end;
[Home] [Help]