Home » RDBMS Server » Performance Tuning » Module in Statspack Report
Module in Statspack Report [message #267207] |
Wed, 12 September 2007 13:23 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
kumarsz
Messages: 180 Registered: March 2005 Location: canada
|
Senior Member |
|
|
Hi,
I am using Oracle 9i R2 on Linux.
we have a batch process which is executed in the night
It is an Oracle job which executes many procedures in a sequence
apart from this there are report servers (oracle 10g AS) which are executing reports in the night.
While I am collecting statspack report I often see following lines the statspack report whereas nobody is connected to the system using front end (J2EE based application)
Module: JDBC Thin Client
Thanks and Regards,
Pratap
|
|
|
|
Re: Module in Statspack Report [message #267211 is a reply to message #267207] |
Wed, 12 September 2007 13:40 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
kumarsz
Messages: 180 Registered: March 2005 Location: canada
|
Senior Member |
|
|
Hi,
Sorry for that...
and here is the extract
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
BEGIN :1 := rw_server.insert_job(:2, :3, :4, :5, :6, :7, :8, :9,
:10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22
, :23); END;
157 1 157.0 0.0 0.04 1.20 1231237720
Module: ? @pulprds002.hsa.co.uk (TNS V1-V3)
SELECT OM_GET_CURR_GROUP_SCHEME_FNC ( cpd . strpolnbr , dtdue ,
: p_pol_no ) strschemeid , om_get_client_name_fnc ( cpm . strcli
entcd ) emp_name , ccm . STRLASTNAME strlastname , cpm . strpoln
br pol_no , om_get_param_desc_fnc ( :"SYS_B_0" , nsalfrq ) freq
, om_get_currsign_fnc ( cpd . strpolnbr ) currency , strpaymenti
141 10 14.1 0.0 0.04 0.59 2488355788
Module: JDBC Thin Client
SELECT NPRCDAYS FROM COM_USER_PROFILE WHERE TRIM(STRUSERID) = :B
1
110 1 110.0 0.0 0.37 0.70 4043595143
Module: SQL*Plus
INSERT INTO STATS$SQL_SUMMARY ( SNAP_ID , DBID , INSTANCE_NUMBER
, TEXT_SUBSET , SHARABLE_MEM , SORTS , MODULE , LOADED_VERSIONS
, FETCHES , EXECUTIONS , LOADS , INVALIDATIONS , PARSE_CALLS ,
DISK_READS , BUFFER_GETS , ROWS_PROCESSED , COMMAND_TYPE , ADDRE
SS , HASH_VALUE , VERSION_COUNT , CPU_TIME , ELAPSED_TIME , OUTL
93 13 7.2 0.0 31.43 31.77 3246231460
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN begin wf_com_diary_management_pkg
.WF_TRANSFER_DEFFERED_ITEM_PRC; end ; :mydate := next_date; IF b
roken THEN :b := 1; ELSE :b := 0; END IF; END;
57 3 19.0 0.0 0.02 0.39 2148339904
Module: JDBC Thin Client
INSERT INTO FIN_VOU_HDR ( STRVOUTYPE, STRVOUSERIES, NFISCALYEAR,
LVOUNBR, DTVOU, STRNARRATION, NFISCALMONTH, NVOUSTAT, STRCURRCD
, DEXCHANGERATE, NBASEDOCTYPE, STRBASEDOCNBR, NREFIND, NREFTYPE,
STRREFNBR, STRCLIENTCD, STRREFVOUTYPE, STRREFVOUSERIES, NREFFIS
CALYEAR, LREFVOUNBR, NISPOSTED, NCLUBPMT, STRREASNCD, STROTHREFN
54 7 7.7 0.0 0.03 0.18 3251751581
Module: ? @pulprds001.hsa.co.uk (TNS V1-V3)
SELECT CRD.LREPSEQ AS LREPSEQ, NVL(CMM.STRTBLNAME, CRD.STRREFTBL
NAME) STRREFTBLNAME, DECODE(CRD.NDATATYPE,4,NULL,CRD.NREFCOLCD)
NREFCOLCD, CRD.STRDISPLAYNAME STRDISPLAYNAME, CRD.STRREFCOLNAME
STRREFCOLNAME, CRD.STRREFDISPCOLNAME , NPASSINGORDER, NFIELDTYPE
, LREPDTLSEQ FROM COM_REP_DTL CRD, COM_MAINTAIN_M CMM WHERE LREP
49 4 12.3 0.0 0.00 0.12 372357728
Module: JDBC Thin Client
SELECT NFISCALYEAR, NFISCALMONTH FROM FIN_FINANCIAL_YEAR WHERE :
B2 BETWEEN DTSTART AND DTEND AND NFISCALMONTH != 0 AND NVL ( NST
ATCD, 0 ) IN ( 0, 2 ) AND STRBRANDCD = :B1
Thanks and Regards,
Pratap
|
|
|
Re: Module in Statspack Report [message #267217 is a reply to message #267211] |
Wed, 12 September 2007 13:54 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Statspack does not create these records.
It has them in its tables.
So they were executed.
So maybe they were there during the period you choose for your report, or maybe there were there before and spreport.sql still takes them.
Check what spreport.sql does.
But as the total of their totals is less than 1 second, I wonder if it worths to worry about them.
Regards
Michel
|
|
|
Goto Forum:
Current Time: Mon Sep 09 08:26:12 CDT 2024
|