My Oracle Support Banner

11g show parameter event or v$parameter value shows full event setting, but 10g shows only first 512 characters partial settings (Doc ID 1482835.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.

***Checked for relevance on 01-Mar-2017***

Symptoms

 SQL> show parameter event

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
event                                string      10027 trace name context forev
                                                er, level 1, 10028 trace name
                                                context forever, level 1, 1014
                                                2 trace name context forever,
                                                level 1, 10183 trace name cont
                                                ext forever, level 1, 10191 tr
                                                ace name context forever, leve
                                                l 1, 10411 trace name context
                                                forever, level 1, 10629 trace
                                                name context forever, level 32
                                                , 10753 trace name context for
                                                ever, level 2, 14532 trace nam
                                                e context forever, level 1, 38
                                                068 trace name context forever
                                                , level 100, 38085 trace name
                                                context forever, level 1, 3808
                                                7 trace name context forever,
                                                le 

or below query also shows only 512 characters

SQL> select NAME,VALUE from V$parameter where NAME='event';

 

Changes

 In 11g shows full and in 10g shows only first 512 characters

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.