224270.1 Trace Analyzer TRCANLZR (TRCA) Changes Log

11.4.5.8 May 10, 2013

  1. BUG: Fix TRCA parsing errors due to missing CURSOR information: invalid call at line 27 "1" "1" "" "2".

11.4.5.7 April 5, 2013

  1. ENH: Purge of TRCA global temporary tables uses now a TRUNCATE instead of a DELETE.
  2. ENH: TRCA produces now a TRCA_installation_logs_archive.zip with all installation logs.
  3. ENH: Include Product Component Version in installation logs.

11.4.5.5 March 1, 2013

  1. ENH: 11g PLSQL_CODE_TYPE is set to NATIVE by default (to improver performance). 10g defaults back to INTERPRETED.

11.4.5.4 February 4, 2013

  1. BUG: Avoid on 9i:
    BEGIN DBMS_STATS.LOCK_TABLE_STATS('TRCANLZR', 'trca_tables'); END;
    ORA-06550: line 1, column 18:
    PLS-00302: component 'LOCK_TABLE_STATS' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored
  2. ENH: PLSQL_CODE_TYPE changed from INTERPRETED to NATIVE in order to improver performance.

11.4.5.3 December 31, 2012

  1. BUG: Avoid:
    BEGIN trcadmin.trca$t.refresh_trca$_dict_from_that; END;
    ORA-12838: cannot read/modify an object after modifying it in parallel.
    ORA-06512: at "TRCADMIN.TRCA$T", line 200
    ORA-06512: at "TRCADMIN.TRCA$T", line 918

11.4.5.2 December 12, 2012

  1. ENH: Connect identifier parameter is now deprecated.
  2. ENH: New synonyms to allow the call of TRCA APIs with either TRCANLZR or TRCADMIN schema name.

11.4.5.1 November 27, 2012

  1. ENH: Table audit_actions is now optional.

11.4.5.0 November 21, 2012

  1. ENH: New Security Model.

11.4.4.8 September 27, 2012

  1. ENH: Security related improvements.

11.4.4.2 February 2, 2012

  1. BUG: Fix on 9i: Errors for PACKAGE BODY TRCA$G: 416/7 PLS-00306: wrong number or types of arguments in call to 'GATHER_TABLE_STATS'

