-
About
- This is an aggregator for the blogs I follow, not a complete list of all Oracle blogs. For a more complete list of Oracle blogs, go to OraNA.info.
-
Recent Posts
Calendar
Blogroll
- An Expert’s Guide to Oracle Technology
- Best Practices PL/SQL with Steven Feuerstein: Most Recent Content
- Blog in isolation
- Burning Questions - The FeedBurner Weblog
- Cary Millsap
- Christian Bilien’s Oracle performance and tuning blog
- DanNorris.com
- DBAs-R-Us
- Dimitri Gielis Blog (Oracle Application Express - APEX)
- Doug’s Oracle Blog
- Eddie Awad’s Blog
- FeuerThoughts
- Hotsos Happenings
- Inside the Oracle Optimizer - Removing the black magic
- Johns Blog
- Kevin Closson’s Oracle Blog: Platform, Storage & Clustering Topics Related to Oracle Databases
- Laurent Schneider
- lutz hartmann as sysdba
- Mary Ann Davidson Blog
- Niall Litchfield’s blog
- One size doesn’t fit all
- Oracle AppsLab
- Oracle Scratchpad
- OracleBlog
- OraStory
- Pankaj Chandiramani’s Blog
- Pete Scott’s random notes
- Peter K’s Blog
- Radio Free Tooting
- Renaps’ Blog
- Rittman Mead Consulting
- Sergio’s Blog
- So What Co-operative
- Steve Karam :: The Oracle Alchemist
- Tanel Poder’s blog: Core IT for geeks and pros
- The Oracle Sponge
- The ORACLE-BASE Blog
- The Tom Kyte Blog
- Tyler Muth’s Blog
- We Do Not Use Blogs
ORACLE-BASE Blog Aggregator
You are currently viewing the daily archives for Tuesday, May 2008
Daily Archives Tuesday, May 2008
I really need to get a new passport!
I am currently in Paris getting ready to participate in a training course - makes a change to be trained, usually I am the one doing the training.
For me, getting to Paris is simple, I walk to my local station (less than ten minutes), catch a train to London (about 30 minutes) then the short [...]
Mix Updates
Rich, ENTP and I spent last week fixing some issues in Mix that you may have seen. Suggest a session for OpenWorld has driven steady traffic into Mix, and we’re rushing to fix bugs that people have encountered.
Virtually all of the recent fixes have been around suggest a session, which makes sense because that’ where [...]
Learn Oracle: Triggers
LewisC’s An Expert’s Guide To Oracle Technology
Today I will be writing about triggers. One of the questions I get fairly often is “what is the difference between a function, a procedure and a trigger?” I already wrote about functions and procedures in <a href=”http://blogs.ittoolbox.com/oracle/guide/archives/learn-plsql-procedures-and-functions-13
Something to be aware of (10.2.0.4)
My standard install of 10.2.0.3 included 23 patches at last count. When the 10.2.0.4 patchset came out a few weeks ago I checked it and decided that since my 23 patches were included in 10.2.0.4, it would be a good idea to upgrade to that version.I fir…
Just Add Enterprise
If you read here, you’ll know I’m not a fan of the term Enterprise 2.0, at least not when it’s used to refer to Web 2.0 practiced behind the firewall.
I know why people feel the need to differentiate Web 2.0 and Enterprise 2.0; Web 2.0 suffers from an image problem, i.e. it’s associated with sites [...]
Indexing Collections (Q&A)
I want to use associative arrays to quickly look up an office product name for a given product number and a product number for a given product name. Product names are unique, and product numbers are integers. I see how I can use the product number as the index value in my collection of names, but I also need to reverse the process and find a product number for a given product name. Can I create another index on a collection’s contents?
Knowing your PGA impact (Q&A)
My DBA wants me to reduce the amount of PGA (program global area) memory I use in my
collection-based programs. Isn’t it the DBA’s job to manage memory, and if it isn’t, how am I supposed to know how much PGA memory I am using?
Kicking the %NOTFOUND Habit (Q&A)
I was very happy to learn that Oracle Database 10g will automatically optimize my cursor FOR loops to perform at speeds comparable to BULK COLLECT. Unfortunately, my company is still running on Oracle9i Database, so I have started converting my cursor FOR loops to BULK COLLECTs. I have run into a problem: I am using a LIMIT of 100, and my query retrieves a total of 227 rows, but my program processes only 200 of them. [The query is shown in Listing 2.] What am I doing wrong?
Knowing your LIMIT (Q&A)
I have started using BULK COLLECT whenever I need to fetch large volumes of data. This has caused me some trouble with my DBA, however. He is complaining that although my programs might be running much faster, they are also consuming way too much memory. He refuses to approve them for a production rollout. What’s a programmer to do?