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
Get a list of all available Tables in your Oracle database
Having a list of tables in a database can help you to get a picture of what's there. Here's how you can do that.
What Oracle Functions are there
Ever wondered what Oracle function you can use? There's a data dictionary telling you about every available function including some additional information.
Monitor Database errors
Want to make sure no one creates code errors in a database? Check this article for an easy monitoring solution.
Prohibit Excel from connecting to your database
You want to make sure no one connects to your production database using Excel, Sqlplus or another tool?
Determine Database Uptime
Want to let management know how well your database is running?
Find unnecessary indexes
You'll definitely have to use indexes if you want your database to perform but having too many indexes isn't good either. Save some storage and make your database faster by removing unnecessary indexes.
Save storage and improve Performance by compressing your indexes
Oracle allows you to compress indexes for a rather long time, but a lot of DBAs still don't know about that feature yet and they probably should.
Using DBMS_PROFILER to find bottleneck in a procedure
Finding a performance issue can be a tricky thing but if you know the tools available at Oracle, you'll sometimes even enjoy it. This article shows you how you can analyze a PL/SQL procedure or function.
Using Flashback to recover lost data
You sure have a backup when running an Oracle database but sometimes it takes a while to restore a single table or even a single row. Oracle comes with a handy feature called "Flashback" which allows you to run a query on a table state from the past.
Monitor long running Oracle operations
You're probably trying to avoid that but sometimes when you have to run a long running operation like a full table scan on a table with millions of rows, you'll want to know how long you have to wait until that operation finished. Check this article for more information.
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.