Closed
Description
After upgrading from version 3.1.3 to 3.1.6 the coverage report on a huge 4.7M lines code base seems to never end. I shut the execution down after more then 7 hours while on version 3.1.3 it took less then 10 minutes to generate the report.
The script was run via SQL*Plus:
SET define off
SET serveroutput on size unlimited
SET linesize 250
SET echo off feedback off termout off
spool full_schema_coverage.html
BEGIN
ut.run(ut_coverage_html_reporter());
END;
/
spool off
set serveroutput off
Information about utPLSQL and Database version,
Oracle XE 12.1
DB version 12.1.0.1.0
DB compatibility 12.1.0.0.0
UT_VERSION
--------------------------------------------------------------------------------
v3.1.6.2735
BANNER
--------------------------------------------------------------------------------
Personal Oracle Database 12c Release 12.1.0.1.0 - 64bit Production
PL/SQL Release 12.1.0.1.0 - Production
CORE 12.1.0.1.0 Production
TNS for 64-bit Windows: Version 12.1.0.1.0 - Production
NLSRTL Version 12.1.0.1.0 - Production
PARAMETER VALUE
------------------------------ --------------------------------------------------
NLS_LANGUAGE ITALIAN
NLS_TERRITORY ITALY
NLS_CURRENCY €
NLS_ISO_CURRENCY ITALY
NLS_NUMERIC_CHARACTERS ,.
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE ITALIAN
NLS_SORT WEST_EUROPEAN
NLS_TIME_FORMAT HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT DD-MON-RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH24:MI:SSXFF TZR
NLS_DUAL_CURRENCY €
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
PORT_STRING
-------------------------------------------------------------------------------------
IBMPC/WIN_NT64-9.1.0
According to Oracle Enterprise Manager, the SQL statement running for hours is
SELECT TEXT, ITEM_TYPE FROM TABLE((:B1 ).GET_LINES(:B2 , :B3 ))