Hello Oracle Security interested folks,
Firstly thanks to Oracle for referencing my Oracle Wallet article on www.oracle.com as well as the interesting comments from our readers. This blog has become quite popular so thank you for your support.
I have some excellent news as my company has been selected as a Channel Partner for Sentrigo covering the [...]
April 25, 2010 (Back to the Previous Post in the Series) (Forward to the Next Post in the Series) Previous articles in this series showed a number of interesting troubleshooting techniques that take advantage of the Wireshark packet capture utility. A recent OTN thread made me wonder if there isn’t a lot more than Wireshark offers, [...]
To investigate a query performance issues on one of our RAC database with two instances, I have initiated the 'oradebug dump errorstack 3' command for the session which was running the query. However, after few minutes I had canceled the operation as it was taking a long time and surprisingly, I found that the session is waiting for 'KJC: Wait for msg sends to complete' event. Although the event
It is Saturday (ok, you probably knew that) so I'll do something non-Oracle. Did you know - carrots aren't really supposed to be orange? They should be purple. And they are if you grow a few generations of the Orange ones (they revert back to their natural state).
So, much like the yellow, easy to peel bananas we enjoy - Orange carrots are a product of "us".
Now I’ve got 11g up and running, I’ve finally had the chance to mess about with some of the new features. Anyone who has done any amount of work with Oracle triggers will be familiar with the dreaded ORA-04091 mutating table error. You’ll be relieved to hear that I’ve managed to resist the temptation to [...]
Rollback segments (aka "Undo segments") were introduced in V6. They provide two key implementations :
a. The ability to rollback a transaction -- whether intentionally or to handle transaction / session / process / instance / server failure
b. Multi Version Read Consistency
In 9i, Oracle introduced Automatic Undo Management whereby the database instance itself adds and drops undo segments and retains undo information for a duration ("UNDO_RETENTION") specified by the DBA.
While going through a bug list on metalink I have come across of a ML note: "SELECT FOR UPDATE OF" Hangs in 126.96.36.199 [ID 1081727.1] and thought to blog about it which could be useful for the people who are on 11g or planning to go to 11g. Below is the extract from the note:
Applies to: Version: 188.8.131.52 - Release: 11.2 applies to any platform.
Symptoms "SELECT FOR UPDATE OF" Hangs in 184.108.40.206