Hidden Automatic Diagnostic Repository (ADRCI) commands
I like unknow stuff so here is latest addition.. As you know ADR tool can be invoked using adrci command: -sh-3.2$ adrci ADRCI: Release 11.1.0.6.0 – Beta on Fri Mar 13 12:06:38 2009 Copyright (c) 1982, 2007, Oracle. All rights reserved. ADR base = “/oracle/admin” and with help command with can get available options: adrci> … Read more
Oracle event SQL_TRACE in 11g
This time I will focus only on one event sql_trace or 10046 . Oracle 11g greatly extended options for this event.I will start with SQL_ID option. Now I can set this event to trace only specific sql_id or few of them: Syntax is : alter session/system set events ‘sql_trace [sql:<sql_id>|<sql_id>] … rest of event specification … Read more
Oracle Diagnostic Events Part 4
This is my 4th post on Oracle events.. Oracle really extended event syntax .In this post I will focus only on Trace event..Even I am getting lost in all combinations.One day I will sort it in nice format but for now I am just dumping knowledge.Also I will use spefic troubleshooting case and used them … Read more
Oracle Diagnostic Events Part 3
This is the 3th blog about Oracle events.. So many things to cover.. Let me start with this giant command: SQL> alter session set events ’10046 trace name context level 12, type decr, lifetime 1, after 5 times’; Session altered. Many combinations in one command.. All these commands are self explanatory ( tried them anyway … Read more
Oracle diagnostic events Part 2
This is my second post on Oracle events only but with more details.Every Oracle release has new stuff so I decided best way would be to dig version 11g… So here is what I got : Let’s start with event syntax what is most important part of all: <event_spec> ::= ‘<event_id> [<event_scope>] [<event_filter_list>] … Read more
