Document Type | Troubleshooting
Category | Administration
Applicable Product Version | 6FS06
Error Codes | 15115, 20010
Document Number | TADTS027
Issue
This phenomenon occurs as TBR-20010: Error -15115 in processing during statistics collection of a specific table.
Below is an excerpt from the sys.log.
SQL> exec DBMS_STATS.GATHER_TABLE_STATS(OwnName=>'OWNER',TabName=>'TABLE_NAME',ESTIMATE_PERCENT=>10,Method_Opt=>'FOR ALL COLUMNS SIZE 255',No_Invalidate=>FALSE,degree=>4); TBR-20010: Error -15115 in processing 'OWNER'.'TABLE_NAME' .. TBR-15163: Unhandled exception at SYS.DBMS_STATS, line 127. TBR-15163: Unhandled exception at SYS.DBMS_STATS, line 4146. TBR-15163: Unhandled exception at SYS.DBMS_STATS, line 4199. TBR-15163: Unhandled exception at line 1.
Cause
During column statistics collection, there is a query inside Build_histogram that retrieves column information.
The issue occurred because this query sometimes retrieves information exceeding the PSM varchar max size of 32,767 characters.
Solutions
1. Apply the patch. (Patch applied: FS06_315747a)
- FS06_315747a patch details: When retrieving column information, it is adjusted to retrieve only up to 32,767 characters.
Caution
Apply the patch through technical support provided by Tmax Tibero.
2. Set a temporary workaround to resolve the error.
- Temporary workaround: Check max(length(column_name)) and if the length of the column value exceeds 32,767 characters, modify the value.