Oracle-How to check if max_string_size is standard or extended

Question

I am new on Oracle and maybe my question is an easiest one however I could not find my answer. I want to check max_string_size. Is there any useful system query ? Kind regards, Thank you.

Answer 1

You could try to use:

show parameter max_string_size

The value could be STANDARD or EXTENDED. You could find some useful information here.

Answer 2

If you need to find the results via a query you could use....

SELECT name, value
  FROM v$parameter
 WHERE name = 'max_string_size'