Результаты поиска по запросу "alter session set events":

  1. Alter session set event tips

    • ALTER SESSION SET EVENTS 'immediate trace name buffers level x'; x is 1-3 for buffer header order or 4-6 for LRU chain order. To correct transportable tablespace export hanging (reported on 8.1.6, 8.1.7 on HPUX, a known bug).

    www.dba-oracle.com

  2. alter session in Oracle | alter session set events

    • alter session set events. This statement sets a diagnostic event. The following snippet dumps an Index Tree.
    • alter session set optimizer_mode. optimizer_goal seems to be an alias for optimizer_mode (??)

    www.adp-gmbh.ch

  3. Oracle TKPROF & SQLTRACE Trace Plustrace | ALTER SESSION Commands

    • ALTER SESSION SET sql_trace = FALSE; Event Tracing Examples. Active Session History.
    • ALTER SESSION SET tracefile_identifier = 'test_plan1'; ALTER SESSION SET EVENTS '10053 trace name context forever, level 1'

    psoug.org

  4. Why doesn’t ALTER SYSTEM SET EVENTS set the events or tracing immediately? | Tanel Poder's Performance & Troubleshooting blog

    • Basically the question was that while ALTER SESSION SET EVENTS ‘10046 … ‘ enabled the SQL Trace for the current session immediately, ALTER SYSTEM on the other hand didn’t seem to do anything at all for other sessions in the instance.

    blog.tanelpoder.com

  5. Events in a session - Oracle Event Codes - ALTER SESSION command

    • SQL> alter session set events '10046 trace name context forever, level 12'; SQL> @check_param Event 10015 set at level 12 Event 10046 set at level 12 PL/SQL procedure successfully completed.

    www.praetoriate.com

  6. oracle - Alter session set current_schema privilege - Stack Overflow

    Note that the ALTER SESSION privilege is required for setting events. Very few database users should require the alter session privilege. SQL> ALTER SESSION SET EVENTS .

    stackoverflow.com

  7. alter session set events | The Anti-Kyte

    • Tag Archives: alter session set events. Tracing for fun and (tk)profit.
    • Which is a pity. Sometimes there is just no substitute for getting into the nitty gritty of exactly what is happening inside a given session.

    mikesmithers.wordpress.com

  8. Oracle-L: Re: ALTER SESSION SET EVENTS '...'

    • a.ru> Subject: ALTER SESSION SET EVENTS '...' Sent by: root_at_fatcity.
    • But I can't found some explanations for ALTER SESSION SET EVENTS '...' in Oracle documentation. Who can me point some explanation to this command in Oracle docs ?

    www.orafaq.com

  9. Трассировка сессии — event 10046 | APPS-ORACLE.RU

    • alter session set sql_trace=true; Список данных событий и для чего они предназначены можно посмотреть здесь EventReference.
    • Включить трассировку в текущей сессии. alter session set events '10046 trace name context forever, level 1'

    apps-oracle.ru

  10. Oracle-L: Re: ALTER SESSION SET EVENTS '...'

    • Unless you already know what the event does, setting it is probably a REALLY bad idea. Of course, what I like to do is create a small throwaway database.
    • where Level is one of 0,1,4,8,12 to trace your session > > > > But I can't found some explanations for ALTER SESSION SET EVENTS > > '...' in...

    www.orafaq.com