Oracle Diagnostic Events in 11g
This was presented at HOTSOS 2011 Oracle 11g has a completely new low-level kernel diagnostics and tracing infrastructure built into it. This presentation will explore new diagnostic events. It covers topics like: how to find Oracle internal documentation about events, sample cases, demos, etc. You can download it from these links: PDF file: Oracle_Diagnostic_Events_in_11g Presentation: … Read more
How to disable flush of ASH data to AWR?
MMON process will periodically flush ASH data into AWR tables. Oracle introduced WF enqueue which is used to serialize the flushing of snapshots. If for any reason ( space issue, bugs, hanging etc..) you need to disable flushing the run time statistics for particular table than following procedure needs to be done. First, locate the … Read more
EVAL – Oracle Golden Gate internal command
I had a chance to take a quick look at Golden Gate executable GGSCI. If you run HELP command you will get a list of all ( or not ) options that you can use: -bash-3.2$ ./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 11.1.1.0.0 Build 078 Linux, x64, 64bit (optimized), Oracle 11 on Jul … Read more
Oracle network encrypted data exposed.
For this exercise I will use Oracle Advanced Security Option ( ASO) with following parameters: SQLNET.ORA file: /* ASO Encryption */ SQLNET.CRYPTO_SEED = “fsdfsdfsdfsdfsdfsdfsdfsdfwrewrwerwerwesdfsdfsdfsd” SQLNET.ENCRYPTION_SERVER = REQUIRED SQLNET.ENCRYPTION_CLIENT = REQUIRED SQLNET.ENCRYPTION_TYPES_SERVER = (RC4_256) SQLNET.ENCRYPTION_TYPES_CLIENT = (RC4_256) /* ASO Checksumm */ SQLNET.CRYPTO_CHECKSUM_SERVER = REQUIRED SQLNET.CRYPTO_CHECKSUM_CLIENT = REQUIRED SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (MD5) SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT = (MD5) * Tracing */ … Read more
Patch utility interface
This is also undocumented feature.As name suggest this utility is used to install patches or to be more precise online patches without shooting down instance ( as you know Oracle now offers online patching ). This patch utility can be invoked by running oradebug command: oradebug patch Here is list of all available options which … Read more
