Database 
Using the Oracle CEIL function to round to nearest five thousandth
The Oracle CEIL function can be used to round to the nearest five thousandth. Learn how to do this in this tip from SQL expert Karen Morton.
JAVA$POLICY$ Past Exploitation Check
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 [...]
Network Monitoring Experimentations 4
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, [...]
KJC: Wait for msg sends to complete
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
Did you know...
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".
Oracle User Group in Thailand
The Oracle User Group in Thailand was founded in 2010.
Compound Triggers – Managing the Mutant Menace
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 [...]
AutoTune Undo
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.
SELECT FOR UPDATE OF" Hangs in 11.2.0.1
While going through a bug list on metalink I have come across of a ML note: "SELECT FOR UPDATE OF" Hangs in 11.2.0.1 [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: 11.2.0.1 - Release: 11.2 applies to any platform.
Symptoms "SELECT FOR UPDATE OF" Hangs in 11.2.0.1
Latest whitepapersWhitepaper RSS
-
Learn how to upgrade to OEM 12c Release 2
-
Tips and Tricks to plan your EBS 11i to R12 upgrade
-
Tips and Tricks to for smarter monitoring with OEM 12c
-
Learn how to setup Oracle VM DR with a SAN
Latest PodcastsPopcasts RSS
