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
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 #267210 is a reply to message #267207] Wed, 12 September 2007 13:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't see any line containing that in what you posted.

Regards
Michel
Re: Module in Statspack Report [message #267211 is a reply to message #267207] Wed, 12 September 2007 13:40 Go to previous messageGo to next message
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
Michel Cadot
Messages: 68665
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
Previous Topic: lots of waits sql*net
Next Topic: How to rebuild indexes
Goto Forum:
  


Current Time: Sat Jun 29 06:52:55 CDT 2024