The init.ora parameter max_sql_string_size can have two
values, extended and legacy, and the max_sql_string_size is
used to control the maximum size for long datatypes such as
varchar2, RAW and nvarchar2 data types.
You
must use the scope option to re-set max_sql_string_size:
SQL> alter system
set max_sql_string_size='EXTENDED';
alter system set
max_sql_string_size='EXTENDED' * ERROR at line 1:
ORA-02097: parameter cannot be modified because specified
value is invalid
ORA-02096: specified initialization
parameter is not modifiable with this option
SQL>
alter system set max_sql_string_size='EXTENDED'
scope=spfile;
System altered.
Setting the max_sql_string_size=extended is
required to use the new 12c features where the maximum size
of varchar2 data types has been increased to 32 k.
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
