Skip to Content
avatar image
Former Member

What's wrong with the input value for the Alter session in ST04?

Hello Team,

Could you pls have a look and give some recommendation?

2.jpg (246.2 kB)
1.jpg (139.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Mar 01, 2013 at 04:07 AM

    Hi Cai,

    the reason:

    ORA-02248, 00000, "invalid option for ALTER SESSION"

    the command is sent to db as:

    ALTER SESSION SET "EVENTS" = "10046 TRACE NAME CONTEXT FOREVER,LEVEL 4"

    You can change the session parameter from db level:

    SQL> alter session set events '10046 trace name context forever, level 4';

    Regards,
    Shahab

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 01, 2013 at 07:34 AM

    Place text for events in single quotes:

    '10046 TRACE NAME CONTEXT FOREVER,LEVEL 4'

    Regards,

    Roman

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 01, 2013 at 10:41 AM

    Hello

    From the screenshot you are entering EVENTS but it should be EVENT and also I believe it should be ALTER SYSTEM and NOT alter session.

    Never tried setting event from SAP.

    Cheers

    RB

    Add comment
    10|10000 characters needed characters exceeded