Oracle database AWR report is an important tool for DBA to analyze database performance!
Recently encountered a problem and reported an error:
ERROR:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 919
ORA-06512: at line 1
So, how to solve this problem?
Solution:
update WRH$_SQLTEXT set sql_text = SUBSTR(sql_text, 1, 1000);
commit;
After execution, re execute sqlplus/as SYSDBA @/ RDMBS/admin/awrrpt. SQL script successfully generates AWR report!
This sharing is over~
Read More:
- Oracle11g Startup Database Error: ORA-27154: post/wait create failed
- Oracle-OrcleInstanctClient Install ODBC Error: Oracle ODBC Driver with same name already exists
- Zabbix import MySQL database error ERROR 1046 (3D000) at line 1: No database selected
- Kettle stores data report ora-00600 to Oracle: internal error parameters [KQD object $], [u], [0], [107], [CS], []
- [Solved] Running in 64 bit mode with the 32 bit Oracle client installed
- Oracle creates a job and executes the stored procedure with parameters regularly
- How to release Oracle PLSQL data lock table
- [Mybatis] How to Solve the problem of Oracle query processing more than 1000 in conditions
- The attributes of Oracle batch modification sequence (such as cache)_size, increment_(by et al.)
- [How to Fix] Database can’t open file (errno:24)
- scm_prepare_database.sh CDH initial data script execute error
- [Solved] Daily further: database error: unknown column ‘model’ in ‘field list‘
- [Solved] Connections could not be acquired from the underlying database
- [Solved] Error 1044: Access denied for user ‘syz-remote‘@‘%‘ to database ‘webapp‘
- IDEA Database Tool connects to SQL Server 2008 Error [How to Solve]
- [Solved] C# connecting to MySQL database reports an error
- [Solved] Red hat 7.9 install DM8 of Damon database and starting graphical error with xmanager enterprise 5
- C# System.Data.SQLite.SQLiteException:“SQL logic error or missing database no such table: XX”
- mysql workbench Error Code: 1046. No database selected Select the default DB to be used by doubl
- [Solved] MybatisPlus Error: Error querying database. Cause: java.lang.IndexOutOfBoundsException