Categories
Latest Articles
About OracleRecipes.com
This little web sites provides a couple of Oracle recipes which hopefully help to get a solution to a real problem as quickly and easily as possible.
Latest Oracle recipes on OracleRecipes.com
Establish Connection without tnsnames
Connecting to a database is usually an easy thing to do but when you don't know much about the system, don't have the right to modify tnsnames, it can be a bit annoying from time to time. A quick recipe to show you how to connect without using a tnsnames file.
Statistical Data about Database Events, Waits and more using ASH
Get information about waits and other events of your database by using ASH (Active Session History)
Better Performance by having less Data Type Conversions
Got a number and want to put it in a string - Oracle has to do a conversion. Not a big deal but there's a small and easy to remember detail which leads to slightly faster code. Look at this article to see how the performance can improve by avoiding unnecessary data type conversions.
Monitor Code Changes
Ever wanted to know who creates or modifies an object in your database? Want to see what views, tables or packages your co-workers create? This trigger does the trick!
Deterministic Functions to improve Performance
When you look for a discrete value in a value you can easily add an index to speed up your query, but what if you're looking for something more complex which you have to calculate using a function? Make sure it's deterministic and you'll be able to improve your query in no time!
Finding locked database object
Often when you've got a lock in your system, you'd quickly like to know the object causing the problem. Here's a simple query which does just that.
Display Oracle Session ID (SID)
When you work with views like v$session you'll often want to know the current session ID. Here's how you can get it.
Find Blocking Sessions
Blocking Sessions can cause a lot of problems in Oracle. Tracking these sessions is important because as the name says, they are blocking which means that the blocked session won't be able to finish unless the blocking session has done its work.
Access data from previous record
How to mix values from the current rows with values from previous or preceding rows.
Get Columns from Ref Cursor
You've got some dynamic application where you want to access some meta data from a ref cursor? Two examples are right here!
Contact
Got any questions? A good idea for a new Oracle recipe? Drop us a message and we'll try to get a hold on you as soon as possible.