11.4.4.1 January 2, 2012

  1. ENH: Procedure sys.tasqdirset uses now double single quotes in the directory path before creating it: replace(p2_directory_path,'''','''''')
  2. ENH: Procedure sys.tasqdirset is now named sys.sqlt$_trca$_dir_set.
  3. ENH: TRCA: When producing an "Explain Plan" section, it includes now a warning:
    "May not match the plan used for execution.".
  4. ENH: When trcanlzr is executed and the path/filename is passed, ignore the path and give a warning in log file.
  5. ENH: TRCA provides now a script trca/run/trcasplit.sql to split a trace file into a 10046 trace and the rest.
    (In other words, it provides access to this capability of splitting a 10046/10053 trace to end users.)

11.4.4.0 December 4, 2011

  1. BUG: Avoid following error when using SQLT on a distributed environment and remote SQL is executed as some user other than local user.
    ORA-20210: To download this file you must connect as "SYS", "SYSTEM", "SQLTXPLAIN", or "remote user"
  2. ENH: Set the sequence sqlt$_sql_statement_id_s to NOCACHE. Caching is intended to speed frequent access to the sequence (which does not happen here), and results in the sequence tending jump by units of 20. This makes it harder to identify consecutive runs. This also applies to trca$_tool_execution_id.

11.4.3.1 June 17, 2011

  1. TRCA was not handling a trace truncate on STAT lines where id is present but pid is not. Now it does.
  2. Orphan WAITs used to be ignored. That is WAITs without corresponding database call in trace. Now TRCA creates some dummy cursors to account for those waits instead of consider them un-accounted for.
  3. Fix error below when executing this command on 9i: EXEC DBMS_STATS.LOCK_TABLE_STATS(USER, 'trca_control');
    PLS-00302: component 'LOCK_TABLE_STATS' must be declared.
  4. Fix error below when executing this command on 9i: GRANT SELECT ON trca$_log_v TO PUBLIC;
    ORA-01720: grant option does not exist for 'SYS.V_$SESSION_LONGOPS'.

11.4.2.7 April 8, 2011

  1. Lock statistics on external tables in order to avoid following errors when gathering statistics:
    DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file.
    ORA-20011:Approximate NDV failed:
    ORA-29913: error in executing ODCIEXTTABLEOPE N callout
    ORA-29400: data cartridge error
    KUP-04040: file TRCA_CONTROL.txt in TRCA$STAGE not found.
    Problem was introduced by bug 9056912.
  2. Filename sizes increased from 128 to 256 in order to accommodate output file identifier needed by EBS.

11.4.2.5 March 20, 2011

  1. Default and temporary tablespace names for TRCANLZR schema owner are now case sensitive.
  2. Tool parameters "Top SQL Threshold" and "Top Execution Threshold" have been raised from 5 to 10%.
  3. New set of APIs under package TRCA$E to allow the execution of TRCA from a PL/SQL package.
  4. Parsing issue when a gap timestamp is in the SQL (between PARSING line and SQL text) is now fixed.
  5. TRCA progress is now recorded into v$session_longops and displayed using new view TRCA$_LOG_V.
  6. Module and Action are updated for TRCA using DBMS_APPLICATION_INFO.

11.4.2.4 February 18, 2011

  1. Fix following error on 9.2.0.6 when passing oacfl2=4000000000000001: ORA-06502: PL/SQL: numeric or value error: character to number conversion error

11.4.2.3 January 6, 2011

  1. Validate that SYSAUX is not specified as TABLESPACE for TRCANLZR during installation.
  2. CREATE script verifies that TABLESPACE to be used by this tool has at least 100 free megabytes.
  3. Wait events from V$EVENT_NAME are now updated as of 11.2.0.2

11.4.2.1 October 24, 2010

  1. Fix "ORA-01426: numeric overflow" when analyzing a trace generated on 11.2.0.2 and cursor number is very large (after fix for 7309111 is applied).
  2. Relevant executions for Top SQL include now up to 5 FETCH calls: First, Second, Third, Last and the one with largest Elapsed Time. This functionality allows to measure time to return first set of rows.

11.4.1.6 August 20, 2010

  1. Relevant executions are now included for Top SQL in terms of ET and CPU, and not only in terms of response time.
  2. Workaround bugs 9299013 and 9559544 producing
    ORA-12801: error signaled in parallel query server P000
    ORA-00600: internal error code, arguments: [15714], [], [], [], [], [], [], [], [], [], [], []
    ORA-06512: at "SQLTXPLAIN.TRCA$T", line 459
  3. Update taconfig.sql with new parameters.

11.4.1.5 August 4, 2010

  1. Installation asks now for "Connect Identifier". This parameter is useful when access to database server is restricted.
  2. Improved performance of API trca$t.refresh_trca$_dict_from_this. This API is executed as the last step of the installation and whenever the dictionary repository within TRCA needs to be refreshed.
  3. New parameter "capture_extents" to control if extents must be captured using parallel execution, serial execution, or no capture at all. Extents are captured during dictionary repository refresh within TRCA.
  4. New parameter "refresh_dict_repository" to control if dictionary repository within TRCA is refreshed or not.
  5. On PX plans, cost and cardinality should not be aggregated from all plans for given SQL.
  6. For PX traces, in addition to an aggregate row source plan, TRCA now displays one per session.
  7. Individual SQL section includes now the "First Call" column with timestamp where that SQL was first seen in trace.

11.4.1.4 July 12, 2010

  1. Default for maximum trace file size that TRCA would analyze is now 999999999 bytes (less than 1GB) as per tool parameter trace_file_max_size_bytes. Prior default was 9999999999 bytes (about 9.31GB). Traces greater than 999999999 bytes are then analyzed up to first 999999999 bytes.
  2. New parameter "copy_file_max_size_bytes" to control size of 10053 and 10046 split files. Default value is 99999999 bytes (less than 100M).

11.4.1.2 June 2, 2010

  1. Instructions and changes log are now html documents.

11.4.1.1 June 1, 2010

  1. TRCA directories can now be specified during installation.
  2. New API for sqltrcanlzr.sql.

11.4.1.0 May 25, 2010

  1. Change background color in titles from f0f0d0 to cccc99.
  2. Actual Number of Rows in Explain Plan is scaled down only when Actual Rows = Rows Processed.
  3. Include note number in reports.
  4. Improve performance and size of main HTML report by using one javascript function for +/- instead of several.
  5. Adapt TRCA so it can be included into SQLT.

11.3.1.0 April 11, 2010

  1. Script trca/install/tautltest.sql no longer tests BDUMP nor TRCA$INPUT.
  2. Input files are searched now on TRCA$INPUT and BDUMP. The former can point to UDIMP (default) or any other designated directory.
  3. TRCA$OUTPUT is no longer used as a staging directory to place generated files (HTML, TEXT, LOG). Now files are created as CLOBs then copied into local SQL*Plus directory.

11.3.0.5 February 17, 2010

  1. Extracts table and index names from row source plan operation even on partitioned objects.