Grid DBA

The Oracle Database has some useful debugging and diagnostics features. One such utility called the Automatic Diagnostics Repository Command Interpreter or ADRCI, enables database and system administrators to view and analyze information including trace and log files. In addition to the usual ADR commands, you can also issue DML-like statements. These statements are limited to the diagnostics information found in the ADR. Let's take a look at how to use ADRCI to issue DML. Please note: DML statement issued via ADRCI don't require a termination character such as the semicolon. Also, the statements have to be on a single line. The following DML commands are defined in ADRCI version 12.1.0.2.0 SELECT UPDATE* DELETE* INSERT* UPDATE* QUERY* To get a list of the commands, use the help  keyword in ADRCI. You may notice that only the SELECT statement is shown by default. To see the list of additional commands, type help extended . Note: Commands proceeded by a...

ASM trace files begin with the "+" prefix.  On Unix/Linux I normally view database trace files using the more/less or vi/vim/view commands.  These commands and their variants however accept the "+" command as an option. Run 'man' on any of the commands to see what the "+" option does. Trying to use either of these commands may leave you a bit bewildered at first. [grid@oelgrid01 trace]$ more +ASM1_ora_15496.trc usage: more [-dflpcsu] [+linenum | +/pattern] name1 name2 ...   [grid@oelgrid01 trace]$ less +ASM1_ora_15496.trc   Missing filename ("less --help" for help) You have several other options to viewing these trace files.  Of course, you could do a tail/head against the file e.g  tail -50 +ASM_filename.trc .  But if the file was pretty big you would probably want to traverse back and forth.  For a small tracefile whose standard output fits on the screen you could just issue either of the following commands: cat +ASM_filename.trc c...